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 Privilege Llc , Sharjah , United Arab Emirates
Mali Yellow Pages Online
Video Gallery

View More

Our Activities

PSI Products Linkseal, casing spacers & end seals


View More

Product Categories

Catalogue

Our Management Team


Ahmed Ahmed

View More

Certificates

View More

Location
Sharjah

Year Established

Business Type

Turn over
US$ NA

Employees
NA

Main Markets
United Arab Emirates