4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Algeciras CF

Algeciras CF

Entrenador: Lolo Escobar

Temporada 1948/1949
TEMPORADA 1948/1949
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Tetuán Tetuán 26 52 26 34
2 RCD Córdoba Córdoba 26 62 30 34
3 RB Linense RB Linense 26 72 38 34
4 Recreativo Recreativo 26 55 42 32
5 Cádiz Cádiz 26 56 41 30
6 SD Ceuta SD Ceuta 26 47 50 28
7 Real Betis Real Betis 26 60 42 25
8 Algeciras CF Algeciras 26 57 62 25
9 UD España UD España 26 46 63 23
10 Real Jaén Real Jaén 26 50 59 22
11 Iliturgi CF Iliturgi CF 26 57 75 22
12 UD Melilla UD Melilla 26 50 52 21
13 CD Electromecánica Electromecá 26 34 66 19
14 Larache Larache 26 39 91 15
TEMPORADA 1947/1948
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 UD Melilla UD Melilla 26 58 29 40
2 Recreativo Recreativo 26 84 36 35
3 RB Linense RB Linense 26 70 38 35
4 SD Ceuta SD Ceuta 26 64 55 29
5 Cádiz Cádiz 26 48 47 28
6 Iliturgi CF Iliturgi CF 26 68 56 26
7 Larache Larache 26 51 55 26
8 Tetuán Tetuán 26 60 58 25
9 Algeciras CF Algeciras 26 75 64 24
10 CD Electromecánica Electromecá 26 55 73 24
11 CD San Fernando Fernando 26 48 66 23
12 Coria CF Coria CF 26 36 56 19
13 Antequera CF Antequera 26 38 59 19
14 Calavera Calavera 26 30 93 11
TEMPORADA 1946/1947
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 UD Melilla UD Melilla 18 42 26 25
2 Cádiz Cádiz 18 36 31 24
3 SD Ceuta SD Ceuta 18 35 18 23
4 Tetuán Tetuán 18 47 37 22
5 CD San Fernando Fernando 18 43 42 17
6 Algeciras CF Algeciras 18 34 38 16
7 Antequera CF Antequera 18 30 41 14
8 RB Linense RB Linense 18 21 34 14
9 Larache Larache 18 32 42 13
10 CA Almeria CA Almeria 18 23 34 12
TEMPORADA 1945/1946
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD Málaga CD Málaga 18 54 18 27
2 Real Jaén Real Jaén 18 40 26 25
3 UD Melilla UD Melilla 18 43 37 23
4 Larache Larache 18 36 36 17
5 RB Linense RB Linense 18 33 40 16
6 Coria CF Coria CF 18 33 37 15
7 Recreativo Recreativo 18 38 42 15
8 Cádiz Cádiz 18 28 47 15
9 CD Linares CD Linares 18 28 37 14
10 Algeciras CF Algeciras 18 28 41 13
TEMPORADA 1944/1945
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 RCD Córdoba Córdoba 18 41 20 25
2 CD Málaga CD Málaga 18 50 22 23
3 Coria CF Coria CF 18 36 30 20
4 Real Jaén Real Jaén 18 32 35 19
5 UD Melilla UD Melilla 18 26 31 18
6 Recreativo Recreativo 18 29 29 17
7 RB Linense RB Linense 18 23 32 17
8 Algeciras CF Algeciras 18 28 34 16
9 CD Linares CD Linares 18 23 31 13
10 Tetuán Tetuán 18 20 44 12
TEMPORADA 1943/1944
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 CD Málaga CD Málaga 18 51 13 31
2 Real Jaén Real Jaén 18 31 24 23
3 RCD Córdoba Córdoba 18 39 28 21
4 Coria CF Coria CF 18 27 21 18
5 Tetuán Tetuán 18 33 33 18
6 Recreativo Recreativo 18 36 41 15
7 Algeciras CF Algeciras 18 37 45 15
8 CD Linares CD Linares 18 33 38 14
9 RB Linense RB Linense 18 25 44 13
10 Hércules Gaditano F.C. Hércules 18 20 45 12

  USO DE MEMORIA  
5,661,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1578
Total Execution Time  0.1590
  CADENA URL  
/historico/Algeciras-Cf/1949
  GET DATOS  
$_GET['/historico/Algeciras-Cf/1949']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0111  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 = 'Algeciras-Cf' AND l.year = 1949 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.0025  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=166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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=166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0069  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 = 21374
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=166 AND type_rel = 2
0.0040  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 166 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0034  SELECT /*35 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 (1903,2601,2835,3254,4075) ORDER BY n.cover_points DESC, update_date DESC
0.0085  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 = '166' AND l.year = 1949 ORDER BY l.year DESC,cat.coefficient DESC
0.0088  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 = '166' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0047  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 = 22153 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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 = 21374 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0079  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=166 AND l.year in (1948,1949,1950) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (22154,21383) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 21383 AND teamId = 166
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 22154 AND teamId = 166
0.0029  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 = '166' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '166' and rp.type = 4
0.0024  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 = '166' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '166' and rp.type = 4
0.0037  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 events1949 e ON e.player_id = p.id AND e.league_id = 22153 WHERE rp.league_id = 22153 AND rp.teamId = 166 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.0037  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 events1949 e ON e.player_id = p.id AND e.league_id = 22153 WHERE rp.league_id = 22153 AND rp.teamId = 166 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 events1949 e ON e.player_id = p.id AND e.league_id = 22153 WHERE rp.league_id = 22153 AND rp.teamId = 166 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0055  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 = 166 AND l.year <= 1949 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0035  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 `tables1949` 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 = 21374 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables1948` 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 = 21367 AND t.round = 26 ORDER BY team.conference 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 `tables1947` 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 = 21356 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1946` 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 = 21355 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 `tables1945` 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 = 21346 AND t.round = 18 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 `tables1944` 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 = 21328 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC