|
| | | |
|
Query:
select md.*, msc.hosts, msc.guests,
st1.short_name st_name_h, st2.short_name st_name_g, ag1.short_name ag_name_h,
ag2.short_name ag_name_g, pr1.short_name pr_name_h, pr2.short_name pr_name_g
from match_schedule msc, match_details md, match_settings mse1,
match_settings mse2, styles st1, styles st2, aggressivenesses ag1,
aggressivenesses ag2, pressings pr1, pressings pr2
where md.game = 1126205 and msc.id = 1126205
and mse1.game = 1126205 and mse2.game = 1126205
and st1.id = mse1.style and st2.id = mse2.style
and ag1.id = mse1.aggressiveness and ag2.id = mse2.aggressiveness
and pr1.id = mse1.pressing and pr2.id = mse2.pressing
and mse1.team = msc.hosts and mse2.team = msc.guests
error: Can't open file: './fb/match_details.frm' (errno: 24) |
|
