4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Castilleja Sub 12
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 28 183 36 73
2 Sevilla Sub 12 B Sevilla 28 167 39 73
3 Doctor Fleming Sub 12 Doctor 28 117 40 65
4 Castilleja Sub 12 Castilleja 28 101 47 65
5 Camas CF Sub 12 Camas 28 115 61 54
6 San Roque Balompie Sub 12 Roque 28 111 72 50
7 Coria Sub 12 Coria 28 126 81 49
8 Juventud Gines Sub 12 Juventud 28 112 83 47
9 Umbrete Sub 12 Umbrete 28 105 89 40
10 Tomares Sub 12 B Tomares 28 90 125 30
11 Atletico Sanlucar Sub 12 Atletico 28 85 89 27
12 Montequinto Sub 12 Montequinto 28 63 136 27
13 Guillena Sub 12 Guillena 28 40 142 16
14 La Liara Sub 12 Liara 28 40 128 15
15 El Pilar Sub 12 Pilar 28 34 167 7
16 Mairena Del Aljarafe Sub 12 Mairena 28 51 205 6
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 30 207 34 85
2 Sevilla Sub 12 B Sevilla 30 137 54 69
3 Tomares Sub 12 B Tomares 30 96 48 68
4 Castilleja Sub 12 Castilleja 30 100 55 64
5 San Roque Balompié Sub 12 B Roque 30 99 74 58
6 Camas CF Sub 12 Camas 30 88 92 49
7 Montequinto Sub 12 Montequinto 30 87 101 40
8 La Liara Sub 12 Liara 30 108 125 38
9 Coria Sub 12 Coria 30 87 99 36
10 Doctor Fleming Sub 12 Doctor 30 77 117 33
11 Umbrete Sub 12 Umbrete 30 68 97 31
12 Juventud Gines Sub 12 Juventud 30 56 98 30
13 Mairena Del Aljarafe Sub 12 Mairena 30 78 113 29
14 Lora Lora 30 68 122 25
15 Sededos Sededos 30 45 83 24
16 Atlético Algabeño Atlético 30 33 122 11
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 30 169 24 85
2 San Roque Balompie Sub 12 Roque 29 183 43 76
3 Sevilla Sub 12 Sevilla 30 149 66 66
4 Montequinto Sub 12 Montequinto 30 101 73 54
5 Coria Sub 12 Coria 30 93 67 53
6 Tomares Sub 12 Tomares 30 108 57 52
7 Juventud Gines Sub 12 Juventud 30 104 97 48
8 Castilleja Sub 12 Castilleja 30 94 113 39
9 Camas A Camas A 29 80 112 35
10 C. Claret A C. Claret A 30 88 123 29
11 AD Dani Triana Ar Rabad A Dani Triana 30 67 123 29
12 Umbrete Sub 12 Umbrete 30 60 139 27
13 Bellavista A Bellavista 30 64 149 25
14 Asociación Nervion Sub 12 B Asociación 30 68 123 24
15 Sededos Sededos 28 62 89 23
16 Atlético Antoniano Atlético 30 54 146 18
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 7
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 10 70 3 30
2 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 10 46 13 27
3 Tomares Sub 12 Tomares 10 32 27 19
4 Sevilla Sub 12 B Sevilla 10 32 23 18
5 Tomares Sub 12 B Tomares 10 18 20 14
6 San Roque Balompie Sub 12 Roque 10 23 30 12
7 Castilleja Sub 12 Castilleja 10 19 44 10
8 CD Antonio Puerta Sub 12 Antonio 10 23 52 10
9 Camas A Camas A 10 21 47 4
10 Centro Historico Sub 12 Centro 10 15 40 1
TEMPORADA 2019/2020
2ª SEVILLA ALEVÍN (2ª FASE) GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 9 70 6 24
2 Coria Sub 12 Coria 9 28 17 21
3 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 9 38 15 20
4 Viso Graphenstone Viso 9 27 40 12
5 Mosquito Sub 12 Mosquito 9 27 39 11
6 Centro Historico Sub 12 Centro 9 17 34 7
7 Castilleja Sub 12 Castilleja 9 18 48 7
8 San Roque Balompie Sub 12 Roque 9 12 38 3
TEMPORADA 2018/2019
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 2
Equipo PJ GF GC Puntos
1 Coria CF B Coria CF B 30 167 42 87
2 Real Betis Sub 12 D Real Betis 30 198 37 79
3 Camas Camas 30 180 55 72
4 Castilleja Sub 12 Castilleja 30 166 71 63
5 Aca. Ugena Aca. Ugena 30 137 81 54
6 CP Bormujos CP Bormujos 30 130 90 54
7 Tor del Rey de Pilas Pilas 30 143 112 51
8 Dc3 Carrion Dc3 Carrion 30 141 121 48
9 FBJ de La Puebla del Rio Puebla 30 105 126 37
10 Juventud Gines Sub 12 Juventud 30 93 126 34
11 Benacazon Benacazon 30 85 124 31
12 CMD San Juan A Juan 30 119 170 30
13 Mairena del Aljarafe Mairena 30 127 201 29
14 Espartinas Tilde Espartinas 30 70 154 19
15 Nueva Sevilla Nueva 30 51 195 8
16 Gelves Gelves 30 48 255 4
TEMPORADA 2017/2018
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 30 255 27 90
2 Umbrete B Umbrete B 30 179 52 74
3 Betisevilla Betisevilla 30 131 86 66
4 Coria CF B Coria CF B 30 144 73 65
5 CMD San Juan A Juan 30 103 70 57
6 Juventud Gines Sub 12 Juventud 30 118 80 54
7 Nueva Sevilla Nueva 30 120 109 50
8 FBJ de La Puebla del Rio Puebla 30 109 103 40
9 Gelves Gelves 30 75 149 34
10 Mairena del Aljarafe Mairena 30 118 155 32
11 Castilleja Sub 12 Castilleja 30 93 130 31
12 Tor del Rey de Pilas Pilas 30 120 153 30
13 Benacazon Benacazon 30 126 176 30
14 A. Grosso A. Grosso 30 72 142 28
15 Tomares Tomares 30 72 204 11
16 A. Aznalcazar Aznalcazar 30 49 211 4
TEMPORADA 2016/2017
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 D Real Betis 28 209 25 84
2 Tomares Tomares 28 122 72 58
3 Mun. Gerena Mun. Gerena 28 124 75 58
4 Coria CF B Coria CF B 28 112 53 51
5 Castilleja Sub 12 Castilleja 28 123 65 51
6 Camas Camas 28 90 79 49
7 Juventud Gines Sub 12 Juventud 28 110 82 45
8 Guillena Sub 12 Guillena 28 83 89 40
9 Juan Puerto Juan Puerto 28 94 101 39
10 Umbrete Sub 12 Umbrete 28 107 114 38
11 A. Aznalcazar Aznalcazar 28 96 149 31
12 Betisevilla Betisevilla 28 93 128 28
13 Gelves Gelves 28 52 139 19
14 Calavera B Calavera B 28 60 184 11
15 M. Aljarafe A Aljarafe 28 52 172 3
TEMPORADA 2015/2016
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Centro Historico AAVV A Centro 27 186 38 76
2 M. Aljarafe C Aljarafe 28 215 56 73
3 Castilleja Sub 12 Castilleja 27 141 29 65
4 Rey de Pilas A Pilas 27 126 75 54
5 CMD San Juan A Juan 28 117 83 47
6 At. Libertad A Libertad 27 152 103 43
7 Villafranco Villafranco 27 131 94 43
8 Aca. Ugena Aca. Ugena 28 114 108 38
9 FBJ de La Puebla del Rio Puebla 27 116 101 36
10 San Martin San Martin 28 103 97 36
11 Tomares C Tomares C 28 112 120 32
12 Camino Viejo C.F. 'C' Camino Viejo 27 102 163 25
13 Benacazon Benacazon 27 81 126 18
14 Gelves C Gelves C 27 46 255 3
15 Santiponce Santiponce 0 0 0 0
16 Palomares J. Palomares 19 17 255 0
TEMPORADA 2014/2015
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 2
Equipo PJ GF GC Puntos
1 A. Aznalcazar Aznalcazar 24 152 26 69
2 Castilleja Sub 12 Castilleja 24 135 31 63
3 Puebla Puebla 24 152 50 60
4 M. Aljarafe B Aljarafe 24 201 53 55
5 Villafranco Villafranco 24 97 49 45
6 N. Sevilla A Sevilla 24 86 75 32
7 Benacazon A Benacazon A 24 72 91 30
8 Betisevilla Betisevilla 24 96 104 29
9 Aca. Ugena Aca. Ugena 24 58 75 27
10 C.D. BORMUJOS S.M. C.D. 24 61 87 24
11 Tomares C Tomares C 24 62 128 21
12 Almensilla Almensilla 24 26 198 3
13 Rey de Pilas B Pilas 24 26 255 3
14 Palomares J. Palomares 0 0 0 0

  USO DE MEMORIA  
5,639,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  2.9642
Total Execution Time  2.9656
  CADENA URL  
/historico/Castilleja-Cf-Alevin
  GET DATOS  
$_GET['/historico/Castilleja-Cf-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.3320  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-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=92678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=92678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 74449
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92678 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=470 AND type_rel = 3
0.1715  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 470 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0656  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 (658127,72746) ORDER BY n.cover_points DESC, update_date DESC
0.1082  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 = '92678' ORDER BY l.year DESC,cat.coefficient DESC
0.1126  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 = '92678' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.1244  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 = '92678' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0263  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 = 74449 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.2128  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=92678 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0089  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 (74449) 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.0224  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74449 AND teamId = 92678
0.0498  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 = '92678' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0566  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '92678' and rp.type = 4
0.0083  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 = '92678' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0932  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 = 92678 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.1951  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 = 74449 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.0947  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 = 69673 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.1014  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 = 64479 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.0593  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 = 60531 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.0748  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 = 62289 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.0308  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 = 53215 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.0530  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 = 55287 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.1623  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 = 45017 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2549  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 = 42085 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2476  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 = 34773 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1876  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 = 17913 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0600  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 = 6909 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC