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

2018-08-18

Alcorcon

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

2018-08-26

Gijon

2-0

Gimnastic

1/0

2,00

1.00/1

1.00/1

0.00/0

1.00/1

1/0

2,00

1.00/1

1.00/1

1.00/1

0.00/0

2018-09-02

Gijon

2-0

Extremadura UD

3/2

2,00

2.00/2

2.00/2

3.00/1

1.00/1

1/-1

1,50

0.50/2

0.50/2

0.00/1

1.00/1

2018-09-09

Dep. La Coruna

1-0

Gijon

4/1

2,33

1.67/3

1.67/3

0.00/0

1.67/3

5/4

2,00

2.33/3

2.33/3

3.00/2

1.00/1

2018-09-16

Gijon

1-1

Numancia

5/3

1,75

1.75/4

1.75/4

3.00/2

0.50/2

7/0

3,50

1.25/4

1.25/4

2.00/2

0.50/2

2018-09-22

Osasuna

1-0

Gijon

4/-2

2,00

0.80/5

0.80/5

2.00/2

0.00/3

6/3

1,80

1.60/5

1.60/5

2.33/3

0.50/2

2018-09-29

Gijon

1-0

Las Palmas

6/2

1,67

1.33/6

1.33/6

2.33/3

0.33/3

11/8

2,33

2.33/6

2.33/6

2.50/4

2.00/2

2018-10-08

Rayo Majadahonda

2-1

Gijon

4/-7

2,14

0.86/7

0.86/7

1.00/3

0.75/4

7/3

1,57

1.57/7

1.57/7

2.50/4

0.33/3

2018-10-13

Gijon

1-1

Reus FCR

8/2

1,75

1.38/8

1.38/8

2.50/4

0.25/4

6/-3

1,88

1.00/8

1.00/8

0.50/4

1.50/4

2018-10-21

Cadiz CF

0-0

Gijon

7/-4

1,64

0.91/11

0.75/8

1.00/5

0.83/6

9/2

1,78

1.33/9

1.38/8

2.20/5

0.25/4

2018-10-21

Gijon

0-1

Reus Deportiu

9/2

1,60

1.30/10

1.13/8

2.20/5

0.40/5

9/-1

1,00

1.42/19

1.88/8

0.00/10

3.00/9

2018-10-21

Reus Deportiu

0-1

Gijon

14/-1

1,00

1.45/29

1.88/8

0.00/15

3.00/14

9/1

1,55

1.18/11

1.13/8

1.83/6

0.40/5

2018-10-26

Gijon

0-0

Cordoba

10/2

1,50

1.33/12

1.13/8

1.83/6

0.83/6

12/-11

2,92

0.83/12

1.00/8

1.00/7

0.60/5

2018-11-04

Almeria

2-1

Gijon

13/2

1,85

1.31/13

1.63/8

1.67/6

1.00/7

10/2

1,38

1.31/13

1.13/8

1.71/7

0.83/6

2018-11-11

Gijon

2-2

Malaga

11/1

1,50

1.21/14

1.13/8

1.71/7

0.71/7

16/7

1,79

2.00/14

1.63/8

2.57/7

1.43/7

2018-11-17

R. Oviedo

2-1

Gijon

15/-6

2,40

1.27/15

1.25/8

1.29/7

1.25/8

13/1

1,67

1.20/15

0.88/8

1.63/8

0.71/7

2018-11-23

Granada CF

1-2

Gijon

23/12

2,13

1.94/16

1.75/8

2.13/8

1.75/8

14/0

1,75

1.13/16

0.88/8

1.63/8

0.63/8

2018-12-01

Gijon

2-1

Tenerife

16/1

1,82

1.24/17

1.13/8

1.63/8

0.89/9

14/-6

2,00

1.12/17

1.38/8

1.50/8

0.78/9

2018-12-09

Elche

0-0

Gijon

14/-8

2,00

1.06/18

1.00/8

1.33/9

0.78/9

18/2

1,89

1.33/18

1.13/8

1.78/9

0.89/9

2018-12-15

Gijon

1-0

Mallorca

18/2

1,79

1.32/19

1.25/8

1.78/9

0.90/10

24/7

2,16

1.58/19

1.88/8

1.70/10

1.44/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-05

Gijon

1-2

Zaragoza

19/3

1,67

1.38/21

1.50/8

1.90/10

0.91/11

21/-5

2,24

1.05/21

1.00/8

1.00/11

1.10/10

2019-01-12

Albacete

1-1

Gijon

30/12

2,18

1.86/22

2.25/8

1.82/11

1.91/11

20/2

1,73

1.32/22

1.50/8

1.73/11

0.91/11

2019-01-20

Gijon

2-0

Alcorcon

21/2

1,74

1.30/23

1.50/8

1.73/11

0.92/12

20/5

1,52

1.52/23

1.00/8

2.00/12

1.00/11

2019-01-27

Gijon

1-2

Dep. La Coruna

23/4

1,75

1.38/24

1.88/8

1.83/12

0.92/12

34/16

2,17

1.75/24

1.50/8

2.25/12

1.25/12

2019-02-03

Extremadura UD

0-3

Gijon

29/-4

2,48

1.00/25

0.88/8

0.83/12

1.15/13

24/3

1,80

1.32/25

1.50/8

1.69/13

0.92/12

2019-02-08

Gijon

0-2

Osasuna

27/6

1,85

1.38/26

1.50/8

1.69/13

1.08/13

32/7

2,19

1.81/26

2.38/8

2.46/13

1.15/13

2019-02-17

Las Palmas

1-0

Gijon

31/3

2,19

1.37/27

1.38/8

1.69/13

1.07/14

27/4

1,85

1.33/27

1.38/8

1.57/14

1.08/13

2019-02-24

Gijon

2-3

Rayo Majadahonda

27/3

1,82

1.29/28

1.00/8

1.57/14

1.00/14

23/-11

2,04

1.07/28

0.88/8

1.36/14

0.79/14

2019-03-03

Numancia

1-2

Gijon

33/0

2,28

1.28/29

1.50/8

1.64/14

0.93/15

29/2

1,93

1.24/29

0.88/8

1.47/15

1.00/14

2019-03-09

Gijon

1-0

Almeria

31/3

1,97

1.30/30

1.25/8

1.47/15

1.13/15

33/7

1,97

1.43/30

1.50/8

1.73/15

1.13/15

2019-03-17

Cordoba

1-2

Gijon

34/-21

2,87

0.81/31

0.50/8

1.07/15

0.56/16

32/4

1,94

1.35/31

1.50/8

1.56/16

1.13/15

2019-03-24

Gijon

1-0

R. Oviedo

34/5

1,97

1.41/32

1.50/8

1.56/16

1.25/16

35/2

2,13

1.56/32

1.75/8

1.81/16

1.31/16

2019-03-29

Malaga

1-1

Gijon

33/10

1,70

1.73/33

1.38/8

1.88/16

1.59/17

35/6

1,94

1.45/33

1.88/8

1.65/17

1.25/16

2019-04-05

Tenerife

0-1

Gijon

30/-8

2,00

1.09/34

0.88/8

1.53/17

0.65/17

36/6

1,94

1.44/34

1.63/8

1.65/17

1.24/17

2019-04-12

Gijon

1-0

Granada CF

37/7

1,91

1.49/35

2.00/8

1.65/17

1.33/18

40/18

1,77

1.74/35

1.75/8

1.78/18

1.71/17

2019-04-20

Gimnastic

0-0

Gijon

19/-30

1,89

0.75/36

0.75/8

1.06/17

0.47/19

38/8

1,89

1.53/36

2.38/8

1.72/18

1.33/18

2019-04-28

Gijon

1-1

Elche

38/8

1,84

1.51/37

2.50/8

1.72/18

1.32/19

37/-3

2,08

1.24/37

1.75/8

1.58/19

0.89/18

2019-05-05

Mallorca

2-1

Gijon

48/15

2,13

1.61/38

2.00/8

2.05/19

1.16/19

39/8

1,84

1.50/38

2.25/8

1.68/19

1.32/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-17

Zaragoza

4-2

Gijon

44/-2

2,25

1.18/40

1.25/8

1.05/20

1.30/20

40/7

1,83

1.45/40

1.63/8

1.65/20

1.25/20

2019-05-25

Gijon

0-2

Albacete

42/5

1,93

1.41/41

1.25/8

1.65/20

1.19/21

52/18

2,10

1.73/41

1.50/8

1.76/21

1.70/20

2019-06-02

Reus FCR

0-0

Gijon

16/-13

1,13

0.53/40

0.00/8

0.40/20

0.65/20

42/3

1,93

1.38/42

1.13/8

1.57/21

1.19/21

2019-06-08

Gijon

1-0

Cadiz CF

42/3

1,88

1.35/43

0.75/8

1.57/21

1.14/22

53/17

2,07

1.49/43

1.38/8

1.68/22

1.29/21