Database error: Invalid SQL: select distinct
e.establishment_id
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 establishment_category ec
on ec.establishment_id = e.establishment_id
and ec.establishment_id = es.establishment_id
where ec.category_id = 52
and s.suburb_id =
and e.published_ind = 1
group by e.establishment_name
order by e.establishment_id
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and e.published_ind = 1
group by e.establishment_name
order by e.es' at line 13)