unreviewed articles by number of external links

SQL

#reviewed pages without talk pages  that are not dismambiguation pages
SELECT *
FROM pagetriage_page 
JOIN enwiki_p.page ON page_id = ptrp_page_id 
JOIN  templatelinks  ON tl_from = page_id
WHERE ptrp_last_reviewed_by = 120801
AND page_namespace = 0
AND NOT EXISTS (SELECT * FROM page AS talk WHERE talk.page_title = page.page_title AND talk.page_namespace = 1)
AND tl_title NOT IN ('Disambiguation', 'disambiguation' ,'Hndis', 'human name disambiguation', 'geodis', 'Disambig', 'disambig' 'Dab', 'Disambiguation_page_short_description', '	Disambiguation/cat', 'Title_disambig_text');

SQL

Checking query status...