unreviewed articles by specific user

SQL

#unreviewed articles by user
#SELECT DISTINCT categorylinks.cl_to, COUNT(categorylinks.cl_to) AS count
SELECT page_title,   rev_timestamp  AS created
FROM revision 
JOIN pagetriage_page ON rev_page = ptrp_page_id 
JOIN page ON page_id = rev_page 
JOIN actor ON rev_actor = actor_id
JOIN categorylinks ON page.page_id=categorylinks.cl_from
WHERE rev_parent_id = 0
AND categorylinks.cl_to IN ('CS1_German-language_sources_(de)')
AND categorylinks.cl_to NOT IN ('All_articles_with_failed_verification')
AND actor_name = 'Gihan Jayaweera'
AND ptrp_reviewed = 0
AND page_namespace = 0
AND page_is_redirect = 0
#GROUP BY categorylinks.cl_to
#ORDER BY COUNT(categorylinks.cl_to) DESC
SQL

Checking query status...
