| 0.0016 |
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` = '386726'
|
| 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 = 'I-Ignatyev-386726' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0141 | 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 = 'I-Ignatyev-386726' 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 = 62835 |
| 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 = 62616 |
| 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 = 62617 |
| 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 = 57357 |
| 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 = 56547 |
| 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 = 58679 |
| 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 = 49956 |
| 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 = 50412 |
| 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 = 50645 |
| 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 = 50924 |
| 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 = 51193 |
| 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 = 43597 |
| 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 = 43602 |
| 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 = 44370 |
| 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 = 44999 |
| 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 = 48458 |
| 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 = 49145 |
| 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 = 49200 |
| 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 = 38674 |
| 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 = 38736 |
| 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 = 39156 |
| 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 = 39659 |
| 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 = 33446 |
| 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 = 33934 |
| 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 = 38206 |
| 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 = 38305 |
| 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 = 38338 |
| 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 = 15682 |
| 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 = 15793 |
| 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 = '386726'
|
| 0.0154 | 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 = 67320 AND rp.teamId = 2193 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC |
| 0.0023 | 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 = 386726 ORDER BY rp.year DESC |
| 0.0019 | 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 = '386726' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0018 | 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 = '386726' and rp.type = 3 |
| 0.0019 | SELECT e.* FROM `events2023` e WHERE e.player_id = 386726 AND league_id = 67320 ORDER BY e.date ASC |
| 0.0036 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67320 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2023 WHERE player_id = 386726 AND league_id = 67320 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2023 WHERE player_id = 386726 AND league_id = 67320 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2022` e WHERE e.player_id = 386726 AND league_id = 62835 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 = 62835 AND rel.player_id=386726 |
| 0.0021 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62835 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62835 AND action = 19 |
| 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 = 62835 AND rel.player_id=386726 |
| 0.0020 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62835 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62835 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2022` e WHERE e.player_id = 386726 AND league_id = 62616 ORDER BY e.date ASC |
| 0.0026 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62616 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62616 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62616 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2022` e WHERE e.player_id = 386726 AND league_id = 62617 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 = 62617 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62617 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62617 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2022` e WHERE e.player_id = 386726 AND league_id = 62807 ORDER BY e.date ASC |
| 0.0027 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62807 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62807 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 386726 AND league_id = 62807 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2021` e WHERE e.player_id = 386726 AND league_id = 57357 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 = 57357 AND rel.player_id=386726 |
| 0.0022 | SELECT action,minute FROM events2021 WHERE player_id = 386726 AND league_id = 57357 AND action = 18 |
| 0.0024 | SELECT action,minute FROM events2021 WHERE player_id = 386726 AND league_id = 57357 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2021` e WHERE e.player_id = 386726 AND league_id = 56547 ORDER BY e.date ASC |
| 0.0044 | 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=386726 |
| 0.0018 | SELECT action,minute FROM events2021 WHERE player_id = 386726 AND league_id = 56547 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2021 WHERE player_id = 386726 AND league_id = 56547 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2021` e WHERE e.player_id = 386726 AND league_id = 58679 ORDER BY e.date ASC |
| 0.0027 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58679 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2021 WHERE player_id = 386726 AND league_id = 58679 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2021 WHERE player_id = 386726 AND league_id = 58679 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 386726 AND league_id = 49956 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 = 49956 AND rel.player_id=386726 |
| 0.0024 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49956 AND action = 18 |
| 0.0023 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49956 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2020` e WHERE e.player_id = 386726 AND league_id = 49957 ORDER BY e.date ASC |
| 0.0023 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49957 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49957 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49957 AND action = 19 |
| 0.0044 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49956 AND rel.player_id=386726 |
| 0.0029 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49956 AND action = 18 |
| 0.0028 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49956 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2020` e WHERE e.player_id = 386726 AND league_id = 49506 ORDER BY e.date ASC |
| 0.0051 | 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=386726 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49506 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49506 AND action = 19 |
| 0.0030 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49506 AND rel.player_id=386726 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49506 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 49506 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 386726 AND league_id = 50412 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 = 50412 AND rel.player_id=386726 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 50412 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 50412 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 386726 AND league_id = 50645 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 = 50645 AND rel.player_id=386726 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 50645 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 50645 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 386726 AND league_id = 50924 ORDER BY e.date ASC |
| 0.0027 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50924 AND rel.player_id=386726 |
| 0.0020 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 50924 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 50924 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 386726 AND league_id = 51193 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 = 51193 AND rel.player_id=386726 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 51193 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 386726 AND league_id = 51193 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2019` e WHERE e.player_id = 386726 AND league_id = 43597 ORDER BY e.date ASC |
| 0.0049 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43597 AND rel.player_id=386726 |
| 0.0024 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 43597 AND action = 18 |
| 0.0023 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 43597 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2019` e WHERE e.player_id = 386726 AND league_id = 43602 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 = 43602 AND rel.player_id=386726 |
| 0.0025 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 43602 AND action = 18 |
| 0.0025 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 43602 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2019` e WHERE e.player_id = 386726 AND league_id = 43475 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 = 43475 AND rel.player_id=386726 |
| 0.0019 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 43475 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 43475 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2019` e WHERE e.player_id = 386726 AND league_id = 44370 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 = 44370 AND rel.player_id=386726 |
| 0.0020 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 44370 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 44370 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2019` e WHERE e.player_id = 386726 AND league_id = 44999 ORDER BY e.date ASC |
| 0.0035 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44999 AND rel.player_id=386726 |
| 0.0022 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 44999 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 44999 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2019` e WHERE e.player_id = 386726 AND league_id = 48458 ORDER BY e.date ASC |
| 0.0042 | 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=386726 |
| 0.0022 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 48458 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 48458 AND action = 19 |
| 0.0023 | SELECT e.* FROM `events2019` e WHERE e.player_id = 386726 AND league_id = 49145 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 = 49145 AND rel.player_id=386726 |
| 0.0023 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 49145 AND action = 18 |
| 0.0024 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 49145 AND action = 19 |
| 0.0025 | SELECT e.* FROM `events2019` e WHERE e.player_id = 386726 AND league_id = 49200 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 = 49200 AND rel.player_id=386726 |
| 0.0029 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 49200 AND action = 18 |
| 0.0029 | SELECT action,minute FROM events2019 WHERE player_id = 386726 AND league_id = 49200 AND action = 19 |
| 0.0025 | SELECT e.* FROM `events2018` e WHERE e.player_id = 386726 AND league_id = 38674 ORDER BY e.date ASC |
| 0.0059 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38674 AND rel.player_id=386726 |
| 0.0032 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38674 AND action = 18 |
| 0.0032 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38674 AND action = 19 |
| 0.0029 | SELECT e.* FROM `events2018` e WHERE e.player_id = 386726 AND league_id = 38736 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 = 38736 AND rel.player_id=386726 |
| 0.0050 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38736 AND action = 18 |
| 0.0058 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38736 AND action = 19 |
| 0.0025 | SELECT e.* FROM `events2018` e WHERE e.player_id = 386726 AND league_id = 39156 ORDER BY e.date ASC |
| 0.0115 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39156 AND rel.player_id=386726 |
| 0.0020 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 39156 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 39156 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2018` e WHERE e.player_id = 386726 AND league_id = 38380 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 = 38380 AND rel.player_id=386726 |
| 0.0022 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38380 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38380 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2018` e WHERE e.player_id = 386726 AND league_id = 38427 ORDER BY e.date ASC |
| 0.0046 | 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=386726 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38427 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38427 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2018` e WHERE e.player_id = 386726 AND league_id = 38744 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 = 38744 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38744 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38744 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2018` e WHERE e.player_id = 386726 AND league_id = 38745 ORDER BY e.date ASC |
| 0.0054 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38745 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38745 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 38745 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2018` e WHERE e.player_id = 386726 AND league_id = 39659 ORDER BY e.date ASC |
| 0.0062 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39659 AND rel.player_id=386726 |
| 0.0019 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 39659 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 386726 AND league_id = 39659 AND action = 19 |
| 0.0024 | SELECT e.* FROM `events2017` e WHERE e.player_id = 386726 AND league_id = 33446 ORDER BY e.date ASC |
| 0.0080 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33446 AND rel.player_id=386726 |
| 0.0023 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 33446 AND action = 18 |
| 0.0024 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 33446 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2017` e WHERE e.player_id = 386726 AND league_id = 33934 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 = 33934 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 33934 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 33934 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2017` e WHERE e.player_id = 386726 AND league_id = 38206 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 = 38206 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 38206 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 38206 AND action = 19 |
| 0.0024 | SELECT e.* FROM `events2017` e WHERE e.player_id = 386726 AND league_id = 38305 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 = 38305 AND rel.player_id=386726 |
| 0.0019 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 38305 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 38305 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2017` e WHERE e.player_id = 386726 AND league_id = 38338 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 = 38338 AND rel.player_id=386726 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 38338 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 386726 AND league_id = 38338 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2016` e WHERE e.player_id = 386726 AND league_id = 15682 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 = 15682 AND rel.player_id=386726 |
| 0.0021 | SELECT action,minute FROM events2016 WHERE player_id = 386726 AND league_id = 15682 AND action = 18 |
| 0.0024 | SELECT action,minute FROM events2016 WHERE player_id = 386726 AND league_id = 15682 AND action = 19 |
| 0.0023 | SELECT e.* FROM `events2016` e WHERE e.player_id = 386726 AND league_id = 15793 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 = 15793 AND rel.player_id=386726 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 386726 AND league_id = 15793 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 386726 AND league_id = 15793 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2016` e WHERE e.player_id = 386726 AND league_id = 21314 ORDER BY e.date ASC |
| 0.0027 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 21314 AND rel.player_id=386726 |
| 0.0021 | SELECT action,minute FROM events2016 WHERE player_id = 386726 AND league_id = 21314 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 386726 AND league_id = 21314 AND action = 19 |
I. Konovalov
A. Gorodovoy
Nikita Yanovich
N. Medvedev
Y. Dyupin
A. Belenov
Artem Ismagilov
Nikita Korets
R. Bagautdinov
Ebert Belorusov
Egor Teslenko
S. Begic
A. Martynovich
F. Uremovic
R. Ashurmatov
V. Ignatjev
G. Zotov
A. Gritsaenko
D. Makarov
Ilya Rozhkov
A. Adnan
M. Shiryaev
D. Kabutov
I. Samoshnikov
K. Nizhegorodov
I. Popov
Stepan Surikov
In-Beom Hwang
A. Dzagoev
D. Jevtic
I. Gorbunov
M. Saito
M. Apshatsev
Oleg Ivanov
A. Zotov
Ruslan Bezrukov
Oliver Abildgaard
O. Shatov
Leon Musaev
Aleksandr Saplinov
D. Motorin
V. Chuperka
K. Klimov
A. Zuev
Daniil Kuznetsov
S. Bakaev
A. Popov
D. Despotović
A. Lomovitski
M. Kostyukov
K. Mullin
Joel Fameyeh
K. Kvaratskhelia
V. Lisakovich
M. Uridia
K. Kosarev
Lenar Fattakhov
Sead Haksabanovic