Punjabi Editathon statistics

SQL

USE enwiki_p;
SELECT COUNT(*), p.page_title, p.page_id, r1.rev_timestamp, r1.rev_user_text, r2.rev_user_text, r2.rev_timestamp, r2.rev_len 
FROM revision r
LEFT JOIN page p ON p.page_id = r.rev_page
LEFT JOIN revision r1 ON r1.rev_page = p.page_id AND r1.rev_parent_id = 0
LEFT JOIN revision r2 ON r2.rev_id = p.page_latest 
WHERE r.rev_page IN
( SELECT page_id FROM page AS p2
    WHERE p2.page_namespace = 0 AND p2.page_title IN
 	( SELECT page_title FROM page
      WHERE page_id IN (SELECT cl_from FROM categorylinks
      WHERE cl_to = "Articles_created_as_part_of_Punjab_Editathon_-_2016") 
    )
)
AND p.page_namespace = 0
GROUP BY page_namespace, page_title;
SQL

Checking query status...
