
NUMAX STEELS - | E-Showroom
Select CompanyProdID,producttitle,productdesc,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl,a.companyid from trncompanyprod_forsearch a inner JOIN mstproduct b on a.ProductID=b.ProductId inner join mstmaingroup c on b.maingroupid=c.maingroupid where a.CompanyID= ? and a.isproductapproved=1 ORDER by ProductOrderNo=0, ProductOrderNo ASC,productimagefilepath desc, a.productlastmodifieddate desc,companyprodid desc limit 0, 3000
NUMAX STEELS - | E-Showroom
Range | 5 mm to 200 & length 100 mm to 3000 mm |
Standard | 2205, 2304, 2507 & LDX 2101 |
Forms | Round; square; rectangle, wire (coil form), wire mesh,; hex (A/F); billet; ingot; forging |