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

2019-08-18

Girona

1-1

Gijon

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

2019-08-25

Gijon

1-1

Rayo Vallecano

1/0

2,00

1.00/1

1.00/1

0.00/0

1.00/1

2/0

4,00

1.00/1

1.00/1

1.00/1

0.00/0

2019-09-01

Gijon

2-0

Albacete

2/0

2,00

1.00/2

1.00/2

1.00/1

1.00/1

1/-2

2,00

1.50/2

1.50/2

3.00/1

0.00/1

2019-09-08

Huesca

1-0

Gijon

4/2

2,00

2.00/3

2.00/3

3.00/1

1.50/2

4/2

2,00

1.67/3

1.67/3

2.00/2

1.00/1

2019-09-15

Gijon

1-1

Dep. La Coruna

4/1

1,75

1.25/4

1.25/4

2.00/2

0.50/2

5/-4

3,50

0.75/4

0.75/4

1.50/2

0.00/2

2019-09-19

Las Palmas

1-0

Gijon

3/-4

2,00

0.60/5

0.60/5

0.33/3

1.00/2

5/1

1,80

1.20/5

1.20/5

1.67/3

0.50/2

2019-09-22

Gijon

1-1

Racing Santander

5/0

1,67

1.00/6

1.00/6

1.67/3

0.33/3

8/0

2,67

0.83/6

0.83/6

1.00/4

0.50/2

2019-09-29

Malaga

0-0

Gijon

4/-2

1,43

0.86/7

0.86/7

0.67/3

1.00/4

6/0

1,71

1.00/7

1.00/7

1.50/4

0.33/3

2019-10-03

Gijon

4-2

Almeria

6/0

1,50

1.00/8

1.00/8

1.50/4

0.50/4

14/9

2,38

2.13/8

2.13/8

2.25/4

2.00/4

2019-10-06

Fuenlabrada

2-0

Gijon

10/2

2,25

1.75/8

1.75/8

1.67/3

1.80/5

10/2

2,00

1.22/9

1.25/8

1.80/5

0.50/4

2019-10-12

Gijon

1-3

Alcorcon

10/0

2,00

1.10/10

1.13/8

1.80/5

0.40/5

13/-1

2,70

1.20/10

1.13/8

0.60/5

1.80/5

2019-10-19

Elche

0-1

Gijon

11/1

1,91

1.45/11

1.63/8

1.20/5

1.67/6

11/-2

2,18

1.00/11

0.75/8

1.50/6

0.40/5

2019-10-27

Gijon

4-0

Zaragoza

12/-1

2,08

1.17/12

1.13/8

1.50/6

0.83/6

17/5

2,42

1.58/12

1.13/8

1.57/7

1.60/5

2019-11-01

Cadiz CF

3-1

Gijon

20/10

2,31

2.38/13

2.00/8

2.67/6

2.14/7

16/3

2,23

1.31/13

1.38/8

1.71/7

0.83/6

2019-11-09

Gijon

0-1

Numancia

17/1

2,36

1.21/14

1.38/8

1.71/7

0.71/7

16/4

2,00

1.50/14

1.63/8

2.00/8

0.83/6

2019-11-17

R. Oviedo

0-0

Gijon

19/-5

2,87

0.93/15

1.50/8

1.14/7

0.75/8

17/0

2,27

1.13/15

1.25/8

1.50/8

0.71/7

2019-11-22

Gijon

0-2

Tenerife

17/0

2,13

1.13/16

1.25/8

1.50/8

0.75/8

18/-3

2,44

0.94/16

0.50/8

0.88/8

1.00/8

2019-11-30

Mirandes

0-0

Gijon

22/-4

2,82

1.41/17

2.00/8

1.78/9

1.00/8

17/-2

2,12

1.06/17

0.88/8

1.33/9

0.75/8

2019-12-07

Gijon

1-0

Ponferradina

17/-2

2,00

1.06/18

1.00/8

1.33/9

0.78/9

24/3

2,50

1.33/18

1.38/8

1.70/10

0.88/8

2019-12-15

Lugo

1-2

Gijon

19/-7

2,37

1.11/19

1.38/8

1.30/10

0.89/9

18/-1

1,95

1.16/19

1.38/8

1.50/10

0.78/9

2019-12-21

Gijon

0-1

Extremadura UD

20/0

2,00

1.25/20

1.38/8

1.50/10

1.00/10

17/-10

2,20

0.90/20

0.63/8

0.90/10

0.90/10

2020-01-07

Zaragoza

2-0

Gijon

31/7

2,62

1.57/21

1.75/8

1.64/11

1.50/10

20/-1

1,95

1.19/21

1.00/8

1.36/11

1.00/10

2020-01-14

Gijon

1-0

Elche

20/-3

1,95

1.14/22

1.00/8

1.36/11

0.91/11

28/4

2,36

1.45/22

1.63/8

1.27/11

1.64/11

2020-01-18

Numancia

2-0

Gijon

28/4

2,26

1.43/23

1.13/8

1.75/12

1.09/11

21/-2

1,91

1.22/23

1.38/8

1.50/12

0.91/11

2020-01-25

Gijon

1-0

Fuenlabrada

21/-4

1,92

1.17/24

1.25/8

1.50/12

0.83/12

29/5

2,21

1.54/24

1.13/8

1.75/12

1.33/12

2020-01-31

Tenerife

2-1

Gijon

28/-4

2,40

1.04/25

1.00/8

1.17/12

0.92/13

22/-3

1,88

1.24/25

1.63/8

1.62/13

0.83/12

2020-02-09

Gijon

2-2

Mirandes

23/-4

1,92

1.19/26

1.50/8

1.62/13

0.77/13

33/-1

2,68

1.40/25

1.38/8

1.69/13

1.08/12

2020-02-16

Racing Santander

0-2

Gijon

27/-6

2,22

0.89/27

0.88/8

1.08/13

0.71/14

25/-4

2,00

1.19/27

1.25/8

1.57/14

0.77/13

2020-02-21

Gijon

1-0

Cadiz CF

27/-2

2,00

1.25/28

1.25/8

1.57/14

0.93/14

38/12

2,29

1.86/28

1.13/8

2.00/14

1.71/14

2020-02-29

Ponferradina

1-0

Gijon

35/2

2,34

1.28/29

0.88/8

1.73/15

0.79/14

28/-1

1,97

1.31/29

1.63/8

1.67/15

0.93/14

2020-03-08

Gijon

4-0

Las Palmas

28/-2

1,93

1.27/30

1.63/8

1.67/15

0.87/15

34/-1

2,30

1.27/30

0.63/8

1.33/15

1.20/15

2020-06-14

Dep. La Coruna

0-0

Gijon

28/-18

2,39

1.13/31

1.75/8

1.40/15

0.88/16

32/2

2,00

1.32/31

1.63/8

1.75/16

0.87/15

2020-06-18

Alcorcon

0-2

Gijon

41/3

2,47

1.38/32

1.75/8

1.00/16

1.75/16

32/2

1,94

1.31/32

1.75/8

1.75/16

0.88/16

2020-06-22

Gijon

0-1

R. Oviedo

34/4

1,94

1.36/33

1.75/8

1.75/16

1.00/17

39/-6

2,55

1.12/33

1.50/8

1.29/17

0.94/16

2020-06-25

Rayo Vallecano

1-1

Gijon

43/7

2,32

1.32/34

1.25/8

1.59/17

1.06/17

34/3

1,91

1.32/34

1.75/8

1.65/17

1.00/17

2020-06-28

Gijon

2-0

Lugo

35/3

1,91

1.31/35

1.75/8

1.65/17

1.00/18

31/-14

2,17

1.09/35

1.50/8

1.22/18

0.94/17

2020-07-01

Almeria

1-0

Gijon

56/20

2,56

1.58/36

1.38/8

1.59/17

1.58/19

37/5

1,92

1.36/36

1.75/8

1.72/18

1.00/18

2020-07-06

Gijon

0-0

Girona

37/4

1,89

1.32/37

1.38/8

1.72/18

0.95/19

43/5

2,19

1.49/37

1.25/8

2.16/19

0.78/18

2020-07-09

Albacete

1-1

Gijon

30/-11

1,87

1.18/38

1.25/8

1.05/19

1.32/19

37/4

1,84

1.32/38

1.50/8

1.68/19

0.95/19

2020-07-13

Gijon

2-1

Malaga

38/4

1,85

1.31/39

1.25/8

1.68/19

0.95/20

32/1

1,62

1.26/39

1.38/8

1.50/20

1.00/19

2020-07-17

Extremadura UD

2-0

Gijon

40/-14

2,35

1.00/40

1.00/8

0.95/20

1.05/20

40/5

1,88

1.35/40

1.50/8

1.75/20

0.95/20

2020-07-20

Gijon

0-1

Huesca

40/3

1,88

1.32/41

1.13/8

1.75/20

0.90/21

54/12

2,34

1.63/41

1.75/8

2.29/21

0.95/20