| 0.0005 |
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` = '15775'
|
| 0.0160 | 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 = 'Mehmet-Hetemaj' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0605 | 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 = 'Mehmet-Hetemaj' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0156 | 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 = 67755 |
| 0.0160 | 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 = 67756 |
| 0.0178 | 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 = 71034 |
| 0.0174 | 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 = 66704 |
| 0.0177 | 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 = 69491 |
| 0.0174 | 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 = 70078 |
| 0.0175 | 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 = 66320 |
| 0.0176 | 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 = 66862 |
| 0.0178 | 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 = 61118 |
| 0.0174 | 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 = 64932 |
| 0.0172 | 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 = 60728 |
| 0.0153 | 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 = 61675 |
| 0.0151 | 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 = 55346 |
| 0.0155 | 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 = 48795 |
| 0.0152 | 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 = 51233 |
| 0.0153 | 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 = 51795 |
| 0.0157 | 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 = 42551 |
| 0.0165 | 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 = 48328 |
| 0.0155 | 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 = 37855 |
| 0.0157 | 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 = 30387 |
| 0.0158 | 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 = 33325 |
| 0.0161 | 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 = 37194 |
| 0.0176 | 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 = 37202 |
| 0.0151 | 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 = 40229 |
| 0.0153 | 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 = 41656 |
| 0.0153 | 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 = 20276 |
| 0.0154 | 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 = 16586 |
| 0.0160 | 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 = 16615 |
| 0.0170 | 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 = 20065 |
| 0.0174 | 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 = 20337 |
| 0.0174 | 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 = 4072 |
| 0.0173 | 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 = 10089 |
| 0.0176 | 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 = 3839 |
| 0.0173 | 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 = 9298 |
| 0.0173 | 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 = 10447 |
| 0.0159 | 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 = 10873 |
| 0.0160 | 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 = 2744 |
| 0.0153 | 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 = 3652 |
| 0.0152 | 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 = 22554 |
| 0.0152 | 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 = 47493 |
| 0.0154 | 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 = 2082 |
| 0.0151 | 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 = 2109 |
| 0.0152 | 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 = 1485 |
| 0.0153 | 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.0155 | 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 = 1188 |
| 0.0160 | 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 = 10610 |
| 0.0173 | 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.0169 | 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 = 11984 |
| 0.0152 | 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 = 13200 |
| 0.0155 | 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 = 39417 |
| 0.0155 | 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.0156 | 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.0155 | 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 = 396 |
| 0.0161 | 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 = 10440 |
| 0.0175 | 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 = 39581 |
| 0.0175 | 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 = 44506 |
| 0.0176 | 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 = 10371 |
| 0.0147 | 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 = '15775'
|
| 0.0201 | 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 = 67755 AND rp.teamId = 12598 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC |
| 0.0184 | 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 = 15775 ORDER BY rp.year DESC |
| 0.0153 | 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 = '15775' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0149 | 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 = '15775' and rp.type = 3 |
| 0.0151 | SELECT e.* FROM `events2023` e WHERE e.player_id = 15775 AND league_id = 67755 ORDER BY e.date ASC |
| 0.0186 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67755 AND rel.player_id=15775 |
| 0.0150 | SELECT action,minute FROM events2023 WHERE player_id = 15775 AND league_id = 67755 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2023 WHERE player_id = 15775 AND league_id = 67755 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2023` e WHERE e.player_id = 15775 AND league_id = 67756 ORDER BY e.date ASC |
| 0.0180 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67756 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2023 WHERE player_id = 15775 AND league_id = 67756 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2023 WHERE player_id = 15775 AND league_id = 67756 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2023` e WHERE e.player_id = 15775 AND league_id = 71034 ORDER BY e.date ASC |
| 0.0155 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71034 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2023 WHERE player_id = 15775 AND league_id = 71034 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2023 WHERE player_id = 15775 AND league_id = 71034 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2022` e WHERE e.player_id = 15775 AND league_id = 66704 ORDER BY e.date ASC |
| 0.0167 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66704 AND rel.player_id=15775 |
| 0.0149 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 66704 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 66704 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2022` e WHERE e.player_id = 15775 AND league_id = 69491 ORDER BY e.date ASC |
| 0.0147 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 69491 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 69491 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 69491 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2022` e WHERE e.player_id = 15775 AND league_id = 70078 ORDER BY e.date ASC |
| 0.0146 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 70078 AND rel.player_id=15775 |
| 0.0144 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 70078 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 70078 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2022` e WHERE e.player_id = 15775 AND league_id = 66320 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 = 66320 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 66320 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 66320 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2022` e WHERE e.player_id = 15775 AND league_id = 66769 ORDER BY e.date ASC |
| 0.0154 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66769 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 66769 AND action = 18 |
| 0.0149 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 66769 AND action = 19 |
| 0.0152 | SELECT e.* FROM `events2022` e WHERE e.player_id = 15775 AND league_id = 66862 ORDER BY e.date ASC |
| 0.0156 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66862 AND rel.player_id=15775 |
| 0.0153 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 66862 AND action = 18 |
| 0.0152 | SELECT action,minute FROM events2022 WHERE player_id = 15775 AND league_id = 66862 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2021` e WHERE e.player_id = 15775 AND league_id = 61118 ORDER BY e.date ASC |
| 0.0167 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61118 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 61118 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 61118 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2021` e WHERE e.player_id = 15775 AND league_id = 61699 ORDER BY e.date ASC |
| 0.0171 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61699 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 61699 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 61699 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2021` e WHERE e.player_id = 15775 AND league_id = 64932 ORDER BY e.date ASC |
| 0.0153 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 64932 AND rel.player_id=15775 |
| 0.0153 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 64932 AND action = 18 |
| 0.0153 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 64932 AND action = 19 |
| 0.0151 | SELECT e.* FROM `events2021` e WHERE e.player_id = 15775 AND league_id = 56547 ORDER BY e.date ASC |
| 0.0339 | 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=15775 |
| 0.0148 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 56547 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 56547 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2021` e WHERE e.player_id = 15775 AND league_id = 60728 ORDER BY e.date ASC |
| 0.0148 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 60728 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 60728 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 60728 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2021` e WHERE e.player_id = 15775 AND league_id = 61675 ORDER BY e.date ASC |
| 0.0146 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61675 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 61675 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2021 WHERE player_id = 15775 AND league_id = 61675 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2020` e WHERE e.player_id = 15775 AND league_id = 55346 ORDER BY e.date ASC |
| 0.0156 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 55346 AND rel.player_id=15775 |
| 0.0147 | SELECT action,minute FROM events2020 WHERE player_id = 15775 AND league_id = 55346 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2020 WHERE player_id = 15775 AND league_id = 55346 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2020` e WHERE e.player_id = 15775 AND league_id = 49506 ORDER BY e.date ASC |
| 0.0182 | 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=15775 |
| 0.0145 | SELECT action,minute FROM events2020 WHERE player_id = 15775 AND league_id = 49506 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2020 WHERE player_id = 15775 AND league_id = 49506 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2019` e WHERE e.player_id = 15775 AND league_id = 48795 ORDER BY e.date ASC |
| 0.0158 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48795 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2019 WHERE player_id = 15775 AND league_id = 48795 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2019 WHERE player_id = 15775 AND league_id = 48795 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2019` e WHERE e.player_id = 15775 AND league_id = 51233 ORDER BY e.date ASC |
| 0.0147 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 51233 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2019 WHERE player_id = 15775 AND league_id = 51233 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2019 WHERE player_id = 15775 AND league_id = 51233 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2019` e WHERE e.player_id = 15775 AND league_id = 43475 ORDER BY e.date ASC |
| 0.0170 | 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=15775 |
| 0.0145 | SELECT action,minute FROM events2019 WHERE player_id = 15775 AND league_id = 43475 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2019 WHERE player_id = 15775 AND league_id = 43475 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2019` e WHERE e.player_id = 15775 AND league_id = 51795 ORDER BY e.date ASC |
| 0.0151 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 51795 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2019 WHERE player_id = 15775 AND league_id = 51795 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2019 WHERE player_id = 15775 AND league_id = 51795 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2018` e WHERE e.player_id = 15775 AND league_id = 42551 ORDER BY e.date ASC |
| 0.0160 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42551 AND rel.player_id=15775 |
| 0.0147 | SELECT action,minute FROM events2018 WHERE player_id = 15775 AND league_id = 42551 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2018 WHERE player_id = 15775 AND league_id = 42551 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2018` e WHERE e.player_id = 15775 AND league_id = 38427 ORDER BY e.date ASC |
| 0.0171 | 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=15775 |
| 0.0149 | SELECT action,minute FROM events2018 WHERE player_id = 15775 AND league_id = 38427 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2018 WHERE player_id = 15775 AND league_id = 38427 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2018` e WHERE e.player_id = 15775 AND league_id = 38742 ORDER BY e.date ASC |
| 0.0153 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38742 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2018 WHERE player_id = 15775 AND league_id = 38742 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2018 WHERE player_id = 15775 AND league_id = 38742 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2018` e WHERE e.player_id = 15775 AND league_id = 48328 ORDER BY e.date ASC |
| 0.0151 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48328 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2018 WHERE player_id = 15775 AND league_id = 48328 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2018 WHERE player_id = 15775 AND league_id = 48328 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2017` e WHERE e.player_id = 15775 AND league_id = 37855 ORDER BY e.date ASC |
| 0.0157 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37855 AND rel.player_id=15775 |
| 0.0147 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 37855 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 37855 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2017` e WHERE e.player_id = 15775 AND league_id = 30386 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 = 30386 AND rel.player_id=15775 |
| 0.0148 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 30386 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 30386 AND action = 19 |
| 0.0151 | SELECT e.* FROM `events2017` e WHERE e.player_id = 15775 AND league_id = 30387 ORDER BY e.date ASC |
| 0.0250 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30387 AND rel.player_id=15775 |
| 0.0149 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 30387 AND action = 18 |
| 0.0151 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 30387 AND action = 19 |
| 0.0151 | SELECT e.* FROM `events2017` e WHERE e.player_id = 15775 AND league_id = 33325 ORDER BY e.date ASC |
| 0.0169 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33325 AND rel.player_id=15775 |
| 0.0144 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 33325 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 33325 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2017` e WHERE e.player_id = 15775 AND league_id = 37194 ORDER BY e.date ASC |
| 0.0146 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37194 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 37194 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 37194 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2017` e WHERE e.player_id = 15775 AND league_id = 37202 ORDER BY e.date ASC |
| 0.0150 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37202 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 37202 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 37202 AND action = 19 |
| 0.0149 | SELECT e.* FROM `events2017` e WHERE e.player_id = 15775 AND league_id = 40229 ORDER BY e.date ASC |
| 0.0146 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 40229 AND rel.player_id=15775 |
| 0.0152 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 40229 AND action = 18 |
| 0.0151 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 40229 AND action = 19 |
| 0.0153 | SELECT e.* FROM `events2017` e WHERE e.player_id = 15775 AND league_id = 41656 ORDER BY e.date ASC |
| 0.0204 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41656 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 41656 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2017 WHERE player_id = 15775 AND league_id = 41656 AND action = 19 |
| 0.0153 | SELECT e.* FROM `events2016` e WHERE e.player_id = 15775 AND league_id = 20276 ORDER BY e.date ASC |
| 0.0182 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20276 AND rel.player_id=15775 |
| 0.0148 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 20276 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 20276 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2016` e WHERE e.player_id = 15775 AND league_id = 15735 ORDER BY e.date ASC |
| 0.0164 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15735 AND rel.player_id=15775 |
| 0.0147 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 15735 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 15735 AND action = 19 |
| 0.0153 | SELECT e.* FROM `events2016` e WHERE e.player_id = 15775 AND league_id = 16586 ORDER BY e.date ASC |
| 0.0193 | 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=15775 |
| 0.0148 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 16586 AND action = 18 |
| 0.0149 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 16586 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2016` e WHERE e.player_id = 15775 AND league_id = 16615 ORDER BY e.date ASC |
| 0.0147 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16615 AND rel.player_id=15775 |
| 0.0149 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 16615 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 16615 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2016` e WHERE e.player_id = 15775 AND league_id = 20065 ORDER BY e.date ASC |
| 0.0149 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20065 AND rel.player_id=15775 |
| 0.0148 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 20065 AND action = 18 |
| 0.0149 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 20065 AND action = 19 |
| 0.0156 | SELECT e.* FROM `events2016` e WHERE e.player_id = 15775 AND league_id = 20337 ORDER BY e.date ASC |
| 0.0164 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20337 AND rel.player_id=15775 |
| 0.0155 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 20337 AND action = 18 |
| 0.0151 | SELECT action,minute FROM events2016 WHERE player_id = 15775 AND league_id = 20337 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2015` e WHERE e.player_id = 15775 AND league_id = 4072 ORDER BY e.date ASC |
| 0.0198 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4072 AND rel.player_id=15775 |
| 0.0147 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 4072 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 4072 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2015` e WHERE e.player_id = 15775 AND league_id = 10089 ORDER BY e.date ASC |
| 0.0167 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10089 AND rel.player_id=15775 |
| 0.0148 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 10089 AND action = 18 |
| 0.0154 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 10089 AND action = 19 |
| 0.0152 | SELECT e.* FROM `events2015` e WHERE e.player_id = 15775 AND league_id = 3839 ORDER BY e.date ASC |
| 0.0153 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3839 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 3839 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 3839 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2015` e WHERE e.player_id = 15775 AND league_id = 3981 ORDER BY e.date ASC |
| 0.0150 | 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=15775 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 3981 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 3981 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2015` e WHERE e.player_id = 15775 AND league_id = 9298 ORDER BY e.date ASC |
| 0.0150 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9298 AND rel.player_id=15775 |
| 0.0152 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 9298 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 9298 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2015` e WHERE e.player_id = 15775 AND league_id = 10447 ORDER BY e.date ASC |
| 0.0146 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10447 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 10447 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 10447 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2015` e WHERE e.player_id = 15775 AND league_id = 10873 ORDER BY e.date ASC |
| 0.0148 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10873 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 10873 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 15775 AND league_id = 10873 AND action = 19 |
| 0.0149 | SELECT e.* FROM `events2014` e WHERE e.player_id = 15775 AND league_id = 2744 ORDER BY e.date ASC |
| 0.0168 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2744 AND rel.player_id=15775 |
| 0.0147 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 2744 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 2744 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2014` e WHERE e.player_id = 15775 AND league_id = 3652 ORDER BY e.date ASC |
| 0.0169 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3652 AND rel.player_id=15775 |
| 0.0149 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 3652 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 3652 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2014` e WHERE e.player_id = 15775 AND league_id = 3602 ORDER BY e.date ASC |
| 0.0180 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3602 AND rel.player_id=15775 |
| 0.0150 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 3602 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 3602 AND action = 19 |
| 0.0170 | 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=15775 |
| 0.0151 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 3602 AND action = 18 |
| 0.0151 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 3602 AND action = 19 |
| 0.0151 | SELECT e.* FROM `events2014` e WHERE e.player_id = 15775 AND league_id = 22554 ORDER BY e.date ASC |
| 0.0147 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 22554 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 22554 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 22554 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2014` e WHERE e.player_id = 15775 AND league_id = 47493 ORDER BY e.date ASC |
| 0.0156 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 47493 AND rel.player_id=15775 |
| 0.0152 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 47493 AND action = 18 |
| 0.0151 | SELECT action,minute FROM events2014 WHERE player_id = 15775 AND league_id = 47493 AND action = 19 |
| 0.0150 | SELECT e.* FROM `events2013` e WHERE e.player_id = 15775 AND league_id = 2082 ORDER BY e.date ASC |
| 0.0185 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2082 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2013 WHERE player_id = 15775 AND league_id = 2082 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2013 WHERE player_id = 15775 AND league_id = 2082 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2013` e WHERE e.player_id = 15775 AND league_id = 2109 ORDER BY e.date ASC |
| 0.0150 | 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=15775 |
| 0.0147 | SELECT action,minute FROM events2013 WHERE player_id = 15775 AND league_id = 2109 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2013 WHERE player_id = 15775 AND league_id = 2109 AND action = 19 |
| 0.0150 | SELECT e.* FROM `events2012` e WHERE e.player_id = 15775 AND league_id = 1485 ORDER BY e.date ASC |
| 0.0169 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1485 AND rel.player_id=15775 |
| 0.0149 | SELECT action,minute FROM events2012 WHERE player_id = 15775 AND league_id = 1485 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2012 WHERE player_id = 15775 AND league_id = 1485 AND action = 19 |
| 0.0150 | SELECT e.* FROM `events2012` e WHERE e.player_id = 15775 AND league_id = 14107 ORDER BY e.date ASC |
| 0.0175 | 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=15775 |
| 0.0151 | SELECT action,minute FROM events2012 WHERE player_id = 15775 AND league_id = 14107 AND action = 18 |
| 0.0151 | SELECT action,minute FROM events2012 WHERE player_id = 15775 AND league_id = 14107 AND action = 19 |
| 0.0159 | SELECT e.* FROM `events2011` e WHERE e.player_id = 15775 AND league_id = 1188 ORDER BY e.date ASC |
| 0.0328 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1188 AND rel.player_id=15775 |
| 0.0149 | SELECT action,minute FROM events2011 WHERE player_id = 15775 AND league_id = 1188 AND action = 18 |
| 0.0149 | SELECT action,minute FROM events2011 WHERE player_id = 15775 AND league_id = 1188 AND action = 19 |
| 0.0149 | SELECT e.* FROM `events2011` e WHERE e.player_id = 15775 AND league_id = 10610 ORDER BY e.date ASC |
| 0.0155 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10610 AND rel.player_id=15775 |
| 0.0151 | SELECT action,minute FROM events2011 WHERE player_id = 15775 AND league_id = 10610 AND action = 18 |
| 0.0151 | SELECT action,minute FROM events2011 WHERE player_id = 15775 AND league_id = 10610 AND action = 19 |
| 0.0156 | SELECT e.* FROM `events2011` e WHERE e.player_id = 15775 AND league_id = 14108 ORDER BY e.date ASC |
| 0.0202 | 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=15775 |
| 0.0152 | SELECT action,minute FROM events2011 WHERE player_id = 15775 AND league_id = 14108 AND action = 18 |
| 0.0149 | SELECT action,minute FROM events2011 WHERE player_id = 15775 AND league_id = 14108 AND action = 19 |
| 0.0150 | SELECT e.* FROM `events2010` e WHERE e.player_id = 15775 AND league_id = 873 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 = 873 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2010 WHERE player_id = 15775 AND league_id = 873 AND action = 18 |
| 0.0152 | SELECT action,minute FROM events2010 WHERE player_id = 15775 AND league_id = 873 AND action = 19 |
| 0.0150 | SELECT e.* FROM `events2010` e WHERE e.player_id = 15775 AND league_id = 14109 ORDER BY e.date ASC |
| 0.0180 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 14109 AND rel.player_id=15775 |
| 0.0151 | SELECT action,minute FROM events2010 WHERE player_id = 15775 AND league_id = 14109 AND action = 18 |
| 0.0151 | SELECT action,minute FROM events2010 WHERE player_id = 15775 AND league_id = 14109 AND action = 19 |
| 0.0151 | SELECT e.* FROM `events2010` e WHERE e.player_id = 15775 AND league_id = 39416 ORDER BY e.date ASC |
| 0.0201 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39416 AND rel.player_id=15775 |
| 0.0148 | SELECT action,minute FROM events2010 WHERE player_id = 15775 AND league_id = 39416 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2010 WHERE player_id = 15775 AND league_id = 39416 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2009` e WHERE e.player_id = 15775 AND league_id = 395 ORDER BY e.date ASC |
| 0.0183 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 395 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 395 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 395 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2009` e WHERE e.player_id = 15775 AND league_id = 11984 ORDER BY e.date ASC |
| 0.0168 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 11984 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 11984 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 11984 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2009` e WHERE e.player_id = 15775 AND league_id = 13200 ORDER BY e.date ASC |
| 0.0147 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 13200 AND rel.player_id=15775 |
| 0.0144 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 13200 AND action = 18 |
| 0.0144 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 13200 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2009` e WHERE e.player_id = 15775 AND league_id = 20704 ORDER BY e.date ASC |
| 0.0150 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20704 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 20704 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 20704 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2009` e WHERE e.player_id = 15775 AND league_id = 39417 ORDER BY e.date ASC |
| 0.0221 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39417 AND rel.player_id=15775 |
| 0.0147 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 39417 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 39417 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2009` e WHERE e.player_id = 15775 AND league_id = 39580 ORDER BY e.date ASC |
| 0.0150 | 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=15775 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 39580 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 39580 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2009` e WHERE e.player_id = 15775 AND league_id = 41917 ORDER BY e.date ASC |
| 0.0177 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41917 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 41917 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 41917 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2009` e WHERE e.player_id = 15775 AND league_id = 41918 ORDER BY e.date ASC |
| 0.0146 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41918 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 41918 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 15775 AND league_id = 41918 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2008` e WHERE e.player_id = 15775 AND league_id = 396 ORDER BY e.date ASC |
| 0.0169 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 396 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2008 WHERE player_id = 15775 AND league_id = 396 AND action = 18 |
| 0.0144 | SELECT action,minute FROM events2008 WHERE player_id = 15775 AND league_id = 396 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2008` e WHERE e.player_id = 15775 AND league_id = 10440 ORDER BY e.date ASC |
| 0.0146 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10440 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2008 WHERE player_id = 15775 AND league_id = 10440 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2008 WHERE player_id = 15775 AND league_id = 10440 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2008` e WHERE e.player_id = 15775 AND league_id = 39581 ORDER BY e.date ASC |
| 0.0153 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39581 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2008 WHERE player_id = 15775 AND league_id = 39581 AND action = 18 |
| 0.0144 | SELECT action,minute FROM events2008 WHERE player_id = 15775 AND league_id = 39581 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2007` e WHERE e.player_id = 15775 AND league_id = 44506 ORDER BY e.date ASC |
| 0.0159 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44506 AND rel.player_id=15775 |
| 0.0146 | SELECT action,minute FROM events2007 WHERE player_id = 15775 AND league_id = 44506 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2007 WHERE player_id = 15775 AND league_id = 44506 AND action = 19 |
| 0.0177 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44506 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2007 WHERE player_id = 15775 AND league_id = 44506 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2007 WHERE player_id = 15775 AND league_id = 44506 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2006` e WHERE e.player_id = 15775 AND league_id = 10371 ORDER BY e.date ASC |
| 0.0169 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 10371 AND rel.player_id=15775 |
| 0.0145 | SELECT action,minute FROM events2006 WHERE player_id = 15775 AND league_id = 10371 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2006 WHERE player_id = 15775 AND league_id = 10371 AND action = 19 |
J. Öst
T. Pöyhonen
M. Uusitalo
T. Koivisto
Martti Haukioja
M. Vainionpää
V. Tikkanen
N. Markkula
Pablo Andrade
M. Hradecky
A. Bates
J. Dunwoody
D. Rojas
N. Laine
Pyry Hannola
J. Monreal
J. Jervis
T. Kaukua
K. Ofori
Daniel Hakans
S. Atakayi