Skip to content

Instantly share code, notes, and snippets.

@vertexvaar

vertexvaar/query.sql

Created November 29, 2019 09:52
Show Gist options
  • Save vertexvaar/0cb83e53217bd1b477a80c1f42cc09fa to your computer and use it in GitHub Desktop.
Save vertexvaar/0cb83e53217bd1b477a80c1f42cc09fa to your computer and use it in GitHub Desktop.
Download ZIP
SQL query select News Plugin with "List News" action
Raw
query.sql
SELECT *
FROM tt_content
WHERE `CType` = 'list'
AND `list_type` = 'news_pi1'
AND ExtractValue(`pi_flexform`,
'/T3FlexForms/data/sheet[@index="sDEF"]/language[@index="lDEF"]/field[@index="switchableControllerActions"]/value[@index="vDEF"]/text()')
IN ("News->list;News->detail", "News->list;News->detail");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment