Commons DjVu in use coming from archive.org

SQL

USE commonswiki_p;
SELECT /*SLOW_OK*/
  CONCAT("[[:File:", REPLACE(img_name, "_", " "), "]]") AS "File",
  el_from,
  img_size,
  REPLACE(img_user_text, "_", " ") AS "Uploader",
  img_timestamp AS "Timestamp",
  el_to,
  (SELECT COUNT(*) FROM globalimagelinks WHERE gil_to=page_title) AS "Usage",
  (SELECT COUNT(*) FROM oldimage WHERE oi_name=page_title) AS "Reuploads",
  SUBSTRING_INDEX(el_to,"/",-1) AS "Archive_Name"
FROM image
JOIN page ON page_namespace=6 AND page_title=CONVERT(img_name USING latin1)
JOIN externallinks ON el_from=page_id
WHERE img_media_type="BITMAP"
AND img_major_mime="image" AND img_minor_mime="vnd.djvu"
AND (el_index LIKE "http://org.archive.%/details/_%"
OR  el_index LIKE "https://org.archive.%/details/_%");
SQL

Checking query status...
