2.855.770 resultados, 9.127.069 comentarios, 804.045 imágenes, 79.786 vídeos, 85.880 noticias
Información sobre Algeciras Enviar Datos
Información
  • Nombre del equipo Algeciras
  • Nombre completo Algeciras Club de Fútbol
  • Nombre corto ALG
  • País España
  • Ciudad Algeciras
  • Presidente Ricardo Alfonso Álvarez
  • Entrenador Iván Ania
  • URL del equipo en RF testing.resultados-futbol.com/Algeciras-Cf
Otros Datos
  • Año de Fundación 1912
  • 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 Ir al LIVESCORE
15 May 22  en 3 meses San Fernando CD
12:00
Algeciras 0
07 May 22  en 3 meses Algeciras
19:00
Sevilla At. 0
29 Abr 22  en 3 meses CD Castellón
21:00
Algeciras 0
24 Abr 22  en 3 meses Algeciras
12:00
UCAM Murcia 0
16 Abr 22  en 2 meses UE Costa Brava
19:00
Algeciras 0
10 Abr 22  en 2 meses Algeciras
12:00
Atlético Baleares 0
02 Abr 22  en 2 meses Villarreal B
19:00
Algeciras 0
26 Mar 22  en 2 meses Algeciras
17:00
Linares Deportivo 0
20 Mar 22  en 2 meses Algeciras
12:00
Albacete 0
13 Mar 22  en 1 mes Betis Deportivo
12:00
Algeciras 1
06 Mar 22  en 1 mes Algeciras
12:00
RB Linense 2
27 Feb 22  en 1 mes At. Sanluqueño
12:00
Algeciras 0
19 Feb 22  en 1 mes Algeciras
19:00
Alcoyano 0
13 Feb 22  en 25 días Gimnàstic Tarragona
17:00
Algeciras 0
05 Feb 22  en 17 días Algeciras
17:00
Barcelona B 0
29 Ene 22  en 10 días FC Andorra
17:00
Algeciras 0
26 Ene 22  en 7 días Algeciras
19:00
Cornellà 0
23 Ene 22  en 4 días Atlético Baleares
12:00
Algeciras 26
09 Ene 22  Finalizado Algeciras
2 - 1
Villarreal B 45
19 Dic 21  Finalizado Albacete
3 - 1
Algeciras 167
11 Dic 21  Finalizado Algeciras
3 - 0
San Fernando CD 209
05 Dic 21  Finalizado Algeciras
1 - 3
At. Sanluqueño 101
28 Nov 21  Finalizado UCAM Murcia
2 - 0
AlgecirasTarjeta Roja 94
21 Nov 21  Finalizado Algeciras
1 - 0
Gimnàstic TarragonaTarjeta Roja 145
14 Nov 21  Finalizado RM Castilla
2 - 0
Algeciras 131
07 Nov 21  Finalizado Tarjeta RojaAlgeciras
0 - 0
CD CastellónTarjeta Roja 311
31 Oct 21  Finalizado Alcoyano
0 - 0
Algeciras 77
23 Oct 21  Finalizado Algeciras
1 - 1
Betis DeportivoTarjeta Roja 72
16 Oct 21  Finalizado Tarjeta RojaLinares Deportivo
0 - 3
Algeciras 162
10 Oct 21  Finalizado Algeciras
5 - 1
UE Costa Brava 120
01 Oct 21  Finalizado Sevilla At.
1 - 3
Algeciras 78
25 Sep 21  Finalizado Algeciras
0 - 0
Sabadell 107
19 Ene 22  en 1 h Algeciras
12:00
Pardubice 0
14 Ene 22  Finalizado Recreativo Granada
1 - 1
Algeciras 7

Plantilla del Algeciras Temporada 2021/2022

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 37 es 188 83 - - 1
13 19 es 188 - - - -
Defensa
17 22 es 173 - - - 1
7 24 es 174 70 2 - 2
2 23 es 175 76 - - -
21 34 es 185 82 - - 1
5 22 ar 193 85 1 - 3
23 20 es 190 - - - -
3 32 es 171 65 - - 1
18 29 fr 187 76 - - 8
11 28 es 171 66 2 - 6
22 24 es 180 71 1 - 3
Centrocampista
4 26 es 177 71 - - 3
8 32 es 183 80 - - 7
14 24 es 179 64 - 1 -
21 es 177 70 - - -
6 23 es 175 72 1 - 3
15 26 es 191 85 - - 3
Delantero
30 17 es 173 - 3 - 3
10 25 es 167 54 9 - 4
19 23 es 187 72 1 - 1
32 18 es 175 - - - 1
16 20 es 182 74 1 - -
20 21 es 180 68 - - -
9 28 es 181 76 5 1 4
Noticias del Algeciras
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 cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
7,514,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2520
Total Execution Time  0.2541
  CADENA URL  
/Algeciras-Cf
  GET DATOS  
$_GET['/Algeciras-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0020  SELECT type FROM routes WHERE alias = 'algeciras-cf'
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=166 AND type_rel = 2
0.0039  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.0036  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.0069  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 > 2018
0.0039  (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 calendars2022 as c ON c.league_id = l.id WHERE (c.datateam1 = 166 or c.datateam2 = 166) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2022 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0069  (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 calendars2022 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 ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2022 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0047  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2022 as c ON c.league_id = l.id INNER JOIN events2022 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 ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2022)
0.0058  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 (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0028  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 (65506,62807,62379,62372,61721,58611) 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.0048  SELECT count(id) as num_players from rel_players WHERE league_id = 62379 AND teamId = 166
0.0047  SELECT count(id) as num_players from rel_players WHERE league_id = 58611 AND teamId = 166
0.0069  SELECT count(id) as num_players from rel_players WHERE league_id = 65506 AND teamId = 166
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 62372 AND teamId = 166
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 61721 AND teamId = 166
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 166
0.0027  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.0019  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.0019  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '166' and rp.type = 4
0.0043  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 events2022 e ON e.player_id = p.id AND e.league_id = 62379 WHERE rp.league_id = 62379 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.0039  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 events2022 e ON e.player_id = p.id AND e.league_id = 62379 WHERE rp.league_id = 62379 AND rp.teamId = 166 AND (e.action = 4 or e.action = 5) 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 events2022 e ON e.player_id = p.id AND e.league_id = 62379 WHERE rp.league_id = 62379 AND rp.teamId = 166 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 62379 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0031  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6444934 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0021  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6444934
0.0038  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6444934 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0043  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6444934 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0039  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6444934 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0040   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6444934 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0050  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6444934 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC