SELECT * FROM 1_Kampe WHERE LigaID = '274' AND (Home='Mersin' OR Away='Mersin') 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-10-21 Eskisehirspor 1-3 Mersin 40/-1 2,45 1.42/33 1.13/8 1.56/16 1.29/17   34/-9 2,33 1.27/33 1.50/8 1.06/17 1.50/16
2018-10-21 Kardemir Karabuk 1-3 Mersin 15/-6 2,40 0.80/15 0.63/8 1.57/7 0.13/8   15/2 1,87 1.53/15 1.63/8 1.38/8 1.71/7
2018-10-21 Mersin 1-3 Samsunspor 14/1 1,93 1.43/14 1.25/8 1.14/7 1.71/7   9/-8 1,86 0.79/14 0.75/8 1.29/7 0.29/7
2018-10-21 Basaksehir 1-3 Mersin 19/5 2,54 1.62/13 1.38/8 2.00/6 1.29/7   14/1 2,08 1.46/13 1.13/8 1.14/7 1.83/6
2018-10-21 Mersin 1-3 Manisaspor 14/1 2,25 1.50/12 1.13/8 1.17/6 1.83/6   13/5 1,75 1.83/12 2.50/8 2.17/6 1.50/6
2018-10-21 Orduspor 1-3 Mersin 10/3 1,55 1.55/11 1.63/8 1.80/5 1.33/6   13/0 2,36 1.36/11 1.13/8 1.17/6 1.60/5
2018-10-21 Mersin 1-3 Trabzonspor 12/0 2,40 1.40/10 1.38/8 1.20/5 1.60/5   16/6 2,60 1.90/10 2.25/8 2.00/5 1.80/5
2018-10-21 Galatasaray 1-3 Mersin 15/6 2,67 1.89/9 2.13/8 2.25/4 1.60/5   12/0 2,67 1.44/9 1.25/8 1.20/5 1.75/4
2018-10-21 Mersin 1-3 Genclerbirligi 10/-1 2,63 1.25/8 1.25/8 0.75/4 1.75/4   9/-3 2,63 1.38/8 1.38/8 2.50/4 0.25/4
2018-10-21 Sivasspor 1-3 Mersin 10/-5 3,57 1.14/7 1.14/7 1.33/3 1.00/4   10/0 2,86 1.43/7 1.43/7 0.75/4 2.33/3
2018-10-21 Mersin 1-3 Besiktas 10/1 3,17 1.67/6 1.67/6 1.00/3 2.33/3   7/1 2,17 1.67/6 1.67/6 2.00/3 1.33/3
2018-10-21 Mersin 1-3 Fenerbahce 9/2 3,20 2.00/5 2.00/5 1.50/2 2.33/3   10/6 2,80 2.60/5 2.60/5 2.33/3 3.00/2
2018-10-21 Kayserispor 1-3 Mersin 2/-4 2,00 0.75/4 0.75/4 0.00/2 1.50/2   7/2 3,00 2.25/4 2.25/4 1.50/2 3.00/2
2018-10-21 Mersin 1-3 Gaziantepspor 5/0 3,33 2.00/3 2.00/3 0.00/1 3.00/2   2/-4 2,67 0.00/3 0.00/3 0.00/2 0.00/1
2018-10-21 Antalyaspor 1-3 Mersin 2/2 1,00 3.00/2 3.00/2 3.00/1 3.00/1   3/-1 3,50 1.50/2 1.50/2 0.00/1 3.00/1
2018-10-21 Mersin 1-3 Bursaspor 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   3/3 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-10-21 Mersin 1-3 Eskisehirspor 20/4 2,25 1.63/16 2.00/8 1.38/8 1.88/8   19/4 2,13 1.81/16 2.63/8 2.00/8 1.63/8
2018-10-21 Mersin 1-3 Ankaragucu 20/4 2,12 1.59/17 1.75/8 1.33/9 1.88/8   15/-19 2,88 0.41/17 0.75/8 0.63/8 0.22/9
2018-10-21 Mersin 1-3 Kardemir Karabuk 34/-7 2,34 1.31/32 1.50/8 1.13/16 1.50/16   41/-14 3,00 1.25/32 2.00/8 2.19/16 0.31/16
2018-10-21 Samsunspor 1-3 Mersin 32/-13 2,48 0.97/31 1.63/8 1.33/15 0.63/16   34/-5 2,35 1.35/31 1.88/8 1.13/16 1.60/15
2018-10-21 Mersin 1-3 Basaksehir 32/-7 2,37 1.30/30 1.50/8 1.00/15 1.60/15   44/-1 2,97 1.43/30 1.63/8 2.00/15 0.87/15
2018-10-21 Manisaspor 1-3 Mersin 27/-11 2,24 1.00/29 0.50/8 1.07/14 0.93/15   32/-5 2,38 1.34/29 1.50/8 1.00/15 1.71/14
2018-10-21 Mersin 1-3 Orduspor 31/-6 2,43 1.29/28 1.13/8 0.86/14 1.71/14   26/-3 1,96 1.36/28 2.00/8 1.79/14 0.93/14
2018-10-21 Trabzonspor 1-3 Mersin 51/19 3,07 1.70/27 2.00/8 2.00/14 1.38/13   28/-7 2,33 1.22/27 0.75/8 0.86/14 1.62/13
2018-10-21 Mersin 1-3 Galatasaray 27/-5 2,27 1.27/26 0.75/8 0.92/13 1.62/13   48/30 2,54 2.19/26 2.13/8 2.46/13 1.92/13
2018-10-21 Genclerbirligi 1-3 Mersin 38/8 2,72 1.72/25 1.88/8 2.15/13 1.25/12   25/-6 2,24 1.20/25 0.38/8 0.92/13 1.50/12
2018-10-21 Mersin 1-3 Sivasspor 24/-2 2,08 1.25/24 0.50/8 1.00/12 1.50/12   39/4 3,08 1.58/24 2.13/8 2.00/13 1.09/11
2018-10-21 Besiktas 1-3 Mersin 35/13 2,48 1.96/23 2.13/8 2.25/12 1.64/11   23/-3 2,13 1.17/23 0.50/8 1.00/12 1.36/11
2018-10-21 Fenerbahce 1-3 Mersin 36/16 2,55 2.05/22 2.13/8 2.60/10 1.58/12   22/-2 2,09 1.23/22 0.88/8 1.00/12 1.50/10
2018-10-21 Mersin 1-3 Kayserispor 21/-1 2,05 1.29/21 1.00/8 1.09/11 1.50/10   22/-3 2,24 1.24/21 1.25/8 1.55/11 0.90/10
2018-10-21 Gaziantepspor 1-3 Mersin 17/-5 1,95 1.00/20 1.25/8 1.20/10 0.80/10   21/0 2,10 1.35/20 1.13/8 1.09/11 1.67/9
2018-10-21 Mersin 1-3 Antalyaspor 21/2 2,11 1.42/19 1.50/8 1.20/10 1.67/9   14/-3 1,63 1.26/19 1.38/8 1.90/10 0.56/9
2018-10-21 Bursaspor 1-3 Mersin 20/2 2,11 1.22/18 1.13/8 1.33/9 1.11/9   21/3 2,17 1.50/18 1.63/8 1.20/10 1.88/8
2018-10-21 Ankaragucu 1-3 Mersin 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