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

C. Romaric

Jugador del Omonia Nicosia
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de C. Romaric
Nacionalidad
Costa de Marfil
Nombre
Koffi Christian N'dri Romaric
Edad
40 Años (04-06-1983)
Altura
187
Peso
88 kilogramos
Equipo
Omonia Nicosia
Posición
Centrocampista
Liga
Liga Chipre 2017 G 1
Compañeros de equipo
Fotos
7
  • Foto principal de C. Romaric | Bastia
  • N. Romaric
  • N. Romaric
  • N. Romaric
  • N. Romaric
  • N. Romaric
  • Ndri Romaric
5 Comentarios
  • daniel200
    Hace 12 años daniel200 dice: jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjjj jjjjjjjjjjjjjjjjjjjjjjav vvvvvvvvvvvvvvvvvvvvvvvv vvvvvvvvvvvvviiii
  • Hace 12 años xxmurciaxx dice: Internacional , un makina
  • nadal-mallorca
    Hace 12 años nadal-mallorca dice: buen jugadorbuen jugador
  • joserodriguez
    Hace 13 años joserodriguez dice: sera la sensacion este año sera la sensacion este año
  • jvdgs24
    Hace 14 años jvdgs24 dice: Tranquilidad para el Sevilla. El centrocampista Koffi Romaric ya realizó los estudios correspondientes y se comprobó que apenas sufrió un esguince en su rodilla izquierda. Por ende, se descartó una lesión grave ligamentaria y sólo deberá permanecer fuera de los campos de juego entre tres y cuatro semanas. El marfileño debió abandonar el partido contra el Valencia en la primera mitad, lo cual proTranquilidad para el Sevilla. El centrocampista Koffi Romaric ya realizó los estudios correspondientes y se comprobó que apenas sufrió un esguince en su rodilla izquierda. Por ende, se descartó una lesión grave ligamentaria y sólo deberá permanecer fuera de los campos de juego entre tres y cuatro semanas. El marfileño debió abandonar el partido contra el Valencia en la primera mitad, lo cual pro

  USO DE MEMORIA  
15,342,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Player / Index )  1.3071
Total Execution Time  1.3083
  CADENA URL  
/jugador/c-romaric-3418
  GET DATOS  
$_GET['/jugador/c-romaric-3418']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (381)  
0.0100   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` = '3418' AND c.comment_id IN (1475160,1451254,943395,495335,55458) GROUP BY c.comment_id
0.0027  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'c-romaric-3418' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0375  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 = 'c-romaric-3418' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
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 = 33682
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 = 15731
0.0056  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 = 15732
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 = 20342
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 = 19689
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 = 4307
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 = 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.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 = 2531
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 = 3602
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 = 1907
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 = 2272
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 = 2285
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 = 1437
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 = 1889
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 = 39535
0.0024  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1099
0.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 = 1115
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 = 1210
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 = 1255
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 = 42732
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 = 72573
0.0037  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 = 893
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 = 939
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 = 975
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 = 39416
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 = 71987
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 = 72576
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 = 770
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 = 778
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 = 793
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 = 72577
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 = 26
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 = 12242
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 = 12247
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 = 20486
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 = 20540
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 = 54
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 = 20485
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 = 20541
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 = 39419
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 = 42733
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 = 53
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 = 3787
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 = 12254
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 = 12258
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 = 20484
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 = 20542
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 = 39421
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 = 358
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 = 23350
0.0017  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 = '3418'
0.0042  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 = 33682 AND rp.teamId = 4060 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 = 3418 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 = '3418' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3418' and rp.type = 3
0.0019  SELECT e.* FROM `events2017` e WHERE e.player_id = 3418 AND league_id = 33682 ORDER BY e.date ASC
0.0126  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33682 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 3418 AND league_id = 33682 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 3418 AND league_id = 33682 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 3418 AND league_id = 30386 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 = 30386 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 3418 AND league_id = 30386 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 3418 AND league_id = 30386 AND action = 19
0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 3418 AND league_id = 15731 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 = 15731 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 15731 AND action = 18
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 15731 AND action = 19
0.0018  SELECT e.* FROM `events2016` e WHERE e.player_id = 3418 AND league_id = 15732 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 = 15732 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 15732 AND action = 18
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 15732 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 3418 AND league_id = 20342 ORDER BY e.date ASC
0.0058  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20342 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 20342 AND action = 18
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 20342 AND action = 19
0.0018  SELECT e.* FROM `events2016` e WHERE e.player_id = 3418 AND league_id = 15065 ORDER BY e.date ASC
0.0523  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15065 AND rel.player_id=3418
0.0023  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 15065 AND action = 18
0.0025  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 15065 AND action = 19
0.0018  SELECT e.* FROM `events2016` e WHERE e.player_id = 3418 AND league_id = 16245 ORDER BY e.date ASC
0.0026  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16245 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 16245 AND action = 18
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 16245 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 3418 AND league_id = 19689 ORDER BY e.date ASC
0.0030  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 19689 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 19689 AND action = 18
0.0018  SELECT action,minute FROM events2016 WHERE player_id = 3418 AND league_id = 19689 AND action = 19
0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 3418 AND league_id = 3771 ORDER BY e.date ASC
0.0058  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3771 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 3771 AND action = 18
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 3771 AND action = 19
0.0018  SELECT e.* FROM `events2015` e WHERE e.player_id = 3418 AND league_id = 4307 ORDER BY e.date ASC
0.0055  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4307 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 4307 AND action = 18
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 4307 AND action = 19
0.0019  SELECT e.* FROM `events2015` e WHERE e.player_id = 3418 AND league_id = 3804 ORDER BY e.date ASC
0.0050  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=3418
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 3804 AND action = 18
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 3804 AND action = 19
0.0018  SELECT e.* FROM `events2015` e WHERE e.player_id = 3418 AND league_id = 3980 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 = 3980 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 3980 AND action = 18
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 3980 AND action = 19
0.0019  SELECT e.* FROM `events2015` e WHERE e.player_id = 3418 AND league_id = 7560 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 = 7560 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 7560 AND action = 18
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 3418 AND league_id = 7560 AND action = 19
0.0020  SELECT e.* FROM `events2014` e WHERE e.player_id = 3418 AND league_id = 2432 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 = 2432 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2014 WHERE player_id = 3418 AND league_id = 2432 AND action = 18
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 3418 AND league_id = 2432 AND action = 19
0.0019  SELECT e.* FROM `events2014` e WHERE e.player_id = 3418 AND league_id = 2530 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 = 2530 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 3418 AND league_id = 2530 AND action = 18
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 3418 AND league_id = 2530 AND action = 19
0.0018  SELECT e.* FROM `events2014` e WHERE e.player_id = 3418 AND league_id = 2531 ORDER BY e.date ASC
0.0094  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=3418
0.0020  SELECT action,minute FROM events2014 WHERE player_id = 3418 AND league_id = 2531 AND action = 18
0.0020  SELECT action,minute FROM events2014 WHERE player_id = 3418 AND league_id = 2531 AND action = 19
0.0020  SELECT e.* FROM `events2014` e WHERE e.player_id = 3418 AND league_id = 3602 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 = 3602 AND rel.player_id=3418
0.0022  SELECT action,minute FROM events2014 WHERE player_id = 3418 AND league_id = 3602 AND action = 18
0.0021  SELECT action,minute FROM events2014 WHERE player_id = 3418 AND league_id = 3602 AND action = 19
0.0021  SELECT e.* FROM `events2013` e WHERE e.player_id = 3418 AND league_id = 1907 ORDER BY e.date ASC
0.0097  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1907 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 1907 AND action = 18
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 1907 AND action = 19
0.0018  SELECT e.* FROM `events2013` e WHERE e.player_id = 3418 AND league_id = 1906 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 = 1906 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 1906 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 1906 AND action = 19
0.0018  SELECT e.* FROM `events2013` e WHERE e.player_id = 3418 AND league_id = 1969 ORDER BY e.date ASC
0.0052  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1969 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 1969 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 1969 AND action = 19
0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 3418 AND league_id = 2249 ORDER BY e.date ASC
0.0080  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2249 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 2249 AND action = 18
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 2249 AND action = 19
0.0020  SELECT e.* FROM `events2013` e WHERE e.player_id = 3418 AND league_id = 2272 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 = 2272 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 2272 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 2272 AND action = 19
0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 3418 AND league_id = 2285 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 = 2285 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 2285 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 3418 AND league_id = 2285 AND action = 19
0.0021  SELECT e.* FROM `events2012` e WHERE e.player_id = 3418 AND league_id = 1334 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 = 1334 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 1334 AND action = 18
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 1334 AND action = 19
0.0018  SELECT e.* FROM `events2012` e WHERE e.player_id = 3418 AND league_id = 1323 ORDER BY e.date ASC
0.0050  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1323 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 1323 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 1323 AND action = 19
0.0019  SELECT e.* FROM `events2012` e WHERE e.player_id = 3418 AND league_id = 1437 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 = 1437 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 1437 AND action = 18
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 1437 AND action = 19
0.0019  SELECT e.* FROM `events2012` e WHERE e.player_id = 3418 AND league_id = 1889 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 = 1889 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 1889 AND action = 18
0.0022  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 1889 AND action = 19
0.0019  SELECT e.* FROM `events2012` e WHERE e.player_id = 3418 AND league_id = 39535 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 = 39535 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 39535 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 39535 AND action = 19
0.0020  SELECT e.* FROM `events2012` e WHERE e.player_id = 3418 AND league_id = 72606 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 = 72606 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 72606 AND action = 18
0.0021  SELECT action,minute FROM events2012 WHERE player_id = 3418 AND league_id = 72606 AND action = 19
0.0020  SELECT e.* FROM `events2011` e WHERE e.player_id = 3418 AND league_id = 1099 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 = 1099 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1099 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1099 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 3418 AND league_id = 1115 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 = 1115 AND rel.player_id=3418
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1115 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1115 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 3418 AND league_id = 1210 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 = 1210 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1210 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1210 AND action = 19
0.0021  SELECT e.* FROM `events2011` e WHERE e.player_id = 3418 AND league_id = 1235 ORDER BY e.date ASC
0.0080  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1235 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1235 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1235 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 3418 AND league_id = 1255 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 = 1255 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1255 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 1255 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 3418 AND league_id = 24786 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 = 24786 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 24786 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 24786 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 3418 AND league_id = 42732 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 = 42732 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 42732 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 42732 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 3418 AND league_id = 42848 ORDER BY e.date ASC
0.0025  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42848 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 42848 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 42848 AND action = 19
0.0018  SELECT e.* FROM `events2011` e WHERE e.player_id = 3418 AND league_id = 72573 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 = 72573 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 72573 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 3418 AND league_id = 72573 AND action = 19
0.0020  SELECT e.* FROM `events2010` e WHERE e.player_id = 3418 AND league_id = 811 ORDER BY e.date ASC
0.0100  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 811 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 811 AND action = 18
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 811 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 3418 AND league_id = 893 ORDER BY e.date ASC
0.0063  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 893 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 893 AND action = 18
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 893 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 3418 AND league_id = 939 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 = 939 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 939 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 939 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 3418 AND league_id = 967 ORDER BY e.date ASC
0.0100  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 967 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 967 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 967 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 3418 AND league_id = 975 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 = 975 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 975 AND action = 18
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 975 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 3418 AND league_id = 39416 ORDER BY e.date ASC
0.0055  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39416 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 39416 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 39416 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 3418 AND league_id = 71987 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 = 71987 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 71987 AND action = 18
0.0022  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 71987 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 3418 AND league_id = 72576 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 = 72576 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 72576 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 3418 AND league_id = 72576 AND action = 19
0.0024  SELECT e.* FROM `events2009` e WHERE e.player_id = 3418 AND league_id = 104 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 = 104 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 104 AND action = 18
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 104 AND action = 19
0.0020  SELECT e.* FROM `events2009` e WHERE e.player_id = 3418 AND league_id = 770 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 = 770 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 770 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 770 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 3418 AND league_id = 778 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 = 778 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 778 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 778 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 3418 AND league_id = 793 ORDER BY e.date ASC
0.0023  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 793 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 793 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 793 AND action = 19
0.0018  SELECT e.* FROM `events2009` e WHERE e.player_id = 3418 AND league_id = 805 ORDER BY e.date ASC
0.0050  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=3418
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 805 AND action = 18
0.0017  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 805 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 3418 AND league_id = 39417 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 = 39417 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 39417 AND action = 18
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 39417 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 3418 AND league_id = 72577 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 = 72577 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 72577 AND action = 18
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 3418 AND league_id = 72577 AND action = 19
0.0021  SELECT e.* FROM `events2008` e WHERE e.player_id = 3418 AND league_id = 26 ORDER BY e.date ASC
0.0079  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 26 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 26 AND action = 18
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 26 AND action = 19
0.0020  SELECT e.* FROM `events2008` e WHERE e.player_id = 3418 AND league_id = 12242 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 = 12242 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 12242 AND action = 18
0.0023  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 12242 AND action = 19
0.0018  SELECT e.* FROM `events2008` e WHERE e.player_id = 3418 AND league_id = 12247 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 = 12247 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 12247 AND action = 18
0.0020  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 12247 AND action = 19
0.0020  SELECT e.* FROM `events2008` e WHERE e.player_id = 3418 AND league_id = 20486 ORDER BY e.date ASC
0.0084  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20486 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 20486 AND action = 18
0.0017  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 20486 AND action = 19
0.0018  SELECT e.* FROM `events2008` e WHERE e.player_id = 3418 AND league_id = 20540 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 = 20540 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 20540 AND action = 18
0.0017  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 20540 AND action = 19
0.0018  SELECT e.* FROM `events2008` e WHERE e.player_id = 3418 AND league_id = 39418 ORDER BY e.date ASC
0.0109  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39418 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 39418 AND action = 18
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 3418 AND league_id = 39418 AND action = 19
0.0023  SELECT e.* FROM `events2007` e WHERE e.player_id = 3418 AND league_id = 54 ORDER BY e.date ASC
0.0137  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 54 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 54 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 54 AND action = 19
0.0018  SELECT e.* FROM `events2007` e WHERE e.player_id = 3418 AND league_id = 20485 ORDER BY e.date ASC
0.0119  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20485 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 20485 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 20485 AND action = 19
0.0019  SELECT e.* FROM `events2007` e WHERE e.player_id = 3418 AND league_id = 20541 ORDER BY e.date ASC
0.0029  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20541 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 20541 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 20541 AND action = 19
0.0018  SELECT e.* FROM `events2007` e WHERE e.player_id = 3418 AND league_id = 39419 ORDER BY e.date ASC
0.0117  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39419 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 39419 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 39419 AND action = 19
0.0019  SELECT e.* FROM `events2007` e WHERE e.player_id = 3418 AND league_id = 42733 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 = 42733 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 42733 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 3418 AND league_id = 42733 AND action = 19
0.0019  SELECT e.* FROM `events2006` e WHERE e.player_id = 3418 AND league_id = 53 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 = 53 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 53 AND action = 18
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 53 AND action = 19
0.0018  SELECT e.* FROM `events2006` e WHERE e.player_id = 3418 AND league_id = 3787 ORDER BY e.date ASC
0.0027  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3787 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 3787 AND action = 18
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 3787 AND action = 19
0.0018  SELECT e.* FROM `events2006` e WHERE e.player_id = 3418 AND league_id = 12254 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 = 12254 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 12254 AND action = 18
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 12254 AND action = 19
0.0018  SELECT e.* FROM `events2006` e WHERE e.player_id = 3418 AND league_id = 12258 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 = 12258 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 12258 AND action = 18
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 12258 AND action = 19
0.0018  SELECT e.* FROM `events2006` e WHERE e.player_id = 3418 AND league_id = 20484 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 = 20484 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 20484 AND action = 18
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 20484 AND action = 19
0.0019  SELECT e.* FROM `events2006` e WHERE e.player_id = 3418 AND league_id = 20542 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 = 20542 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 20542 AND action = 18
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 20542 AND action = 19
0.0020  SELECT e.* FROM `events2006` e WHERE e.player_id = 3418 AND league_id = 39420 ORDER BY e.date ASC
0.0114  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39420 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 39420 AND action = 18
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 3418 AND league_id = 39420 AND action = 19
0.0019  SELECT e.* FROM `events2005` e WHERE e.player_id = 3418 AND league_id = 357 ORDER BY e.date ASC
0.0058  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 357 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 357 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 357 AND action = 19
0.0018  SELECT e.* FROM `events2005` e WHERE e.player_id = 3418 AND league_id = 10979 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 = 10979 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 10979 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 10979 AND action = 19
0.0018  SELECT e.* FROM `events2005` e WHERE e.player_id = 3418 AND league_id = 10992 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 = 10992 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 10992 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 10992 AND action = 19
0.0018  SELECT e.* FROM `events2005` e WHERE e.player_id = 3418 AND league_id = 20644 ORDER BY e.date ASC
0.0063  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20644 AND rel.player_id=3418
0.0020  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 20644 AND action = 18
0.0019  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 20644 AND action = 19
0.0019  SELECT e.* FROM `events2005` e WHERE e.player_id = 3418 AND league_id = 39421 ORDER BY e.date ASC
0.0080  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39421 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 39421 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 39421 AND action = 19
0.0019  SELECT e.* FROM `events2005` e WHERE e.player_id = 3418 AND league_id = 42357 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 = 42357 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 42357 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 3418 AND league_id = 42357 AND action = 19
0.0020  SELECT e.* FROM `events2004` e WHERE e.player_id = 3418 AND league_id = 358 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 = 358 AND rel.player_id=3418
0.0019  SELECT action,minute FROM events2004 WHERE player_id = 3418 AND league_id = 358 AND action = 18
0.0018  SELECT action,minute FROM events2004 WHERE player_id = 3418 AND league_id = 358 AND action = 19
0.0019  SELECT e.* FROM `events2004` e WHERE e.player_id = 3418 AND league_id = 23350 ORDER BY e.date ASC
0.0052  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 23350 AND rel.player_id=3418
0.0018  SELECT action,minute FROM events2004 WHERE player_id = 3418 AND league_id = 23350 AND action = 18
0.0017  SELECT action,minute FROM events2004 WHERE player_id = 3418 AND league_id = 23350 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` = '3418' 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 = '1475160' 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 = '1451254' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0024   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 = '943395' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   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 = '495335' 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 = '55458' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20