Shopping Bag

0 Items

Please add a product to your shopping bag in order to checkout.

Free US Standard Shipping Over $50!

Total $0.00

Excl. Shipping & Taxes

My Promo Codes

Available Promo Codes: 0

No promo codes are available.

Free US Standard Shipping Over $50!

Travel Friendly

SELECT a.*, b.id as opt_id, b.opt_value, b.opt_price, b.opt_price_value, b.opt_discount, b.travel_size, b.value_size, b.best_seller, b.new_arrival, b.featured_img as opt_featured_img, b.opt_stock_qty, c.slug as catSlug FROM lakme_product a, lakme_product_options b, lakme_product_category c WHERE a.status='active' AND b.status='active' AND c.status='active' AND a.id=b.product_id AND FIND_IN_SET(c.id,a.pdt_category) AND c.remove_link<>1 AND b.travel_size=1 GROUP BY a.id ORDER BY a.sort_order ASC, a.title ASC