Unreviewed pages categorized as "%New_York%"

SQL

SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(rev_comment, ':',  2), ':', -1) AS 'Source wiki',
	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,
           page_is_redirect
FROM revision
JOIN change_tag
	ON ct_rev_id = rev_id
JOIN page
	ON page_id = rev_page
WHERE ct_tag = 'contenttranslation'
	AND rev_timestamp >= 20160727115600;
SQL

Checking query status...
