4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Peñaflor 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 25 146 47 64
3 Municipal de Gerena Sub 12 Municipal 24 132 43 62
4 Esfubasa Sub 12 Esfubasa 25 164 52 59
5 Real Betis Sub 12 E Real Betis 26 151 54 58
6 Santiponce Sub 12 B Santiponce 25 98 66 47
7 Peñaflor Sub 12 Peñaflor 25 95 124 37
8 Triana Ar Rabad Sub 12 B Triana Rabad 25 77 67 34
9 Loreto Sub 12 Loreto 25 88 78 33
10 Lora Sub 12 B Lora 25 76 91 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 25 48 106 16
14 Centro Historico Sub 12 B Centro 25 65 149 13
15 San Pablo Pino Sub 12 Pablo Pino 25 42 172 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 2019/2020
3ª ANDALUZA SEVILLA ALEVÍN
Equipo PJ GF GC Puntos
1 Sevilla C Sevilla C 23 176 32 61
2 San Pablo Pino Sub 12 Pablo Pino 23 121 46 56
3 San Jose A San Jose A 23 101 56 49
4 Lora Lora 23 110 60 48
5 Calavera Calavera 23 116 55 47
6 S. Jeronimo A Jeronimo 23 91 49 45
7 Esfubasa A Esfubasa A 23 109 58 43
8 CD Antonio Puerta B Antonio 23 84 59 41
9 A. Algabeño A Algabeño 23 103 95 29
10 Peñaflor Sub 12 Peñaflor 23 96 124 28
11 CD San Alberto Magno Alberto 23 83 132 23
12 M. Aljarafe A Aljarafe 23 66 103 20
13 Alcala del Rio Alcala 23 64 114 17
14 El Pilar El Pilar 23 55 113 15
15 Centro Historico AAVV A Centro 23 34 124 9
16 Alcolea Rio Alcolea Rio 23 30 219 3
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
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Betisevilla B Betisevilla 28 255 27 81
2 Villaverde Villaverde 28 255 42 81
3 Alcala Rio A Alcala 28 218 79 65
4 Peñaflor Sub 12 Peñaflor 28 119 97 49
5 Alcolea Rio Alcolea Rio 28 125 153 48
6 Minas Minas 28 121 107 47
7 Cantillana Cantillana 28 96 108 47
8 Campana Campana 28 117 87 44
9 A. Algabeño A Algabeño 28 93 117 31
10 Viso Graphenstone D Viso 28 78 143 31
11 Priorato Juventud de Futbol Priorato 28 65 130 29
12 Brenes Balompie B Brenes 28 81 175 22
13 AD San José Sub 12 José 28 59 147 21
14 Lora Lora 28 56 182 14
15 Rinconada C. B Rinconada 28 30 230 3

  USO DE MEMORIA  
5,195,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0793
Total Execution Time  0.0805
  CADENA URL  
/historico/Cd-Penaflor-Fs-Alevin
  GET DATOS  
$_GET['/historico/Cd-Penaflor-Fs-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0029  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 = 'Cd-Penaflor-Fs-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=109096 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=109096 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=109096 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=474 AND type_rel = 3
0.0022  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 = '109096' 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 = '109096' 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 = '109096' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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.0020  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=109096 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 (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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74479 AND teamId = 109096
0.0019  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.0020  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 = '109096' 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 = '109096' 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 = '109096' 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 = 109096 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0021  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.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 `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.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 = 53241 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.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 `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.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 `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