4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Imagen de UD Logroñés

David Fernández

Jugador del UD Logroñés
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de David Fernández
Nacionalidad
España
Nombre
David Fernández Cortázar
Edad
39 Años (06-04-1985)
Altura
186
Dorsal
19
Peso
81 kilogramos
Equipo
UD Logroñés
Posición
Defensa
Liga
Primera Federación 2023 G 2
Compañeros de equipo
Fotos
13
  • Foto principal de David Fernández | Alcorcón
  • Foto principal de David Fernández | Alcorcón
  • Foto principal de David Fernández | Alcorcón
  • Foto principal de David Fernández | Alcorcón
  • Foto principal de David Fernández | Real Oviedo
  • Foto principal de David Fernández | Real Oviedo
  • Foto principal de David Fernández | Real Oviedo
  • David Fernández
  • David Fernández
  • David Fernández
  • David Fernández
  • David Fernández
  • DAVID FERNANDEZ
6 Comentarios
  • Colton
    Hace 8 años Colton dice: ¡Daaaavid Feeernáaaandeeeeeeez! ¡Lolololooolooooo!
  • somiedo
    Hace 10 años somiedo dice: Muy irregular e inseguro. Puede cambiar
  • joseherranzl
    Hace 11 años joseherranzl dice: jugador polivalente jugo en todos los puestos de la defensa y medio centro regular y buenos años en guada
  • philip28
    Hace 12 años philip28 dice: Gran central y polivalente,tambien puede hacerlo de lateral,gran concepto del juego y de la colocacíon siempre esta en su sitio para ir al corte,poderoso en el salto va muy bien por alto,tiene calidad para salir con el balon jugado,siempre elige la opcion mas correcta del juego a la hora de recuperar el balon.En definitiva un gran jugador con calidad para jugar con solvencia en primera y segunda dGran central y polivalente,tambien puede hacerlo de lateral,gran concepto del juego y de la colocacíon siempre esta en su sitio para ir al corte,poderoso en el salto va muy bien por alto,tiene calidad para salir con el balon jugado,siempre elige la opcion mas correcta del juego a la hora de recuperar el balon.En definitiva un gran jugador con calidad para jugar con solvencia en primera y segunda d
  • chupcerrista
    Hace 14 años chupcerrista dice: rnada 1: SENIOR Villanovense 0 - Guadalajara 2 No 11 0 0 0 Jornada 2: SENIOR Guadalajara 2 - Real Oviedo 0 No 14 0 0 0 Jornada 4: SENIOR Guadalajara 3 - Univ. Las Palmas 1 Si 90 0 0 0 Jornada 5: SENIOR Toledo 1 - Guadalajara 2 Si 90 0 0 0 Jornada 6: SENIOR Guadalajara 0 - Vecindario 1 Si 90 0 0 0 Jornada 7: SENIOR Guadalajarrnada 1: SENIOR Villanovense 0 - Guadalajara 2 No 11 0 0 0 Jornada 2: SENIOR Guadalajara 2 - Real Oviedo 0 No 14 0 0 0 Jornada 4: SENIOR Guadalajara 3 - Univ. Las Palmas 1 Si 90 0 0 0 Jornada 5: SENIOR Toledo 1 - Guadalajara 2 Si 90 0 0 0 Jornada 6: SENIOR Guadalajara 0 - Vecindario 1 Si 90 0 0 0 Jornada 7: SENIOR Guadalajar
  • chupcerrista
    Hace 14 años chupcerrista dice: # AÑOS EN EL CLUB: 1 # EQUIPO DE PROCEDENCIA: Linares # TRAYECTORIA COMO SENIOR: Rayo Vallecano juvenil; Rayo Vallecano B (3º); Atlético Madrid B (2ºB); CD Linares (2ºB); Guadalajara (2ºB)# AÑOS EN EL CLUB: 1 # EQUIPO DE PROCEDENCIA: Linares # TRAYECTORIA COMO SENIOR: Rayo Vallecano juvenil; Rayo Vallecano B (3º); Atlético Madrid B (2ºB); CD Linares (2ºB); Guadalajara (2ºB)

  USO DE MEMORIA  
10,518,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Player / Index )  0.7728
Total Execution Time  0.7740
  CADENA URL  
/jugador/david-fernandez-34171
  GET DATOS  
$_GET['/jugador/david-fernandez-34171']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (217)  
0.0009   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` = '34171' AND c.comment_id IN (6046388,2265873,1887406,1087022,78198,78197) GROUP BY c.comment_id
0.0025  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 = 'david-fernandez-34171' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0162  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 = 'david-fernandez-34171' 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 = 67960
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 = 62832
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 = 56547
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 = 50064
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 = 73044
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 = 39175
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 = 16245
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 = 14186
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 = 2735
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 = 1335
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 = 1101
0.0022  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.0022  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 = 1307
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 = 999
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 = 130
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 = 2
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 = 4
0.0022  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 = 82
0.0021  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 = '34171'
0.0064  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 = 67960 AND rp.teamId = 1578 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0038  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 = 34171 ORDER BY rp.year DESC
0.0049  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 = '34171' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '34171' and rp.type = 3
0.0026  SELECT e.* FROM `events2023` e WHERE e.player_id = 34171 AND league_id = 67960 ORDER BY e.date ASC
0.0185  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67960 AND rel.player_id=34171
0.0033  SELECT action,minute FROM events2023 WHERE player_id = 34171 AND league_id = 67960 AND action = 18
0.0030  SELECT action,minute FROM events2023 WHERE player_id = 34171 AND league_id = 67960 AND action = 19
0.0019  SELECT e.* FROM `events2023` e WHERE e.player_id = 34171 AND league_id = 69563 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 = 69563 AND rel.player_id=34171
0.0019  SELECT action,minute FROM events2023 WHERE player_id = 34171 AND league_id = 69563 AND action = 18
0.0018  SELECT action,minute FROM events2023 WHERE player_id = 34171 AND league_id = 69563 AND action = 19
0.0020  SELECT e.* FROM `events2022` e WHERE e.player_id = 34171 AND league_id = 62832 ORDER BY e.date ASC
0.0057  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62832 AND rel.player_id=34171
0.0029  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 62832 AND action = 18
0.0029  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 62832 AND action = 19
0.0019  SELECT e.* FROM `events2022` e WHERE e.player_id = 34171 AND league_id = 62807 ORDER BY e.date ASC
0.0045  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62807 AND rel.player_id=34171
0.0019  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 62807 AND action = 18
0.0019  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 62807 AND action = 19
0.0019  SELECT e.* FROM `events2022` e WHERE e.player_id = 34171 AND league_id = 65506 ORDER BY e.date ASC
0.0043  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 65506 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 65506 AND action = 18
0.0018  SELECT action,minute FROM events2022 WHERE player_id = 34171 AND league_id = 65506 AND action = 19
0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 34171 AND league_id = 57314 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 = 57314 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 57314 AND action = 18
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 57314 AND action = 19
0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 34171 AND league_id = 56547 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 = 56547 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 56547 AND action = 18
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 56547 AND action = 19
0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 34171 AND league_id = 59872 ORDER BY e.date ASC
0.0057  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 59872 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 59872 AND action = 18
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 34171 AND league_id = 59872 AND action = 19
0.0018  SELECT e.* FROM `events2020` e WHERE e.player_id = 34171 AND league_id = 50064 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 = 50064 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 50064 AND action = 18
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 50064 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 34171 AND league_id = 49506 ORDER BY e.date ASC
0.0034  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49506 AND rel.player_id=34171
0.0019  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 49506 AND action = 18
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 49506 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 34171 AND league_id = 51355 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 = 51355 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 51355 AND action = 18
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 34171 AND league_id = 51355 AND action = 19
0.0019  SELECT e.* FROM `events2019` e WHERE e.player_id = 34171 AND league_id = 43686 ORDER BY e.date ASC
0.0048  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43686 AND rel.player_id=34171
0.0023  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 43686 AND action = 18
0.0023  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 43686 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 34171 AND league_id = 43475 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 = 43475 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 43475 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 43475 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 34171 AND league_id = 44594 ORDER BY e.date ASC
0.0046  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44594 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 44594 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 44594 AND action = 19
0.0019  SELECT e.* FROM `events2019` e WHERE e.player_id = 34171 AND league_id = 73044 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 = 73044 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 73044 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 34171 AND league_id = 73044 AND action = 19
0.0019  SELECT e.* FROM `events2018` e WHERE e.player_id = 34171 AND league_id = 38790 ORDER BY e.date ASC
0.0049  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38790 AND rel.player_id=34171
0.0023  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 38790 AND action = 18
0.0023  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 38790 AND action = 19
0.0019  SELECT e.* FROM `events2018` e WHERE e.player_id = 34171 AND league_id = 38427 ORDER BY e.date ASC
0.0051  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38427 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 38427 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 38427 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 34171 AND league_id = 39175 ORDER BY e.date ASC
0.0042  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39175 AND rel.player_id=34171
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 39175 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 34171 AND league_id = 39175 AND action = 19
0.0026  SELECT e.* FROM `events2017` e WHERE e.player_id = 34171 AND league_id = 33377 ORDER BY e.date ASC
0.0174  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33377 AND rel.player_id=34171
0.0049  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 33377 AND action = 18
0.0048  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 33377 AND action = 19
0.0023  SELECT e.* FROM `events2017` e WHERE e.player_id = 34171 AND league_id = 30386 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 = 30386 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 30386 AND action = 18
0.0021  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 30386 AND action = 19
0.0021  SELECT e.* FROM `events2017` e WHERE e.player_id = 34171 AND league_id = 33904 ORDER BY e.date ASC
0.0077  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33904 AND rel.player_id=34171
0.0020  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 33904 AND action = 18
0.0020  SELECT action,minute FROM events2017 WHERE player_id = 34171 AND league_id = 33904 AND action = 19
0.0024  SELECT e.* FROM `events2016` e WHERE e.player_id = 34171 AND league_id = 15374 ORDER BY e.date ASC
0.0089  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15374 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 15374 AND action = 18
0.0020  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 15374 AND action = 19
0.0021  SELECT e.* FROM `events2016` e WHERE e.player_id = 34171 AND league_id = 16245 ORDER BY e.date ASC
0.0034  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16245 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 16245 AND action = 18
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 16245 AND action = 19
0.0021  SELECT e.* FROM `events2016` e WHERE e.player_id = 34171 AND league_id = 16597 ORDER BY e.date ASC
0.0072  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16597 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 16597 AND action = 18
0.0023  SELECT action,minute FROM events2016 WHERE player_id = 34171 AND league_id = 16597 AND action = 19
0.0023  SELECT e.* FROM `events2015` e WHERE e.player_id = 34171 AND league_id = 3865 ORDER BY e.date ASC
0.0098  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3865 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3865 AND action = 18
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3865 AND action = 19
0.0021  SELECT e.* FROM `events2015` e WHERE e.player_id = 34171 AND league_id = 3992 ORDER BY e.date ASC
0.0071  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=34171
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3992 AND action = 18
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3992 AND action = 19
0.0022  SELECT e.* FROM `events2015` e WHERE e.player_id = 34171 AND league_id = 14186 ORDER BY e.date ASC
0.0071  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 14186 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 14186 AND action = 18
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 14186 AND action = 19
0.0022  SELECT e.* FROM `events2015` e WHERE e.player_id = 34171 AND league_id = 3804 ORDER BY e.date ASC
0.0123  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3804 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3804 AND action = 18
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 34171 AND league_id = 3804 AND action = 19
0.0023  SELECT e.* FROM `events2014` e WHERE e.player_id = 34171 AND league_id = 2466 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 = 2466 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2466 AND action = 18
0.0023  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2466 AND action = 19
0.0021  SELECT e.* FROM `events2014` e WHERE e.player_id = 34171 AND league_id = 2399 ORDER BY e.date ASC
0.0076  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2399 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2399 AND action = 18
0.0022  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2399 AND action = 19
0.0021  SELECT e.* FROM `events2014` e WHERE e.player_id = 34171 AND league_id = 2735 ORDER BY e.date ASC
0.0071  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=34171
0.0022  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2735 AND action = 18
0.0025  SELECT action,minute FROM events2014 WHERE player_id = 34171 AND league_id = 2735 AND action = 19
0.0023  SELECT e.* FROM `events2013` e WHERE e.player_id = 34171 AND league_id = 1902 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 = 1902 AND rel.player_id=34171
0.0026  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 1902 AND action = 18
0.0021  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 1902 AND action = 19
0.0023  SELECT e.* FROM `events2013` e WHERE e.player_id = 34171 AND league_id = 1969 ORDER BY e.date ASC
0.0102  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=34171
0.0021  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 1969 AND action = 18
0.0020  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 1969 AND action = 19
0.0021  SELECT e.* FROM `events2013` e WHERE e.player_id = 34171 AND league_id = 2339 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 = 2339 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 2339 AND action = 18
0.0022  SELECT action,minute FROM events2013 WHERE player_id = 34171 AND league_id = 2339 AND action = 19
0.0024  SELECT e.* FROM `events2012` e WHERE e.player_id = 34171 AND league_id = 1335 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 = 1335 AND rel.player_id=34171
0.0022  SELECT action,minute FROM events2012 WHERE player_id = 34171 AND league_id = 1335 AND action = 18
0.0022  SELECT action,minute FROM events2012 WHERE player_id = 34171 AND league_id = 1335 AND action = 19
0.0022  SELECT e.* FROM `events2012` e WHERE e.player_id = 34171 AND league_id = 1437 ORDER BY e.date ASC
0.0127  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=34171
0.0024  SELECT action,minute FROM events2012 WHERE player_id = 34171 AND league_id = 1437 AND action = 18
0.0023  SELECT action,minute FROM events2012 WHERE player_id = 34171 AND league_id = 1437 AND action = 19
0.0023  SELECT e.* FROM `events2011` e WHERE e.player_id = 34171 AND league_id = 1101 ORDER BY e.date ASC
0.0115  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1101 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1101 AND action = 18
0.0022  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1101 AND action = 19
0.0024  SELECT e.* FROM `events2011` e WHERE e.player_id = 34171 AND league_id = 1115 ORDER BY e.date ASC
0.0087  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=34171
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1115 AND action = 18
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1115 AND action = 19
0.0021  SELECT e.* FROM `events2011` e WHERE e.player_id = 34171 AND league_id = 1307 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 = 1307 AND rel.player_id=34171
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1307 AND action = 18
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 34171 AND league_id = 1307 AND action = 19
0.0023  SELECT e.* FROM `events2010` e WHERE e.player_id = 34171 AND league_id = 827 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 = 827 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2010 WHERE player_id = 34171 AND league_id = 827 AND action = 18
0.0022  SELECT action,minute FROM events2010 WHERE player_id = 34171 AND league_id = 827 AND action = 19
0.0021  SELECT e.* FROM `events2010` e WHERE e.player_id = 34171 AND league_id = 999 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 = 999 AND rel.player_id=34171
0.0021  SELECT action,minute FROM events2010 WHERE player_id = 34171 AND league_id = 999 AND action = 18
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 34171 AND league_id = 999 AND action = 19
0.0022  SELECT e.* FROM `events2009` e WHERE e.player_id = 34171 AND league_id = 130 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 = 130 AND rel.player_id=34171
0.0020  SELECT action,minute FROM events2009 WHERE player_id = 34171 AND league_id = 130 AND action = 18
0.0022  SELECT action,minute FROM events2009 WHERE player_id = 34171 AND league_id = 130 AND action = 19
0.0021  SELECT e.* FROM `events2009` e WHERE e.player_id = 34171 AND league_id = 805 ORDER BY e.date ASC
0.0187  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=34171
0.0025  SELECT action,minute FROM events2009 WHERE player_id = 34171 AND league_id = 805 AND action = 18
0.0022  SELECT action,minute FROM events2009 WHERE player_id = 34171 AND league_id = 805 AND action = 19
0.0026  SELECT e.* FROM `events2008` e WHERE e.player_id = 34171 AND league_id = 2 ORDER BY e.date ASC
0.0243  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=34171
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 34171 AND league_id = 2 AND action = 18
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 34171 AND league_id = 2 AND action = 19
0.0021  SELECT e.* FROM `events2008` e WHERE e.player_id = 34171 AND league_id = 4 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 = 4 AND rel.player_id=34171
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 34171 AND league_id = 4 AND action = 18
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 34171 AND league_id = 4 AND action = 19
0.0019  SELECT e.* FROM `events2007` e WHERE e.player_id = 34171 AND league_id = 82 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 = 82 AND rel.player_id=34171
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 34171 AND league_id = 82 AND action = 18
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 34171 AND league_id = 82 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` = '34171' 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 = '6046388' 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 = '2265873' 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 = '1887406' 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 = '1087022' 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 = '78198' 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 = '78197' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20