Last modified: 2014-01-03 15:58:26 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-120. Summary: Files in "Category:Creator template home categories" without "template:Creator" Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com> Date: Tue, 18 Jan 2011 05:15:42 ------------------------------------------------------------------------------- I would like a list of files on Commons which meet 3 conditions: 1) file belongs to subcategories of [[Commons:Category:Creator template home categories]] 2) transcludes "Template:PD-Layout" (files with PD license) 3) does not transclude [[Commons:template:Creator]] Those files will be likely candidates for adding one of the [[Commons:Category:Creator templates]].
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 21 Jan 2011 13:26:04 ------------------------------------------------------------------------------- SQL: SELECT /* SLOW_OK */ page.page_title as file FROM page INNER JOIN categorylinks ON page.page_id = categorylinks.cl_from INNER JOIN templatelinks ON templatelinks.tl_from = page.page_id LEFT JOIN (SELECT COUNT(*) as bool, tl_from FROM templatelinks WHERE templatelinks.tl_title = 'Creator' GROUP BY tl_from) as tlinks ON tlinks.tl_from = page.page_id WHERE page.page_namespace = 6 AND categorylinks.cl_to IN (SELECT page.page_title FROM page INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id WHERE categorylinks.cl_to = 'Creator_template_home_categories' AND page.page_namespace=14) AND templatelinks.tl_title = 'PD-Layout' AND isnull(tlinks.bool); Result: http://toolserver.org/~hoo/dbq/dbq-120.txt (plain text) http://toolserver.org/~hoo/dbq/dbq-120_wiki.txt (wiki table)
------------------------------------------------------------------------------- From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com> Date: Fri, 21 Jan 2011 19:56:57 ------------------------------------------------------------------------------- Thanks a lot - it is very useful. I just have one more question: Many filenames had foreign characters which did not come out correctly. See for example http://commons.wikimedia.org/wiki/User:Jarekt/c where I pasted links to the last 400 files. Only about 20 are correct. Is there a way to correct that?
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 21 Jan 2011 23:27:56 ------------------------------------------------------------------------------- This is an issue caused by your browser which doesn't recognize the encoding correctly. If you are using Firefox, do the following: Go to View > Character Encodings > then select UTF-8 ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
------------------------------------------------------------------------------- From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com> Date: Sun, 23 Jan 2011 21:14:44 ------------------------------------------------------------------------------- Thanks that worked.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: hoo@online.de CC list: hoo@online.de, jaroslaw.w.tuszynski@leidos.com
