
error in query: You have an error in your SQL syntax near ')' at line 21
SELECT
s.*,
COALESCE(s.EventTitle, e.display_title) as EventTitle,
COALESCE(sy, start_year) as start_year,
COALESCE(sm, start_month) as start_month,
COALESCE(sd, start_day) as start_day,
COALESCE(ey, end_year) as end_year,
COALESCE(em, end_month) as end_month,
COALESCE(ed, end_day) as end_day,
venue_details,
phone,
fax,
email,
website
FROM Story s LEFT JOIN events e
ON e.eventid = s.EventId
AND e.published = 1
WHERE
s.published = 1
AND
s.StoryId IN ()