4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Esparreguera A
TEMPORADA 2021/2022
2ª CATALANA ALEVIN GRUPO 1
Equipo PJ GF GC Puntos
1 Palleja CF A Palleja 25 164 51 69
2 Abrera Abrera 23 111 27 60
3 Sant Andreu de la Barca A Sant Andreu 27 115 71 54
4 Corbera CF A Corbera 25 113 62 50
5 San Mauro A San Mauro A 23 121 48 47
6 Anoia A Anoia A 26 93 102 42
7 Molins de Rei A Molins 25 89 86 38
8 Martorell Associacio Esport Martorell 26 81 70 37
9 Odena A Odena A 25 79 86 37
10 Sant Esteve Sesrovires A Sant Esteve 28 92 125 29
11 Fundacio Atletic Vilafranca Fundacio 22 57 95 24
12 Escola Gava C H Escola Gava 26 73 115 24
13 Igualada CF F Igualada 25 69 110 19
14 Esparreguera A Esparreguera 25 45 123 11
15 EF Olesa 87 C A Olesa 25 33 164 7
TEMPORADA 2019/2020
3ª CATALANA ALEVIN GRUPO 55
Equipo PJ GF GC Puntos
1 Sporting Gava 2013 Futbol C Sporting 16 179 24 48
2 Escola Gava I Escola Gava 16 137 29 40
3 Viladecans D Viladecans 16 108 42 40
4 Atletic Sant Just C E Atletic Sant 16 114 48 35
5 Marianao Poblet E Marianao 17 77 98 29
6 Begues B Begues B 16 61 45 28
7 Esparreguera A Esparreguera 17 98 83 25
8 Santfeliuenc E Santfeliuenc 17 88 72 24
9 Colegio Aleman Salberto A Colegio 17 73 57 23
10 Sant Joan Despi C Sant Joan D. 16 60 57 19
11 Athletic Viladecans Athletic 16 38 73 17
12 Fundacio Unio Esportiva Cor Fundacio 16 47 89 14
13 Fontsanta Fatjo D Fontsanta 17 19 140 6
14 Castelldefels J Castelldefel 17 24 151 5
15 Can Vidalet CF F Vidalet 12 12 127 1
TEMPORADA 2018/2019
2ª CATALANA ALEVIN GRUPO 2
Equipo PJ GF GC Puntos
1 Santfeliuenc B Santfeliuenc 30 163 44 77
2 Martorell Associacio Esport Martorell 30 143 58 68
3 Olesa 87 C B Olesa 29 140 62 67
4 Fundacio Unio Esportiva Cor Fundacio 30 131 58 64
5 Corbera A Corbera A 30 137 58 60
6 Sant Sadurni B Sant Sadurni 30 126 65 58
7 Molins de Rei A Molins 29 135 99 52
8 Igualada F Igualada F 30 128 90 49
9 Abrera Abrera 30 142 105 49
10 Pª Barc Sant Feliu Llobrega Barc Sant F. 30 83 101 38
11 Pª Barc Sant Vicenç Horts Pª Barc Sa. 29 107 145 33
12 Pª Blaugrana Vallirana B Blaugrana 29 68 109 25
13 Sant Andreu de La Barca Agr Sant Andreu 30 83 137 22
14 Sant Esteve Sesrovires A Sant Esteve 30 88 228 15
15 Esparreguera A Esparreguera 30 54 151 13
16 Sant Vicenç Assoc Esportiva Sant Vicenç 30 49 255 3
TEMPORADA 2017/2018
3ª CATALANA ALEVIN GRUPO 52
Equipo PJ GF GC Puntos
1 Sant Andreu de La Barca Agr Sant Andreu 30 255 46 84
2 Esparreguera A Esparreguera 30 216 53 84
3 Sporting Gava 2013 Futbol C Sporting 29 184 57 71
4 Can Vidalet B Vidalet 30 196 72 68
5 Sector Montserratina E Sector 30 132 105 53
6 Sant VicenÇ Assoc Esportiv Sant 30 117 129 50
7 Atletic Sant Just C E Atletic Sant 30 124 105 46
8 Fundacio Unio Esportiva Cor Fundacio 29 111 109 44
9 Marianao Poblet C Marianao 30 104 107 44
10 Terlenka Barcelonista Club Terlenka 30 114 120 42
11 Vista Alegre C Vista Alegre 30 114 138 37
12 Escola Esportiva Llor B Escola 30 105 170 28
13 Vinyets Moli Vell E Vinyets Moli 30 81 164 21
14 Sant Just Desvern Club Futb Sant Just D. 30 62 148 20
15 Sant Ildefons D Sant 30 70 248 7
16 Santfeliuenc F Santfeliuenc 30 34 255 7
TEMPORADA 2016/2017
3ª CATALANA ALEVIN GRUPO 48
Equipo PJ GF GC Puntos
1 Espluguenc B Espluguenc 30 255 27 86
2 Pª Blanc Blava Sant Feliu Pª Blanc 30 218 36 83
3 Levante las Planas A Levante 30 246 38 81
4 Esparreguera A Esparreguera 29 164 54 69
5 Viladecans Viladecans 30 167 83 60
6 Santboia D Santboia D 30 176 88 56
7 Efo 87 D Efo 87 D 30 173 98 53
8 Begues D Begues D 30 136 104 46
9 Sporting Gava 2013 Futbol C Sporting 30 87 110 38
10 Santfeliuenc E Santfeliuenc 30 63 191 28
11 Martorell Associacio Esport Martorell 30 72 172 24
12 Escola Esportiva Llor A Escola 30 80 177 20
13 Sant VicenÇ Dels Horts 201 Sant 30 60 198 20
14 Castelldefels I Castelldefel 30 75 163 17
15 Sant Joan Despi G Sant Joan D. 29 54 196 17
16 Sant Lluis Associació Espor Sant Lluis. 28 30 255 3
TEMPORADA 2015/2016
3ª CATALANA ALEVIN GRUPO 14
Equipo PJ GF GC Puntos
1 Pª Blaugrana Vallirana B Blaugrana 30 200 44 85
2 PB Cervello A Cervello 30 164 57 82
3 Abrera Abrera 30 178 53 69
4 Pª Barc Sant Vicenç Horts B Barc Sant V. 30 158 75 68
5 Santfeliuenc B Santfeliuenc 30 133 68 61
6 Corbera B Corbera B 30 144 107 51
7 Sant Vicenç Assoc Esportiva Sant Vicenç 30 123 96 48
8 Sant Andreu de La Barca Agr Sant Andreu 30 86 108 46
9 Esparreguera A Esparreguera 30 108 107 41
10 Incresa Atletico Club Futbo Incresa 30 106 107 40
11 Esport Base del Papiol A Esport Base 30 118 127 34
12 Agora Masia Bach A Agora Masia 30 87 116 33
13 Martorell Associacio Esport Martorell 30 78 130 22
14 Molins de Rei B Molins 30 64 154 21
15 Palleja C Palleja C 30 37 249 6
16 Efo 87 D Efo 87 D 30 30 216 0

  USO DE MEMORIA  
5,206,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.5390
Total Execution Time  0.5405
  CADENA URL  
/historico/Esparreguera-Ce-A-Alevin
  GET DATOS  
$_GET['/historico/Esparreguera-Ce-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0148  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 = 'Esparreguera-Ce-A-Alevin' 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.0154  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 = 'Esparreguera-Ce-A-Alevin' 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=73463 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=73463 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=73463 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=73463 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=73463 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=73463 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=73463 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0175  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 = 65783
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=73463 AND type_rel = 2
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=911 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 911 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0146  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 (1130610,997097,728077,726221) 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 = '73463' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '73463' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = '73463' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 65783 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=73463 AND l.year in (2021,2022,2023) 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 (65783) 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.0147  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65783 AND teamId = 73463
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 65783 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = 73463 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 65783 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.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 `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 = 51777 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 = 46594 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 = 41470 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 36152 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 17805 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC