SELECT * FROM 1_Kampe WHERE LigaID = '244' AND (Home='Amkar' OR Away='Amkar') 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 Amkar 1-3 Krasnodar 36/-1 2,35 1.26/31 0.38/8 1.67/15 0.88/16   45/6 2,71 1.61/31 1.88/8 1.69/16 1.53/15
2018-10-21 Lokomotiv Moscow 1-3 Amkar 26/13 3,00 1.92/13 1.88/8 2.00/5 1.88/8   15/7 1,77 1.62/13 1.88/8 2.00/6 1.29/7
2018-10-21 Volga N. Novgorod 1-3 Amkar 10/-8 2,55 1.18/11 1.13/8 1.50/6 0.80/5   13/5 1,75 1.50/12 1.63/8 2.00/6 1.00/6
2018-10-21 FK Anzi Makhackala 1-3 Amkar 10/-7 2,45 0.55/11 0.50/8 0.33/3 0.63/8   11/5 1,55 1.55/11 1.63/8 2.00/6 1.00/5
2018-10-21 Amkar 1-3 FK Rostov 10/4 1,60 1.40/10 1.25/8 1.80/5 1.00/5   13/-1 3,00 1.56/9 1.38/8 2.00/5 1.00/4
2018-10-21 Kuban 1-3 Amkar 9/0 2,00 1.22/9 1.25/8 1.67/3 1.00/6   7/1 1,44 1.22/9 1.00/8 1.80/5 0.50/4
2018-10-21 Amkar 1-3 Rubin Kazan 7/1 1,63 1.25/8 1.25/8 2.00/4 0.50/4   8/4 1,50 1.50/8 1.50/8 1.50/4 1.50/4
2018-10-21 CSKA Moscow 1-3 Amkar 11/5 2,43 2.43/7 2.43/7 3.00/3 2.00/4   6/2 1,43 1.43/7 1.43/7 2.00/4 0.67/3
2018-10-21 Amkar 1-3 Spartak Moscow 4/1 1,17 1.17/6 1.17/6 1.67/3 0.67/3   12/7 2,83 2.33/6 2.33/6 1.00/1 2.60/5
2018-10-21 Ural 1-3 Amkar 5/-2 3,00 1.00/4 1.00/4 0.33/3 3.00/1   4/1 1,40 1.20/5 1.20/5 1.67/3 0.50/2
2018-10-21 Amkar 1-3 FK Krylya Sovetov Samara 4/1 1,75 1.25/4 1.20/5 2.00/2 0.50/2   3/-2 2,67 0.33/3 0.33/3 0.50/2 0.00/1
2018-10-21 Krasnodar 1-3 Amkar 3/-1 3,50 0.50/2 0.50/2 0.00/1 1.00/1   3/2 2,00 2.00/2 2.00/2 3.00/1 1.00/1
2018-10-21 Akhmat Grozny 1-3 Amkar 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   2/2 2,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-10-21 Amkar 1-3 Tomsk 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-10-21 Krylya Sovetov 1-3 Amkar 24/-12 2,31 0.96/26 0.50/8 0.92/13 1.00/13   33/2 2,29 1.36/28 0.63/8 1.79/14 0.93/14
2018-10-21 Amkar 1-3 Dynamo Moscow 15/3 1,93 1.50/14 1.75/8 2.00/6 1.13/8   25/8 3,00 1.86/14 2.13/8 1.80/10 2.00/4
2018-10-21 Zenit 1-3 Amkar 38/26 3,33 2.53/15 3.00/8 2.67/6 2.44/9   17/4 2,00 1.60/15 1.75/8 2.14/7 1.13/8
2018-10-21 Spartak Moscow 1-3 Amkar 45/10 2,67 1.67/30 0.88/8 1.93/14 1.44/16   36/0 2,40 1.30/30 0.50/8 1.67/15 0.93/15
2018-10-21 Amkar 1-3 CSKA Moscow 35/2 2,34 1.34/29 0.63/8 1.79/14 0.93/15   48/21 2,59 2.10/29 3.00/8 2.64/14 1.60/15
2018-10-21 FK Krylya Sovetov Samara 1-3 Amkar 24/-12 2,31 0.96/26 0.50/8 0.92/13 1.00/13   31/2 2,22 1.37/27 0.75/8 1.79/14 0.92/13
2018-10-21 Amkar 1-3 Ural 31/4 2,23 1.42/26 0.75/8 1.92/13 0.92/13   24/-21 2,56 0.96/27 1.50/8 0.71/14 1.23/13
2018-10-21 Tomsk 1-3 Amkar 16/-19 2,04 0.80/25 1.00/8 0.82/11 0.79/14   31/4 2,32 1.44/25 1.00/8 1.92/13 0.92/12
2018-10-21 Amkar 1-3 Akhmat Grozny 31/5 2,38 1.50/24 1.38/8 2.08/12 0.92/12   17/-10 1,91 0.83/23 1.25/8 1.31/13 0.20/10
2018-10-21 Amkar 1-3 Zenit 30/6 2,35 1.57/23 1.50/8 2.27/11 0.92/12   48/24 3,00 2.08/24 1.38/8 2.25/12 1.92/12
2018-10-21 FK Rostov 1-3 Amkar 28/2 2,35 1.35/23 1.88/8 1.17/12 1.55/11   27/6 2,18 1.59/22 1.75/8 2.27/11 0.91/11
2018-10-21 Amkar 1-3 Lokomotiv Moscow 27/6 2,29 1.62/21 1.63/8 2.40/10 0.91/11   43/23 2,86 2.14/22 2.38/8 2.30/10 2.00/12
2018-10-21 Amkar 1-3 Volga N. Novgorod 22/2 2,10 1.55/20 1.63/8 2.33/9 0.91/11   20/-21 2,90 0.90/21 0.38/8 1.09/11 0.70/10
2018-10-21 Dynamo Moscow 1-3 Amkar 34/12 2,80 1.90/20 2.25/8 2.00/12 1.75/8   22/4 2,11 1.63/19 1.75/8 2.33/9 1.00/10
2018-10-21 Rubin Kazan 1-3 Amkar 19/4 1,89 1.17/18 1.00/8 1.11/9 1.22/9   22/7 2,06 1.72/18 2.13/8 2.33/9 1.11/9
2018-10-21 Amkar 1-3 Kuban 19/5 1,94 1.65/17 2.13/8 2.25/8 1.11/9   23/3 2,53 1.41/17 1.63/8 1.88/8 1.00/9
2018-10-21 Amkar 1-3 FK Anzi Makhackala 18/4 2,00 1.56/16 1.88/8 2.14/7 1.11/9   13/-15 2,56 0.44/16 0.38/8 0.33/6 0.50/10
2018-10-21 Amkar 1-3 Krylya Sovetov 4/1 2,33 1.33/3 1.33/3 3.00/1 0.50/2   3/-2 2,67 0.33/3 0.33/3 0.50/2 0.00/1