mpopov added a comment. |
In T177354#3676545, @chelsyx wrote:Unfortunately, the mediawiki snapshot doesn't has the image table which describes images and other uploaded files.
Ah, yeah. I missed the reference to image in your query. But looks like we can use img_timestamp, although those queries will take some time.
Also something to note is that img_major_mime shows up as "application" for .ogg files (which are audio files) and .pdf files:
SELECT DISTINCT img_major_mime, img_minor_mime FROM commonswiki.image;
img_major_mime img_minor_mime image gif image jpeg image png image tiff image vnd.djvu image webp image x-xcf image svg+xml application ogg audio midi audio wav audio webm audio x-flac video webm application I recommend adding a CASE that returns "audio" for ogg files and "document" (for example) for PDFs.
TASK DETAIL
EMAIL PREFERENCES
To: chelsyx, mpopov
Cc: Aklapper, mpopov, chelsyx, Abit, SandraF_WMF, Ramsey-WMF, Capt_Swing, debt, E1presidente, Jmmuguerza, GoranSMilovanovic, QZanden, EBjune, Acer, Avner, Gehel, FloNight, Susannaanas, Wikidata-bugs, PKM, Base, matthiasmullie, aude, Ricordisamoa, Fabrice_Florin, Raymond, Mbch331
Cc: Aklapper, mpopov, chelsyx, Abit, SandraF_WMF, Ramsey-WMF, Capt_Swing, debt, E1presidente, Jmmuguerza, GoranSMilovanovic, QZanden, EBjune, Acer, Avner, Gehel, FloNight, Susannaanas, Wikidata-bugs, PKM, Base, matthiasmullie, aude, Ricordisamoa, Fabrice_Florin, Raymond, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs