Sandbox - Quarry

SQL

SELECT p.page_title, actor_name, rev_timestamp,
       (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
         JOIN page pr ON pr.page_namespace = 4 AND pr.page_title LIKE 'Peer_review/' + p.page_title + '/%'
WHERE p.page_namespace = 1
SQL

Checking query status...
