4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Alcolea del Río F.C.
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Real Betis C Real Betis 28 111 16 74
2 Palomares Palomares 27 33 22 52
3 La Barrera La Barrera 27 41 31 51
4 Atlético Algabeño Atlético 28 60 41 50
5 Juventud Dva. Gines Juventud 28 51 43 44
6 El Palmar Vereda Real Palmar 27 33 37 44
7 La Liara Balompie Liara 28 37 36 41
8 Camas Camas 28 47 46 39
9 Alcolea del Río F.C. Alcolea Río 28 48 62 37
10 Lora CF Lora CF 27 40 37 37
11 UD Villaverde Villaverde 27 38 40 35
12 San Juan San Juan 27 35 47 34
13 La Motilla La Motilla 27 35 44 31
14 Camino Viejo Camino Viejo 27 36 51 21
15 Marchena Balompié Marchena 27 27 72 18
16 Pilas Pilas 27 23 70 5
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
3ª ANDALUZA SEVILLA GRUPO 1
Equipo PJ GF GC Puntos
1 C.D. Los Caminantes C.D. 30 71 35 68
2 CD Alanis CD Alanis 30 77 38 61
3 Priorato Juventud Priorato 30 79 56 60
4 Campana Balompié Campana 29 84 36 59
5 Constantina UD Constantina 30 69 40 57
6 Alcolea del Río F.C. Alcolea Río 30 65 31 56
7 Cantillana Cantillana 30 66 46 46
8 Guillena Cf Guillena Cf 30 57 51 46
9 Torre Reina CD Torre Reina 30 58 56 38
10 Ventas de las Pajanosas Ventas 29 59 58 37
11 Aznalcollar C.D Aznalcollar 30 41 51 32
12 Guadalcanal C.D Guadalcanal 30 48 73 31
13 Burguillos CD Burguillos 28 40 51 30
14 Celti Puebla Celti Puebla 30 42 90 20
15 Villaverde B Villaverde 30 50 104 17
16 Atlético Almaden Atlético 28 29 119 7
TEMPORADA 2018/2019
3ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Constantina UD Constantina 31 79 14 72
2 Guillena Cf Guillena Cf 31 92 30 70
3 Olivarense Olivarense 32 90 50 69
4 Brenes Balompié Brenes 32 71 41 59
5 Salteras Salteras 31 91 55 56
6 Gelves C.D Gelves C.D 32 70 58 51
7 Alcolea del Río F.C. Alcolea Río 29 70 61 46
8 Priorato Juventud Priorato 32 48 49 45
9 Guadalcanal C.D Guadalcanal 32 75 73 42
10 Celti Puebla Celti Puebla 32 75 81 41
11 Huévar C.F. Huévar C.F. 32 54 62 40
12 Torre Reina CD Torre Reina 32 40 54 38
13 San Martin C.D. Martin C.D. 31 45 61 37
14 Liceo C.D.C. Alanis Liceo C.D.C. 31 57 83 31
15 Benacazón CF Benacazón 32 50 87 27
16 Real CD Real CD 31 51 105 21
17 Cantillana Cantillana 31 36 130 9
TEMPORADA 2017/2018
3ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Peñaflor Peñaflor 28 81 24 65
2 Villanueva Atlético Villanueva 29 73 30 59
3 Aznalcollar C.D Aznalcollar 29 50 25 57
4 Constantina UD Constantina 28 61 38 52
5 Guadalcanal C.D Guadalcanal 29 51 40 47
6 Alcolea del Río F.C. Alcolea Río 28 60 55 46
7 Brenes Balompié Brenes 28 49 44 43
8 Priorato Juventud Priorato 28 34 27 40
9 Liceo C.D.C. Alanis Liceo C.D.C. 28 39 42 40
10 Almensilla CD Almensilla 29 43 52 33
11 Salteras Salteras 29 45 67 32
12 San Martin C.D. Martin C.D. 28 38 54 30
13 Navas de la Concepción Navas 28 37 76 25
14 Cantillana Cantillana 29 29 63 22
15 Torre Reina CD Torre Reina 27 24 61 17
16 Minas CF Minas CF 9 14 30 5
TEMPORADA 2016/2017
3ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Calavera Calavera 32 86 34 71
2 CD Albaida CD Albaida 33 81 28 69
3 UD Bellavista B Bellavista 33 82 43 68
4 Guillena Cf Guillena Cf 33 80 41 65
5 CD Peñaflor Peñaflor 32 82 38 64
6 Aznalcollar C.D Aznalcollar 32 70 43 60
7 Pino Montano Pino Montano 33 69 66 44
8 Constantina UD Constantina 32 61 56 43
9 Cantillana Cantillana 33 48 63 41
10 Guadalcanal C.D Guadalcanal 32 62 70 40
11 Liceo C.D.C. Alanis Liceo C.D.C. 33 57 67 40
12 Alcolea del Río F.C. Alcolea Río 32 54 74 40
13 Priorato Juventud Priorato 32 48 48 39
14 Minas CF Minas CF 33 35 65 34
15 Castillo C.F. Castillo 32 55 115 27
16 Navas de la Concepción Navas 33 51 105 24
17 Santiponce Santiponce 32 45 84 19
18 C.D. de el Pedroso C.D. Pedroso 12 15 41 7
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
TEMPORADA 2012/2013
3ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Adp Sevilla Este Sevilla Este 30 63 43 63
2 Salteras Salteras 30 86 45 60
3 Cantillana Cantillana 30 65 42 56
4 Pino Montano Pino Montano 30 53 37 53
5 Aznalcollar C.D Aznalcollar 30 54 41 50
6 Campana Balompié Campana 30 60 46 49
7 Guadajoz C.F. Guadajoz 30 60 51 48
8 CDF Cazalla CDF Cazalla 30 44 43 41
9 Recreativo Alcosa CD Recreativo 30 53 61 39
10 Priorato Juventud Priorato 30 45 60 39
11 C.D.Santiponce C.D.Santipon 30 44 57 33
12 Alcolea del Río F.C. Alcolea Río 30 46 64 33
13 Murcia Féminas Murcia 30 31 43 32
14 Valencina Juv.Dva. Valencina 30 41 54 31
15 Constantina UD Constantina 30 47 63 31
16 C.D. de el Pedroso C.D. Pedroso 30 38 80 12

  USO DE MEMORIA  
5,929,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1068
Total Execution Time  0.1084
  CADENA URL  
/historico/Alcolea-Del-Rio-F-C
  GET DATOS  
$_GET['/historico/Alcolea-Del-Rio-F-C']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14170 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=277 AND type_rel = 3
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 277 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (986815,818727,685220,55701) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '14170' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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=14170 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73639,69279) 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 WHERE league_id = 73639 AND teamId = 14170
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 69279 AND teamId = 14170
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 = '14170' 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 = '14170' 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 = '14170' 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 = 73639 WHERE rp.league_id = 73639 AND rp.teamId = 14170 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.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 = 73639 WHERE rp.league_id = 73639 AND rp.teamId = 14170 AND (e.action = 4 or e.action = 5) 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 = 73639 WHERE rp.league_id = 73639 AND rp.teamId = 14170 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 14170 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 = 73639 AND t.round = 28 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 `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.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 = 64473 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 `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 = 45327 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 = 39834 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` 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 = 35348 AND t.round = 34 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` 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.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 `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.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 `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
0.0048  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 `tables2013` 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 = 3007 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC