select c.id as carid,cc.car_name as car_name, z.city as city, z.region as region ,
z.address_1 as address, z.address_2 as address_2,z.alias as address_3,z.name as zone_name
from cars c
left join car_classes cc on cc.id = c.car_class_id
left join zones z on z.id = c.zone_id
where c.state = 'normal'
and z.state = 'normal'
and cc.car_name in ('AXIA','Iriz','Picanto','BEZZA','MYVI')
and z.city in ('KL','SL');


select c.id as carid,cc.car_name as car_name, z.city as city, z.region as region ,
z.address_1 as address, z.address_2 as address_2,z.alias as address_3,z.name as zone_name
from cars c
left join car_classes cc on cc.id = c.car_class_id
left join zones z on z.id = c.zone_id
where c.state = 'normal'
and z.state = 'normal'
and cc.car_name in ('AXIA','Iriz','Picanto')
and z.city in ('KL','SL');