SQL-Query

[Ilja]

yo,

SELECT modul.id, modul.category_id .... modul.created, categories.category
FROM nboard modul, nboard_categories categories
WHERE categories.id=modul.category_id
AND modul.created =
   (
   SELECT MAX(tab1.created)
   FROM nboard tab1
   WHERE tab1.category_id = modul.category_id
   )

die anderen LEFT JOINS habe ich mir mal ersparrt.

Ilja