Last SQL Query:
select a.name, a.type, a.slug, a.id,
c.city_name, ct.display_name, a.username, s.state_name,
ct.slug as category_slug, s.slug as state_slug, c.slug as city_slug
from artists a
join cities c on c.id=a.city_id
join states s on s.id=c.state_id
join categories ct on ct.cat_id=a.subcat_id
where a.subcat_id in (133,)
and a.status='1'
order by a.name
Error:
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 a.status='1'
order by a.name' at line 15