SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Lille' OR Away='Lille') 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 Metz 3-2 Lille 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-20 Lille 1-0 Dijon 2/-1 5,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2016-08-27 Nice 1-1 Lille 2/2 1,00 3.00/2 3.00/2 3.00/1 3.00/1   3/0 3,00 1.50/2 1.50/2 3.00/1 0.00/1
2016-09-10 Lille 1-4 Monaco 4/0 2,67 1.33/3 1.33/3 3.00/1 0.50/2   9/5 3,25 2.50/4 2.50/4 2.33/3 3.00/1
2016-09-17 Lorient 1-0 Lille 2/-8 3,00 0.00/4 0.00/4 0.00/2 0.00/2   5/-3 3,25 1.00/4 1.00/4 1.50/2 0.50/2
2016-09-20 Lille 1-2 Toulouse 5/-4 2,80 0.80/5 0.80/5 1.50/2 0.33/3   7/3 2,20 1.60/5 1.60/5 3.00/2 0.67/3
2016-09-25 St Etienne 3-1 Lille 8/2 2,00 1.43/7 1.43/7 2.33/3 0.75/4   6/-5 2,83 0.67/6 0.67/6 1.00/3 0.33/3
2016-10-01 Lille 1-0 Nancy 7/-7 3,00 0.57/7 0.57/7 1.00/3 0.25/4   3/-6 1,71 0.71/7 0.71/7 0.25/4 1.33/3
2016-10-15 Guingamp 1-0 Lille 9/1 2,13 1.38/8 1.38/8 2.33/3 0.80/5   8/-6 2,75 0.88/8 0.88/8 1.50/4 0.25/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-28 Lille 0-1 Paris SG 10/-6 2,60 1.00/10 0.88/8 1.80/5 0.20/5   19/12 2,60 2.00/10 1.75/8 2.20/5 1.80/5
2016-10-28 Lille 0-1 PSG 10/-7 2,45 0.91/11 0.75/8 1.50/6 0.20/5   19/12 2,60 2.00/10 1.75/8 2.20/5 1.80/5
2016-11-05 Angers 1-0 Lille 10/-1 1,91 1.27/11 1.75/8 1.60/5 1.00/6   10/-8 2,33 0.83/12 0.75/8 1.29/7 0.20/5
2016-11-18 Lille 0-1 Lyon 10/-9 2,23 0.77/13 0.75/8 1.29/7 0.17/6   20/4 3,00 1.58/12 1.63/8 2.00/6 1.17/6
2016-11-26 Nantes 0-0 Lille 9/-11 2,07 0.86/14 0.88/8 0.83/6 0.88/8   10/-10 2,14 0.71/14 0.75/8 1.13/8 0.17/6
2016-11-29 Lille 4-2 Caen 10/-10 2,00 0.73/15 0.88/8 1.13/8 0.29/7   11/-18 2,67 0.93/15 1.00/8 1.63/8 0.14/7
2016-12-03 Bordeaux 0-1 Lille 20/1 2,44 1.50/16 1.38/8 2.00/7 1.11/9   14/-8 2,25 0.88/16 0.88/8 1.33/9 0.29/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-18 Marseille 2-0 Lille 18/0 2,00 1.39/18 1.50/8 2.25/8 0.70/10   17/-6 2,22 1.11/18 1.25/8 1.50/10 0.63/8
2016-12-21 Lille 1-1 Rennes 17/-8 2,21 1.05/19 1.25/8 1.50/10 0.56/9   19/-7 2,37 1.42/19 0.88/8 2.30/10 0.44/9
2017-01-13 Lille 1-1 St Etienne 18/-8 2,20 1.05/20 1.38/8 1.45/11 0.56/9   19/2 1,80 1.35/20 1.13/8 1.70/10 1.00/10
2017-01-21 Dijon 0-0 Lille 27/-6 2,86 0.95/21 0.75/8 1.60/10 0.36/11   19/-8 2,19 1.05/21 1.50/8 1.42/12 0.56/9
2017-01-28 Lyon 1-2 Lille 40/15 3,10 1.76/21 1.88/8 1.91/11 1.60/10   19/-8 2,09 1.05/22 1.63/8 1.42/12 0.60/10
2017-02-04 Lille 0-1 Lorient 21/-7 2,13 1.13/23 1.88/8 1.42/12 0.82/11   25/-26 3,30 0.78/23 0.88/8 1.45/11 0.17/12
2017-02-07 Paris SG 2-1 Lille 45/28 2,70 2.13/23 1.75/8 2.27/11 2.00/12   21/-8 2,08 1.08/24 1.50/8 1.31/13 0.82/11
2017-02-07 PSG 2-1 Lille 45/28 2,70 2.13/23 1.75/8 2.27/11 2.00/12   22/-9 2,12 1.04/25 0.75/8 1.31/13 0.75/12
2017-02-11 Lille 1-2 Angers 23/-10 2,15 1.00/26 0.75/8 1.31/13 0.69/13   19/-15 2,12 0.96/25 0.63/8 1.42/12 0.54/13
2017-02-18 Caen 0-1 Lille 25/-23 2,92 1.00/25 1.25/8 1.67/12 0.38/13   24/-11 2,19 0.96/27 0.75/8 1.21/14 0.69/13
2017-02-25 Lille 2-3 Bordeaux 25/-10 2,14 1.04/28 1.00/8 1.21/14 0.86/14   32/-4 2,43 1.39/28 1.75/8 1.47/15 1.31/13
2017-03-05 Toulouse 1-1 Lille 33/5 2,10 1.34/29 1.25/8 2.00/14 0.73/15   27/-11 2,24 1.00/29 0.88/8 1.13/15 0.86/14
2017-03-11 Nancy 1-2 Lille 19/-19 1,90 0.93/30 0.50/8 1.21/14 0.69/16   28/-11 2,23 1.00/30 0.88/8 1.13/15 0.87/15
2017-03-17 Lille 0-0 Marseille 30/-10 2,26 1.06/31 0.88/8 1.13/15 1.00/16   44/2 2,77 1.48/31 1.50/8 2.06/16 0.87/15
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-07 Lille 1-2 Nice 31/-9 2,15 1.12/33 1.38/8 1.13/16 1.12/17   52/25 2,47 2.13/32 2.25/8 2.50/16 1.75/16
2017-04-15 Rennes 2-0 Lille 29/-13 2,09 1.18/34 1.00/8 1.76/17 0.59/17   32/-10 2,18 1.09/34 1.38/8 1.06/17 1.12/17
2017-04-22 Lille 3-0 Guingamp 32/-12 2,17 1.06/35 1.38/8 1.06/17 1.06/18   42/-7 2,60 1.34/35 1.25/8 2.12/17 0.61/18
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-06 Lille 0-2 Metz 38/-6 2,22 1.16/37 1.75/8 1.17/18 1.16/19   38/-38 3,08 1.05/37 0.88/8 1.42/19 0.67/18
2017-05-14 Monaco 4-0 Lille 102/71 3,59 2.43/37 3.00/8 2.72/18 2.16/19   38/-8 2,21 1.13/38 1.63/8 1.11/19 1.16/19
2017-05-20 Lille 3-0 Nantes 38/-12 2,26 1.10/39 1.25/8 1.11/19 1.10/20   40/-15 2,44 1.31/39 1.75/8 1.40/20 1.21/19