[10:52:50] Hi! How can I get a list of pages that use some template, '''including their parameters'''? [10:53:25] templatetiger would do it but it has old data. anything similar or pywikibot? [11:28:24] geraki: I believe AWB has a plugin for that [11:31:03] quick question, is there a simple way to seek current revision of a page in the database? [11:31:11] do I need to go though all revisions? [11:31:26] ie the text table? [11:32:27] ToAruShiroiNeko: page.page_latest [11:32:49] ah so I dont even need text, neat [11:37:27] Reedy hmm [11:37:27] https://quarry.wmflabs.org/query/13988 [11:37:49] ToAruShiroiNeko: No, it's the revision number [11:37:55] Do you have the time to glance at this? Is there somehting obvious I am doing wrong? [11:37:58] OH [11:38:07] okay inner join then [11:38:09] makes sense [11:38:11] yeah on rev_id [11:38:12] what was I thinking [11:38:30] inner join it is [11:39:53] err rather revision [11:42:56] so text doesnt even exists [11:43:02] I am looking at https://www.mediawiki.org/wiki/Manual:Database_layout [11:44:10] Could be in ES [11:44:31] ES/ [11:44:34] ? [11:44:35] External Storage [11:44:42] I mean, for the actual revision text [11:44:55] I dunno if the text table is/is supposed to be shown on labs replicas [11:44:57] Maybe not [11:45:08] not for commons [11:45:41] text is where it would be right? [11:46:45] text.old_text [11:49:38] https://meta.wikimedia.org/wiki/Research:Quarry#Available_tables_and_columns [11:49:40] bleh [11:50:19] The table text containing the actual content of the revisions is missing. [11:50:35] Reedy do you have another way to querry these for me? [11:54:28] I can do it on production, depending on what exactly you're trying to find out [11:56:28] I am tryin to identify files from two sites [11:56:39] change.org and greatagain.gov [11:56:54] possily also ealier sites if we find them like for bush [11:57:08] it seems like these transitional sites have the lifespan of the presidents term [11:58:24] on commons I intend to re-license them so that we can better keep track of such content as they are not in the public domain by default [11:59:30] I intend to plug in the page_title list into the bot to process [12:04:22] greatagain.gov probably has only one file, the one I uploaded [12:04:40] example file for change.org https://commons.wikimedia.org/wiki/File:Official_portrait_of_Barack_Obama.jpg [13:09:49] RoanKattouw: I edited a desription of a file you uploaded https://commons.wikimedia.org/w/index.php?title=File:Notification_panel_with_cross-wiki_notification.png&diff=213079175&oldid=192896233 [13:30:02] Josve05a: why can't you keep a double license? [13:30:30] It's not irrelevant that the uploader waived any own copyright [14:33:39] Reedy is that acceptable?