21,886
社区成员
发帖
与我相关
我的任务
分享
select a.id,b.id as mycompid,b.typeid,b.co_end,a.pro_price,
a.pro_name as realproname,a.discount_rate,a.bigpic,a.temp_url,b.co_name,
c.pro_name,d.city_name,a.begindate,a.modifydate,a.pro_intro
from product a
left join company b on(a.userid=b.id)
left join pro c on(b.proid=c.id)
left join city d on(b.cityid=d.id)
left join protype e on(a.typeid=e.id)
where (a.pro_name like binary '%%' or a.pro_intro like binary '%%' or a.keywords like binary '%%')
and co_type=112 and b.islock=0 and a.isdel=0 and a.comp_state=1 and b.islock=0 order by b.realtypeid desc,a.modifydate desc limit 0,20