Query Access Control Schedules

SELECT s.name as "Panel", s.nSCPId as "SCP", lookupSCP.description as "Controller", a.name as "Door", lookupSIO.description as "Interface", dg.name as "Door Group", sch.name as "Auto-Unlock Schedule", COALESCE(dg.requireValidCardRead, '') as "Valid Card Read", COALESCE(dg.enableLockdown, '') as "Allow Lockdown", COALESCE(dg.isLockedDown, '') as "Is Locked Down", COALESCE(sch.scheduleID, '') as "Schedule ID", COALESCE(format(DATEADD(ms,t.startTime*60000,0), 'hh:mm tt'), '') as "Schedule Start", COALESCE(format(DATEADD(ms,t.endTime*60000,0), 'hh:mm tt'), '') as "Schedule End", COALESCE(t.sunday, '') as "SUN", COALESCE(t.monday, '') as "MON", COALESCE(t.tuesday, '') as "TUE", COALESCE(t.wednesday, '') as "WED", COALESCE(t.thursday, '') as "THU", COALESCE(t.friday, '') as "FRI", COALESCE(t.saturday, '') as "SAT", COALESCE(h.name, '') as "HOLIDAY", COALESCE(format(h.startDate, 'MM/dd/yyyy'), '') as Date, COALESCE(h.duration+1, '') as "Duration" FROM dbo.Schedule as sch FULL OUTER JOIN dbo.DoorGroup as dg ON dg.autounlockScheduleUID=sch.scheduleUID FULL OUTER JOIN dbo.DoorGroupMembership as dgm ON dgm.doorGroupUID=dg.doorGroupUID FULL OUTER JOIN dbo.ACR as a on a.acrUID=dgm.acrUID LEFT JOIN dbo.SCP as s on s.SCPUID = a.scpUID LEFT JOIN dbo.TimeInterval as t on t.scheduleUID = sch.scheduleUID LEFT JOIN dbo.Holiday as h on t.HolidayTypeUID = h.holidayTypeUID FULL OUTER JOIN dbo.LookupSCPModelType as lookupSCP on lookupSCP.lookupSCPModelTypeUID = s.lookupSCPModelTypeUID FULL OUTER JOIN dbo.SIO as si on si.scpUID = s.SCPUID FULL OUTER JOIN dbo.LookupSIOModelType as lookupSIO on lookupSIO.lookupSIOModelTypeUID = si.lookupSIOModelTypeUID ORDER BY s.nSCPId, a.acr_number, a.acrID