select ordernumber,oa.DateTime_Start,op.DateTime_Planned
from ris.dbo.tblorder_appointment oa
inner join Ris.dbo.tblOrder_Procedure op on op.order_uid = oa.Order_UID
inner join Ris.dbo.tblorder o on o.id = op.order_uid 
inner join Ris.dbo.tblProcedure pr on pr.id = op.procedure_uid
where YEAR(DateTime_Start) >= '2024'
and DateTime_Start >= '2024-02-01 00:00:00.000'
and op.DateTime_Planned is NULL 
and op.Removed = '0'
and o.Deleted = '0'
and pr.modality_uid in ('4','6')
ORDER BY oa.DateTime_Start