uploaded videos on specific period

Fork of Images in certain category by the date of upload by Tohaomg

This query is marked as a draft This query has been published by Estopedist1.

SQL

FROM commonswiki_p;
SELECT DISTINCT CONCAT ("File:"img_name""), img_timestamp
FROM image
  LEFT JOIN page ON img_name=page_title
#WHERE I.img_timestamp > 20191014000000
WHERE img_timestamp BETWEEN 20191014000000 AND 20191020000000
  AND page_namespace = 6
  AND (page_title LIKE "%.webm" OR #only two video extensions in Commons
       page_title LIKE "%.ogv" OR #only two video extensions in Commons
	   page_title LIKE "%.ogg" OR
       page_title LIKE "%.wav" OR
       page_title LIKE "%.mid" OR
       page_title LIKE "%.oga" OR
       page_title LIKE "%.flac" OR
       page_title LIKE "%.mp3" OR
       page_title LIKE "%.opus" 
      )
ORDER BY page_title DESC
LIMIT 10;

SQL

Checking query status...