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

H. Worley

Jugador del Stevenage
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de H. Worley
Nacionalidad
Inglaterra
Nombre
Harry Worley
Edad
35 Años (25-11-1988)
Altura
193
Peso
84 kilogramos
Equipo
Stevenage
Posición
Defensa
Liga
League Two 2017
Compañeros de equipo

No hay comentarios


  USO DE MEMORIA  
8,886,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Player / Index )  0.5053
Total Execution Time  0.5066
  CADENA URL  
/jugador/h-worley-47098
  GET DATOS  
$_GET['/jugador/h-worley-47098']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (170)  
0.0004   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` = '47098'
0.0027  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'h-worley-47098' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0129  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 = 'h-worley-47098' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
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 = 33911
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 = 34032
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 = 15150
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 = 24387
0.0022  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 13708
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 = 2439
0.0022  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 24412
0.0022  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1918
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 = 24416
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 = 1318
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 = 20549
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 = 24421
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 = 1040
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 = 443
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 = 12730
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 = 156
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 = 476
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 = 12813
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 = 477
0.0017  SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '47098'
0.0071  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 = 30629 AND rp.teamId = 2859 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0025  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 = 47098 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 = '47098' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 47098 AND league_id = 30629 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 = 30629 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 30629 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 30629 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 47098 AND league_id = 33911 ORDER BY e.date ASC
0.0030  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33911 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 33911 AND action = 18
0.0017  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 33911 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 47098 AND league_id = 30386 ORDER BY e.date ASC
0.0030  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30386 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 30386 AND action = 18
0.0017  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 30386 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 47098 AND league_id = 33348 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 = 33348 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 33348 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 33348 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 47098 AND league_id = 33979 ORDER BY e.date ASC
0.0029  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33979 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 33979 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 33979 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 47098 AND league_id = 34032 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 = 34032 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 34032 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 47098 AND league_id = 34032 AND action = 19
0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 47098 AND league_id = 15150 ORDER BY e.date ASC
0.0028  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15150 AND rel.player_id=47098
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 15150 AND action = 18
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 15150 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 47098 AND league_id = 15425 ORDER BY e.date ASC
0.0029  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15425 AND rel.player_id=47098
0.0025  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 15425 AND action = 18
0.0020  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 15425 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 47098 AND league_id = 16245 ORDER BY e.date ASC
0.0032  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16245 AND rel.player_id=47098
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 16245 AND action = 18
0.0020  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 16245 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 47098 AND league_id = 16427 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 = 16427 AND rel.player_id=47098
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 16427 AND action = 18
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 16427 AND action = 19
0.0019  SELECT e.* FROM `events2016` e WHERE e.player_id = 47098 AND league_id = 24387 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 = 24387 AND rel.player_id=47098
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 24387 AND action = 18
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 47098 AND league_id = 24387 AND action = 19
0.0021  SELECT e.* FROM `events2015` e WHERE e.player_id = 47098 AND league_id = 3889 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 = 3889 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 3889 AND action = 18
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 3889 AND action = 19
0.0018  SELECT e.* FROM `events2015` e WHERE e.player_id = 47098 AND league_id = 3804 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 = 3804 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 3804 AND action = 18
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 3804 AND action = 19
0.0019  SELECT e.* FROM `events2015` e WHERE e.player_id = 47098 AND league_id = 4028 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 = 4028 AND rel.player_id=47098
0.0022  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 4028 AND action = 18
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 4028 AND action = 19
0.0018  SELECT e.* FROM `events2015` e WHERE e.player_id = 47098 AND league_id = 4393 ORDER BY e.date ASC
0.0049  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4393 AND rel.player_id=47098
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 4393 AND action = 18
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 4393 AND action = 19
0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 47098 AND league_id = 13708 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 = 13708 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 13708 AND action = 18
0.0024  SELECT action,minute FROM events2015 WHERE player_id = 47098 AND league_id = 13708 AND action = 19
0.0028  SELECT e.* FROM `events2014` e WHERE e.player_id = 47098 AND league_id = 2439 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 = 2439 AND rel.player_id=47098
0.0027  SELECT action,minute FROM events2014 WHERE player_id = 47098 AND league_id = 2439 AND action = 18
0.0024  SELECT action,minute FROM events2014 WHERE player_id = 47098 AND league_id = 2439 AND action = 19
0.0021  SELECT e.* FROM `events2014` e WHERE e.player_id = 47098 AND league_id = 2511 ORDER BY e.date ASC
0.0049  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2511 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2014 WHERE player_id = 47098 AND league_id = 2511 AND action = 18
0.0021  SELECT action,minute FROM events2014 WHERE player_id = 47098 AND league_id = 2511 AND action = 19
0.0019  SELECT e.* FROM `events2014` e WHERE e.player_id = 47098 AND league_id = 3321 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 = 3321 AND rel.player_id=47098
0.0024  SELECT action,minute FROM events2014 WHERE player_id = 47098 AND league_id = 3321 AND action = 18
0.0023  SELECT action,minute FROM events2014 WHERE player_id = 47098 AND league_id = 3321 AND action = 19
0.0019  SELECT e.* FROM `events2014` e WHERE e.player_id = 47098 AND league_id = 24412 ORDER BY e.date ASC
0.0031  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 24412 AND rel.player_id=47098
0.0021  SELECT action,minute FROM events2014 WHERE player_id = 47098 AND league_id = 24412 AND action = 18
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 47098 AND league_id = 24412 AND action = 19
0.0020  SELECT e.* FROM `events2013` e WHERE e.player_id = 47098 AND league_id = 1918 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 = 1918 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2013 WHERE player_id = 47098 AND league_id = 1918 AND action = 18
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 47098 AND league_id = 1918 AND action = 19
0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 47098 AND league_id = 2013 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 = 2013 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 47098 AND league_id = 2013 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 47098 AND league_id = 2013 AND action = 19
0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 47098 AND league_id = 24416 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 = 24416 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2013 WHERE player_id = 47098 AND league_id = 24416 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 47098 AND league_id = 24416 AND action = 19
0.0019  SELECT e.* FROM `events2012` e WHERE e.player_id = 47098 AND league_id = 1318 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 = 1318 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 47098 AND league_id = 1318 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 47098 AND league_id = 1318 AND action = 19
0.0018  SELECT e.* FROM `events2012` e WHERE e.player_id = 47098 AND league_id = 13879 ORDER BY e.date ASC
0.0027  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 13879 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2012 WHERE player_id = 47098 AND league_id = 13879 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 47098 AND league_id = 13879 AND action = 19
0.0019  SELECT e.* FROM `events2012` e WHERE e.player_id = 47098 AND league_id = 20549 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 = 20549 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2012 WHERE player_id = 47098 AND league_id = 20549 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 47098 AND league_id = 20549 AND action = 19
0.0019  SELECT e.* FROM `events2012` e WHERE e.player_id = 47098 AND league_id = 24421 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 = 24421 AND rel.player_id=47098
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 47098 AND league_id = 24421 AND action = 18
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 47098 AND league_id = 24421 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 47098 AND league_id = 14433 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 = 14433 AND rel.player_id=47098
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 47098 AND league_id = 14433 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 47098 AND league_id = 14433 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 47098 AND league_id = 20548 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 = 20548 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 47098 AND league_id = 20548 AND action = 18
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 47098 AND league_id = 20548 AND action = 19
0.0020  SELECT e.* FROM `events2010` e WHERE e.player_id = 47098 AND league_id = 1040 ORDER BY e.date ASC
0.0030  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1040 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 47098 AND league_id = 1040 AND action = 18
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 47098 AND league_id = 1040 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 47098 AND league_id = 443 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 = 443 AND rel.player_id=47098
0.0019  SELECT action,minute FROM events2009 WHERE player_id = 47098 AND league_id = 443 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 47098 AND league_id = 443 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 47098 AND league_id = 12730 ORDER BY e.date ASC
0.0031  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 12730 AND rel.player_id=47098
0.0020  SELECT action,minute FROM events2009 WHERE player_id = 47098 AND league_id = 12730 AND action = 18
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 47098 AND league_id = 12730 AND action = 19
0.0019  SELECT e.* FROM `events2008` e WHERE e.player_id = 47098 AND league_id = 156 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 = 156 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 47098 AND league_id = 156 AND action = 18
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 47098 AND league_id = 156 AND action = 19
0.0018  SELECT e.* FROM `events2008` e WHERE e.player_id = 47098 AND league_id = 476 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 = 476 AND rel.player_id=47098
0.0018  SELECT action,minute FROM events2008 WHERE player_id = 47098 AND league_id = 476 AND action = 18
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 47098 AND league_id = 476 AND action = 19
0.0018  SELECT e.* FROM `events2008` e WHERE e.player_id = 47098 AND league_id = 12813 ORDER BY e.date ASC
0.0020  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 12813 AND rel.player_id=47098
0.0019  SELECT action,minute FROM events2008 WHERE player_id = 47098 AND league_id = 12813 AND action = 18
0.0022  SELECT action,minute FROM events2008 WHERE player_id = 47098 AND league_id = 12813 AND action = 19
0.0020  SELECT e.* FROM `events2007` e WHERE e.player_id = 47098 AND league_id = 477 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 = 477 AND rel.player_id=47098
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 47098 AND league_id = 477 AND action = 18
0.0019  SELECT action,minute FROM events2007 WHERE player_id = 47098 AND league_id = 477 AND action = 19