0.0132 | SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'huesca' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC |
0.0107 | SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1 |
0.0107 | SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1 |
0.0106 | SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1 |
0.0106 | SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1 |
0.0106 | SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72177 AND t.total_twitter > 0 ORDER BY nameShow |
0.0111 | 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 = 72177 |
0.0107 | SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 1334 ORDER BY nameShow LIMIT 100 |
0.0107 | SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 1335 ORDER BY nameShow LIMIT 100 |
0.0111 | SELECT dt.nameShow, dt.basealias, t.id, t.total_twitter,dt.fullName FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE t.total_twitter > 0 AND league_id != 1334 AND league_id != 1335 ORDER BY nameShow |
0.0109 | SELECT dp.name,dp.last_name,dp.nick,dp.alias,dp.twitter,dp.valor FROM rel_players rp INNER JOIN dataplayers dp ON rp.player_id = dp.id WHERE rp.in_squad = 1 AND rp.team_id = 6584340 AND dp.twitter is not null ORDER BY dp.valor DESC,dp.id ASC LIMIT 15 |
0.0106 | SELECT dp.name,dp.last_name,dp.nick,dp.alias,dp.twitter,dp.valor FROM rel_players rp INNER JOIN dataplayers dp ON rp.player_id = dp.id INNER JOIN games.manager_players mp ON mp.playerId = dp.id WHERE rp.in_squad = 1 AND rp.league_id = 1334 AND dp.twitter is not null ORDER BY mp.action_value DESC,dp.id ASC LIMIT 15 |