In principle, it's quite simple with a little SQL:
SELECT
p.uid,
p.title,
c.sys_language_uid,
COUNT(c.uid) AS total_content,
SUM(CASE WHEN c.l18n_parent = 0 THEN 1 ELSE 0 END) AS free_mode_content,
SUM(CASE WHEN c.l18n_parent > 0 THEN 1 ELSE 0 END) AS connected_mode_content
FROM pages p
JOIN tt_content c ON c.pid = p.uid
WHERE c.sys_language_uid > 0 AND c.deleted = 0 AND p.deleted = 0
GROUP BY p.uid, p.title, c.sys_language_uid
HAVING free_mode_content > 0 AND connected_mode_content > 0
ORDER BY p.uid, c.sys_language_uid; I hope this helps you with the cleanup.
