|
 Кливленд (Кливленд, США) |
|---|
| | | | Последние матчи | Query:
select * from (select msc.id as id, tm_h.name as hosts_name, tm_g.name as guests_name,
tm_h.roster_name as hosts_roster_name, tm_g.roster_name as guests_roster_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,
t.short_name as tour_short_name, t.name as tour_name
from match_schedule msc, match_statistics mst,
tournament_schedule tsc, teams tm_h, teams tm_g, days d,
tournament_stages tst, tournaments t
where msc.hosts = '461' and tm_h.id = '461' and tm_g.id = msc.guests
and tm_h.id != tm_g.id and tsc.day = d.day
and tsc.tour_stage = tst.id and tst.tournament = t.id
and msc.played and mst.game = msc.id and msc.tour_sch = tsc.id
union select msc.id as id, tm_h.name as hosts_name, tm_g.name as guests_name,
tm_h.roster_name as hosts_roster_name, tm_g.roster_name as guests_roster_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,
t.short_name as tour_short_name, t.name as tour_name
from match_schedule msc, match_statistics mst,
tournament_schedule tsc, teams tm_h, teams tm_g, days d,
tournament_stages tst, tournaments t
where msc.guests = '461' and tm_g.id = '461' and tm_h.id = msc.hosts
and tm_h.id != tm_g.id and tsc.day = d.day
and tsc.tour_stage = tst.id and tst.tournament = t.id
and msc.played and mst.game = msc.id and msc.tour_sch = tsc.id
order by day desc limit 0, 4
) as lstgames order by day asc
error: Out of resources when opening file './fb/teams.MYD' (Errcode: 24)
|
|
|
|
