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
WHERE page_namespace != 0 AND comment_text LIKE '%@%' AND comment_text LIKE '%.de%' AND comment_text NOT LIKE '%@[[%' AND comment_text NOT LIKE '%@import%' AND comment_text NOT LIKE '%@ [[%' AND r1.rev_timestamp > '20240101000000' AND r1.rev_timestamp < '20240807000000'
LIMIT 70
SQL

Checking query status...
