Fork of
ML edits under Punjab Editathon 2016
by Viswaprabha
This query is marked as a draft
This query has been published
by Viswaprabha.
SQL
x
USE pawiki_p;
SELECT
rev_page, rev_id, rev_user, rev_user_text, rev_timestamp, rev_len, rev_parent_id,rev_minor_edit, rev_deleted
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 = "ਪੰਜਾਬ_ਐਡਿਟਾਥਾਨ_2016_ਦੌਰਾਨ_ਬਣਾਏ_ਗਏ_ਲੇਖ")
)
) Order by rev_id asc;
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.