|
 Ювентус (Манагуа, Никарагуа) |
|---|
| | | | | № | Имя | Нц | Поз | Вз | С | Пт | Ф | Оп | ДО | ДТ | ТехнСп | Ск | В | Тм | Гр | Дс | См | Л | Ун | Ад | Вл | ЗП | Ст |
|---|
| 12 | Джадзиль Мендоса  | | GK | 31 | 81 | 81 | 100 | 140 | 49 | -- | ИВ3 Р3 Т3 О3 | 15 | 15 | 20 | 20 | 20 | 5 | 20 | 8 | 8 | 20 | 28 | | | 1 | Юрий Цой |  | GK | 27 | 73 | 73 | 100 | 24 | 84 | -- | | 12 | 7 | 2 | 10 | 4 | 14 | 9 | 2 | 2 | 6 | 8 | | | 5 | Вильям Роблес | | LD/CD/RD... | 36 | 32 | 32 | 100 | 158 | 63 | -- | П1 От3 Пр3 ИГ3 | 4 | 10 | 7 | 5 | 13 | 5 | 15 | 13 | 16 | 20 | 5 | | | 11 | Вильям Эспанья | | LD/LB/LM... | 32 | 82 | 82 | 99 | 207 | 35 | -- | П3 Др3 От3 Пр3 ИГ1 Уд3 | 18 | 20 | 1 | 8 | 20 | 15 | 19 | 18 | 13 | 20 | 180 | | | 18 | Карлос Гвардадо | | LD/CD/LB | 25 | 89 | 96 | 100 | 54 | 49 | -- | П2 От3 Пр3 | 17 | 10 | 1 | 15 | 10 | 2 | 13 | 14 | 18 | 19 | 40 | | | 4 | Луис Гутьеррес | | CD/RD/DM... | 36 | 37 | 37 | 100 | 167 | 84 | -- | П3 Др1 От3 Пр3 | 8 | 7 | 7 | 5 | 13 | 5 | 15 | 13 | 16 | 20 | 10 | | | 19 | Брандон Айердис | | CD/RD | 28 | 87 | 87 | 100 | 69 | 49 | -- | П1 От3 Пр3 ИГ1 | 13 | 12 | 15 | 15 | 5 | 8 | 19 | 5 | 4 | 20 | 39 | | | 21 | Хуниор Артеага | | CD/DM/RB | 25 | 81 | 85 | 100 | 45 | 49 | -- | От3 Пр3 ИГ2 | 11 | 11 | 18 | 10 | 6 | 2 | 11 | 9 | 10 | 19 | 24 | | | 23 | Лукас Рейносо |  | CD/DM/CM | 23 | 77 | 87 | 100 | 38 | 56 | -- | От3 Пр2 | 12 | 17 | 15 | 20 | 12 | 10 | 5 | 18 | 13 | 4 | 19 | | | 2 | Вильсон Алеман | | RD/DM/RB... | 37 | 28 | 28 | 100 | 166 | 84 | -- | П3 Др2 От3 Пр3 | 9 | 9 | 7 | 5 | 13 | 1 | 13 | 13 | 16 | 20 | 5 | | | 7 | Берман Крус | | RD/RB/LM... | 35 | 55 | 55 | 100 | 168 | 49 | -- | П3 Др3 От2 Пр1 Уд2 | 13 | 15 | 5 | 8 | 13 | 15 | 20 | 18 | 13 | 20 | 19 | | | 10 | Эрик Ласо | | RD/RB/CM... | 33 | 62 | 62 | 100 | 145 | 49 | -- | П3 Др3 ИГ3 Уд3 | 11 | 11 | 1 | 8 | 18 | 20 | 13 | 18 | 13 | 20 | 29 | | | 22 | Деннис Бергер | | RD/LB/RB | 25 | 77 | 83 | 100 | 59 | 49 | -- | П2 От3 Пр3 | 17 | 19 | 11 | 9 | 8 | 4 | 3 | 9 | 8 | 2 | 36 | | | 9 | Лестер Харкин | | RB/RM/AM... | 34 | 67 | 67 | 100 | 186 | 49 | -- | П3 Др3 От1 Пр1 ИГ3 Уд3 | 12 | 10 | 3 | 8 | 16 | 20 | 20 | 13 | 13 | 20 | 44 | | | 8 | Норлан Куадра | | LM/CM/RM/LW | 34 | 51 | 51 | 100 | 124 | 49 | -- | П3 Др3 От3 Пр2 | 9 | 17 | 3 | 8 | 16 | 15 | 20 | 10 | 13 | 20 | 13 | | 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 = 71663
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 = 71663
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 = 71663
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 = 71663
group by t.id) xxx
group by player
error: Out of resources when opening file './fb/tournament_groups_stages.MYD' (Errcode: 24)
|
|
