Create List of Translation Entries

create-translation-entry-list.sql

-- Don't forget to add table prefixes if necessary
select distinct tf.`elementId` as 'Entry ID', c.`title` as 'Entry Title', s.name as 'Target Site'
	from translations_files as tf
		inner join `content` as c
			on c.`elementId` = tf.`elementId`
			and tf.`status` != 'published'
		inner join `sites` as s
			on tf.`targetSite` = s.id;