select car.car_seq,car_nm, photo.photo_upload_nm from car_basic_info as car
left outer join (select car_seq, photo_upload_nm from car_photo where main_flag = 'Y') as photo
on car.car_seq = photo.car_seq
where rent_type = '신차장기' and use_flag = 1 and delete_flag = 0
order by reg_date desc
LIMIT 0,8
단기렌트 가능차량
select car.car_seq,car_nm, photo.photo_upload_nm from car_basic_info as car
left outer join (select car_seq, photo_upload_nm from car_photo where main_flag = 'Y') as photo
on car.car_seq = photo.car_seq
where rent_type = '단기' and use_flag = 1 and delete_flag = 0
order by reg_date desc
LIMIT 0,8
사고대차대량
select car.car_seq,car_nm, photo.photo_upload_nm from car_basic_info as car
left outer join (select car_seq, photo_upload_nm from car_photo where main_flag = 'Y') as photo
on car.car_seq = photo.car_seq
where rent_type = '보험사고' and use_flag = 1 and delete_flag = 0
order by reg_date desc
LIMIT 0,8
