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

Amas

Jugador del Real Sociedad
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Amas
Nacionalidad
España
Nombre
Carmelo Amas Méndez
Edad
80 Años (03-08-1943)
Altura
169
Peso
68 kilogramos
Equipo
Real Sociedad
Posición
Delantero
Liga
Primera División 1976
Compañeros de equipo

No hay comentarios


  USO DE MEMORIA  
8,460,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Player / Index )  0.4338
Total Execution Time  0.4349
  CADENA URL  
/jugador/amas-255271
  GET DATOS  
$_GET['/jugador/amas-255271']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (161)  
0.0003   SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`playerId` = '255271'
0.0034  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 = 'amas-255271' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0207  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 = 'amas-255271' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
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 = 5401
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 = 10942
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 = 5400
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 = 10941
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 = 21981
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 = 5399
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 = 5398
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 = 22112
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 = 5397
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 = 5396
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 = 22132
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 = 5394
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 = 22133
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 = 5392
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 = 22135
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 = 5391
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 = 22136
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 = 5461
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 = 22137
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 = 5460
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 = 22138
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 = 5459
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 = 22139
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 = 5458
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 = 22140
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 = 58817
0.0018  SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '255271'
0.0025  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 = 5401 AND rp.teamId = 2120 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0020  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 = 255271 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 = '255271' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT e.* FROM `events1976` e WHERE e.player_id = 255271 AND league_id = 5401 ORDER BY e.date ASC
0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 5401 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1976 WHERE player_id = 255271 AND league_id = 5401 AND action = 18
0.0018  SELECT action,minute FROM events1976 WHERE player_id = 255271 AND league_id = 5401 AND action = 19
0.0020  SELECT e.* FROM `events1976` e WHERE e.player_id = 255271 AND league_id = 10942 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 = 10942 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1976 WHERE player_id = 255271 AND league_id = 10942 AND action = 18
0.0018  SELECT action,minute FROM events1976 WHERE player_id = 255271 AND league_id = 10942 AND action = 19
0.0019  SELECT e.* FROM `events1975` e WHERE e.player_id = 255271 AND league_id = 5400 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 = 5400 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1975 WHERE player_id = 255271 AND league_id = 5400 AND action = 18
0.0019  SELECT action,minute FROM events1975 WHERE player_id = 255271 AND league_id = 5400 AND action = 19
0.0018  SELECT e.* FROM `events1975` e WHERE e.player_id = 255271 AND league_id = 10941 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 = 10941 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1975 WHERE player_id = 255271 AND league_id = 10941 AND action = 18
0.0018  SELECT action,minute FROM events1975 WHERE player_id = 255271 AND league_id = 10941 AND action = 19
0.0018  SELECT e.* FROM `events1975` e WHERE e.player_id = 255271 AND league_id = 21981 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 = 21981 AND rel.player_id=255271
0.0019  SELECT action,minute FROM events1975 WHERE player_id = 255271 AND league_id = 21981 AND action = 18
0.0018  SELECT action,minute FROM events1975 WHERE player_id = 255271 AND league_id = 21981 AND action = 19
0.0021  SELECT e.* FROM `events1974` e WHERE e.player_id = 255271 AND league_id = 5399 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 = 5399 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1974 WHERE player_id = 255271 AND league_id = 5399 AND action = 18
0.0018  SELECT action,minute FROM events1974 WHERE player_id = 255271 AND league_id = 5399 AND action = 19
0.0018  SELECT e.* FROM `events1974` e WHERE e.player_id = 255271 AND league_id = 21982 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 = 21982 AND rel.player_id=255271
0.0019  SELECT action,minute FROM events1974 WHERE player_id = 255271 AND league_id = 21982 AND action = 18
0.0019  SELECT action,minute FROM events1974 WHERE player_id = 255271 AND league_id = 21982 AND action = 19
0.0021  SELECT e.* FROM `events1973` e WHERE e.player_id = 255271 AND league_id = 5398 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 = 5398 AND rel.player_id=255271
0.0019  SELECT action,minute FROM events1973 WHERE player_id = 255271 AND league_id = 5398 AND action = 18
0.0019  SELECT action,minute FROM events1973 WHERE player_id = 255271 AND league_id = 5398 AND action = 19
0.0019  SELECT e.* FROM `events1973` e WHERE e.player_id = 255271 AND league_id = 22112 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 = 22112 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1973 WHERE player_id = 255271 AND league_id = 22112 AND action = 18
0.0018  SELECT action,minute FROM events1973 WHERE player_id = 255271 AND league_id = 22112 AND action = 19
0.0021  SELECT e.* FROM `events1972` e WHERE e.player_id = 255271 AND league_id = 5397 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 = 5397 AND rel.player_id=255271
0.0030  SELECT action,minute FROM events1972 WHERE player_id = 255271 AND league_id = 5397 AND action = 18
0.0020  SELECT action,minute FROM events1972 WHERE player_id = 255271 AND league_id = 5397 AND action = 19
0.0022  SELECT e.* FROM `events1971` e WHERE e.player_id = 255271 AND league_id = 5396 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 = 5396 AND rel.player_id=255271
0.0021  SELECT action,minute FROM events1971 WHERE player_id = 255271 AND league_id = 5396 AND action = 18
0.0028  SELECT action,minute FROM events1971 WHERE player_id = 255271 AND league_id = 5396 AND action = 19
0.0022  SELECT e.* FROM `events1971` e WHERE e.player_id = 255271 AND league_id = 22131 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 = 22131 AND rel.player_id=255271
0.0025  SELECT action,minute FROM events1971 WHERE player_id = 255271 AND league_id = 22131 AND action = 18
0.0023  SELECT action,minute FROM events1971 WHERE player_id = 255271 AND league_id = 22131 AND action = 19
0.0028  SELECT e.* FROM `events1970` e WHERE e.player_id = 255271 AND league_id = 5466 ORDER BY e.date ASC
0.0025  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 5466 AND rel.player_id=255271
0.0024  SELECT action,minute FROM events1970 WHERE player_id = 255271 AND league_id = 5466 AND action = 18
0.0023  SELECT action,minute FROM events1970 WHERE player_id = 255271 AND league_id = 5466 AND action = 19
0.0024  SELECT e.* FROM `events1970` e WHERE e.player_id = 255271 AND league_id = 22132 ORDER BY e.date ASC
0.0043  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 22132 AND rel.player_id=255271
0.0023  SELECT action,minute FROM events1970 WHERE player_id = 255271 AND league_id = 22132 AND action = 18
0.0028  SELECT action,minute FROM events1970 WHERE player_id = 255271 AND league_id = 22132 AND action = 19
0.0025  SELECT e.* FROM `events1969` e WHERE e.player_id = 255271 AND league_id = 5394 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 = 5394 AND rel.player_id=255271
0.0023  SELECT action,minute FROM events1969 WHERE player_id = 255271 AND league_id = 5394 AND action = 18
0.0024  SELECT action,minute FROM events1969 WHERE player_id = 255271 AND league_id = 5394 AND action = 19
0.0023  SELECT e.* FROM `events1969` e WHERE e.player_id = 255271 AND league_id = 22133 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 = 22133 AND rel.player_id=255271
0.0022  SELECT action,minute FROM events1969 WHERE player_id = 255271 AND league_id = 22133 AND action = 18
0.0023  SELECT action,minute FROM events1969 WHERE player_id = 255271 AND league_id = 22133 AND action = 19
0.0024  SELECT e.* FROM `events1968` e WHERE e.player_id = 255271 AND league_id = 5393 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 = 5393 AND rel.player_id=255271
0.0021  SELECT action,minute FROM events1968 WHERE player_id = 255271 AND league_id = 5393 AND action = 18
0.0022  SELECT action,minute FROM events1968 WHERE player_id = 255271 AND league_id = 5393 AND action = 19
0.0022  SELECT e.* FROM `events1968` e WHERE e.player_id = 255271 AND league_id = 22134 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 = 22134 AND rel.player_id=255271
0.0031  SELECT action,minute FROM events1968 WHERE player_id = 255271 AND league_id = 22134 AND action = 18
0.0023  SELECT action,minute FROM events1968 WHERE player_id = 255271 AND league_id = 22134 AND action = 19
0.0027  SELECT e.* FROM `events1967` e WHERE e.player_id = 255271 AND league_id = 5392 ORDER BY e.date ASC
0.0034  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 5392 AND rel.player_id=255271
0.0026  SELECT action,minute FROM events1967 WHERE player_id = 255271 AND league_id = 5392 AND action = 18
0.0027  SELECT action,minute FROM events1967 WHERE player_id = 255271 AND league_id = 5392 AND action = 19
0.0027  SELECT e.* FROM `events1967` e WHERE e.player_id = 255271 AND league_id = 22135 ORDER BY e.date ASC
0.0099  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 22135 AND rel.player_id=255271
0.0021  SELECT action,minute FROM events1967 WHERE player_id = 255271 AND league_id = 22135 AND action = 18
0.0021  SELECT action,minute FROM events1967 WHERE player_id = 255271 AND league_id = 22135 AND action = 19
0.0022  SELECT e.* FROM `events1966` e WHERE e.player_id = 255271 AND league_id = 5391 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 = 5391 AND rel.player_id=255271
0.0020  SELECT action,minute FROM events1966 WHERE player_id = 255271 AND league_id = 5391 AND action = 18
0.0020  SELECT action,minute FROM events1966 WHERE player_id = 255271 AND league_id = 5391 AND action = 19
0.0019  SELECT e.* FROM `events1966` e WHERE e.player_id = 255271 AND league_id = 11081 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 = 11081 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1966 WHERE player_id = 255271 AND league_id = 11081 AND action = 18
0.0020  SELECT action,minute FROM events1966 WHERE player_id = 255271 AND league_id = 11081 AND action = 19
0.0019  SELECT e.* FROM `events1966` e WHERE e.player_id = 255271 AND league_id = 22136 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 = 22136 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1966 WHERE player_id = 255271 AND league_id = 22136 AND action = 18
0.0018  SELECT action,minute FROM events1966 WHERE player_id = 255271 AND league_id = 22136 AND action = 19
0.0019  SELECT e.* FROM `events1965` e WHERE e.player_id = 255271 AND league_id = 5461 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 = 5461 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1965 WHERE player_id = 255271 AND league_id = 5461 AND action = 18
0.0018  SELECT action,minute FROM events1965 WHERE player_id = 255271 AND league_id = 5461 AND action = 19
0.0019  SELECT e.* FROM `events1965` e WHERE e.player_id = 255271 AND league_id = 22137 ORDER BY e.date ASC
0.0024  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 22137 AND rel.player_id=255271
0.0019  SELECT action,minute FROM events1965 WHERE player_id = 255271 AND league_id = 22137 AND action = 18
0.0018  SELECT action,minute FROM events1965 WHERE player_id = 255271 AND league_id = 22137 AND action = 19
0.0020  SELECT e.* FROM `events1964` e WHERE e.player_id = 255271 AND league_id = 5460 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 = 5460 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1964 WHERE player_id = 255271 AND league_id = 5460 AND action = 18
0.0019  SELECT action,minute FROM events1964 WHERE player_id = 255271 AND league_id = 5460 AND action = 19
0.0019  SELECT e.* FROM `events1964` e WHERE e.player_id = 255271 AND league_id = 22138 ORDER BY e.date ASC
0.0025  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 22138 AND rel.player_id=255271
0.0020  SELECT action,minute FROM events1964 WHERE player_id = 255271 AND league_id = 22138 AND action = 18
0.0018  SELECT action,minute FROM events1964 WHERE player_id = 255271 AND league_id = 22138 AND action = 19
0.0019  SELECT e.* FROM `events1963` e WHERE e.player_id = 255271 AND league_id = 5459 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 = 5459 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1963 WHERE player_id = 255271 AND league_id = 5459 AND action = 18
0.0018  SELECT action,minute FROM events1963 WHERE player_id = 255271 AND league_id = 5459 AND action = 19
0.0018  SELECT e.* FROM `events1963` e WHERE e.player_id = 255271 AND league_id = 22139 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 = 22139 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1963 WHERE player_id = 255271 AND league_id = 22139 AND action = 18
0.0018  SELECT action,minute FROM events1963 WHERE player_id = 255271 AND league_id = 22139 AND action = 19
0.0019  SELECT e.* FROM `events1962` e WHERE e.player_id = 255271 AND league_id = 5458 ORDER BY e.date ASC
0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 5458 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1962 WHERE player_id = 255271 AND league_id = 5458 AND action = 18
0.0018  SELECT action,minute FROM events1962 WHERE player_id = 255271 AND league_id = 5458 AND action = 19
0.0019  SELECT e.* FROM `events1962` e WHERE e.player_id = 255271 AND league_id = 22140 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 = 22140 AND rel.player_id=255271
0.0018  SELECT action,minute FROM events1962 WHERE player_id = 255271 AND league_id = 22140 AND action = 18
0.0019  SELECT action,minute FROM events1962 WHERE player_id = 255271 AND league_id = 22140 AND action = 19
0.0019  SELECT e.* FROM `events1961` e WHERE e.player_id = 255271 AND league_id = 58817 ORDER BY e.date ASC
0.0024  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58817 AND rel.player_id=255271
0.0019  SELECT action,minute FROM events1961 WHERE player_id = 255271 AND league_id = 58817 AND action = 18
0.0018  SELECT action,minute FROM events1961 WHERE player_id = 255271 AND league_id = 58817 AND action = 19