Fork of
Top 10 largest uploads in the last day
by Fæ
This query is marked as a draft
This query has been published
by Fæ.
SQL
AخA
USE commonswiki_p;
SELECT CONCAT("[[:File:", img_name, "]]") AS File, img_user_text AS Uploader, LEFT(img_timestamp,8) AS Date
FROM categorylinks
JOIN page on cl_to = "PD_Old_(assumed)" AND page_id = cl_from
JOIN image ON img_name = page_title
WHERE img_timestamp < 20181124235959 AND img_timestamp > 20181017000000
LIMIT 60;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.