4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sededos Sub 8
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Betis Balompie B Real Betis. 13 119 7 39
2 Atletico Oromana Sub 8 Atletico 13 73 22 36
3 Sevilla Sub 8 B Sevilla 13 56 25 30
4 Asociación Nervion Sub 8 Asociación 13 66 38 27
5 Doctor Fleming Sub 8 Doctor 13 60 28 26
6 Montequinto Sub 8 Montequinto 14 53 45 25
7 San Roque Balompie Sub 8 B Roque 11 55 14 24
8 Pablo VI Sub 8 Pablo 13 52 41 22
9 Utrera Sub 8 Utrera 13 46 44 20
10 Osuna Bote Club Sub 8 Osuna Bote. 13 42 48 13
11 Aficionado Écija Sub 8 Aficionado 14 20 59 12
12 SAM-CAM Dos Hermanas Sub 8 SAM-CAM 13 27 49 11
13 Sededos Sub 8 Sededos 13 14 65 8
14 Estepa Industrial Sub 8 Estepa 13 35 88 8
15 David Castedo 3 (DC 3) David 13 16 83 3
16 Bellavista Sub 8 Bellavista 13 13 91 0
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 2
Equipo PJ GF GC Puntos
1 Sevilla Sub 8 Sevilla 30 255 16 88
2 Real Betis Balompie B Real Betis. 30 255 39 82
3 San Roque Balompie Sub 8 B Roque 30 223 56 75
4 Asociación Nervion Sub 8 Asociación 30 255 69 73
5 Colegio Claret Sub 8 Colegio 30 155 92 58
6 Pablo VI Sub 8 Pablo 30 110 95 56
7 Utrera Sub 8 Utrera 30 155 123 54
8 AD Dani Triana Ar-Rabad B Dani Triana 30 126 99 48
9 Calavera CF Sub 8 Calavera 30 103 128 40
10 Aficionado Écija Sub 8 Aficionado 30 130 146 39
11 AAVV Centro Histórico Sub 8 AAVV Centro 30 79 170 27
12 Sededos Sub 8 Sededos 30 43 167 22
13 La Barrera La Barrera 30 46 207 18
14 Estepa Industrial Sub 8 Estepa 30 56 238 18
15 Torreblanca Torreblanca 30 35 255 6
16 Alcala Alcala 30 33 251 4
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 32 234 9 96
2 Real Betis Balompie Sub 8 Real Betis. 32 226 35 85
3 San Roque Balompie Sub 8 Roque 32 159 47 80
4 Loreto Sub 8 Loreto 32 139 75 70
5 Tomares A Tomares A 32 115 76 61
6 Camas Sub 8 Camas Sub 8 32 146 102 56
7 Castilleja Sub 8 Castilleja 32 107 113 48
8 David Castedo 3 (DC 3) David 32 96 105 44
9 Coria CF Sub 8 Coria 32 92 122 42
10 Sededos Sub 8 Sededos 32 92 132 40
11 San Alberto Magno Alberto 32 93 117 39
12 Montequinto Sub 8 Montequinto 32 92 135 38
13 Club Polideportivo Bormujos Club 32 54 95 33
14 Lora CF Sub 8 Lora 32 71 150 33
15 Salteras A Salteras A 32 76 142 24
16 La Liara Balompie Liara 32 36 216 6
17 Mairena del Aljarafe Sub 10 Mairena 32 31 188 4
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 8
Equipo PJ GF GC Puntos
1 Montequinto Sub 8 Montequinto 8 23 8 19
2 Aficionado Écija Sub 8 Aficionado 8 33 20 18
3 Andalucia Este CF A Andalucia 8 39 26 15
4 La Barrera La Barrera 8 35 23 15
5 Sededos Sub 8 Sededos 8 31 21 14
6 Ciudad de Moron Ciudad Moron 8 21 32 6
7 Alcala Alcala 8 11 22 6
8 Mairena Mairena 8 8 49 0
TEMPORADA 2019/2020
2ª SEVILLA BENJAMIN (2ª FASE) GRUPO 2
Equipo PJ GF GC Puntos
1 Sevilla Sub 8 Sevilla 9 97 5 27
2 Real Betis Balompié B Real Betis. 9 42 20 18
3 Coria CF Sub 8 Coria 9 33 33 18
4 Mosquito Mosquito 9 26 40 15
5 Torreblanca Torreblanca 9 21 24 10
6 CD San Pablo Pino Montano A Pablo Pino. 9 16 54 10
7 AAVV Centro Histórico Sub 8 AAVV Centro 9 21 33 9
8 Sededos Sub 8 Sededos 9 20 67 0
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Mairena Mairena 12 49 16 29
2 Sededos Sub 8 Sededos 12 48 20 27
3 Montequinto Sub 8 Montequinto 12 32 22 25
4 San Alberto Magno Alberto 12 72 19 24
5 Bellavista Sub 8 Bellavista 12 20 47 9
6 Doctor Fleming Doctor 11 18 50 6
7 Atletico Oromana Atletico 0 0 0 0
8 La Liara Balompie Liara 11 14 79 0
TEMPORADA 2017/2018
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 6
Equipo PJ GF GC Puntos
1 Real Betis Balompié B Real Betis. 14 95 11 42
2 Sededos Sub 8 Sededos 14 29 24 28
3 Asociación Nervion Sub 8 Asociación 14 58 36 27
4 Tomares Tomares 14 47 46 17
5 Pablo VI Sub 8 Pablo 14 31 34 16
6 Viso Graphenstone Viso 14 35 45 14
7 Doctor Fleming B Doctor 14 22 53 12
8 Torreblanca Torreblanca 14 12 80 1
TEMPORADA 2016/2017
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 30 255 27 90
2 La Liara Balompie Liara 30 140 79 72
3 Alcosa Pol. Alcosa Pol. 30 95 60 57
4 Pablo VI Sub 8 Pablo 30 124 81 55
5 Andalucia Este CF A Andalucia 30 121 90 54
6 Viso Graphenstone Viso 30 98 82 52
7 Utrera CD Utrera CD 30 92 87 50
8 Alcala Alcala 30 87 89 46
9 Ciudad de Moron Ciudad Moron 30 93 100 46
10 Sededos Sub 8 Sededos 30 76 82 45
11 Doctor Fleming Doctor 30 79 110 32
12 CD Antonio Puerta A Antonio 30 79 145 24
13 Atletico Oromana Atletico 30 70 171 24
14 Mosqueo Mosqueo 30 56 129 22
15 Bellavista Sub 8 Bellavista 30 61 137 16
16 Montequinto Sub 8 Montequinto 30 36 189 1
TEMPORADA 2015/2016
2ª ANDALUZA SEVILLA BENJAMIN
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 30 215 23 90
2 Sevilla A Sevilla A 30 255 35 81
3 Asociación Nervion Sub 8 Asociación 30 126 66 62
4 Sededos Sub 8 Sededos 30 130 73 62
5 Tomares Tomares 30 94 85 54
6 Bellavista Sub 8 Bellavista 30 87 77 50
7 Coria CF Sub 8 Coria 30 103 91 47
8 Viso Graphenstone Viso 30 94 102 44
9 Utrera CD Utrera CD 30 111 113 41
10 Pablo VI Sub 8 Pablo 30 87 106 38
11 AD Dani Triana Sub 8 Dani Triana 30 95 100 37
12 Alcosa Pol. Alcosa Pol. 30 74 77 33
13 Montequinto Sub 8 Montequinto 30 64 109 25
14 AAVV Centro Histórico Sub 8 AAVV Centro 30 44 128 17
15 AD San Jose AD San Jose 30 68 227 11
16 Los Mares Los Mares 30 29 255 0
TEMPORADA 2014/2015
2ª ANDALUZA SEVILLA BENJAMIN
Equipo PJ GF GC Puntos
1 Sevilla FC Sevilla FC 30 255 25 87
2 Real Betis Balompie Sub 8 Real Betis. 30 249 17 85
3 Nervion AD Nervion AD 30 140 60 70
4 Alcosa Pol. Alcosa Pol. 30 95 79 64
5 Coria CF Sub 8 Coria 30 133 100 60
6 Bellavista UD Bellavista 30 100 111 50
7 AD Dani Triana Sub 8 Dani Triana 30 101 93 46
8 Tomares UD Tomares UD 30 98 109 39
9 Montequinto CD Montequinto 30 74 109 35
10 Utrera CD Utrera CD 30 78 101 34
11 Sededos Sub 8 Sededos 30 57 100 29
12 Los Mares AD Mares 30 90 122 28
13 El Pilar El Pilar 30 73 98 27
14 Gelves CD Gelves CD 30 81 136 27
15 Calavera CF Sub 8 Calavera 30 54 165 9
16 La Oliva AF La Oliva AF 30 18 255 0

  USO DE MEMORIA  
5,551,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6421
Total Execution Time  0.6434
  CADENA URL  
/historico/Cd-Sededos-Benjamin
  GET DATOS  
$_GET['/historico/Cd-Sededos-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0190  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-Sededos-Benjamin' 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.0151  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=76105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=76105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0317  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 = 74454
0.0156  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=76105 AND type_rel = 2
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=855 AND type_rel = 3
0.0154  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 = '76105' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '76105' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0153  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 = '76105' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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 = 74454 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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=76105 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (74454) 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.0151  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74454 AND teamId = 76105
0.0153  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 = 74454 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0154  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 = '76105' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '76105' and rp.type = 4
0.0147  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 = '76105' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0151  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 = 76105 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153  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 = 74454 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.0161  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 = 69681 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.0161  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 = 64499 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 60682 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.0164  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 = 60776 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 62294 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 53309 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.0148  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 = 55280 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.0148  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 = 44981 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 40539 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 42867 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0173  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 = 34836 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 = 18279 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 5422 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 74454 ORDER BY nameShow LIMIT 100