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.opt_default=1 GROUP BY a.id ORDER BY a.sort_order ASC, a.title ASC
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.