Analysis¶
Which views are used?
SELECT COUNT(ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value')) AS qty,
ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value') AS viewsList
FROM tt_content
WHERE CType = 'list'
AND list_type LIKE 'browser%'
GROUP BY ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value')
ORDER BY viewsList;
Find all plugins with an empty view
SELECT pid,
uid,
ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value') AS viewsList,
hidden AS chidden,
deleted AS cdeleted
FROM tt_content
WHERE CType = 'list'
AND list_type LIKE 'browser%'
AND ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value') = ''
ORDER BY pid,
uid;
Find all plugins with a specific view
SELECT pid,
uid,
ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value') AS viewsList,
hidden AS chidden,
deleted AS cdeleted
FROM tt_content
WHERE CType = 'list'
AND list_type LIKE 'browser%'
AND 61826 IN (ExtractValue(pi_flexform,'/T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="viewsList"]/value'))
ORDER BY pid,
uid;