select DATE_FORMAT(p.post_date,'%Y-%m-%d') as post_date,p.pic_name as pic_name,p.pic_name1 as pic_name1,p.id,p.product,replace(replace(replace(replace(p.product,' ','-'),'.','-'),'/','-'),'"','-') as product_cut,p.intro,p.asid,p.id as pid,IF(p.rank > 100 AND c.mark =1, 100, p.rank) AS rank,IF(c.rank_date, c.rank_date, '2999') AS cidrank,c.mark, c.company,replace(replace(SUBSTRING_INDEX(c.company,' ',3),'.','-'),' ','-') as company_cut,c.cate1 as cate1_id, r.category as country,r.dir as country_dir,'http://www.toocle.com' as webbase from toocle.product_s_base_p as psp,toocle.product_s as p,toocle.company_s as c left join toocle_cate.regional_toocle as r on r.cat_id = c.cate1 where psp.cid = c.id and psp.pid=p.id and psp.prank like '1%' and psp.catid4 = '4119' order by psp.prank desc limit 10,10