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

MENS

Our cool collection of men's Kurtas for whatever the occasion.
Exclusive Kurtas brought to you by DIYA.

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