SELECT * FROM 1_Kampe WHERE LigaID = '130' 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
2016-08-20 Granada CF 1-1 Villarreal 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-28 Villarreal 0-0 Sevilla 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   6/2 10,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-09-10 Malaga 0-2 Villarreal 3/0 3,00 1.00/2 1.00/2 1.00/1 1.00/1   1/0 1,00 1.00/2 1.00/2 1.00/1 1.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 Madrid 1-1 Villarreal 12/9 3,75 3.00/4 3.00/4 3.00/2 3.00/2   5/3 1,75 2.00/4 2.00/4 2.00/2 2.00/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-02 Espanyol 0-0 Villarreal 9/-5 3,83 0.83/6 0.83/6 0.33/3 1.33/3   9/5 2,17 2.00/6 2.00/6 2.33/3 1.67/3
2016-10-16 Villarreal 5-0 Celta Vigo 9/5 1,86 1.86/7 1.86/7 2.33/3 1.50/4   9/-2 2,86 1.43/7 1.43/7 1.50/4 1.33/3
2016-10-23 Villarreal 2-1 Las Palmas 14/10 2,25 2.00/8 2.00/8 2.50/4 1.50/4   16/3 3,63 1.50/8 1.50/8 2.00/4 1.00/4
2016-10-30 Eibar 2-1 Villarreal 14/1 3,00 1.33/9 1.50/8 1.75/4 1.00/5   16/11 2,33 2.11/9 2.25/8 2.60/5 1.50/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-20 Ath Bilbao 1-0 Villarreal 15/2 2,55 1.55/11 1.75/8 2.00/5 1.17/6   19/12 2,36 2.00/11 2.13/8 2.67/6 1.20/5
2016-11-27 Villarreal 0-2 Alaves 19/11 2,25 1.83/12 1.75/8 2.67/6 1.00/6   11/-5 2,25 1.08/12 0.88/8 1.00/6 1.17/6
2016-12-03 Leganes 0-0 Villarreal 11/-14 2,77 1.00/13 0.75/8 0.67/6 1.29/7   19/9 2,23 1.69/13 1.63/8 2.29/7 1.00/6
2016-12-12 Villarreal 3-0 Atl. Madrid 19/9 2,07 1.64/14 1.38/8 2.29/7 1.00/7   28/17 2,79 1.79/14 1.63/8 2.00/7 1.57/7
2016-12-17 Gijon 1-3 Villarreal 16/-14 3,07 0.80/15 0.63/8 1.43/7 0.25/8   22/12 2,13 1.73/15 1.63/8 2.38/8 1.00/7
2017-01-08 Villarreal 1-1 Barcelona 25/14 2,25 1.81/16 1.63/8 2.38/8 1.25/8   41/25 3,56 2.13/16 2.25/8 1.88/8 2.38/8
2017-01-14 Dep. La Coruna 0-0 Villarreal 23/-5 3,00 1.00/17 1.13/8 1.63/8 0.44/9   26/14 2,24 1.76/17 1.38/8 2.22/9 1.25/8
2017-01-21 Villarreal 0-2 Valencia 26/14 2,11 1.72/18 1.50/8 2.22/9 1.22/9   26/-7 3,47 0.94/17 0.88/8 1.00/8 0.89/9
2017-01-28 Villarreal 2-0 Granada CF 26/12 2,11 1.63/19 1.13/8 2.00/10 1.22/9   16/-26 3,05 0.53/19 0.75/8 0.78/9 0.30/10
2017-02-05 Sevilla 0-0 Villarreal 43/15 3,55 2.10/20 2.25/8 2.67/9 1.64/11   28/14 2,10 1.70/20 1.50/8 2.09/11 1.22/9
2017-02-12 Villarreal 1-1 Malaga 28/14 2,00 1.67/21 1.63/8 2.09/11 1.20/10   28/-7 3,00 1.05/21 0.38/8 1.70/10 0.45/11
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-26 Villarreal 2-3 Real Madrid 30/15 1,96 1.70/23 1.63/8 2.00/12 1.36/11   57/37 3,50 2.36/22 2.25/8 2.67/12 2.00/10
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-04 Villarreal 2-0 Espanyol 36/17 2,20 1.68/25 1.50/8 1.85/13 1.50/12   35/2 2,72 1.44/25 1.63/8 1.54/13 1.33/12
2017-03-12 Celta Vigo 0-1 Villarreal 39/-5 3,32 1.40/25 1.38/8 2.08/12 0.77/13   38/19 2,19 1.73/26 1.75/8 1.93/14 1.50/12
2017-03-17 Las Palmas 1-0 Villarreal 43/-2 3,26 1.19/27 0.88/8 1.86/14 0.46/13   39/20 2,15 1.78/27 2.13/8 1.93/14 1.62/13
2017-04-01 Villarreal 2-3 Eibar 39/19 2,11 1.71/28 1.75/8 1.93/14 1.50/14   44/5 2,96 1.46/28 1.50/8 1.80/15 1.08/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-07 Villarreal 3-1 Ath Bilbao 42/19 2,17 1.70/30 1.88/8 1.80/15 1.60/15   39/6 2,40 1.67/30 1.88/8 2.25/16 1.00/14
2017-04-17 Alaves 2-1 Villarreal 29/-9 2,16 1.29/31 1.25/8 1.27/15 1.31/16   45/21 2,23 1.74/31 1.88/8 1.88/16 1.60/15
2017-04-22 Villarreal 2-1 Leganes 46/20 2,25 1.69/32 1.88/8 1.88/16 1.50/16   26/-23 2,34 0.84/32 0.75/8 0.88/16 0.81/16
2017-04-25 Atl. Madrid 0-1 Villarreal 60/36 2,55 2.06/33 2.75/8 2.38/16 1.76/17   48/21 2,27 1.73/33 1.88/8 1.94/17 1.50/16
2017-04-28 Villarreal 3-1 Gijon 49/22 2,24 1.76/34 1.88/8 1.94/17 1.59/17   37/-30 3,06 0.71/34 0.88/8 0.88/17 0.53/17
2017-05-06 Barcelona 4-1 Villarreal 104/71 3,91 2.31/35 2.63/8 2.47/17 2.17/18   52/24 2,29 1.80/35 1.88/8 2.00/18 1.59/17
2017-05-14 Villarreal 0-0 Dep. La Coruna 53/21 2,36 1.75/36 1.88/8 2.00/18 1.50/18   40/-21 2,81 0.89/36 0.63/8 1.28/18 0.50/18
2017-05-21 Valencia 1-3 Villarreal 55/-7 3,16 1.24/37 1.63/8 1.56/18 0.95/19   53/21 2,30 1.73/37 2.00/8 1.95/19 1.50/18