Re: GROUP BY is too greedy

2003-02-18 Thread Paul DuBois
At 18:32 -0800 2/18/03, Jon Drukman wrote: this query: select ep.product, s.id,s.type,s.headline,date_format(post_date,'%a, %m/%d/%y - %h:%m %p') date,user_level,s.ext_url from story s left join e_prod ep on ep.story=s.id where s.post_date > date_sub(now(), interval 14 day) and s.status = 9 or

GROUP BY is too greedy

2003-02-18 Thread Jon Drukman
this query: select ep.product, s.id,s.type,s.headline,date_format(post_date,'%a, %m/%d/%y - %h:%m %p') date,user_level,s.ext_url from story s left join e_prod ep on ep.story=s.id where s.post_date > date_sub(now(), interval 14 day) and s.status = 9 order by post_date desc limit 10 returns the