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

Tercera Estonia 2020

  • FC Tallinn
  • TJK Legion II
  • FCI Tallinn
  • Trans II
  • Tartu Welco II
  • Sillamäe Kalev
  • Jogeva SK Noorus 96
  • Põhja-Tallinna JK Volta
  • Maardu II
  • Ajax Lasnamäe
  • FC Helios Voru
  • Tammeka III
  • JK Järve II
  • Jõgeva Wolves

Tercera Estonia 2020

La temporada finalizó el Domingo, 15 Noviembre 2020.
Resultados
« Jornada Anterior
Jornada 19
Jornada Siguiente »
 
25 Sep 20
17:00 Finalizado 		TJK Legion II TJK Legion II 5-3 Tartu Welco II Tartu Welco II más información Jugadas destacadas ...
0-1 9' R. Kuusik
14' G. Ussov 1-1
31' Nikita Ivanov 2-1
49' K. Vinogradov 3-1
81' Filipp Drabinko 4-1
88' M. Šatov 5-1
89' Jevgeni Kuprikov
6-2 92' R. Kuusik
 
26 Sep 20
13:00 Finalizado 		Ajax Lasnamäe Ajax Lasnamäe 1-1 Trans II Trans II más información ...
 
27 Sep 20
16:00 Finalizado 		Põhja-Tallinna JK Volta Põhja-Tallinna Volta 1-1 FC Tallinn FC Tallinn más información ...
 
27 Sep 20
16:00 Finalizado 		FC Helios Voru FC Helios Voru 6-0 Jogeva SK Noorus 96 Jogeva SK Noorus 96 más información ...
 
27 Sep 20
18:00 Finalizado 		Tammeka III Tammeka III 1-4 Sillamäe Kalev Sillamäe Kalev más información ...
 
01 Oct 20
19:00 Finalizado 		JK Järve II JK Järve II 1-2 FCI Tallinn FCI Tallinn más información ...
 
14 Oct 20
18:30 Finalizado 		Maardu II Maardu II 15-0 Jõgeva Wolves Jõgeva Wolves más información 2
Clasificación
« Jornada Anterior
Jornada 19
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 FC Tallinn FC Tallinn 45 19 14 3 2 66 19
  • VICTORIA
  • Jõgeva Wolves 2
  • FC Tallinn 8
  • VICTORIA
  • FC Tallinn 3
  • Trans II 0
  • VICTORIA
  • FC Tallinn 5
  • Ajax Lasnamäe 1
  • VICTORIA
  • FC Tallinn 4
  • Maardu II 0
  • EMPATE
  • Põhja-Tallinna JK. 1
  • FC Tallinn 1
2 TJK Legion II TJK Legion II 43 19 14 1 4 72 40
  • DERROTA
  • FCI Tallinn 4
  • TJK Legion II 3
  • DERROTA
  • FC Helios Voru 9
  • TJK Legion II 5
  • VICTORIA
  • TJK Legion II 2
  • JK Järve II 0
  • VICTORIA
  • Jogeva SK Noorus 9. 1
  • TJK Legion II 6
  • VICTORIA
  • TJK Legion II 5
  • Tartu Welco II 3
3 FCI Tallinn FCI Tallinn 39 19 13 0 6 65 21
  • VICTORIA
  • FCI Tallinn 4
  • TJK Legion II 3
  • VICTORIA
  • FCI Tallinn 18
  • Jõgeva Wolves 0
  • VICTORIA
  • FC Helios Voru 0
  • FCI Tallinn 6
  • DERROTA
  • FCI Tallinn 0
  • Trans II 1
  • VICTORIA
  • JK Järve II 1
  • FCI Tallinn 2
4 Trans II Trans II 38 19 12 2 5 47 27
  • DERROTA
  • Trans II 1
  • Sillamäe Kalev 2
  • DERROTA
  • FC Tallinn 3
  • Trans II 0
  • VICTORIA
  • Trans II 7
  • Jõgeva Wolves 0
  • VICTORIA
  • FCI Tallinn 0
  • Trans II 1
  • EMPATE
  • Ajax Lasnamäe 1
  • Trans II 1
5 Tartu Welco II Tartu Welco II 33 19 10 3 6 40 35
  • EMPATE
  • Ajax Lasnamäe 2
  • Tartu Welco II 2
  • VICTORIA
  • Tartu Welco II 4
  • Maardu II 1
  • VICTORIA
  • Põhja-Tallinna JK. 0
  • Tartu Welco II 1
  • VICTORIA
  • Tartu Welco II 2
  • Tammeka III 1
  • DERROTA
  • TJK Legion II 5
  • Tartu Welco II 3
6 Sillamäe Kalev Sillamäe Kalev 29 19 9 2 8 42 32
  • VICTORIA
  • Trans II 1
  • Sillamäe Kalev 2
  • VICTORIA
  • Sillamäe Kalev 6
  • Ajax Lasnamäe 0
  • VICTORIA
  • Maardu II 0
  • Sillamäe Kalev 4
  • VICTORIA
  • Põhja-Tallinna JK. 0
  • Sillamäe Kalev 1
  • VICTORIA
  • Tammeka III 1
  • Sillamäe Kalev 4
7 Jogeva SK Noorus 96 Jogeva Noorus 27 19 8 3 8 42 44
  • DERROTA
  • Maardu II 3
  • Jogeva SK Noorus 9. 1
  • DERROTA
  • Põhja-Tallinna JK. 1
  • Jogeva SK Noorus 9. 0
  • VICTORIA
  • Tammeka III 2
  • Jogeva SK Noorus 9. 4
  • DERROTA
  • Jogeva SK Noorus 9. 1
  • TJK Legion II 6
  • DERROTA
  • FC Helios Voru 6
  • Jogeva SK Noorus 9. 0
8 Põhja-Tallinna JK Volta Põhja-Tallinna 24 19 7 3 9 18 25
  • VICTORIA
  • Põhja-Tallinna JK. 1
  • JK Järve II 0
  • VICTORIA
  • Põhja-Tallinna JK. 1
  • Jogeva SK Noorus 9. 0
  • DERROTA
  • Põhja-Tallinna JK. 0
  • Tartu Welco II 1
  • DERROTA
  • Põhja-Tallinna JK. 0
  • Sillamäe Kalev 1
  • EMPATE
  • Põhja-Tallinna JK. 1
  • FC Tallinn 1
9 Maardu II Maardu II 21 19 6 3 10 37 51
  • VICTORIA
  • Maardu II 3
  • Jogeva SK Noorus 9. 1
  • DERROTA
  • Tartu Welco II 4
  • Maardu II 1
  • DERROTA
  • Maardu II 0
  • Sillamäe Kalev 4
  • DERROTA
  • FC Tallinn 4
  • Maardu II 0
  • VICTORIA
  • Maardu II 15
  • Jõgeva Wolves 0
10 Ajax Lasnamäe Ajax Lasnamäe 20 19 5 5 9 37 49
  • EMPATE
  • Ajax Lasnamäe 2
  • Tartu Welco II 2
  • DERROTA
  • Sillamäe Kalev 6
  • Ajax Lasnamäe 0
  • DERROTA
  • FC Tallinn 5
  • Ajax Lasnamäe 1
  • VICTORIA
  • Jõgeva Wolves 1
  • Ajax Lasnamäe 8
  • EMPATE
  • Ajax Lasnamäe 1
  • Trans II 1
11 FC Helios Voru FC Helios Voru 18 19 5 3 11 38 49
  • DERROTA
  • Tammeka III 1
  • FC Helios Voru 0
  • VICTORIA
  • FC Helios Voru 9
  • TJK Legion II 5
  • DERROTA
  • FC Helios Voru 0
  • FCI Tallinn 6
  • VICTORIA
  • JK Järve II 1
  • FC Helios Voru 3
  • VICTORIA
  • FC Helios Voru 6
  • Jogeva SK Noorus 9. 0
12 Tammeka III Tammeka III 17 19 5 2 12 33 47
  • VICTORIA
  • Tammeka III 1
  • FC Helios Voru 0
  • DERROTA
  • JK Järve II 4
  • Tammeka III 1
  • DERROTA
  • Tammeka III 2
  • Jogeva SK Noorus 9. 4
  • DERROTA
  • Tartu Welco II 2
  • Tammeka III 1
  • DERROTA
  • Tammeka III 1
  • Sillamäe Kalev 4
13 JK Järve II JK Järve II 17 19 5 2 12 29 47
  • DERROTA
  • Põhja-Tallinna JK. 1
  • JK Järve II 0
  • VICTORIA
  • JK Järve II 4
  • Tammeka III 1
  • DERROTA
  • TJK Legion II 2
  • JK Järve II 0
  • DERROTA
  • JK Järve II 1
  • FC Helios Voru 3
  • DERROTA
  • JK Järve II 1
  • FCI Tallinn 2
14 Jõgeva Wolves Jõgeva Wolves 11 19 3 2 14 19 99
  • DERROTA
  • Jõgeva Wolves 2
  • FC Tallinn 8
  • DERROTA
  • FCI Tallinn 18
  • Jõgeva Wolves 0
  • DERROTA
  • Trans II 7
  • Jõgeva Wolves 0
  • DERROTA
  • Jõgeva Wolves 1
  • Ajax Lasnamäe 8
  • DERROTA
  • Maardu II 15
  • Jõgeva Wolves 0


  USO DE MEMORIA  
5,461,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.2807
Total Execution Time  0.2826
  CADENA URL  
/tercera_estonia2020/grupo1/jornada19
  GET DATOS  
$_GET['/tercera_estonia2020/grupo1/jornada19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1606 AND type_rel = 3
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 03:34:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 03:34:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 03:34:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 03:34:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  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=55928 AND rel.round=19
0.0131  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 `calendars2020` 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` = 55928 AND c.`round` = 19 ORDER BY shedule ASC LIMIT 200
0.0150  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 events2020 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2020 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 55928 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 (472671,472672,472675,472676,472677,472736,472673) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0135  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 `events2020` e INNER JOIN calendars2020 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 = 19 AND e.real_date IS NOT NULL AND e.league_id = 55928 ORDER BY total DESC LIMIT 40
0.0128  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 `tables2020` 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 = 55928 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 55928 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT distinct(shedule), round FROM `calendars2020` as c WHERE c.`league_id` = 55928 AND shedule >= '2020/09/01' AND shedule < '2020/10/01' ORDER BY shedule ASC
0.0125  SELECT data1, data2 FROM services_tags WHERE categoryId=1606
0.0127  SELECT group_code, extraName from `leagues` WHERE categoryId=1606 AND year=2020