|
| Основная информация |
|---|
| Национальность: |  Фиджи (8 матчей/0 голов) | | Клуб: | Нандронга | | Позиция: | LD/CD/RD/LB/RB | | Возраст: | 27 | | Сила: | 76 | | Потенциал: | 76 | | Опыт: | 110 | | Зарплата: | 47 (на следующий сезон: 57) | | Специализации: | отсутствуют | | Рабочая нога: | обе | Рост: | 182 |
| | Физические и "ментальные" спецвозможности |
|---|
| Скорость | 17 | | Выносливость | 20 | | Подверженность травмам | 7 | | Грубость | 11 | | Дисциплина | 16 | | Склонность к симуляции | 5 | | Лидерство | 12 | | Универсальность | 13 | | Способность к адаптации | 16 | | Воля | 20 |
|
| Зарегистрирован в 23-м сезоне (возраст 19, сила 48, потенциал 80) в клубе Нандронга |
| Тренировки |
|---|
| Сила | 28% | | Игра головой | 1% | | Пас | 37% |
| | Технические спецвозможности |
|---|
| Пас | 2 | | Отбор | 3 | | Перехват | 3 | | Игра головой | 1 |
|
| Опыт игры в странах |
|---|
| 100% |
|
| | Действия |
|---|
| Вы не можете совершать действия с этим игроком |
|
| | | | | | | Настрой (игровое время): | 0 |
| | |
| | Игровая практика | 0 | доволен | Суммарно: | 0 | доволен | | Тренировки | 0 | доволен |
| Статистика текущего сезона |
|---|
| Команда | Турнир | Игры | Минуты | Г(П) | П | ЖК | 2ЖК | КК | АГ | Пр(П) | Оц | +/- |
|---|
| Нандронга | Чемпионаты стран | 28 | 2460 | 1(0) | 3 | 7 | 1 | 0 | 0 | 0(0) | 6.79 | 0 | | Нандронга | Кубки стран | 3 | 301 | 0(0) | 0 | 1 | 0 | 0 | 0 | 0(0) | 6.76 | 0 | | Фиджи | Чемпионат мира (отбор) | 4 | 364 | 0(0) | 0 | 0 | 0 | 0 | 0 | 0(0) | 6.71 | +1 | | Фиджи | Товарищеские матчи сборных | 2 | 182 | 0(0) | 0 | 1 | 0 | 0 | 0 | 0(0) | 6.51 | 0 | 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 = 66910 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 = 10102 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = tm1.id
and t.id = 16
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 = 66910 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 = 10102 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 16
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 = 66910 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 = 10102 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 16
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 = 66910 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 = 10102 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 16 order by game_day
error: Out of resources when opening file './fb/tournament_groups_stages.MYD' (Errcode: 24)
|
