https://bugzilla.wikimedia.org/show_bug.cgi?id=59255
--- Comment #1 from Bugzilla Bug Importer (valhallasw) <wmf.bugconver...@gmail.com> --- ------------------------------------------------------------------------------- From: Bryan Tong Minh <br...@tools.wikimedia.de> Date: Sun, 28 Oct 2007 11:40:10 ------------------------------------------------------------------------------- That would be something like USE commonswiki_p; SELECT CONCAT('* Image:', page_title) FROM image, page LEFT JOIN templatelinks ON tl_from = page_id WHERE (page_namespace, page_title) = (6, img_name) AND (tl_namespace, tl_title) <> (10, 'Information') AND tl_from IS NULL; It would be much easier if all Commons license tags would embed Category:License_tags aside from the sub cats of License_tags. -- 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