Spieleransicht / Saisonspiele

SELECT m.id AS mid, tp.id AS tpid, sum(IF(md.came_in=0,1,0)) AS started, sum(IF(md.teamplayer_id IN ('14') AND md.came_in=1,1,0)) AS sub_in, sum(IF((md.teamplayer_id IN ('14') AND md.out=1) OR (md.in_for IN ('14')),1,0)) AS sub_out, tp.projectteam_id FROM jom_joomleague_match_player AS md LEFT JOIN jom_joomleague_team_player AS tp_in ON tp_in.id = md.in_for INNER JOIN jom_joomleague_match AS m ON m.id = md.match_id INNER JOIN jom_joomleague_team_player AS tp ON tp.id = md.teamplayer_id INNER JOIN jom_joomleague_project_team AS pt ON pt.id=tp.projectteam_id INNER JOIN jom_joomleague_project AS p ON p.id=pt.project_id WHERE tp.id IN ('14') OR tp_in.id IN ('14') AND (md.came_in = 0 || md.came_in = 1) AND (md.teamplayer_id IN ('14') OR md.in_for IN ('14')) GROUP BY m.id