Untitled query #58544

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

SQL

SELECT comment_text, rev1.rev_timestamp, actor1.actor_name, page1.page_title FROM revision AS rev1 
JOIN page as page1 on rev1.rev__page=page1.page_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
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...