(un)reviewed articles with CSD tags

SQL

# unreviewed pages 
SELECT page_title, tl_title
FROM page 
JOIN templatelinks ON tl_from = page_id
JOIN pagetriage_page ON page_id = ptrp_page_id
WHERE tl_title IN ('Prod_blp', 'Proposed_deletion', 'Proposed_deletion/dated', 'db-g1', 'db-g2', 'db-g3', 'db-g4', 'db-g5', 'db-g6', 'db-g7', 'db-g8', 'db-g9', 'db-g10', 'db-g11',  'db-g12', 'db-g13', 'db-a1', 'db-a2', 'db-a3', 'db-a5', 'db-a7', 'db-a9', 'db-a10', 'db-a11', 'db-r2', 'db-r3')
AND ptrp_reviewed = 0
#AND article.page_is_redirect = 0
LIMIT 100;

SQL

Checking query status...