SQL
AخA
SELECT p.page_title, actor_name, rev_timestamp, pr.page_title
(SELECT COUNT(DISTINCT actor_name) FROM revision
JOIN actor_revision ON actor_id = rev_actor
WHERE rev_page = pr.page_id
) AS num_commentors
FROM page p
JOIN categorylinks ON cl_from = page_id AND cl_to = 'Requests_for_peer_review'
JOIN revision ON rev_page = page_id AND rev_parent_id = 0
JOIN actor_revision ON actor_id = rev_actor
LEFT JOIN page pr ON pr.page_namespace = 4 AND pr.page_title LIKE 'Peer_review/' + p.page_title + '%'
WHERE p.page_namespace = 1
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.