| 0.0260 | 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.0125 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3715 AND type_rel = 2 |
| 0.0146 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3715 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5 |
| 0.0133 | 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 (203513,4564,7805,8842,9693) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0138 | 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 = '3715' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020 |
| 0.0144 | 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 events2017 e ON e.player_id = p.id AND e.league_id = 33424 WHERE rp.league_id = 33424 AND rp.teamId = 3715 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.0141 | 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 events2017 e ON e.player_id = p.id AND e.league_id = 33424 WHERE rp.league_id = 33424 AND rp.teamId = 3715 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
| 0.0146 | 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 events2017 e ON e.player_id = p.id AND e.league_id = 33424 WHERE rp.league_id = 33424 AND rp.teamId = 3715 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
Argentina
Grupo 1
Estudiantes La Plata
Flamengo
Independiente
Racing Club
São Paulo
Cruzeiro
Fluminense
Corinthians
CA Huracán
Univ de Chile
Gimnasia La Plata
Sport Recife
Liga de Quito
Olimpia
Deportivo Cali
Cerro Porteño
Junior
Santa Fe
Deportes Tolima
Bolívar
Independiente Medellín
Palestino
Everton
Caracas
Libertad
O'Higgins
Defensor Sporting
Ponte Preta
Alianza Lima
Oriente Petrolero
Danubio
Deportivo Cuenca
Chapecoense
Universidad Católica
Arsenal de Sarandí
Deportes Iquique
Águilas Doradas
Liverpool Montevideo
Atl. Tucumán
Nacional
Defensa y Justicia
Patriotas Boyacá
Sportivo Luqueño
Sol de América
Dep. Anzoátegui
Sport Huancayo
Boston River
Juan Aurich Chiclayo
At. Venezuela
Nacional Potosí
Boca Juniors
River Plate
San Lorenzo
Vélez Sarsfield
Newell's Old Boys
Rosario Central
Argentinos Juniors
Lanús
Ferro Carril Oeste
Banfield
Talleres Córdoba
Unión Santa Fe
Chacarita Juniors
Colón
Atlanta
Tigre
Quilmes
Belgrano
Godoy Cruz
Instituto
CA Estudiantes
Almagro
Sarmiento
Temperley
Atletico Rafaela
San Martín San Juan
All Boys
Central Norte
Olimpo
Defensores Belgrano VR
Nueva Chicago
Aldosivi
Central Córdoba
Cipolletti
Deportivo Morón
Gimnasia y Tiro
Patronato
Indep. Rivadavia
Def. Belgrano
Estudiantes Río Cuarto
Chaco For Ever
Gimnasia Mendoza