SELECT * FROM 1_Kampe WHERE LigaID = '247' AND (Home='Luch' OR Away='Luch') 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 F. Voronezh 1-3 Luch 60/-8 4,00 1.31/32 1.13/8 0.00/18 3.00/14   9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2
2018-10-21 Luch 1-3 F. Voronezh 3/2 4,00 3.00/1 1.50/8 0.00/0 3.00/1   1/-2 4,00 0.00/1 1.13/8 0.00/1 0.00/0
2018-10-21 T. Moscow 1-3 Luch 64/0 4,00 1.50/32 2.25/8 0.00/16 3.00/16   5/-2 4,00 1.00/3 1.50/8 0.00/2 3.00/1
2018-10-21 M. Saransk 1-3 Luch 8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2018-10-21 Luch 1-3 T. Moscow 4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1   18/-12 4,00 0.75/12 2.25/8 0.00/9 3.00/3
2018-10-21 Luch 1-3 M. Saransk 12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3   42/-4 4,00 1.36/22 1.50/8 0.00/12 3.00/10
2018-10-21 Nizhny Novgorod 1-3 Luch 52/0 4,00 1.50/26 1.13/8 0.00/13 3.00/13   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2018-10-21 Luch 1-3 Nizhny Novgorod 8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2   14/-4 4,00 1.13/8 1.13/8 0.00/5 3.00/3
2019-07-07 Luch 2-5 Khimki 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 Krasnodar 2 1-2 Luch 17/-1 3,89 1.33/9 1.13/8 0.00/4 2.40/5   18/-3 4,33 1.33/9 1.50/8 0.00/5 3.00/4
2019-07-20 Luch 1-1 Tomsk 20/-2 4,20 1.50/10 1.50/8 0.00/5 3.00/5   20/4 3,60 1.80/10 1.88/8 0.60/5 3.00/5
2019-07-24 Neftekhimik 1-1 Luch 21/4 3,17 1.83/12 1.63/8 0.20/5 3.00/7   21/-2 4,00 1.45/11 1.63/8 0.17/6 3.00/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 Luch 2-4 Spartak Moscow 2 24/-1 3,77 1.54/13 1.75/8 0.57/7 2.67/6   22/1 3,07 1.43/14 1.38/8 0.67/6 2.00/8
2019-08-10 Luch 0-1 Torpedo Moscow 26/-4 3,73 1.33/15 1.00/8 0.44/9 2.67/6   32/7 3,35 1.88/17 2.13/8 1.22/9 2.63/8
2019-08-10 Luch 0-1 Torpedo Moscow 26/-3 3,93 1.43/14 1.75/8 0.50/8 2.67/6   33/8 3,22 1.94/18 2.13/8 1.22/9 2.67/9
2019-08-14 Luch 1-1 FK Chayka 26/-5 3,56 1.25/16 1.00/8 0.40/10 2.67/6   18/-3 2,44 1.19/16 0.88/8 0.14/7 2.00/9
2019-08-18 Luch 3-0 Fakel Voronezh 27/-5 3,47 1.24/17 1.13/8 0.45/11 2.67/6   10/-4 2,18 1.00/11 1.00/8 1.00/8 1.00/3
2019-08-25 Baltika 0-0 Luch 28/1 3,06 1.39/18 1.63/8 0.38/8 2.20/10   30/-2 3,44 1.33/18 1.13/8 0.67/12 2.67/6
2019-08-31 Luch 0-2 SKA Khabarovsk 30/-2 3,26 1.32/19 1.13/8 0.67/12 2.43/7   30/4 2,95 1.42/19 1.75/8 0.83/12 2.43/7
2019-09-07 Mordovia Saransk 1-2 Luch 8/-6 2,00 0.82/11 0.75/8 0.67/6 1.00/5   32/-3 3,19 1.33/21 1.38/8 0.62/13 2.50/8
2019-09-07 FK Saransk 1-2 Luch 16/-6 2,53 1.00/15 0.75/8 0.50/8 1.57/7   30/-4 3,20 1.25/20 1.00/8 0.62/13 2.43/7
2019-09-14 Luch 0-0 Pari NN 34/-2 3,18 1.41/22 1.38/8 0.62/13 2.56/9   11/-2 1,85 1.46/13 1.88/8 1.57/7 1.33/6
2019-09-21 Armavir 0-0 Luch 28/-6 2,70 1.17/23 1.25/8 0.92/12 1.45/11   34/-2 3,04 1.39/23 1.50/8 0.64/14 2.56/9
2019-09-29 Luch 0-1 Chertanovo M. 34/-2 2,92 1.38/24 1.63/8 0.64/14 2.40/10   33/4 2,70 1.61/23 1.25/8 0.82/11 2.33/12
2019-10-05 Luch 2-2 Kursk 34/-3 2,84 1.32/25 1.50/8 0.60/15 2.40/10   33/-9 3,00 1.16/25 1.13/8 0.92/13 1.42/12
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 Luch 0-1 Yenisey 39/-4 3,04 1.26/27 1.13/8 0.63/16 2.18/11   32/-14 2,89 1.11/27 1.50/8 0.75/12 1.40/15
2019-10-23 R. Volgograd 2-0 Luch 46/10 2,93 1.79/28 2.00/8 1.08/12 2.31/16   39/-5 2,96 1.21/28 1.13/8 0.59/17 2.18/11
2019-10-27 Luch 1-1 Krasnodar 2 39/-7 2,93 1.17/29 0.75/8 0.59/17 2.00/12   42/-2 2,97 1.17/29 1.25/8 0.42/12 1.71/17
2019-11-03 Tomsk 4-0 Luch 41/9 2,43 1.50/30 1.63/8 1.38/16 1.64/14   40/-7 2,90 1.17/30 0.50/8 0.61/18 2.00/12
2019-11-09 Luch 0-2 Neftekhimik 40/-11 2,94 1.13/31 0.38/8 0.61/18 1.85/13   47/11 2,68 1.74/31 2.38/8 1.27/15 2.19/16
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 Spartak Moscow 2 0-2 Luch 56/-4 3,41 1.15/34 1.25/8 0.94/17 1.35/17   41/-15 2,94 1.06/33 0.25/8 0.58/19 1.71/14
2019-11-23 Torpedo Moscow 0-2 Luch 86/32 2,75 2.10/51 1.00/8 2.10/31 2.10/20   43/-13 2,91 1.12/34 0.50/8 0.58/19 1.80/15
2019-11-23 Torpedo Moscow 0-2 Luch 86/34 2,76 2.14/50 1.50/8 2.17/30 2.10/20   45/-11 2,89 1.17/35 1.25/8 0.58/19 1.88/16
2020-03-09 FK Chayka 1-1 Luch 49/3 2,64 1.44/36 1.88/8 1.35/17 1.53/19   47/-9 2,86 1.22/36 1.25/8 0.58/19 1.94/17
2020-03-15 Fakel Voronezh 1-0 Luch 20/-30 2,33 0.77/30 0.63/8 0.73/15 0.80/15   48/-9 2,84 1.22/37 1.38/8 0.58/19 1.89/18
2020-03-22 Luch 0-0 Baltika 48/-10 2,79 1.18/38 1.25/8 0.58/19 1.79/19   53/12 2,54 1.57/37 1.25/8 1.28/18 1.84/19
2020-03-29 SKA Khabarovsk 0-0 Luch 63/11 2,95 1.49/39 1.88/8 1.42/19 1.55/20   48/-10 2,72 1.15/39 1.25/8 0.55/20 1.79/19
2020-04-04 Luch - Mordovia Saransk / /0 / / /   / /0 / / /
2020-04-04 Luch 0-0 FK Saransk 48/-10 2,65 1.13/40 1.25/8 0.55/20 1.70/20   29/-23 2,45 0.76/33 0.63/8 0.59/17 0.94/16
2020-04-08 Pari NN 0-0 Luch 29/0 1,87 1.26/31 0.88/8 1.13/15 1.38/16   48/-10 2,59 1.10/41 1.25/8 0.52/21 1.70/20
2020-04-12 Luch 0-0 Armavir 48/-10 2,52 1.07/42 0.88/8 0.52/21 1.62/21   40/-7 2,12 1.05/41 0.75/8 1.10/21 1.00/20
2020-04-18 Chertanovo M. 0-0 Luch 60/23 2,26 1.74/43 1.13/8 1.40/20 2.04/23   48/-10 2,47 1.05/43 0.50/8 0.50/22 1.62/21
2020-04-26 Kursk 0-0 Luch 50/-12 2,55 0.98/44 0.25/8 0.91/23 1.05/21   48/-10 2,41 1.02/44 0.13/8 0.50/22 1.55/22
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 Yenisey 0-0 Luch 41/-18 2,17 0.93/46 0.00/8 0.83/23 1.04/23   48/-10 2,30 0.98/46 0.00/8 0.48/23 1.48/23
2020-05-10 Luch 0-0 R. Volgograd 48/-10 2,26 0.96/47 0.00/8 0.48/23 1.42/24   58/19 2,06 1.51/47 0.00/8 1.09/23 1.92/24
2020-05-16 Khimki 0-0 Luch 70/34 2,21 1.44/48 0.00/8 1.50/24 1.38/24   48/-10 2,21 0.94/48 0.00/8 0.46/24 1.42/24