All categories in MLWiki

SQL

USE enwiki_p;
SELECT DISTINCT 
page.page_title, rev_page, rev_id, rev_user,	rev_user_text,	rev_timestamp, rev_len,	rev_parent_id,rev_minor_edit, rev_deleted	
FROM  revision
Join page ON rev_page = page_id

WHERE rev_parent_id = 0 and  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") 
                                                      		)
     ) Order by rev_id asc;
SQL

Checking query status...
