4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San G. Arrabal Sub 14
TEMPORADA 2023/2024
DIVISIÓN HONOR ARAGÓN INFANTIL
Equipo PJ GF GC Puntos
1 Real Zaragoza Sub 14 Real 23 131 6 66
2 RC Zaragoza Sub 14 Zaragoza 23 78 11 57
3 UD Amistad Sub 14 Amistad 23 81 24 53
4 SD Huesca Sub 14 Huesca 23 64 27 51
5 Montecarlo Sub 14 Montecarlo 23 53 34 46
6 Atl. Teruel Sub 14 Atl. Teruel 23 40 53 40
7 CD Oliver Sub 14 Oliver 23 57 42 39
8 Balsas Picarral Sub 14 Balsas 23 39 47 30
9 St. Casablanca Sub 14 Casablanca 23 27 43 28
10 U. La Jota Vadorrey Sub 14 Jota 23 45 64 24
11 CD Ebro Sub 14 Ebro 23 37 64 24
12 Olivar Estadio Sub 14 Olivar 23 24 54 24
13 UD Fraga Sub 14 Fraga 23 24 51 18
14 Monzon Sub 14 Monzon 23 22 53 16
15 San G. Arrabal Sub 14 Arrabal 23 13 82 7
16 Teruel Sub 14 Teruel 23 21 101 5
TEMPORADA 2021/2022
3ª ARAGÓN INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Oliver B Oliver B 30 104 36 73
2 Valdefierro A Valdefierro 30 103 36 72
3 Los Molinos UD B INF Molinos 30 143 51 70
4 Olivar Estadio Miralbueno E Olivar 30 102 55 66
5 Delicias Club Deportivo A Delicias 30 73 43 56
6 Miralbueno Ctrodep Miralbueno 30 95 50 53
7 La Cartuja FC Cartuja 30 61 60 46
8 Bajo Aragon Caspe B Bajo Aragon 30 65 61 44
9 Fleta CD Fleta CD 30 68 76 41
10 Marianistas A Marianistas 30 79 86 39
11 San G. Arrabal Sub 14 Arrabal 30 87 93 37
12 Cuarte Club Deportivo C Cuarte Club 30 58 93 29
13 Santa Venecia Santa 30 50 87 25
14 Santo Juventud Santo 30 29 76 20
15 Ranillas At. Ranillas 30 49 146 8
16 Villamayor B Villamayor 30 32 149 8
TEMPORADA 2019/2020
3ª ARAGÓN INFANTIL GRUPO 3
Equipo PJ GF GC Puntos
1 Rey Fernando de Aragón Fernando 19 161 14 57
2 Delicias Club Deportivo Delicias 20 74 21 52
3 Helios Helios 20 60 37 39
4 Hernan Cortes Junquera A Hernan 20 47 64 29
5 Valdefierro Valdefierro 19 62 64 23
6 Zaragoza Cff A Zaragoza 20 40 43 23
7 Alfajarin A Alfajarin A 18 46 59 23
8 Fleta CD Fleta CD 19 45 58 23
9 Oliver Oliver 19 27 28 22
10 San Jose San Jose 19 38 52 21
11 Union La Jota Vadorrey CD Union Jota. 17 29 43 18
12 San G. Arrabal Sub 14 Arrabal 20 30 60 18
13 Maella CD Maella CD 16 10 126 1
TEMPORADA 2018/2019
3ª ARAGÓN INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Bajo Aragon Caspe B Bajo Aragon 26 94 8 73
2 Union La Jota Valdorrey A Union Jota. 26 110 14 65
3 Delicias Club Deportivo A Delicias 26 107 18 62
4 San G. Arrabal Sub 14 Arrabal 26 87 33 55
5 Hernán Cortés Junquera Hernán 26 73 30 50
6 Cristo Rey B Cristo 26 55 41 42
7 Valdefierro A Valdefierro 26 63 35 41
8 Santa Isabel RSD A Santa Isabel 26 81 41 39
9 Helios Cn A Helios Cn A 26 48 53 35
10 El Salvador El Salvador 26 42 74 23
11 Alfajarin B Alfajarin B 26 33 116 15
12 Santa Venecia C Santa 26 27 106 14
13 Leciñena R Leciñena R 26 25 130 14
14 Miralbueno Ctrodep Miralbueno 26 8 154 1
TEMPORADA 2017/2018
DIVISIÓN HONOR ARAGÓN INFANTIL
Equipo PJ GF GC Puntos
1 Real Zaragoza Sub 14 Real 30 135 13 82
2 SD Huesca Sub 14 Huesca 30 60 30 60
3 Santo Juventud Santo 30 45 20 52
4 CD Ebro Sub 14 Ebro 30 43 30 52
5 CD Oliver Sub 14 Oliver 30 68 52 50
6 UD Amistad Sub 14 Amistad 30 55 48 50
7 U. La Jota Vadorrey Sub 14 Jota 30 33 24 48
8 St. Casablanca Sub 14 Casablanca 30 51 43 46
9 Montecarlo Sub 14 Montecarlo 30 41 39 43
10 Olivar Estadio Sub 14 Olivar 30 36 41 42
11 Teruel Sub 14 Teruel 30 49 61 35
12 Peñas Oscenses A Peñas 30 23 47 33
13 Balsas Picarral Sub 14 Balsas 30 26 51 26
14 Ejea A Ejea A 30 29 73 23
15 San G. Arrabal Sub 14 Arrabal 30 24 71 17
16 Giner Torrero CD Giner 30 25 100 11
TEMPORADA 2016/2017
3ª ARAGÓN INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Montearagon Montearagon 26 129 16 72
2 Oliver C Oliver C 26 87 31 58
3 Racing Club Zaragoza B Racing Club 26 83 39 55
4 San G. Arrabal Sub 14 Arrabal 26 74 29 54
5 El Gancho El Gancho 26 62 23 53
6 Utebo C Utebo C 26 65 54 42
7 Olivar Estadio Miralbueno E Olivar 26 60 46 40
8 Alfajarin CF Alfajarin 26 50 75 28
9 Ranillas At. Ranillas 26 36 66 28
10 San Jose UD C Jose 26 42 61 27
11 Montecarlo B Montecarlo 26 35 67 26
12 San Agustin San Agustin 26 37 102 20
13 Delicias Club Deportivo A Delicias 26 28 75 14
14 Marianistas Marianistas 26 19 123 3
TEMPORADA 2015/2016
DIVISIÓN HONOR ARAGÓN INFANTIL
Equipo PJ GF GC Puntos
1 Real Zaragoza Sub 14 Real 30 123 14 78
2 SD Huesca Sub 14 Huesca 30 82 24 71
3 UD Amistad Sub 14 Amistad 30 73 40 61
4 Montecarlo Sub 14 Montecarlo 30 63 37 56
5 Olivar Estadio Sub 14 Olivar 30 54 49 45
6 Balsas Picarral Sub 14 Balsas 30 54 49 44
7 CD Oliver Sub 14 Oliver 30 47 47 43
8 Santo Juventud Santo 30 39 34 42
9 St. Casablanca Sub 14 Casablanca 30 38 35 42
10 Actur Pablo Iglesias Actur Pablo 30 50 58 36
11 CD Ebro Sub 14 Ebro 30 27 46 36
12 San G. Arrabal Sub 14 Arrabal 30 31 66 31
13 Venecia St. AD Venecia 30 33 59 30
14 Teruel CD Teruel CD 30 36 65 28
15 Ejea A Ejea A 30 27 86 20
16 Juventud de Huesca Juventud 30 26 94 9

  USO DE MEMORIA  
5,348,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1086
Total Execution Time  0.1098
  CADENA URL  
/historico/San-G-Arrabal-Cd-Infantil
  GET DATOS  
$_GET['/historico/San-G-Arrabal-Cd-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0036  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-G-Arrabal-Cd-Infantil' 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.0020  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=71358 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=71358 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=71358 AND type_rel = 2
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=816 AND type_rel = 3
0.0026  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 = '71358' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '71358' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '71358' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=71358 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74758) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74758 AND teamId = 71358
0.0019  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 = '71358' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '71358' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  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 = 71358 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 = 64438 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.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 `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 = 65081 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.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 `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 = 53153 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.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 `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 = 53166 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.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 `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 = 53165 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.0022  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 = 46237 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 `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 = 46265 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 46476 AND t.round = 26 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 = 40838 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 40775 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 `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 = 34387 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 35366 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 `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 = 35706 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 17555 AND t.round = 34 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 = 17600 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 `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 = 17729 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC