Database error: Invalid SQL: select distinct e.*, sg.stars, s.suburb_name from establishment e inner join establishment_suburb es ON es.establishment_id = e.establishment_id and es.default_ind = 1 inner join suburb s on s.suburb_id = es.suburb_id inner join region_suburb rs on rs.region_id = r.region_id and s.suburb_id = rs.suburb_id inner join region r inner join star_grading sg on sg.star_grading_id = e.star_grading_id where r.region_id = 69 and e.published_ind = 1 order by e.establishment_name
MySQL Error: 1054 (Unknown column 'r.region_id' in 'on clause')