Timetrial League Standings for 2024

Quarterly Prizes

First Quarter Winner (Jan-Mar)	R200
Second Quarter Winner (Apr-Jun)	R200
Third Quarter Winner (Jul-Oct)	R200
Fourth Quarter Winner (Nov-Dec)	R200

Annual Prizes

Winner	R400
Second Place	R250
Third Place	R150

Please Note : Only club members are eligible for prizes. Members are in red; non-members are in black.

If you are a member but do not appear here in red, please contact a committee member.

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1627 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1627 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:12

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1627 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test - Iteration 1 , Time 2024/04/25 15:15:12complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1623 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1623 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:12

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1623 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test - Iteration 2 , Time 2024/04/25 15:15:12complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1626 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1626 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:12

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1626 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test - Iteration 3 , Time 2024/04/25 15:15:12complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:12

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test - Iteration 4 , Time 2024/04/25 15:15:12complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:12

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1622 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test - Iteration 5 , Time 2024/04/25 15:15:12complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1628 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:12

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1628 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:12

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1628 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 6 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 7 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 8 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 1.50 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 28 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 9 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1508 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1508 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1508 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 10 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 11 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 12 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 13 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1614 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 14 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 15 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 16 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 17 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1494 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 18 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 19 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 20 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 21 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 70 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 22 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 23 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 24 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 25 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 69 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 26 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 90 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 90 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 90 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 27 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 94 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 94 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 94 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 28 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1118 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1118 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1118 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 29 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 30 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 31 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 32 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1453 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 33 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:13

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:13

Test - Iteration 34 , Time 2024/04/25 15:15:13complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.01 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 35 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.01 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.01 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1355 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 36 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 37 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 38 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1400 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 39 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 40 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 636 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 41 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 42 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 177 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 43 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1624 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1624 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1624 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 44 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 198 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 198 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 198 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 45 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1571 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 46 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 47 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 48 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 49 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 206 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 50 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.01 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 51 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 52 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 53 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 207 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 54 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 55 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1573 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 56 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 57 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 58 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 59 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 257 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 60 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test - Iteration 61 , Time 2024/04/25 15:15:14complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:14

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 62 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 63 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1405 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 64 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 65 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1282 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 66 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1625 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 1.50 AND cr_cp_key = 1625 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1625 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 67 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1612 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1612 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1612 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 68 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 69 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 70 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 71 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 488 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 72 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 651 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 651 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 651 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 73 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1620 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.01 AND cr_cp_key = 1620 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1620 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 74 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 75 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 76 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 77 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1406 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 78 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.51 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 79 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1338 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 80 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 81 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 520 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 82 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 83 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 8.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 84 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 85 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 521 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 86 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 87 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 88 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) - 732 AND CONVERT(DATETIME, '04/01/2024', 101) - 1 , Time 2024/04/25 15:15:15

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1621 AND cd_date BETWEEN CONVERT(DATETIME, '04/01/2024', 101) AND CONVERT(DATETIME, '05/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:15

Test - Iteration 89 , Time 2024/04/25 15:15:15complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 560 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:16

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 2.50 AND cr_cp_key = 560 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:16

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 560 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:16

Test - Iteration 90 , Time 2024/04/25 15:15:16complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:16

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) - 732 AND CONVERT(DATETIME, '01/01/2024', 101) - 1 , Time 2024/04/25 15:15:16

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '01/01/2024', 101) AND CONVERT(DATETIME, '02/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:16

Test - Iteration 91 , Time 2024/04/25 15:15:16complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:16

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:16

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 5.50 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) - 732 AND CONVERT(DATETIME, '02/01/2024', 101) - 1 , Time 2024/04/25 15:15:16

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '02/01/2024', 101) AND CONVERT(DATETIME, '03/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:16

Test - Iteration 92 , Time 2024/04/25 15:15:16complete

Test 210 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:16

Test 300 - sql SELECT MIN(cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss), COUNT(cr_cd_key) FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist = 4.00 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) - 732 AND CONVERT(DATETIME, '03/01/2024', 101) - 1 , Time 2024/04/25 15:15:16

Test 220 - sql SELECT FORMAT(ce_dist,'N') ce_dist, cr_time_hh* 3600 + cr_time_mm * 60 + cr_time_ss FROM kalsabco.dbo.ClubResult, kalsabco.dbo.ClubEventDate, kalsabco.dbo.ClubEvent WHERE cr_cd_key = cd_key AND cd_ce_key = ce_key AND ce_club_key = 1 AND ce_dist > 0 AND cr_cp_key = 1524 AND cd_date BETWEEN CONVERT(DATETIME, '03/01/2024', 101) AND CONVERT(DATETIME, '04/01/2024', 101)-1 ORDER BY 1,2 , Time 2024/04/25 15:15:16

Test - Iteration 93 , Time 2024/04/25 15:15:16complete

---

January  2024

Name	Points
Craig Inggs	8
David Lamont	5
Keenan Clothier	4
Craig Fowels	4
Karen Inggs	3
Fred Schoon	3
Jennifer Sutton	3
Mike Sutton	3
Martin Birtwhistle	2
Sandra Conway	2
Leona Lamont	2
Steve Conway	1
Owethi Ntuli	1
Zama Cele	1
Kelly Schoon	1
Simone Schoon	1
Susan Schoon	1
Marguerite Labuschagne	1
Shane Govender	1
Johannes Van Eden	1
Odette Wheeler	1

---

February  2024

Name	Points
Keenan Clothier	4
Sandra Conway	4
Craig Inggs	4
Karen Inggs	4
David Lamont	4
Leona Lamont	4
Fred Schoon	4
Steve Conway	3
Susan Schoon	3
Donovan Snodgrass	3
Jennifer Sutton	3
Mike Sutton	3
Zama Cele	2
Craig Fowels	2
Shane Govender	2
Jan Van Eden	2
Odette Wheeler	2
Asante .	1
Derek Gace	1
Sihle Lange	1
Hazel Gace	1
Cyril .	1
Garth Hancock	1
Thérèse Hurly	1
Francois De Villiers	1
Ruth De Villiers	1
Marguerite Labuschagne	1

---

March  2024

Name	Points
Keenan Clothier	3
Craig Fowels	3
Derek Gace	3
Hazel Gace	3
David Lamont	3
Fred Schoon	3
Susan Schoon	3
Zara Hardy	2
Craig Inggs	2
Karen Inggs	2
Zama Cele	2
Leona Lamont	2
Sandra Conway	2
Steve Conway	2
Jan Van Eden	2
Odette Wheeler	2
Susan Ferencak	1
Mike Sutton	1
Sihle Lange	1
Martin Birtwhistle	1

---

Quarter 1

Name	Points
Craig Inggs	14
David Lamont	12
Keenan Clothier	11
Fred Schoon	10
Craig Fowels	9
Karen Inggs	9
Leona Lamont	8
Sandra Conway	8
Susan Schoon	7
Mike Sutton	7
Jennifer Sutton	6
Steve Conway	6
Zama Cele	5
Odette Wheeler	5
Hazel Gace	4
Jan Van Eden	4
Derek Gace	4
Shane Govender	3
Donovan Snodgrass	3
Martin Birtwhistle	3
Marguerite Labuschagne	2
Sihle Lange	2
Zara Hardy	2
Owethi Ntuli	1
Thérèse Hurly	1
Kelly Schoon	1
Simone Schoon	1
Cyril .	1
Asante .	1
Francois De Villiers	1
Ruth De Villiers	1
Garth Hancock	1
Johannes Van Eden	1
Susan Ferencak	1

---

April  2024

Name	Points
Craig Inggs	8
Karen Inggs	7
Sandra Conway	6
Mike Sutton	6
Fred Schoon	4
Craig Fowels	4
Leona Lamont	3
Steve Conway	3
David Lamont	3
Keenan Clothier	2
Derek Gace	2
Lily Ngcobo	2
Martin Birtwhistle	2
Susan Schoon	2
Donovan Snodgrass	2
Zama Cele	2
Jan Van Eden	2
Andrew .	1
Sandy Byleveld	1
Charmaine .	1
Hazel Gace	1
Garth Hancock	1
Craig Holtzhausen	1
Cyril .	1
Zara .	1

---

Annual Scores

Name	Points
Craig Inggs	22
Karen Inggs	16
David Lamont	15
Sandra Conway	14
Fred Schoon	14
Keenan Clothier	13
Craig Fowels	13
Mike Sutton	13
Leona Lamont	11
Susan Schoon	9
Steve Conway	9
Zama Cele	7
Jennifer Sutton	6
Derek Gace	6
Jan Van Eden	6
Martin Birtwhistle	5
Hazel Gace	5
Donovan Snodgrass	5
Odette Wheeler	5
Shane Govender	3
Marguerite Labuschagne	2
Zara Hardy	2
Cyril .	2
Sihle Lange	2
Lily Ngcobo	2
Garth Hancock	2
Andrew .	1
Zara .	1
Asante .	1
Owethi Ntuli	1
Francois De Villiers	1
Kelly Schoon	1
Simone Schoon	1
Craig Holtzhausen	1
Thérèse Hurly	1
Ruth De Villiers	1
Susan Ferencak	1
Sandy Byleveld	1
Johannes Van Eden	1
Charmaine .	1

END OF LIST

Formula To Derive Monthly Scores :

• A point will be awarded for each run completed in the month, up to a maximum of 4 points.
• Anyone who takes times will be awarded an attendance point.
• For each week, your time will be compared to your best time over the distance in the last 2 years. If your time is within 1.5% of your best time, you will be awarded points based on the formula (BEST_TIME divided by CURRENT_TIME) * 100 - 98.5 times 2.
• If, however, you have run less than 7 times over this distance in the last 2 years, the score will be reduced by multiplying it by the number of runs and dividing by 7.
• If you have run less than 3 times over the distance in the last 2 years, no score will be awarded for that week.
• Even if you shatter your PB, the maximum points which will be awarded for one week is 7 + 1 attendance point.
• Once your scores have been calculated for all the weeks in a month using this formula, the 2 best scores will be added to your attendance score to give your total score for the month.
• Thus, the maximum score which can be achieved for a month = 4 (attendance) + 7 + 7 = 18 points.
• Bonus points may be awarded at the discretion of the Club Captain and/or Time Trial League Administrator!
If this happens, details will be made known on the web or in the newsletter.