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

J. Arvidsson

Jugador del Brommapojkarna
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de J. Arvidsson
Nacionalidad
Suecia
Nombre
John Jesper Arvidsson
Edad
35 Años
Altura
181
Peso
74 kilogramos
Equipo
Brommapojkarna
Posición
Defensa
Liga
Partidos Amistosos 2021
Compañeros de equipo
Fotos
4
  • Foto principal de J. Arvidsson | Sirius
  • Foto principal de J. Arvidsson | Valerenga IF Oslo
  • Foto principal de J. Arvidsson | Djurgårdens
  • Foto principal de J. Arvidsson | Djurgårdens

No hay comentarios


  USO DE MEMORIA  
9,595,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Player / Index )  2.7975
Total Execution Time  2.7994
  CADENA URL  
/jugador/j-arvidsson-217149
  GET DATOS  
$_GET['/jugador/j-arvidsson-217149']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (195)  
0.0005   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` = '217149'
0.0134  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 = 'j-arvidsson-217149' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0337  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 = 'j-arvidsson-217149' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0132  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 = 55396
0.0131  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 = 60292
0.0133  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 = 48475
0.0132  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 = 42069
0.0132  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 = 41836
0.0142  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 = 37608
0.0131  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 = 37670
0.0133  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 = 28082
0.0131  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 = 37463
0.0133  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 = 20091
0.0131  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 = 20197
0.0134  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 = 20315
0.0131  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 = 23324
0.0138  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 = 9130
0.0132  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.0131  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 = 9245
0.0133  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.0132  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.0132  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 = 21119
0.0132  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.0133  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 = 10192
0.0130  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 = 21118
0.0131  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 = 1089
0.0146  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 = 10196
0.0131  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 = 21116
0.0131  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 = 10197
0.0131  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 = 10199
0.0132  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 = 688
0.0133  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 = 39583
0.0132  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 = 689
0.0132  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 = 691
0.0125  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 = '217149'
0.0265  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 = 56547 AND rp.teamId = 3051 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0131  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 = 217149 ORDER BY rp.year DESC
0.0129  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 = '217149' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '217149' and rp.type = 3
0.0130  SELECT e.* FROM `events2021` e WHERE e.player_id = 217149 AND league_id = 56547 ORDER BY e.date ASC
0.0170  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 56547 AND rel.player_id=217149
0.0129  SELECT action,minute FROM events2021 WHERE player_id = 217149 AND league_id = 56547 AND action = 18
0.0131  SELECT action,minute FROM events2021 WHERE player_id = 217149 AND league_id = 56547 AND action = 19
0.0129  SELECT e.* FROM `events2021` e WHERE e.player_id = 217149 AND league_id = 57296 ORDER BY e.date ASC
0.0176  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 57296 AND rel.player_id=217149
0.0139  SELECT action,minute FROM events2021 WHERE player_id = 217149 AND league_id = 57296 AND action = 18
0.0126  SELECT action,minute FROM events2021 WHERE player_id = 217149 AND league_id = 57296 AND action = 19
0.0126  SELECT e.* FROM `events2020` e WHERE e.player_id = 217149 AND league_id = 55396 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 = 55396 AND rel.player_id=217149
0.0131  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 55396 AND action = 18
0.0128  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 55396 AND action = 19
0.0126  SELECT e.* FROM `events2020` e WHERE e.player_id = 217149 AND league_id = 53459 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 = 53459 AND rel.player_id=217149
0.0126  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 53459 AND action = 18
0.0126  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 53459 AND action = 19
0.0133  SELECT e.* FROM `events2020` e WHERE e.player_id = 217149 AND league_id = 60292 ORDER BY e.date ASC
0.0133  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 60292 AND rel.player_id=217149
0.0131  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 60292 AND action = 18
0.0130  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 60292 AND action = 19
0.0128  SELECT e.* FROM `events2019` e WHERE e.player_id = 217149 AND league_id = 48539 ORDER BY e.date ASC
0.0148  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48539 AND rel.player_id=217149
0.0126  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 48539 AND action = 18
0.0126  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 48539 AND action = 19
0.0126  SELECT e.* FROM `events2019` e WHERE e.player_id = 217149 AND league_id = 43475 ORDER BY e.date ASC
0.0143  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43475 AND rel.player_id=217149
0.0127  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 43475 AND action = 18
0.0126  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 43475 AND action = 19
0.0126  SELECT e.* FROM `events2019` e WHERE e.player_id = 217149 AND league_id = 48475 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 = 48475 AND rel.player_id=217149
0.0129  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 48475 AND action = 18
0.0125  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 48475 AND action = 19
0.0127  SELECT e.* FROM `events2018` e WHERE e.player_id = 217149 AND league_id = 42069 ORDER BY e.date ASC
0.0140  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42069 AND rel.player_id=217149
0.0128  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 42069 AND action = 18
0.0128  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 42069 AND action = 19
0.0127  SELECT e.* FROM `events2018` e WHERE e.player_id = 217149 AND league_id = 38427 ORDER BY e.date ASC
0.0140  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=217149
0.0126  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 38427 AND action = 18
0.0126  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 38427 AND action = 19
0.0126  SELECT e.* FROM `events2018` e WHERE e.player_id = 217149 AND league_id = 41836 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 = 41836 AND rel.player_id=217149
0.0126  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 41836 AND action = 18
0.0126  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 41836 AND action = 19
0.0127  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 37608 ORDER BY e.date ASC
0.0158  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37608 AND rel.player_id=217149
0.0129  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37608 AND action = 18
0.0128  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37608 AND action = 19
0.0125  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 37670 ORDER BY e.date ASC
0.0181  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37670 AND rel.player_id=217149
0.0126  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37670 AND action = 18
0.0158  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37670 AND action = 19
0.0126  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 28082 ORDER BY e.date ASC
0.0134  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 28082 AND rel.player_id=217149
0.0125  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 28082 AND action = 18
0.0125  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 28082 AND action = 19
0.0142  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 30386 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30386 AND rel.player_id=217149
0.0126  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 30386 AND action = 18
0.0126  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 30386 AND action = 19
0.0125  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 37463 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 = 37463 AND rel.player_id=217149
0.0147  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37463 AND action = 18
0.0126  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37463 AND action = 19
0.0128  SELECT e.* FROM `events2016` e WHERE e.player_id = 217149 AND league_id = 20091 ORDER BY e.date ASC
0.0172  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20091 AND rel.player_id=217149
0.0127  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20091 AND action = 18
0.0127  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20091 AND action = 19
0.0128  SELECT e.* FROM `events2016` e WHERE e.player_id = 217149 AND league_id = 20197 ORDER BY e.date ASC
0.0144  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20197 AND rel.player_id=217149
0.0182  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20197 AND action = 18
0.0133  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20197 AND action = 19
0.0126  SELECT e.* FROM `events2016` e WHERE e.player_id = 217149 AND league_id = 20315 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 = 20315 AND rel.player_id=217149
0.0126  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20315 AND action = 18
0.0126  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20315 AND action = 19
0.0129  SELECT e.* FROM `events2016` e WHERE e.player_id = 217149 AND league_id = 23324 ORDER BY e.date ASC
0.0138  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 23324 AND rel.player_id=217149
0.0126  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 23324 AND action = 18
0.0126  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 23324 AND action = 19
0.0128  SELECT e.* FROM `events2015` e WHERE e.player_id = 217149 AND league_id = 9130 ORDER BY e.date ASC
0.0139  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9130 AND rel.player_id=217149
0.0127  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9130 AND action = 18
0.0127  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9130 AND action = 19
0.0127  SELECT e.* FROM `events2015` e WHERE e.player_id = 217149 AND league_id = 9516 ORDER BY e.date ASC
0.0157  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=217149
0.0126  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9516 AND action = 18
0.0127  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9516 AND action = 19
0.0126  SELECT e.* FROM `events2015` e WHERE e.player_id = 217149 AND league_id = 3804 ORDER BY e.date ASC
0.0129  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=217149
0.0127  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 3804 AND action = 18
0.0127  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 3804 AND action = 19
0.0128  SELECT e.* FROM `events2015` e WHERE e.player_id = 217149 AND league_id = 9245 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 = 9245 AND rel.player_id=217149
0.0128  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9245 AND action = 18
0.0128  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9245 AND action = 19
0.0133  SELECT e.* FROM `events2014` e WHERE e.player_id = 217149 AND league_id = 3641 ORDER BY e.date ASC
0.0353  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=217149
0.0133  SELECT action,minute FROM events2014 WHERE player_id = 217149 AND league_id = 3641 AND action = 18
0.0128  SELECT action,minute FROM events2014 WHERE player_id = 217149 AND league_id = 3641 AND action = 19
0.0126  SELECT e.* FROM `events2013` e WHERE e.player_id = 217149 AND league_id = 2326 ORDER BY e.date ASC
0.0144  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=217149
0.0126  SELECT action,minute FROM events2013 WHERE player_id = 217149 AND league_id = 2326 AND action = 18
0.0127  SELECT action,minute FROM events2013 WHERE player_id = 217149 AND league_id = 2326 AND action = 19
0.0133  SELECT e.* FROM `events2013` e WHERE e.player_id = 217149 AND league_id = 21119 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 = 21119 AND rel.player_id=217149
0.0133  SELECT action,minute FROM events2013 WHERE player_id = 217149 AND league_id = 21119 AND action = 18
0.0129  SELECT action,minute FROM events2013 WHERE player_id = 217149 AND league_id = 21119 AND action = 19
0.0130  SELECT e.* FROM `events2012` e WHERE e.player_id = 217149 AND league_id = 1554 ORDER BY e.date ASC
0.0159  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1554 AND rel.player_id=217149
0.0137  SELECT action,minute FROM events2012 WHERE player_id = 217149 AND league_id = 1554 AND action = 18
0.0128  SELECT action,minute FROM events2012 WHERE player_id = 217149 AND league_id = 1554 AND action = 19
0.0131  SELECT e.* FROM `events2011` e WHERE e.player_id = 217149 AND league_id = 10192 ORDER BY e.date ASC
0.0174  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10192 AND rel.player_id=217149
0.0129  SELECT action,minute FROM events2011 WHERE player_id = 217149 AND league_id = 10192 AND action = 18
0.0127  SELECT action,minute FROM events2011 WHERE player_id = 217149 AND league_id = 10192 AND action = 19
0.0127  SELECT e.* FROM `events2011` e WHERE e.player_id = 217149 AND league_id = 21118 ORDER BY e.date ASC
0.0151  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 21118 AND rel.player_id=217149
0.0127  SELECT action,minute FROM events2011 WHERE player_id = 217149 AND league_id = 21118 AND action = 18
0.0126  SELECT action,minute FROM events2011 WHERE player_id = 217149 AND league_id = 21118 AND action = 19
0.0130  SELECT e.* FROM `events2010` e WHERE e.player_id = 217149 AND league_id = 1089 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1089 AND rel.player_id=217149
0.0125  SELECT action,minute FROM events2010 WHERE player_id = 217149 AND league_id = 1089 AND action = 18
0.0130  SELECT action,minute FROM events2010 WHERE player_id = 217149 AND league_id = 1089 AND action = 19
0.0130  SELECT e.* FROM `events2009` e WHERE e.player_id = 217149 AND league_id = 10196 ORDER BY e.date ASC
0.0199  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10196 AND rel.player_id=217149
0.0135  SELECT action,minute FROM events2009 WHERE player_id = 217149 AND league_id = 10196 AND action = 18
0.0127  SELECT action,minute FROM events2009 WHERE player_id = 217149 AND league_id = 10196 AND action = 19
0.0128  SELECT e.* FROM `events2009` e WHERE e.player_id = 217149 AND league_id = 21116 ORDER BY e.date ASC
0.0130  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 21116 AND rel.player_id=217149
0.0126  SELECT action,minute FROM events2009 WHERE player_id = 217149 AND league_id = 21116 AND action = 18
0.0125  SELECT action,minute FROM events2009 WHERE player_id = 217149 AND league_id = 21116 AND action = 19
0.0126  SELECT e.* FROM `events2008` e WHERE e.player_id = 217149 AND league_id = 10197 ORDER BY e.date ASC
0.0140  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10197 AND rel.player_id=217149
0.0125  SELECT action,minute FROM events2008 WHERE player_id = 217149 AND league_id = 10197 AND action = 18
0.0125  SELECT action,minute FROM events2008 WHERE player_id = 217149 AND league_id = 10197 AND action = 19
0.0125  SELECT e.* FROM `events2007` e WHERE e.player_id = 217149 AND league_id = 10199 ORDER BY e.date ASC
0.0133  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10199 AND rel.player_id=217149
0.0125  SELECT action,minute FROM events2007 WHERE player_id = 217149 AND league_id = 10199 AND action = 18
0.0126  SELECT action,minute FROM events2007 WHERE player_id = 217149 AND league_id = 10199 AND action = 19
0.0126  SELECT e.* FROM `events2006` e WHERE e.player_id = 217149 AND league_id = 688 ORDER BY e.date ASC
0.0144  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 688 AND rel.player_id=217149
0.0125  SELECT action,minute FROM events2006 WHERE player_id = 217149 AND league_id = 688 AND action = 18
0.0126  SELECT action,minute FROM events2006 WHERE player_id = 217149 AND league_id = 688 AND action = 19
0.0126  SELECT e.* FROM `events2006` e WHERE e.player_id = 217149 AND league_id = 39583 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 = 39583 AND rel.player_id=217149
0.0125  SELECT action,minute FROM events2006 WHERE player_id = 217149 AND league_id = 39583 AND action = 18
0.0125  SELECT action,minute FROM events2006 WHERE player_id = 217149 AND league_id = 39583 AND action = 19
0.0126  SELECT e.* FROM `events2005` e WHERE e.player_id = 217149 AND league_id = 689 ORDER BY e.date ASC
0.0188  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 689 AND rel.player_id=217149
0.0125  SELECT action,minute FROM events2005 WHERE player_id = 217149 AND league_id = 689 AND action = 18
0.0125  SELECT action,minute FROM events2005 WHERE player_id = 217149 AND league_id = 689 AND action = 19
0.0125  SELECT e.* FROM `events2003` e WHERE e.player_id = 217149 AND league_id = 691 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 = 691 AND rel.player_id=217149
0.0126  SELECT action,minute FROM events2003 WHERE player_id = 217149 AND league_id = 691 AND action = 18
0.0125  SELECT action,minute FROM events2003 WHERE player_id = 217149 AND league_id = 691 AND action = 19