XML Query in SQL.sql

SELECT 
  uid, pid, list_type,
  ExtractValue(`tt_content`.`pi_flexform`, '//T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="settings.category"]/value') category,
  ExtractValue(`tt_content`.`pi_flexform`, '//T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="settings.special"]/value') special
FROM tt_content
WHERE
  CType='list' AND
  list_type='xxx' AND 
  ExtractValue(`tt_content`.`pi_flexform`, '//T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="settings.category"]/value') = '';

SELECT 
  uid, pid, list_type,
  ExtractValue(`tt_content`.`pi_flexform`, '//T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="switchableControllerActions"]/value') switchableControllerActions
FROM tt_content
WHERE
  deleted=0 AND
  CType='list' AND
  list_type='news_pi1';

-- Powermail Plugin using a certain form
SELECT 
  uid, pid, list_type,
  ExtractValue(`tt_content`.`pi_flexform`, '//T3FlexForms/data/sheet[@index="main"]/language/field[@index="settings.flexform.main.form"]/value') form
FROM tt_content
WHERE
  CType='list' AND
  list_type='powermail_pi1' AND 
  ExtractValue(`tt_content`.`pi_flexform`, '//T3FlexForms/data/sheet[@index="main"]/language/field[@index="settings.flexform.main.form"]/value') = 3;