4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Vilafranquense Sub 19
TEMPORADA 2022/2023
LIGA PORTUGUESA SUB 19 GRUPO 4
Equipo PJ GF GC Puntos
1 Vitória Setúbal Sub 19 Vitória 14 19 8 28
2 Maritimo Sub 19 Maritimo 14 21 13 25
3 Nacional Sub 19 Nacional 14 16 12 23
4 Casa Pia AC Sub 19 Casa 14 19 13 22
5 Torreense Sub 19 Torreense 14 14 17 18
6 Belenenses Sub 19 Belenenses 14 12 13 11
7 Académica Coimbra Sub 19 Académica 14 12 21 11
8 Vilafranquense Sub 19 Vilafranquen 14 9 25 7
TEMPORADA 2021/2022
LIGA PORTUGUESA SUB 19 GRUPO 3
Equipo PJ GF GC Puntos
1 Paços de Ferreira Sub 19 Paços 14 23 12 27
2 Vizela Sub 19 Vizela 14 26 19 26
3 Tondela Sub 19 Tondela 14 27 14 23
4 Gil Vicente Sub 19 Vicente 14 24 19 20
5 Leixões Sub 19 Leixões 14 22 25 20
6 Famalicão Sub 19 Famalicão 14 15 17 18
7 Feirense Sub 19 Feirense 14 10 24 11
8 Oliveirense sub 19 Oliveirense 14 10 27 8
9 Nacional Sub 19 Nacional 14 27 10 32
10 Académica Coimbra Sub 19 Académica 14 30 24 27
11 Amora FC Sub 19 Amora 14 20 19 21
12 Vilafranquense Sub 19 Vilafranquen 14 18 17 18
13 Vitória Setúbal Sub 19 Vitória 14 20 22 18
14 Belenenses Sub 19 Belenenses 14 18 23 15
15 União Leiria Sub 19 União 14 18 29 13
16 Sacavenense Sub 19 Sacavenense 14 17 24 10
TEMPORADA 2020/2021
LIGA PORTUGUESA SUB 19
Equipo PJ GF GC Puntos
1 Porto Sub 19 Porto 7 19 8 14
2 Braga Sub 19 Braga 7 16 7 14
3 Vitória Guimarães Sub 19 Vitória 5 14 5 9
4 Leixões Sub 19 Leixões 6 5 14 4
5 Benfica Sub 19 Benfica 7 21 7 16
6 Sporting CP Sub 19 Sporting 6 17 6 10
7 Belenenses Sub 19 Belenenses 5 4 20 3
8 Académica Coimbra Sub 19 Académica 7 4 33 0
9 Paços de Ferreira Sub 19 Paços 8 14 8 14
10 Famalicão Sub 19 Famalicão 8 12 10 13
11 Rio Ave Sub 19 8 11 10 10
12 Vizela Sub 19 Vizela 8 12 17 10
13 Tondela Sub 19 Tondela 8 9 13 8
14 Alverca Sub 19 Alverca 10 34 9 26
15 Estoril Sub 19 Estoril 10 24 19 19
16 Vitória Setúbal Sub 19 Vitória 10 19 11 18
17 Sacavenense Sub 19 Sacavenense 10 30 13 16
18 Amora FC Sub 19 Amora 10 18 42 7
19 Vilafranquense Sub 19 Vilafranquen 10 4 35 0
TEMPORADA 2019/2020
LIGA PORTUGUESA SUB 19 GRUPO 4
Equipo PJ GF GC Puntos
1 Gil Vicente Sub 19 Vicente 4 8 2 10
2 Vitória Guimarães Sub 19 Vitória 4 5 3 8
3 Paços de Ferreira Sub 19 Paços 4 6 3 7
4 Leixões Sub 19 Leixões 4 3 4 6
5 Desportivo Aves Sub 19 Desportivo 3 4 3 4
6 Feirense Sub 19 Feirense 3 2 3 3
7 Nacional Sub 19 Nacional 4 3 7 2
8 Vizela Sub 19 Vizela 4 2 8 1
9 Belenenses Sub 19 Belenenses 4 9 4 10
10 Académica Coimbra Sub 19 Académica 4 14 7 9
11 Vitória Setúbal Sub 19 Vitória 4 6 4 9
12 Sacavenense Sub 19 Sacavenense 4 9 6 6
13 Amora FC Sub 19 Amora 4 7 6 6
14 Tondela Sub 19 Tondela 4 8 11 6
15 Vilafranquense Sub 19 Vilafranquen 4 5 8 1
16 União Leiria Sub 19 União 4 1 13 0

  USO DE MEMORIA  
5,307,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2848
Total Execution Time  0.2860
  CADENA URL  
/historico/Vilafranquense-Sub19
  GET DATOS  
$_GET['/historico/Vilafranquense-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=139038 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2181 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2181 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (1082027,1052870,1031940,875033,775728) ORDER BY n.cover_points DESC, update_date DESC
0.0127  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '139038' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '139038' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 139038 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0256  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 68383 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 71086 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
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 63776 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 66703 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
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 62582 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 59382 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 59384 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