select PRODUCT_NAME_INFO.product_info_name as product_info FROM PRICE_VARIANT_VALUES,PRODUCT_NAME_INFO,PRODUCT_MASTER where PRICE_VARIANT_VALUES.variant_id = 1 and PRICE_VARIANT_VALUES.status = 1 and PRODUCT_MASTER.product_id = PRICE_VARIANT_VALUES.product_id and PRICE_VARIANT_VALUES.default_city=1 and PRODUCT_MASTER.product_name = PRODUCT_NAME_INFO.product_info_name and PRODUCT_NAME_INFO.status=1 and PRICE_VARIANT_VALUES.color_id = 0 and PRODUCT_MASTER.category_id in(1) and PRODUCT_MASTER.brand_id in(40) and PRODUCT_MASTER.status=1 and (PRODUCT_MASTER.discontinue_date >= '2015-03-01 00:00:00' OR PRODUCT_MASTER.discontinue_date = '0000-00-00 00:00:00') order by CAST(PRICE_VARIANT_VALUES.variant_value AS UNSIGNED) asc
Mini Cars in India - Explore Mini Cars Models with Price in India | OnCars.in

Mini Cars

Mini
Mini has evolved from being a brilliant hatchback to a lifestyle product and has been introduced in India by their parent company, BMW. Mini is step ahead of its competition VW Beetle and is here with four models for now but they may introduce a couple more in near future.
SHARE

THIS

New Mini Cars in India

Filter by: 
Price  

Advertisement