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

[Computer Guru]

Thank you!!


On 11/20/07, Kimmo Suominen <kimmo at global-wire.fi> wrote:
>
> That's an interesting bug with MySQL.
>
> This seems to produce the result wanted:
>
> SELECT comment_post_id
> FROM wp_comments
> WHERE comment_approved = '1'
> GROUP BY comment_post_id
> ORDER BY MAX(comment_date) DESC
>
> Best regards,
> + Kimmo
> --
> <A HREF="http://kimmo.suominen.com/">Kimmo Suominen</A>
>
>
> On Mon, Nov 19, 2007 at 11:27:34PM +0200, Computer Guru wrote:
> > 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/
> > _______________________________________________
> > wp-hackers mailing list
> > wp-hackers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-hackers
> >
> _______________________________________________
> 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/