|
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 = '1002' 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 = '1002'
and msc.played and msc.tour_sch = tsc.id and d.day >= 11005
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 = '1002' 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 = '1002'
and msc.played and msc.tour_sch = tsc.id and d.day >= 11005
and not tgs.hide error: Out of resources when opening file './fb/match_schedule.MYD' (Errcode: 24) |