= $P{startDate} AND acts.activity_start_time <= date_add($P{endDate}, INTERVAL "23:59:59" HOUR_SECOND) AND (acts.arch_short_name LIKE "act.customerAccount%item") GROUP BY entities.`name` ORDER BY entities.`name` ASC) AS ct ON (ct.ct_clinician_name=entities1.`name`) WHERE acts.arch_short_name = "act.customerAppointment" AND acts.activity_start_time >= $P{startDate} AND acts.activity_start_time <= date_add($P{endDate}, INTERVAL "23:59:59" HOUR_SECOND) ORDER BY clinician_name, appt_day, appt_time]]>