[bluesman]

Nemam mysql 5 i ne radi mi tako, ali radi ovako:

SELECT news_id, cat_id from news group by cat_id order by news_date DESC;

Dobijem:

+---------+---------+
| news_id | cat_id |
+---------+---------+
|      17 |      10 |
|       7 |       0 |
|       6 |       2 |
|       1 |       3 |
|       5 |       1 |
+---------+---------+