SELECT * FROM 1_Kampe WHERE LigaID = '201' AND (Home='Roskilde' OR Away='Roskilde') ORDER BY Dato ASC;
Dato Home Score Away H Goals/Dif A Goals Av. H Avp/M H Avp Last/M H Avp Home/M H Avp Away/M   A Goals/Dif A Goals Av. A Avp/M A Avp Last/M A Avp Home/M A Avp Away/M
2011-08-13 Hobro 1-1 Roskilde 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2011-08-21 Roskilde 5-1 Jammerbugt 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0
2011-08-28 Viborg 1-0 Roskilde 4/3 2,50 1.50/2 1.50/2 3.00/1 0.00/1   6/4 4,00 2.00/2 2.00/2 3.00/1 1.00/1
2011-09-04 Roskilde 3-2 Fredericia 6/3 3,00 1.33/3 1.33/3 3.00/1 0.50/2   8/5 3,67 2.33/3 2.33/3 2.00/2 3.00/1
2011-09-11 Esbjerg 1-0 Roskilde 12/5 4,75 2.25/4 2.25/4 3.00/2 1.50/2   9/4 3,50 1.75/4 1.75/4 3.00/2 0.50/2
2011-09-18 Roskilde 0-2 Slagelse 9/3 3,00 1.40/5 1.40/5 3.00/2 0.33/3   10/2 3,60 1.40/5 1.40/5 2.33/3 0.00/2
2011-09-25 Vendsyssel 0-0 Roskilde 8/-5 3,50 1.50/6 1.50/6 2.00/3 1.00/3   9/1 2,83 1.17/6 1.17/6 2.00/3 0.33/3
2011-10-02 Roskilde 0-1 AB Copenhagen 9/1 2,43 1.14/7 1.14/7 2.00/3 0.50/4   9/0 2,57 1.29/7 1.29/7 1.50/4 1.00/3
2011-10-09 Roskilde 2-0 Naestved 9/0 2,25 1.00/8 1.00/8 1.50/4 0.50/4   10/-11 3,88 0.63/8 0.63/8 1.25/4 0.00/4
2011-10-16 Skive 2-1 Roskilde 7/-12 2,89 0.67/9 0.63/8 0.25/4 1.00/5   11/2 2,22 1.22/9 1.25/8 1.80/5 0.50/4
2011-10-23 Roskilde 0-3 Vejle 12/1 2,30 1.10/10 0.88/8 1.80/5 0.40/5   20/10 3,00 1.60/10 1.63/8 2.20/5 1.00/5
2011-10-30 Randers FC 3-1 Roskilde 15/9 1,91 2.18/11 2.50/8 2.60/5 1.83/6   12/-2 2,36 1.00/11 0.88/8 1.50/6 0.40/5
2011-11-06 Roskilde 0-2 Bronshoj 13/-4 2,50 0.92/12 0.50/8 1.50/6 0.33/6   11/-5 2,25 1.25/12 1.25/8 1.50/6 1.00/6
2011-11-13 Roskilde 3-2 Hobro 13/-6 2,46 0.85/13 0.50/8 1.29/7 0.33/6   21/3 3,00 1.08/13 0.88/8 1.33/6 0.86/7
2012-04-05 Jammerbugt 1-2 Roskilde 20/-12 3,71 0.79/14 0.88/8 1.00/6 0.63/8   16/-5 2,64 1.00/14 0.88/8 1.50/8 0.33/6
2012-04-09 Roskilde 0-4 Viborg 18/-4 2,67 1.13/15 1.13/8 1.50/8 0.71/7   25/9 2,73 1.60/15 1.88/8 1.71/7 1.50/8
2012-04-15 Fredericia 1-3 Roskilde 20/4 2,25 1.38/16 1.50/8 1.50/8 1.25/8   18/-8 2,75 1.06/16 1.13/8 1.33/9 0.71/7
2012-04-22 Roskilde 1-2 Esbjerg 21/-6 2,82 1.18/17 1.13/8 1.33/9 1.00/8   42/27 3,35 2.59/17 3.00/8 2.78/9 2.38/8
2012-04-29 Slagelse 0-1 Roskilde 26/0 2,89 1.33/18 1.13/8 1.11/9 1.56/9   22/-7 2,83 1.11/18 1.13/8 1.20/10 1.00/8
2012-05-06 Roskilde 0-1 Vendsyssel 23/-6 2,74 1.21/19 1.50/8 1.20/10 1.22/9   24/-8 2,95 1.21/19 1.00/8 1.30/10 1.11/9
2012-05-11 AB Copenhagen 2-1 Roskilde 23/-11 2,85 1.05/20 0.75/8 1.40/10 0.70/10   23/-7 2,65 1.15/20 1.50/8 1.09/11 1.22/9
2012-05-20 Naestved 1-0 Roskilde 25/-18 3,24 0.71/21 1.13/8 1.20/10 0.27/11   24/-8 2,67 1.10/21 1.50/8 1.09/11 1.10/10
2012-05-27 Roskilde 0-1 Skive 24/-9 2,59 1.05/22 1.13/8 1.09/11 1.00/11   25/-14 2,78 1.17/23 1.50/8 1.38/13 0.90/10
2012-06-02 Vejle 2-2 Roskilde 52/25 3,29 1.67/24 1.38/8 2.18/11 1.23/13   24/-10 2,52 1.00/23 0.75/8 1.00/12 1.00/11
2012-06-05 Roskilde 1-0 Randers FC 26/-10 2,58 1.00/24 0.88/8 1.00/12 1.00/12   38/20 2,33 2.04/24 2.00/8 2.33/12 1.75/12
2012-06-10 Bronshoj 2-1 Roskilde 33/0 2,64 1.48/25 1.25/8 1.50/12 1.46/13   27/-9 2,52 1.08/25 0.88/8 1.15/13 1.00/12
2018-10-21 Roskilde 1-3 Skive IK 28/-10 2,54 1.04/26 0.88/8 1.15/13 0.92/13   29/-2 4,00 1.40/15 1.88/8 0.00/8 3.00/7
2018-10-21 Skive IK 1-3 Roskilde 7/2 4,00 2.00/3 1.88/8 0.00/1 3.00/2   29/-12 2,59 1.00/27 0.88/8 1.07/14 0.92/13