| 0.0004 |
SELECT
COUNT(DISTINCT c.`id`) AS num
FROM comments AS c
WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0
AND c.comment_id!=0
AND c.lang = '1'
AND c.`playerId` = '308161'
|
| 0.0135 | 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 = 'Irving-Maurozurita-Garcia-308161' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0565 | 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 = 'Irving-Maurozurita-Garcia-308161' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 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 = 67937 |
| 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 = 70110 |
| 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 = 63294 |
| 0.0138 | 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 = 65968 |
| 0.0138 | 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 = 66236 |
| 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 = 67354 |
| 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 = 56984 |
| 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 = 51709 |
| 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 = 50020 |
| 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 = 43804 |
| 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 = 44040 |
| 0.0135 | 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 = 47885 |
| 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 = 48493 |
| 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 = 48521 |
| 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 = 49048 |
| 0.0135 | 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 = 41853 |
| 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 = 38667 |
| 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 = 38861 |
| 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 = 39995 |
| 0.0137 | 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 = 42128 |
| 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 = 42961 |
| 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 = 33339 |
| 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 = 37252 |
| 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 = 31716 |
| 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 = 35499 |
| 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 = 37113 |
| 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 = 15285 |
| 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 = 19765 |
| 0.0144 | 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 = 20081 |
| 0.0138 | 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 = 15265 |
| 0.0140 | 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 = 20079 |
| 0.0139 | 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 = 24543 |
| 0.0139 | 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 = 3460 |
| 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 = 20598 |
| 0.0136 | 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 = 20599 |
| 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 = 20602 |
| 0.0125 | 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 = '308161'
|
| 0.0144 | 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 = 67937 AND rp.teamId = 10273 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC |
| 0.0133 | 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 = 308161 ORDER BY rp.year DESC |
| 0.0128 | 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 = '308161' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0127 | 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 = '308161' and rp.type = 3 |
| 0.0128 | SELECT e.* FROM `events2023` e WHERE e.player_id = 308161 AND league_id = 67937 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 = 67937 AND rel.player_id=308161 |
| 0.0133 | SELECT action,minute FROM events2023 WHERE player_id = 308161 AND league_id = 67937 AND action = 18 |
| 0.0133 | SELECT action,minute FROM events2023 WHERE player_id = 308161 AND league_id = 67937 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2023` e WHERE e.player_id = 308161 AND league_id = 70110 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 = 70110 AND rel.player_id=308161 |
| 0.0127 | SELECT action,minute FROM events2023 WHERE player_id = 308161 AND league_id = 70110 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2023 WHERE player_id = 308161 AND league_id = 70110 AND action = 19 |
| 0.0128 | SELECT e.* FROM `events2022` e WHERE e.player_id = 308161 AND league_id = 63294 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 = 63294 AND rel.player_id=308161 |
| 0.0131 | SELECT action,minute FROM events2022 WHERE player_id = 308161 AND league_id = 63294 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2022 WHERE player_id = 308161 AND league_id = 63294 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2022` e WHERE e.player_id = 308161 AND league_id = 65968 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 = 65968 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2022 WHERE player_id = 308161 AND league_id = 65968 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2022 WHERE player_id = 308161 AND league_id = 65968 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2022` e WHERE e.player_id = 308161 AND league_id = 66236 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 = 66236 AND rel.player_id=308161 |
| 0.0127 | SELECT action,minute FROM events2022 WHERE player_id = 308161 AND league_id = 66236 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2022 WHERE player_id = 308161 AND league_id = 66236 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2022` e WHERE e.player_id = 308161 AND league_id = 67354 ORDER BY e.date ASC |
| 0.0131 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67354 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2022 WHERE player_id = 308161 AND league_id = 67354 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2022 WHERE player_id = 308161 AND league_id = 67354 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2021` e WHERE e.player_id = 308161 AND league_id = 56984 ORDER BY e.date ASC |
| 0.0135 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 56984 AND rel.player_id=308161 |
| 0.0128 | SELECT action,minute FROM events2021 WHERE player_id = 308161 AND league_id = 56984 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2021 WHERE player_id = 308161 AND league_id = 56984 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2020` e WHERE e.player_id = 308161 AND league_id = 49960 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 = 49960 AND rel.player_id=308161 |
| 0.0127 | SELECT action,minute FROM events2020 WHERE player_id = 308161 AND league_id = 49960 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2020 WHERE player_id = 308161 AND league_id = 49960 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2020` e WHERE e.player_id = 308161 AND league_id = 51709 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 = 51709 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2020 WHERE player_id = 308161 AND league_id = 51709 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2020 WHERE player_id = 308161 AND league_id = 51709 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2020` e WHERE e.player_id = 308161 AND league_id = 53478 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 = 53478 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2020 WHERE player_id = 308161 AND league_id = 53478 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2020 WHERE player_id = 308161 AND league_id = 53478 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2020` e WHERE e.player_id = 308161 AND league_id = 50020 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 = 50020 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2020 WHERE player_id = 308161 AND league_id = 50020 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2020 WHERE player_id = 308161 AND league_id = 50020 AND action = 19 |
| 0.0129 | SELECT e.* FROM `events2019` e WHERE e.player_id = 308161 AND league_id = 43804 ORDER BY e.date ASC |
| 0.0191 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43804 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 43804 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 43804 AND action = 19 |
| 0.0129 | SELECT e.* FROM `events2019` e WHERE e.player_id = 308161 AND league_id = 44040 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 = 44040 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 44040 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 44040 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2019` e WHERE e.player_id = 308161 AND league_id = 47885 ORDER BY e.date ASC |
| 0.0130 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 47885 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 47885 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 47885 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2019` e WHERE e.player_id = 308161 AND league_id = 48493 ORDER BY e.date ASC |
| 0.0136 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48493 AND rel.player_id=308161 |
| 0.0127 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 48493 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 48493 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2019` e WHERE e.player_id = 308161 AND league_id = 43475 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 = 43475 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 43475 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 43475 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2019` e WHERE e.player_id = 308161 AND league_id = 43475 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 = 43475 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 43475 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 43475 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2019` e WHERE e.player_id = 308161 AND league_id = 48521 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 = 48521 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 48521 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 48521 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2019` e WHERE e.player_id = 308161 AND league_id = 49048 ORDER BY e.date ASC |
| 0.0134 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49048 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 49048 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2019 WHERE player_id = 308161 AND league_id = 49048 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2018` e WHERE e.player_id = 308161 AND league_id = 41853 ORDER BY e.date ASC |
| 0.0136 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41853 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 41853 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 41853 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2018` e WHERE e.player_id = 308161 AND league_id = 38667 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 = 38667 AND rel.player_id=308161 |
| 0.0127 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 38667 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 38667 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2018` e WHERE e.player_id = 308161 AND league_id = 38861 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 = 38861 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 38861 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 38861 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2018` e WHERE e.player_id = 308161 AND league_id = 39995 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 = 39995 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 39995 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 39995 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2018` e WHERE e.player_id = 308161 AND league_id = 42128 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 = 42128 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 42128 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 42128 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2018` e WHERE e.player_id = 308161 AND league_id = 42961 ORDER BY e.date ASC |
| 0.0129 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42961 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 42961 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2018 WHERE player_id = 308161 AND league_id = 42961 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2017` e WHERE e.player_id = 308161 AND league_id = 33339 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 = 33339 AND rel.player_id=308161 |
| 0.0127 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 33339 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 33339 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2017` e WHERE e.player_id = 308161 AND league_id = 37252 ORDER BY e.date ASC |
| 0.0129 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37252 AND rel.player_id=308161 |
| 0.0127 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 37252 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 37252 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2017` e WHERE e.player_id = 308161 AND league_id = 37587 ORDER BY e.date ASC |
| 0.0136 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37587 AND rel.player_id=308161 |
| 0.0128 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 37587 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 37587 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2017` e WHERE e.player_id = 308161 AND league_id = 31716 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 = 31716 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 31716 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 31716 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2017` e WHERE e.player_id = 308161 AND league_id = 35499 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 = 35499 AND rel.player_id=308161 |
| 0.0136 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 35499 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 35499 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2017` e WHERE e.player_id = 308161 AND league_id = 37113 ORDER BY e.date ASC |
| 0.0129 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37113 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 37113 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2017 WHERE player_id = 308161 AND league_id = 37113 AND action = 19 |
| 0.0129 | SELECT e.* FROM `events2016` e WHERE e.player_id = 308161 AND league_id = 15285 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 = 15285 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 15285 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 15285 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2016` e WHERE e.player_id = 308161 AND league_id = 19765 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 = 19765 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 19765 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 19765 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2016` e WHERE e.player_id = 308161 AND league_id = 20081 ORDER BY e.date ASC |
| 0.0136 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20081 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 20081 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 20081 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2016` e WHERE e.player_id = 308161 AND league_id = 15265 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 = 15265 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 15265 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 15265 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2016` e WHERE e.player_id = 308161 AND league_id = 20079 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 = 20079 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 20079 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 20079 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2016` e WHERE e.player_id = 308161 AND league_id = 24543 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 = 24543 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 24543 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2016 WHERE player_id = 308161 AND league_id = 24543 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2014` e WHERE e.player_id = 308161 AND league_id = 3460 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 = 3460 AND rel.player_id=308161 |
| 0.0127 | SELECT action,minute FROM events2014 WHERE player_id = 308161 AND league_id = 3460 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2014 WHERE player_id = 308161 AND league_id = 3460 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2013` e WHERE e.player_id = 308161 AND league_id = 2062 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 = 2062 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 2062 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 2062 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2013` e WHERE e.player_id = 308161 AND league_id = 2258 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 = 2258 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 2258 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 2258 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2013` e WHERE e.player_id = 308161 AND league_id = 20598 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 = 20598 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 20598 AND action = 18 |
| 0.0125 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 20598 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2013` e WHERE e.player_id = 308161 AND league_id = 20599 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 = 20599 AND rel.player_id=308161 |
| 0.0125 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 20599 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 20599 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2013` e WHERE e.player_id = 308161 AND league_id = 20602 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 = 20602 AND rel.player_id=308161 |
| 0.0126 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 20602 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2013 WHERE player_id = 308161 AND league_id = 20602 AND action = 19 |
Santiago Ramírez
Sebastián Huerta
José González
M. Velázquez
A. Ledesma
V. Milke
M. Trejo
Kenneth Jaime
R. Melgarejo
L. Perez
J. Zamudio
Alejandro Andrade
W. Mejía
J. Ruiz
S. Vergara
D. Abella
Ángel Robles
Juan Gamboa
O. Rosas
Álvaro Verda
J. Uchuari
D. Pineda
B. Mendoza