4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Marianistas
TEMPORADA 2021/2022
3ª ARAGÓN CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Santa Venecia A Santa 26 151 25 70
2 Montañana Montañana 26 107 31 69
3 Cristo Rey B Cristo 26 90 25 59
4 Alfajarin Alfajarin 26 85 50 55
5 San G Arrabal B Arrabal 26 94 38 50
6 Miralbueno Ctrodep Miralbueno 26 57 41 42
7 Pina Pina 26 45 40 35
8 Cuarte Club Deportivo B Cuarte Club 26 61 69 35
9 Hernan Cortes Junquera C Hernan 26 46 67 28
10 Marianistas Marianistas 26 39 69 27
11 Helios Cn B Helios Cn B 26 48 98 21
12 Utebo Utebo 26 34 118 18
13 San Agustin CD Agustin 26 15 135 11
14 Mozarrifar CD Atlético Mozarrifar 26 31 97 6
TEMPORADA 2018/2019
3ª ANDALUZA CÁDIZ CADETE GRUPO 8
Equipo PJ GF GC Puntos
1 Divina Pastora Sanluqueña Divina 30 147 28 82
2 Roteña Roteña 30 135 23 79
3 Marianistas Marianistas 30 152 21 74
4 Sanlucar Sanlucar 30 142 52 67
5 Escuela Futbol Paquete Escuela 30 116 53 66
6 Chipiona CF A Chipiona 30 120 46 53
7 CD Rota CD Rota 30 70 65 41
8 Trebujena CF Trebujena 30 69 81 40
9 Nueva Jarilla AD Nueva 30 91 111 36
10 CD Guadalcacín B Guadalcacín 30 49 80 36
11 Rosario de Rota Rosario Rota 30 80 114 35
12 Federico Mayo Federico 30 85 123 34
13 Juventud Jerez Industrial Juventud 30 81 101 33
14 La Jerezana La Jerezana 30 29 116 10
15 Aficion Xerecista Aficion 30 35 233 7
16 Algaida UD Algaida UD 30 27 181 6
TEMPORADA 2017/2018
3ª ANDALUZA CÁDIZ CADETE GRUPO 5
Equipo PJ GF GC Puntos
1 Divina Pastora Sanluqueña A Divina 27 123 27 68
2 Estrella Portuense B Estrella 26 116 27 65
3 San Jose Obrero UD B Jose Obrero 26 111 30 65
4 Sanlucar B Sanlucar B 26 129 15 64
5 Juventud Jerez Industrial Juventud 26 64 46 46
6 Xerez Deportivo B Xerez 27 65 44 45
7 Roteña Roteña 26 86 64 38
8 Los Frailes Los Frailes 26 59 81 36
9 Marianistas Marianistas 26 81 70 34
10 Nextstars Nextstars 27 70 81 32
11 Rvo Portuense Club Futbol B Portuense 27 63 84 30
12 La Salle Jerez CD Salle Jerez 27 52 74 23
13 Barriada de la Playa Barriada 27 27 89 22
14 Rosario de Rota B Rosario Rota 26 27 114 9
15 Escuela Futbol Paquete B Escuela 26 13 240 0
TEMPORADA 2016/2017
3ª ANDALUZA CÁDIZ CADETE GRUPO 5
Equipo PJ GF GC Puntos
1 Amigos Cruz Roja Jerez A Amigos Cruz 29 190 24 82
2 Marianistas Marianistas 30 188 28 74
3 Chipiona CF A Chipiona 30 148 27 73
4 Escuela Futbol Paquete A Escuela 30 170 48 67
5 Juventud Jerez Industrial Juventud 29 156 45 66
6 Veteranos Xerez Veteranos 30 149 64 61
7 Icovesa Icovesa 30 99 93 44
8 San Jose Obrero UD B Jose Obrero 29 88 84 44
9 Sanlucar B Sanlucar B 30 122 99 43
10 Pueblo Nuevo La Granja B Pueblo Nuevo 30 97 77 42
11 CD Guadalcacín B Guadalcacín 30 85 77 32
12 La Salle Jerez CD Salle Jerez 29 57 147 22
13 Divina Pastora Sanluqueña B Divina 28 66 142 20
14 Xerez Club Balompie A Xerez Club. 30 63 169 18
15 Federico Mayo Federico 30 29 163 13
16 San Benito B CF Benito 30 14 255 0
TEMPORADA 2015/2016
3ª ANDALUZA CÁDIZ CADETE GRUPO 5
Equipo PJ GF GC Puntos
1 Flamenco CF Flamenco CF 20 75 25 48
2 Amigos Cruz Roja Jerez A Amigos Cruz 20 85 22 41
3 Liberacion Liberacion 20 70 35 38
4 Pueblo Nuevo La Granja B Pueblo Nuevo 20 48 43 32
5 Juventud Jerez Industrial Juventud 20 61 49 32
6 Xerez Club Balompie A Xerez Club. 20 49 46 32
7 Escuela Futbol Paquete Escuela 20 68 47 31
8 Marianistas Marianistas 20 72 44 31
9 San Benito A Benito 20 39 65 19
10 Pago San Jose Jerez Pago Jose J. 20 40 90 14
11 Federico Mayo Federico 0 0 0 0
12 Distrito La Granja Distrito 20 15 156 0
TEMPORADA 2014/2015
2ª ARAGÓN CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 CDU La Jota Vadorrey Sub 16 Jota 29 187 22 80
2 San Jose San Jose 30 117 25 74
3 Casablanca Casablanca 30 125 27 72
4 Escalerillas AT A Escalerillas 30 121 21 69
5 Marianistas Marianistas 30 120 45 65
6 Olivar Olivar 30 73 35 58
7 Venecia Venecia 30 61 49 52
8 Montañana Montañana 30 42 86 32
9 Delicias Delicias 30 68 71 31
10 Fuentes Fuentes 30 57 83 30
11 Valdefierro Valdefierro 30 61 106 29
12 Santo Juventud Santo 30 35 97 28
13 Santa Isabel Santa Isabel 30 42 101 25
14 El Gancho El Gancho 30 47 124 25
15 Huracan Huracan 29 40 148 17
16 San Antonio San Antonio 30 27 183 7

  USO DE MEMORIA  
5,158,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1029
Total Execution Time  0.1042
  CADENA URL  
/historico/Marianistas-Cadete
  GET DATOS  
$_GET['/historico/Marianistas-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0027  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 = 'Marianistas-Cadete' 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.0034  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 = 'Marianistas-Cadete' 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.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=29328 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=29328 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=29328 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=29328 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=29328 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=29328 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=29328 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 65068
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29328 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=815 AND type_rel = 3
0.0028  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 = '29328' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '29328' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '29328' 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 = 65068 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=29328 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (65068) 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 = 65068 AND teamId = 29328
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 `tables2022` 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 = 65068 AND t.round = 26 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 = '29328' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0023  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '29328' 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 = '29328' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 29328 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0036  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 = 65068 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.0039  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 = 45924 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 `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 = 40271 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 34464 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 17260 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 5145 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 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 = 65068 ORDER BY nameShow LIMIT 100