4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
29 Jul 23 Rubin Kazan Sub 17Rubin Kazan 0 - 2 Dinamo Moscú Sub 17Dinamo ...
29 Jul 23 CSKA Moskva Sub 17CSKA Moskva 3 - 0 SShOR Zenit Sub 17SShOR Zenit ...
29 Jul 23 FShM Moskau Sub 17FShM Moskau 0 - 2 Y. Konoplev Sub 17Konoplev ...
29 Jul 23 Strogino Sub 17Strogino 0 - 1 Spartak Moskva Sub 17Spartak ...
29 Jul 23 Rostov Sub 17Rostov 1 - 0 Zenit Sub 17Zenit ...
29 Jul 23 FK Krasnodar Sub 17Krasnodar 6 - 1 Saturn-Master Sub 17Saturn-Mast ...
30 Jul 23 Lokomotiv Moskva Sub 17Lokomotiv 3 - 3 Chertanovo Sub 17Chertanovo ...
Ver jornada
Jornada 2
05 Ago 23 SShOR Zenit Sub 17SShOR Zenit 3 - 4 Spartak Moskva Sub 17Spartak ...
05 Ago 23 Saturn-Master Sub 17Saturn-Mast 0 - 2 Strogino Sub 17Strogino ...
05 Ago 23 Zenit Sub 17Zenit 2 - 0 FK Krasnodar Sub 17Krasnodar ...
05 Ago 23 Y. Konoplev Sub 17Konoplev 1 - 2 Rostov Sub 17Rostov ...
06 Ago 23 Chertanovo Sub 17Chertanovo 3 - 2 FShM Moskau Sub 17FShM Moskau ...
06 Ago 23 Dinamo Moscú Sub 17Dinamo 1 - 1 Lokomotiv Moskva Sub 17Lokomotiv ...
05 Ago 23 CSKA Moskva Sub 17CSKA Moskva 9 - 1 Rubin Kazan Sub 17Rubin Kazan ...
Ver jornada
Jornada 3
12 Ago 23 Lokomotiv Moskva Sub 17Lokomotiv 0 - 1 CSKA Moskva Sub 17CSKA Moskva ...
12 Ago 23 Spartak Moskva Sub 17Spartak 2 - 1 Saturn-Master Sub 17Saturn-Mast ...
12 Ago 23 Strogino Sub 17Strogino 1 - 2 Zenit Sub 17Zenit ...
12 Ago 23 FK Krasnodar Sub 17Krasnodar 4 - 2 Y. Konoplev Sub 17Konoplev ...
12 Ago 23 Rostov Sub 17Rostov 3 - 2 Chertanovo Sub 17Chertanovo ...
12 Ago 23 FShM Moskau Sub 17FShM Moskau 0 - 0 Dinamo Moscú Sub 17Dinamo ...
13 Ago 23 Rubin Kazan Sub 17Rubin Kazan 4 - 0 SShOR Zenit Sub 17SShOR Zenit ...
Ver jornada
Jornada 4
19 Ago 23 Rubin Kazan Sub 17Rubin Kazan 0 - 2 Lokomotiv Moskva Sub 17Lokomotiv ...
19 Ago 23 CSKA Moskva Sub 17CSKA Moskva 4 - 1 FShM Moskau Sub 17FShM Moskau ...
19 Ago 23 Dinamo Moscú Sub 17Dinamo 0 - 1 Rostov Sub 17Rostov ...
19 Ago 23 Y. Konoplev Sub 17Konoplev 2 - 1 Strogino Sub 17Strogino ...
19 Ago 23 Zenit Sub 17Zenit 2 - 0 Spartak Moskva Sub 17Spartak ...
19 Ago 23 SShOR Zenit Sub 17SShOR Zenit 0 - 3 Saturn-Master Sub 17Saturn-Mast ...
19 Ago 23 Chertanovo Sub 17Chertanovo 0 - 2 FK Krasnodar Sub 17Krasnodar ...
Ver jornada
Jornada 5
27 Ago 23 Lokomotiv Moskva Sub 17Lokomotiv 4 - 1 SShOR Zenit Sub 17SShOR Zenit ...
26 Ago 23 FShM Moskau Sub 17FShM Moskau 0 - 1 Rubin Kazan Sub 17Rubin Kazan ...
26 Ago 23 Rostov Sub 17Rostov 0 - 3 CSKA Moskva Sub 17CSKA Moskva ...
26 Ago 23 FK Krasnodar Sub 17Krasnodar 0 - 2 Dinamo Moscú Sub 17Dinamo ...
26 Ago 23 Strogino Sub 17Strogino 1 - 1 Chertanovo Sub 17Chertanovo ...
26 Ago 23 Spartak Moskva Sub 17Spartak 4 - 1 Y. Konoplev Sub 17Konoplev ...
27 Ago 23 Saturn-Master Sub 17Saturn-Mast 1 - 5 Zenit Sub 17Zenit ...
Ver jornada
Jornada 6
02 Sep 23 SShOR Zenit Sub 17SShOR Zenit 0 - 5 Zenit Sub 17Zenit ...
03 Sep 23 Lokomotiv Moskva Sub 17Lokomotiv 1 - 1 FShM Moskau Sub 17FShM Moskau ...
02 Sep 23 Rubin Kazan Sub 17Rubin Kazan 2 - 1 Rostov Sub 17Rostov ...
02 Sep 23 CSKA Moskva Sub 17CSKA Moskva 2 - 3 FK Krasnodar Sub 17Krasnodar ...
02 Sep 23 Dinamo Moscú Sub 17Dinamo 1 - 2 Strogino Sub 17Strogino ...
03 Sep 23 Chertanovo Sub 17Chertanovo 3 - 0 Spartak Moskva Sub 17Spartak ...
02 Sep 23 Y. Konoplev Sub 17Konoplev 1 - 2 Saturn-Master Sub 17Saturn-Mast ...
Ver jornada
Jornada 7
16 Sep 23 Zenit Sub 17Zenit 8 - 0 Y. Konoplev Sub 17Konoplev ...
17 Sep 23 Saturn-Master Sub 17Saturn-Mast 1 - 6 Chertanovo Sub 17Chertanovo ...
16 Sep 23 Spartak Moskva Sub 17Spartak 1 - 1 Dinamo Moscú Sub 17Dinamo ...
16 Sep 23 Strogino Sub 17Strogino 2 - 7 CSKA Moskva Sub 17CSKA Moskva ...
16 Sep 23 Rostov Sub 17Rostov 2 - 1 Lokomotiv Moskva Sub 17Lokomotiv ...
16 Sep 23 FShM Moskau Sub 17FShM Moskau 1 - 0 SShOR Zenit Sub 17SShOR Zenit ...
16 Sep 23 FK Krasnodar Sub 17Krasnodar 3 - 1 Rubin Kazan Sub 17Rubin Kazan ...
Ver jornada
Jornada 8
23 Sep 23 SShOR Zenit Sub 17SShOR Zenit 1 - 2 Y. Konoplev Sub 17Konoplev ...
24 Sep 23 Chertanovo Sub 17Chertanovo 1 - 3 Zenit Sub 17Zenit ...
24 Sep 23 Dinamo Moscú Sub 17Dinamo 0 - 3 Saturn-Master Sub 17Saturn-Mast ...
23 Sep 23 CSKA Moskva Sub 17CSKA Moskva 2 - 0 Spartak Moskva Sub 17Spartak ...
23 Sep 23 Rubin Kazan Sub 17Rubin Kazan 1 - 5 Strogino Sub 17Strogino ...
23 Sep 23 Lokomotiv Moskva Sub 17Lokomotiv 5 - 1 FK Krasnodar Sub 17Krasnodar ...
23 Sep 23 FShM Moskau Sub 17FShM Moskau 0 - 2 Rostov Sub 17Rostov ...
Ver jornada
Jornada 9
30 Sep 23 Rostov Sub 17Rostov 4 - 1 SShOR Zenit Sub 17SShOR Zenit ...
30 Sep 23 Y. Konoplev Sub 17Konoplev 1 - 0 Chertanovo Sub 17Chertanovo ...
30 Sep 23 Zenit Sub 17Zenit 6 - 0 Dinamo Moscú Sub 17Dinamo ...
30 Sep 23 Saturn-Master Sub 17Saturn-Mast 0 - 2 CSKA Moskva Sub 17CSKA Moskva ...
30 Sep 23 Spartak Moskva Sub 17Spartak 2 - 1 Rubin Kazan Sub 17Rubin Kazan ...
30 Sep 23 Strogino Sub 17Strogino 3 - 3 Lokomotiv Moskva Sub 17Lokomotiv ...
30 Sep 23 FK Krasnodar Sub 17Krasnodar 2 - 0 FShM Moskau Sub 17FShM Moskau ...
Ver jornada
Jornada 10
07 Oct 23 Rostov Sub 17Rostov 0 - 2 FK Krasnodar Sub 17Krasnodar ...
07 Oct 23 FShM Moskau Sub 17FShM Moskau 2 - 2 Strogino Sub 17Strogino ...
08 Oct 23 Lokomotiv Moskva Sub 17Lokomotiv 1 - 2 Spartak Moskva Sub 17Spartak ...
07 Oct 23 CSKA Moskva Sub 17CSKA Moskva 5 - 2 Zenit Sub 17Zenit ...
07 Oct 23 Dinamo Moscú Sub 17Dinamo 4 - 0 Y. Konoplev Sub 17Konoplev ...
07 Oct 23 SShOR Zenit Sub 17SShOR Zenit 3 - 1 Chertanovo Sub 17Chertanovo ...
07 Oct 23 Rubin Kazan Sub 17Rubin Kazan 1 - 1 Saturn-Master Sub 17Saturn-Mast ...
Ver jornada
Jornada 11
14 Oct 23 FK Krasnodar Sub 17Krasnodar 3 - 1 SShOR Zenit Sub 17SShOR Zenit ...
14 Oct 23 Strogino Sub 17Strogino 1 - 2 Rostov Sub 17Rostov ...
14 Oct 23 Spartak Moskva Sub 17Spartak 5 - 1 FShM Moskau Sub 17FShM Moskau ...
14 Oct 23 Saturn-Master Sub 17Saturn-Mast 2 - 4 Lokomotiv Moskva Sub 17Lokomotiv ...
14 Oct 23 Zenit Sub 17Zenit 3 - 0 Rubin Kazan Sub 17Rubin Kazan ...
14 Oct 23 Y. Konoplev Sub 17Konoplev 1 - 4 CSKA Moskva Sub 17CSKA Moskva ...
14 Oct 23 Chertanovo Sub 17Chertanovo 3 - 0 Dinamo Moscú Sub 17Dinamo ...
Ver jornada
Jornada 12
19 Oct 23 Spartak Moskva Sub 17Spartak 3 - 2 FK Krasnodar Sub 17Krasnodar ...
19 Oct 23 Dinamo Moscú Sub 17Dinamo 0 - 4 CSKA Moskva Sub 17CSKA Moskva ...
19 Oct 23 Chertanovo Sub 17Chertanovo 5 - 2 Rubin Kazan Sub 17Rubin Kazan ...
19 Oct 23 Y. Konoplev Sub 17Konoplev 0 - 3 Lokomotiv Moskva Sub 17Lokomotiv ...
19 Oct 23 Zenit Sub 17Zenit 1 - 2 FShM Moskau Sub 17FShM Moskau ...
19 Oct 23 Saturn-Master Sub 17Saturn-Mast 0 - 5 Rostov Sub 17Rostov ...
19 Oct 23 Strogino Sub 17Strogino 3 - 0 SShOR Zenit Sub 17SShOR Zenit ...
Ver jornada
Jornada 13
04 Nov 23 SShOR Zenit Sub 17SShOR Zenit 2 - 2 Dinamo Moscú Sub 17Dinamo ...
04 Nov 23 CSKA Moskva Sub 17CSKA Moskva 1 - 1 Chertanovo Sub 17Chertanovo ...
04 Nov 23 Rubin Kazan Sub 17Rubin Kazan 2 - 1 Y. Konoplev Sub 17Konoplev ...
04 Nov 23 Lokomotiv Moskva Sub 17Lokomotiv 2 - 0 Zenit Sub 17Zenit ...
04 Nov 23 FShM Moskau Sub 17FShM Moskau 2 - 3 Saturn-Master Sub 17Saturn-Mast ...
04 Nov 23 Rostov Sub 17Rostov 3 - 1 Spartak Moskva Sub 17Spartak ...
04 Nov 23 FK Krasnodar Sub 17Krasnodar 4 - 1 Strogino Sub 17Strogino ...

Clasificación

Equipo PJ GF GC Puntos
1 CSKA Moskva Sub 17 CSKA Moskva 13 47 11 34
2 Rostov Sub 17 Rostov 13 26 14 30
3 Zenit Sub 17 Zenit 13 39 13 27
4 FK Krasnodar Sub 17 Krasnodar 13 32 20 27
5 Spartak Moskva Sub 17 Spartak 13 25 21 25
6 Lokomotiv Moskva Sub 17 Lokomotiv 13 30 17 22
7 Chertanovo Sub 17 Chertanovo 13 29 22 18
8 Strogino Sub 17 Strogino 13 24 26 15
9 Dinamo Moscú Sub 17 Dinamo 13 13 23 13
10 Saturn-Master Sub 17 Saturn-Maste 13 18 36 13
11 Rubin Kazan Sub 17 Rubin Kazan 13 16 34 13
12 Y. Konoplev Sub 17 Konoplev 13 14 35 12
13 FShM Moskau Sub 17 FShM Moskau 13 12 26 9
14 SShOR Zenit Sub 17 SShOR Zenit 13 12 39 4

  USO DE MEMORIA  
5,511,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4122
Total Execution Time  0.4142
  CADENA URL  
/liga_rusia_sub_172024/grupo1/calendario
  GET DATOS  
$_GET['/liga_rusia_sub_172024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0145  SELECT type FROM routes WHERE alias = 'liga_rusia_sub_172024'
0.0291  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_17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2366 AND type_rel = 3
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2366 ORDER BY order_id ASC
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2366 GROUP BY l.categoryId
0.0156  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=2366 GROUP BY l.year ORDER BY l.year DESC
0.0147  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 = 72874 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 72874 ORDER BY round ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:41:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 14:41:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 14:41:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 14:41:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  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_17' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0200  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 events2024 e ON e.player_id = p.id AND e.league_id = 72874 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72874 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.0192  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 events2024 e ON e.player_id = p.id AND e.league_id = 72874 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72874 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  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 events2024 e ON e.player_id = p.id AND e.league_id = 72874 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72874 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0154  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 72874 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC