4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
08 Ago 23 Braga Sub 23Braga 2 - 3 Academico Viseu Sub 23Academico ...
09 Ago 23 Famalicão Sub 23Famalicão 1 - 0 Rio Ave Sub 23 ...
09 Ago 23 Leixões Sub 23Leixões 1 - 3 Gil Vicente Sub 23Vicente ...
09 Ago 23 Torreense Sub 23Torreense 0 - 3 Vizela Sub 23Vizela ...
08 Ago 23 Estoril Sub 23Estoril 2 - 2 CD Santa Clara Sub 23Santa Clara ...
08 Ago 23 Estrela Amadora Sub 23Estrela 2 - 1 Benfica Sub 23Benfica 2
08 Ago 23 Mafra Sub 23Mafra 1 - 2 Farense Sub 23Farense 1
08 Ago 23 Sporting CP Sub 23Sporting 0 - 0 Portimonense Sub 23Portimonens 5
Ver jornada
Jornada 2
15 Ago 23 Academico Viseu Sub 23Academico 1 - 0 Leixões Sub 23Leixões ...
15 Ago 23 Gil Vicente Sub 23Vicente 2 - 3 Famalicão Sub 23Famalicão ...
15 Ago 23 Vizela Sub 23Vizela 1 - 1 Braga Sub 23Braga 3
15 Ago 23 Rio Ave Sub 23 0 - 1 Torreense Sub 23Torreense ...
15 Ago 23 Benfica Sub 23Benfica 2 - 2 Sporting CP Sub 23Sporting 1
16 Ago 23 Portimonense Sub 23Portimonens 0 - 1 Mafra Sub 23Mafra 3
14 Sep 23 CD Santa Clara Sub 23Santa Clara 1 - 3 Estrela Amadora Sub 23Estrela ...
31 Oct 23 Farense Sub 23Farense 1 - 1 Estoril Sub 23Estoril ...
Ver jornada
Jornada 3
22 Ago 23 Braga Sub 23Braga 2 - 1 Rio Ave Sub 23 2
22 Ago 23 Gil Vicente Sub 23Vicente 3 - 1 Academico Viseu Sub 23Academico ...
22 Ago 23 Leixões Sub 23Leixões 1 - 2 Vizela Sub 23Vizela ...
23 Ago 23 Torreense Sub 23Torreense 1 - 1 Famalicão Sub 23Famalicão 1
22 Ago 23 Estoril Sub 23Estoril 2 - 1 Mafra Sub 23Mafra 10
22 Ago 23 Estrela Amadora Sub 23Estrela 0 - 0 Farense Sub 23Farense 3
22 Ago 23 Portimonense Sub 23Portimonens 0 - 5 Benfica Sub 23Benfica 3
22 Ago 23 Sporting CP Sub 23Sporting 5 - 0 CD Santa Clara Sub 23Santa Clara ...
Ver jornada
Jornada 4
29 Ago 23 Famalicão Sub 23Famalicão 2 - 2 Braga Sub 23Braga ...
28 Nov 23 Rio Ave Sub 23 0 - 1 Leixões Sub 23Leixões ...
29 Ago 23 Vizela Sub 23Vizela 3 - 0 Academico Viseu Sub 23Academico ...
29 Ago 23 Torreense Sub 23Torreense 2 - 2 Gil Vicente Sub 23Vicente ...
29 Ago 23 Estoril Sub 23Estoril 4 - 2 Portimonense Sub 23Portimonens ...
29 Ago 23 Mafra Sub 23Mafra 0 - 1 Estrela Amadora Sub 23Estrela ...
29 Ago 23 CD Santa Clara Sub 23Santa Clara 3 - 1 Benfica Sub 23Benfica 7
28 Nov 23 Farense Sub 23Farense 2 - 2 Sporting CP Sub 23Sporting 6
Ver jornada
Jornada 5
19 Sep 23 Academico Viseu Sub 23Academico 3 - 1 Rio Ave Sub 23 ...
19 Sep 23 Gil Vicente Sub 23Vicente 0 - 2 Vizela Sub 23Vizela ...
19 Sep 23 Leixões Sub 23Leixões 1 - 2 Famalicão Sub 23Famalicão ...
16 Sep 23 Braga Sub 23Braga 1 - 2 Torreense Sub 23Torreense ...
16 Sep 23 Benfica Sub 23Benfica 5 - 0 Farense Sub 23Farense ...
19 Sep 23 Estrela Amadora Sub 23Estrela 1 - 2 Estoril Sub 23Estoril ...
19 Sep 23 Portimonense Sub 23Portimonens 1 - 1 CD Santa Clara Sub 23Santa Clara ...
19 Sep 23 Sporting CP Sub 23Sporting 4 - 2 Mafra Sub 23Mafra 1
Ver jornada
Jornada 6
26 Sep 23 Braga Sub 23Braga 0 - 0 Gil Vicente Sub 23Vicente 1
25 Sep 23 Famalicão Sub 23Famalicão 1 - 0 Academico Viseu Sub 23Academico ...
26 Sep 23 Rio Ave Sub 23 1 - 2 Vizela Sub 23Vizela ...
26 Sep 23 Torreense Sub 23Torreense 2 - 2 Leixões Sub 23Leixões ...
26 Sep 23 Estoril Sub 23Estoril 3 - 1 Sporting CP Sub 23Sporting ...
26 Sep 23 Estrela Amadora Sub 23Estrela 0 - 0 Portimonense Sub 23Portimonens ...
26 Sep 23 Mafra Sub 23Mafra 3 - 1 Benfica Sub 23Benfica ...
22 Sep 23 Farense Sub 23Farense 2 - 1 CD Santa Clara Sub 23Santa Clara ...
Ver jornada
Jornada 7
03 Oct 23 Gil Vicente Sub 23Vicente 1 - 1 Rio Ave Sub 23 1
09 Oct 23 Leixões Sub 23Leixões 0 - 1 Braga Sub 23Braga ...
30 Sep 23 Vizela Sub 23Vizela 3 - 0 Famalicão Sub 23Famalicão ...
03 Oct 23 Academico Viseu Sub 23Academico 2 - 2 Torreense Sub 23Torreense ...
07 Oct 23 Benfica Sub 23Benfica 3 - 4 Estoril Sub 23Estoril ...
03 Oct 23 Portimonense Sub 23Portimonens 0 - 4 Farense Sub 23Farense 1
10 Oct 23 CD Santa Clara Sub 23Santa Clara 0 - 1 Mafra Sub 23Mafra 13
03 Oct 23 Sporting CP Sub 23Sporting 1 - 1 Estrela Amadora Sub 23Estrela ...
Ver jornada
Jornada 8
20 Oct 23 Academico Viseu Sub 23Academico 2 - 0 Braga Sub 23Braga ...
24 Oct 23 Gil Vicente Sub 23Vicente 1 - 0 Leixões Sub 23Leixões ...
20 Oct 23 Rio Ave Sub 23 0 - 0 Famalicão Sub 23Famalicão ...
24 Oct 23 Vizela Sub 23Vizela 0 - 0 Torreense Sub 23Torreense ...
20 Oct 23 Benfica Sub 23Benfica 1 - 0 Estrela Amadora Sub 23Estrela ...
24 Oct 23 Portimonense Sub 23Portimonens 1 - 5 Sporting CP Sub 23Sporting 1
24 Oct 23 CD Santa Clara Sub 23Santa Clara 2 - 2 Estoril Sub 23Estoril ...
24 Oct 23 Farense Sub 23Farense 1 - 4 Mafra Sub 23Mafra ...
Ver jornada
Jornada 9
31 Oct 23 Braga Sub 23Braga 1 - 1 Vizela Sub 23Vizela 1
31 Oct 23 Famalicão Sub 23Famalicão 0 - 0 Gil Vicente Sub 23Vicente 2
22 Nov 23 Leixões Sub 23Leixões 2 - 0 Academico Viseu Sub 23Academico 1
31 Oct 23 Torreense Sub 23Torreense 1 - 0 Rio Ave Sub 23 ...
15 Ago 23 Estoril Sub 23Estoril 2 - 1 Farense Sub 23Farense ...
31 Oct 23 Estrela Amadora Sub 23Estrela 2 - 4 CD Santa Clara Sub 23Santa Clara ...
01 Nov 23 Mafra Sub 23Mafra 1 - 2 Portimonense Sub 23Portimonens ...
31 Oct 23 Sporting CP Sub 23Sporting 4 - 0 Benfica Sub 23Benfica ...
Ver jornada
Jornada 10
07 Nov 23 Academico Viseu Sub 23Academico 0 - 1 Gil Vicente Sub 23Vicente ...
04 Nov 23 Rio Ave Sub 23 2 - 3 Braga Sub 23Braga ...
07 Nov 23 Vizela Sub 23Vizela 3 - 2 Leixões Sub 23Leixões ...
07 Nov 23 Famalicão Sub 23Famalicão 2 - 2 Torreense Sub 23Torreense ...
12 Nov 23 Benfica Sub 23Benfica 2 - 2 Portimonense Sub 23Portimonens ...
07 Nov 23 Mafra Sub 23Mafra 1 - 3 Estoril Sub 23Estoril ...
07 Nov 23 CD Santa Clara Sub 23Santa Clara 0 - 0 Sporting CP Sub 23Sporting 2
07 Nov 23 Farense Sub 23Farense 2 - 2 Estrela Amadora Sub 23Estrela ...
Ver jornada
Jornada 11
28 Nov 23 Academico Viseu Sub 23Academico 3 - 1 Vizela Sub 23Vizela ...
25 Nov 23 Braga Sub 23Braga 1 - 1 Famalicão Sub 23Famalicão ...
29 Ago 23 Leixões Sub 23Leixões 2 - 0 Rio Ave Sub 23 ...
28 Nov 23 Gil Vicente Sub 23Vicente 4 - 2 Torreense Sub 23Torreense ...
25 Nov 23 Benfica Sub 23Benfica 4 - 1 CD Santa Clara Sub 23Santa Clara ...
28 Nov 23 Estrela Amadora Sub 23Estrela 2 - 1 Mafra Sub 23Mafra ...
28 Nov 23 Portimonense Sub 23Portimonens 4 - 0 Estoril Sub 23Estoril ...
29 Ago 23 Sporting CP Sub 23Sporting 1 - 1 Farense Sub 23Farense ...
Ver jornada
Jornada 12
05 Dic 23 Famalicão Sub 23Famalicão 3 - 2 Leixões Sub 23Leixões ...
05 Dic 23 Rio Ave Sub 23 3 - 2 Academico Viseu Sub 23Academico ...
05 Dic 23 Vizela Sub 23Vizela 1 - 2 Gil Vicente Sub 23Vicente ...
05 Dic 23 Torreense Sub 23Torreense 1 - 0 Braga Sub 23Braga 1
05 Dic 23 Estoril Sub 23Estoril 2 - 1 Estrela Amadora Sub 23Estrela ...
06 Dic 23 Mafra Sub 23Mafra 0 - 1 Sporting CP Sub 23Sporting 1
05 Dic 23 CD Santa Clara Sub 23Santa Clara 2 - 0 Portimonense Sub 23Portimonens ...
05 Dic 23 Farense Sub 23Farense 2 - 2 Benfica Sub 23Benfica ...
Ver jornada
Jornada 13
12 Dic 23 Academico Viseu Sub 23Academico 3 - 3 Famalicão Sub 23Famalicão ...
09 Dic 23 Gil Vicente Sub 23Vicente 2 - 3 Braga Sub 23Braga ...
12 Dic 23 Vizela Sub 23Vizela 2 - 1 Rio Ave Sub 23 ...
12 Dic 23 Leixões Sub 23Leixões 2 - 0 Torreense Sub 23Torreense ...
19 Dic 23 Benfica Sub 23Benfica 2 - 0 Mafra Sub 23Mafra 2
19 Dic 23 Portimonense Sub 23Portimonens 1 - 2 Estrela Amadora Sub 23Estrela ...
12 Dic 23 CD Santa Clara Sub 23Santa Clara 1 - 1 Farense Sub 23Farense 4
12 Dic 23 Sporting CP Sub 23Sporting 0 - 2 Estoril Sub 23Estoril ...
Ver jornada
Jornada 14
19 Dic 23 Braga Sub 23Braga 2 - 0 Leixões Sub 23Leixões ...
19 Dic 23 Famalicão Sub 23Famalicão 1 - 1 Vizela Sub 23Vizela 2
19 Dic 23 Rio Ave Sub 23 2 - 1 Gil Vicente Sub 23Vicente ...
19 Dic 23 Torreense Sub 23Torreense 1 - 0 Academico Viseu Sub 23Academico ...
23 Dic 23 Estoril Sub 23Estoril 3 - 3 Benfica Sub 23Benfica ...
23 Dic 23 Estrela Amadora Sub 23Estrela 1 - 0 Sporting CP Sub 23Sporting ...
23 Dic 23 Mafra Sub 23Mafra 0 - 2 CD Santa Clara Sub 23Santa Clara ...
23 Dic 23 Farense Sub 23Farense 2 - 0 Portimonense Sub 23Portimonens ...

Clasificación

Equipo PJ GF GC Puntos
1 Vizela Sub 23 Vizela 14 25 13 28
2 Famalicão Sub 23 Famalicão 14 20 18 23
3 Gil Vicente Sub 23 Vicente 14 22 18 22
4 Torreense Sub 23 Torreense 14 17 19 21
5 Braga Sub 23 Braga 14 19 18 20
6 Academico Viseu Sub 23 Academico 14 20 23 17
7 Leixões Sub 23 Leixões 14 16 20 13
8 Rio Ave Sub 23 14 12 22 8
9 Estoril Sub 23 Estoril 14 32 23 31
10 Estrela Amadora Sub 23 Estrela 14 18 16 22
11 Sporting CP Sub 23 Sporting 14 26 15 21
12 Benfica Sub 23 Benfica 14 32 26 19
13 Farense Sub 23 Farense 14 21 22 19
14 CD Santa Clara Sub 23 Santa Clara 14 20 24 17
15 Mafra Sub 23 Mafra 14 16 23 12
16 Portimonense Sub 23 Portimonense 14 13 29 10

  USO DE MEMORIA  
5,729,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.4253
Total Execution Time  0.4287
  CADENA URL  
/liga_revelacao2024/grupo1/calendario
  GET DATOS  
$_GET['/liga_revelacao2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0146  SELECT type FROM routes WHERE alias = 'liga_revelacao2024'
0.0298  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_revelacao' 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.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2079 AND type_rel = 3
0.0151  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2079 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0155  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1224970,1220641,1048306,1045659,1031317) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2079 ORDER BY order_id ASC
0.0146  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 = 72798 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 = 72798 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-28 15:17:27' 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-28 15:17:27' 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=4 AND last_update > '2024-04-28 15:17:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 15:17:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_revelacao' 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.0189  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 = 72798 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72798 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.0278  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 = 72798 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72798 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0151  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 = 72798 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72798 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 = 72798 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC