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 Ask Automotive Limited , , India
Namibia Yellow Pages Online
Video Gallery

View More

Our Activities

To be a global market leader in Friction products, Die Casting Products and Safety Control cables through quality and Innovation.


View More

Product Categories

Catalogue

Our Management Team


Manager Manager

View More

Certificates

View More

Location

Year Established

Business Type

Turn over
US$ NA

Employees
NA

Main Markets
India