4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Esfubasa Sub 12
TEMPORADA 2023/2024
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 AD San José Sub 12 José 27 169 51 70
2 Tocina Los Rosales Sub 12 B Tocina 27 156 54 68
3 Municipal de Gerena Sub 12 Municipal 25 141 44 65
4 Esfubasa Sub 12 Esfubasa 27 176 58 63
5 Real Betis Sub 12 E Real Betis 27 158 54 61
6 Santiponce Sub 12 B Santiponce 27 108 71 53
7 Peñaflor Sub 12 Peñaflor 27 102 129 41
8 Triana Ar Rabad Sub 12 B Triana Rabad 26 78 71 34
9 Loreto Sub 12 Loreto 26 89 87 33
10 Lora Sub 12 B Lora 27 81 101 28
11 Algabeño Atlético Sub 12 C Algabeño 26 80 113 25
12 Camas Sub 12 B Camas 26 85 110 22
13 Centro Historico Sub 12 B Centro 27 70 153 17
14 Castilleja Sub 12 Castilleja 27 53 123 16
15 San Pablo Pino Sub 12 Pablo Pino 27 43 181 11
16 CD Rinconada Cantera Sub 12 Rinconada 23 18 207 4
TEMPORADA 2021/2022
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Peñaflor Sub 12 Peñaflor 26 149 42 65
2 Rinconada C. A Rinconada 26 128 52 62
3 Villaverde Villaverde 26 131 70 53
4 Brenes Balompie A Brenes 26 111 62 53
5 Minas Minas 26 106 56 51
6 Campana Campana 26 115 73 48
7 Esfubasa Sub 12 Esfubasa 26 115 73 47
8 AD San José Sub 12 José 26 92 79 36
9 Burguillos Burguillos 25 58 76 29
10 CD Multideporte Tocina Los Multideporte 26 74 116 24
11 A. Algabeño A Algabeño 26 51 102 18
12 Lora Lora 25 66 146 16
13 Priorato Juventud de Futbol Priorato 26 54 155 15
14 Alcolea Rio Alcolea Rio 26 33 181 9
TEMPORADA 2020/2021
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 7
Equipo PJ GF GC Puntos
1 A. Algabeño B Algabeño 23 186 62 61
2 Club Jorge Juan Antonio Ull Club Jorge. 22 153 40 60
3 Alcosa Polid. B Alcosa 24 125 64 51
4 AD San José Sub 12 José 24 108 53 49
5 San Pablo Pino Sub 12 Pablo Pino 23 80 67 41
6 Andalucía Este B Andalucía 24 75 90 36
7 Villaverde UD B Villaverde 24 84 82 34
8 Torreblanca B Torreblanca 24 98 79 31
9 CD Rinconada Cantera Sub 12 Rinconada 24 65 99 31
10 Campana Balompie B Campana 20 69 95 25
11 Esfubasa Sub 12 Esfubasa 23 63 136 13
12 Oduciarosal B Oduciarosal 23 46 131 13
13 Padre Pio B Padre Pio B 24 37 191 1
TEMPORADA 2019/2020
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 2
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 D Sevilla 23 255 24 69
2 Juventud Gines Sub 12 Juventud 23 134 51 60
3 Benacazon Benacazon 23 75 71 48
4 CD Tor Del Rey De Pilas Pilas 23 109 71 46
5 Atletico Sanlucar CF Atletico 23 90 77 39
6 Club Polideportivo Bormujos Club 23 80 74 39
7 Coria CF B Coria CF B 23 68 67 38
8 San Martin San Martin 23 66 97 34
9 UD Tomares Sub 12 Tomares 23 66 68 30
10 CD Carrion De Los Cespedes Carrion 23 57 87 29
11 Loreto Loreto 22 63 91 25
12 Esfubasa Sub 12 Esfubasa 22 61 92 24
13 CD FB Juventud Deportiva Pu Juventud 23 45 94 19
14 Mairena Del Aljarafe Sub 12 Mairena 23 40 119 12
15 CMD San Juan Juan 23 44 119 10
16 CD Rinconada Cantera Sub 12 Rinconada 23 42 103 5
TEMPORADA 2014/2015
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 5
Equipo PJ GF GC Puntos
1 Cantillana Cantillana 22 153 27 59
2 Alcolea Rio Alcolea Rio 22 192 55 49
3 La Negrilla A Negrilla 22 166 64 46
4 San Jose A San Jose A 22 163 66 43
5 Villaverde Villaverde 22 161 77 40
6 Esfubasa Sub 12 Esfubasa 22 107 53 40
7 Campana Campana 22 112 66 40
8 Brenes B. Brenes B. 22 126 61 35
9 C. Claret C C. Claret C 22 59 182 14
10 A. Algabeño B Algabeño 22 49 231 12
11 Alcala Rio B Alcala 22 52 230 10
12 Rinconada C. A Rinconada 22 22 250 1
13 R. Forja XXI Forja 0 0 0 0

  USO DE MEMORIA  
5,043,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0915
Total Execution Time  0.0927
  CADENA URL  
/historico/Cd-Esfubasa-Alevin
  GET DATOS  
$_GET['/historico/Cd-Esfubasa-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0029  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 = 'Cd-Esfubasa-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.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=44464 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=44464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 74479
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=44464 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=474 AND type_rel = 3
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 = '44464' ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '44464' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '44464' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 74479 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=44464 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (74479) 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.0020  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74479 AND teamId = 44464
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 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 = 74479 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  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 = '44464' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0026  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 = '44464' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 44464 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039  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 = 74479 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.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 `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 = 64770 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.0028  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 = 60611 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.0033  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 = 53976 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.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 `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 = 53958 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.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 `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 = 6912 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 74479 ORDER BY nameShow LIMIT 100