I noticed the unnecessary 'event's, I was gonna tackle them in any rewrite.
And yes, the error is likely from that comma. It's always the tiny symbols you don't notice that cause the most trouble eh.
In case it's not clear, this is the tidy rewrite of that code:
Code:
SELECT calendarid, dateline_from, title, lv_vb_eventforums_threadid, customfields
FROM event
WHERE dateline_from >= 1156455695 AND calendarid = 1
ORDER BY dateline_from