Skip to content

Instantly share code, notes, and snippets.

@froemken

froemken/ShowTYPO3CEsByType.sql

Last active October 9, 2025 09:07
Show Gist options
  • Save froemken/dfc13a5cc5261143b5fd21e6b5d038ba to your computer and use it in GitHub Desktop.
Save froemken/dfc13a5cc5261143b5fd21e6b5d038ba to your computer and use it in GitHub Desktop.
Download ZIP
Show all list of all kind of used TYPO3 content elements and where they are used incl. a count
Raw
ShowTYPO3CEsByType.sql
SELECT CType, list_type, GROUP_CONCAT(pid) AS Seiten, COUNT(*) AS Anzahl
FROM `tt_content`
WHERE `tt_content`.`hidden` = 0
AND `tt_content`.`deleted` = 0
GROUP BY CType, list_type
ORDER BY CType, list_type;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment