£ GBP
FREE UK POSTAGE OVER £75
  Request a Call  0207 0434824
 
Diya Logo
 

AW16 SAREE COLLECTION

Be a showstopper and turn heads in our exclusive saree collection, designed in a range of modern styles and rich materials, perfect for any occasion.

 
 Beige
 Black
 Brown
 Blue
 Maroon
 Red
 White
 Green
 Purple
 Pink
 Yellow
 Orange
 Cream
 Gold
 Silver
 Bronze
 STANDARD
Price


 
Error Execute [SELECT MAX(diya_products.ProductID) as ProductID,diya_product_colors.Color,diya_products.ProductName,diya_products.AlternateName,diya_products.Price,diya_products.discPrice,diya_products.OldPrice,diya_products.NewProduct,diya_product_colors.ColorID,diya_products.IsDisplay,diya_products.IsLatest,diya_product_colors.Priority,diya_products.TagPrice,diya_products.CategoryID,diya_products.DescID,diya_products.DescPrice FROM diya_products INNER JOIN diya_product_stock ON diya_products.ProductID=diya_product_stock.ProductID INNER JOIN Lot_Mst_StockDRL ON diya_product_stock.UniqueID=Lot_Mst_StockDRL.lot_code INNER JOIN diya_product_colors ON diya_product_stock.ColorID=diya_product_colors.ColorID INNER JOIN diya_product_size ON diya_product_stock.Size=diya_product_size.SizeID AND diya_products.NewArrival=1 AND diya_products.ProductID IN () AND diya_products.NewProduct IN (1,6) AND Lot_Mst_StockDRL.quantity > 0 AND Lot_Mst_StockDRL.FinYear='20112012' AND Lot_Mst_StockDRL.c_sh='DRL' and diya_products.Price>0 And diya_products.IsActive=1 GROUP BY diya_product_colors.ColorID,diya_products.ProductName,diya_products.AlternateName,diya_products.Price,diya_products.discPrice,diya_products.OldPrice,diya_products.NewProduct,diya_product_colors.Color,diya_products.IsDisplay,diya_products.IsLatest,diya_product_colors.Priority,diya_products.TagPrice,diya_products.CategoryID,diya_products.DescID,diya_products.DescPrice ORDER BY diya_product_colors.Priority]