Unreviewed pages categorized as "%New_York%"

SQL

SELECT CONCAT('[[',
              (CASE page_namespace
               WHEN 0 THEN ''
               WHEN 2 THEN 'User:'
               WHEN 4 THEN 'Wikipedia:'
               WHEN 10 THEN 'Template:'
               WHEN 14 THEN ':Category:'
               WHEN 118 THEN 'Draft:'
               ELSE CONCAT('{{ns:', page_namespace, '}}:')
               END),
              page_title, ']]') AS 'Page',
		page_len,
        cl_to AS 'Category',
        ptrp_created
FROM pagetriage_page
JOIN page
	ON (page_id = ptrp_page_id)
LEFT JOIN categorylinks
	ON (cl_from = ptrp_page_id)
WHERE ptrp_reviewed = 0
	AND ptrp_deleted = 0
    AND cl_to LIKE '%New_York%'
ORDER BY ptrp_created DESC
LIMIT 1000;
SQL

Checking query status...
