[00:55:32] <JJPMaster>	 A bit of a basic question: how do I know when my daily scheduled task is set to run?
[14:11:29] <wm-bb>	 <djhartman> Anyone wanna help out with a full disk problem ?
[14:11:30] <wm-bb>	 <djhartman> https://phabricator.wikimedia.org/T382138
[14:12:33] <wm-bb>	 <djhartman> I cant see the project owner details, but im guessing they all are mia, and susanna doesnt know how to do this i suspect.
[14:13:17] <wm-bb>	 <lucaswerkmeister> you can see the “members” (admins) and “viewers” (members) at https://openstack-browser.toolforge.org/project/wikidocumentaries
[14:16:08] <RhinosF1>	 TuukaH was active recently
[18:53:59] <Polomo>	 Hi, everyone. Here to ask about SQL queries: so I'm trying to make one for English Wiktionary, to get main-namespace pages that fulfill all of 3 conditions.
[18:53:59] <Polomo>	 1. Is in `Category:Portuguese_non-lemma_forms`
[18:54:00] <Polomo>	 2. Is not in `Category:Portuguese_forms_superseded_in_1945`
[18:54:00] <Polomo>	 3. Does not contain certain text (thinking searching by text is my best option)
[18:54:01] <Polomo>	    - `{{pt-verb form of`, `{{plural of|pt`, `{{adj form of|pt`, `{{feminine singular of|pt`, `{{feminine plural of|pt`, `{{masculine plural of|pt`
[18:54:01] <Polomo>	 Does anyone know what SQL query I could use to achieve this? For reference, below is what I'm trying to use right now, but it's throwing error `Unknown column 'rev_text' in 'where clause'`. I know little to nothing about SQL, really...
[18:54:02] <Polomo>	 ```SELECT DISTINCT page_title
[18:54:02] <Polomo>	 FROM page
[18:54:03] <Polomo>	 JOIN categorylinks ON page_id = cl_from
[18:54:03] <Polomo>	 JOIN revision ON revision.rev_page = page.page_id
[18:54:04] <Polomo>	 WHERE page_namespace = 0
[18:54:04] <Polomo>	 AND cl_to = "Portuguese_non-lemma_forms"
[18:54:05] <Polomo>	 AND page_id NOT IN (
[18:54:05] <Polomo>	     SELECT cl_from
[18:54:06] <Polomo>	     FROM categorylinks
[18:54:06] <Polomo>	     WHERE cl_to = "Portuguese_forms_superseded_in_1945"
[18:54:07] <Polomo>	     )
[18:54:07] <Polomo>	 AND rev_text NOT LIKE '%{{pt-verb form of%'
[18:54:25] <lucaswerkmeister>	 please use a pastebin instead of this many messages
[18:54:26] <lucaswerkmeister>	 e.g. https://paste.toolforge.org/
[18:54:47] <Polomo>	 Right. Good idea.
[18:55:28] <lucaswerkmeister>	 1 and 2 are basically doable similarly to your query (haven’t looked at the exact syntax) but 3 is not possible on quarry
[18:55:34] <lucaswerkmeister>	 the revision contents aren’t available there
[18:55:57] <lucaswerkmeister>	 *looks closer* although, I suppose you could do something pretty similar by checking that certain templatelinks are available
[18:56:05] <lucaswerkmeister>	 if you’re interested in templates and not arbitrary page contents
[18:56:46] <Polomo>	 Yeah, I'm interested in templates, but it's only templates that have a certain parameter. Can I search for parameters, too, like, get the value of `{{{1}}}`` ?
[18:57:06] <lucaswerkmeister>	 ok, I see
[18:57:08] <Polomo>	 Apologies again for the big message, by the way. Slipped my mind. And thanks for the reply.
[18:57:16] <lucaswerkmeister>	 then the answer is probably no again :/
[18:57:20] <lucaswerkmeister>	 the regular search might work better?
[18:57:42] <lucaswerkmeister>	 incategory:"Portuguese non-lemma forms" -incategory:"Portuguese forms superseded in 1945", and then some -insource: keywords
[18:58:07] <lucaswerkmeister>	 though I’m not sure how insource deals with {, I’ve had mixed success with it overall
[18:59:16] <lucaswerkmeister>	 something like this? https://w.wiki/CR3w
[19:04:07] <Polomo>	 Hm, I see, thanks. I could try looking in the regular search, but before that: I had a third idea on how to achieve what I want to do. Queries can get the links included in a page, right?
[19:04:08] <Polomo>	 So I tried querying for pages that do not link to pages inside certain categorieshttps://paste.toolforge.org/view/d5aa3b17 (learned this time). This query also turned up an error; I tried to make it work in various ways, but still couldn't. I wonder if there's something else I could try to fix the error?
[19:05:25] <Polomo>	 omg I messed up the link
[19:05:36] <Polomo>	 https://paste.toolforge.org/view/d5aa3b17
[19:05:42] <lucaswerkmeister>	 I figured it out ^^
[19:05:45] <lucaswerkmeister>	 (the link, that is :P)
[19:05:57] <lucaswerkmeister>	 line 17 looks like it has some extra spaces that would cause that subquery to have 0 results, I assume
[19:06:27] <lucaswerkmeister>	 also I think line 16 is wrong. let me think through that a bit more
[19:06:41] <Polomo>	 Oops, I may have introduced those spaces when pasting to pastebin. Let me check, just in case.
[19:09:17] <Polomo>	 Oh! I think that query actually works flawlessly?
[19:09:47] <Polomo>	 So embarassing when you ask for help, then magically solve your own issue.
[19:10:39] <lucaswerkmeister>	 hm, really? :D
[19:10:45] <lucaswerkmeister>	 I was thinking you would need something like this: https://paste.toolforge.org/view/dbf77505
[19:10:48] <lucaswerkmeister>	 (totally untested btw)
[19:11:08] <Polomo>	 Let me see if that gives different results...
[19:11:09] <lucaswerkmeister>	 but I would’ve thought that’s what the JOIN for “pages that do not link to pages inside certain categories” has to look like
[19:13:13] <Polomo>	 Hmm, the queries do give slightly different results. I'll try to look into that? I think that's all for now, though (heh). Thank you so much for the help!!
[19:13:39] <lucaswerkmeister>	 alright, good luck!
[19:20:41] <Polomo>	 To conclude: I compared the documents both queries yielded. The one I had initially seems to have given the results I wanted, while your tweaked query didn't exclude pages with the unwanted links. Must be due to the "sub-query" returning empty.
[19:21:01] <lucaswerkmeister>	 hm, ok ^^
[19:24:19] <Polomo>	 Thanks again. Cya :)