Commons upload list

SQL

SELECT page_id, page_title, img_timestamp, img_metadata
FROM page
INNER JOIN categorylinks ON page_id = cl_from
INNER JOIN image ON page_title = img_name
WHERE img_metadata != ''
AND img_timestamp BETWEEN '20000101' AND '20091231'
AND cl_to LIKE '%Koserow%'
GROUP BY page_id;



#limit 150;
#SELECT page_title, rev_timestamp, rev_len
#FROM page
#JOIN revision ON page_id = rev_page
#WHERE page_namespace = 6
#AND rev_parent_id = 0
#AND rev_timestamp >= '20000101000000'
#AND rev_timestamp <= '20001231235959'
#AND rev_deleted = 0
#ORDER BY rev_timestamp DESC
#LIMIT 1000;
SQL

Checking query status...
