|
| | | |
|
| | Рейтинги |
|
|
| Рейтинг на начало матча | | Рейтинг на конец матча |
|
|
|
| | Контратакующая РС |
|
|
| Коэффициент на начало матча | | Коэффициент на конец матча |
|
|
|
|
|
|
| ОРС на начало матча | | ОРС на конец матча |
|
|
|
|
|
|
| АРС на начало матча | | АРС на конец матча |
|
|
|
|
| Query:
select pms.*, p.short_name as pos_name,
pl.name as player_name, ifnull(pms.team_number, pl.team_number) as team_number, pms.starting_position as position, tc.*,
pms.team as team from (seasons ss, player_match_statistics pms, positions p, players pl)
left join team_colors tc on tc.team = 1101 and tc.season = ss.season where game = 487298 and starting_position <= 15
and pms.team = 1101 and p.id = starting_position
and pl.id = pms.player and ss.start_day <= 6313 and ss.end_day >= 6313 order by p.code
error: Out of resources when opening file './fb_arc/positions.MYD' (Errcode: 24) | | |
|
