4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2018
Temporada Siguiente »
Publicidad 600x120.gif
Segunda Estonia 2018
2017/2018

Segunda Estonia 2018

  • Maardu FC
  • FC Flora Tallin II
  • Levadia Tallinn II
  • Rakvere JK Tarvas
  • FC Elva
  • Tartu Welco
  • Tallinna Kalev II
  • Tartu FC Santos
  • Keila
  • Nõmme Kalju II

Segunda Estonia 2018

La temporada finalizó el Domingo, 11 Noviembre 2018.
Resultados
« Jornada Anterior
Jornada 30
Jornada Siguiente »
 
23 Sep 18
12:00 Finalizado 		Tartu Welco Tartu Welco 0-4 FC Elva FC Elva más información Jugadas destacadas ...
2' M. Nõmmsalu M. Nõmmsalu
0-1 10' A. Joandi A. Joandi
0-2 42' P. Frei P. Frei
0-3 56' J. Kuresoo J. Kuresoo
0-4 71' P. Frei P. Frei
 
23 Sep 18
12:00 Finalizado 		Rakvere JK Tarvas Rakvere JK Tarvas 1-1 Keila Keila más información Jugadas destacadas ...
6' S. Goldberg S. Goldberg 1-0
1-1 73' R. Friedemann R. Friedemann
 
24 Sep 18
18:00 Finalizado 		Levadia Tallinn II Levadia Tallinn II 2-7 Maardu FC Maardu FC más información Jugadas destacadas 2
16' K. Oigus K. Oigus 1-0
1-1 18' V. Ogorodnik V. Ogorodnik
1-2 42' N. Brolin N. Brolin
1-3 56' V. Gussev V. Gussev
59' H. Ounas H. Ounas 2-3
2-4 61' I. Zelentsov I. Zelentsov
2-5 68' V. Ogorodnik V. Ogorodnik
2-6 72' V. Gussev V. Gussev
2-7 84' V. Gussev V. Gussev
 
24 Sep 18
18:00 Finalizado 		Tartu FC Santos Tartu FC Santos 4-1 Tallinna Kalev II Tallinna Kalev II más información Jugadas destacadas ...
13' A. Alve A. Alve 1-0
1-1 37' O. Meus O. Meus
37' O. Meus O. Meus 2-1
2-2 53' B. Bachmann B. Bachmann
79' A. Alve A. Alve 3-2
90' K. Heinmae K. Heinmae
90' K. Reinberg K. Reinberg 4-2
 
24 Sep 18
18:00 Finalizado 		Nõmme Kalju II Nõmme Kalju II 1-1 FC Flora Tallin II FC Flora Tallin II más información Jugadas destacadas 3
0-1 33' N. Komissarov N. Komissarov
90' J. Demidov J. Demidov 1-1
Clasificación
« Jornada Anterior
Jornada 30
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 Maardu FC Maardu FC 73 30 24 1 5 106 32
  • VICTORIA
  • Keila 4
  • Maardu FC 6
  • VICTORIA
  • Maardu FC 2
  • Tallinna Kalev II 0
  • VICTORIA
  • Maardu FC 5
  • Tartu FC Santos 0
  • DERROTA
  • Rakvere JK Tarvas 2
  • Maardu FC 1
  • VICTORIA
  • Levadia Tallinn II 2
  • Maardu FC 7
2 FC Flora Tallin II Flora Tallin 58 30 17 7 6 100 29
  • VICTORIA
  • FC Flora Tallin II 11
  • Tartu Welco 0
  • VICTORIA
  • Rakvere JK Tarvas 1
  • FC Flora Tallin II 2
  • DERROTA
  • FC Flora Tallin II 3
  • Levadia Tallinn II 5
  • DERROTA
  • FC Elva 2
  • FC Flora Tallin II 1
  • EMPATE
  • Nõmme Kalju II 1
  • FC Flora Tallin II 1
3 Levadia Tallinn II Levadia Tallinn 49 30 14 7 9 57 46
  • VICTORIA
  • Levadia Tallinn II 3
  • Tartu FC Santos 0
  • DERROTA
  • Levadia Tallinn II 1
  • Tartu Welco 2
  • VICTORIA
  • FC Flora Tallin II 3
  • Levadia Tallinn II 5
  • VICTORIA
  • Keila 1
  • Levadia Tallinn II 5
  • DERROTA
  • Levadia Tallinn II 2
  • Maardu FC 7
4 Rakvere JK Tarvas Rakvere Tarvas 48 30 13 9 8 52 46
  • VICTORIA
  • Nõmme Kalju II 1
  • Rakvere JK Tarvas 2
  • DERROTA
  • Rakvere JK Tarvas 1
  • FC Flora Tallin II 2
  • DERROTA
  • Rakvere JK Tarvas 1
  • Tallinna Kalev II 2
  • VICTORIA
  • Rakvere JK Tarvas 2
  • Maardu FC 1
  • EMPATE
  • Rakvere JK Tarvas 1
  • Keila 1
5 FC Elva FC Elva 43 30 11 10 9 41 54
  • EMPATE
  • Tallinna Kalev II 1
  • FC Elva 1
  • EMPATE
  • FC Elva 0
  • Tartu FC Santos 0
  • VICTORIA
  • FC Elva 3
  • Nõmme Kalju II 2
  • VICTORIA
  • FC Elva 2
  • FC Flora Tallin II 1
  • VICTORIA
  • Tartu Welco 0
  • FC Elva 4
6 Tartu Welco Tartu Welco 38 30 11 5 14 37 64
  • DERROTA
  • FC Flora Tallin II 11
  • Tartu Welco 0
  • VICTORIA
  • Levadia Tallinn II 1
  • Tartu Welco 2
  • VICTORIA
  • Tartu Welco 3
  • Keila 0
  • EMPATE
  • Tallinna Kalev II 1
  • Tartu Welco 1
  • DERROTA
  • Tartu Welco 0
  • FC Elva 4
7 Tallinna Kalev II Tallinna Kalev 33 30 8 9 13 33 45
  • EMPATE
  • Tallinna Kalev II 1
  • FC Elva 1
  • DERROTA
  • Maardu FC 2
  • Tallinna Kalev II 0
  • VICTORIA
  • Rakvere JK Tarvas 1
  • Tallinna Kalev II 2
  • EMPATE
  • Tallinna Kalev II 1
  • Tartu Welco 1
  • DERROTA
  • Tartu FC Santos 4
  • Tallinna Kalev II 1
8 Tartu FC Santos Tartu FC Santos 31 30 8 7 15 41 62
  • DERROTA
  • Levadia Tallinn II 3
  • Tartu FC Santos 0
  • EMPATE
  • FC Elva 0
  • Tartu FC Santos 0
  • DERROTA
  • Maardu FC 5
  • Tartu FC Santos 0
  • DERROTA
  • Nõmme Kalju II 3
  • Tartu FC Santos 1
  • VICTORIA
  • Tartu FC Santos 4
  • Tallinna Kalev II 1
9 Keila Keila 23 30 6 5 19 31 75
  • DERROTA
  • Keila 4
  • Maardu FC 6
  • VICTORIA
  • Keila 4
  • Nõmme Kalju II 1
  • DERROTA
  • Tartu Welco 3
  • Keila 0
  • DERROTA
  • Keila 1
  • Levadia Tallinn II 5
  • EMPATE
  • Rakvere JK Tarvas 1
  • Keila 1
10 Nõmme Kalju II Nõmme Kalju II 21 30 5 6 19 31 76
  • DERROTA
  • Nõmme Kalju II 1
  • Rakvere JK Tarvas 2
  • DERROTA
  • Keila 4
  • Nõmme Kalju II 1
  • DERROTA
  • FC Elva 3
  • Nõmme Kalju II 2
  • VICTORIA
  • Nõmme Kalju II 3
  • Tartu FC Santos 1
  • EMPATE
  • Nõmme Kalju II 1
  • FC Flora Tallin II 1
Ascenso : Maardu FC
Playoff Ascenso : Flora Tallin
Playoff Descenso : Tartu FC Santos
Descenso : Keila, Nõmme Kalju II
JUGADORES DESTACADOS


  USO DE MEMORIA  
5,758,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.3310
Total Execution Time  0.3341
  CADENA URL  
/esiliiga_estonia2018/grupo1/jornada30
  GET DATOS  
$_GET['/esiliiga_estonia2018/grupo1/jornada30']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=368 AND type_rel = 3
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 06:17:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 06:17:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 06:17:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 06:17:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0155  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=42546 AND rel.round=30
0.0153  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 `calendars2018` 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` = 42546 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0187  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 events2018 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2018 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 42546 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 (724143,724144,724145,724146,724147) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0228  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 `events2018` e INNER JOIN calendars2018 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 = 42546 ORDER BY total DESC LIMIT 40
0.0152  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 `tables2018` 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 = 42546 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 42546 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT distinct(shedule), round FROM `calendars2018` as c WHERE c.`league_id` = 42546 AND shedule >= '2018/09/01' AND shedule < '2018/10/01' ORDER BY shedule ASC
0.0144  SELECT data1, data2 FROM services_tags WHERE categoryId=368
0.0146  SELECT group_code, extraName from `leagues` WHERE categoryId=368 AND year=2018