SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Bastia' OR Away='Bastia') 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-12 Bastia 0-1 PSG 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-12 Bastia 0-1 Paris SG 0/-1 1,00 0.00/1 0.00/2 0.00/1 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2016-08-20 Lorient 0-3 Bastia 2/-1 5,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-2 1,00 0.00/2 0.00/2 0.00/2 0.00/0
2016-08-27 Caen 2-0 Bastia 3/-1 3,50 1.50/2 1.50/2 3.00/1 0.00/1   3/1 1,67 1.00/3 1.00/3 0.00/2 3.00/1
2016-09-10 Bastia 2-1 Toulouse 3/-1 1,75 0.75/4 0.75/4 0.00/2 1.50/2   4/3 1,67 1.67/3 1.67/3 3.00/1 1.00/2
2016-09-18 St Etienne 1-0 Bastia 7/1 2,60 1.20/5 1.20/5 2.00/2 0.67/3   5/0 2,00 1.20/5 1.20/5 1.00/3 1.50/2
2016-09-21 Bastia 0-0 Nancy 5/-1 1,83 1.00/6 1.00/6 1.00/3 1.00/3   3/-5 2,20 0.80/5 0.80/5 0.33/3 1.50/2
2016-09-24 Bastia 1-0 Guingamp 5/-1 1,57 1.00/7 1.00/7 1.00/4 1.00/3   9/3 2,50 1.83/6 1.83/6 2.33/3 1.33/3
2016-10-01 Nantes 1-0 Bastia 3/-5 1,57 0.71/7 0.71/7 0.33/3 1.00/4   6/0 1,50 1.25/8 1.25/8 1.40/5 1.00/3
2016-10-15 Bastia 1-2 Angers 6/-1 1,44 1.11/9 1.25/8 1.40/5 0.75/4   8/-1 2,13 1.25/8 1.25/8 1.75/4 0.75/4
2016-10-22 Lille 2-1 Bastia 8/-7 2,56 0.78/9 0.88/8 1.50/4 0.20/5   7/-2 1,60 1.00/10 1.25/8 1.17/6 0.75/4
2016-10-29 Bastia 0-0 Dijon 8/-3 1,73 0.91/11 0.88/8 1.17/6 0.60/5   13/-4 2,73 1.09/11 1.13/8 1.83/6 0.20/5
2016-11-05 Lyon 2-1 Bastia 18/3 3,00 1.45/11 1.25/8 1.80/5 1.17/6   8/-3 1,58 0.92/12 1.00/8 1.14/7 0.60/5
2016-11-19 Bastia 1-1 Montpellier 9/-4 1,69 0.85/13 0.63/8 1.14/7 0.50/6   19/-7 3,75 1.17/12 1.13/8 1.83/6 0.50/6
2016-11-27 Nice 1-1 Bastia 25/16 2,62 2.46/13 2.63/8 2.71/7 2.17/6   10/-4 1,71 0.86/14 0.75/8 1.13/8 0.50/6
2016-11-30 Bastia 1-1 Bordeaux 11/-4 1,73 0.87/15 0.75/8 1.13/8 0.57/7   19/1 2,47 1.53/15 1.25/8 2.00/7 1.13/8
2016-12-03 Monaco 5-0 Bastia 47/30 4,00 2.25/16 2.13/8 2.75/8 1.75/8   12/-4 1,75 0.88/16 0.50/8 1.11/9 0.57/7
2016-12-10 Bastia 2-0 Metz 12/-9 1,94 0.82/17 0.50/8 1.11/9 0.50/8   16/-16 3,00 1.13/16 0.63/8 1.14/7 1.11/9
2016-12-17 Rennes 1-2 Bastia 18/-6 2,33 1.50/18 1.25/8 2.56/9 0.44/9   14/-7 1,94 0.94/18 0.88/8 1.30/10 0.50/8
2016-12-21 Bastia 1-2 Marseille 16/-6 2,00 1.05/19 1.25/8 1.30/10 0.78/9   20/2 2,00 1.47/19 1.75/8 2.33/9 0.70/10
2017-01-14 Nancy 1-0 Bastia 16/-9 2,05 1.05/20 1.50/8 1.30/10 0.80/10   17/-7 2,05 1.00/20 1.13/8 1.18/11 0.78/9
2017-01-20 Bastia 1-1 Nice 17/-8 2,00 0.95/21 1.13/8 1.18/11 0.70/10   36/21 2,43 2.19/21 1.75/8 2.45/11 1.90/10
2017-01-28 Bastia 1-1 Caen 18/-8 2,00 0.95/22 1.13/8 1.17/12 0.70/10   23/-18 3,05 1.00/21 1.00/8 1.82/11 0.10/10
2017-02-04 Montpellier 2-1 Bastia 33/-6 3,13 1.13/23 1.25/8 2.00/11 0.33/12   19/-8 2,00 0.96/23 1.13/8 1.15/13 0.70/10
2017-02-11 Toulouse 4-1 Bastia 29/2 2,24 1.32/25 1.00/8 1.92/13 0.67/12   20/-9 2,04 0.92/24 1.00/8 1.15/13 0.64/11
2017-02-17 Bastia 1-1 Monaco 21/-12 2,16 0.88/25 1.00/8 1.15/13 0.58/12   79/54 3,85 2.30/27 2.50/8 2.64/14 1.92/13
2017-02-25 Angers 3-0 Bastia 22/-13 2,11 1.11/27 1.38/8 1.54/13 0.71/14   22/-12 2,15 0.88/26 0.75/8 1.14/14 0.58/12
2017-03-01 Bastia 2-2 Nantes 22/-15 2,19 0.85/27 0.38/8 1.14/14 0.54/13   22/-17 2,18 1.18/28 1.38/8 1.20/15 1.15/13
2017-03-04 Bastia 0-0 St Etienne 24/-15 2,25 0.86/28 0.50/8 1.13/15 0.54/13   32/9 1,96 1.43/28 1.63/8 1.86/14 1.00/14
2017-03-11 Guingamp 5-0 Bastia 34/-3 2,45 1.31/29 0.63/8 1.93/14 0.73/15   24/-15 2,17 0.86/29 0.63/8 1.13/16 0.54/13
2017-03-17 Metz 1-0 Bastia 28/-28 2,90 1.10/29 1.13/8 1.54/13 0.75/16   24/-20 2,27 0.83/30 0.50/8 1.13/16 0.50/14
2017-04-01 Bastia 0-1 Lille 24/-21 2,23 0.81/31 0.38/8 1.13/16 0.47/15   30/-10 2,19 1.06/32 1.00/8 1.13/16 1.00/16
2017-04-08 Dijon 1-2 Bastia 40/-14 2,85 0.88/33 0.63/8 1.25/16 0.53/17   24/-22 2,19 0.78/32 0.38/8 1.06/17 0.47/15
2017-04-16 Bastia 0-3 Lyon 26/-21 2,21 0.85/33 0.75/8 1.06/17 0.63/16   67/24 3,24 1.59/34 1.38/8 1.94/17 1.24/17
2017-04-22 Bordeaux 2-0 Bastia 47/3 2,60 1.49/35 2.00/8 1.61/18 1.35/17   26/-24 2,24 0.82/34 0.63/8 1.00/18 0.63/16
2017-04-29 Bastia 1-0 Rennes 26/-26 2,23 0.80/35 0.63/8 1.00/18 0.59/17   32/-11 2,08 1.22/36 1.38/8 1.83/18 0.61/18
2017-05-06 Paris SG 5-0 Bastia 72/46 2,80 2.29/35 2.63/8 2.41/17 2.17/18   27/-25 2,19 0.86/36 0.88/8 1.11/19 0.59/17
2017-05-06 PSG 5-0 Bastia 72/46 2,80 2.29/35 2.63/8 2.41/17 2.17/18   27/-30 2,27 0.84/37 0.75/8 1.11/19 0.56/18
2017-05-14 Bastia 2-0 Lorient 27/-35 2,34 0.82/38 0.75/8 1.11/19 0.53/19   44/-30 3,11 0.92/38 1.63/8 1.26/19 0.58/19
2017-05-20 Marseille 1-0 Bastia 57/11 2,64 1.54/39 1.75/8 2.11/19 1.00/20   29/-33 2,33 0.87/39 1.13/8 1.20/20 0.53/19