4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Marianao Poblet Sub 16
TEMPORADA 2023/2024
PREFERENTE CATALANA CADETE GRUPO 4
Equipo PJ GF GC Puntos
1 Barcelona Sub 16 B Barcelona 26 80 9 67
2 Cambrils Unio Sub 16 Cambrils 27 51 19 63
3 La Floresta Sub 16 Floresta 27 54 25 57
4 Nastic Tarragona Sub 16 B Nastic 26 59 32 54
5 Cornella Sub 16 B Cornella 26 50 30 53
6 Martorell Sub 16 Martorell 27 50 34 43
7 Amposta Sub 16 Amposta 27 35 36 43
8 Marianao Poblet Sub 16 Marianao 26 38 37 33
9 Castelldefels Sub 16 B Castelldefel 26 38 43 32
10 Gava Sub 16 B Gava 26 42 56 30
11 Rapitenca Sub 16 Rapitenca 27 30 46 29
12 Calafell Sub 16 Calafell 27 52 74 23
13 Sant Cugat Sub 16 B Sant Cugat 26 37 53 21
14 Atletic Vilafranca Sub 16 Atletic 26 27 55 18
15 Sitges Sub 16 Sitges 26 24 71 17
16 Escola Valls Sub 16 Escola Valls 26 20 67 13
TEMPORADA 2022/2023
PREFERENTE CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Rapitenca Sub 16 Rapitenca 2 9 3 6
2 Barcelona Sub 16 B Barcelona 2 6 2 6
3 Calafell Sub 16 Calafell 2 4 1 6
4 Nastic Tarragona Sub 16 B Nastic 2 3 1 6
5 Martorell Sub 16 Martorell 2 3 2 4
6 Cambrils Unio Sub 16 Cambrils 2 6 3 3
7 La Floresta Sub 16 Floresta 2 4 3 3
8 Castelldefels Sub 16 Castelldefel 2 3 2 3
9 CE Sabadell Sub 16 Sabadell 2 6 6 3
10 Sant Ildefons A Sant 2 2 2 3
11 Marianao Poblet Sub 16 Marianao 2 2 2 3
12 Can Vidalet A Vidalet 2 4 6 1
13 Fundación Reus B Fundación 2 1 4 0
14 Cornella Sub 16 B Cornella 2 0 4 0
15 Atletic Vilafranca Sub 16 Atletic 2 0 5 0
16 Tortosa A Tortosa A 2 2 9 0
TEMPORADA 2021/2022
PREFERENTE CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona Sub 16 B Barcelona 30 107 10 86
2 Ud Cornellà Sub 16 Cornellà 30 104 21 80
3 Castelldefels Sub 16 Castelldefel 29 55 32 59
4 La Floresta Sub 16 Floresta 29 50 32 54
5 Rapitenca Sub 16 Rapitenca 30 45 47 44
6 Cambrils Unio Sub 16 Cambrils 28 37 33 38
7 Fundación Reus B Fundación 29 37 53 35
8 Marianao Poblet Sub 16 Marianao 28 36 43 33
9 Martorell Sub 16 Martorell 30 38 54 32
10 Tortosa A Tortosa A 28 40 60 32
11 Atletic Vilafranca Sub 16 Atletic 30 40 61 32
12 Nastic Tarragona Sub 16 B Nastic 28 38 41 31
13 Jabac I Terrassa B Jabac 29 35 66 30
14 San Pedro San Pablo A Pedro Pablo 30 37 61 29
15 Santfeliuenc A Santfeliuenc 29 31 67 26
16 Santboia A Santboia A 29 11 60 16
TEMPORADA 2020/2021
PREFERENTE CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona B Barcelona B 2 7 3 6
2 Cornella Sub 16 B Cornella 2 6 2 6
3 Cambrils UniÒ A Cambrils 2 6 3 6
4 Escuela Fsan Pedro San Pabl Escuela Fsan 2 4 2 4
5 Gimnastic Tarragona C B Gimnastic 2 4 2 4
6 La Floresta A Floresta 2 4 3 3
7 Atletic Sant Just Sub 16 Atletic Sant 2 4 5 3
8 Sant Ildefons A Sant 2 3 4 3
9 Rapitenca Sub 16 Rapitenca 2 4 4 2
10 Castelldefels A Castelldefel 1 3 3 1
11 Escola Futbol Base Calafell Escola 2 4 5 1
12 Marianao Poblet Sub 16 Marianao 2 3 4 1
13 Prat AE A Prat AE A 2 1 3 1
14 Viladecans A Viladecans 2 1 4 0
15 Santboia A Santboia A 1 1 4 0
16 Fundación Reus B Fundación 2 1 5 0
TEMPORADA 2019/2020
PREFERENTE CATALANA CADETE
Equipo PJ GF GC Puntos
1 Barcelona B Barcelona B 19 45 12 50
2 Cornella Sub 16 B Cornella 20 34 26 41
3 Cambrils UniÒ A Cambrils 19 31 13 38
4 La Floresta A Floresta 20 37 26 34
5 Castelldefels A Castelldefel 20 26 20 31
6 Escuela Fsan Pedro San Pabl Escuela Fsan 20 32 25 30
7 Sant Ildefons A Sant 19 25 19 28
8 Fundacio Jupiter B B Fundacio 20 29 27 26
9 Atletic Sant Just Sub 16 Atletic Sant 19 23 25 26
10 Santboia A Santboia A 20 21 23 25
11 Rapitenca B Rapitenca B 20 27 33 23
12 Gimnastic Tarragona C B Gimnastic 20 23 31 22
13 Escola Futbol Base Calafell Escola 20 14 26 18
14 Viladecans A Viladecans 20 30 43 18
15 Prat AE A Prat AE A 20 17 37 14
16 Marianao Poblet Sub 16 Marianao 20 16 44 12
TEMPORADA 2018/2019
PREFERENTE CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona Sub 16 B Barcelona 30 137 15 76
2 Fundación Reus Sub 16 Fundación 30 89 19 74
3 Cornella B Cornella B 30 69 47 53
4 Prat A Prat A 30 56 37 51
5 Nastic Tarragona Sub 16 B Nastic 30 52 48 48
6 Escuela San Pedro San Pablo Escuela 30 62 55 47
7 La Floresta Sub 16 Floresta 29 59 52 46
8 Castelldefels Sub 16 Castelldefel 30 64 61 43
9 Viladecans A Viladecans 30 52 74 43
10 Cambrils UniÒ A Cambrils 30 56 50 42
11 Marianao Poblet Sub 16 Marianao 29 40 49 34
12 Can Buxeres A Buxeres 30 37 53 34
13 L'Hospitalet Centre Esports L'Hospitalet 30 34 70 29
14 Piera A Piera A 30 44 74 23
15 Terlenka Barcelonista B Terlenka 30 33 97 20
16 Tortosa A Tortosa A 30 26 109 12
TEMPORADA 2017/2018
1ª CATALANA CADETE GRUPO 10
Equipo PJ GF GC Puntos
1 Marianao Poblet Sub 16 Marianao 30 115 29 75
2 Atletic Sant Just Sub 16 Atletic Sant 30 91 25 72
3 Ciudad Cooperativa A Ciudad 30 80 35 72
4 Atletic Vilafranca B Atletic 30 97 45 56
5 Cornella E Cornella E 29 56 48 54
6 Martorell B Martorell B 29 60 53 54
7 Efo 87 A Efo 87 A 29 57 49 45
8 Corbera A Corbera A 29 48 42 41
9 Fontsanta Fatjo A Fontsanta 29 46 66 31
10 Santfeliuenc B Santfeliuenc 29 36 71 29
11 Pª Blaugrana Vallirana B Blaugrana 29 57 80 28
12 Prat C Prat C 29 47 81 28
13 Castelldefels C Castelldefel 28 26 52 21
14 Cabrera A Cabrera A 29 38 73 21
15 Sant Andreu de la Barca A Sant Andreu 30 27 90 19
16 Vista Alegre A Vista Alegre 29 36 78 16
TEMPORADA 2016/2017
1ª CATALANA CADETE GRUPO 10
Equipo PJ GF GC Puntos
1 Cornella C Cornella C 30 125 16 88
2 Atletic Sant Just Sub 16 Atletic Sant 30 130 23 82
3 Ciudad Cooperativa A Ciudad 30 89 42 69
4 Almeda A Almeda A 30 62 46 55
5 Martorell B Martorell B 29 62 48 49
6 Sant Andreu de la Barca A Sant Andreu 30 55 51 44
7 Sant Joan Despi A Sant Joan D. 30 61 67 38
8 Santfeliuenc B Santfeliuenc 30 66 81 38
9 Escola Gava D Escola Gava 30 42 55 36
10 Efolesa 87 C A A Efolesa 30 68 81 35
11 Marianao Poblet Sub 16 Marianao 30 49 71 34
12 Barcelonista Terlenka CF Barcelonista 30 44 73 29
13 Barbera Andalucia A Barbera 30 56 85 27
14 Santboia A Santboia A 29 45 102 22
15 Molins de Rei A Molins 30 44 100 21
16 Palleja A Palleja A 30 27 84 15

  USO DE MEMORIA  
5,498,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0843
Total Execution Time  0.0855
  CADENA URL  
/historico/Marianao-Poblet-Ud-A-A-Cadete
  GET DATOS  
$_GET['/historico/Marianao-Poblet-Ud-A-A-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0026  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 = 'Marianao-Poblet-Ud-A-A-Cadete' 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.0018  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=93936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=93936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=93936 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=722 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 722 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (300290,143126,138013,111914) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '93936' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '93936' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '93936' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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=93936 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (74156) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74156 AND teamId = 93936
0.0021  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 = '93936' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '93936' and rp.type = 4
0.0020  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 = '93936' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 93936 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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_base` 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 = 74156 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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_base` 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 = 68630 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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_base` 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 = 64564 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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_base` 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 = 59253 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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_base` 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 = 52001 AND t.round = 30 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 `tables2019_base` 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 = 45999 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2018_base` 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 = 40123 AND t.round = 30 ORDER BY team.conference 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 `tables2017_base` 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 = 35168 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC