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 Furniture Manufacturers from classico trading and upholstery in Manama, BAHRAIN
classico trading and upholstery
we make and repair all kinds of sofa, chair, curtains, window blinds, arabic setting, sun shades, carpet, car seat and all kinds of upholstery and decor.
our service is best service with finishing work and quality and time.
i hope if you give a chance to work you will be happy with finishing work,quality of material, and price.
contact:
mohammed sakeeb
37328908.
mohammedsakeeb7@gmail.com
