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

Adam Bartlett

Jugador del York City
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Adam Bartlett
Nacionalidad
Inglaterra
Nombre
Adam Bartlett
Edad
38 Años (26-02-1986)
Altura
183
Peso
74 kilogramos
Equipo
York City
Posición
Portero
Liga
Partidos Amistosos 2020
Compañeros de equipo

No hay comentarios


  USO DE MEMORIA  
8,504,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Player / Index )  1.2760
Total Execution Time  1.2783
  CADENA URL  
/jugador/adam-bartlett-209778
  GET DATOS  
$_GET['/jugador/adam-bartlett-209778']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (174)  
0.0013   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` = '209778'
0.0028  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 = 'adam-bartlett-209778' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0153  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 = 'adam-bartlett-209778' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0139  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 = 44237
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 = 33911
0.0081  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.0060  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.0068  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 = 4393
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 = 2502
0.0078  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 = 2511
0.0120  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 = 3778
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 = 2010
0.0066  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.0096  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.0035  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.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 = 1073
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 = 14433
0.0050  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 = 20548
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 = 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 = 984
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.0071  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 = 58653
0.0057  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 = '209778'
0.0190  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 = 49506 AND rp.teamId = 5490 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0076  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 = 209778 ORDER BY rp.year DESC
0.0055  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 = '209778' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0060  SELECT e.* FROM `events2020` e WHERE e.player_id = 209778 AND league_id = 49506 ORDER BY e.date ASC
0.0089  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49506 AND rel.player_id=209778
0.0067  SELECT action,minute FROM events2020 WHERE player_id = 209778 AND league_id = 49506 AND action = 18
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 209778 AND league_id = 49506 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 209778 AND league_id = 44237 ORDER BY e.date ASC
0.0119  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44237 AND rel.player_id=209778
0.0063  SELECT action,minute FROM events2019 WHERE player_id = 209778 AND league_id = 44237 AND action = 18
0.0046  SELECT action,minute FROM events2019 WHERE player_id = 209778 AND league_id = 44237 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 209778 AND league_id = 43475 ORDER BY e.date ASC
0.0105  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=209778
0.0019  SELECT action,minute FROM events2019 WHERE player_id = 209778 AND league_id = 43475 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 209778 AND league_id = 43475 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 209778 AND league_id = 44547 ORDER BY e.date ASC
0.0149  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44547 AND rel.player_id=209778
0.0063  SELECT action,minute FROM events2019 WHERE player_id = 209778 AND league_id = 44547 AND action = 18
0.0019  SELECT action,minute FROM events2019 WHERE player_id = 209778 AND league_id = 44547 AND action = 19
0.0060  SELECT e.* FROM `events2019` e WHERE e.player_id = 209778 AND league_id = 44643 ORDER BY e.date ASC
0.0083  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44643 AND rel.player_id=209778
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 209778 AND league_id = 44643 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 209778 AND league_id = 44643 AND action = 19
0.0019  SELECT e.* FROM `events2018` e WHERE e.player_id = 209778 AND league_id = 38702 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 = 38702 AND rel.player_id=209778
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 209778 AND league_id = 38702 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 209778 AND league_id = 38702 AND action = 19
0.0055  SELECT e.* FROM `events2018` e WHERE e.player_id = 209778 AND league_id = 38704 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 = 38704 AND rel.player_id=209778
0.0060  SELECT action,minute FROM events2018 WHERE player_id = 209778 AND league_id = 38704 AND action = 18
0.0020  SELECT action,minute FROM events2018 WHERE player_id = 209778 AND league_id = 38704 AND action = 19
0.0054  SELECT e.* FROM `events2018` e WHERE e.player_id = 209778 AND league_id = 38427 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 = 38427 AND rel.player_id=209778
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 209778 AND league_id = 38427 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 209778 AND league_id = 38427 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 209778 AND league_id = 39016 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 = 39016 AND rel.player_id=209778
0.0019  SELECT action,minute FROM events2018 WHERE player_id = 209778 AND league_id = 39016 AND action = 18
0.0069  SELECT action,minute FROM events2018 WHERE player_id = 209778 AND league_id = 39016 AND action = 19
0.0021  SELECT e.* FROM `events2017` e WHERE e.player_id = 209778 AND league_id = 30629 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 = 30629 AND rel.player_id=209778
0.0020  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 30629 AND action = 18
0.0068  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 30629 AND action = 19
0.0019  SELECT e.* FROM `events2017` e WHERE e.player_id = 209778 AND league_id = 33911 ORDER BY e.date ASC
0.0058  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33911 AND rel.player_id=209778
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 33911 AND action = 18
0.0069  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 33911 AND action = 19
0.0055  SELECT e.* FROM `events2017` e WHERE e.player_id = 209778 AND league_id = 30386 ORDER BY e.date ASC
0.0073  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=209778
0.0047  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 30386 AND action = 18
0.0019  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 30386 AND action = 19
0.0076  SELECT e.* FROM `events2017` e WHERE e.player_id = 209778 AND league_id = 33348 ORDER BY e.date ASC
0.0109  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33348 AND rel.player_id=209778
0.0019  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 33348 AND action = 18
0.0065  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 33348 AND action = 19
0.0066  SELECT e.* FROM `events2017` e WHERE e.player_id = 209778 AND league_id = 33979 ORDER BY e.date ASC
0.0075  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=209778
0.0045  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 33979 AND action = 18
0.0032  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 33979 AND action = 19
0.0033  SELECT e.* FROM `events2017` e WHERE e.player_id = 209778 AND league_id = 34032 ORDER BY e.date ASC
0.0075  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=209778
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 34032 AND action = 18
0.0019  SELECT action,minute FROM events2017 WHERE player_id = 209778 AND league_id = 34032 AND action = 19
0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 209778 AND league_id = 15150 ORDER BY e.date ASC
0.0075  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=209778
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 15150 AND action = 18
0.0056  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 15150 AND action = 19
0.0145  SELECT e.* FROM `events2016` e WHERE e.player_id = 209778 AND league_id = 15425 ORDER BY e.date ASC
0.0123  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=209778
0.0062  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 15425 AND action = 18
0.0024  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 15425 AND action = 19
0.0062  SELECT e.* FROM `events2016` e WHERE e.player_id = 209778 AND league_id = 16245 ORDER BY e.date ASC
0.0075  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=209778
0.0045  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 16245 AND action = 18
0.0115  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 16245 AND action = 19
0.0051  SELECT e.* FROM `events2016` e WHERE e.player_id = 209778 AND league_id = 16427 ORDER BY e.date ASC
0.0177  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=209778
0.0069  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 16427 AND action = 18
0.0166  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 16427 AND action = 19
0.0056  SELECT e.* FROM `events2016` e WHERE e.player_id = 209778 AND league_id = 24387 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 = 24387 AND rel.player_id=209778
0.0059  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 24387 AND action = 18
0.0057  SELECT action,minute FROM events2016 WHERE player_id = 209778 AND league_id = 24387 AND action = 19
0.0032  SELECT e.* FROM `events2015` e WHERE e.player_id = 209778 AND league_id = 3890 ORDER BY e.date ASC
0.0206  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3890 AND rel.player_id=209778
0.0067  SELECT action,minute FROM events2015 WHERE player_id = 209778 AND league_id = 3890 AND action = 18
0.0046  SELECT action,minute FROM events2015 WHERE player_id = 209778 AND league_id = 3890 AND action = 19
0.0059  SELECT e.* FROM `events2015` e WHERE e.player_id = 209778 AND league_id = 4393 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 = 4393 AND rel.player_id=209778
0.0072  SELECT action,minute FROM events2015 WHERE player_id = 209778 AND league_id = 4393 AND action = 18
0.0023  SELECT action,minute FROM events2015 WHERE player_id = 209778 AND league_id = 4393 AND action = 19
0.0026  SELECT e.* FROM `events2014` e WHERE e.player_id = 209778 AND league_id = 2502 ORDER BY e.date ASC
0.0205  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2502 AND rel.player_id=209778
0.0051  SELECT action,minute FROM events2014 WHERE player_id = 209778 AND league_id = 2502 AND action = 18
0.0064  SELECT action,minute FROM events2014 WHERE player_id = 209778 AND league_id = 2502 AND action = 19
0.0080  SELECT e.* FROM `events2014` e WHERE e.player_id = 209778 AND league_id = 2511 ORDER BY e.date ASC
0.0228  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=209778
0.0027  SELECT action,minute FROM events2014 WHERE player_id = 209778 AND league_id = 2511 AND action = 18
0.0051  SELECT action,minute FROM events2014 WHERE player_id = 209778 AND league_id = 2511 AND action = 19
0.0090  SELECT e.* FROM `events2014` e WHERE e.player_id = 209778 AND league_id = 3778 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 = 3778 AND rel.player_id=209778
0.0058  SELECT action,minute FROM events2014 WHERE player_id = 209778 AND league_id = 3778 AND action = 18
0.0022  SELECT action,minute FROM events2014 WHERE player_id = 209778 AND league_id = 3778 AND action = 19
0.0061  SELECT e.* FROM `events2013` e WHERE e.player_id = 209778 AND league_id = 2010 ORDER BY e.date ASC
0.0184  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2010 AND rel.player_id=209778
0.0022  SELECT action,minute FROM events2013 WHERE player_id = 209778 AND league_id = 2010 AND action = 18
0.0020  SELECT action,minute FROM events2013 WHERE player_id = 209778 AND league_id = 2010 AND action = 19
0.0020  SELECT e.* FROM `events2012` e WHERE e.player_id = 209778 AND league_id = 1318 ORDER BY e.date ASC
0.0180  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=209778
0.0100  SELECT action,minute FROM events2012 WHERE player_id = 209778 AND league_id = 1318 AND action = 18
0.0021  SELECT action,minute FROM events2012 WHERE player_id = 209778 AND league_id = 1318 AND action = 19
0.0021  SELECT e.* FROM `events2012` e WHERE e.player_id = 209778 AND league_id = 20549 ORDER BY e.date ASC
0.0123  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=209778
0.0022  SELECT action,minute FROM events2012 WHERE player_id = 209778 AND league_id = 20549 AND action = 18
0.0020  SELECT action,minute FROM events2012 WHERE player_id = 209778 AND league_id = 20549 AND action = 19
0.0023  SELECT e.* FROM `events2012` e WHERE e.player_id = 209778 AND league_id = 24421 ORDER BY e.date ASC
0.0047  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=209778
0.0020  SELECT action,minute FROM events2012 WHERE player_id = 209778 AND league_id = 24421 AND action = 18
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 209778 AND league_id = 24421 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 209778 AND league_id = 1073 ORDER BY e.date ASC
0.0116  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1073 AND rel.player_id=209778
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 209778 AND league_id = 1073 AND action = 18
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 209778 AND league_id = 1073 AND action = 19
0.0051  SELECT e.* FROM `events2011` e WHERE e.player_id = 209778 AND league_id = 14433 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 = 14433 AND rel.player_id=209778
0.0027  SELECT action,minute FROM events2011 WHERE player_id = 209778 AND league_id = 14433 AND action = 18
0.0021  SELECT action,minute FROM events2011 WHERE player_id = 209778 AND league_id = 14433 AND action = 19
0.0026  SELECT e.* FROM `events2011` e WHERE e.player_id = 209778 AND league_id = 20548 ORDER BY e.date ASC
0.0203  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=209778
0.0059  SELECT action,minute FROM events2011 WHERE player_id = 209778 AND league_id = 20548 AND action = 18
0.0064  SELECT action,minute FROM events2011 WHERE player_id = 209778 AND league_id = 20548 AND action = 19
0.0040  SELECT e.* FROM `events2010` e WHERE e.player_id = 209778 AND league_id = 1040 ORDER BY e.date ASC
0.0085  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=209778
0.0022  SELECT action,minute FROM events2010 WHERE player_id = 209778 AND league_id = 1040 AND action = 18
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 209778 AND league_id = 1040 AND action = 19
0.0040  SELECT e.* FROM `events2010` e WHERE e.player_id = 209778 AND league_id = 984 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 = 984 AND rel.player_id=209778
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 209778 AND league_id = 984 AND action = 18
0.0064  SELECT action,minute FROM events2010 WHERE player_id = 209778 AND league_id = 984 AND action = 19
0.0069  SELECT e.* FROM `events2010` e WHERE e.player_id = 209778 AND league_id = 20547 ORDER BY e.date ASC
0.0080  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20547 AND rel.player_id=209778
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 209778 AND league_id = 20547 AND action = 18
0.0059  SELECT action,minute FROM events2010 WHERE player_id = 209778 AND league_id = 20547 AND action = 19
0.0019  SELECT e.* FROM `events2009` e WHERE e.player_id = 209778 AND league_id = 12730 ORDER BY e.date ASC
0.0072  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=209778
0.0018  SELECT action,minute FROM events2009 WHERE player_id = 209778 AND league_id = 12730 AND action = 18
0.0060  SELECT action,minute FROM events2009 WHERE player_id = 209778 AND league_id = 12730 AND action = 19
0.0018  SELECT e.* FROM `events2009` e WHERE e.player_id = 209778 AND league_id = 58653 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 = 58653 AND rel.player_id=209778
0.0020  SELECT action,minute FROM events2009 WHERE player_id = 209778 AND league_id = 58653 AND action = 18
0.0020  SELECT action,minute FROM events2009 WHERE player_id = 209778 AND league_id = 58653 AND action = 19