Files imported with FileImporter from Viwiki

SQL

SELECT page_title AS File, rev_id AS "Special:Diff/", rev_timestamp AS Timestamp, rev_actor AS "Actor_ID", comment_text AS "Edit summary"
FROM revision
JOIN `comment` ON comment_id = rev_comment_id AND comment_text REGEXP "Imported with FileImporter from https://vi.wikipedia.org/wiki/"
/*JOIN actor ON actor_id = rev_actor AND actor_user IS NULL */
JOIN page ON page_id = rev_page AND (page_namespace = 6) /* File */
LEFT JOIN change_tag ON ct_rev_id = rev_id AND ct_tag_id = 590 /* mw-reverted */
WHERE rev_timestamp >= REPLACE(CURDATE() - INTERVAL 10 DAY, "-", "") AND ct_tag_id IS NULL

SQL

Checking query status...