4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Real Betis Sub 12 D
TEMPORADA 2023/2024
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Aficionado de Ecija Sub 12 Aficionado 26 160 25 76
2 Asociación Nervion Sub 12 B Asociación 26 139 51 60
3 Altair Sub 12 Altair 26 132 69 57
4 Sevilla Sub 12 D Sevilla 26 102 69 49
5 Viso Sub 12 B Viso 26 88 64 49
6 Estepa Industrial CD Sub 12 Estepa 26 110 110 48
7 San Roque Sub 12 D Roque 26 126 64 44
8 Real Betis Sub 12 D Real Betis 26 93 78 42
9 AD Dani Triana Sub 12 Dani Triana 26 90 84 38
10 Carmona Sub 12 Carmona 26 76 59 35
11 Peloteros S. Sur Sub 12 B Peloteros 26 79 103 27
12 CD Alcala Sub 12 B Alcala 26 65 101 22
13 Lora Sub 12 Lora Sub 12 26 50 130 18
14 Mosquito Sub 12 B Mosquito 26 51 137 16
15 Puebla Cazalla Sub 12 Puebla 26 46 95 14
16 Centro Historico Sub 12 B Centro 26 42 210 7
TEMPORADA 2022/2023
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 D Real Betis 24 220 24 67
2 San Roque Sub 12 D Roque 24 113 54 52
3 Bellavista Sub 12 Bellavista 24 115 67 51
4 La Union del Porvenir Union 24 125 94 50
5 Andalucia Este Andalucia 24 101 46 48
6 Asociación Nervion Sub 12 B Asociación 24 114 54 46
7 Torreblanca Torreblanca 24 84 74 38
8 Centro Historico Sub 12 B Centro 24 68 119 23
9 San Pablo Pino Sub 12 Pablo Pino 24 59 116 17
10 AD Cerro Del Aguila Cerro Aguila 24 48 125 16
11 CD Alcala Sub 12 B Alcala 24 49 153 16
12 Viso Sub 12 B Viso 24 38 142 15
13 SAM-CAM Dos Hermanas B SAM-CAM 24 28 94 11
TEMPORADA 2021/2022
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Peloteros Sierra Sur Sub 12 Peloteros 26 182 42 73
2 Real Betis Sub 12 D Real Betis 26 196 32 68
3 CD Alcala CD Alcala 26 111 69 50
4 Estilo de Futbol de Utrera Estilo 26 103 114 50
5 Puebla Cazalla Sub 12 Puebla 26 100 74 45
6 Carmona Sub 12 Carmona 26 92 54 44
7 Viso A Viso A 26 101 77 43
8 Mosquito A Mosquito A 26 90 78 34
9 Ciudad de Moron Ciudad Moron 26 94 92 31
10 CD Atletico Oromana Atletico 26 101 119 30
11 Utrera A Utrera A 26 85 101 29
12 Consolacion B Consolacion 26 79 138 22
13 CD Mairena CD Mairena 26 40 135 14
14 Pablo VI Pablo VI 26 17 255 0
TEMPORADA 2020/2021
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Montequinto Sub 12 Montequinto 22 158 25 61
2 CD David Castedo 3 (dc 3) David 22 149 38 60
3 Paradas Balompie B Paradas 22 153 74 49
4 Estilo de Futbol de Utrera Estilo 22 125 72 41
5 Mosquito C Mosquito C 22 87 66 40
6 Real Betis Sub 12 D Real Betis 22 125 83 35
7 Cantera de Utrera Cantera 22 133 107 33
8 Miguel De Unamuno C Miguel 22 122 132 28
9 C Atlético Antoniano C Atlético 22 92 144 21
10 C.D. Utrera C.D. Utrera 22 92 193 12
11 Tinte de Utrera Tinte Utrera 22 57 187 6
12 CD San Alberto Magno Alberto 22 44 216 6
13 CD Escuelas Los Molares Escuelas 0 0 0 0
TEMPORADA 2019/2020
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 D Real Betis 23 161 39 69
2 Estepa Industrial CD Sub 12 Estepa 23 101 37 61
3 Torreblanca Torreblanca 23 87 52 56
4 CD Alcala CD Alcala 23 73 45 44
5 CD Atletico Oromana Atletico 23 95 81 38
6 CD Los Caminantes Caminantes 23 72 62 35
7 Montequinto Sub 12 Montequinto 23 72 78 35
8 Centro Historico Sub 12 B Centro 23 89 97 32
9 Osuna Bote Club Sub 12 Osuna Bote. 23 75 81 29
10 Mosquito Sub 12 Mosquito 23 97 81 27
11 La Barrera Sub 12 Barrera 23 71 83 23
12 P. Pio Gorra Gorra 23 82 108 22
13 Carmona Sub 12 Carmona 23 64 129 20
14 Viso A Viso A 23 47 86 15
15 Madre de Dios Madre Dios 23 61 122 15
16 Lora Lora 23 48 114 15
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 3
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 D Real Betis 30 255 39 86
2 Aficionado de Ecija Sub 12 Aficionado 30 221 47 81
3 Estepa Industrial Estepa 30 130 69 67
4 Osuna Bote Club Sub 12 Osuna Bote. 30 146 120 57
5 Centro Historico AAVV A Centro 30 107 67 56
6 Calavera A Calavera A 30 154 103 54
7 CD Antonio Puerta B Antonio 30 103 101 47
8 Circulo Don Bosco Circulo 30 108 107 46
9 Alcosa Polid. Alcosa 30 91 101 44
10 San Pablo Pino Sub 12 Pablo Pino 30 97 121 40
11 Tabladilla Tabladilla 30 104 144 39
12 Andalucia Este A Andalucia 30 102 108 35
13 Sevilla 3000 Sevilla 3000 30 75 178 21
14 An Andalis An Andalis 30 50 190 13
15 Pino Montano Pino Montano 30 46 169 8
16 Los Mares Los Mares 30 40 186 1
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 6
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 D Real Betis 26 255 15 78
2 P. Pio Gorra Gorra 26 164 59 65
3 Bellavista B Bellavista 26 172 51 64
4 Los Mares Los Mares 26 140 77 58
5 Circulo Don Bosco Circulo 26 178 92 54
6 Club Deportivo Eloy Angulo Club 26 131 146 41
7 Polideportivo Alcosa C Polideportiv 26 103 97 40
8 Asociación Nervion C Asociación 26 129 92 38
9 Almena Almena 26 96 114 32
10 Montequinto Sub 12 B Montequinto 26 81 146 21
11 Pablo Norte C Pablo Norte 26 86 131 16
12 San Roque C San Roque C 26 53 212 13
13 A. Grosso A. Grosso 26 56 183 10
14 Andalucia Este C Andalucia 26 28 255 6
15 Active Sorts Active Sorts 0 0 0 0

  USO DE MEMORIA  
5,573,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0912
Total Execution Time  0.0924
  CADENA URL  
/historico/Real-Betis-Balompie-D-Alevin
  GET DATOS  
$_GET['/historico/Real-Betis-Balompie-D-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0026  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 = 'Real-Betis-Balompie-D-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=110227 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=110227 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 74453
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=110227 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=474 AND type_rel = 3
0.0021  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 = '110227' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '110227' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '110227' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74453 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=110227 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (74453) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74453 AND teamId = 110227
0.0020  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 = 74453 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '110227' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '110227' and rp.type = 4
0.0020  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 = '110227' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 110227 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 74453 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.0022  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 = 69676 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.0023  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 = 64485 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.0022  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 = 60541 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.0022  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 = 60607 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.0025  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 = 53960 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.0025  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.0024  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 = 42087 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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.0032  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 = 17918 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC