4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del AD San José Sub 12
TEMPORADA 2023/2024
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 AD San José Sub 12 José 26 158 50 67
2 Tocina Los Rosales Sub 12 B Tocina 26 150 51 65
3 Municipal de Gerena Sub 12 Municipal 25 141 44 65
4 Esfubasa Sub 12 Esfubasa 26 168 56 60
5 Real Betis Sub 12 E Real Betis 26 151 54 58
6 Santiponce Sub 12 B Santiponce 26 104 70 50
7 Peñaflor Sub 12 Peñaflor 26 99 126 40
8 Triana Ar Rabad Sub 12 B Triana Rabad 25 77 67 34
9 Loreto Sub 12 Loreto 26 89 87 33
10 Lora Sub 12 B Lora 26 78 95 28
11 Algabeño Atlético Sub 12 C Algabeño 25 78 105 25
12 Camas Sub 12 B Camas 26 85 110 22
13 Castilleja Sub 12 Castilleja 26 52 112 16
14 Centro Historico Sub 12 B Centro 26 67 150 16
15 San Pablo Pino Sub 12 Pablo Pino 26 43 174 11
16 CD Rinconada Cantera Sub 12 Rinconada 23 18 207 4
TEMPORADA 2022/2023
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Guillena Sub 12 Guillena 24 203 51 64
2 Asociación Nervion C Asociación 24 137 50 60
3 Peñaflor Sub 12 Peñaflor 24 146 83 52
4 AD San José Sub 12 José 24 124 57 49
5 San Roque B San Roque B 24 147 74 47
6 Real Betis Sub 12 E Real Betis 24 104 62 40
7 Centro Historico Sub 12 B Centro 24 134 87 35
8 CD Rinconada Cantera Sub 12 Rinconada 24 95 89 35
9 Sevilla Sub 12 D Sevilla 24 74 72 33
10 Torreblanca B Torreblanca 24 67 116 16
11 Lora Sub 12 Lora Sub 12 24 72 139 13
12 Alcala del Rio Alcala 24 75 174 8
13 Club Deportivo Oduciarosal Club 24 22 255 4
14 CD Esfubasa B Esfubasa 0 0 0 0
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
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 8
Equipo PJ GF GC Puntos
1 San Pablo Pino Sub 12 Pablo Pino 10 56 24 24
2 AD San José Sub 12 José 10 43 25 19
3 Torreblanca A Torreblanca 10 37 29 19
4 Juventud Gines Sub 12 Juventud 10 45 29 18
5 Coria Sub 12 Coria 10 25 15 18
6 Andalucia Este A Andalucia 10 33 25 18
7 AD Dani Triana Ar Rabad A Dani Triana 10 33 22 16
8 Umbrete Sub 12 Umbrete 10 26 25 15
9 Olivarense A. A Olivarense 10 18 51 0
10 Betisevilla Betisevilla 10 11 82 0
TEMPORADA 2019/2020
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 7
Equipo PJ GF GC Puntos
1 Guillena Sub 12 Guillena 23 191 45 65
2 Cantillana Cantillana 23 140 63 58
3 Brenes B. Brenes B. 23 130 64 52
4 AD San José Sub 12 José 23 115 53 49
5 Burguillos Burguillos 23 91 41 47
6 Mun. Gerena Mun. Gerena 23 99 56 45
7 Priorato Juventud de Futbol Priorato 23 85 67 39
8 Campana Campana 23 92 79 37
9 CD Multideporte Tocina Los Multideporte 23 96 78 29
10 Club Deportivo Oduciarosal Club 23 67 89 28
11 Esfubasa Sub 12 Esfubasa 23 66 97 27
12 Villaverde Villaverde 23 75 95 23
13 CD Rinconada Cantera Sub 12 Rinconada 23 45 105 16
14 Lora Lora 23 60 134 9
15 Atco. Algabeño Atco. 23 38 187 6
16 Minas Minas 23 40 177 4
TEMPORADA 2018/2019
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Peñaflor Sub 12 Peñaflor 26 243 63 69
2 Rinconada C. A Rinconada 26 177 41 68
3 Villaverde Villaverde 26 187 70 60
4 Brenes Balompie A Brenes 26 176 61 55
5 Priorato Juventud de Futbol Priorato 26 146 70 55
6 A. Algabeño A Algabeño 26 126 81 48
7 Cantillana Cantillana 26 88 119 38
8 Campana Campana 26 86 121 37
9 Burguillos Burguillos 26 106 88 30
10 Lora Lora 26 93 101 30
11 Alcolea Rio Alcolea Rio 26 82 151 24
12 AD San José Sub 12 José 26 46 150 13
13 Minas Minas 26 59 193 10
14 Alcala Rio A Alcala 0 0 0 0
15 Guillena Sub 12 Guillena 26 39 255 0
TEMPORADA 2017/2018
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 7
Equipo PJ GF GC Puntos
1 AD San José Sub 12 José 14 56 25 34
2 Viso Graphenstone Viso 14 47 33 31
3 Los Caminantes Caminantes 14 46 30 28
4 AD Dani Triana Ar Rabad A Dani Triana 14 45 28 26
5 Ciudad de Moron Ciudad Moron 14 51 54 14
6 Camas Camas 14 44 56 13
7 La Liara Sub 12 Liara 14 36 55 12
8 Lora Lora 14 29 73 4
TEMPORADA 2016/2017
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 10
Equipo PJ GF GC Puntos
1 Aficionado de Ecija Sub 12 Aficionado 30 255 33 90
2 CP Bormujos B Bormujos 30 180 64 73
3 San Roque Balompie E Roque 30 176 44 70
4 Alcala Rio A Alcala 29 174 78 70
5 AD San José Sub 12 José 30 166 67 63
6 Villaverde Villaverde 30 116 74 58
7 Rinconada C. A Rinconada 30 127 77 54
8 Cantillana Cantillana 30 87 97 39
9 Campana Campana 30 84 121 37
10 A. Algabeño A Algabeño 30 76 144 30
11 Mun. Gerena Mun. Gerena 29 73 107 28
12 Espartinas Tilde Espartinas 30 78 155 28
13 Brenes B. Brenes B. 30 88 134 27
14 Alcolea Rio Alcolea Rio 30 73 143 27
15 Minas Minas 30 41 255 5
16 Aznalcollar Aznalcollar 30 42 253 4
TEMPORADA 2015/2016
2ª ANDALUZA SEVILLA ALEVÍN
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 30 255 20 88
2 Sevilla Sub 12 Sevilla 30 255 35 85
3 Asociación Nervion Sub 12 B Asociación 30 147 69 70
4 CD Antonio Puerta Sub 12 Antonio 30 130 81 66
5 Coria Sub 12 Coria 30 113 91 55
6 Tomares Tomares 30 79 80 51
7 Montequinto Sub 12 Montequinto 30 96 90 46
8 Sededos Sededos 30 83 74 45
9 AD San José Sub 12 José 30 83 116 42
10 Utrera Sub 12 Utrera 30 71 130 30
11 Lora C.F Lora C.F 30 64 95 30
12 CD Alcala CD Alcala 30 94 153 28
13 El Pilar El Pilar 30 68 141 27
14 La Liara Sub 12 Liara 30 60 157 20
15 C.D. BORMUJOS S.M. C.D. 30 28 158 5
16 Betisevilla Betisevilla 30 41 255 3

  USO DE MEMORIA  
5,526,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5098
Total Execution Time  0.5109
  CADENA URL  
/historico/Ad-San-Jose-Alevin
  GET DATOS  
$_GET['/historico/Ad-San-Jose-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0254  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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=73815 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=474 AND type_rel = 3
0.0129  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 = '73815' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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.0129  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=73815 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74479 AND teamId = 73815
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 = 74479 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '73815' 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 = '73815' and rp.type = 4
0.0126  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 = '73815' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0130  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 = 73815 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 26 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 `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 = 69678 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.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 `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 = 64487 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.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 `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.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 `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 = 60532 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.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 `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.0128  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 = 62290 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.0132  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 = 53977 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 `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.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 = 44976 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 `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 = 45198 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 42080 AND t.round = 14 ORDER BY team.conference 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 `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 = 42162 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 42863 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 `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 = 34537 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 `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 = 35009 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 = 17854 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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