KLOVE | Extra 5% off on all Kbeauty orders above ₹999
SUMVIBE10 | Extra 10% off on orders on orders ₹1,999+
SUNKISS5 | Extra 5% off on orders ₹999+
SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (37079)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc

SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (37079)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (37079)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (37079)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (37079)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (37079)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (37079)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
SELECT products.product_id, descr1.product as product, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' WHERE 1 AND prices.usergroup_id IN (0) AND ((1 AND products.product_id IN (37079)) AND prices.usergroup_id IN (0)) GROUP BY products.product_id ORDER BY NULL asc
Delivery
- Use SUMVIBE10 & Get Flat 10% off on orders above Rs. 1999.
- Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999.
Details
La Pink Young Forever White Haldi Day Cream is a 100% microplastic-free formulation designed to reduce fine lines, enhance skin radiance, and protect against UV rays. This day cream for dry skin harnesses the power of naturally derived biopeptides from cranberries and glycoproteins from soybeans, which effectively slow down the skin aging process. Its primary goal is to diminish fine lines and wrinkles, resulting in younger-looking, brighter, softer, and more supple skin. With its unique blend, this day cream with spf 15 protection to shield the skin from harmful sun damage while further enhancing its natural radiance. It combats issues like tan, blemishes, and dark spots, promoting an even skin tone. The formula includes natural ingredients like cranberry, bakuchi, and mulethi extract, providing deep cleansing, skin tightening benefits, and UV protection. The gel creme formula is fast-absorbing, non-greasy, and nourishes the skin, leaving it looking youthful and rejuvenated. La Pink Young Forever White Haldi Day Cream is an innovative skincare solution that effectively targets signs of aging while revitalizing and protecting the skin.








Features
- Butylene Glycol
- Glycerin
- Aqua
- Aqua, Butylene Glycol, Glycerin, Water & Ethylhexyl Methoxycinnamate & Butyl Methoxydibenzoylmethane & Benzophenone-3 & Phospholipids & 1,3- Butylene Glycol, Dicaprylyl carbonate, Hydroxypropyl...Read more
Additional Information
Dimensions
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND ?:product_required_products.product_id = 37079 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
How to use
Related to watch
Reviews
No reviews found
kindcode