Sandbox - Quarry

SQL

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 CONCAT('Peer_review/', p.page_title, '%')
WHERE p.page_namespace = 1
SQL

Checking query status...
