Content translation reference errors (#1)

SQL

select 
	page_title, 
    page_namespace, 
    r.rev_timestamp, 
    group_concat(ctd_name) AS tags 
FROM 
	(
  		SELECT 
  			MIN(rev_timestamp) AS min_rev_timestamp, 
  			rev_page 
  		FROM 
  			categorylinks,
  			revision 
  		WHERE 
  			cl_from=rev_page 
  			AND cl_to = "Sivut,_joissa_on_viittausvirheitä" 
  		GROUP BY rev_page
	) AS t, 
	page, 
	revision AS r 
	LEFT JOIN change_tag ON r.rev_id=ct_rev_id 
	LEFT JOIN change_tag_def ON ctd_id=ct_tag_id 
WHERE 
	t.rev_page=page_id 
    AND r.rev_page=t.rev_page 
	AND r.rev_timestamp=t.min_rev_timestamp
GROUP BY t.rev_page
ORDER BY tags DESC

SQL

Checking query status...