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)

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;