Untitled query #58544

This query is marked as a draft This query has been published by Larske.

SQL

SELECT comment_text, rev1.timestamp, actor1_name, page1_title FROM revision AS rev1 JOIN page as page1 on rev1_page=page1_id 
JOIN comment ON rev1_comment_id=comment_id JOIN actor AS actor1 on rev1_actor=actor1_id JOIN revision as rev2 ON rev2_comment_id=comment_id 
JOIN actor AS actor2 ON rev_actor=actor2_id WHERE
rev1_timestamp>'20240921000000'
ORDER BY rev1_timestamp

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...