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

E. Rivière

Jugador del Crotone
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de E. Rivière
Nacionalidad
Martinica
Nombre
Emmanuel Rivière
Edad
34 Años (03-03-1990)
Altura
182
Peso
76 kilogramos
Equipo
Crotone
Posición
Delantero
Liga
Partidos Amistosos 2022
Compañeros de equipo
Fotos
8
  • Foto principal de E. Rivière | Crotone
  • Foto principal de E. Rivière | Osasuna
  • Foto principal de E. Rivière | Newcastle
  • Foto principal de E. Rivière | Newcastle United
  • Foto principal de E. Rivière | Monaco
  • E. Riviere
  • E. Riviere
  • Riviere
1 Comentarios
  • Adriantheboss
    Hace 14 años Adriantheboss dice: pero si este es delantero de toda la vida en la alineacion esta coimo lateral porque?pero si este es delantero de toda la vida en la alineacion esta coimo lateral porque?

  USO DE MEMORIA  
13,741,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Player / Index )  0.9782
Total Execution Time  0.9794
  CADENA URL  
/jugador/e-riviere-21172
  GET DATOS  
$_GET['/jugador/e-riviere-21172']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (313)  
0.0003   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` = '21172' AND c.comment_id IN (113953) GROUP BY c.comment_id
0.0026  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'e-riviere-21172' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0227  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 = 'e-riviere-21172' 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 = 63341
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 = 57792
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 = 59041
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 = 43687
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 = 44442
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 = 49342
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 = 38644
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 = 38752
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 = 39081
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 = 41146
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 = 33348
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 = 15425
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 = 16427
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 = 3773
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 = 4028
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 = 2432
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 = 2530
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 = 2531
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 = 1910
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 = 1921
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 = 20491
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 = 20535
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 = 41905
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 = 41906
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 = 1327
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 = 20490
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 = 20536
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 = 39577
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 = 1072
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 = 20537
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 = 39578
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 = 41908
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 = 816
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 = 20488
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 = 20538
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 = 39579
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 = 151
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 = 774
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 20487
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 = 20539
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 = 42594
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 = 42595
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 = 43863
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 = 39062
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 = 39065
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 = 58906
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 = 75418
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 = '21172'
0.0245  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 = 62807 AND rp.teamId = 1056 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0028  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 = 21172 ORDER BY rp.year DESC
0.0024  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 = '21172' 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 = '21172' and rp.type = 3
0.0018  SELECT e.* FROM `events2022` e WHERE e.player_id = 21172 AND league_id = 62807 ORDER BY e.date ASC
0.0083  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62807 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2022 WHERE player_id = 21172 AND league_id = 62807 AND action = 18
0.0018  SELECT action,minute FROM events2022 WHERE player_id = 21172 AND league_id = 62807 AND action = 19
0.0018  SELECT e.* FROM `events2022` e WHERE e.player_id = 21172 AND league_id = 63341 ORDER BY e.date ASC
0.0074  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 63341 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2022 WHERE player_id = 21172 AND league_id = 63341 AND action = 18
0.0018  SELECT action,minute FROM events2022 WHERE player_id = 21172 AND league_id = 63341 AND action = 19
0.0020  SELECT e.* FROM `events2021` e WHERE e.player_id = 21172 AND league_id = 57792 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 = 57792 AND rel.player_id=21172
0.0023  SELECT action,minute FROM events2021 WHERE player_id = 21172 AND league_id = 57792 AND action = 18
0.0024  SELECT action,minute FROM events2021 WHERE player_id = 21172 AND league_id = 57792 AND action = 19
0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 21172 AND league_id = 58676 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 = 58676 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 21172 AND league_id = 58676 AND action = 18
0.0019  SELECT action,minute FROM events2021 WHERE player_id = 21172 AND league_id = 58676 AND action = 19
0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 21172 AND league_id = 59041 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 = 59041 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2021 WHERE player_id = 21172 AND league_id = 59041 AND action = 18
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 21172 AND league_id = 59041 AND action = 19
0.0020  SELECT e.* FROM `events2020` e WHERE e.player_id = 21172 AND league_id = 49921 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 = 49921 AND rel.player_id=21172
0.0022  SELECT action,minute FROM events2020 WHERE player_id = 21172 AND league_id = 49921 AND action = 18
0.0022  SELECT action,minute FROM events2020 WHERE player_id = 21172 AND league_id = 49921 AND action = 19
0.0019  SELECT e.* FROM `events2019` e WHERE e.player_id = 21172 AND league_id = 43687 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 = 43687 AND rel.player_id=21172
0.0022  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 43687 AND action = 18
0.0023  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 43687 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 21172 AND league_id = 43475 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 = 43475 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 43475 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 43475 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 21172 AND league_id = 44442 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 = 44442 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 44442 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 44442 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 21172 AND league_id = 47499 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 = 47499 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 47499 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 47499 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 21172 AND league_id = 49342 ORDER BY e.date ASC
0.0070  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49342 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 49342 AND action = 18
0.0019  SELECT action,minute FROM events2019 WHERE player_id = 21172 AND league_id = 49342 AND action = 19
0.0021  SELECT e.* FROM `events2018` e WHERE e.player_id = 21172 AND league_id = 38644 ORDER BY e.date ASC
0.0090  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38644 AND rel.player_id=21172
0.0023  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 38644 AND action = 18
0.0021  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 38644 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 21172 AND league_id = 38427 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 = 38427 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 38427 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 38427 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 21172 AND league_id = 38752 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 = 38752 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 38752 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 38752 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 21172 AND league_id = 39081 ORDER BY e.date ASC
0.0032  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39081 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 39081 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 39081 AND action = 19
0.0019  SELECT e.* FROM `events2018` e WHERE e.player_id = 21172 AND league_id = 41146 ORDER BY e.date ASC
0.0059  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41146 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 41146 AND action = 18
0.0020  SELECT action,minute FROM events2018 WHERE player_id = 21172 AND league_id = 41146 AND action = 19
0.0020  SELECT e.* FROM `events2017` e WHERE e.player_id = 21172 AND league_id = 30626 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 = 30626 AND rel.player_id=21172
0.0021  SELECT action,minute FROM events2017 WHERE player_id = 21172 AND league_id = 30626 AND action = 18
0.0021  SELECT action,minute FROM events2017 WHERE player_id = 21172 AND league_id = 30626 AND action = 19
0.0019  SELECT e.* FROM `events2017` e WHERE e.player_id = 21172 AND league_id = 30386 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 = 30386 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2017 WHERE player_id = 21172 AND league_id = 30386 AND action = 18
0.0020  SELECT action,minute FROM events2017 WHERE player_id = 21172 AND league_id = 30386 AND action = 19
0.0019  SELECT e.* FROM `events2017` e WHERE e.player_id = 21172 AND league_id = 33348 ORDER BY e.date ASC
0.0032  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33348 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 21172 AND league_id = 33348 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 21172 AND league_id = 33348 AND action = 19
0.0019  SELECT e.* FROM `events2017` e WHERE e.player_id = 21172 AND league_id = 33904 ORDER BY e.date ASC
0.0033  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33904 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 21172 AND league_id = 33904 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 21172 AND league_id = 33904 AND action = 19
0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 21172 AND league_id = 15131 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 = 15131 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2016 WHERE player_id = 21172 AND league_id = 15131 AND action = 18
0.0018  SELECT action,minute FROM events2016 WHERE player_id = 21172 AND league_id = 15131 AND action = 19
0.0018  SELECT e.* FROM `events2016` e WHERE e.player_id = 21172 AND league_id = 15425 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 = 15425 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2016 WHERE player_id = 21172 AND league_id = 15425 AND action = 18
0.0018  SELECT action,minute FROM events2016 WHERE player_id = 21172 AND league_id = 15425 AND action = 19
0.0018  SELECT e.* FROM `events2016` e WHERE e.player_id = 21172 AND league_id = 16245 ORDER BY e.date ASC
0.0032  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=21172
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 21172 AND league_id = 16245 AND action = 18
0.0020  SELECT action,minute FROM events2016 WHERE player_id = 21172 AND league_id = 16245 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 21172 AND league_id = 16427 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 = 16427 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 21172 AND league_id = 16427 AND action = 18
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 21172 AND league_id = 16427 AND action = 19
0.0021  SELECT e.* FROM `events2015` e WHERE e.player_id = 21172 AND league_id = 3773 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 = 3773 AND rel.player_id=21172
0.0022  SELECT action,minute FROM events2015 WHERE player_id = 21172 AND league_id = 3773 AND action = 18
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 21172 AND league_id = 3773 AND action = 19
0.0018  SELECT e.* FROM `events2015` e WHERE e.player_id = 21172 AND league_id = 3804 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 = 3804 AND rel.player_id=21172
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 21172 AND league_id = 3804 AND action = 18
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 21172 AND league_id = 3804 AND action = 19
0.0019  SELECT e.* FROM `events2015` e WHERE e.player_id = 21172 AND league_id = 4028 ORDER BY e.date ASC
0.0053  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4028 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 21172 AND league_id = 4028 AND action = 18
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 21172 AND league_id = 4028 AND action = 19
0.0018  SELECT e.* FROM `events2015` e WHERE e.player_id = 21172 AND league_id = 4393 ORDER BY e.date ASC
0.0068  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4393 AND rel.player_id=21172
0.0024  SELECT action,minute FROM events2015 WHERE player_id = 21172 AND league_id = 4393 AND action = 18
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 21172 AND league_id = 4393 AND action = 19
0.0021  SELECT e.* FROM `events2014` e WHERE e.player_id = 21172 AND league_id = 2432 ORDER BY e.date ASC
0.0066  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2432 AND rel.player_id=21172
0.0021  SELECT action,minute FROM events2014 WHERE player_id = 21172 AND league_id = 2432 AND action = 18
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 21172 AND league_id = 2432 AND action = 19
0.0022  SELECT e.* FROM `events2014` e WHERE e.player_id = 21172 AND league_id = 2399 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 = 2399 AND rel.player_id=21172
0.0021  SELECT action,minute FROM events2014 WHERE player_id = 21172 AND league_id = 2399 AND action = 18
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 21172 AND league_id = 2399 AND action = 19
0.0019  SELECT e.* FROM `events2014` e WHERE e.player_id = 21172 AND league_id = 2530 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 = 2530 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 21172 AND league_id = 2530 AND action = 18
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 21172 AND league_id = 2530 AND action = 19
0.0019  SELECT e.* FROM `events2014` e WHERE e.player_id = 21172 AND league_id = 2531 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 = 2531 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 21172 AND league_id = 2531 AND action = 18
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 21172 AND league_id = 2531 AND action = 19
0.0020  SELECT e.* FROM `events2013` e WHERE e.player_id = 21172 AND league_id = 1910 ORDER BY e.date ASC
0.0101  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1910 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 1910 AND action = 18
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 1910 AND action = 19
0.0020  SELECT e.* FROM `events2013` e WHERE e.player_id = 21172 AND league_id = 1921 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 = 1921 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 1921 AND action = 18
0.0021  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 1921 AND action = 19
0.0018  SELECT e.* FROM `events2013` e WHERE e.player_id = 21172 AND league_id = 20491 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 = 20491 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 20491 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 20491 AND action = 19
0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 21172 AND league_id = 20535 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 = 20535 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 20535 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 20535 AND action = 19
0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 21172 AND league_id = 41905 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 = 41905 AND rel.player_id=21172
0.0027  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 41905 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 41905 AND action = 19
0.0018  SELECT e.* FROM `events2013` e WHERE e.player_id = 21172 AND league_id = 41906 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 = 41906 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 41906 AND action = 18
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 21172 AND league_id = 41906 AND action = 19
0.0022  SELECT e.* FROM `events2012` e WHERE e.player_id = 21172 AND league_id = 1327 ORDER BY e.date ASC
0.0078  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1327 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2012 WHERE player_id = 21172 AND league_id = 1327 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 21172 AND league_id = 1327 AND action = 19
0.0018  SELECT e.* FROM `events2012` e WHERE e.player_id = 21172 AND league_id = 20490 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 = 20490 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 21172 AND league_id = 20490 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 21172 AND league_id = 20490 AND action = 19
0.0018  SELECT e.* FROM `events2012` e WHERE e.player_id = 21172 AND league_id = 20536 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 = 20536 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 21172 AND league_id = 20536 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 21172 AND league_id = 20536 AND action = 19
0.0018  SELECT e.* FROM `events2012` e WHERE e.player_id = 21172 AND league_id = 39577 ORDER BY e.date ASC
0.0032  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39577 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 21172 AND league_id = 39577 AND action = 18
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 21172 AND league_id = 39577 AND action = 19
0.0021  SELECT e.* FROM `events2011` e WHERE e.player_id = 21172 AND league_id = 1072 ORDER BY e.date ASC
0.0081  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1072 AND rel.player_id=21172
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 1072 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 1072 AND action = 19
0.0021  SELECT e.* FROM `events2011` e WHERE e.player_id = 21172 AND league_id = 20489 ORDER BY e.date ASC
0.0082  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20489 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 20489 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 20489 AND action = 19
0.0018  SELECT e.* FROM `events2011` e WHERE e.player_id = 21172 AND league_id = 20537 ORDER BY e.date ASC
0.0060  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20537 AND rel.player_id=21172
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 20537 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 20537 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 21172 AND league_id = 39578 ORDER BY e.date ASC
0.0112  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39578 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 39578 AND action = 18
0.0029  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 39578 AND action = 19
0.0020  SELECT e.* FROM `events2011` e WHERE e.player_id = 21172 AND league_id = 41908 ORDER BY e.date ASC
0.0064  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41908 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 41908 AND action = 18
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 21172 AND league_id = 41908 AND action = 19
0.0021  SELECT e.* FROM `events2010` e WHERE e.player_id = 21172 AND league_id = 816 ORDER BY e.date ASC
0.0111  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 816 AND rel.player_id=21172
0.0023  SELECT action,minute FROM events2010 WHERE player_id = 21172 AND league_id = 816 AND action = 18
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 21172 AND league_id = 816 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 21172 AND league_id = 20488 ORDER BY e.date ASC
0.0053  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20488 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 21172 AND league_id = 20488 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 21172 AND league_id = 20488 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 21172 AND league_id = 20538 ORDER BY e.date ASC
0.0054  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20538 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 21172 AND league_id = 20538 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 21172 AND league_id = 20538 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 21172 AND league_id = 39579 ORDER BY e.date ASC
0.0062  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39579 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 21172 AND league_id = 39579 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 21172 AND league_id = 39579 AND action = 19
0.0020  SELECT e.* FROM `events2009` e WHERE e.player_id = 21172 AND league_id = 151 ORDER BY e.date ASC
0.0054  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 151 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 151 AND action = 18
0.0022  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 151 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 21172 AND league_id = 774 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 = 774 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 774 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 774 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 21172 AND league_id = 778 ORDER BY e.date ASC
0.0067  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 778 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 778 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 778 AND action = 19
0.0022  SELECT e.* FROM `events2009` e WHERE e.player_id = 21172 AND league_id = 20487 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 = 20487 AND rel.player_id=21172
0.0022  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 20487 AND action = 18
0.0020  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 20487 AND action = 19
0.0021  SELECT e.* FROM `events2009` e WHERE e.player_id = 21172 AND league_id = 20539 ORDER BY e.date ASC
0.0096  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20539 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 20539 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 20539 AND action = 19
0.0020  SELECT e.* FROM `events2009` e WHERE e.player_id = 21172 AND league_id = 42594 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 = 42594 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 42594 AND action = 18
0.0029  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 42594 AND action = 19
0.0022  SELECT e.* FROM `events2009` e WHERE e.player_id = 21172 AND league_id = 42595 ORDER BY e.date ASC
0.0033  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42595 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 42595 AND action = 18
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 21172 AND league_id = 42595 AND action = 19
0.0020  SELECT e.* FROM `events2008` e WHERE e.player_id = 21172 AND league_id = 43863 ORDER BY e.date ASC
0.0092  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43863 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 21172 AND league_id = 43863 AND action = 18
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 21172 AND league_id = 43863 AND action = 19
0.0023  SELECT e.* FROM `events2007` e WHERE e.player_id = 21172 AND league_id = 39062 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 = 39062 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 39062 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 39062 AND action = 19
0.0019  SELECT e.* FROM `events2007` e WHERE e.player_id = 21172 AND league_id = 39065 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 = 39065 AND rel.player_id=21172
0.0020  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 39065 AND action = 18
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 39065 AND action = 19
0.0018  SELECT e.* FROM `events2007` e WHERE e.player_id = 21172 AND league_id = 43938 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 = 43938 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 43938 AND action = 18
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 43938 AND action = 19
0.0018  SELECT e.* FROM `events2007` e WHERE e.player_id = 21172 AND league_id = 58906 ORDER BY e.date ASC
0.0086  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58906 AND rel.player_id=21172
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 58906 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 58906 AND action = 19
0.0018  SELECT e.* FROM `events2007` e WHERE e.player_id = 21172 AND league_id = 75418 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 = 75418 AND rel.player_id=21172
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 75418 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 21172 AND league_id = 75418 AND action = 19
0.0024   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` = '21172' 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 = '113953' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20