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) = 'lumax'