SELECT * FROM 1_Kampe WHERE LigaID = '158' AND (Home='Mafra' OR Away='Mafra') 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-12 Varzim 0-1 Mafra 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 Mafra 2-0 Vitoria Guimaraes B 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-08-26 Benfica B 1-0 Mafra 4/2 3,00 3.00/2 3.00/2 3.00/1 3.00/1   3/3 1,50 3.00/2 3.00/2 3.00/1 3.00/1
2018-09-01 Mafra 1-1 Oliveirense 3/2 1,33 2.00/3 2.00/3 3.00/1 1.50/2   3/-2 2,67 0.67/3 0.67/3 1.00/2 0.00/1
2018-09-23 Estoril 1-4 Mafra 10/8 3,00 2.25/4 2.25/4 1.50/2 3.00/2   4/2 1,50 1.75/4 1.75/4 2.00/2 1.50/2
2018-10-06 Mafra 1-1 Famalicao 8/5 2,20 2.00/5 2.00/5 2.00/2 2.00/3   10/5 3,00 2.40/5 2.40/5 3.00/2 2.00/3
2018-10-21 Mafra 1-3 Ferreira 9/5 2,17 1.83/6 1.83/6 1.67/3 2.00/3   1/-2 4,00 0.00/1 1.88/8 0.00/1 0.00/0
2018-10-21 Mafra 1-3 Guimaraes B 10/3 2,43 1.57/7 1.38/8 1.25/4 2.00/3   27/-6 4,00 1.20/15 1.50/8 0.00/9 3.00/6
2018-10-21 Ferreira 1-3 Mafra 38/-4 4,00 1.35/20 1.88/8 0.00/11 3.00/9   11/1 2,63 1.38/8 1.38/8 1.00/5 2.00/3
2018-10-21 Guimaraes B 1-3 Mafra 66/4 4,00 1.59/32 1.50/8 0.00/15 3.00/17   14/3 2,78 1.56/9 1.38/8 1.00/5 2.25/4
2018-10-28 Arouca 2-2 Mafra 14/-4 3,20 1.20/10 1.13/8 0.00/4 2.00/6   17/5 2,90 1.70/10 1.38/8 1.00/5 2.40/5
2018-11-03 Mafra 1-0 Penafiel 19/5 3,00 1.64/11 1.50/8 1.00/5 2.17/6   16/3 2,64 1.55/11 1.75/8 1.17/6 2.00/5
2018-11-10 Academico Viseu 1-0 Mafra 19/0 3,17 1.42/12 1.25/8 1.17/6 1.67/6   20/6 2,83 1.75/12 1.75/8 1.33/6 2.17/6
2018-11-18 SC Farense 1-0 Mafra 17/0 2,62 1.38/13 1.38/8 1.14/7 1.67/6   20/5 2,69 1.62/13 1.38/8 1.33/6 1.86/7
2018-12-01 Mafra 2-1 FC Porto B 20/4 2,57 1.50/14 1.25/8 1.33/6 1.63/8   17/-10 3,14 1.00/14 1.25/8 1.00/6 1.00/8
2018-12-09 Braga B 6-1 Mafra 15/-4 2,43 1.14/14 1.13/8 0.86/7 1.43/7   22/5 2,60 1.60/15 1.63/8 1.57/7 1.63/8
2018-12-15 Mafra 1-0 Leixoes 23/0 2,88 1.50/16 1.25/8 1.57/7 1.44/9   18/0 2,40 1.40/15 1.00/8 1.14/7 1.63/8
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-29 CD Cova da Piedade 0-3 Mafra 18/-4 2,35 1.35/17 1.38/8 1.00/8 1.67/9   26/0 2,89 1.50/18 1.25/8 1.56/9 1.44/9
2019-01-06 Mafra 1-1 Pacos Ferreira 29/3 2,89 1.58/19 1.50/8 1.56/9 1.60/10   20/15 1,79 2.36/14 2.25/8 2.25/8 2.50/6
2019-01-13 Mafra 1-2 Covilha 30/3 2,85 1.55/20 1.25/8 1.50/10 1.60/10   22/-10 2,70 0.95/20 0.63/8 1.00/10 0.90/10
2019-01-20 Mafra 2-0 Varzim 31/2 2,86 1.48/21 1.25/8 1.36/11 1.60/10   25/-3 2,52 1.33/21 1.38/8 1.00/11 1.70/10
2019-01-28 Vitoria Guimaraes B 1-2 Mafra 23/-4 2,50 1.15/20 1.25/8 0.90/10 1.40/10   33/4 2,82 1.55/22 1.63/8 1.50/12 1.60/10
2019-02-02 Mafra 1-1 Benfica B 35/5 2,83 1.61/23 1.63/8 1.50/12 1.73/11   36/11 2,65 1.74/23 1.38/8 2.18/11 1.33/12
2019-02-10 Oliveirense 3-2 Mafra 30/-6 2,75 1.17/24 1.25/8 1.25/12 1.08/12   36/5 2,79 1.58/24 1.75/8 1.46/13 1.73/11
2019-02-17 Mafra 1-1 Estoril 38/4 2,88 1.52/25 1.38/8 1.46/13 1.58/12   40/10 2,80 1.68/25 1.25/8 1.54/13 1.83/12
2019-02-23 Famalicao 2-1 Mafra 38/12 2,46 1.92/26 1.75/8 1.85/13 2.00/13   39/4 2,85 1.50/26 1.50/8 1.43/14 1.58/12
2019-03-02 Mafra 1-1 Arouca 40/3 2,85 1.44/27 1.13/8 1.43/14 1.46/13   36/-1 2,70 1.33/27 2.13/8 1.36/14 1.31/13
2019-03-10 Penafiel 3-2 Mafra 37/0 2,64 1.32/28 0.63/8 1.54/13 1.13/15   41/3 2,82 1.43/28 1.13/8 1.40/15 1.46/13
2019-03-16 Mafra 2-2 Academico Viseu 43/2 2,90 1.38/29 1.13/8 1.40/15 1.36/14   39/-11 3,07 1.14/29 1.00/8 1.27/15 1.00/14
2019-03-30 FC Porto B 3-0 Mafra 40/2 2,60 1.47/30 1.38/8 1.80/15 1.13/15   45/2 2,93 1.37/30 0.88/8 1.38/16 1.36/14
2019-04-06 Mafra 1-1 Braga B 45/-1 2,94 1.32/31 0.50/8 1.38/16 1.27/15   36/-9 2,61 1.13/31 1.25/8 1.19/16 1.07/15
2019-04-14 Leixoes 1-0 Mafra 37/-3 2,41 1.28/32 1.00/8 1.63/16 0.94/16   46/-1 2,91 1.31/32 0.50/8 1.35/17 1.27/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 Mafra 1-0 CD Cova da Piedade 46/-2 2,76 1.26/34 0.50/8 1.35/17 1.18/17   31/-16 2,29 1.29/34 2.13/8 1.18/17 1.41/17
2019-05-05 Pacos Ferreira 2-0 Mafra 45/25 2,10 2.16/31 1.88/8 2.27/15 2.06/16   47/-1 2,71 1.31/35 0.88/8 1.44/18 1.18/17
2019-05-12 Mafra 0-1 SC Farense 47/-3 2,69 1.28/36 0.75/8 1.44/18 1.11/18   45/2 2,44 1.19/36 1.38/8 1.50/18 0.89/18
2019-05-19 Covilha 1-1 Mafra 49/5 2,51 1.46/37 1.75/8 1.61/18 1.32/19   47/-4 2,65 1.24/37 0.75/8 1.37/19 1.11/18