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 Siguiente »

2022/2023

Championship Escocia 2023

Championship Escocia - Play Offs Ascenso

Championship Escocia 2023

Championship Escocia 2023

La temporada finalizó el Viernes, 05 Mayo 2023.

	05 May 23 20:45 Finalizado	Arbroath	Arbroath - Hamilton Academical 2023-05-05T20:45:00 Gayfield Park 0-0	Hamilton Academical	más información 4
	05 May 23 20:45 Finalizado	Cove Rangers	Cove Rangers - Greenock Morton 2023-05-05T20:45:00 No disponible 1-2	Greenock Morton	más información Jugadas destacadas 3
			0-1	2' J. Baird
		45' D. Glass	1-1
				49' C. Blues
			1-2	73' R. Muirhead
	05 May 23 20:45 Finalizado	Inverness CT	Inverness CT - Ayr United 2023-05-05T20:45:00 Tulloch Caledonian Stadium 1-2	Ayr United	más información Jugadas destacadas ...
			0-1	35' J. Mullin
		81' N. Shaw	1-1
			1-2	88' M. McKenzie
	05 May 23 20:45 Finalizado	Queen's Park	Queen's Park - Dundee 2023-05-05T20:45:00 Hampden Park 3-5	Dundee	más información Jugadas destacadas 8
			0-1	4' A. Jakubiak
		10' C. Fox	1-1
		12' C. Shields	2-1
			2-2	17' L. Ashcroft
			2-3	34' Z. Robinson
		46' C. Fox	3-3
			3-4	54' L. Cameron
			3-5	81' Luke Mccowan
	05 May 23 20:45 Finalizado	Raith Rovers	Raith Rovers - Partick Thistle 2023-05-05T20:45:00 Stark's Park 2-2	Partick Thistle	más información Jugadas destacadas ...
			0-1	21' D. Brownlie
		35' L. Vaughan	1-1
		59' S. Mcgill	2-1
			2-2	68' S. Tiffoney

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Dundee	63	36	17	12	7	66	40	VICTORIA Dundee 3 Raith Rovers 1 EMPATE Dundee 3 Greenock Morton 3 EMPATE Inverness CT 1 Dundee 1 EMPATE Dundee 0 Cove Rangers 0 VICTORIA Queen's Park 3 Dundee 5
2	Ayr United	58	36	16	10	10	61	43	EMPATE Ayr United 1 Greenock Morton 1 EMPATE Partick Thistle 1 Ayr United 1 EMPATE Ayr United 0 Queen's Park 0 VICTORIA Ayr United 1 Raith Rovers 0 VICTORIA Inverness CT 1 Ayr United 2
3	Queen's Park	58	36	17	7	12	63	52	DERROTA Partick Thistle 4 Queen's Park 0 VICTORIA Queen's Park 1 Hamilton Academica. 0 EMPATE Ayr United 0 Queen's Park 0 DERROTA Greenock Morton 2 Queen's Park 1 DERROTA Queen's Park 3 Dundee 5
4	Partick Thistle	57	36	16	9	11	65	45	VICTORIA Partick Thistle 4 Queen's Park 0 EMPATE Partick Thistle 1 Ayr United 1 EMPATE Hamilton Academica. 2 Partick Thistle 2 VICTORIA Partick Thistle 2 Arbroath 0 EMPATE Raith Rovers 2 Partick Thistle 2
5	Greenock Morton	57	36	15	12	9	53	43	VICTORIA Greenock Morton 2 Hamilton Academica. 0 EMPATE Dundee 3 Greenock Morton 3 VICTORIA Greenock Morton 1 Raith Rovers 0 VICTORIA Greenock Morton 2 Queen's Park 1 VICTORIA Cove Rangers 1 Greenock Morton 2
6	Inverness CT	55	36	15	10	11	52	47	VICTORIA Inverness CT 2 Arbroath 0 VICTORIA Cove Rangers 1 Inverness CT 2 VICTORIA Hamilton Academica. 1 Inverness CT 2 EMPATE Inverness CT 1 Dundee 1 DERROTA Inverness CT 1 Ayr United 2
7	Raith Rovers	43	36	11	10	15	46	49	DERROTA Dundee 3 Raith Rovers 1 EMPATE Raith Rovers 1 Arbroath 1 DERROTA Greenock Morton 1 Raith Rovers 0 DERROTA Ayr United 1 Raith Rovers 0 EMPATE Raith Rovers 2 Partick Thistle 2
8	Arbroath	34	36	6	16	14	29	47	DERROTA Inverness CT 2 Arbroath 0 EMPATE Raith Rovers 1 Arbroath 1 DERROTA Arbroath 0 Cove Rangers 1 DERROTA Partick Thistle 2 Arbroath 0 EMPATE Arbroath 0 Hamilton Academica. 0
9	Hamilton	31	36	7	10	19	31	63	DERROTA Greenock Morton 2 Hamilton Academica. 0 DERROTA Queen's Park 1 Hamilton Academica. 0 DERROTA Hamilton Academica. 1 Inverness CT 2 EMPATE Hamilton Academica. 2 Partick Thistle 2 EMPATE Arbroath 0 Hamilton Academica. 0
10	Cove Rangers	31	36	7	10	19	38	75	EMPATE Hamilton Academica. 1 Cove Rangers 1 DERROTA Cove Rangers 1 Inverness CT 2 VICTORIA Arbroath 0 Cove Rangers 1 EMPATE Dundee 0 Cove Rangers 0 DERROTA Cove Rangers 1 Greenock Morton 2

	Ascenso : Dundee
	Playoff Ascenso : Ayr United
	Siguiente Ronda : Queen's Park, Partick Thistle
	Playoff Descenso : Hamilton
	Descenso : Cove Rangers

JUGADORES DESTACADOS

RK		Nombre	Goles	Posición	Equipo
1		D. Akinyemi	20	DEL	Ayr United
2		Simon Murray	15	DEL	Queen's Park
3		W. Mckay	13	DEL	Inverness CT
4		B. Graham	13	DEL	Partick Thistle
5		Z. Robinson	12	DEL	Dundee
6		R. Muirhead	11	DEL	Greenock Morton
7		A. Connolly	10	DEL	Raith Rovers
8		G. Savoury	10	MED	Queen's Park
9		S. Tiffoney	9	DEL	Partick Thistle
10		N. Shaw	9	DEF	Inverness CT
11		L. Mcintosh	8	DEL	Cove Rangers
12		G. Gillespie	8	MED	Greenock Morton
13		J. Mullin	8	MED	Ayr United
14		L. Cameron	8	DEF	Dundee
15		S. Lawless	7	DEL	Partick Thistle
16		M. Megginson	7	DEL	Cove Rangers
17		G. Oakley	7	DEL	Greenock Morton
18		C. Scully	7	MED	Cove Rangers
19		Luke Mccowan	7	DEL	Dundee
20		B. Dempsey	7	MED	Ayr 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

10

USO DE MEMORIA

5,921,512 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.0918
Total Execution Time	0.0938

CADENA URL

/first_division2023

GET DATOS

$_GET['/first_division2023']

POST DATOS

No hay datos POST existentes

CONSULTAS (14)

0.0022	SELECT type,rule FROM rules WHERE categoryId = 23 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0024	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:50:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:50:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:50:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:50:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0028	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=67941 AND rel.round=36
0.0040	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 `calendars2023` 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` = 67941 AND c.`round` = 36 ORDER BY shedule ASC LIMIT 200
0.0065	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 events2023 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2023 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 67941 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 (23467,23468,23469,23470,23471) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0132	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 `events2023` e INNER JOIN calendars2023 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 = 36 AND e.real_date IS NOT NULL AND e.league_id = 67941 ORDER BY total DESC LIMIT 40
0.0038	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* `tables2023` 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 = 67941 AND t.round = 35 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0072	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` 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 = 67941 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT distinct(shedule), round FROM `calendars2023` as c WHERE c.`league_id` = 67941 AND shedule >= '2023/05/01' AND shedule < '2023/06/01' ORDER BY shedule ASC
0.0019	SELECT data1, data2 FROM services_tags WHERE categoryId=23
0.0038	SELECT group_code, extraName from `leagues` WHERE categoryId=23 AND year=2023