Jornada 1
22 Jul 21 Chertanovo ReservasChertanovo 3 - 2 Arsenal Tula ReservasArsenal ...
23 Jul 21 Rostov ReservasRostov 3 - 1 Sochi ReservasSochi ...
23 Jul 21 Ural ReservasUral 2 - 1 Spartak Moskva ReservasSpartak ...
23 Jul 21 Nizhny Novgorod ReservasNizhny 2 - 1 Rubin Kazan ReservasRubin Kazan ...
23 Jul 21 FK Khimki ReservasKhimki 2 - 2 Master-Saturn ReservasMaster-Satu ...
23 Jul 21 Ufa ReservasReservas 1 - 1 Strogino ReservasStrogino ...
23 Jul 21 Dinamo Moskva ReservasDinamo 1 - 4 CSKA Moskva ReservasCSKA Moskva ...
23 Jul 21 Krylya Sovetov ReservasKrylya 3 - 1 Yuri Konoplev ReservasYuri ...
23 Jul 21 Akhmat ReservasAkhmat 1 - 2 Zenit ReservasZenit ...
23 Jul 21 Lokomotiv Moskva ReservasLokomotiv 3 - 0 Krasnodar ReservasKrasnodar ...
Jornada 2
07 Jul 21 Ufa ReservasReservas 1 - 0 Spartak Moskva ReservasSpartak ...
27 Jul 21 Yuri Konoplev ReservasYuri 3 - 1 Dinamo Moskva ReservasDinamo ...
27 Jul 21 Rubin Kazan ReservasRubin Kazan 4 - 0 Ural ReservasUral ...
27 Jul 21 Krylya Sovetov ReservasKrylya 0 - 2 Nizhny Novgorod ReservasNizhny 4
27 Jul 21 Master-Saturn ReservasMaster-Satu 1 - 1 Arsenal Tula ReservasArsenal ...
27 Jul 21 CSKA Moskva ReservasCSKA Moskva 2 - 1 Strogino ReservasStrogino ...
27 Jul 21 Akhmat ReservasAkhmat 1 - 2 Sochi ReservasSochi ...
27 Jul 21 Lokomotiv Moskva ReservasLokomotiv 2 - 2 Chertanovo ReservasChertanovo ...
27 Jul 21 Zenit ReservasZenit 6 - 0 FK Khimki ReservasKhimki 1
27 Jul 21 Krasnodar ReservasKrasnodar 1 - 2 Rostov ReservasRostov ...
Jornada 3
30 Jul 21 Nizhny Novgorod ReservasNizhny 0 - 1 Ural ReservasUral ...
30 Jul 21 Strogino ReservasStrogino 1 - 2 Yuri Konoplev ReservasYuri ...
30 Jul 21 Arsenal Tula ReservasArsenal 1 - 2 Lokomotiv Moskva ReservasLokomotiv ...
30 Jul 21 Chertanovo ReservasChertanovo 3 - 1 FK Khimki ReservasKhimki ...
30 Jul 21 Rubin Kazan ReservasRubin Kazan 3 - 2 CSKA Moskva ReservasCSKA Moskva ...
30 Jul 21 Dinamo Moskva ReservasDinamo 3 - 0 Ufa ReservasReservas ...
30 Jul 21 Spartak Moskva ReservasSpartak 3 - 1 Krylya Sovetov ReservasKrylya ...
30 Jul 21 Sochi ReservasSochi 1 - 0 Master-Saturn ReservasMaster-Satu ...
30 Jul 21 Rostov ReservasRostov 2 - 1 Zenit ReservasZenit ...
30 Jul 21 Krasnodar ReservasKrasnodar 1 - 1 Akhmat ReservasAkhmat ...
Jornada 4
06 Ago 21 CSKA Moskva ReservasCSKA Moskva 3 - 0 Ufa ReservasReservas ...
06 Ago 21 Spartak Moskva ReservasSpartak 1 - 0 Strogino ReservasStrogino ...
06 Ago 21 Ural ReservasUral 1 - 1 Krylya Sovetov ReservasKrylya ...
06 Ago 21 Yuri Konoplev ReservasYuri 2 - 2 Rubin Kazan ReservasRubin Kazan ...
06 Ago 21 Nizhny Novgorod ReservasNizhny 1 - 3 Dinamo Moskva ReservasDinamo ...
06 Ago 21 Lokomotiv Moskva ReservasLokomotiv 0 - 1 Sochi ReservasSochi ...
06 Ago 21 Arsenal Tula ReservasArsenal 2 - 3 Zenit ReservasZenit ...
06 Ago 21 FK Khimki ReservasKhimki 0 - 2 Rostov ReservasRostov ...
06 Ago 21 Chertanovo ReservasChertanovo 2 - 0 Krasnodar ReservasKrasnodar ...
06 Ago 21 Master-Saturn ReservasMaster-Satu 2 - 2 Akhmat ReservasAkhmat ...
Jornada 5
13 Ago 21 CSKA Moskva ReservasCSKA Moskva 3 - 0 Ural ReservasUral ...
13 Ago 21 Strogino ReservasStrogino 2 - 1 Dinamo Moskva ReservasDinamo ...
13 Ago 21 Ufa ReservasReservas 1 - 2 Nizhny Novgorod ReservasNizhny ...
13 Ago 21 Yuri Konoplev ReservasYuri 1 - 1 Spartak Moskva ReservasSpartak ...
13 Ago 21 Krylya Sovetov ReservasKrylya 4 - 2 Rubin Kazan ReservasRubin Kazan ...
13 Ago 21 Zenit ReservasZenit 3 - 0 Lokomotiv Moskva ReservasLokomotiv ...
13 Ago 21 Akhmat ReservasAkhmat 1 - 2 Chertanovo ReservasChertanovo ...
13 Ago 21 Sochi ReservasSochi 2 - 3 Krasnodar ReservasKrasnodar ...
13 Ago 21 Master-Saturn ReservasMaster-Satu 0 - 7 Rostov ReservasRostov ...
13 Ago 21 FK Khimki ReservasKhimki 2 - 1 Arsenal Tula ReservasArsenal ...
Jornada 6
20 Ago 21 Rubin Kazan ReservasRubin Kazan 1 - 1 Strogino ReservasStrogino ...
22 Ago 21 Dinamo Moskva ReservasDinamo 1 - 2 Spartak Moskva ReservasSpartak ...
22 Ago 21 Ural ReservasUral 0 - 3 Yuri Konoplev ReservasYuri ...
20 Ago 21 Krylya Sovetov ReservasKrylya 1 - 0 Ufa ReservasReservas ...
20 Ago 21 Nizhny Novgorod ReservasNizhny 0 - 3 CSKA Moskva ReservasCSKA Moskva ...
20 Ago 21 Krasnodar ReservasKrasnodar 3 - 1 Zenit ReservasZenit ...
20 Ago 21 FK Khimki ReservasKhimki 4 - 4 Lokomotiv Moskva ReservasLokomotiv ...
20 Ago 21 Rostov ReservasRostov 5 - 0 Akhmat ReservasAkhmat ...
20 Ago 21 Arsenal Tula ReservasArsenal 4 - 5 Sochi ReservasSochi ...
20 Ago 21 Chertanovo ReservasChertanovo 2 - 0 Master-Saturn ReservasMaster-Satu ...
Jornada 7
27 Ago 21 CSKA Moskva ReservasCSKA Moskva 2 - 0 Yuri Konoplev ReservasYuri ...
27 Ago 21 Spartak Moskva ReservasSpartak 3 - 0 Nizhny Novgorod ReservasNizhny ...
27 Ago 21 Strogino ReservasStrogino 1 - 0 Ural ReservasUral ...
27 Ago 21 Dinamo Moskva ReservasDinamo 2 - 2 Krylya Sovetov ReservasKrylya ...
27 Ago 21 Ufa ReservasReservas 2 - 1 Rubin Kazan ReservasRubin Kazan ...
27 Ago 21 Zenit ReservasZenit 1 - 0 Sochi ReservasSochi ...
27 Ago 21 Arsenal Tula ReservasArsenal 1 - 3 Krasnodar ReservasKrasnodar ...
27 Ago 21 Master-Saturn ReservasMaster-Satu 0 - 2 Lokomotiv Moskva ReservasLokomotiv ...
27 Ago 21 FK Khimki ReservasKhimki 1 - 4 Akhmat ReservasAkhmat ...
27 Ago 21 Chertanovo ReservasChertanovo 0 - 3 Rostov ReservasRostov ...
Jornada 8
08 Sep 21 Zenit ReservasZenit 0 - 1 Chertanovo ReservasChertanovo ...
10 Sep 21 CSKA Moskva ReservasCSKA Moskva 3 - 0 Spartak Moskva ReservasSpartak ...
10 Sep 21 Rubin Kazan ReservasRubin Kazan 1 - 0 Dinamo Moskva ReservasDinamo ...
10 Sep 21 Strogino ReservasStrogino 0 - 1 Krylya Sovetov ReservasKrylya ...
10 Sep 21 Ufa ReservasReservas 0 - 3 Ural ReservasUral ...
10 Sep 21 Yuri Konoplev ReservasYuri 0 - 4 Nizhny Novgorod ReservasNizhny ...
10 Sep 21 Krasnodar ReservasKrasnodar 3 - 0 Master-Saturn ReservasMaster-Satu ...
10 Sep 21 Akhmat ReservasAkhmat 0 - 0 Arsenal Tula ReservasArsenal ...
10 Sep 21 Rostov ReservasRostov 0 - 1 Lokomotiv Moskva ReservasLokomotiv ...
10 Sep 21 Sochi ReservasSochi 2 - 1 FK Khimki ReservasKhimki ...
Jornada 9
17 Sep 21 Spartak Moskva ReservasSpartak 2 - 2 Rubin Kazan ReservasRubin Kazan ...
17 Sep 21 Ural ReservasUral 1 - 2 Dinamo Moskva ReservasDinamo ...
17 Sep 21 Yuri Konoplev ReservasYuri 0 - 1 Ufa ReservasReservas ...
17 Sep 21 Krylya Sovetov ReservasKrylya 1 - 0 CSKA Moskva ReservasCSKA Moskva ...
17 Sep 21 Nizhny Novgorod ReservasNizhny 3 - 1 Strogino ReservasStrogino ...
17 Sep 21 Lokomotiv Moskva ReservasLokomotiv 1 - 0 Akhmat ReservasAkhmat ...
17 Sep 21 Sochi ReservasSochi 2 - 1 Chertanovo ReservasChertanovo ...
17 Sep 21 Arsenal Tula ReservasArsenal 1 - 2 Rostov ReservasRostov ...
17 Sep 21 FK Khimki ReservasKhimki 0 - 3 Krasnodar ReservasKrasnodar ...
20 Sep 21 Master-Saturn ReservasMaster-Satu 1 - 6 Zenit ReservasZenit ...
Jornada 10
24 Sep 21 Rubin Kazan ReservasRubin Kazan 5 - 1 Yuri Konoplev ReservasYuri ...
24 Sep 21 Strogino ReservasStrogino 1 - 2 Spartak Moskva ReservasSpartak ...
24 Sep 21 Dinamo Moskva ReservasDinamo 5 - 3 Nizhny Novgorod ReservasNizhny ...
24 Sep 21 Ufa ReservasReservas 0 - 3 CSKA Moskva ReservasCSKA Moskva 1
24 Sep 21 Krylya Sovetov ReservasKrylya 1 - 0 Ural ReservasUral ...
24 Sep 21 Zenit ReservasZenit 4 - 1 Akhmat ReservasAkhmat ...
24 Sep 21 Krasnodar ReservasKrasnodar 1 - 1 Sochi ReservasSochi ...
24 Sep 21 Rostov ReservasRostov 3 - 1 Master-Saturn ReservasMaster-Satu ...
24 Sep 21 Arsenal Tula ReservasArsenal 4 - 3 FK Khimki ReservasKhimki ...
24 Sep 21 Chertanovo ReservasChertanovo 1 - 2 Lokomotiv Moskva ReservasLokomotiv ...
Jornada 11
01 Oct 21 CSKA Moskva ReservasCSKA Moskva 0 - 1 Nizhny Novgorod ReservasNizhny ...
01 Oct 21 Spartak Moskva ReservasSpartak 2 - 3 Dinamo Moskva ReservasDinamo ...
30 Sep 21 Rubin Kazan ReservasRubin Kazan 0 - 1 Krylya Sovetov ReservasKrylya ...
01 Oct 21 Strogino ReservasStrogino 4 - 1 Ufa ReservasReservas ...
01 Oct 21 Yuri Konoplev ReservasYuri 1 - 0 Ural ReservasUral ...
01 Oct 21 Akhmat ReservasAkhmat 1 - 0 Krasnodar ReservasKrasnodar ...
01 Oct 21 Sochi ReservasSochi 1 - 3 Rostov ReservasRostov ...
01 Oct 21 Master-Saturn ReservasMaster-Satu 0 - 2 Chertanovo ReservasChertanovo ...
01 Oct 21 Lokomotiv Moskva ReservasLokomotiv 4 - 0 FK Khimki ReservasKhimki ...
03 Oct 21 Zenit ReservasZenit 1 - 2 Arsenal Tula ReservasArsenal ...
Jornada 12
15 Oct 21 Dinamo Moskva ReservasDinamo 1 - 0 Strogino ReservasStrogino ...
15 Oct 21 Ufa ReservasReservas 0 - 1 Krylya Sovetov ReservasKrylya ...
15 Oct 21 Ural ReservasUral 3 - 4 Rubin Kazan ReservasRubin Kazan ...
15 Oct 21 Yuri Konoplev ReservasYuri 0 - 1 CSKA Moskva ReservasCSKA Moskva ...
15 Oct 21 Nizhny Novgorod ReservasNizhny 1 - 3 Spartak Moskva ReservasSpartak ...
15 Oct 21 Rostov ReservasRostov 1 - 0 Krasnodar ReservasKrasnodar ...
15 Oct 21 Lokomotiv Moskva ReservasLokomotiv 3 - 0 Zenit ReservasZenit ...
15 Oct 21 Sochi ReservasSochi 2 - 1 Akhmat ReservasAkhmat ...
15 Oct 21 Arsenal Tula ReservasArsenal 1 - 0 Chertanovo ReservasChertanovo ...
15 Oct 21 Master-Saturn ReservasMaster-Satu 1 - 1 FK Khimki ReservasKhimki ...
Jornada 13
22 Oct 21 CSKA Moskva ReservasCSKA Moskva 1 - 3 Dinamo Moskva ReservasDinamo ...
22 Oct 21 Spartak Moskva ReservasSpartak 4 - 1 Yuri Konoplev ReservasYuri ...
22 Oct 21 Rubin Kazan ReservasRubin Kazan 6 - 0 Ufa ReservasReservas ...
22 Oct 21 Ural ReservasUral 2 - 1 Nizhny Novgorod ReservasNizhny ...
22 Oct 21 Krylya Sovetov ReservasKrylya 2 - 1 Strogino ReservasStrogino ...
22 Oct 21 Krasnodar ReservasKrasnodar 2 - 3 Lokomotiv Moskva ReservasLokomotiv ...
22 Oct 21 Akhmat ReservasAkhmat 3 - 3 Rostov ReservasRostov ...
22 Oct 21 Arsenal Tula ReservasArsenal 1 - 2 Master-Saturn ReservasMaster-Satu ...
22 Oct 21 FK Khimki ReservasKhimki 3 - 1 Sochi ReservasSochi ...
23 Oct 21 Chertanovo ReservasChertanovo 2 - 1 Zenit ReservasZenit ...
Jornada 14
29 Oct 21 Spartak Moskva ReservasSpartak 4 - 1 Ural ReservasUral ...
29 Oct 21 Strogino ReservasStrogino 1 - 1 CSKA Moskva ReservasCSKA Moskva ...
29 Oct 21 Dinamo Moskva ReservasDinamo 5 - 2 Rubin Kazan ReservasRubin Kazan ...
29 Oct 21 Yuri Konoplev ReservasYuri 2 - 2 Krylya Sovetov ReservasKrylya ...
29 Oct 21 Nizhny Novgorod ReservasNizhny 0 - 0 Ufa ReservasReservas ...
29 Oct 21 Zenit ReservasZenit 2 - 1 Krasnodar ReservasKrasnodar ...
29 Oct 21 Akhmat ReservasAkhmat 1 - 1 Master-Saturn ReservasMaster-Satu ...
29 Oct 21 Rostov ReservasRostov 4 - 0 Arsenal Tula ReservasArsenal ...
29 Oct 21 Sochi ReservasSochi 0 - 2 Lokomotiv Moskva ReservasLokomotiv ...
29 Oct 21 FK Khimki ReservasKhimki 3 - 3 Chertanovo ReservasChertanovo ...
Jornada 15
05 Nov 21 CSKA Moskva ReservasCSKA Moskva 4 - 1 Krylya Sovetov ReservasKrylya ...
05 Nov 21 Rubin Kazan ReservasRubin Kazan 0 - 0 Spartak Moskva ReservasSpartak ...
05 Nov 21 Strogino ReservasStrogino 4 - 0 Nizhny Novgorod ReservasNizhny ...
05 Nov 21 Dinamo Moskva ReservasDinamo 3 - 1 Ural ReservasUral ...
05 Nov 21 Ufa ReservasReservas 1 - 1 Yuri Konoplev ReservasYuri ...
05 Nov 21 Krasnodar ReservasKrasnodar 2 - 1 FK Khimki ReservasKhimki ...
05 Nov 21 Lokomotiv Moskva ReservasLokomotiv 1 - 1 Arsenal Tula ReservasArsenal ...
05 Nov 21 Master-Saturn ReservasMaster-Satu 0 - 4 Sochi ReservasSochi ...
05 Nov 21 Chertanovo ReservasChertanovo 1 - 1 Akhmat ReservasAkhmat ...
06 Nov 21 Zenit ReservasZenit 2 - 1 Rostov ReservasRostov ...
Jornada 16
19 Nov 21 Rubin Kazan ReservasRubin Kazan 1 - 1 Nizhny Novgorod ReservasNizhny ...
19 Nov 21 Ufa ReservasReservas 0 - 1 Dinamo Moskva ReservasDinamo ...
19 Nov 21 Ural ReservasUral 1 - 2 CSKA Moskva ReservasCSKA Moskva ...
19 Nov 21 Yuri Konoplev ReservasYuri 0 - 4 Strogino ReservasStrogino ...
19 Nov 21 Krylya Sovetov ReservasKrylya 0 - 3 Spartak Moskva ReservasSpartak ...
19 Nov 21 Lokomotiv Moskva ReservasLokomotiv 1 - 3 Rostov ReservasRostov ...
19 Nov 21 Arsenal Tula ReservasArsenal 1 - 4 Akhmat ReservasAkhmat ...
19 Nov 21 Master-Saturn ReservasMaster-Satu 1 - 1 Krasnodar ReservasKrasnodar ...
19 Nov 21 FK Khimki ReservasKhimki 1 - 1 Zenit ReservasZenit ...
19 Nov 21 Chertanovo ReservasChertanovo 4 - 2 Sochi ReservasSochi ...
Jornada 17
26 Nov 21 CSKA Moskva ReservasCSKA Moskva 5 - 2 Rubin Kazan ReservasRubin Kazan 1
26 Nov 21 Spartak Moskva ReservasSpartak 2 - 0 Ufa ReservasReservas ...
26 Nov 21 Dinamo Moskva ReservasDinamo 4 - 1 Yuri Konoplev ReservasYuri ...
26 Nov 21 Ural ReservasUral 2 - 3 Strogino ReservasStrogino ...
26 Nov 21 Nizhny Novgorod ReservasNizhny 0 - 2 Krylya Sovetov ReservasKrylya ...
26 Nov 21 Krasnodar ReservasKrasnodar 1 - 1 Chertanovo ReservasChertanovo ...
26 Nov 21 Akhmat ReservasAkhmat 0 - 0 Lokomotiv Moskva ReservasLokomotiv ...
26 Nov 21 Rostov ReservasRostov 3 - 1 FK Khimki ReservasKhimki ...
26 Nov 21 Sochi ReservasSochi 2 - 0 Arsenal Tula ReservasArsenal ...
27 Nov 21 Zenit ReservasZenit 11 - 1 Master-Saturn ReservasMaster-Satu ...
Jornada 18
03 Dic 21 Spartak Moskva ReservasSpartak 0 - 1 CSKA Moskva ReservasCSKA Moskva ...
03 Dic 21 Strogino ReservasStrogino 0 - 1 Rubin Kazan ReservasRubin Kazan ...
03 Dic 21 Ural ReservasUral 4 - 1 Ufa ReservasReservas ...
03 Dic 21 Krylya Sovetov ReservasKrylya 1 - 2 Dinamo Moskva ReservasDinamo ...
03 Dic 21 Nizhny Novgorod ReservasNizhny 5 - 2 Yuri Konoplev ReservasYuri ...
03 Dic 21 Krasnodar ReservasKrasnodar 4 - 0 Arsenal Tula ReservasArsenal ...
03 Dic 21 Lokomotiv Moskva ReservasLokomotiv 1 - 0 Master-Saturn ReservasMaster-Satu 1
03 Dic 21 Akhmat ReservasAkhmat 1 - 2 FK Khimki ReservasKhimki ...
03 Dic 21 Rostov ReservasRostov 0 - 2 Chertanovo ReservasChertanovo ...
03 Dic 21 Sochi ReservasSochi 4 - 2 Zenit ReservasZenit ...

Clasificación

Equipo PJ GF GC Puntos
1 CSKA Moskva Reservas CSKA Moskva 18 40 15 40
2 Dinamo Moskva Reservas Dinamo 18 41 27 37
3 Spartak Moskva Reservas Spartak 18 33 19 33
4 Krylya Sovetov Reservas Krylya 18 25 23 33
5 Rubin Kazan Reservas Rubin Kazan 18 38 31 26
6 Nizhny Novgorod Reservas Nizhny 18 26 32 23
7 Strogino Reservas Strogino 18 26 22 21
8 Ural Reservas Ural 18 22 35 16
9 Yuri Konoplev Reservas Yuri 18 21 41 16
10 Ufa Reservas Reservas 18 9 36 12
11 Rostov Reservas Rostov 18 47 16 43
12 Lokomotiv Moskva Reservas Lokomotiv 18 32 18 37
13 Chertanovo Reservas Chertanovo 18 32 22 34
14 Zenit Reservas Zenit 18 47 26 31
15 Sochi Reservas Sochi 18 33 30 31
16 Krasnodar Reservas Krasnodar 18 29 23 25
17 Akhmat Reservas Akhmat 18 23 30 16
18 FK Khimki Reservas Khimki 18 26 47 14
19 Arsenal Tula Reservas Arsenal Tula 18 23 42 12
20 Master-Saturn Reservas Master-Satur 18 13 51 9

  USO DE MEMORIA  
6,380,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3634
Total Execution Time  0.3653
  CADENA URL  
/liga_rusia_sub_212022/grupo1/calendario
  GET DATOS  
$_GET['/liga_rusia_sub_212022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_rusia_sub_212022'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_rusia_sub_21' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1545 ORDER BY order_id ASC
0.0105  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1545 GROUP BY l.categoryId
0.0106  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1545 GROUP BY l.year ORDER BY l.year DESC
0.0107  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63543 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 63543 ORDER BY round ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 23:53:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 23:53:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 23:53:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 23:53:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_rusia_sub_21' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0201  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63543 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63543 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0271  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63543 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63543 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0143  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63543 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63543 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0119  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63543 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC