|
Query:
select msc.id
from match_schedule msc, tournament_schedule tsc, days d,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp
where msc.hosts = '1112' and tsc.day = d.day and tsc.tour_stage = tst.id
and tst.id = tgs.stage and tgsp.gr_st = tgs.id and tgsp.team = '1112'
and msc.played and msc.tour_sch = tsc.id and d.day >= 12487
and not tgs.hide
union select msc.id
from match_schedule msc, tournament_schedule tsc, days d,
tournament_stages tst, tournament_groups_stages tgs,
tournament_gr_st_participants tgsp
where msc.guests = '1112' and tsc.day = d.day and tsc.tour_stage = tst.id
and tst.id = tgs.stage and tgsp.gr_st = tgs.id and tgsp.team = '1112'
and msc.played and msc.tour_sch = tsc.id and d.day >= 12487
and not tgs.hide
error: Out of resources when opening file './fb/tournament_gr_st_participants.MYD' (Errcode: 24) |
