| scfc added a comment. |
The query should be very simple:
MariaDB [enwiki_p]> SELECT enwiki_p.image.img_name, commonswiki_p.image.img_name FROM enwiki_p.image JOIN commonswiki_p.image USING (img_sha1) LIMIT 10; +------------------------------------------------------------------------------------+------------------------------------------------------------------------------------+ | img_name | img_name | +------------------------------------------------------------------------------------+------------------------------------------------------------------------------------+ | | | | Clergymandaugher.jpg | Clergymandaugher.jpg | | STS_Pallada_-_August_2011.jpg | STS_Pallada_-_August_2011.jpg | | New_Kadampa_Tradition.png | New_Kadampa_Tradition.png | | BanburyTramway_estate_shed_2.jpg | BanburyTramway_estate_shed_2.jpg | | Victoria_county_with_mariposa_highlighted.png | Victoria_county_with_mariposa_highlighted.png | | Short_line_coupler_unequal_impedance.svg | Short_line_coupler_unequal_impedance.svg | | OgMandinoInspirationalwriter.jpg | OgMandinoInspirationalwriter.jpg | | Daisybell.jpg | Daisybell.jpg | | Roses_growing_in_front_of_graves,_Menin_Road_South_Military_cemetery_977687052.jpg | Roses_growing_in_front_of_graves,_Menin_Road_South_Military_cemetery_977687052.jpg | +------------------------------------------------------------------------------------+------------------------------------------------------------------------------------+ 10 rows in set (0.31 sec)
MariaDB [enwiki_p]>
In practice, for example on enwiki pages in Category:Wikipedia files on Wikimedia Commons for which a local copy has been requested to be kept need to be excluded.
I would suggest making a database report or its local equivalent out of the finished query; IMHO there is a bigger motivation to fix a list of things that is already on your wiki than to periodically browse some tool's website.
TASK DETAIL
EMAIL PREFERENCES
To: scfc
Cc: scfc, whym, gerritbot, Avicennasis, Aklapper, Steinsplitter, Multichill, Xqt, pywikibot-bugs-list, Magul, Tbscho, MayS, Mdupont, JJMC89, jayvdb, Dalba, Masti, Alchimista, Rxy
Cc: scfc, whym, gerritbot, Avicennasis, Aklapper, Steinsplitter, Multichill, Xqt, pywikibot-bugs-list, Magul, Tbscho, MayS, Mdupont, JJMC89, jayvdb, Dalba, Masti, Alchimista, Rxy
_______________________________________________ pywikibot-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/pywikibot-bugs
