select venue_featured.id as venue_featured_id,
venue_featured.id,
venue_featured.tier,
venue.id as venue_id,
venue.*,
venue.id as venue,
venue.id as vibe,
venue.id as venue_music,
venue.name as venue_name,
venue.address1,
venue.city,
venue.state,
venue.zip,
venue.description,
venue.place_type,
venue.music
from venue_featured
LEFT JOIN venue on venue_featured.venue_id = venue.id and venue.active = 1
where venue_featured.active = 1 and venue.market_id = 10
and ( venue.name ilike 'Eddie's Attic%' or venue.name ilike '% Eddie's Attic%' )
order by tier asc, random()
ERROR: syntax error at or near "s" at character 519
