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

[Computer Guru]

Nope, not working....

Expected result:

493
501
229
485
....

Actual result:
501
502
500
491
....

That's the same result I get w/ the original SELECT DISTINCT ... GROUP BY
query in my OP.


On 11/19/07, Aaron Brazell <emmensetech at gmail.com> wrote:
>
> 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
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>



-- 
Computer Guru
Director,
NeoSmart Technologies
http://neosmart.net/blog/