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 
WHERE
comment_text != ''
AND actor1.actor_name = 'Riggwelter'
AND actor2.actor_name != 'Riggwelter'
AND rev1.rev_timestamp>'20240901000000'
AND rev2.rev_timestamp>'20240901000000'
ORDER BY rev1.rev_timestamp
SQL

Checking query status...
