4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Santa Isabel RSD
TEMPORADA 2022/2023
2ª ARAGÓN JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Santo D. Juventud Sub 19 Santo 30 124 29 83
2 Pina CD Pina CD 30 113 48 76
3 Rey Fernando de Aragón Fernando 30 137 55 74
4 Hernan Cortes Junquera B Hernan 30 131 22 72
5 Vedruna A Vedruna A 30 67 72 52
6 Alfajarin CF Alfajarin 30 87 74 50
7 Santa Isabel RSD Santa Isabel 30 66 63 44
8 San Agustin CD Agustin 30 61 60 44
9 San Gregorio Gregorio 30 66 64 42
10 Montearagon AD Montearagon 30 59 80 37
11 Valdefierro B Valdefierro 30 55 100 29
12 Utebo B Utebo B 30 51 84 26
13 Delicias Delicias 30 41 84 20
14 Helios CN Helios CN 30 51 116 18
15 San José UD B José 30 36 116 16
16 Stadium Casablanca B Juv. Stadium 30 22 100 11
TEMPORADA 2019/2020
2ª ARAGÓN JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Los Molinos Los Molinos 21 84 25 58
2 Alfajarin CF Alfajarin 21 57 37 45
3 Garrapinillos Garrapinillo 19 45 28 39
4 Santa Isabel RSD Santa Isabel 21 44 27 39
5 Seulcar San Fernando Seulcar 20 34 33 33
6 Delicias Club Deportivo A Delicias 21 53 38 32
7 Balsas Picarral UD Balsas 21 61 44 30
8 Fleta A Fleta A 21 43 38 30
9 La Cartuja FC B Cartuja 21 55 47 26
10 Cd Oliver Cd Oliver 21 39 37 25
11 El Salvador Sub 19 Salvador 20 34 57 19
12 San Jose B San Jose B 21 37 65 18
13 St. Venecia AD B Venecia 21 38 79 13
14 Olivar Estadio Miralbueno E Olivar 19 30 99 6
TEMPORADA 2018/2019
2ª ARAGÓN JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Miralbueno Ctrodep Miralbueno 33 122 40 78
2 Utebo CF Utebo CF 33 138 37 77
3 La Cartuja FC Cartuja 33 114 54 72
4 San José UD Sub 19 José 33 107 29 71
5 Villamayor CD Villamayor 33 123 59 69
6 San Juan AD San Juan AD 33 138 57 64
7 Santa Isabel RSD Santa Isabel 33 118 73 60
8 Puebla de la Calzada Puebla 33 78 65 60
9 Garrapinillos Garrapinillo 32 79 74 47
10 Zuera Zuera 33 68 79 42
11 Huracan CD Huracan CD 33 83 99 42
12 Hernan Cortes Junquera B Hernan 33 60 97 38
13 San Gregorio Arrabal C Gregorio 33 89 85 37
14 Olivar Estadio Miralbueno Olivar 33 84 94 35
15 Los Molinos Los Molinos 16 44 66 19
16 Rey Fernando de Aragón Fernando 33 30 159 9
17 Fleta A Fleta A 33 31 188 7
18 Marianistas B Marianistas 33 27 178 6
TEMPORADA 2017/2018
PREFERENTE ARAGÓN JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CF Hernán Cortés Sub 19 Hernán 34 95 51 82
2 Santa Casablanca Santa 34 84 44 70
3 CD Marianistas Sub 19 Marianistas 34 76 41 65
4 Giner Torrero CD Sub 19 Giner 34 79 48 65
5 E. Miralbueno Olivar Sub 19 Miralbueno 34 73 59 57
6 Amistad Sub 19 B Amistad 34 79 70 51
7 Santa Isabel RSD Santa Isabel 34 68 80 48
8 El Salvador Sub 19 Salvador 34 66 54 46
9 CD Ebro Sub 19 B Ebro 34 60 49 44
10 Santo D. Juventud Sub 19 Santo 33 56 67 43
11 Montecarlo Sub 19 B Montecarlo 34 50 58 42
12 Ranillas At. Ranillas 34 69 85 38
13 Cuarte CD Cuarte CD 33 60 75 36
14 UD Balsas Picarral Sub 19 B Balsas 34 50 62 35
15 Utebo CF Sub 19 Utebo 34 42 71 35
16 Oliver CD Sub 19 Oliver 34 63 88 34
17 Union La Jota Vadorrey Union Jota. 34 66 100 32
18 San Gregorio Arrabal B Gregorio 34 50 84 27
TEMPORADA 2016/2017
2ª ARAGÓN JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Hernan Cortes Junquera B Hernan 32 125 42 77
2 Santa Isabel RSD Santa Isabel 32 110 43 73
3 San José UD Sub 19 José 32 98 42 70
4 Valdefierro A Valdefierro 32 85 31 69
5 Santa Venecia Santa 32 106 68 61
6 El Olivar EM A Olivar 32 88 60 54
7 Ranillas At. Ranillas 32 74 65 50
8 Villamayor CD Villamayor 32 95 92 50
9 Alfinden AD Alfinden AD 32 66 72 43
10 Actur Pablo Iglesias CD B Actur Pablo 32 77 75 40
11 Cd Giner Torrero Giner 32 57 61 40
12 Montañana AD Montañana 32 72 82 38
13 Delicias Club Deportivo B Delicias 32 49 92 25
14 El Gancho El Gancho 32 57 103 24
15 Union La Jota Vadorrey B Union Jota. 32 33 101 22
16 El Burgo de Ebro Burgo Ebro 32 60 143 21
17 Fleta A Fleta A 32 56 136 16
TEMPORADA 2015/2016
2ª ARAGÓN JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Club Zaragoza Sub 19 Racing Club 30 151 28 78
2 Santa Isabel RSD Santa Isabel 30 144 34 77
3 Huracan CD Huracan CD 30 133 45 77
4 San Gregorio Arrabal C Gregorio 30 114 59 61
5 Garrapinillos Garrapinillo 30 101 53 59
6 Ranillas At. Ranillas 30 114 58 58
7 Valdefierro B Valdefierro 30 90 58 49
8 Casetas UD Casetas UD 30 61 72 46
9 San Mateo San Mateo 30 61 103 37
10 La Cartuja FC Cartuja 30 69 97 33
11 El Salvador Sub 19 Salvador 30 68 96 33
12 Olivar B Olivar B 30 65 80 29
13 Movera CD Movera CD 29 30 70 22
14 Escalerillas B Escalerillas 30 38 114 14
15 Cristo Rey AD Cristo 29 38 214 10
16 CD Delicias Sub 19 Delicias 30 39 135 6
TEMPORADA 2014/2015
1ª ARAGÓN JUVENIL
Equipo PJ GF GC Puntos
1 Oliver CD Sub 19 Oliver 33 56 32 69
2 Pina CD Pina CD 33 74 44 63
3 San Gregorio Arrabal B Gregorio 33 67 48 55
4 Santa Isabel RSD Santa Isabel 33 65 57 54
5 Union La Jota Vadorrey Union Jota. 33 77 71 53
6 El Salvador Sub 19 Salvador 33 72 57 51
7 Utebo CF Utebo CF 33 58 47 49
8 Casetas UD Casetas UD 33 65 57 49
9 Balsas Picarral UD Balsas 33 70 73 45
10 Venecia St. AD Venecia 33 53 66 45
11 CD Delicias Sub 19 Delicias 33 57 54 44
12 CD Ebro Sub 19 C Ebro 33 57 57 42
13 Escalerillas B Escalerillas 33 69 77 42
14 CD Valdefierro Sub 19 Valdefierro 33 55 65 42
15 San Jose San Jose 33 54 63 41
16 San Fernando Amesa Puesta Fernando 33 60 85 41
17 Hernan Cortes Junquera B Hernan 33 56 75 32
18 Puerto Venecia Aragon Puerto 17 15 52 5

  USO DE MEMORIA  
5,453,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.3957
Total Execution Time  0.3970
  CADENA URL  
/historico/Santa-Isabel-Rsd-Juvenil
  GET DATOS  
$_GET['/historico/Santa-Isabel-Rsd-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0227  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 = 70041
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29225 AND type_rel = 2
0.0111  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=812 AND type_rel = 3
0.0121  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 = '29225' ORDER BY l.year DESC,cat.coefficient DESC
0.0118  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 = '29225' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0116  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 = 70041 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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=29225 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (70041) 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.0106  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70041 AND teamId = 29225
0.0107  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 70041 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0109  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 = '29225' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '29225' and rp.type = 4
0.0114  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 = '29225' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0124  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 = 29225 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70041 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.0122  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 = 52036 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 44901 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 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 = 45837 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39866 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 39870 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 34182 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 34631 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 16967 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119  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 = 16970 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 5137 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC