4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Asoc. Dva. Nervión
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA CADETE
Equipo PJ GF GC Puntos
1 CD Alcala Sub 16 Alcala 30 63 38 64
2 Calavera CF Calavera CF 30 62 38 59
3 Castilleja Castilleja 30 66 34 55
4 San Roque Balompie B Roque 30 58 39 53
5 UD Tomares UD Tomares 30 50 42 48
6 Coria CF Coria CF 30 85 56 46
7 Peloteros Sierra Sur Sub 16 Peloteros 30 55 41 45
8 La Liara Balompie Liara 30 76 64 45
9 Nevaluz Ecija Union Deporti Nevaluz 30 52 46 43
10 CD Asoc. Dva. Nervión Asoc. Dva.. 30 48 42 43
11 CD Montequinto Montequinto 30 50 45 43
12 CD Mosquito CD Mosquito 30 43 48 32
13 CD Diablos Rojos Diablos 30 32 42 32
14 Bormujos JD Bormujos JD 30 41 56 25
15 C Atlético Antoniano Grupo Atlético 30 30 72 20
16 CD Atletico Oromana Atletico 30 12 120 5
TEMPORADA 2021/2022
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Peloteros Sierra Sur Sub 16 Peloteros 30 96 31 75
2 Real Betis Sub 16 B Real Betis 30 107 34 68
3 CD Utrera Sub 16 Utrera 29 86 35 68
4 Fundacion Cadiz CF CD Fundacion 29 83 33 64
5 Sevilla FC Sub 16 B Sevilla 30 63 38 57
6 San Roque Balompie Sub 16 Roque 29 59 43 53
7 Algeciras CF Sub 16 Algeciras 30 61 49 47
8 CD Asoc. Dva. Nervión Asoc. Dva.. 29 59 62 42
9 Palma del Rio Atlético Palma 30 44 62 39
10 Córdoba CF B Córdoba 30 36 55 31
11 San Fernando CD Isleño Fernando 30 52 73 26
12 Balón De Cádiz CF B Balón 30 46 69 24
13 CD Siempre Alegres Siempre 29 30 84 23
14 Recreativo de Huelva B Recreativo 30 38 72 20
15 Calavera CF Calavera CF 30 35 81 20
16 Nuevo Molino Sub 16 Nuevo Molino 29 27 101 14
TEMPORADA 2020/2021
DIVISIÓN DE HONOR CADETE ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 CD Altair Sub 16 Altair 10 22 7 24
2 Córdoba CF Sub 16 Córdoba 10 18 14 21
3 Peloteros Sierra Sur Sub 16 Peloteros 10 16 19 16
4 Séneca CF Sub 16 Séneca 10 12 11 15
5 CD San Félix Félix 10 19 14 14
6 CD Tiro Pichón Tiro Pichón 10 15 15 14
7 CD Asoc. Dva. Nervión Asoc. Dva.. 10 13 20 11
8 Atlético Jaén Sub 16 Atlético 10 10 14 9
9 Puerto Malagueño Sub 16 Puerto 10 19 24 7
10 UCD La Cañada Atlético Cañada 10 8 14 7
TEMPORADA 2019/2020
DIVISIÓN DE HONOR CADETE ANDALUZA
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 Sevilla 23 65 8 63
2 Real Betis Sub 16 Real Betis 23 52 15 51
3 Málaga CF Sub 16 Málaga 23 45 22 44
4 Granada CF Sub 16 Granada 23 48 33 44
5 UCD La Cañada Atlético Cañada 23 34 24 36
6 Puerto Malagueño Sub 16 Puerto 23 30 24 34
7 CD Asoc. Dva. Nervión Asoc. Dva.. 23 32 38 32
8 CD 26 De Febrero Sub 16 Febrero 23 31 37 30
9 Cádiz CF Sub 16 Cádiz 23 23 24 29
10 UD Almeria Sub 16 Almeria 23 29 35 28
11 CD San Félix Félix 23 24 35 26
12 Córdoba CF Sub 16 Córdoba 23 29 39 25
13 Recreativo de Huelva Sub 16 Recreativo 23 27 53 23
14 CD Tiro Pichón Tiro Pichón 23 22 45 21
15 CD Altair Sub 16 Altair 23 31 49 19
16 Peloteros Sierra Sur Sub 16 Peloteros 23 18 59 14
TEMPORADA 2018/2019
DIVISIÓN DE HONOR CADETE ANDALUZA
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 Sevilla 30 105 23 79
2 Málaga CF Sub 16 Málaga 30 76 27 72
3 Real Betis Sub 16 Real Betis 30 75 32 63
4 CD Altair Sub 16 Altair 30 49 40 52
5 UD Almeria Sub 16 Almeria 30 57 39 51
6 Granada CF Sub 16 Granada 30 53 46 48
7 Puerto Malagueño Sub 16 Puerto 30 53 46 43
8 CD San Félix Félix 30 50 49 41
9 Cádiz CF Sub 16 Cádiz 30 44 46 37
10 Córdoba CF Sub 16 Córdoba 30 35 45 35
11 CD 26 De Febrero Sub 16 Febrero 30 44 60 33
12 CD Asoc. Dva. Nervión Asoc. Dva.. 30 38 57 31
13 Linares Deportivo Sub 16 Linares 30 39 68 31
14 Atlético Sanluqueño Sub 16 Atlético 30 41 86 31
15 UD Maracena Sub 16 Maracena 30 40 69 24
16 Séneca CF Sub 16 Séneca 30 17 83 7
TEMPORADA 2017/2018
DIVISIÓN DE HONOR CADETE ANDALUZA
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 Sevilla 30 58 19 71
2 Real Betis Sub 16 Real Betis 30 83 25 70
3 Málaga CF Sub 16 Málaga 30 73 36 67
4 CD Altair Sub 16 Altair 30 71 41 53
5 Granada CF Sub 16 Granada 30 71 41 52
6 UD Almeria Sub 16 Almeria 30 50 33 50
7 Córdoba CF Sub 16 Córdoba 30 60 45 46
8 Cádiz CF Sub 16 Cádiz 30 35 40 39
9 CD 26 De Febrero Sub 16 Febrero 30 44 50 39
10 CD San Félix Félix 30 46 57 33
11 CD Asoc. Dva. Nervión Asoc. Dva.. 30 46 68 33
12 UD Maracena Sub 16 Maracena 30 44 60 32
13 CD Alcala Sub 16 Alcala 30 30 47 29
14 UCD La Cañada Atlético Cañada 30 31 52 27
15 Peloteros Sierra Sur Sub 16 Peloteros 30 34 73 15
16 CD Roquetas CD Roquetas 30 20 109 7
TEMPORADA 2016/2017
DIVISIÓN DE HONOR CADETE ANDALUZA
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 Sevilla 30 70 17 72
2 Real Betis Sub 16 Real Betis 30 85 31 67
3 Málaga CF Sub 16 Málaga 30 74 35 64
4 UD Almeria Sub 16 Almeria 30 51 25 58
5 Córdoba CF Sub 16 Córdoba 30 54 46 52
6 Granada CF Sub 16 Granada 30 45 44 49
7 CD San Félix Félix 30 43 53 38
8 CD Altair CD Altair 30 45 49 37
9 CD 26 De Febrero Sub 16 Febrero 30 43 55 37
10 UCD La Cañada Atlético Cañada 30 42 57 36
11 Cádiz CF Sub 16 Cádiz 30 45 65 33
12 CD Asoc. Dva. Nervión Asoc. Dva.. 30 43 47 32
13 Puerto Malagueño Sub 16 Puerto 30 35 39 32
14 Recreativo de Huelva Sub 16 Recreativo 30 36 59 29
15 Séneca CF Sub 16 Séneca 30 49 78 27
16 Real Jaén Sub 16 Real Jaén 30 31 91 16
TEMPORADA 2015/2016
2ª ANDALUZA SEVILLA CADETE
Equipo PJ GF GC Puntos
1 Real Betis Sub 16 B Real Betis 30 90 16 73
2 CD Alcala Sub 16 Alcala 30 88 34 73
3 Sevilla FC Sub 16 B Sevilla 30 87 17 71
4 Centro Historico AAVV Centro 30 80 45 63
5 Tor del Rey de Pilas Pilas 30 44 39 48
6 CD Asoc. Dva. Nervión Asoc. Dva.. 30 57 50 46
7 Calavera CF Calavera CF 30 56 41 44
8 Circulo Don Bosco Circulo 30 55 45 43
9 Mairena del Aljarafe Mairena 30 47 61 39
10 Sevilla Este Sevilla Este 30 50 68 36
11 Ecija Balompie SAD Ecija 30 61 61 35
12 Coria CF Coria CF 30 42 62 34
13 Dos Hermanas Cf Hermanas 30 50 76 28
14 Andalucia Este CF Andalucia 30 21 73 19
15 San Jose Sub 16 Jose 30 33 86 18
16 Ciudad de Moron Ciudad Moron 30 35 122 13

  USO DE MEMORIA  
5,582,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5841
Total Execution Time  0.5853
  CADENA URL  
/historico/Cd-Asociacion-Dva-Nervion-Cadete
  GET DATOS  
$_GET['/historico/Cd-Asociacion-Dva-Nervion-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0132  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-Asociacion-Dva-Nervion-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.0144  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-Asociacion-Dva-Nervion-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.0125  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=68696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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 = 68955
0.0131  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 = 70166
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68696 AND type_rel = 2
0.0129  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 = '68696' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '68696' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 70166 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 68955 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=68696 AND l.year in (2022,2023,2024) 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 (70166,68955) 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 = 68955 AND teamId = 68696
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70166 AND teamId = 68696
0.0126  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 = '68696' 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 = '68696' and rp.type = 4
0.0127  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 = '68696' 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 = 68696 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  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 = 70166 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.0133  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 = 64285 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 `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 = 59693 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.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 = 62001 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.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 `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 = 52903 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 `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 = 44967 AND t.round = 30 ORDER BY team.conference 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 `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 = 39447 AND t.round = 30 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 `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 = 38053 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 = 17362 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC