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

A. Olesen

Jugador del Fremad Amager
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de A. Olesen
Nacionalidad
Dinamarca
Nombre
Allan Arenfeldt Olesen
Edad
41 Años (20-05-1982)
Altura
182
Peso
85 kilogramos
Equipo
Fremad Amager
Posición
Defensa
Liga
Primera Dinamarca 2018
Compañeros de equipo

No hay comentarios


  USO DE MEMORIA  
10,180,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Player / Index )  0.6480
Total Execution Time  0.6493
  CADENA URL  
/jugador/a-olesen-212205
  GET DATOS  
$_GET['/jugador/a-olesen-212205']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (232)  
0.0003   SELECT 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` = '212205'
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 = 'a-olesen-212205' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0143  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 = 'a-olesen-212205' 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 = 38748
0.0028  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 38841
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 = 33345
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 = 30386
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 = 33399
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 = 16251
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 = 9516
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 = 3804
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 = 3641
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 = 2326
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 = 1554
0.0028  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 47495
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 = 1311
0.0029  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 21309
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 = 47496
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 = 1037
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 = 1038
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 = 20878
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 = 21134
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 = 42903
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 = 42904
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 = 42905
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 = 319
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 = 20877
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 = 69
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 = 368
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 = 369
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 = 370
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 = 371
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 = 372
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 = 40743
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 = 373
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 = 56956
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 = 62755
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 = 374
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 = 40764
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 = 57821
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 = 58508
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 = 75854
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 = 37820
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 = 37821
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 = '212205'
0.0034  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 = 38748 AND rp.teamId = 7449 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0024  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 = 212205 ORDER BY rp.year DESC
0.0020  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 = '212205' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT e.* FROM `events2018` e WHERE e.player_id = 212205 AND league_id = 38748 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 = 38748 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2018 WHERE player_id = 212205 AND league_id = 38748 AND action = 18
0.0019  SELECT action,minute FROM events2018 WHERE player_id = 212205 AND league_id = 38748 AND action = 19
0.0019  SELECT e.* FROM `events2018` e WHERE e.player_id = 212205 AND league_id = 38841 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 = 38841 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 212205 AND league_id = 38841 AND action = 18
0.0019  SELECT action,minute FROM events2018 WHERE player_id = 212205 AND league_id = 38841 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 212205 AND league_id = 38427 ORDER BY e.date ASC
0.0051  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38427 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 212205 AND league_id = 38427 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 212205 AND league_id = 38427 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 212205 AND league_id = 33345 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 = 33345 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2017 WHERE player_id = 212205 AND league_id = 33345 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 212205 AND league_id = 33345 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 212205 AND league_id = 30386 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 = 30386 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2017 WHERE player_id = 212205 AND league_id = 30386 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 212205 AND league_id = 30386 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 212205 AND league_id = 33399 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 = 33399 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 212205 AND league_id = 33399 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 212205 AND league_id = 33399 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 212205 AND league_id = 16251 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 = 16251 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 212205 AND league_id = 16251 AND action = 18
0.0018  SELECT action,minute FROM events2016 WHERE player_id = 212205 AND league_id = 16251 AND action = 19
0.0021  SELECT e.* FROM `events2015` e WHERE e.player_id = 212205 AND league_id = 9516 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 = 9516 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 212205 AND league_id = 9516 AND action = 18
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 212205 AND league_id = 9516 AND action = 19
0.0019  SELECT e.* FROM `events2015` e WHERE e.player_id = 212205 AND league_id = 3804 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 = 3804 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 212205 AND league_id = 3804 AND action = 18
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 212205 AND league_id = 3804 AND action = 19
0.0023  SELECT e.* FROM `events2014` e WHERE e.player_id = 212205 AND league_id = 3641 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 = 3641 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 212205 AND league_id = 3641 AND action = 18
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 212205 AND league_id = 3641 AND action = 19
0.0020  SELECT e.* FROM `events2013` e WHERE e.player_id = 212205 AND league_id = 2326 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 = 2326 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 212205 AND league_id = 2326 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 212205 AND league_id = 2326 AND action = 19
0.0020  SELECT e.* FROM `events2012` e WHERE e.player_id = 212205 AND league_id = 1554 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 = 1554 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 212205 AND league_id = 1554 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 212205 AND league_id = 1554 AND action = 19
0.0019  SELECT e.* FROM `events2012` e WHERE e.player_id = 212205 AND league_id = 47495 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 = 47495 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 212205 AND league_id = 47495 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 212205 AND league_id = 47495 AND action = 19
0.0021  SELECT e.* FROM `events2011` e WHERE e.player_id = 212205 AND league_id = 1311 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 = 1311 AND rel.player_id=212205
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 212205 AND league_id = 1311 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 212205 AND league_id = 1311 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 212205 AND league_id = 21309 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 = 21309 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 212205 AND league_id = 21309 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 212205 AND league_id = 21309 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 212205 AND league_id = 47496 ORDER BY e.date ASC
0.0035  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 47496 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 212205 AND league_id = 47496 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 212205 AND league_id = 47496 AND action = 19
0.0020  SELECT e.* FROM `events2010` e WHERE e.player_id = 212205 AND league_id = 1037 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 = 1037 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 1037 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 1037 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 212205 AND league_id = 1038 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 = 1038 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 1038 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 1038 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 212205 AND league_id = 20878 ORDER BY e.date ASC
0.0037  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20878 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 20878 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 20878 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 212205 AND league_id = 21134 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 = 21134 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 21134 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 21134 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 212205 AND league_id = 42903 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 = 42903 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 42903 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 42903 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 212205 AND league_id = 42904 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 = 42904 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 42904 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 42904 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 212205 AND league_id = 42905 ORDER BY e.date ASC
0.0040  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42905 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 42905 AND action = 18
0.0021  SELECT action,minute FROM events2010 WHERE player_id = 212205 AND league_id = 42905 AND action = 19
0.0022  SELECT e.* FROM `events2009` e WHERE e.player_id = 212205 AND league_id = 319 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 = 319 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 212205 AND league_id = 319 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 212205 AND league_id = 319 AND action = 19
0.0018  SELECT e.* FROM `events2009` e WHERE e.player_id = 212205 AND league_id = 20877 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 = 20877 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 212205 AND league_id = 20877 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 212205 AND league_id = 20877 AND action = 19
0.0019  SELECT e.* FROM `events2008` e WHERE e.player_id = 212205 AND league_id = 69 ORDER BY e.date ASC
0.0037  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 69 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 212205 AND league_id = 69 AND action = 18
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 212205 AND league_id = 69 AND action = 19
0.0020  SELECT e.* FROM `events2007` e WHERE e.player_id = 212205 AND league_id = 368 ORDER BY e.date ASC
0.0037  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 368 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 212205 AND league_id = 368 AND action = 18
0.0018  SELECT action,minute FROM events2007 WHERE player_id = 212205 AND league_id = 368 AND action = 19
0.0020  SELECT e.* FROM `events2006` e WHERE e.player_id = 212205 AND league_id = 369 ORDER BY e.date ASC
0.0035  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 369 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 212205 AND league_id = 369 AND action = 18
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 212205 AND league_id = 369 AND action = 19
0.0020  SELECT e.* FROM `events2005` e WHERE e.player_id = 212205 AND league_id = 370 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 = 370 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 212205 AND league_id = 370 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 212205 AND league_id = 370 AND action = 19
0.0020  SELECT e.* FROM `events2004` e WHERE e.player_id = 212205 AND league_id = 371 ORDER BY e.date ASC
0.0061  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 371 AND rel.player_id=212205
0.0021  SELECT action,minute FROM events2004 WHERE player_id = 212205 AND league_id = 371 AND action = 18
0.0018  SELECT action,minute FROM events2004 WHERE player_id = 212205 AND league_id = 371 AND action = 19
0.0021  SELECT e.* FROM `events2004` e WHERE e.player_id = 212205 AND league_id = 10978 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 = 10978 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2004 WHERE player_id = 212205 AND league_id = 10978 AND action = 18
0.0018  SELECT action,minute FROM events2004 WHERE player_id = 212205 AND league_id = 10978 AND action = 19
0.0018  SELECT e.* FROM `events2004` e WHERE e.player_id = 212205 AND league_id = 42358 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 = 42358 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2004 WHERE player_id = 212205 AND league_id = 42358 AND action = 18
0.0019  SELECT action,minute FROM events2004 WHERE player_id = 212205 AND league_id = 42358 AND action = 19
0.0020  SELECT e.* FROM `events2003` e WHERE e.player_id = 212205 AND league_id = 372 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 = 372 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 212205 AND league_id = 372 AND action = 18
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 212205 AND league_id = 372 AND action = 19
0.0018  SELECT e.* FROM `events2003` e WHERE e.player_id = 212205 AND league_id = 10977 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 = 10977 AND rel.player_id=212205
0.0021  SELECT action,minute FROM events2003 WHERE player_id = 212205 AND league_id = 10977 AND action = 18
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 212205 AND league_id = 10977 AND action = 19
0.0018  SELECT e.* FROM `events2003` e WHERE e.player_id = 212205 AND league_id = 40743 ORDER BY e.date ASC
0.0041  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 40743 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 212205 AND league_id = 40743 AND action = 18
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 212205 AND league_id = 40743 AND action = 19
0.0019  SELECT e.* FROM `events2003` e WHERE e.player_id = 212205 AND league_id = 40745 ORDER BY e.date ASC
0.0040  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 40745 AND rel.player_id=212205
0.0020  SELECT action,minute FROM events2003 WHERE player_id = 212205 AND league_id = 40745 AND action = 18
0.0017  SELECT action,minute FROM events2003 WHERE player_id = 212205 AND league_id = 40745 AND action = 19
0.0019  SELECT e.* FROM `events2002` e WHERE e.player_id = 212205 AND league_id = 373 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 = 373 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2002 WHERE player_id = 212205 AND league_id = 373 AND action = 18
0.0019  SELECT action,minute FROM events2002 WHERE player_id = 212205 AND league_id = 373 AND action = 19
0.0020  SELECT e.* FROM `events2002` e WHERE e.player_id = 212205 AND league_id = 56956 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 = 56956 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2002 WHERE player_id = 212205 AND league_id = 56956 AND action = 18
0.0018  SELECT action,minute FROM events2002 WHERE player_id = 212205 AND league_id = 56956 AND action = 19
0.0021  SELECT e.* FROM `events2002` e WHERE e.player_id = 212205 AND league_id = 62755 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 = 62755 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2002 WHERE player_id = 212205 AND league_id = 62755 AND action = 18
0.0021  SELECT action,minute FROM events2002 WHERE player_id = 212205 AND league_id = 62755 AND action = 19
0.0022  SELECT e.* FROM `events2001` e WHERE e.player_id = 212205 AND league_id = 374 ORDER BY e.date ASC
0.0128  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 374 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 374 AND action = 18
0.0019  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 374 AND action = 19
0.0020  SELECT e.* FROM `events2001` e WHERE e.player_id = 212205 AND league_id = 40764 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 = 40764 AND rel.player_id=212205
0.0021  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 40764 AND action = 18
0.0019  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 40764 AND action = 19
0.0019  SELECT e.* FROM `events2001` e WHERE e.player_id = 212205 AND league_id = 57821 ORDER BY e.date ASC
0.0045  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 57821 AND rel.player_id=212205
0.0019  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 57821 AND action = 18
0.0019  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 57821 AND action = 19
0.0019  SELECT e.* FROM `events2001` e WHERE e.player_id = 212205 AND league_id = 58508 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 = 58508 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 58508 AND action = 18
0.0019  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 58508 AND action = 19
0.0019  SELECT e.* FROM `events2001` e WHERE e.player_id = 212205 AND league_id = 75854 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 = 75854 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 75854 AND action = 18
0.0019  SELECT action,minute FROM events2001 WHERE player_id = 212205 AND league_id = 75854 AND action = 19
0.0019  SELECT e.* FROM `events1998` e WHERE e.player_id = 212205 AND league_id = 37820 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 = 37820 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events1998 WHERE player_id = 212205 AND league_id = 37820 AND action = 18
0.0018  SELECT action,minute FROM events1998 WHERE player_id = 212205 AND league_id = 37820 AND action = 19
0.0018  SELECT e.* FROM `events1998` e WHERE e.player_id = 212205 AND league_id = 37821 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 = 37821 AND rel.player_id=212205
0.0018  SELECT action,minute FROM events1998 WHERE player_id = 212205 AND league_id = 37821 AND action = 18
0.0018  SELECT action,minute FROM events1998 WHERE player_id = 212205 AND league_id = 37821 AND action = 19