SELECT * FROM 1_Kampe WHERE LigaID = '84' 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

2012-08-11

St Etienne

1-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

2012-08-17

Lille

1-1

Nancy

2/1

3,00

3.00/1

3.00/1

0.00/0

3.00/1

1/1

1,00

3.00/1

3.00/1

3.00/1

0.00/0

2012-08-25

Nice

2-2

Lille

0/-1

0,50

0.50/2

0.50/2

0.00/1

1.00/1

3/1

2,50

2.00/2

2.00/2

1.00/1

3.00/1

2012-09-02

Lille

1-2

PSG

5/1

3,00

1.67/3

1.67/3

1.00/1

2.00/2

2/0

1,33

1.00/3

1.00/3

1.00/2

1.00/1

2012-09-15

Troyes

1-1

Lille

4/-5

3,25

0.25/4

0.25/4

0.50/2

0.00/2

6/0

3,00

1.25/4

1.25/4

0.50/2

2.00/2

2012-09-23

Lille

1-1

Lyon

7/0

2,80

1.20/5

1.20/5

0.50/2

1.67/3

11/7

3,00

2.60/5

2.60/5

3.00/3

2.00/2

2012-09-28

Rennes

2-0

Lille

7/-4

3,00

0.67/6

0.67/6

1.00/3

0.33/3

8/0

2,67

1.17/6

1.17/6

0.67/3

1.67/3

2012-10-06

Lille

2-0

AC Ajaccio

8/-2

2,57

1.00/7

1.00/7

0.67/3

1.25/4

6/-1

1,86

1.57/7

1.57/7

2.33/3

1.00/4

2012-10-19

Bordeaux

1-1

Lille

10/4

2,00

1.75/8

1.75/8

1.67/3

1.80/5

10/0

2,50

1.25/8

1.25/8

1.25/4

1.25/4

2012-10-27

Lille

2-1

Valenciennes

11/0

2,44

1.22/9

1.00/8

1.25/4

1.20/5

19/10

3,11

1.67/9

1.50/8

2.20/5

1.00/4

2012-11-03

Thonon-Evian

0-2

Lille

10/-5

2,78

0.89/9

1.00/8

1.00/5

0.75/4

13/1

2,50

1.40/10

1.25/8

1.60/5

1.20/5

2012-11-10

Lille

1-0

Brest

15/3

2,45

1.55/11

1.50/8

1.60/5

1.50/6

11/-6

2,55

1.18/11

1.25/8

2.60/5

0.00/6

2012-11-16

Lorient

2-0

Lille

19/-6

3,67

1.25/12

0.88/8

1.50/6

1.00/6

16/4

2,33

1.67/12

1.88/8

1.83/6

1.50/6

2012-11-25

Marseille

1-0

Lille

16/5

2,25

1.92/12

1.38/8

2.20/5

1.71/7

16/2

2,31

1.54/13

1.75/8

1.83/6

1.29/7

2012-12-01

Lille

0-0

Bastia

16/1

2,21

1.43/14

1.63/8

1.83/6

1.13/8

21/-12

3,86

1.21/14

1.38/8

1.71/7

0.71/7

2012-12-08

Sochaux

1-1

Lille

15/-7

2,47

1.00/15

1.13/8

1.00/7

1.00/8

16/1

2,07

1.40/15

1.75/8

1.71/7

1.13/8

2012-12-11

Lille

2-0

Toulouse

17/1

2,06

1.38/16

1.50/8

1.71/7

1.11/9

23/6

2,50

1.44/16

1.25/8

1.63/8

1.25/8

2012-12-15

Reims

1-1

Lille

13/-4

1,76

1.00/17

0.38/8

1.67/9

0.25/8

19/3

2,06

1.47/17

1.75/8

1.88/8

1.11/9

2012-12-22

Lille

4-1

Montpellier

20/3

2,06

1.44/18

1.50/8

1.88/8

1.10/10

28/8

2,67

1.44/18

1.88/8

1.67/9

1.22/9

2013-01-12

Nancy

2-2

Lille

15/-18

2,53

0.58/19

0.75/8

0.70/10

0.44/9

24/6

2,21

1.53/19

1.50/8

2.00/9

1.10/10

2013-01-20

Lille

0-2

Nice

26/6

2,30

1.50/20

1.25/8

2.00/9

1.09/11

31/5

2,85

1.60/20

2.38/8

2.18/11

0.89/9

2013-01-27

PSG

1-0

Lille

37/25

2,33

2.00/21

2.38/8

1.91/11

2.10/10

26/4

2,29

1.43/21

1.25/8

1.80/10

1.09/11

2013-02-02

Lille

1-1

Troyes

26/3

2,23

1.36/22

1.25/8

1.80/10

1.00/12

25/-18

3,09

0.73/22

1.00/8

1.17/12

0.20/10

2013-02-10

Lyon

1-3

Lille

38/17

2,57

1.96/23

1.75/8

2.36/11

1.58/12

27/3

2,22

1.35/23

1.25/8

1.73/11

1.00/12

2013-02-15

Lille

2-0

Rennes

30/5

2,29

1.42/24

1.50/8

1.73/11

1.15/13

37/7

2,79

1.67/24

1.75/8

1.67/12

1.67/12

2013-02-23

AC Ajaccio

1-3

Lille

28/-5

2,44

1.24/25

1.25/8

1.58/12

0.92/13

32/7

2,28

1.48/25

1.50/8

1.83/12

1.15/13

2013-03-03

Lille

2-1

Bordeaux

35/9

2,35

1.54/26

1.75/8

1.83/12

1.29/14

26/4

1,85

1.46/26

1.25/8

1.38/13

1.54/13

2013-03-09

Valenciennes

1-3

Lille

35/-2

2,67

1.30/27

0.75/8

1.92/13

0.71/14

37/10

2,37

1.59/27

1.75/8

1.92/13

1.29/14

2013-03-16

Lille

1-2

Thonon-Evian

40/12

2,43

1.64/28

2.00/8

1.92/13

1.40/15

30/-10

2,50

0.96/28

1.00/8

1.07/14

0.86/14

2013-03-31

Brest

1-2

Lille

28/-14

2,41

1.00/29

0.63/8

1.29/14

0.73/15

41/11

2,45

1.59/29

2.00/8

1.79/14

1.40/15

2013-04-07

Lille

5-0

Lorient

43/12

2,47

1.63/30

2.38/8

1.79/14

1.50/16

48/3

3,10

1.47/30

1.25/8

2.00/15

0.93/15

2013-04-14

Lille

0-0

Marseille

48/17

2,55

1.68/31

2.63/8

1.87/15

1.50/16

36/4

2,19

1.84/31

1.88/8

2.00/15

1.69/16

2013-04-21

Bastia

1-2

Lille

43/-17

3,22

1.22/32

1.63/8

1.67/15

0.82/17

48/17

2,47

1.66/32

2.38/8

1.81/16

1.50/16

2013-04-26

Lille

3-3

Sochaux

50/18

2,48

1.70/33

2.38/8

1.81/16

1.59/17

34/-18

2,61

1.00/33

0.88/8

1.18/17

0.81/16

2013-05-04

Toulouse

4-2

Lille

40/-2

2,41

1.24/34

1.13/8

1.29/17

1.18/17

53/18

2,59

1.68/34

2.13/8

1.76/17

1.59/17

2013-05-10

Lille

3-0

Reims

55/16

2,69

1.63/35

1.75/8

1.76/17

1.50/18

32/-7

2,03

1.11/35

1.50/8

1.56/18

0.65/17

2013-05-18

Montpellier

0-0

Lille

54/5

2,86

1.42/36

0.88/8

2.06/18

0.78/18

58/19

2,69

1.67/36

1.75/8

1.83/18

1.50/18

2013-05-26

Lille

1-1

St Etienne

58/19

2,62

1.65/37

1.88/8

1.83/18

1.47/19

59/28

2,43

1.68/37

1.63/8

1.95/19

1.39/18

2018-10-21

Lille

0-1

Paris SG

59/19

2,61

1.63/38

1.63/8

1.79/19

1.47/19

10/2

1,20

1.60/15

1.50/8

0.00/7

3.00/8

2018-10-21

Evian TG

0-1

Lille

6/3

1,00

2.00/9

1.13/8

0.00/3

3.00/6

59/18

2,56

1.59/39

1.38/8

1.70/20

1.47/19

2018-10-21

Paris SG

0-1

Lille

19/2

1,09

1.55/33

1.50/8

0.00/16

3.00/17

60/19

2,53

1.63/40

1.38/8

1.70/20

1.55/20

2018-10-21

Lille

0-1

Evian TG

61/20

2,49

1.66/41

1.38/8

1.70/20

1.62/21

14/0

1,00

1.50/28

1.13/8

0.00/14

3.00/14