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
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