Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

« Temporada Anterior

Temporada 2024

2023/2024

League One

League One

League One

League One

27 Abr 24 Sin comenzar	Barnsley	Barnsley - Northampton 2024-04-27T13:30:00 Oakwell Stadium 13:30	Northampton	más información ...
27 Abr 24 Sin comenzar	Derby County	Derby County - Carlisle United 2024-04-27T13:30:00 iPro Stadium 13:30	Carlisle United	más información ...
27 Abr 24 Sin comenzar	Exeter City	Exeter City - Oxford United 2024-04-27T13:30:00 St. James' Park 13:30	Oxford United	más información ...
27 Abr 24 Sin comenzar	Fleetwood Town	Fleetwood Town - Burton Albion 2024-04-27T13:30:00 Highbury Stadium 13:30	Burton Albion	más información ...
27 Abr 24 Sin comenzar	Lincoln City	Lincoln City - Portsmouth 2024-04-27T13:30:00 Sincil Bank Stadium 13:30	Portsmouth	más información ...
27 Abr 24 Sin comenzar	Peterborough United	Peterborough United - Bolton Wanderers 2024-04-27T13:30:00 London Road Stadium 13:30	Bolton Wanderers	más información 1
27 Abr 24 Sin comenzar	Port Vale	Port Vale - Cambridge United 2024-04-27T13:30:00 Vale Park 13:30	Cambridge United	más información 1
27 Abr 24 Sin comenzar	Reading	Reading - Blackpool 2024-04-27T13:30:00 Madejski Stadium 13:30	Blackpool	más información 1
27 Abr 24 Sin comenzar	Shrewsbury Town	Shrewsbury Town - Leyton Orient 2024-04-27T13:30:00 Greenhous Meadow 13:30	Leyton Orient	más información 1
27 Abr 24 Sin comenzar	Stevenage	Stevenage - Cheltenham Town 2024-04-27T13:30:00 The Lamex Stadium 13:30	Cheltenham Town	más información 1
27 Abr 24 Sin comenzar	Wigan Athletic	Wigan Athletic - Bristol Rovers 2024-04-27T13:30:00 The DW Stadium 13:30	Bristol Rovers	más información 1
27 Abr 24 Sin comenzar	Wycombe Wanderers	Wycombe Wanderers - Charlton Athletic 2024-04-27T13:30:00 Adams Park 13:30	Charlton Athletic	más información ...

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Portsmouth	94	45	27	13	5	76	41	EMPATE Portsmouth 2 Derby County 2 VICTORIA Portsmouth 3 Shrewsbury Town 1 EMPATE Bolton Wanderers 1 Portsmouth 1 VICTORIA Portsmouth 3 Barnsley 2 DERROTA Portsmouth 1 Wigan Athletic 2
2	Derby County	89	45	27	8	10	76	37	VICTORIA Derby County 1 Blackpool 0 EMPATE Portsmouth 2 Derby County 2 EMPATE Wycombe Wanderers 0 Derby County 0 VICTORIA Derby County 3 Leyton Orient 0 VICTORIA Cambridge United 0 Derby County 1
3	Bolton Wanderers	86	45	25	11	9	83	48	VICTORIA Bolton Wanderers 5 Reading 2 VICTORIA Bristol Rovers 0 Bolton Wanderers 2 EMPATE Bolton Wanderers 1 Portsmouth 1 EMPATE Bolton Wanderers 2 Shrewsbury Town 2 VICTORIA Bolton Wanderers 2 Port Vale 0
4	Peterborough	83	45	25	8	12	86	58	VICTORIA Peterborough Unite. 3 Port Vale 0 DERROTA Oxford United 5 Peterborough Unite. 0 VICTORIA Peterborough Unite. 4 Fleetwood Town 1 VICTORIA Bristol Rovers 0 Peterborough Unite. 2 DERROTA Cheltenham Town 2 Peterborough Unite. 0
5	Barnsley	75	45	21	12	12	81	63	DERROTA Charlton Athletic 2 Barnsley 1 DERROTA Stevenage 2 Barnsley 1 EMPATE Barnsley 2 Reading 2 DERROTA Portsmouth 3 Barnsley 2 DERROTA Blackpool 3 Barnsley 2
6	Lincoln City	74	45	20	14	11	65	38	VICTORIA Carlisle United 1 Lincoln City 3 EMPATE Reading 1 Lincoln City 1 DERROTA Lincoln City 1 Wigan Athletic 2 VICTORIA Oxford United 0 Lincoln City 1 VICTORIA Cheltenham Town 1 Lincoln City 2
7	Oxford United	74	45	21	11	13	77	55	VICTORIA Oxford United 4 Fleetwood Town 0 VICTORIA Burton Albion 0 Oxford United 4 VICTORIA Oxford United 5 Peterborough Unite. 0 DERROTA Oxford United 0 Lincoln City 1 EMPATE Oxford United 1 Stevenage 1
8	Blackpool	73	45	21	10	14	63	45	EMPATE Blackpool 0 Wycombe Wanderers 0 VICTORIA Blackpool 1 Cambridge United 0 VICTORIA Blackpool 1 Fleetwood Town 0 VICTORIA Carlisle United 0 Blackpool 1 VICTORIA Blackpool 3 Barnsley 2
9	Stevenage	68	45	18	14	13	55	45	EMPATE Charlton Athletic 0 Stevenage 0 DERROTA Exeter City 1 Stevenage 0 VICTORIA Stevenage 2 Barnsley 1 DERROTA Stevenage 1 Burton Albion 2 EMPATE Oxford United 1 Stevenage 1
10	Wycombe	62	45	16	14	15	59	55	EMPATE Wycombe Wanderers 0 Derby County 0 VICTORIA Shrewsbury Town 0 Wycombe Wanderers 2 VICTORIA Port Vale 1 Wycombe Wanderers 2 VICTORIA Carlisle United 1 Wycombe Wanderers 3 EMPATE Cambridge United 1 Wycombe Wanderers 1
11	Leyton Orient	62	45	17	11	17	50	54	DERROTA Leyton Orient 1 Peterborough Unite. 2 VICTORIA Leyton Orient 3 Cheltenham Town 1 EMPATE Leyton Orient 2 Exeter City 2 DERROTA Derby County 3 Leyton Orient 0 DERROTA Leyton Orient 0 Fleetwood Town 1
12	Exeter City	61	45	17	10	18	45	59	VICTORIA Cheltenham Town 1 Exeter City 2 VICTORIA Exeter City 1 Stevenage 0 EMPATE Leyton Orient 2 Exeter City 2 VICTORIA Port Vale 2 Exeter City 4 VICTORIA Northampton 1 Exeter City 2
13	Wigan Athletic *	59	45	19	10	16	61	56	DERROTA Cambridge United 3 Wigan Athletic 1 EMPATE Wigan Athletic 0 Port Vale 0 EMPATE Charlton Athletic 2 Wigan Athletic 2 VICTORIA Lincoln City 1 Wigan Athletic 2 VICTORIA Portsmouth 1 Wigan Athletic 2
14	Northampton	59	45	17	8	20	56	65	DERROTA Reading 1 Northampton 0 VICTORIA Northampton 2 Port Vale 0 VICTORIA Northampton 2 Carlisle United 0 DERROTA Fleetwood Town 2 Northampton 0 DERROTA Northampton 1 Exeter City 2
15	Bristol Rovers	57	45	16	9	20	52	66	DERROTA Bristol Rovers 0 Bolton Wanderers 2 DERROTA Bristol Rovers 0 Reading 2 VICTORIA Cheltenham Town 1 Bristol Rovers 3 VICTORIA Bristol Rovers 1 Cambridge United 0 DERROTA Bristol Rovers 0 Peterborough Unite. 2
16	Charlton	53	45	11	20	14	64	64	EMPATE Charlton Athletic 0 Stevenage 0 VICTORIA Charlton Athletic 2 Barnsley 1 EMPATE Charlton Athletic 2 Wigan Athletic 2 EMPATE Cambridge United 1 Charlton Athletic 1 EMPATE Charlton Athletic 1 Shrewsbury Town 1
17	Reading *	50	45	15	11	19	65	68	DERROTA Bolton Wanderers 5 Reading 2 EMPATE Reading 1 Lincoln City 1 VICTORIA Bristol Rovers 0 Reading 2 EMPATE Barnsley 2 Reading 2 DERROTA Burton Albion 3 Reading 2
18	Shrewsbury Town	48	45	13	9	23	34	64	EMPATE Bristol Rovers 0 Shrewsbury Town 0 DERROTA Portsmouth 3 Shrewsbury Town 1 DERROTA Shrewsbury Town 0 Wycombe Wanderers 2 EMPATE Bolton Wanderers 2 Shrewsbury Town 2 EMPATE Charlton Athletic 1 Shrewsbury Town 1
19	Cambridge United	47	45	12	11	22	39	61	DERROTA Blackpool 1 Cambridge United 0 EMPATE Cambridge United 1 Charlton Athletic 1 DERROTA Bristol Rovers 1 Cambridge United 0 DERROTA Cambridge United 0 Derby County 1 EMPATE Cambridge United 1 Wycombe Wanderers 1
20	Burton Albion	46	45	12	10	23	39	64	DERROTA Burton Albion 1 Barnsley 3 DERROTA Burton Albion 0 Oxford United 4 VICTORIA Stevenage 1 Burton Albion 2 DERROTA Burton Albion 1 Cheltenham Town 2 VICTORIA Burton Albion 3 Reading 2
21	Cheltenham Town	44	45	12	8	25	40	63	DERROTA Cheltenham Town 0 Carlisle United 1 DERROTA Cheltenham Town 1 Bristol Rovers 3 VICTORIA Burton Albion 1 Cheltenham Town 2 DERROTA Cheltenham Town 1 Lincoln City 2 VICTORIA Cheltenham Town 2 Peterborough Unite. 0
22	Fleetwood Town	40	45	9	13	23	46	72	DERROTA Oxford United 4 Fleetwood Town 0 DERROTA Blackpool 1 Fleetwood Town 0 VICTORIA Fleetwood Town 2 Northampton 0 DERROTA Peterborough Unite. 4 Fleetwood Town 1 VICTORIA Leyton Orient 0 Fleetwood Town 1
23	Port Vale	40	45	10	10	25	41	74	EMPATE Wigan Athletic 0 Port Vale 0 DERROTA Peterborough Unite. 3 Port Vale 0 DERROTA Port Vale 2 Exeter City 4 DERROTA Port Vale 1 Wycombe Wanderers 2 DERROTA Bolton Wanderers 2 Port Vale 0
24	Carlisle United	30	45	7	9	29	41	79	DERROTA Carlisle United 1 Lincoln City 3 DERROTA Northampton 2 Carlisle United 0 VICTORIA Cheltenham Town 0 Carlisle United 1 DERROTA Carlisle United 0 Blackpool 1 DERROTA Carlisle United 1 Wycombe Wanderers 3

	Ascenso : Portsmouth, Derby County
	Playoff Ascenso : Bolton Wanderers, Peterborough, Barnsley, Lincoln City
	Descenso : Cheltenham Town, Fleetwood Town, Port Vale, Carlisle United

Penalizaciones de la competición

	-8 Puntos: Wigan Athletic
	-6 Puntos: Reading

JUGADORES DESTACADOS

RK	Nombre	Goles	Posición	Equipo
1	A. May	23	DEL	Charlton Athletic
2	C. Bishop	21	DEL	Portsmouth
3	J. Reid	18	DEL	Stevenage
4	D. Cole	18	DEL	Barnsley
5	C. Martin	16	DEL	Bristol Rovers
6	J. Rhodes	15	DEL	Blackpool
7	S. Hoskins	15	DEL	Northampton
8	Samuel Smith	14	DEL	Reading
9	E. Mason-Clark	14	DEL	Peterborough United
10	M. Harris	14	DEL	Oxford United
11	J. Collins	13	DEL	Derby County
12	Dion Charles	13	DEL	Bolton Wanderers
13	John Mcatee	12	MED	Barnsley
14	L. Sercombe	11	MED	Cheltenham Town
15	Adam Phillips	11	MED	Barnsley
16	Cameron Brannagan	11	MED	Oxford United
17	A. Collins	11	DEL	Bolton Wanderers
18	R. Sotiriou	11	DEL	Leyton Orient
19	K. Poku	11	DEL	Peterborough United
20	Gassan Ahadme	11	DEL	Cambridge United

Busca la liga de tu equipo

Introduce el nombre de tu equipo y busca rápidamente su competición

NOTICIAS RELACIONADAS

Ver más noticias de la competicion»

Equipos de esta competición

INFORMACIÓN

La Football League One, o League One (que por razones de patrocinio es llamada en el Reino Unido Coca-Cola Football League 1) es la segunda competición futbolística de la Football League, y la tercera del Sistema de ligas de fútbol de Inglaterra (abajo de la Football League Championship).

League One

Peterborough United vs Bolton Wanderers 27 Abr 24 13:30

London Road Stadium

Lincoln City vs Portsmouth 27 Abr 24 13:30

Sincil Bank Stadium

Exeter City vs Oxford United 27 Abr 24 13:30

St. James' Park

Barnsley vs Northampton 27 Abr 24 13:30

Oakwell Stadium

Reading vs Blackpool 27 Abr 24 13:30

Select Car Leasing Stadium

USO DE MEMORIA

6,735,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.1955
Total Execution Time	0.1977

CADENA URL

/league_one/grupo1/jornada46

GET DATOS

$_GET['/league_one/grupo1/jornada46']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0019	SELECT type FROM routes WHERE alias = 'league_one'
0.0041	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_one' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=87 AND type_rel = 3
0.0043	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 87 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024	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 (1312253,1304327,1303359,1291172,1290901) ORDER BY n.cover_points DESC, update_date DESC
0.0023	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72035 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=87 ORDER BY l.group_code ASC
0.0019	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 06:34:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 06:34:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 06:34:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 06:34:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_one' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0043	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72035) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0032	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72035) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (358721,57587,192089,193961,193667,13212,186804,332554,352284,357882,231392,276502,393110,69334,235151,235155,244116,471424,687531,843790) ORDER BY rp.in_squad = 1 DESC
0.0052	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72035) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0030	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72035) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (136218,205026,426819,915147,134459,325206,333287,427672,206375,297304,309243,312455,317739,332533,425787,471036,138830,228162,232171,244088) ORDER BY rp.in_squad = 1 DESC
0.0020	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72035) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0027	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72035) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (618020,117647,126858,132491,206375,272592,279980,305581,312455,391753,425843,426819,111,13212,13456,30122,46607,138830,140319,150358) ORDER BY rp.in_squad = 1 DESC
0.0029	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72035) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0026	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72035) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (70619,424221,344399,232171,244116,874419,206026,235155,230444,325863,420675,824922,160190,205908,284459,322984,366812,687531,789774,44132) ORDER BY rp.in_squad = 1 DESC
0.0023	SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72035 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0157	SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72035 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021	SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=72035 AND rel.round=46
0.0018	SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 72035 AND esl.points > 0
0.0018	SELECT fau.user_name, c., NOW() as difference_time,creation_date FROM* (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 72035 ORDER BY creation_date DESC LIMIT 0, 10
0.0023	SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 72035
0.0021	SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 72035 AND c.`round` = 46 ORDER BY shedule ASC LIMIT 200
0.0024	SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 72035 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (28703,28704,28705,28706,28707,28708,28709,28710,28711,28712,28713,28714) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0049	SELECT name,eventId,odds,id_,live_id,site, link FROM bet_relations WHERE typeId=40 AND (site='bet365' AND eventId IN (154138871,154138873,154138880,154138886,154138890,154138892,154138895,154138898,154138901,154138905,154138907,154138909)) ORDER BY FIELD(site,'mbet', 'bet365', 'sportium', 'marca', 'bwin', 'b888sport'), eventId ASC
0.0147	SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 46 AND e.real_date IS NOT NULL AND e.league_id = 72035 ORDER BY total DESC LIMIT 40
0.0042	SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 72035 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0053	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* `tables2024` 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 = 72035 AND t.round = 44 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2024` 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 = 72035 AND t.round = 46 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72035 AND shedule >= '2024/04/01' AND shedule < '2024/05/01' ORDER BY shedule ASC
0.0035	SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 72035 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0035	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 28708
0.0031	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 28707
0.0030	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 28705
0.0030	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 28703
0.0018	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 28710
0.0020	SELECT data1, data2 FROM services_tags WHERE categoryId=87
0.0020	SELECT group_code, extraName from `leagues` WHERE categoryId=87 AND year=2024

Resultados de Fútbol

Partido televisado en... x

League One

Penalizaciones de la competición

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN

League One


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra:


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

RK	Nombre	Amarillas	Posición	Equipo
1	J. Vela	14	MED	Carlisle United
2	A. Oshilaja	13	MED	Burton Albion
3	Ethan Galbraith	13	MED	Leyton Orient
4	G. Thomason	13	MED	Bolton Wanderers
5	Pierce Sweeney	12	DEF	Exeter City
6	R. Cole	12	MED	Exeter City
7	L. Freestone	12	DEF	Cheltenham Town
8	J. Brown	12	MED	Leyton Orient
9	Paul Digby	11	MED	Cambridge United
10	O. Moxon	11	MED	Portsmouth
11	Anthony Evans	11	MED	Bristol Rovers
12	Joe Morrell	11	MED	Portsmouth
13	G. Dobson	11	MED	Charlton Athletic
14	C. Lang	11	DEL	Portsmouth
15	Herbert Kane	11	MED	Barnsley
16	E. Erhahon	11	MED	Lincoln City
17	O. Norburn	10	MED	Blackpool
18	S. Long	10	DEF	Cheltenham Town
19	Josh Sheehan	10	MED	Bolton Wanderers
20	D. Butler	10	DEF	Stevenage

RK	Nombre	Rojas	Posición	Equipo
1	S. Seddon	3	DEF	Burton Albion
2	R. Woods	2	MED	Exeter City
3	N. Thompson	2	DEF	Stevenage
4	Andy Yiadom	2	DEF	Reading
5	Paul Digby	2	MED	Cambridge United
6	Ricardo Santos	2	DEF	Bolton Wanderers
7	P. O'connor	2	DEF	Lincoln City
8	W. Aimson	2	DEF	Exeter City
9	Joe Morrell	2	MED	Portsmouth
10	J. Earl	2	DEF	Barnsley
11	D. Mandroiu	2	MED	Lincoln City
12	Ethan Galbraith	2	MED	Leyton Orient
13	C. Davies	1	DEF	Cheltenham Town
14	J. Rhodes	1	DEL	Blackpool
15	Jevani Brown	1	MED	Bristol Rovers
16	J. Wilson	1	DEF	Bristol Rovers
17	A. Macdonald	1	DEF	Stevenage
18	O. Norburn	1	MED	Blackpool
19	J. Forster-Caskey	1	MED	Stevenage
20	Gethin Jones	1	DEF	Bolton Wanderers

RK	Nombre	Asistencias	Posición	Equipo
1	N. Mendez-Laing	15	DEL	Derby County
2	H. Burrows	14	DEF	Peterborough United
3	K. Dembélé	13	MED	Blackpool
4	Josh Sheehan	12	MED	Bolton Wanderers
5	A. Collins	10	DEL	Bolton Wanderers
6	Abu Kamara	10	DEL	Portsmouth
7	Marlon Pack	9	MED	Portsmouth
8	Cameron Brannagan	9	MED	Oxford United
9	Conor Hourihane	8	MED	Derby County
10	Lasse Sørensen	8	MED	Lincoln City
11	L. Wing	8	MED	Reading
12	F. Azeez	8	DEL	Reading
13	L. Leahy	7	MED	Wycombe Wanderers
14	M. Pinnock	7	DEL	Northampton
15	Cj Hamilton	7	DEL	Blackpool
16	C. Taylor	7	DEL	Derby County
17	Max Bird	7	MED	Derby County
18	K. Poku	7	DEL	Peterborough United
19	E. Chislett	7	MED	Port Vale
20	G. Mccleary	6	DEL	Wycombe Wanderers

Resultados de Fútbol

Partido televisado en... x

League One

Penalizaciones de la competición

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

Los chicos de la silla... literalmente

El técnico que ha pasado de la League Two a la League One y al Championship en meses

Hart colgará los guantes a final de temporada

"¿Un descenso? Es más probable que me quede en League One que si ganamos la Champions"

El Barnsley, eliminado en los despachos: histórico pase de un Séptima

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN

League One