|
| Основная информация |
|---|
 | Национальность: |  Буркина-Фасо | | Клуб: |  Грёдих | | Позиция: | CD/RD | | Возраст: | 26 | | Сила: | 79 | | Потенциал: | 81 | | Опыт: | 49 | | Зарплата: | 29 (на следующий сезон: 34) | | Специализации: | персональщик | | Рабочая нога: | правая | Рост: | 182 |
| | Физические и "ментальные" спецвозможности |
|---|
| Скорость | 14 | | Выносливость | 15 | | Подверженность травмам | 10 | | Грубость | 18 | | Дисциплина | 7 | | Склонность к симуляции | 2 | | Лидерство | 15 | | Универсальность | 6 | | Способность к адаптации | 19 | | Воля | 20 |
|
| Пришел из спортшколы в 23-м сезоне (возраст 18, сила 59, потенциал 83) в клубе Грёдих |
| Тренировки |
|---|
| Сила | 43% | | Игра головой | 30% | | Пас | 5% | | Выносливость | 12% |
| | Технические спецвозможности |
|---|
| Отбор | 3 | | Перехват | 3 | | Игра головой | 1 | | Штрафные | 1 |
|
| Опыт игры в странах |
|---|
| 100% 100% |
|
| | Действия |
|---|
| Вы не можете совершать действия с этим игроком |
|
| | | | | | | Настрой (игровое время): | 0 |
| | |
| | Игровая практика | 0 | доволен | Суммарно: | 0 | доволен | | Тренировки | 0 | доволен |
| Статистика текущего сезона |
|---|
| Команда | Турнир | Игры | Минуты | Г(П) | П | ЖК | 2ЖК | КК | АГ | Пр(П) | Оц | +/- |
|---|
| Грёдих | Чемпионаты стран | 27 | 2514 | 4(0) | 0 | 12 | 1 | 0 | 0 | 0(0) | 6.74 | +1 | Query:
select pms.*, tm1.id as hosts, tm2.id as guests,
tm1.name as hosts_name, tm2.name as guests_name, d.day as game_day,
tm1.country as hosts_country, tm2.country as guests_country,
mst.goals_h, mst.goals_g, DATE_FORMAT(d.date, '%d/%m/%y') as game_date
from player_match_statistics pms, tournaments t, days d,
teams tm1, teams tm2,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp, match_schedule msc,
match_statistics mst, tournament_schedule tsc
where pms.player = 69950 and tsc.id = msc.tour_sch
and tm1.id = msc.hosts and tm2.id = msc.guests
and tsc.tour_stage = tst.id and mst.game = msc.id
and tst.tournament = t.id and tsc.day = d.day
and tgs.stage = tst.id and msc.id = pms.game
and pms.team = 1181 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = tm1.id
and t.id = 2
union select pms.*, tm1.id + 10000 as hosts,
tm2.id + 10000 as guests,
tm1.name as hosts_name, tm2.name as guests_name, d.day as game_day,
tm1.id as hosts_country, tm2.id as guests_country,
mst.goals_h, mst.goals_g, DATE_FORMAT(d.date, '%d/%m/%y') as game_date
from player_match_statistics pms, tournaments t, days d,
countries tm1, countries tm2,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp, match_schedule msc,
match_statistics mst, tournament_schedule tsc
where pms.player = 69950 and tsc.id = msc.tour_sch
and tm1.id = msc.hosts - 10000
and tm2.id = msc.guests - 10000
and tsc.tour_stage = tst.id and mst.game = msc.id
and tst.tournament = t.id and tsc.day = d.day
and tgs.stage = tst.id and msc.id = pms.game
and pms.team = 1181 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 2
union select pms.*, tm1.id + 20000 as hosts,
tm2.id + 20000 as guests,
CONCAT(tm1.name, ' U21') as hosts_name,
CONCAT(tm2.name, ' U21') as guests_name, d.day as game_day,
tm1.id as hosts_country, tm2.id as guests_country,
mst.goals_h, mst.goals_g, DATE_FORMAT(d.date, '%d/%m/%y') as game_date
from player_match_statistics pms, tournaments t, days d,
countries tm1, countries tm2,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp, match_schedule msc,
match_statistics mst, tournament_schedule tsc
where pms.player = 69950 and tsc.id = msc.tour_sch
and tm1.id = msc.hosts - 20000
and tm2.id = msc.guests - 20000
and tsc.tour_stage = tst.id and mst.game = msc.id
and tst.tournament = t.id and tsc.day = d.day
and tgs.stage = tst.id and msc.id = pms.game
and pms.team = 1181 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 2
union select pms.*, tm1.id + 30000 as hosts,
tm2.id + 30000 as guests,
CONCAT(tm1.name, ' U19') as hosts_name,
CONCAT(tm2.name, ' U19') as guests_name, d.day as game_day,
tm1.id as hosts_country, tm2.id as guests_country,
mst.goals_h, mst.goals_g, DATE_FORMAT(d.date, '%d/%m/%y') as game_date
from player_match_statistics pms, tournaments t, days d,
countries tm1, countries tm2,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp, match_schedule msc,
match_statistics mst, tournament_schedule tsc
where pms.player = 69950 and tsc.id = msc.tour_sch
and tm1.id = msc.hosts - 30000
and tm2.id = msc.guests - 30000
and tsc.tour_stage = tst.id and mst.game = msc.id
and tst.tournament = t.id and tsc.day = d.day
and tgs.stage = tst.id and msc.id = pms.game
and pms.team = 1181 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 2 order by game_day
error: Out of resources when opening file './fb/tournament_groups_stages.MYD' (Errcode: 24)
|
