SELECT * FROM 1_Kampe WHERE LigaID = '130' AND (Home='Osasuna' OR Away='Osasuna') 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-19 Malaga 1-1 Osasuna 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-10 Real Madrid 5-2 Osasuna 5/4 3,00 3.00/2 3.00/2 3.00/1 3.00/1   1/-2 2,00 0.50/2 0.50/2 0.00/1 1.00/1
2016-09-18 Osasuna 0-0 Celta Vigo 3/-5 3,67 0.33/3 0.33/3 0.00/1 0.50/2   1/-6 2,67 0.00/3 0.00/3 0.00/2 0.00/1
2016-09-22 Osasuna 1-2 Espanyol 3/-5 2,75 0.50/4 0.50/4 0.50/2 0.50/2   7/-4 4,50 0.50/4 0.50/4 0.50/2 0.50/2
2016-09-25 Villarreal 3-1 Osasuna 6/3 1,80 1.80/5 1.80/5 2.00/2 1.67/3   4/-6 2,80 0.40/5 0.40/5 0.33/3 0.50/2
2016-10-01 Osasuna 2-2 Las Palmas 5/-8 3,00 0.33/6 0.33/6 0.33/3 0.33/3   14/3 4,17 1.67/6 1.67/6 2.33/3 1.00/3
2016-10-17 Eibar 2-3 Osasuna 9/2 2,29 1.57/7 1.57/7 2.33/3 1.00/4   7/-8 3,14 0.43/7 0.43/7 0.50/4 0.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 Ath Bilbao 1-1 Osasuna 14/2 2,89 1.67/9 1.88/8 2.25/4 1.20/5   11/-8 3,33 0.67/9 0.63/8 0.40/5 1.00/4
2016-11-05 Osasuna 0-1 Alaves 12/-8 3,20 0.70/10 0.75/8 0.40/5 1.00/5   10/-5 2,50 1.00/10 1.00/8 1.20/5 0.80/5
2016-11-21 Leganes 2-0 Osasuna 9/-13 2,82 0.91/11 0.75/8 0.20/5 1.50/6   12/-9 3,00 0.64/11 0.75/8 0.33/6 1.00/5
2016-11-27 Osasuna 0-3 Atl. Madrid 12/-11 2,92 0.58/12 0.63/8 0.33/6 0.83/6   25/14 3,00 1.75/12 1.63/8 2.17/6 1.33/6
2016-12-04 Gijon 3-1 Osasuna 12/-15 3,00 0.69/13 0.25/8 1.17/6 0.29/7   12/-14 2,92 0.54/13 0.63/8 0.29/7 0.83/6
2016-12-10 Osasuna 0-3 Barcelona 13/-16 3,00 0.50/14 0.63/8 0.29/7 0.71/7   34/19 3,50 2.00/14 1.88/8 1.71/7 2.29/7
2016-12-18 Dep. La Coruna 2-0 Osasuna 20/-7 3,13 0.87/15 0.63/8 1.43/7 0.38/8   13/-19 3,00 0.47/15 0.50/8 0.25/8 0.71/7
2017-01-09 Osasuna 3-3 Valencia 13/-21 2,94 0.44/16 0.13/8 0.25/8 0.63/8   21/-8 3,33 0.80/15 0.75/8 0.71/7 0.88/8
2017-01-15 Granada CF 1-1 Osasuna 14/-24 3,06 0.53/17 0.75/8 0.75/8 0.33/9   16/-21 3,12 0.47/17 0.25/8 0.33/9 0.63/8
2017-01-22 Osasuna 3-4 Sevilla 17/-21 3,06 0.50/18 0.25/8 0.33/9 0.67/9   38/16 3,33 2.17/18 2.25/8 2.67/9 1.67/9
2017-01-27 Osasuna 1-1 Malaga 20/-22 3,26 0.47/19 0.25/8 0.30/10 0.67/9   27/-6 3,16 1.11/19 0.75/8 1.89/9 0.40/10
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-11 Osasuna 1-3 Real Madrid 23/-23 3,29 0.48/21 0.38/8 0.36/11 0.60/10   51/34 3,58 2.42/19 2.38/8 2.64/11 2.13/8
2017-02-19 Celta Vigo 3-0 Osasuna 33/-3 3,29 1.43/21 1.25/8 2.10/10 0.82/11   24/-25 3,32 0.45/22 0.38/8 0.33/12 0.60/10
2017-02-26 Espanyol 3-0 Osasuna 30/-1 2,65 1.39/23 1.25/8 1.42/12 1.36/11   24/-28 3,30 0.43/23 0.38/8 0.33/12 0.55/11
2017-03-01 Osasuna 1-4 Villarreal 24/-31 3,29 0.42/24 0.38/8 0.33/12 0.50/12   32/14 2,08 1.63/24 1.25/8 1.85/13 1.36/11
2017-03-05 Las Palmas 5-2 Osasuna 35/-4 2,96 1.16/25 0.63/8 1.77/13 0.50/12   25/-34 3,36 0.40/25 0.25/8 0.31/13 0.50/12
2017-03-13 Osasuna 1-1 Eibar 27/-37 3,50 0.38/26 0.13/8 0.31/13 0.46/13   42/5 3,04 1.50/26 1.63/8 1.86/14 1.08/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-04-01 Osasuna 1-2 Ath Bilbao 28/-39 3,39 0.39/28 0.13/8 0.36/14 0.43/14   35/3 2,39 1.57/28 1.50/8 2.20/15 0.85/13
2017-04-05 Alaves 0-1 Osasuna 29/-7 2,24 1.38/29 1.63/8 1.36/14 1.40/15   29/-40 3,38 0.38/29 0.13/8 0.33/15 0.43/14
2017-04-09 Osasuna 2-1 Leganes 30/-39 3,30 0.47/30 0.50/8 0.33/15 0.60/15   25/-21 2,37 0.90/30 1.13/8 0.93/15 0.87/15
2017-04-15 Atl. Madrid 3-0 Osasuna 56/32 2,58 2.00/31 2.13/8 2.33/15 1.69/16   32/-38 3,29 0.55/31 0.88/8 0.50/16 0.60/15
2017-04-22 Osasuna 2-2 Gijon 32/-41 3,28 0.53/32 0.88/8 0.50/16 0.56/16   34/-30 3,06 0.69/32 0.63/8 0.88/16 0.50/16
2017-04-26 Barcelona 7-1 Osasuna 94/62 3,82 2.27/33 2.25/8 2.44/16 2.12/17   34/-41 3,30 0.55/33 1.00/8 0.53/17 0.56/16
2017-04-30 Osasuna 2-2 Dep. La Coruna 35/-47 3,44 0.53/34 1.00/8 0.53/17 0.53/17   37/-20 2,76 0.91/34 0.88/8 1.35/17 0.47/17
2017-05-07 Valencia 4-1 Osasuna 50/-11 3,17 1.14/35 1.25/8 1.47/17 0.83/18   37/-47 3,46 0.54/35 1.00/8 0.56/18 0.53/17
2017-05-13 Osasuna 2-1 Granada CF 38/-50 3,50 0.53/36 1.00/8 0.56/18 0.50/18   28/-50 2,94 0.56/36 0.13/8 0.89/18 0.22/18
2017-05-20 Sevilla 5-0 Osasuna 64/15 3,05 1.86/37 1.38/8 2.39/18 1.37/19   40/-49 3,49 0.59/37 1.38/8 0.68/19 0.50/18