Маноха Константин #2119

SELECT tournament.id , tournament.name , tournament.hash , game_result_composition.player_id , game_result_composition.team_id , COUNT(game.id) AS game_count , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((game_result_score.player_id = game_result_composition.player_id) OR (assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_point , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND game_result_score.player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_goal , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_assistent , (SELECT SUM(minute) FROM game_result_penalty JOIN game ON game.id = game_result_penalty.game_id AND game.publish_results = 1 WHERE game_result_penalty.team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_penalty ,( SELECT SUM(game_result_plus_minus.point) FROM game_result_plus_minus JOIN game ON game.id = game_result_plus_minus.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_plus_minus , (SELECT SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_shoots , (SELECT SUM(goals_missed) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_goals_missed , (SELECT SUM(reflected_shoots) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_reflected_shoots , (SELECT SUM(reflected_shoots) / (SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3)) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_percent , player_request.player_position_id , championship.name AS championship_name FROM game_result_composition JOIN game ON game.id = game_result_composition.game_id AND game.publish_results = 1 JOIN player_request ON player_request.id = game_result_composition.player_request_id JOIN tournament ON tournament.id = game.tournament_id JOIN championship ON championship.id = tournament.championship_id JOIN game_series ON game_series.id = game.game_series_id WHERE game_result_composition.player_id = '2119' AND tournament.season_id = '10' GROUP BY tournament.id ORDER BY tournament.id DESC

Сезон 2025-2026	М	Б	Ш	%	ШТ
5-й дивизион	1	20 ср.20	2 ср.2	90%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Ржавый якорь - Легион	21 октября 2025	20	2	90%	0
Осенний Кубок Выборга	4	79 ср.19.8	13 ср.3.3	83.54%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Викинги - Вымпел	11 октября 2025	14	3	78.57%	0
Вымпел - Легион	11 октября 2025	24	5	79.17%	0
Отрадное - Вымпел	12 октября 2025	21	3	85.71%	0
Вымпел - Пента	12 октября 2025	20	2	90%	0

SELECT tournament.id , tournament.name , tournament.hash , game_result_composition.player_id , game_result_composition.team_id , COUNT(game.id) AS game_count , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((game_result_score.player_id = game_result_composition.player_id) OR (assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_point , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND game_result_score.player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_goal , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_assistent , (SELECT SUM(minute) FROM game_result_penalty JOIN game ON game.id = game_result_penalty.game_id AND game.publish_results = 1 WHERE game_result_penalty.team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_penalty ,( SELECT SUM(game_result_plus_minus.point) FROM game_result_plus_minus JOIN game ON game.id = game_result_plus_minus.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_plus_minus , (SELECT SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_shoots , (SELECT SUM(goals_missed) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_goals_missed , (SELECT SUM(reflected_shoots) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_reflected_shoots , (SELECT SUM(reflected_shoots) / (SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3)) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_percent , player_request.player_position_id , championship.name AS championship_name FROM game_result_composition JOIN game ON game.id = game_result_composition.game_id AND game.publish_results = 1 JOIN player_request ON player_request.id = game_result_composition.player_request_id JOIN tournament ON tournament.id = game.tournament_id JOIN championship ON championship.id = tournament.championship_id JOIN game_series ON game_series.id = game.game_series_id WHERE game_result_composition.player_id = '2119' AND tournament.season_id = '9' GROUP BY tournament.id ORDER BY tournament.id DESC

Сезон 2024-2025	М	Б	Ш	%	ШТ
Кубок Великого Новгорода	4	107 ср.26.8	7 ср.1.8	93.46%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
North Stars - Сборная РХЛ Санкт-Петербург	01 февраля 2025	22	2	90.91%	0
Т-34 - Сборная РХЛ Санкт-Петербург	01 февраля 2025	23	0	100%	0
Сборная РХЛ Санкт-Петербург - Викинги	02 февраля 2025	35	5	85.71%	0
ЦМКБ Алмаз - Сборная РХЛ Санкт-Петербург	02 февраля 2025	27	0	100%	0
Финальный этап, Малый кубок	1	19 ср.19	3 ср.3	84.21%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Сборная РХЛ Санкт-Петербург - Легион	29 сентября 2024	19	3	84.21%	0
Предварительный этап, Группа А	2	42 ср.21	7 ср.3.5	83.33%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Рать - Сборная РХЛ Санкт-Петербург	28 сентября 2024	25	5	80%	0
Сборная РХЛ Санкт-Петербург - Отрадное	28 сентября 2024	17	2	88.24%	0
4-й Дивизион	1	17 ср.17	4 ср.4	76.47%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Атомэнергопроект - Штерн	06 февраля 2025	17	4	76.47%	0
Матч в честь 10-ти летия ХК «Легион»	1	29 ср.29	5 ср.5	82.76%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Легион - Легион 2023	05 августа 2024	29	5	82.76%	0

SELECT tournament.id , tournament.name , tournament.hash , game_result_composition.player_id , game_result_composition.team_id , COUNT(game.id) AS game_count , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((game_result_score.player_id = game_result_composition.player_id) OR (assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_point , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND game_result_score.player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_goal , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_assistent , (SELECT SUM(minute) FROM game_result_penalty JOIN game ON game.id = game_result_penalty.game_id AND game.publish_results = 1 WHERE game_result_penalty.team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_penalty ,( SELECT SUM(game_result_plus_minus.point) FROM game_result_plus_minus JOIN game ON game.id = game_result_plus_minus.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_plus_minus , (SELECT SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_shoots , (SELECT SUM(goals_missed) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_goals_missed , (SELECT SUM(reflected_shoots) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_reflected_shoots , (SELECT SUM(reflected_shoots) / (SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3)) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_percent , player_request.player_position_id , championship.name AS championship_name FROM game_result_composition JOIN game ON game.id = game_result_composition.game_id AND game.publish_results = 1 JOIN player_request ON player_request.id = game_result_composition.player_request_id JOIN tournament ON tournament.id = game.tournament_id JOIN championship ON championship.id = tournament.championship_id JOIN game_series ON game_series.id = game.game_series_id WHERE game_result_composition.player_id = '2119' AND tournament.season_id = '8' GROUP BY tournament.id ORDER BY tournament.id DESC

Сезон 2023-2024	М	Б	Ш	%	ШТ
MadGuyHockey Cup. Группа В (6-й дивизион)	3	73 ср.24.3	7 ср.2.3	90.41%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Sharks С - Металлострой	16 мая 2024	29	2	93.1%	0
Металлострой - Red Star	08 мая 2024	24	2	91.67%	0
Омега - Металлострой	12 июня 2024	20	3	85%	0
MadGuyHockey Cup. Группа C (5-й дивизион)	2	45 ср.22.5	2 ср.1	95.56%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Royals 3 - Легион	17 мая 2024	21	0	100%	0
ХКЛ - Легион	07 июня 2024	24	2	91.67%	0
Зимний кубок Выборга 2024	4	85 ср.21.3	5 ср.1.3	94.12%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Ястребы г. Выборг - Сборная РХЛ	17 февраля 2024	21	2	90.48%	0
Сборная РХЛ - Пента	17 февраля 2024	22	2	90.91%	0
Легион - Сборная РХЛ	18 февраля 2024	22	0	100%	0
Сборная РХЛ - Викинги	18 февраля 2024	20	1	95%	0
Осенний Кубок Выборга	4	84 ср.21	8 ср.2	90.48%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Танк - Сборная РХЛ	11 ноября 2023	20	0	100%	0
Сборная РХЛ - Легион	11 ноября 2023	23	4	82.61%	0
Сборная РХЛ - Синяя Машина	12 ноября 2023	22	3	86.36%	0
Викинги - Сборная РХЛ	12 ноября 2023	19	1	94.74%	0
Кубок Ленинское	4	105 ср.26.3	17 ср.4.3	83.81%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Викинги - Сборная РХЛ	19 августа 2023	24	4	83.33%	0
Сборная РХЛ - Отрадное	19 августа 2023	22	5	77.27%	0
Сборная РХЛ - Легион	20 августа 2023	27	3	88.89%	0
Рать - Сборная РХЛ	20 августа 2023	32	5	84.38%	0
5-й дивизион	26	417 ср.16	57 ср.2.2	86.33%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Прогресс - Легион	01 ноября 2023	24	0	100%	0
Прогресс - ЦМКБ Алмаз	08 ноября 2023	27	4	85.19%	0
Royals 3 - Прогресс	04 декабря 2023	31	2	93.55%	0
Прогресс - Отрадное	20 декабря 2023	26	4	84.62%	0
Легион - Прогресс	17 января 2024	27	3	88.89%	0
Вымпел Про - ЦМКБ Алмаз	19 января 2024	22	2	90.91%	0
Вымпел Про - Royals 3	02 февраля 2024			0%	0
Прогресс - Вымпел Про	21 февраля 2024	28	7	75%	0
Рать - Прогресс	05 марта 2024	31	3	90.32%	0
Прогресс - Рать	06 марта 2024	25	1	96%	0
Вымпел Про - Royals 3	10 марта 2024	19	4	78.95%	0
Рать - Прогресс	12 марта 2024	17	2	88.24%	0
Прогресс - Рать	13 марта 2024	15	2	86.67%	0
Royals 3 - Вымпел Про	15 марта 2024	38	1	97.37%	0
Вымпел Про - Royals 3	17 марта 2024	20	4	80%	0
Рать - Прогресс	19 марта 2024	13	0	100%	0
Royals 3 - Вымпел Про	22 марта 2024	17	2	88.24%	0
Вымпел Про - Royals 3	24 марта 2024	16	2	87.5%	0
Отрадное - Прогресс	26 марта 2024	26	6	76.92%	0
Прогресс - Отрадное	27 марта 2024	14	3	78.57%	0
Отрадное - Прогресс	02 апреля 2024	29	4	86.21%	0
Прогресс - Отрадное	03 апреля 2024	13	4	69.23%	0
Отрадное - Вымпел Про	11 апреля 2024	17	4	76.47%	0
ЦМКБ Алмаз - Прогресс	13 апреля 2024	16	3	81.25%	0
Прогресс - ЦМКБ Алмаз	17 апреля 2024	27	5	81.48%	0
ЦМКБ Алмаз - Прогресс	20 апреля 2024	28	4	85.71%	0
Квалификационный 2023 Группа С (3-й дивизион)	1	25 ср.25	4 ср.4	84%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Jokers - Легион	07 августа 2023	25	4	84%	0

SELECT tournament.id , tournament.name , tournament.hash , game_result_composition.player_id , game_result_composition.team_id , COUNT(game.id) AS game_count , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((game_result_score.player_id = game_result_composition.player_id) OR (assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_point , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND game_result_score.player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_goal , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_assistent , (SELECT SUM(minute) FROM game_result_penalty JOIN game ON game.id = game_result_penalty.game_id AND game.publish_results = 1 WHERE game_result_penalty.team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_penalty ,( SELECT SUM(game_result_plus_minus.point) FROM game_result_plus_minus JOIN game ON game.id = game_result_plus_minus.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_plus_minus , (SELECT SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_shoots , (SELECT SUM(goals_missed) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_goals_missed , (SELECT SUM(reflected_shoots) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_reflected_shoots , (SELECT SUM(reflected_shoots) / (SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3)) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_percent , player_request.player_position_id , championship.name AS championship_name FROM game_result_composition JOIN game ON game.id = game_result_composition.game_id AND game.publish_results = 1 JOIN player_request ON player_request.id = game_result_composition.player_request_id JOIN tournament ON tournament.id = game.tournament_id JOIN championship ON championship.id = tournament.championship_id JOIN game_series ON game_series.id = game.game_series_id WHERE game_result_composition.player_id = '2119' AND tournament.season_id = '7' GROUP BY tournament.id ORDER BY tournament.id DESC

Сезон 2022-2023	М	Б	Ш	%	ШТ
MadGuyHockey Cup. Группа D (3-й дивизион, группа Б)	2	53 ср.26.5	14 ср.7	73.58%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Штерн - Парк	29 апреля 2023	25	7	72%	0
Ржавый якорь - Штерн	02 мая 2023	28	7	75%	0
MadGuyHockey Cup. Группа С (4-й дивизион)	1	36 ср.36	11 ср.11	69.44%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Парк-Премьер 2 - Гепард	25 апреля 2023	36	11	69.44%	0
3-й Дивизион	3	80 ср.26.7	15 ср.5	81.25%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Шкипер - Прогресс	18 декабря 2022	32	6	81.25%	0
Штерн - Прогресс	21 января 2023	20	6	70%	0
Jokers - Прогресс	03 февраля 2023	28	3	89.29%	0

SELECT tournament.id , tournament.name , tournament.hash , game_result_composition.player_id , game_result_composition.team_id , COUNT(game.id) AS game_count , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((game_result_score.player_id = game_result_composition.player_id) OR (assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_point , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND game_result_score.player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_goal , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_assistent , (SELECT SUM(minute) FROM game_result_penalty JOIN game ON game.id = game_result_penalty.game_id AND game.publish_results = 1 WHERE game_result_penalty.team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_penalty ,( SELECT SUM(game_result_plus_minus.point) FROM game_result_plus_minus JOIN game ON game.id = game_result_plus_minus.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_plus_minus , (SELECT SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_shoots , (SELECT SUM(goals_missed) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_goals_missed , (SELECT SUM(reflected_shoots) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_reflected_shoots , (SELECT SUM(reflected_shoots) / (SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3)) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_percent , player_request.player_position_id , championship.name AS championship_name FROM game_result_composition JOIN game ON game.id = game_result_composition.game_id AND game.publish_results = 1 JOIN player_request ON player_request.id = game_result_composition.player_request_id JOIN tournament ON tournament.id = game.tournament_id JOIN championship ON championship.id = tournament.championship_id JOIN game_series ON game_series.id = game.game_series_id WHERE game_result_composition.player_id = '2119' AND tournament.season_id = '6' GROUP BY tournament.id ORDER BY tournament.id DESC

Сезон 2021-2022	М	Б	Ш	%	ШТ
Квалификационный 2022, 3-й Дивизион, Группа А	3	61 ср.20.3	17 ср.5.7	72.13%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Оккервиль - Ржавый якорь	30 июня 2022	18	9	50%	0
Ржавый якорь - Оккервиль	01 августа 2022	21	4	80.95%	0
Оккервиль - Гранит	18 августа 2022	22	4	81.82%	0
Третий дивизион	18	391 ср.21.7	58 ср.3.2	85.17%	2 ср.0.1
Соперники	Дата матча	Б	Ш	%	ШТ
Венчур - Rolf Ю-Питер	28 ноября 2021	29	3	89.66%	0
Rolf Ю-Питер - ЖХК Хорс	01 декабря 2021	20	2	90%	0
ССП - Rolf Ю-Питер	11 декабря 2021	27	4	85.19%	0
Rolf Ю-Питер - Прогресс 2	22 декабря 2021	17	6	64.71%	0
Форвард 2 - Rolf Ю-Питер	26 декабря 2021	15	1	93.33%	0
Rolf Ю-Питер - Парк	29 декабря 2021	13	4	69.23%	0
Rolf Ю-Питер - ССП	12 января 2022	23	2	91.3%	0
Red Bulls - Rolf Ю-Питер	18 января 2022	25	2	92%	0
Rolf Ю-Питер - РамбоВ	26 января 2022	9	1	88.89%	0
ЖХК Хорс - Rolf Ю-Питер	31 января 2022	24	2	91.67%	2
Лоси - Rolf Ю-Питер	06 февраля 2022	30	4	86.67%	0
Прогресс 2 - Rolf Ю-Питер	19 февраля 2022	24	6	75%	0
РамбоВ - Rolf Ю-Питер	21 февраля 2022	20	2	90%	0
Rolf Ю-Питер - Венчур	23 февраля 2022	21	5	76.19%	0
Rolf Ю-Питер - Лоси	26 февраля 2022	30	2	93.33%	0
Rolf Ю-Питер - Red Bulls	28 февраля 2022	18	1	94.44%	0
Лоси - Rolf Ю-Питер	10 марта 2022	25	5	80%	0
Rolf Ю-Питер - Лоси	16 марта 2022	21	6	71.43%	0

SELECT tournament.id , tournament.name , tournament.hash , game_result_composition.player_id , game_result_composition.team_id , COUNT(game.id) AS game_count , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((game_result_score.player_id = game_result_composition.player_id) OR (assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_point , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND game_result_score.player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_goal , (SELECT COUNT(game_result_score.id) FROM game_result_score JOIN game ON game.id = game_result_score.game_id AND game.publish_results = 1 WHERE game_result_score.team_id = game_result_composition.team_id AND ((assistent1_id = game_result_composition.player_id) OR (assistent2_id = game_result_composition.player_id)) AND game.tournament_id = tournament.id ) AS player_assistent , (SELECT SUM(minute) FROM game_result_penalty JOIN game ON game.id = game_result_penalty.game_id AND game.publish_results = 1 WHERE game_result_penalty.team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_penalty ,( SELECT SUM(game_result_plus_minus.point) FROM game_result_plus_minus JOIN game ON game.id = game_result_plus_minus.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND player_id = game_result_composition.player_id AND game.tournament_id = tournament.id ) AS player_plus_minus , (SELECT SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_shoots , (SELECT SUM(goals_missed) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_goals_missed , (SELECT SUM(reflected_shoots) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_reflected_shoots , (SELECT SUM(reflected_shoots) / (SUM(shoot_1)+SUM(shoot_2)+SUM(shoot_3)) FROM game_result_goalkeeper JOIN game ON game.id = game_result_goalkeeper.game_id AND game.publish_results = 1 WHERE team_id = game_result_composition.team_id AND game.tournament_id = tournament.id AND player_id = game_result_composition.player_id) AS goalkeeper_percent , player_request.player_position_id , championship.name AS championship_name FROM game_result_composition JOIN game ON game.id = game_result_composition.game_id AND game.publish_results = 1 JOIN player_request ON player_request.id = game_result_composition.player_request_id JOIN tournament ON tournament.id = game.tournament_id JOIN championship ON championship.id = tournament.championship_id JOIN game_series ON game_series.id = game.game_series_id WHERE game_result_composition.player_id = '2119' AND tournament.season_id = '5' GROUP BY tournament.id ORDER BY tournament.id DESC

Сезон 2020-2021	М	Б	Ш	%	ШТ
Дивизион СТАРТ	5	103 ср.20.6	13 ср.2.6	87.38%	0 ср.0
Соперники	Дата матча	Б	Ш	%	ШТ
Легион 2023 - Прогресс 2	21 апреля 2021	18	1	94.44%	0
Прогресс 2 - Легион 2023	28 апреля 2021	11	1	90.91%	0
Венчур - Легион 2023	16 мая 2021	26	3	88.46%	0
Легион 2023 - Венчур	19 мая 2021	23	6	73.91%	0
Red Bull's 2 - Легион 2023	07 июня 2021	25	2	92%	0

Сезон 2025-2026	И
5-й дивизион	0	0	0	0
Осенний Кубок Выборга	0	0	0	0

Сезон 2024-2025	И
Кубок Великого Новгорода	0	0	0	0
Финальный этап, Малый кубок	0	0	0	0
Предварительный этап, Группа А	0	0	0	0
4-й Дивизион	0	0	0	0
Матч в честь 10-ти летия ХК «Легион»	0	0	0	0

Сезон 2023-2024	И
MadGuyHockey Cup. Группа В (6-й дивизион)	0	0	0	0
MadGuyHockey Cup. Группа C (5-й дивизион)	0	0	0	0
Зимний кубок Выборга 2024	0	0	0	0
Осенний Кубок Выборга	0	0	0	0
Кубок Ленинское	0	0	0	0
5-й дивизион	0	0	0	0
Квалификационный 2023 Группа С (3-й дивизион)	0	0	0	0

Сезон 2022-2023	И
MadGuyHockey Cup. Группа D (3-й дивизион, группа Б)	0	0	0	0
MadGuyHockey Cup. Группа С (4-й дивизион)	0	0	0	0
3-й Дивизион	0	0	0	0

Сезон 2021-2022	И
Квалификационный 2022, 3-й Дивизион, Группа А	0	0	0	0
Третий дивизион	1	0	0	1
Соперники	Дата матча
Red Bulls - Rolf Ю-Питер	18 января 2022

Сезон 2020-2021	И
Дивизион СТАРТ	1	0	0	1
Соперники	Дата матча
Red Bull's 2 - Легион 2023	07 июня 2021