Punjabi Editathon statistics

SQL

USE enwiki_p;
SELECT p.page_id, p.page_title, r.rev_timestamp AS 'Creation time', r.rev_user_text AS 'Creator', r.rev_id AS 'Creation ID',
r1.rev_len AS 'Latest edit size', r1.rev_timestamp AS 'Last edit time', r1.rev_user_text AS 'Last editor', r2.cnt
FROM page p
LEFT JOIN revision r ON r.rev_page = p.page_id AND r.rev_parent_id = 0
LEFT JOIN revision r1 ON r1.rev_id = p.page_latest
LEFT JOIN 
( SELECT rev_page, COUNT(*) AS cnt FROM revision GROUP BY rev_page ) r2 ON r2.rev_page = p.page_id
WHERE p.page_id 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_title;
SQL

Checking query status...
