4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Alcalá del Río CF
TEMPORADA 2023/2024
3ª ANDALUZA SEVILLA GRUPO 3
Equipo PJ GF GC Puntos
1 CD Peñaflor Peñaflor 26 50 21 61
2 CD Fuentes CD Fuentes 27 55 28 58
3 Cantillana Cantillana 26 64 29 53
4 Alcalá del Río CF Alcalá Río 26 50 32 50
5 Campana Balompié Campana 27 45 41 45
6 CD Alanis CD Alanis 27 45 49 41
7 Brenes Balompié Brenes 27 42 39 41
8 Burguillos CD Burguillos 27 65 52 40
9 Priorato Juventud Priorato 27 47 47 36
10 CDF Cazalla CDF Cazalla 26 52 49 35
11 Celti Puebla Celti Puebla 27 44 45 35
12 Guadalcanal C.D Guadalcanal 27 58 55 32
13 Minas CF Minas CF 26 39 48 28
14 Deportivo Oduciarosal Deportivo 27 34 58 24
15 Constantina UD Constantina 21 29 50 19
16 Cañada Rosal CF Cañada 26 9 85 3
TEMPORADA 2022/2023
3ª ANDALUZA SEVILLA GRUPO 3
Equipo PJ GF GC Puntos
1 Alcolea del Río F.C. Alcolea Río 28 92 21 74
2 Campana Balompié Campana 28 78 43 59
3 CD Peñaflor Peñaflor 28 77 41 57
4 Priorato Juventud Priorato 28 67 52 48
5 Guillena Cf Guillena Cf 28 50 42 47
6 Brenes Balompié Brenes 28 75 60 42
7 Celti Puebla Celti Puebla 28 43 46 41
8 Alcalá del Río CF Alcalá Río 28 51 52 41
9 Guadalcanal C.D Guadalcanal 28 56 65 36
10 Constantina UD Constantina 28 44 56 35
11 CD Alanis CD Alanis 28 58 66 34
12 Burguillos CD Burguillos 28 52 66 31
13 Cantillana Cantillana 28 31 73 21
14 Minas CF Minas CF 28 31 69 14
15 Ventas de las Pajanosas Ventas 28 38 91 7
16 Villaverde B Villaverde 0 0 0 0
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA GRUPO 1
Equipo PJ GF GC Puntos
1 Puebla CF Puebla CF 32 74 20 77
2 Pilas Pilas 32 53 28 64
3 Olivarense Olivarense 32 54 20 61
4 JD Bormujos JD Bormujos 32 62 45 56
5 UD Villaverde Villaverde 32 69 50 53
6 UD Loreto UD Loreto 32 55 57 52
7 La Motilla La Motilla 32 44 36 46
8 San Juan San Juan 32 44 41 45
9 La Liara Balompie Liara 32 56 53 42
10 Espartinas CF Espartinas 32 38 53 40
11 Los Palacios CF Palacios 32 48 54 38
12 PD Rociera PD Rociera 32 47 59 36
13 Ibarburu CF Ibarburu CF 32 28 41 35
14 Brenes Balompié Brenes 32 46 67 30
15 CD Peñaflor Peñaflor 32 35 74 30
16 Atlético Sanlucar Atlético 32 39 60 29
17 Alcalá del Río CF Alcalá Río 32 45 79 25
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA GRUPO 3
Equipo PJ GF GC Puntos
1 UD Villaverde Villaverde 18 39 21 39
2 Camino Viejo Camino Viejo 18 38 19 37
3 Espartinas CF Espartinas 18 27 19 31
4 Alcalá del Río CF Alcalá Río 18 26 22 29
5 CD Peñaflor Peñaflor 18 36 25 26
6 San Juan San Juan 18 21 29 24
7 Brenes Balompié Brenes 18 24 24 20
8 Guillena Cf Guillena Cf 18 16 22 20
9 Aznalcollar C.D Aznalcollar 18 15 30 17
10 Constantina UD Constantina 18 12 43 9
TEMPORADA 2019/2020
2ª ANDALUZA SEVILLA GRUPO 1
Equipo PJ GF GC Puntos
1 Ibarburu CF Ibarburu CF 25 56 25 55
2 CDF Cazalla CDF Cazalla 25 43 15 54
3 Puebla CF Puebla CF 25 55 21 53
4 Camino Viejo Camino Viejo 25 43 20 49
5 CD Peñaflor Peñaflor 25 54 30 46
6 San Juan San Juan 25 44 33 46
7 Mosqueo Mosqueo 25 41 21 41
8 Los Palacios CF Palacios 25 39 38 40
9 UD Villaverde Villaverde 25 40 43 40
10 CD Albaida CD Albaida 25 37 40 35
11 Espartinas CF Espartinas 25 34 39 30
12 Olivarense Olivarense 25 35 52 28
13 Atlético Sanlucar Atlético 25 25 37 26
14 Constantina UD Constantina 25 33 40 21
15 Aznalcollar C.D Aznalcollar 25 16 35 21
16 La Liara Balompie Liara 25 29 56 15
17 Alcalá del Río CF Alcalá Río 25 22 59 12
18 Guillena Cf Guillena Cf 25 33 75 12
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 5
Equipo PJ GF GC Puntos
1 UD Tomares UD Tomares 34 82 32 77
2 PD Rociera PD Rociera 34 64 33 67
3 Villafranco Villafranco 34 67 46 60
4 UD Bellavista Bellavista 34 71 53 59
5 UD Morón UD Morón 34 68 42 58
6 A. Cerro Águila Cerro 34 64 41 56
7 Estrella San Agustín Estrella 34 48 38 56
8 Osuna Bote Club Osuna Bote. 34 58 56 52
9 Lora CF Lora CF 34 42 46 49
10 CD Coronil CD Coronil 34 47 49 45
11 Mairena Mairena 34 39 51 43
12 Camas Camas 34 46 58 41
13 Paradas Balompié Paradas 34 54 69 41
14 CD Pedrera CD Pedrera 34 68 68 40
15 Camino Viejo Camino Viejo 34 39 55 36
16 Los Palacios CF Palacios 34 40 57 36
17 Alcalá del Río CF Alcalá Río 34 29 76 17
18 CD Demo CD Demo 34 28 84 17
TEMPORADA 2017/2018
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Alcalá del Río CF Alcalá Río 34 49 17 74
2 Camino Viejo Camino Viejo 34 63 37 72
3 UD Rinconada Rinconada 34 80 51 67
4 At. Dos Hermanas Hermanas 34 83 48 59
5 Andalucia Este CF Andalucia 33 54 34 56
6 Puebla CF Puebla CF 34 87 50 55
7 Pilas Pilas 34 65 35 55
8 CD Albaida CD Albaida 33 64 55 55
9 Mosqueo Mosqueo 34 70 62 54
10 CDF Cazalla CDF Cazalla 34 73 54 52
11 UD Loreto UD Loreto 34 53 50 47
12 Atlético Sanlucar Atlético 33 57 70 44
13 Calavera Calavera 34 56 49 40
14 Atlético Libertad Atlético 34 54 89 33
15 UD Bellavista B Bellavista 34 38 75 26
16 Olivarense Olivarense 34 43 103 25
17 UD Soleá UD Soleá 34 42 84 16
18 Benacazón CF Benacazón 33 34 102 16
TEMPORADA 2016/2017
2ª ANDALUZA SEVILLA GRUPO 1
Equipo PJ GF GC Puntos
1 UD Villaverde Villaverde 34 59 32 70
2 CD Demo CD Demo 34 66 39 69
3 Alcalá del Río CF Alcalá Río 34 66 42 66
4 UD Rinconada Rinconada 34 71 37 65
5 CDF Cazalla CDF Cazalla 34 64 39 63
6 CDF Herrera CDF Herrera 34 65 43 59
7 La Jara La Jara 34 65 60 51
8 El Rubio El Rubio 34 60 57 50
9 Campana Balompié Campana 34 56 58 48
10 Ciudad Jardin Ciudad 34 62 63 47
11 Andalucia Este CF Andalucia 34 54 69 39
12 UD Soleá UD Soleá 34 48 63 39
13 At. Dos Hermanas Hermanas 34 45 51 36
14 CD Antonio Puerta B Antonio 34 45 61 36
15 Gilena C.F. Gilena C.F. 34 43 65 36
16 Ibarburu CF Ibarburu CF 34 51 63 33
17 Brenes Balompié Brenes 34 39 68 28
18 San Jeronimo Jeronimo 34 36 85 17
TEMPORADA 2015/2016
4ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Alcalá del Río CF Alcalá Río 25 65 29 58
2 Mairena del Aljarafe Mairena 25 68 31 54
3 Mosquito CD Mosquito CD 25 82 39 49
4 Alcolea del Río F.C. Alcolea Río 25 45 22 46
5 Cantillana Cantillana 25 55 33 45
6 Guadalcanal C.D Guadalcanal 24 51 39 40
7 C.D. de el Pedroso C.D. Pedroso 25 57 57 39
8 Constantina UD Constantina 25 43 38 39
9 CD Peñaflor Peñaflor 24 35 41 29
10 Liceo C.D.C. Alanis Liceo C.D.C. 25 33 64 22
11 Carmonense Carmonense 15 23 29 17
12 Priorato Juventud Priorato 24 19 67 16
13 Minas CF Minas CF 25 28 81 15
14 Navas de la Concepción Navas 24 33 67 10
TEMPORADA 2014/2015
4ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 CDF Cazalla CDF Cazalla 26 54 32 55
2 At. Dos Hermanas Hermanas 26 72 33 54
3 Constantina UD Constantina 26 56 23 54
4 Guadalcanal C.D Guadalcanal 26 59 45 46
5 UD Loreto UD Loreto 26 62 36 42
6 Alcolea del Río F.C. Alcolea Río 26 47 32 41
7 C.D. de el Pedroso C.D. Pedroso 26 63 52 41
8 Alcalá del Río CF Alcalá Río 26 55 52 36
9 CD Peñaflor Peñaflor 26 31 39 33
10 Cantillana Cantillana 26 41 50 33
11 Carmonense Carmonense 26 26 61 22
12 Priorato Juventud Priorato 26 22 60 22
13 Liceo C.D.C. Alanis Liceo C.D.C. 26 28 65 20
14 Minas CF Minas CF 26 26 62 15
15 Guadajoz C.F. Guadajoz 0 0 0 0
TEMPORADA 2013/2014
3ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Campana Balompié Campana 28 73 28 62
2 Alcalá del Río CF Alcalá Río 28 70 36 59
3 CDF Cazalla CDF Cazalla 28 70 26 57
4 Salteras Salteras 28 91 39 57
5 Guadajoz C.F. Guadajoz 28 64 59 49
6 Guadalcanal C.D Guadalcanal 28 51 48 45
7 Constantina UD Constantina 28 52 43 43
8 C.D. de el Pedroso C.D. Pedroso 28 61 49 43
9 Priorato Juventud Priorato 28 40 36 36
10 Valencina Juv.Dva. Valencina 28 45 43 36
11 Alcolea del Río F.C. Alcolea Río 28 40 59 34
12 Carmonense Carmonense 28 36 67 22
13 Liceo C.D.C. Alanis Liceo C.D.C. 28 34 72 22
14 Castilblanco Castilblanco 28 25 90 13
15 An Andalis An Andalis 28 36 93 12
16 El Ronquillo CF Ronquillo 0 0 0 0

  USO DE MEMORIA  
6,055,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1108
Total Execution Time  0.1120
  CADENA URL  
/historico/Alcala-Del-Rio-C-F
  GET DATOS  
$_GET['/historico/Alcala-Del-Rio-C-F']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0029  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 = 'Alcala-Del-Rio-C-F' 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.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=16111 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=16111 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16111 AND type_rel = 2
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 = '16111' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=16111 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (73750) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 73750 AND teamId = 16111
0.0020  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 = '16111' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0026  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16111' and rp.type = 4
0.0022  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 = '16111' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 73750 WHERE rp.league_id = 73750 AND rp.teamId = 16111 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.0022  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 = 73750 WHERE rp.league_id = 73750 AND rp.teamId = 16111 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 = 73750 WHERE rp.league_id = 73750 AND rp.teamId = 16111 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 16111 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 `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 = 73750 AND t.round = 27 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 `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 = 69279 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.0027  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 = 64458 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.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 `tables2021` 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 = 61883 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 59509 AND t.round = 18 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 `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 = 51359 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.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 `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 = 44624 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 = 39685 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 `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 = 34430 AND t.round = 34 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 `tables2016` 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 = 16943 AND t.round = 26 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 `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 = 4126 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 `tables2014` 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 = 3343 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC