|
 Заря (Луганск, Украина) |
|---|
| | | | | № | Имя | Нц | Поз | Вз | С | Пт | Ф | Оп | ДО | ДТ | ТехнСп | Ск | В | Тм | Гр | Дс | См | Л | Ун | Ад | Вл | ЗП | Ст |
|---|
| 16 | Никита Шевченко | | GK | 28 | 80 | 85 | 100 | 28 | 7 | -- | ИВ2 Р3 Т2 О1 | 9 | 7 | 18 | 12 | 9 | 5 | 20 | 15 | 17 | 20 | 15 | | | 12 | Дмитрий Мацапура | | GK | 20 | 52 | 98 | 98 | 20 | 21 | -- | Р1 | 11 | 12 | 7 | 8 | 12 | 7 | 1 | 19 | 12 | 3 | 4 |  | | 4 | Алексей Гусев  | | SW/CD/RD... | 19 | 75 | 92 | 94 | 28 | 28 | -- | От3 Пр2 | 3 | 18 | 15 | 8 | 19 | 11 | 16 | 18 | 13 | 20 | 17 | | | 21 | Александр Тымчик | | LD/CD | 31 | 81 | 81 | 100 | 114 | 7 | -- | П3 Др1 От3 Пр3 ИГ1 | 17 | 15 | 2 | 6 | 6 | 6 | 20 | 5 | 3 | 20 | 68 | | | 5 | Николай Михайленко | | LD/CD/LB... | 24 | 83 | 92 | 100 | 46 | 7 | -- | П1 От3 Пр3 | 10 | 17 | 17 | 8 | 14 | 7 | 9 | 16 | 3 | 12 | 36 | | | 3 | Антон Боль | | LD/LB | 22 | 68 | 77 | 98 | 24 | 28 | -- | От3 Пр3 Уг1 | 15 | 20 | 3 | 12 | 13 | 11 | 8 | 2 | 19 | 14 | 20 | | | 24 | Владимир Бражко | | LD/RD/LB... | 22 | 73 | 82 | 100 | 34 | 7 | -- | От2 Пр2 | 14 | 20 | 2 | 5 | 4 | 4 | 13 | 13 | 14 | 20 | 21 | | 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 = 43261
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 = 43261
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 = 43261
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 = 43261
group by t.id) xxx
group by player
error: Out of resources when opening file './fb/tournament_gr_st_participants.MYD' (Errcode: 24)
|
|
