| 0.0023 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1335 AND type_rel = 2 |
| 0.0044 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1335 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5 |
| 0.0038 | 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 (2871,10148,23913,32155,35387) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0077 | 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 = '1335' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020 |
| 0.0053 | SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1335 AND rp.league_id = 74447 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1 |
| 0.0049 | SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1335 AND rp.league_id = 74447 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1 |
| 0.0048 | SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1335 AND rp.league_id = 74447 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1 |
| 0.0053 | SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1335 AND rp.league_id = 74447 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1 |
| 0.0051 | SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1335 AND rp.league_id = 74447 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1 |
| 0.0049 | SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1335 AND rp.league_id = 74447 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1 |
Estados Unidos
Grupo 2
América
Chivas Guadalajara
Toluca
Deportivo Saprissa
Tigres UANL
Monterrey
Pachuca
LD Alajuelense
CS Herediano
Comunicaciones
Columbus Crew
New England Revolution
Real Estelí
Vancouver Whitecaps
Houston Dynamo
Philadelphia Union
Orlando City
Independiente Chorrera
SV Robinhood
Cincinnati
Nashville SC
Moca
Forge
Inter Miami
Cavalier
Cavalry
St. Louis City
Seattle Sounders
Sporting Kansas City
FC Dallas
Charleston Battery
Real Salt Lake
San Jose Earthquakes
Richmond Kickers
North Carolina
Pittsburgh Riverhounds
Tampa Bay Rowdies
Des Moines Menace
Orange County SC
Sacramento Republic
Phoenix Rising
Atlanta United
Indy Eleven
Louisville City
Los Angeles FC
Western Mass Pioneers
Charlotte Independence
Chattanooga
Colorado Springs Switchback
Detroit City
San Antonio
FC Tulsa
Miami FC
LA Galaxy II
Motown
Chicago Fire II
Tormenta
Tulsa Athletics
New York RB II
Birmingham Legion
New Mexico United
SC United Bantams
West Chester United
El Paso Locomotive
Memphis 901
Miami United
Forward Madison
Greenville Triumph
Chattanooga Red Wolves
El Farolito
Las Vegas Lights
Union Omaha
Oakland Roots
Hartford Athletic
LA Force
Michigan Stars
Pumas UNAM
León
Atlas Guadalajara
Necaxa
LA Galaxy
Tijuana
Minnesota United
Chicago Fire
Portland Timbers
Colorado Rapids
FC Juárez
Austin FC
DC United
New York RB
CF Montréal
Toronto FC
New York City
Charlotte FC