| 0.0003 |
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` = '71955'
|
| 0.0025 | 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 = 'D-Pellegrino-71955' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0131 | 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 = 'D-Pellegrino-71955' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 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 = 65506 |
| 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 = 60153 |
| 0.0037 | 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 = 66510 |
| 0.0031 | 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 = 53557 |
| 0.0033 | 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 = 43555 |
| 0.0031 | 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 = 48466 |
| 0.0032 | 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 = 48479 |
| 0.0030 | 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 = 49304 |
| 0.0032 | 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 = 39647 |
| 0.0031 | 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 = 43358 |
| 0.0029 | 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 = 37686 |
| 0.0031 | 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 = 37834 |
| 0.0031 | 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 = 8714 |
| 0.0028 | 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 = 9530 |
| 0.0029 | 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 = 19698 |
| 0.0032 | 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 = 2501 |
| 0.0029 | 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 = 3841 |
| 0.0029 | 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 = 3397 |
| 0.0029 | 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 = 1999 |
| 0.0029 | 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 = 20579 |
| 0.0029 | 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 = 1387 |
| 0.0028 | 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 = 20580 |
| 0.0030 | 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 = 8382 |
| 0.0029 | 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 = 12933 |
| 0.0030 | 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 = 12932 |
| 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 = '71955'
|
| 0.0038 | 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 = 62378 AND rp.teamId = 2545 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC |
| 0.0027 | 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 = 71955 ORDER BY rp.year DESC |
| 0.0022 | 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 = '71955' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0020 | 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 = '71955' and rp.type = 3 |
| 0.0021 | SELECT e.* FROM `events2022` e WHERE e.player_id = 71955 AND league_id = 62378 ORDER BY e.date ASC |
| 0.0063 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62378 AND rel.player_id=71955 |
| 0.0020 | SELECT action,minute FROM events2022 WHERE player_id = 71955 AND league_id = 62378 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2022 WHERE player_id = 71955 AND league_id = 62378 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2022` e WHERE e.player_id = 71955 AND league_id = 62807 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 = 62807 AND rel.player_id=71955 |
| 0.0022 | SELECT action,minute FROM events2022 WHERE player_id = 71955 AND league_id = 62807 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2022 WHERE player_id = 71955 AND league_id = 62807 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2022` e WHERE e.player_id = 71955 AND league_id = 65506 ORDER BY e.date ASC |
| 0.0090 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 65506 AND rel.player_id=71955 |
| 0.0019 | SELECT action,minute FROM events2022 WHERE player_id = 71955 AND league_id = 65506 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2022 WHERE player_id = 71955 AND league_id = 65506 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2021` e WHERE e.player_id = 71955 AND league_id = 60153 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 = 60153 AND rel.player_id=71955 |
| 0.0020 | SELECT action,minute FROM events2021 WHERE player_id = 71955 AND league_id = 60153 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2021 WHERE player_id = 71955 AND league_id = 60153 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 71955 AND league_id = 49952 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 = 49952 AND rel.player_id=71955 |
| 0.0020 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 49952 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 49952 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 71955 AND league_id = 66510 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 = 66510 AND rel.player_id=71955 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 66510 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 66510 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 71955 AND league_id = 53476 ORDER BY e.date ASC |
| 0.0093 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53476 AND rel.player_id=71955 |
| 0.0020 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 53476 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 53476 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2020` e WHERE e.player_id = 71955 AND league_id = 53492 ORDER BY e.date ASC |
| 0.0021 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53492 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 53492 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 53492 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2020` e WHERE e.player_id = 71955 AND league_id = 53557 ORDER BY e.date ASC |
| 0.0019 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53557 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 53557 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 71955 AND league_id = 53557 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2019` e WHERE e.player_id = 71955 AND league_id = 43555 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 = 43555 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 71955 AND league_id = 43555 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 71955 AND league_id = 43555 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2019` e WHERE e.player_id = 71955 AND league_id = 48466 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 = 48466 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 71955 AND league_id = 48466 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 71955 AND league_id = 48466 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2019` e WHERE e.player_id = 71955 AND league_id = 48479 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 = 48479 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 71955 AND league_id = 48479 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 71955 AND league_id = 48479 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2019` e WHERE e.player_id = 71955 AND league_id = 49304 ORDER BY e.date ASC |
| 0.0043 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49304 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 71955 AND league_id = 49304 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 71955 AND league_id = 49304 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2018` e WHERE e.player_id = 71955 AND league_id = 39647 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 = 39647 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 71955 AND league_id = 39647 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 71955 AND league_id = 39647 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2018` e WHERE e.player_id = 71955 AND league_id = 43358 ORDER BY e.date ASC |
| 0.0020 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43358 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 71955 AND league_id = 43358 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 71955 AND league_id = 43358 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2017` e WHERE e.player_id = 71955 AND league_id = 33424 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 = 33424 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 33424 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 33424 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2017` e WHERE e.player_id = 71955 AND league_id = 30386 ORDER BY e.date ASC |
| 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 = 30386 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 30386 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 30386 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2017` e WHERE e.player_id = 71955 AND league_id = 37686 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 = 37686 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 37686 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 37686 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 = 37686 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 37686 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 37686 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2017` e WHERE e.player_id = 71955 AND league_id = 37834 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 = 37834 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 37834 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 71955 AND league_id = 37834 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2016` e WHERE e.player_id = 71955 AND league_id = 20176 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 = 20176 AND rel.player_id=71955 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 71955 AND league_id = 20176 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 71955 AND league_id = 20176 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2016` e WHERE e.player_id = 71955 AND league_id = 20217 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 = 20217 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2016 WHERE player_id = 71955 AND league_id = 20217 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2016 WHERE player_id = 71955 AND league_id = 20217 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2015` e WHERE e.player_id = 71955 AND league_id = 8714 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 = 8714 AND rel.player_id=71955 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 71955 AND league_id = 8714 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 71955 AND league_id = 8714 AND action = 19 |
| 0.0032 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 8714 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2015 WHERE player_id = 71955 AND league_id = 8714 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2015 WHERE player_id = 71955 AND league_id = 8714 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2015` e WHERE e.player_id = 71955 AND league_id = 9530 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 = 9530 AND rel.player_id=71955 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 71955 AND league_id = 9530 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 71955 AND league_id = 9530 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2015` e WHERE e.player_id = 71955 AND league_id = 19698 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 = 19698 AND rel.player_id=71955 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 71955 AND league_id = 19698 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2015 WHERE player_id = 71955 AND league_id = 19698 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2014` e WHERE e.player_id = 71955 AND league_id = 2501 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 = 2501 AND rel.player_id=71955 |
| 0.0021 | SELECT action,minute FROM events2014 WHERE player_id = 71955 AND league_id = 2501 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2014 WHERE player_id = 71955 AND league_id = 2501 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2014` e WHERE e.player_id = 71955 AND league_id = 3841 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 = 3841 AND rel.player_id=71955 |
| 0.0020 | SELECT action,minute FROM events2014 WHERE player_id = 71955 AND league_id = 3841 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2014 WHERE player_id = 71955 AND league_id = 3841 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2014` e WHERE e.player_id = 71955 AND league_id = 3397 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 = 3397 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2014 WHERE player_id = 71955 AND league_id = 3397 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2014 WHERE player_id = 71955 AND league_id = 3397 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2013` e WHERE e.player_id = 71955 AND league_id = 1999 ORDER BY e.date ASC |
| 0.0032 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1999 AND rel.player_id=71955 |
| 0.0020 | SELECT action,minute FROM events2013 WHERE player_id = 71955 AND league_id = 1999 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2013 WHERE player_id = 71955 AND league_id = 1999 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2013` e WHERE e.player_id = 71955 AND league_id = 20579 ORDER BY e.date ASC |
| 0.0048 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20579 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2013 WHERE player_id = 71955 AND league_id = 20579 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2013 WHERE player_id = 71955 AND league_id = 20579 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2012` e WHERE e.player_id = 71955 AND league_id = 1387 ORDER BY e.date ASC |
| 0.0052 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1387 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 71955 AND league_id = 1387 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2012 WHERE player_id = 71955 AND league_id = 1387 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2012` e WHERE e.player_id = 71955 AND league_id = 20580 ORDER BY e.date ASC |
| 0.0038 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20580 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 71955 AND league_id = 20580 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2012 WHERE player_id = 71955 AND league_id = 20580 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2011` e WHERE e.player_id = 71955 AND league_id = 8382 ORDER BY e.date ASC |
| 0.0032 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 8382 AND rel.player_id=71955 |
| 0.0019 | SELECT action,minute FROM events2011 WHERE player_id = 71955 AND league_id = 8382 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2011 WHERE player_id = 71955 AND league_id = 8382 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2010` e WHERE e.player_id = 71955 AND league_id = 12933 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 = 12933 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2010 WHERE player_id = 71955 AND league_id = 12933 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2010 WHERE player_id = 71955 AND league_id = 12933 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2009` e WHERE e.player_id = 71955 AND league_id = 12932 ORDER BY e.date ASC |
| 0.0041 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 12932 AND rel.player_id=71955 |
| 0.0018 | SELECT action,minute FROM events2009 WHERE player_id = 71955 AND league_id = 12932 AND action = 18 |
| 0.0017 | SELECT action,minute FROM events2009 WHERE player_id = 71955 AND league_id = 12932 AND action = 19 |
Ignacio Zabal
Eric Gamen
Matías Sánchez
Iván López
Pela
David Luna
Yasin
Jesús Cedenilla
Diego Royo
Cavafe
G. Faber
Álex Gualda
Alain Ribeiro
Aitor González
Laerte
A. Marín
Agus Alonso
Ivan Cabellud
P. Caballero
A. Aranzabe
B. Compaore
L. Carrera