MySQL Error Occured
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM cc_CubeCart_cats_idx INNER JOIN cc_CubeCart_inventory ON cc_CubeCart_cats_i' at line 1

QUERY = SELECT cc_CubeCart_cats_idx.cat_id, cc_CubeCart_cats_idx.productId, productCode, quantity, description, image, price, name, popularity, sale_price, stock_level, useStockLevel, corner_ribbon, corner_ribbon_default, corner_ribbon_text, border, FROM cc_CubeCart_cats_idx INNER JOIN cc_CubeCart_inventory ON cc_CubeCart_cats_idx.productId = cc_CubeCart_inventory.productId WHERE hidden=0 AND sale_price > 0 GROUP BY cc_CubeCart_inventory.productId