SELECT * FROM 1_Kampe WHERE LigaID = '239' AND (Home='Arsenal Tula' OR Away='Arsenal Tula') 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-07-29 Arsenal Tula 0-0 Dynamo Moscow 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-04 Zenit 1-0 Arsenal Tula 2/2 2,00 3.00/1 3.00/1 0.00/0 3.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2018-08-12 Arsenal Tula 3-1 Akhmat Grozny 0/-1 0,50 0.50/2 0.50/2 1.00/1 0.00/1   1/0 1,00 1.50/2 1.50/2 3.00/1 0.00/1
2018-08-18 CSKA Moscow 3-0 Arsenal Tula 1/-1 0,75 0.75/4 0.75/4 0.00/1 1.00/3   3/1 1,67 1.33/3 1.33/3 2.00/2 0.00/1
2018-08-24 Arsenal Tula 0-1 FK Rostov 3/-2 2,00 1.00/4 1.00/4 2.00/2 0.00/2   6/4 1,60 1.80/5 1.80/5 1.50/4 3.00/1
2018-09-02 Yenisey 0-0 Arsenal Tula 3/-5 1,83 1.17/6 1.17/6 1.75/4 0.00/2   3/-3 1,80 0.80/5 0.80/5 1.33/3 0.00/2
2018-09-15 Arsenal Tula 4-0 Krylya Sovetov 3/-3 1,50 0.83/6 0.83/6 1.33/3 0.33/3   2/-3 1,17 1.17/6 1.17/6 1.00/4 1.50/2
2018-09-15 Arsenal Tula 4-0 FK Krylya Sovetov Samara 7/1 1,86 1.14/7 1.38/8 1.75/4 0.33/3   2/-3 1,17 1.17/6 1.17/6 1.00/4 1.50/2
2018-09-22 Arsenal Tula 2-2 Rubin Kazan 11/5 2,13 1.38/8 1.38/8 2.00/5 0.33/3   7/1 1,86 1.43/7 1.43/7 1.75/4 1.00/3
2018-09-29 Ural 2-1 Arsenal Tula 8/-7 2,88 1.00/8 1.00/8 1.00/5 1.00/3   13/5 2,33 1.33/9 1.38/8 1.83/6 0.33/3
2018-10-05 Arsenal Tula 1-1 Ufa 14/4 2,40 1.20/10 1.38/8 1.83/6 0.25/4   6/-6 2,00 0.89/9 0.88/8 1.17/6 0.33/3
2018-10-21 Spartak Moscow 2-3 Arsenal Tula 10/3 1,70 1.80/10 1.75/8 1.80/5 1.80/5   15/4 2,36 1.18/11 1.13/8 1.71/7 0.25/4
2018-10-27 Arsenal Tula 2-2 Orenburg 18/5 2,58 1.33/12 1.50/8 1.71/7 0.80/5   14/5 1,92 1.50/12 1.13/8 1.00/5 1.86/7
2018-11-03 Lokomotiv Moscow 3-1 Arsenal Tula 17/6 2,15 1.85/13 2.00/8 2.20/5 1.63/8   20/5 2,69 1.31/13 1.63/8 1.63/8 0.80/5
2018-11-09 Arsenal Tula 2-0 FK Anzi Makhackala 21/3 2,79 1.21/14 1.50/8 1.63/8 0.67/6   8/-12 2,00 0.93/14 1.25/8 1.20/5 0.78/9
2018-11-25 Krasnodar 3-0 Arsenal Tula 28/16 2,67 1.93/15 2.00/8 1.67/6 2.11/9   23/5 2,73 1.33/15 1.50/8 1.78/9 0.67/6
2018-12-03 Arsenal Tula 4-2 Zenit 23/2 2,75 1.25/16 1.13/8 1.78/9 0.57/7   25/14 2,25 2.31/16 1.88/8 2.71/7 2.00/9
2018-12-10 Akhmat Grozny 2-0 Arsenal Tula 15/-3 1,94 1.35/17 1.50/8 1.43/7 1.30/10   27/4 2,94 1.35/17 1.38/8 1.90/10 0.57/7
2019-03-02 Arsenal Tula 2-0 CSKA Moscow 27/2 2,89 1.28/18 1.38/8 1.90/10 0.50/8   23/15 1,72 1.72/18 1.75/8 1.63/8 1.80/10
2019-03-10 FK Rostov 0-0 Arsenal Tula 15/1 1,45 1.25/20 0.88/8 1.30/10 1.20/10   29/4 2,84 1.37/19 1.63/8 2.00/11 0.50/8
2019-03-16 Arsenal Tula 2-0 Yenisey 29/4 2,70 1.35/20 1.38/8 2.00/11 0.56/9   13/-24 2,38 0.67/21 0.63/8 1.00/10 0.36/11
2019-03-29 FK Krylya Sovetov Samara 0-1 Arsenal Tula 18/-6 2,21 1.26/19 1.63/8 1.30/10 1.22/9   31/6 2,67 1.43/21 1.63/8 2.08/12 0.56/9
2019-03-29 Krylya Sovetov 0-1 Arsenal Tula 18/-6 2,21 1.26/19 1.63/8 1.30/10 1.22/9   32/7 2,59 1.50/22 2.00/8 2.08/12 0.80/10
2019-04-07 Rubin Kazan 0-0 Arsenal Tula 21/0 1,91 1.45/22 1.25/8 1.83/12 1.00/10   33/8 2,52 1.57/23 2.00/8 2.08/12 1.00/11
2019-04-13 Arsenal Tula 0-0 Ural 33/8 2,42 1.54/24 2.13/8 2.08/12 1.00/12   24/-12 2,61 1.17/23 0.88/8 1.31/13 1.00/10
2019-04-20 Ufa 1-2 Arsenal Tula 18/-9 1,88 0.88/24 0.88/8 1.08/13 0.64/11   33/8 2,32 1.52/25 1.88/8 2.00/13 1.00/12
2019-04-25 Arsenal Tula 3-0 Spartak Moscow 35/9 2,35 1.58/26 2.25/8 2.00/13 1.15/13   34/9 2,36 1.68/25 1.75/8 1.64/14 1.73/11
2019-04-29 Orenburg 1-1 Arsenal Tula 38/8 2,52 1.52/27 1.88/8 1.77/13 1.29/14   38/12 2,37 1.63/27 2.25/8 2.07/14 1.15/13
2019-05-04 Arsenal Tula 2-0 Lokomotiv Moscow 39/12 2,36 1.61/28 2.25/8 2.07/14 1.14/14   41/15 2,39 1.89/28 2.50/8 1.93/14 1.86/14
2019-05-10 FK Anzi Makhackala 0-1 Arsenal Tula 13/-37 2,17 0.69/29 0.25/8 0.71/14 0.67/15   41/14 2,34 1.66/29 2.25/8 2.13/15 1.14/14
2019-05-19 Arsenal Tula 0-3 Krasnodar 42/15 2,30 1.70/30 2.25/8 2.13/15 1.27/15   55/32 2,60 1.87/30 1.88/8 2.00/15 1.73/15
2019-05-26 Dynamo Moscow 3-3 Arsenal Tula 26/0 1,68 1.13/31 1.38/8 1.53/15 0.75/16   42/12 2,32 1.65/31 1.88/8 2.00/16 1.27/15