Hallo zusammen, ich möchte gern eine MySQL anweisung in TS abbilden. Allerdings verstehe ich nicht, wie ich ein Where Exists abbilden kann. Hat da jemand einen Tipp für mich?
Konkret geht es um dieses:
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
_______________________________________________
TYPO3-german mailing list
TYPO3-german@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-german
