|
Эт Таавун (Бурайда, Саудовская Аравия) |
---|
| | | | № | Имя | Нц | Поз | Вз | С | Пт | Ф | Оп | ДО | ДТ | ТехнСп | Ск | В | Тм | Гр | Дс | См | Л | Ун | Ад | Вл | ЗП | Ст |
---|
1 | Фаиз Эс Собеа | ![Саудовская Аравия Саудовская Аравия](flag/198.gif) | GK | 38 | 62 | 62 | 100 | 244 | 54 | -- | ИВ3 Р3 Т2 О2 | 1 | 10 | 5 | 5 | 19 | 5 | 20 | 8 | 16 | 20 | 22 | | 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 = 81481
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 = 81481
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 = 81481
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 = 81481
group by t.id) xxx
group by player error: Out of resources when opening file './fb/tournament_gr_st_participants.MYD' (Errcode: 24)
|
|