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

« Temporada Anterior

Temporada 2024

2023/2024

League Two

League Two

League Two

League Two

27 Abr 24 Sin comenzar	AFC Wimbledon	AFC Wimbledon - Walsall 2024-04-27T16:00:00 Cherry Red Records Fans' Stadium 16:00	Walsall	más información ...
27 Abr 24 Sin comenzar	Accrington Stanley	Accrington Stanley - Tranmere Rovers 2024-04-27T16:00:00 Store First Stadium 16:00	Tranmere Rovers	más información ...
27 Abr 24 Sin comenzar	Barrow	Barrow - Mansfield Town 2024-04-27T16:00:00 Holker Street 16:00	Mansfield Town	más información ...
27 Abr 24 Sin comenzar	Bradford City	Bradford City - Newport County 2024-04-27T16:00:00 Coral Windows Stadium 16:00	Newport County	más información ...
27 Abr 24 Sin comenzar	Colchester United	Colchester United - Crewe Alexandra 2024-04-27T16:00:00 Weston Homes Community Stadium 16:00	Crewe Alexandra	más información ...
27 Abr 24 Sin comenzar	Crawley Town	Crawley Town - Grimsby Town 2024-04-27T16:00:00 Checkatrade.com Stadium 16:00	Grimsby Town	más información ...
27 Abr 24 Sin comenzar	Forest Green Rovers	Forest Green Rovers - Notts County 2024-04-27T16:00:00 The New Lawn 16:00	Notts County	más información ...
27 Abr 24 Sin comenzar	Gillingham	Gillingham - Doncaster Rovers 2024-04-27T16:00:00 KRBS Priestfield Stadium 16:00	Doncaster Rovers	más información ...
27 Abr 24 Sin comenzar	Milton Keynes Dons	Milton Keynes Dons - Sutton United 2024-04-27T16:00:00 Stadium mk 16:00	Sutton United	más información ...
27 Abr 24 Sin comenzar	Salford City	Salford City - Harrogate Town 2024-04-27T16:00:00 No disponible 16:00	Harrogate Town	más información ...
27 Abr 24 Sin comenzar	Swindon Town	Swindon Town - Morecambe 2024-04-27T16:00:00 County Ground 16:00	Morecambe	más información ...
27 Abr 24 Sin comenzar	Wrexham AFC	Wrexham AFC - Stockport County 2024-04-27T16:00:00 Racecourse Ground 16:00	Stockport County	más información 1

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Stockport County	92	45	27	11	7	95	46	VICTORIA Sutton United 1 Stockport County 3 VICTORIA Colchester United 1 Stockport County 2 VICTORIA Stockport County 2 Morecambe 0 VICTORIA Notts County 2 Stockport County 5 VICTORIA Stockport County 4 Accrington Stanley 2
2	Mansfield Town	85	45	24	13	8	89	46	DERROTA Mansfield Town 1 Crawley Town 4 VICTORIA Mansfield Town 1 Forest Green Rover. 0 VICTORIA Milton Keynes Dons 1 Mansfield Town 4 VICTORIA Mansfield Town 2 Accrington Stanley 1 VICTORIA Mansfield Town 2 Gillingham 1
3	Wrexham AFC	85	45	25	10	10	87	51	DERROTA Doncaster Rovers 1 Wrexham AFC 0 VICTORIA Colchester United 1 Wrexham AFC 2 VICTORIA Wrexham AFC 4 Crawley Town 1 VICTORIA Wrexham AFC 6 Forest Green Rover. 0 VICTORIA Crewe Alexandra 0 Wrexham AFC 3
4	Milton Keynes D.	77	45	23	8	14	79	64	VICTORIA Milton Keynes Dons 5 Walsall 0 EMPATE Notts County 3 Milton Keynes Dons 3 VICTORIA Forest Green Rover. 0 Milton Keynes Dons 2 DERROTA Milton Keynes Dons 1 Mansfield Town 4 VICTORIA Harrogate Town 3 Milton Keynes Dons 5
5	Doncaster Rovers	70	45	21	7	17	71	66	VICTORIA Morecambe 0 Doncaster Rovers 3 VICTORIA Doncaster Rovers 2 Walsall 1 VICTORIA Doncaster Rovers 4 Accrington Stanley 0 VICTORIA Doncaster Rovers 4 Barrow 2 VICTORIA Colchester United 1 Doncaster Rovers 4
6	Crewe Alexandra	70	45	19	13	13	68	64	DERROTA Crewe Alexandra 0 Forest Green Rover. 3 EMPATE Accrington Stanley 0 Crewe Alexandra 0 VICTORIA Morecambe 0 Crewe Alexandra 1 DERROTA Crewe Alexandra 0 Grimsby Town 3 DERROTA Crewe Alexandra 0 Wrexham AFC 3
7	Barrow	68	45	18	14	13	61	55	DERROTA Barrow 0 Swindon Town 2 DERROTA Gillingham 3 Barrow 0 EMPATE Crawley Town 1 Barrow 1 DERROTA Doncaster Rovers 4 Barrow 2 DERROTA Barrow 1 Bradford City 2
8	Crawley Town	67	45	20	7	18	71	67	VICTORIA Mansfield Town 1 Crawley Town 4 DERROTA Wrexham AFC 4 Crawley Town 1 DERROTA Crawley Town 2 Colchester United 3 EMPATE Crawley Town 1 Barrow 1 EMPATE Sutton United 2 Crawley Town 2
9	Bradford City	66	45	18	12	15	57	58	EMPATE Grimsby Town 1 Bradford City 1 VICTORIA Bradford City 1 Gillingham 0 VICTORIA Salford City 1 Bradford City 2 VICTORIA Walsall 2 Bradford City 3 VICTORIA Barrow 1 Bradford City 2
10	Walsall	65	45	18	11	16	68	68	VICTORIA Tranmere Rovers 1 Walsall 3 DERROTA Doncaster Rovers 2 Walsall 1 DERROTA Walsall 1 Notts County 3 VICTORIA Walsall 2 Swindon Town 1 DERROTA Walsall 2 Bradford City 3
11	Gillingham	63	45	18	9	18	44	55	EMPATE Gillingham 0 Crewe Alexandra 0 DERROTA Harrogate Town 5 Gillingham 1 DERROTA Bradford City 1 Gillingham 0 VICTORIA Gillingham 3 Barrow 0 DERROTA Mansfield Town 2 Gillingham 1
12	AFC Wimbledon	62	45	16	14	15	59	50	EMPATE AFC Wimbledon 1 Harrogate Town 1 DERROTA Stockport County 1 AFC Wimbledon 0 VICTORIA AFC Wimbledon 1 Salford City 0 DERROTA Swindon Town 3 AFC Wimbledon 2 DERROTA Tranmere Rovers 3 AFC Wimbledon 2
13	Harrogate Town	62	45	17	11	17	58	67	VICTORIA Harrogate Town 5 Gillingham 1 DERROTA Notts County 3 Harrogate Town 0 VICTORIA Harrogate Town 1 Grimsby Town 0 EMPATE Harrogate Town 2 Sutton United 2 DERROTA Harrogate Town 3 Milton Keynes Dons 5
14	Notts County	61	45	18	7	20	89	85	EMPATE Notts County 3 Milton Keynes Dons 3 VICTORIA Notts County 3 Harrogate Town 0 VICTORIA Walsall 1 Notts County 3 DERROTA Notts County 2 Stockport County 5 VICTORIA Notts County 1 Colchester United 0
15	Tranmere Rovers	57	45	17	6	22	66	66	DERROTA Bradford City 2 Tranmere Rovers 0 EMPATE Tranmere Rovers 1 Colchester United 1 DERROTA Tranmere Rovers 1 Walsall 3 VICTORIA Newport County 1 Tranmere Rovers 2 VICTORIA Tranmere Rovers 3 AFC Wimbledon 2
16	Morecambe *	57	45	17	9	19	64	78	VICTORIA Morecambe 2 Barrow 1 DERROTA Morecambe 0 Doncaster Rovers 3 DERROTA Morecambe 0 Crewe Alexandra 1 DERROTA Stockport County 2 Morecambe 0 DERROTA Morecambe 1 Forest Green Rover. 2
17	Newport County	55	45	16	7	22	61	72	DERROTA Newport County 0 Crawley Town 4 DERROTA Grimsby Town 1 Newport County 0 DERROTA Newport County 1 Accrington Stanley 3 DERROTA Newport County 1 Tranmere Rovers 2 DERROTA Newport County 0 Salford City 1
18	Accrington	54	45	15	9	21	59	70	EMPATE Accrington Stanley 0 Crewe Alexandra 0 VICTORIA Newport County 1 Accrington Stanley 3 DERROTA Doncaster Rovers 4 Accrington Stanley 0 DERROTA Mansfield Town 2 Accrington Stanley 1 DERROTA Stockport County 4 Accrington Stanley 2
19	Swindon Town	53	45	14	11	20	74	80	DERROTA Sutton United 3 Swindon Town 1 VICTORIA Barrow 0 Swindon Town 2 VICTORIA Swindon Town 3 AFC Wimbledon 2 DERROTA Walsall 2 Swindon Town 1 DERROTA Grimsby Town 2 Swindon Town 0
20	Salford City	50	45	13	11	21	64	80	DERROTA Salford City 1 Sutton United 2 DERROTA Walsall 2 Salford City 1 DERROTA AFC Wimbledon 1 Salford City 0 DERROTA Salford City 1 Bradford City 2 VICTORIA Newport County 0 Salford City 1
21	Grimsby Town	49	45	11	16	18	57	72	VICTORIA Grimsby Town 1 Newport County 0 DERROTA Harrogate Town 1 Grimsby Town 0 VICTORIA Crewe Alexandra 0 Grimsby Town 3 DERROTA Colchester United 2 Grimsby Town 0 VICTORIA Grimsby Town 2 Swindon Town 0
22	Colchester	44	45	11	11	23	58	79	DERROTA Colchester United 1 Stockport County 2 VICTORIA Crawley Town 2 Colchester United 3 VICTORIA Colchester United 2 Grimsby Town 0 DERROTA Notts County 1 Colchester United 0 DERROTA Colchester United 1 Doncaster Rovers 4
23	Sutton United	41	45	9	14	22	55	80	VICTORIA Salford City 1 Sutton United 2 VICTORIA Sutton United 3 Swindon Town 1 DERROTA Sutton United 1 Stockport County 3 EMPATE Harrogate Town 2 Sutton United 2 EMPATE Sutton United 2 Crawley Town 2
24	Forest Green Ro.	39	45	10	9	26	43	78	VICTORIA Crewe Alexandra 0 Forest Green Rover. 3 DERROTA Forest Green Rover. 0 Milton Keynes Dons 2 DERROTA Mansfield Town 1 Forest Green Rover. 0 DERROTA Wrexham AFC 6 Forest Green Rover. 0 VICTORIA Morecambe 1 Forest Green Rover. 2

	Ascenso : Stockport County, Mansfield Town, Wrexham AFC
	Playoff Ascenso : Milton Keynes D., Doncaster Rovers, Crewe Alexandra, Barrow
	Descenso : Sutton United, Forest Green Ro.

Penalizaciones de la competición

	-3 Puntos: Morecambe

JUGADORES DESTACADOS

RK	Nombre	Goles	Posición	Equipo
1	Macca	28	DEL	Notts County
2	P. Mullin	24	DEL	Wrexham AFC
3	M. Smith	24	DEL	Salford City
4	D. Keillor-Dunn	22	MED	Mansfield Town
5	W. Evans	21	DEL	Newport County
6	I. Olaofe	20	DEL	Stockport County
7	J. Ironside	19	DEL	Doncaster Rovers
8	D. Orsi	18	DEL	Crawley Town
9	P. Madden	17	DEL	Stockport County
10	D. Kemp	17	MED	Milton Keynes Dons
11	E. Lee	16	MED	Wrexham AFC
12	A. Cook	16	DEL	Bradford City
13	G. Thomson	16	MED	Harrogate Town
14	J. Young	16	DEL	Bradford City
15	Dan Crowley	15	MED	Notts County
16	J. Nolan	15	DEL	Accrington Stanley
17	Max Dean	15	DEL	Milton Keynes Dons
18	Elliott Nevitt	15	DEL	Crewe Alexandra
19	D. Rose	13	DEL	Grimsby Town
20	A. Al-Hamadi	13	DEL	AFC Wimbledon

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

Descripción

La Football League Two, o League Two (que por razones de patrocinio es llamada en el Reino Unido Coca-Cola Football League 2) es la tercera competición futbolística de la Football League, y la cuarta de la Liga inglesa de fútbol (abajo de la Football League One).

La Football League Two fue introducida para la temporada 2004-05, y reemplazó a la Football League Third Division.

League Two

Wrexham AFC vs Stockport County 27 Abr 24 16:00

Racecourse Ground

Barrow vs Mansfield Town 27 Abr 24 16:00

Holker Street

Gillingham vs Doncaster Rovers 27 Abr 24 16:00

KRBS Priestfield Stadium

AFC Wimbledon vs Walsall 27 Abr 24 16:00

Plough Lane

Bradford City vs Newport County 27 Abr 24 16:00

Coral Windows Stadium

USO DE MEMORIA

6,686,248 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.6622
Total Execution Time	0.6640

CADENA URL

/league_two

GET DATOS

$_GET['/league_two']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0125	SELECT type FROM routes WHERE alias = 'league_two'
0.0251	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_two' 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.0131	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=88 ORDER BY l.group_code ASC
0.0127	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 21:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 21:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 21:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 21:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_two' 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.0166	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72036) 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.0148	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 (72036) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (386645,56898,121816,375913,340531,711576,203836,742391,205903,318763,190035,208772,300870,965291,283004,424200,972697,3168009,209826,754422) ORDER BY rp.in_squad = 1 DESC
0.0151	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72036) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0132	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 (72036) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (770412,209396,209897,250951,125416,142001,206156,309923,923353,3168009,205895,232979,276599,341861,424874,3171067,47598,191332,204679,284218) ORDER BY rp.in_squad = 1 DESC
0.0127	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72036) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0134	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 (72036) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (206156,209396,232975,301352,306906,340297,868580,923353,251,9362,9435,47435,47550,56480,57628,69068,84224,85657,125404,191332) ORDER BY rp.in_squad = 1 DESC
0.0146	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72036) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0140	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 (72036) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (248264,9435,283004,424231,203860,318763,375913,125416,242879,286468,677981,86448,318726,742033,127737,204891,204961,205898,208772,246526) ORDER BY rp.in_squad = 1 DESC
0.0147	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 = 72036 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0516	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 = 72036 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0127	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=72036 AND rel.round=46
0.0126	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 = 72036 AND esl.points > 0
0.0132	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` = 72036 AND c.`round` = 46 ORDER BY shedule ASC LIMIT 200
0.0127	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 = 72036 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 (29255,29256,29257,29258,29259,29260,29261,29262,29263,29264,29265,29266) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0130	SELECT name,eventId,odds,id_,live_id,site, link FROM bet_relations WHERE typeId=40 AND (site='bet365' AND eventId IN (154138913,154138915,154138917,154138919,154138921,154138928,154138932,154138938,154138940,154138944,154138947,154138953)) ORDER BY FIELD(site,'mbet', 'bet365', 'sportium', 'marca', 'bwin', 'b888sport'), eventId ASC
0.0159	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 = 72036 ORDER BY total DESC LIMIT 40
0.0221	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 = 72036 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0131	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 = 72036 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.0138	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 = 72036 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.0134	SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72036 AND shedule >= '2024/04/01' AND shedule < '2024/05/01' ORDER BY shedule ASC
0.0133	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-24 00:00:00' AND c.`shedule` < '2024-04-28 23:59:59' AND l.id = 72036 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0136	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 = 29266
0.0137	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 = 29257
0.0137	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 = 29262
0.0141	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 = 29255
0.0137	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 = 29258
0.0124	SELECT data1, data2 FROM services_tags WHERE categoryId=88
0.0126	SELECT group_code, extraName from `leagues` WHERE categoryId=88 AND year=2024

Partido televisado en... x

League Two

Penalizaciones de la competición

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN

League Two


	¡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:

RK	Nombre	Amarillas	Posición	Equipo
1	J. Williams	16	DEF	Crawley Town
2	Cameron Mcgeehan	14	MED	Colchester United
3	L. Garbutt	13	DEF	Salford City
4	D. Tutonda	13	DEF	Morecambe
5	J. Mcclean	12	MED	Wrexham AFC
6	R. Smallwood	12	MED	Bradford City
7	R. Inniss	12	DEF	Forest Green Rovers
8	L. Maguire	12	DEF	Crawley Town
9	Brad Hills	12	DEF	Accrington Stanley
10	Elliott Nevitt	12	DEL	Crewe Alexandra
11	C. Jennings	11	DEL	Tranmere Rovers
12	L. Reed	11	MED	Mansfield Town
13	D. Harvie	11	DEF	Milton Keynes Dons
14	E. Watt	11	MED	Salford City
15	T. Knowles	11	DEL	Walsall
16	Aden Baldwin	11	DEF	Notts County
17	S. Malone	10	DEF	Gillingham
18	G. Ray	10	DEF	Barrow
19	O. Clarke	10	MED	Mansfield Town
20	M. Lund	10	MED	Salford City

RK	Nombre	Rojas	Posición	Equipo
1	R. Inniss	2	DEF	Forest Green Rovers
2	Cameron Mcgeehan	2	MED	Colchester United
3	J. Turnbull	2	DEF	Tranmere Rovers
4	T. Vassell	2	DEF	Salford City
5	Will Boyle	2	DEF	Wrexham AFC
6	H. Smith	2	DEL	Sutton United
7	H. Biler	2	DEF	AFC Wimbledon
8	Brad Hills	2	DEF	Accrington Stanley
9	A. Taylor	1	DEF	Bradford City
10	A. Mariappa	1	DEF	Salford City
11	Stephen Quinn	1	MED	Mansfield Town
12	D. Lewington	1	DEF	Milton Keynes Dons
13	T. Rowe	1	MED	Doncaster Rovers
14	J. Bowery	1	DEL	Mansfield Town
15	J. Proctor	1	DEL	Barrow
16	J. O'toole	1	DEF	AFC Wimbledon
17	Y. Songo'o	1	MED	Morecambe
18	George Evans	1	MED	Wrexham AFC
19	C. Mcaleny	1	DEL	Salford City
20	G. Ray	1	DEF	Barrow

RK	Nombre	Asistencias	Posición	Equipo
1	Jodi Jones	23	DEL	Notts County
2	Stephen Quinn	12	MED	Mansfield Town
3	Dan Crowley	11	MED	Notts County
4	I. Hutchinson	11	MED	Walsall
5	A. Gilbey	10	MED	Milton Keynes Dons
6	D. Kemp	10	MED	Milton Keynes Dons
7	D. Keillor-Dunn	10	MED	Mansfield Town
8	J. Mcclean	9	MED	Wrexham AFC
9	I. Touray	9	DEF	Stockport County
10	Liam Kelly	9	MED	Crawley Town
11	Matty Daly	9	MED	Harrogate Town
12	Luke Molyneux	8	MED	Doncaster Rovers
13	O. Bailey	8	MED	Stockport County
14	W. Wright	8	DEF	Crawley Town
15	J. Reeves	7	MED	AFC Wimbledon
16	Tom Nichols	7	DEL	Mansfield Town
17	A. Sarcevic	7	MED	Stockport County
18	H. Adelakun	7	DEL	Doncaster Rovers
19	A. Cook	7	DEL	Bradford City
20	K. Wootton	7	DEL	Stockport County

Partido televisado en... x

League Two

Penalizaciones de la competición

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

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

El Forest Green Rovers echa a Deeney tras menos de 1 mes como entrenador

El Wrexham se rearma con un veterano soldado de la Premier nacido en una base militar

Ben Foster, el héroe del ascenso del Wrexham de 'Deadpool', vuelve a retirarse

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN

League Two