|
| ИД | Дата | Турнир | Тур | МатчQuery:
select * from (select msc.id as id, tm_h.name as hosts_name, tm_g.name as guests_name, mst.goals_h as goals_h, mst.goals_g as goals_g, tm_h.id as hosts, tm_g.id as guests, 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, ss.season from match_schedule msc, match_statistics mst, tournament_schedule tsc, teams tm_h, teams tm_g, days d, tournament_stages tst, tournament_groups_stages tgs, tournament_gr_st_participants tgsp, seasons ss where msc.hosts = '120' and tm_h.id = '120' and tm_g.id = '116' and msc.guests = '116' and tm_h.id != tm_g.id 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 = '120' and msc.played and mst.game = msc.id and msc.tour_sch = tsc.id and tst.season = ss.season and tgs.season = ss.season and tgsp.season = ss.season and d.day <= ss.end_day and d.day >= ss.start_day union select msc.id as id, tm_h.name as hosts_name, tm_g.name as guests_name, mst.goals_h as goals_h, mst.goals_g as goals_g, tm_h.id as hosts, tm_g.id as guests, 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, ss.season from match_schedule msc, match_statistics mst, tournament_schedule tsc, teams tm_h, teams tm_g, days d, tournament_stages tst, tournament_groups_stages tgs, tournament_gr_st_participants tgsp, seasons ss where msc.guests = '120' and tm_g.id = '120' and tm_h.id = '116' and msc.hosts = '116' and tm_h.id != tm_g.id 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 = '120' and msc.played and mst.game = msc.id and msc.tour_sch = tsc.id and tst.season = ss.season and tgs.season = ss.season and tgsp.season = ss.season and d.day <= ss.end_day and d.day >= ss.start_day order by day desc /*limit 0, 30*/ ) as lstgames order by day asc
error: Can't open file: './fb_arc/tournament_schedule.frm' (errno: 24) |
|
