https://bugzilla.wikimedia.org/show_bug.cgi?id=59381

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Sun, 13 Feb 2011 16:13:08
-------------------------------------------------------------------------------

SQL:

    SELECT DISTINCT categorylinks.cl_to as cat FROM (SELECT page.page_id as
img_id FROM image INNER JOIN page ON image.img_name = page.page_title INNER
JOIN categorylinks ON categorylinks.cl_from = page.page_id INNER JOIN (SELECT
page.page_title as cats FROM categorylinks INNER JOIN page ON
categorylinks.cl_from = page.page_id WHERE categorylinks.cl_to =
'Popular_Science_Monthly_illustrations' AND page.page_namespace = 14) as
subcats ON categorylinks.cl_to = subcats.cats WHERE image.img_user_text =
'Ineuw' AND page.page_namespace = '6') as tmp INNER JOIN categorylinks ON
tmp.img_id = categorylinks.cl_from WHERE categorylinks.cl_to NOT LIKE
'Popular_Science_Monthly_illustrations/Volume_%';

Result:  
http://toolserver.org/~hoo/dbq/dbq-127.txt

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to