|
 Татабанья (Татабанья, Венгрия) |
|---|
| | | | | № | Имя | Нц | Поз | Вз | С | Пт | Ф | Оп | ДО | ДТ | ТехнСп | Ск | В | Тм | Гр | Дс | См | Л | Ун | Ад | Вл | ЗП | Ст |
|---|
| 21 | Габор Риго | | GK | 35 | 55 | 55 | 100 | 84 | 54 | -- | ИВ3 Р3 Т3 О2 | 1 | 11 | 19 | 6 | 12 | 5 | 15 | 1 | 3 | 20 | 8 | | | 13 | Роланд Куншаги | | GK | 25 | 68 | 79 | 95 | 22 | 68 | -- | Р3 | 16 | 8 | 13 | 5 | 9 | 18 | 20 | 19 | 2 | 20 | 8 | | | 19 | Виктор Фаркаш | | SW/CD/RD/DM | 35 | 56 | 56 | 100 | 140 | 54 | -- | П1 От3 Пр3 ИГ3 | 10 | 5 | 19 | 11 | 10 | 5 | 20 | 10 | 9 | 20 | 10 | | | 24 | Серхио Агуэро |  | SW/CD/RD | 30 | 75 | 75 | 100 | 74 | 61 | -- | П1 От3 Пр3 ИГ3 | 12 | 13 | 19 | 15 | 10 | 4 | 15 | 8 | 3 | 20 | 35 | | | 17 | Эдуар Нджодо |  | SW/CD/DM... | 23 | 72 | 84 | 100 | 37 | 54 | -- | От2 Пр2 | 7 | 13 | 15 | 10 | 13 | 8 | 11 | 16 | 20 | 20 | 10 | | | 20 | Барнабаш Шолтес | | LD/CD/LB... | 36 | 41 | 41 | 100 | 142 | 68 | -- | П3 Др1 От3 Пр3 | 2 | 5 | 17 | 10 | 10 | 6 | 20 | 16 | 3 | 20 | 7 | | | 3 | Балаж Крупански | | LD/CD/LB... | 32 | 75 | 75 | 100 | 111 | 54 | -- | П3 Др2 От3 Пр2 | 10 | 12 | 11 | 14 | 11 | 5 | 7 | 16 | 19 | 13 | 33 | | | 23 | Роланд Гаснер | | LD/LB | 31 | 65 | 65 | 100 | 97 | 54 | -- | П3 От3 Пр3 | 16 | 18 | 2 | 15 | 12 | 1 | 20 | 3 | 19 | 20 | 30 | | | 4 | Карой Катона  | | CD/DM/CM | 18 | 48 | 98 | 100 | 20 | 71 | -- | От1 | 11 | 13 | 9 | 14 | 14 | 4 | 13 | 9 | 15 | 17 | 2 | | | 22 | Давид Ковач | | RD/RB | 34 | 57 | 57 | 100 | 124 | 61 | -- | П3 Др1 От3 Пр3 | 16 | 12 | 10 | 8 | 16 | 12 | 8 | 2 | 10 | 14 | 19 | | | 6 | Марк Фаркаш  | | RD/RB/RM/RW | 21 | 77 | 88 | 100 | 36 | 54 | -- | От2 Пр2 | 8 | 20 | 13 | 10 | 12 | 13 | 14 | 15 | 16 | 12 | 16 | | Query:
select player, sum(minutes) as sm from
(select ps.player, ps.minutes, t.id
from player_statistics ps, tournaments t, teams tm, countries c,
tournament_groups tg,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp
where t.id = ps.tournament and tm.id = ps.team
and tst.tournament = t.id and tg.tournament = t.id and tgs.group = tg.id
and tgs.stage = tst.id and t.id != 1 and t.id != 5
and tgsp.gr_st = tgs.id and tgsp.team = tm.id and tm.country = c.id
and ps.player = 41601
union select ps.player, ps.minutes, t.id
from player_statistics ps, tournaments t, countries tm,
tournament_groups tg,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp
where t.id = ps.tournament and
tm.id = ps.team - 10000
and tst.tournament = t.id and tg.tournament = t.id and tgs.group = tg.id
and tgs.stage = tst.id and t.id != 1 and t.id != 5
and tgsp.gr_st = tgs.id and tgsp.team = ps.team
and ps.player = 41601
union select ps.player, ps.minutes, t.id
from player_statistics ps, tournaments t, countries tm,
tournament_groups tg,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp
where t.id = ps.tournament and
tm.id = ps.team - 20000
and tst.tournament = t.id and tg.tournament = t.id and tgs.group = tg.id
and tgs.stage = tst.id and t.id != 1 and t.id != 5
and tgsp.gr_st = tgs.id and tgsp.team = ps.team
and ps.player = 41601
union select ps.player, ps.minutes, t.id
from player_statistics ps, tournaments t, countries tm,
tournament_groups tg,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp
where t.id = ps.tournament and
tm.id = ps.team - 30000
and tst.tournament = t.id and tg.tournament = t.id and tgs.group = tg.id
and tgs.stage = tst.id and t.id != 1 and t.id != 5
and tgsp.gr_st = tgs.id and tgsp.team = ps.team
and ps.player = 41601
group by t.id) xxx
group by player
error: Out of resources when opening file './fb/player_statistics.MYD' (Errcode: 24)
|
|
