SELECT * FROM 1_Kampe WHERE LigaID = '158' 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
2018-08-11 Oliveirense 1-1 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
2018-08-18 Academica 0-1 Pacos Ferreira 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   2/2 2,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-08-26 Vitoria Guimaraes B 0-0 Academica 0/-3 1,50 0.00/2 0.00/2 0.00/1 0.00/1   1/-1 1,50 0.50/2 0.50/2 0.00/1 1.00/1
2018-09-01 Academica 1-1 Benfica B 1/-1 1,00 0.67/3 0.67/3 0.00/1 1.00/2   5/3 2,33 3.00/3 3.00/3 3.00/2 3.00/1
2018-09-23 SC Farense 0-2 Academica 5/2 2,00 1.75/4 1.75/4 2.00/2 1.50/2   2/-1 1,25 0.75/4 0.75/4 0.50/2 1.00/2
2018-10-07 Academica 2-7 Estoril 4/1 1,40 1.20/5 1.20/5 0.50/2 1.67/3   11/5 3,40 1.80/5 1.80/5 1.00/3 3.00/2
2018-10-21 Guimaraes B 1-3 Academica 26/-4 4,00 1.29/14 1.50/8 0.00/8 3.00/6   6/-4 2,67 1.00/6 1.00/6 0.33/3 1.67/3
2018-10-21 Academica 1-3 Ferreira 9/-2 2,86 1.29/7 1.38/8 0.33/3 2.00/4   26/-4 4,00 1.29/14 1.88/8 0.00/8 3.00/6
2018-10-21 Ferreira 1-3 Academica 65/-2 4,00 1.45/33 1.88/8 0.00/17 3.00/16   10/-4 3,00 1.13/8 1.38/8 0.25/4 2.00/4
2018-10-21 Academica 1-3 Guimaraes B 13/-2 3,11 1.33/9 1.38/8 0.25/4 2.20/5   63/2 4,00 1.55/31 1.50/8 0.00/15 3.00/16
2018-10-29 Penafiel 2-1 Academica 14/2 2,60 1.40/10 1.75/8 0.80/5 2.00/5   14/-4 3,20 1.20/10 1.38/8 0.20/5 2.20/5
2018-11-04 Academica 0-1 Academico Viseu 15/-5 3,18 1.09/11 1.25/8 0.20/5 1.83/6   18/-1 3,36 1.27/11 0.88/8 1.17/6 1.40/5
2018-11-11 Braga B 0-1 Academica 14/-2 2,50 1.33/12 1.88/8 1.00/6 1.67/6   15/-6 3,00 1.00/12 1.13/8 0.17/6 1.83/6
2018-11-18 Covilha 0-1 Academica 18/-5 3,15 1.08/13 1.25/8 0.83/6 1.29/7   16/-5 2,85 1.15/13 1.13/8 0.17/6 2.00/7
2018-12-01 Academica 2-0 Arouca 17/-4 2,71 1.29/14 1.50/8 0.17/6 2.13/8   18/-3 3,00 1.23/13 1.63/8 0.67/6 1.71/7
2018-12-08 FC Porto B 3-0 Academica 18/-11 3,13 0.93/15 0.88/8 1.00/6 0.89/9   19/-2 2,67 1.40/15 1.88/8 0.57/7 2.13/8
2018-12-17 Academica 0-1 Famalicao 19/-5 2,69 1.31/16 1.50/8 0.57/7 1.89/9   28/8 3,00 2.00/16 2.00/8 2.14/7 1.89/9
2018-12-23 Mafra 2-3 Academica 24/1 2,76 1.59/17 1.25/8 1.75/8 1.44/9   19/-6 2,59 1.24/17 1.50/8 0.50/8 1.89/9
2018-12-30 Academica 2-1 Leixoes 22/-5 2,72 1.33/18 1.50/8 0.50/8 2.00/10   19/-2 2,35 1.24/17 1.00/8 1.00/8 1.44/9
2019-01-04 Academica 3-0 CD Cova da Piedade 24/-4 2,74 1.42/19 1.88/8 0.78/9 2.00/10   18/-7 2,39 1.28/18 1.38/8 0.89/9 1.67/9
2019-01-13 Academica 2-0 Varzim 27/-1 2,75 1.50/20 2.25/8 1.00/10 2.00/10   25/-1 2,55 1.40/20 1.50/8 1.00/11 1.89/9
2019-01-20 Academica 1-0 Oliveirense 29/1 2,71 1.57/21 2.25/8 1.18/11 2.00/10   24/-8 2,67 1.05/21 0.63/8 1.09/11 1.00/10
2019-01-28 Pacos Ferreira 2-0 Academica 26/17 1,94 2.22/18 2.00/8 2.33/9 2.11/9   30/2 2,64 1.64/22 2.25/8 1.33/12 2.00/10
2019-02-02 Academica 1-1 Vitoria Guimaraes B 30/0 2,61 1.57/23 1.88/8 1.33/12 1.82/11   24/-5 2,52 1.10/21 1.25/8 0.82/11 1.40/10
2019-02-09 Benfica B 0-1 Academica 37/11 2,63 1.71/24 1.13/8 2.18/11 1.31/13   31/0 2,58 1.54/24 2.00/8 1.31/13 1.82/11
2019-02-17 Academica 1-0 SC Farense 32/1 2,52 1.60/25 2.38/8 1.31/13 1.92/12   32/3 2,44 1.28/25 1.25/8 1.33/12 1.23/13
2019-02-24 Estoril 1-0 Academica 41/10 2,77 1.65/26 1.00/8 1.54/13 1.77/13   33/2 2,46 1.65/26 2.38/8 1.43/14 1.92/12
2019-03-02 Academica 2-1 Penafiel 33/1 2,41 1.59/27 2.00/8 1.43/14 1.77/13   36/1 2,63 1.37/27 1.00/8 1.54/13 1.21/14
2019-03-10 Academico Viseu 1-2 Academica 38/-10 3,07 1.18/28 1.00/8 1.36/14 1.00/14   35/2 2,43 1.64/28 2.00/8 1.53/15 1.77/13
2019-03-16 Academica 1-0 Braga B 37/3 2,45 1.69/29 2.00/8 1.53/15 1.86/14   35/-8 2,69 1.17/29 1.50/8 1.20/15 1.14/14
2019-03-31 Arouca 2-1 Academica 37/-3 2,57 1.23/30 1.63/8 1.27/15 1.20/15   38/4 2,40 1.73/30 2.00/8 1.63/16 1.86/14
2019-04-06 Academica 4-1 FC Porto B 39/3 2,42 1.68/31 2.00/8 1.63/16 1.73/15   43/5 2,61 1.52/31 1.63/8 1.88/16 1.13/15
2019-04-13 Famalicao 2-0 Academica 48/13 2,59 1.88/32 1.63/8 1.88/16 1.88/16   43/6 2,50 1.72/32 2.25/8 1.71/17 1.73/15
2019-04-20 Academica 0-0 Mafra 43/4 2,48 1.67/33 1.88/8 1.71/17 1.63/16   46/-2 2,85 1.27/33 0.50/8 1.35/17 1.19/16
2019-04-27 Leixoes 1-1 Academica 39/-2 2,35 1.32/34 1.00/8 1.71/17 0.94/17   43/4 2,41 1.65/34 1.63/8 1.67/18 1.63/16
2019-05-04 CD Cova da Piedade 2-0 Academica 31/-17 2,26 1.26/35 1.75/8 1.18/17 1.33/18   44/4 2,40 1.63/35 1.75/8 1.67/18 1.59/17
2019-05-12 Academica 0-2 Covilha 44/2 2,39 1.58/36 1.38/8 1.67/18 1.50/18   47/3 2,53 1.42/36 1.75/8 1.61/18 1.22/18
2019-05-19 Varzim 1-0 Academica 32/-13 2,08 1.19/37 1.38/8 1.22/18 1.16/19   44/0 2,38 1.54/37 1.00/8 1.58/19 1.50/18