SELECT * FROM 1_Kampe WHERE LigaID = '127' AND (Home='Real Sociedad' OR Away='Real Sociedad') 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-17

Valencia

1-1

Real Sociedad

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

Mallorca

0-1

Real Sociedad

2/1

3,00

3.00/1

3.00/1

3.00/1

0.00/0

1/0

2,00

1.00/1

1.00/1

0.00/0

1.00/1

2019-08-30

Ath Bilbao

2-0

Real Sociedad

2/1

1,50

2.00/2

2.00/2

3.00/1

1.00/1

2/1

1,50

2.00/2

2.00/2

0.00/0

2.00/2

2019-09-14

Real Sociedad

2-0

Atl. Madrid

2/-1

1,67

1.33/3

1.33/3

0.00/0

1.33/3

5/3

2,33

3.00/3

3.00/3

3.00/2

3.00/1

2019-09-22

Espanyol

1-3

Real Sociedad

2/-4

2,00

1.00/4

1.00/4

0.00/2

2.00/2

4/1

1,75

1.75/4

1.75/4

3.00/1

1.33/3

2019-09-26

Real Sociedad

3-0

Alaves

7/3

2,20

2.00/5

2.00/5

3.00/1

1.75/4

2/-2

1,20

1.00/5

1.00/5

1.33/3

0.50/2

2019-09-29

Sevilla

3-2

Real Sociedad

7/2

2,00

1.67/6

1.67/6

0.50/2

2.25/4

10/6

2,33

2.17/6

2.17/6

3.00/2

1.75/4

2019-10-06

Real Sociedad

1-2

Getafe

12/5

2,71

1.86/7

1.86/7

3.00/2

1.40/5

10/-1

3,00

1.00/7

1.00/7

1.25/4

0.67/3

2019-10-20

Real Sociedad

3-1

Betis

13/4

2,75

1.63/8

1.63/8

2.00/3

1.40/5

11/-5

3,38

1.13/8

1.13/8

1.60/5

0.33/3

2019-10-27

Celta Vigo

0-1

Real Sociedad

5/-6

1,78

1.00/9

1.13/8

1.40/5

0.50/4

16/6

2,89

1.78/9

1.88/8

2.25/4

1.40/5

2019-10-30

Real Sociedad

1-2

Levante

17/7

2,70

1.90/10

1.88/8

2.25/4

1.67/6

10/-2

2,20

1.10/10

1.00/8

1.60/5

0.60/5

2019-11-03

Granada CF

1-2

Real Sociedad

18/5

2,82

1.82/11

2.00/8

2.40/5

1.33/6

18/6

2,73

1.73/11

1.88/8

1.80/5

1.67/6

2019-11-08

Real Sociedad

1-1

Leganes

20/7

2,75

1.83/12

1.88/8

1.80/5

1.86/7

6/-15

2,25

0.42/12

0.63/8

0.57/7

0.20/5

2019-11-23

Real Madrid

3-1

Real Sociedad

25/16

2,83

2.08/12

2.13/8

2.33/6

1.83/6

21/7

2,69

1.77/13

1.63/8

1.67/6

1.86/7

2019-11-30

Real Sociedad

4-1

Eibar

22/5

2,79

1.64/14

1.25/8

1.67/6

1.63/8

14/-9

2,64

1.07/14

1.25/8

1.29/7

0.86/7

2019-12-08

Valladolid

0-0

Real Sociedad

14/-4

2,13

1.20/15

1.13/8

1.50/6

1.00/9

26/8

2,93

1.73/15

1.63/8

1.86/7

1.63/8

2019-12-14

Real Sociedad

2-2

Barcelona

26/8

2,75

1.69/16

1.75/8

1.86/7

1.56/9

41/23

3,93

2.27/15

2.63/8

3.00/7

1.63/8

2019-12-22

Osasuna

3-4

Real Sociedad

22/2

2,47

1.35/17

1.50/8

1.63/8

1.11/9

28/8

2,82

1.65/17

1.50/8

1.75/8

1.56/9

2020-01-05

Real Sociedad

1-2

Villarreal

32/9

3,06

1.72/18

1.50/8

1.75/8

1.70/10

31/6

3,11

1.39/18

1.00/8

1.78/9

1.00/9

2020-01-19

Betis

3-0

Real Sociedad

26/-6

3,05

1.26/19

1.50/8

1.70/10

0.78/9

33/8

3,05

1.63/19

1.50/8

1.56/9

1.70/10

2020-01-26

Real Sociedad

3-0

Mallorca

33/5

3,05

1.55/20

1.13/8

1.56/9

1.55/11

22/-12

2,80

0.90/20

0.88/8

1.55/11

0.11/9

2020-02-02

Leganes

2-1

Real Sociedad

16/-17

2,33

0.71/21

1.13/8

0.91/11

0.50/10

36/8

3,05

1.62/21

1.38/8

1.70/10

1.55/11

2020-02-09

Real Sociedad

2-1

Ath Bilbao

37/7

3,05

1.55/22

1.38/8

1.70/10

1.42/12

22/5

1,77

1.41/22

1.00/8

1.91/11

0.91/11

2020-02-22

Real Sociedad

3-0

Valencia

39/8

3,04

1.61/23

1.38/8

1.82/11

1.42/12

35/1

2,88

1.58/24

1.50/8

2.08/13

1.00/11

2020-02-28

Real Sociedad

1-0

Valladolid

42/11

3,04

1.67/24

1.63/8

1.92/12

1.42/12

22/-6

2,00

1.16/25

1.25/8

1.33/12

1.00/13

2020-03-07

Barcelona

1-0

Real Sociedad

62/31

3,58

2.12/26

2.00/8

2.85/13

1.38/13

43/12

2,96

1.72/25

1.88/8

2.00/13

1.42/12

2020-03-10

Eibar

1-2

Real Sociedad

26/-13

2,50

1.04/26

1.00/8

1.46/13

0.62/13

43/11

2,88

1.65/26

1.50/8

2.00/13

1.31/13

2020-06-14

Real Sociedad

1-1

Osasuna

45/12

2,89

1.70/27

1.88/8

2.00/13

1.43/14

34/-4

2,67

1.26/27

1.25/8

1.43/14

1.08/13

2020-06-18

Alaves

2-0

Real Sociedad

29/-10

2,43

1.14/28

1.13/8

1.64/14

0.64/14

46/12

2,86

1.68/28

2.00/8

1.93/14

1.43/14

2020-06-21

Real Sociedad

1-2

Real Madrid

46/10

2,83

1.62/29

1.63/8

1.93/14

1.33/15

55/35

2,59

2.14/29

2.00/8

2.47/15

1.79/14

2020-06-24

Real Sociedad

0-1

Celta Vigo

47/9

2,83

1.57/30

1.63/8

1.80/15

1.33/15

28/-7

2,10

1.00/30

1.63/8

1.33/15

0.67/15

2020-06-29

Getafe

2-1

Real Sociedad

40/11

2,23

1.58/31

0.88/8

1.69/16

1.47/15

47/8

2,77

1.52/31

1.25/8

1.69/16

1.33/15

2020-07-02

Real Sociedad

2-1

Espanyol

48/7

2,78

1.47/32

0.88/8

1.69/16

1.25/16

26/-25

2,41

0.75/32

0.63/8

0.69/16

0.81/16

2020-07-06

Levante

1-1

Real Sociedad

41/-5

2,64

1.27/33

1.25/8

1.75/16

0.82/17

50/8

2,79

1.52/33

0.88/8

1.76/17

1.25/16

2020-07-10

Real Sociedad

2-3

Granada CF

51/8

2,76

1.50/34

1.00/8

1.76/17

1.24/17

42/2

2,41

1.38/34

1.25/8

1.76/17

1.00/17

2020-07-13

Villarreal

1-2

Real Sociedad

57/12

2,91

1.63/35

2.38/8

1.71/17

1.56/18

53/7

2,83

1.46/35

0.63/8

1.67/18

1.24/17

2020-07-16

Real Sociedad

0-0

Sevilla

55/8

2,83

1.50/36

0.88/8

1.67/18

1.33/18

53/19

2,42

1.83/36

2.00/8

1.89/18

1.78/18

2020-07-19

Atl. Madrid

1-1

Real Sociedad

50/24

2,05

1.86/37

2.50/8

2.28/18

1.47/19

55/8

2,76

1.49/37

1.00/8

1.63/19

1.33/18