—-Req_list_statistic_by_aot
Select 
  [HN], 
  [LN], 
  [FULLNAME], 
  [YEAR], 
  [SEX], 
  [WARD NAME], 
  [SOURCE NAME], 
  [PRIORITY], 
  [REQ ITEM CHECKIN DATETIME], 
  [REQ ITEM NAME], 
  [REQ ITEM GROUP NAME], 
  [REQ ITEM CODE], 
  [ISP TEXT] 
From 
  view_lab_statistic_Order_List 
Where 
  (
    [req item checkin datetime] between @d1 
    and @d2
  ) 
  And ([order inactive] <> 'Y') 
  And ([req item state] <> 'R') 
  And ([TEST INACTIVE] <> '1') 
  And (
    [REQ ITEM CHECKIN DATETIME] is not null
  ) 
  And (
    [REQ ITEM CHECKIN STAFF CODE] is not null
  ) 
  And ([req item countable] = '1') 
Order By 
  ln, 
  [req item group seq], 
  [req item seq]