[wp-hackers] SELECT DISTINCT .... ORDER BY not working....

[Aaron Brazell]

This works for me...

SELECT DISTINCT comment_post_id FROM wp_comments
   WHERE comment_approved = '1'
GROUP BY comment_id
ORDER BY comment_date DESC

--
Aaron Brazell
Director of Technology, b5media

skype: technosailor
phone: 410-608-6620
web: http://technosailor.com

Everything contained in this email is confidential and stuff

On Nov 19, 2007, at 4:18 PM, Computer Guru wrote:

> SELECT DISTINCT comment_post_id FROM wp_comments
>   WHERE comment_approved = '1'
> ORDER BY comment_date DESC