SQL
AخA
use commonswiki_p;
SELECT CONCAT('# [[:File:', page_title, ']]') as "Pilt", log_timestamp, SUBSTRING_INDEX(MID(comment_text,35,20),'.',2) 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>20181101000000
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.