Directo al grano

[portalmana]

GROUP BY

DISTINCT tambien sirve y creo que es mas conveniente en tu caso...

Código PHP:

SELECT * FROM tabla WHERE ids='592' GROUP BY tem ORDER BY tem DESC
// o
SELECT distinct(tem) FROM tabla WHERE ids='592' ORDER By tem DESC
 

Saludos