запрос:
SELECT `type`, COUNT(*) as `count` FROM `footCupUser` WHERE `team_id` = 293 GROUP BY `type` HAVING COUNT(*) > 0;
результат на скрине:
запрос:
SELECT `type`, COUNT(*) as `count` FROM `footCupUser` WHERE `team_id` = 293 GROUP BY `type` HAVING COUNT(*) > 0;
результат на скрине: