SELECT * FROM 1_Kampe WHERE LigaID = '241' 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 Rubin Kazan 26/-3 1,77 1.19/31 0.50/8 1.73/15 0.69/16   31/-2 2,06 1.26/31 1.00/8 1.56/16 0.93/15
2018-10-21 CSKA Moscow 1-3 Amkar 14/4 1,85 1.85/13 1.63/8 2.33/3 1.70/10   9/3 1,15 1.62/13 1.63/8 2.14/7 1.00/6
2018-10-21 Amkar 1-3 FK Rostov 8/2 1,17 1.50/12 1.25/8 2.00/6 1.00/6   15/5 2,08 1.67/12 1.63/8 2.71/7 0.20/5
2018-10-21 Krasnodar 1-3 Amkar 14/6 2,00 1.55/11 1.25/8 2.40/5 0.83/6   8/3 1,18 1.64/11 1.63/8 2.00/6 1.20/5
2018-10-21 Amkar 1-3 Lokomotiv Moscow 8/3 1,30 1.70/10 1.63/8 2.20/5 1.20/5   6/-2 1,40 0.90/10 0.88/8 0.80/5 1.00/5
2018-10-21 Ufa 1-3 Amkar 5/-1 1,22 1.56/9 1.75/8 0.67/3 2.00/6   7/3 1,22 1.78/9 1.88/8 2.20/5 1.25/4
2018-10-21 Amkar 1-3 FK Krylya Sovetov Samara 7/3 1,57 2.00/7 2.00/7 3.00/3 1.25/4   3/-5 1,57 0.29/7 0.29/7 0.33/3 0.25/4
2018-10-21 Akhmat Grozny 1-3 Amkar 8/-2 2,57 1.86/7 1.86/7 2.50/4 1.00/3   4/1 1,17 1.83/6 1.83/6 3.00/3 0.67/3
2018-10-21 Amkar 1-3 Tomsk 3/0 1,20 1.60/5 1.60/5 3.00/2 0.67/3   3/-6 2,40 0.80/5 0.80/5 1.50/2 0.33/3
2018-10-21 Zenit 1-3 Amkar 4/1 1,75 1.50/4 1.50/4 1.67/3 1.00/1   3/3 0,75 2.00/4 2.00/4 3.00/2 1.00/2
2018-10-21 Amkar 1-3 Ural 2/2 0,67 1.67/3 1.67/3 3.00/1 1.00/2   2/1 1,00 1.33/3 1.33/3 1.50/2 1.00/1
2018-10-21 Orenburg 1-3 Amkar 0/-2 1,00 0.00/2 0.00/2 0.00/1 0.00/1   2/2 1,00 2.00/2 2.00/2 3.00/1 1.00/1
2018-10-21 Amkar 1-3 FK Anzi Makhackala 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2018-10-21 Rubin Kazan 1-3 Amkar 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 18/-8 2,10 0.76/21 1.00/8 1.30/10 0.27/11   20/3 1,61 1.43/23 1.13/8 2.27/11 0.67/12
2018-10-21 Spartak Moscow 1-3 Amkar 23/15 2,21 2.43/14 2.25/8 2.63/8 2.17/6   11/3 1,36 1.57/14 1.38/8 2.14/7 1.00/7
2018-10-21 Amkar 1-3 Arsenal Tula 11/2 1,33 1.47/15 1.00/8 2.14/7 0.88/8   6/-16 1,87 0.67/15 0.63/8 0.86/7 0.50/8
2018-10-21 Arsenal Tula 1-3 Amkar 18/-23 1,97 0.93/30 1.13/8 1.71/14 0.25/16   26/-3 1,83 1.20/30 0.50/8 1.73/15 0.67/15
2018-10-21 Amkar 1-3 Spartak Moscow 26/-2 1,86 1.24/29 0.63/8 1.86/14 0.67/15   43/15 2,45 2.28/29 2.38/8 2.80/15 1.71/14
2018-10-21 Amkar 1-3 CSKA Moscow 26/0 1,86 1.29/28 0.63/8 2.00/13 0.67/15   40/23 2,04 2.00/28 2.13/8 2.07/14 1.93/14
2018-10-21 FK Rostov 1-3 Amkar 31/18 1,63 1.59/27 1.50/8 2.43/14 0.69/13   26/1 1,89 1.33/27 1.00/8 2.00/13 0.71/14
2018-10-21 Amkar 1-3 Krasnodar 26/3 1,88 1.38/26 1.00/8 2.17/12 0.71/14   34/14 2,08 1.65/26 1.75/8 2.00/15 1.18/11
2018-10-21 Lokomotiv Moscow 1-3 Amkar 33/17 1,96 1.52/25 2.13/8 1.33/12 1.69/13   23/3 1,72 1.40/25 1.25/8 2.17/12 0.69/13
2018-10-21 Amkar 1-3 Ufa 22/3 1,71 1.42/24 1.13/8 2.27/11 0.69/13   17/0 1,42 1.58/24 1.63/8 1.33/12 1.83/12
2018-10-21 FK Krylya Sovetov Samara 1-3 Amkar 18/-8 2,10 0.76/21 1.00/8 1.30/10 0.27/11   18/3 1,50 1.45/22 1.25/8 2.27/11 0.64/11
2018-10-21 Amkar 1-3 Akhmat Grozny 17/3 1,48 1.48/21 1.25/8 2.40/10 0.64/11   22/-1 2,14 1.52/21 1.00/8 1.77/13 1.13/8
2018-10-21 Tomsk 1-3 Amkar 8/-36 2,60 0.45/20 0.13/8 0.88/8 0.17/12   17/4 1,50 1.55/20 1.63/8 2.40/10 0.70/10
2018-10-21 Amkar 1-3 Zenit 16/3 1,53 1.47/19 1.25/8 2.33/9 0.70/10   36/22 2,63 2.05/19 1.75/8 2.64/11 1.25/8
2018-10-21 Ural 1-3 Amkar 13/-14 2,22 0.83/18 0.75/8 0.88/8 0.80/10   16/4 1,56 1.56/18 1.38/8 2.33/9 0.78/9
2018-10-21 Amkar 1-3 Orenburg 13/1 1,47 1.47/17 1.13/8 2.25/8 0.78/9   12/-6 1,76 0.88/17 1.38/8 1.30/10 0.29/7
2018-10-21 FK Anzi Makhackala 1-3 Amkar 11/-7 1,81 1.06/16 0.63/8 1.00/7 1.11/9   12/3 1,31 1.56/16 1.25/8 2.25/8 0.88/8
2018-10-21 Amkar 1-3 Krylya Sovetov 7/3 1,38 1.88/8 1.88/8 2.50/4 1.25/4   3/-5 1,57 0.29/7 0.29/7 0.33/3 0.25/4