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;