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

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Mon, 01 Oct 2012 23:43:26
-------------------------------------------------------------------------------

Please notice, that I changed the two user names Liangent asked about above.
I've assumed all other names to be valid (this is case SENSITIVE).

SQL:

    SELECT DISTINCT img_name FROM image INNER JOIN page ON page_title =
img_name AND page_namespace = 6 INNER JOIN categorylinks ON cl_from = page_id
WHERE img_user_text IN(/* ... */) AND cl_to LIKE
'All_media_needing_categories_as_of_%';

Result:  
http://toolserver.org/~hoo/dbq/dbq-193.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