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

A. Del Horno

Jugador del Levante
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de A. Del Horno
Nacionalidad
España
Nombre
Asier Del Horno Cosgaya
Edad
43 Años (19-01-1981)
Altura
183
Dorsal
15
Peso
72 kilogramos
Equipo
Levante
Posición
Defensa
Liga
Primera División 2012
Compañeros de equipo
Fotos
7
  • Foto principal de A. Del Horno | Levante
  • Del Horno
  • Del Horno
  • Del Horno
  • Asier Del Horno
  • Del Horno
  • Del Horno
4 Comentarios
  • ivanfrigialme
    Hace 12 años ivanfrigialme dice: Grande Del Horno , para mí es el mejor defensa del Levante
  • colchonero
    Hace 14 años colchonero dice: este hombre cada vez mas abajo de akia na juega en el equipo de mi barrioeste hombre cada vez mas abajo de akia na juega en el equipo de mi barrio
  • colchonero
    Hace 14 años colchonero dice: este hombre cada vez mas abajo de akia na juega en el equipo de mi barrioeste hombre cada vez mas abajo de akia na juega en el equipo de mi barrio
  • JdMcrew
    Hace 14 años JdMcrew dice: 30/01/2010. Del Horno se va cedido al Valladolid hasta el proximo 30 de Junio.30/01/2010. Del Horno se va cedido al Valladolid hasta el proximo 30 de Junio.

  USO DE MEMORIA  
11,182,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Player / Index )  0.8836
Total Execution Time  0.8853
  CADENA URL  
/jugador/asier-del-horno-cosgaya
  GET DATOS  
$_GET['/jugador/asier-del-horno-cosgaya']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (239)  
0.0021   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` = '7218' AND c.comment_id IN (1372301,144036,144018,144012) GROUP BY c.comment_id
0.0051  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 = 'asier-del-horno-cosgaya' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0173  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 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 = 'asier-del-horno-cosgaya' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0023  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 = 1334
0.0023  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 = 1437
0.0024  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 = 1099
0.0055  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 = 957
0.0032  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 = 774
0.0025  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 = 44808
0.0025  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 = 72817
0.0025  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 = 9600
0.0025  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 = 47
0.0028  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 = 9608
0.0026  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 = 9616
0.0024  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 = 12815
0.0024  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 = 39354
0.0023  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 = 40
0.0024  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 = 10986
0.0026  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 = 36324
0.0043  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 = 39586
0.0028  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 = 37
0.0023  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 = 39587
0.0032  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 = 56960
0.0025  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 = 62755
0.0025  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 = 159
0.0024  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 = 5505
0.0028  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 = 56947
0.0025  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 = 58510
0.0030  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 = 57828
0.0026  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 = 57928
0.0054  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 = 57939
0.0034  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 = 57951
0.0024  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 = 57965
0.0019  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 = '7218'
0.0031  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 = 1334 AND rp.teamId = 1547 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0022  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 = 7218 ORDER BY rp.year DESC
0.0023  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 = '7218' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7218' and rp.type = 3
0.0020  SELECT e.* FROM `events2012` e WHERE e.player_id = 7218 AND league_id = 1334 ORDER BY e.date ASC
0.0100  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1334 AND rel.player_id=7218
0.0023  SELECT action,minute FROM events2012 WHERE player_id = 7218 AND league_id = 1334 AND action = 18
0.0047  SELECT action,minute FROM events2012 WHERE player_id = 7218 AND league_id = 1334 AND action = 19
0.0021  SELECT e.* FROM `events2012` e WHERE e.player_id = 7218 AND league_id = 1437 ORDER BY e.date ASC
0.0067  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1437 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 7218 AND league_id = 1437 AND action = 18
0.0020  SELECT action,minute FROM events2012 WHERE player_id = 7218 AND league_id = 1437 AND action = 19
0.0032  SELECT e.* FROM `events2011` e WHERE e.player_id = 7218 AND league_id = 1099 ORDER BY e.date ASC
0.0080  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1099 AND rel.player_id=7218
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 7218 AND league_id = 1099 AND action = 18
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 7218 AND league_id = 1099 AND action = 19
0.0022  SELECT e.* FROM `events2011` e WHERE e.player_id = 7218 AND league_id = 1115 ORDER BY e.date ASC
0.0039  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1115 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 7218 AND league_id = 1115 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 7218 AND league_id = 1115 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 7218 AND league_id = 811 ORDER BY e.date ASC
0.0036  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 811 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 7218 AND league_id = 811 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 7218 AND league_id = 811 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 7218 AND league_id = 957 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 957 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 7218 AND league_id = 957 AND action = 18
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 7218 AND league_id = 957 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 7218 AND league_id = 967 ORDER BY e.date ASC
0.0038  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 967 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 7218 AND league_id = 967 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 7218 AND league_id = 967 AND action = 19
0.0020  SELECT e.* FROM `events2009` e WHERE e.player_id = 7218 AND league_id = 104 ORDER BY e.date ASC
0.0036  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 104 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 104 AND action = 18
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 104 AND action = 19
0.0023  SELECT e.* FROM `events2009` e WHERE e.player_id = 7218 AND league_id = 774 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 774 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 774 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 774 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 7218 AND league_id = 778 ORDER BY e.date ASC
0.0055  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 778 AND rel.player_id=7218
0.0022  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 778 AND action = 18
0.0020  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 778 AND action = 19
0.0018  SELECT e.* FROM `events2009` e WHERE e.player_id = 7218 AND league_id = 805 ORDER BY e.date ASC
0.0052  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 805 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 805 AND action = 18
0.0017  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 805 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 7218 AND league_id = 44808 ORDER BY e.date ASC
0.0065  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44808 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 44808 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 44808 AND action = 19
0.0021  SELECT e.* FROM `events2009` e WHERE e.player_id = 7218 AND league_id = 72817 ORDER BY e.date ASC
0.0020  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72817 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 72817 AND action = 18
0.0020  SELECT action,minute FROM events2009 WHERE player_id = 7218 AND league_id = 72817 AND action = 19
0.0021  SELECT e.* FROM `events2008` e WHERE e.player_id = 7218 AND league_id = 2 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 = 2 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events2008 WHERE player_id = 7218 AND league_id = 2 AND action = 18
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 7218 AND league_id = 2 AND action = 19
0.0022  SELECT e.* FROM `events2008` e WHERE e.player_id = 7218 AND league_id = 20575 ORDER BY e.date ASC
0.0119  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20575 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events2008 WHERE player_id = 7218 AND league_id = 20575 AND action = 18
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 7218 AND league_id = 20575 AND action = 19
0.0019  SELECT e.* FROM `events2007` e WHERE e.player_id = 7218 AND league_id = 42 ORDER BY e.date ASC
0.0081  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events2007 WHERE player_id = 7218 AND league_id = 42 AND action = 18
0.0021  SELECT action,minute FROM events2007 WHERE player_id = 7218 AND league_id = 42 AND action = 19
0.0019  SELECT e.* FROM `events2007` e WHERE e.player_id = 7218 AND league_id = 9600 ORDER BY e.date ASC
0.0136  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9600 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 7218 AND league_id = 9600 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 7218 AND league_id = 9600 AND action = 19
0.0021  SELECT e.* FROM `events2006` e WHERE e.player_id = 7218 AND league_id = 47 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 = 47 AND rel.player_id=7218
0.0021  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 47 AND action = 18
0.0020  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 47 AND action = 19
0.0023  SELECT e.* FROM `events2006` e WHERE e.player_id = 7218 AND league_id = 9608 ORDER BY e.date ASC
0.0101  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9608 AND rel.player_id=7218
0.0027  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 9608 AND action = 18
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 9608 AND action = 19
0.0019  SELECT e.* FROM `events2006` e WHERE e.player_id = 7218 AND league_id = 9616 ORDER BY e.date ASC
0.0023  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9616 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 9616 AND action = 18
0.0022  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 9616 AND action = 19
0.0021  SELECT e.* FROM `events2006` e WHERE e.player_id = 7218 AND league_id = 12815 ORDER BY e.date ASC
0.0023  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 12815 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 12815 AND action = 18
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 12815 AND action = 19
0.0019  SELECT e.* FROM `events2006` e WHERE e.player_id = 7218 AND league_id = 12886 ORDER BY e.date ASC
0.0091  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 12886 AND rel.player_id=7218
0.0025  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 12886 AND action = 18
0.0020  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 12886 AND action = 19
0.0019  SELECT e.* FROM `events2006` e WHERE e.player_id = 7218 AND league_id = 39354 ORDER BY e.date ASC
0.0025  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39354 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 39354 AND action = 18
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 7218 AND league_id = 39354 AND action = 19
0.0021  SELECT e.* FROM `events2005` e WHERE e.player_id = 7218 AND league_id = 40 ORDER BY e.date ASC
0.0067  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 40 AND rel.player_id=7218
0.0021  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 40 AND action = 18
0.0021  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 40 AND action = 19
0.0019  SELECT e.* FROM `events2005` e WHERE e.player_id = 7218 AND league_id = 10979 ORDER BY e.date ASC
0.0069  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10979 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 10979 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 10979 AND action = 19
0.0018  SELECT e.* FROM `events2005` e WHERE e.player_id = 7218 AND league_id = 10986 ORDER BY e.date ASC
0.0024  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10986 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 10986 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 10986 AND action = 19
0.0019  SELECT e.* FROM `events2005` e WHERE e.player_id = 7218 AND league_id = 20578 ORDER BY e.date ASC
0.0070  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20578 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 20578 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 20578 AND action = 19
0.0018  SELECT e.* FROM `events2005` e WHERE e.player_id = 7218 AND league_id = 39421 ORDER BY e.date ASC
0.0083  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39421 AND rel.player_id=7218
0.0021  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 39421 AND action = 18
0.0019  SELECT action,minute FROM events2005 WHERE player_id = 7218 AND league_id = 39421 AND action = 19
0.0022  SELECT e.* FROM `events2004` e WHERE e.player_id = 7218 AND league_id = 39 ORDER BY e.date ASC
0.0065  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2004 WHERE player_id = 7218 AND league_id = 39 AND action = 18
0.0019  SELECT action,minute FROM events2004 WHERE player_id = 7218 AND league_id = 39 AND action = 19
0.0021  SELECT e.* FROM `events2004` e WHERE e.player_id = 7218 AND league_id = 36324 ORDER BY e.date ASC
0.0056  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 36324 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2004 WHERE player_id = 7218 AND league_id = 36324 AND action = 18
0.0020  SELECT action,minute FROM events2004 WHERE player_id = 7218 AND league_id = 36324 AND action = 19
0.0019  SELECT e.* FROM `events2004` e WHERE e.player_id = 7218 AND league_id = 39422 ORDER BY e.date ASC
0.0092  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39422 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events2004 WHERE player_id = 7218 AND league_id = 39422 AND action = 18
0.0020  SELECT action,minute FROM events2004 WHERE player_id = 7218 AND league_id = 39422 AND action = 19
0.0020  SELECT e.* FROM `events2003` e WHERE e.player_id = 7218 AND league_id = 38 ORDER BY e.date ASC
0.0079  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events2003 WHERE player_id = 7218 AND league_id = 38 AND action = 18
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 7218 AND league_id = 38 AND action = 19
0.0021  SELECT e.* FROM `events2003` e WHERE e.player_id = 7218 AND league_id = 21476 ORDER BY e.date ASC
0.0085  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 21476 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2003 WHERE player_id = 7218 AND league_id = 21476 AND action = 18
0.0019  SELECT action,minute FROM events2003 WHERE player_id = 7218 AND league_id = 21476 AND action = 19
0.0019  SELECT e.* FROM `events2003` e WHERE e.player_id = 7218 AND league_id = 39586 ORDER BY e.date ASC
0.0023  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39586 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 7218 AND league_id = 39586 AND action = 18
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 7218 AND league_id = 39586 AND action = 19
0.0020  SELECT e.* FROM `events2002` e WHERE e.player_id = 7218 AND league_id = 37 ORDER BY e.date ASC
0.0103  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 37 AND action = 18
0.0019  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 37 AND action = 19
0.0019  SELECT e.* FROM `events2002` e WHERE e.player_id = 7218 AND league_id = 21477 ORDER BY e.date ASC
0.0197  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 21477 AND rel.player_id=7218
0.0021  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 21477 AND action = 18
0.0023  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 21477 AND action = 19
0.0019  SELECT e.* FROM `events2002` e WHERE e.player_id = 7218 AND league_id = 39587 ORDER BY e.date ASC
0.0041  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39587 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 39587 AND action = 18
0.0023  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 39587 AND action = 19
0.0025  SELECT e.* FROM `events2002` e WHERE e.player_id = 7218 AND league_id = 56960 ORDER BY e.date ASC
0.0033  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 56960 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 56960 AND action = 18
0.0021  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 56960 AND action = 19
0.0022  SELECT e.* FROM `events2002` e WHERE e.player_id = 7218 AND league_id = 62755 ORDER BY e.date ASC
0.0026  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62755 AND rel.player_id=7218
0.0018  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 62755 AND action = 18
0.0031  SELECT action,minute FROM events2002 WHERE player_id = 7218 AND league_id = 62755 AND action = 19
0.0024  SELECT e.* FROM `events2001` e WHERE e.player_id = 7218 AND league_id = 159 ORDER BY e.date ASC
0.0152  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 159 AND rel.player_id=7218
0.0063  SELECT action,minute FROM events2001 WHERE player_id = 7218 AND league_id = 159 AND action = 18
0.0021  SELECT action,minute FROM events2001 WHERE player_id = 7218 AND league_id = 159 AND action = 19
0.0019  SELECT e.* FROM `events2001` e WHERE e.player_id = 7218 AND league_id = 21493 ORDER BY e.date ASC
0.0125  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 21493 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2001 WHERE player_id = 7218 AND league_id = 21493 AND action = 18
0.0023  SELECT action,minute FROM events2001 WHERE player_id = 7218 AND league_id = 21493 AND action = 19
0.0021  SELECT e.* FROM `events2000` e WHERE e.player_id = 7218 AND league_id = 5505 ORDER BY e.date ASC
0.0022  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 5505 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2000 WHERE player_id = 7218 AND league_id = 5505 AND action = 18
0.0019  SELECT action,minute FROM events2000 WHERE player_id = 7218 AND league_id = 5505 AND action = 19
0.0020  SELECT e.* FROM `events2000` e WHERE e.player_id = 7218 AND league_id = 56947 ORDER BY e.date ASC
0.0044  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 56947 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2000 WHERE player_id = 7218 AND league_id = 56947 AND action = 18
0.0032  SELECT action,minute FROM events2000 WHERE player_id = 7218 AND league_id = 56947 AND action = 19
0.0019  SELECT e.* FROM `events2000` e WHERE e.player_id = 7218 AND league_id = 58510 ORDER BY e.date ASC
0.0024  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58510 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events2000 WHERE player_id = 7218 AND league_id = 58510 AND action = 18
0.0018  SELECT action,minute FROM events2000 WHERE player_id = 7218 AND league_id = 58510 AND action = 19
0.0019  SELECT e.* FROM `events1999` e WHERE e.player_id = 7218 AND league_id = 57828 ORDER BY e.date ASC
0.0022  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 57828 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events1999 WHERE player_id = 7218 AND league_id = 57828 AND action = 18
0.0018  SELECT action,minute FROM events1999 WHERE player_id = 7218 AND league_id = 57828 AND action = 19
0.0019  SELECT e.* FROM `events1999` e WHERE e.player_id = 7218 AND league_id = 57928 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 57928 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events1999 WHERE player_id = 7218 AND league_id = 57928 AND action = 18
0.0018  SELECT action,minute FROM events1999 WHERE player_id = 7218 AND league_id = 57928 AND action = 19
0.0020  SELECT e.* FROM `events1999` e WHERE e.player_id = 7218 AND league_id = 57939 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 57939 AND rel.player_id=7218
0.0021  SELECT action,minute FROM events1999 WHERE player_id = 7218 AND league_id = 57939 AND action = 18
0.0018  SELECT action,minute FROM events1999 WHERE player_id = 7218 AND league_id = 57939 AND action = 19
0.0019  SELECT e.* FROM `events1998` e WHERE e.player_id = 7218 AND league_id = 57951 ORDER BY e.date ASC
0.0023  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 57951 AND rel.player_id=7218
0.0020  SELECT action,minute FROM events1998 WHERE player_id = 7218 AND league_id = 57951 AND action = 18
0.0022  SELECT action,minute FROM events1998 WHERE player_id = 7218 AND league_id = 57951 AND action = 19
0.0019  SELECT e.* FROM `events1998` e WHERE e.player_id = 7218 AND league_id = 57965 ORDER BY e.date ASC
0.0023  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 57965 AND rel.player_id=7218
0.0019  SELECT action,minute FROM events1998 WHERE player_id = 7218 AND league_id = 57965 AND action = 18
0.0042  SELECT action,minute FROM events1998 WHERE player_id = 7218 AND league_id = 57965 AND action = 19
0.0026   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` = '7218' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0022   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 = '1372301' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0020   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 = '144036' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0022   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 = '144018' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0019   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 = '144012' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20