[08:51:36] Good Evening [08:53:26] Had a question. Currently I'm using a MediaWiki that has a monthly featured article. Annoyingly this is being updated manually. Is there a way where the Wiki can pull an article from the Featured Articles Category and display it each day/month? [16:53:55] hi there everyone [16:54:09] Can someone help me make query to run on Quarry? [16:54:47] or is it hte wrong channel? [16:54:51] *the [16:58:44] guys? [17:00:12] campitor: I can help!. Could you please explain what's your problem? [17:03:49] ASammour: You are awesome. It is a tiny one. I promise. All I am trying to do is to find all the interwiki titles from one wiki to another. Like all the pages that have been translated from en_wiki to ar_wiki, and what is their titles in both langauges [17:03:57] I have already found this: [17:04:21] https://quarry.wmflabs.org/query/263 [17:04:31] but it only does it for med titles [17:04:37] medical related stuff [17:04:52] and it does it for all the languages that are in existence on wikipedia [17:05:13] I only want it for a pair of languages and for all the pages [17:05:22] cl_to = 'WikiProject_Medicine_Translation_Task_Force_articles' [17:05:29] That limits it to a specific category [17:05:36] Yes [17:05:43] I have already figured that part out [17:05:45] Replace it with ll_lang = 'ar' [17:05:45] but [17:05:59] it does it for all the languages [17:06:01] uuuh [17:06:07] Thanks Reedy [17:07:20] Well, actually [17:07:33] Reedy: what? [17:07:33] You don't need half the query anymore [17:07:48] what do you mean? [17:08:07] You don't need to query hte category links anymore [17:08:20] select * from langlinks where ll_from = 'ar'; [17:08:24] That does 99% of the work [17:08:35] You then just need a join on page to turn ll_from from a page id to a title [17:08:50] Now I am totally confused [17:08:59] I have no query language knowledge [17:09:38] select * from langlinks limit inner join page p1 on ll_from = p1.page_id and p1.page_namespace = 0 where ll_lang='ar'; [17:09:48] That will give you them all for the main namespace [17:10:15] select * from langlinks inner join page p1 on ll_from = p1.page_id and p1.page_namespace = 0 where ll_lang = 'ar'; [17:10:20] so all I have to do is to run that single line [17:11:17] select page_title, ll_title from langlinks inner join page p1 on ll_from = p1.page_id and p1.page_namespace = 0 where ll_lang= 'ar' limit 10; [17:11:26] what do you mean btw that it would only do 99% of the job? [17:11:27] That gives you only the two things you care about, both titles [17:11:35] "select * from langlinks where ll_from = 'ar';" [17:11:44] That will give you all the language links to ar on a wiki [17:11:56] It's 99% as it doesn't give you a human readable version of what the english title is [17:12:01] So you need the join, as per the query above [17:16:41] Just a small clarification. This query will take so much time to execute for two reasons. First because it will list redirects also, Second because it has no limit. So The total rows will be like 750k [17:18:20] Redirects don't tend to have language links [17:21:08] ASammour: So you mean running "select page_title, ll_title from langlinks inner join page p1 on ll_from = p1.page_id and p1.page_namespace = 0 where ll_lang= 'fa';" will output only a fraction of all the actual results after it is finished? [17:22:31] campitor: No. It will get all the results. But the execution time will be very long. [17:23:43] btw, how can I stop a running query to save server time? [17:23:43] Reedy: I've made a query about that before. And I found for example in arwiki there are 6k redirects contain inter-wiki links. [17:25:21] I need to stop my queries folks. should I be worried? [17:28:23] gens? [17:31:38] campitor: There is no option to stop query on Quarry. [17:41:43] dam [17:41:46] *damn [17:48:14] Thenk you guys [18:08:55] I have a mediawiki install where text will be entered in unusual scripts, for example Balinese script. many users will not have system fonts that support these scripts so we are using webfonts. this works decently for viewing, but what about editing? [18:09:09] what do I do with the