clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1044295 fiddles created (9414 in the last week).

CREATE TABLE #Example ( UniqueID INT IDENTITY(1,1) , GroupID INT , GroupDate DATETIME , UniqueDate DATETIME ) SET NOCOUNT ON --Populate some test data DECLARE @i INT = 0, @j INT = 5, @UniqueDate DATETIME, @GroupDate DATETIME WHILE @i < 100000 BEGIN IF((@i + @j)%173 = 0) BEGIN SET @UniqueDate = GETDATE()+@i+5 END ELSE BEGIN SET @UniqueDate = GETDATE()+@i END SET @GroupDate = GETDATE()+(@j-1) INSERT INTO #Example (GroupID, GroupDate, UniqueDate) VALUES (@j, @GroupDate, @UniqueDate) SET @i = @i + 1 IF (@i % 5 = 0) BEGIN SET @j = @j+5 END END CREATE CLUSTERED INDEX cx_whatever ON #Example (GroupID) CREATE UNIQUE NONCLUSTERED INDEX ix_GroupId_UniqueDate_DESC_GroupDate ON #Example (GroupID, UniqueDate DESC, GroupDate) CREATE NONCLUSTERED INDEX ix_UniqueDate_GroupDate ON #Example (UniqueDate,GroupDate) INCLUDE (UniqueID,GroupID); CREATE INDEX ix_GroupId_UniqueDate_Cover ON #Example (GroupID, UniqueDate) INCLUDE (UniqueID, GroupDate); SET NOCOUNT OFF
 hidden batch(es)


set statistics time, io, xml on; -- Identify any UniqueDates that are greater than the GroupDate within their GroupID SELECT UniqueID , GroupID , GroupDate , UniqueDate FROM ( SELECT UniqueID , GroupID , GroupDate , UniqueDate , MAX(UniqueDate) OVER (PARTITION BY GroupID) AS maxUniqueDate FROM #Example ) calc_maxUD WHERE maxUniqueDate > GroupDate AND maxUniqueDate = UniqueDate
UniqueID GroupID GroupDate UniqueDate
172 175 05/10/2017 21:18:35 07/10/2017 21:18:35
260 260 29/12/2017 21:18:35 03/01/2018 21:18:35
431 435 22/06/2018 21:18:35 23/06/2018 21:18:35
519 520 15/09/2018 21:18:35 19/09/2018 21:18:35
778 780 02/06/2019 21:18:35 05/06/2019 21:18:35
1037 1040 17/02/2020 21:18:35 19/02/2020 21:18:35
1125 1125 12/05/2020 21:18:35 17/05/2020 21:18:35
1296 1300 03/11/2020 21:18:35 04/11/2020 21:18:35
1384 1385 27/01/2021 21:18:35 31/01/2021 21:18:35
1643 1645 14/10/2021 21:18:35 17/10/2021 21:18:35
1902 1905 01/07/2022 21:18:35 03/07/2022 21:18:35
1990 1990 24/09/2022 21:18:35 29/09/2022 21:18:35
2161 2165 18/03/2023 21:18:35 19/03/2023 21:18:35
2249 2250 11/06/2023 21:18:35 15/06/2023 21:18:35
2508 2510 26/02/2024 21:18:35 29/02/2024 21:18:35
2767 2770 12/11/2024 21:18:35 14/11/2024 21:18:35
2855 2855 05/02/2025 21:18:35 10/02/2025 21:18:35
3026 3030 30/07/2025 21:18:35 31/07/2025 21:18:35
3114 3115 23/10/2025 21:18:35 27/10/2025 21:18:35
3373 3375 10/07/2026 21:18:35 13/07/2026 21:18:35
3632 3635 27/03/2027 21:18:35 29/03/2027 21:18:35
3720 3720 20/06/2027 21:18:35 25/06/2027 21:18:35
3891 3895 12/12/2027 21:18:35 13/12/2027 21:18:35
3979 3980 06/03/2028 21:18:35 10/03/2028 21:18:35
4238 4240 21/11/2028 21:18:35 24/11/2028 21:18:35
4497 4500 08/08/2029 21:18:35 10/08/2029 21:18:35
4585 4585 01/11/2029 21:18:35 06/11/2029 21:18:35
4756 4760 25/04/2030 21:18:35 26/04/2030 21:18:35
4844 4845 19/07/2030 21:18:35 23/07/2030 21:18:35
5103 5105 05/04/2031 21:18:35 08/04/2031 21:18:35
5362 5365 21/12/2031 21:18:35 23/12/2031 21:18:35
5450 5450 15/03/2032 21:18:35 20/03/2032 21:18:35
5621 5625 06/09/2032 21:18:35 07/09/2032 21:18:35
5709 5710 30/11/2032 21:18:35 04/12/2032 21:18:35
5968 5970 17/08/2033 21:18:35 20/08/2033 21:18:35
6227 6230 04/05/2034 21:18:35 06/05/2034 21:18:35
6315 6315 28/07/2034 21:18:35 02/08/2034 21:18:35
6486 6490 19/01/2035 21:18:35 20/01/2035 21:18:35
6574 6575 14/04/2035 21:18:35 18/04/2035 21:18:35
6833 6835 30/12/2035 21:18:35 02/01/2036 21:18:35
7092 7095 15/09/2036 21:18:35 17/09/2036 21:18:35
7180 7180 09/12/2036 21:18:35 14/12/2036 21:18:35
7351 7355 02/06/2037 21:18:35 03/06/2037 21:18:35
7439 7440 26/08/2037 21:18:35 30/08/2037 21:18:35
7698 7700 13/05/2038 21:18:35 16/05/2038 21:18:35
7957 7960 28/01/2039 21:18:35 30/01/2039 21:18:35
8045 8045 23/04/2039 21:18:35 28/04/2039 21:18:35
8216 8220 15/10/2039 21:18:35 16/10/2039 21:18:35
8304 8305 08/01/2040 21:18:35 12/01/2040 21:18:35
8563 8565 24/09/2040 21:18:35 27/09/2040 21:18:35
8822 8825 11/06/2041 21:18:35 13/06/2041 21:18:35
8910 8910 04/09/2041 21:18:35 09/09/2041 21:18:35
9081 9085 26/02/2042 21:18:35 27/02/2042 21:18:35
9169 9170 22/05/2042 21:18:35 26/05/2042 21:18:35
9428 9430 06/02/2043 21:18:35 09/02/2043 21:18:35
9687 9690 24/10/2043 21:18:35 26/10/2043 21:18:35
9775 9775 17/01/2044 21:18:35 22/01/2044 21:18:35
9946 9950 10/07/2044 21:18:35 11/07/2044 21:18:35
10034 10035 03/10/2044 21:18:35 07/10/2044 21:18:35
10293 10295 20/06/2045 21:18:35 23/06/2045 21:18:35
10552 10555 07/03/2046 21:18:35 09/03/2046 21:18:35
10640 10640 31/05/2046 21:18:35 05/06/2046 21:18:35
10811 10815 22/11/2046 21:18:35 23/11/2046 21:18:35
10899 10900 15/02/2047 21:18:35 19/02/2047 21:18:35
11158 11160 02/11/2047 21:18:35 05/11/2047 21:18:35
11417 11420 19/07/2048 21:18:35 21/07/2048 21:18:35
11505 11505 12/10/2048 21:18:35 17/10/2048 21:18:35
11676 11680 05/04/2049 21:18:35 06/04/2049 21:18:35
11764 11765 29/06/2049 21:18:35 03/07/2049 21:18:35
12023 12025 16/03/2050 21:18:35 19/03/2050 21:18:35
12282 12285 01/12/2050 21:18:35 03/12/2050 21:18:35
12370 12370 24/02/2051 21:18:35 01/03/2051 21:18:35
12541 12545 18/08/2051 21:18:35 19/08/2051 21:18:35
12629 12630 11/11/2051 21:18:35 15/11/2051 21:18:35
12888 12890 28/07/2052 21:18:35 31/07/2052 21:18:35
13147 13150 14/04/2053 21:18:35 16/04/2053 21:18:35
13235 13235 08/07/2053 21:18:35 13/07/2053 21:18:35
13406 13410 30/12/2053 21:18:35 31/12/2053 21:18:35
13494 13495 25/03/2054 21:18:35 29/03/2054 21:18:35
13753 13755 10/12/2054 21:18:35 13/12/2054 21:18:35
14012 14015 27/08/2055 21:18:35 29/08/2055 21:18:35
14100 14100 20/11/2055 21:18:35 25/11/2055 21:18:35
14271 14275 13/05/2056 21:18:35 14/05/2056 21:18:35
14359 14360 06/08/2056 21:18:35 10/08/2056 21:18:35
14618 14620 23/04/2057 21:18:35 26/04/2057 21:18:35
14877 14880 08/01/2058 21:18:35 10/01/2058 21:18:35
14965 14965 03/04/2058 21:18:35 08/04/2058 21:18:35
15136 15140 25/09/2058 21:18:35 26/09/2058 21:18:35
15224 15225 19/12/2058 21:18:35 23/12/2058 21:18:35
15483 15485 05/09/2059 21:18:35 08/09/2059 21:18:35
15742 15745 22/05/2060 21:18:35 24/05/2060 21:18:35
15830 15830 15/08/2060 21:18:35 20/08/2060 21:18:35
16001 16005 06/02/2061 21:18:35 07/02/2061 21:18:35
16089 16090 02/05/2061 21:18:35 06/05/2061 21:18:35
16348 16350 17/01/2062 21:18:35 20/01/2062 21:18:35
16607 16610 04/10/2062 21:18:35 06/10/2062 21:18:35
16695 16695 28/12/2062 21:18:35 02/01/2063 21:18:35
16866 16870 21/06/2063 21:18:35 22/06/2063 21:18:35
16954 16955 14/09/2063 21:18:35 18/09/2063 21:18:35
17213 17215 31/05/2064 21:18:35 03/06/2064 21:18:35
17472 17475 15/02/2065 21:18:35 17/02/2065 21:18:35
17560 17560 11/05/2065 21:18:35 16/05/2065 21:18:35
17731 17735 02/11/2065 21:18:35 03/11/2065 21:18:35
17819 17820 26/01/2066 21:18:35 30/01/2066 21:18:35
18078 18080 13/10/2066 21:18:35 16/10/2066 21:18:35
18337 18340 30/06/2067 21:18:35 02/07/2067 21:18:35
18425 18425 23/09/2067 21:18:35 28/09/2067 21:18:35
18596 18600 16/03/2068 21:18:35 17/03/2068 21:18:35
18684 18685 09/06/2068 21:18:35 13/06/2068 21:18:35
18943 18945 24/02/2069 21:18:35 27/02/2069 21:18:35
19202 19205 11/11/2069 21:18:35 13/11/2069 21:18:35
19290 19290 04/02/2070 21:18:35 09/02/2070 21:18:35
19461 19465 29/07/2070 21:18:35 30/07/2070 21:18:35
19549 19550 22/10/2070 21:18:35 26/10/2070 21:18:35
19808 19810 09/07/2071 21:18:35 12/07/2071 21:18:35
20067 20070 25/03/2072 21:18:35 27/03/2072 21:18:35
20155 20155 18/06/2072 21:18:35 23/06/2072 21:18:35
20326 20330 10/12/2072 21:18:35 11/12/2072 21:18:35
20414 20415 05/03/2073 21:18:35 09/03/2073 21:18:35
20673 20675 20/11/2073 21:18:35 23/11/2073 21:18:35
20932 20935 07/08/2074 21:18:35 09/08/2074 21:18:35
21020 21020 31/10/2074 21:18:35 05/11/2074 21:18:35
21191 21195 24/04/2075 21:18:35 25/04/2075 21:18:35
21279 21280 18/07/2075 21:18:35 22/07/2075 21:18:35
21538 21540 03/04/2076 21:18:35 06/04/2076 21:18:35
21797 21800 19/12/2076 21:18:35 21/12/2076 21:18:35
21885 21885 14/03/2077 21:18:35 19/03/2077 21:18:35
22056 22060 05/09/2077 21:18:35 06/09/2077 21:18:35
22144 22145 29/11/2077 21:18:35 03/12/2077 21:18:35
22403 22405 16/08/2078 21:18:35 19/08/2078 21:18:35
22662 22665 03/05/2079 21:18:35 05/05/2079 21:18:35
22750 22750 27/07/2079 21:18:35 01/08/2079 21:18:35
22921 22925 18/01/2080 21:18:35 19/01/2080 21:18:35
23009 23010 12/04/2080 21:18:35 16/04/2080 21:18:35
23268 23270 28/12/2080 21:18:35 31/12/2080 21:18:35
23527 23530 14/09/2081 21:18:35 16/09/2081 21:18:35
23615 23615 08/12/2081 21:18:35 13/12/2081 21:18:35
23786 23790 01/06/2082 21:18:35 02/06/2082 21:18:35
23874 23875 25/08/2082 21:18:35 29/08/2082 21:18:35
24133 24135 12/05/2083 21:18:35 15/05/2083 21:18:35
24392 24395 27/01/2084 21:18:35 29/01/2084 21:18:35
24480 24480 21/04/2084 21:18:35 26/04/2084 21:18:35
24651 24655 13/10/2084 21:18:35 14/10/2084 21:18:35
24739 24740 06/01/2085 21:18:35 10/01/2085 21:18:35
24998 25000 23/09/2085 21:18:35 26/09/2085 21:18:35
25257 25260 10/06/2086 21:18:35 12/06/2086 21:18:35
25345 25345 03/09/2086 21:18:35 08/09/2086 21:18:35
25516 25520 25/02/2087 21:18:35 26/02/2087 21:18:35
25604 25605 21/05/2087 21:18:35 25/05/2087 21:18:35
25863 25865 05/02/2088 21:18:35 08/02/2088 21:18:35
26122 26125 22/10/2088 21:18:36 24/10/2088 21:18:36
26210 26210 15/01/2089 21:18:36 20/01/2089 21:18:36
26381 26385 09/07/2089 21:18:36 10/07/2089 21:18:36
26469 26470 02/10/2089 21:18:36 06/10/2089 21:18:36
26728 26730 19/06/2090 21:18:36 22/06/2090 21:18:36
26987 26990 06/03/2091 21:18:36 08/03/2091 21:18:36
27075 27075 30/05/2091 21:18:36 04/06/2091 21:18:36
27246 27250 21/11/2091 21:18:36 22/11/2091 21:18:36
27334 27335 14/02/2092 21:18:36 18/02/2092 21:18:36
27593 27595 31/10/2092 21:18:36 03/11/2092 21:18:36
27852 27855 18/07/2093 21:18:36 20/07/2093 21:18:36
27940 27940 11/10/2093 21:18:36 16/10/2093 21:18:36
28111 28115 04/04/2094 21:18:36 05/04/2094 21:18:36
28199 28200 28/06/2094 21:18:36 02/07/2094 21:18:36
28458 28460 15/03/2095 21:18:36 18/03/2095 21:18:36
28717 28720 30/11/2095 21:18:36 02/12/2095 21:18:36
28805 28805 23/02/2096 21:18:36 28/02/2096 21:18:36
28976 28980 16/08/2096 21:18:36 17/08/2096 21:18:36
29064 29065 09/11/2096 21:18:36 13/11/2096 21:18:36
29323 29325 27/07/2097 21:18:36 30/07/2097 21:18:36
29582 29585 13/04/2098 21:18:36 15/04/2098 21:18:36
29670 29670 07/07/2098 21:18:36 12/07/2098 21:18:36
29841 29845 29/12/2098 21:18:36 30/12/2098 21:18:36
29929 29930 24/03/2099 21:18:36 28/03/2099 21:18:36
30188 30190 09/12/2099 21:18:36 12/12/2099 21:18:36
30447 30450 26/08/2100 21:18:36 28/08/2100 21:18:36
30535 30535 19/11/2100 21:18:36 24/11/2100 21:18:36
30706 30710 13/05/2101 21:18:36 14/05/2101 21:18:36
30794 30795 06/08/2101 21:18:36 10/08/2101 21:18:36
31053 31055 23/04/2102 21:18:36 26/04/2102 21:18:36
31312 31315 08/01/2103 21:18:36 10/01/2103 21:18:36
31400 31400 03/04/2103 21:18:36 08/04/2103 21:18:36
31571 31575 25/09/2103 21:18:36 26/09/2103 21:18:36
31659 31660 19/12/2103 21:18:36 23/12/2103 21:18:36
31918 31920 04/09/2104 21:18:36 07/09/2104 21:18:36
32177 32180 22/05/2105 21:18:36 24/05/2105 21:18:36
32265 32265 15/08/2105 21:18:36 20/08/2105 21:18:36
32436 32440 06/02/2106 21:18:36 07/02/2106 21:18:36
32524 32525 02/05/2106 21:18:36 06/05/2106 21:18:36
32783 32785 17/01/2107 21:18:36 20/01/2107 21:18:36
33042 33045 04/10/2107 21:18:36 06/10/2107 21:18:36
33130 33130 28/12/2107 21:18:36 02/01/2108 21:18:36
33301 33305 20/06/2108 21:18:36 21/06/2108 21:18:36
33389 33390 13/09/2108 21:18:36 17/09/2108 21:18:36
33648 33650 31/05/2109 21:18:36 03/06/2109 21:18:36
33907 33910 15/02/2110 21:18:36 17/02/2110 21:18:36
33995 33995 11/05/2110 21:18:36 16/05/2110 21:18:36
34166 34170 02/11/2110 21:18:36 03/11/2110 21:18:36
34254 34255 26/01/2111 21:18:36 30/01/2111 21:18:36
34513 34515 13/10/2111 21:18:36 16/10/2111 21:18:36
34772 34775 29/06/2112 21:18:36 01/07/2112 21:18:36
34860 34860 22/09/2112 21:18:36 27/09/2112 21:18:36
35031 35035 16/03/2113 21:18:36 17/03/2113 21:18:36
35119 35120 09/06/2113 21:18:36 13/06/2113 21:18:36
35378 35380 24/02/2114 21:18:36 27/02/2114 21:18:36
35637 35640 11/11/2114 21:18:36 13/11/2114 21:18:36
35725 35725 04/02/2115 21:18:36 09/02/2115 21:18:36
35896 35900 29/07/2115 21:18:36 30/07/2115 21:18:36
35984 35985 22/10/2115 21:18:36 26/10/2115 21:18:36
36243 36245 08/07/2116 21:18:36 11/07/2116 21:18:36
36502 36505 25/03/2117 21:18:36 27/03/2117 21:18:36
36590 36590 18/06/2117 21:18:36 23/06/2117 21:18:36
36761 36765 10/12/2117 21:18:36 11/12/2117 21:18:36
36849 36850 05/03/2118 21:18:36 09/03/2118 21:18:36
37108 37110 20/11/2118 21:18:36 23/11/2118 21:18:36
37367 37370 07/08/2119 21:18:36 09/08/2119 21:18:36
37455 37455 31/10/2119 21:18:36 05/11/2119 21:18:36
37626 37630 23/04/2120 21:18:36 24/04/2120 21:18:36
37714 37715 17/07/2120 21:18:36 21/07/2120 21:18:36
37973 37975 03/04/2121 21:18:36 06/04/2121 21:18:36
38232 38235 19/12/2121 21:18:36 21/12/2121 21:18:36
38320 38320 14/03/2122 21:18:36 19/03/2122 21:18:36
38491 38495 05/09/2122 21:18:36 06/09/2122 21:18:36
38579 38580 29/11/2122 21:18:36 03/12/2122 21:18:36
38838 38840 16/08/2123 21:18:36 19/08/2123 21:18:36
39097 39100 02/05/2124 21:18:36 04/05/2124 21:18:36
39185 39185 26/07/2124 21:18:36 31/07/2124 21:18:36
39356 39360 17/01/2125 21:18:36 18/01/2125 21:18:36
39444 39445 12/04/2125 21:18:36 16/04/2125 21:18:36
39703 39705 28/12/2125 21:18:36 31/12/2125 21:18:36
39962 39965 14/09/2126 21:18:36 16/09/2126 21:18:36
40050 40050 08/12/2126 21:18:36 13/12/2126 21:18:36
40221 40225 01/06/2127 21:18:36 02/06/2127 21:18:36
40309 40310 25/08/2127 21:18:36 29/08/2127 21:18:36
40568 40570 11/05/2128 21:18:36 14/05/2128 21:18:36
40827 40830 26/01/2129 21:18:36 28/01/2129 21:18:36
40915 40915 21/04/2129 21:18:36 26/04/2129 21:18:36
41086 41090 13/10/2129 21:18:36 14/10/2129 21:18:36
41174 41175 06/01/2130 21:18:36 10/01/2130 21:18:36
41433 41435 23/09/2130 21:18:36 26/09/2130 21:18:36
41692 41695 10/06/2131 21:18:36 12/06/2131 21:18:36
41780 41780 03/09/2131 21:18:36 08/09/2131 21:18:36
41951 41955 25/02/2132 21:18:36 26/02/2132 21:18:36
42039 42040 20/05/2132 21:18:36 24/05/2132 21:18:36
42298 42300 04/02/2133 21:18:36 07/02/2133 21:18:36
42557 42560 22/10/2133 21:18:36 24/10/2133 21:18:36
42645 42645 15/01/2134 21:18:36 20/01/2134 21:18:36
42816 42820 09/07/2134 21:18:36 10/07/2134 21:18:36
42904 42905 02/10/2134 21:18:36 06/10/2134 21:18:36
43163 43165 19/06/2135 21:18:36 22/06/2135 21:18:36
43422 43425 05/03/2136 21:18:36 07/03/2136 21:18:36
43510 43510 29/05/2136 21:18:36 03/06/2136 21:18:36
43681 43685 20/11/2136 21:18:36 21/11/2136 21:18:36
43769 43770 13/02/2137 21:18:36 17/02/2137 21:18:36
44028 44030 31/10/2137 21:18:36 03/11/2137 21:18:36
44287 44290 18/07/2138 21:18:36 20/07/2138 21:18:36
44375 44375 11/10/2138 21:18:36 16/10/2138 21:18:36
44546 44550 04/04/2139 21:18:36 05/04/2139 21:18:36
44634 44635 28/06/2139 21:18:36 02/07/2139 21:18:36
44893 44895 14/03/2140 21:18:36 17/03/2140 21:18:36
45152 45155 29/11/2140 21:18:36 01/12/2140 21:18:36
45240 45240 22/02/2141 21:18:36 27/02/2141 21:18:36
45411 45415 16/08/2141 21:18:36 17/08/2141 21:18:36
45499 45500 09/11/2141 21:18:36 13/11/2141 21:18:36
45758 45760 27/07/2142 21:18:36 30/07/2142 21:18:36
46017 46020 13/04/2143 21:18:36 15/04/2143 21:18:36
46105 46105 07/07/2143 21:18:36 12/07/2143 21:18:36
46276 46280 29/12/2143 21:18:36 30/12/2143 21:18:36
46364 46365 23/03/2144 21:18:36 27/03/2144 21:18:36
46623 46625 08/12/2144 21:18:36 11/12/2144 21:18:36
46882 46885 25/08/2145 21:18:36 27/08/2145 21:18:36
46970 46970 18/11/2145 21:18:36 23/11/2145 21:18:36
47141 47145 12/05/2146 21:18:36 13/05/2146 21:18:36
47229 47230 05/08/2146 21:18:36 09/08/2146 21:18:36
47488 47490 22/04/2147 21:18:36 25/04/2147 21:18:36
47747 47750 07/01/2148 21:18:36 09/01/2148 21:18:36
47835 47835 01/04/2148 21:18:36 06/04/2148 21:18:36
48006 48010 23/09/2148 21:18:36 24/09/2148 21:18:36
48094 48095 17/12/2148 21:18:36 21/12/2148 21:18:36
48353 48355 03/09/2149 21:18:36 06/09/2149 21:18:36
48612 48615 21/05/2150 21:18:36 23/05/2150 21:18:36
48700 48700 14/08/2150 21:18:36 19/08/2150 21:18:36
48871 48875 05/02/2151 21:18:36 06/02/2151 21:18:36
48959 48960 01/05/2151 21:18:36 05/05/2151 21:18:36
49218 49220 16/01/2152 21:18:36 19/01/2152 21:18:36
49477 49480 02/10/2152 21:18:36 04/10/2152 21:18:36
49565 49565 26/12/2152 21:18:36 31/12/2152 21:18:36
49736 49740 19/06/2153 21:18:36 20/06/2153 21:18:36
49824 49825 12/09/2153 21:18:36 16/09/2153 21:18:36
50083 50085 30/05/2154 21:18:36 02/06/2154 21:18:36
50342 50345 14/02/2155 21:18:36 16/02/2155 21:18:36
50430 50430 10/05/2155 21:18:36 15/05/2155 21:18:36
50601 50605 01/11/2155 21:18:36 02/11/2155 21:18:36
50689 50690 25/01/2156 21:18:36 29/01/2156 21:18:36
50948 50950 11/10/2156 21:18:36 14/10/2156 21:18:36
51207 51210 28/06/2157 21:18:36 30/06/2157 21:18:36
51295 51295 21/09/2157 21:18:36 26/09/2157 21:18:36
51466 51470 15/03/2158 21:18:36 16/03/2158 21:18:36
51554 51555 08/06/2158 21:18:36 12/06/2158 21:18:36
51813 51815 23/02/2159 21:18:36 26/02/2159 21:18:36
52072 52075 10/11/2159 21:18:36 12/11/2159 21:18:36
52160 52160 03/02/2160 21:18:36 08/02/2160 21:18:36
52331 52335 27/07/2160 21:18:36 28/07/2160 21:18:36
52419 52420 20/10/2160 21:18:36 24/10/2160 21:18:36
52678 52680 07/07/2161 21:18:36 10/07/2161 21:18:36
52937 52940 24/03/2162 21:18:36 26/03/2162 21:18:36
53025 53025 17/06/2162 21:18:36 22/06/2162 21:18:36
53196 53200 09/12/2162 21:18:36 10/12/2162 21:18:36
53284 53285 04/03/2163 21:18:36 08/03/2163 21:18:36
53543 53545 19/11/2163 21:18:36 22/11/2163 21:18:36
53802 53805 05/08/2164 21:18:36 07/08/2164 21:18:36
53890 53890 29/10/2164 21:18:36 03/11/2164 21:18:36
54061 54065 22/04/2165 21:18:36 23/04/2165 21:18:36
54149 54150 16/07/2165 21:18:36 20/07/2165 21:18:36
54408 54410 02/04/2166 21:18:36 05/04/2166 21:18:36
54667 54670 18/12/2166 21:18:36 20/12/2166 21:18:36
54755 54755 13/03/2167 21:18:36 18/03/2167 21:18:36
54926 54930 04/09/2167 21:18:36 05/09/2167 21:18:36
55014 55015 28/11/2167 21:18:36 02/12/2167 21:18:36
55273 55275 14/08/2168 21:18:36 17/08/2168 21:18:36
55532 55535 01/05/2169 21:18:36 03/05/2169 21:18:36
55620 55620 25/07/2169 21:18:36 30/07/2169 21:18:36
55791 55795 16/01/2170 21:18:36 17/01/2170 21:18:36
55879 55880 11/04/2170 21:18:36 15/04/2170 21:18:36
56138 56140 27/12/2170 21:18:36 30/12/2170 21:18:36
56397 56400 13/09/2171 21:18:36 15/09/2171 21:18:36
56485 56485 07/12/2171 21:18:36 12/12/2171 21:18:36
56656 56660 30/05/2172 21:18:36 31/05/2172 21:18:36
56744 56745 23/08/2172 21:18:36 27/08/2172 21:18:36
57003 57005 10/05/2173 21:18:36 13/05/2173 21:18:36
57262 57265 25/01/2174 21:18:36 27/01/2174 21:18:36
57350 57350 20/04/2174 21:18:36 25/04/2174 21:18:36
57521 57525 12/10/2174 21:18:36 13/10/2174 21:18:36
57609 57610 05/01/2175 21:18:36 09/01/2175 21:18:36
57868 57870 22/09/2175 21:18:36 25/09/2175 21:18:36
58127 58130 08/06/2176 21:18:36 10/06/2176 21:18:36
58215 58215 01/09/2176 21:18:36 06/09/2176 21:18:36
58386 58390 23/02/2177 21:18:36 24/02/2177 21:18:36
58474 58475 19/05/2177 21:18:36 23/05/2177 21:18:36
58733 58735 03/02/2178 21:18:36 06/02/2178 21:18:36
58992 58995 21/10/2178 21:18:36 23/10/2178 21:18:36
59080 59080 14/01/2179 21:18:36 19/01/2179 21:18:36
59251 59255 08/07/2179 21:18:36 09/07/2179 21:18:36
59339 59340 01/10/2179 21:18:36 05/10/2179 21:18:36
59598 59600 17/06/2180 21:18:36 20/06/2180 21:18:36
59857 59860 04/03/2181 21:18:36 06/03/2181 21:18:36
59945 59945 28/05/2181 21:18:36 02/06/2181 21:18:36
60116 60120 19/11/2181 21:18:36 20/11/2181 21:18:36
60204 60205 12/02/2182 21:18:36 16/02/2182 21:18:36
60463 60465 30/10/2182 21:18:36 02/11/2182 21:18:36
60722 60725 17/07/2183 21:18:36 19/07/2183 21:18:36
60810 60810 10/10/2183 21:18:36 15/10/2183 21:18:36
60981 60985 02/04/2184 21:18:36 03/04/2184 21:18:36
61069 61070 26/06/2184 21:18:36 30/06/2184 21:18:36
61328 61330 13/03/2185 21:18:36 16/03/2185 21:18:36
61587 61590 28/11/2185 21:18:36 30/11/2185 21:18:36
61675 61675 21/02/2186 21:18:36 26/02/2186 21:18:36
61846 61850 15/08/2186 21:18:36 16/08/2186 21:18:36
61934 61935 08/11/2186 21:18:36 12/11/2186 21:18:36
62193 62195 26/07/2187 21:18:36 29/07/2187 21:18:36
62452 62455 11/04/2188 21:18:36 13/04/2188 21:18:36
62540 62540 05/07/2188 21:18:36 10/07/2188 21:18:36
62711 62715 27/12/2188 21:18:36 28/12/2188 21:18:36
62799 62800 22/03/2189 21:18:36 26/03/2189 21:18:36
63058 63060 07/12/2189 21:18:36 10/12/2189 21:18:36
63317 63320 24/08/2190 21:18:36 26/08/2190 21:18:36
63405 63405 17/11/2190 21:18:36 22/11/2190 21:18:36
63576 63580 11/05/2191 21:18:36 12/05/2191 21:18:36
63664 63665 04/08/2191 21:18:36 08/08/2191 21:18:36
63923 63925 20/04/2192 21:18:36 23/04/2192 21:18:36
64182 64185 05/01/2193 21:18:36 07/01/2193 21:18:36
64270 64270 31/03/2193 21:18:36 05/04/2193 21:18:36
64441 64445 22/09/2193 21:18:36 23/09/2193 21:18:36
64529 64530 16/12/2193 21:18:36 20/12/2193 21:18:36
64788 64790 02/09/2194 21:18:36 05/09/2194 21:18:36
65047 65050 20/05/2195 21:18:36 22/05/2195 21:18:36
65135 65135 13/08/2195 21:18:36 18/08/2195 21:18:36
65306 65310 04/02/2196 21:18:36 05/02/2196 21:18:36
65394 65395 29/04/2196 21:18:36 03/05/2196 21:18:36
65653 65655 14/01/2197 21:18:36 17/01/2197 21:18:36
65912 65915 01/10/2197 21:18:37 03/10/2197 21:18:37
66000 66000 25/12/2197 21:18:37 30/12/2197 21:18:37
66171 66175 18/06/2198 21:18:37 19/06/2198 21:18:37
66259 66260 11/09/2198 21:18:37 15/09/2198 21:18:37
66518 66520 29/05/2199 21:18:37 01/06/2199 21:18:37
66777 66780 13/02/2200 21:18:37 15/02/2200 21:18:37
66865 66865 09/05/2200 21:18:37 14/05/2200 21:18:37
67036 67040 31/10/2200 21:18:37 01/11/2200 21:18:37
67124 67125 24/01/2201 21:18:37 28/01/2201 21:18:37
67383 67385 11/10/2201 21:18:37 14/10/2201 21:18:37
67642 67645 28/06/2202 21:18:37 30/06/2202 21:18:37
67730 67730 21/09/2202 21:18:37 26/09/2202 21:18:37
67901 67905 15/03/2203 21:18:37 16/03/2203 21:18:37
67989 67990 08/06/2203 21:18:37 12/06/2203 21:18:37
68248 68250 23/02/2204 21:18:37 26/02/2204 21:18:37
68507 68510 09/11/2204 21:18:37 11/11/2204 21:18:37
68595 68595 02/02/2205 21:18:37 07/02/2205 21:18:37
68766 68770 27/07/2205 21:18:37 28/07/2205 21:18:37
68854 68855 20/10/2205 21:18:37 24/10/2205 21:18:37
69113 69115 07/07/2206 21:18:37 10/07/2206 21:18:37
69372 69375 24/03/2207 21:18:37 26/03/2207 21:18:37
69460 69460 17/06/2207 21:18:37 22/06/2207 21:18:37
69631 69635 09/12/2207 21:18:37 10/12/2207 21:18:37
69719 69720 03/03/2208 21:18:37 07/03/2208 21:18:37
69978 69980 18/11/2208 21:18:37 21/11/2208 21:18:37
70237 70240 05/08/2209 21:18:37 07/08/2209 21:18:37
70325 70325 29/10/2209 21:18:37 03/11/2209 21:18:37
70496 70500 22/04/2210 21:18:37 23/04/2210 21:18:37
70584 70585 16/07/2210 21:18:37 20/07/2210 21:18:37
70843 70845 02/04/2211 21:18:37 05/04/2211 21:18:37
71102 71105 18/12/2211 21:18:37 20/12/2211 21:18:37
71190 71190 12/03/2212 21:18:37 17/03/2212 21:18:37
71361 71365 03/09/2212 21:18:37 04/09/2212 21:18:37
71449 71450 27/11/2212 21:18:37 01/12/2212 21:18:37
71708 71710 14/08/2213 21:18:37 17/08/2213 21:18:37
71967 71970 01/05/2214 21:18:37 03/05/2214 21:18:37
72055 72055 25/07/2214 21:18:37 30/07/2214 21:18:37
72226 72230 16/01/2215 21:18:37 17/01/2215 21:18:37
72314 72315 11/04/2215 21:18:37 15/04/2215 21:18:37
72573 72575 27/12/2215 21:18:37 30/12/2215 21:18:37
72832 72835 12/09/2216 21:18:37 14/09/2216 21:18:37
72920 72920 06/12/2216 21:18:37 11/12/2216 21:18:37
73091 73095 30/05/2217 21:18:37 31/05/2217 21:18:37
73179 73180 23/08/2217 21:18:37 27/08/2217 21:18:37
73438 73440 10/05/2218 21:18:37 13/05/2218 21:18:37
73697 73700 25/01/2219 21:18:37 27/01/2219 21:18:37
73785 73785 20/04/2219 21:18:37 25/04/2219 21:18:37
73956 73960 12/10/2219 21:18:37 13/10/2219 21:18:37
74044 74045 05/01/2220 21:18:37 09/01/2220 21:18:37
74303 74305 21/09/2220 21:18:37 24/09/2220 21:18:37
74562 74565 08/06/2221 21:18:37 10/06/2221 21:18:37
74650 74650 01/09/2221 21:18:37 06/09/2221 21:18:37
74821 74825 23/02/2222 21:18:37 24/02/2222 21:18:37
74909 74910 19/05/2222 21:18:37 23/05/2222 21:18:37
75168 75170 03/02/2223 21:18:37 06/02/2223 21:18:37
75427 75430 21/10/2223 21:18:37 23/10/2223 21:18:37
75515 75515 14/01/2224 21:18:37 19/01/2224 21:18:37
75686 75690 07/07/2224 21:18:37 08/07/2224 21:18:37
75774 75775 30/09/2224 21:18:37 04/10/2224 21:18:37
76033 76035 17/06/2225 21:18:37 20/06/2225 21:18:37
76292 76295 04/03/2226 21:18:37 06/03/2226 21:18:37
76380 76380 28/05/2226 21:18:37 02/06/2226 21:18:37
76551 76555 19/11/2226 21:18:37 20/11/2226 21:18:37
76639 76640 12/02/2227 21:18:37 16/02/2227 21:18:37
76898 76900 30/10/2227 21:18:37 02/11/2227 21:18:37
77157 77160 16/07/2228 21:18:37 18/07/2228 21:18:37
77245 77245 09/10/2228 21:18:37 14/10/2228 21:18:37
77416 77420 02/04/2229 21:18:37 03/04/2229 21:18:37
77504 77505 26/06/2229 21:18:37 30/06/2229 21:18:37
77763 77765 13/03/2230 21:18:37 16/03/2230 21:18:37
78022 78025 28/11/2230 21:18:37 30/11/2230 21:18:37
78110 78110 21/02/2231 21:18:37 26/02/2231 21:18:37
78281 78285 15/08/2231 21:18:37 16/08/2231 21:18:37
78369 78370 08/11/2231 21:18:37 12/11/2231 21:18:37
78628 78630 25/07/2232 21:18:37 28/07/2232 21:18:37
78887 78890 11/04/2233 21:18:37 13/04/2233 21:18:37
78975 78975 05/07/2233 21:18:37 10/07/2233 21:18:37
79146 79150 27/12/2233 21:18:37 28/12/2233 21:18:37
79234 79235 22/03/2234 21:18:37 26/03/2234 21:18:37
79493 79495 07/12/2234 21:18:37 10/12/2234 21:18:37
79752 79755 24/08/2235 21:18:37 26/08/2235 21:18:37
79840 79840 17/11/2235 21:18:37 22/11/2235 21:18:37
80011 80015 10/05/2236 21:18:37 11/05/2236 21:18:37
80099 80100 03/08/2236 21:18:37 07/08/2236 21:18:37
80358 80360 20/04/2237 21:18:37 23/04/2237 21:18:37
80617 80620 05/01/2238 21:18:37 07/01/2238 21:18:37
80705 80705 31/03/2238 21:18:37 05/04/2238 21:18:37
80876 80880 22/09/2238 21:18:37 23/09/2238 21:18:37
80964 80965 16/12/2238 21:18:37 20/12/2238 21:18:37
81223 81225 02/09/2239 21:18:37 05/09/2239 21:18:37
81482 81485 19/05/2240 21:18:37 21/05/2240 21:18:37
81570 81570 12/08/2240 21:18:37 17/08/2240 21:18:37
81741 81745 03/02/2241 21:18:37 04/02/2241 21:18:37
81829 81830 29/04/2241 21:18:37 03/05/2241 21:18:37
82088 82090 14/01/2242 21:18:37 17/01/2242 21:18:37
82347 82350 01/10/2242 21:18:37 03/10/2242 21:18:37
82435 82435 25/12/2242 21:18:37 30/12/2242 21:18:37
82606 82610 18/06/2243 21:18:37 19/06/2243 21:18:37
82694 82695 11/09/2243 21:18:37 15/09/2243 21:18:37
82953 82955 28/05/2244 21:18:37 31/05/2244 21:18:37
83212 83215 12/02/2245 21:18:37 14/02/2245 21:18:37
83300 83300 08/05/2245 21:18:37 13/05/2245 21:18:37
83471 83475 30/10/2245 21:18:37 31/10/2245 21:18:37
83559 83560 23/01/2246 21:18:37 27/01/2246 21:18:37
83818 83820 10/10/2246 21:18:37 13/10/2246 21:18:37
84077 84080 27/06/2247 21:18:37 29/06/2247 21:18:37
84165 84165 20/09/2247 21:18:37 25/09/2247 21:18:37
84336 84340 13/03/2248 21:18:37 14/03/2248 21:18:37
84424 84425 06/06/2248 21:18:37 10/06/2248 21:18:37
84683 84685 21/02/2249 21:18:37 24/02/2249 21:18:37
84942 84945 08/11/2249 21:18:37 10/11/2249 21:18:37
85030 85030 01/02/2250 21:18:37 06/02/2250 21:18:37
85201 85205 26/07/2250 21:18:37 27/07/2250 21:18:37
85289 85290 19/10/2250 21:18:37 23/10/2250 21:18:37
85548 85550 06/07/2251 21:18:37 09/07/2251 21:18:37
85807 85810 22/03/2252 21:18:37 24/03/2252 21:18:37
85895 85895 15/06/2252 21:18:37 20/06/2252 21:18:37
86066 86070 07/12/2252 21:18:37 08/12/2252 21:18:37
86154 86155 02/03/2253 21:18:37 06/03/2253 21:18:37
86413 86415 17/11/2253 21:18:37 20/11/2253 21:18:37
86672 86675 04/08/2254 21:18:37 06/08/2254 21:18:37
86760 86760 28/10/2254 21:18:37 02/11/2254 21:18:37
86931 86935 21/04/2255 21:18:37 22/04/2255 21:18:37
87019 87020 15/07/2255 21:18:37 19/07/2255 21:18:37
87278 87280 31/03/2256 21:18:37 03/04/2256 21:18:37
87537 87540 16/12/2256 21:18:37 18/12/2256 21:18:37
87625 87625 11/03/2257 21:18:37 16/03/2257 21:18:37
87796 87800 02/09/2257 21:18:37 03/09/2257 21:18:37
87884 87885 26/11/2257 21:18:37 30/11/2257 21:18:37
88143 88145 13/08/2258 21:18:37 16/08/2258 21:18:37
88402 88405 30/04/2259 21:18:37 02/05/2259 21:18:37
88490 88490 24/07/2259 21:18:37 29/07/2259 21:18:37
88661 88665 15/01/2260 21:18:37 16/01/2260 21:18:37
88749 88750 09/04/2260 21:18:37 13/04/2260 21:18:37
89008 89010 25/12/2260 21:18:37 28/12/2260 21:18:37
89267 89270 11/09/2261 21:18:37 13/09/2261 21:18:37
89355 89355 05/12/2261 21:18:37 10/12/2261 21:18:37
89526 89530 29/05/2262 21:18:37 30/05/2262 21:18:37
89614 89615 22/08/2262 21:18:37 26/08/2262 21:18:37
89873 89875 09/05/2263 21:18:37 12/05/2263 21:18:37
90132 90135 24/01/2264 21:18:37 26/01/2264 21:18:37
90220 90220 18/04/2264 21:18:37 23/04/2264 21:18:37
90391 90395 10/10/2264 21:18:37 11/10/2264 21:18:37
90479 90480 03/01/2265 21:18:37 07/01/2265 21:18:37
90738 90740 20/09/2265 21:18:37 23/09/2265 21:18:37
90997 91000 07/06/2266 21:18:37 09/06/2266 21:18:37
91085 91085 31/08/2266 21:18:37 05/09/2266 21:18:37
91256 91260 22/02/2267 21:18:37 23/02/2267 21:18:37
91344 91345 18/05/2267 21:18:37 22/05/2267 21:18:37
91603 91605 02/02/2268 21:18:37 05/02/2268 21:18:37
91862 91865 19/10/2268 21:18:37 21/10/2268 21:18:37
91950 91950 12/01/2269 21:18:37 17/01/2269 21:18:37
92121 92125 06/07/2269 21:18:37 07/07/2269 21:18:37
92209 92210 29/09/2269 21:18:37 03/10/2269 21:18:37
92468 92470 16/06/2270 21:18:37 19/06/2270 21:18:37
92727 92730 03/03/2271 21:18:37 05/03/2271 21:18:37
92815 92815 27/05/2271 21:18:37 01/06/2271 21:18:37
92986 92990 18/11/2271 21:18:37 19/11/2271 21:18:37
93074 93075 11/02/2272 21:18:37 15/02/2272 21:18:37
93333 93335 28/10/2272 21:18:37 31/10/2272 21:18:37
93592 93595 15/07/2273 21:18:37 17/07/2273 21:18:37
93680 93680 08/10/2273 21:18:37 13/10/2273 21:18:37
93851 93855 01/04/2274 21:18:37 02/04/2274 21:18:37
93939 93940 25/06/2274 21:18:37 29/06/2274 21:18:37
94198 94200 12/03/2275 21:18:37 15/03/2275 21:18:37
94457 94460 27/11/2275 21:18:37 29/11/2275 21:18:37
94545 94545 20/02/2276 21:18:37 25/02/2276 21:18:37
94716 94720 13/08/2276 21:18:37 14/08/2276 21:18:37
94804 94805 06/11/2276 21:18:37 10/11/2276 21:18:37
95063 95065 24/07/2277 21:18:37 27/07/2277 21:18:37
95322 95325 10/04/2278 21:18:37 12/04/2278 21:18:37
95410 95410 04/07/2278 21:18:37 09/07/2278 21:18:37
95581 95585 26/12/2278 21:18:37 27/12/2278 21:18:37
95669 95670 21/03/2279 21:18:37 25/03/2279 21:18:37
95928 95930 06/12/2279 21:18:37 09/12/2279 21:18:37
96187 96190 22/08/2280 21:18:37 24/08/2280 21:18:37
96275 96275 15/11/2280 21:18:37 20/11/2280 21:18:37
96446 96450 09/05/2281 21:18:37 10/05/2281 21:18:37
96534 96535 02/08/2281 21:18:37 06/08/2281 21:18:37
96793 96795 19/04/2282 21:18:37 22/04/2282 21:18:37
97052 97055 04/01/2283 21:18:37 06/01/2283 21:18:37
97140 97140 30/03/2283 21:18:37 04/04/2283 21:18:37
97311 97315 21/09/2283 21:18:37 22/09/2283 21:18:37
97399 97400 15/12/2283 21:18:37 19/12/2283 21:18:37
97658 97660 31/08/2284 21:18:37 03/09/2284 21:18:37
97917 97920 18/05/2285 21:18:37 20/05/2285 21:18:37
98005 98005 11/08/2285 21:18:37 16/08/2285 21:18:37
98176 98180 02/02/2286 21:18:37 03/02/2286 21:18:37
98264 98265 28/04/2286 21:18:37 02/05/2286 21:18:37
98523 98525 13/01/2287 21:18:37 16/01/2287 21:18:37
98782 98785 30/09/2287 21:18:37 02/10/2287 21:18:37
98870 98870 24/12/2287 21:18:37 29/12/2287 21:18:37
99041 99045 16/06/2288 21:18:37 17/06/2288 21:18:37
99129 99130 09/09/2288 21:18:37 13/09/2288 21:18:37
99388 99390 27/05/2289 21:18:37 30/05/2289 21:18:37
99647 99650 11/02/2290 21:18:37 13/02/2290 21:18:37
99735 99735 07/05/2290 21:18:37 12/05/2290 21:18:37
99906 99910 29/10/2290 21:18:37 30/10/2290 21:18:37
99994 99995 22/01/2291 21:18:37 26/01/2291 21:18:37
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.5" Build="13.0.4001.0"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT UniqueID&#xa;&#x9; , GroupID&#xa;&#x9; , GroupDate&#xa;&#x9; , UniqueDate&#xa;FROM (&#xa;&#x9;SELECT UniqueID&#xa;&#x9;&#x9; , GroupID&#xa;&#x9;&#x9; , GroupDate&#xa;&#x9;&#x9; , UniqueDate&#xa;&#x9;&#x9; , MAX(UniqueDate) OVER (PARTITION BY GroupID) AS maxUniqueDate&#xa;&#x9;FROM #Example&#xa;&#x9;) calc_maxUD&#xa;WHERE maxUniqueDate &gt; GroupDate&#xa;&#x9;AND maxUniqueDate = UniqueDate" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="2.60342" StatementEstRows="5477.23" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x2E519B513AF35D25" QueryPlanHash="0x707DCEE9EC2570AC" CardinalityEstimationModelVersion="130"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="32" CompileTime="0" CompileCPU="0" CompileMemory="168"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1721488"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="359" CpuTime="359"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="5477.23" EstimateIO="0" EstimateCPU="0.088" AvgRowSize="31" EstimatedTotalSubtreeCost="2.60342" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="579" Batches="0" ActualExecutionMode="Row" ActualElapsedms="359" ActualCPUms="359" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="100000" EstimateIO="0" EstimateCPU="1.59298" AvgRowSize="39" EstimatedTotalSubtreeCost="2.51542" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="328" ActualCPUms="328" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="2" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="20000" EstimateIO="0" EstimateCPU="0" AvgRowSize="31" EstimatedTotalSubtreeCost="0.860375" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="20001" Batches="0" ActualExecutionMode="Row" ActualElapsedms="281" ActualCPUms="281" ActualScans="1" ActualLogicalReads="200001" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Spool><RelOp NodeId="3" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="100000" EstimateIO="0" EstimateCPU="0.20688" AvgRowSize="31" EstimatedTotalSubtreeCost="0.653495" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference><ColumnReference Column="Segment1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="62" ActualCPUms="62" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1004"></ColumnReference></SegmentColumn><RelOp NodeId="4" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="100000" EstimatedRowsRead="100000" EstimateIO="0.336458" EstimateCPU="0.110157" AvgRowSize="31" EstimatedTotalSubtreeCost="0.446615" TableCardinality="100000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="46" ActualCPUms="46" ActualScans="1" ActualLogicalReads="455" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="100000" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Index="[ix_GroupId_UniqueDate_Cover]" IndexKind="NonClustered" Storage="RowStore"></Object></IndexScan></RelOp></Segment></RelOp></Spool></RelOp><RelOp NodeId="5" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="5" EstimateIO="0" EstimateCPU="0.020688" AvgRowSize="31" EstimatedTotalSubtreeCost="0.041376" Parallel="0" EstimateRebinds="20000" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="46" ActualCPUms="46" ActualEndOfScans="20001" ActualExecutions="20001"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></Predicate><RelOp NodeId="6" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.020688" AvgRowSize="31" EstimatedTotalSubtreeCost="0.020688" Parallel="0" EstimateRebinds="20000" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="20000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="31" ActualCPUms="31" ActualEndOfScans="20001" ActualExecutions="20001"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="MAX([tempdb].[dbo].[#Example].[UniqueDate])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="5" EstimateIO="0" EstimateCPU="0" AvgRowSize="31" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="20000" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="31" ActualCPUms="31" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="20000" ActualEndOfScans="20001" ActualExecutions="20001"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="2"></Spool></RelOp></StreamAggregate></RelOp><RelOp NodeId="8" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="5" EstimateIO="0" EstimateCPU="0" AvgRowSize="31" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="20000" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="20000" ActualEndOfScans="20000" ActualExecutions="20000"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="2"></Spool></RelOp></NestedLoops></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="[Expr1003]&gt;[tempdb].[dbo].[#Example].[GroupDate] AND [Expr1003]=[tempdb].[dbo].[#Example].[UniqueDate]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
Table 'Worktable'. Scan count 3, logical reads 280001, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Table '#Example____________________________________________________________________________________________________________0000000000D5'. Scan count 1, logical reads 455, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. SQL Server Execution Times: CPU time = 359 ms, elapsed time = 359 ms.
 hidden batch(es)


set statistics time, io, xml on; with cte as ( select top 1 with ties UniqueID , GroupID , GroupDate , UniqueDate from #Example order by row_number() over (partition by GroupId order by UniqueDate desc) ) select UniqueID , GroupID , GroupDate , UniqueDate from cte where UniqueDate > GroupDate
UniqueID GroupID GroupDate UniqueDate
172 175 05/10/2017 21:18:35 07/10/2017 21:18:35
260 260 29/12/2017 21:18:35 03/01/2018 21:18:35
431 435 22/06/2018 21:18:35 23/06/2018 21:18:35
519 520 15/09/2018 21:18:35 19/09/2018 21:18:35
778 780 02/06/2019 21:18:35 05/06/2019 21:18:35
1037 1040 17/02/2020 21:18:35 19/02/2020 21:18:35
1125 1125 12/05/2020 21:18:35 17/05/2020 21:18:35
1296 1300 03/11/2020 21:18:35 04/11/2020 21:18:35
1384 1385 27/01/2021 21:18:35 31/01/2021 21:18:35
1643 1645 14/10/2021 21:18:35 17/10/2021 21:18:35
1902 1905 01/07/2022 21:18:35 03/07/2022 21:18:35
1990 1990 24/09/2022 21:18:35 29/09/2022 21:18:35
2161 2165 18/03/2023 21:18:35 19/03/2023 21:18:35
2249 2250 11/06/2023 21:18:35 15/06/2023 21:18:35
2508 2510 26/02/2024 21:18:35 29/02/2024 21:18:35
2767 2770 12/11/2024 21:18:35 14/11/2024 21:18:35
2855 2855 05/02/2025 21:18:35 10/02/2025 21:18:35
3026 3030 30/07/2025 21:18:35 31/07/2025 21:18:35
3114 3115 23/10/2025 21:18:35 27/10/2025 21:18:35
3373 3375 10/07/2026 21:18:35 13/07/2026 21:18:35
3632 3635 27/03/2027 21:18:35 29/03/2027 21:18:35
3720 3720 20/06/2027 21:18:35 25/06/2027 21:18:35
3891 3895 12/12/2027 21:18:35 13/12/2027 21:18:35
3979 3980 06/03/2028 21:18:35 10/03/2028 21:18:35
4238 4240 21/11/2028 21:18:35 24/11/2028 21:18:35
4497 4500 08/08/2029 21:18:35 10/08/2029 21:18:35
4585 4585 01/11/2029 21:18:35 06/11/2029 21:18:35
4756 4760 25/04/2030 21:18:35 26/04/2030 21:18:35
4844 4845 19/07/2030 21:18:35 23/07/2030 21:18:35
5103 5105 05/04/2031 21:18:35 08/04/2031 21:18:35
5362 5365 21/12/2031 21:18:35 23/12/2031 21:18:35
5450 5450 15/03/2032 21:18:35 20/03/2032 21:18:35
5621 5625 06/09/2032 21:18:35 07/09/2032 21:18:35
5709 5710 30/11/2032 21:18:35 04/12/2032 21:18:35
5968 5970 17/08/2033 21:18:35 20/08/2033 21:18:35
6227 6230 04/05/2034 21:18:35 06/05/2034 21:18:35
6315 6315 28/07/2034 21:18:35 02/08/2034 21:18:35
6486 6490 19/01/2035 21:18:35 20/01/2035 21:18:35
6574 6575 14/04/2035 21:18:35 18/04/2035 21:18:35
6833 6835 30/12/2035 21:18:35 02/01/2036 21:18:35
7092 7095 15/09/2036 21:18:35 17/09/2036 21:18:35
7180 7180 09/12/2036 21:18:35 14/12/2036 21:18:35
7351 7355 02/06/2037 21:18:35 03/06/2037 21:18:35
7439 7440 26/08/2037 21:18:35 30/08/2037 21:18:35
7698 7700 13/05/2038 21:18:35 16/05/2038 21:18:35
7957 7960 28/01/2039 21:18:35 30/01/2039 21:18:35
8045 8045 23/04/2039 21:18:35 28/04/2039 21:18:35
8216 8220 15/10/2039 21:18:35 16/10/2039 21:18:35
8304 8305 08/01/2040 21:18:35 12/01/2040 21:18:35
8563 8565 24/09/2040 21:18:35 27/09/2040 21:18:35
8822 8825 11/06/2041 21:18:35 13/06/2041 21:18:35
8910 8910 04/09/2041 21:18:35 09/09/2041 21:18:35
9081 9085 26/02/2042 21:18:35 27/02/2042 21:18:35
9169 9170 22/05/2042 21:18:35 26/05/2042 21:18:35
9428 9430 06/02/2043 21:18:35 09/02/2043 21:18:35
9687 9690 24/10/2043 21:18:35 26/10/2043 21:18:35
9775 9775 17/01/2044 21:18:35 22/01/2044 21:18:35
9946 9950 10/07/2044 21:18:35 11/07/2044 21:18:35
10034 10035 03/10/2044 21:18:35 07/10/2044 21:18:35
10293 10295 20/06/2045 21:18:35 23/06/2045 21:18:35
10552 10555 07/03/2046 21:18:35 09/03/2046 21:18:35
10640 10640 31/05/2046 21:18:35 05/06/2046 21:18:35
10811 10815 22/11/2046 21:18:35 23/11/2046 21:18:35
10899 10900 15/02/2047 21:18:35 19/02/2047 21:18:35
11158 11160 02/11/2047 21:18:35 05/11/2047 21:18:35
11417 11420 19/07/2048 21:18:35 21/07/2048 21:18:35
11505 11505 12/10/2048 21:18:35 17/10/2048 21:18:35
11676 11680 05/04/2049 21:18:35 06/04/2049 21:18:35
11764 11765 29/06/2049 21:18:35 03/07/2049 21:18:35
12023 12025 16/03/2050 21:18:35 19/03/2050 21:18:35
12282 12285 01/12/2050 21:18:35 03/12/2050 21:18:35
12370 12370 24/02/2051 21:18:35 01/03/2051 21:18:35
12541 12545 18/08/2051 21:18:35 19/08/2051 21:18:35
12629 12630 11/11/2051 21:18:35 15/11/2051 21:18:35
12888 12890 28/07/2052 21:18:35 31/07/2052 21:18:35
13147 13150 14/04/2053 21:18:35 16/04/2053 21:18:35
13235 13235 08/07/2053 21:18:35 13/07/2053 21:18:35
13406 13410 30/12/2053 21:18:35 31/12/2053 21:18:35
13494 13495 25/03/2054 21:18:35 29/03/2054 21:18:35
13753 13755 10/12/2054 21:18:35 13/12/2054 21:18:35
14012 14015 27/08/2055 21:18:35 29/08/2055 21:18:35
14100 14100 20/11/2055 21:18:35 25/11/2055 21:18:35
14271 14275 13/05/2056 21:18:35 14/05/2056 21:18:35
14359 14360 06/08/2056 21:18:35 10/08/2056 21:18:35
14618 14620 23/04/2057 21:18:35 26/04/2057 21:18:35
14877 14880 08/01/2058 21:18:35 10/01/2058 21:18:35
14965 14965 03/04/2058 21:18:35 08/04/2058 21:18:35
15136 15140 25/09/2058 21:18:35 26/09/2058 21:18:35
15224 15225 19/12/2058 21:18:35 23/12/2058 21:18:35
15483 15485 05/09/2059 21:18:35 08/09/2059 21:18:35
15742 15745 22/05/2060 21:18:35 24/05/2060 21:18:35
15830 15830 15/08/2060 21:18:35 20/08/2060 21:18:35
16001 16005 06/02/2061 21:18:35 07/02/2061 21:18:35
16089 16090 02/05/2061 21:18:35 06/05/2061 21:18:35
16348 16350 17/01/2062 21:18:35 20/01/2062 21:18:35
16607 16610 04/10/2062 21:18:35 06/10/2062 21:18:35
16695 16695 28/12/2062 21:18:35 02/01/2063 21:18:35
16866 16870 21/06/2063 21:18:35 22/06/2063 21:18:35
16954 16955 14/09/2063 21:18:35 18/09/2063 21:18:35
17213 17215 31/05/2064 21:18:35 03/06/2064 21:18:35
17472 17475 15/02/2065 21:18:35 17/02/2065 21:18:35
17560 17560 11/05/2065 21:18:35 16/05/2065 21:18:35
17731 17735 02/11/2065 21:18:35 03/11/2065 21:18:35
17819 17820 26/01/2066 21:18:35 30/01/2066 21:18:35
18078 18080 13/10/2066 21:18:35 16/10/2066 21:18:35
18337 18340 30/06/2067 21:18:35 02/07/2067 21:18:35
18425 18425 23/09/2067 21:18:35 28/09/2067 21:18:35
18596 18600 16/03/2068 21:18:35 17/03/2068 21:18:35
18684 18685 09/06/2068 21:18:35 13/06/2068 21:18:35
18943 18945 24/02/2069 21:18:35 27/02/2069 21:18:35
19202 19205 11/11/2069 21:18:35 13/11/2069 21:18:35
19290 19290 04/02/2070 21:18:35 09/02/2070 21:18:35
19461 19465 29/07/2070 21:18:35 30/07/2070 21:18:35
19549 19550 22/10/2070 21:18:35 26/10/2070 21:18:35
19808 19810 09/07/2071 21:18:35 12/07/2071 21:18:35
20067 20070 25/03/2072 21:18:35 27/03/2072 21:18:35
20155 20155 18/06/2072 21:18:35 23/06/2072 21:18:35
20326 20330 10/12/2072 21:18:35 11/12/2072 21:18:35
20414 20415 05/03/2073 21:18:35 09/03/2073 21:18:35
20673 20675 20/11/2073 21:18:35 23/11/2073 21:18:35
20932 20935 07/08/2074 21:18:35 09/08/2074 21:18:35
21020 21020 31/10/2074 21:18:35 05/11/2074 21:18:35
21191 21195 24/04/2075 21:18:35 25/04/2075 21:18:35
21279 21280 18/07/2075 21:18:35 22/07/2075 21:18:35
21538 21540 03/04/2076 21:18:35 06/04/2076 21:18:35
21797 21800 19/12/2076 21:18:35 21/12/2076 21:18:35
21885 21885 14/03/2077 21:18:35 19/03/2077 21:18:35
22056 22060 05/09/2077 21:18:35 06/09/2077 21:18:35
22144 22145 29/11/2077 21:18:35 03/12/2077 21:18:35
22403 22405 16/08/2078 21:18:35 19/08/2078 21:18:35
22662 22665 03/05/2079 21:18:35 05/05/2079 21:18:35
22750 22750 27/07/2079 21:18:35 01/08/2079 21:18:35
22921 22925 18/01/2080 21:18:35 19/01/2080 21:18:35
23009 23010 12/04/2080 21:18:35 16/04/2080 21:18:35
23268 23270 28/12/2080 21:18:35 31/12/2080 21:18:35
23527 23530 14/09/2081 21:18:35 16/09/2081 21:18:35
23615 23615 08/12/2081 21:18:35 13/12/2081 21:18:35
23786 23790 01/06/2082 21:18:35 02/06/2082 21:18:35
23874 23875 25/08/2082 21:18:35 29/08/2082 21:18:35
24133 24135 12/05/2083 21:18:35 15/05/2083 21:18:35
24392 24395 27/01/2084 21:18:35 29/01/2084 21:18:35
24480 24480 21/04/2084 21:18:35 26/04/2084 21:18:35
24651 24655 13/10/2084 21:18:35 14/10/2084 21:18:35
24739 24740 06/01/2085 21:18:35 10/01/2085 21:18:35
24998 25000 23/09/2085 21:18:35 26/09/2085 21:18:35
25257 25260 10/06/2086 21:18:35 12/06/2086 21:18:35
25345 25345 03/09/2086 21:18:35 08/09/2086 21:18:35
25516 25520 25/02/2087 21:18:35 26/02/2087 21:18:35
25604 25605 21/05/2087 21:18:35 25/05/2087 21:18:35
25863 25865 05/02/2088 21:18:35 08/02/2088 21:18:35
26122 26125 22/10/2088 21:18:36 24/10/2088 21:18:36
26210 26210 15/01/2089 21:18:36 20/01/2089 21:18:36
26381 26385 09/07/2089 21:18:36 10/07/2089 21:18:36
26469 26470 02/10/2089 21:18:36 06/10/2089 21:18:36
26728 26730 19/06/2090 21:18:36 22/06/2090 21:18:36
26987 26990 06/03/2091 21:18:36 08/03/2091 21:18:36
27075 27075 30/05/2091 21:18:36 04/06/2091 21:18:36
27246 27250 21/11/2091 21:18:36 22/11/2091 21:18:36
27334 27335 14/02/2092 21:18:36 18/02/2092 21:18:36
27593 27595 31/10/2092 21:18:36 03/11/2092 21:18:36
27852 27855 18/07/2093 21:18:36 20/07/2093 21:18:36
27940 27940 11/10/2093 21:18:36 16/10/2093 21:18:36
28111 28115 04/04/2094 21:18:36 05/04/2094 21:18:36
28199 28200 28/06/2094 21:18:36 02/07/2094 21:18:36
28458 28460 15/03/2095 21:18:36 18/03/2095 21:18:36
28717 28720 30/11/2095 21:18:36 02/12/2095 21:18:36
28805 28805 23/02/2096 21:18:36 28/02/2096 21:18:36
28976 28980 16/08/2096 21:18:36 17/08/2096 21:18:36
29064 29065 09/11/2096 21:18:36 13/11/2096 21:18:36
29323 29325 27/07/2097 21:18:36 30/07/2097 21:18:36
29582 29585 13/04/2098 21:18:36 15/04/2098 21:18:36
29670 29670 07/07/2098 21:18:36 12/07/2098 21:18:36
29841 29845 29/12/2098 21:18:36 30/12/2098 21:18:36
29929 29930 24/03/2099 21:18:36 28/03/2099 21:18:36
30188 30190 09/12/2099 21:18:36 12/12/2099 21:18:36
30447 30450 26/08/2100 21:18:36 28/08/2100 21:18:36
30535 30535 19/11/2100 21:18:36 24/11/2100 21:18:36
30706 30710 13/05/2101 21:18:36 14/05/2101 21:18:36
30794 30795 06/08/2101 21:18:36 10/08/2101 21:18:36
31053 31055 23/04/2102 21:18:36 26/04/2102 21:18:36
31312 31315 08/01/2103 21:18:36 10/01/2103 21:18:36
31400 31400 03/04/2103 21:18:36 08/04/2103 21:18:36
31571 31575 25/09/2103 21:18:36 26/09/2103 21:18:36
31659 31660 19/12/2103 21:18:36 23/12/2103 21:18:36
31918 31920 04/09/2104 21:18:36 07/09/2104 21:18:36
32177 32180 22/05/2105 21:18:36 24/05/2105 21:18:36
32265 32265 15/08/2105 21:18:36 20/08/2105 21:18:36
32436 32440 06/02/2106 21:18:36 07/02/2106 21:18:36
32524 32525 02/05/2106 21:18:36 06/05/2106 21:18:36
32783 32785 17/01/2107 21:18:36 20/01/2107 21:18:36
33042 33045 04/10/2107 21:18:36 06/10/2107 21:18:36
33130 33130 28/12/2107 21:18:36 02/01/2108 21:18:36
33301 33305 20/06/2108 21:18:36 21/06/2108 21:18:36
33389 33390 13/09/2108 21:18:36 17/09/2108 21:18:36
33648 33650 31/05/2109 21:18:36 03/06/2109 21:18:36
33907 33910 15/02/2110 21:18:36 17/02/2110 21:18:36
33995 33995 11/05/2110 21:18:36 16/05/2110 21:18:36
34166 34170 02/11/2110 21:18:36 03/11/2110 21:18:36
34254 34255 26/01/2111 21:18:36 30/01/2111 21:18:36
34513 34515 13/10/2111 21:18:36 16/10/2111 21:18:36
34772 34775 29/06/2112 21:18:36 01/07/2112 21:18:36
34860 34860 22/09/2112 21:18:36 27/09/2112 21:18:36
35031 35035 16/03/2113 21:18:36 17/03/2113 21:18:36
35119 35120 09/06/2113 21:18:36 13/06/2113 21:18:36
35378 35380 24/02/2114 21:18:36 27/02/2114 21:18:36
35637 35640 11/11/2114 21:18:36 13/11/2114 21:18:36
35725 35725 04/02/2115 21:18:36 09/02/2115 21:18:36
35896 35900 29/07/2115 21:18:36 30/07/2115 21:18:36
35984 35985 22/10/2115 21:18:36 26/10/2115 21:18:36
36243 36245 08/07/2116 21:18:36 11/07/2116 21:18:36
36502 36505 25/03/2117 21:18:36 27/03/2117 21:18:36
36590 36590 18/06/2117 21:18:36 23/06/2117 21:18:36
36761 36765 10/12/2117 21:18:36 11/12/2117 21:18:36
36849 36850 05/03/2118 21:18:36 09/03/2118 21:18:36
37108 37110 20/11/2118 21:18:36 23/11/2118 21:18:36
37367 37370 07/08/2119 21:18:36 09/08/2119 21:18:36
37455 37455 31/10/2119 21:18:36 05/11/2119 21:18:36
37626 37630 23/04/2120 21:18:36 24/04/2120 21:18:36
37714 37715 17/07/2120 21:18:36 21/07/2120 21:18:36
37973 37975 03/04/2121 21:18:36 06/04/2121 21:18:36
38232 38235 19/12/2121 21:18:36 21/12/2121 21:18:36
38320 38320 14/03/2122 21:18:36 19/03/2122 21:18:36
38491 38495 05/09/2122 21:18:36 06/09/2122 21:18:36
38579 38580 29/11/2122 21:18:36 03/12/2122 21:18:36
38838 38840 16/08/2123 21:18:36 19/08/2123 21:18:36
39097 39100 02/05/2124 21:18:36 04/05/2124 21:18:36
39185 39185 26/07/2124 21:18:36 31/07/2124 21:18:36
39356 39360 17/01/2125 21:18:36 18/01/2125 21:18:36
39444 39445 12/04/2125 21:18:36 16/04/2125 21:18:36
39703 39705 28/12/2125 21:18:36 31/12/2125 21:18:36
39962 39965 14/09/2126 21:18:36 16/09/2126 21:18:36
40050 40050 08/12/2126 21:18:36 13/12/2126 21:18:36
40221 40225 01/06/2127 21:18:36 02/06/2127 21:18:36
40309 40310 25/08/2127 21:18:36 29/08/2127 21:18:36
40568 40570 11/05/2128 21:18:36 14/05/2128 21:18:36
40827 40830 26/01/2129 21:18:36 28/01/2129 21:18:36
40915 40915 21/04/2129 21:18:36 26/04/2129 21:18:36
41086 41090 13/10/2129 21:18:36 14/10/2129 21:18:36
41174 41175 06/01/2130 21:18:36 10/01/2130 21:18:36
41433 41435 23/09/2130 21:18:36 26/09/2130 21:18:36
41692 41695 10/06/2131 21:18:36 12/06/2131 21:18:36
41780 41780 03/09/2131 21:18:36 08/09/2131 21:18:36
41951 41955 25/02/2132 21:18:36 26/02/2132 21:18:36
42039 42040 20/05/2132 21:18:36 24/05/2132 21:18:36
42298 42300 04/02/2133 21:18:36 07/02/2133 21:18:36
42557 42560 22/10/2133 21:18:36 24/10/2133 21:18:36
42645 42645 15/01/2134 21:18:36 20/01/2134 21:18:36
42816 42820 09/07/2134 21:18:36 10/07/2134 21:18:36
42904 42905 02/10/2134 21:18:36 06/10/2134 21:18:36
43163 43165 19/06/2135 21:18:36 22/06/2135 21:18:36
43422 43425 05/03/2136 21:18:36 07/03/2136 21:18:36
43510 43510 29/05/2136 21:18:36 03/06/2136 21:18:36
43681 43685 20/11/2136 21:18:36 21/11/2136 21:18:36
43769 43770 13/02/2137 21:18:36 17/02/2137 21:18:36
44028 44030 31/10/2137 21:18:36 03/11/2137 21:18:36
44287 44290 18/07/2138 21:18:36 20/07/2138 21:18:36
44375 44375 11/10/2138 21:18:36 16/10/2138 21:18:36
44546 44550 04/04/2139 21:18:36 05/04/2139 21:18:36
44634 44635 28/06/2139 21:18:36 02/07/2139 21:18:36
44893 44895 14/03/2140 21:18:36 17/03/2140 21:18:36
45152 45155 29/11/2140 21:18:36 01/12/2140 21:18:36
45240 45240 22/02/2141 21:18:36 27/02/2141 21:18:36
45411 45415 16/08/2141 21:18:36 17/08/2141 21:18:36
45499 45500 09/11/2141 21:18:36 13/11/2141 21:18:36
45758 45760 27/07/2142 21:18:36 30/07/2142 21:18:36
46017 46020 13/04/2143 21:18:36 15/04/2143 21:18:36
46105 46105 07/07/2143 21:18:36 12/07/2143 21:18:36
46276 46280 29/12/2143 21:18:36 30/12/2143 21:18:36
46364 46365 23/03/2144 21:18:36 27/03/2144 21:18:36
46623 46625 08/12/2144 21:18:36 11/12/2144 21:18:36
46882 46885 25/08/2145 21:18:36 27/08/2145 21:18:36
46970 46970 18/11/2145 21:18:36 23/11/2145 21:18:36
47141 47145 12/05/2146 21:18:36 13/05/2146 21:18:36
47229 47230 05/08/2146 21:18:36 09/08/2146 21:18:36
47488 47490 22/04/2147 21:18:36 25/04/2147 21:18:36
47747 47750 07/01/2148 21:18:36 09/01/2148 21:18:36
47835 47835 01/04/2148 21:18:36 06/04/2148 21:18:36
48006 48010 23/09/2148 21:18:36 24/09/2148 21:18:36
48094 48095 17/12/2148 21:18:36 21/12/2148 21:18:36
48353 48355 03/09/2149 21:18:36 06/09/2149 21:18:36
48612 48615 21/05/2150 21:18:36 23/05/2150 21:18:36
48700 48700 14/08/2150 21:18:36 19/08/2150 21:18:36
48871 48875 05/02/2151 21:18:36 06/02/2151 21:18:36
48959 48960 01/05/2151 21:18:36 05/05/2151 21:18:36
49218 49220 16/01/2152 21:18:36 19/01/2152 21:18:36
49477 49480 02/10/2152 21:18:36 04/10/2152 21:18:36
49565 49565 26/12/2152 21:18:36 31/12/2152 21:18:36
49736 49740 19/06/2153 21:18:36 20/06/2153 21:18:36
49824 49825 12/09/2153 21:18:36 16/09/2153 21:18:36
50083 50085 30/05/2154 21:18:36 02/06/2154 21:18:36
50342 50345 14/02/2155 21:18:36 16/02/2155 21:18:36
50430 50430 10/05/2155 21:18:36 15/05/2155 21:18:36
50601 50605 01/11/2155 21:18:36 02/11/2155 21:18:36
50689 50690 25/01/2156 21:18:36 29/01/2156 21:18:36
50948 50950 11/10/2156 21:18:36 14/10/2156 21:18:36
51207 51210 28/06/2157 21:18:36 30/06/2157 21:18:36
51295 51295 21/09/2157 21:18:36 26/09/2157 21:18:36
51466 51470 15/03/2158 21:18:36 16/03/2158 21:18:36
51554 51555 08/06/2158 21:18:36 12/06/2158 21:18:36
51813 51815 23/02/2159 21:18:36 26/02/2159 21:18:36
52072 52075 10/11/2159 21:18:36 12/11/2159 21:18:36
52160 52160 03/02/2160 21:18:36 08/02/2160 21:18:36
52331 52335 27/07/2160 21:18:36 28/07/2160 21:18:36
52419 52420 20/10/2160 21:18:36 24/10/2160 21:18:36
52678 52680 07/07/2161 21:18:36 10/07/2161 21:18:36
52937 52940 24/03/2162 21:18:36 26/03/2162 21:18:36
53025 53025 17/06/2162 21:18:36 22/06/2162 21:18:36
53196 53200 09/12/2162 21:18:36 10/12/2162 21:18:36
53284 53285 04/03/2163 21:18:36 08/03/2163 21:18:36
53543 53545 19/11/2163 21:18:36 22/11/2163 21:18:36
53802 53805 05/08/2164 21:18:36 07/08/2164 21:18:36
53890 53890 29/10/2164 21:18:36 03/11/2164 21:18:36
54061 54065 22/04/2165 21:18:36 23/04/2165 21:18:36
54149 54150 16/07/2165 21:18:36 20/07/2165 21:18:36
54408 54410 02/04/2166 21:18:36 05/04/2166 21:18:36
54667 54670 18/12/2166 21:18:36 20/12/2166 21:18:36
54755 54755 13/03/2167 21:18:36 18/03/2167 21:18:36
54926 54930 04/09/2167 21:18:36 05/09/2167 21:18:36
55014 55015 28/11/2167 21:18:36 02/12/2167 21:18:36
55273 55275 14/08/2168 21:18:36 17/08/2168 21:18:36
55532 55535 01/05/2169 21:18:36 03/05/2169 21:18:36
55620 55620 25/07/2169 21:18:36 30/07/2169 21:18:36
55791 55795 16/01/2170 21:18:36 17/01/2170 21:18:36
55879 55880 11/04/2170 21:18:36 15/04/2170 21:18:36
56138 56140 27/12/2170 21:18:36 30/12/2170 21:18:36
56397 56400 13/09/2171 21:18:36 15/09/2171 21:18:36
56485 56485 07/12/2171 21:18:36 12/12/2171 21:18:36
56656 56660 30/05/2172 21:18:36 31/05/2172 21:18:36
56744 56745 23/08/2172 21:18:36 27/08/2172 21:18:36
57003 57005 10/05/2173 21:18:36 13/05/2173 21:18:36
57262 57265 25/01/2174 21:18:36 27/01/2174 21:18:36
57350 57350 20/04/2174 21:18:36 25/04/2174 21:18:36
57521 57525 12/10/2174 21:18:36 13/10/2174 21:18:36
57609 57610 05/01/2175 21:18:36 09/01/2175 21:18:36
57868 57870 22/09/2175 21:18:36 25/09/2175 21:18:36
58127 58130 08/06/2176 21:18:36 10/06/2176 21:18:36
58215 58215 01/09/2176 21:18:36 06/09/2176 21:18:36
58386 58390 23/02/2177 21:18:36 24/02/2177 21:18:36
58474 58475 19/05/2177 21:18:36 23/05/2177 21:18:36
58733 58735 03/02/2178 21:18:36 06/02/2178 21:18:36
58992 58995 21/10/2178 21:18:36 23/10/2178 21:18:36
59080 59080 14/01/2179 21:18:36 19/01/2179 21:18:36
59251 59255 08/07/2179 21:18:36 09/07/2179 21:18:36
59339 59340 01/10/2179 21:18:36 05/10/2179 21:18:36
59598 59600 17/06/2180 21:18:36 20/06/2180 21:18:36
59857 59860 04/03/2181 21:18:36 06/03/2181 21:18:36
59945 59945 28/05/2181 21:18:36 02/06/2181 21:18:36
60116 60120 19/11/2181 21:18:36 20/11/2181 21:18:36
60204 60205 12/02/2182 21:18:36 16/02/2182 21:18:36
60463 60465 30/10/2182 21:18:36 02/11/2182 21:18:36
60722 60725 17/07/2183 21:18:36 19/07/2183 21:18:36
60810 60810 10/10/2183 21:18:36 15/10/2183 21:18:36
60981 60985 02/04/2184 21:18:36 03/04/2184 21:18:36
61069 61070 26/06/2184 21:18:36 30/06/2184 21:18:36
61328 61330 13/03/2185 21:18:36 16/03/2185 21:18:36
61587 61590 28/11/2185 21:18:36 30/11/2185 21:18:36
61675 61675 21/02/2186 21:18:36 26/02/2186 21:18:36
61846 61850 15/08/2186 21:18:36 16/08/2186 21:18:36
61934 61935 08/11/2186 21:18:36 12/11/2186 21:18:36
62193 62195 26/07/2187 21:18:36 29/07/2187 21:18:36
62452 62455 11/04/2188 21:18:36 13/04/2188 21:18:36
62540 62540 05/07/2188 21:18:36 10/07/2188 21:18:36
62711 62715 27/12/2188 21:18:36 28/12/2188 21:18:36
62799 62800 22/03/2189 21:18:36 26/03/2189 21:18:36
63058 63060 07/12/2189 21:18:36 10/12/2189 21:18:36
63317 63320 24/08/2190 21:18:36 26/08/2190 21:18:36
63405 63405 17/11/2190 21:18:36 22/11/2190 21:18:36
63576 63580 11/05/2191 21:18:36 12/05/2191 21:18:36
63664 63665 04/08/2191 21:18:36 08/08/2191 21:18:36
63923 63925 20/04/2192 21:18:36 23/04/2192 21:18:36
64182 64185 05/01/2193 21:18:36 07/01/2193 21:18:36
64270 64270 31/03/2193 21:18:36 05/04/2193 21:18:36
64441 64445 22/09/2193 21:18:36 23/09/2193 21:18:36
64529 64530 16/12/2193 21:18:36 20/12/2193 21:18:36
64788 64790 02/09/2194 21:18:36 05/09/2194 21:18:36
65047 65050 20/05/2195 21:18:36 22/05/2195 21:18:36
65135 65135 13/08/2195 21:18:36 18/08/2195 21:18:36
65306 65310 04/02/2196 21:18:36 05/02/2196 21:18:36
65394 65395 29/04/2196 21:18:36 03/05/2196 21:18:36
65653 65655 14/01/2197 21:18:36 17/01/2197 21:18:36
65912 65915 01/10/2197 21:18:37 03/10/2197 21:18:37
66000 66000 25/12/2197 21:18:37 30/12/2197 21:18:37
66171 66175 18/06/2198 21:18:37 19/06/2198 21:18:37
66259 66260 11/09/2198 21:18:37 15/09/2198 21:18:37
66518 66520 29/05/2199 21:18:37 01/06/2199 21:18:37
66777 66780 13/02/2200 21:18:37 15/02/2200 21:18:37
66865 66865 09/05/2200 21:18:37 14/05/2200 21:18:37
67036 67040 31/10/2200 21:18:37 01/11/2200 21:18:37
67124 67125 24/01/2201 21:18:37 28/01/2201 21:18:37
67383 67385 11/10/2201 21:18:37 14/10/2201 21:18:37
67642 67645 28/06/2202 21:18:37 30/06/2202 21:18:37
67730 67730 21/09/2202 21:18:37 26/09/2202 21:18:37
67901 67905 15/03/2203 21:18:37 16/03/2203 21:18:37
67989 67990 08/06/2203 21:18:37 12/06/2203 21:18:37
68248 68250 23/02/2204 21:18:37 26/02/2204 21:18:37
68507 68510 09/11/2204 21:18:37 11/11/2204 21:18:37
68595 68595 02/02/2205 21:18:37 07/02/2205 21:18:37
68766 68770 27/07/2205 21:18:37 28/07/2205 21:18:37
68854 68855 20/10/2205 21:18:37 24/10/2205 21:18:37
69113 69115 07/07/2206 21:18:37 10/07/2206 21:18:37
69372 69375 24/03/2207 21:18:37 26/03/2207 21:18:37
69460 69460 17/06/2207 21:18:37 22/06/2207 21:18:37
69631 69635 09/12/2207 21:18:37 10/12/2207 21:18:37
69719 69720 03/03/2208 21:18:37 07/03/2208 21:18:37
69978 69980 18/11/2208 21:18:37 21/11/2208 21:18:37
70237 70240 05/08/2209 21:18:37 07/08/2209 21:18:37
70325 70325 29/10/2209 21:18:37 03/11/2209 21:18:37
70496 70500 22/04/2210 21:18:37 23/04/2210 21:18:37
70584 70585 16/07/2210 21:18:37 20/07/2210 21:18:37
70843 70845 02/04/2211 21:18:37 05/04/2211 21:18:37
71102 71105 18/12/2211 21:18:37 20/12/2211 21:18:37
71190 71190 12/03/2212 21:18:37 17/03/2212 21:18:37
71361 71365 03/09/2212 21:18:37 04/09/2212 21:18:37
71449 71450 27/11/2212 21:18:37 01/12/2212 21:18:37
71708 71710 14/08/2213 21:18:37 17/08/2213 21:18:37
71967 71970 01/05/2214 21:18:37 03/05/2214 21:18:37
72055 72055 25/07/2214 21:18:37 30/07/2214 21:18:37
72226 72230 16/01/2215 21:18:37 17/01/2215 21:18:37
72314 72315 11/04/2215 21:18:37 15/04/2215 21:18:37
72573 72575 27/12/2215 21:18:37 30/12/2215 21:18:37
72832 72835 12/09/2216 21:18:37 14/09/2216 21:18:37
72920 72920 06/12/2216 21:18:37 11/12/2216 21:18:37
73091 73095 30/05/2217 21:18:37 31/05/2217 21:18:37
73179 73180 23/08/2217 21:18:37 27/08/2217 21:18:37
73438 73440 10/05/2218 21:18:37 13/05/2218 21:18:37
73697 73700 25/01/2219 21:18:37 27/01/2219 21:18:37
73785 73785 20/04/2219 21:18:37 25/04/2219 21:18:37
73956 73960 12/10/2219 21:18:37 13/10/2219 21:18:37
74044 74045 05/01/2220 21:18:37 09/01/2220 21:18:37
74303 74305 21/09/2220 21:18:37 24/09/2220 21:18:37
74562 74565 08/06/2221 21:18:37 10/06/2221 21:18:37
74650 74650 01/09/2221 21:18:37 06/09/2221 21:18:37
74821 74825 23/02/2222 21:18:37 24/02/2222 21:18:37
74909 74910 19/05/2222 21:18:37 23/05/2222 21:18:37
75168 75170 03/02/2223 21:18:37 06/02/2223 21:18:37
75427 75430 21/10/2223 21:18:37 23/10/2223 21:18:37
75515 75515 14/01/2224 21:18:37 19/01/2224 21:18:37
75686 75690 07/07/2224 21:18:37 08/07/2224 21:18:37
75774 75775 30/09/2224 21:18:37 04/10/2224 21:18:37
76033 76035 17/06/2225 21:18:37 20/06/2225 21:18:37
76292 76295 04/03/2226 21:18:37 06/03/2226 21:18:37
76380 76380 28/05/2226 21:18:37 02/06/2226 21:18:37
76551 76555 19/11/2226 21:18:37 20/11/2226 21:18:37
76639 76640 12/02/2227 21:18:37 16/02/2227 21:18:37
76898 76900 30/10/2227 21:18:37 02/11/2227 21:18:37
77157 77160 16/07/2228 21:18:37 18/07/2228 21:18:37
77245 77245 09/10/2228 21:18:37 14/10/2228 21:18:37
77416 77420 02/04/2229 21:18:37 03/04/2229 21:18:37
77504 77505 26/06/2229 21:18:37 30/06/2229 21:18:37
77763 77765 13/03/2230 21:18:37 16/03/2230 21:18:37
78022 78025 28/11/2230 21:18:37 30/11/2230 21:18:37
78110 78110 21/02/2231 21:18:37 26/02/2231 21:18:37
78281 78285 15/08/2231 21:18:37 16/08/2231 21:18:37
78369 78370 08/11/2231 21:18:37 12/11/2231 21:18:37
78628 78630 25/07/2232 21:18:37 28/07/2232 21:18:37
78887 78890 11/04/2233 21:18:37 13/04/2233 21:18:37
78975 78975 05/07/2233 21:18:37 10/07/2233 21:18:37
79146 79150 27/12/2233 21:18:37 28/12/2233 21:18:37
79234 79235 22/03/2234 21:18:37 26/03/2234 21:18:37
79493 79495 07/12/2234 21:18:37 10/12/2234 21:18:37
79752 79755 24/08/2235 21:18:37 26/08/2235 21:18:37
79840 79840 17/11/2235 21:18:37 22/11/2235 21:18:37
80011 80015 10/05/2236 21:18:37 11/05/2236 21:18:37
80099 80100 03/08/2236 21:18:37 07/08/2236 21:18:37
80358 80360 20/04/2237 21:18:37 23/04/2237 21:18:37
80617 80620 05/01/2238 21:18:37 07/01/2238 21:18:37
80705 80705 31/03/2238 21:18:37 05/04/2238 21:18:37
80876 80880 22/09/2238 21:18:37 23/09/2238 21:18:37
80964 80965 16/12/2238 21:18:37 20/12/2238 21:18:37
81223 81225 02/09/2239 21:18:37 05/09/2239 21:18:37
81482 81485 19/05/2240 21:18:37 21/05/2240 21:18:37
81570 81570 12/08/2240 21:18:37 17/08/2240 21:18:37
81741 81745 03/02/2241 21:18:37 04/02/2241 21:18:37
81829 81830 29/04/2241 21:18:37 03/05/2241 21:18:37
82088 82090 14/01/2242 21:18:37 17/01/2242 21:18:37
82347 82350 01/10/2242 21:18:37 03/10/2242 21:18:37
82435 82435 25/12/2242 21:18:37 30/12/2242 21:18:37
82606 82610 18/06/2243 21:18:37 19/06/2243 21:18:37
82694 82695 11/09/2243 21:18:37 15/09/2243 21:18:37
82953 82955 28/05/2244 21:18:37 31/05/2244 21:18:37
83212 83215 12/02/2245 21:18:37 14/02/2245 21:18:37
83300 83300 08/05/2245 21:18:37 13/05/2245 21:18:37
83471 83475 30/10/2245 21:18:37 31/10/2245 21:18:37
83559 83560 23/01/2246 21:18:37 27/01/2246 21:18:37
83818 83820 10/10/2246 21:18:37 13/10/2246 21:18:37
84077 84080 27/06/2247 21:18:37 29/06/2247 21:18:37
84165 84165 20/09/2247 21:18:37 25/09/2247 21:18:37
84336 84340 13/03/2248 21:18:37 14/03/2248 21:18:37
84424 84425 06/06/2248 21:18:37 10/06/2248 21:18:37
84683 84685 21/02/2249 21:18:37 24/02/2249 21:18:37
84942 84945 08/11/2249 21:18:37 10/11/2249 21:18:37
85030 85030 01/02/2250 21:18:37 06/02/2250 21:18:37
85201 85205 26/07/2250 21:18:37 27/07/2250 21:18:37
85289 85290 19/10/2250 21:18:37 23/10/2250 21:18:37
85548 85550 06/07/2251 21:18:37 09/07/2251 21:18:37
85807 85810 22/03/2252 21:18:37 24/03/2252 21:18:37
85895 85895 15/06/2252 21:18:37 20/06/2252 21:18:37
86066 86070 07/12/2252 21:18:37 08/12/2252 21:18:37
86154 86155 02/03/2253 21:18:37 06/03/2253 21:18:37
86413 86415 17/11/2253 21:18:37 20/11/2253 21:18:37
86672 86675 04/08/2254 21:18:37 06/08/2254 21:18:37
86760 86760 28/10/2254 21:18:37 02/11/2254 21:18:37
86931 86935 21/04/2255 21:18:37 22/04/2255 21:18:37
87019 87020 15/07/2255 21:18:37 19/07/2255 21:18:37
87278 87280 31/03/2256 21:18:37 03/04/2256 21:18:37
87537 87540 16/12/2256 21:18:37 18/12/2256 21:18:37
87625 87625 11/03/2257 21:18:37 16/03/2257 21:18:37
87796 87800 02/09/2257 21:18:37 03/09/2257 21:18:37
87884 87885 26/11/2257 21:18:37 30/11/2257 21:18:37
88143 88145 13/08/2258 21:18:37 16/08/2258 21:18:37
88402 88405 30/04/2259 21:18:37 02/05/2259 21:18:37
88490 88490 24/07/2259 21:18:37 29/07/2259 21:18:37
88661 88665 15/01/2260 21:18:37 16/01/2260 21:18:37
88749 88750 09/04/2260 21:18:37 13/04/2260 21:18:37
89008 89010 25/12/2260 21:18:37 28/12/2260 21:18:37
89267 89270 11/09/2261 21:18:37 13/09/2261 21:18:37
89355 89355 05/12/2261 21:18:37 10/12/2261 21:18:37
89526 89530 29/05/2262 21:18:37 30/05/2262 21:18:37
89614 89615 22/08/2262 21:18:37 26/08/2262 21:18:37
89873 89875 09/05/2263 21:18:37 12/05/2263 21:18:37
90132 90135 24/01/2264 21:18:37 26/01/2264 21:18:37
90220 90220 18/04/2264 21:18:37 23/04/2264 21:18:37
90391 90395 10/10/2264 21:18:37 11/10/2264 21:18:37
90479 90480 03/01/2265 21:18:37 07/01/2265 21:18:37
90738 90740 20/09/2265 21:18:37 23/09/2265 21:18:37
90997 91000 07/06/2266 21:18:37 09/06/2266 21:18:37
91085 91085 31/08/2266 21:18:37 05/09/2266 21:18:37
91256 91260 22/02/2267 21:18:37 23/02/2267 21:18:37
91344 91345 18/05/2267 21:18:37 22/05/2267 21:18:37
91603 91605 02/02/2268 21:18:37 05/02/2268 21:18:37
91862 91865 19/10/2268 21:18:37 21/10/2268 21:18:37
91950 91950 12/01/2269 21:18:37 17/01/2269 21:18:37
92121 92125 06/07/2269 21:18:37 07/07/2269 21:18:37
92209 92210 29/09/2269 21:18:37 03/10/2269 21:18:37
92468 92470 16/06/2270 21:18:37 19/06/2270 21:18:37
92727 92730 03/03/2271 21:18:37 05/03/2271 21:18:37
92815 92815 27/05/2271 21:18:37 01/06/2271 21:18:37
92986 92990 18/11/2271 21:18:37 19/11/2271 21:18:37
93074 93075 11/02/2272 21:18:37 15/02/2272 21:18:37
93333 93335 28/10/2272 21:18:37 31/10/2272 21:18:37
93592 93595 15/07/2273 21:18:37 17/07/2273 21:18:37
93680 93680 08/10/2273 21:18:37 13/10/2273 21:18:37
93851 93855 01/04/2274 21:18:37 02/04/2274 21:18:37
93939 93940 25/06/2274 21:18:37 29/06/2274 21:18:37
94198 94200 12/03/2275 21:18:37 15/03/2275 21:18:37
94457 94460 27/11/2275 21:18:37 29/11/2275 21:18:37
94545 94545 20/02/2276 21:18:37 25/02/2276 21:18:37
94716 94720 13/08/2276 21:18:37 14/08/2276 21:18:37
94804 94805 06/11/2276 21:18:37 10/11/2276 21:18:37
95063 95065 24/07/2277 21:18:37 27/07/2277 21:18:37
95322 95325 10/04/2278 21:18:37 12/04/2278 21:18:37
95410 95410 04/07/2278 21:18:37 09/07/2278 21:18:37
95581 95585 26/12/2278 21:18:37 27/12/2278 21:18:37
95669 95670 21/03/2279 21:18:37 25/03/2279 21:18:37
95928 95930 06/12/2279 21:18:37 09/12/2279 21:18:37
96187 96190 22/08/2280 21:18:37 24/08/2280 21:18:37
96275 96275 15/11/2280 21:18:37 20/11/2280 21:18:37
96446 96450 09/05/2281 21:18:37 10/05/2281 21:18:37
96534 96535 02/08/2281 21:18:37 06/08/2281 21:18:37
96793 96795 19/04/2282 21:18:37 22/04/2282 21:18:37
97052 97055 04/01/2283 21:18:37 06/01/2283 21:18:37
97140 97140 30/03/2283 21:18:37 04/04/2283 21:18:37
97311 97315 21/09/2283 21:18:37 22/09/2283 21:18:37
97399 97400 15/12/2283 21:18:37 19/12/2283 21:18:37
97658 97660 31/08/2284 21:18:37 03/09/2284 21:18:37
97917 97920 18/05/2285 21:18:37 20/05/2285 21:18:37
98005 98005 11/08/2285 21:18:37 16/08/2285 21:18:37
98176 98180 02/02/2286 21:18:37 03/02/2286 21:18:37
98264 98265 28/04/2286 21:18:37 02/05/2286 21:18:37
98523 98525 13/01/2287 21:18:37 16/01/2287 21:18:37
98782 98785 30/09/2287 21:18:37 02/10/2287 21:18:37
98870 98870 24/12/2287 21:18:37 29/12/2287 21:18:37
99041 99045 16/06/2288 21:18:37 17/06/2288 21:18:37
99129 99130 09/09/2288 21:18:37 13/09/2288 21:18:37
99388 99390 27/05/2289 21:18:37 30/05/2289 21:18:37
99647 99650 11/02/2290 21:18:37 13/02/2290 21:18:37
99735 99735 07/05/2290 21:18:37 12/05/2290 21:18:37
99906 99910 29/10/2290 21:18:37 30/10/2290 21:18:37
99994 99995 22/01/2291 21:18:37 26/01/2291 21:18:37
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.5" Build="13.0.4001.0"><BatchSequence><Batch><Statements><StmtSimple StatementText="with cte as (&#xa; select top 1 with ties &#xa; UniqueID&#xa; , GroupID&#xa; , GroupDate&#xa; , UniqueDate&#xa; from #Example&#xa; order by row_number() over (partition by GroupId order by UniqueDate desc)&#xa;)&#xa;select&#xa; UniqueID&#xa; , GroupID&#xa; , GroupDate&#xa; , UniqueDate&#xa;from cte&#xa;where UniqueDate &gt; GroupDate" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="15.785" StatementEstRows="30000" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x7C4B9EB5E987B0D0" QueryPlanHash="0x740E45BBCD61B317" CardinalityEstimationModelVersion="130"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="19016" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="32" CompileTime="0" CompileCPU="0" CompileMemory="208"><MemoryGrantInfo SerialRequiredMemory="640" SerialDesiredMemory="19016" RequiredMemory="640" DesiredMemory="19016" RequestedMemory="19016" GrantWaitTime="0" GrantedMemory="19016" MaxUsedMemory="17088" MaxQueryMemory="590608"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1722288"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><WaitStats><Wait WaitType="IO_COMPLETION" WaitTimeMs="218" WaitCount="64"></Wait></WaitStats><QueryTimeStats ElapsedTime="656" CpuTime="437"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="30000" EstimateIO="0" EstimateCPU="0.048" AvgRowSize="31" EstimatedTotalSubtreeCost="15.785" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="579" Batches="0" ActualExecutionMode="Row" ActualElapsedms="640" ActualCPUms="421" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="1" PhysicalOp="Top" LogicalOp="Top" EstimateRows="100000" EstimateIO="0" EstimateCPU="0.01" AvgRowSize="31" EstimatedTotalSubtreeCost="15.737" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="20000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="640" ActualCPUms="421" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="1"><TieColumns><ColumnReference Column="Expr1003"></ColumnReference></TieColumns><TopExpression><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></TopExpression><RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="100000" EstimateIO="0.0112613" EstimateCPU="7.62393" AvgRowSize="39" EstimatedTotalSubtreeCost="15.727" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><Warnings><SpillToTempDb SpillLevel="1" SpilledThreadCount="1"></SpillToTempDb><SortSpillDetails GrantedMemoryKb="10184" UsedMemoryKb="10184" WritesToTempDb="484" ReadsFromTempDb="484"></SortSpillDetails></Warnings><MemoryFractions Input="0.526774" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="20001" Batches="0" ActualExecutionMode="Row" ActualElapsedms="640" ActualCPUms="421" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="1" InputMemoryGrant="10184" OutputMemoryGrant="18504" UsedMemoryGrant="10184"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1003"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="3" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="100000" EstimateIO="0" EstimateCPU="0.008" AvgRowSize="39" EstimatedTotalSubtreeCost="8.0918" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="109" ActualCPUms="109" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="100000" EstimateIO="0" EstimateCPU="0.002" AvgRowSize="39" EstimatedTotalSubtreeCost="8.0838" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference><ColumnReference Column="Segment1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="93" ActualCPUms="93" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1004"></ColumnReference></SegmentColumn><RelOp NodeId="5" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="100000" EstimateIO="0.0112613" EstimateCPU="7.62393" AvgRowSize="31" EstimatedTotalSubtreeCost="8.0818" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OutputList><MemoryFractions Input="1" Output="0.473226"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="78" ActualCPUms="78" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="18888" OutputMemoryGrant="8824" UsedMemoryGrant="6904"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="6" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="100000" EstimatedRowsRead="100000" EstimateIO="0.336458" EstimateCPU="0.110157" AvgRowSize="31" EstimatedTotalSubtreeCost="0.446615" TableCardinality="100000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="100000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="454" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="100000" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Index="[ix_GroupId_UniqueDate_Cover]" IndexKind="NonClustered" Storage="RowStore"></Object></IndexScan></RelOp></Sort></RelOp></Segment></RelOp></SequenceProject></RelOp></Sort></RelOp></Top></RelOp><Predicate><ScalarOperator ScalarString="[tempdb].[dbo].[#Example].[UniqueDate]&gt;[tempdb].[dbo].[#Example].[GroupDate]"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="UniqueDate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#Example]" Column="GroupDate"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 0 ms. SQL Server Execution Times: CPU time = 0 ms, elapsed time = 0 ms. Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 108, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Table '#Example____________________________________________________________________________________________________________0000000000D5'. Scan count 1, logical reads 454, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. SQL Server Execution Times: CPU time = 422 ms, elapsed time = 656 ms.
 hidden batch(es)


set statistics time, io, xml on; SELECT e.UniqueID , e.GroupID , e.GroupDate , e.UniqueDate FROM ( SELECT GroupID, MAX(UniqueDate) AS maxUniqueDate FROM #Example GROUP BY GroupID) AS agg INNER MERGE JOIN #Example AS e ON agg.GroupID=e.GroupID WHERE agg.maxUniqueDate > e.GroupDate AND agg.maxUniqueDate = e.UniqueDate;
UniqueID GroupID GroupDate UniqueDate
172 175 05/10/2017 21:18:35 07/10/2017 21:18:35
260 260 29/12/2017 21:18:35 03/01/2018 21:18:35
431 435 22/06/2018 21:18:35 23/06/2018 21:18:35
519 520 15/09/2018 21:18:35 19/09/2018 21:18:35
778 780 02/06/2019 21:18:35 05/06/2019 21:18:35
1037 1040 17/02/2020 21:18:35 19/02/2020 21:18:35
1125 1125 12/05/2020 21:18:35 17/05/2020 21:18:35
1296 1300 03/11/2020 21:18:35 04/11/2020 21:18:35
1384 1385 27/01/2021 21:18:35 31/01/2021 21:18:35
1643 1645 14/10/2021 21:18:35 17/10/2021 21:18:35
1902 1905 01/07/2022 21:18:35 03/07/2022 21:18:35
1990 1990 24/09/2022 21:18:35 29/09/2022 21:18:35
2161 2165 18/03/2023 21:18:35 19/03/2023 21:18:35
2249 2250 11/06/2023 21:18:35 15/06/2023 21:18:35
2508 2510 26/02/2024 21:18:35 29/02/2024 21:18:35
2767 2770 12/11/2024 21:18:35 14/11/2024 21:18:35
2855 2855 05/02/2025 21:18:35 10/02/2025 21:18:35
3026 3030 30/07/2025 21:18:35 31/07/2025 21:18:35
3114 3115 23/10/2025 21:18:35 27/10/2025 21:18:35
3373 3375 10/07/2026 21:18:35 13/07/2026 21:18:35
3632 3635 27/03/2027 21:18:35 29/03/2027 21:18:35
3720 3720 20/06/2027 21:18:35 25/06/2027 21:18:35
3891 3895 12/12/2027 21:18:35 13/12/2027 21:18:35
3979 3980 06/03/2028 21:18:35 10/03/2028 21:18:35
4238 4240 21/11/2028 21:18:35 24/11/2028 21:18:35
4497 4500 08/08/2029 21:18:35 10/08/2029 21:18:35
4585 4585 01/11/2029 21:18:35 06/11/2029 21:18:35
4756 4760 25/04/2030 21:18:35 26/04/2030 21:18:35
4844 4845 19/07/2030 21:18:35 23/07/2030 21:18:35
5103 5105 05/04/2031 21:18:35 08/04/2031 21:18:35
5362 5365 21/12/2031 21:18:35 23/12/2031 21:18:35
5450 5450 15/03/2032 21:18:35 20/03/2032 21:18:35
5621 5625 06/09/2032 21:18:35 07/09/2032 21:18:35
5709 5710 30/11/2032 21:18:35 04/12/2032 21:18:35
5968 5970 17/08/2033 21:18:35 20/08/2033 21:18:35
6227 6230 04/05/2034 21:18:35 06/05/2034 21:18:35
6315 6315 28/07/2034 21:18:35 02/08/2034 21:18:35
6486 6490 19/01/2035 21:18:35 20/01/2035 21:18:35
6574 6575 14/04/2035 21:18:35 18/04/2035 21:18:35
6833 6835 30/12/2035 21:18:35 02/01/2036 21:18:35
7092 7095 15/09/2036 21:18:35 17/09/2036 21:18:35
7180 7180 09/12/2036 21:18:35 14/12/2036 21:18:35
7351 7355 02/06/2037 21:18:35 03/06/2037 21:18:35
7439 7440 26/08/2037 21:18:35 30/08/2037 21:18:35
7698 7700 13/05/2038 21:18:35 16/05/2038 21:18:35
7957 7960 28/01/2039 21:18:35 30/01/2039 21:18:35
8045 8045 23/04/2039 21:18:35 28/04/2039 21:18:35
8216 8220 15/10/2039 21:18:35 16/10/2039 21:18:35
8304 8305 08/01/2040 21:18:35 12/01/2040 21:18:35
8563 8565 24/09/2040 21:18:35 27/09/2040 21:18:35
8822 8825 11/06/2041 21:18:35 13/06/2041 21:18:35
8910 8910 04/09/2041 21:18:35 09/09/2041 21:18:35
9081 9085 26/02/2042 21:18:35 27/02/2042 21:18:35
9169 9170 22/05/2042 21:18:35 26/05/2042 21:18:35
9428 9430 06/02/2043 21:18:35 09/02/2043 21:18:35
9687 9690 24/10/2043 21:18:35 26/10/2043 21:18:35
9775 9775 17/01/2044 21:18:35 22/01/2044 21:18:35
9946 9950 10/07/2044 21:18:35 11/07/2044 21:18:35
10034 10035 03/10/2044 21:18:35 07/10/2044 21:18:35
10293 10295 20/06/2045 21:18:35 23/06/2045 21:18:35
10552 10555 07/03/2046 21:18:35 09/03/2046 21:18:35
10640 10640 31/05/2046 21:18:35 05/06/2046 21:18:35
10811 10815 22/11/2046 21:18:35 23/11/2046 21:18:35
10899 10900 15/02/2047 21:18:35 19/02/2047 21:18:35
11158 11160 02/11/2047 21:18:35 05/11/2047 21:18:35
11417 11420 19/07/2048 21:18:35 21/07/2048 21:18:35
11505 11505 12/10/2048 21:18:35 17/10/2048 21:18:35
11676 11680 05/04/2049 21:18:35 06/04/2049 21:18:35
11764 11765 29/06/2049 21:18:35 03/07/2049 21:18:35
12023 12025 16/03/2050 21:18:35 19/03/2050 21:18:35
12282 12285 01/12/2050 21:18:35 03/12/2050 21:18:35
12370 12370 24/02/2051 21:18:35 01/03/2051 21:18:35
12541 12545 18/08/2051 21:18:35 19/08/2051 21:18:35
12629 12630 11/11/2051 21:18:35 15/11/2051 21:18:35
12888 12890 28/07/2052 21:18:35 31/07/2052 21:18:35
13147 13150 14/04/2053 21:18:35 16/04/2053 21:18:35
13235 13235 08/07/2053 21:18:35 13/07/2053 21:18:35
13406 13410 30/12/2053 21:18:35 31/12/2053 21:18:35
13494 13495 25/03/2054 21:18:35 29/03/2054 21:18:35
13753 13755 10/12/2054 21:18:35 13/12/2054 21:18:35
14012 14015 27/08/2055 21:18:35 29/08/2055 21:18:35
14100 14100 20/11/2055 21:18:35 25/11/2055 21:18:35
14271 14275 13/05/2056 21:18:35 14/05/2056 21:18:35
14359 14360 06/08/2056 21:18:35 10/08/2056 21:18:35
14618 14620 23/04/2057 21:18:35 26/04/2057 21:18:35
14877 14880 08/01/2058 21:18:35 10/01/2058 21:18:35
14965 14965 03/04/2058 21:18:35 08/04/2058 21:18:35
15136 15140 25/09/2058 21:18:35 26/09/2058 21:18:35
15224 15225 19/12/2058 21:18:35 23/12/2058 21:18:35
15483 15485 05/09/2059 21:18:35 08/09/2059 21:18:35
15742 15745 22/05/2060 21:18:35 24/05/2060 21:18:35
15830 15830 15/08/2060 21:18:35 20/08/2060 21:18:35
16001 16005 06/02/2061 21:18:35 07/02/2061 21:18:35
16089 16090 02/05/2061 21:18:35 06/05/2061 21:18:35
16348 16350 17/01/2062 21:18:35 20/01/2062 21:18:35
16607 16610 04/10/2062 21:18:35 06/10/2062 21:18:35
16695 16695 28/12/2062 21:18:35 02/01/2063 21:18:35
16866 16870 21/06/2063 21:18:35 22/06/2063 21:18:35
16954 16955 14/09/2063 21:18:35 18/09/2063 21:18:35
17213 17215 31/05/2064 21:18:35 03/06/2064 21:18:35
17472 17475 15/02/2065 21:18:35 17/02/2065 21:18:35
17560 17560 11/05/2065 21:18:35 16/05/2065 21:18:35
17731 17735 02/11/2065 21:18:35 03/11/2065 21:18:35
17819 17820 26/01/2066 21:18:35 30/01/2066 21:18:35
18078 18080 13/10/2066 21:18:35 16/10/2066 21:18:35
18337 18340 30/06/2067 21:18:35 02/07/2067 21:18:35
18425 18425 23/09/2067 21:18:35 28/09/2067 21:18:35
18596 18600 16/03/2068 21:18:35 17/03/2068 21:18:35
18684 18685 09/06/2068 21:18:35 13/06/2068 21:18:35
18943 18945 24/02/2069 21:18:35 27/02/2069 21:18:35
19202 19205 11/11/2069 21:18:35 13/11/2069 21:18:35
19290 19290 04/02/2070 21:18:35 09/02/2070 21:18:35
19461 19465 29/07/2070 21:18:35 30/07/2070 21:18:35
19549 19550 22/10/2070 21:18:35 26/10/2070 21:18:35
19808 19810 09/07/2071 21:18:35 12/07/2071 21:18:35
20067 20070 25/03/2072 21:18:35 27/03/2072 21:18:35
20155 20155 18/06/2072 21:18:35 23/06/2072 21:18:35
20326 20330 10/12/2072 21:18:35 11/12/2072 21:18:35
20414 20415 05/03/2073 21:18:35 09/03/2073 21:18:35
20673 20675 20/11/2073 21:18:35 23/11/2073 21:18:35
20932 20935 07/08/2074 21:18:35 09/08/2074 21:18:35
21020 21020 31/10/2074 21:18:35 05/11/2074 21:18:35
21191 21195 24/04/2075 21:18:35 25/04/2075 21:18:35
21279 21280 18/07/2075 21:18:35 22/07/2075 21:18:35
21538 21540 03/04/2076 21:18:35 06/04/2076 21:18:35
21797 21800 19/12/2076 21:18:35 21/12/2076 21:18:35
21885 21885 14/03/2077 21:18:35 19/03/2077 21:18:35
22056 22060 05/09/2077 21:18:35 06/09/2077 21:18:35
22144 22145 29/11/2077 21:18:35 03/12/2077 21:18:35
22403 22405 16/08/2078 21:18:35 19/08/2078 21:18:35
22662 22665 03/05/2079 21:18:35 05/05/2079 21:18:35
22750 22750 27/07/2079 21:18:35 01/08/2079 21:18:35
22921 22925 18/01/2080 21:18:35 19/01/2080 21:18:35
23009 23010 12/04/2080 21:18:35 16/04/2080 21:18:35
23268 23270 28/12/2080 21:18:35 31/12/2080 21:18:35
23527 23530 14/09/2081 21:18:35 16/09/2081 21:18:35
23615 23615 08/12/2081 21:18:35 13/12/2081 21:18:35
23786 23790 01/06/2082 21:18:35 02/06/2082 21:18:35
23874 23875 25/08/2082 21:18:35 29/08/2082 21:18:35
24133 24135 12/05/2083 21:18:35 15/05/2083 21:18:35
24392 24395 27/01/2084 21:18:35 29/01/2084 21:18:35
24480 24480 21/04/2084 21:18:35 26/04/2084 21:18:35
24651 24655 13/10/2084 21:18:35 14/10/2084 21:18:35
24739 24740 06/01/2085 21:18:35 10/01/2085 21:18:35
24998 25000 23/09/2085 21:18:35 26/09/2085 21:18:35
25257 25260 10/06/2086 21:18:35 12/06/2086 21:18:35
25345 25345 03/09/2086 21:18:35 08/09/2086 21:18:35
25516 25520 25/02/2087 21:18:35 26/02/2087 21:18:35
25604 25605 21/05/2087 21:18:35 25/05/2087 21:18:35
25863 25865 05/02/2088 21:18:35 08/02/2088 21:18:35
26122 26125 22/10/2088 21:18:36 24/10/2088 21:18:36
26210 26210 15/01/2089 21:18:36 20/01/2089 21:18:36
26381 26385 09/07/2089 21:18:36 10/07/2089 21:18:36
26469 26470 02/10/2089 21:18:36 06/10/2089 21:18:36
26728 26730 19/06/2090 21:18:36 22/06/2090 21:18:36
26987 26990 06/03/2091 21:18:36 08/03/2091 21:18:36
27075 27075 30/05/2091 21:18:36 04/06/2091 21:18:36
27246 27250 21/11/2091 21:18:36 22/11/2091 21:18:36
27334 27335 14/02/2092 21:18:36 18/02/2092 21:18:36
27593 27595 31/10/2092 21:18:36 03/11/2092 21:18:36
27852 27855 18/07/2093 21:18:36 20/07/2093 21:18:36
27940 27940 11/10/2093 21:18:36 16/10/2093 21:18:36
28111 28115 04/04/2094 21:18:36 05/04/2094 21:18:36
28199 28200 28/06/2094 21:18:36 02/07/2094 21:18:36
28458 28460 15/03/2095 21:18:36 18/03/2095 21:18:36
28717 28720 30/11/2095 21:18:36 02/12/2095 21:18:36
28805 28805 23/02/2096 21:18:36 28/02/2096 21:18:36
28976 28980 16/08/2096 21:18:36 17/08/2096 21:18:36
29064 29065 09/11/2096 21:18:36 13/11/2096 21:18:36
29323 29325 27/07/2097 21:18:36 30/07/2097 21:18:36
29582 29585 13/04/2098 21:18:36 15/04/2098 21:18:36
29670 29670 07/07/2098 21:18:36 12/07/2098 21:18:36
29841 29845 29/12/2098 21:18:36 30/12/2098 21:18:36
29929 29930 24/03/2099 21:18:36 28/03/2099 21:18:36
30188 30190 09/12/2099 21:18:36 12/12/2099 21:18:36
30447 30450 26/08/2100 21:18:36 28/08/2100 21:18:36
30535 30535 19/11/2100 21:18:36 24/11/2100 21:18:36
30706 30710 13/05/2101 21:18:36 14/05/2101 21:18:36
30794 30795 06/08/2101 21:18:36 10/08/2101 21:18:36
31053 31055 23/04/2102 21:18:36 26/04/2102 21:18:36
31312 31315 08/01/2103 21:18:36 10/01/2103 21:18:36
31400 31400 03/04/2103 21:18:36 08/04/2103 21:18:36
31571 31575 25/09/2103 21:18:36 26/09/2103 21:18:36
31659 31660 19/12/2103 21:18:36 23/12/2103 21:18:36
31918 31920 04/09/2104 21:18:36 07/09/2104 21:18:36
32177 32180 22/05/2105 21:18:36 24/05/2105 21:18:36
32265 32265 15/08/2105 21:18:36 20/08/2105 21:18:36
32436 32440 06/02/2106 21:18:36 07/02/2106 21:18:36
32524 32525 02/05/2106 21:18:36 06/05/2106 21:18:36
32783 32785 17/01/2107 21:18:36 20/01/2107 21:18:36
33042 33045 04/10/2107 21:18:36 06/10/2107 21:18:36
33130 33130 28/12/2107 21:18:36 02/01/2108 21:18:36
33301 33305 20/06/2108 21:18:36 21/06/2108 21:18:36
33389 33390 13/09/2108 21:18:36 17/09/2108 21:18:36
33648 33650 31/05/2109 21:18:36 03/06/2109 21:18:36
33907 33910 15/02/2110 21:18:36 17/02/2110 21:18:36
33995 33995 11/05/2110 21:18:36 16/05/2110 21:18:36
34166 34170 02/11/2110 21:18:36 03/11/2110 21:18:36
34254 34255 26/01/2111 21:18:36 30/01/2111 21:18:36
34513 34515 13/10/2111 21:18:36 16/10/2111 21:18:36
34772 34775 29/06/2112 21:18:36 01/07/2112 21:18:36
34860 34860 22/09/2112 21:18:36 27/09/2112 21:18:36
35031 35035 16/03/2113 21:18:36 17/03/2113 21:18:36
35119 35120 09/06/2113 21:18:36 13/06/2113 21:18:36
35378 35380 24/02/2114 21:18:36 27/02/2114 21:18:36
35637 35640 11/11/2114 21:18:36 13/11/2114 21:18:36
35725 35725 04/02/2115 21:18:36 09/02/2115 21:18:36
35896 35900 29/07/2115 21:18:36 30/07/2115 21:18:36
35984 35985 22/10/2115 21:18:36 26/10/2115 21:18:36
36243 36245 08/07/2116 21:18:36 11/07/2116 21:18:36
36502 36505 25/03/2117 21:18:36 27/03/2117 21:18:36
36590 36590 18/06/2117 21:18:36 23/06/2117 21:18:36
36761 36765 10/12/2117 21:18:36 11/12/2117 21:18:36
36849 36850 05/03/2118 21:18:36 09/03/2118 21:18:36
37108 37110 20/11/2118 21:18:36 23/11/2118 21:18:36
37367 37370 07/08/2119 21:18:36 09/08/2119 21:18:36
37455 37455 31/10/2119 21:18:36 05/11/2119 21:18:36
37626 37630 23/04/2120 21:18:36 24/04/2120 21:18:36
37714 37715 17/07/2120 21:18:36 21/07/2120 21:18:36
37973 37975 03/04/2121 21:18:36 06/04/2121 21:18:36
38232 38235 19/12/2121 21:18:36 21/12/2121 21:18:36
38320 38320 14/03/2122 21:18:36 19/03/2122 21:18:36
38491 38495 05/09/2122 21:18:36 06/09/2122 21:18:36
38579 38580 29/11/2122 21:18:36 03/12/2122 21:18:36
38838 38840 16/08/2123 21:18:36 19/08/2123 21:18:36
39097 39100 02/05/2124 21:18:36 04/05/2124 21:18:36
39185 39185 26/07/2124 21:18:36 31/07/2124 21:18:36
39356 39360 17/01/2125 21:18:36 18/01/2125 21:18:36
39444 39445 12/04/2125 21:18:36 16/04/2125 21:18:36
39703 39705 28/12/2125 21:18:36 31/12/2125 21:18:36
39962 39965 14/09/2126 21:18:36 16/09/2126 21:18:36
40050 40050 08/12/2126 21:18:36 13/12/2126 21:18:36
40221 40225 01/06/2127 21:18:36 02/06/2127 21:18:36
40309 40310 25/08/2127 21:18:36 29/08/2127 21:18:36
40568 40570 11/05/2128 21:18:36 14/05/2128 21:18:36
40827 40830 26/01/2129 21:18:36 28/01/2129 21:18:36
40915 40915 21/04/2129 21:18:36 26/04/2129 21:18:36
41086 41090 13/10/2129 21:18:36 14/10/2129 21:18:36
41174 41175 06/01/2130 21:18:36 10/01/2130 21:18:36
41433 41435 23/09/2130 21:18:36 26/09/2130 21:18:36
41692 41695 10/06/2131 21:18:36 12/06/2131 21:18:36
41780 41780 03/09/2131 21:18:36 08/09/2131 21:18:36
41951 41955 25/02/2132 21:18:36 26/02/2132 21:18:36
42039 42040 20/05/2132 21:18:36 24/05/2132 21:18:36
42298 42300 04/02/2133 21:18:36 07/02/2133 21:18:36
42557 42560 22/10/2133 21:18:36 24/10/2133 21:18:36
42645 42645 15/01/2134 21:18:36 20/01/2134 21:18:36
42816 42820 09/07/2134 21:18:36 10/07/2134 21:18:36
42904 42905 02/10/2134 21:18:36 06/10/2134 21:18:36
43163 43165 19/06/2135 21:18:36 22/06/2135 21:18:36
43422 43425 05/03/2136 21:18:36 07/03/2136 21:18:36
43510 43510 29/05/2136 21:18:36 03/06/2136 21:18:36
43681 43685 20/11/2136 21:18:36 21/11/2136 21:18:36
43769 43770 13/02/2137 21:18:36 17/02/2137 21:18:36
44028 44030 31/10/2137 21:18:36 03/11/2137 21:18:36
44287 44290 18/07/2138 21:18:36 20/07/2138 21:18:36
44375 44375 11/10/2138 21:18:36 16/10/2138 21:18:36
44546 44550 04/04/2139 21:18:36 05/04/2139 21:18:36
44634 44635 28/06/2139 21:18:36 02/07/2139 21:18:36
44893 44895 14/03/2140 21:18:36 17/03/2140 21:18:36
45152 45155 29/11/2140 21:18:36 01/12/2140 21:18:36
45240 45240 22/02/2141 21:18:36 27/02/2141 21:18:36
45411 45415 16/08/2141 21:18:36 17/08/2141 21:18:36
45499 45500 09/11/2141 21:18:36 13/11/2141 21:18:36
45758 45760 27/07/2142 21:18:36 30/07/2142 21:18:36
46017 46020 13/04/2143 21:18:36 15/04/2143 21:18:36
46105 46105 07/07/2143 21:18:36 12/07/2143 21:18:36
46276 46280 29/12/2143 21:18:36 30/12/2143 21:18:36
46364 46365 23/03/2144 21:18:36 27/03/2144 21:18:36
46623 46625 08/12/2144 21:18:36 11/12/2144 21:18:36
46882 46885 25/08/2145 21:18:36 27/08/2145 21:18:36
46970 46970 18/11/2145 21:18:36 23/11/2145 21:18:36
47141 47145 12/05/2146 21:18:36 13/05/2146 21:18:36
47229 47230 05/08/2146 21:18:36 09/08/2146 21:18:36
47488 47490 22/04/2147 21:18:36 25/04/2147 21:18:36
47747 47750 07/01/2148 21:18:36 09/01/2148 21:18:36
47835 47835 01/04/2148 21:18:36 06/04/2148 21:18:36
48006 48010 23/09/2148 21:18:36 24/09/2148 21:18:36
48094 48095 17/12/2148 21:18:36 21/12/2148 21:18:36
48353 48355 03/09/2149 21:18:36 06/09/2149 21:18:36
48612 48615 21/05/2150 21:18:36 23/05/2150 21:18:36
48700 48700 14/08/2150 21:18:36 19/08/2150 21:18:36
48871 48875 05/02/2151 21:18:36 06/02/2151 21:18:36
48959 48960 01/05/2151 21:18:36 05/05/2151 21:18:36
49218 49220 16/01/2152 21:18:36 19/01/2152 21:18:36
49477 49480 02/10/2152 21:18:36 04/10/2152 21:18:36
49565 49565 26/12/2152 21:18:36 31/12/2152 21:18:36
49736 49740 19/06/2153 21:18:36 20/06/2153 21:18:36
49824 49825 12/09/2153 21:18:36 16/09/2153 21:18:36
50083 50085 30/05/2154 21:18:36 02/06/2154 21:18:36
50342 50345 14/02/2155 21:18:36 16/02/2155 21:18:36
50430 50430 10/05/2155 21:18:36 15/05/2155 21:18:36
50601 50605 01/11/2155 21:18:36 02/11/2155 21:18:36
50689 50690 25/01/2156 21:18:36 29/01/2156 21:18:36
50948 50950 11/10/2156 21:18:36 14/10/2156 21:18:36
51207 51210 28/06/2157 21:18:36 30/06/2157 21:18:36
51295 51295 21/09/2157 21:18:36 26/09/2157 21:18:36
51466 51470 15/03/2158 21:18:36 16/03/2158 21:18:36
51554 51555 08/06/2158 21:18:36 12/06/2158 21:18:36
51813 51815 23/02/2159 21:18:36 26/02/2159 21:18:36
52072 52075 10/11/2159 21:18:36 12/11/2159 21:18:36
52160 52160 03/02/2160 21:18:36 08/02/2160 21:18:36
52331 52335 27/07/2160 21:18:36 28/07/2160 21:18:36
52419 52420 20/10/2160 21:18:36 24/10/2160 21:18:36
52678 52680 07/07/2161 21:18:36 10/07/2161 21:18:36
52937 52940 24/03/2162 21:18:36 26/03/2162 21:18:36
53025 53025 17/06/2162 21:18:36 22/06/2162 21:18:36
53196 53200 09/12/2162 21:18:36 10/12/2162 21:18:36
53284 53285 04/03/2163 21:18:36 08/03/2163 21:18:36
53543 53545 19/11/2163 21:18:36 22/11/2163 21:18:36
53802 53805 05/08/2164 21:18:36 07/08/2164 21:18:36
53890 53890 29/10/2164 21:18:36 03/11/2164 21:18:36
54061 54065 22/04/2165 21:18:36 23/04/2165 21:18:36
54149 54150 16/07/2165 21:18:36 20/07/2165 21:18:36
54408 54410 02/04/2166 21:18:36 05/04/2166 21:18:36
54667 54670 18/12/2166 21:18:36 20/12/2166 21:18:36
54755 54755 13/03/2167 21:18:36 18/03/2167 21:18:36
54926 54930 04/09/2167 21:18:36 05/09/2167 21:18:36
55014 55015 28/11/2167 21:18:36 02/12/2167 21:18:36
55273 55275 14/08/2168 21:18:36 17/08/2168 21:18:36
55532 55535 01/05/2169 21:18:36 03/05/2169 21:18:36
55620 55620 25/07/2169 21:18:36 30/07/2169 21:18:36
55791 55795 16/01/2170 21:18:36 17/01/2170 21:18:36
55879 55880 11/04/2170 21:18:36 15/04/2170 21:18:36
56138 56140 27/12/2170 21:18:36 30/12/2170 21:18:36
56397 56400 13/09/2171 21:18:36 15/09/2171 21:18:36
56485 56485 07/12/2171 21:18:36 12/12/2171 21:18:36
56656 56660 30/05/2172 21:18:36 31/05/2172 21:18:36
56744 56745 23/08/2172 21:18:36 27/08/2172 21:18:36
57003 57005 10/05/2173 21:18:36 13/05/2173 21:18:36
57262 57265 25/01/2174 21:18:36 27/01/2174 21:18:36
57350 57350 20/04/2174 21:18:36 25/04/2174 21:18:36
57521 57525 12/10/2174 21:18:36 13/10/2174 21:18:36
57609 57610 05/01/2175 21:18:36 09/01/2175 21:18:36
57868 57870 22/09/2175 21:18:36 25/09/2175 21:18:36
58127 58130 08/06/2176 21:18:36 10/06/2176 21:18:36
58215 58215 01/09/2176 21:18:36 06/09/2176 21:18:36
58386 58390 23/02/2177 21:18:36 24/02/2177 21:18:36
58474 58475 19/05/2177 21:18:36 23/05/2177 21:18:36
58733 58735 03/02/2178 21:18:36 06/02/2178 21:18:36
58992 58995 21/10/2178 21:18:36 23/10/2178 21:18:36
59080 59080 14/01/2179 21:18:36 19/01/2179 21:18:36
59251 59255 08/07/2179 21:18:36 09/07/2179 21:18:36
59339 59340 01/10/2179 21:18:36 05/10/2179 21:18:36
59598 59600 17/06/2180 21:18:36 20/06/2180 21:18:36
59857 59860 04/03/2181 21:18:36 06/03/2181 21:18:36
59945 59945 28/05/2181 21:18:36 02/06/2181 21:18:36
60116 60120 19/11/2181 21:18:36 20/11/2181 21:18:36
60204 60205 12/02/2182 21:18:36 16/02/2182 21:18:36
60463 60465 30/10/2182 21:18:36 02/11/2182 21:18:36
60722 60725 17/07/2183 21:18:36 19/07/2183 21:18:36
60810 60810 10/10/2183 21:18:36 15/10/2183 21:18:36
60981 60985 02/04/2184 21:18:36 03/04/2184 21:18:36
61069 61070 26/06/2184 21:18:36 30/06/2184 21:18:36
61328 61330 13/03/2185 21:18:36 16/03/2185 21:18:36
61587 61590 28/11/2185 21:18:36 30/11/2185 21:18:36
61675 61675 21/02/2186 21:18:36 26/02/2186 21:18:36
61846 61850 15/08/2186 21:18:36 16/08/2186 21:18:36
61934 61935 08/11/2186 21:18:36 12/11/2186 21:18:36
62193 62195 26/07/2187 21:18:36 29/07/2187 21:18:36
62452 62455 11/04/2188 21:18:36 13/04/2188 21:18:36
62540 62540 05/07/2188 21:18:36 10/07/2188 21:18:36
62711 62715 27/12/2188 21:18:36 28/12/2188 21:18:36
62799 62800 22/03/2189 21:18:36 26/03/2189 21:18:36
63058 63060 07/12/2189 21:18:36 10/12/2189 21:18:36
63317 63320 24/08/2190 21:18:36 26/08/2190 21:18:36
63405 63405 17/11/2190 21:18:36 22/11/2190 21:18:36
63576 63580 11/05/2191 21:18:36 12/05/2191 21:18:36
63664 63665 04/08/2191 21:18:36 08/08/2191 21:18:36
63923 63925 20/04/2192 21:18:36 23/04/2192 21:18:36
64182 64185 05/01/2193 21:18:36 07/01/2193 21:18:36
64270 64270 31/03/2193 21:18:36 05/04/2193 21:18:36
64441 64445 22/09/2193 21:18:36 23/09/2193 21:18:36
64529 64530 16/12/2193 21:18:36 20/12/2193 21:18:36
64788 64790 02/09/2194 21:18:36 05/09/2194 21:18:36
65047 65050 20/05/2195 21:18:36 22/05/2195 21:18:36
65135 65135 13/08/2195 21:18:36 18/08/2195 21:18:36
65306 65310 04/02/2196 21:18:36 05/02/2196 21:18:36
65394 65395 29/04/2196 21:18:36 03/05/2196 21:18:36
65653 65655 14/01/2197 21:18:36 17/01/2197 21:18:36
65912 65915 01/10/2197 21:18:37 03/10/2197 21:18:37
66000 66000 25/12/2197 21:18:37 30/12/2197 21:18:37
66171 66175 18/06/2198 21:18:37 19/06/2198 21:18:37
66259 66260 11/09/2198 21:18:37 15/09/2198 21:18:37
66518 66520 29/05/2199 21:18:37 01/06/2199 21:18:37
66777 66780 13/02/2200 21:18:37 15/02/2200 21:18:37
66865 66865 09/05/2200 21:18:37 14/05/2200 21:18:37
67036 67040 31/10/2200 21:18:37 01/11/2200 21:18:37
67124 67125 24/01/2201 21:18:37 28/01/2201 21:18:37
67383 67385 11/10/2201 21:18:37 14/10/2201 21:18:37
67642 67645 28/06/2202 21:18:37 30/06/2202 21:18:37
67730 67730 21/09/2202 21:18:37 26/09/2202 21:18:37
67901 67905 15/03/2203 21:18:37 16/03/2203 21:18:37
67989 67990 08/06/2203 21:18:37 12/06/2203 21:18:37
68248 68250 23/02/2204 21:18:37 26/02/2204 21:18:37
68507 68510 09/11/2204 21:18:37 11/11/2204 21:18:37
68595 68595 02/02/2205 21:18:37 07/02/2205 21:18:37
68766 68770 27/07/2205 21:18:37 28/07/2205 21:18:37
68854 68855 20/10/2205 21:18:37 24/10/2205 21:18:37
69113 69115 07/07/2206 21:18:37 10/07/2206 21:18:37
69372 69375 24/03/2207 21:18:37 26/03/2207 21:18:37
69460 69460 17/06/2207 21:18:37 22/06/2207 21:18:37
69631 69635 09/12/2207 21:18:37 10/12/2207 21:18:37
69719 69720 03/03/2208 21:18:37 07/03/2208 21:18:37
69978 69980 18/11/2208 21:18:37 21/11/2208 21:18:37
70237 70240 05/08/2209 21:18:37 07/08/2209 21:18:37
70325 70325 29/10/2209 21:18:37 03/11/2209 21:18:37
70496 70500 22/04/2210 21:18:37 23/04/2210 21:18:37