In Bengaluru, Chennai, Delhi NCR, Hyderabad, Mumbai and Pune
Hyundai Xcent battery Price
The price of battery available for your Hyundai Xcent ranges from ₹4,299 to ₹6,799. Get Hyundai Xcent battery Changed At Home - CONVENIENCE at your DOORSTEP.
Hyundai Xcent battery price list
List of Hyundai Xcent battery
Price (Updated on 14-Nov-2025)
SF Car Battery F4W5-72S-35L (35Ah)
₹4,299
ELITO AET-RR 040B20LBH (40Ah) Car battery
₹4,399
SF Batteries F4W5-66S-40LBH (40Ah)
₹4,649
Amaron Flo 40Ah AAM-FL-0BH40B20L car battery
₹4,749
EXIDE EPIQ FEPO-EPIQ35L (35Ah)
₹4,999
EXIDE EPIQ FEPO-EPIQ35R (35Ah)
₹5,049
Let’s get started
Please login/register to proceed
OTP Verification
Don't drive away just yet,while we are fetching your address!
Let’s get started
Please login/register to proceed
We are here to help
Enter your contact details and we are happy to assist.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, IFNULL(top_brand_option_value_t2.option_id, top_brand_option_value_t1.option_id) AS `top_brand`, IFNULL(top_brand_option_value_t2.value, top_brand_option_value_t1.value) AS `top_brand_value`, IFNULL(top_brand_option_t1.sort_order, 0) AS `top_brand_order` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store4` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=4 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=3891
INNER JOIN `catalog_product_index_price_store` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
INNER JOIN `temp_ecaefe2510b54527a1d5fe82ff724d4e759b1d85` AS `search_result` ON `e`.`entity_id` = `search_result`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `top_brand_t1` ON e.row_id=top_brand_t1.row_id AND top_brand_t1.attribute_id='522' AND top_brand_t1.store_id=0
LEFT JOIN `catalog_product_entity_int` AS `top_brand_t2` ON e.row_id=top_brand_t2.row_id AND top_brand_t2.attribute_id='522' AND top_brand_t2.store_id='4'
LEFT JOIN `eav_attribute_option_value` AS `top_brand_option_value_t1` ON top_brand_option_value_t1.option_id=IF(top_brand_t2.value_id > 0, top_brand_t2.value, top_brand_t1.value) AND top_brand_option_value_t1.store_id=0
LEFT JOIN `eav_attribute_option_value` AS `top_brand_option_value_t2` ON top_brand_option_value_t2.option_id=IF(top_brand_t2.value_id > 0, top_brand_t2.value, top_brand_t1.value) AND top_brand_option_value_t2.store_id=4
LEFT JOIN `eav_attribute_option` AS `top_brand_option_t1` ON top_brand_option_t1.option_id=IF(top_brand_t2.value_id > 0, top_brand_t2.value, top_brand_t1.value) WHERE ((price_index.store_id = 4) AND (price_index.store_id = 4) AND (price_index.store_id = 4) AND (stock_status_index.stock_status = 1) AND (price_index.store_id = 4)) AND (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY `top_brand_order` ASC, `e`.`entity_id` DESC, `e`.`entity_id` ASC
LIMIT 20
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
*Offer valid only for cities other than Bangaluru, Chennai, Delhi-NCR, Mumbai, Pune, Hyderabad
OFFERS
CART VALUE DISCOUNT ON CAR TYRES
TyresNmore loves to give you more!
Buy Tyres, Batteries or Alloys and avail discounts as below
Coupon Codes
Cart Value Rs.
Discount on cart value
Max discount
CV15000
15000 to 29999
0.75%
Rs. 225
CV30000
30000 to 49999
1%
Rs. 500
CV50000
50000 & above
1.5%
Rs. 4000
Additional discount :- Get 1% discount by placing your order and paying online now - No code required
OFFERS
ONLINE PAYMENT DISCOUNT
Pay online and get an additional 1% Discount on your order.
*Subject to a successful online payment on www.tyresnmore.com online payment partners.
OFFERS
FREE WHEEL BALANCING
We love to give you More!
With every car tyre that you buy you get wheel balancing worth Rs.150 free.
You Save upto Rs.200 on purchase of 4 car tyres.
TYRE EXCHANGE FESTIVAL!!!
On Buying 4 or More Car Tyres :
Rs 200 off per order
On Buying 1/2/3 Car Tyres :
Rs 50 off per car tyre
All you need to do is to provide the same quantity of old tyres of the same size in exchange of the new tyres that you are buying when our team comes to fit the new tyres on your vehicle.
OFFERS
BONANZA OFFER ON 17 INCH+ TYRES!
Applicable on
Code
Offer
All tyres of wheel size 17 inch & above
TNM4000
2% off upto Rs. 4000 off per order
*T&C apply. Offer valid on 17 inch+ tyres of all brands. Use the above coupon code while placing order. This offer is on per order basis and not on per tyre basis. Tyresnmore Online Pvt. Ltd. reserves the right to withdraw or amend the above offers at any time prior to installation of tyres as per the orders placed by website users.
Extra 3% Discount upto Rs.10,000*
60 Months Warranty
Same Day Fitment
Â
Four Wheeler Tyres
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Buy Tyres, Batteries or Alloys and avail discounts as below
Coupon Codes
Cart Value Rs.
Discount on cart value
Max discount
CV15000
15000 to 29999
0.75%
Rs. 225
CV30000
30000 to 49999
1%
Rs. 500
CV50000
50000 & above
1.5%
Rs. 4000
Additional discount :- Get 1% discount by placing your order and paying online now - No code required
OFFERS
ONLINE PAYMENT DISCOUNT
Pay online and get an additional 1% Discount on your order.
*Subject to a successful online payment on www.tyresnmore.com online payment partners.
OFFERS
FREE WHEEL BALANCING
We love to give you More!
With every car tyre that you buy you get wheel balancing worth Rs.150 free.
You Save upto Rs.400 on purchase of 4 car tyres.
TYRE EXCHANGE FESTIVAL!!!
On Buying 4 or More Car Tyres :
Rs 400 off per order
On Buying 1/2/3 Car Tyres :
Rs 50 off per car tyre
All you need to do is to provide the same quantity of old tyres of the same size in exchange of the new tyres that you are buying when our team comes to fit the new tyres on your vehicle.
OFFERS
BONANZA OFFER ON 17 INCH+ TYRES!
Applicable on
Code
Offer
All tyres of wheel size 17 inch & above
TNM4000
2% off upto Rs. 4000 off per order
*T&C apply. Offer valid on 17 inch+ tyres of all brands. Use the above coupon code while placing order. This offer is on per order basis and not on per tyre basis. Tyresnmore Online Pvt. Ltd. reserves the right to withdraw or amend the above offers at any time prior to installation of tyres as per the orders placed by website users.
Extra 3% Discount upto Rs.10,000*
60 Months Warranty
Same Day Fitment
Â
Four Wheeler Tyres
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
Doorstep fitment, wheel balancing and weights are available on purchase of four wheeler tyres ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In Other Cities we provide ONLY Home Delivery of four wheeler tyres. No doorstep fitment available in Other Cities
Â
Two Wheeler Tyres
Wheel balancing and weights are not applicable on purchase of two wheeler tyres.
Doorstep fitment is available only in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide only Home Delivery of two wheeler tyres.
Â
Alloy wheels
Doorstep fitment, available on purchase of Alloy wheels ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we provide ONLY Home Delivery of Alloy wheels.
Battery
Doorstep fitment, available on purchase of batteries ONLY in Bangalore, Chennai, Delhi NCR, Hyderabad, Secunderabad, Mumbai, Pune.
In other cities we DO NOT provide batteries.
Â
Accessories
Elevate your car or bike with premium accessories, precision engineered, made of durable materials to enhance your vehicle aesthetics.
We deliver bike and car accessories at your doorstep throughout India.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, IFNULL(top_brand_option_value_t2.option_id, top_brand_option_value_t1.option_id) AS `top_brand`, IFNULL(top_brand_option_value_t2.value, top_brand_option_value_t1.value) AS `top_brand_value`, IFNULL(top_brand_option_t1.sort_order, 0) AS `top_brand_order` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store4` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=4 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=3891
INNER JOIN `catalog_product_index_price_store` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 4 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
INNER JOIN `temp_ecaefe2510b54527a1d5fe82ff724d4e759b1d85` AS `search_result` ON `e`.`entity_id` = `search_result`.`entity_id`
LEFT JOIN `catalog_product_entity_int` AS `top_brand_t1` ON e.row_id=top_brand_t1.row_id AND top_brand_t1.attribute_id='522' AND top_brand_t1.store_id=0
LEFT JOIN `catalog_product_entity_int` AS `top_brand_t2` ON e.row_id=top_brand_t2.row_id AND top_brand_t2.attribute_id='522' AND top_brand_t2.store_id='4'
LEFT JOIN `eav_attribute_option_value` AS `top_brand_option_value_t1` ON top_brand_option_value_t1.option_id=IF(top_brand_t2.value_id > 0, top_brand_t2.value, top_brand_t1.value) AND top_brand_option_value_t1.store_id=0
LEFT JOIN `eav_attribute_option_value` AS `top_brand_option_value_t2` ON top_brand_option_value_t2.option_id=IF(top_brand_t2.value_id > 0, top_brand_t2.value, top_brand_t1.value) AND top_brand_option_value_t2.store_id=4
LEFT JOIN `eav_attribute_option` AS `top_brand_option_t1` ON top_brand_option_t1.option_id=IF(top_brand_t2.value_id > 0, top_brand_t2.value, top_brand_t1.value) WHERE ((price_index.store_id = 4) AND (price_index.store_id = 4) AND (price_index.store_id = 4) AND (stock_status_index.stock_status = 1) AND (price_index.store_id = 4)) AND (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY `top_brand_order` ASC, `e`.`entity_id` DESC, `e`.`entity_id` ASC
LIMIT 20
Select Model
