Untitled query #87719

SQL

SELECT page_title AS File, rev_id AS "Special:Diff/", rev_timestamp AS Timestamp, /*actor_name AS IP,*/ 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 0.1 MONTH, "-", "") AND ct_tag_id IS NULL
SQL

Checking query status...
