Orphaned Translingual proper noun entries

SQL

SELECT CONCAT(
  '{{l|mul|', page_title, '}} ',
  '(rank: ', COALESCE(GROUP_CONCAT(REPLACE(REPLACE(catlinks_rank.cl_to, 'mul:Taxonomic_names_(', ''), ')', '') SEPARATOR ', '), '[taxon template missing]'), ' | ',
  'created: ', COALESCE(CONCAT(SUBSTRING(log_timestamp, 1, 4), '-', SUBSTRING(log_timestamp, 5, 2), '-', SUBSTRING(log_timestamp, 7, 2)), '???'), ')')
  
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...
