Hallo TYPO3-German-NG, ich möchte gern eine MySQL Abfrage in TS portieren. Allerdings scheitere ich schon am Anfang. Ich habe bisher im Netz keinen Hinweis gefunden, wie man ein Select Where Exists in TypoScript abbildet. Kann mir da bitte jemand weiterhelfen?
Konkret geht es um folgende SQL Abfrage:
SELECT mother.title FROM sys_category AS mother
WHERE exists ( SELECT kind.title FROM sys_category AS kind
INNER JOIN sys_category_record_mm AS record ON (kind.uid =
record.uid_local)
INNER JOIN tx_news_domain_model_news AS news ON (record.uid_foreign =
news.uid)
WHERE record.tablenames = 'tx_news_domain_model_news'
AND kind.parent = mother.uid
AND kind.hidden = 0
AND kind.deleted = 0
AND kind.pid IN (53,58,57,56,55,54)
AND news.hidden = 0
AND news.deleted = 0
)
AND mother.parent = 0
AND mother.hidden = 0
AND mother.deleted = 0
AND mother.pid IN
(53,58,57,56,55,54)
order by mother.sorting
--
Grüße aus Berlin
Peter Reinboth
_______________________________________________
TYPO3-german mailing list
TYPO3-german@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-german
