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 Solvent Dyes from ANAR CHEMICALS LLP in Ahmedabad, India
Promoted by the Choksi family in Ahmedabad in 1980
First Chemical Co. to achieve simultaneous certification under ISO 9001 & 14001 in the Year 2000.
R & D Lab with many concrete achievements to its credit
First-rate manufacturing facilities in the business of specialty chemical intermediates in the colors & related fields
Exports as the thrust area
ISO 18001 & PAS 99 in the Year 2014
