SELECT Count(DISTINCT categoryId) as rowCount FROM product_sub_category C WHERE mainCategoryId = MySql #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 '' at line 1