|
| ИД | Дата | Турнир | Тур | Матч | ЛВQuery:
select msc.id as gameid, tm_h.name as hosts_name, tm_g.name as guests_name, tm_h.id as hosts, tm_g.id as guests, t.id as tourid, DATE_FORMAT(d.date,'%d/%m/%Y') as game_date, d.day as day, tgs.name as tgs_name, tgs.id as tgs_id, tsc.round from match_schedule msc, tournaments t, tournament_stages tst, tournament_schedule tsc, teams tm_h, teams tm_g, days d, tournament_groups_stages tgs, tournament_gr_st_participants tgsp where msc.hosts = '1141' and tm_h.id = '1141' and tm_g.id = msc.guests and tm_h.id != tm_g.id and tsc.tour_stage = tst.id and tst.tournament = t.id and tsc.day = d.day and tst.id = tgs.stage and tgsp.gr_st = tgs.id and tgsp.team = '1141' and not msc.played and msc.tour_sch = tsc.id and tsc.day >= 11386 group by tsc.id union select msc.id as gameid, tm_h.name as hosts_name, tm_g.name as guests_name, tm_h.id as hosts, tm_g.id as guests, t.id as tourid, DATE_FORMAT(d.date,'%d/%m/%Y') as game_date, d.day as day, tgs.name as tgs_name, tgs.id as tgs_id, tsc.round from match_schedule msc, tournaments t, tournament_stages tst, tournament_schedule tsc, teams tm_h, teams tm_g, days d, tournament_groups_stages tgs, tournament_gr_st_participants tgsp where msc.guests = '1141' and tm_g.id = '1141' and tm_h.id = msc.hosts and tm_h.id != tm_g.id and tsc.tour_stage = tst.id and tst.tournament = t.id and tsc.day = d.day and not tgs.hide and tst.id = tgs.stage and tgsp.gr_st = tgs.id and tgsp.team = '1141' and not msc.played and msc.tour_sch = tsc.id and tsc.day >= 11386 group by tsc.id order by day asc
error: Out of resources when opening file './fb/tournament_schedule.MYD' (Errcode: 24) |
|
