SQL Server time processing self-connect

--Delayed orders
Select
T1. OrderId order1, T1. Verifystatusid id1,t1. Verifydate ' time 1 ',
T2. OrderId Order2, T2. Verifystatusid Id2,t2. Verifydate ' Time 2 ',
T1. Verifystatus ' State 1 ',
T2. Verifystatus ' State 2 ',
DateDiff (n, T2. Verifydate,t1. verifydate) ' Delay '
From T_verifysituation T1, T_verifysituation T2
where 1 =1
and (t1. Verifystatusid>t2. VERIFYSTATUSID)
and (t1. Orderid=t2. ORDERID)
and (DateDiff (d, T2. Verifydate,t1. Verifydate) >1)--Growing up in one day
and
(
(T2. verifystatus=3024 and T1. verifystatus=3013) or--Trial time
(T2. verifystatus=3013 and T1. verifystatus=3018) or--of Final appeal
(T2. verifystatus=3018 and T1. VERIFYSTATUS=1008) or--Comprehensive Assessment
(T2. verifystatus=1019 and T1. verifystatus=1010)--time of reconsideration
)

SQL Server time processing self-connect