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