4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Nastic Tarragona Sub 16 B
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 26 50 19 60
3 La Floresta Sub 16 Floresta 26 53 25 54
4 Nastic Tarragona Sub 16 B Nastic 26 59 32 54
5 Cornella Sub 16 B Cornella 26 50 30 53
6 Amposta Sub 16 Amposta 26 35 34 43
7 Martorell Sub 16 Martorell 26 48 34 40
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 26 30 45 29
12 Calafell Sub 16 Calafell 26 52 73 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 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
PREFERENTE CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona Sub 16 B Barcelona 30 111 24 76
2 Nastic Tarragona Sub 16 B Nastic 29 56 38 56
3 Sant Ildefons A Sant 30 64 42 54
4 Rapitenca Sub 16 Rapitenca 30 53 39 54
5 Cornella B Cornella B 30 55 38 52
6 Barcelonista Terlenka A Barcelonista 30 58 43 51
7 Viladecans A Viladecans 30 51 46 48
8 Prat A Prat A 29 58 62 42
9 Castelldefels Sub 16 Castelldefel 30 39 41 41
10 Reus Deportiu B Reus 29 43 56 40
11 La Floresta Sub 16 Floresta 30 52 55 39
12 Cambrils Unio Sub 16 Cambrils 29 36 49 35
13 Vilanova Geltru A Vilanova 29 48 75 31
14 Gava Mar B Gava Mar B 30 33 59 25
15 Martorell Sub 16 Martorell 29 37 70 23
16 Segre Sub 16 Segre 30 27 84 7
TEMPORADA 2016/2017
PREFERENTE CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona Sub 16 B Barcelona 30 134 16 85
2 Fundación Reus Sub 16 Fundación 30 73 27 61
3 Cornella B Cornella B 30 66 30 61
4 Vilanova Geltru A Vilanova 30 57 50 45
5 Martorell Sub 16 Martorell 30 54 49 45
6 Prat A Prat A 30 47 45 43
7 Gava C Gava C 30 48 57 43
8 Castelldefels Sub 16 Castelldefel 29 32 27 41
9 Barcelonista Terlenka A Barcelonista 30 41 44 40
10 Nastic Tarragona Sub 16 B Nastic 30 40 45 40
11 Segre B Segre B 30 47 56 38
12 La Floresta Sub 16 Floresta 29 32 52 34
13 Escola de Futbol Bellpuig A Escola 30 32 52 33
14 Calafell Sub 16 Calafell 29 36 81 23
15 Atletic Vilafranca Sub 16 Atletic 29 31 66 22
16 Tortosa A Tortosa A 30 19 92 9
TEMPORADA 2015/2016
PREFERENTE CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona Sub 16 B Barcelona 30 136 23 83
2 Rapitenca Sub 16 Rapitenca 29 64 23 69
3 La Floresta Sub 16 Floresta 30 50 21 65
4 Fundación Reus Sub 16 Fundación 30 42 21 55
5 Sabadell Sub 16 B Sabadell 29 65 40 48
6 Vilanova Geltru A Vilanova 29 63 57 43
7 Atletic Vilafranca Sub 16 Atletic 29 41 48 41
8 Escola Valls Sub 16 Escola Valls 30 57 70 41
9 Castelldefels Sub 16 Castelldefel 30 59 56 39
10 Martorell Sub 16 Martorell 30 43 52 35
11 Gava C Gava C 30 47 60 35
12 Nastic Tarragona Sub 16 B Nastic 30 50 73 34
13 Blanca Subur A Blanca Subur 30 45 51 31
14 Mariano Poblet A Mariano 29 26 60 25
15 Asco A Asco A 30 40 101 20
16 Bordeta de Lleida B Bordeta 29 28 100 12
TEMPORADA 2014/2015
PREFERENTE CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona Sub 16 B Barcelona 30 129 21 82
2 Cornella C Cornella C 30 76 34 62
3 Prat A Prat A 30 75 36 60
4 Fundación Reus Sub 16 Fundación 30 48 26 58
5 Vilanova Geltru A Vilanova 30 76 50 50
6 Sabadell Sub 16 B Sabadell 30 68 58 48
7 La Floresta Sub 16 Floresta 30 47 54 46
8 Gava Sub 16 B Gava 30 55 54 44
9 Martorell Sub 16 Martorell 30 58 56 43
10 Mariano Poblet A Mariano 30 48 48 39
11 Rapitenca B Rapitenca B 30 37 62 38
12 Nastic Tarragona Sub 16 B Nastic 30 35 46 36
13 Sant Joan Despi A Sant Joan D. 30 50 73 28
14 Salou A Salou A 30 40 82 22
15 Tortosa A Tortosa A 30 30 93 18
16 La Cava A La Cava A 30 22 101 10

  USO DE MEMORIA  
5,512,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5637
Total Execution Time  0.5649
  CADENA URL  
/historico/Gimnastic-Tarragona-B-Cadete
  GET DATOS  
$_GET['/historico/Gimnastic-Tarragona-B-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0153  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 = 'Gimnastic-Tarragona-B-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.0144  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=21307 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=21307 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0315  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 = 74156
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=21307 AND type_rel = 2
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=722 AND type_rel = 3
0.0158  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.0165  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.0147  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 = '21307' ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '21307' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0159  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 = '21307' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0159  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 = 74156 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0160  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=21307 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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.0146  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74156 AND teamId = 21307
0.0145  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 = 74156 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '21307' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '21307' and rp.type = 4
0.0146  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 = '21307' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 21307 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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.0147  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.0148  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.0148  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.0149  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 = 40128 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 34321 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2016_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 = 17241 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables2015` 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 = 4546 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 74156 ORDER BY nameShow LIMIT 100