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 page_id IN 
( SELECT tl_from
 FROM templatelinks
 WHERE tl_title = 'Disambiguation'
 OR LOWER(tl_title) IN ('disambiguation' ,'hndis', 'human name disambiguation', 'geodis', 'disambig', 'dab', 'disambiguation_page_short_description', '	disambiguation/cat', 'title_disambig_text')
AND tl_namespace = 10
);

SQL

Checking query status...