Pasted from WT:Database reports
On the English Wikipedia, the categories "Images made obsolete by a PNG version" and "Wikipedia images available as SVG" contain files which have been superseded. Many of these images have been replaced in articles with their superseded versions, but there are a lot of articles which still need to be updated to use superseded images. I would like to have a list of files from each category that are still used in main space, preferably sorted by the number of articles the file is used in. I can't seem to find a way to do this with automated tools such as AWB or CatScan, but if there is a way I'd be happy to do it myself if possible. These lists would help me with the running of my bot (DanhashBot). Can anybody write and run database queries for these two lists, or explain how I can use an automated tool to compile such a list myself? Thanks!