4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Castilleja Sub 8
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla Sub 8 Sevilla 28 244 16 84
2 UD Tomares Sub 8 Tomares 28 153 57 71
3 Real Betis Balompie Sub 8 Real Betis. 27 175 46 69
4 AAVV Centro Histórico Sub 8 AAVV Centro 27 107 79 55
5 San Roque Balompie Sub 8 Roque 27 112 65 53
6 Castilleja Sub 8 Castilleja 28 80 81 45
7 Coria CF Sub 8 Coria 28 92 109 45
8 Umbrete Sub 8 Umbrete 28 82 96 41
9 Camas Sub 8 Camas Sub 8 26 70 77 33
10 AD Dani Triana Sub 8 Dani Triana 28 79 116 30
11 Lora CF Sub 8 Lora 27 73 121 23
12 Calavera CF Sub 8 Calavera 28 53 107 22
13 Loreto Sub 8 Loreto 28 54 143 20
14 Atlético Algabeño Sub 8 Atlético 28 44 121 16
15 Colegio Claret Sub 8 Colegio 28 71 173 16
16 Juventud Dva. Gines Sub 8 Juventud 28 40 122 12
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 30 255 11 90
2 UD Tomares Sub 8 Tomares 29 156 80 70
3 Sevilla Sub 8 B Sevilla 30 136 74 63
4 San Roque Balompie Sub 8 Roque 30 143 69 57
5 Umbrete Sub 8 Umbrete 30 107 82 57
6 Camas Sub 8 Camas Sub 8 30 114 77 55
7 Loreto Sub 8 Loreto 30 92 70 51
8 Coria CF Sub 8 Coria 30 137 102 49
9 David Castedo 3 (DC 3) David 30 110 128 43
10 Lora CF Sub 8 Lora 30 89 128 37
11 Montequinto Sub 8 Montequinto 30 98 104 36
12 Castilleja Sub 8 Castilleja 30 82 128 28
13 SAM-CAM Dos Hermanas Sub 8 SAM-CAM 30 84 145 26
14 Cud Santiponce Sub 10 Santiponce 29 69 182 13
15 Municipal de Gerena Sub 10 Municipal 30 49 230 9
16 CD Esfubasa Sub 10 Esfubasa 30 52 203 7
TEMPORADA 2021/2022
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Cud Santiponce Sub 10 Santiponce 30 138 47 75
2 CD Atlético San Martin Atlético 30 130 52 72
3 Umbrete Sub 8 Umbrete 30 135 67 68
4 Albaida benjamin a Albaida 30 110 87 57
5 Juventud Gines Juventud 29 107 68 53
6 Atletico Sanlucar CF Atletico 30 109 85 50
7 Tomares B Tomares B 30 92 78 49
8 CD FB Juventud Deportiva Juventud 30 105 95 48
9 Tor del Rey de Pilas Pilas 30 97 101 42
10 Camino Viejo A Camino Viejo 30 101 110 40
11 Villafranco Villafranco 30 94 101 36
12 Camas Sub 8 Camas Sub 8 30 64 86 34
13 Mairena del Aljarafe Sub 10 Mairena 30 88 114 34
14 Castilleja Sub 8 Castilleja 29 63 144 19
15 AAVV Centro Histórico Sub 8 AAVV Centro 30 46 132 10
16 Benacazon Benacazon 30 34 146 7
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 5
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 10 81 8 30
2 Sevilla A Sevilla A 10 81 13 24
3 Castilleja Sub 8 Castilleja 10 38 36 22
4 Tomares A Tomares A 10 29 28 18
5 Coria CF Sub 8 Coria 10 27 30 11
6 San Roque Balompie A Roque 10 26 32 11
7 CD San Pablo Pino Montano A Pablo Pino. 10 16 34 11
8 Lora CF Sub 8 Lora 10 28 60 9
9 AAVV Centro Histórico Sub 8 AAVV Centro 10 15 64 4
10 Torreblanca Torreblanca 10 15 51 3
TEMPORADA 2019/2020
2ª SEVILLA BENJAMIN (2ª FASE) GRUPO 4
Equipo PJ GF GC Puntos
1 UP Viso Graphenstone Viso 9 58 14 24
2 Castilleja Sub 8 Castilleja 9 46 24 21
3 La Barrera La Barrera 9 32 24 18
4 CD Esfubasa Sub 10 Esfubasa 9 32 24 16
5 CD David Castedo 3 (dc 3) David 9 19 32 10
6 San Martin San Martin 9 21 35 8
7 CD Antonio Puerta A Antonio 9 16 34 8
8 Mosqueo Mosqueo 9 12 49 0
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 14 166 7 42
2 Coria CF Sub 8 Coria 14 55 42 31
3 Tomares Tomares 14 68 38 25
4 Castilleja Sub 8 Castilleja 14 63 48 24
5 Camas Sub 8 Camas Sub 8 14 49 46 22
6 San Martin San Martin 14 28 57 11
7 Olivarense Atletico Olivarense 14 30 104 7
8 Loreto Sub 8 Loreto 14 20 137 3
TEMPORADA 2017/2018
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 28 232 43 81
2 Castilleja Sub 8 Castilleja 28 138 60 66
3 Olivarense Atletico Olivarense 28 111 40 66
4 Tor del Rey de Pilas Pilas 28 133 92 55
5 Benacazon Benacazon 28 92 60 53
6 Espartinas Tilde Espartinas 28 130 80 52
7 Juventud Gines Juventud 28 113 74 50
8 Club Polideportivo Bormujos Club 28 77 72 40
9 Camino Viejo Camino Viejo 28 83 116 34
10 Mairena del Aljarafe Sub 10 Mairena 28 87 154 27
11 Camas Sub 10 B Camas 28 63 119 26
12 Umbrete Sub 8 Umbrete 28 74 112 25
13 Futbol Base Juv de La Puebl Futbol Base 28 63 140 20
14 Gelves Gelves 28 60 122 17
15 Circulo Don Bosco Circulo 28 27 199 0
TEMPORADA 2016/2017
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Loreto Sub 8 Loreto 30 202 48 88
2 Villafranco Villafranco 30 157 36 77
3 Castilleja Sub 8 Castilleja 30 143 51 70
4 Mairena del Aljarafe Sub 10 Mairena 30 153 69 64
5 San Roque Balompie Sub 8 Roque 30 127 73 56
6 Tor del Rey de Pilas Pilas 30 151 100 56
7 Camino Viejo Camino Viejo 30 110 102 52
8 Umbrete A Umbrete A 30 120 85 50
9 Benacazon A Benacazon A 30 92 91 45
10 Camas A Camas A 30 79 110 31
11 Juventud Gines Juventud 30 99 119 30
12 Betisevilla Betisevilla 30 101 160 27
13 Guillena Sub 10 Guillena 30 64 163 15
14 Tomares Tomares 30 55 188 14
15 Atletico Libertad A Atletico 30 48 201 12
16 CD Esfubasa B Esfubasa 30 62 167 11

  USO DE MEMORIA  
5,341,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4216
Total Execution Time  0.4228
  CADENA URL  
/historico/Castilleja-Cf-Benjamin
  GET DATOS  
$_GET['/historico/Castilleja-Cf-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0113  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 = 'Castilleja-Cf-Benjamin' 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.0105  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=92923 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=92923 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92923 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=855 AND type_rel = 3
0.0109  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 = '92923' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0107  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 = '92923' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 74452 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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=92923 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (74452) 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.0106  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74452 AND teamId = 92923
0.0106  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 = 74452 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '92923' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '92923' and rp.type = 4
0.0106  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 = '92923' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0109  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 = 92923 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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 = 74452 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 69680 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.0109  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 = 64499 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 64504 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.0108  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 = 60680 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 60704 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.0108  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 = 60785 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 62291 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.0110  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 = 54036 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.0108  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 = 53312 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 55282 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 44980 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 42873 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 34854 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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 = 74452 ORDER BY nameShow LIMIT 100