SELECT * FROM 1_Kampe WHERE LigaID = '130' 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
2016-08-21 Real Sociedad 0-3 Real Madrid 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
2016-08-27 Osasuna 0-2 Real Sociedad 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   0/-3 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2016-09-09 Real Sociedad 1-1 Espanyol 2/-1 2,50 1.50/2 1.50/2 0.00/1 3.00/1   6/-2 7,00 0.50/2 0.50/2 1.00/1 0.00/1
2016-09-18 Villarreal 2-1 Real Sociedad 3/2 1,33 1.67/3 1.67/3 1.00/1 2.00/2   3/-1 2,33 1.33/3 1.33/3 0.50/2 3.00/1
2016-09-21 Real Sociedad 4-1 Las Palmas 4/-2 2,50 1.00/4 1.00/4 0.50/2 1.50/2   11/6 4,00 2.25/4 2.25/4 3.00/2 1.50/2
2016-09-24 Eibar 2-0 Real Sociedad 6/0 2,40 1.40/5 1.40/5 2.00/2 1.00/3   8/1 3,00 1.40/5 1.40/5 1.33/3 1.50/2
2016-09-30 Real Sociedad 1-0 Betis 8/-1 2,83 1.17/6 1.17/6 1.33/3 1.00/3   8/-3 3,17 1.33/6 1.33/6 1.67/3 1.00/3
2016-10-16 Ath Bilbao 3-2 Real Sociedad 10/2 2,57 1.71/7 1.71/7 2.00/3 1.50/4   9/0 2,57 1.43/7 1.43/7 1.75/4 1.00/3
2016-10-22 Real Sociedad 3-0 Alaves 11/-1 2,88 1.25/8 1.25/8 1.75/4 0.75/4   9/1 2,13 1.25/8 1.25/8 1.50/4 1.00/4
2016-10-28 Leganes 0-2 Real Sociedad 9/-8 2,89 1.11/9 0.88/8 0.25/4 1.80/5   14/2 2,89 1.44/9 1.63/8 2.00/5 0.75/4
2016-11-05 Real Sociedad 2-0 Atl. Madrid 16/4 2,80 1.60/10 1.63/8 2.00/5 1.20/5   25/19 3,10 2.10/10 2.38/8 2.60/5 1.60/5
2016-11-20 Gijon 1-3 Real Sociedad 10/-12 2,91 0.82/11 0.25/8 1.40/5 0.33/6   18/6 2,73 1.73/11 1.88/8 2.17/6 1.20/5
2016-11-27 Real Sociedad 1-1 Barcelona 21/8 2,83 1.83/12 2.25/8 2.17/6 1.50/6   32/19 3,75 2.17/12 2.13/8 1.83/6 2.50/6
2016-12-05 Dep. La Coruna 5-1 Real Sociedad 13/-10 2,77 0.77/13 0.63/8 1.17/6 0.43/7   22/8 2,77 1.77/13 2.00/8 2.00/7 1.50/6
2016-12-10 Real Sociedad 3-2 Valencia 23/4 3,00 1.64/14 2.00/8 2.00/7 1.29/7   19/-7 3,21 0.86/14 0.75/8 0.71/7 1.00/7
2016-12-17 Granada CF 0-2 Real Sociedad 14/-17 3,00 0.60/15 0.88/8 0.86/7 0.38/8   26/5 3,13 1.73/15 2.00/8 2.13/8 1.29/7
2017-01-07 Real Sociedad 0-4 Sevilla 28/7 3,06 1.81/16 2.38/8 2.13/8 1.50/8   32/11 3,31 2.06/16 2.00/8 2.63/8 1.50/8
2017-01-16 Malaga 0-2 Real Sociedad 26/-3 3,24 1.24/17 1.13/8 2.13/8 0.44/9   28/3 3,12 1.71/17 2.00/8 1.89/9 1.50/8
2017-01-22 Real Sociedad 1-0 Celta Vigo 30/5 3,06 1.78/18 2.00/8 1.89/9 1.67/9   29/-3 3,39 1.50/18 1.63/8 2.10/10 0.75/8
2017-01-29 Real Madrid 3-0 Real Sociedad 48/31 3,61 2.39/18 2.38/8 2.60/10 2.13/8   31/6 2,95 1.84/19 2.00/8 2.00/10 1.67/9
2017-02-05 Real Sociedad 3-2 Osasuna 31/3 2,95 1.75/20 1.63/8 2.00/10 1.50/10   21/-22 3,20 0.50/20 0.38/8 0.36/11 0.67/9
2017-02-10 Espanyol 1-2 Real Sociedad 29/2 2,67 1.52/21 1.75/8 1.55/11 1.50/10   34/4 3,05 1.81/21 1.88/8 2.09/11 1.50/10
2017-02-19 Real Sociedad 0-1 Villarreal 36/5 3,05 1.86/22 2.25/8 2.09/11 1.64/11   29/14 2,00 1.64/22 1.63/8 2.00/12 1.20/10
2017-02-24 Las Palmas 0-1 Real Sociedad 32/-3 2,91 1.22/23 0.88/8 1.92/12 0.45/11   36/4 2,96 1.78/23 1.88/8 1.92/12 1.64/11
2017-02-28 Real Sociedad 2-2 Eibar 37/5 2,88 1.83/24 1.88/8 1.92/12 1.75/12   39/8 2,92 1.58/24 1.88/8 2.00/13 1.09/11
2017-03-03 Betis 2-3 Real Sociedad 25/-13 2,63 1.13/24 1.13/8 1.38/13 0.82/11   39/5 2,92 1.80/25 2.00/8 1.85/13 1.75/12
2017-03-12 Real Sociedad 0-2 Ath Bilbao 42/6 3,00 1.85/26 2.00/8 1.85/13 1.85/13   32/2 2,38 1.58/26 1.63/8 2.36/14 0.67/12
2017-03-18 Alaves 1-0 Real Sociedad 28/-5 2,26 1.37/27 1.75/8 1.23/13 1.50/14   42/4 2,96 1.78/27 1.63/8 1.71/14 1.85/13
2017-04-01 Real Sociedad 1-1 Leganes 42/3 2,89 1.71/28 1.63/8 1.71/14 1.71/14   22/-19 2,25 0.93/28 1.00/8 1.00/14 0.86/14
2017-04-04 Atl. Madrid 1-0 Real Sociedad 54/31 2,66 2.00/29 2.38/8 2.29/14 1.73/15   43/3 2,86 1.69/29 1.38/8 1.67/15 1.71/14
2017-04-10 Real Sociedad 3-1 Gijon 43/2 2,80 1.63/30 1.00/8 1.67/15 1.60/15   31/-27 2,97 0.73/30 0.75/8 0.93/15 0.53/15
2017-04-15 Barcelona 3-2 Real Sociedad 88/60 3,74 2.23/31 2.25/8 2.40/15 2.06/16   46/4 2,84 1.68/31 1.38/8 1.75/16 1.60/15
2017-04-23 Real Sociedad 1-0 Dep. La Coruna 48/3 2,91 1.63/32 1.00/8 1.75/16 1.50/16   35/-15 2,66 0.97/32 1.38/8 1.44/16 0.50/16
2017-04-26 Valencia 2-3 Real Sociedad 47/-9 3,12 1.21/33 1.38/8 1.56/16 0.88/17   49/4 2,85 1.67/33 1.25/8 1.82/17 1.50/16
2017-04-29 Real Sociedad 2-1 Granada CF 52/5 2,91 1.71/34 1.25/8 1.82/17 1.59/17   27/-45 2,91 0.59/34 0.13/8 0.94/17 0.24/17
2017-05-05 Sevilla 1-1 Real Sociedad 62/18 3,03 1.94/35 1.38/8 2.47/17 1.44/18   54/6 2,91 1.74/35 1.63/8 1.89/18 1.59/17
2017-05-14 Real Sociedad 2-2 Malaga 55/6 2,89 1.72/36 1.75/8 1.89/18 1.56/18   47/-4 2,72 1.25/36 2.25/8 1.78/18 0.72/18
2017-05-21 Celta Vigo 2-2 Real Sociedad 51/-16 3,19 1.19/37 0.38/8 1.56/18 0.84/19   57/6 2,92 1.70/37 1.75/8 1.84/19 1.56/18