[TYPO3-german] MySQL -> TS: Select Where Exists

Peter Reinboth mailinglisten at preinboth.de
Thu Oct 27 14:44:57 CEST 2016


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
 
 
 
 
 
 



More information about the TYPO3-german mailing list