SELECT * FROM 1_Kampe WHERE LigaID = '151' AND (Home='Rio Ave' OR Away='Rio Ave') 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
2015-08-15 BSAD 3-3 Rio Ave 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
2015-08-21 Rio Ave 1-0 Braga 3/0 6,00 1.00/1 1.00/1 0.00/0 1.00/1   2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2015-08-29 Vitoria Setubal 2-2 Rio Ave 6/4 4,00 2.00/2 2.00/2 1.00/1 3.00/1   4/1 3,50 2.00/2 2.00/2 3.00/1 1.00/1
2015-09-13 Rio Ave 1-2 Sporting CP 6/1 3,67 1.67/3 1.67/3 3.00/1 1.00/2   6/3 3,00 2.33/3 2.33/3 1.00/1 3.00/2
2015-09-19 Pacos Ferreira 0-3 Rio Ave 4/2 1,50 2.00/4 2.00/4 2.00/2 2.00/2   7/0 3,50 1.25/4 1.25/4 1.50/2 1.00/2
2015-09-28 Rio Ave 1-0 Academica 10/3 3,40 1.60/5 1.60/5 1.50/2 1.67/3   1/-11 2,60 0.00/5 0.00/5 0.00/3 0.00/2
2015-10-03 Rio Ave 1-0 Boavista 11/4 3,00 1.83/6 1.83/6 2.00/3 1.67/3   5/-2 2,00 1.33/6 1.33/6 1.33/3 1.33/3
2015-10-24 Estoril 2-2 Rio Ave 6/-2 2,00 1.71/7 1.71/7 3.00/3 0.75/4   12/5 2,71 2.00/7 2.00/7 2.25/4 1.67/3
2015-11-01 Rio Ave 1-0 Nacional 14/5 2,88 1.88/8 1.88/8 2.25/4 1.50/4   6/-2 1,75 1.00/8 1.00/8 2.00/4 0.00/4
2015-11-08 Maritimo 3-2 Rio Ave 11/-3 2,78 1.22/9 1.38/8 1.75/4 0.80/5   15/6 2,67 2.00/9 2.13/8 2.40/5 1.50/4
2015-11-29 Rio Ave 0-1 Moreirense 17/5 2,90 1.80/10 1.75/8 2.40/5 1.20/5   8/-7 2,30 0.70/10 0.88/8 1.00/5 0.40/5
2015-12-07 Vitoria Guimaraes 3-1 Rio Ave 9/-6 2,18 1.18/11 1.38/8 1.00/5 1.33/6   17/4 2,73 1.64/11 1.63/8 2.00/6 1.20/5
2015-12-12 Rio Ave 3-1 Arouca 18/2 2,83 1.50/12 1.63/8 2.00/6 1.00/6   12/1 1,92 1.33/12 1.13/8 1.33/6 1.33/6
2015-12-20 Benfica 3-1 Rio Ave 31/22 3,08 2.15/13 2.38/8 2.57/7 1.67/6   21/4 2,92 1.62/13 1.63/8 2.14/7 1.00/6
2016-01-03 Rio Ave 2-3 Tondela 22/2 3,00 1.50/14 1.25/8 2.14/7 0.86/7   6/-15 1,93 0.36/14 0.25/8 0.50/8 0.17/6
2016-01-06 FC Porto 1-1 Rio Ave 28/20 2,40 2.20/15 2.00/8 2.75/8 1.57/7   24/1 3,13 1.40/15 0.88/8 1.88/8 0.86/7
2016-01-10 Rio Ave 1-0 U. Madeira 25/1 3,06 1.38/16 0.88/8 1.88/8 0.88/8   10/-11 1,94 1.06/16 1.38/8 1.67/9 0.29/7
2016-01-17 Rio Ave 1-2 BSAD 26/2 2,94 1.47/17 0.88/8 2.00/9 0.88/8   20/-16 3,29 1.06/17 1.00/8 1.88/8 0.33/9
2016-01-24 Braga 5-1 Rio Ave 28/15 2,28 1.78/18 1.50/8 2.13/8 1.50/10   27/1 2,94 1.39/18 0.88/8 1.80/10 0.88/8
2016-01-31 Rio Ave 2-1 Vitoria Setubal 28/-3 3,11 1.32/19 0.88/8 1.80/10 0.78/9   30/-5 3,42 1.32/19 1.25/8 1.20/10 1.44/9
2016-02-08 Sporting CP 0-0 Rio Ave 43/29 2,85 2.55/20 2.38/8 2.60/10 2.50/10   30/-2 3,10 1.40/20 1.25/8 1.91/11 0.78/9
2016-02-15 Rio Ave 1-1 Pacos Ferreira 30/-2 2,95 1.38/21 1.00/8 1.91/11 0.80/10   29/4 2,57 1.43/21 1.25/8 1.55/11 1.30/10
2016-02-20 Academica 0-2 Rio Ave 22/-17 2,77 0.86/22 1.13/8 1.45/11 0.27/11   31/-2 2,91 1.36/22 1.13/8 1.83/12 0.80/10
2016-02-27 Boavista 1-2 Rio Ave 16/-14 2,00 0.91/23 1.38/8 0.91/11 0.92/12   33/0 2,87 1.43/23 1.50/8 1.83/12 1.00/11
2016-03-07 Rio Ave 1-3 Estoril 35/1 2,88 1.50/24 1.75/8 1.83/12 1.17/12   25/-4 2,25 1.25/24 1.63/8 1.75/12 0.75/12
2016-03-13 Nacional 1-0 Rio Ave 28/-7 2,52 1.12/25 1.38/8 1.50/12 0.77/13   36/-1 2,92 1.44/25 1.38/8 1.69/13 1.17/12
2016-03-18 Rio Ave 1-0 Maritimo 36/-2 2,85 1.38/26 1.38/8 1.69/13 1.08/13   36/-15 3,35 1.12/26 1.00/8 1.31/13 0.92/13
2016-04-03 Moreirense 0-1 Rio Ave 32/-13 2,85 1.04/27 1.00/8 0.77/13 1.29/14   37/-1 2,78 1.44/27 1.75/8 1.79/14 1.08/13
2016-04-11 Rio Ave 2-0 Vitoria Guimaraes 38/0 2,71 1.50/28 1.75/8 1.79/14 1.21/14   38/-5 2,89 1.25/28 0.63/8 1.20/15 1.31/13
2016-04-16 Arouca 0-0 Rio Ave 39/5 2,52 1.55/29 2.13/8 1.79/14 1.33/15   40/2 2,69 1.55/29 2.00/8 1.87/15 1.21/14
2016-04-24 Rio Ave 0-1 Benfica 40/2 2,60 1.53/30 2.00/8 1.87/15 1.20/15   80/59 3,37 2.53/30 3.00/8 2.60/15 2.47/15
2016-04-30 Tondela 1-1 Rio Ave 27/-25 2,55 0.74/31 1.63/8 0.60/15 0.88/16   40/1 2,55 1.48/31 1.63/8 1.75/16 1.20/15
2016-05-07 Rio Ave 1-3 FC Porto 41/1 2,53 1.47/32 1.38/8 1.75/16 1.19/16   58/30 2,69 2.00/32 1.50/8 2.19/16 1.81/16
2016-05-14 U. Madeira 1-2 Rio Ave 26/-22 2,24 0.88/33 0.50/8 1.50/16 0.29/17   42/-1 2,58 1.42/33 1.38/8 1.65/17 1.19/16
2018-10-21 Rio Ave 0-1 Belenenses 44/0 2,59 1.47/34 1.75/8 1.65/17 1.29/17   38/-4 2,29 1.37/35 1.88/8 0.00/19 3.00/16
2018-10-21 Rio Ave 0-1 Setubal 44/-1 2,54 1.43/35 1.13/8 1.56/18 1.29/17   33/2 2,06 1.55/31 1.50/8 0.00/15 3.00/16
2018-10-21 Sporting 0-1 Rio Ave 42/7 2,41 1.69/32 1.13/8 0.00/14 3.00/18   44/-2 2,50 1.39/36 1.13/8 1.47/19 1.29/17
2018-10-21 Rio Ave 0-1 Ferreira 45/-1 2,46 1.43/37 1.13/8 1.47/19 1.39/18   39/2 2,45 1.55/31 1.13/8 0.00/15 3.00/16
2018-10-21 Guimaraes 0-1 Rio Ave 3/1 1,00 1.80/5 1.88/8 0.00/2 3.00/3   45/-2 2,42 1.39/38 1.13/8 1.40/20 1.39/18
2018-10-21 Rio Ave 0-1 Guimaraes 46/-1 2,38 1.44/39 1.13/8 1.40/20 1.47/19   25/-2 2,36 1.36/22 1.88/8 0.00/12 3.00/10
2018-10-21 Ferreira 1-3 Rio Ave 17/3 3,10 1.80/10 1.13/8 0.00/4 3.00/6   46/-2 2,35 1.40/40 1.13/8 1.33/21 1.47/19
2018-10-21 Rio Ave 1-3 Sporting 49/0 2,39 1.44/41 1.13/8 1.33/21 1.55/20   18/1 3,18 1.64/11 1.13/8 0.00/5 3.00/6
2018-10-21 Setubal 1-3 Rio Ave 20/-1 2,93 1.29/14 1.50/8 0.00/8 3.00/6   50/-2 2,43 1.40/42 1.13/8 1.27/22 1.55/20
2018-10-21 Belenenses 1-3 Rio Ave 24/1 3,36 1.50/14 1.88/8 0.00/7 3.00/7   53/0 2,47 1.44/43 1.13/8 1.27/22 1.62/21