SELECT * FROM 1_Kampe WHERE LigaID = '201' AND (Home='Randers FC' OR Away='Randers FC') 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-12 Randers FC 4-1 Vejle 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 Naestved 1-0 Randers FC 4/-1 9,00 0.00/1 0.00/1 0.00/0 0.00/1   4/3 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2011-08-28 Bronshoj 0-0 Randers FC 2/-4 2,67 0.67/3 0.67/3 1.00/2 0.00/1   4/2 3,00 1.50/2 1.50/2 3.00/1 0.00/1
2011-09-04 Randers FC 2-0 Hobro 4/2 2,00 1.33/3 1.33/3 3.00/1 0.50/2   14/7 5,25 1.75/4 1.75/4 0.50/2 3.00/2
2011-09-11 Jammerbugt 0-1 Randers FC 7/-2 4,00 1.75/4 1.75/4 2.33/3 0.00/1   6/4 2,00 1.75/4 1.75/4 3.00/2 0.50/2
2011-09-16 Randers FC 1-0 Viborg 7/5 1,80 2.00/5 2.00/5 3.00/2 1.33/3   6/4 1,33 1.50/6 1.50/6 2.33/3 0.67/3
2011-09-25 Fredericia 1-1 Randers FC 10/2 2,57 1.14/7 1.14/7 1.00/4 1.33/3   8/6 1,67 2.17/6 2.17/6 3.00/3 1.33/3
2011-10-02 Randers FC 0-0 Esbjerg 9/6 1,71 2.00/7 2.00/7 3.00/3 1.25/4   23/15 3,88 2.63/8 2.63/8 3.00/4 2.25/4
2011-10-16 Randers FC 1-0 Vendsyssel 9/6 1,50 1.88/8 1.88/8 2.50/4 1.25/4   14/-1 3,22 1.78/9 2.00/8 1.75/4 1.80/5
2011-10-19 Slagelse 1-2 Randers FC 15/6 2,40 1.60/10 1.63/8 1.80/5 1.40/5   10/7 1,44 2.00/9 1.88/8 2.60/5 1.25/4
2011-10-23 AB Copenhagen 2-3 Randers FC 16/1 2,82 1.64/11 1.63/8 2.00/6 1.20/5   12/8 1,60 2.10/10 2.25/8 2.60/5 1.60/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   13/-3 2,42 0.92/12 0.50/8 1.50/6 0.33/6
2011-11-06 Skive IK 0-3 Randers FC 10/-13 2,75 1.00/12 1.25/8 1.17/6 0.83/6   18/11 2,08 2.25/12 2.50/8 2.67/6 1.83/6
2011-11-06 Skive 0-3 Randers FC 10/-13 2,75 1.00/12 1.25/8 1.17/6 0.83/6   21/14 2,15 2.31/13 2.50/8 2.67/6 2.00/7
2011-11-20 Vejle 3-0 Randers FC 31/19 3,07 1.86/14 1.88/8 2.43/7 1.29/7   24/17 2,21 2.36/14 2.50/8 2.67/6 2.13/8
2012-04-01 Randers FC 2-1 Naestved 24/14 2,27 2.20/15 2.38/8 2.67/6 1.89/9   15/-20 3,33 0.40/15 0.25/8 0.86/7 0.00/8
2012-04-09 Randers FC 0-1 Bronshoj 26/15 2,31 2.25/16 2.63/8 2.71/7 1.89/9   18/-8 2,59 1.29/17 1.38/8 1.63/8 1.00/9
2012-04-15 Hobro 1-0 Randers FC 33/7 3,28 1.28/18 1.25/8 1.75/8 0.90/10   26/14 2,24 2.12/17 2.25/8 2.38/8 1.89/9
2012-04-22 Randers FC 4-0 Jammerbugt 26/13 2,17 2.00/18 1.88/8 2.38/8 1.70/10   26/-17 3,63 0.74/19 0.50/8 1.00/9 0.50/10
2012-04-27 Viborg 2-2 Randers FC 35/13 2,85 1.55/20 1.38/8 1.56/9 1.55/11   30/17 2,26 2.05/19 1.88/8 2.44/9 1.70/10
2012-05-06 Randers FC 0-1 Fredericia 32/17 2,35 2.00/20 1.63/8 2.44/9 1.64/11   27/5 2,33 1.38/21 1.50/8 1.18/11 1.60/10
2012-05-11 Esbjerg 0-2 Randers FC 53/35 3,23 2.68/22 3.00/8 2.82/11 2.55/11   32/16 2,29 1.90/21 1.25/8 2.20/10 1.64/11
2012-05-21 Randers FC 2-1 Slagelse 34/18 2,27 1.95/22 1.25/8 2.20/10 1.75/12   29/1 2,48 1.30/23 1.13/8 1.17/12 1.45/11
2012-05-25 Vendsyssel 0-2 Randers FC 29/-11 2,88 1.21/24 1.13/8 1.08/12 1.33/12   36/19 2,30 2.00/23 1.63/8 2.27/11 1.75/12
2012-06-01 Randers FC 3-1 AB Copenhagen 38/21 2,29 2.04/24 1.63/8 2.27/11 1.85/13   30/-11 2,84 1.16/25 0.75/8 1.54/13 0.75/12
2012-06-05 Roskilde 1-0 Randers FC 27/-12 2,54 0.92/26 0.50/8 0.92/13 0.92/13   41/23 2,36 2.08/25 2.00/8 2.33/12 1.85/13
2012-06-10 Randers FC 0-3 Skive IK 41/22 2,31 2.00/26 2.00/8 2.33/12 1.71/14   28/-13 2,76 1.24/25 1.50/8 1.38/13 1.08/12
2012-06-10 Randers FC 0-3 Skive 41/19 2,33 1.93/27 1.50/8 2.15/13 1.71/14   28/-13 2,76 1.24/25 1.50/8 1.38/13 1.08/12