Fichiers DJVU en double fr.ws/Commons (SHA-1)

This query is marked as a draft This query has been published by Guillaume (WMF).

Fichiers DJVU ayant exactement le même contenu sur Wikisource en français et Commons.
https://fr.wikisource.org/wiki/Wikisource:Scriptorium/D%C3%A9cembre_2014#Mod.C3.A8les_.C3.A0_cr.C3.A9er_pour_des_livres_en_fran.C3.A7ais_sur_Commons

SQL

SELECT image.img_name AS fichier
    FROM commonswiki_p.image
    WHERE image.img_sha1 IN (
        SELECT image.img_sha1
            FROM frwikisource_p.image
            WHERE image.img_minor_mime = 'vnd.djvu'
    )
    ORDER BY fichier ASC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...