SELECT * FROM 1_Kampe WHERE LigaID = '247' AND (Home='Tekstilshtik' OR Away='Tekstilshtik') 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 Tekstilshtik 1-3 M. Saransk 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   46/-4 4,00 1.38/24 1.50/8 0.00/13 3.00/11
2018-10-21 M. Saransk 1-3 Tekstilshtik 12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3   2/-4 4,00 0.00/2 1.50/8 0.00/2 0.00/0
2018-10-21 Tekstilshtik 1-3 F. Voronezh 1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0   5/-2 4,00 1.00/3 1.13/8 0.00/2 3.00/1
2018-10-21 T. Moscow 1-3 Tekstilshtik 16/-8 4,00 0.90/10 2.25/8 0.00/7 3.00/3   5/-2 4,00 1.00/3 1.50/8 0.00/2 3.00/1
2018-10-21 Tekstilshtik 1-3 Nizhny Novgorod 8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2   42/-4 4,00 1.36/22 1.13/8 0.00/12 3.00/10
2018-10-21 Tekstilshtik 1-3 T. Moscow 9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2   58/-4 4,00 1.40/30 2.25/8 0.00/16 3.00/14
2018-10-21 F. Voronezh 1-3 Tekstilshtik 56/-8 4,00 1.30/30 1.13/8 0.00/17 3.00/13   10/-4 4,00 1.00/6 1.50/8 0.00/4 3.00/2
2018-10-21 Nizhny Novgorod 1-3 Tekstilshtik 56/0 4,00 1.50/28 1.13/8 0.00/14 3.00/14   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2019-07-07 Tekstilshtik 0-1 Yenisey 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 R. Volgograd 3-2 Tekstilshtik 19/3 3,89 1.67/9 1.88/8 0.00/4 3.00/5   16/-1 3,67 1.33/9 1.13/8 0.00/5 3.00/4
2019-07-20 Tekstilshtik 1-4 Khimki 18/-2 3,80 1.20/10 0.75/8 0.00/5 2.40/5   24/6 4,20 1.80/10 1.88/8 0.60/5 3.00/5
2019-07-24 Krasnodar 2 1-1 Tekstilshtik 19/-2 3,64 1.18/11 0.88/8 0.00/5 2.17/6   19/-5 3,91 1.09/11 0.75/8 0.00/6 2.40/5
2019-07-28 Tomsk 2-1 Tekstilshtik 23/6 3,33 1.83/12 1.63/8 1.00/6 2.67/6   20/-5 3,75 1.08/12 0.88/8 0.00/6 2.17/6
2019-08-03 Neftekhimik 1-2 Tekstilshtik 22/3 2,93 1.64/14 1.75/8 0.33/6 2.63/8   21/-6 3,69 1.00/13 0.88/8 0.00/6 1.86/7
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 Spartak Moscow 2 1-2 Tekstilshtik 28/3 3,31 1.50/16 1.50/8 0.67/6 2.00/10   24/-5 3,53 1.13/15 1.00/8 0.14/7 2.00/8
2019-08-18 Torpedo Moscow 3-1 Tekstilshtik 43/15 3,23 2.14/22 3.00/8 1.67/12 2.70/10   26/-4 3,50 1.25/16 1.00/8 0.14/7 2.11/9
2019-08-18 Torpedo Moscow 3-1 Tekstilshtik 40/13 3,19 2.10/21 2.38/8 1.55/11 2.70/10   27/-6 3,53 1.18/17 1.00/8 0.14/7 1.90/10
2019-08-25 FK Chayka 3-0 Tekstilshtik 20/-3 2,39 1.17/18 1.00/8 0.14/7 1.82/11   28/-8 3,56 1.11/18 1.00/8 0.14/7 1.73/11
2019-08-31 Tekstilshtik 1-4 Fakel Voronezh 28/-11 3,53 1.05/19 1.00/8 0.14/7 1.58/12   10/-7 2,08 0.92/13 0.88/8 1.00/9 0.75/4
2019-09-08 Tekstilshtik 1-5 Baltika 29/-14 3,60 1.00/20 0.88/8 0.13/8 1.58/12   28/1 2,75 1.35/20 1.50/8 0.44/9 2.09/11
2019-09-14 Tekstilshtik 3-1 SKA Khabarovsk 30/-18 3,71 0.95/21 0.88/8 0.11/9 1.58/12   33/7 2,81 1.57/21 1.75/8 1.00/13 2.50/8
2019-09-21 FK Saransk 1-0 Tekstilshtik 19/-7 2,65 0.94/17 0.63/8 0.44/9 1.50/8   33/-17 3,61 1.00/23 0.38/8 0.40/10 1.46/13
2019-09-21 Mordovia Saransk 1-0 Tekstilshtik 11/-7 2,23 0.77/13 0.63/8 0.57/7 1.00/6   33/-16 3,73 1.05/22 0.88/8 0.40/10 1.58/12
2019-09-29 Tekstilshtik 0-2 Pari NN 33/-18 3,50 0.96/24 0.38/8 0.40/10 1.36/14   12/-2 1,73 1.40/15 1.63/8 1.50/8 1.29/7
2019-10-05 Armavir 2-0 Tekstilshtik 29/-7 2,60 1.12/25 0.63/8 0.92/13 1.33/12   33/-20 3,44 0.92/25 0.38/8 0.36/11 1.36/14
2019-10-12 Tekstilshtik 4-3 Luch 33/-22 3,38 0.88/26 0.38/8 0.36/11 1.27/15   36/-3 2,88 1.31/26 1.25/8 0.63/16 2.40/10
2019-10-19 Kursk 2-1 Tekstilshtik 35/-10 2,96 1.11/27 1.00/8 0.86/14 1.38/13   37/-21 3,52 0.96/27 0.75/8 0.58/12 1.27/15
2019-10-23 Chertanovo M. 1-0 Tekstilshtik 39/8 2,50 1.79/28 1.88/8 0.83/12 2.50/16   38/-22 3,50 0.93/28 0.75/8 0.58/12 1.19/16
2019-10-27 Tekstilshtik 0-1 R. Volgograd 38/-23 3,41 0.90/29 0.75/8 0.58/12 1.12/17   48/12 2,90 1.83/29 2.38/8 1.23/13 2.31/16
2019-11-03 Khimki 2-1 Tekstilshtik 58/31 2,83 1.93/30 2.00/8 1.93/14 1.94/16   38/-24 3,33 0.87/30 0.38/8 0.54/13 1.12/17
2019-11-09 Tekstilshtik 1-0 Krasnodar 2 39/-25 3,32 0.84/31 0.38/8 0.54/13 1.06/18   44/-1 2,87 1.23/31 1.63/8 0.62/13 1.67/18
2019-11-13 Tekstilshtik 0-2 Tomsk 40/-24 3,25 0.91/32 0.75/8 0.71/14 1.06/18   47/12 2,56 1.50/32 1.63/8 1.47/17 1.53/15
2019-11-17 Tekstilshtik 1-2 Neftekhimik 40/-26 3,21 0.88/33 0.75/8 0.67/15 1.06/18   50/13 2,64 1.76/33 2.13/8 1.25/16 2.24/17
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 Tekstilshtik 1-1 Spartak Moscow 2 41/-30 3,20 0.83/35 0.38/8 0.63/16 1.00/19   57/-6 3,33 1.11/36 1.38/8 0.89/19 1.35/17
2020-03-15 Tekstilshtik 0-0 Torpedo Moscow 42/-30 3,17 0.83/36 0.50/8 0.65/17 1.00/19   90/30 2,73 2.00/55 0.50/8 2.03/32 1.96/23
2020-03-15 Tekstilshtik 0-0 Torpedo Moscow 42/-30 3,08 0.84/37 0.75/8 0.67/18 1.00/19   90/30 2,78 2.02/54 0.50/8 2.03/32 2.00/22
2020-03-22 Tekstilshtik 0-0 FK Chayka 42/-30 3,00 0.84/38 0.75/8 0.68/19 1.00/19   51/3 2,61 1.42/38 2.13/8 1.32/19 1.53/19
2020-03-29 Fakel Voronezh 0-0 Tekstilshtik 21/-29 2,22 0.81/32 0.63/8 0.88/16 0.75/16   42/-30 2,92 0.82/39 0.75/8 0.65/20 1.00/19
2020-04-04 Baltika 0-0 Tekstilshtik 53/12 2,41 1.49/39 0.88/8 1.21/19 1.75/20   42/-30 2,85 0.80/40 0.38/8 0.65/20 0.95/20
2020-04-08 SKA Khabarovsk 0-0 Tekstilshtik 63/11 2,80 1.41/41 1.13/8 1.35/20 1.48/21   42/-30 2,78 0.78/41 0.38/8 0.65/20 0.90/21
2020-04-12 Tekstilshtik 0-0 FK Saransk 42/-30 2,71 0.76/42 0.38/8 0.65/20 0.86/22   29/-23 2,31 0.71/35 0.50/8 0.56/18 0.88/17
2020-04-12 Tekstilshtik - Mordovia Saransk / /0 / / /   / /0 / / /
2020-04-18 Pari NN 0-0 Tekstilshtik 29/0 1,76 1.18/33 0.50/8 1.06/16 1.29/17   42/-30 2,65 0.74/43 0.38/8 0.62/21 0.86/22
2020-04-26 Tekstilshtik 0-0 Armavir 42/-30 2,59 0.73/44 0.25/8 0.62/21 0.83/23   40/-7 2,02 1.00/43 0.38/8 1.05/22 0.95/21
2020-05-02 Luch 0-0 Tekstilshtik 48/-10 2,36 1.00/45 0.00/8 0.50/22 1.48/23   42/-30 2,53 0.71/45 0.13/8 0.59/22 0.83/23
2020-05-06 Tekstilshtik 0-0 Kursk 42/-30 2,48 0.70/46 0.00/8 0.59/22 0.79/24   50/-12 2,43 0.93/46 0.00/8 0.88/24 1.00/22
2020-05-10 Tekstilshtik 0-0 Chertanovo M. 42/-30 2,43 0.68/47 0.00/8 0.57/23 0.79/24   60/23 2,06 1.60/47 0.00/8 1.22/23 1.96/24
2020-05-16 Yenisey 0-0 Tekstilshtik 41/-18 2,08 0.90/48 0.00/8 0.79/24 1.00/24   42/-30 2,38 0.67/48 0.00/8 0.54/24 0.79/24