Untitled query #85378

SQL

SELECT page_title, page_namespace, comment_text, actor_name, r1.rev_timestamp
FROM revision_userindex r1
JOIN actor_revision ON actor_id = r1.rev_actor
LEFT JOIN page ON page_id = r1.rev_page
LEFT JOIN comment_revision ON comment_id = r1.rev_comment_id
LEFT JOIN revision r2 ON r1.rev_parent_id = r2.rev_id
AND comment_text LIKE '%@%'
AND comment_text LIKE '%.com%'
AND comment_text REGEXP '[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.com'
AND comment_text NOT LIKE '%wikimedia.com%'
AND comment_text NOT LIKE '%hotel.com%'
AND comment_text NOT LIKE '%Patrick.Martin@%'
SQL

Checking query status...
