|
| Основная информация |
|---|
| Национальность: |  Израиль (9 U21-матчей/0 голов) | | Клуб: | Маккаби (Х) | | Позиция: | LD/RD/LB/DM/RB/LM/CM/LW | | Возраст: | 24 | | Сила: | 79 | | Потенциал: | 82 | | Опыт: | 79 | | Зарплата: | 59 (на следующий сезон: 69) | | Специализации: | отсутствуют | | Рабочая нога: | левая | Рост: | 177 |
| | Физические и "ментальные" спецвозможности |
|---|
| Скорость | 18 | | Выносливость | 20 | | Подверженность травмам | 18 | | Грубость | 12 | | Дисциплина | 6 | | Склонность к симуляции | 3 | | Лидерство | 6 | | Универсальность | 20 | | Способность к адаптации | 7 | | Воля | 19 |
|
| Пришел из спортшколы в 23-м сезоне (возраст 16, сила 57, потенциал 82) в клубе Маккаби (Х) |
| Тренировки |
|---|
| Сила | 2% | | Дриблинг | 33% | | RM | 16% |
| | Технические спецвозможности |
|---|
| Пас | 3 | | Дриблинг | 2 | | Отбор | 3 | | Перехват | 3 |
|
| Опыт игры в странах |
|---|
| 100% |
|
| | Действия |
|---|
| Вы не можете совершать действия с этим игроком |
|
| | | | | | | Настрой (игровое время): | 0 |
| | |
| | Игровая практика | 0 | доволен | Суммарно: | 0 | доволен | | Тренировки | 0 | доволен |
| Статистика текущего сезона |
|---|
| Команда | Турнир | Игры | Минуты | Г(П) | П | ЖК | 2ЖК | КК | АГ | Пр(П) | Оц | +/- |
|---|
| Маккаби (Х) | Чемпионаты стран | 28 | 2572 | 1(0) | 2 | 7 | 1 | 0 | 0 | 0(0) | 6.84 | 0 | | Маккаби (Х) | Кубки стран | 6 | 490 | 1(0) | 0 | 0 | 0 | 0 | 0 | 0(0) | 6.99 | 0 | | Маккаби (Х) | Лига чемпионов | 3 | 245 | 0(0) | 0 | 0 | 0 | 1 | 0 | 0(0) | 6.58 | 0 | | Маккаби (Х) | Суперкубки стран | 1 | 90 | 0(0) | 0 | 0 | 0 | 0 | 0 | 0(0) | 7.20 | 0 | | Маккаби (Х) | Кубок Лиги | 2 | 183 | 0(0) | 0 | 0 | 0 | 0 | 0 | 0(0) | 6.42 | 0 | | Маккаби (Х) | Кубок претендентов | 4 | 368 | 0(0) | 0 | 0 | 0 | 0 | 0 | 0(0) | 6.76 | 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 = 69107 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 = 752 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = tm1.id
and t.id = 15
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 = 69107 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 = 752 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 15
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 = 69107 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 = 752 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 15
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 = 69107 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 = 752 and d.day >= 11005
and tgsp.gr_st = tgs.id and tgsp.team = msc.hosts
and t.id = 15 order by game_day
error: Out of resources when opening file './fb/match_schedule.MYD' (Errcode: 24)
|
