Hey,

>  FROM  WHERE  GROUP BY lat ORDER BY lat

$GLOBALS['TYPO3_DB']->exec_SELECTquery('SELECT v1.*, (SELECT MIN(uid) 
FROM tx_drwiki_pages WHERE pid='.$GLOBALS['TSFE']->id.' AND 
keyword=v1.keyword GROUP BY keyword) AS lat','v1, 
tx_drwiki_pages','v1.pid='.$GLOBALS['TSFE']->id,'lat','lat');

-- 
Jan Bednarik
www.bednarik.org - web about Typo3 in czech
_______________________________________________
TYPO3-english mailing list
[email protected]
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english

Reply via email to