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,
       pr_closed.page_title,
       pr_closed.page_title IS NOT NULl AS is_closed
FROM page p
         JOIN categorylinks ON cl_from = page_id AND cl_to = 'Requests_for_peer_review'
         LEFT JOIN (
                SELECT page_title, page_id FROM page
                JOIN categorylinks ON cl_from = page_id AND cl_to = 'Current_peer_reviews'
            ) pr ON pr.page_title LIKE CONCAT('Peer_review/', p.page_title, '/archive%')
         LEFT JOIN (
                SELECT page_title, page_id FROM page
                JOIN templatelinks ON tl_from = page_id AND tl_namespace = 10 AND tl_title = 'Closed_peer_review_page'
            ) pr_closed ON pr_closed.page_title LIKE CONCAT('Peer_review/', p.page_title, '/archive%')
         LEFT JOIN revision ON rev_page = pr.page_id AND rev_parent_id = 0
         LEFT JOIN actor_revision ON actor_id = rev_actor
WHERE p.page_namespace = 1
SQL

Checking query status...
