Liefert alle Datensätze, die Dateilinks aus dem Storage 1 (meistens "fileadmin") einbinden

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