Pages incorrectly marked as GTP?

SQL

use tewiki_p;
SELECT
  page_title
FROM page
LEFT JOIN revision
      ON rev_id = page_id
LEFT JOIN user
      ON rev_user= user_id
LEFT JOIN categorylinks
	ON categorylinks.cl_from = page.page_id
WHERE page_namespace=0 AND page_is_redirect =0 AND categorylinks.cl_to = 'గూగుల్_అనువాద_వ్యాసాలు' AND (user_name NOT IN (SELECT page_title 
                    FROM page
			LEFT JOIN  categorylinks ON categorylinks.cl_from = page.page_id
		WHERE (page_namespace=2 AND categorylinks.cl_to = 'యాంత్రిక_అనువాదాలు_చేసే_సభ్యులు')))
GROUP BY page_title
ORDER BY page_title,user_name;
SQL

Checking query status...
