[TYPO3-ttnews] category wise news

[Georg Ringer]

Hi,

generally this should be possible but you need a bit more TS. The query 
you need should look kind of this:

----
SELECT tt_news.uid AS uid, tt_news.title AS newstitle, tt_news_cat.uid 
AS catuid, tt_news_cat.title AS catitle
FROM tt_news
JOIN tt_news_cat_mm ON ( tt_news.uid = tt_news_cat_mm.uid_local )
JOIN tt_news_cat ON ( tt_news_cat_mm.uid_foreign = tt_news_cat.uid )
WHERE tt_news.hidden =0
AND tt_news.deleted =0
GROUP BY tt_news.uid
ORDER BY tt_news_cat.uid
----

Georg