SELECT TOP 4 * FROM (SELECT top 50 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, 0 as PshowOrder,prodName,brandName,largeImageURL FROM products left join brands on products.idbrand = brands.idbrand left join discountsperquantity as disc on disc.idDiscountperquantity = (Select top 1 idDiscountperquantity from discountsperquantity where discountsperquantity.idproduct = products.idproduct) WHERE active=-1 AND configOnly=0 and removed=0 order by sales desc) AS topProds ORDER BY NEWID()

• 
  Yonka Gel Nettoyant (Cleansing Gel), 200ml/6.8 fl oz Yonka Gel Nettoyant (Cleansing Gel), 200ml/6.8 fl oz
  $40.00

  

• 
  SkinCeuticals Hydrating B5 Gel, 30 ml/1 fl oz SkinCeuticals Hydrating B5 Gel, 30 ml/1 fl oz
  $82.00

  

• 
  Yonka Phyto-Contour Eye and Lip, 15ml/0.5 fl oz Yonka Phyto-Contour Eye and Lip, 15ml/0.5 fl oz
  $58.00

  

• 
  Vi Derm Cleanser for All Skin Types, 240ml/8 fl oz Vi Derm Cleanser for All Skin Types, 240ml/8 fl oz
  $40.00