with li as (select * from [Orion].dbo.pList), ld as (select *, row_number() over( partition by HozOrgan order by TimeVal desc) as n
               from [Orion].dbo.pLogData 
               where(CONVERT(date, dbo.pLogData.TimeVal) BETWEEN  '2021-03-24 16:00:00' AND '2021-03-25 01:00:00')
			         and [Orion].dbo.pLogData.Remark in ('1: Выход   Проходная № 1', '2: Выход   Проходная № 2')
					 and [Orion].dbo.pLogData.HozOrgan in (2158,1173,357,773,7538,1172,753,1941,1991,1901,103,1713,1929,2016,1940,1917,1226,1376,312,1695,245,1607,353,1957,10,1718,1719,2015,
776,2212,2004,1841,1174,853,2012,939,536,562,1818,1416,35,1936,1140,1176,2006,308,1228,995,1419,649,1443,2009,804,2,2058,2014,2036,805,1371,1768,
2005,1707,1243,33,197,1605,1374,523,1446,984,2001,315,1292,1439,1337,1878,305,2008,1418) 
	)
   , pd as ( select * from [Orion].dbo.PDivision )
   select li.Name, li.MidName, li.FirstName, ld.TimeVal AS DataTime, ld.Remark AS Department, pd.Name AS Division 
     from ld 
	      left outer join li on li.ID = ld.HozOrgan
	      left outer join pd on pd.ID = li.Section
	 where ld.n =1  and li.Company='2'
ORDER BY DataTime