[04:49:35] You could probably do a UNION or something. [04:49:58] Or I guess a straight JOIN would work. [04:58:36] Josve05a: select page_title from page join templatelinks on tl_from = page_id join externallinks on el_from = page_id where tl_title = 'Cite_web' and tl_namespace = 10 and page_namespace = 0 and el_index like 'http://com.google.books%' limit 10; [04:58:43] Seems to work okay. [04:59:26] Oh :D [04:59:28] There's also https://books.google.com [04:59:35] So you may need to do a separate query for that. [04:59:59] insource:{{cite web|url= assumes that the url parameter will be first. [05:00:08] Yeah... And .co.uk, .se, etc. But I only really need this [05:00:27] This query is just finding pages that use {{cite web}} and link to books.google.com. [05:00:38] Which may or may not be in the url parameter. [05:00:39] Yeah. Thanks! I suck at queries. I just copy others [05:00:55] Hmm... [05:01:11] Any way to only get links which are in that template? [05:03:29] Why? [05:03:33] What are you trying to do? [05:04:44] Josve05a: ^ [05:06:03] Debra: I'm going to (1) run AWB on them and turn them to Cite books, then run [[en:User:Citation bot]] to clean the urland add isbn etc. [05:06:17] Url and* [05:06:47] Sounds tedious. [05:07:05] so, I want a list of articles which has links to Google Books in a cite web template [05:07:06] :p [05:07:14] I am a real wiki gnome [05:30:21] !urgent [05:30:42] https://el.wikipedia.org/wiki/%CE%95%CE%B9%CE%B4%CE%B9%CE%BA%CF%8C:%CE%A0%CF%81%CF%8C%CF%83%CF%86%CE%B1%CF%84%CE%B5%CF%82%CE%91%CE%BB%CE%BB%CE%B1%CE%B3%CE%AD%CF%82 [05:30:51] Recent changes in elwiki [05:51:58] https://phabricator.wikimedia.org/T137083 [06:47:29] problem fixed, thanks [08:48:35] !ping [12:00:12] Could an admin at Commons Beta Cluster delete http://commons.wikimedia.beta.wmflabs.org/wiki/Category:BulbaBot_test1 , http://commons.wikimedia.beta.wmflabs.org/wiki/Category:BulbaBot_test2 , http://commons.wikimedia.beta.wmflabs.org/wiki/Category:BulbaBot_test3 , http://commons.wikimedia.beta.wmflabs.org/wiki/Category:BulbaBot_test4 , [12:00:20] and http://commons.wikimedia.beta.wmflabs.org/wiki/Category:BulbaBot_test5 [12:00:32] As author's request? Thanks [12:03:17] Poke95: It doesn't really mattter even if test pages are not deleted on beta [12:03:39] Well, they are unlikely to be used though [12:04:00] I can't get my BulbaBot to use pywikibot on Commons Beta [12:04:05] I imagine that there are many pages like that on beta [12:07:38] "Nothing you make on the *.beta.wmflabs.org sites should be considered permanent and it may be removed at any time." (according to https://deployment.wikimedia.beta.wmflabs.org/wiki/Main_Page ) [12:09:45] Poke95: I meant that it doesn't really matter even if pages are deleted or not but if you really want it to be deleted then I guess I can. [12:09:59] I think that disclaimer is about technical stuff. [12:10:09] Ah [12:10:22] Well I am ok if the pages are not deleted then [12:10:52] Someone deleted them already. :) [12:11:06] Oh, then thanks to them :) [15:43:28] o/ Krinkle [15:43:52] Do you think you could take a look at https://gerrit.wikimedia.org/r/#/c/278841/ ? [15:46:10] * Krinkle is looking, halfak [15:46:25] Thanks! [15:46:55] We are really close to being able to deploy the ORES extension as a Beta feature on a couple of wikis :) [15:47:10] fawiki & wikidatawiki are first [15:47:23] Once we deal with the first bug-wave, we'll target a bigger deployment. [15:54:10] I'm getting an email once per day "Alert: puppet failed on wigi.wikidumpparse.eqiad.wmflabs" . I restarted puppet and puppet-run, but to no avail. I don't know how to start troubleshooting this. Any thoughts? [15:54:43] The error message contains no information just. Puppet is failing to run on the "wigi" instance in the Wikimedia Labs [15:54:44] project "wikidumpparse" [16:09:13] Anyone here good with templates? [16:10:22] How can I make that the "Bullet-separator" on https://sv.wikipedia.org/w/index.php?title=Mall:Taxonbar/Link&action=edit onlyappears in between "links" and not after each one (right now it will apear after eech one, including after the last link as well) [16:10:39] see https://usercontent.irccloud-cdn.com/file/Kob2tHvy/Screenshot%202016-06-06%20at%2018.10.18.png [16:15:11] halfak: Can you rebase it so I can test it in vagrant? [16:15:15] It seems to be in conflict [16:48:15] Anyone here who can help me publish translations made on meta? Else, suggest me proper channel. [16:48:37] tuxnani: link? [16:49:12] Glaisher: https://meta.wikimedia.org/w/index.php?title=Special:Translate&group=Centralnotice-tgroup-inspire_har&filter=translated|!reviewer%3A665408|!last-translator%3A665408&language=kn&action=proofread [16:49:24] language is Kannada [16:49:28] kn [16:49:54] https://meta.wikimedia.org/w/index.php?title=Special:Translate&group=Centralnotice-tgroup-inspire_har&filter=&language=kn&action=proofread [16:52:37] tuxnani: published [16:52:46] Glaisher: thank you! [16:53:55] tuxnani: https://meta.wikimedia.org/w/index.php?title=Image_filter_referendum/Email/hr&banner=inspire_har&uselang=kn&force=1 looks good, thanks! [16:58:24] wut, what are people linking that stuff for? [16:58:40] (was that just a random page?) [17:00:08] That was through Special:Random (the preview link on the CN interface) [17:02:20] https://meta.wikimedia.org/w/index.php?title=Special:Translate&group=Centralnotice-tgroup-inspire_har&filter=&language=te&action=translate this too for Telugu (te) [17:02:46] So much garbage we have on Meta thanks to Jimbo & friends [17:03:36] tuxnani: also done [17:03:45] Thank you again! [17:04:05] np [18:04:32] HI all! I just need a quick thing, which should be easy if you know how...can someone help make a list of all articles which trancludes {{Taxobox}} on sv.wp... [18:04:40] AWB can only make up to 10 000 article-lists [18:20:44] is there a way to put a relative path into an extension.json, and have MediaWiki resolve it to an absolute path when the extension is loaded? [18:22:25] DanielK_WMDE: not yet, https://phabricator.wikimedia.org/T100956 [18:28:33] legoktm: thanks [18:30:20] DanielK_WMDE: $wgExtensionWiringFiles is from core right? then it's not a configuration setting (for sysadmins), it's a registration thing that can have the path prefixed in ExtensionProcessor [18:55:31] Hello. It appears that e-mails are not delivered to OTRS since some hours. Does anybody have information on that, or is anybody present who could look around? [19:01:39] nothing obviously wrong with the mail server graphs [19:02:49] I'd guess there are no new emails in OTRS for around 10 hours. [19:03:03] At least something must be broken. [19:03:37] https://ganglia.wikimedia.org/latest/graph.php?r=day&z=xlarge&c=Miscellaneous+eqiad&h=mendelevium.eqiad.wmnet&jr=&js=&v=0&m=exim+messages+in&vl=messages does look like a bit of a drop but it's not completely ridiculous-looking [19:04:09] akosiaris, ^ [19:05:35] krd, sorry I can't looking into this further - no access + no time [19:06:05] Ok, thank you. [19:06:42] If anybody else could look info that, I can provide more details. [21:28:31] If a bug gets fixed (in my case: printing formulas didn't work, T136709), but, from a user perspective, the correct behavior can only be seen after purging the page, how long does it usually take until that's no longer necessary? I mean, I suppose the server cache gets cleared from time to time? [21:28:31] T136709: Make math using MathML / SVG / PNG mode print properly - https://phabricator.wikimedia.org/T136709 [21:30:37] pajz: usually about 30 days [21:32:38] Thanks!