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
0 Comentarios

No hay comentarios


  USO DE MEMORIA  
9,601,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Player / Index )  0.6101
Total Execution Time  0.6114
  CADENA URL  
/jugador/j-arvidsson-217149
  GET DATOS  
$_GET['/jugador/j-arvidsson-217149']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (193)  
0.0025   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.0029  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.0208  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.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 = 57296
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 = 53459
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 = 60292
0.0030  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 = 48539
0.0030  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.0030  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.0032  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.0036  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.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 = 28082
0.0038  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.0038  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.0036  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.0038  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.0043  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.0048  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.0042  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.0043  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.0045  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.0048  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.0041  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.0042  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.0034  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.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 = 1089
0.0030  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.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 = 21116
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 = 10197
0.0031  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.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 = 688
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 = 39583
0.0019  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.0180  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.0022  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.0021  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.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '217149' and rp.type = 3
0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 217149 AND league_id = 56547 ORDER BY e.date ASC
0.0065  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.0018  SELECT action,minute FROM events2021 WHERE player_id = 217149 AND league_id = 56547 AND action = 18
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 217149 AND league_id = 56547 AND action = 19
0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 217149 AND league_id = 57296 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 = 57296 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 217149 AND league_id = 57296 AND action = 18
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 217149 AND league_id = 57296 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 217149 AND league_id = 55396 ORDER BY e.date ASC
0.0038  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 55396 AND rel.player_id=217149
0.0021  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 55396 AND action = 18
0.0021  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 55396 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 217149 AND league_id = 53459 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 = 53459 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 53459 AND action = 18
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 53459 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 217149 AND league_id = 60292 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 = 60292 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 60292 AND action = 18
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 217149 AND league_id = 60292 AND action = 19
0.0019  SELECT e.* FROM `events2019` e WHERE e.player_id = 217149 AND league_id = 48539 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 = 48539 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 48539 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 48539 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 217149 AND league_id = 43475 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 = 43475 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 43475 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 43475 AND action = 19
0.0019  SELECT e.* FROM `events2019` e WHERE e.player_id = 217149 AND league_id = 48475 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 = 48475 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 48475 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 217149 AND league_id = 48475 AND action = 19
0.0020  SELECT e.* FROM `events2018` e WHERE e.player_id = 217149 AND league_id = 42069 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 = 42069 AND rel.player_id=217149
0.0021  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 42069 AND action = 18
0.0020  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 42069 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 217149 AND league_id = 38427 ORDER BY e.date ASC
0.0044  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38427 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 38427 AND action = 18
0.0019  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 38427 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 217149 AND league_id = 41836 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 = 41836 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 41836 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 217149 AND league_id = 41836 AND action = 19
0.0020  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 37608 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 = 37608 AND rel.player_id=217149
0.0021  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37608 AND action = 18
0.0020  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37608 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 37670 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 = 37670 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37670 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37670 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 28082 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 = 28082 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 28082 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 28082 AND action = 19
0.0019  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 30386 ORDER BY e.date ASC
0.0038  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30386 AND rel.player_id=217149
0.0019  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 30386 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 30386 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 217149 AND league_id = 37463 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 = 37463 AND rel.player_id=217149
0.0019  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37463 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 217149 AND league_id = 37463 AND action = 19
0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 217149 AND league_id = 20091 ORDER BY e.date ASC
0.0078  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20091 AND rel.player_id=217149
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20091 AND action = 18
0.0020  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20091 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 217149 AND league_id = 20197 ORDER BY e.date ASC
0.0044  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20197 AND rel.player_id=217149
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20197 AND action = 18
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20197 AND action = 19
0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 217149 AND league_id = 20315 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 = 20315 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20315 AND action = 18
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 20315 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 217149 AND league_id = 23324 ORDER BY e.date ASC
0.0071  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.0019  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 23324 AND action = 18
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 217149 AND league_id = 23324 AND action = 19
0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 217149 AND league_id = 9130 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 = 9130 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9130 AND action = 18
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9130 AND action = 19
0.0019  SELECT e.* FROM `events2015` e WHERE e.player_id = 217149 AND league_id = 9516 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 = 9516 AND rel.player_id=217149
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9516 AND action = 18
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9516 AND action = 19
0.0019  SELECT e.* FROM `events2015` e WHERE e.player_id = 217149 AND league_id = 3804 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 = 3804 AND rel.player_id=217149
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 3804 AND action = 18
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 3804 AND action = 19
0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 217149 AND league_id = 9245 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 = 9245 AND rel.player_id=217149
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9245 AND action = 18
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 217149 AND league_id = 9245 AND action = 19
0.0022  SELECT e.* FROM `events2014` e WHERE e.player_id = 217149 AND league_id = 3641 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 = 3641 AND rel.player_id=217149
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 217149 AND league_id = 3641 AND action = 18
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 217149 AND league_id = 3641 AND action = 19
0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 217149 AND league_id = 2326 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 = 2326 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 217149 AND league_id = 2326 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 217149 AND league_id = 2326 AND action = 19
0.0018  SELECT e.* FROM `events2013` e WHERE e.player_id = 217149 AND league_id = 21119 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 = 21119 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 217149 AND league_id = 21119 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 217149 AND league_id = 21119 AND action = 19
0.0019  SELECT e.* FROM `events2012` e WHERE e.player_id = 217149 AND league_id = 1554 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 = 1554 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 217149 AND league_id = 1554 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 217149 AND league_id = 1554 AND action = 19
0.0021  SELECT e.* FROM `events2011` e WHERE e.player_id = 217149 AND league_id = 10192 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 = 10192 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 217149 AND league_id = 10192 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 217149 AND league_id = 10192 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 217149 AND league_id = 21118 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 = 21118 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 217149 AND league_id = 21118 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 217149 AND league_id = 21118 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 217149 AND league_id = 1089 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 = 1089 AND rel.player_id=217149
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 217149 AND league_id = 1089 AND action = 18
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 217149 AND league_id = 1089 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 217149 AND league_id = 10196 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 = 10196 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 217149 AND league_id = 10196 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 217149 AND league_id = 10196 AND action = 19
0.0018  SELECT e.* FROM `events2009` e WHERE e.player_id = 217149 AND league_id = 21116 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 = 21116 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 217149 AND league_id = 21116 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 217149 AND league_id = 21116 AND action = 19
0.0022  SELECT e.* FROM `events2008` e WHERE e.player_id = 217149 AND league_id = 10197 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 = 10197 AND rel.player_id=217149
0.0022  SELECT action,minute FROM events2008 WHERE player_id = 217149 AND league_id = 10197 AND action = 18
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 217149 AND league_id = 10197 AND action = 19
0.0019  SELECT e.* FROM `events2007` e WHERE e.player_id = 217149 AND league_id = 10199 ORDER BY e.date ASC
0.0039  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10199 AND rel.player_id=217149
0.0020  SELECT action,minute FROM events2007 WHERE player_id = 217149 AND league_id = 10199 AND action = 18
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 217149 AND league_id = 10199 AND action = 19
0.0019  SELECT e.* FROM `events2006` e WHERE e.player_id = 217149 AND league_id = 688 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 = 688 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 217149 AND league_id = 688 AND action = 18
0.0019  SELECT action,minute FROM events2006 WHERE player_id = 217149 AND league_id = 688 AND action = 19
0.0019  SELECT e.* FROM `events2006` e WHERE e.player_id = 217149 AND league_id = 39583 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 = 39583 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 217149 AND league_id = 39583 AND action = 18
0.0018  SELECT action,minute FROM events2006 WHERE player_id = 217149 AND league_id = 39583 AND action = 19
0.0019  SELECT e.* FROM `events2005` e WHERE e.player_id = 217149 AND league_id = 689 ORDER BY e.date ASC
0.0044  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 689 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 217149 AND league_id = 689 AND action = 18
0.0018  SELECT action,minute FROM events2005 WHERE player_id = 217149 AND league_id = 689 AND action = 19
0.0019  SELECT e.* FROM `events2003` e WHERE e.player_id = 217149 AND league_id = 691 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 = 691 AND rel.player_id=217149
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 217149 AND league_id = 691 AND action = 18
0.0018  SELECT action,minute FROM events2003 WHERE player_id = 217149 AND league_id = 691 AND action = 19