Untitled query #60097

SQL

SELECT rev_id, page_title, comment_text
FROM revision_userindex
JOIN change_tag ON ct_rev_id = rev_id
JOIN comment_revision ON rev_comment_id = comment_id
JOIN page ON rev_page = page_id
WHERE 
	ct_tag_id = (SELECT ctd_id from change_tag_def WHERE ctd_name = "twinkle")
    AND page_namespace = 2
    AND page_title NOT LIKE "%/%"
    AND comment_text NOT LIKE "Reverted%"
    AND comment_text NOT LIKE "Restored%"
    AND comment_text NOT LIKE "Changed protection%"
    AND comment_text NOT LIKE "%CSD%"
ORDER BY rev_timestamp DESC
SQL

Checking query status...
