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

2012/2013

Segunda B Estonia 2013

Segunda B Estonia Play Offs Ascenso

Segunda B Estonia 2013

Segunda B Estonia 2013

La temporada finalizó el Domingo, 10 Noviembre 2013.

	28 Sep 13 13:00 Finalizado	TJK Legion	TJK Legion - FC Elva 2013-09-28T13:00:00 No disponible 3-1	FC Elva	más información Jugadas destacadas ...
		17' R. Mikailov	1-0
			1-1	44' Marek Naaris
		45' Gleb Artjuhhov	2-1
		51' A. Titenok	3-1
	29 Sep 13 13:00 Finalizado	Emmaste	Emmaste - FC Flora Tallin III 2013-09-29T13:00:00 No disponible 2-3	FC Flora Tallin III	más información Jugadas destacadas ...
			0-1	25' M. Astur
		34' Kristjan Paapsi	1-1
			1-2	35' M. Astur
		41' Vahur Vahtramäe	2-2
			2-3	56' M. Astur
	29 Sep 13 13:05 Finalizado	Nõmme Kalju II	Nõmme Kalju II - Sillamäe Kalev II 2013-09-29T13:05:00 No disponible 5-1	Sillamäe Kalev II	más información Jugadas destacadas ...
		12' K. Usami	1-0
			1-1	12' K. Usami
		66' Mihkel Ainsalu	2-1
		75' Mihkel Ainsalu	3-1
		82' A. Hadzanovic	4-1
		83' Mihkel Ainsalu	5-1
		89' A. Hadzanovic	6-1
	29 Sep 13 16:00 Finalizado	Tallinna Dünamo	Tallinna Dünamo - Vaprus Pärnu 2013-09-29T16:00:00 No disponible 1-1	Vaprus Pärnu	más información Jugadas destacadas ...
		26' Maksim Zidkov	1-0
			1-1	45' H. Hanson
	29 Sep 13 16:00 Finalizado	Alliance FC	Alliance FC - Ararat 2013-09-29T16:00:00 No disponible 1-3	Ararat	más información Jugadas destacadas ...
				61' R. Pold
			0-1	66' Andre Järva
			0-2	75' Avetis Harutjunjan
			0-3	80' Andre Järva
		87' Anatoli Beregovski	1-3

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Nõmme Kalju II	66	30	21	3	6	75	31	DERROTA Nõmme Kalju II 0 Vaprus Pärnu 3 VICTORIA Tallinna Dünamo 1 Nõmme Kalju II 2 VICTORIA Nõmme Kalju II 3 Tallinna Dünamo 0 VICTORIA Vaprus Pärnu 2 Nõmme Kalju II 3 VICTORIA Nõmme Kalju II 5 Sillamäe Kalev II 1
2	Vaprus Pärnu	63	30	20	3	7	91	44	VICTORIA Nõmme Kalju II 0 Vaprus Pärnu 3 VICTORIA Emmaste 0 Vaprus Pärnu 2 VICTORIA Vaprus Pärnu 5 Emmaste 3 DERROTA Vaprus Pärnu 2 Nõmme Kalju II 3 EMPATE Tallinna Dünamo 1 Vaprus Pärnu 1
3	Sillamäe Kalev	56	30	16	8	6	65	42	DERROTA Sillamäe Kalev II 1 Emmaste 3 VICTORIA Alliance FC 2 Sillamäe Kalev II 3 VICTORIA Sillamäe Kalev II 4 Alliance FC 0 VICTORIA Emmaste 1 Sillamäe Kalev II 2 DERROTA Nõmme Kalju II 5 Sillamäe Kalev II 1
4	Ararat	54	30	17	3	10	67	42	DERROTA TJK Legion 3 Ararat 2 DERROTA Ararat 1 FC Elva 2 VICTORIA FC Elva 1 Ararat 3 VICTORIA Ararat 5 TJK Legion 0 VICTORIA Alliance FC 1 Ararat 3
5	Emmaste	54	30	17	3	10	60	37	VICTORIA Sillamäe Kalev II 1 Emmaste 3 DERROTA Emmaste 0 Vaprus Pärnu 2 DERROTA Vaprus Pärnu 5 Emmaste 3 DERROTA Emmaste 1 Sillamäe Kalev II 2 DERROTA Emmaste 2 FC Flora Tallin II. 3
6	TJK Legion	41	30	12	5	13	49	57	VICTORIA TJK Legion 3 Ararat 2 DERROTA FC Flora Tallin II. 3 TJK Legion 1 VICTORIA TJK Legion 1 FC Flora Tallin II. 0 DERROTA Ararat 5 TJK Legion 0 VICTORIA TJK Legion 3 FC Elva 1
7	FC Elva	40	30	12	4	14	49	55	EMPATE FC Elva 0 Alliance FC 0 VICTORIA Ararat 1 FC Elva 2 DERROTA FC Elva 1 Ararat 3 VICTORIA Alliance FC 0 FC Elva 1 DERROTA TJK Legion 3 FC Elva 1
8	Tallinna Dünamo	24	30	7	3	20	33	73	VICTORIA Tallinna Dünamo 4 FC Flora Tallin II. 0 DERROTA Tallinna Dünamo 1 Nõmme Kalju II 2 DERROTA Nõmme Kalju II 3 Tallinna Dünamo 0 DERROTA FC Flora Tallin II. 3 Tallinna Dünamo 0 EMPATE Tallinna Dünamo 1 Vaprus Pärnu 1
9	Flora Tallin	23	30	7	2	21	31	88	DERROTA Tallinna Dünamo 4 FC Flora Tallin II. 0 VICTORIA FC Flora Tallin II. 3 TJK Legion 1 DERROTA TJK Legion 1 FC Flora Tallin II. 0 VICTORIA FC Flora Tallin II. 3 Tallinna Dünamo 0 VICTORIA Emmaste 2 FC Flora Tallin II. 3
10	Alliance FC	10	30	2	4	24	19	70	EMPATE FC Elva 0 Alliance FC 0 DERROTA Alliance FC 2 Sillamäe Kalev II 3 DERROTA Sillamäe Kalev II 4 Alliance FC 0 DERROTA Alliance FC 0 FC Elva 1 DERROTA Alliance FC 1 Ararat 3

JUGADORES DESTACADOS

RK		Nombre	Goles	Posición	Equipo
1		J. Kuresoo	33	DEF	FC Elva
2		H. Hanson	28	MED	Vaprus Pärnu
3		K. Saarts	25	DEL	Vaprus Pärnu
4		I. Torinava	20	MED	Sillamäe Kalev II
5		Robert Kirss	16	DEL	Nõmme Kalju II
6		Andre Järva	16	DEL	Ararat
7		A. Antonov	15	DEL	Ararat
8		K. Usami	15	DEL	Nõmme Kalju II
9		Reimo Oja	15	DEL	Emmaste
10		Avetis Harutjunjan	14	DEL	Ararat
11		E. Lauter	13	MED	Vaprus Pärnu
12		A. Hadzanovic	12	MED	Nõmme Kalju II
13		M. Astur	12	DEL	FC Flora Tallin III
14		Mihkel Ainsalu	10	MED	Nõmme Kalju II
15		Maksim Zidkov	10	MED	Tallinna Dünamo
16		T. Laurits	9	DEL	Emmaste
17		A. Issakov	9	MED	Vaprus Pärnu
18		T. Vihmoja	9	MED	Vaprus Pärnu
19		R. Mikailov	8	DEF	TJK Legion
20		Magnus Martinson	8	DEF	Emmaste

Busca la liga de tu equipo

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

ÚLTIMAS NOTICIAS

Ver más noticias de la competicion»

Equipos de esta competición

10

USO DE MEMORIA

5,617,368 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.3852
Total Execution Time	0.3873

CADENA URL

/segunda_b_estonia2013/grupo1/jornada30

GET DATOS

$_GET['/segunda_b_estonia2013/grupo1/jornada30']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0018	SELECT type FROM routes WHERE alias = 'segunda_b_estonia2013'
0.0041	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_b_estonia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1605 AND type_rel = 3
0.0022	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 = 15379 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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='2013' WHERE c.parentId=1605 GROUP BY c.id ORDER BY c.order_id ASC
0.0018	SELECT type,rule FROM rules WHERE categoryId = 1605 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-09 16:23:44' 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-09 16:23:44' 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-09 16:23:44' 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-09 16:23:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_b_estonia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0049	SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (15379) 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.0046	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 (15379) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (62716,290463,286395,175373,227675,277445,449496,490932,604992,605174,286396,128934,531346,283404,605427,286290,287588,319678,430031,604988) ORDER BY rp.in_squad = 1 DESC
0.0356	SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (15379) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0321	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 (15379) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (696744,604988,370759,286396,604970,809394,279349,286395,430031,606786,65267,175368,228613,572337,175119,175355,277445,287088,375475,490435) ORDER BY rp.in_squad = 1 DESC
0.0129	SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (15379) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0285	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 (15379) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (490435,65267,379182,384366,604988,606854,175358,175368,228613,277445,287088,290463,312786,315942,318288,319678,330000,336392,370759,375475) ORDER BY rp.in_squad = 1 DESC
0.0068	SELECT e.action, count(e.action) as total, e.player_id FROM events2013 e WHERE e.league_id IN (15379) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0072	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 (15379) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (385256,449496,607048,809505) ORDER BY rp.in_squad = 1 DESC
0.0056	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 = 15379 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0053	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 = 15379 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0042	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=15379 AND rel.round=30
0.0029	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 = 15379 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020	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 = 15379 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-09" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 15379 ORDER BY creation_date DESC LIMIT 0, 10
0.0097	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-09" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 15379
0.0382	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 `calendars2013` 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` = 15379 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0846	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 events2013 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2013 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 15379 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 (496368,496370,496369,496371,496372) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0062	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 `events2013` e INNER JOIN calendars2013 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 15379 ORDER BY total DESC LIMIT 40
0.0050	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* `tables2013` 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 = 15379 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2013` 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 = 15379 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT distinct(shedule), round FROM `calendars2013` as c WHERE c.`league_id` = 15379 AND shedule >= '2013/09/01' AND shedule < '2013/10/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-09 00:00:00' AND c.`shedule` < '2024-05-13 23:59:59' AND l.id = 15379 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0097	SELECT data1, data2 FROM services_tags WHERE categoryId=1605
0.0032	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1605 AND l.year = 2013 ORDER BY l.group_code ASC
0.0032	SELECT group_code, extraName from `leagues` WHERE categoryId=1605 AND year=2013