SELECT * FROM 1_Kampe WHERE LigaID = '106' AND (Home='Alfortville' OR Away='Alfortville') 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-08-07 Gueugnon 0-2 Alfortville 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-08-14 Alfortville 0-2 Plabennec 2/2 2,00 3.00/1 3.00/1 0.00/0 3.00/1   1/-2 4,00 0.00/1 0.00/1 0.00/1 0.00/0
2010-08-20 Beauvais 2-2 Alfortville 3/2 2,00 2.00/2 2.00/2 1.00/1 3.00/1   2/0 2,00 1.50/2 1.50/2 0.00/1 3.00/1
2010-08-28 Alfortville 1-2 Frejus Saint Raphael 4/0 2,67 1.33/3 1.33/3 0.00/1 2.00/2   2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1
2010-09-04 Pacy Eure 1-0 Alfortville 3/-1 2,33 1.00/3 1.00/3 0.00/1 1.50/2   5/-1 2,75 1.00/4 1.00/4 0.00/2 2.00/2
2010-09-14 Alfortville 1-1 Creteil 5/-2 2,40 0.80/5 0.80/5 0.00/2 1.33/3   5/-1 1,83 1.50/6 1.50/6 2.00/3 1.00/3
2010-09-18 Luzenac 4-0 Alfortville 7/5 1,29 1.57/7 1.57/7 2.00/3 1.25/4   6/-2 2,33 0.83/6 0.83/6 0.33/3 1.33/3
2010-09-24 Alfortville 0-2 Orleans 6/-6 2,57 0.71/7 0.71/7 0.33/3 1.00/4   9/0 2,25 1.13/8 1.13/8 1.75/4 0.50/4
2010-09-28 Amiens 3-1 Alfortville 7/2 1,33 1.78/9 2.00/8 3.00/4 0.80/5   6/-8 2,50 0.63/8 0.63/8 0.25/4 1.00/4
2010-10-02 Alfortville 0-2 Rodez 7/-10 2,67 0.56/9 0.25/8 0.25/4 0.80/5   9/-9 2,70 0.80/10 0.88/8 1.60/5 0.00/5
2010-10-08 Rouen 2-1 Alfortville 13/5 1,91 1.73/11 1.88/8 2.60/5 1.00/6   7/-12 2,60 0.50/10 0.25/8 0.20/5 0.80/5
2010-10-13 Alfortville 1-1 Bayonne 8/-13 2,64 0.45/11 0.13/8 0.20/5 0.67/6   2/-18 1,83 0.50/12 0.63/8 0.50/6 0.50/6
2010-10-23 Strasbourg 4-0 Alfortville 13/3 1,92 1.33/12 1.63/8 2.00/6 0.67/6   9/-13 2,58 0.50/12 0.25/8 0.33/6 0.67/6
2010-11-05 Alfortville 0-0 Cannes 9/-17 2,69 0.46/13 0.25/8 0.33/6 0.57/7   18/11 1,92 1.92/13 1.75/8 1.86/7 2.00/6
2010-11-09 Guingamp 6-3 Alfortville 22/14 2,14 2.07/14 2.50/8 2.71/7 1.43/7   9/-17 2,50 0.50/14 0.25/8 0.43/7 0.57/7
2010-11-13 Alfortville 0-1 Niort 12/-20 2,93 0.47/15 0.25/8 0.43/7 0.50/8   19/5 2,20 1.40/15 1.38/8 1.63/8 1.14/7
2010-11-27 Bastia 1-1 Alfortville 34/24 2,75 2.38/16 3.00/8 2.75/8 2.00/8   12/-21 2,81 0.44/16 0.25/8 0.38/8 0.50/8
2010-12-18 Paris FC 5-1 Alfortville 19/5 1,94 1.47/17 1.25/8 1.78/9 1.13/8   13/-21 2,76 0.47/17 0.38/8 0.38/8 0.56/9
2011-01-12 Alfortville 0-1 Colmar 14/-25 2,94 0.44/18 0.38/8 0.38/8 0.50/10   10/-18 2,11 0.67/18 0.75/8 0.78/9 0.56/9
2011-01-15 Plabennec 1-2 Alfortville 20/-4 2,32 1.26/19 1.13/8 1.60/10 0.89/9   14/-26 2,84 0.42/19 0.38/8 0.33/9 0.50/10
2011-01-22 Alfortville 0-0 Beauvais 16/-25 2,85 0.55/20 0.63/8 0.33/9 0.73/11   31/7 2,62 1.81/21 2.00/8 1.64/11 2.00/10
2011-01-26 Alfortville 0-0 Gap 16/-25 2,71 0.57/21 0.75/8 0.40/10 0.73/11   24/-12 3,00 1.05/20 1.38/8 2.00/10 0.10/10
2011-02-05 Alfortville 1-1 Pacy Eure 16/-25 2,59 0.59/22 0.75/8 0.45/11 0.73/11   23/-4 2,38 1.14/21 1.13/8 1.00/11 1.30/10
2011-02-18 Creteil 3-2 Alfortville 21/-1 1,72 1.36/25 1.50/8 1.08/12 1.62/13   17/-25 2,57 0.61/23 0.88/8 0.50/12 0.73/11
2011-02-26 Alfortville 1-2 Luzenac 19/-26 2,67 0.58/24 0.88/8 0.50/12 0.67/12   22/0 1,76 1.16/25 0.38/8 1.83/12 0.54/13
2011-03-05 Orleans 0-1 Alfortville 35/6 2,37 1.37/27 2.50/8 1.62/13 1.14/14   20/-27 2,68 0.56/25 0.75/8 0.46/13 0.67/12
2011-03-09 Frejus Saint Raphael 2-1 Alfortville 31/5 2,19 1.62/26 1.50/8 2.25/12 1.07/14   21/-26 2,62 0.65/26 1.13/8 0.46/13 0.85/13
2011-03-12 Alfortville 2-4 Amiens 22/-27 2,63 0.63/27 1.13/8 0.46/13 0.79/14   38/21 1,96 2.07/28 2.75/8 2.71/14 1.43/14
2011-03-19 Rodez 4-0 Alfortville 29/-20 2,69 0.97/29 1.25/8 1.43/14 0.53/15   24/-29 2,75 0.61/28 0.75/8 0.43/14 0.79/14
2011-03-26 Alfortville 1-2 Rouen 24/-33 2,79 0.59/29 0.63/8 0.43/14 0.73/15   38/12 2,13 1.67/30 1.88/8 2.27/15 1.07/15
2011-04-02 Bayonne 0-4 Alfortville 30/-15 2,42 1.13/31 2.00/8 1.47/15 0.81/16   25/-34 2,80 0.57/30 0.50/8 0.40/15 0.73/15
2011-04-09 Alfortville 1-3 Strasbourg 29/-30 2,84 0.65/31 0.75/8 0.40/15 0.88/16   42/21 1,97 1.84/32 2.50/8 2.13/16 1.56/16
2011-04-16 Cannes 3-0 Alfortville 37/10 2,00 1.66/32 1.38/8 2.19/16 1.13/16   30/-32 2,88 0.63/32 0.75/8 0.38/16 0.88/16
2011-04-22 Alfortville 0-6 Guingamp 30/-35 2,88 0.61/33 0.75/8 0.38/16 0.82/17   64/35 2,82 1.94/33 2.25/8 2.41/17 1.44/16
2011-04-26 Niort 2-0 Alfortville 36/1 2,09 1.26/34 1.00/8 1.76/17 0.76/17   30/-41 2,97 0.59/34 0.38/8 0.35/17 0.82/17
2011-04-30 Alfortville 0-4 Bastia 30/-43 2,94 0.57/35 0.38/8 0.35/17 0.78/18   70/49 2,60 2.31/35 2.25/8 2.44/18 2.18/17
2011-05-07 Colmar 0-0 Alfortville 26/-19 1,97 0.94/36 1.50/8 0.94/18 0.94/18   30/-47 2,97 0.56/36 0.38/8 0.33/18 0.78/18
2011-05-13 Alfortville 2-1 Paris FC 30/-47 2,89 0.57/37 0.50/8 0.33/18 0.79/19   38/-2 2,11 1.22/37 0.88/8 1.58/19 0.83/18
2011-05-20 Gap 1-1 Alfortville 39/-21 2,61 1.00/38 0.63/8 1.53/19 0.47/19   32/-46 2,89 0.63/38 0.88/8 0.47/19 0.79/19
2011-05-27 Alfortville 0-0 Gueugnon 33/-46 2,87 0.64/39 0.63/8 0.47/19 0.80/20   21/-36 2,00 0.41/39 0.00/8 0.40/20 0.42/19