4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del La Rambla CF
TEMPORADA 2020/2021
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Egabrense Egabrense 16 40 15 39
2 Palma del Rio Atletico CF Palma 16 31 21 25
3 Lucecor Lucecor 16 25 25 23
4 FC Aguilarense Aguilarense 16 20 25 22
5 CD Priego CD Priego 16 22 24 21
6 CD Montalbeño Montalbeño 16 25 29 21
7 Almodóvar del Río Almodóvar 16 30 30 18
8 La Rambla CF Rambla 16 24 35 12
9 Salerm Puente Genil B Salerm 16 24 37 12
TEMPORADA 2019/2020
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Montilla Montilla 24 58 19 58
2 CD Priego CD Priego 24 46 24 46
3 Almodóvar del Río Almodóvar 24 45 27 46
4 Palma del Rio Atletico CF Palma 24 53 29 43
5 Egabrense Egabrense 24 46 30 39
6 Atco. Villanueva Atco. 24 41 28 38
7 CD Alcazar CD Alcazar 24 35 33 36
8 Lucecor Lucecor 24 44 38 35
9 Villa Del Rio CF Villa 24 27 33 30
10 La Rambla CF Rambla 24 31 32 29
11 Bujalance Futbol Base AD Bujalance 24 33 48 24
12 Los Leones de Pozoblanco Leones 24 32 50 24
13 CD Castro Del Rio-Cajasol Castro 24 29 43 23
14 FC Aguilarense Aguilarense 24 33 71 23
15 Peñarroya Pueblonuevo Peñarroya 24 26 42 22
16 Salerm Puente Genil B Salerm 24 20 52 13
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Ciudad Jardin CD Ciudad 30 67 30 68
2 Montilla Montilla 30 66 22 67
3 Bujalance Futbol Base AD Bujalance 29 50 35 52
4 La Rambla CF Rambla 30 52 37 51
5 Villa Del Rio CF Villa 30 57 49 47
6 Palma del Rio Atletico CF Palma 30 60 51 46
7 CD Alcazar CD Alcazar 29 47 38 43
8 Salerm Puente Genil B Salerm 29 48 53 42
9 Almodóvar del Río Almodóvar 29 48 46 41
10 CD Priego CD Priego 30 46 46 40
11 Egabrense Egabrense 29 44 44 39
12 Atco. Villanueva Atco. 30 52 58 36
13 FC Aguilarense Aguilarense 29 39 45 34
14 Almedinilla Atl Almedinilla 30 39 56 32
15 UD Belalcazar Belalcazar 29 37 95 17
16 C.D. Stadium C.D. Stadium 25 20 67 12
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Peñarroya Pueblonuevo Peñarroya 30 61 22 66
2 Almodóvar del Río Almodóvar 30 66 39 55
3 Villa Del Rio CF Villa 30 52 38 51
4 Atco. Villanueva Atco. 30 61 49 49
5 Palma del Rio Atletico CF Palma 30 67 43 49
6 La Rambla CF Rambla 30 49 53 45
7 C.D. Stadium C.D. Stadium 30 46 37 44
8 Egabrense Egabrense 30 58 56 44
9 Bujalance Futbol Base AD Bujalance 30 57 49 44
10 Almedinilla Atl Almedinilla 30 49 35 44
11 CD Alcazar CD Alcazar 30 58 50 43
12 At. Menciano Menciano 30 64 47 42
13 CD Priego CD Priego 30 46 51 40
14 CD Montalbeño Montalbeño 30 40 48 39
15 Pedroche CD Pedroche CD 30 37 82 15
16 CD El Villar Villar 30 17 129 5
TEMPORADA 2015/2016
3ª ANDALUZA CÓRDOBA GRUPO 1
Equipo PJ GF GC Puntos
1 La Rambla CF Rambla 27 73 28 62
2 At. Menciano Menciano 28 68 35 57
3 CD El Villar Villar 28 50 32 56
4 C.D. Stadium C.D. Stadium 28 58 27 51
5 Santaella 2010 Santaella 28 70 45 48
6 Villafranca CF Villafranca 27 84 44 46
7 CD Priego CD Priego 27 61 40 46
8 CD Colonia Fuente Palmera Colonia 27 68 39 44
9 Palma del Rio Atletico CF Palma 28 69 40 42
10 CD Castro Del Rio-Cajasol Castro 27 54 51 40
11 La Victoria C.F. Victoria 27 32 66 30
12 FC Aguilarense Aguilarense 28 46 68 22
13 C.D. Atlético Cerro Muriano C.D. 21 29 62 13
14 Atlético Baenense Atlético 27 25 99 10
15 Prieguense A.F. Prieguense 28 32 143 7
16 Posadas Atlético C.D. Posadas 0 0 0 0
TEMPORADA 2014/2015
3ª ANDALUZA CÓRDOBA GRUPO 1
Equipo PJ GF GC Puntos
1 Almedinilla Atl Almedinilla 28 74 21 61
2 Perro Verde CD Perro Verde 28 66 42 57
3 Fray Albino-UCO Fray 27 65 39 54
4 CD Alcazar CD Alcazar 28 59 44 51
5 CD Castro Del Rio-Cajasol Castro 28 59 44 49
6 La Rambla CF Rambla 27 62 43 47
7 Atlético Baenense Atlético 28 56 44 44
8 At. Menciano Menciano 28 55 61 40
9 C.D. Stadium C.D. Stadium 27 44 38 37
10 FC Aguilarense Aguilarense 28 50 52 37
11 Villafranca CF Villafranca 28 53 62 35
12 CD El Villar Villar 28 48 58 23
13 Posadas Bpie. Posadas 25 25 57 21
14 Rute Calidad Rute Calidad 28 41 92 19
15 Almodóvar del Río Almodóvar 28 20 80 16
16 Moreras Atletico C.D. Moreras 0 0 0 0
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 AgD Ceuta AgD Ceuta 38 81 27 82
2 CD San Fernando Fernando 38 91 31 78
3 San Roque de Lepe Roque Lepe 38 50 30 64
4 Algeciras CF Algeciras 38 54 46 64
5 Lucena Lucena 38 34 21 63
6 Coria CF Coria CF 38 57 36 63
7 Chiclana CF Chiclana CF 38 54 43 58
8 Utrera Utrera 38 48 48 53
9 La Palma La Palma 38 45 60 52
10 CD Rota CD Rota 38 53 65 50
11 RB Linense RB Linense 38 39 60 46
12 Ayamonte Ayamonte 38 46 48 46
13 Puerto Real CF Puerto Real 38 49 61 45
14 Montilla Montilla 38 35 47 45
15 At. Sanluqueño Sanluqueño 38 49 49 44
16 CD Pozoblanco Pozoblanco 38 43 48 44
17 UD Los Palacios Palacios 38 40 53 42
18 Cádiz CF Mirandilla Cádiz 38 35 47 40
19 La Rambla CF Rambla 38 38 74 34
20 Rayo Sanluqueño Rayo 38 36 83 24

  USO DE MEMORIA  
5,580,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0896
Total Execution Time  0.0909
  CADENA URL  
/historico/La-Rambla-Senior
  GET DATOS  
$_GET['/historico/La-Rambla-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
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 = 61894
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19100 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 5 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 (1267671,1255959,1148089,1109642,1107691) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '19100' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = '19100' 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=19100 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (64159,61894) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 61894 AND teamId = 19100
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 64159 AND teamId = 19100
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 = '19100' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19100' 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 = '19100' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 events2021 e ON e.player_id = p.id AND e.league_id = 58856 WHERE rp.league_id = 58856 AND rp.teamId = 19100 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.0024  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 events2021 e ON e.player_id = p.id AND e.league_id = 58856 WHERE rp.league_id = 58856 AND rp.teamId = 19100 AND (e.action = 4 or e.action = 5) 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 events2021 e ON e.player_id = p.id AND e.league_id = 58856 WHERE rp.league_id = 58856 AND rp.teamId = 19100 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 19100 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 61894 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.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 `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 = 58856 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.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 = 51256 AND t.round = 24 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 `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 = 44622 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 `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 = 39326 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 `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 = 16867 AND t.round = 30 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 `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 = 4122 AND t.round = 30 ORDER BY team.conference 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 `tables1998` 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 = 21991 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC