|
Query:
select pl.id, pl.season_start, pl.start_age, pl.potential,
pl.start_ability, pl.start_potential, pl.team, pl.age, pl.ability,
pl.nation, tm.name as tm_name, c1.name as pl_nation,
c2.name as tm_country, pl.name as pl_name, pl.team, tm.country,
p.short_name
from ((players pl, positions p, countries c1)
left join transfer_history trh
on pl.id = trh.player)
left join teams tm on pl.team = tm.id
left join countries c2 on c2.id = tm.country
where source = 'Y' and own_team = 1576 and trh.id is null
and pl.nation = c1.id and p.id = pl.main_position
union select pl.id, pl.season_start, pl.start_age, pl.potential,
pl.start_ability, pl.start_potential, pl.team, pl.age, pl.ability,
pl.nation, tm.name as tm_name, c1.name as pl_nation,
c2.name as tm_country, pl.name as pl_name, pl.team, tm.country,
p.short_name
from (((players pl, positions p, countries c1)
left join transfer_history trh2
on pl.id = trh2.player and trh2.team_from = 1576)
left join transfer_history trh1
on pl.id = trh1.player and trh1.team_to = 1576)
left join teams tm on pl.team = tm.id
left join countries c2 on c2.id = tm.country
where source = 'Y' and trh2.id is not null and (trh1.id is null /*or trh1.day > trh2.day*/)
and pl.nation = c1.id and p.id = pl.main_position
order by season_start, id
error: Out of resources when opening file './fb/positions.MYD' (Errcode: 24) |
