4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Diablos Rojos
TEMPORADA 2023/2024
PRIMERA ANDALUZA GRUPO 7
Equipo PJ GF GC Puntos
1 Dos Hermanas 1971 Hermanas 24 57 21 57
2 UD Rinconada Rinconada 24 52 31 49
3 Mairena Mairena 24 33 22 48
4 Ventippo Ventippo 24 39 21 45
5 CD Alcalá CD Alcalá 24 39 32 41
6 PD Rociera PD Rociera 24 29 19 38
7 Montequinto CD Montequinto 24 36 33 36
8 Torreblanca CF Torreblanca 24 42 36 32
9 AD San José José 24 26 32 28
10 Estrella San Agustín Estrella 24 35 42 28
11 Mosqueo Mosqueo 24 29 45 27
12 CD Demo CD Demo 24 27 37 23
13 Puebla CF Puebla CF 24 24 29 22
14 CD Diablos Rojos Diablos 24 20 39 22
15 Arahal Arahal 24 20 45 20
16 UD Morón UD Morón 24 27 51 17
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Diablos Rojos Diablos 30 81 29 66
2 UD Loreto UD Loreto 30 59 34 59
3 Andalucia Este CF Andalucia 30 57 43 59
4 Camino Viejo Camino Viejo 30 59 39 58
5 UD Bellavista Bellavista 30 63 37 57
6 UD Tomares B Tomares 30 72 47 51
7 Olivarense Olivarense 30 51 42 43
8 San Juan San Juan 30 50 48 42
9 UD Villaverde Villaverde 30 62 68 42
10 Juventud Dva. Gines Juventud 30 58 57 37
11 Lora CF Lora CF 30 53 53 36
12 JD Bormujos JD Bormujos 30 53 67 30
13 Benacazón CF Benacazón 30 41 51 28
14 CDF Cazalla CDF Cazalla 30 46 85 27
15 A. Cerro Águila Cerro 30 24 52 23
16 Calavera Calavera 30 30 107 11
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Demo CD Demo 32 73 23 71
2 Montequinto CD Montequinto 32 75 36 70
3 Arahal Arahal 32 61 33 65
4 Puebla Cazalla CF Puebla 32 64 40 60
5 Andalucia Este CF Andalucia 31 53 46 53
6 Calavera Calavera 32 49 40 50
7 CD Diablos Rojos Diablos 31 42 32 43
8 Marchena Balompié Marchena 32 53 56 43
9 Atletico Viso Atletico 31 42 44 42
10 Pablo VI Pablo VI 32 61 74 42
11 Colegio Claret Colegio 32 59 67 40
12 Montellano CD Montellano 32 33 44 39
13 San Roque Balompié Roque 31 52 60 36
14 Badolatosa CF Badolatosa 31 54 68 36
15 El Tinte de Utrera Tinte Utrera 31 39 62 29
16 Atl. Antoniano B Atl. 31 41 85 18
17 Nervión Nervión 25 23 64 12
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA GRUPO 7
Equipo PJ GF GC Puntos
1 San Pablo Pino Montano Pablo Pino. 28 52 32 50
2 Utrera B Utrera B 26 51 32 49
3 CD Diablos Rojos Diablos 28 48 32 48
4 Andalucia Este CF Andalucia 28 52 41 48
5 El Tinte de Utrera Tinte Utrera 26 44 36 41
6 Montequinto CD Montequinto 28 39 40 40
7 Nervión Nervión 27 44 36 39
8 Montellano CD Montellano 26 16 25 31
9 Puebla Cazalla CF Puebla 26 44 46 29
10 Arahal Arahal 25 30 39 27
TEMPORADA 2019/2020
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Club Atl. Central Club Atl. C. 25 59 31 58
2 CD Demo CD Demo 25 64 28 57
3 Nervión Nervión 25 53 27 52
4 CDF Herrera CDF Herrera 25 49 26 45
5 Montequinto CD Montequinto 25 34 32 41
6 Utrera B Utrera B 25 45 34 40
7 Montellano CD Montellano 25 30 33 39
8 Badolatosa CF Badolatosa 25 40 34 38
9 San Pablo Pino Montano Pablo Pino. 25 39 28 37
10 San Roque Balompié Roque 25 43 43 36
11 CD Diablos Rojos Diablos 25 37 36 33
12 Arahal Arahal 25 37 39 33
13 El Tinte de Utrera Tinte Utrera 25 41 62 29
14 CD San Marcos Marcos 25 34 49 23
15 Ecija CF Ecija CF 25 21 44 20
16 El Rubio El Rubio 25 22 45 19
17 Andalucia Este CF Andalucia 25 23 49 17
18 Triana CF Triana CF 25 25 56 17
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Ventippo Ventippo 34 72 31 79
2 At. Dos Hermanas Hermanas 34 68 30 72
3 CDF Herrera CDF Herrera 34 77 50 65
4 Utrera B Utrera B 34 59 43 61
5 Nervión Nervión 34 62 40 50
6 Badolatosa CF Badolatosa 34 73 65 50
7 Ecija CF Ecija CF 34 54 47 50
8 El Rubio El Rubio 34 55 55 48
9 Andalucia Este CF Andalucia 34 60 59 45
10 San Pablo Pino Montano Pablo Pino. 34 57 56 45
11 El Tinte de Utrera Tinte Utrera 34 56 67 45
12 Montellano CD Montellano 34 49 46 44
13 CD Diablos Rojos Diablos 34 41 41 44
14 Triana CF Triana CF 34 38 49 41
15 Ciudad Jardin Ciudad 34 42 62 41
16 Marchena Balompié Marchena 34 46 81 29
17 Calavera Calavera 34 39 67 27
18 UD Morón B UD Morón B 34 37 96 25
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 5
Equipo PJ GF GC Puntos
1 Torreblanca CF Torreblanca 34 53 20 72
2 Moron Moron 34 66 34 66
3 Los Palacios CF Palacios 34 53 30 63
4 UD Morón UD Morón 34 55 36 60
5 PD Rociera PD Rociera 34 55 37 59
6 UD Tomares UD Tomares 34 65 42 59
7 A. Cerro Águila Cerro 34 58 47 54
8 Villafranco Villafranco 34 48 44 52
9 UD Bellavista Bellavista 34 45 45 50
10 CD Demo CD Demo 34 45 47 49
11 Mairena Mairena 34 47 54 47
12 Lora CF Lora CF 34 36 47 42
13 CD Coronil CD Coronil 34 35 42 40
14 CD Pedrera CD Pedrera 34 36 52 37
15 UD Villaverde Villaverde 34 30 43 35
16 San Juan San Juan 34 36 52 35
17 CD Diablos Rojos Diablos 34 26 62 23
18 La Liara Balompie Liara 34 22 77 9
TEMPORADA 2016/2017
PRIMERA ANDALUZA GRUPO 6
Equipo PJ GF GC Puntos
1 Atlético Algabeño Atlético 34 72 45 63
2 Los Palacios CF Palacios 34 60 44 57
3 PD Rociera PD Rociera 34 49 39 53
4 Villafranco Villafranco 34 58 47 53
5 A. Cerro Águila Cerro 34 58 40 53
6 UD Tomares UD Tomares 34 60 63 53
7 Torreblanca CF Torreblanca 34 51 41 51
8 Moron Moron 34 58 48 50
9 UD Bellavista Bellavista 34 57 55 49
10 Mairena Mairena 34 47 42 49
11 CD Diablos Rojos Diablos 34 47 45 48
12 CD Pedrera CD Pedrera 34 62 67 46
13 La Liara Balompie Liara 34 45 50 43
14 Osuna Bote Club Osuna Bote. 34 46 56 42
15 Puebla CF Puebla CF 34 49 62 39
16 Pilas Pilas 34 47 58 33
17 Nervión Nervión 34 40 66 32
18 La Barrera La Barrera 34 34 72 24
TEMPORADA 2015/2016
2ª ANDALUZA SEVILLA
Equipo PJ GF GC Puntos
1 Viso UP Viso UP 34 59 26 67
2 Villafranco Villafranco 34 67 50 63
3 UD Tomares UD Tomares 34 55 38 61
4 Torreblanca C.F. Torreblanca 34 55 36 60
5 Osuna Bote Club Osuna Bote. 34 57 38 59
6 A. Cerro Águila Cerro 34 59 35 56
7 La Liara Balompie Liara 33 53 38 54
8 CD Diablos Rojos Diablos 32 56 49 53
9 Puebla CF Puebla CF 34 45 37 49
10 Atlético Algabeño Atlético 34 57 54 47
11 Mosqueo Mosqueo 34 47 58 42
12 Paradas Balompié Paradas 33 55 58 40
13 Ciudad Jardin Ciudad 34 38 62 40
14 UD Rinconada Rinconada 34 48 54 37
15 UD Soleá UD Soleá 34 48 69 36
16 CD Coronil CD Coronil 34 43 65 30
17 Gilena C.F. Gilena C.F. 34 33 62 26
18 Huévar C.F. Huévar C.F. 34 38 84 22
TEMPORADA 2014/2015
3ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Diablos Rojos Diablos 30 68 26 59
2 Ciudad Jardin Ciudad 30 63 32 59
3 Gilena C.F. Gilena C.F. 30 66 37 58
4 Montellano CD Montellano 30 51 38 55
5 CDF Herrera CDF Herrera 30 57 41 52
6 Andalucia Este CF Andalucia 30 58 37 48
7 La Jara La Jara 30 58 48 47
8 San Jeronimo Jeronimo 30 49 45 46
9 Campana Balompié Campana 30 57 49 44
10 Marchena Balompié Marchena 30 43 39 43
11 Los Corrales Corrales 30 52 48 41
12 Su Eminencia Eminencia 30 43 41 38
13 Círculo Don Bosco Círculo 30 59 64 34
14 Pino Montano Pino Montano 30 34 53 33
15 CD Demo CD Demo 30 37 56 31
16 Calavera Calavera 30 33 63 21
17 Ventippo Ventippo 30 38 86 20
18 Fuente del Rey Fuente 30 21 84 13

  USO DE MEMORIA  
6,071,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1256
Total Execution Time  0.1268
  CADENA URL  
/historico/Cd-Diablos-Rojos
  GET DATOS  
$_GET['/historico/Cd-Diablos-Rojos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0058  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-Diablos-Rojos' 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.0023  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=14446 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=14446 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14446 AND type_rel = 2
0.0048  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 = '14446' ORDER BY l.year DESC,cat.coefficient DESC
0.0048  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 = '14446' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '14446' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0034  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=14446 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (73630,68923) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73630 AND teamId = 14446
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68923 AND teamId = 14446
0.0024  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 = '14446' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '14446' and rp.type = 4
0.0026  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 = '14446' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0046  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73630 WHERE rp.league_id = 73630 AND rp.teamId = 14446 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73630 WHERE rp.league_id = 73630 AND rp.teamId = 14446 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73630 WHERE rp.league_id = 73630 AND rp.teamId = 14446 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 14446 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0030  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` 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 = 68923 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.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` 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 = 64460 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.0028  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` 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 = 59508 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.0031  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` 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 = 61885 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.0029  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` 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 = 51360 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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` 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 = 44924 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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` 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 = 39328 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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` 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 = 34151 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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` 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 = 16800 AND t.round = 34 ORDER BY team.conference 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 `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 = 4111 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC