select i.`calitemId` as `calitemId`, i.`name` as `name`, i.`description` as `description`, i.`start` as `start`, i.`end` as `end`, i.`url` as `url`, i.`status` as `status`, i.`priority` as `priority`, c.`name` as `calname`, i.`calendarId` as `calendarId`, i.`locationID` as `locationID`, i.`categoryID` as `categoryID`, i.`nlId` as `nlId` from `tiki_calendar_items` as i left join `tiki_calendars` as c on i.`calendarId`=c.`calendarId` where ((i.`calendarId`=?) and ((i.`start` > ? and i.`end` < ?) or (i.`start` < ? and i.`end` > ?)) and ((c.`personal`='y' and i.`user`=?) or c.`personal` != 'y')) order by `start` asc