probot - Quarry

SQL

SELECT page.page_namespace, page.page_title
FROM (SELECT lt_namespace AS page_namespace, lt_title AS page_title, 
    		COUNT(*) AS total_transclusions,
              COUNT(CASE WHEN tl_from_namespace = 0 OR tl_from_namespace = 118 THEN 1 END) AS content_transclusions
    FROM linktarget
    INNER JOIN templatelinks ON linktarget.lt_id = templatelinks.tl_target_id
    GROUP BY lt_id
    HAVING COUNT(*) >= 100)
    	AS candidates
INNER JOIN page ON candidates.page_namespace = page.page_namespace AND candidates.page_title = page.page_title
LEFT OUTER JOIN page_restrictions AS edit_prot ON page.page_id = edit_prot.pr_id AND edit_prot.pr_type = 'edit'
LEFT OUTER JOIN page_restrictions AS move_prot ON page.page_id = move_prot.pr_id AND move_prot.pr_type = 'move'
WHERE total_transclusions + content_transclusions >= 1000 AND ((edit_prot.pr_level IS NULL OR edit_prot.pr_expiry IS NOT NULL)
       OR (move_prot.pr_level IS NULL OR move_prot.pr_expiry IS NOT NULL))
GROUP BY page.page_id;
SQL

Checking query status...
