4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Diablos Rojos
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA CADETE
Equipo PJ GF GC Puntos
1 CD Los Caminantes Caminantes 32 82 37 76
2 CD Mosquito CD Mosquito 32 70 31 71
3 Atletico Oromana Atletico 31 68 45 63
4 Coria CF Coria CF 32 79 44 57
5 CD Asoc. Dva. Nervion Asoc. Dva.. 32 64 57 45
6 Diablos Rojos Diablos 32 51 59 45
7 Peloteros Sierra Sur Sub 16 Peloteros 32 47 39 44
8 La Liara Balompie Liara 32 58 54 44
9 Bormujos JD Bormujos JD 32 61 75 42
10 C Atl. Antoniano Atl. 32 61 63 39
11 UD Tomares UD Tomares 32 56 59 39
12 CD Alcala Sub 16 Alcala 32 40 60 38
13 CD Montequinto Montequinto 32 52 56 37
14 Rociera Rociera 32 59 69 37
15 Cabecense Cabecense 31 60 73 32
16 Centro Historico AAVV Centro 32 41 64 28
17 UD Bellavista Bellavista 32 27 91 18
TEMPORADA 2020/2021
3ª ANDALUZA SEVILLA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Diablos Rojos Diablos 23 58 29 52
2 San Roque Balompie A Roque 22 80 21 49
3 AD San Jose AD San Jose 22 61 16 46
4 Manantial A Manantial A 23 75 37 43
5 Almena Almena 22 68 37 42
6 Andalucia Este CF Andalucia 22 43 27 41
7 Centro Historico Centro 22 41 47 28
8 CD Antonio Puerta Antonio 23 45 52 26
9 Constantina Constantina 21 34 48 25
10 Atletico Algabeño Atletico 22 62 79 24
11 Alcala del Rio Alcala 23 44 71 22
12 San Jeronimo Jeronimo 22 32 100 9
13 San Pablo Pino Montano A Pablo Pino. 23 22 101 6
TEMPORADA 2018/2019
4ª ANDALUZA SEVILLA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Asociación Famil La Oliva Asociación 26 80 15 68
2 Manantial A Manantial A 26 103 26 64
3 Diablos Rojos Diablos 26 105 55 57
4 Padre Pio Padre Pio 26 91 57 51
5 Vistahermosa Vistahermosa 26 61 47 44
6 Colegio Claret B Colegio 26 70 55 40
7 Recreativo Alcosa A Recreativo 26 57 68 37
8 Portaceli Portaceli 26 64 59 36
9 Andalucia Este CF Andalucia 26 43 62 33
10 San Jeronimo Jeronimo 26 55 65 29
11 Atletico Los Puertos Atletico 26 43 99 22
12 La Union del Porvenir Union 26 51 96 20
13 San Roque Balompie Sub 16 Roque 26 32 69 16
14 Sporting Cerro Sporting 26 39 121 8
15 La Negrilla La Negrilla 0 0 0 0
16 San Pablo Pino Montano A Pablo Pino. 0 0 0 0
TEMPORADA 2017/2018
4ª ANDALUZA SEVILLA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 Circulo Don Bosco Circulo 24 93 27 64
2 Tabladilla Tabladilla 24 106 40 57
3 San Roque Balompie Sub 16 Roque 24 65 42 47
4 Jorge Juan Antonio Ulloa Jorge Juan. 24 53 31 47
5 Almena Almena 24 68 37 43
6 Manantial A Manantial A 24 69 45 43
7 Portaceli Portaceli 24 54 52 40
8 Diablos Rojos Diablos 24 55 40 35
9 Einstein Pino Montano Einstein 24 43 35 29
10 Colegio Claret B Colegio 24 50 80 18
11 Vistahermosa Vistahermosa 24 30 81 16
12 Jd Bormujos C Bormujos 24 23 150 5
13 Spinola Sevilla Spinola 24 21 70 4
TEMPORADA 2016/2017
4ª ANDALUZA SEVILLA CADETE GRUPO 5
Equipo PJ GF GC Puntos
1 Torreblanca Torreblanca 26 188 17 71
2 La Union del Porvenir Union 26 120 24 65
3 Andalucia Este CF Andalucia 25 112 40 57
4 Jorge Juan Antonio Ulloa Jorge Juan. 26 131 46 50
5 Amigos de Sevilla Este Amigos 26 68 46 50
6 La Hispalense Hispalense 26 78 65 42
7 Los Puertos Atletico Puertos 26 87 46 41
8 San Roque Balompie Sub 16 Roque 26 80 52 38
9 Triana Balompie Montecarlos Triana 26 88 71 36
10 Almena A Almena A 26 61 79 33
11 San Pablo Norte Pablo Norte 26 32 152 14
12 CD Altair Sub 16 Altair 26 28 154 11
13 Colegio Claret B Colegio 26 24 146 10
14 El Pilar El Pilar 25 47 206 7
TEMPORADA 2015/2016
3ª ANDALUZA SEVILLA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Alcolea del Rio Alcolea 30 109 46 70
2 CD Los Caminantes Caminantes 30 112 53 65
3 Bellavista Bellavista 29 80 39 62
4 San Roque Balompie Sub 16 Roque 29 88 54 53
5 Viso Viso 29 94 69 52
6 Calavera CF Calavera CF 29 57 55 46
7 CD Utrera B CD Utrera B 29 66 73 43
8 Portaceli Portaceli 29 71 69 37
9 Circulo Don Bosco Circulo 29 64 63 37
10 Amigos Cerro del Aguila Amigos Cerro 29 52 78 32
11 CD Antonio Puerta Sub 16 Antonio 29 66 81 31
12 San Jose San Jose 29 42 73 30
13 Ecija Balompie SAD Ecija 29 57 91 27
14 Torreblanca Torreblanca 29 58 102 27
15 Diablos Rojos Diablos 29 43 81 22
16 Sevilla 3000 Sevilla 3000 17 37 69 9
TEMPORADA 2014/2015
3ª ANDALUZA SEVILLA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 C.F. Ciudad de Morón C.F. Ciudad 30 99 33 70
2 Sevilla Este Cadete Sevilla Este 30 77 29 65
3 Sevilla 3000 Sevilla 3000 30 108 54 54
4 Los Caminantes Caminantes 30 89 50 52
5 Portaceli Portaceli 30 74 57 52
6 Arahelense Arahelense 30 58 48 51
7 Torreblanca Torreblanca 30 69 57 46
8 Utrera Utrera 30 63 54 43
9 Diablos Rojos Diablos 30 46 50 42
10 Calavera Calavera 30 58 56 40
11 F.B Carmona F.B Carmona 30 60 62 40
12 San Jose San Jose 30 64 81 40
13 Lora Lora 30 60 58 38
14 Marchena Marchena 30 51 62 27
15 C.D. Mairena C.D. Mairena 30 43 109 17
16 Los Mares Los Mares 30 33 192 1

  USO DE MEMORIA  
5,337,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0952
Total Execution Time  0.0972
  CADENA URL  
/historico/Diablos-Rojos-Cadete
  GET DATOS  
$_GET['/historico/Diablos-Rojos-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0023  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 = 'Diablos-Rojos-Cadete' 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.0028  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 = 'Diablos-Rojos-Cadete' 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=20744 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=20744 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=20744 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=20744 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=20744 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=20744 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=20744 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=20744 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20744 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=451 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 = '20744' AND l.year = 2022 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 = '20744' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '20744' 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 = 64736 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=20744 AND l.year in (2021,2022,2023) 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 (64736,60388) 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.0017  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64736 AND teamId = 20744
0.0020  SELECT count(id) as num_players from rel_players_base WHERE league_id = 60388 AND teamId = 20744
0.0018  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 = 64736 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '20744' 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 = '20744' 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 = '20744' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 20744 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 60388 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 `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 = 45948 AND t.round = 30 ORDER BY team.conference 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 `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 = 40636 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 34746 AND t.round = 30 ORDER BY team.conference 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 `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 = 17369 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 `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 = 4476 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC