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

CONTEMPORARY EDIT

Find your favourites in our range of adorned suits designed with dense thread, bead, stone & button detail.

 
 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]