MySQL Error!
------------------------

The Error returned was:
Expression #1 of ORDER BY clause is not in SELECT list, references column 'promobil.dle_comments.id' which is not in SELECT list; this is incompatible with DISTINCT

Error Number:
3065

SELECT pos.id, pos.comm_num,pos.category,pos.alt_name,pos.title,pos.date,pos.flag FROM (select distinct post_id from dle_comments order by id desc limit 10) com left join dle_post pos on pos.id=com.post_id WHERE approve = '1' AND category IN ('179','173','174','175','176') limit 0, 5