SQL
AخA
use commonswiki_p;
SELECT CONCAT('# [[:File:', rc_title, ']]') as "Pilt",
DATE_FORMAT(rc_timestamp,'%d.%m.%Y %H:%i') as "Import",
DATE_FORMAT(img_timestamp,'%d.%m.%Y %H:%i') as "Üles"
FROM recentchanges
JOIN comment ON rc_comment_id=comment_id
JOIN page ON rc_cur_id=page_id
JOIN image ON page_title=img_name
WHERE rc_namespace=6
AND rc_type=0
AND rc_timestamp>20180625000000
AND rc_minor=1
AND comment_text RLIKE '^Imported with FileImporter'
ORDER BY img_timestamp;
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.