4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Parma Sub 17
TEMPORADA 2023/2024
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 24 64 30 50
2 Bologna Sub 17 Bologna 24 60 33 48
3 Sassuolo Sub 17 Sassuolo 24 45 32 46
4 Parma Sub 17 Parma 24 39 26 42
5 Torino Sub 17 Torino 24 38 24 41
6 Genoa Sub 17 Genoa 24 39 23 40
7 Pisa SC Sub 17 Pisa 24 33 32 32
8 Spezia Sub 17 Spezia 24 44 39 30
9 Sampdoria Sub 17 Sampdoria 24 38 49 30
10 Cremonese Sub 17 Cremonese 24 28 47 24
11 Modena Sub 17 Modena 24 31 49 23
12 Napoli Sub 17 Napoli 24 32 69 16
13 Reggiana Sub 17 Reggiana 24 17 55 13
TEMPORADA 2022/2023
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Fiorentina Sub 17 Fiorentina 24 79 33 57
2 Juventus Sub 17 Juventus 24 58 21 51
3 Parma Sub 17 Parma 24 52 24 49
4 Genoa Sub 17 Genoa 24 55 35 48
5 Bologna Sub 17 Bologna 24 60 34 46
6 Torino Sub 17 Torino 24 39 41 32
7 Pisa SC Sub 17 Pisa 24 30 40 32
8 Sassuolo Sub 17 Sassuolo 24 31 43 29
9 Napoli Sub 17 Napoli 24 37 54 28
10 Empoli Sub 17 Empoli 24 30 45 27
11 Sampdoria Sub 17 Sampdoria 24 21 39 24
12 Spezia Sub 17 Spezia 24 29 53 14
13 Modena Sub 17 Modena 24 13 72 3
TEMPORADA 2021/2022
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Bologna Sub 17 Bologna 24 40 24 49
2 Juventus Sub 17 Juventus 24 54 22 48
3 Genoa Sub 17 Genoa 24 65 34 47
4 Fiorentina Sub 17 Fiorentina 24 51 22 44
5 Sampdoria Sub 17 Sampdoria 24 36 31 38
6 Empoli Sub 17 Empoli 24 36 38 35
7 Cremonese Sub 17 Cremonese 24 37 43 31
8 Spezia Sub 17 Spezia 24 41 48 29
9 US Alessandria Sub17 Alessandria 24 37 39 28
10 Sassuolo Sub 17 Sassuolo 24 37 44 24
11 Torino Sub 17 Torino 24 31 56 22
12 Parma Sub 17 Parma 24 29 54 19
13 Pisa SC Sub 17 Pisa 24 27 66 13
TEMPORADA 2020/2021
CAMPEONATO NACIONAL SUB 17 GRUPO 4
Equipo PJ GF GC Puntos
1 Genoa Sub 17 Genoa 8 17 7 19
2 Juventus Sub 17 Juventus 8 19 8 15
3 Virtus Entella Sub 17 Virtus 8 8 13 11
4 Sampdoria Sub 17 Sampdoria 8 13 18 8
5 Torino Sub 17 Torino 8 10 21 3
6 Milan Sub 17 Milan 8 20 11 17
7 Cagliari Sub 17 Cagliari 8 22 12 14
8 Inter Sub 17 Inter 8 17 10 13
9 AC Monza Sub 17 Monza 8 12 14 10
10 Cremonese Sub 17 Cremonese 8 6 30 1
11 Atalanta Sub 17 Atalanta 8 16 11 16
12 Chievo Verona Sub 17 Chievo 8 18 10 15
13 Vicenza Sub 17 Vicenza 8 18 13 13
14 Brescia Sub 17 Brescia 8 17 20 7
15 Hellas Verona Sub 17 Hellas 8 10 25 5
16 SPAL Sub 17 SPAL Sub 17 8 28 8 19
17 Cittadella Sub 17 Cittadella 8 17 13 11
18 Udinese Sub 17 Udinese 8 14 19 11
19 Venezia Sub 17 Venezia 8 14 22 7
20 Pordenone Sub 17 Pordenone 8 7 18 7
21 Bologna Sub 17 Bologna 8 29 9 17
22 Sassuolo Sub 17 Sassuolo 8 17 10 16
23 Spezia Sub 17 Spezia 8 15 16 15
24 Parma Sub 17 Parma 8 10 14 7
25 Reggiana Sub 17 Reggiana 8 6 28 3
26 Roma Sub 17 Roma Sub 17 8 18 14 15
27 Lazio Sub 17 Lazio 8 19 18 15
28 Empoli Sub 17 Empoli 8 18 14 13
29 Fiorentina Sub 17 Fiorentina 8 16 13 10
30 Pisa SC Sub 17 Pisa 8 11 23 5
31 Benevento Sub 17 Benevento 8 16 12 17
32 Pescara Sub 17 Pescara 8 23 10 15
33 Napoli Sub 17 Napoli 8 17 15 12
34 Frosinone Sub 17 Frosinone 8 16 19 10
35 Ascoli Sub 17 Ascoli 8 12 28 4
36 Crotone Sub 17 Crotone 8 21 8 21
37 Lecce Sub 17 Lecce 8 20 7 21
38 Salernitana Sub 17 Salernitana 8 15 18 12
39 Nuova Cosenza Sub 17 Nuova 8 6 15 3
40 Reggina Sub 17 Reggina 8 8 22 3
TEMPORADA 2019/2020
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 18 75 19 52
2 Parma Sub 17 Parma 19 32 26 31
3 Genoa Sub 17 Genoa 18 30 25 30
4 Sassuolo Sub 17 Sassuolo 19 30 22 29
5 Empoli Sub 17 Empoli 18 38 35 28
6 Fiorentina Sub 17 Fiorentina 19 38 26 27
7 Spezia Sub 17 Spezia 18 31 24 27
8 Lazio Sub 17 Lazio 19 38 37 24
9 Torino Sub 17 Torino 17 21 21 24
10 Sampdoria Sub 17 Sampdoria 19 26 36 20
11 Virtus Entella Sub 17 Virtus 18 20 31 17
12 Pisa SC Sub 17 Pisa 20 19 61 12
13 Livorno Sub 17 Livorno 18 20 55 9
TEMPORADA 2018/2019
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 24 56 31 51
2 Fiorentina Sub 17 Fiorentina 24 59 32 50
3 Genoa Sub 17 Genoa 24 43 26 46
4 Torino Sub 17 Torino 24 44 30 45
5 Empoli Sub 17 Empoli 24 39 25 42
6 Sampdoria Sub 17 Sampdoria 24 46 29 41
7 Lazio Sub 17 Lazio 24 45 34 41
8 Sassuolo Sub 17 Sassuolo 24 40 25 35
9 Parma Sub 17 Parma 24 39 49 25
10 Cremonese Sub 17 Cremonese 24 27 50 22
11 Carpi Sub 17 Carpi 24 20 50 17
12 Livorno Sub 17 Livorno 24 21 61 14
13 Spezia Sub 17 Spezia 24 23 60 11
TEMPORADA 2017/2018
CAMPEONATO NACIONAL SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 17 Juventus 26 65 28 60
2 Torino Sub 17 Torino 26 46 18 60
3 Genoa Sub 17 Genoa 26 35 19 54
4 Novara Sub 17 Novara 26 45 31 47
5 Sampdoria Sub 17 Sampdoria 26 40 32 44
6 Fiorentina Sub 17 Fiorentina 26 48 35 42
7 Cremonese Sub 17 Cremonese 26 40 38 35
8 Sassuolo Sub 17 Sassuolo 26 36 31 32
9 Virtus Entella Sub 17 Virtus 26 35 46 32
10 Empoli Sub 17 Empoli 26 31 41 28
11 Carpi Sub 17 Carpi 26 24 47 21
12 Spezia Sub 17 Spezia 26 23 46 18
13 Pro Vercelli Sub 17 Vercelli 26 25 57 16
14 Parma Sub 17 Parma 26 19 43 14

  USO DE MEMORIA  
5,584,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1316
Total Execution Time  0.1328
  CADENA URL  
/historico/Parma-Sub-17
  GET DATOS  
$_GET['/historico/Parma-Sub-17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0041  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Parma-Sub-17' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=111204 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=111204 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0048  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74022
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111204 AND type_rel = 2
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2043 AND type_rel = 3
0.0036  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '111204' ORDER BY l.year DESC,cat.coefficient DESC
0.0039  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '111204' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0036  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 = '111204' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74022 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0052  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=111204 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74022) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0045  SELECT count(id) as num_players from rel_players WHERE league_id = 74022 AND teamId = 111204
0.0046  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74022 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0032  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '111204' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '111204' and rp.type = 4
0.0033  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '111204' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0069  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 74022 WHERE rp.league_id = 74022 AND rp.teamId = 111204 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0067  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 74022 WHERE rp.league_id = 74022 AND rp.teamId = 111204 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0048  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 74022 WHERE rp.league_id = 74022 AND rp.teamId = 111204 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 111204 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031  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 `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 = 74022 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 68785 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 63937 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 58747 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 62218 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.0025  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 = 51480 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2019` 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 = 48433 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74022 ORDER BY nameShow LIMIT 100