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 NOT IN 
( SELECT tl_from
 FROM templatelinks
 WHERE tl_title = 'Disambiguation'
 OR tl_title IN ('Disambiguation', 'disambiguation' ,'Hndis', 'human name disambiguation', 'geodis', 'Disambig', 'disambig' 'Dab', 'Disambiguation_page_short_description', '	Disambiguation/cat', 'Title_disambig_text')
AND tl_namespace = 10
);
SQL

Checking query status...
