SELECT * FROM 1_Kampe WHERE LigaID = '195' AND (Home='Sonderjyske' OR Away='Sonderjyske') 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
2010-07-18 Sonderjyske 1-3 FC Copenhagen 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
2010-07-25 Nordsjaelland 1-2 Sonderjyske 4/3 5,00 3.00/1 3.00/1 3.00/1 0.00/0   1/-2 4,00 0.00/1 0.00/1 0.00/1 0.00/0
2010-07-31 Sonderjyske 3-0 Esbjerg 3/-1 3,50 1.50/2 1.50/2 0.00/1 3.00/1   1/-4 3,00 0.00/2 0.00/2 0.00/1 0.00/1
2010-08-08 Lyngby 1-0 Sonderjyske 5/-1 3,67 1.33/3 1.33/3 1.50/2 1.00/1   6/2 3,33 2.00/3 2.00/3 1.50/2 3.00/1
2010-08-14 Sonderjyske 1-3 Odense 6/1 2,75 1.50/4 1.50/4 1.50/2 1.50/2   6/1 2,75 1.00/4 1.00/4 1.33/3 0.00/1
2010-08-22 Sonderjyske 2-0 Horsens 7/-1 3,00 1.20/5 1.20/5 1.00/3 1.50/2   3/-1 1,40 1.40/5 1.40/5 1.33/3 1.50/2
2010-08-29 Randers FC 0-0 Sonderjyske 7/0 2,33 1.50/6 1.50/6 2.00/3 1.00/3   9/1 2,83 1.50/6 1.50/6 1.50/4 1.50/2
2010-09-12 Brondby 3-1 Sonderjyske 14/4 3,43 1.71/7 1.71/7 1.67/3 1.75/4   9/1 2,43 1.43/7 1.43/7 1.50/4 1.33/3
2010-09-19 Sonderjyske 0-2 Midtjylland 10/-1 2,63 1.25/8 1.25/8 1.50/4 1.00/4   15/10 2,50 2.00/8 2.00/8 2.50/4 1.50/4
2010-09-25 Aalborg 0-2 Sonderjyske 11/-3 2,78 1.00/9 0.75/8 0.25/4 1.60/5   10/-3 2,56 1.11/9 1.25/8 1.20/5 1.00/4
2010-10-03 Silkeborg 3-1 Sonderjyske 13/-3 2,90 1.00/10 1.25/8 1.25/4 0.83/6   12/-1 2,50 1.30/10 1.25/8 1.20/5 1.40/5
2010-10-16 Sonderjyske 1-0 Aalborg 13/-3 2,64 1.18/11 0.88/8 1.20/5 1.17/6   12/-6 2,73 0.82/11 0.63/8 0.17/6 1.60/5
2010-10-25 Odense 1-2 Sonderjyske 19/-1 3,25 1.42/12 1.63/8 1.67/6 1.17/6   14/-2 2,50 1.33/12 1.25/8 1.50/6 1.17/6
2010-10-31 Sonderjyske 1-2 Silkeborg 16/-1 2,54 1.46/13 1.63/8 1.50/6 1.43/7   17/-4 2,92 1.08/13 1.50/8 1.33/6 0.86/7
2010-11-07 Lyngby 1-0 Sonderjyske 21/-5 3,36 1.29/14 1.38/8 1.57/7 1.00/7   17/-2 2,57 1.36/14 1.25/8 1.29/7 1.43/7
2010-11-14 Sonderjyske 3-3 FC Copenhagen 17/-3 2,47 1.27/15 1.13/8 1.29/7 1.25/8   39/29 3,27 2.73/15 2.75/8 2.56/9 3.00/6
2010-11-21 Sonderjyske 0-3 Horsens 20/-3 2,69 1.25/16 1.25/8 1.25/8 1.25/8   13/-11 2,31 1.25/16 1.25/8 1.00/8 1.50/8
2010-11-28 Nordsjaelland 1-1 Sonderjyske 18/-8 2,59 1.06/17 1.00/8 1.38/8 0.78/9   20/-6 2,71 1.18/17 1.25/8 1.11/9 1.25/8
2010-12-05 Sonderjyske 1-1 Randers FC 21/-6 2,67 1.17/18 1.00/8 1.11/9 1.22/9   21/-3 2,50 1.00/18 0.75/8 1.33/9 0.67/9
2011-03-06 Esbjerg 0-1 Sonderjyske 22/-9 2,79 0.89/19 0.63/8 0.67/9 1.10/10   22/-6 2,63 1.16/19 1.13/8 1.10/10 1.22/9
2011-03-13 Brondby 2-0 Sonderjyske 32/5 2,95 1.55/20 1.88/8 1.60/10 1.50/10   23/-5 2,55 1.25/20 1.13/8 1.10/10 1.40/10
2011-03-21 Sonderjyske 2-1 Midtjylland 23/-7 2,52 1.19/21 0.75/8 1.10/10 1.27/11   35/12 2,90 1.65/20 1.63/8 1.73/11 1.56/9
2011-04-03 Randers FC 0-0 Sonderjyske 29/3 2,50 1.18/22 1.50/8 1.50/10 0.92/12   25/-6 2,55 1.27/22 1.13/8 1.27/11 1.27/11
2011-04-10 Sonderjyske 0-2 Nordsjaelland 25/-6 2,43 1.26/23 1.25/8 1.27/11 1.25/12   24/-12 2,61 1.04/23 1.13/8 1.36/11 0.75/12
2011-04-17 Horsens 1-1 Sonderjyske 20/-9 2,04 1.25/24 1.25/8 1.17/12 1.33/12   25/-8 2,42 1.21/24 1.13/8 1.17/12 1.25/12
2011-04-20 Silkeborg 1-0 Sonderjyske 32/-5 2,76 1.28/25 1.38/8 1.67/12 0.92/13   26/-8 2,40 1.20/25 1.25/8 1.17/12 1.23/13
2011-04-25 Sonderjyske 0-2 Odense 26/-9 2,35 1.15/26 1.13/8 1.17/12 1.14/14   44/9 3,04 1.58/26 1.50/8 1.77/13 1.38/13
2011-05-01 FC Copenhagen 3-0 Sonderjyske 65/43 3,22 2.59/27 2.38/8 2.71/14 2.46/13   26/-11 2,33 1.11/27 1.00/8 1.08/13 1.14/14
2011-05-09 Midtjylland 2-1 Sonderjyske 43/9 2,75 1.46/28 1.00/8 1.71/14 1.21/14   26/-14 2,36 1.07/28 0.63/8 1.08/13 1.07/15
2011-05-15 Sonderjyske 1-0 Lyngby 27/-15 2,38 1.03/29 0.63/8 1.08/13 1.00/16   38/-11 3,00 1.10/29 1.00/8 1.50/14 0.73/15
2011-05-19 Sonderjyske 2-1 Esbjerg 28/-14 2,33 1.10/30 0.63/8 1.21/14 1.00/16   31/-13 2,50 0.97/30 1.13/8 0.75/16 1.21/14
2011-05-25 Aalborg 1-2 Sonderjyske 37/-7 2,61 1.13/31 1.88/8 1.00/16 1.27/15   30/-13 2,35 1.16/31 0.88/8 1.33/15 1.00/16
2011-05-29 Sonderjyske 0-2 Brondby 32/-12 2,38 1.22/32 1.25/8 1.33/15 1.12/17   50/11 2,78 1.50/32 1.50/8 1.53/17 1.47/15