[TYPO3-german] MySQL ->TS: select where exists

[Peter Reinboth]

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