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

Urko Vera

Jugador del Santutxu
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Urko Vera
Nacionalidad
España
Nombre
Urko Vera Mateos
Edad
36 Años (14-05-1987)
Altura
190
Dorsal
7
Peso
85 kilogramos
Equipo
Santutxu
Posición
Delantero
Liga
Tercera Federación 2022 G 4
Twitter
@UrkoVera7
Compañeros de equipo
Fotos
10
  • Foto principal de Urko Vera | Mirandés
  • Foto principal de Urko Vera | Huesca
  • Urko Vera en juego
  • Foto principal de Urko Vera | Mirandés
  • Foto principal de Urko Vera | Eibar
  • Vera
  • Vera
  • Vera
  • Vera
  • Vera
5 Comentarios + 3 respuestas
  • laperladuero_zmr
    Hace 10 años laperladuero_zmr dice: buen jugador
  • jmerayo
    Actualizado hace 10 años (Creado hace 11 años ) jmerayo dice: delantero típico de lezma corpulento. con 12 goles esta temporada con la ponfe lo renovaria
  • joseherranzl
    Actualizado hace 10 años (Creado hace 11 años ) joseherranzl dice: delantero alto
  • Hace 12 años gnomo dice: yo no creo que este tio sea malo.yo no creo que este tio sea malo.
  • Endika87
    Actualizado hace 12 años (Creado hace 13 años ) Endika87 dice: no sólo es malo sino que aparte es un cerdo... no sólo es malo sino que aparte es un cerdo...

  USO DE MEMORIA  
12,260,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Player / Index )  3.8803
Total Execution Time  3.8815
  CADENA URL  
/jugador/urko-vera-80367/historico
  GET DATOS  
$_GET['/jugador/urko-vera-80367/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (238)  
0.0007   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` = '80367' AND c.comment_id IN (2253244,1736612,1891305,1236012,852875) GROUP BY c.comment_id
0.0159  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 = 'urko-vera-80367' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0937  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 = 'urko-vera-80367' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0152  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 = 62388
0.0150  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 = 58582
0.0150  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 = 59872
0.0150  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 = 61789
0.0150  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 = 50266
0.0151  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 = 49919
0.0152  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 = 50152
0.0153  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 = 50480
0.0171  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 = 43872
0.0173  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 = 44208
0.0172  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 = 43753
0.0176  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 = 44847
0.0171  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 = 38849
0.0173  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 = 42957
0.0156  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 = 39415
0.0154  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 = 15374
0.0150  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 = 30488
0.0150  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 = 9995
0.0150  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 = 3803
0.0153  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 = 9144
0.0149  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 = 2391
0.0150  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 = 1881
0.0150  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 = 1102
0.0150  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.0145  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 = '80367'
0.0150  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 = 62388 AND rp.teamId = 2273 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0150  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 = 80367 ORDER BY rp.year DESC
0.0150  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 = '80367' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '80367' and rp.type = 3
0.0151  SELECT e.* FROM `events2022` e WHERE e.player_id = 80367 AND league_id = 62388 ORDER BY e.date ASC
0.0189  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62388 AND rel.player_id=80367
0.0201  SELECT action,minute FROM events2022 WHERE player_id = 80367 AND league_id = 62388 AND action = 18
0.0203  SELECT action,minute FROM events2022 WHERE player_id = 80367 AND league_id = 62388 AND action = 19
0.0150  SELECT e.* FROM `events2021` e WHERE e.player_id = 80367 AND league_id = 58582 ORDER BY e.date ASC
0.0165  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58582 AND rel.player_id=80367
0.0157  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 58582 AND action = 18
0.0158  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 58582 AND action = 19
0.0153  SELECT e.* FROM `events2021` e WHERE e.player_id = 80367 AND league_id = 58609 ORDER BY e.date ASC
0.0186  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58609 AND rel.player_id=80367
0.0160  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 58609 AND action = 18
0.0161  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 58609 AND action = 19
0.0149  SELECT e.* FROM `events2021` e WHERE e.player_id = 80367 AND league_id = 56547 ORDER BY e.date ASC
0.0168  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=80367
0.0146  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 56547 AND action = 18
0.0146  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 56547 AND action = 19
0.0146  SELECT e.* FROM `events2021` e WHERE e.player_id = 80367 AND league_id = 59872 ORDER BY e.date ASC
0.0159  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=80367
0.0147  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 59872 AND action = 18
0.0146  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 59872 AND action = 19
0.0148  SELECT e.* FROM `events2021` e WHERE e.player_id = 80367 AND league_id = 61789 ORDER BY e.date ASC
0.0153  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61789 AND rel.player_id=80367
0.0150  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 61789 AND action = 18
0.0153  SELECT action,minute FROM events2021 WHERE player_id = 80367 AND league_id = 61789 AND action = 19
0.0145  SELECT e.* FROM `events2020` e WHERE e.player_id = 80367 AND league_id = 50266 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50266 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 80367 AND league_id = 50266 AND action = 18
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 80367 AND league_id = 50266 AND action = 19
0.0146  SELECT e.* FROM `events2020` e WHERE e.player_id = 80367 AND league_id = 49919 ORDER BY e.date ASC
0.0155  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49919 AND rel.player_id=80367
0.0147  SELECT action,minute FROM events2020 WHERE player_id = 80367 AND league_id = 49919 AND action = 18
0.0149  SELECT action,minute FROM events2020 WHERE player_id = 80367 AND league_id = 49919 AND action = 19
0.0146  SELECT e.* FROM `events2020` e WHERE e.player_id = 80367 AND league_id = 50152 ORDER BY e.date ASC
0.0168  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50152 AND rel.player_id=80367
0.0147  SELECT action,minute FROM events2020 WHERE player_id = 80367 AND league_id = 50152 AND action = 18
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 80367 AND league_id = 50152 AND action = 19
0.0145  SELECT e.* FROM `events2020` e WHERE e.player_id = 80367 AND league_id = 50480 ORDER BY e.date ASC
0.0156  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50480 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 80367 AND league_id = 50480 AND action = 18
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 80367 AND league_id = 50480 AND action = 19
0.0146  SELECT e.* FROM `events2019` e WHERE e.player_id = 80367 AND league_id = 43872 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43872 AND rel.player_id=80367
0.0191  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 43872 AND action = 18
0.0175  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 43872 AND action = 19
0.0151  SELECT e.* FROM `events2019` e WHERE e.player_id = 80367 AND league_id = 44208 ORDER BY e.date ASC
0.0195  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44208 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44208 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44208 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 80367 AND league_id = 44547 ORDER BY e.date ASC
0.0172  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44547 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44547 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44547 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 80367 AND league_id = 44604 ORDER BY e.date ASC
0.0148  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44604 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44604 AND action = 18
0.0144  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44604 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 80367 AND league_id = 43475 ORDER BY e.date ASC
0.0154  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=80367
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 43475 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 43475 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 80367 AND league_id = 43753 ORDER BY e.date ASC
0.0145  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43753 AND rel.player_id=80367
0.0148  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 43753 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 43753 AND action = 19
0.0146  SELECT e.* FROM `events2019` e WHERE e.player_id = 80367 AND league_id = 43952 ORDER BY e.date ASC
0.0165  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43952 AND rel.player_id=80367
0.0150  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 43952 AND action = 18
0.0150  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 43952 AND action = 19
0.0150  SELECT e.* FROM `events2019` e WHERE e.player_id = 80367 AND league_id = 44546 ORDER BY e.date ASC
0.0227  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44546 AND rel.player_id=80367
0.0146  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44546 AND action = 18
0.0146  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44546 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 80367 AND league_id = 44847 ORDER BY e.date ASC
0.0158  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44847 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44847 AND action = 18
0.0144  SELECT action,minute FROM events2019 WHERE player_id = 80367 AND league_id = 44847 AND action = 19
0.0146  SELECT e.* FROM `events2018` e WHERE e.player_id = 80367 AND league_id = 38849 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38849 AND rel.player_id=80367
0.0148  SELECT action,minute FROM events2018 WHERE player_id = 80367 AND league_id = 38849 AND action = 18
0.0147  SELECT action,minute FROM events2018 WHERE player_id = 80367 AND league_id = 38849 AND action = 19
0.0145  SELECT e.* FROM `events2018` e WHERE e.player_id = 80367 AND league_id = 42957 ORDER BY e.date ASC
0.0147  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42957 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 80367 AND league_id = 42957 AND action = 18
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 80367 AND league_id = 42957 AND action = 19
0.0145  SELECT e.* FROM `events2018` e WHERE e.player_id = 80367 AND league_id = 38427 ORDER BY e.date ASC
0.0154  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=80367
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 80367 AND league_id = 38427 AND action = 18
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 80367 AND league_id = 38427 AND action = 19
0.0145  SELECT e.* FROM `events2018` e WHERE e.player_id = 80367 AND league_id = 39415 ORDER BY e.date ASC
0.0150  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39415 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 80367 AND league_id = 39415 AND action = 18
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 80367 AND league_id = 39415 AND action = 19
0.0147  SELECT e.* FROM `events2017` e WHERE e.player_id = 80367 AND league_id = 33377 ORDER BY e.date ASC
0.0154  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=80367
0.0153  SELECT action,minute FROM events2017 WHERE player_id = 80367 AND league_id = 33377 AND action = 18
0.0156  SELECT action,minute FROM events2017 WHERE player_id = 80367 AND league_id = 33377 AND action = 19
0.0148  SELECT e.* FROM `events2017` e WHERE e.player_id = 80367 AND league_id = 30386 ORDER BY e.date ASC
0.0173  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=80367
0.0150  SELECT action,minute FROM events2017 WHERE player_id = 80367 AND league_id = 30386 AND action = 18
0.0153  SELECT action,minute FROM events2017 WHERE player_id = 80367 AND league_id = 30386 AND action = 19
0.0151  SELECT e.* FROM `events2017` e WHERE e.player_id = 80367 AND league_id = 33904 ORDER BY e.date ASC
0.0202  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=80367
0.0150  SELECT action,minute FROM events2017 WHERE player_id = 80367 AND league_id = 33904 AND action = 18
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 80367 AND league_id = 33904 AND action = 19
0.0147  SELECT e.* FROM `events2016` e WHERE e.player_id = 80367 AND league_id = 15374 ORDER BY e.date ASC
0.0203  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=80367
0.0152  SELECT action,minute FROM events2016 WHERE player_id = 80367 AND league_id = 15374 AND action = 18
0.0149  SELECT action,minute FROM events2016 WHERE player_id = 80367 AND league_id = 15374 AND action = 19
0.0149  SELECT e.* FROM `events2016` e WHERE e.player_id = 80367 AND league_id = 20271 ORDER BY e.date ASC
0.0172  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20271 AND rel.player_id=80367
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 80367 AND league_id = 20271 AND action = 18
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 80367 AND league_id = 20271 AND action = 19
0.0145  SELECT e.* FROM `events2016` e WHERE e.player_id = 80367 AND league_id = 30488 ORDER BY e.date ASC
0.0145  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30488 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 80367 AND league_id = 30488 AND action = 18
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 80367 AND league_id = 30488 AND action = 19
0.0146  SELECT e.* FROM `events2015` e WHERE e.player_id = 80367 AND league_id = 9995 ORDER BY e.date ASC
0.0158  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9995 AND rel.player_id=80367
0.0148  SELECT action,minute FROM events2015 WHERE player_id = 80367 AND league_id = 9995 AND action = 18
0.0150  SELECT action,minute FROM events2015 WHERE player_id = 80367 AND league_id = 9995 AND action = 19
0.0156  SELECT e.* FROM `events2015` e WHERE e.player_id = 80367 AND league_id = 3803 ORDER BY e.date ASC
0.0180  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3803 AND rel.player_id=80367
0.0154  SELECT action,minute FROM events2015 WHERE player_id = 80367 AND league_id = 3803 AND action = 18
0.0160  SELECT action,minute FROM events2015 WHERE player_id = 80367 AND league_id = 3803 AND action = 19
0.0152  SELECT e.* FROM `events2015` e WHERE e.player_id = 80367 AND league_id = 3992 ORDER BY e.date ASC
0.0225  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=80367
0.0146  SELECT action,minute FROM events2015 WHERE player_id = 80367 AND league_id = 3992 AND action = 18
0.0146  SELECT action,minute FROM events2015 WHERE player_id = 80367 AND league_id = 3992 AND action = 19
0.0145  SELECT e.* FROM `events2015` e WHERE e.player_id = 80367 AND league_id = 9144 ORDER BY e.date ASC
0.0149  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9144 AND rel.player_id=80367
0.0146  SELECT action,minute FROM events2015 WHERE player_id = 80367 AND league_id = 9144 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 80367 AND league_id = 9144 AND action = 19
0.0147  SELECT e.* FROM `events2014` e WHERE e.player_id = 80367 AND league_id = 2434 ORDER BY e.date ASC
0.0162  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2434 AND rel.player_id=80367
0.0146  SELECT action,minute FROM events2014 WHERE player_id = 80367 AND league_id = 2434 AND action = 18
0.0145  SELECT action,minute FROM events2014 WHERE player_id = 80367 AND league_id = 2434 AND action = 19
0.0145  SELECT e.* FROM `events2014` e WHERE e.player_id = 80367 AND league_id = 2399 ORDER BY e.date ASC
0.0159  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=80367
0.0147  SELECT action,minute FROM events2014 WHERE player_id = 80367 AND league_id = 2399 AND action = 18
0.0145  SELECT action,minute FROM events2014 WHERE player_id = 80367 AND league_id = 2399 AND action = 19
0.0145  SELECT e.* FROM `events2014` e WHERE e.player_id = 80367 AND league_id = 2735 ORDER BY e.date ASC
0.0229  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=80367
0.0159  SELECT action,minute FROM events2014 WHERE player_id = 80367 AND league_id = 2735 AND action = 18
0.0161  SELECT action,minute FROM events2014 WHERE player_id = 80367 AND league_id = 2735 AND action = 19
0.0150  SELECT e.* FROM `events2013` e WHERE e.player_id = 80367 AND league_id = 1901 ORDER BY e.date ASC
0.0160  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=80367
0.0145  SELECT action,minute FROM events2013 WHERE player_id = 80367 AND league_id = 1901 AND action = 18
0.0146  SELECT action,minute FROM events2013 WHERE player_id = 80367 AND league_id = 1901 AND action = 19
0.0145  SELECT e.* FROM `events2013` e WHERE e.player_id = 80367 AND league_id = 1969 ORDER BY e.date ASC
0.0156  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=80367
0.0146  SELECT action,minute FROM events2013 WHERE player_id = 80367 AND league_id = 1969 AND action = 18
0.0146  SELECT action,minute FROM events2013 WHERE player_id = 80367 AND league_id = 1969 AND action = 19
0.0148  SELECT e.* FROM `events2013` e WHERE e.player_id = 80367 AND league_id = 2391 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2391 AND rel.player_id=80367
0.0152  SELECT action,minute FROM events2013 WHERE player_id = 80367 AND league_id = 2391 AND action = 18
0.0152  SELECT action,minute FROM events2013 WHERE player_id = 80367 AND league_id = 2391 AND action = 19
0.0146  SELECT e.* FROM `events2012` e WHERE e.player_id = 80367 AND league_id = 1335 ORDER BY e.date ASC
0.0145  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=80367
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 80367 AND league_id = 1335 AND action = 18
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 80367 AND league_id = 1335 AND action = 19
0.0145  SELECT e.* FROM `events2012` e WHERE e.player_id = 80367 AND league_id = 1437 ORDER BY e.date ASC
0.0160  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=80367
0.0148  SELECT action,minute FROM events2012 WHERE player_id = 80367 AND league_id = 1437 AND action = 18
0.0152  SELECT action,minute FROM events2012 WHERE player_id = 80367 AND league_id = 1437 AND action = 19
0.0156  SELECT e.* FROM `events2012` e WHERE e.player_id = 80367 AND league_id = 1881 ORDER BY e.date ASC
0.0170  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1881 AND rel.player_id=80367
0.0146  SELECT action,minute FROM events2012 WHERE player_id = 80367 AND league_id = 1881 AND action = 18
0.0146  SELECT action,minute FROM events2012 WHERE player_id = 80367 AND league_id = 1881 AND action = 19
0.0145  SELECT e.* FROM `events2011` e WHERE e.player_id = 80367 AND league_id = 1099 ORDER BY e.date ASC
0.0156  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=80367
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 80367 AND league_id = 1099 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 80367 AND league_id = 1099 AND action = 19
0.0146  SELECT e.* FROM `events2011` e WHERE e.player_id = 80367 AND league_id = 1102 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1102 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 80367 AND league_id = 1102 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 80367 AND league_id = 1102 AND action = 19
0.0145  SELECT e.* FROM `events2011` e WHERE e.player_id = 80367 AND league_id = 1098 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1098 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 80367 AND league_id = 1098 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 80367 AND league_id = 1098 AND action = 19
0.0145  SELECT e.* FROM `events2010` e WHERE e.player_id = 80367 AND league_id = 826 ORDER BY e.date ASC
0.0145  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 826 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 80367 AND league_id = 826 AND action = 18
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 80367 AND league_id = 826 AND action = 19
0.0145  SELECT e.* FROM `events2010` e WHERE e.player_id = 80367 AND league_id = 831 ORDER BY e.date ASC
0.0145  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 831 AND rel.player_id=80367
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 80367 AND league_id = 831 AND action = 18
0.0146  SELECT action,minute FROM events2010 WHERE player_id = 80367 AND league_id = 831 AND action = 19
0.0145  SELECT e.* FROM `events2010` e WHERE e.player_id = 80367 AND league_id = 967 ORDER BY e.date ASC
0.0153  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=80367
0.0146  SELECT action,minute FROM events2010 WHERE player_id = 80367 AND league_id = 967 AND action = 18
0.0144  SELECT action,minute FROM events2010 WHERE player_id = 80367 AND league_id = 967 AND action = 19
0.0145  SELECT e.* FROM `events2010` e WHERE e.player_id = 80367 AND league_id = 999 ORDER BY e.date ASC
0.0146  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=80367
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 80367 AND league_id = 999 AND action = 18
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 80367 AND league_id = 999 AND action = 19
0.0146  SELECT e.* FROM `events2009` e WHERE e.player_id = 80367 AND league_id = 805 ORDER BY e.date ASC
0.0155  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=80367
0.0145  SELECT action,minute FROM events2009 WHERE player_id = 80367 AND league_id = 805 AND action = 18
0.0145  SELECT action,minute FROM events2009 WHERE player_id = 80367 AND league_id = 805 AND action = 19
0.0156   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` = '80367' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0150   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 = '2253244' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0154   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 = '1736612' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0154   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 = '1891305' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0153   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 = '1236012' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0156   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 = '852875' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20