MySQL Error Occured
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pyrettas_pyrettaslair.CubeCart_cats_idx.cat_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

QUERY = SELECT CubeCart_cats_idx.cat_id, CubeCart_cats_idx.productId, productCode, quantity, description, image, price, their_price, name, popularity, sale_price, stock_level, useStockLevel FROM CubeCart_cats_idx INNER JOIN CubeCart_inventory ON CubeCart_cats_idx.productId = CubeCart_inventory.productId WHERE sale_price > 0 GROUP BY CubeCart_inventory.productId ORDER by CubeCart_inventory.productId DESC