4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Villa del Rio Servicio Depo
TEMPORADA 2020/2021
3ª ANDALUZA CORDOBA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Salvador Allende Salvador 8 21 5 20
2 Don Bosco CF B Bosco 9 26 14 19
3 Ciudad Jardin CD Ciudad 8 15 11 14
4 CD AD Miralbaida Miralbaida 7 23 8 13
5 A.D. Apademar A A.D. 10 25 30 11
6 Peñarroya Pueblonuevo CF Peñarroya 7 17 20 10
7 Villa del Rio Servicio Depo Villa 7 15 31 6
8 Bujalance Futbol Base AD Bujalance 7 9 20 2
9 CD Deportivo Cordoba CF Deportivo 5 5 17 1
TEMPORADA 2019/2020
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Apedem A CD Apedem A 22 86 18 55
2 Don Bosco CF Sub 16 Bosco 23 66 19 54
3 Pozoblanco Pozoblanco 22 74 24 50
4 Atlético Seneca Atlético 22 85 27 49
5 Juanin Y Diego Sub 16 Juanin Diego 23 63 31 47
6 A.D. Apademar A A.D. 22 61 24 40
7 Futbol Base Egabrense Futbol Base 23 54 43 37
8 Salerm Cosmetics Puente Gen Salerm 23 52 40 33
9 Rud La Carlota A Carlota 22 45 51 31
10 C.D. Stadium C.D. Stadium 22 53 52 29
11 Villa del Rio Servicio Depo Villa 23 44 54 25
12 Figueroa CD Figueroa CD 20 33 44 19
13 Deportivo Córdoba CF Deportivo 21 52 66 19
14 Alcazar CD Alcazar CD 23 24 95 10
15 Baenense Atletico Baenense 23 16 169 3
16 La Rambla de Futbol Base Rambla 16 13 64 1
TEMPORADA 2018/2019
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Los Califas Balompie Califas 30 115 19 75
2 CD Deportivo Cordoba CF Deportivo 30 104 30 72
3 A.D. Apademar A A.D. 30 104 32 72
4 Juanin Y Diego Sub 16 Juanin Diego 30 107 24 69
5 Atlético Seneca Atlético 30 109 25 64
6 Don Bosco CF Sub 16 Bosco 30 91 39 62
7 CD Apedem A CD Apedem A 30 70 57 45
8 Futbol Base Egabrense Futbol Base 30 72 56 41
9 C.D. Stadium C.D. Stadium 30 79 105 39
10 Villa del Rio Servicio Depo Villa 30 56 75 33
11 Rud La Carlota A Carlota 30 67 81 32
12 Alcazar CD Alcazar CD 30 41 100 28
13 Fundacion Lucena Fundacion 30 37 89 23
14 Palma del Rio Atlético Palma 30 52 152 21
15 Atlético Villanueva FB Atlético 30 48 123 15
16 Salvador Allende Salvador 30 15 160 7
TEMPORADA 2017/2018
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Atlético Villanueva FB Atlético 28 92 34 61
2 Villa del Rio Servicio Depo Villa 28 91 37 60
3 CD Deportivo Cordoba CF Deportivo 28 105 39 59
4 C.D. Stadium C.D. Stadium 28 66 34 57
5 La Rambla de Futbol Base Rambla 28 79 45 47
6 Santaella 2010 Santaella 28 72 41 46
7 CD Posadas CF Posadas 28 72 58 46
8 Salerm Cosmetics Puente Gen Salerm 28 71 47 45
9 Figueroa CD Figueroa CD 28 68 51 44
10 Bujalance Futbol Base AD Bujalance 28 69 60 43
11 Los Califas Balompie B Califas 28 70 46 41
12 Salvador Allende Salvador 28 50 61 34
13 Villafranca Villafranca 28 73 124 23
14 Aguilarense Atletico Aguilarense 28 37 172 6
15 El Higueron El Higueron 28 19 185 0
TEMPORADA 2016/2017
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Fundacion Lucena Fundacion 26 139 37 68
2 Atletico Baenense Atletico 26 112 46 65
3 Juanin Y Diego Sub 16 Juanin Diego 26 113 36 62
4 Alcazar CD Alcazar CD 27 99 43 57
5 Atlético Villanueva FB Atlético 26 86 48 45
6 El Higueron El Higueron 27 75 75 43
7 Salvador Allende Salvador 26 75 49 42
8 Villa del Rio Servicio Depo Villa 26 60 59 39
9 La Rambla de Futbol Base Rambla 26 71 73 37
10 C.D. Stadium C.D. Stadium 26 59 80 27
11 CD Posadas CF Posadas 26 58 87 25
12 Deportivo Cordoba Deportivo 26 38 81 17
13 Los Califas Balompie B Califas 26 25 154 6
14 Parque Cruz Conde Parque Cruz 26 19 154 3
TEMPORADA 2015/2016
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Posadas CF Posadas 33 155 49 85
2 A.D. Apademar A A.D. 33 113 53 75
3 Rud La Carlota A Carlota 33 87 31 70
4 CD Colonia de Fuente Palmer Colonia 33 105 61 61
5 Villafranca C Villafranca 33 118 86 59
6 Los Califas Balompie B Califas 33 67 62 53
7 Atletico Aguilarense Atletico 33 122 124 52
8 La Rambla de Futbol Base Rambla 33 105 82 52
9 Deportivo Cordoba Deportivo 33 85 73 49
10 La Ribera del Guadalquivir Ribera 33 125 126 49
11 CD Hinojosa CD Hinojosa 33 64 59 46
12 C.D. Stadium C.D. Stadium 33 64 90 41
13 CD Castro Del Rio-Cajasol Castro 33 64 74 39
14 Salvador Allende Salvador 33 73 127 30
15 Villa del Rio Servicio Depo Villa 33 65 107 26
16 El Higueron El Higueron 33 63 143 19
17 Peñarroya Pueblonuevo Peñarroya 17 37 57 17
18 Figueroa CD Figueroa CD 33 60 168 5
TEMPORADA 2014/2015
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Sporting Benameji Sporting 30 132 43 78
2 Don Bosco CF B Bosco 30 119 44 63
3 Deportivo Cordoba Deportivo 30 84 32 60
4 La Rambla de Futbol Base Rambla 30 84 59 58
5 Parque Cruz Conde Parque Cruz 30 79 51 57
6 Rud La Carlota A Carlota 30 81 57 55
7 CD Colonia de Fuente Palmer Colonia 30 92 61 54
8 Villa del Rio Servicio Depo Villa 30 105 86 44
9 CD Los Califas Balompie Califas 30 56 52 42
10 CD Hinojosa CD Hinojosa 30 75 87 39
11 La Ribera del Guadalquivir Ribera 30 112 123 35
12 Villafranca Villafranca 30 57 102 27
13 CD Castro Del Rio-Cajasol Castro 30 46 100 25
14 Salvador Allende Salvador 30 51 114 22
15 Almodóvar del Río C.F. Almodóvar 30 50 100 16
16 Atletico Baenense Atletico 30 68 180 10

  USO DE MEMORIA  
5,305,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5489
Total Execution Time  0.5502
  CADENA URL  
/historico/Villa-Del-Rio-Servicio-Deporte-Cadete/2021
  GET DATOS  
$_GET['/historico/Villa-Del-Rio-Servicio-Deporte-Cadete/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0184  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 = 'Villa-Del-Rio-Servicio-Deporte-Cadete' AND l.year = 2021 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.0152  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=25280 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=25280 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0320  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 = 59535
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25280 AND type_rel = 2
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=760 AND type_rel = 3
0.0148  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 = '25280' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '25280' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '25280' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153  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 = 59535 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  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=25280 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (66118,59535,52410) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66118 AND teamId = 25280
0.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 59535 AND teamId = 25280
0.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 52410 AND teamId = 25280
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 `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 = 59535 AND t.round = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0150  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 = '25280' 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 = '25280' and rp.type = 4
0.0150  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 = '25280' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 = 25280 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0154  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 = 59535 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 `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 = 52410 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.0150  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 = 45915 AND t.round = 30 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 = 40581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 35352 AND t.round = 30 ORDER BY team.conference 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 `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 = 17288 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 4867 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 59535 ORDER BY nameShow LIMIT 100