|
| | | |
|
| | Рейтинги |
|
|
| Рейтинг на начало матча | | Рейтинг на конец матча |
|
|
|
|
| | | | Расчетные данные | |
|
|
| Тактика | |
|
|
| | На начало матча | |
|
| РС команды | | ОРС команды | | АРС команды |
|
| | На конец матча | |
|
| РС команды | | ОРС команды | | АРС команды |
|
|
|
| |
|
|
|
|
Query:
select pms.*, pl.name as player_name, pmd.*,
pl.id as pl_id, if(pms.age = 0, pl.age, pms.age) as age,
if(pms.ability = 0, pl.ability, pms.ability) as ability,
if(pms.potential = 0, pl.potential, pms.potential) as potential, pl.nation
from player_match_statistics pms, players pl, player_match_details pmd
where pms.game = 289838 and starting_position > 15 and min_in > 0
and pms.team = 146 and pl.id = pms.player and pmd.game = 289838
and pmd.team = 146 and pl.id = pmd.player
order by pms.min_in
error: Can't open file: './fb_arc/players.frm' (errno: 24) | |
|
