[TYPO3-UG Oesterreich] Typoscript tt_address_group

[Stefan Beylen]

Hi,

ich versuche folgendes SQL query in Typoscript abzubilden, scheitere 
aber kläglich:

SELECT *
FROM `tt_address_group` INNER JOIN `tt_address_group_mm`
WHERE tt_address_group.deleted=0
AND tt_address_group.hidden=0
AND tt_address_group.uid = tt_address_group_mm.uid_foreign
AND tt_address_group_mm.uid_local = 3593

can anyone help me please?

20 = CONTENT
20 {
	table = tt_address_group
	select {
		HILFE BITTE!
	}
	renderObj = TEXT
	renderObj {
		field = title
		wrap = |<br />
	}
}

Danke!