SELECT * FROM 1_Kampe WHERE LigaID = '151' AND (Home='Academica' OR Away='Academica') 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-17 Pacos Ferreira 1-0 Academica 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-24 Academica 0-4 Vitoria Setubal 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0
2015-08-30 Academica 1-3 Sporting CP 0/-5 2,50 0.00/2 0.00/2 0.00/1 0.00/1   3/1 2,50 2.00/2 2.00/2 1.00/1 3.00/1
2015-09-13 Nacional 2-0 Academica 2/-1 1,67 1.00/3 1.00/3 3.00/1 0.00/2   1/-7 3,00 0.00/3 0.00/3 0.00/2 0.00/1
2015-09-20 Academica 0-2 Boavista 1/-9 2,75 0.00/4 0.00/4 0.00/2 0.00/2   3/-4 2,50 1.00/4 1.00/4 1.50/2 0.50/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 Academica 1-0 Maritimo 1/-12 2,33 0.00/6 0.00/6 0.00/3 0.00/3   10/-1 3,50 1.33/6 1.33/6 2.33/3 0.33/3
2015-10-24 Vitoria Guimaraes 1-1 Academica 5/-7 2,43 0.86/7 0.86/7 1.33/3 0.50/4   2/-11 2,14 0.43/7 0.43/7 0.75/4 0.00/3
2015-11-01 Academica 1-1 Moreirense 3/-11 2,13 0.50/8 0.50/8 0.75/4 0.25/4   5/-9 2,38 0.38/8 0.38/8 0.50/4 0.25/4
2015-11-06 Estoril 1-1 Academica 8/-3 2,11 1.44/9 1.63/8 2.50/4 0.60/5   4/-11 2,11 0.56/9 0.63/8 0.80/5 0.25/4
2015-11-29 Academica 1-1 Arouca 5/-11 2,10 0.60/10 0.75/8 0.80/5 0.40/5   8/0 1,60 1.20/10 0.75/8 1.00/5 1.40/5
2015-12-04 Benfica 3-0 Academica 24/17 3,10 2.10/10 2.25/8 2.50/6 1.50/4   6/-11 2,09 0.64/11 0.88/8 0.83/6 0.40/5
2015-12-14 Academica 4-3 BSAD 6/-14 2,17 0.58/12 0.88/8 0.83/6 0.33/6   12/-14 3,17 1.08/12 1.25/8 1.83/6 0.33/6
2015-12-20 FC Porto 3-1 Academica 25/20 2,31 2.31/13 2.13/8 2.71/7 1.83/6   10/-13 2,54 0.77/13 1.25/8 1.14/7 0.33/6
2016-01-02 Academica 3-1 U. Madeira 11/-15 2,64 0.71/14 1.25/8 1.14/7 0.29/7   8/-10 1,86 1.00/14 1.00/8 1.50/8 0.33/6
2016-01-06 Braga 3-0 Academica 20/12 1,87 1.73/15 1.63/8 2.00/7 1.50/8   14/-13 2,73 0.87/15 1.25/8 1.38/8 0.29/7
2016-01-10 Academica 2-1 Tondela 14/-16 2,75 0.81/16 1.13/8 1.38/8 0.25/8   9/-16 2,13 0.50/16 0.38/8 0.44/9 0.57/7
2016-01-16 Academica 1-1 Pacos Ferreira 16/-15 2,76 0.94/17 1.38/8 1.56/9 0.25/8   25/7 2,53 1.65/17 1.75/8 1.89/9 1.38/8
2016-01-22 Vitoria Setubal 2-1 Academica 28/-6 3,44 1.22/18 1.00/8 1.00/9 1.44/9   17/-15 2,72 0.94/18 1.38/8 1.50/10 0.25/8
2016-01-30 Sporting CP 3-2 Academica 40/28 2,74 2.53/19 2.38/8 2.56/9 2.50/10   18/-16 2,74 0.89/19 1.25/8 1.50/10 0.22/9
2016-02-07 Academica 2-2 Nacional 20/-17 2,85 0.85/20 1.25/8 1.50/10 0.20/10   21/-7 2,45 1.00/20 0.63/8 1.50/10 0.50/10
2016-02-14 Boavista 0-0 Academica 16/-12 2,10 0.95/21 1.25/8 0.90/10 1.00/11   22/-17 2,90 0.86/21 1.00/8 1.45/11 0.20/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-28 Maritimo 1-0 Academica 33/-13 3,43 1.09/23 0.88/8 1.27/11 0.92/12   22/-19 2,74 0.83/23 0.75/8 1.33/12 0.27/11
2016-03-06 Academica 2-0 Vitoria Guimaraes 22/-20 2,67 0.79/24 0.75/8 1.33/12 0.25/12   35/-1 2,96 1.42/24 1.50/8 1.31/13 1.55/11
2016-03-13 Moreirense 2-2 Academica 30/-13 2,92 1.04/25 1.13/8 0.75/12 1.31/13   24/-18 2,64 0.88/25 0.75/8 1.46/13 0.25/12
2016-03-20 Academica 0-3 Estoril 26/-18 2,69 0.88/26 0.75/8 1.46/13 0.31/13   29/-3 2,35 1.27/26 1.63/8 1.62/13 0.92/13
2016-04-02 Arouca 3-2 Academica 36/4 2,52 1.52/27 2.13/8 1.69/13 1.36/14   26/-21 2,70 0.85/27 0.75/8 1.36/14 0.31/13
2016-04-09 Academica 1-2 Benfica 28/-22 2,79 0.82/28 0.75/8 1.36/14 0.29/14   76/57 3,39 2.50/28 2.63/8 2.57/14 2.43/14
2016-04-17 BSAD 1-1 Academica 39/-20 3,38 1.24/29 1.38/8 1.36/14 1.13/15   29/-23 2,79 0.79/29 0.63/8 1.27/15 0.29/14
2016-04-23 Academica 1-2 FC Porto 30/-23 2,77 0.80/30 0.63/8 1.27/15 0.33/15   55/31 2,63 2.03/30 1.88/8 2.33/15 1.73/15
2016-05-01 U. Madeira 3-1 Academica 23/-23 2,23 0.84/31 0.25/8 1.40/15 0.31/16   31/-24 2,77 0.77/31 0.63/8 1.19/16 0.33/15
2016-05-07 Academica 0-0 Braga 32/-26 2,81 0.75/32 0.63/8 1.19/16 0.31/16   54/23 2,66 1.78/32 1.63/8 2.31/16 1.25/16
2016-05-14 Tondela 2-0 Academica 32/-22 2,61 0.82/33 1.75/8 0.63/16 1.00/17   32/-26 2,73 0.76/33 0.38/8 1.18/17 0.31/16
2018-10-21 Belenenses 0-1 Academica 33/-2 2,96 1.43/23 1.88/8 0.00/12 3.00/11   32/-28 2,71 0.74/34 0.25/8 1.18/17 0.29/17
2018-10-21 Academica 0-1 Guimaraes 33/-27 2,66 0.80/35 1.50/8 1.18/17 0.44/18   27/-2 2,15 1.38/26 1.88/8 0.00/14 3.00/12
2018-10-21 Guimaraes 1-3 Academica 10/2 2,00 1.67/9 1.88/8 0.00/4 3.00/5   33/-28 2,61 0.78/36 1.50/8 1.11/18 0.44/18
2018-10-21 Sporting 0-1 Academica 42/6 2,36 1.64/33 1.13/8 0.00/15 3.00/18   36/-26 2,65 0.84/37 1.50/8 1.11/18 0.58/19
2018-10-21 Setubal 0-1 Academica 34/3 2,03 1.59/32 1.50/8 0.00/15 3.00/17   37/-25 2,61 0.89/38 1.50/8 1.11/18 0.70/20
2018-10-21 Academica 0-1 Ferreira 38/-24 2,56 0.95/39 1.50/8 1.11/18 0.81/21   41/2 2,29 1.54/35 1.13/8 0.00/17 3.00/18
2018-10-21 Academica 1-3 Setubal 38/-25 2,53 0.93/40 1.50/8 1.05/19 0.81/21   21/-3 3,00 1.20/15 1.50/8 0.00/9 3.00/6
2018-10-21 Academica 1-3 Sporting 39/-27 2,56 0.90/41 1.50/8 1.00/20 0.81/21   21/3 3,25 1.75/12 1.13/8 0.00/5 3.00/7
2018-10-21 Academica 0-1 Belenenses 40/-29 2,60 0.88/42 1.50/8 0.95/21 0.81/21   0/-2 1,00 0.00/2 1.88/8 0.00/2 0.00/0
2018-10-21 Ferreira 1-3 Academica 25/3 3,36 1.71/14 1.13/8 0.00/6 3.00/8   40/-30 2,56 0.86/43 1.50/8 0.91/22 0.81/21