4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del AD San Juan
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 CD Teruel CD Teruel 22 34 11 49
2 Huesca B Huesca B 22 36 18 45
3 CD Belchite 97 Belchite 22 22 9 35
4 Deportivo Aragón Deportivo 22 32 14 34
5 Illueca Illueca 22 23 16 34
6 CD Binéfar CD Binéfar 22 29 17 32
7 Atlético Monzón Atlético 22 26 19 31
8 CD Cariñena Cariñena 22 21 23 27
9 CDJ Tamarite Tamarite 22 19 29 25
10 Valdefierro Valdefierro 22 20 36 22
11 Fraga Fraga 22 17 21 22
12 AD San Juan AD San Juan 22 0 66 0
13 Brea Brea 22 34 12 42
14 CD Cuarte CD Cuarte 22 32 21 39
15 Utebo Utebo 22 21 15 37
16 Barbastro Barbastro 22 27 18 36
17 SD Borja SD Borja 22 29 23 31
18 Calamocha Calamocha 22 24 19 30
19 Sariñena Sariñena 22 36 36 29
20 CF Epila CF Epila 22 23 23 26
21 Robres Robres 22 23 31 26
22 Almudévar Almudévar 22 17 32 22
23 Villanueva CF Villanueva 22 16 39 18
24 Sabiñánigo Sabiñánigo 22 24 37 14
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 SD Tarazona SD Tarazona 28 58 20 65
2 CD Teruel CD Teruel 29 53 19 63
3 Brea Brea 29 41 23 54
4 Deportivo Aragón Deportivo 28 51 23 51
5 CD Cuarte CD Cuarte 28 39 32 50
6 AD San Juan AD San Juan 28 38 30 46
7 SD Borja SD Borja 28 37 29 45
8 Illueca Illueca 28 42 37 43
9 Sariñena Sariñena 29 36 32 43
10 CD Binéfar CD Binéfar 29 34 30 41
11 Barbastro Barbastro 29 35 33 39
12 Fraga Fraga 29 35 33 37
13 Utebo Utebo 29 37 41 32
14 Atlético Monzón Atlético 29 24 34 32
15 Robres Robres 29 31 39 28
16 CDJ Tamarite Tamarite 29 27 45 28
17 Calamocha Calamocha 28 32 48 27
18 CD Belchite 97 Belchite 29 21 35 26
19 Villanueva CF Villanueva 29 23 48 24
20 Valdefierro Valdefierro 28 22 56 22
21 Almudévar Almudévar 28 18 47 19
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 SD Tarazona SD Tarazona 38 72 17 80
2 Illueca Illueca 38 60 34 72
3 Deportivo Aragón Deportivo 38 58 19 72
4 Sariñena Sariñena 38 51 30 71
5 SD Borja SD Borja 38 54 30 70
6 Utebo Utebo 38 50 31 67
7 Brea Brea 38 48 34 61
8 AD San Juan AD San Juan 38 44 30 58
9 Atlético Monzón Atlético 38 41 35 57
10 Almudévar Almudévar 38 42 42 50
11 CD Binéfar CD Binéfar 38 45 50 47
12 Calamocha Calamocha 38 41 55 46
13 Villanueva CF Villanueva 38 37 56 44
14 Robres Robres 38 38 46 43
15 CDJ Tamarite Tamarite 38 36 59 43
16 CD Belchite 97 Belchite 38 32 42 38
17 San Lorenzo Flumen Lorenzo 38 32 69 33
18 Sabiñánigo Sabiñánigo 38 33 55 32
19 CD La Almunia Almunia 38 38 71 31
20 Casetas Casetas 38 20 67 23
TEMPORADA 2017/2018
PREFERENTE ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 AD San Juan AD San Juan 34 69 26 74
2 Calamocha Calamocha 34 66 31 69
3 CD Mequinenza Mequinenza 34 64 34 62
4 Fuentes Fuentes 33 45 31 56
5 At. Calatayud Calatayud 34 59 48 56
6 CF Epila CF Epila 34 48 34 54
7 CD Cuarte CD Cuarte 34 59 40 52
8 Alcañiz Alcañiz 34 51 40 51
9 Andorra Andorra 34 51 44 49
10 Actur Pablo Iglesias Actur Pablo 34 56 47 48
11 Cella Cella 34 45 41 48
12 UD San José José 34 57 52 47
13 CD Utrillas CD Utrillas 34 46 54 42
14 Mores CD Mores CD 34 22 34 34
15 Teruel Teruel 33 24 74 25
16 Alfindén A.D Alfindén 34 32 65 24
17 Morata CD Morata CD 34 29 70 23
18 Atlético Escalerillas Atlético 34 24 82 21
TEMPORADA 2016/2017
1ª REGIONAL ARAGÓN GRUPO 1
Equipo PJ GF GC Puntos
1 San Gregorio Arrabal Gregorio 34 79 42 72
2 Alfindén A.D Alfindén 34 80 39 67
3 AD San Juan AD San Juan 34 68 46 64
4 CD Delicias CD Delicias 33 73 49 59
5 San Fernando Fernando 33 72 65 57
6 El Salvador SD Salvador 34 77 56 56
7 Ranillas At. Ranillas 34 78 61 53
8 El Gancho CF Gancho 33 60 46 53
9 La Cartuja FC Cartuja 33 54 40 50
10 Miralbueno CD Miralbueno 34 74 62 50
11 Zuera Zuera 34 52 61 42
12 Union La Jota Vadorrey Union Jota. 34 62 76 39
13 Cd Movera Cd Movera 34 56 78 38
14 Anento Anento 34 48 60 37
15 El Burgo de Ebro Burgo Ebro 34 46 72 35
16 Ajax de Juslibol Ajax 34 62 95 35
17 CD Cuarte B CD Cuarte B 34 46 73 31
18 Villanueva B Villanueva 32 32 98 22
TEMPORADA 2015/2016
1ª REGIONAL ARAGÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Valdefierro Valdefierro 33 86 28 83
2 Zaragoza 2014 Zaragoza 32 79 34 80
3 Alfindén A.D Alfindén 33 71 57 56
4 El Salvador SD Salvador 33 71 52 54
5 AD San Juan AD San Juan 33 67 60 52
6 Zuera Zuera 33 54 55 51
7 La Cartuja FC Cartuja 33 61 54 50
8 CD Delicias CD Delicias 33 66 64 46
9 El Gancho CF Gancho 32 64 67 43
10 San Fernando Fernando 32 47 53 40
11 Anento Anento 33 52 76 39
12 El Burgo de Ebro Burgo Ebro 33 57 65 39
13 CD Cuarte B CD Cuarte B 33 51 59 38
14 Union La Jota Vadorrey Union Jota. 33 61 72 37
15 Ranillas At. Ranillas 33 48 73 36
16 Huracan CD Huracan CD 17 30 35 26
17 Utebo CF B Utebo CF B 33 47 68 26
18 San Andres AF Andres 32 37 77 17
TEMPORADA 2014/2015
1ª REGIONAL ARAGÓN GRUPO 1
Equipo PJ GF GC Puntos
1 San Gregorio Arrabal Gregorio 34 89 41 73
2 Hernán Cortés Junquera Hernán 34 94 39 70
3 Zaragoza 2014 Zaragoza 34 76 39 68
4 Alfindén A.D Alfindén 34 69 35 67
5 El Salvador SD Salvador 34 76 62 54
6 San Andres AF Andres 34 51 59 48
7 AD San Juan AD San Juan 34 58 64 47
8 CD Cuarte B CD Cuarte B 34 52 54 45
9 Huracan CD Huracan CD 34 67 64 44
10 La Cartuja FC Cartuja 34 66 65 44
11 San Fernando Fernando 34 53 59 44
12 El Gancho CF Gancho 34 60 88 44
13 Utebo CF B Utebo CF B 34 64 73 43
14 Anento Anento 34 53 59 42
15 Ranillas At. Ranillas 34 48 60 39
16 Cd Movera Cd Movera 34 46 76 37
17 Valdefierro CD Valdefierro 34 49 78 27
18 Perdiguera CD Perdiguera 34 33 89 19

  USO DE MEMORIA  
5,934,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6362
Total Execution Time  0.6382
  CADENA URL  
/historico/San-Juan-Ad
  GET DATOS  
$_GET['/historico/San-Juan-Ad']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0131  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 = 'San-Juan-Ad' 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.0136  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 = 'San-Juan-Ad' 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.0133  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=28979 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=28979 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=28979 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=28979 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=28979 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=28979 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=28979 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=28979 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=28979 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 58596
0.0130  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 = 61820
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=28979 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 28979 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (146375,146556,146890,148779,725638) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '28979' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '28979' 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 = 61820 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 = 58596 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=28979 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (61820,58596) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 58596 AND teamId = 28979
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 61820 AND teamId = 28979
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 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 = 58596 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '28979' 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 = '28979' 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 = '28979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0131  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 events2021 e ON e.player_id = p.id AND e.league_id = 58596 WHERE rp.league_id = 58596 AND rp.teamId = 28979 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.0133  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 events2021 e ON e.player_id = p.id AND e.league_id = 58596 WHERE rp.league_id = 58596 AND rp.teamId = 28979 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 events2021 e ON e.player_id = p.id AND e.league_id = 58596 WHERE rp.league_id = 58596 AND rp.teamId = 28979 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 28979 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0135  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 = 58596 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 50285 AND t.round = 31 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 `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 = 44405 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 39350 AND t.round = 34 ORDER BY team.conference 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 `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 = 34097 AND t.round = 34 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` 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 = 16770 AND t.round = 34 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 `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 = 5120 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 58596 ORDER BY nameShow LIMIT 100