SELECT * FROM 1_Kampe WHERE LigaID = '138' AND (Home='Lugo' OR Away='Lugo') 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

2018-08-18

Lugo

1-2

Malaga

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

2018-08-26

Granada CF

1-1

Lugo

0/0

0,00

1.00/1

1.00/1

0.00/0

1.00/1

1/-1

3,00

0.00/1

0.00/1

0.00/1

0.00/0

2018-09-01

Lugo

3-2

Numancia

2/-1

2,50

0.50/2

0.50/2

0.00/1

1.00/1

4/0

4,00

1.00/2

1.00/2

1.00/1

1.00/1

2018-09-10

Rayo Majadahonda

1-0

Lugo

2/-1

1,67

1.00/3

1.00/3

0.00/1

1.50/2

5/0

3,33

1.33/3

1.33/3

1.50/2

1.00/1

2018-09-16

Lugo

0-2

R. Oviedo

5/-1

2,75

1.00/4

1.00/4

1.50/2

0.50/2

6/-2

3,50

1.25/4

1.25/4

0.50/2

2.00/2

2018-09-22

Zaragoza

0-2

Lugo

8/4

2,40

1.60/5

1.60/5

2.00/2

1.33/3

5/-3

2,60

0.80/5

0.80/5

1.00/3

0.50/2

2018-09-29

Lugo

1-1

Mallorca

7/-1

2,50

1.17/6

1.17/6

1.00/3

1.33/3

5/0

1,67

1.67/6

1.67/6

2.00/3

1.33/3

2018-10-07

Elche

2-1

Lugo

5/-3

1,86

0.71/7

0.71/7

0.67/3

0.75/4

8/-1

2,43

1.14/7

1.14/7

1.00/4

1.33/3

2018-10-14

Tenerife

0-0

Lugo

7/-4

2,25

0.88/8

0.88/8

1.33/3

0.60/5

9/-2

2,50

1.00/8

1.00/8

1.00/4

1.00/4

2018-10-21

Lugo

0-1

Reus Deportiu

9/-2

2,22

1.00/9

1.13/8

1.00/4

1.00/5

19/-1

1,00

1.46/39

1.88/8

0.00/20

3.00/19

2018-10-21

Lugo

1-0

Gimnastic

9/-3

2,10

0.90/10

1.38/8

0.80/5

1.00/5

6/-7

1,90

0.90/10

1.00/8

0.80/5

1.00/5

2018-10-21

Reus Deportiu

0-1

Lugo

5/1

1,00

1.67/9

1.88/8

0.00/4

3.00/5

10/-2

2,00

1.09/11

1.38/8

1.17/6

1.00/5

2018-10-27

Lugo

1-2

Cadiz CF

11/-1

1,92

1.25/12

1.38/8

1.17/6

1.33/6

7/-4

1,50

0.92/12

0.75/8

1.00/6

0.83/6

2018-11-03

Reus FCR

0-0

Lugo

9/-4

2,00

1.09/11

1.00/8

1.00/5

1.17/6

12/-2

2,00

1.15/13

1.38/8

1.00/7

1.33/6

2018-11-10

Lugo

0-1

Alcorcon

12/-2

1,86

1.14/14

1.13/8

1.00/7

1.29/7

13/7

1,36

1.71/14

1.63/8

2.29/7

1.14/7

2018-11-18

Albacete

1-0

Lugo

20/7

2,20

1.60/15

1.38/8

1.43/7

1.75/8

12/-3

1,80

1.07/15

1.00/8

0.88/8

1.29/7

2018-11-24

Lugo

2-1

Cordoba

12/-4

1,75

1.00/16

1.00/8

0.88/8

1.13/8

17/-14

3,00

0.88/16

1.00/8

1.11/9

0.57/7

2018-12-02

Osasuna

1-0

Lugo

19/2

2,12

1.47/17

1.63/8

2.13/8

0.89/9

14/-3

1,82

1.12/17

1.25/8

1.11/9

1.13/8

2018-12-09

Lugo

4-2

Las Palmas

14/-4

1,78

1.06/18

0.88/8

1.11/9

1.00/9

21/4

2,11

1.44/18

1.00/8

1.70/10

1.13/8

2018-12-16

Almeria

1-1

Lugo

21/2

2,11

1.37/19

1.25/8

1.67/9

1.10/10

18/-2

2,00

1.16/19

1.25/8

1.30/10

1.00/9

2018-12-22

Lugo

0-0

Gijon

19/-2

2,00

1.15/20

1.00/8

1.30/10

1.00/10

19/3

1,75

1.40/20

1.50/8

1.90/10

0.90/10

2019-01-06

Dep. La Coruna

0-0

Lugo

32/15

2,33

1.81/21

1.63/8

2.30/10

1.36/11

19/-2

1,90

1.14/21

1.13/8

1.27/11

1.00/10

2019-01-13

Lugo

1-1

Extremadura UD

19/-2

1,82

1.14/22

1.13/8

1.27/11

1.00/11

28/-2

2,64

1.05/22

1.38/8

0.91/11

1.18/11

2019-01-19

Malaga

2-1

Lugo

25/8

1,83

1.83/23

1.63/8

2.18/11

1.50/12

20/-2

1,83

1.13/23

1.25/8

1.25/12

1.00/11

2019-01-26

Lugo

3-2

Rayo Majadahonda

21/-3

1,88

1.08/24

1.25/8

1.25/12

0.92/12

19/-10

2,00

1.08/24

0.50/8

1.33/12

0.83/12

2019-02-02

Numancia

3-0

Lugo

28/-3

2,36

1.20/25

1.25/8

1.58/12

0.85/13

24/-2

2,00

1.16/25

1.25/8

1.38/13

0.92/12

2019-02-09

Lugo

1-2

Zaragoza

24/-5

2,04

1.12/26

1.25/8

1.38/13

0.85/13

28/-4

2,31

1.15/26

1.50/8

1.08/13

1.23/13

2019-02-17

Mallorca

3-0

Lugo

30/5

2,04

1.48/27

1.25/8

2.00/13

1.00/14

25/-6

2,07

1.07/27

0.88/8

1.29/14

0.85/13

2019-02-24

Lugo

2-2

Elche

25/-9

2,11

1.04/28

0.75/8

1.29/14

0.79/14

26/-6

2,07

1.11/28

1.00/8

1.40/15

0.77/13

2019-03-03

R. Oviedo

1-1

Lugo

32/1

2,17

1.59/29

2.38/8

1.79/14

1.40/15

27/-9

2,17

1.03/29

0.75/8

1.27/15

0.79/14

2019-03-10

Lugo

0-0

Reus FCR

28/-9

2,17

1.03/30

0.75/8

1.27/15

0.80/15

16/-13

1,61

0.75/28

0.13/8

0.53/15

1.00/13

2019-03-16

Cadiz CF

1-1

Lugo

39/14

2,06

1.61/31

1.75/8

1.93/15

1.31/16

28/-9

2,10

1.00/31

0.63/8

1.19/16

0.80/15

2019-03-23

Lugo

0-3

Albacete

29/-9

2,09

1.00/32

0.75/8

1.19/16

0.81/16

38/14

1,94

1.75/32

1.75/8

1.94/16

1.56/16

2019-03-31

Alcorcon

0-0

Lugo

29/-2

1,82

1.30/33

0.63/8

1.94/16

0.71/17

29/-12

2,12

0.97/33

0.38/8

1.12/17

0.81/16

2019-04-07

Lugo

2-2

Osasuna

29/-12

2,06

0.97/34

0.50/8

1.12/17

0.82/17

45/15

2,21

1.94/34

2.38/8

2.59/17

1.29/17

2019-04-14

Cordoba

0-4

Lugo

39/-22

2,86

0.83/35

0.63/8

1.12/17

0.56/18

31/-12

2,11

0.97/35

0.63/8

1.11/18

0.82/17

2019-04-20

Lugo

1-2

Granada CF

35/-8

2,17

1.03/36

1.00/8

1.11/18

0.94/18

40/17

1,75

1.69/36

1.38/8

1.78/18

1.61/18

2019-04-28

Las Palmas

4-1

Lugo

39/-4

2,22

1.24/37

0.75/8

1.44/18

1.05/19

36/-9

2,19

1.00/37

0.88/8

1.05/19

0.94/18

2019-05-05

Lugo

4-2

Almeria

37/-12

2,26

0.97/38

0.75/8

1.05/19

0.89/19

41/9

1,92

1.37/38

1.13/8

1.63/19

1.11/19

2019-05-11

Gijon

0-0

Lugo

40/7

1,87

1.46/39

1.88/8

1.68/19

1.25/20

41/-10

2,36

1.03/39

1.13/8

1.15/20

0.89/19

2019-05-19

Lugo

1-0

Dep. La Coruna

41/-10

2,30

1.03/40

1.13/8

1.15/20

0.90/20

47/15

1,98

1.53/40

1.13/8

1.60/20

1.45/20

2019-05-26

Extremadura UD

0-0

Lugo

42/-6

2,20

1.17/41

2.25/8

1.00/20

1.33/21

42/-9

2,27

1.07/41

1.50/8

1.24/21

0.90/20

2019-06-04

Lugo

0-0

Tenerife

42/-9

2,21

1.07/42

1.50/8

1.24/21

0.90/21

39/-12

2,14

1.10/42

1.13/8

1.52/21

0.67/21

2019-06-09

Gimnastic

1-1

Lugo

28/-32

2,05

0.81/43

1.00/8

1.10/21

0.55/22

42/-9

2,16

1.07/43

1.50/8

1.23/22

0.90/21