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

[Kimmo Suominen]

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
>