Database error: Invalid SQL: select distinct
e.*,
if(if(min_price is null, '0', min_price)=0, 'Not Specified', min_price) minimum_price,
if(if(max_price is null, '0', max_price)=0, 'Not Specified', max_price) maximum_price,
sg.stars,
s.suburb_name,
1 sort_order
from establishment e
inner join establishment_suburb es
ON es.establishment_id = e.establishment_id
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 = 96
and e.published_ind = 1
and e.german_url IS NOT NULL
group by e.establishment_name
UNION
select distinct
e.*,
if(if(min_price is null, '0', min_price)=0, 'Not Specified', min_price) minimum_price,
if(if(max_price is null, '0', max_price)=0, 'Not Specified', max_price) maximum_price,
sg.stars,
s.suburb_name,
2 sort_order
from establishment e
inner join establishment_suburb es
ON es.establishment_id = e.establishment_id
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 = 96
and e.published_ind = 1
and e.german_url IS NULL
group by e.establishment_name
order by sort_order, establishment_name ASC
MySQL Error: 1054 (Unknown column 'r.region_id' in 'on clause')