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

2014/2015

Eliminatoria

Segunda División Uruguay Formato Antiguo 2015

Segunda Uruguay - Playoffs Ascenso

Segunda División Uruguay Formato Antiguo 2015

Segunda División Uruguay Formato Antiguo 2015

La temporada finalizó el Lunes, 25 Mayo 2015.

	19 Dic 14 21:00 Finalizado	Huracán FC	Huracán FC - Boston River 2014-12-19T21:00:00 J.A.Lavalleja de Flores 1-3	Boston River	más información Jugadas destacadas ...
			0-1	28' G. Zarfino
		52' R. Molina	1-1
			1-2	79' F. Moreira
				87' W. Lencina
			1-3	90' G. Zarfino
	20 Dic 14 21:00 Finalizado	Deportivo Maldonado	Deportivo Maldonado - Progreso 2014-12-20T21:00:00 Domingo Burgueño (Municipal de Maldonado) 1-0	Progreso	más información Jugadas destacadas ...
				38' F. Trujillo
		90' S. Bello	1-0
	20 Dic 14 21:00 Finalizado	Canadian	Canadian - Miramar Misiones 2014-12-20T21:00:00 No disponible 0-0	Miramar Misiones	más información ...
	20 Dic 14 21:00 Finalizado	Liverpool Montevideo	Liverpool Montevideo - CSyD Villa Española 2014-12-20T21:00:00 Belvedere 2-1	CSyD Villa Española	más información Jugadas destacadas ...
			0-1	20' S. López
		68' E. Alfaro	1-1
				90' I. Avilés
		90' J. Arias	2-1
				90' D. Santin
	20 Dic 14 21:00 Finalizado	Cerrito	Cerrito - Cerro Largo 2014-12-20T21:00:00 Parque Maracaná 0-0	Cerro Largo	más información Jugadas destacadas ...
				86' S. Maidana
	20 Dic 14 21:00 Finalizado	Central Español FC	Central Español FC - Villa Teresa 2014-12-20T21:00:00 Parque Palermo 1-1	Villa Teresa	más información Jugadas destacadas ...
		57' Pablo Daniel Olivera	1-0
			1-1	86' P. Lavandeira
	21 Dic 14 21:00 Finalizado	Plaza Colonia	Plaza Colonia - Rocha FC 2014-12-21T21:00:00 Estadio Profesor Alberto Suppici 1-0	Rocha FC	más información Jugadas destacadas ...
		81' N. Dibble	1-0

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Liverpool	38	14	12	2	0	45	10	VICTORIA Liverpool Montevid. 4 Boston River 0 VICTORIA Cerro Largo 0 Liverpool Montevid. 1 VICTORIA Liverpool Montevid. 4 Miramar Misiones 1 EMPATE Villa Teresa 1 Liverpool Montevid. 1 VICTORIA Liverpool Montevid. 2 CSyD Villa Español. 1
2	CSyD Villa Espa.	22	14	6	4	4	24	17	VICTORIA Cerro Largo 0 CSyD Villa Español. 1 DERROTA CSyD Villa Español. 1 Miramar Misiones 2 VICTORIA Villa Teresa 1 CSyD Villa Español. 3 VICTORIA CSyD Villa Español. 2 Montevideo City To. 0 DERROTA Liverpool Montevid. 2 CSyD Villa Español. 1
3	Cerro Largo	21	14	6	3	5	18	13	DERROTA Montevideo City To. 3 Cerro Largo 2 DERROTA Cerro Largo 0 Liverpool Montevid. 1 DERROTA Central Español FC 2 Cerro Largo 1 EMPATE Cerro Largo 0 Canadian 0 EMPATE Cerrito 0 Cerro Largo 0
4	Central Español	21	14	5	6	3	17	17	EMPATE Central Español FC 1 Rocha FC 1 VICTORIA Boston River 1 Central Español FC 2 VICTORIA Central Español FC 2 Cerro Largo 1 EMPATE Miramar Misiones 0 Central Español FC 0 EMPATE Central Español FC 1 Villa Teresa 1
5	Montevideo City	21	14	5	6	3	20	22	VICTORIA Boston River 2 Montevideo City To. 3 VICTORIA Montevideo City To. 3 Cerro Largo 2 VICTORIA Miramar Misiones 0 Montevideo City To. 1 VICTORIA Montevideo City To. 3 Villa Teresa 1 DERROTA CSyD Villa Español. 2 Montevideo City To. 0
6	Canadian	20	14	5	5	4	17	14	VICTORIA Canadian 2 Progreso 0 DERROTA Rocha FC 1 Canadian 0 EMPATE Canadian 0 Boston River 0 EMPATE Cerro Largo 0 Canadian 0 EMPATE Canadian 0 Miramar Misiones 0
7	Villa Teresa	18	14	5	3	6	21	20	EMPATE Miramar Misiones 1 Villa Teresa 1 DERROTA Villa Teresa 1 CSyD Villa Español. 3 DERROTA Montevideo City To. 3 Villa Teresa 1 EMPATE Villa Teresa 1 Liverpool Montevid. 1 EMPATE Central Español FC 1 Villa Teresa 1
8	Huracán FC	18	14	5	3	6	24	25	DERROTA Huracán FC 0 Plaza Colonia 3 EMPATE Deportivo Maldonad. 1 Huracán FC 1 DERROTA Huracán FC 1 Progreso 2 EMPATE Rocha FC 1 Huracán FC 1 DERROTA Huracán FC 1 Boston River 3
9	Deportivo	18	14	5	3	6	16	18	DERROTA Deportivo Maldonad. 2 Canadian 3 VICTORIA Cerrito 1 Deportivo Maldonad. 2 EMPATE Deportivo Maldonad. 1 Huracán FC 1 DERROTA Plaza Colonia 3 Deportivo Maldonad. 2 VICTORIA Deportivo Maldonad. 1 Progreso 0
10	Boston River	17	14	4	5	5	17	20	DERROTA Liverpool Montevid. 4 Boston River 0 DERROTA Boston River 1 Central Español FC 2 EMPATE Canadian 0 Boston River 0 EMPATE Boston River 2 Cerrito 2 VICTORIA Huracán FC 1 Boston River 3
11	Rocha FC	15	14	3	6	5	11	18	EMPATE Central Español FC 1 Rocha FC 1 VICTORIA Rocha FC 1 Canadian 0 EMPATE Cerrito 2 Rocha FC 2 EMPATE Rocha FC 1 Huracán FC 1 DERROTA Plaza Colonia 1 Rocha FC 0
12	Plaza Colonia	15	14	4	3	7	16	29	DERROTA Plaza Colonia 1 Cerrito 2 VICTORIA Huracán FC 0 Plaza Colonia 3 VICTORIA Plaza Colonia 3 Deportivo Maldonad. 2 EMPATE Progreso 1 Plaza Colonia 1 VICTORIA Plaza Colonia 1 Rocha FC 0
13	Progreso	14	14	3	5	6	10	19	DERROTA Canadian 2 Progreso 0 VICTORIA Progreso 2 Cerrito 1 VICTORIA Huracán FC 1 Progreso 2 EMPATE Progreso 1 Plaza Colonia 1 DERROTA Deportivo Maldonad. 1 Progreso 0
14	Miramar Misiones	12	14	2	6	6	11	16	VICTORIA CSyD Villa Español. 1 Miramar Misiones 2 DERROTA Miramar Misiones 0 Montevideo City To. 1 DERROTA Liverpool Montevid. 4 Miramar Misiones 1 EMPATE Miramar Misiones 0 Central Español FC 0 EMPATE Canadian 0 Miramar Misiones 0
15	Cerrito	12	14	2	6	6	16	25	DERROTA Cerrito 1 Deportivo Maldonad. 2 DERROTA Progreso 2 Cerrito 1 EMPATE Cerrito 2 Rocha FC 2 EMPATE Boston River 2 Cerrito 2 EMPATE Cerrito 0 Cerro Largo 0

	Ascenso: Liverpool, CSyD Villa Espa.
	Playoff Ascenso: Cerro Largo, Central Español, Montevideo City, Canadian

JUGADORES DESTACADOS

RK		Nombre	Goles	Posición	Equipo
1		E. Alfaro	21	DEL	Liverpool Montevideo
2		J. Arias	17	DEL	Liverpool Montevideo
3		I. Lemmo	14	MED	Canadian
4		S. López	14	DEL	CSyD Villa Española
5		R. Tarragona	13	DEL	Boston River
6		W. Techera	13	DEF	Montevideo City Torq.
7		M. Méndez	13	DEF	Huracán FC
8		A. Mello	11	DEL	Villa Teresa
9		M. Freitas	11	DEL	Plaza Colonia
10		S. Bello	10	DEL	Deportivo Maldonado
11		F. Vega	10	MED	Plaza Colonia
12		F. Cañarte	10	MED	CSyD Villa Española
13		C. Gutiérrez	9	DEL	Rocha FC
14		M. Aldave	8	DEL	Cerrito
15		I. Flores	7	DEL	Canadian
16		J. Zeballos	7	DEL	Deportivo Maldonado
17		Artigas	6	MED	Central Español FC
18		J. Charquero	6	DEL	Boston River
19		S. García	6	DEF	Boston River
20		J. Rivero	6	MED	Central Español FC

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

15

INFORMACIÓN

La Segunda División Profesional de Uruguay es el torneo de segunda división del fútbol uruguayo, organizado por la Asociación Uruguaya de Fútbol. Actualmente lo disputan 12 equipos, de los cuales cinco pertenecen a la ciudad de Montevideo y los otros siete al interior del Uruguay. De estos doce participantes, tres lograrán el ascenso a Primera División.

USO DE MEMORIA

5,800,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1038
Total Execution Time	0.1057

CADENA URL

/uruguay_segunda_divison2015/grupo1/jornada15

GET DATOS

$_GET['/uruguay_segunda_divison2015/grupo1/jornada15']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0020	SELECT type FROM routes WHERE alias = 'uruguay_segunda_divison2015'
0.0049	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'uruguay_segunda_divison' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=198 AND type_rel = 3
0.0030	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 198 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0030	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 (814046,799005,796636,687526,586340) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = 4850 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2015' WHERE c.parentId=198 GROUP BY c.id ORDER BY c.order_id ASC
0.0019	SELECT type,rule FROM rules WHERE categoryId = 198 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 13:31:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 13:31:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 13:31:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 13:31:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'uruguay_segunda_divison' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018	SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 198 GROUP BY l.categoryId
0.0018	SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=198 GROUP BY l.year ORDER BY l.year DESC
0.0019	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=4850 AND rel.round=15
0.0019	SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA 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 = 4850 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
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 = 4850 AND esl.points > 0
0.0017	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-04-08" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 4850 ORDER BY creation_date DESC LIMIT 0, 10
0.0024	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-04-08" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 4850
0.0032	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 `calendars2015` 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` = 4850 AND c.`round` = 15 ORDER BY shedule ASC LIMIT 200
0.0050	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 events2015 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2015 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 4850 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 (232798,232797,232799,232800,232802,232803,232801) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0023	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 `events2015` e INNER JOIN calendars2015 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 = 15 AND e.real_date IS NOT NULL AND e.league_id = 4850 ORDER BY total DESC LIMIT 40
0.0029	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* `tables2015` 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 = 4850 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2015` 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 = 4850 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	SELECT distinct(shedule), round FROM `calendars2015` as c WHERE c.`league_id` = 4850 AND shedule >= '2014/12/01' AND shedule < '2015/01/01' ORDER BY shedule ASC
0.0018	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-05-08 00:00:00' AND c.`shedule` < '2024-05-12 23:59:59' AND l.id = 4850 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020	SELECT data1, data2 FROM services_tags WHERE categoryId=198
0.0020	SELECT group_code, extraName from `leagues` WHERE categoryId=198 AND year=2015