SELECT distinct(products.idProduct), products.sku, products.description, products.price, products.listhidden, products.listprice, products.serviceSpec, products.bToBPrice, products.imageUrl,products.noprices,products.stock, products.noStock,products.pcprod_HideBTOPrice, 0 as POrder,products.FormQuantity,products.pcProd_BackOrder,brands.IH_showprice,brands.IH_callOrder,brands.callOrderPrice,products.idbrand,disc.discountDesc, CAST(products.sdesc AS NVARCHAR(MAX)) as sdesc ,products.pcProd_BTODefaultWPrice, products.pcProd_BTODefaultPrice, CASE WHEN showOrder.POrder = 0 THEN 999 WHEN showOrder.POrder is null THEN 999 ELSE showOrder.POrder END as PshowOrder,prodName,brandName,largeImageURL FROM products left join brands on products.idbrand = brands.idbrand left join (select idproduct,pOrder from categories_products where idcategory = 5215)as showOrder on showOrder.idproduct = products.idproduct left join discountsperquantity as disc on disc.idDiscountperquantity = (Select top 1 idDiscountperquantity from discountsperquantity where discountsperquantity.idproduct = products.idproduct and discountPerUnit<>0), categories_products WHERE products.idProduct=categories_products.idProduct AND categories_products.idCategory in(5215) AND active=-1 AND configOnly=0 and removed=0 ORDER BY products.description Asc

• 
  Arcona Dry Skin Starter Kit, 1 set Arcona Dry Skin Starter Kit, 1 set
  $87.00

  

• 
  Biodroga Age Performance Formula Day Care for Dry and Mature Skin, 50ml/1.7 fl oz Biodroga Age Performance Formula Day Care for Dry and Mature Skin, 50ml/1.7 fl oz
  $103.00

  

• 
  Biodroga Golden Caviar 24 Hour Care - Dry Skin, 50ml/1.7 fl oz Biodroga Golden Caviar 24 Hour Care - Dry Skin, 50ml/1.7 fl oz
  $88.00

  

• 
  Bioelements Starter Kit for Very Dry, Dry Skin, 1 set Bioelements Starter Kit for Very Dry, Dry Skin, 1 set
  $99.00

  

• 
  Consonant Ultra Moisturizing Organic Face Cream for Dry Skin, 50ml/1.7 fl oz Consonant Ultra Moisturizing Organic Face Cream for Dry Skin, 50ml/1.7 fl oz
  $42.00

  

• 
  Darphin Predermine Densifying Anti-Wrinkle Cream - Dry Skin, 50ml/1.7 fl oz Darphin Predermine Densifying Anti-Wrinkle Cream - Dry Skin, 50ml/1.7 fl oz
  $158.00

  

• 
  Darphin Stimulskin Plus Multi-Corrective Divine Cream Rich - Dry to Very Dry Skin, 50ml/1.7 fl oz Darphin Stimulskin Plus Multi-Corrective Divine Cream Rich - Dry to Very Dry Skin, 50ml/1.7 fl oz
  $308.00

  

• 
  Jan Marini Skin Care Management System (Starter Kit) - Dry/Very Dry, 1 sets Jan Marini Skin Care Management System (Starter Kit) - Dry/Very Dry, 1 sets
  $308.00

  

• 
  Jan Marini Skin Care Management Systems - Dry to Very Dry, 1 sets Jan Marini Skin Care Management Systems - Dry to Very Dry, 1 sets
  $308.00

  

• 
  Juvena Delining Day Cream - Normal to Dry Skin, 50ml/1.7 fl oz Juvena Delining Day Cream - Normal to Dry Skin, 50ml/1.7 fl oz
  $89.00

  

• 
  Juvena Skin Energy Moisture Rich Cream - Dry Skin, 50ml/1.7 fl oz Juvena Skin Energy Moisture Rich Cream - Dry Skin, 50ml/1.7 fl oz
  $63.00

  

• 
  Odacite Very Dry Skin Booster - Mo + P: Moringa Petitgrain, 5ml/0.17 fl oz Odacite Very Dry Skin Booster - Mo + P: Moringa Petitgrain, 5ml/0.17 fl oz
  $46.00

  

• 
  Vi Derm Complete Care for Normal to Dry Skin, 50ml/1.75 fl oz Vi Derm Complete Care for Normal to Dry Skin, 50ml/1.75 fl oz
  $90.00

  

• 
  Yonka Lotion Yon-ka - Invigorating Mist (Dry skin), 200ml/6.7 fl oz Yonka Lotion Yon-ka - Invigorating Mist (Dry skin), 200ml/6.7 fl oz
  $42.00

  

• 
  Yonka Pamplemousse (Grapefruit) - Dry Skin, 50ml/1.7 fl oz Yonka Pamplemousse (Grapefruit) - Dry Skin, 50ml/1.7 fl oz
  $60.00

  

• 
  Yonka Phyto 58 PS - Dry Skin, 40ml/1.35 fl oz Yonka Phyto 58 PS - Dry Skin, 40ml/1.35 fl oz
  $68.00