| 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` = '68038'
|
| 0.0159 | 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 = 'C-Freitag-68038' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0380 | 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 = 'C-Freitag-68038' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 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 = 68052 |
| 0.0171 | 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 = 68059 |
| 0.0171 | 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 = 63139 |
| 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 = 63190 |
| 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 = 58548 |
| 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 = 56547 |
| 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 = 50149 |
| 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 = 50650 |
| 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 = 50221 |
| 0.0150 | 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 = 43673 |
| 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 = 49412 |
| 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 = 44346 |
| 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 = 38776 |
| 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 = 38838 |
| 0.0163 | 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 = 33336 |
| 0.0171 | 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 = 33329 |
| 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 = 15704 |
| 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 = 16135 |
| 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 = 2482 |
| 0.0171 | 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 = 20742 |
| 0.0171 | 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 = 2014 |
| 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 = 20741 |
| 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 = 8927 |
| 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 = 24533 |
| 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 = 20739 |
| 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 = 8925 |
| 0.0149 | 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 = 20738 |
| 0.0150 | 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 = 8921 |
| 0.0144 | 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 = '68038'
|
| 0.0151 | 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 = 68052 AND rp.teamId = 12394 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC |
| 0.0149 | 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 = 68038 ORDER BY rp.year DESC |
| 0.0145 | 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 = '68038' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0145 | 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 = '68038' and rp.type = 3 |
| 0.0145 | SELECT e.* FROM `events2023` e WHERE e.player_id = 68038 AND league_id = 68052 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 = 68052 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2023 WHERE player_id = 68038 AND league_id = 68052 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2023 WHERE player_id = 68038 AND league_id = 68052 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2023` e WHERE e.player_id = 68038 AND league_id = 67320 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 = 67320 AND rel.player_id=68038 |
| 0.0148 | SELECT action,minute FROM events2023 WHERE player_id = 68038 AND league_id = 67320 AND action = 18 |
| 0.0150 | SELECT action,minute FROM events2023 WHERE player_id = 68038 AND league_id = 67320 AND action = 19 |
| 0.0149 | SELECT e.* FROM `events2023` e WHERE e.player_id = 68038 AND league_id = 68059 ORDER BY e.date ASC |
| 0.0219 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 68059 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2023 WHERE player_id = 68038 AND league_id = 68059 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2023 WHERE player_id = 68038 AND league_id = 68059 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2022` e WHERE e.player_id = 68038 AND league_id = 63139 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 = 63139 AND rel.player_id=68038 |
| 0.0147 | SELECT action,minute FROM events2022 WHERE player_id = 68038 AND league_id = 63139 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2022 WHERE player_id = 68038 AND league_id = 63139 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2022` e WHERE e.player_id = 68038 AND league_id = 63190 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 = 63190 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2022 WHERE player_id = 68038 AND league_id = 63190 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2022 WHERE player_id = 68038 AND league_id = 63190 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2021` e WHERE e.player_id = 68038 AND league_id = 58548 ORDER BY e.date ASC |
| 0.0161 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58548 AND rel.player_id=68038 |
| 0.0148 | SELECT action,minute FROM events2021 WHERE player_id = 68038 AND league_id = 58548 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2021 WHERE player_id = 68038 AND league_id = 58548 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2021` e WHERE e.player_id = 68038 AND league_id = 56547 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 = 56547 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2021 WHERE player_id = 68038 AND league_id = 56547 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2021 WHERE player_id = 68038 AND league_id = 56547 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2021` e WHERE e.player_id = 68038 AND league_id = 57797 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 = 57797 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2021 WHERE player_id = 68038 AND league_id = 57797 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2021 WHERE player_id = 68038 AND league_id = 57797 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2020` e WHERE e.player_id = 68038 AND league_id = 50149 ORDER BY e.date ASC |
| 0.0178 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50149 AND rel.player_id=68038 |
| 0.0147 | SELECT action,minute FROM events2020 WHERE player_id = 68038 AND league_id = 50149 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2020 WHERE player_id = 68038 AND league_id = 50149 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2020` e WHERE e.player_id = 68038 AND league_id = 50650 ORDER BY e.date ASC |
| 0.0152 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50650 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2020 WHERE player_id = 68038 AND league_id = 50650 AND action = 18 |
| 0.0144 | SELECT action,minute FROM events2020 WHERE player_id = 68038 AND league_id = 50650 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2020` e WHERE e.player_id = 68038 AND league_id = 49506 ORDER BY e.date ASC |
| 0.0189 | 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=68038 |
| 0.0145 | SELECT action,minute FROM events2020 WHERE player_id = 68038 AND league_id = 49506 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2020 WHERE player_id = 68038 AND league_id = 49506 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2020` e WHERE e.player_id = 68038 AND league_id = 50221 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 = 50221 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2020 WHERE player_id = 68038 AND league_id = 50221 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2020 WHERE player_id = 68038 AND league_id = 50221 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2019` e WHERE e.player_id = 68038 AND league_id = 43673 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 = 43673 AND rel.player_id=68038 |
| 0.0146 | SELECT action,minute FROM events2019 WHERE player_id = 68038 AND league_id = 43673 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2019 WHERE player_id = 68038 AND league_id = 43673 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2019` e WHERE e.player_id = 68038 AND league_id = 49412 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 = 49412 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2019 WHERE player_id = 68038 AND league_id = 49412 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2019 WHERE player_id = 68038 AND league_id = 49412 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2019` e WHERE e.player_id = 68038 AND league_id = 43475 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 = 43475 AND rel.player_id=68038 |
| 0.0147 | SELECT action,minute FROM events2019 WHERE player_id = 68038 AND league_id = 43475 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2019 WHERE player_id = 68038 AND league_id = 43475 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2019` e WHERE e.player_id = 68038 AND league_id = 44346 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 = 44346 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2019 WHERE player_id = 68038 AND league_id = 44346 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2019 WHERE player_id = 68038 AND league_id = 44346 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2018` e WHERE e.player_id = 68038 AND league_id = 38776 ORDER BY e.date ASC |
| 0.0162 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38776 AND rel.player_id=68038 |
| 0.0149 | SELECT action,minute FROM events2018 WHERE player_id = 68038 AND league_id = 38776 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2018 WHERE player_id = 68038 AND league_id = 38776 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2018` e WHERE e.player_id = 68038 AND league_id = 38427 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 = 38427 AND rel.player_id=68038 |
| 0.0144 | SELECT action,minute FROM events2018 WHERE player_id = 68038 AND league_id = 38427 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2018 WHERE player_id = 68038 AND league_id = 38427 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2018` e WHERE e.player_id = 68038 AND league_id = 38838 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 = 38838 AND rel.player_id=68038 |
| 0.0146 | SELECT action,minute FROM events2018 WHERE player_id = 68038 AND league_id = 38838 AND action = 18 |
| 0.0150 | SELECT action,minute FROM events2018 WHERE player_id = 68038 AND league_id = 38838 AND action = 19 |
| 0.0152 | SELECT e.* FROM `events2017` e WHERE e.player_id = 68038 AND league_id = 33336 ORDER BY e.date ASC |
| 0.0178 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33336 AND rel.player_id=68038 |
| 0.0147 | SELECT action,minute FROM events2017 WHERE player_id = 68038 AND league_id = 33336 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2017 WHERE player_id = 68038 AND league_id = 33336 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2017` e WHERE e.player_id = 68038 AND league_id = 30386 ORDER BY e.date ASC |
| 0.0163 | 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=68038 |
| 0.0145 | SELECT action,minute FROM events2017 WHERE player_id = 68038 AND league_id = 30386 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2017 WHERE player_id = 68038 AND league_id = 30386 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2017` e WHERE e.player_id = 68038 AND league_id = 33329 ORDER BY e.date ASC |
| 0.0162 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33329 AND rel.player_id=68038 |
| 0.0147 | SELECT action,minute FROM events2017 WHERE player_id = 68038 AND league_id = 33329 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2017 WHERE player_id = 68038 AND league_id = 33329 AND action = 19 |
| 0.0155 | SELECT e.* FROM `events2016` e WHERE e.player_id = 68038 AND league_id = 15704 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 = 15704 AND rel.player_id=68038 |
| 0.0146 | SELECT action,minute FROM events2016 WHERE player_id = 68038 AND league_id = 15704 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2016 WHERE player_id = 68038 AND league_id = 15704 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2016` e WHERE e.player_id = 68038 AND league_id = 16135 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 = 16135 AND rel.player_id=68038 |
| 0.0146 | SELECT action,minute FROM events2016 WHERE player_id = 68038 AND league_id = 16135 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2016 WHERE player_id = 68038 AND league_id = 16135 AND action = 19 |
| 0.0149 | SELECT e.* FROM `events2015` e WHERE e.player_id = 68038 AND league_id = 3813 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 = 3813 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 68038 AND league_id = 3813 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2015 WHERE player_id = 68038 AND league_id = 3813 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2015` e WHERE e.player_id = 68038 AND league_id = 9283 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 = 9283 AND rel.player_id=68038 |
| 0.0147 | SELECT action,minute FROM events2015 WHERE player_id = 68038 AND league_id = 9283 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 68038 AND league_id = 9283 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2014` e WHERE e.player_id = 68038 AND league_id = 2482 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 = 2482 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2014 WHERE player_id = 68038 AND league_id = 2482 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2014 WHERE player_id = 68038 AND league_id = 2482 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2014` e WHERE e.player_id = 68038 AND league_id = 20742 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 = 20742 AND rel.player_id=68038 |
| 0.0146 | SELECT action,minute FROM events2014 WHERE player_id = 68038 AND league_id = 20742 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2014 WHERE player_id = 68038 AND league_id = 20742 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2013` e WHERE e.player_id = 68038 AND league_id = 2014 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 = 2014 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2013 WHERE player_id = 68038 AND league_id = 2014 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2013 WHERE player_id = 68038 AND league_id = 2014 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2013` e WHERE e.player_id = 68038 AND league_id = 20741 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 = 20741 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2013 WHERE player_id = 68038 AND league_id = 20741 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2013 WHERE player_id = 68038 AND league_id = 20741 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2012` e WHERE e.player_id = 68038 AND league_id = 8927 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 = 8927 AND rel.player_id=68038 |
| 0.0146 | SELECT action,minute FROM events2012 WHERE player_id = 68038 AND league_id = 8927 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2012 WHERE player_id = 68038 AND league_id = 8927 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2012` e WHERE e.player_id = 68038 AND league_id = 20740 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 = 20740 AND rel.player_id=68038 |
| 0.0146 | SELECT action,minute FROM events2012 WHERE player_id = 68038 AND league_id = 20740 AND action = 18 |
| 0.0144 | SELECT action,minute FROM events2012 WHERE player_id = 68038 AND league_id = 20740 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2011` e WHERE e.player_id = 68038 AND league_id = 24533 ORDER BY e.date ASC |
| 0.0184 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 24533 AND rel.player_id=68038 |
| 0.0146 | SELECT action,minute FROM events2011 WHERE player_id = 68038 AND league_id = 24533 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2011 WHERE player_id = 68038 AND league_id = 24533 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2011` e WHERE e.player_id = 68038 AND league_id = 20739 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 = 20739 AND rel.player_id=68038 |
| 0.0148 | SELECT action,minute FROM events2011 WHERE player_id = 68038 AND league_id = 20739 AND action = 18 |
| 0.0149 | SELECT action,minute FROM events2011 WHERE player_id = 68038 AND league_id = 20739 AND action = 19 |
| 0.0153 | SELECT e.* FROM `events2010` e WHERE e.player_id = 68038 AND league_id = 8925 ORDER BY e.date ASC |
| 0.0206 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 8925 AND rel.player_id=68038 |
| 0.0149 | SELECT action,minute FROM events2010 WHERE player_id = 68038 AND league_id = 8925 AND action = 18 |
| 0.0149 | SELECT action,minute FROM events2010 WHERE player_id = 68038 AND league_id = 8925 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2010` e WHERE e.player_id = 68038 AND league_id = 20738 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 = 20738 AND rel.player_id=68038 |
| 0.0148 | SELECT action,minute FROM events2010 WHERE player_id = 68038 AND league_id = 20738 AND action = 18 |
| 0.0149 | SELECT action,minute FROM events2010 WHERE player_id = 68038 AND league_id = 20738 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2009` e WHERE e.player_id = 68038 AND league_id = 8924 ORDER BY e.date ASC |
| 0.0173 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 8924 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 68038 AND league_id = 8924 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2009 WHERE player_id = 68038 AND league_id = 8924 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2009` e WHERE e.player_id = 68038 AND league_id = 20737 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 = 20737 AND rel.player_id=68038 |
| 0.0144 | SELECT action,minute FROM events2009 WHERE player_id = 68038 AND league_id = 20737 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2009 WHERE player_id = 68038 AND league_id = 20737 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2008` e WHERE e.player_id = 68038 AND league_id = 8921 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 = 8921 AND rel.player_id=68038 |
| 0.0145 | SELECT action,minute FROM events2008 WHERE player_id = 68038 AND league_id = 8921 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2008 WHERE player_id = 68038 AND league_id = 8921 AND action = 19 |
V. Hüttner
Nikolas Polster
Florian Eres
D. Bumberger
A. Prada
M. Lageder
G. Dombaxi
Nico Wiesinger
D. Marceta
P. Malicsek
Nicolas Zdichynec
S. Sprangler
O. Filip
Noah Bitsche
M. Şatin
Faris Zubanovic
Tobias Pellegrini
Eldin Sehic
K. Yilmaz