Table 'www_evzcw_com.***_ecms_chexing' doesn't exist
select concat(min(a.price*1),'-',max(a.price*1)) as price,b.* FROM ***_ecms_chexing a LEFT JOIN ***_ecms_chexi b ON a.chexi = b.id where a.id<>'' and b.id<>'' and a.price <> '' AND b.brand = 29 AND a.type = 7 AND a.level = 3 AND a.guobie = 7 AND b.changshang = 40 AND a.gongxinxuhang >= 100 AND a.gongxinxuhang <= 200 AND a.price <= 5 GROUP BY b.id order by a.id desc limit 0,12