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

Ander Lafuente

Jugador del Sodupe
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Ander Lafuente
Nacionalidad
España
Nombre
Ánder Lafuente Aguado
Edad
41 Años (18-02-1983)
Altura
165
Peso
63 kilogramos
Equipo
Sodupe
Posición
Delantero
Liga
Tercera División 2019 G 4
  • Jugador del Sodupe desde hace 5 años
    • Compañeros de equipo
    Fotos
    4
    • Foto principal de Lafuente | Racing Santander
    • Lafuente
    • Lafuente
    • Lafuente
    2 Comentarios
    • mikelamesti
      Hace 10 años mikelamesti dice: éste es un jugador de calidad!!! Gracias por todo pequeño buda, grande de corazón!! :))
    • granadacf
      Hace 14 años granadacf dice: eres un crak gran temporada en el granada el año pasaoeres un crak gran temporada en el granada el año pasao

      USO DE MEMORIA  
    9,057,544 bytes
      BENCHMARKS  
    Loading Time Base Classes  0.0012
    Controller Execution Time ( Player / Index )  0.3654
    Total Execution Time  0.3667
      CADENA URL  
    /jugador/ander-lafuente-29743
      GET DATOS  
    $_GET['/jugador/ander-lafuente-29743']  
      POST DATOS  
    No hay datos POST existentes
      CONSULTAS (144)  
    0.0005   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` = '29743' AND c.comment_id IN (2338469,189605) GROUP BY c.comment_id
    0.0027  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 = 'ander-lafuente-29743' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    0.0142  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 = 'ander-lafuente-29743' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    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 = 44392
    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 = 39028
    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 = 3863
    0.0027  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 = 2466
    0.0027  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 = 2735
    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 = 3672
    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 = 1901
    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 = 1969
    0.0029  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 = 1115
    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 = 812
    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 = 967
    0.0033  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 = 130
    0.0027  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 = 805
    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 = 7
    0.0029  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 = 20575
    0.0029  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 = 85
    0.0029  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 = 20576
    0.0031  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 = 171
    0.0029  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 = 45168
    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 = 173
    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 = 176
    0.0018  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 = '29743'
    0.0026  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 = 44392 AND rp.teamId = 2358 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
    0.0020  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 = 29743 ORDER BY rp.year DESC
    0.0021  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 = '29743' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
    0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '29743' and rp.type = 3
    0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 29743 AND league_id = 44392 ORDER BY e.date ASC
    0.0027  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44392 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 29743 AND league_id = 44392 AND action = 18
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 29743 AND league_id = 44392 AND action = 19
    0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 29743 AND league_id = 43475 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 = 43475 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 29743 AND league_id = 43475 AND action = 18
    0.0018  SELECT action,minute FROM events2019 WHERE player_id = 29743 AND league_id = 43475 AND action = 19
    0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 29743 AND league_id = 39028 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 = 39028 AND rel.player_id=29743
    0.0017  SELECT action,minute FROM events2018 WHERE player_id = 29743 AND league_id = 39028 AND action = 18
    0.0018  SELECT action,minute FROM events2018 WHERE player_id = 29743 AND league_id = 39028 AND action = 19
    0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 29743 AND league_id = 15376 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 = 15376 AND rel.player_id=29743
    0.0019  SELECT action,minute FROM events2016 WHERE player_id = 29743 AND league_id = 15376 AND action = 18
    0.0018  SELECT action,minute FROM events2016 WHERE player_id = 29743 AND league_id = 15376 AND action = 19
    0.0022  SELECT e.* FROM `events2015` e WHERE e.player_id = 29743 AND league_id = 3863 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 = 3863 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2015 WHERE player_id = 29743 AND league_id = 3863 AND action = 18
    0.0019  SELECT action,minute FROM events2015 WHERE player_id = 29743 AND league_id = 3863 AND action = 19
    0.0018  SELECT e.* FROM `events2015` e WHERE e.player_id = 29743 AND league_id = 3992 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 = 3992 AND rel.player_id=29743
    0.0019  SELECT action,minute FROM events2015 WHERE player_id = 29743 AND league_id = 3992 AND action = 18
    0.0019  SELECT action,minute FROM events2015 WHERE player_id = 29743 AND league_id = 3992 AND action = 19
    0.0020  SELECT e.* FROM `events2014` e WHERE e.player_id = 29743 AND league_id = 2466 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2466 AND rel.player_id=29743
    0.0019  SELECT action,minute FROM events2014 WHERE player_id = 29743 AND league_id = 2466 AND action = 18
    0.0020  SELECT action,minute FROM events2014 WHERE player_id = 29743 AND league_id = 2466 AND action = 19
    0.0019  SELECT e.* FROM `events2014` e WHERE e.player_id = 29743 AND league_id = 2735 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 = 2735 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2014 WHERE player_id = 29743 AND league_id = 2735 AND action = 18
    0.0019  SELECT action,minute FROM events2014 WHERE player_id = 29743 AND league_id = 2735 AND action = 19
    0.0021  SELECT e.* FROM `events2014` e WHERE e.player_id = 29743 AND league_id = 3672 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 = 3672 AND rel.player_id=29743
    0.0019  SELECT action,minute FROM events2014 WHERE player_id = 29743 AND league_id = 3672 AND action = 18
    0.0019  SELECT action,minute FROM events2014 WHERE player_id = 29743 AND league_id = 3672 AND action = 19
    0.0020  SELECT e.* FROM `events2013` e WHERE e.player_id = 29743 AND league_id = 1901 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 = 1901 AND rel.player_id=29743
    0.0020  SELECT action,minute FROM events2013 WHERE player_id = 29743 AND league_id = 1901 AND action = 18
    0.0019  SELECT action,minute FROM events2013 WHERE player_id = 29743 AND league_id = 1901 AND action = 19
    0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 29743 AND league_id = 1969 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 = 1969 AND rel.player_id=29743
    0.0019  SELECT action,minute FROM events2013 WHERE player_id = 29743 AND league_id = 1969 AND action = 18
    0.0018  SELECT action,minute FROM events2013 WHERE player_id = 29743 AND league_id = 1969 AND action = 19
    0.0020  SELECT e.* FROM `events2012` e WHERE e.player_id = 29743 AND league_id = 1335 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 = 1335 AND rel.player_id=29743
    0.0020  SELECT action,minute FROM events2012 WHERE player_id = 29743 AND league_id = 1335 AND action = 18
    0.0020  SELECT action,minute FROM events2012 WHERE player_id = 29743 AND league_id = 1335 AND action = 19
    0.0018  SELECT e.* FROM `events2012` e WHERE e.player_id = 29743 AND league_id = 1323 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 = 1323 AND rel.player_id=29743
    0.0019  SELECT action,minute FROM events2012 WHERE player_id = 29743 AND league_id = 1323 AND action = 18
    0.0018  SELECT action,minute FROM events2012 WHERE player_id = 29743 AND league_id = 1323 AND action = 19
    0.0018  SELECT e.* FROM `events2012` e WHERE e.player_id = 29743 AND league_id = 1437 ORDER BY e.date ASC
    0.0028  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=29743
    0.0019  SELECT action,minute FROM events2012 WHERE player_id = 29743 AND league_id = 1437 AND action = 18
    0.0019  SELECT action,minute FROM events2012 WHERE player_id = 29743 AND league_id = 1437 AND action = 19
    0.0021  SELECT e.* FROM `events2011` e WHERE e.player_id = 29743 AND league_id = 1100 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1100 AND rel.player_id=29743
    0.0020  SELECT action,minute FROM events2011 WHERE player_id = 29743 AND league_id = 1100 AND action = 18
    0.0020  SELECT action,minute FROM events2011 WHERE player_id = 29743 AND league_id = 1100 AND action = 19
    0.0018  SELECT e.* FROM `events2011` e WHERE e.player_id = 29743 AND league_id = 1115 ORDER BY e.date ASC
    0.0030  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=29743
    0.0022  SELECT action,minute FROM events2011 WHERE player_id = 29743 AND league_id = 1115 AND action = 18
    0.0021  SELECT action,minute FROM events2011 WHERE player_id = 29743 AND league_id = 1115 AND action = 19
    0.0021  SELECT e.* FROM `events2010` e WHERE e.player_id = 29743 AND league_id = 812 ORDER BY e.date ASC
    0.0029  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 812 AND rel.player_id=29743
    0.0020  SELECT action,minute FROM events2010 WHERE player_id = 29743 AND league_id = 812 AND action = 18
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29743 AND league_id = 812 AND action = 19
    0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 29743 AND league_id = 967 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 = 967 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29743 AND league_id = 967 AND action = 18
    0.0019  SELECT action,minute FROM events2010 WHERE player_id = 29743 AND league_id = 967 AND action = 19
    0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 29743 AND league_id = 130 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 130 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2009 WHERE player_id = 29743 AND league_id = 130 AND action = 18
    0.0018  SELECT action,minute FROM events2009 WHERE player_id = 29743 AND league_id = 130 AND action = 19
    0.0018  SELECT e.* FROM `events2009` e WHERE e.player_id = 29743 AND league_id = 805 ORDER BY e.date ASC
    0.0028  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=29743
    0.0018  SELECT action,minute FROM events2009 WHERE player_id = 29743 AND league_id = 805 AND action = 18
    0.0019  SELECT action,minute FROM events2009 WHERE player_id = 29743 AND league_id = 805 AND action = 19
    0.0020  SELECT e.* FROM `events2008` e WHERE e.player_id = 29743 AND league_id = 7 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 7 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2008 WHERE player_id = 29743 AND league_id = 7 AND action = 18
    0.0018  SELECT action,minute FROM events2008 WHERE player_id = 29743 AND league_id = 7 AND action = 19
    0.0019  SELECT e.* FROM `events2008` e WHERE e.player_id = 29743 AND league_id = 20575 ORDER BY e.date ASC
    0.0028  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=29743
    0.0018  SELECT action,minute FROM events2008 WHERE player_id = 29743 AND league_id = 20575 AND action = 18
    0.0018  SELECT action,minute FROM events2008 WHERE player_id = 29743 AND league_id = 20575 AND action = 19
    0.0022  SELECT e.* FROM `events2007` e WHERE e.player_id = 29743 AND league_id = 85 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 85 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2007 WHERE player_id = 29743 AND league_id = 85 AND action = 18
    0.0018  SELECT action,minute FROM events2007 WHERE player_id = 29743 AND league_id = 85 AND action = 19
    0.0018  SELECT e.* FROM `events2007` e WHERE e.player_id = 29743 AND league_id = 20576 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 = 20576 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2007 WHERE player_id = 29743 AND league_id = 20576 AND action = 18
    0.0018  SELECT action,minute FROM events2007 WHERE player_id = 29743 AND league_id = 20576 AND action = 19
    0.0021  SELECT e.* FROM `events2006` e WHERE e.player_id = 29743 AND league_id = 171 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 = 171 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2006 WHERE player_id = 29743 AND league_id = 171 AND action = 18
    0.0018  SELECT action,minute FROM events2006 WHERE player_id = 29743 AND league_id = 171 AND action = 19
    0.0018  SELECT e.* FROM `events2006` e WHERE e.player_id = 29743 AND league_id = 45168 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 45168 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2006 WHERE player_id = 29743 AND league_id = 45168 AND action = 18
    0.0018  SELECT action,minute FROM events2006 WHERE player_id = 29743 AND league_id = 45168 AND action = 19
    0.0020  SELECT e.* FROM `events2005` e WHERE e.player_id = 29743 AND league_id = 173 ORDER BY e.date ASC
    0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 173 AND rel.player_id=29743
    0.0019  SELECT action,minute FROM events2005 WHERE player_id = 29743 AND league_id = 173 AND action = 18
    0.0018  SELECT action,minute FROM events2005 WHERE player_id = 29743 AND league_id = 173 AND action = 19
    0.0020  SELECT e.* FROM `events2004` e WHERE e.player_id = 29743 AND league_id = 176 ORDER BY e.date ASC
    0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 176 AND rel.player_id=29743
    0.0018  SELECT action,minute FROM events2004 WHERE player_id = 29743 AND league_id = 176 AND action = 18
    0.0018  SELECT action,minute FROM events2004 WHERE player_id = 29743 AND league_id = 176 AND action = 19
    0.0021   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` = '29743' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
    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 = '2338469' 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 = '189605' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20