select
evTitle as 'name',
concat(description,"\n",url) as description,
CASt(CONCAT(CAST(startDate as char),' ',cast(startTime as CHAR)) as datetime) as dtstart,
CASt(CONCAT(CAST(endDate as char),' ',cast(endTime as CHAR)) as datetime) as dtend,
evVenue as location,
evAddress as street,
evCity as city,
evState as state,
cast(NOW() as datetime) as modified_at,
cast(dateEntered as datetime ) as created_at,
'1' as author,
'127.0.0.1' as author_ip
from FTDevents;