Translation flagged pages not using content translation tool on tewiki

SQL

USE tewiki_p;
SELECT CONCAT('[[', page_title, ']]') as page_title,
       actor_name,
       LEFT(rev_timestamp,8) as date,

FROM page 
INNER JOIN categorylinks  ON page_id = cl_from
JOIN revision ON  page_id = rev_page
JOIN actor ON actor_id=rev_actor
WHERE cl_to = "అనువదించ_వలసిన_పేజీలు" AND 
    page_namespace = 0 and
    rev_parent_id = 0 AND
    page_title NOT IN ( 
      SELECT page_title
      FROM page 
      INNER JOIN categorylinks  ON page_id = cl_from
      JOIN revision ON  page_id = rev_page
      JOIN actor ON actor_id=rev_actor
      JOIN change_tag ON ct_rev_id=rev_id
      JOIN Change_tag_def ON ctd_id=ct_id
      WHERE cl_to = "అనువదించ_వలసిన_పేజీలు" AND 
          page_namespace = 0 and
          rev_parent_id = 0 and
          ctd_name LIKE "contenttranslation%")
ORDER BY LEFT(rev_timestamp,8) DESC
LIMIT 500;
SQL

Checking query status...
