Skip to content

Instantly share code, notes, and snippets.

@alfredbez

alfredbez/typo3.selectStorage.sql

Created February 11, 2015 14:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alfredbez/5c76077d02884c9cd424 to your computer and use it in GitHub Desktop.
Save alfredbez/5c76077d02884c9cd424 to your computer and use it in GitHub Desktop.
Download ZIP
Liefert alle Datensätze, die Dateilinks aus dem Storage 1 (meistens "fileadmin") einbinden
Raw
typo3.selectStorage.sql
SELECT DISTINCT
t4.title as Seite,
t4.uid as SeitenID,
t3.header as Titel,
t3.uid as InhaltsID
FROM
sys_file as t1,
sys_file_reference as t2,
tt_content as t3,
pages as t4
WHERE
t2.uid_foreign = t3.uid
AND t1.uid = t2.uid_local
AND t1.storage = 1
AND t2.deleted = 0
AND t2.hidden = 0
AND t4.uid = t3.pid
ORDER BY
InhaltsID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment