SELECT * FROM 1_Kampe WHERE LigaID = '127' AND (Home='Villarreal' OR Away='Villarreal') 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 Villarreal 4-4 Granada CF 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-23 Levante 2-1 Villarreal 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   4/0 8,00 1.00/1 1.00/1 1.00/1 0.00/0
2019-09-01 Villarreal 2-2 Real Madrid 5/-1 5,50 0.50/2 0.50/2 1.00/1 0.00/1   4/2 3,00 2.00/2 2.00/2 1.00/1 3.00/1
2019-09-14 Leganes 0-3 Villarreal 1/-3 1,67 0.00/3 0.00/3 0.00/2 0.00/1   7/-1 5,00 0.67/3 0.67/3 1.00/2 0.00/1
2019-09-21 Villarreal 2-0 Valladolid 10/2 4,50 1.25/4 1.25/4 1.00/2 1.50/2   4/-1 2,25 1.25/4 1.25/4 1.00/1 1.33/3
2019-09-24 Barcelona 2-1 Villarreal 12/3 4,20 1.40/5 1.40/5 3.00/2 0.33/3   12/4 4,00 1.60/5 1.60/5 1.67/3 1.50/2
2019-09-27 Villarreal 5-1 Betis 13/3 3,83 1.33/6 1.33/6 1.67/3 1.00/3   9/-1 3,17 1.33/6 1.33/6 1.75/4 0.50/2
2019-10-05 Osasuna 2-1 Villarreal 5/-1 1,57 1.14/7 1.14/7 1.00/3 1.25/4   18/7 4,14 1.57/7 1.57/7 2.00/4 1.00/3
2019-10-20 Espanyol 0-1 Villarreal 4/-10 2,25 0.63/8 0.63/8 0.00/4 1.25/4   19/6 4,00 1.38/8 1.38/8 2.00/4 0.75/4
2019-10-25 Villarreal 4-1 Alaves 20/7 3,67 1.56/9 1.63/8 2.00/4 1.20/5   7/-2 1,78 1.22/9 1.00/8 2.00/5 0.25/4
2019-10-31 Eibar 2-1 Villarreal 10/-5 2,50 0.90/10 1.00/8 1.50/4 0.50/6   24/10 3,80 1.70/10 2.00/8 2.20/5 1.20/5
2019-11-03 Villarreal 0-0 Ath Bilbao 25/9 3,73 1.55/11 1.88/8 2.20/5 1.00/6   11/4 1,64 1.45/11 1.13/8 2.17/6 0.60/5
2019-11-10 Mallorca 3-1 Villarreal 9/-9 2,25 0.92/12 0.88/8 1.57/7 0.00/5   25/9 3,42 1.50/12 1.63/8 2.00/6 1.00/6
2019-11-24 Villarreal 1-3 Celta Vigo 26/7 3,46 1.38/13 1.25/8 2.00/6 0.86/7   7/-12 2,00 0.69/13 0.50/8 1.00/7 0.33/6
2019-11-30 Valencia 2-1 Villarreal 20/0 2,86 1.43/14 1.75/8 1.86/7 1.00/7   27/5 3,50 1.29/14 1.25/8 1.71/7 0.86/7
2019-12-06 Villarreal 0-0 Atl. Madrid 28/4 3,47 1.20/15 0.88/8 1.71/7 0.75/8   16/6 1,73 1.67/15 1.38/8 1.88/8 1.43/7
2019-12-15 Sevilla 1-2 Villarreal 20/5 2,19 1.94/16 2.25/8 2.00/7 1.89/9   28/4 3,25 1.19/16 1.00/8 1.63/8 0.75/8
2019-12-21 Villarreal 1-0 Getafe 30/5 3,24 1.29/17 1.00/8 1.63/8 1.00/9   26/10 2,47 1.76/17 2.13/8 2.00/9 1.50/8
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 Villarreal 1-2 Espanyol 33/7 3,11 1.47/19 1.38/8 1.78/9 1.20/10   14/-22 2,63 0.58/19 0.38/8 0.30/10 0.89/9
2020-01-25 Alaves 1-2 Villarreal 21/-8 2,50 1.15/20 1.38/8 1.60/10 0.70/10   34/6 3,10 1.40/20 1.25/8 1.60/10 1.20/10
2020-02-02 Villarreal 3-1 Osasuna 36/7 3,10 1.48/21 1.63/8 1.60/10 1.36/11   28/3 2,52 1.33/21 1.13/8 1.55/11 1.10/10
2020-02-08 Valladolid 1-1 Villarreal 18/-6 1,91 1.14/22 1.00/8 1.20/10 1.08/12   39/9 3,14 1.55/22 2.00/8 1.73/11 1.36/11
2020-02-15 Villarreal 2-1 Levante 40/9 3,09 1.52/23 2.13/8 1.73/11 1.33/12   29/-5 2,74 1.26/23 1.13/8 1.82/11 0.75/12
2020-02-23 Atl. Madrid 3-1 Villarreal 25/8 1,75 1.67/24 1.75/8 2.08/12 1.25/12   42/10 3,08 1.58/24 2.38/8 1.83/12 1.33/12
2020-03-01 Ath Bilbao 1-0 Villarreal 24/2 1,84 1.24/25 0.50/8 1.75/12 0.77/13   43/8 3,12 1.52/25 2.00/8 1.83/12 1.23/13
2020-03-08 Villarreal 1-2 Leganes 43/7 3,04 1.46/26 1.63/8 1.83/12 1.14/14   19/-19 2,19 0.77/26 0.88/8 1.07/14 0.42/12
2020-06-13 Celta Vigo 0-1 Villarreal 22/-12 2,07 0.96/27 1.38/8 1.31/13 0.64/14   44/6 3,04 1.41/27 1.25/8 1.69/13 1.14/14
2020-06-16 Villarreal 1-0 Mallorca 45/7 2,96 1.46/28 1.63/8 1.69/13 1.27/15   28/-20 2,71 0.89/28 0.88/8 1.33/15 0.38/13
2020-06-19 Granada CF 0-1 Villarreal 37/2 2,48 1.45/29 1.88/8 2.07/14 0.87/15   46/8 2,90 1.52/29 1.63/8 1.79/14 1.27/15
2020-06-22 Villarreal 2-2 Sevilla 47/9 2,83 1.57/30 1.63/8 1.79/14 1.38/16   42/12 2,40 1.73/30 1.63/8 1.80/15 1.67/15
2020-06-28 Villarreal 2-0 Valencia 49/9 2,87 1.55/31 1.63/8 1.73/15 1.38/16   41/-3 2,74 1.48/31 1.13/8 2.13/16 0.80/15
2020-07-01 Betis 0-2 Villarreal 43/-9 2,97 1.16/32 1.00/8 1.75/16 0.56/16   51/11 2,84 1.59/32 1.63/8 1.81/16 1.38/16
2020-07-05 Villarreal 1-4 Barcelona 53/13 2,82 1.64/33 2.00/8 1.81/16 1.47/17   74/39 3,30 2.12/33 1.88/8 2.76/17 1.44/16
2020-07-08 Getafe 1-3 Villarreal 42/11 2,15 1.56/34 1.00/8 1.76/17 1.35/17   54/10 2,88 1.59/34 2.00/8 1.71/17 1.47/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 Madrid 2-1 Villarreal 66/44 2,44 2.31/36 3.00/8 2.56/18 2.06/18   58/11 2,92 1.58/36 2.00/8 1.61/18 1.56/18
2020-07-19 Villarreal 4-0 Eibar 59/10 2,92 1.54/37 1.63/8 1.61/18 1.47/19   39/-13 2,46 1.14/37 1.75/8 1.42/19 0.83/18