INVALID SQL: 0 : SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stoutdr/public_html/cart/include/func.php on line 103
Skin Care Products :: Luxury Skin Shop
Do you suffer from dry skin spots that never go away? Then DERMUD is for you. DERMUD is an intensive nourishing body cream for dry skin. Clinical trials show an improvement in the moisture level of the skin of up to 83%!
Great for oily/acne prone skin, the Blueberry Scrub Mask is effective as an anti-aging and revitalizing treatment. Blueberries are one of nature's most powerful anti-oxidants, very potent, and blue Cornmeal will aid in exfoliation, removing dead skin cells while polishing the skin.
Enjoy the ancient benefits of 100% pure Emu oil with Dremu Oil. The world's most effective skin moisturizer for dry skin, it absorbs immediately and plumps up fine lines, soothes roughness, rehydrates, and heals all skin types and conditions.
Kinara's Lactic Acid Hydrating Serum is a light, penetrating essence with a wide spectrum of anti-aging and nourishing benefits. Utilizing a combination of lactic and glycolic acids, Kinara Lactic Acid Hydrating Serum provides benefits to acne-prone, oily, normal and dry skin.
LuxurySkinShop appreciates your business, but we will be off-line until further notice as we upgrade our inventory tracking system. Any order that has been submitted up to this date will be honored and fufilled. If there is a stock delay, then you will be notified and will receive a full refund with our apology and gift. We apologize for this inconvenience, and we shall return better, faster, and well stocked.
Do you suffer from dry skin spots that never go away? Then DERMUD is for you. DERMUD is an intensive nourishing body cream for dry skin. Clinical trials show an improvement in the moisture level of the skin of up to 83%!
Great for oily/acne prone skin, the Blueberry Scrub Mask is effective as an anti-aging and revitalizing treatment. Blueberries are one of nature's most powerful anti-oxidants, very potent, and blue Cornmeal will aid in exfoliation, removing dead skin cells while polishing the skin.
Enjoy the ancient benefits of 100% pure Emu oil with Dremu Oil. The world's most effective skin moisturizer for dry skin, it absorbs immediately and plumps up fine lines, soothes roughness, rehydrates, and heals all skin types and conditions.
Kinara's Lactic Acid Hydrating Serum is a light, penetrating essence with a wide spectrum of anti-aging and nourishing benefits. Utilizing a combination of lactic and glycolic acids, Kinara Lactic Acid Hydrating Serum provides benefits to acne-prone, oily, normal and dry skin.