[TYPO3-english] JOIN ... AS ... in Typoscript

[Ralf-Rene Schröder]

sorry for doubleposting from german list...

i have to query a parent and a child genre in my sql request...

i have a SQL query with the absolut correct result !!!
(in my database this are 3 records)

SELECT *
FROM tx_ifcwmedia_mediaitems
JOIN tx_ifcwmedia_mediaitems_genres_mm AS mm1
ON(tx_ifcwmedia_mediaitems.uid=mm1.uid_local)
JOIN tx_ifcwmedia_mediaitems_genres_mm AS mm2
ON(tx_ifcwmedia_mediaitems.uid=mm2.uid_local)
WHERE mm1.uid_foreign=30 AND mm2.uid_foreign=4

but with typoscript (completly reduced and hardcoded) there is NO result
???

count = TEXT
count.numRows.table = tx_ifcwmedia_mediaitems
count.numRows.select {
  join = tx_ifcwmedia_mediaitems_genres_mm AS mm1
ON(tx_ifcwmedia_mediaitems.uid=mm1.uid_local)
JOIN tx_ifcwmedia_mediaitems_genres_mm AS mm2
ON(tx_ifcwmedia_mediaitems.uid=mm2.uid_local)
  where = mm1.uid_foreign=30 AND mm2.uid_foreign=4
}

(info: join = is only one row in my TS)
is it possible that the JOIN ... AS is not possible in Typoscript ???

-- 
image[FORMAT] - Ralf-René Schröder
http://www.image-format.eu ... Wir geben Ihrem Image das richtige Format