您所在的位置:首页 >
select top 100 b.id,b.sid,b.city,b.gsmc,b.wdname,b.jiancheng,b.gsmcurl,b.address,a.litpic,a.lianxiren,b.tel,b.lianxitel,a.qq,b.zongbu,b.zb,a.qianming,a.ywms,a.hylx,a.hylx2,a.updatetime,a.picno from ctouser a,ctouser_wangdian b where a.id=b.sid and (c4=17777 or (c2=261 and (b.wdname like '%北果元%' or b.address like '%北果元%'))) and a.user_type=3 and b.stop=1 order by zongbu desc,a.updatetime desc,a.hylx2 desc,a.picno desc