Untitled query #77570

SQL

WITH revisions AS (SELECT childRev.rev_page, childRev.rev_timestamp
FROM revision_userindex AS childRev
JOIN revision AS parentRev ON childRev.rev_parent_id = parentRev.rev_id
WHERE childRev.rev_actor = 191773594
AND (childRev.rev_parent_id - parentRev.rev_id >= 200
     OR childRev.rev_parent_id - parentRev.rev_id <= -200))
     
SELECT rev_timestamp as MainspaceEdits
FROM revisions
JOIN page ON rev_page = page_id
WHERE page_namespace = 0
ORDER BY rev_timestamp ASC;

SELECT rev_timestamp AS TalkEdits 
FROM revisions
JOIN page ON rev_page = page_id
WHERE page_namespace = 1
ORDER BY rev_timestamp ASC;

SELECT rev_timestamp AS AllEdits
FROM revisions
ORDER BY rev_timestamp ASC;
SQL

Checking query status...
