SELECT * FROM 1_Kampe WHERE LigaID = '49' AND (Home='Mainz' OR Away='Mainz') 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
2013-08-11 Mainz 3-2 Stuttgart 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
2013-08-17 Freiburg 1-2 Mainz 1/-2 4,00 0.00/1 0.00/1 0.00/0 0.00/1   3/1 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2013-08-24 Mainz 2-0 Wolfsburg 5/2 4,00 3.00/2 3.00/2 3.00/1 3.00/1   4/2 3,00 1.50/2 1.50/2 3.00/1 0.00/1
2013-08-31 Hannover 4-1 Mainz 4/0 2,67 2.00/3 2.00/3 3.00/2 0.00/1   7/4 3,33 3.00/3 3.00/3 3.00/2 3.00/1
2013-09-14 Mainz 0-1 Schalke 8/1 3,75 2.25/4 2.25/4 3.00/2 1.50/2   6/-3 3,75 1.00/4 1.00/4 2.00/2 0.00/2
2013-09-21 Mainz 1-4 Bayer Leverkusen 8/0 3,20 1.80/5 1.80/5 2.00/3 1.50/2   11/5 3,40 2.40/5 2.40/5 3.00/3 1.50/2
2013-09-28 Hertha Berlin 3-1 Mainz 10/3 2,83 1.33/6 1.33/6 2.00/3 0.67/3   9/-3 3,50 1.50/6 1.50/6 1.50/4 1.50/2
2013-10-05 Mainz 2-2 Hoffenheim 10/-5 3,57 1.29/7 1.29/7 1.50/4 1.00/3   18/0 5,14 1.29/7 1.29/7 1.50/4 1.00/3
2013-10-19 Bayern Munich 4-1 Mainz 15/12 2,25 2.50/8 2.50/8 3.00/4 2.00/4   12/-5 3,63 1.25/8 1.25/8 1.40/5 1.00/3
2013-10-26 Mainz 2-0 Braunschweig 13/-8 3,78 1.11/9 0.88/8 1.40/5 0.75/4   7/-14 3,11 0.44/9 0.50/8 0.20/5 0.75/4
2013-11-03 Augsburg 2-1 Mainz 11/-8 3,00 1.00/10 1.25/8 1.40/5 0.60/5   15/-6 3,60 1.30/10 0.88/8 1.67/6 0.75/4
2013-11-10 Mainz 1-0 Eintracht Frankfurt 16/-7 3,55 1.18/11 0.50/8 1.67/6 0.60/5   14/-6 3,09 0.91/11 0.88/8 0.40/5 1.33/6
2013-11-24 Werder Bremen 2-3 Mainz 13/-7 2,75 1.25/12 1.13/8 1.60/5 1.00/7   17/-6 3,33 1.33/12 0.88/8 1.86/7 0.60/5
2013-11-30 Mainz 1-3 Dortmund 20/-5 3,46 1.46/13 1.25/8 1.86/7 1.00/6   32/18 3,54 2.15/13 1.63/8 2.57/7 1.67/6
2013-12-06 Nurnberg 1-1 Mainz 13/-16 3,00 0.57/14 0.50/8 0.50/6 0.63/8   21/-7 3,50 1.36/14 1.25/8 1.63/8 1.00/6
2013-12-14 Mainz 0-0 B. Monchengladbach 22/-7 3,40 1.33/15 1.38/8 1.63/8 1.00/7   33/16 3,33 2.07/15 2.63/8 3.00/8 1.00/7
2013-12-21 Hamburger SV 2-3 Mainz 31/-4 4,13 1.00/16 1.00/8 1.00/7 1.00/9   22/-7 3,19 1.31/16 1.38/8 1.56/9 1.00/7
2014-01-25 Stuttgart 1-2 Mainz 29/-2 3,75 1.19/16 1.00/8 1.29/7 1.11/9   25/-6 3,29 1.41/17 1.75/8 1.56/9 1.25/8
2014-02-01 Mainz 2-0 Freiburg 27/-5 3,28 1.50/18 1.75/8 1.56/9 1.44/9   19/-14 2,89 0.94/18 1.50/8 1.00/9 0.89/9
2014-02-08 Wolfsburg 3-0 Mainz 30/6 2,84 1.58/19 1.50/8 2.11/9 1.10/10   29/-3 3,21 1.58/19 2.13/8 1.70/10 1.44/9
2014-02-14 Mainz 2-0 Hannover 29/-6 3,20 1.50/20 1.75/8 1.70/10 1.30/10   29/-6 3,20 1.20/20 1.25/8 2.10/10 0.30/10
2014-02-21 Schalke 0-0 Mainz 41/11 3,38 1.90/21 2.38/8 2.20/10 1.64/11   31/-4 3,14 1.57/21 1.75/8 1.82/11 1.30/10
2014-03-01 Bayer Leverkusen 0-1 Mainz 39/14 2,91 1.95/22 1.13/8 2.27/11 1.64/11   31/-4 3,00 1.55/22 1.88/8 1.82/11 1.27/11
2014-03-09 Mainz 1-1 Hertha Berlin 32/-3 2,91 1.61/23 2.13/8 1.82/11 1.42/12   34/7 2,65 1.52/23 1.63/8 1.42/12 1.64/11
2014-03-15 Hoffenheim 2-4 Mainz 52/0 4,33 1.21/24 1.38/8 1.42/12 1.00/12   33/-3 2,88 1.58/24 2.13/8 1.75/12 1.42/12
2014-03-22 Mainz 0-2 Bayern Munich 37/-1 3,00 1.64/25 2.13/8 1.75/12 1.54/13   74/62 3,44 2.84/25 3.00/8 3.00/13 2.67/12
2014-03-25 Braunschweig 3-1 Mainz 21/-27 2,65 0.69/26 0.75/8 0.92/13 0.46/13   37/-3 2,96 1.58/26 1.75/8 1.62/13 1.54/13
2014-03-29 Mainz 3-0 Augsburg 38/-5 3,00 1.52/27 1.38/8 1.62/13 1.43/14   40/0 2,96 1.44/27 1.38/8 1.54/13 1.36/14
2014-04-05 Eintracht Frankfurt 2-0 Mainz 35/-13 2,96 1.14/28 1.38/8 1.21/14 1.07/14   41/-2 3,00 1.57/28 1.75/8 1.71/14 1.43/14
2014-04-12 Mainz 3-0 Werder Bremen 41/-4 2,97 1.52/29 1.38/8 1.71/14 1.33/15   34/-21 3,07 1.14/29 1.50/8 1.20/15 1.07/14
2014-04-19 Dortmund 4-2 Mainz 67/35 3,30 2.03/30 2.38/8 1.93/15 2.13/15   44/-1 2,97 1.57/30 1.63/8 1.80/15 1.33/15
2014-04-26 Mainz 2-0 Nurnberg 46/-3 3,06 1.52/31 1.25/8 1.80/15 1.25/16   36/-26 3,16 0.84/31 0.38/8 0.88/16 0.80/15
2014-05-03 B. Monchengladbach 3-1 Mainz 55/16 2,94 1.63/32 2.00/8 2.06/16 1.19/16   48/-1 3,03 1.56/32 1.50/8 1.88/16 1.25/16
2014-05-10 Mainz 3-2 Hamburger SV 49/-3 3,06 1.52/33 1.13/8 1.88/16 1.18/17   49/-23 3,67 0.82/33 0.50/8 1.06/17 0.56/16