SELECT o.ID, OrderNumber,convert(varchar,oa.DateTime_Start,103) as 'Afspraak',icn.NomenclatureNumber, icn.Code, icn.PercentSupplement,icn.NomenclatureDescription
FROM RIS.dbo.tblorder AS o
INNER JOIN RIS.dbo.tblOrder_Procedure AS op ON o.ID = op.Order_UID
INNER JOIN RIS.dbo.tblProcedure AS pr ON op.Procedure_UID = pr.ID
INNER JOIN RIS.dbo.tblModality AS mo ON pr.Modality_UID = mo.ID
inner join INVOICE.dbo.tblInvoice_ConfirmedNomenclature icn on icn.Invoice_UID = o.Invoice_EUID
inner join RIS.dbo.tblOrder_Appointment oa on oa.Order_UID = o.ID
WHERE oa.DateTime_Start between convert(datetime, '01/02/2024', 103) and dateadd(d, 1, convert(datetime, '29/02/2024', 103))
    AND  mo.Name IN ('CT', 'MR') 
 AND DATEPART(dw, oa.DateTime_Start) BETWEEN 2 AND 6
    AND CONVERT(TIME, oa.DateTime_Start) BETWEEN '08:00:00' AND '18:00:00'
 AND oa.DateTime_Start not in (select DATE from RIS.dbo.tblHoliday)
 --AND icn.SupplementType is not null
 AND o.Deleted = '0'
 and o.Status_UID !='10'
 and o.Status_UID = '6'
 and o.Site_UID = '3'
 and o.PatientAH = 'A'
 and icn.Code in (select Code from RIS.dbo.tblProcedure where Modality_UID in (4,6))
 and PercentSupplement != '0' 
 and PercentSupplement is not NULL
 and OrderNumber = '20231123002'
 and icn.NomenclatureNumber = '1006'
 and oa.Deleted = '0'
ORDER BY o.DateTime_Prescription ASC;