HI

```SELECT        UJ.JobID, UJ.UserID, UJ.DriverID, UJ.VehicleID, UJ.SubscriberServiceID, UJ.ProviderID, U.SubscriberID, UJ.TrackingTypeID, UJ.Date, UJ.State, UJ.AppointmentTime, UJ.DateCreated, FROM_UA.Name AS FromAddress,
                         FROM_UA.Postcode AS From_PostCode, TO_UA.Name AS ToAddress, TO_UA.Postcode AS To_PostCode, SE.Name AS ServiceName, S.Name AS SubscriberName, P.Name AS ProviderName, V.RegistrationNumber,
                         V.VehicleMake, V.VehicleModel, V.VehicleColour, ISNULL(V.WheelChairAccessible, 0) AS WheelChairAccessible, DRIVER.Forenames AS DriverFornames, DRIVER.Surname AS DriverSurname, TT.TrackingType, UJ.JourneyTime,
                         UJ.JourneyDistance, UJ.JourneyDuration, UJ.PickUpTime, CASE WHEN UJ.TrackingTypeID = 6 THEN CASE WHEN JT.StartTime IS NOT NULL THEN JT.StartTime ELSE UJ.AppointmentTime END ELSE NULL
                         END AS CompletedTime, CASE WHEN (CASE WHEN UJ.TrackingTypeID = 6 THEN CASE WHEN JT.StartTime IS NOT NULL THEN JT.StartTime ELSE UJ.AppointmentTime END ELSE UJ.AppointmentTime END)
                         <= UJ.AppointmentTime THEN 1 ELSE 0 END AS CompletedOnTime, ABS(UJ.UnitID) AS UnitID, UJ.FromAddress AS FromUserAddressID, UJ.ToAddress AS ToUserAddressID, UJ.RequiresWheelChairVehicle,
                         CASE WHEN UJ.[State] = 3 THEN 1 ELSE 0 END AS Cancelled, PA.Forenames + ' ' + PA.Surname AS PatientName, UJ.JobChainID, UJ.ReferrerID, CASE WHEN UJ.ReferrerID > 0 THEN 1 ELSE 0 END AS CreatedByReferrer,
                         UJ.ContractID, UJ.PickUpOrder, UJ.DestinationOrder, CASE WHEN JTEnRoute.JobID IS NOT NULL AND JTEnRoute.TrackingFile IS NOT NULL THEN 1 ELSE 0 END AS TrackingDataAvailable, SE.ServiceID AS UJServiceID,
                         UJ.CancelledReason, UJ.CancelledByUserID, CU.Forenames + ' ' + CU.Surname AS CancelledBy, CASE WHEN UJ.UserID = UJ.CancelledByUserID THEN 1 ELSE 0 END AS CancelledByPatient, UJ.CancelledDate,
                         UJ.CancellationReasonID, CR.CancellationReason, UJ.JobTypeID, RJT.JobType, UJ.Notes, UJ.VisitDuration, UJ.VisitTimescale, V.CallSign, UJ.BlockBookingScheduleID,
                         CASE WHEN UJ.ToAddress < 0 THEN 1 ELSE 0 END AS JourneyToUnit, ISNULL(JTStart.StartTime, UJ.AppointmentTime) AS StartTime, 0 AS IsMultiJob, UJ.BuyerID
FROM            dbo.UserJobs AS UJ INNER JOIN
                         dbo.[User] AS PA ON UJ.UserID = PA.UserID INNER JOIN
                         dbo.vwUserAddresses AS FROM_UA ON UJ.FromAddress = FROM_UA.UserAddressID AND UJ.UserID = FROM_UA.UserID INNER JOIN
                         dbo.vwUserAddresses AS TO_UA ON UJ.ToAddress = TO_UA.UserAddressID AND UJ.UserID = TO_UA.UserID LEFT OUTER JOIN
                         dbo.Provider AS P ON P.ProviderID = UJ.ProviderID LEFT OUTER JOIN
                         dbo.Vehicle AS V ON V.VehicleID = UJ.VehicleID LEFT OUTER JOIN
                         dbo.[User] AS DRIVER ON UJ.DriverID = DRIVER.UserID LEFT OUTER JOIN
                         dbo.ref_TrackingType AS TT ON TT.TrackingTypeID = UJ.TrackingTypeID LEFT OUTER JOIN
                             (SELECT        JobTrackingID, JobID, TrackingTypeID, TrackingData, TrackingFile, DateCreated, JobChainID, TotalDistance, TotalDuration, TotalTime, StartTime, EndTime, Notes, CreatedByID, CreatedByDriver
                               FROM            dbo.Job_Tracking
                               WHERE        (TrackingTypeID = 5)) AS JT ON UJ.JobID = JT.JobID LEFT OUTER JOIN
                             (SELECT        JobTrackingID, JobID, TrackingTypeID, TrackingData, TrackingFile, DateCreated, JobChainID, TotalDistance, TotalDuration, TotalTime, StartTime, EndTime, Notes, CreatedByID, CreatedByDriver
                               FROM            dbo.Job_Tracking
                               WHERE        (TrackingTypeID = 4)) AS JTEnRoute ON UJ.JobID = JTEnRoute.JobID LEFT OUTER JOIN
                             (SELECT        JobTrackingID, JobID, TrackingTypeID, TrackingData, TrackingFile, DateCreated, JobChainID, TotalDistance, TotalDuration, TotalTime, StartTime, EndTime, Notes, CreatedByID, CreatedByDriver
                               FROM            dbo.Job_Tracking
                               WHERE        (TrackingTypeID = 2)) AS JTStart ON UJ.JobID = JTStart.JobID INNER JOIN
                         dbo.Unit AS U ON UJ.UnitID = U.UnitID INNER JOIN
                         dbo.Subscriber AS S ON U.SubscriberID = S.SubscriberID INNER JOIN
                         dbo.Service AS SE ON U.ServiceID = SE.ServiceID LEFT OUTER JOIN
                         dbo.[User] AS CU ON UJ.CancelledByUserID = CU.UserID LEFT OUTER JOIN
                         dbo.ref_CancellationReason AS CR ON UJ.CancellationReasonID = CR.CancellationReasonID INNER JOIN
                         dbo.ref_JobType AS RJT ON UJ.JobTypeID = RJT.JobTypeID```