4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Medina Balompié
TEMPORADA 2023/2024
3ª ANDALUZA CÁDIZ GRUPO 1
Equipo PJ GF GC Puntos
1 Tesorillo Tesorillo 22 55 22 52
2 Medina Balompié Medina 22 55 23 52
3 Jimena Athletic Club Jimena 22 52 25 41
4 CD Benalup CD Benalup 22 47 34 38
5 UD Los Barrios B Barrios 22 52 33 38
6 Castellar UD Castellar 22 63 41 35
7 CD Rivera CD Rivera 22 52 53 30
8 CD La Rock Puente FC Rock Puente 22 41 52 26
9 Facinas Facinas 22 38 70 18
10 Atlético Pastores Atlético 22 24 47 16
11 Rayo Alcalá Rayo Alcalá 22 26 68 14
12 Bahia de Algeciras CF Bahia 22 24 61 12
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 2021/2022
3ª ANDALUZA CÁDIZ GRUPO 2
Equipo PJ GF GC Puntos
1 Fundacion Cadiz Fundacion 24 50 24 42
2 RC Portuense B Portuense 24 48 27 41
3 CD Rivera CD Rivera 24 40 25 40
4 Medina Balompié Medina 23 35 22 40
5 CD Benalup CD Benalup 23 34 22 40
6 Puerto Serrano Atletico Puerto 24 39 30 37
7 Espera C.F. Espera C.F. 24 45 41 37
8 Ubrique Union Dva Ubrique 24 51 40 35
9 Rayo Alcalá Rayo Alcalá 24 26 40 31
10 Prado del Rey Prado 24 33 55 28
11 Ud Bornense Ud Bornense 24 31 42 24
12 Tiempo Libre Tiempo Libre 24 29 53 19
13 Nextstars B Nextstars B 22 17 57 11
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
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Alcalá del Valle Alcalá 33 69 31 72
2 Tarifa UD Tarifa UD 34 87 44 68
3 Ubrique UD Ubrique UD 32 67 23 67
4 C.D. La Salle C.D. Salle 33 75 33 66
5 Algeciras CF B Algeciras 32 69 34 65
6 San Bernardo Bernardo 31 63 46 59
7 Puerto Real CF Puerto Real 33 64 49 55
8 Medina Balompié Medina 32 58 59 43
9 Los Cortijillos Cortijillos 32 44 45 43
10 Prado del Rey Prado 32 45 62 41
11 Barbate Barbate 30 42 44 37
12 Divina Pastora Sanluqueña Divina 33 40 61 32
13 Espera C.F. Espera C.F. 32 30 46 31
14 CD Rivera CD Rivera 33 41 76 31
15 Facinas Facinas 33 44 65 29
16 At. Sanluqueño B Sanluqueño 31 53 78 27
17 Alma de África Alma África 32 42 78 20
18 Federico Mayo C.F. Federico 26 33 92 10
TEMPORADA 2016/2017
3ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Alcalá del Valle Alcalá 17 50 19 35
2 Medina Balompié Medina 17 29 19 32
3 Facinas Facinas 17 37 29 30
4 Divina Pastora Sanluqueña Divina 17 45 28 29
5 Alma de África Alma África 17 35 24 29
6 Xerez Balompié Xerez 17 33 31 28
7 Ud Bornense Ud Bornense 17 20 30 21
8 Juventud Jerez Industrial Juventud 17 40 33 15
9 Federico Mayo B Federico 17 17 48 12
10 Español de Vejer Español 9 6 51 0

  USO DE MEMORIA  
5,407,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0986
Total Execution Time  0.0998
  CADENA URL  
/historico/Cd-Medina-Balompie-Senior
  GET DATOS  
$_GET['/historico/Cd-Medina-Balompie-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0026  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-Medina-Balompie-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.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=91133 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=91133 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 73744
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=91133 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=420 AND type_rel = 3
0.0020  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.0021  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.0021  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 = '91133' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '91133' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '91133' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 73744 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=91133 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 (73744) 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 WHERE league_id = 73744 AND teamId = 91133
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 73744 AND t.round = 22 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 = '91133' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '91133' and rp.type = 4
0.0020  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 = '91133' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 events2024 e ON e.player_id = p.id AND e.league_id = 73744 WHERE rp.league_id = 73744 AND rp.teamId = 91133 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.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 73744 WHERE rp.league_id = 73744 AND rp.teamId = 91133 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events2024 e ON e.player_id = p.id AND e.league_id = 73744 WHERE rp.league_id = 73744 AND rp.teamId = 91133 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 91133 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 `tables2024` 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 = 73744 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.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 `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.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` 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 = 64466 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 `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.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 `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 = 45002 AND t.round = 34 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 `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 = 39686 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 34315 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC