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 Sterile Latex Examination Gloves from BHAGWATI PHARMA SURGICALS in Vadodara , India
Headquartered in Vadodara, Gujarat, India, Bhagwati Pharma Surgicals was established in the year 2014. The company has witnessed great success in such a short span of time. With certified, reliable and qualitative Medical Products, we have successfully positioned ourselves amid the high-flying names in the industry.
