|
| | | |
|
Query:
select st.name as stadium_name,
st.capacity as stadium_capacity, rf.name as referee_name, tn.name as ref_town_name,
hosts, guests, tst.ref_rules, c.name as ref_nation_name, ticket_price,
tm.country as tm_country, rf.nation as rf_nation, msc.temperature, msc.weather,
stn.name as stad_town_name
from match_schedule msc, stadiums st, teams tm, referees rf, seasons ss
left join towns tn on (tn.id = rf.town), tournament_schedule tsc,
tournament_stages tst, countries c, towns stn
where msc.id = 136892 and st.id = msc.venue and rf.id = msc.referee
and tsc.id = msc.tour_sch and tst.id = tsc.tour_stage and rf.nation = c.id
and tm.id = msc.hosts and (tsc.day <= ss.end_day
and tsc.day >= ss.start_day or ss.end_day is null) and tst.season = ss.season
and st.town = stn.id
error: Unknown column 'rf.town' in 'on clause' |
|
