No record foundSELECT products.productImg, First(products.ProdDisable) as ProdDisable , First(products.productID) AS productID, First(products.productName) AS productName, First(products.productPrice) AS productPrice, First(products.ProductCode) AS ProductCode FROM products WHERE products.ProdDisable<>'d' and catalogID = '10'GROUP BY products.productImg order by First(products.productID) !

Version: SW 6.0p2       DB Shop 3.6p8 (23/05/2019)  CCP   Visitatori: 4232876       WebMaster              3335 on-line