select Brand, year, a.modelType, j.carType as carType, year,
transmission, cylinderCapacity, replace(replace(priceRange,'.',''),'Rp','') as priceRange, carTypeID
from tableRajaMobil2 a
join (
	select carTypeID,carType, c.modelType from CarType b
	JOIN modeltype  c on b.modelTypeID = c.modeltypeID
	where b.carType <> 'default'
)as j
where  a.carType like concat(j.carType, '%')
and a.modelType like concat(j.modeltype, '%');