4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Estrella Portuense FC
TEMPORADA 2022/2023
3ª ANDALUZA CÁDIZ GRUPO 2
Equipo PJ GF GC Puntos
1 AD Taraguilla Taraguilla 34 131 23 91
2 Athletic Nueva Jarilla Athletic 34 85 42 74
3 Puerto Real Puerto Real 34 103 44 70
4 CD Rivera CD Rivera 34 72 39 70
5 UD Los Barrios B Barrios 34 79 49 63
6 AD Burreños Burreños 34 59 36 60
7 CF Sherry Atlético Sherry 34 72 50 60
8 CD Benalup CD Benalup 34 68 51 56
9 RC Portuense B Portuense 34 67 67 50
10 Novo Chiclana Novo 33 58 60 43
11 CD La Rock Puente FC Rock Puente 34 64 84 43
12 Federico Mayo C.F. Federico 34 55 73 33
13 Nextstars B Nextstars B 34 52 75 32
14 Rayo Alcalá Rayo Alcalá 34 43 86 29
15 Medina Balompié Medina 34 45 89 24
16 Cañorrera Cañorrera 34 39 88 24
17 Union Deportiva Esperanza Union 34 34 95 20
18 Estrella Portuense FC Estrella 33 27 102 13
TEMPORADA 2019/2020
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Guadiaro Guadiaro 25 79 17 69
2 Los Cortijillos Cortijillos 25 53 20 55
3 UD Algaida UD Algaida 25 56 24 48
4 Xerez Deportivo B Xerez 25 65 34 47
5 CD Jédula CD Jédula 25 45 33 41
6 San Fernando CD B Fernando 25 42 34 41
7 CD Rivera CD Rivera 25 36 30 40
8 RC Portuense Portuense 25 42 32 39
9 Divina Pastora Sanluqueña Divina 25 28 41 31
10 Amigos Cruz Roja Jerez Amigos Cruz 25 39 45 28
11 J. Sanluqueña Sanluqueña 25 39 46 28
12 Medina Balompié Medina 25 36 41 27
13 Estrella Portuense FC Estrella 25 23 39 25
14 Rayo Sanluqueño Rayo 25 21 40 25
15 Alcalá del Valle Alcalá 25 27 53 24
16 Espera C.F. Espera C.F. 25 22 54 23
17 Cañorrera Cañorrera 25 18 65 21
18 San Jose Obrero UD Jose Obrero 25 30 53 20
TEMPORADA 2018/2019
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 San Bernardo Bernardo 34 73 41 76
2 Puerto Real CF Puerto Real 34 75 36 74
3 Chipiona CF Chipiona CF 34 67 33 72
4 Barbate Barbate 33 75 46 69
5 Los Cortijillos Cortijillos 34 62 34 63
6 Espera C.F. Espera C.F. 34 62 37 56
7 CD Jédula CD Jédula 34 68 44 56
8 At. Sanluqueño B Sanluqueño 34 57 40 51
9 Medina Balompié Medina 33 59 48 50
10 San Jose Obrero UD Jose Obrero 34 51 63 40
11 Rayo Sanluqueño Rayo 34 55 76 39
12 C.D. La Salle C.D. Salle 34 36 57 38
13 Estrella Portuense FC Estrella 34 34 60 34
14 Juventud Jerez Industrial Juventud 34 47 68 33
15 Divina Pastora Sanluqueña Divina 34 52 76 31
16 San Jose Atletico Jose 34 44 70 30
17 Facinas Facinas 34 37 86 26
18 Prado del Rey Prado 34 40 79 19
TEMPORADA 2017/2018
3ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Estrella Portuense FC Estrella 19 49 16 44
2 Aficion Xerecista Aficion 20 55 34 41
3 Juventud Jerez Industrial Juventud 18 36 20 38
4 San Jose Atletico Jose 18 38 27 37
5 Portuense R.C. Portuense 19 39 29 35
6 Ud Bornense Ud Bornense 17 30 27 24
7 Cañorrera Cañorrera 18 27 34 22
8 Amigos Cruz Roja Jerez Amigos Cruz 19 29 26 19
9 Rayo Sanluqueño B Rayo 18 27 47 16
10 Rota B Rota B 20 26 49 10
11 Arcos B Arcos B 0 0 0 0
12 Xerez Club Balompie Xerez Club. 0 0 0 0
13 Federico Mayo B Federico 12 7 54 0

  USO DE MEMORIA  
5,112,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5380
Total Execution Time  0.5393
  CADENA URL  
/historico/Cd-Estrella-Portuense-Fc-Senior
  GET DATOS  
$_GET['/historico/Cd-Estrella-Portuense-Fc-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0132  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 = 'Cd-Estrella-Portuense-Fc-Senior' 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.0141  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 = 'Cd-Estrella-Portuense-Fc-Senior' 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.0126  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=103195 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=103195 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=103195 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=103195 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=103195 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 68942
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103195 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=420 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 420 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  SELECT /*53 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 (685788,641934,638815,68963,68433) 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 = '103195' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '103195' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = '103195' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 68942 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139  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=103195 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0132  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 (68942) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 68942 AND teamId = 103195
0.0272  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 = 68942 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135  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 = '103195' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '103195' and rp.type = 4
0.0136  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 = '103195' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 events2023 e ON e.player_id = p.id AND e.league_id = 68942 WHERE rp.league_id = 68942 AND rp.teamId = 103195 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.0132  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 events2023 e ON e.player_id = p.id AND e.league_id = 68942 WHERE rp.league_id = 68942 AND rp.teamId = 103195 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 events2023 e ON e.player_id = p.id AND e.league_id = 68942 WHERE rp.league_id = 68942 AND rp.teamId = 103195 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 103195 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0255  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` 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 = 68942 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 51363 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 39903 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 68942 ORDER BY nameShow LIMIT 100