|
| | | |
|
| | Игровая дата: 24/08/2024 | | Стадион: Сентре д`Энтренамен 2 (Андорра-ла-Велья, 35000) | | Зрители: 35000 (цена билета: 57) | | Погода: 19°C, без осадков | | Судья: Мануэл Фернандеш |
| 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 (player_match_statistics pms, positions p, players pl)
left join team_colors tc on tc.team = 1829 where game = 967838 and starting_position <= 15
and pms.team = 1829 and p.id = starting_position
and pl.id = pms.player order by p.code
error: Can't open file: './fb/team_colors.frm' (errno: 24) |
| |
|
