select car.*, shop.*, maker.maker_e,carname.carname_e from cartown_smain.car inner join cartown_smain.shop on car.shop_id = shop.shop_id and shop.shopvalid=1 inner join cartown_smain.company on car.com_id = company.com_id and company.comvalid=1 left join cartown_smain.maker on car.makercode=maker.maker_code left join cartown_smain.carname on car.makercode=carname.maker_code and car.carname=carname.carname where car.car_disp = 1 and car.carvalid = 1 and shop.tdfkcode in(11) order by car.pricemode_order2, car.carimg1 desc limit 1220, 20