| 0.0293 | 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 = 58545 |
| 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 = 58567 |
| 0.0145 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10035 AND type_rel = 2 |
| 0.0150 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10035 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5 |
| 0.0149 | SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (236,665,916,1062,2898) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0158 | SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '10035' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020 |
| 0.0148 | SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58567 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0147 | SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58772 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0146 | SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58545 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0158 | SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date
FROM categories AS ct
INNER JOIN leagues AS l ON ct.id=l.categoryId
INNER JOIN teams AS t ON l.id=t.league_id
WHERE t.teamId=10035 AND l.year in (2020,2021,2022)
ORDER BY l.id DESC, l.year DESC ; |
| 0.0146 | SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group
FROM categories AS ct
INNER JOIN leagues AS l ON ct.id=l.categoryId
WHERE l.id IN (66139,63331,63179,62807,62617,58772,53486,50645)
ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC,
l.year DESC,
ct.coefficient DESC, l.group_code ASC |
| 0.0153 | SELECT count(id) as num_players from rel_players WHERE league_id = 63179 AND teamId = 10035 |
| 0.0155 | SELECT count(id) as num_players from rel_players WHERE league_id = 53486 AND teamId = 10035 |
| 0.0151 | SELECT count(id) as num_players from rel_players WHERE league_id = 66139 AND teamId = 10035 |
| 0.0153 | SELECT count(id) as num_players from rel_players WHERE league_id = 50645 AND teamId = 10035 |
| 0.0154 | SELECT count(id) as num_players from rel_players WHERE league_id = 58772 AND teamId = 10035 |
| 0.0154 | SELECT count(id) as num_players from rel_players WHERE league_id = 62617 AND teamId = 10035 |
| 0.0152 | SELECT count(id) as num_players from rel_players WHERE league_id = 63331 AND teamId = 10035 |
| 0.0265 | SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 10035 |
| 0.0150 | SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2021` as t
INNER JOIN teams as team ON team.id = t.team
INNER JOIN datateams as dt ON team.teamId = dt.id
WHERE t.league_id = 58545
AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC |
| 0.0172 | SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58545 WHERE rp.league_id = 58545 AND rp.teamId = 10035 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
| 0.0166 | SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58545 WHERE rp.league_id = 58545 AND rp.teamId = 10035 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
| 0.0158 | SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58545 WHERE rp.league_id = 58545 AND rp.teamId = 10035 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
| 0.0159 | SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58545 WHERE rp.league_id = 58545 AND rp.teamId = 10035 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
| 0.0162 | SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58545 WHERE rp.league_id = 58545 AND rp.teamId = 10035 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
| 0.0161 | SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58545 WHERE rp.league_id = 58545 AND rp.teamId = 10035 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
C. Chiappetta
Tician Tushi
Blas Riveros
Grupo 1
Grupo 2
Basel
Young Boys
Grasshopper
Zurich
Servette
Sion
Neuchâtel Xamax
Lausanne Sports
Luzern
St. Gallen
Aarau
FC Lugano
Thun
Kriens
Winterthur
FC Wil
Chiasso
Schaffhausen
Stade Nyonnais
Solothurn
Tuggen
FC Koniz
Stade Lausanne-Ouchy
Schotz
Black Stars
Vevey Sports
FC Monthey
SC Schöftland
Sierre
Laufen
Dürrenast
Ajoie-Monterri
FC Savièse
Balerna
Dübendorf
Zollbrück
Haute-Broye
Celtic
Galatasaray SK
Milan
Rangers FC
Sporting CP
Tottenham Hotspur
PSV
Standard de Liège
Malmö FF
Dinamo Zagreb
CSKA Sofia
Legia Warszawa
Rosenborg BK
Granada
APOEL
Crvena Zvezda
Kobenhavn
AEK Athens
Maccabi Haifa
Lech Poznań
LASK
Dundalk
Hapoel Beer Sheva
Wolfsburg
HNK Rijeka
CFR Cluj
Fehérvár
Qarabağ
Charleroi
Viktoria Plzeň
FC Flora
Ludogorets
KuPS Kuopio
Rio Ave
Slovan Liberec
KF Tirana
Sarajevo
Kí Klaksvík
Dinamo Brest
Ararat-Armenia
FC Vaduz