https://bugzilla.wikimedia.org/show_bug.cgi?id=59461
--- Comment #1 from Bugzilla Bug Importer (valhallasw)
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Mon, 09 Apr 2012 20:57:04
-------------------------------------------------------------------------------
Sorry, but I can't help you with either CatScan or AWB, as I'm not firm with
those, so I did it in SQL:
SQL:
SELECT image_pages.page_title AS image FROM categorylinks INNER JOIN page
AS image_pages ON cl_from = image_pages.page_id INNER JOIN imagelinks ON
image_pages.page_title = il_to INNER JOIN page ON il_from = page.page_id WHERE
cl_to = 'Images_made_obsolete_by_a_PNG_version' AND page.page_namespace = 0
GROUP BY cl_from HAVING COUNT(*) > 0;
(Replace Images_made_obsolete_by_a_PNG_version with
Wikipedia_images_available_as_SVG for the SVGs)
Result:
PNG: http://toolserver.org/~hoo/dbq/dbq-182_1.txt
SVG: http://toolserver.org/~hoo/dbq/dbq-182_2.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
