Parts with mapping

select distinct 
part_urls.part_number,  part_urls.name, 
        part_urls.part_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.mrp
        

        
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


where 

lower(brand) = 'tvs girling'