USE enwiki_p;

SELECT page_id, page_title, GROUP_CONCAT(ptrt_tag_name) AS tags

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 (ptrpt_value = 1 and ptrt_tag_name != 'user_autoconfirmed' ))

GROUP BY page_id