SQL
AخA
use commonswiki_p;
SELECT CONCAT('# [[:File:', page_title, ']]') as "Pilt", log_timestamp, MID(comment_text,35),12) as "Allikas"
FROM logging
JOIN comment ON log_comment_id=comment_id
JOIN page ON log_page=page_id
WHERE log_type = 'import'
AND log_namespace=6
AND log_timestamp>20181220000000
AND comment_text RLIKE '^Imported with FileImporter'
ORDER BY log_timestamp DESC;
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.