--- Comment #6 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: Hoo man <>
Date: Tue, 15 May 2012 17:51:10

SQL (only slightly modified):

    SELECT DISTINCT categorylinks.cl_to as cat FROM (SELECT page.page_id as
img_id FROM page 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 page.page_namespace = '6') as tmp INNER JOIN categorylinks ON tmp.img_id
= categorylinks.cl_from WHERE categorylinks.cl_to NOT LIKE


You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to