select id, product, cas_no, company, post_date, pubDate, mtype_en, poster, cate1 from sell s JOIN ( SELECT id FROM sell order by pubDate desc limit 0,45 ) x ON x.id = s.id where 1 and pubDate >= date_add(current_date(), interval -14 day) order by pubDate desc, mtype_en desc, post_date desc;Caveats:
|is read block write?||2029||h ch||10/10/2011 01:02AM|
|Re: is read block write?||1007||Rick James||10/12/2011 06:05AM|
|Re: is read block write?||636||h ch||10/18/2011 11:50PM|
|Re: is read block write?||808||Rick James||10/20/2011 10:54PM|
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.