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