MySQL query error: file - , line -

SELECT a.categoryID, a.name, count(*) as num FROM lito_shop_category a, lito_shop_products b, lito_shop_products c WHERE a.categoryID=b.category2ID AND b.productID=c.productID # AND b.enable = '1' GROUP BY c.category2ID ORDER BY a.categoryID

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'litofito_ru.a.categoryID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by