Which extensions are used on which pages?

Sometimes it would be helpful to know which extensions are used on which pages. This information can also be obtained with a special extension, but you can also simply use MySQL. If there are more than 5000 tt_content records, we recommend creating an index to speed up the query.

ALTER TABLE `tt_content` 
ADD INDEX `plugins` ( `
CType`( 30 ), 
`list_type`( 50 ), 
`uid`, 
`pid` 
); 

You can then use a SELECT command to display all the extensions used, including the UIDs of the pages on which they are used:

SELECT list_type, 
GROUP_CONCAT(pid) AS pages, 
GROUP_CONCAT(uid) AS ttContentUids 
FROM tt_content 
WHERE CType = 'list' 
AND list_type <> "" 
AND deleted = 0 
GROUP BY list_type 
ORDER BY list_type