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

2022/2023

Liga Premier Serie A - Apertura

Liga Premier Serie A - Clausura

Liga Premier Serie A - Apertura

La temporada finalizó el Domingo, 23 Octubre 2022.

Resultados

« Jornada Anterior

Jornada Siguiente »

	28 Sep 22 23:00 Finalizado	UA Zacatecas	UA Zacatecas - Mineros de Fresnillo 2022-09-28T23:00:00 No disponible (5) 3-3 (4)	Mineros de Fresnillo	más información Jugadas destacadas ...
		7' J. Sandoval	1-0
		17' Jared Torres	2-0
			2-1	39' Diego Espinosa
			2-2	60' P. Padilla
		65' Luis Maldonado	3-2
			3-3	76' Melchor López
				90' I. Moreno
		90' C. García
	28 Sep 22 23:00 Finalizado	Tritones Vallarta	Tritones Vallarta - Los Cabos 2022-09-28T23:00:00 No disponible 1-1	Los Cabos	más información Jugadas destacadas 4
		9' Mario Orozco	1-0
			1-1	48' Aldo Suárez
	29 Sep 22 00:00 Finalizado	Tecos	Tecos - Leones Negros II 2022-09-29T00:01:00 Tres de Marzo 0-3	Leones Negros II	más información Jugadas destacadas 1
			0-1	15' Kevin Sandoval
			0-2	48' J. Garibay
				71' B. Toledo
			0-3	90' Kevin Sandoval
	29 Sep 22 02:30 Finalizado	Chihuahua FC	Chihuahua FC - Mexicali FC 2022-09-29T02:30:00 No disponible 6-0	Mexicali FC	más información Jugadas destacadas 2
		10' G. Escobedo	1-0
		12' Axel García	2-0
		22' J. Coronel	3-0
		31' D. Gama	4-0
		58' D. Gama	5-0
		91' S. Rodríguez	6-0
	29 Sep 22 03:30 Finalizado	Coras de Nayarit	Coras de Nayarit - Cimarrones II 2022-09-29T03:30:00 No disponible (1) 2-2 (3)	Cimarrones II	más información Jugadas destacadas 26
			0-1	5' J. Osuna
		41' D. Mosquera
		50' M. Rodríguez	1-1
		62' Luis Adalberto García	2-1
			2-2	74' Erick Solórzano

Clasificación

« Jornada Anterior

Jornada Siguiente »

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Los Cabos *	18	7	5	1	1	13	5	DERROTA Chihuahua FC 2 Los Cabos 1 VICTORIA Los Cabos 1 Leones Negros II 0 VICTORIA Mexicali FC 0 Los Cabos 2 VICTORIA Los Cabos 3 Tecos 0 EMPATE Tritones Vallarta 1 Los Cabos 1
2	UA Zacatecas *	16	6	4	1	1	14	5	VICTORIA UA Zacatecas 3 Tecos 0 VICTORIA Tritones Vallarta 1 UA Zacatecas 2 VICTORIA UA Zacatecas 3 Coras de Nayarit 0 DERROTA UA Zacatecas 0 Chihuahua FC 1 EMPATE UA Zacatecas 3 Mineros de Fresnil. 3
3	Tritones *	14	6	4	1	1	8	5	DERROTA Tritones Vallarta 1 UA Zacatecas 2 VICTORIA Mineros de Fresnil. 0 Tritones Vallarta 1 VICTORIA Tritones Vallarta 3 Halcones de Zapopa. 2 VICTORIA Cimarrones II 0 Tritones Vallarta 1 EMPATE Tritones Vallarta 1 Los Cabos 1
4	Chihuahua FC	13	6	4	1	1	14	5	DERROTA Coras de Nayarit 3 Chihuahua FC 0 VICTORIA Chihuahua FC 2 Los Cabos 1 VICTORIA Chihuahua FC 4 Leones Negros II 0 VICTORIA UA Zacatecas 0 Chihuahua FC 1 VICTORIA Chihuahua FC 6 Mexicali FC 0
5	Leones Negros *	11	7	3	1	3	14	10	DERROTA Leones Negros II 2 Cimarrones II 3 DERROTA Los Cabos 1 Leones Negros II 0 DERROTA Chihuahua FC 4 Leones Negros II 0 VICTORIA Leones Negros II 5 Mexicali FC 0 VICTORIA Tecos 0 Leones Negros II 3
6	Halcones Zapopan	10	6	3	1	2	11	9	EMPATE Halcones de Zapopa. 1 Leones Negros II 1 VICTORIA Mexicali FC 1 Halcones de Zapopa. 2 VICTORIA Halcones de Zapopa. 3 Tecos 1 DERROTA Tritones Vallarta 3 Halcones de Zapopa. 2 VICTORIA Halcones de Zapopa. 2 Coras de Nayarit 1
7	Cimarrones II *	9	7	2	2	3	11	14	VICTORIA Leones Negros II 2 Cimarrones II 3 VICTORIA Cimarrones II 3 Mexicali FC 1 DERROTA Tecos 4 Cimarrones II 1 DERROTA Cimarrones II 0 Tritones Vallarta 1 EMPATE Coras de Nayarit 2 Cimarrones II 2
8	Mineros	7	6	2	1	3	13	12	VICTORIA Mineros de Fresnil. 6 Mexicali FC 1 VICTORIA Tecos 2 Mineros de Fresnil. 3 DERROTA Mineros de Fresnil. 0 Tritones Vallarta 1 DERROTA Coras de Nayarit 2 Mineros de Fresnil. 0 EMPATE UA Zacatecas 3 Mineros de Fresnil. 3
9	Coras Nayarit	7	6	2	1	3	8	8	VICTORIA Coras de Nayarit 3 Chihuahua FC 0 DERROTA UA Zacatecas 3 Coras de Nayarit 0 VICTORIA Coras de Nayarit 2 Mineros de Fresnil. 0 DERROTA Halcones de Zapopa. 2 Coras de Nayarit 1 EMPATE Coras de Nayarit 2 Cimarrones II 2
10	Tecos *	4	6	1	0	5	7	16	DERROTA Tecos 2 Mineros de Fresnil. 3 DERROTA Halcones de Zapopa. 3 Tecos 1 VICTORIA Tecos 4 Cimarrones II 1 DERROTA Los Cabos 3 Tecos 0 DERROTA Tecos 0 Leones Negros II 3
11	Mexicali FC	0	7	0	0	7	3	27	DERROTA Mexicali FC 1 Halcones de Zapopa. 2 DERROTA Cimarrones II 3 Mexicali FC 1 DERROTA Mexicali FC 0 Los Cabos 2 DERROTA Leones Negros II 5 Mexicali FC 0 DERROTA Chihuahua FC 6 Mexicali FC 0

	Series Finales : Los Cabos, UA Zacatecas
	Posible siguiente ronda : Tritones

Penalizaciones de la competición

	+1 Puntos: Tecos
	+3 Puntos: UA Zacatecas
	+1 Puntos: Cimarrones II
	+1 Puntos: Leones Negros
	+1 Puntos: Tritones
	+2 Puntos: Los Cabos

JUGADORES DESTACADOS

RK		Nombre	Goles	Posición	Equipo
1		D. Gama	7	DEL	Chihuahua FC
2		Kevin Sandoval	6	MED	Leones Negros II
3		M. Rodríguez	4	MED	Coras de Nayarit
4		J. Torres	4	DEL	UA Zacatecas
5		V. Argumedo	4	MED	Los Cabos
6		Aldo Suárez	4	DEL	Los Cabos
7		A. Godínez	4	MED	Halcones de Zapopan
8		Armando Bernal	4	DEL	UA Zacatecas
9		David Rangel	3	MED	Tritones Vallarta
10		M. Serrano	3	MED	Mineros de Fresnillo
11		A. Acosta	3	MED	Halcones de Zapopan
12		Diego Espinosa	3	MED	Mineros de Fresnillo
13		Roberto Cabral	3	DEL	Tecos
14		J. Garibay	3	DEL	Leones Negros II
15		Oxiel Angulo	3	MED	Tecos
16		Jared Torres	3	DEL	UA Zacatecas
17		Agustín Ortega	3	DEL	Tritones Vallarta
18		S. Rodríguez	2	MED	Chihuahua FC
19		G. Escobedo	2	DEL	Tecos
20		J. Barajas	2	MED	Tritones Vallarta

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»

LIGAS RELACIONADAS

Equipos de esta competición

11

USO DE MEMORIA

5,818,064 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.2568
Total Execution Time	0.2588

CADENA URL

/premier_de_ascenso_apertura/grupo1/jornada7

GET DATOS

$_GET['/premier_de_ascenso_apertura/grupo1/jornada7']

POST DATOS

No hay datos POST existentes

CONSULTAS (15)

0.0109	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1415 AND type_rel = 3
0.0115	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1415 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0121	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 (1081943,1008128,684922,673672,273827) ORDER BY n.cover_points DESC, update_date DESC
0.0113	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 05:06:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 05:06:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-06 05:06:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 05:06:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109	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=68370 AND rel.round=7
0.0108	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` = 68370 AND c.`round` = 7 ORDER BY shedule ASC LIMIT 200
0.0114	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 = 68370 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 (186665,186666,186667,186668,186669) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0121	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 = 7 AND e.real_date IS NOT NULL AND e.league_id = 68370 ORDER BY total DESC LIMIT 40
0.0111	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 = 68370 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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 = 68370 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106	SELECT data1, data2 FROM services_tags WHERE categoryId=1415
0.0107	SELECT group_code, extraName from `leagues` WHERE categoryId=1415 AND year=2023