SQL
x
USE enwiki_p;
SELECT rev_page AS 'Page', rev_id AS 'Creation ID', rev_user_text AS 'Creator', rev_timestamp AS 'Creation timestamp',
FROM revision
WHERE 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 rev_parent_id = 0;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.