Players' stats

stats.sql

SELECT
	`Division_i18n`.`content` AS `Division__name`,
	`TeamInfo`.`id`,
	`TeamInfo`.`name`,
	`Player`.`id`,
	`PlayerInfo`.`name`,
	`PointsSummary`.`matches`,
	`PointsSummary`.`points`,
	`PunishmentsSummary`.`punishment_type_id`,
	`PunishmentsSummary`.`count`
FROM 
	`divisions` AS `Division`
JOIN `i18n` AS `Division_i18n` 
	ON (`Division_i18n`.`foreign_key` = `Division`.`id` 
        AND `Division_i18n`.`model` = "Division" 
        AND `Division_i18n`.`locale` = "cze")
JOIN `teams` AS `Team`
	ON (`Team`.`division_id` = `Division`.`id`
       AND `Team`.`season_id` = 1)
JOIN `team_infos` AS `TeamInfo`
	ON (`TeamInfo`.`id` = `Team`.`team_info_id`
       AND `Team`.`season_id` = 1)
JOIN `players_teams` AS `PlayersTeam`
	ON (`PlayersTeam`.`team_id` = `Team`.`id`)
JOIN `players` AS `Player`
	ON (`Player`.`id` = `PlayersTeam`.`player_id`)
LEFT JOIN `points_summary` AS `PointsSummary`
	ON (`PointsSummary`.`player_id` = `Player`.`id`
       AND `PointsSummary`.`season_id` = 1)
LEFT JOIN `punishments_summary` AS `PunishmentsSummary`
	ON (`PunishmentsSummary`.`player_id` = `Player`.`id`
       AND `PunishmentsSummary`.`season_id` = 1)
JOIN `player_infos` AS `PlayerInfo`
	ON (`PlayerInfo`.`player_id` = `Player`.`id`
       AND `PlayerInfo`.`season_id` = 1)
WHERE 
	`Division`.`sport_id` = 1 
	AND `Division`.`season_id` = 1