Commons upload list

SQL

USE commonswiki_p;
select distinct concat("File:", page_title) as Dateiname, img_timestamp, SUBSTR(REGEXP_SUBSTR(img_metadata,'(s:8:"DateTime";s:19:"(.*?[^[\\\\])")'), 21, 19), img_metadata
from page
left join categorylinks
on page_id = cl_from
left join image
on page_title = img_name
where img_timestamp between "20060101" and "20091231"
and cl_to like "%Heringsdorf%"

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...
