select top 100 cat_id,car_photo,car_id,car_param_array,(select top 1 buy_14 from tz_buyinfo where tz_car.car_id=tz_buyinfo.car_id) as buy_14,(select top 1 buy_company from tz_buyinfo where tz_car.car_id=tz_buyinfo.car_id) as buy_company,(select top 1 buy_name from tz_buyinfo where tz_car.car_id=tz_buyinfo.car_id) as buy_name from tz_car where ispass='1' and ( cat_id in(select cat_id from tz_cat where cat_parentid=1720)) order by car_id asc 慈溪网-汽车频道-车型库
慈溪汽车网>汽车报价东风本田 复制本页链接
进入官方网站
东风本田
东风本田频道|报价|图片
东风本田 车型 厂商指导价 经销商名称 对比

慈溪汽车网 电话:0574-63035050 传真:0574-63035801 业务电话:15306666117