SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Montpellier' OR Away='Montpellier') 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-13 Montpellier 1-0 Angers 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-21 St Etienne 3-1 Montpellier 2/-1 5,00 0.00/1 0.00/1 0.00/0 0.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-27 Montpellier 1-1 Rennes 2/-1 2,50 1.50/2 1.50/2 3.00/1 0.00/1   2/1 1,50 1.50/2 1.50/2 3.00/1 0.00/1
2016-09-10 Guingamp 1-1 Montpellier 6/3 3,00 2.33/3 2.33/3 3.00/1 2.00/2   3/-1 2,33 1.33/3 1.33/3 2.00/2 0.00/1
2016-09-18 Montpellier 1-1 Nice 4/-1 2,25 1.25/4 1.25/4 2.00/2 0.50/2   6/3 2,25 2.50/4 2.50/4 2.33/3 3.00/1
2016-09-21 Lyon 5-1 Montpellier 8/1 3,00 1.40/5 1.40/5 1.50/2 1.33/3   5/-1 2,20 1.20/5 1.20/5 1.67/3 0.50/2
2016-09-24 Montpellier 0-1 Metz 6/-5 2,83 1.00/6 1.00/6 1.67/3 0.33/3   8/-3 2,71 1.43/7 1.43/7 2.00/3 1.00/4
2016-10-01 Dijon 3-3 Montpellier 8/-5 2,63 0.88/8 0.88/8 1.75/4 0.00/4   6/-6 2,57 0.86/7 0.86/7 1.25/4 0.33/3
2016-10-15 Montpellier 3-2 Caen 9/-6 3,00 0.88/8 0.88/8 1.25/4 0.50/4   7/-13 3,00 1.11/9 0.88/8 1.80/5 0.25/4
2016-10-21 Monaco 6-2 Montpellier 26/13 3,90 2.20/10 2.25/8 2.60/5 1.80/5   12/-5 3,22 1.11/9 0.88/8 1.60/5 0.50/4
2016-10-29 Lorient 2-2 Montpellier 6/-10 2,20 0.60/10 0.75/8 1.20/5 0.00/5   14/-9 3,70 1.00/10 0.88/8 1.60/5 0.40/5
2016-11-04 Montpellier 3-1 Marseille 16/-9 3,73 1.00/11 0.88/8 1.60/5 0.50/6   11/1 1,75 1.25/12 1.38/8 2.00/6 0.50/6
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-26 Montpellier 0-0 Nancy 20/-7 3,62 1.15/13 1.13/8 1.83/6 0.57/7   9/-12 2,14 0.86/14 0.88/8 0.88/8 0.83/6
2016-11-30 Toulouse 1-0 Montpellier 19/6 2,13 1.47/15 1.00/8 2.14/7 0.88/8   20/-7 3,36 1.14/14 1.25/8 1.71/7 0.57/7
2016-12-03 Montpellier 3-0 Paris SG 20/-8 3,20 1.07/15 1.25/8 1.71/7 0.50/8   30/22 2,53 2.33/15 2.75/8 2.50/8 2.14/7
2016-12-03 Montpellier 3-0 PSG 23/-5 3,19 1.19/16 1.50/8 1.88/8 0.50/8   30/22 2,53 2.33/15 2.75/8 2.50/8 2.14/7
2016-12-10 Lille 2-1 Montpellier 15/-7 2,18 1.00/17 1.25/8 1.33/9 0.63/8   26/-2 3,18 1.29/17 1.50/8 2.00/9 0.50/8
2016-12-17 Montpellier 4-0 Bordeaux 27/-3 3,17 1.22/18 1.50/8 2.00/9 0.44/9   20/-4 2,44 1.33/18 1.25/8 1.56/9 1.11/9
2016-12-21 Nantes 1-0 Montpellier 11/-17 2,17 0.89/18 0.63/8 0.75/8 1.00/10   31/1 3,21 1.32/19 1.75/8 2.10/10 0.44/9
2017-01-14 Montpellier 1-1 Dijon 31/0 3,10 1.25/20 1.38/8 2.10/10 0.40/10   26/-6 2,90 0.95/20 0.75/8 1.60/10 0.30/10
2017-01-21 Metz 2-0 Montpellier 18/-21 2,85 1.00/20 0.88/8 1.13/8 0.92/12   32/0 3,05 1.24/21 1.38/8 2.00/11 0.40/10
2017-01-27 Marseille 5-1 Montpellier 24/-2 2,27 1.41/22 1.63/8 2.10/10 0.83/12   32/-2 3,00 1.18/22 1.25/8 2.00/11 0.36/11
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-07 Montpellier 1-2 Monaco 35/-5 3,13 1.21/24 1.25/8 2.08/12 0.33/12   72/48 3,84 2.24/25 2.13/8 2.62/13 1.83/12
2017-02-11 Nancy 0-3 Montpellier 19/-12 2,08 1.13/24 1.38/8 1.33/12 0.92/12   36/-6 3,12 1.16/25 0.88/8 1.92/13 0.33/12
2017-02-19 Montpellier 2-1 St Etienne 39/-3 3,12 1.23/26 1.25/8 1.92/13 0.54/13   31/11 1,96 1.54/26 1.75/8 2.00/13 1.08/13
2017-02-24 Nice 2-1 Montpellier 44/22 2,44 2.11/27 1.63/8 2.54/13 1.71/14   41/-2 3,11 1.30/27 1.25/8 2.00/14 0.54/13
2017-03-04 Montpellier 1-1 Guingamp 42/-3 3,11 1.25/28 1.25/8 2.00/14 0.50/14   33/-3 2,46 1.32/28 0.50/8 1.93/14 0.71/14
2017-03-11 Montpellier 2-3 Nantes 43/-3 3,07 1.24/29 1.25/8 1.93/15 0.50/14   24/-21 2,30 1.13/30 1.13/8 1.20/15 1.07/15
2017-03-18 Bordeaux 5-1 Montpellier 37/-4 2,52 1.39/31 1.38/8 1.44/16 1.33/15   45/-4 3,13 1.20/30 1.25/8 1.81/16 0.50/14
2017-04-02 Montpellier 0-1 Toulouse 46/-8 3,23 1.16/31 1.25/8 1.81/16 0.47/15   34/1 2,09 1.28/32 1.13/8 1.88/16 0.69/16
2017-04-08 Caen 0-2 Montpellier 31/-27 2,78 1.00/32 0.88/8 1.44/16 0.56/16   46/-9 3,16 1.13/32 0.88/8 1.71/17 0.47/15
2017-04-15 Montpellier 2-0 Lorient 48/-7 3,12 1.18/33 1.25/8 1.71/17 0.63/16   38/-31 3,15 0.91/34 1.13/8 1.18/17 0.65/17
2017-04-22 Paris SG 2-0 Montpellier 69/46 2,79 2.33/33 2.75/8 2.38/16 2.29/17   50/-5 3,09 1.24/34 1.25/8 1.78/18 0.63/16
2017-04-22 PSG 2-0 Montpellier 69/46 2,79 2.33/33 2.75/8 2.38/16 2.29/17   50/-7 3,06 1.20/35 0.88/8 1.78/18 0.59/17
2017-04-29 Montpellier 0-3 Lille 50/-9 3,03 1.17/36 0.88/8 1.78/18 0.56/18   35/-9 2,19 1.11/36 1.38/8 1.17/18 1.06/18
2017-05-07 Rennes 1-0 Montpellier 32/-12 2,05 1.19/37 1.00/8 1.83/18 0.58/19   50/-12 3,03 1.14/37 0.75/8 1.68/19 0.56/18
2017-05-14 Montpellier 1-3 Lyon 50/-13 2,97 1.11/38 0.75/8 1.68/19 0.53/19   76/28 3,26 1.66/38 1.63/8 1.89/19 1.42/19
2017-05-20 Angers 2-0 Montpellier 38/-15 2,33 1.10/39 0.50/8 1.37/19 0.85/20   51/-15 3,00 1.08/39 0.75/8 1.60/20 0.53/19