4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atco. Villanueva F.B.
TEMPORADA 2018/2019
LIGA NACIONAL GRUPO 14
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 B Sevilla 30 73 23 69
2 Real Betis Sub 19 B Real Betis 30 62 16 66
3 AD Nervión Sub 19 Nervión 30 64 30 62
4 Castilleja CF Sub 19 Castilleja 30 54 27 59
5 Córdoba CF Sub 19 B Córdoba 30 75 34 53
6 Sporting de Ceuta Sub 19 Sporting 30 58 42 47
7 Algeciras CF Sub 19 Algeciras 30 51 57 44
8 Coria CF Sub 19 Coria 30 40 45 41
9 Atl. Sanluqueño Sub 19 Atl. 30 49 44 39
10 San Fernando Isleño Sub 19 Fernando 30 35 45 39
11 Don Bosco CF Sub 19 Bosco 30 38 48 38
12 Xerez Deportivo FC Sub 19 Xerez 30 48 42 38
13 CMD San Juan Juvenil Juan Juvenil 30 32 43 31
14 Recreativo B Recreativo 30 36 61 30
15 Atco. Villanueva F.B. Atco. 30 19 98 8
16 Sevilla Este Sevilla Este 30 28 107 7
TEMPORADA 2017/2018
2ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 Atco. Villanueva F.B. Atco. 30 72 39 72
2 Séneca B CF Séneca 30 76 22 71
3 Fundación Lucena FC Sub 19 Fundación 30 72 27 65
4 CD Pozoblanco Sub 19 Pozoblanco 30 69 29 61
5 Apademar A Apademar A 30 64 42 50
6 RUD La Carlota Carlota 30 50 54 44
7 Montalbeño Montalbeño 30 48 47 42
8 Salerm Puente Genil Sub 19 Salerm 30 60 66 38
9 Palma del Rio Atlético Sub Palma 30 47 58 36
10 CD Apedem CD Apedem 30 40 51 34
11 Palomera-Naranjo Palomera-Nar 30 46 62 31
12 CD Deportivo Cordoba CF A Deportivo 30 48 57 30
13 La Rambla AD Rambla 30 45 71 30
14 La Ribera del Guadalquivir Ribera 30 46 75 30
15 Sporting de Benameji Sporting 30 38 77 24
16 Almodóvar del Río C.F. Almodóvar 30 25 69 17
TEMPORADA 2016/2017
2ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 Don Bosco CF Sub 19 Bosco 30 79 29 76
2 Los Califas Los Califas 30 121 41 71
3 Séneca B CF Séneca 30 92 35 63
4 Apademar A Apademar A 30 87 58 57
5 CD Apedem CD Apedem 30 61 53 47
6 CD Egabrense Egabrense 30 56 59 46
7 CD Deportivo Cordoba CF A Deportivo 30 60 53 45
8 Atco. Villanueva F.B. Atco. 30 50 61 43
9 Villafranca Villafranca 30 66 63 42
10 Salerm Puente Genil Sub 19 Salerm 30 60 59 42
11 CD Pozoblanco Sub 19 Pozoblanco 30 55 76 38
12 Montalbeño Montalbeño 30 58 75 32
13 La Ribera del Guadalquivir Ribera 30 69 92 27
14 La Rambla AD Rambla 30 36 61 25
15 Peñarroya Pueblonuevo Peñarroya 30 32 96 15
16 Villa del Rio Servicio Depo Villa 30 34 105 15
TEMPORADA 2015/2016
2ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 Séneca B CF Séneca 29 66 22 63
2 Almodóvar del Río C.F. Almodóvar 29 62 29 57
3 Villafranca Villafranca 29 64 44 55
4 CD Pozoblanco Sub 19 Pozoblanco 29 55 31 54
5 Apademar A Apademar A 29 73 42 52
6 Don Bosco CF Sub 19 Bosco 29 47 27 47
7 CD Apedem CD Apedem 29 41 50 47
8 CD Deportivo Cordoba CF A Deportivo 29 57 39 46
9 Montalbeño Montalbeño 29 34 41 37
10 La Rambla AD Rambla 29 44 56 36
11 Salerm Puente Genil Sub 19 Salerm 29 49 64 33
12 Atco. Villanueva F.B. Atco. 29 31 65 28
13 Peñarroya Pueblonuevo Peñarroya 29 36 58 27
14 C.D. Stadium C.D. Stadium 30 33 76 25
15 Lucena C.F. Lucena C.F. 29 36 61 20
16 Parque Cruz Conde CF Parque Cruz 16 17 40 11
TEMPORADA 2014/2015
2ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 Córdoba CF Sub 19 B Córdoba 29 105 26 71
2 CD Deportivo Cordoba CF A Deportivo 30 111 30 67
3 Lucena C.F. Lucena C.F. 29 74 38 59
4 Salerm Puente Genil Sub 19 Salerm 29 70 37 54
5 CD Apedem CD Apedem 29 46 45 46
6 Villafranca Villafranca 29 82 56 45
7 Séneca Cf Séneca Cf 30 52 45 43
8 La Rambla AD Rambla 29 44 45 43
9 C.D. Stadium C.D. Stadium 29 62 60 39
10 Don Bosco CF Sub 19 Bosco 29 55 49 38
11 Atco. Villanueva F.B. Atco. 29 57 58 35
12 CD Egabrense Egabrense 29 60 63 30
13 Apademar A Apademar A 29 47 57 30
14 Almodóvar del Río C.F. Almodóvar 28 54 63 27
15 Atlético Baenense Atlético 29 28 121 14
16 Prieguense AF Prieguense 18 7 161 0

  USO DE MEMORIA  
5,112,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0900
Total Execution Time  0.0914
  CADENA URL  
/historico/Atletico-Villanueva-Juvenil
  GET DATOS  
$_GET['/historico/Atletico-Villanueva-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0024  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 = 'Atletico-Villanueva-Juvenil' 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.0033  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 = 'Atletico-Villanueva-Juvenil' 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.0019  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=19485 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=19485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19485 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=19485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 44720
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19485 AND type_rel = 2
0.0023  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 = '19485' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 44720 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=19485 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (52185,44720) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 52185 AND teamId = 19485
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 44720 AND teamId = 19485
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 44720 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '19485' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19485' and rp.type = 4
0.0021  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 = '19485' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 19485 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 44720 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 39954 AND t.round = 30 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 `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 = 34208 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 = 17030 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 4265 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC