Оптимизация запроса, выдающего суточные показания на определённых датчиках (по recordID) в одной таблице

SET dateformat dmy
DECLARE @dt datetime
SET @dt= getdate()
SELECT t1.dt1, t1.c125, t2.c129, t3.c133, t4.c137, t5.c185
FROM
(SELECT datepart(HOUR,dt) AS dt1, val AS c125
FROM std.dbo.test1dhour
WHERE (DAY(dt)=DAY(@dt)AND MONTH(dt)=MONTH(@dt)AND YEAR(dt)= YEAR(@dt) AND datepart(HOUR,dt)>0 OR dt=dateadd(DAY,1,@dt)) AND recordID=125) t1,
(SELECT datepart(HOUR,dt) AS dt1, val AS c129
FROM std.dbo.test1dhour
WHERE (DAY(dt)=DAY(@dt)AND MONTH(dt)=MONTH(@dt)AND YEAR(dt)= YEAR(@dt) AND datepart(HOUR,dt)>0 OR dt=dateadd(DAY,1,@dt)) AND recordID=129) t2,
(SELECT datepart(HOUR,dt) AS dt1, val AS c133
FROM std.dbo.test1dhour
WHERE (DAY(dt)=DAY(@dt)AND MONTH(dt)=MONTH(@dt)AND YEAR(dt)= YEAR(@dt) AND datepart(HOUR,dt)>0 OR dt=dateadd(DAY,1,@dt)) AND recordID=123) t3,
(SELECT datepart(HOUR,dt) AS dt1, val AS c137
FROM std.dbo.test1dhour
WHERE (DAY(dt)=DAY(@dt)AND MONTH(dt)=MONTH(@dt)AND YEAR(dt)= YEAR(@dt) AND datepart(HOUR,dt)>0 OR dt=dateadd(DAY,1,@dt)) AND recordID=137) t4,
(SELECT datepart(HOUR,dt) AS dt1, val AS c185
FROM std.dbo.test1dhour
WHERE (DAY(dt)=DAY(@dt)AND MONTH(dt)=MONTH(@dt)AND YEAR(dt)= YEAR(@dt) AND datepart(HOUR,dt)>0 OR dt=dateadd(DAY,1,@dt)) AND recordID=129) t5
WHERE t1.dt1=t2.dt1 AND t1.dt1=t3.dt1 AND t1.dt1=t4.dt1 AND t1.dt1=t5.dt1 
ORDER BY dt1