# unreviewed articles by number of external links 

SELECT page_title, COUNT(*) AS links #, TRIM(LEADING 'www.' FROM SUBSTRING_INDEX(SUBSTRING_INDEX(el_to, '/', 3),'/',-1)) AS site

FROM externallinks, page, pagetriage_page 

WHERE el_from = page_id

AND page_namespace = 0

AND page_id = ptrp_page_id 

AND ptrp_reviewed = 0

AND page_is_redirect=0

GROUP BY page_title

HAVING COUNT(*) >= 1 

ORDER BY links DESC;

​

​

​