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 rev_user_text, COUNT(rev_user)
FROM enwiki_p.revision JOIN enwiki_p.pagetriage_page ON rev_page = ptrp_page_id
WHERE 
ptrp_reviewed = 0 
page_is_redirect=0
GROUP BY rev_user
ORDER BY COUNT(rev_user) DESC;

SQL

Checking query status...