SELECT * FROM 1_Kampe WHERE LigaID = '130' AND (Home='Betis' OR Away='Betis') 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-20 Barcelona 6-2 Betis 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-26 Betis 0-0 Dep. La Coruna 2/-4 8,00 0.00/1 0.00/1 0.00/0 0.00/1   2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-09-11 Valencia 2-3 Betis 2/-3 3,50 0.00/2 0.00/2 0.00/1 0.00/1   2/-4 4,00 0.50/2 0.50/2 1.00/1 0.00/1
2016-09-16 Betis 2-2 Granada CF 5/-3 4,33 1.33/3 1.33/3 1.00/1 1.50/2   3/-5 3,67 0.33/3 0.33/3 0.50/2 0.00/1
2016-09-20 Sevilla 1-0 Betis 9/3 3,75 2.00/4 2.00/4 3.00/2 1.00/2   7/-3 4,25 1.25/4 1.25/4 1.00/2 1.50/2
2016-09-23 Betis 1-0 Malaga 7/-4 3,60 1.00/5 1.00/5 1.00/2 1.00/3   5/-2 2,40 1.00/5 1.00/5 1.33/3 0.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-15 Betis 1-6 Real Madrid 8/-4 2,86 1.14/7 1.14/7 1.67/3 0.75/4   16/9 3,29 2.14/7 2.14/7 2.00/4 2.33/3
2016-10-21 Osasuna 1-2 Betis 10/-7 3,38 0.75/8 0.75/8 0.50/4 1.00/4   9/-9 3,38 1.00/8 1.00/8 1.25/4 0.75/4
2016-10-30 Betis 0-1 Espanyol 11/-8 3,33 1.22/9 1.38/8 1.25/4 1.20/5   12/-5 3,22 0.89/9 1.00/8 0.60/5 1.25/4
2016-11-06 Villarreal 2-0 Betis 17/10 2,40 1.90/10 2.13/8 2.60/5 1.20/5   11/-9 3,10 1.10/10 1.25/8 1.00/5 1.20/5
2016-11-18 Betis 2-0 Las Palmas 11/-11 3,00 1.00/11 0.88/8 1.00/5 1.00/6   21/3 3,55 1.45/11 1.25/8 2.00/6 0.80/5
2016-11-25 Eibar 3-1 Betis 17/2 2,67 1.50/12 1.38/8 2.17/6 0.83/6   13/-9 2,92 1.17/12 1.13/8 1.33/6 1.00/6
2016-12-04 Betis 3-3 Celta Vigo 14/-11 3,00 1.08/13 1.13/8 1.33/6 0.86/7   21/-2 3,38 1.54/13 2.00/8 2.14/7 0.83/6
2016-12-11 Betis 1-0 Ath Bilbao 17/-11 3,21 1.07/14 0.88/8 1.29/7 0.86/7   20/3 2,64 1.64/14 1.38/8 2.29/7 1.00/7
2016-12-16 Alaves 1-0 Betis 14/-3 2,07 1.20/15 1.13/8 1.00/7 1.38/8   18/-10 3,07 1.20/15 1.25/8 1.50/8 0.86/7
2017-01-08 Betis 2-0 Leganes 18/-11 2,94 1.13/16 1.25/8 1.50/8 0.75/8   13/-14 2,50 1.00/16 0.75/8 0.75/8 1.25/8
2017-01-14 Atl. Madrid 1-0 Betis 31/17 2,65 1.82/17 1.63/8 2.13/8 1.56/9   20/-9 2,88 1.24/17 1.25/8 1.67/9 0.75/8
2017-01-22 Betis 0-0 Gijon 20/-10 2,78 1.17/18 1.25/8 1.67/9 0.67/9   19/-18 3,11 0.67/18 0.38/8 1.11/9 0.22/9
2017-01-29 Betis 1-1 Barcelona 20/-10 2,63 1.16/19 1.38/8 1.60/10 0.67/9   51/34 3,58 2.16/19 2.00/8 2.00/9 2.30/10
2017-02-11 Betis 0-0 Valencia 21/-10 2,60 1.15/20 1.13/8 1.55/11 0.67/9   29/-11 3,45 0.95/20 1.00/8 0.89/9 1.00/11
2017-02-17 Granada CF 4-1 Betis 17/-31 2,95 0.59/22 0.63/8 1.00/10 0.25/12   21/-10 2,48 1.14/21 1.25/8 1.50/12 0.67/9
2017-02-25 Betis 1-2 Sevilla 22/-13 2,59 1.09/22 1.13/8 1.50/12 0.60/10   46/18 3,22 2.13/23 2.38/8 2.55/11 1.75/12
2017-02-28 Malaga 1-2 Betis 31/-9 2,96 1.08/24 0.63/8 1.82/11 0.46/13   23/-14 2,61 1.04/23 0.75/8 1.38/13 0.60/10
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-08 Dep. La Coruna 1-1 Betis 28/-12 2,72 0.92/25 0.75/8 1.36/11 0.57/14   27/-14 2,72 1.08/25 0.75/8 1.29/14 0.82/11
2017-03-12 Real Madrid 2-1 Betis 67/41 3,72 2.36/25 2.38/8 2.54/13 2.17/12   28/-14 2,69 1.08/26 0.88/8 1.29/14 0.83/12
2017-03-18 Betis 2-0 Osasuna 29/-15 2,70 1.04/27 0.75/8 1.29/14 0.77/13   28/-37 3,44 0.41/27 0.25/8 0.36/14 0.46/13
2017-03-31 Espanyol 2-1 Betis 40/1 2,82 1.43/28 1.38/8 1.64/14 1.21/14   31/-13 2,68 1.11/28 1.00/8 1.40/15 0.77/13
2017-04-04 Betis 0-1 Villarreal 32/-14 2,69 1.07/29 0.88/8 1.40/15 0.71/14   41/18 2,21 1.66/29 1.63/8 1.80/15 1.50/14
2017-04-09 Las Palmas 4-1 Betis 46/-5 3,23 1.17/30 0.88/8 1.93/15 0.40/15   32/-15 2,63 1.03/30 0.88/8 1.31/16 0.71/14
2017-04-16 Betis 2-0 Eibar 33/-18 2,71 1.00/31 0.88/8 1.31/16 0.67/15   52/10 3,03 1.61/31 1.88/8 1.88/16 1.33/15
2017-04-23 Celta Vigo 0-1 Betis 48/-3 3,19 1.42/31 1.25/8 1.87/15 1.00/16   35/-16 2,69 1.06/32 0.88/8 1.41/17 0.67/15
2017-04-27 Ath Bilbao 2-1 Betis 46/9 2,52 1.70/33 2.25/8 2.29/17 1.06/16   36/-15 2,64 1.12/33 1.25/8 1.41/17 0.81/16
2017-04-30 Betis 1-4 Alaves 37/-16 2,65 1.09/34 1.13/8 1.41/17 0.76/17   32/-8 2,12 1.32/34 1.38/8 1.35/17 1.29/17
2017-05-08 Leganes 4-0 Betis 30/-23 2,37 0.86/35 0.63/8 1.00/17 0.72/18   38/-19 2,71 1.06/35 1.13/8 1.33/18 0.76/17
2017-05-14 Betis 1-1 Atl. Madrid 38/-23 2,75 1.03/36 0.75/8 1.33/18 0.72/18   66/41 2,53 2.06/36 2.38/8 2.28/18 1.83/18
2017-05-20 Gijon 2-2 Betis 40/-30 2,97 0.81/37 1.00/8 1.00/18 0.63/19   39/-23 2,73 1.03/37 0.88/8 1.32/19 0.72/18