56,673
社区成员
发帖
与我相关
我的任务
分享
SELECT
o.mobile AS mobile,
o.user_name AS userName,
o.dealer_id AS dealerId,
o.location_id AS locationId,
o.user_ip AS userIp,
CASE
WHEN LENGTH(IFNULL(city.attach_province_id, '')) = 0
THEN city.city_name
ELSE CONCAT(city.attach_province_name,' ',city.attach_city_name)
END AS city,
CONCAT(car.car_name,' ',car.car_year) AS carName,
cs.cs_show_name AS cbName,
cs.mb_Name AS bsName,
o.car_id AS carId,
DATE_FORMAT(o.create_time,'%Y-%m-%d %H:%i:%s') AS createTime,
o.update_by AS updateBy,
o.STATUS,
o.source,
o.channel,
o.zt,
o.key
FROM car_order o
LEFT JOIN car_city city ON o.location_id = city.city_id
LEFT JOIN (SELECT dealer_short_name, dealer_id FROM car_dealer GROUP BY dealer_id) dealer ON dealer.dealer_id = o.dealer_id
LEFT JOIN car_info car ON car.car_id = o.car_id
LEFT JOIN car_serial cs ON cs.cs_id = car.cs_id
WHERE date_format(o.create_time, '%Y-%m-%d') BETWEEN date_format('2016-12-14', '%Y-%m-%d') AND date_format('2016-12-15', '%Y-%m-%d')