Untitled query #58544

SQL

SELECT comment_text, actor1.actor_name, rev1.rev_timestamp, page1.page_title, actor2.actor_name, rev2.rev_timestamp, page2.page_title FROM revision AS rev1 
JOIN page as page1 on rev1.rev_page=page1.page_id JOIN actor as actor1 ON rev1.rev_actor=actor1.actor_id
JOIN comment ON rev1.rev_comment_id=comment_id JOIN revision as rev2 on rev2.rev_comment_id=comment_id 
JOIN actor AS actor2 on rev2.rev_actor=actor2.actor_id JOIN page as page2 ON rev2.rev_page=page2.page_id
WHERE
comment_text != ''
AND NOT comment_text LIKE '/*%' 
AND NOT comment_text LIKE '%*/'
AND actor1.actor_name = 'Attack898'
AND actor2.actor_name != 'Attack898'
AND rev1.rev_timestamp>'20240901000000'
AND rev2.rev_timestamp>'20240901000000'
AND page1.page_namespace = '0'
AND page2.page_namespace = '0'
ORDER BY rev1.rev_timestamp
SQL

Checking query status...
