| 0.0019 |
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` = '295241'
|
| 0.0134 | 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 = 'P-Roller-295241' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0350 | 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 = 'P-Roller-295241' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 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 = 63250 |
| 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 = 62588 |
| 0.0143 | 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 = 64478 |
| 0.0146 | 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 = 66456 |
| 0.0145 | 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 = 61155 |
| 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 = 61158 |
| 0.0132 | 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 = 65341 |
| 0.0131 | 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 = 55277 |
| 0.0132 | 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 = 64654 |
| 0.0132 | 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 = 66240 |
| 0.0133 | 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 = 48753 |
| 0.0131 | 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 = 49347 |
| 0.0133 | 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 = 42548 |
| 0.0132 | 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 = 38428 |
| 0.0134 | 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 = 47911 |
| 0.0132 | 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 = 47912 |
| 0.0131 | 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.0130 | 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 = 38905 |
| 0.0133 | 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.0130 | 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 = 15772 |
| 0.0133 | 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.0132 | 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 = 3903 |
| 0.0132 | 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 = 4377 |
| 0.0131 | 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 = 3544 |
| 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 = 27075 |
| 0.0131 | 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 = 27079 |
| 0.0132 | 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 = 49576 |
| 0.0132 | 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 = 44063 |
| 0.0132 | 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 = 71898 |
| 0.0124 | 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 = '295241'
|
| 0.0130 | 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 = 295241 ORDER BY rp.year DESC |
| 0.0125 | 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 = '295241' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0125 | 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 = '295241' and rp.type = 3 |
| 0.0126 | SELECT e.* FROM `events2022` e WHERE e.player_id = 295241 AND league_id = 63250 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 = 63250 AND rel.player_id=295241 |
| 0.0129 | SELECT action,minute FROM events2022 WHERE player_id = 295241 AND league_id = 63250 AND action = 18 |
| 0.0132 | SELECT action,minute FROM events2022 WHERE player_id = 295241 AND league_id = 63250 AND action = 19 |
| 0.0129 | SELECT e.* FROM `events2022` e WHERE e.player_id = 295241 AND league_id = 62588 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 = 62588 AND rel.player_id=295241 |
| 0.0131 | SELECT action,minute FROM events2022 WHERE player_id = 295241 AND league_id = 62588 AND action = 18 |
| 0.0130 | SELECT action,minute FROM events2022 WHERE player_id = 295241 AND league_id = 62588 AND action = 19 |
| 0.0132 | SELECT e.* FROM `events2022` e WHERE e.player_id = 295241 AND league_id = 64478 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 = 64478 AND rel.player_id=295241 |
| 0.0132 | SELECT action,minute FROM events2022 WHERE player_id = 295241 AND league_id = 64478 AND action = 18 |
| 0.0131 | SELECT action,minute FROM events2022 WHERE player_id = 295241 AND league_id = 64478 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2022` e WHERE e.player_id = 295241 AND league_id = 66456 ORDER BY e.date ASC |
| 0.0126 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66456 AND rel.player_id=295241 |
| 0.0125 | SELECT action,minute FROM events2022 WHERE player_id = 295241 AND league_id = 66456 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2022 WHERE player_id = 295241 AND league_id = 66456 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2021` e WHERE e.player_id = 295241 AND league_id = 56833 ORDER BY e.date ASC |
| 0.0137 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 56833 AND rel.player_id=295241 |
| 0.0125 | SELECT action,minute FROM events2021 WHERE player_id = 295241 AND league_id = 56833 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2021 WHERE player_id = 295241 AND league_id = 56833 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2021` e WHERE e.player_id = 295241 AND league_id = 61155 ORDER BY e.date ASC |
| 0.0127 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61155 AND rel.player_id=295241 |
| 0.0125 | SELECT action,minute FROM events2021 WHERE player_id = 295241 AND league_id = 61155 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2021 WHERE player_id = 295241 AND league_id = 61155 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2021` e WHERE e.player_id = 295241 AND league_id = 61158 ORDER BY e.date ASC |
| 0.0127 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61158 AND rel.player_id=295241 |
| 0.0126 | SELECT action,minute FROM events2021 WHERE player_id = 295241 AND league_id = 61158 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2021 WHERE player_id = 295241 AND league_id = 61158 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2021` e WHERE e.player_id = 295241 AND league_id = 65341 ORDER BY e.date ASC |
| 0.0128 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 65341 AND rel.player_id=295241 |
| 0.0126 | SELECT action,minute FROM events2021 WHERE player_id = 295241 AND league_id = 65341 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2021 WHERE player_id = 295241 AND league_id = 65341 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2020` e WHERE e.player_id = 295241 AND league_id = 55277 ORDER BY e.date ASC |
| 0.0141 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 55277 AND rel.player_id=295241 |
| 0.0128 | SELECT action,minute FROM events2020 WHERE player_id = 295241 AND league_id = 55277 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2020 WHERE player_id = 295241 AND league_id = 55277 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2020` e WHERE e.player_id = 295241 AND league_id = 64654 ORDER BY e.date ASC |
| 0.0132 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 64654 AND rel.player_id=295241 |
| 0.0125 | SELECT action,minute FROM events2020 WHERE player_id = 295241 AND league_id = 64654 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2020 WHERE player_id = 295241 AND league_id = 64654 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2020` e WHERE e.player_id = 295241 AND league_id = 66240 ORDER BY e.date ASC |
| 0.0126 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66240 AND rel.player_id=295241 |
| 0.0126 | SELECT action,minute FROM events2020 WHERE player_id = 295241 AND league_id = 66240 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2020 WHERE player_id = 295241 AND league_id = 66240 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2019` e WHERE e.player_id = 295241 AND league_id = 48753 ORDER BY e.date ASC |
| 0.0143 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48753 AND rel.player_id=295241 |
| 0.0127 | SELECT action,minute FROM events2019 WHERE player_id = 295241 AND league_id = 48753 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2019 WHERE player_id = 295241 AND league_id = 48753 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2019` e WHERE e.player_id = 295241 AND league_id = 49347 ORDER BY e.date ASC |
| 0.0125 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49347 AND rel.player_id=295241 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 295241 AND league_id = 49347 AND action = 18 |
| 0.0129 | SELECT action,minute FROM events2019 WHERE player_id = 295241 AND league_id = 49347 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2019` e WHERE e.player_id = 295241 AND league_id = 50535 ORDER BY e.date ASC |
| 0.0140 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50535 AND rel.player_id=295241 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 295241 AND league_id = 50535 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 295241 AND league_id = 50535 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2019` e WHERE e.player_id = 295241 AND league_id = 43333 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 = 43333 AND rel.player_id=295241 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 295241 AND league_id = 43333 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 295241 AND league_id = 43333 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2018` e WHERE e.player_id = 295241 AND league_id = 38776 ORDER BY e.date ASC |
| 0.0139 | 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=295241 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 38776 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 38776 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2018` e WHERE e.player_id = 295241 AND league_id = 42548 ORDER BY e.date ASC |
| 0.0140 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42548 AND rel.player_id=295241 |
| 0.0128 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 42548 AND action = 18 |
| 0.0129 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 42548 AND action = 19 |
| 0.0129 | SELECT e.* FROM `events2018` e WHERE e.player_id = 295241 AND league_id = 38427 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 = 38427 AND rel.player_id=295241 |
| 0.0129 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 38427 AND action = 18 |
| 0.0133 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 38427 AND action = 19 |
| 0.0133 | SELECT e.* FROM `events2018` e WHERE e.player_id = 295241 AND league_id = 38428 ORDER BY e.date ASC |
| 0.0141 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38428 AND rel.player_id=295241 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 38428 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 38428 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2018` e WHERE e.player_id = 295241 AND league_id = 47911 ORDER BY e.date ASC |
| 0.0128 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 47911 AND rel.player_id=295241 |
| 0.0126 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 47911 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 47911 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2018` e WHERE e.player_id = 295241 AND league_id = 47912 ORDER BY e.date ASC |
| 0.0126 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 47912 AND rel.player_id=295241 |
| 0.0126 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 47912 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 295241 AND league_id = 47912 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2017` e WHERE e.player_id = 295241 AND league_id = 33336 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 = 33336 AND rel.player_id=295241 |
| 0.0128 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 33336 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 33336 AND action = 19 |
| 0.0134 | SELECT e.* FROM `events2017` e WHERE e.player_id = 295241 AND league_id = 37724 ORDER BY e.date ASC |
| 0.0137 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37724 AND rel.player_id=295241 |
| 0.0128 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 37724 AND action = 18 |
| 0.0129 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 37724 AND action = 19 |
| 0.0128 | SELECT e.* FROM `events2017` e WHERE e.player_id = 295241 AND league_id = 38905 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 = 38905 AND rel.player_id=295241 |
| 0.0127 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 38905 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 38905 AND action = 19 |
| 0.0132 | SELECT e.* FROM `events2017` e WHERE e.player_id = 295241 AND league_id = 30386 ORDER BY e.date ASC |
| 0.0215 | 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=295241 |
| 0.0129 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 30386 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 30386 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2017` e WHERE e.player_id = 295241 AND league_id = 33329 ORDER BY e.date ASC |
| 0.0133 | 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=295241 |
| 0.0126 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 33329 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2017 WHERE player_id = 295241 AND league_id = 33329 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2016` e WHERE e.player_id = 295241 AND league_id = 15704 ORDER BY e.date ASC |
| 0.0138 | 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=295241 |
| 0.0126 | SELECT action,minute FROM events2016 WHERE player_id = 295241 AND league_id = 15704 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2016 WHERE player_id = 295241 AND league_id = 15704 AND action = 19 |
| 0.0129 | SELECT e.* FROM `events2016` e WHERE e.player_id = 295241 AND league_id = 15772 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 = 15772 AND rel.player_id=295241 |
| 0.0131 | SELECT action,minute FROM events2016 WHERE player_id = 295241 AND league_id = 15772 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2016 WHERE player_id = 295241 AND league_id = 15772 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2016` e WHERE e.player_id = 295241 AND league_id = 16135 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 = 16135 AND rel.player_id=295241 |
| 0.0131 | SELECT action,minute FROM events2016 WHERE player_id = 295241 AND league_id = 16135 AND action = 18 |
| 0.0132 | SELECT action,minute FROM events2016 WHERE player_id = 295241 AND league_id = 16135 AND action = 19 |
| 0.0136 | SELECT e.* FROM `events2015` e WHERE e.player_id = 295241 AND league_id = 3903 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 = 3903 AND rel.player_id=295241 |
| 0.0125 | SELECT action,minute FROM events2015 WHERE player_id = 295241 AND league_id = 3903 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2015 WHERE player_id = 295241 AND league_id = 3903 AND action = 19 |
| 0.0129 | SELECT e.* FROM `events2015` e WHERE e.player_id = 295241 AND league_id = 4377 ORDER BY e.date ASC |
| 0.0142 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4377 AND rel.player_id=295241 |
| 0.0126 | SELECT action,minute FROM events2015 WHERE player_id = 295241 AND league_id = 4377 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2015 WHERE player_id = 295241 AND league_id = 4377 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2014` e WHERE e.player_id = 295241 AND league_id = 3544 ORDER BY e.date ASC |
| 0.0137 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3544 AND rel.player_id=295241 |
| 0.0127 | SELECT action,minute FROM events2014 WHERE player_id = 295241 AND league_id = 3544 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2014 WHERE player_id = 295241 AND league_id = 3544 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2013` e WHERE e.player_id = 295241 AND league_id = 23836 ORDER BY e.date ASC |
| 0.0138 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 23836 AND rel.player_id=295241 |
| 0.0129 | SELECT action,minute FROM events2013 WHERE player_id = 295241 AND league_id = 23836 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2013 WHERE player_id = 295241 AND league_id = 23836 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2013` e WHERE e.player_id = 295241 AND league_id = 27075 ORDER BY e.date ASC |
| 0.0144 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 27075 AND rel.player_id=295241 |
| 0.0128 | SELECT action,minute FROM events2013 WHERE player_id = 295241 AND league_id = 27075 AND action = 18 |
| 0.0129 | SELECT action,minute FROM events2013 WHERE player_id = 295241 AND league_id = 27075 AND action = 19 |
| 0.0130 | SELECT e.* FROM `events2012` e WHERE e.player_id = 295241 AND league_id = 27079 ORDER BY e.date ASC |
| 0.0138 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 27079 AND rel.player_id=295241 |
| 0.0126 | SELECT action,minute FROM events2012 WHERE player_id = 295241 AND league_id = 27079 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2012 WHERE player_id = 295241 AND league_id = 27079 AND action = 19 |
| 0.0131 | SELECT e.* FROM `events2012` e WHERE e.player_id = 295241 AND league_id = 49576 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 = 49576 AND rel.player_id=295241 |
| 0.0132 | SELECT action,minute FROM events2012 WHERE player_id = 295241 AND league_id = 49576 AND action = 18 |
| 0.0132 | SELECT action,minute FROM events2012 WHERE player_id = 295241 AND league_id = 49576 AND action = 19 |
| 0.0138 | SELECT e.* FROM `events2011` e WHERE e.player_id = 295241 AND league_id = 44063 ORDER BY e.date ASC |
| 0.0289 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44063 AND rel.player_id=295241 |
| 0.0129 | SELECT action,minute FROM events2011 WHERE player_id = 295241 AND league_id = 44063 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2011 WHERE player_id = 295241 AND league_id = 44063 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2011` e WHERE e.player_id = 295241 AND league_id = 71898 ORDER BY e.date ASC |
| 0.0142 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71898 AND rel.player_id=295241 |
| 0.0126 | SELECT action,minute FROM events2011 WHERE player_id = 295241 AND league_id = 71898 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2011 WHERE player_id = 295241 AND league_id = 71898 AND action = 19 |
W. Buathong
K. Thammasatchanan
Airton
A. Promrak
Rochela
M. Steuble
Negueba
Sergio Suárez
C. Chappuis
T. Kesarat
S. Limwatthana
W. Weidersjoe
P. Prempakdee
B. Phala
N. Sriyankem
J. Patiño
N. Bonilla
A. Kraisorn