Select CompanyProdID,producttitle,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl from trncompanyprod_forsearch a left JOIN mstproduct b on a.ProductID=b.ProductId left 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 Intercomsas , , India

Nigeria Yellow Pages Online

	NIGERIA YELLOW PAGES ONLINE
	Global site for local search

Intercomsas

Intercomsas - | E-Showroom

Intercomsas
Kolkata 25, Daikhnee Housing Society Metropoliton Societ
India

Home

Our Products

NONWOVEN MANUFACTURING EQUIPMENT

Video Gallery

Our Activities

We constantly innovate with a clear focus on performance, efficiency, compliances, and sustainability - something that has made us the most preferred partner for our 850+ customers & counting.

Product Categories

NONWOVEN MANUFACTURING EQUIPMENT |

Catalogue

Our Management Team