| 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` = '37762'
|
| 0.0026 | 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 = 'A-Ranocchia-37762' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0352 | 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 = 'A-Ranocchia-37762' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 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 = 62734 |
| 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 = 63341 |
| 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 = 63995 |
| 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 = 65902 |
| 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 = 66133 |
| 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 = 57792 |
| 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 = 58676 |
| 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 = 59176 |
| 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 = 49851 |
| 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 = 49360 |
| 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 = 50675 |
| 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 = 51188 |
| 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 = 53486 |
| 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 = 72806 |
| 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 = 43550 |
| 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 = 43268 |
| 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 = 44983 |
| 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 = 48458 |
| 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 = 38071 |
| 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 = 38083 |
| 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 = 29314 |
| 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 = 30661 |
| 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 = 22265 |
| 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 = 34914 |
| 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 = 15239 |
| 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 = 15030 |
| 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 = 16245 |
| 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 = 16630 |
| 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 = 3774 |
| 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 = 3808 |
| 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 = 3981 |
| 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 = 4017 |
| 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 = 4249 |
| 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 = 4255 |
| 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 = 4262 |
| 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 = 2489 |
| 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 = 3600 |
| 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 = 3602 |
| 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 = 2156 |
| 0.0033 | 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 = 2249 |
| 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 = 2257 |
| 0.0039 | 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 = 41753 |
| 0.0040 | 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 = 41754 |
| 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 = 1416 |
| 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 = 1323 |
| 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 = 1340 |
| 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 = 1427 |
| 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 = 1438 |
| 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 = 1444 |
| 0.0059 | 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 = 14107 |
| 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 = 25249 |
| 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 = 1138 |
| 0.0033 | 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 = 1098 |
| 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 = 1126 |
| 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 = 14108 |
| 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 = 24786 |
| 0.0033 | 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 = 41909 |
| 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 = 863 |
| 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 = 990 |
| 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 = 39579 |
| 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 = 444 |
| 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 = 13199 |
| 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 = 13201 |
| 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 = 14110 |
| 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 = 39580 |
| 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 = 41917 |
| 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 = 41918 |
| 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 = 538 |
| 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 = 41121 |
| 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 = 507 |
| 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 = 14112 |
| 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 = 39582 |
| 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 = 41122 |
| 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 = 508 |
| 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 = '37762'
|
| 0.0024 | 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 = 37762 ORDER BY rp.year DESC |
| 0.0023 | SELECT p.title,p.totalcomments,p.downloads,p.views,p.id,p.author_id FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '37762' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0019 | SELECT COUNT(DISTINCT(p.id)) as total FROM `pictures` p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '37762' and rp.type = 3 |
| 0.0018 | SELECT e.* FROM `events2023` e WHERE e.player_id = 37762 AND league_id = 67673 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 = 67673 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2023 WHERE player_id = 37762 AND league_id = 67673 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2023 WHERE player_id = 37762 AND league_id = 67673 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2023` e WHERE e.player_id = 37762 AND league_id = 67320 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 = 67320 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2023 WHERE player_id = 37762 AND league_id = 67320 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2023 WHERE player_id = 37762 AND league_id = 67320 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2023` e WHERE e.player_id = 37762 AND league_id = 68214 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 = 68214 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2023 WHERE player_id = 37762 AND league_id = 68214 AND action = 18 |
| 0.0017 | SELECT action,minute FROM events2023 WHERE player_id = 37762 AND league_id = 68214 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2022` e WHERE e.player_id = 37762 AND league_id = 62734 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 = 62734 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 62734 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 62734 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2022` e WHERE e.player_id = 37762 AND league_id = 62807 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 = 62807 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 62807 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 62807 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2022` e WHERE e.player_id = 37762 AND league_id = 63341 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 = 63341 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 63341 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 63341 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2022` e WHERE e.player_id = 37762 AND league_id = 63995 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 = 63995 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 63995 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 63995 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2022` e WHERE e.player_id = 37762 AND league_id = 65902 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 = 65902 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 65902 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 65902 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2022` e WHERE e.player_id = 37762 AND league_id = 66133 ORDER BY e.date ASC |
| 0.0068 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66133 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 66133 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 37762 AND league_id = 66133 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2021` e WHERE e.player_id = 37762 AND league_id = 57792 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 = 57792 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2021 WHERE player_id = 37762 AND league_id = 57792 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2021 WHERE player_id = 37762 AND league_id = 57792 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2021` e WHERE e.player_id = 37762 AND league_id = 56547 ORDER BY e.date ASC |
| 0.0094 | 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=37762 |
| 0.0019 | SELECT action,minute FROM events2021 WHERE player_id = 37762 AND league_id = 56547 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2021 WHERE player_id = 37762 AND league_id = 56547 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2021` e WHERE e.player_id = 37762 AND league_id = 58676 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 = 58676 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2021 WHERE player_id = 37762 AND league_id = 58676 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2021 WHERE player_id = 37762 AND league_id = 58676 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2021` e WHERE e.player_id = 37762 AND league_id = 59176 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 = 59176 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2021 WHERE player_id = 37762 AND league_id = 59176 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2021 WHERE player_id = 37762 AND league_id = 59176 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 37762 AND league_id = 49851 ORDER BY e.date ASC |
| 0.0077 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49851 AND rel.player_id=37762 |
| 0.0023 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 49851 AND action = 18 |
| 0.0023 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 49851 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2020` e WHERE e.player_id = 37762 AND league_id = 49360 ORDER BY e.date ASC |
| 0.0064 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49360 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 49360 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 49360 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2020` e WHERE e.player_id = 37762 AND league_id = 49506 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 = 49506 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 49506 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 49506 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2020` e WHERE e.player_id = 37762 AND league_id = 50675 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 = 50675 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 50675 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 50675 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2020` e WHERE e.player_id = 37762 AND league_id = 51188 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 = 51188 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 51188 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 51188 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2020` e WHERE e.player_id = 37762 AND league_id = 53486 ORDER BY e.date ASC |
| 0.0066 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53486 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 53486 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 53486 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2020` e WHERE e.player_id = 37762 AND league_id = 72806 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 = 72806 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 72806 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 37762 AND league_id = 72806 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2019` e WHERE e.player_id = 37762 AND league_id = 43550 ORDER BY e.date ASC |
| 0.0066 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43550 AND rel.player_id=37762 |
| 0.0025 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 43550 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 43550 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2019` e WHERE e.player_id = 37762 AND league_id = 43268 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 = 43268 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 43268 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 43268 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2019` e WHERE e.player_id = 37762 AND league_id = 43475 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 = 43475 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 43475 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 43475 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2019` e WHERE e.player_id = 37762 AND league_id = 44541 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 = 44541 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 44541 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 44541 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2019` e WHERE e.player_id = 37762 AND league_id = 44983 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 = 44983 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 44983 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 44983 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2019` e WHERE e.player_id = 37762 AND league_id = 48458 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 = 48458 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 48458 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2019 WHERE player_id = 37762 AND league_id = 48458 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2018` e WHERE e.player_id = 37762 AND league_id = 38646 ORDER BY e.date ASC |
| 0.0050 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38646 AND rel.player_id=37762 |
| 0.0025 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 38646 AND action = 18 |
| 0.0025 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 38646 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2018` e WHERE e.player_id = 37762 AND league_id = 38071 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 = 38071 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 38071 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 38071 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2018` e WHERE e.player_id = 37762 AND league_id = 38083 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 = 38083 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 38083 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 38083 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2018` e WHERE e.player_id = 37762 AND league_id = 38427 ORDER BY e.date ASC |
| 0.0106 | 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=37762 |
| 0.0021 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 38427 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 38427 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2018` e WHERE e.player_id = 37762 AND league_id = 39142 ORDER BY e.date ASC |
| 0.0127 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39142 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 39142 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2018 WHERE player_id = 37762 AND league_id = 39142 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2017` e WHERE e.player_id = 37762 AND league_id = 29314 ORDER BY e.date ASC |
| 0.0110 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 29314 AND rel.player_id=37762 |
| 0.0035 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 29314 AND action = 18 |
| 0.0035 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 29314 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2017` e WHERE e.player_id = 37762 AND league_id = 30661 ORDER BY e.date ASC |
| 0.0112 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30661 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 30661 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 30661 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2017` e WHERE e.player_id = 37762 AND league_id = 22265 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 = 22265 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 22265 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 22265 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2017` e WHERE e.player_id = 37762 AND league_id = 30386 ORDER BY e.date ASC |
| 0.0120 | 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=37762 |
| 0.0024 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 30386 AND action = 18 |
| 0.0025 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 30386 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2017` e WHERE e.player_id = 37762 AND league_id = 33909 ORDER BY e.date ASC |
| 0.0172 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33909 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 33909 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 33909 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2017` e WHERE e.player_id = 37762 AND league_id = 34914 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 = 34914 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 34914 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2017 WHERE player_id = 37762 AND league_id = 34914 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2016` e WHERE e.player_id = 37762 AND league_id = 15239 ORDER BY e.date ASC |
| 0.0076 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15239 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 15239 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 15239 AND action = 19 |
| 0.0056 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15239 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 15239 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 15239 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2016` e WHERE e.player_id = 37762 AND league_id = 15030 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 = 15030 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 15030 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 15030 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2016` e WHERE e.player_id = 37762 AND league_id = 16245 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 = 16245 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 16245 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 16245 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2016` e WHERE e.player_id = 37762 AND league_id = 16586 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 = 16586 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 16586 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 16586 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2016` e WHERE e.player_id = 37762 AND league_id = 16630 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 = 16630 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 16630 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2016 WHERE player_id = 37762 AND league_id = 16630 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2015` e WHERE e.player_id = 37762 AND league_id = 3774 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 = 3774 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 3774 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 3774 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2015` e WHERE e.player_id = 37762 AND league_id = 3804 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 = 3804 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 3804 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 3804 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2015` e WHERE e.player_id = 37762 AND league_id = 3808 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 = 3808 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 3808 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 3808 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2015` e WHERE e.player_id = 37762 AND league_id = 3981 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 = 3981 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 3981 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 3981 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2015` e WHERE e.player_id = 37762 AND league_id = 4017 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 = 4017 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 4017 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 4017 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2015` e WHERE e.player_id = 37762 AND league_id = 4249 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 = 4249 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 4249 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 4249 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2015` e WHERE e.player_id = 37762 AND league_id = 4255 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 = 4255 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 4255 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 4255 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2015` e WHERE e.player_id = 37762 AND league_id = 4262 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 = 4262 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 4262 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2015 WHERE player_id = 37762 AND league_id = 4262 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2014` e WHERE e.player_id = 37762 AND league_id = 2489 ORDER BY e.date ASC |
| 0.0079 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2489 AND rel.player_id=37762 |
| 0.0025 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 2489 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 2489 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2014` e WHERE e.player_id = 37762 AND league_id = 2399 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 = 2399 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 2399 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 2399 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2014` e WHERE e.player_id = 37762 AND league_id = 3322 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 = 3322 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 3322 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 3322 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2014` e WHERE e.player_id = 37762 AND league_id = 3600 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 = 3600 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 3600 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 3600 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2014` e WHERE e.player_id = 37762 AND league_id = 3602 ORDER BY e.date ASC |
| 0.0050 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3602 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 3602 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2014 WHERE player_id = 37762 AND league_id = 3602 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2013` e WHERE e.player_id = 37762 AND league_id = 1909 ORDER BY e.date ASC |
| 0.0050 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1909 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 1909 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 1909 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2013` e WHERE e.player_id = 37762 AND league_id = 1906 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 = 1906 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 1906 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 1906 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2013` e WHERE e.player_id = 37762 AND league_id = 2109 ORDER BY e.date ASC |
| 0.0067 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2109 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 2109 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 2109 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2013` e WHERE e.player_id = 37762 AND league_id = 2156 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 = 2156 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 2156 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 2156 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2013` e WHERE e.player_id = 37762 AND league_id = 2249 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 = 2249 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 2249 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 2249 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2013` e WHERE e.player_id = 37762 AND league_id = 2257 ORDER BY e.date ASC |
| 0.0074 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2257 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 2257 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 2257 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2013` e WHERE e.player_id = 37762 AND league_id = 41753 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 = 41753 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 41753 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 41753 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2013` e WHERE e.player_id = 37762 AND league_id = 41754 ORDER BY e.date ASC |
| 0.0056 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41754 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 41754 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2013 WHERE player_id = 37762 AND league_id = 41754 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2012` e WHERE e.player_id = 37762 AND league_id = 1416 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 = 1416 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1416 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1416 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2012` e WHERE e.player_id = 37762 AND league_id = 1323 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 = 1323 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1323 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1323 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2012` e WHERE e.player_id = 37762 AND league_id = 1340 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 = 1340 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1340 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1340 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2012` e WHERE e.player_id = 37762 AND league_id = 1427 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 = 1427 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1427 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1427 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2012` e WHERE e.player_id = 37762 AND league_id = 1438 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 = 1438 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1438 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1438 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2012` e WHERE e.player_id = 37762 AND league_id = 1444 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 = 1444 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1444 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 1444 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2012` e WHERE e.player_id = 37762 AND league_id = 14107 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 = 14107 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 14107 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 14107 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2012` e WHERE e.player_id = 37762 AND league_id = 25249 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 = 25249 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 25249 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 37762 AND league_id = 25249 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2011` e WHERE e.player_id = 37762 AND league_id = 1138 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 = 1138 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 1138 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 1138 AND action = 19 |
| 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 = 1138 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 1138 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 1138 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2011` e WHERE e.player_id = 37762 AND league_id = 1098 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 = 1098 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 1098 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 1098 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2011` e WHERE e.player_id = 37762 AND league_id = 1126 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 = 1126 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 1126 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 1126 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2011` e WHERE e.player_id = 37762 AND league_id = 14108 ORDER BY e.date ASC |
| 0.0084 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 14108 AND rel.player_id=37762 |
| 0.0023 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 14108 AND action = 18 |
| 0.0023 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 14108 AND action = 19 |
| 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 = 14108 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 14108 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 14108 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2011` e WHERE e.player_id = 37762 AND league_id = 24786 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 = 24786 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 24786 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 24786 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2011` e WHERE e.player_id = 37762 AND league_id = 41908 ORDER BY e.date ASC |
| 0.0100 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41908 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 41908 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 41908 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2011` e WHERE e.player_id = 37762 AND league_id = 41909 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 = 41909 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 41909 AND action = 18 |
| 0.0024 | SELECT action,minute FROM events2011 WHERE player_id = 37762 AND league_id = 41909 AND action = 19 |
| 0.0026 | SELECT e.* FROM `events2010` e WHERE e.player_id = 37762 AND league_id = 863 ORDER BY e.date ASC |
| 0.0145 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 863 AND rel.player_id=37762 |
| 0.0022 | SELECT action,minute FROM events2010 WHERE player_id = 37762 AND league_id = 863 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2010 WHERE player_id = 37762 AND league_id = 863 AND action = 19 |
| 0.0023 | SELECT e.* FROM `events2010` e WHERE e.player_id = 37762 AND league_id = 990 ORDER BY e.date ASC |
| 0.0125 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 990 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2010 WHERE player_id = 37762 AND league_id = 990 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2010 WHERE player_id = 37762 AND league_id = 990 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2010` e WHERE e.player_id = 37762 AND league_id = 14109 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 = 14109 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2010 WHERE player_id = 37762 AND league_id = 14109 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2010 WHERE player_id = 37762 AND league_id = 14109 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2010` e WHERE e.player_id = 37762 AND league_id = 39579 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 = 39579 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2010 WHERE player_id = 37762 AND league_id = 39579 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2010 WHERE player_id = 37762 AND league_id = 39579 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2009` e WHERE e.player_id = 37762 AND league_id = 444 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 = 444 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 444 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 444 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2009` e WHERE e.player_id = 37762 AND league_id = 13199 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 = 13199 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 13199 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 13199 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2009` e WHERE e.player_id = 37762 AND league_id = 13201 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 = 13201 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 13201 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 13201 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2009` e WHERE e.player_id = 37762 AND league_id = 14110 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 = 14110 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 14110 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 14110 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2009` e WHERE e.player_id = 37762 AND league_id = 39580 ORDER BY e.date ASC |
| 0.0050 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39580 AND rel.player_id=37762 |
| 0.0019 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 39580 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 39580 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2009` e WHERE e.player_id = 37762 AND league_id = 41917 ORDER BY e.date ASC |
| 0.0067 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41917 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 41917 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 41917 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2009` e WHERE e.player_id = 37762 AND league_id = 41918 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 = 41918 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 41918 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2009 WHERE player_id = 37762 AND league_id = 41918 AND action = 19 |
| 0.0024 | SELECT e.* FROM `events2008` e WHERE e.player_id = 37762 AND league_id = 538 ORDER BY e.date ASC |
| 0.0088 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 538 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2008 WHERE player_id = 37762 AND league_id = 538 AND action = 18 |
| 0.0017 | SELECT action,minute FROM events2008 WHERE player_id = 37762 AND league_id = 538 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2008` e WHERE e.player_id = 37762 AND league_id = 41121 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 = 41121 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2008 WHERE player_id = 37762 AND league_id = 41121 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2008 WHERE player_id = 37762 AND league_id = 41121 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2007` e WHERE e.player_id = 37762 AND league_id = 507 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 = 507 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2007 WHERE player_id = 37762 AND league_id = 507 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2007 WHERE player_id = 37762 AND league_id = 507 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2007` e WHERE e.player_id = 37762 AND league_id = 14112 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 = 14112 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2007 WHERE player_id = 37762 AND league_id = 14112 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2007 WHERE player_id = 37762 AND league_id = 14112 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2007` e WHERE e.player_id = 37762 AND league_id = 39582 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 = 39582 AND rel.player_id=37762 |
| 0.0018 | SELECT action,minute FROM events2007 WHERE player_id = 37762 AND league_id = 39582 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2007 WHERE player_id = 37762 AND league_id = 39582 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2007` e WHERE e.player_id = 37762 AND league_id = 41122 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 = 41122 AND rel.player_id=37762 |
| 0.0021 | SELECT action,minute FROM events2007 WHERE player_id = 37762 AND league_id = 41122 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2007 WHERE player_id = 37762 AND league_id = 41122 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2006` e WHERE e.player_id = 37762 AND league_id = 508 ORDER BY e.date ASC |
| 0.0076 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 508 AND rel.player_id=37762 |
| 0.0020 | SELECT action,minute FROM events2006 WHERE player_id = 37762 AND league_id = 508 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2006 WHERE player_id = 37762 AND league_id = 508 AND action = 19 |
E. Lamanna
M. Di Gregorio
A. Cragno
A. Sorrentino
G. Donati
Pablo Marí
Marlon
Luca Caldirola
Franco Carboni
S. Birindelli
Valentin Antov
Carlos Augusto
L. Marrone
A. Izzo
Nicolo Rovella
Pepín
A. Barberis
Mattia Valoti
Stefano Sensi
G. Caprari
F. Ranocchia
A. Colpani
Leonardo Colombo
S. Vignato
P. Ciurria
C. Gytkjaer
Mirko Maric
A. Petagna
Dany Mota
Marco D'alessandro