| 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` = '192558'
|
| 0.0026 | SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'Marc-Rovirola-Moreno-192558' 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 = 'Marc-Rovirola-Moreno-192558' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0026 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 62378 |
| 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 = 61718 |
| 0.0026 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 50265 |
| 0.0026 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 51355 |
| 0.0026 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 56564 |
| 0.0025 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 44097 |
| 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 = 43475 |
| 0.0025 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 49760 |
| 0.0026 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 38808 |
| 0.0026 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 38790 |
| 0.0027 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 38427 |
| 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 = 39175 |
| 0.0035 | 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 = 33379 |
| 0.0026 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 33904 |
| 0.0038 | 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 = 15376 |
| 0.0027 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 3803 |
| 0.0026 | SELECT
c.*, l.*, cou.name as namec, ct.table_sufix
FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 15058 |
| 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 = 23909 |
| 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 = '192558'
|
| 0.0042 | 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 = 877 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC |
| 0.0023 | SELECT t.nameShow,t.basealias,rp.year,c.name
FROM `rel_players` rp INNER JOIN `datateams` t ON t.id = rp.teamId INNER JOIN categories c ON c.id = rp.category_id WHERE rp.player_id = 192558 ORDER BY rp.year DESC |
| 0.0021 | 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 = '192558' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0019 | 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 = '192558' and rp.type = 3 |
| 0.0020 | SELECT e.* FROM `events2022` e WHERE e.player_id = 192558 AND league_id = 62378 ORDER BY e.date ASC |
| 0.0040 | 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=192558 |
| 0.0021 | SELECT action,minute FROM events2022 WHERE player_id = 192558 AND league_id = 62378 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2022 WHERE player_id = 192558 AND league_id = 62378 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2022` e WHERE e.player_id = 192558 AND league_id = 62807 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 = 62807 AND rel.player_id=192558 |
| 0.0019 | SELECT action,minute FROM events2022 WHERE player_id = 192558 AND league_id = 62807 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 192558 AND league_id = 62807 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2022` e WHERE e.player_id = 192558 AND league_id = 65506 ORDER BY e.date ASC |
| 0.0026 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 65506 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 192558 AND league_id = 65506 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2022 WHERE player_id = 192558 AND league_id = 65506 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2021` e WHERE e.player_id = 192558 AND league_id = 58608 ORDER BY e.date ASC |
| 0.0028 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58608 AND rel.player_id=192558 |
| 0.0021 | SELECT action,minute FROM events2021 WHERE player_id = 192558 AND league_id = 58608 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2021 WHERE player_id = 192558 AND league_id = 58608 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2021` e WHERE e.player_id = 192558 AND league_id = 56547 ORDER BY e.date ASC |
| 0.0026 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 56547 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2021 WHERE player_id = 192558 AND league_id = 56547 AND action = 18 |
| 0.0030 | SELECT action,minute FROM events2021 WHERE player_id = 192558 AND league_id = 56547 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2021` e WHERE e.player_id = 192558 AND league_id = 59872 ORDER BY e.date ASC |
| 0.0035 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 59872 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2021 WHERE player_id = 192558 AND league_id = 59872 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2021 WHERE player_id = 192558 AND league_id = 59872 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2021` e WHERE e.player_id = 192558 AND league_id = 61718 ORDER BY e.date ASC |
| 0.0027 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61718 AND rel.player_id=192558 |
| 0.0019 | SELECT action,minute FROM events2021 WHERE player_id = 192558 AND league_id = 61718 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2021 WHERE player_id = 192558 AND league_id = 61718 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2020` e WHERE e.player_id = 192558 AND league_id = 50265 ORDER BY e.date ASC |
| 0.0026 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50265 AND rel.player_id=192558 |
| 0.0021 | SELECT action,minute FROM events2020 WHERE player_id = 192558 AND league_id = 50265 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2020 WHERE player_id = 192558 AND league_id = 50265 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2020` e WHERE e.player_id = 192558 AND league_id = 49506 ORDER BY e.date ASC |
| 0.0025 | 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=192558 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 192558 AND league_id = 49506 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 192558 AND league_id = 49506 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2020` e WHERE e.player_id = 192558 AND league_id = 51355 ORDER BY e.date ASC |
| 0.0024 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 51355 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 192558 AND league_id = 51355 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2020 WHERE player_id = 192558 AND league_id = 51355 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2020` e WHERE e.player_id = 192558 AND league_id = 56564 ORDER BY e.date ASC |
| 0.0024 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 56564 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 192558 AND league_id = 56564 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2020 WHERE player_id = 192558 AND league_id = 56564 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2019` e WHERE e.player_id = 192558 AND league_id = 44097 ORDER BY e.date ASC |
| 0.0024 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44097 AND rel.player_id=192558 |
| 0.0022 | SELECT action,minute FROM events2019 WHERE player_id = 192558 AND league_id = 44097 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2019 WHERE player_id = 192558 AND league_id = 44097 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2019` e WHERE e.player_id = 192558 AND league_id = 43475 ORDER BY e.date ASC |
| 0.0024 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43475 AND rel.player_id=192558 |
| 0.0019 | SELECT action,minute FROM events2019 WHERE player_id = 192558 AND league_id = 43475 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 192558 AND league_id = 43475 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2019` e WHERE e.player_id = 192558 AND league_id = 49760 ORDER BY e.date ASC |
| 0.0024 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49760 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 192558 AND league_id = 49760 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2019 WHERE player_id = 192558 AND league_id = 49760 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2018` e WHERE e.player_id = 192558 AND league_id = 38808 ORDER BY e.date ASC |
| 0.0026 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38808 AND rel.player_id=192558 |
| 0.0019 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 38808 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 38808 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2018` e WHERE e.player_id = 192558 AND league_id = 38790 ORDER BY e.date ASC |
| 0.0024 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38790 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 38790 AND action = 18 |
| 0.0023 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 38790 AND action = 19 |
| 0.0022 | SELECT e.* FROM `events2018` e WHERE e.player_id = 192558 AND league_id = 42449 ORDER BY e.date ASC |
| 0.0035 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42449 AND rel.player_id=192558 |
| 0.0022 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 42449 AND action = 18 |
| 0.0022 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 42449 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2018` e WHERE e.player_id = 192558 AND league_id = 38427 ORDER BY e.date ASC |
| 0.0039 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38427 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 38427 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 38427 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2018` e WHERE e.player_id = 192558 AND league_id = 39175 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 = 39175 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 39175 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2018 WHERE player_id = 192558 AND league_id = 39175 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2017` e WHERE e.player_id = 192558 AND league_id = 33379 ORDER BY e.date ASC |
| 0.0028 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33379 AND rel.player_id=192558 |
| 0.0022 | SELECT action,minute FROM events2017 WHERE player_id = 192558 AND league_id = 33379 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2017 WHERE player_id = 192558 AND league_id = 33379 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2017` e WHERE e.player_id = 192558 AND league_id = 30386 ORDER BY e.date ASC |
| 0.0024 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30386 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 192558 AND league_id = 30386 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2017 WHERE player_id = 192558 AND league_id = 30386 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2017` e WHERE e.player_id = 192558 AND league_id = 33904 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 = 33904 AND rel.player_id=192558 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 192558 AND league_id = 33904 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2017 WHERE player_id = 192558 AND league_id = 33904 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2017` e WHERE e.player_id = 192558 AND league_id = 38453 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 = 38453 AND rel.player_id=192558 |
| 0.0019 | SELECT action,minute FROM events2017 WHERE player_id = 192558 AND league_id = 38453 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2017 WHERE player_id = 192558 AND league_id = 38453 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2016` e WHERE e.player_id = 192558 AND league_id = 15376 ORDER BY e.date ASC |
| 0.0027 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15376 AND rel.player_id=192558 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 192558 AND league_id = 15376 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 192558 AND league_id = 15376 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2016` e WHERE e.player_id = 192558 AND league_id = 16245 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 = 16245 AND rel.player_id=192558 |
| 0.0020 | SELECT action,minute FROM events2016 WHERE player_id = 192558 AND league_id = 16245 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2016 WHERE player_id = 192558 AND league_id = 16245 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2015` e WHERE e.player_id = 192558 AND league_id = 3803 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 = 3803 AND rel.player_id=192558 |
| 0.0021 | SELECT action,minute FROM events2015 WHERE player_id = 192558 AND league_id = 3803 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2015 WHERE player_id = 192558 AND league_id = 3803 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2015` e WHERE e.player_id = 192558 AND league_id = 15058 ORDER BY e.date ASC |
| 0.0035 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15058 AND rel.player_id=192558 |
| 0.0021 | SELECT action,minute FROM events2015 WHERE player_id = 192558 AND league_id = 15058 AND action = 18 |
| 0.0021 | SELECT action,minute FROM events2015 WHERE player_id = 192558 AND league_id = 15058 AND action = 19 |
| 0.0021 | SELECT e.* FROM `events2015` e WHERE e.player_id = 192558 AND league_id = 23909 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 = 23909 AND rel.player_id=192558 |
| 0.0023 | SELECT action,minute FROM events2015 WHERE player_id = 192558 AND league_id = 23909 AND action = 18 |
| 0.0023 | SELECT action,minute FROM events2015 WHERE player_id = 192558 AND league_id = 23909 AND action = 19 |
Dani Sotres
Edu Frias
Pepo
Riki Mangana
Pedro Empis
F. Escobar
Beni
J. Castañeda
Jorge Moreno
Amelibia
Fran Cruz
Rodri Suárez
Marcos Gonzalez
Rayan
Popi
Jon Gaztañaga
Jony Álamo
Cerrajería
Alberto Solís
Jaime Sierra
Romano
F. Angong
Junior Girón
Aarón Piñán
Ander Vitoria
S. Buenacasa
Nahuel Arroyo
Ketu
N. Obolskii
Álvaro Juan
Diego Percan
Marc
David López
Marc Echarri