USE enwiki_p;

SELECT COUNT(DISTINCT ptrp_page_id) FROM pagetriage_page p

    JOIN page ON page.page_id = p.ptrp_page_id

    LEFT JOIN pagetriage_page_tags pt ON pt.ptrpt_page_id = p.ptrp_page_id

    LEFT JOIN pagetriage_tags t ON t.ptrt_tag_id = pt.ptrpt_tag_id

WHERE ptrp_reviewed = 0

    AND page_is_redirect = 0

    AND page_namespace = 0

    AND (ptrp_deleted = 1 OR ptrt_tag_name IN ('csd_status', 'prod_status', 'blp_prod_status', 'afd_status'))

​