comparison - Quarry

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

SQL

SELECT 
rc1.rc_user_text,
rc1.rc_title,
min(rc1.rc_timestamp) as 91_197_23_timestamp,
min(r1.rev_timestamp) as abc10_timestamp
FROM 
recentchanges_compat as rc1,
revision_compat as r1
WHERE 
rc1.rc_user_text LIKE "Jmk"
AND rc1.rc_namespace=0
AND rc1.rc_source NOT IN ("mw.categorize") 
AND rc1.rc_cur_id=r1.rev_page
AND r1.rev_user_text="Abc10"
AND r1.rev_timestamp<rc1.rc_timestamp
AND r1.rev_timestamp>20220000150724
GROUP BY rc_title

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...