SELECT * FROM 1_Kampe WHERE LigaID = '90' AND (Home='Amiens' OR Away='Amiens') 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
2016-08-01 Amiens 1-1 Reims 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
2016-08-06 Strasbourg 1-0 Amiens 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-12 Amiens 2-0 Niort 1/-1 1,50 0.50/2 0.50/2 1.00/1 0.00/1   1/0 1,00 1.00/2 1.00/2 1.00/1 1.00/1
2016-08-20 Lens 0-1 Amiens 4/2 2,00 1.67/3 1.67/3 1.00/1 2.00/2   3/1 1,67 1.33/3 1.33/3 2.00/2 0.00/1
2016-08-26 Nimes 2-3 Amiens 1/-3 1,25 0.50/4 0.50/4 0.50/2 0.50/2   4/2 1,50 1.75/4 1.75/4 2.00/2 1.50/2
2016-09-09 Amiens 3-1 Tours 7/3 2,20 2.00/5 2.00/5 2.00/2 2.00/3   8/1 3,00 1.20/5 1.20/5 0.67/3 2.00/2
2016-09-20 Amiens 0-0 Valenciennes 10/5 2,50 2.17/6 2.17/6 2.33/3 2.00/3   9/3 2,14 1.43/7 1.43/7 2.00/4 0.67/3
2016-09-23 Orleans 1-2 Amiens 9/-2 2,50 1.00/8 1.00/8 1.75/4 0.25/4   10/5 2,14 2.00/7 2.00/7 2.00/4 2.00/3
2016-09-27 GFC Ajaccio 1-1 Amiens 5/-2 1,50 1.25/8 1.25/8 0.75/4 1.75/4   12/6 2,25 2.13/8 2.13/8 2.00/4 2.25/4
2016-09-30 Amiens 0-1 Troyes 13/6 2,22 2.00/9 2.13/8 2.00/4 2.00/5   13/0 2,89 1.33/9 1.50/8 1.60/5 1.00/4
2016-10-14 Bourg en Bresse 2-4 Amiens 10/-2 2,20 1.10/10 1.25/8 1.20/5 1.00/5   13/5 2,10 1.80/10 2.13/8 1.60/5 2.00/5
2016-10-24 Amiens 0-0 Red Star 17/7 2,45 1.91/11 2.13/8 1.60/5 2.17/6   7/-5 1,73 1.00/11 1.13/8 1.00/6 1.00/5
2016-10-29 Clermont 1-0 Amiens 11/-3 2,08 1.08/12 1.13/8 1.00/6 1.17/6   17/7 2,25 1.83/12 1.88/8 1.50/6 2.17/6
2016-11-04 Amiens 0-0 Auxerre 17/6 2,15 1.69/13 1.50/8 1.50/6 1.86/7   8/-10 2,00 0.69/13 0.50/8 0.67/6 0.71/7
2016-11-19 Le Havre 0-0 Amiens 18/6 2,14 1.79/14 2.00/8 1.83/6 1.75/8   17/6 2,00 1.64/14 1.25/8 1.43/7 1.86/7
2016-11-26 Amiens 3-0 Brest 17/6 1,87 1.60/15 1.25/8 1.43/7 1.75/8   22/6 2,53 1.87/15 1.75/8 1.88/8 1.86/7
2016-11-29 AC Ajaccio 1-1 Amiens 17/-1 2,19 1.25/16 1.13/8 2.00/8 0.50/8   20/9 1,94 1.69/16 1.25/8 1.63/8 1.75/8
2016-12-09 Amiens 0-1 Sochaux 21/9 1,94 1.65/17 1.25/8 1.63/8 1.67/9   17/3 1,82 1.53/17 1.38/8 1.56/9 1.50/8
2016-12-16 Laval 2-2 Amiens 12/-6 1,67 0.83/18 0.88/8 0.75/8 0.90/10   21/8 1,89 1.56/18 1.25/8 1.44/9 1.67/9
2017-01-14 Amiens 4-3 Strasbourg 23/8 2,00 1.53/19 1.00/8 1.44/9 1.60/10   25/6 2,32 1.68/19 2.25/8 2.00/10 1.33/9
2017-01-20 Niort 2-1 Amiens 24/-3 2,55 1.30/20 1.50/8 1.40/10 1.20/10   27/9 2,25 1.60/20 1.25/8 1.60/10 1.60/10
2017-01-28 Amiens 2-1 Lens 28/8 2,29 1.52/21 1.25/8 1.60/10 1.45/11   29/6 2,48 1.67/21 1.75/8 1.60/10 1.73/11
2017-02-03 Amiens 1-2 Nimes 30/9 2,32 1.59/22 1.50/8 1.73/11 1.45/11   32/5 2,68 1.36/22 1.38/8 0.91/11 1.82/11
2017-02-07 Tours 0-3 Amiens 25/-9 2,68 0.91/22 1.25/8 0.83/12 1.00/10   31/8 2,35 1.52/23 1.38/8 1.58/12 1.45/11
2017-02-10 Amiens 4-0 GFC Ajaccio 34/11 2,38 1.58/24 1.38/8 1.58/12 1.58/12   25/2 2,00 1.33/24 1.50/8 1.50/12 1.17/12
2017-02-17 Valenciennes 1-1 Amiens 32/1 2,52 1.20/25 1.00/8 1.42/12 1.00/13   38/15 2,44 1.64/25 1.63/8 1.69/13 1.58/12
2017-02-24 Amiens 0-2 Orleans 39/15 2,42 1.62/26 1.75/8 1.69/13 1.54/13   24/-9 2,19 1.04/26 1.50/8 1.57/14 0.42/12
2017-03-04 Troyes 4-0 Amiens 33/6 2,22 1.52/27 1.13/8 2.00/14 1.00/13   39/13 2,41 1.56/27 1.63/8 1.57/14 1.54/13
2017-03-10 Amiens 2-1 Bourg en Bresse 39/9 2,46 1.50/28 1.25/8 1.57/14 1.43/14   37/1 2,61 1.36/28 1.63/8 1.60/15 1.08/13
2017-03-17 Red Star 0-1 Amiens 28/-11 2,31 1.07/29 1.13/8 1.13/15 1.00/14   41/10 2,48 1.55/29 1.63/8 1.67/15 1.43/14
2017-03-31 Amiens 0-1 Clermont 42/11 2,43 1.60/30 1.63/8 1.67/15 1.53/15   33/1 2,17 1.23/30 1.00/8 1.20/15 1.27/15
2017-04-07 Auxerre 1-0 Amiens 21/-15 1,84 0.94/31 1.25/8 1.00/15 0.88/16   42/10 2,39 1.55/31 1.63/8 1.56/16 1.53/15
2017-04-14 Amiens 2-0 Le Havre 42/9 2,34 1.50/32 1.25/8 1.56/16 1.44/16   30/4 1,75 1.38/32 1.75/8 1.44/16 1.31/16
2017-04-22 Brest 2-3 Amiens 46/12 2,42 1.79/33 1.75/8 1.81/16 1.76/17   44/11 2,33 1.55/33 1.25/8 1.65/17 1.44/16
2017-04-28 Amiens 2-1 AC Ajaccio 47/12 2,41 1.59/34 1.50/8 1.65/17 1.53/17   41/-10 2,71 1.24/34 1.13/8 1.82/17 0.65/17
2017-05-05 Sochaux 1-2 Amiens 34/-3 2,03 1.29/35 0.88/8 1.35/17 1.22/18   49/13 2,43 1.63/35 1.88/8 1.72/18 1.53/17
2017-05-12 Amiens 3-0 Laval 51/14 2,44 1.67/36 2.25/8 1.72/18 1.61/18   32/-15 2,19 0.83/36 0.63/8 0.94/18 0.72/18
2017-05-19 Reims 1-2 Amiens 41/4 2,11 1.49/37 0.75/8 1.78/18 1.21/19   54/17 2,46 1.70/37 2.25/8 1.79/19 1.61/18