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