|
| | | |
|
Query: select pma.*, pl.name as player_name,
p.short_name as pos_name, pl.id as pl_id,
ifnull(pms.team_number, pl.team_number) as team_number, tc.*, pma.team as team
from (player_match_abilities pma, players pl, positions p,
player_match_statistics pms)
left join team_colors tc on tc.team = 411 where pma.minute = 30 and pma.game = 972709
and pma.team = 411 and pms.game = 972709 and pms.team = 411
and pma.player = pl.id and pms.player = pl.id
and pma.position = p.id group by pma.player order by p.code, pma.player error: Can't open file: './fb/player_match_statistics.frm' (errno: 24) | | |
|