MySQL Error Occurred

Error Message:
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 '.show_to_anonymous FROM CubeCart_cats_idx AS C INNER JOIN CubeCart_inventory AS ' at line 1

SQL:
SELECT DISTINCT(I.productId), C.cat_id, I.image, I.price, I.name, I.length, I.no_pics, I.sale_price, I.volume, I.show_to_models, I.show_in_spain I.show_to_anonymous FROM CubeCart_cats_idx AS C INNER JOIN CubeCart_inventory AS I ON C.productId = I.productId WHERE I.disabled = '0' AND C.cat_id > 0 AND C.cat_id = '11' GROUP BY I.productId ORDER BY `date_added` DESC, `name` ASC