02 Jun 24	en 1 mes	Alcorcón	-	Burgos	4
26 May 24	en 27 días	Burgos	-	Tenerife	1
19 May 24	en 20 días	FC Andorra	-	Burgos	1
10 May 24	en 12 días	Burgos	20:30	Eldense	3
05 May 24	en 7 días	Real Zaragoza	18:30	Burgos	1
27 Abr 24	Finalizado	Burgos	2 - 2	SD Amorebieta	294
21 Abr 24	Finalizado	Mirandés	2 - 1	Burgos	287
14 Abr 24	Finalizado	Burgos	2 - 1	Racing	398
07 Abr 24	Finalizado	Villarreal B	2 - 1	Burgos	273
29 Mar 24	Finalizado	Burgos	0 - 0	Espanyol	616
24 Mar 24	Finalizado	Huesca	3 - 0	Burgos	483
16 Mar 24	Finalizado	Burgos	1 - 1	Levante	233
10 Mar 24	Finalizado	Eibar	0 - 1	Burgos	664
02 Mar 24	Finalizado	Burgos	3 - 0	FC Cartagena	517
25 Feb 24	Finalizado	Burgos	1 - 0	Real Sporting	447
17 Feb 24	Finalizado	Real Oviedo	5 - 0	Burgos	345
11 Feb 24	Finalizado	Burgos	2 - 0	Racing Ferrol	249
02 Feb 24	Finalizado	Elche	2 - 0	Burgos	257
28 Ene 24	Finalizado	Burgos	2 - 1	Albacete	328
22 Ene 24	Finalizado	Leganés	2 - 0	Burgos	230
13 Ene 24	Finalizado	Burgos	1 - 0	Real Valladolid	333

Copa del Rey »

07 Ene 24

Finalizado

Burgos

0 - 3

Mallorca

357

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Burgos Temporada 2023/2024

		Edad	Altura	Peso
Portero
13	J. A. Caro	29	184	88	-	-	4
1	L. Badiashile	26	186	80	-	-	-
29	R. De Gea	24	193	-	-	-	-
26	Samu Rodríguez	20	193	-	-	-	-
Defensa
4	A. Arroyo	24	176	70	1	-	3
18	Aitor Córdoba	28	191	80	-	-	2
2	Borja González	28	176	76	1	-	2
24	E. Saveljich	32	187	76	-	-	2
20	Grego Sierra	31	186	74	2	-	6
23	José Matos	28	168	68	3	-	9
31	Oussama	20	-	-	-	-	-
6	Raúl Navarro	30	167	66	-	-	1
14	U. Elgezabal	31	185	75	1	-	10
Centrocampista
35	A. Molina	20	174	61	-	-	-
34	J. Menor	21	-	-	-	-	-
21	Joni Montiel	25	173	67	1	2	8
12	Kévin Appin	26	176	65	1	-	5
5	Miguel Atienza	24	186	77	-	-	6
22	Mumo	29	180	81	-	-	7
28	S. Del Cerro	19	185	-	-	-	-
Delantero
10	Àlex Bermejo	25	183	82	5	-	-
11	Álex Sancris	27	181	74	2	-	5
8	Ander Martín	23	177	77	2	-	2
16	Curro Sánchez	28	176	71	14	-	8
7	Dani Ojeda	29	178	75	3	-	2
19	Edu Espiau	29	185	70	1	-	3
9	Fer Niño	23	191	77	7	-	8
30	Lucas Ricoy	21	180	75	-	-	-
33	Sergio Fernández	22	-	-	-	-	-

Noticias del Burgos

Ver últimas noticias

Un doblete de Jon Morcillo en 2 minutos rescató un empate para el Amorebieta (2-2) que pocos pensaban que fuera posible poco antes, cuando el Burgos ganaba por 2-0 gracias a los tantos de Fer Niño y Curro Sánchez. El punto deja a los locales sin 'play off' y acerca a los vascos a la salvación, tanto en la tabla como en lo moral.

Carlos Aguilera es cesado en el banquillo del filial del Burgos CF

Golsmedia - Martes, 18 Octubre 2022

0 161

El conjunto burgalés atraviesa dinámicas muy dispares entre primer y segundo equipo.

RM Castilla 1-2 Burgos. Primera derrota de la temporada del filial del Real Madrid

BeSoccer - Jueves, 06 Agosto 2015

0 1.163

Un doblete de Fito invalidó el tanto blanco.

Primera jornada del Grupo 1 de la Segunda B

Sergio Álvarez - Jueves, 16 Julio 2015

0 3.288

La RFEF ha dado a conocer el calendario de la primera jornada de la temporada en Segunda B, en el que destaca el derbi entre el filial del Valladolid B y la Cultural Leonesa.

Así queda el grupo I de Segunda B

Isabel Ruiz - Martes, 14 Julio 2015

3 4.651

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.

Ver más noticias del equipo»

Competiciones que juega

Segunda División

Pos	Equipos		Pts
1		Leganés	64
2		Eibar	61
3		Real Valladolid	61
4		Espanyol	60
5		Elche	58
6		Racing	55
7		Real Sporting	55
8		Real Oviedo	55
9		Burgos	54
10		Racing Ferrol	54
11		Levante	52
12		Tenerife	49
13		Real Zaragoza	46
14		Eldense	43
15		Huesca	42
16		FC Cartagena	42
17		Mirandés	41
18		Alcorcón	41
19		Albacete	39
20		Villarreal B	39
21		SD Amorebieta	38
22		FC Andorra	37

	Ascenso : Leganés, Eibar
	Playoff Ascenso : Real Valladolid, Espanyol, Elche, Racing
	Descenso : Albacete, Villarreal B, SD Amorebieta, FC Andorra

RIVALES EN Copa del Rey

RIVALES EN Segunda División

USO DE MEMORIA

6,063,104 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1616
Total Execution Time	0.1636

CADENA URL

/Burgos-Cf/2005?section=legal

GET DATOS

$_GET['/Burgos-Cf/2005']
$_GET['section']	legal

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0018	SELECT type FROM routes WHERE alias = 'burgos-cf'
0.0055	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 = 'Burgos-Cf' AND l.year = 2024 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.0019	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=565 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=565 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=565 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=565 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=565 AND type_rel = 2
0.0026	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 565 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (1312832,1193652,2598,2826,5092) ORDER BY n.cover_points DESC, update_date DESC
0.0037	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 = '565' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	(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 calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 565 or c.datateam2 = 565) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120360024 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0025	(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 calendars2024 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 = 565 or c.datateam2 = 565) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120360024 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0022	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 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 = 565 or c.datateam2 = 565) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120360024 AND l.year = 2024)
0.0029	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=565 AND l.year in (2023,2024,2025) 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 (75879,72177,71432) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 72177 AND teamId = 565
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 75879 AND teamId = 565
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 565
0.0023	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 = '565' 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 = '565' and rp.type = 4
0.0023	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 = '565' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '565' and rp.type = 4
0.0040	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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 565 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.0038	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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 565 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 565 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 565 AND rp.league_id = 72177 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0024	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=6584335 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0020	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6584335
0.0029	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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584335 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.0028	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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584335 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0026	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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584335 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0025	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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584335 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0028	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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6584335 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Burgos

Información sobre Burgos

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Burgos

Estadísticas

Plantilla del Burgos Temporada 2023/2024

Noticias del Burgos

Burgos

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda División