Orphaned Translingual proper noun entries

SQL

SELECT page_title AS `Page`, ,
  COALESCE(GROUP_CONCAT(REPLACE(REPLACE(catlinks_rank.cl_to, 'mul:Taxonomic_names_(', ''), ')', '') SEPARATOR ', '), 'no taxon template') AS `Taxonomic rank`
  CONCAT(SUBSTRING(log_timestamp, 1, 4), '-', SUBSTRING(log_timestamp, 5, 2), '-', SUBSTRING(log_timestamp, 7, 2)) AS `Creation date`
FROM page
  INNER JOIN categorylinks AS catlinks_mul ON catlinks_mul.cl_from = page_id
  LEFT JOIN categorylinks AS catlinks_rank ON catlinks_rank.cl_from = page_id AND catlinks_rank.cl_to LIKE 'mul:Taxonomic_names_(%'
  LEFT JOIN logging_logindex AS create_log ON page_namespace = log_namespace AND page_title = log_title AND log_type = 'create'
  LEFT JOIN pagelinks ON page_namespace = pl_namespace AND page_title = pl_title AND pl_from_namespace = 0
WHERE
  catlinks_mul.cl_to = 'Translingual_proper_nouns' AND
  pl_from IS NULL
GROUP BY page_title, log_timestamp
ORDER BY log_timestamp DESC
SQL

Checking query status...
