select 
allday as 'ganztaegiges ereigniss', 
DATE_FORMAT(start, '%Y-%m-%d') as 'beginnt am',
DATE_FORMAT(start, '%T') as 'beginnt um', 
DATE_FORMAT(end, '%Y-%m-%d') as 'endet am',
DATE_FORMAT(end, '%T') as 'endet um', 
subject as 'betreff',
location as 'ort',
description as 'beschreibung',
cr.caption
FROM appointment
LEFT JOIN appointment_resource ar ON ar.appointment_id = appointment.id
LEFT JOIN calendar_resource cr ON cr.id = ar.resource_id
INNER JOIN instance_properties ip ON ip.object_id = appointment.id AND ip.instance_id = 4
WHERE
appointment.private = 0 AND appointment.recurrence_type = 0 AND ip.deleted = 0