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, 5 as catId, 'in-salon-treatments' as catSlug, 'In-Salon Treatments' as catTitle 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 find_in_set('5', a.pdt_category) AND b.opt_default=1 GROUP BY a.id ORDER BY a.sort_order ASC, a.title ASC
0 items on list
Explore our products or search for an item you’d like to add.
Our site uses technology that ensures your personal and payment information is kept confidential and secure.
Secure Ordering When you provide us with any personal information including your name, address, e-mail and credit card number, it is processed over a secure connection on secure servers. We use Secure Socket Layers (SSL) to encrypt all information you provide before sending it to our servers. SSL is the industry standard and the best software available for secure ecommerce transactions.