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

WOVEN ESSENTIALS

Wrap yourself up in this versatile collection of suits complemented with stylish woven scarves.

 
 Beige
 Black
 Brown
 Blue
 Maroon
 Red
 White
 Green
 Purple
 Pink
 Yellow
 Orange
 Cream
 Gold
 Silver
 Bronze
 XS
 S
 M
 L
 XL
 XXL
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]