4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Imagen de Sevilla

Erik Lamela

Jugador del Sevilla
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Erik Lamela
Nacionalidad
Argentina
Nombre
Erik Manuel Lamela Cordero
Edad
32 Años (04-03-1992)
Altura
184
Dorsal
17
Peso
74 kilogramos
Equipo
Sevilla
Posición
Delantero
Liga
Primera División
Compañeros de equipo
Fotos
16
  • Foto principal de E. Lamela | Sevilla
  • Foto principal de E. Lamela | Tottenham Hotspur
  • Foto principal de E. Lamela | Tottenham Hotspur
  • Foto principal de E. Lamela | Tottenham Hotspur
  • Foto principal de E. Lamela | Tottenham Hotspur
  • Foto principal de E. Lamela | Tottenham Hotspur
  • Foto principal de E. Lamela | Argentina
  • Foto principal de E. Lamela | Tottenham Hotspur
  • Foto principal de E. Lamela | Tottenham Hotspur
  • Foto principal de E. Lamela | Tottenham
  • E. Lamela
  • E. Lamela
  • Erik Lamela.
  • riverplate_afiche_12
  • E. Lamela
‹ Primero ... ... página 1 2 > ... Último ›
  • violi
    Hace 7 años violi dice: CUMPLE EL MISMO DIA QUE YO 4 DE MARZO
  • zergiofc
    Hace 11 años zergiofc dice: jugadoraso tiene un estilo de juego parecido al de iniesta sos un crakss
  • bosh
    Hace 11 años bosh dice: Maquina
  • nazarenolf
    Hace 12 años nazarenolf dice: lastima de que se fue de River! es un gran jugador, pero le esta llendo bien en la Romalastima de que se fue de River! es un gran jugador, pero le esta llendo bien en la Roma
  • bosh
    Hace 12 años bosh dice: me gustame gusta
  • Adriantheboss
    Hace 12 años Adriantheboss dice: Es un makinaaaaaaaaa !Es un makinaaaaaaaaa !
  • klauziel
    Hace 12 años klauziel dice: jugadorazo la va a romper en la ROMAjugadorazo la va a romper en la ROMA
  • Hace 12 años piscis dice: Luis Enrique tiene otra joya más!!Luis Enrique tiene otra joya más!!
  • JdMcrew
    Hace 12 años JdMcrew dice: El Barça estuvo apunto de ficharlo con 12 años... como a Messi... Gran jugador que ya no es sorpresa sus habilidades, aun es joven pero tardara poco en cruzar el charco, yo lo veo en Italia o España, ojala lo fichase el Atletico.El Barça estuvo apunto de ficharlo con 12 años... como a Messi... Gran jugador que ya no es sorpresa sus habilidades, aun es joven pero tardara poco en cruzar el charco, yo lo veo en Italia o España, ojala lo fichase el Atletico.
  • hipolitovieytes
    Hace 12 años hipolitovieytes dice: EL mejor de River EL mejor de River
  • Hace 12 años abonado dice: Me gusta su nombre ; d Me gusta su nombre ; d
  • rafasfc
    Hace 13 años rafasfc dice: piden demasiado por este jugador, es bueno va a ser bueno pero aun es un pezkeñin 18 añitos muy precipitado 20 millones por el piden demasiado por este jugador, es bueno va a ser bueno pero aun es un pezkeñin 18 añitos muy precipitado 20 millones por el
  • valecaporiver
    Hace 13 años valecaporiver dice: capo erik!!!!! capo erik!!!!!
  • Milo23
    Hace 13 años Milo23 dice: Que lo fiche el City xDD Que lo fiche el City xDD
  • lalo2
    Hace 13 años lalo2 dice: Un jugador que promete ser BUENO YA HAN DICHO QUE ES BUEN JUGADOR Y LOS ES.
    Es una promesa para irse al Atlético de Madrid.
    Ellos ponen una oferta de 18 millones pero River quiere 20 millones.
    Se ira al Atlético de Madrid?? Un jugador que promete ser BUENO YA HAN DICHO QUE ES BUEN JUGADOR Y LOS ES.
    Es una promesa para irse al Atlético de Madrid.
    Ellos ponen una oferta de 18 millones pero River quiere 20 millones.
    Se ira al Atlético de Madrid??
‹ Primero ... ... página 1 2 > ... Último ›
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,506,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Player / Index )  0.6292
Total Execution Time  0.6305
  CADENA URL  
/jugador/e-lamela-52052
  GET DATOS  
$_GET['/jugador/e-lamela-52052']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0019   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`playerId` = '52052' AND c.comment_id IN (12160871,1769582,1739063,1288634,1259756,1251831,1119950,1035994,969151,915774,881383,799907,791100,786799,785657) GROUP BY c.comment_id
0.0269  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'e-lamela-52052' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0108  SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '52052'
0.0201  SELECT p.id,p.nick,p.role,p.side,p.alias,rp.squadNumber FROM `rel_players` rp INNER JOIN `dataplayers` p ON p.id = rp.player_id WHERE rp.league_id = 72116 AND rp.teamId = 1102 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0165  SELECT t.nameShow,t.basealias,rp.year,c.name FROM `rel_players` rp INNER JOIN `datateams` t ON t.id = rp.teamId INNER JOIN categories c ON c.id = rp.category_id WHERE rp.player_id = 52052 ORDER BY rp.year DESC
0.0110  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '52052' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '52052' and rp.type = 3
0.0106  SELECT e.* FROM `events2024` e WHERE e.player_id = 52052 AND league_id = 72116 ORDER BY e.date ASC
0.0135  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72116 AND rel.player_id=52052
0.0110  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 72116 AND action = 18
0.0113  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 72116 AND action = 19
0.0106  SELECT e.* FROM `events2024` e WHERE e.player_id = 52052 AND league_id = 71759 ORDER BY e.date ASC
0.0124  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71759 AND rel.player_id=52052
0.0108  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 71759 AND action = 18
0.0108  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 71759 AND action = 19
0.0106  SELECT e.* FROM `events2024` e WHERE e.player_id = 52052 AND league_id = 72034 ORDER BY e.date ASC
0.0106  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72034 AND rel.player_id=52052
0.0105  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 72034 AND action = 18
0.0106  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 72034 AND action = 19
0.0106  SELECT e.* FROM `events2024` e WHERE e.player_id = 52052 AND league_id = 72589 ORDER BY e.date ASC
0.0107  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72589 AND rel.player_id=52052
0.0106  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 72589 AND action = 18
0.0107  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 72589 AND action = 19
0.0108  SELECT e.* FROM `events2024` e WHERE e.player_id = 52052 AND league_id = 73858 ORDER BY e.date ASC
0.0110  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 73858 AND rel.player_id=52052
0.0107  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 73858 AND action = 18
0.0107  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 73858 AND action = 19
0.0106  SELECT e.* FROM `events2024` e WHERE e.player_id = 52052 AND league_id = 71432 ORDER BY e.date ASC
0.0130  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71432 AND rel.player_id=52052
0.0108  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 71432 AND action = 18
0.0110  SELECT action,minute FROM events2024 WHERE player_id = 52052 AND league_id = 71432 AND action = 19
0.0114   SELECT c.comment,c.id,c.author_id,c.author_name,c.last_update,c.creation_date,c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, c.template, NOW() AS difference_time, fau.changeA AS changeA FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id=0 AND c.lang = '1' AND c.language = 'es' AND c.`playerId` = '52052' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0112   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '12160871' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0108   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1769582' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0107   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1739063' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0107   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1288634' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0109   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1259756' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0111   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1251831' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0112   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1119950' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0112   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1035994' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0109   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '969151' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0107   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '915774' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0107   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '881383' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0105   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '799907' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0106   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '791100' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0106   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '786799' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0106   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '785657' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20