4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Levadia

Levadia

Entrenador: Curro Torres

Información
  • Nombre del equipo Levadia
  • Nombre completo FCI Levadia Tallinn
  • Nombre corto LEV
  • País Iso code - ee Estonia
  • Ciudad Tallin
  • Entrenador Curro Torres
  • URL del equipo en RF //m.resultados-futbol.com/Levadia
Otros Datos
  • Año de Fundación 1999
Internet

Información sobre el estadio

  • Nombre del estadio Kadrioru Staadion
  • Capacidad 4880
  • Teléfono +372 637 9147
  • Fax +372 637 9147
Kadrioru Staadion

Partidos del Levadia

Ir al LIVESCORE
28 Sep 06  Finalizado Newcastle Newcastle
2 - 1
Levadia Levadia 0
14 Sep 06  Finalizado Levadia Levadia
0 - 1
Newcastle Newcastle 0
24 Ago 06  Finalizado Levadia Levadia
1 - 0
Twente Twente 0
10 Ago 06  Finalizado Twente Twente
1 - 1
Levadia Levadia 0
27 Jul 06  Finalizado FC Haka FC Haka
1 - 0
Levadia Levadia 0
13 Jul 06  Finalizado Levadia Levadia
2 - 0
FC Haka FC Haka 0
10 Nov 07  Finalizado Levadia Levadia
5 - 0
Vaprus Pärnu Vaprus Pärnu 0
03 Nov 07  Finalizado Tammeka Tammeka
0 - 3
Levadia Levadia 0
27 Oct 07  Finalizado Tulevik Viljandi Tulevik Viljandi
0 - 6
Levadia Levadia 0
20 Oct 07  Finalizado Levadia Levadia
8 - 0
Tallinna Kalev Tallinna Kalev 0
06 Oct 07  Finalizado Kuressaare Kuressaare
0 - 3
Levadia Levadia 0
02 Oct 07  Finalizado Levadia Levadia
1 - 2
Narva Trans Narva Trans 0
29 Sep 07  Finalizado FC TVMK FC TVMK
2 - 6
Levadia LevadiaTarjeta Roja 0
22 Sep 07  Finalizado Levadia Levadia
1 - 1
FC Flora FC Flora 0
18 Sep 07  Finalizado Ajax Lasnamäe Ajax Lasnamäe
1 - 2
Levadia Levadia 0
15 Sep 07  Finalizado Levadia Levadia
7 - 1
Ajax Lasnamäe Ajax Lasnamäe 0
01 Sep 07  Finalizado FC Flora FC Flora
3 - 2
Levadia LevadiaTarjeta Roja 0
25 Ago 07  Finalizado Levadia Tarjeta RojaLevadia
1 - 0
FC TVMK FC TVMKTarjeta Roja 0
18 Ago 07  Finalizado Narva Trans Tarjeta RojaNarva Trans
0 - 3
Levadia Levadia 0
14 Ago 07  Finalizado Tallinna Kalev Tallinna Kalev
0 - 4
Levadia Levadia 0
11 Ago 07  Finalizado Levadia Levadia
4 - 0
Kuressaare Kuressaare 0
28 Jul 07  Finalizado Levadia Levadia
5 - 0
Tulevik Viljandi Tulevik Viljandi 0
14 Jul 07  Finalizado Vaprus Pärnu Vaprus Pärnu
0 - 2
Levadia Levadia 0
07 Jul 07  Finalizado Ajax Lasnamäe Ajax Lasnamäe
0 - 10
Levadia Levadia 0
30 Jun 07  Finalizado Levadia Levadia
2 - 1
FC Flora FC Flora 0
19 Jun 07  Finalizado FC TVMK FC TVMK
1 - 1
Levadia LevadiaTarjeta Roja 0
16 Jun 07  Finalizado Levadia Levadia
2 - 0
Narva Trans Narva Trans 0
09 Jun 07  Finalizado Kuressaare Kuressaare
0 - 5
Levadia Levadia 0
26 May 07  Finalizado Levadia Levadia
4 - 2
Tallinna Kalev Tallinna Kalev 0
19 May 07  Finalizado Tulevik Viljandi Tulevik Viljandi
0 - 4
Levadia Levadia 0
12 May 07  Finalizado Tammeka Tammeka
1 - 3
Levadia Levadia 0
05 May 07  Finalizado Levadia Levadia
4 - 1
Vaprus Pärnu Vaprus Pärnu 0
28 Abr 07  Finalizado Vaprus Pärnu Vaprus Pärnu
0 - 5
Levadia Levadia 0
24 Abr 07  Finalizado Levadia Tarjeta RojaLevadia
2 - 2
Tammeka Tammeka 0
21 Abr 07  Finalizado Levadia Levadia
4 - 0
Tulevik Viljandi Tulevik Viljandi 0
14 Abr 07  Finalizado Tallinna Kalev Tallinna Kalev
1 - 0
Levadia Levadia 0
07 Abr 07  Finalizado Levadia Levadia
4 - 0
Kuressaare Kuressaare 0
03 Abr 07  Finalizado Narva Trans Tarjeta RojaNarva Trans
0 - 0
Levadia Levadia 0
31 Mar 07  Finalizado Levadia Tarjeta RojaLevadia
2 - 0
FC TVMK FC TVMKTarjeta Roja 0
17 Mar 07  Finalizado FC Flora FC Flora
1 - 2
Levadia LevadiaTarjeta Roja 0
10 Mar 07  Finalizado Levadia Levadia
5 - 0
Ajax Lasnamäe Ajax Lasnamäe 0
03 Mar 07  Finalizado Levadia Tarjeta RojaLevadia
4 - 0
Tammeka Tammeka 0
15 May 07  Finalizado Levadia Levadia
3 - 0
Narva Trans Narva Trans 0
01 May 07  Finalizado Levadia Levadia
1 - 0
FC TVMK FC TVMK 0
17 Abr 07  Finalizado Tammeka Tammeka
0 - 1
Levadia Levadia 0
08 Nov 06  Finalizado Kuressaare Kuressaare
2 - 2
Levadia Levadia 0

Estadísticas

GOLEADORES
AMARILLAS

Plantilla del Levadia Temporada 2006/2007

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 42 ee 186 80 - - -
Defensa
2 46 ee 182 80 - - -
21 51 ee - - - - -
7 41 ee 174 67 - - -
3 45 lt - - - - -
Centrocampista
9 42 ee 177 74 - - 1
8 49 ee 182 78 - - -
6 39 ee 175 69 - - -
20 44 lt 171 68 - - -
23 35 ee 177 65 - - -
Delantero
19 38 ee 180 80 - - -
11 49 ee - - 1 - -
18 35 ru 180 - - - 1
15 38 ee 183 74 - - -
36 41 ee 188 80 - - -

Noticias del Levadia

Ver últimas noticias

Marcaron a los 15 segundos ¡sin que nadie del equipo tocara el balón!

En Estonia se vio uno de los goles más curiosos de la historia. Kase se marcó en propia puerta apenas unos segundos después de sacar de centro. Inaudito.

Así les ha ido a los equipos irlandeses en la primera ronda de la Europa League

Este jueves ha concluido la primera ronda de la Europa League con la vuelta de la primera ronda. Han estado presentes tres equipos de la Airtricity League: Cork City, Derry City y Shamrock Rovers. Dos se han clasificado, mientras que uno ha caído eliminado.

Las 5 mejores rachas de la historia en las ligas europeas

Equipos de leyenda que impusieron su ley durante ligas enteras. Rescatamos la lista de 'AS' para hacer un repaso histórico a los clubes que han impuesto su hegemonía durante mayor número de partidos en las ligas europeas. Este es el resultado.

Alan Gatagov, nuevo fichaje del Levadia Tallin

El lateral izquierdo abandona el Taraz de Kazajistán para fichar por el Levadia Tallin, de Estonia.

Comienza una ronda preliminar de Champions de lo más igualada

Los tres enfrentamientos de la primera fase de clasificación de la Liga de Campeones disputados este martes quedaron abiertos y pendientes de los choques de vuelta, que se disputarán la próxima semana, para decidir el pase de los equipos a la segunda ronda.




  USO DE MEMORIA  
6,070,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4106
Total Execution Time  0.4124
  CADENA URL  
/Levadia/2007
  GET DATOS  
$_GET['/Levadia/2007']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0108  SELECT type FROM routes WHERE alias = 'levadia'
0.0244  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 10351
0.0113  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 23915
0.0112  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 26323
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6378 AND type_rel = 2
0.0106  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6378 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0110  SELECT /*35 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 (1105,56885,158839,255111,273078) ORDER BY n.cover_points DESC, update_date DESC
0.0115  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '6378' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 23915 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 10351 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 26323 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0141  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2007 as c ON c.league_id = l.id WHERE (c.datateam1 = 6378 or c.datateam2 = 6378) AND l.year = 2007 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0171  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2007 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 6378 or c.datateam2 = 6378) AND l.year = 2007 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0160  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2007 as c ON c.league_id = l.id INNER JOIN events2007 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 6378 or c.datateam2 = 6378) AND l.year = 2007)
0.0119  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 6378 AND rp.league_id = 11006 AND l.year= 2007 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0113  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=171447 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0106  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=171447
0.0114  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=171447 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0114  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=171447 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0116  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=171447 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0117   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=171447 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0125  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2007 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=171447 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC