SE ALLE RESULTATER

# Spillere resultat spilledagsid indtastet
1Dennis Rasmussen mod Susanne Pedersen11-7, 12-712021-06-17 14:13:35
2Lilian Krogh mod Henrik Jensen12-10, 8-12, 11-212021-06-17 14:14:18
3Martin Olsen mod Thomas Pedersen12-5, 12-022021-06-17 14:15:05
4Thomas Pedersen mod Susanne Pedersen9-11, 11-8, 8-1122021-06-17 14:16:20
5Thomas Pedersen mod Henrik Jensen11-3, 11-722021-06-17 14:16:54
6Lars Friis Rasmussen mod Martin Olsen7-11, 5-1222021-06-17 14:17:37
7Martin Olsen mod Thomas Pedersen11-6, 12-432021-06-17 14:18:29
8Dan Wilcox mod Dennis Rasmussen12-3, 11-932021-06-17 14:19:09
9Thomas Pedersen mod Susanne Pedersen4-11, 9-1132021-06-17 14:20:08
10Martin Olsen mod Dan Wilcox12-2, 12-1032021-06-17 14:20:41
11Anja Støvring mod Lars Friis Rasmussen12-6, 11-432021-06-17 14:21:14
12Anja Støvring mod Thomas Pedersen12-1, 11-242021-06-17 14:23:02
13Thomas Pedersen mod Dan Wilcox8-12, 6-1242021-06-17 14:23:35
14Susanne Pedersen mod Martin Olsen4-12, 5-1242021-06-17 14:24:13
15Anja Støvring mod Susanne Pedersen11-2, 11-542021-06-17 14:24:48
16Henrik Jensen mod Susanne Pedersen0-12, 10-1252021-06-17 14:26:00
17Thomas Pedersen mod Susanne Pedersen5-12, 8-1152021-06-17 14:26:42
18Lars Friis Rasmussen mod Henrik Jensen11-7, 12-052021-06-17 14:27:18
19Lars Friis Rasmussen mod Lilian Krogh12-7, 12-452021-06-17 14:27:47
20Thomas Pedersen mod Susanne Pedersen11-4, 13-1062021-06-17 14:28:36
21Lars Friis Rasmussen mod Thomas Pedersen11-8, 10-12, 12-462021-06-17 14:29:19
22Lars Friis Rasmussen mod Martin Olsen2-11, 6-1172021-06-17 19:57:51
23Henrik Jensen mod Lilian Krogh4-12, 6-1172021-06-17 20:31:31
24Lars Friis Rasmussen mod Anja Støvring12-4, 6-12, 4-1172021-06-17 21:23:48
25Lilian Krogh mod Anja Støvring2-12, 0-1272021-06-17 21:47:57
26Thomas Pedersen mod Martin Olsen5-12, 7-1282021-06-24 16:00:03
27Mads Hvid mod Thomas Pedersen0-12, 4-1182021-06-25 16:59:28
28Henrik Jensen mod Thomas Pedersen6-12, 0-1282021-06-25 17:05:09
29Henrik Jensen mod Martin Olsen5-12, 4-1182021-06-25 17:08:47
30Mads Hvid mod Dennis Rasmussen12-8, 6-12, 12-2102021-07-29 15:38:18
31Henrik Jensen mod Martin Olsen0-12, 0-11112021-07-29 15:45:00
32Lars Friis Rasmussen mod Dan Wilcox12-7, 2-12, 7-11112021-07-29 15:53:42
33Anja Støvring mod Mads Hvid11-7, 11-5122021-07-30 10:50:09
34Lars Friis Rasmussen mod Anja Støvring7-11, 5-11132021-08-12 16:09:17
35Thomas Pedersen mod Dan Wilcox11-2, 11-8142021-08-12 16:18:28
36Henrik Jensen mod Thomas Pedersen12-8, 8-11, 2-12142021-08-12 17:13:47
37Susanne Pedersen mod Dan Wilcox2-12, 11-6, 12-8142021-08-12 18:49:55
38Henrik Jensen mod Lilian Krogh11-9, 10-13, 8-11142021-08-15 11:24:16
39Dan Wilcox mod Susanne Pedersen12-9, 11-7152021-08-20 02:36:57

/* SELECT DISTINCT Log.KampId AS Kamp, Spiller1.Navn AS Spiller1, Spiller2.Navn AS Spiller2, concat(Kampe.Set1_1,'-',Kampe.Set1_2, ', ',Kampe.Set2_1,'-',Kampe.Set2_2, IFNULL(concat(', ',Kampe.Set3_1,'-',Kampe.Set3_2),'')) as resultatet, SpilleDag.start, Log.SpilledagId, Log.HændelsesId, MAX(Log.Timestamp) AS Tidspunkt from udfordringslisteLog AS Log LEFT JOIN udfordringslisteSpillere AS Spiller1 ON Log.Spiller1Id = Spiller1.Id LEFT JOIN udfordringslisteSpillere AS Spiller2 ON Log.Spiller2Id = Spiller2.Id LEFT JOIN udfordringslisteSpilledage AS SpilleDag ON Log.SpilledagId = SpilleDag.id INNER JOIN udfordringslisteKampe Kampe ON Log.KampId=Kampe.Id GROUP BY Log.KampId ASC */