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 Generator Suppliers from AL WAHA TENTS TRAD. in Dammam, SAUDI ARABIA
Al waha tents are a full service rental supplier for weddings, special events, personal parties, functions, business conferences, graduations, and much more.We offer on time pick-up and delivery to anywhere in Eastern Province of Saudi Arabia. We happily provide a wide variety of tent installation options, different table sizes, guest seating, walk way, staging, and catering accessories.
