Part and Mappings

select  part_urls.id        ,    part_urls.part_number,  
        part_urls.part_name ,    part_urls.name, 
        part_urls.brand     ,    part_urls.origin, 
        part_urls.category  ,    part_urls.sub_category_1, part_urls.sub_category_2, 
        part_urls.family    ,    part_urls.features,
        part_urls.hsn_code  ,    part_urls.gst_percentage , 
        part_urls.price     ,    part_urls.mrp, 
        part_urls.current_price ,part_urls.part_url,
        car_makes.name      ,    car_models.name,        
        car_variants.id, 
        car_variants.name,  car_variants.from_month, car_variants.from_year,
        car_variants.to_month, car_variants.to_year,
        car_fuels.name,     car_engines.code
        
from part_urls 
inner join part_variants    on part_urls.id = part_variants.part_id 
inner join car_variants     on car_variants.id = part_variants.variant_id
inner join car_models       on car_models.id   = car_variants.model_id
inner join car_makes        on car_makes.id = car_models.make_id
inner join car_fuels        on car_fuels.id = car_variants.fuel_id
inner join car_engines      on car_engines.id  = car_variants.engine_id

where 

lower(brand) = 'lumax'