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

2014-08-24

Eibar

1-0

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

2014-08-31

Real Sociedad

4-2

Real Madrid

0/-1

1,00

0.00/1

0.00/1

0.00/0

0.00/1

2/2

2,00

3.00/1

3.00/1

3.00/1

0.00/0

2014-09-13

Celta Vigo

2-2

Real Sociedad

4/2

3,00

2.00/2

2.00/2

3.00/1

1.00/1

4/1

3,50

1.50/2

1.50/2

3.00/1

0.00/1

2014-09-21

Real Sociedad

1-2

Almeria

6/1

3,67

1.33/3

1.33/3

3.00/1

0.50/2

2/-1

1,67

0.67/3

0.67/3

1.00/2

0.00/1

2014-09-24

Sevilla

1-0

Real Sociedad

8/5

2,75

2.50/4

2.50/4

2.00/2

3.00/2

7/0

3,50

1.00/4

1.00/4

1.50/2

0.50/2

2014-09-28

Real Sociedad

1-1

Valencia

7/-1

3,00

0.80/5

0.80/5

1.50/2

0.33/3

13/11

3,00

2.60/5

2.60/5

3.00/3

2.00/2

2014-10-05

Espanyol

2-0

Real Sociedad

7/-1

2,50

1.00/6

1.00/6

1.33/3

0.67/3

8/-1

2,83

0.83/6

0.83/6

1.33/3

0.33/3

2014-10-20

Real Sociedad

1-2

Getafe

8/-3

2,71

0.71/7

0.71/7

1.33/3

0.25/4

4/-7

2,14

1.00/7

1.00/7

1.75/4

0.00/3

2014-10-25

Cordoba

1-1

Real Sociedad

5/-8

2,25

0.50/8

0.50/8

0.50/4

0.50/4

9/-4

2,75

0.63/8

0.63/8

1.00/4

0.25/4

2014-11-01

Real Sociedad

0-1

Malaga

10/-4

2,67

0.67/9

0.75/8

1.00/4

0.40/5

11/3

2,11

1.67/9

1.50/8

2.20/5

1.00/4

2014-11-09

Real Sociedad

2-1

Atl. Madrid

10/-5

2,50

0.60/10

0.38/8

0.80/5

0.40/5

19/10

2,80

2.30/10

2.38/8

2.60/5

2.00/5

2014-11-22

Dep. La Coruna

0-0

Real Sociedad

12/-9

3,00

0.82/11

0.63/8

0.80/5

0.83/6

12/-4

2,55

0.82/11

0.63/8

1.17/6

0.40/5

2014-11-28

Real Sociedad

3-0

Elche

12/-4

2,33

0.83/12

0.75/8

1.17/6

0.50/6

12/-12

3,00

0.83/12

0.75/8

0.83/6

0.83/6

2014-12-07

Villarreal

4-0

Real Sociedad

19/5

2,54

1.62/13

1.63/8

1.50/6

1.71/7

15/-1

2,38

1.00/13

1.13/8

1.43/7

0.50/6

2014-12-14

Real Sociedad

1-1

Ath Bilbao

15/-5

2,50

0.93/14

1.00/8

1.43/7

0.43/7

12/-3

1,93

1.29/14

1.75/8

1.57/7

1.00/7

2014-12-20

Levante

1-1

Real Sociedad

11/-18

2,67

0.93/15

1.13/8

1.00/7

0.88/8

16/-5

2,47

0.93/15

1.13/8

1.38/8

0.43/7

2015-01-04

Real Sociedad

1-0

Barcelona

17/-5

2,44

0.94/16

1.25/8

1.38/8

0.50/8

41/34

3,00

2.38/16

2.00/8

2.63/8

2.13/8

2015-01-11

Granada CF

1-1

Real Sociedad

10/-18

2,24

0.76/17

0.50/8

0.88/8

0.67/9

18/-4

2,35

1.06/17

1.50/8

1.56/9

0.50/8

2015-01-17

Real Sociedad

0-1

Rayo Vallecano

19/-4

2,33

1.06/18

1.63/8

1.56/9

0.56/9

19/-14

2,89

1.11/18

1.13/8

0.78/9

1.44/9

2015-01-24

Real Sociedad

1-0

Eibar

19/-5

2,26

1.00/19

1.25/8

1.40/10

0.56/9

24/-1

2,58

1.42/19

1.75/8

1.33/9

1.50/10

2015-01-31

Real Madrid

4-1

Real Sociedad

64/48

4,21

2.53/19

2.63/8

2.63/8

2.45/11

20/-4

2,20

1.10/20

1.50/8

1.55/11

0.56/9

2015-02-07

Real Sociedad

1-1

Celta Vigo

21/-7

2,33

1.05/21

1.13/8

1.55/11

0.50/10

20/-3

2,05

1.14/21

0.50/8

1.50/10

0.82/11

2015-02-13

Almeria

2-2

Real Sociedad

20/-14

2,45

1.00/22

1.50/8

0.60/10

1.33/12

22/-7

2,32

1.05/22

1.25/8

1.50/12

0.50/10

2015-02-22

Real Sociedad

4-3

Sevilla

24/-7

2,39

1.04/23

1.25/8

1.50/12

0.55/11

39/13

2,83

1.96/23

1.88/8

2.50/12

1.36/11

2015-03-01

Valencia

2-0

Real Sociedad

43/22

2,67

2.08/24

2.38/8

2.58/12

1.58/12

28/-6

2,58

1.13/24

1.50/8

1.62/13

0.55/11

2015-03-08

Real Sociedad

1-0

Espanyol

28/-8

2,56

1.08/25

1.13/8

1.62/13

0.50/12

32/-4

2,72

1.28/25

1.50/8

1.85/13

0.67/12

2015-03-16

Getafe

0-1

Real Sociedad

24/-12

2,31

1.12/26

1.50/8

1.38/13

0.85/13

29/-7

2,50

1.15/26

1.38/8

1.71/14

0.50/12

2015-03-22

Real Sociedad

3-1

Cordoba

30/-6

2,44

1.22/27

1.75/8

1.71/14

0.69/13

19/-24

2,30

0.67/27

0.00/8

0.64/14

0.69/13

2015-04-04

Malaga

1-1

Real Sociedad

31/0

2,21

1.57/28

1.50/8

1.93/14

1.21/14

33/-4

2,50

1.29/28

1.75/8

1.80/15

0.69/13

2015-04-07

Atl. Madrid

2-0

Real Sociedad

55/32

2,69

2.14/29

1.88/8

2.53/15

1.71/14

34/-4

2,48

1.28/29

1.88/8

1.80/15

0.71/14

2015-04-12

Real Sociedad

2-2

Dep. La Coruna

34/-6

2,47

1.23/30

1.75/8

1.80/15

0.67/15

25/-22

2,40

0.90/30

0.38/8

1.06/16

0.71/14

2015-04-20

Elche

1-0

Real Sociedad

26/-28

2,58

1.00/31

1.00/8

0.94/16

1.07/15

36/-6

2,52

1.23/31

1.75/8

1.75/16

0.67/15

2015-04-25

Real Sociedad

0-0

Villarreal

36/-7

2,47

1.19/32

1.38/8

1.75/16

0.63/16

44/14

2,31

1.63/32

1.00/8

1.94/16

1.31/16

2015-04-28

Ath Bilbao

1-1

Real Sociedad

33/-4

2,12

1.39/33

2.00/8

1.56/16

1.24/17

36/-7

2,39

1.18/33

1.50/8

1.71/17

0.63/16

2015-05-01

Real Sociedad

3-0

Levante

37/-7

2,38

1.18/34

1.25/8

1.71/17

0.65/17

32/-28

2,71

1.03/34

1.25/8

1.29/17

0.76/17

2015-05-09

Barcelona

2-0

Real Sociedad

105/86

3,54

2.49/35

2.75/8

2.65/17

2.33/18

40/-4

2,40

1.23/35

1.25/8

1.78/18

0.65/17

2015-05-17

Real Sociedad

0-3

Granada CF

40/-6

2,39

1.19/36

0.88/8

1.78/18

0.61/18

26/-38

2,50

0.86/36

1.00/8

1.17/18

0.56/18

2015-05-23

Rayo Vallecano

2-4

Real Sociedad

44/-20

2,92

1.32/37

1.38/8

1.44/18

1.21/19

40/-9

2,41

1.16/37

0.75/8

1.68/19

0.61/18