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 Beauty Products And Supplies from Spa World General Trading in Abu Dhabi, United Arab Emirates
SPA World is one of the leading supplier of top quality, sustainable spa & salon products in UAE.
Our wide range of products include Massage supplies, Hotel spa supplies, Salon Equipment, Beauty Supplies, and much more to suit your requirements.
We deliver products all around the middle east and neighboring countries.
