categories of unreviewd articles

SQL

#DESCRIBE pagetriage_page
#DESCRIBE page
#DESCRIBE templatelinks

#SELECT page.page_title, templatelinks.tl_title 
#FROM page 
#JOIN templatelinks ON templatelinks.tl_from = page.page_id
#WHERE page.page_id=10837430 
#AND page.page_namespace=1
#AND templatelinks.tl_namespace=10
#AND templatelinks.tl_title LIKE '%WikiProject%'
SELECT categorylinks.cl_to, COUNT(page.page_title)
FROM page JOIN categorylinks ON page.page_id=categorylinks.cl_from
#WHERE page.page_id=10837430 
WHERE page.page_id IN (
SELECT page.page_id
FROM revision 
JOIN pagetriage_page ON rev_page = ptrp_page_id 
JOIN page ON page_id = rev_page 
WHERE rev_parent_id = 0
AND ptrp_reviewed = 0
AND page_namespace = 0
AND page_is_redirect = 0
) 
AND page.page_namespace=0
GROUP BY categorylinks.cl_to
ORDER BY COUNT(page.page_title)
SQL

Checking query status...
