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 Mirrors from ALL GLASS MOTORGLASS , South Africa
ALL GLASS is the leading glass merchant in the Western Cape. We offer our customers a wide range of glass products from all types of Glass Decorative Obscure Glass , Safety GlassArmour Plated Glass, Mirrors , ShopfrontsGlass Table Tops, Metal & Aluminium Windows as well as wide range of Frameless Shower Doors .
