No valid database connection 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 showing.published = 1 AND showing.publish_up <= NOW()
ORDER BY location.' at line 5 SQL=SELECT DISTINCT location.*, showing.event_id AS event_id
FROM jos_grokevent_location AS location
LEFT JOIN jos_grokevent_showing AS showing ON showing.location_id = location.id
LEFT JOIN jos_grokevent AS event ON event.id = showing.event_id
WHERE event.id IN () AND showing.published = 1 AND showing.publish_up <= NOW()
ORDER BY location.title

