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/0 2,67 1.67/6 1.67/6 2.00/3 1.33/3
2016-10-01 Dijon 3-3 Montpellier 8/-2 2,57 1.00/7 1.00/7 1.75/4 0.00/3   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/-7 2,63 1.25/8 1.25/8 2.25/4 0.25/4
2016-10-21 Monaco 6-2 Montpellier 23/11 3,89 2.11/9 2.25/8 2.50/4 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,91 1.27/11 1.25/8 2.00/6 0.40/5
2016-11-19 Bastia 1-1 Montpellier 9/-3 1,75 0.92/12 0.63/8 1.33/6 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   8/-11 2,08 0.92/13 1.00/8 1.00/7 0.83/6
2016-11-30 Toulouse 1-0 Montpellier 17/4 2,14 1.36/14 1.00/8 2.00/6 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 PSG 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-10 Lille 2-1 Montpellier 15/-6 2,25 1.06/16 1.25/8 1.50/8 0.63/8   23/-5 3,19 1.19/16 1.50/8 1.88/8 0.50/8
2016-12-17 Montpellier 4-0 Bordeaux 24/-6 3,18 1.12/17 1.13/8 1.88/8 0.44/9   20/-2 2,47 1.41/17 1.25/8 1.56/9 1.25/8
2016-12-21 Nantes 1-0 Montpellier 11/-15 2,18 0.94/17 0.63/8 0.75/8 1.11/9   28/-2 3,22 1.22/18 1.50/8 2.00/9 0.44/9
2017-01-14 Montpellier 1-1 Dijon 28/-3 3,11 1.16/19 1.38/8 2.00/9 0.40/10   26/-3 2,89 1.00/19 0.75/8 1.60/10 0.33/9
2017-01-21 Metz 2-0 Montpellier 18/-18 2,84 1.05/19 0.88/8 1.13/8 1.00/11   29/-3 3,05 1.15/20 1.13/8 1.90/10 0.40/10
2017-01-27 Marseille 5-1 Montpellier 24/-2 2,38 1.43/21 1.63/8 2.10/10 0.82/11   29/-5 3,00 1.10/21 1.00/8 1.90/10 0.36/11
2017-02-04 Montpellier 2-1 Bastia 30/-9 3,14 1.05/22 0.88/8 1.90/10 0.33/12   19/-7 2,05 1.00/22 1.13/8 1.25/12 0.70/10
2017-02-07 Montpellier 1-2 Monaco 32/-8 3,13 1.13/23 1.25/8 2.00/11 0.33/12   68/46 3,91 2.26/23 2.38/8 2.58/12 1.91/11
2017-02-11 Nancy 0-3 Montpellier 18/-11 2,04 1.17/23 1.38/8 1.45/11 0.92/12   33/-9 3,13 1.08/24 0.88/8 1.83/12 0.33/12
2017-02-19 Montpellier 2-1 St Etienne 36/-6 3,12 1.16/25 1.25/8 1.83/12 0.54/13   30/11 1,96 1.56/25 1.75/8 2.00/13 1.08/12
2017-02-24 Nice 2-1 Montpellier 42/22 2,38 2.15/26 1.63/8 2.54/13 1.77/13   38/-5 3,12 1.23/26 1.25/8 1.92/13 0.54/13
2017-03-04 Montpellier 1-1 Guingamp 39/-6 3,11 1.19/27 1.25/8 1.92/13 0.50/14   31/-4 2,44 1.26/27 0.50/8 1.85/13 0.71/14
2017-03-11 Montpellier 2-3 Nantes 40/-6 3,07 1.18/28 1.25/8 1.86/14 0.50/14   24/-17 2,32 1.21/28 1.13/8 1.29/14 1.14/14
2017-03-18 Bordeaux 5-1 Montpellier 37/1 2,52 1.48/29 1.75/8 1.53/15 1.43/14   42/-7 3,14 1.14/29 1.25/8 1.73/15 0.50/14
2017-04-02 Montpellier 0-1 Toulouse 43/-11 3,23 1.10/30 1.25/8 1.73/15 0.47/15   32/-1 2,17 1.23/30 1.38/8 1.80/15 0.67/15
2017-04-08 Caen 0-2 Montpellier 31/-21 2,68 1.03/31 0.88/8 1.53/15 0.56/16   43/-12 3,16 1.06/31 0.88/8 1.63/16 0.47/15
2017-04-15 Montpellier 2-0 Lorient 45/-10 3,13 1.13/32 1.25/8 1.63/16 0.63/16   37/-25 3,09 0.97/32 1.13/8 1.25/16 0.69/16
2017-04-22 PSG 2-0 Montpellier 69/46 2,79 2.33/33 2.75/8 2.38/16 2.29/17   47/-8 3,09 1.18/33 1.25/8 1.71/17 0.63/16
2017-04-29 Montpellier 0-3 Lille 47/-10 3,06 1.15/34 0.88/8 1.71/17 0.59/17   34/-7 2,21 1.18/34 1.38/8 1.24/17 1.12/17
2017-05-07 Rennes 1-0 Montpellier 32/-7 2,03 1.26/35 1.00/8 1.94/17 0.61/18   47/-13 3,06 1.11/35 0.88/8 1.61/18 0.59/17
2017-05-14 Montpellier 1-3 Lyon 47/-14 3,00 1.08/36 0.75/8 1.61/18 0.56/18   74/30 3,28 1.75/36 1.63/8 2.00/18 1.50/18
2017-05-20 Angers 2-0 Montpellier 38/-11 2,35 1.16/37 0.88/8 1.44/18 0.89/19   48/-16 3,03 1.05/37 0.75/8 1.53/19 0.56/18
2018-10-21 Paris SG 0-1 Montpellier 11/-1 1,00 1.43/23 1.88/8 0.00/12 3.00/11   48/-18 3,00 1.03/38 0.75/8 1.53/19 0.53/19
2018-10-21 Montpellier 0-1 Paris SG 49/-17 2,95 1.08/39 0.75/8 1.53/19 0.65/20   1/-1 1,00 1.00/3 1.88/8 0.00/2 3.00/1