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 Anjali Overseas , Ajman , United Arab Emirates
Saudi Yellow Pages Online
Video Gallery

View More

Our Activities

We are the Direct Manufacturers of readymade garments From India having our warehouse in Ajman


View More

Product Categories

Catalogue

Our Management Team


Onkar Sharma

View More

Certificates

View More

Location
Ajman

Year Established

Business Type

Turn over
US$ NA

Employees
NA

Main Markets
United Arab Emirates