Page MenuHomePhabricator

DBQ-120 Files in "Category:Creator template home categories" without "template:Creator"
Closed, ResolvedPublic

Description

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]].


Version: unspecified
Severity: minor

Details

Reference
bz59373

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:26 AM
bzimport set Reference to bz59373.

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