unreviewed articles by number of external links

SQL

# SHOW TABLES FROM enwiki_p;
# DESCRIBE enwiki_p.pagetriage_page;
/* 
SELECT * 
FROM enwiki_p.pagetriage_page
WHERE ptrp_reviewed = 0; 
*/
# DESCRIBE enwiki_p.logging;
# DESCRIBE enwiki_p.pagetriage_page

/* SELECT * 
FROM logging 
WHERE log_user = 120801 
AND log_timestamp > (NOW() - INTERVAL 7 DAY);
*/

SELECT DISTINCT `ug_group` FROM `user_groups`;

/* SELECT page_title, rev_user_text, COUNT(rev_user)
	FROM enwiki_p.revision 
    	JOIN enwiki_p.pagetriage_page ON rev_page = ptrp_page_id 
        JOIN page ON  page_id = rev_page
        JOIN user_groups ON ug_user = rev_user
    WHERE 
		ptrp_reviewed = 0 
		AND page_id = ptrp_page_id
		AND page_is_redirect = 0
		AND page_namespace = 0 
		AND ptrp_created > (NOW() - INTERVAL 90 DAY)
		AND ug_group = 'sysop'
GROUP BY rev_user, page_title
ORDER BY COUNT(rev_user) DESC
*/
SQL

Checking query status...
