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 B
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 26 221 30 78
2 Sevilla Sub 12 C Sevilla 26 172 37 70
3 Peloteros Sierra Sur Sub 12 Peloteros 27 120 73 56
4 San Roque Balompié Sub 12 B Roque 26 95 64 45
5 Montequinto Sub 12 B Montequinto 27 120 86 44
6 Utrera Sub 12 Utrera 27 96 92 41
7 Colegio Claret Sub 12 Colegio 27 90 93 39
8 Osuna Bote Club Sub 12 Osuna Bote. 26 102 109 38
9 Centro Historico Sub 12 Centro 27 88 99 36
10 UD Tomares Sub 12 Tomares 26 75 99 36
11 La Barrera Sub 12 Barrera 27 67 88 35
12 Bellavista Sub 12 Bellavista 27 86 102 26
13 CD Antonio Puerta Sub 12 Antonio 26 56 113 23
14 Atletico Oromana Sub 12 Atletico 27 44 145 15
15 Mosquito Sub 12 Mosquito 27 39 191 6
16 San Pablo Pino Sub 12 Pablo Pino 7 4 54 0
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 5
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 10 89 10 30
2 Real Betis Sub 12 B Real Betis 10 60 17 24
3 SAM-CAM Sub 12 SAM-CAM 10 52 28 22
4 Sededos Sededos 10 23 34 12
5 Utrera Sub 12 Utrera 10 25 39 12
6 Aficionado de Ecija Sub 12 Aficionado 10 34 43 11
7 Mosquito Sub 12 Mosquito 10 30 48 11
8 Pablo VI A Pablo VI A 10 22 46 7
9 San Roque Balompié Sub 12 B Roque 10 24 70 7
10 Montequinto Sub 12 Montequinto 10 27 51 6
TEMPORADA 2019/2020
2ª SEVILLA ALEVÍN (2ª FASE) GRUPO 2
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 9 41 11 24
2 Sevilla Sub 12 Sevilla 9 59 10 24
3 Tomares Sub 12 Tomares 9 32 37 16
4 Sededos Sededos 9 19 23 12
5 Utrera Sub 12 Utrera 9 18 38 9
6 SAM-CAM Sub 12 SAM-CAM 9 19 31 8
7 AD Dani Triana Ar Rabad A Dani Triana 9 21 49 6
8 CD Antonio Puerta Sub 12 Antonio 9 19 29 5
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 12 97 11 36
2 Pablo VI Pablo VI 12 57 32 23
3 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 12 46 41 23
4 Viso Graphenstone Viso 12 31 30 21
5 Estepa Industrial Estepa 12 37 67 7
6 Aficionado de Ecija Sub 12 Aficionado 12 29 71 6
7 Jose Antonio Luque Jose Antonio 12 40 85 6
8 Atletico Oromana Sub 12 Atletico 0 0 0 0
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 3
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 30 255 32 86
2 Sevilla A Sevilla A 30 255 39 84
3 AD Dani Triana Ar Rabad A Dani Triana 30 238 70 76
4 Diablos Rojos Diablos 30 138 88 68
5 Centro Historico AAVV A Centro 30 97 82 55
6 Cantely C.D. Cantely C.D. 30 117 149 52
7 Andalucia Este A Andalucia 30 136 100 49
8 CD Antonio Puerta B Antonio 30 102 152 41
9 Sevilla 3000 Sevilla 3000 30 80 112 38
10 Calavera A Calavera A 30 101 141 32
11 Pablo Norte A Pablo Norte 30 74 143 32
12 Alcosa Polideportivo A Alcosa 30 91 200 30
13 P. Pio Gorra Gorra 30 93 163 26
14 Bellavista A Bellavista 30 54 165 16
15 La Negrilla La Negrilla 30 60 255 12
16 Torreblanca A Torreblanca 30 30 182 9
TEMPORADA 2015/2016
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 30 255 27 90
2 Sevilla C Sevilla C 30 236 48 78
3 Camas Camas 30 201 75 77
4 Olivarense Atletico Olivarense 30 174 70 66
5 Diez Sanlucar Diez 30 171 80 57
6 Atlético Algabeño Atlético 30 121 136 52
7 Coria CF B Coria CF B 30 127 103 46
8 Tor del Rey de Pilas Pilas 30 117 124 46
9 Benacazon Benacazon 30 124 103 44
10 Juventud Gines Sub 12 Juventud 30 123 83 44
11 Tomares Tomares 30 126 192 34
12 A. Aznalcazar Aznalcazar 30 61 139 23
13 Guillena Sub 12 Guillena 30 68 209 21
14 Calavera A Calavera A 30 61 178 15
15 Cantillana Cantillana 30 46 255 7
16 Salteras Salteras 30 44 253 5
TEMPORADA 2014/2015
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 13
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 24 228 21 72
2 M. Unamuno A Unamuno 24 176 44 60
3 Coronil Coronil 24 117 59 58
4 Cantely A Cantely A 24 146 54 54
5 San Roque C San Roque C 24 106 71 43
6 Vistazul Vistazul 24 83 65 39
7 Dr. Fleming A Fleming 24 117 103 38
8 San Alberto Magno A Alberto 24 88 121 26
9 Caminantes A Caminantes 24 69 121 24
10 Mosquito C Mosquito C 24 80 104 18
11 Mairena B Mairena B 24 56 181 14
12 A. Antoniano B Antoniano 24 42 138 13
13 Viso Sub 12 B Viso 24 21 247 0

  USO DE MEMORIA  
5,675,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4992
Total Execution Time  0.5003
  CADENA URL  
/historico/Real-Betis-Balompie-Sad-B-Alevin
  GET DATOS  
$_GET['/historico/Real-Betis-Balompie-Sad-B-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0134  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-Sad-B-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.0125  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=74018 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=74018 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=74018 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=74018 AND type_rel = 2
0.0130  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 = '74018' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '74018' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '74018' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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=74018 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (74450) 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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74450 AND teamId = 74018
0.0126  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 = 74449 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '74018' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '74018' and rp.type = 4
0.0131  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 = '74018' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 74018 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0143  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.0129  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 = 74450 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.0142  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.0129  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.0129  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 = 60530 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.0129  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 = 62287 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.0127  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.0127  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 = 55288 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.0127  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 = 44974 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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.0133  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 = 34775 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 17871 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 6920 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC