Información
  • Nombre del equipo Algeciras CF
  • Nombre completo Algeciras Club de Fútbol
  • Nombre corto ALG
  • País España
  • Ciudad Algeciras
  • Entrenador Lolo Escobar
  • URL del equipo en RF testing.resultados-futbol.com/Algeciras-Cf
Otros Datos
  • Año de Fundación 1909
  • Patrocinador Cepsa
  • Socios 1600
Internet

Información sobre el estadio

  • Nombre del estadio Nuevo Mirador
  • Capacidad 8209
  • Dirección Poligono de la Menacha
  • Teléfono 956 666 346
  • Fax 956 631 492
  • Año de construcción 1999
  • Tamaño 105 x 68 metros
Nuevo Mirador

Partidos del Algeciras CF

Ir al LIVESCORE
19 Jun 88  Finalizado Algeciras CF
7 - 0
CD San Fernando 0
12 Jun 88  Finalizado Cádiz CF Mirandilla
1 - 2
Algeciras CF 0
05 Jun 88  Finalizado Algeciras CF
3 - 0
Coria CF 0
29 May 88  Finalizado Ayamonte
1 - 1
Algeciras CF 0
22 May 88  Finalizado Algeciras CF
3 - 0
RC Portuense 0
15 May 88  Finalizado Brenes Balompié
0 - 1
Algeciras CF 0
08 May 88  Finalizado Algeciras CF
6 - 0
Imperio Ceuta 0
01 May 88  Finalizado Écija Balompié
3 - 1
Algeciras CF 0
24 Abr 88  Finalizado Algeciras CF
0 - 0
Atlético Antoniano 0
17 Abr 88  Finalizado Dos Hermanas CF
0 - 1
Algeciras CF 0
10 Abr 88  Finalizado Algeciras CF
3 - 2
Moguer CD 0
03 Abr 88  Finalizado Utrera
0 - 1
Algeciras CF 0
27 Mar 88  Finalizado Algeciras CF
3 - 0
Ubrique Ind. 0
20 Mar 88  Finalizado San Roque de Lepe
0 - 0
Algeciras CF 0
13 Mar 88  Finalizado Algeciras CF
2 - 1
Bollullos CF 0
06 Mar 88  Finalizado Mairena
1 - 0
Algeciras CF 0
28 Feb 88  Finalizado Algeciras CF
1 - 0
UA. Ceutí 0
21 Feb 88  Finalizado Pilas
0 - 1
Algeciras CF 0
14 Feb 88  Finalizado Algeciras CF
1 - 0
Montilla 0
07 Feb 88  Finalizado Algeciras CF
1 - 0
Palma Atletico 0
31 Ene 88  Finalizado CD Rota
1 - 2
Algeciras CF 0
24 Ene 88  Finalizado CD San Fernando
0 - 0
Algeciras CF 0
17 Ene 88  Finalizado Algeciras CF
1 - 1
Cádiz CF Mirandilla 0
10 Ene 88  Finalizado Coria CF
1 - 2
Algeciras CF 0
03 Ene 88  Finalizado Algeciras CF
2 - 3
Ayamonte 0
20 Dic 87  Finalizado RC Portuense
2 - 3
Algeciras CF 0
13 Dic 87  Finalizado Algeciras CF
3 - 1
Brenes Balompié 0
06 Dic 87  Finalizado Imperio Ceuta
1 - 2
Algeciras CF 0
29 Nov 87  Finalizado Algeciras CF
1 - 0
Écija Balompié 0
22 Nov 87  Finalizado Atlético Antoniano
2 - 0
Algeciras CF 0
15 Nov 87  Finalizado Algeciras CF
2 - 3
Dos Hermanas CF 0
08 Nov 87  Finalizado Moguer CD
1 - 2
Algeciras CF 0
01 Nov 87  Finalizado Algeciras CF
1 - 0
Utrera 0
25 Oct 87  Finalizado Ubrique Ind.
0 - 1
Algeciras CF 0
18 Oct 87  Finalizado Algeciras CF
1 - 1
San Roque de Lepe 0
11 Oct 87  Finalizado Bollullos CF
1 - 0
Algeciras CF 0
04 Oct 87  Finalizado Algeciras CF
2 - 1
Mairena 0
27 Sep 87  Finalizado UA. Ceutí
1 - 1
Algeciras CF 0
20 Sep 87  Finalizado Algeciras CF
2 - 1
Pilas 0
13 Sep 87  Finalizado Montilla
0 - 2
Algeciras CF 0
06 Sep 87  Finalizado Palma Atletico
0 - 0
Algeciras CF 0
30 Ago 87  Finalizado Algeciras CF
2 - 1
CD Rota 0

Noticias del Algeciras CF

Ver últimas noticias

El Tenerife cede a Cristo Díaz al Algeciras

El mediocentro del Tenerife, Cristo Díaz, jugará la próxima temporada en el Algeciras, equipo de Segunda División B, en calidad de cedido, ha informado hoy el CD Tenerife.

Sorteadas la primera y la segunda ronda de la Copa del Rey

En ella toman parte los equipos de Tercera, Segunda División B y Segunda División.

Primera jornada del Grupo 4 de la Segunda B

El cuarto grupo de la Segunda B comienza con un vibrante derbi entre el Recreativo de Huelva y el Cádiz en el Colombino.

Así queda el grupo IV de Segunda B

Esta mañana, la Asamblea de la Federación Española de Fútbol (RFEF) ha aprobado la propuesta de grupos para la temporada 2015-16 que la semana pasada efectuó la Comisión de Segunda B de la RFEF.

La RFEF propone la composición de los grupos de Segunda B

La Real Federación Española de Fútbol ha hecho oficial la propuesta que ha hecho la Comisión Mixta (compuesta por AFE y RFEF) para la composición de los grupos de la Segunda División B para la liga 2015/2016. La propia RFEF tiene la última palabra para ratificarlo.




  USO DE MEMORIA  
5,395,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3814
Total Execution Time  0.3833
  CADENA URL  
/Algeciras-Cf/1988
  GET DATOS  
$_GET['/Algeciras-Cf/1988']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0213  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 = 21785
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=166 AND type_rel = 2
0.0112  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.0111  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.0118  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.0108  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 = 21785 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0236  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1988 as c ON c.league_id = l.id WHERE (c.datateam1 = 166 or c.datateam2 = 166) AND l.year = 1988 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0242  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1988 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 166 or c.datateam2 = 166) AND l.year = 1988 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0336  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1988 as c ON c.league_id = l.id INNER JOIN events1988 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 166 or c.datateam2 = 166) AND l.year = 1988)
0.0114  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 (1987,1988,1989) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (22243,21785,21040) 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.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 22243 AND teamId = 166
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 21785 AND teamId = 166
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 21040 AND teamId = 166
0.0114  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1988` 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 = 21785 AND t.round = 51 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0109  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 events1988 e ON e.player_id = p.id AND e.league_id = 21785 WHERE rp.league_id = 21785 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.0110  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 events1988 e ON e.player_id = p.id AND e.league_id = 21785 WHERE rp.league_id = 21785 AND rp.teamId = 166 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 events1988 e ON e.player_id = p.id AND e.league_id = 21785 WHERE rp.league_id = 21785 AND rp.teamId = 166 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 166 AND rp.league_id = 21785 AND l.year= 1988 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1