SELECT * FROM 1_Kampe WHERE LigaID = '247' AND (Home='Shinnik Yaroslavl' OR Away='Shinnik Yaroslavl') 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 T. Moscow 1-3 Shinnik Yaroslavl 5/-2 4,00 1.00/3 2.25/8 0.00/2 3.00/1   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2018-10-21 Shinnik Yaroslavl 1-3 Nizhny Novgorod 3/2 4,00 3.00/1 1.50/8 0.00/0 3.00/1   78/-4 4,00 1.43/40 1.13/8 0.00/21 3.00/19
2018-10-21 Nizhny Novgorod 1-3 Shinnik Yaroslavl 22/-4 4,00 1.25/12 1.13/8 0.00/7 3.00/5   4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1
2018-10-21 M. Saransk 1-3 Shinnik Yaroslavl 62/-4 4,00 1.41/32 1.50/8 0.00/17 3.00/15   7/2 4,00 2.00/3 1.50/8 0.00/1 3.00/2
2018-10-21 Shinnik Yaroslavl 1-3 M. Saransk 10/4 4,00 2.25/4 1.50/8 0.00/1 3.00/3   24/-8 4,00 1.07/14 1.50/8 0.00/9 3.00/5
2018-10-21 Shinnik Yaroslavl 1-3 T. Moscow 11/2 4,00 1.80/5 1.50/8 0.00/2 3.00/3   41/-10 4,00 1.17/23 2.25/8 0.00/14 3.00/9
2018-10-21 Shinnik Yaroslavl 1-3 F. Voronezh 12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3   52/-8 4,00 1.29/28 1.13/8 0.00/16 3.00/12
2018-10-21 F. Voronezh 1-3 Shinnik Yaroslavl 39/-6 4,00 1.29/21 1.13/8 0.00/12 3.00/9   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2019-07-07 SKA Khabarovsk 1-2 Shinnik Yaroslavl 16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4   16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4
2019-07-13 Shinnik Yaroslavl 1-0 Mordovia Saransk 18/1 3,89 1.67/9 1.88/8 0.00/4 3.00/5   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2019-07-13 Shinnik Yaroslavl 1-0 FK Saransk 19/2 3,60 1.80/10 2.63/8 0.60/5 3.00/5   8/-1 3,40 1.20/5 1.20/5 0.00/3 3.00/2
2019-07-19 Pari NN 1-3 Shinnik Yaroslavl 1/-2 2,00 0.50/2 0.50/2 0.00/1 1.00/1   20/3 3,36 1.91/11 2.63/8 1.00/6 3.00/5
2019-07-24 Shinnik Yaroslavl 1-1 Armavir 23/5 3,42 2.00/12 2.63/8 1.00/6 3.00/6   18/-3 3,55 1.36/11 1.13/8 0.50/6 2.40/5
2019-07-28 Luch 2-1 Shinnik Yaroslavl 22/-2 3,83 1.42/12 1.38/8 0.17/6 2.67/6   24/5 3,31 1.92/13 2.38/8 1.00/7 3.00/6
2019-08-03 Shinnik Yaroslavl 1-3 Kursk 25/4 3,29 1.79/14 2.00/8 1.00/7 2.57/7   18/-7 3,31 1.23/13 0.88/8 0.57/7 2.00/6
2019-08-10 Tekstilshtik 1-1 Shinnik Yaroslavl 23/-5 3,64 1.14/14 1.25/8 0.00/6 2.00/8   26/2 3,33 1.67/15 1.63/8 0.88/8 2.57/7
2019-08-14 Shinnik Yaroslavl 0-0 Yenisey 27/2 3,25 1.63/16 1.75/8 0.88/8 2.38/8   20/-8 3,20 1.13/15 0.63/8 0.14/7 2.00/8
2019-08-18 R. Volgograd 2-3 Shinnik Yaroslavl 30/9 3,19 1.94/16 2.38/8 0.67/6 2.70/10   27/2 3,06 1.59/17 1.50/8 0.89/9 2.38/8
2019-08-25 Shinnik Yaroslavl 0-1 Khimki 30/3 3,17 1.67/18 1.50/8 0.89/9 2.44/9   39/17 3,59 1.94/17 2.25/8 1.50/8 2.33/9
2019-08-31 Krasnodar 2 2-2 Shinnik Yaroslavl 23/-6 2,89 1.11/18 1.00/8 0.13/8 1.90/10   30/2 3,05 1.58/19 1.13/8 0.80/10 2.44/9
2019-09-07 Shinnik Yaroslavl 2-1 Tomsk 32/2 3,10 1.55/20 0.88/8 0.80/10 2.30/10   27/6 2,53 1.63/19 1.50/8 1.00/11 2.50/8
2019-09-14 Neftekhimik 2-2 Shinnik Yaroslavl 32/2 2,95 1.48/21 1.00/8 0.56/9 2.17/12   34/3 3,10 1.62/21 1.13/8 1.00/11 2.30/10
2019-09-21 Chertanovo M. 0-1 Shinnik Yaroslavl 33/5 2,77 1.68/22 1.38/8 0.90/10 2.33/12   36/3 3,14 1.59/22 1.25/8 1.00/11 2.18/11
2019-09-29 Shinnik Yaroslavl 3-2 Spartak Moscow 2 37/4 3,04 1.65/23 1.63/8 1.00/11 2.25/12   33/-4 3,04 1.22/23 0.63/8 0.64/11 1.75/12
2019-10-05 Torpedo Moscow 2-0 Shinnik Yaroslavl 66/31 2,81 2.31/36 2.25/8 2.27/22 2.36/14   40/5 3,13 1.71/24 1.88/8 1.17/12 2.25/12
2019-10-05 Torpedo Moscow 2-0 Shinnik Yaroslavl 64/29 2,83 2.29/35 2.25/8 2.24/21 2.36/14   40/3 3,08 1.64/25 1.38/8 1.17/12 2.08/13
2019-10-12 Shinnik Yaroslavl 2-3 FK Chayka 40/1 3,04 1.58/26 1.38/8 1.17/12 1.93/14   30/-2 2,48 1.24/25 1.38/8 0.73/11 1.64/14
2019-10-19 Fakel Voronezh 0-4 Shinnik Yaroslavl 15/-10 2,00 0.90/20 0.88/8 0.92/12 0.88/8   42/0 3,11 1.52/27 1.38/8 1.08/13 1.93/14
2019-10-23 Shinnik Yaroslavl 0-2 Baltika 46/4 3,14 1.57/28 1.63/8 1.08/13 2.00/15   43/11 2,78 1.63/27 2.25/8 1.08/12 2.07/15
2019-10-27 FK Saransk 1-1 Shinnik Yaroslavl 21/-17 2,57 0.83/23 0.50/8 0.58/12 1.09/11   46/2 3,10 1.52/29 1.25/8 1.00/14 2.00/15
2019-10-27 Mordovia Saransk 1-1 Shinnik Yaroslavl 13/-17 2,26 0.68/19 0.50/8 0.70/10 0.67/9   47/2 3,07 1.50/30 1.00/8 1.00/14 1.94/16
2019-11-03 Shinnik Yaroslavl 1-3 Pari NN 48/2 3,03 1.48/31 1.00/8 1.00/14 1.88/17   19/-3 1,95 1.33/21 1.13/8 1.36/11 1.30/10
2019-11-09 Armavir 0-1 Shinnik Yaroslavl 34/-7 2,42 1.10/31 0.88/8 1.06/16 1.13/15   49/0 3,06 1.44/32 0.63/8 0.93/15 1.88/17
2019-11-13 Shinnik Yaroslavl 3-1 Luch 50/1 3,00 1.48/33 1.00/8 0.93/15 1.94/18   40/-13 2,91 1.09/32 0.25/8 0.58/19 1.85/13
2019-11-17 Kursk 2-2 Shinnik Yaroslavl 42/-12 2,91 1.15/33 1.13/8 1.06/17 1.25/16   53/3 3,03 1.53/34 1.38/8 1.06/16 1.94/18
2019-11-23 Shinnik Yaroslavl 3-0 Tekstilshtik 55/3 3,06 1.51/35 1.50/8 1.06/16 1.89/19   41/-27 3,21 0.85/34 0.75/8 0.63/16 1.06/18
2020-03-09 Yenisey 1-3 Shinnik Yaroslavl 39/-17 2,71 1.14/35 1.25/8 1.00/16 1.26/19   58/6 3,06 1.56/36 1.50/8 1.18/17 1.89/19
2020-03-15 Shinnik Yaroslavl 0-1 R. Volgograd 61/8 3,08 1.59/37 1.88/8 1.18/17 1.95/20   57/18 2,67 1.89/36 2.25/8 1.39/18 2.39/18
2020-03-22 Khimki 0-0 Shinnik Yaroslavl 70/34 2,86 1.86/37 1.75/8 2.00/18 1.74/19   61/7 3,03 1.55/38 1.75/8 1.11/18 1.95/20
2020-03-29 Shinnik Yaroslavl 0-0 Krasnodar 2 61/7 2,95 1.51/39 1.63/8 1.11/18 1.86/21   52/0 2,74 1.13/38 1.00/8 0.71/17 1.48/21
2020-04-04 Tomsk 0-0 Shinnik Yaroslavl 51/7 2,44 1.38/39 0.75/8 1.47/19 1.30/20   61/7 2,88 1.48/40 1.63/8 1.05/19 1.86/21
2020-04-08 Shinnik Yaroslavl 0-0 Neftekhimik 61/7 2,80 1.44/41 1.25/8 1.05/19 1.77/22   56/15 2,43 1.65/40 1.13/8 1.20/20 2.10/20
2020-04-12 Shinnik Yaroslavl 0-0 Chertanovo M. 61/7 2,74 1.40/42 0.88/8 1.00/20 1.77/22   60/23 2,31 1.79/42 1.50/8 1.40/20 2.14/22
2020-04-18 Spartak Moscow 2 0-0 Shinnik Yaroslavl 58/-7 2,86 0.95/43 0.25/8 0.81/21 1.09/22   61/7 2,67 1.37/43 0.75/8 0.95/21 1.77/22
2020-04-26 Shinnik Yaroslavl 0-0 Torpedo Moscow 61/7 2,61 1.34/44 0.38/8 0.95/21 1.70/23   90/30 2,21 1.63/68 0.00/8 1.81/36 1.44/32
2020-04-26 Shinnik Yaroslavl 0-0 Torpedo Moscow 61/7 2,56 1.31/45 0.00/8 0.91/22 1.70/23   90/30 2,17 1.61/69 0.00/8 1.81/36 1.39/33
2020-05-02 FK Chayka 0-0 Shinnik Yaroslavl 51/3 2,20 1.20/45 0.13/8 1.14/22 1.26/23   61/7 2,50 1.28/46 0.00/8 0.87/23 1.70/23
2020-05-06 Shinnik Yaroslavl 0-0 Fakel Voronezh 61/7 2,45 1.26/47 0.00/8 0.87/23 1.63/24   21/-29 1,82 0.67/39 0.00/8 0.70/20 0.63/19
2020-05-10 Baltika 0-0 Shinnik Yaroslavl 53/12 2,04 1.26/46 0.00/8 1.00/23 1.52/23   61/7 2,40 1.23/48 0.00/8 0.83/24 1.63/24
2020-05-16 Shinnik Yaroslavl 0-0 SKA Khabarovsk 61/7 2,35 1.20/49 0.00/8 0.83/24 1.56/25   63/11 2,40 1.21/48 0.00/8 1.13/24 1.29/24