|
| Основная информация |
|---|
| Национальность: |  Малайзия | | Клуб: | Петалинг Джая Сити (тренер) | | Позиция: | LD/LB/LM/RM/LW/AM/RW/ST | | Возраст: | 35 | | Сила: | 48 | | Потенциал: | 48 | | Опыт: | 174 | | Зарплата: | 16 (на следующий сезон: 9) | | Специализации: | командный игрок | | Рабочая нога: | обе | Рост: | 176 |
| | Физические и "ментальные" спецвозможности |
|---|
| Скорость | 14 | | Выносливость | 11 | | Подверженность травмам | 5 | | Грубость | 13 | | Дисциплина | 13 | | Склонность к симуляции | 20 | | Лидерство | 19 | | Универсальность | 18 | | Способность к адаптации | 12 | | Воля | 20 |
|
Зарегистрирован в 16-м сезоне (возраст 20, сила 50, потенциал 77) в клубе  |
| Тренировки |
|---|
| Сила | 5% | | Игра головой | 1% | | Выносливость | 1% | | CM | 16% |
| | Технические спецвозможности |
|---|
| Пас | 3 | | Дриблинг | 3 | | Игра головой | 1 | | Удар | 3 |
|
| Опыт игры в странах |
|---|
| 100% |
|
| | Действия |
|---|
| Вы не можете совершать действия с этим игроком |
|
| | | | | | | Настрой (игровое время): | 0 |
| | |
| | Игровая практика | 0 | доволен | Суммарно: | 0 | доволен | | Тренировки | 0 | доволен |
| Статистика текущего сезона |
|---|
| Команда | Турнир | Игры | Минуты | Г(П) | П | ЖК | 2ЖК | КК | АГ | Пр(П) | Оц | +/- |
|---|
| Петалинг Джая Сити | Чемпионаты стран | 25 | 1519 | 1(0) | 1 | 4 | 0 | 0 | 0 | 0(0) | 6.38 | 0 | | Петалинг Джая Сити | Кубки стран | 5 | 483 | 0(0) | 1 | 2 | 0 | 0 | 0 | 0(0) | 6.62 | 0 | | Петалинг Джая Сити | Лига чемпионов | 2 | 181 | 0(0) | 0 | 0 | 0 | 0 | 0 | 0(0) | 6.29 | 0 | | Петалинг Джая Сити | Суперкубки стран | 1 | 91 | 0(0) | 0 | 1 | 0 | 0 | 0 | 0(0) | 6.27 | 0 | | Петалинг Джая Сити | Кубок Лиги | 2 | 182 | 0(0) | 0 | 1 | 0 | 0 | 0 | 0(0) | 6.17 | 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 = 55519 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 = 1811 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = tm1.id
and t.id = 12
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 = 55519 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 = 1811 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 12
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 = 55519 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 = 1811 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 12
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 = 55519 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 = 1811 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 12 order by game_day
error: Out of resources when opening file './fb/tournaments.MYD' (Errcode: 24)
|
