|
 Статистика игроков клуба Хайбёрниан (Эдинбург, Шотландия) |
|---|
| | | | | Имя | Нц | Поз | Вз | С | Пт | Турнир | И | Мин | Г | ГП | П | ЖК | 2ЖК | КК | АГ | Пр | ПрП |
|---|
Query:
select pl.id, pl.name, pl.nation, c.name as country_name,
(select min(pp.position) from player_positions pp where pp.player = pl.id) as min_position,
pl.age, pl.ability, pl.potential,
t.id as tour_id, t.name as tour_name,
sum(ps.games) as ps_games, sum(ps.goals) as ps_goals, sum(ps.assists) as ps_assists,
sum(ps.minutes) as ps_minutes, sum(ps.goals_from_pen) as ps_goals_from_pen,
sum(ps.yellows) as ps_yellows, sum(ps.two_yellows) as ps_two_yellows,
sum(ps.reds) as ps_reds, sum(ps.own_goals) as ps_own_goals,
sum(ps.conceded) as ps_conceded, sum(ps.conceded_from_pen) as ps_conceded_from_pen
from fb_arc.player_statistics ps, players pl, tournaments t, countries c
where ps.team = '107' and pl.id = ps.player and ps.tournament = t.id
and pl.nation = c.id and ps.season >= 1 and ps.season <= 33
and t.id in (null)
group by ps.player, ps.tournament order by 5
error: Table 'fb_arc.player_statistics' doesn't exist
|
|
