| 0.0216 | 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 = 73865 |
| 0.0124 | 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 = 72212 |
| 0.0126 | 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 = 73212 |
| 0.0108 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3079 AND type_rel = 2 |
| 0.0126 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3079 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5 |
| 0.0110 | 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 (1294310,357,515,620,1303407) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0175 | 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 = '3079' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020 |
| 0.0111 | 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 = 73865 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0129 | 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 = 73212 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0115 | 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 = 72212 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0129 | (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 3079 or c.datateam2 = 3079) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC |
| 0.0125 | (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 3079 or c.datateam2 = 3079) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120 |
| 0.0113 | (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 3079 or c.datateam2 = 3079) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024) |
| 0.0106 | SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 74791
AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC |
Ucrania
Grupo 8
Grupo 0
Barcelona
Porto
Antwerp
Shakhtar Donetsk
Dynamo Kyiv
Chornomorets Odessa
Vorskla Poltava
Karpaty Lviv
Zorya Luhansk
Metalist Kharkiv
Metalurh Zaporizhya
Oleksandriya
Nyva Ternopil
Obolon
Kremin
Bukovyna Chernivtsi
FC Nyva Vinnytsya
Veres Rivne
Hirnyk-Sport
Kolos Kovalivka
Dnipro-1
Real Pharma
Inhulets
Skala Stryi
Rukh Lviv
Podillya Khmelnytskyi
Ahrobiznes Volochysk
FC Kryvbas
FC Prykarpattia
Minai
Chayka
Metalist 1925 Kharkiv
Polissya Zhytomyr
Dinaz Vyshhorod
FSC Mariupol
Chernihiv
FK Epitsentr
Viktoriya Mykolaivka
SC Poltava
LNZ Cherkasy
FK Trostyanets
Khust City
Livyi Bereh
Nyva Buzova
PFK Zvyagel
Druzhba
Kudrivka
Lokomotiv Kyiv
Olimpiya Savyntsi
UCSA
VAST Mykolaiv
FK Shturm Ivankiv
Fazenda Chernivtsi
Benfica
Galatasaray SK
Liverpool
Milan
Rangers FC
Roma
Sporting CP
West Ham
Sporting Braga
Olympique Marseille
Atalanta
Feyenoord
B. Leverkusen
Villarreal
Stade Rennais
Sparta Praha
Lens
Young Boys
Brighton & Hove Albion
Toulouse
Slavia Praha
Qarabağ
SC Freiburg