group by desc y order by desc

[RocoBox3000]

tabla comments

id -> int
idu -> varchar
comment -> text
date -> date time

tabla usuarios

id -> int
idu -> varchar
nombre -> varchar
foto -> varchar

Código MYSQL:

SELECT * FROM (SELECT * FROM comments ORDER BY date DESC) t1 GROUP BY idu LIMIT 10
 
SELECT * from users WHERE idu='".$rcom['idu']."'
 

Editado: Código de programacion no permitido en foros de BBDD.

saludos