probot - Quarry

SQL

SELECT page_id, page_namespace, page_title
FROM (SELECT page_id, page_namespace, 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 page
    INNER JOIN linktarget ON page.page_namespace = linktarget.lt_namespace AND page.page_title = linktarget.lt_title
    INNER JOIN templatelinks ON linktarget.lt_id = templatelinks.tl_target_id
    GROUP BY page_id) 
    	AS by_transclusions
LEFT OUTER JOIN page_restrictions AS edit_prot ON by_transclusions.page_id = edit_prot.pr_id AND edit_prot.pr_type = 'edit'
LEFT OUTER JOIN page_restrictions AS move_prot ON by_transclusions.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_id;
SQL

Checking query status...
