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 Hoses & Belting Suppliers from Oilfield Euipment Wholesalers & Suppliers Dubai in Dubai, United Arab Emirates
We are API,ISO Certified Manufacturer & Supplier of
♦Hammer Unions ♦ Ring Joint Gaskets ♦ BOP Control Units ♦ Hydraulic Tongs ♦ Swivel Joints ♦ Choke & Kill Manifolds ♦ Cement & Stand pipe Manifolds ♦ High Pressure Test Units ♦ API Flanges ♦ Tees & Crosses ♦ Pup Joints & Crossovers ♦ Steel Hose Assemblies ♦ Ball Valve ♦ Gate Valve ♦ Globe Valve ♦ Butterfly Valve ♦ Check Valve as per API specification API 6A, API 6D, API 16A, API 16C, API 16D, API 598.
