4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Minnesota United

Minnesota United

Entrenador: Eric Ramsay

Temporada 2023/2024
TEMPORADA 2023/2024
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Inter Miami Inter Miami 11 26 16 21
2 Cincinnati Cincinnati 10 12 9 18
3 New York RB New York RB 10 14 10 17
4 Toronto FC Toronto FC 10 11 13 16
5 Columbus Crew Columbus 10 12 9 15
6 New York City York City 10 11 10 14
7 Philadelphia Union Philadelphia 9 17 14 13
8 DC United DC United 10 14 15 13
9 Atlanta United Atlanta 9 13 9 12
10 CF Montréal Montréal 9 12 16 12
11 Charlotte FC Charlotte 10 10 13 11
12 Chicago Fire Chicago Fire 10 11 18 10
13 Orlando City Orlando City 9 11 17 9
14 Nashville SC Nashville 9 10 17 8
15 New England Revolution England 9 6 18 4
16 Real Salt Lake Real Salt L. 10 17 9 18
17 LA Galaxy LA Galaxy 10 21 17 18
18 Vancouver Whitecaps Vancouver 9 18 10 17
19 Minnesota United Minnesota 9 15 10 17
20 Los Angeles FC Angeles 10 18 16 15
21 Colorado Rapids Colorado 10 16 15 15
22 Austin FC Austin FC 10 14 13 15
23 Houston Dynamo Houston 9 9 10 13
24 St. Louis City Louis City 9 15 14 12
25 Sporting Kansas City Sporting 10 18 18 11
26 Portland Timbers Portland 10 20 21 10
27 Seattle Sounders Seattle 10 13 13 9
28 FC Dallas FC Dallas 9 9 12 8
29 San Jose Earthquakes Jose 10 14 25 4
TEMPORADA 2022/2023
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Cincinnati Cincinnati 34 57 39 69
2 Orlando City Orlando City 34 55 39 63
3 Columbus Crew Columbus 34 67 46 57
4 Philadelphia Union Philadelphia 34 57 41 55
5 New England Revolution England 34 58 46 55
6 Atlanta United Atlanta 34 66 53 51
7 Nashville SC Nashville 34 39 32 49
8 New York RB New York RB 34 36 39 43
9 Charlotte FC Charlotte 34 45 52 43
10 CF Montréal Montréal 34 36 52 41
11 New York City York City 34 35 39 41
12 DC United DC United 34 45 49 40
13 Chicago Fire Chicago Fire 34 39 51 40
14 Inter Miami Inter Miami 34 41 54 34
15 Toronto FC Toronto FC 34 26 59 22
16 St. Louis City Louis City 33 62 43 56
17 Los Angeles FC Angeles 33 53 38 51
18 Houston Dynamo Houston 34 51 38 51
19 Real Salt Lake Real Salt L. 34 48 50 50
20 Seattle Sounders Seattle 33 39 32 50
21 Vancouver Whitecaps Vancouver 33 54 47 47
22 FC Dallas FC Dallas 34 41 37 46
23 San Jose Earthquakes Jose 34 39 43 44
24 Portland Timbers Portland 34 46 58 43
25 Sporting Kansas City Sporting 33 45 50 41
26 Minnesota United Minnesota 33 45 48 41
27 Austin FC Austin FC 34 49 55 39
28 LA Galaxy LA Galaxy 34 51 67 36
29 Colorado Rapids Colorado 34 26 54 27
TEMPORADA 2021/2022
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Philadelphia Union Philadelphia 34 72 26 67
2 CF Montréal Montréal 34 63 50 65
3 New York City York City 34 57 41 55
4 New York RB New York RB 34 50 41 53
5 Cincinnati Cincinnati 34 64 56 49
6 Inter Miami Inter Miami 34 47 56 48
7 Orlando City Orlando City 34 44 53 48
8 Columbus Crew Columbus 34 46 41 46
9 Charlotte FC Charlotte 34 44 52 42
10 New England Revolution England 34 47 50 42
11 Atlanta United Atlanta 34 48 54 40
12 Chicago Fire Chicago Fire 34 39 48 39
13 Toronto FC Toronto FC 34 49 66 34
14 DC United DC United 34 36 71 27
15 Los Angeles FC Angeles 34 66 38 67
16 Austin FC Austin FC 34 65 49 56
17 FC Dallas FC Dallas 34 48 37 53
18 LA Galaxy LA Galaxy 34 58 51 50
19 Nashville SC Nashville 34 52 41 50
20 Minnesota United Minnesota 34 48 51 48
21 Real Salt Lake Real Salt L. 34 43 45 47
22 Portland Timbers Portland 34 53 53 46
23 Vancouver Whitecaps Vancouver 34 40 57 43
24 Colorado Rapids Colorado 34 46 57 43
25 Seattle Sounders Seattle 34 47 46 41
26 Sporting Kansas City Sporting 34 42 54 40
27 Houston Dynamo Houston 34 43 56 36
28 San Jose Earthquakes Jose 34 52 69 35
TEMPORADA 2020/2021
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 New England Revolution England 34 65 41 73
2 Philadelphia Union Philadelphia 34 48 35 54
3 Nashville SC Nashville 34 55 33 54
4 New York City York City 34 56 36 51
5 Atlanta United Atlanta 34 45 37 51
6 Orlando City Orlando City 34 50 48 51
7 New York RB New York RB 34 39 33 48
8 DC United DC United 34 56 54 47
9 Columbus Crew Columbus 34 46 45 47
10 CF Montréal Montréal 34 46 44 46
11 Inter Miami Inter Miami 34 36 53 41
12 Chicago Fire Chicago Fire 34 36 54 34
13 Toronto FC Toronto FC 34 39 66 28
14 Cincinnati Cincinnati 34 37 74 20
15 Colorado Rapids Colorado 34 51 35 61
16 Seattle Sounders Seattle 34 53 33 60
17 Sporting Kansas City Sporting 34 58 40 58
18 Portland Timbers Portland 34 56 52 55
19 Minnesota United Minnesota 34 42 44 49
20 Vancouver Whitecaps Vancouver 34 45 45 49
21 Real Salt Lake Real Salt L. 34 55 54 48
22 LA Galaxy LA Galaxy 34 50 54 48
23 Los Angeles FC Angeles 34 53 51 45
24 San Jose Earthquakes Jose 34 46 54 41
25 FC Dallas FC Dallas 34 47 56 33
26 Austin FC Austin FC 34 35 56 31
27 Houston Dynamo Houston 34 36 54 30
TEMPORADA 2019/2020
MLS - LIGA USA GRUPO 2
Equipo PJ GF GC Puntos
1 Orlando City Orlando City 3 6 3 7
2 Philadelphia Union Philadelphia 3 4 2 7
3 New York City York City 3 2 4 3
4 Inter Miami Inter Miami 3 2 5 0
5 San Jose Earthquakes Jose 3 6 3 7
6 Seattle Sounders Seattle 3 4 2 4
7 Vancouver Whitecaps Vancouver 3 5 7 3
8 Chicago Fire Chicago Fire 3 2 5 3
9 Toronto FC Toronto FC 3 6 5 5
10 New England Revolution England 3 2 1 5
11 CF Montréal Montréal 3 4 5 3
12 DC United DC United 3 3 4 2
13 Sporting Kansas City Sporting 3 6 4 6
14 Minnesota United Minnesota 3 4 3 5
15 Real Salt Lake Real Salt L. 3 2 2 4
16 Colorado Rapids Colorado 3 4 7 1
17 Columbus Crew Columbus 3 7 0 9
18 Cincinnati Cincinnati 3 3 4 6
19 New York RB New York RB 3 1 4 3
20 Atlanta United Atlanta 3 0 3 0
21 Portland Timbers Portland 3 6 4 7
22 Los Angeles FC Angeles 3 11 7 5
23 Houston Dynamo Houston 3 5 6 2
24 LA Galaxy LA Galaxy 3 4 9 1
TEMPORADA 2018/2019
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 New York City York City 34 63 42 64
2 Atlanta United Atlanta 34 58 43 58
3 Philadelphia Union Philadelphia 34 58 50 55
4 Toronto FC Toronto FC 34 57 52 50
5 DC United DC United 34 42 38 50
6 New York RB New York RB 34 53 51 48
7 New England Revolution England 34 50 57 45
8 Chicago Fire Chicago Fire 34 55 47 42
9 CF Montréal Montréal 34 47 60 41
10 Columbus Crew Columbus 34 39 47 38
11 Orlando City Orlando City 34 44 52 37
12 Cincinnati Cincinnati 34 31 75 24
13 Los Angeles FC Angeles 34 85 37 72
14 Seattle Sounders Seattle 34 52 49 56
15 Minnesota United Minnesota 34 52 43 53
16 Real Salt Lake Real Salt L. 34 46 41 53
17 LA Galaxy LA Galaxy 34 58 59 51
18 Portland Timbers Portland 34 52 49 49
19 FC Dallas FC Dallas 34 54 46 48
20 San Jose Earthquakes Jose 34 52 55 44
21 Colorado Rapids Colorado 34 58 63 42
22 Houston Dynamo Houston 34 49 59 40
23 Sporting Kansas City Sporting 34 49 67 38
24 Vancouver Whitecaps Vancouver 34 37 59 34
TEMPORADA 2017/2018
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 New York RB New York RB 34 62 33 71
2 Atlanta United Atlanta 34 70 44 69
3 New York City York City 34 59 45 56
4 DC United DC United 34 60 50 51
5 Columbus Crew Columbus 34 43 45 51
6 Philadelphia Union Philadelphia 34 49 50 50
7 CF Montréal Montréal 34 47 53 46
8 New England Revolution England 34 49 55 41
9 Toronto FC Toronto FC 34 59 64 36
10 Chicago Fire Chicago Fire 34 48 61 32
11 Orlando City Orlando City 34 43 74 28
12 Sporting Kansas City Sporting 34 65 40 62
13 Seattle Sounders Seattle 34 52 37 59
14 Los Angeles FC Angeles 34 68 52 57
15 FC Dallas FC Dallas 34 52 44 57
16 Portland Timbers Portland 34 54 48 54
17 Real Salt Lake Real Salt L. 34 55 58 49
18 LA Galaxy LA Galaxy 34 66 64 48
19 Vancouver Whitecaps Vancouver 34 54 67 47
20 Houston Dynamo Houston 34 58 58 38
21 Minnesota United Minnesota 34 49 71 36
22 Colorado Rapids Colorado 34 36 63 31
23 San Jose Earthquakes Jose 34 49 71 21
TEMPORADA 2016/2017
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Toronto FC Toronto FC 34 74 37 69
2 New York City York City 34 56 43 57
3 Chicago Fire Chicago Fire 34 61 47 55
4 Atlanta United Atlanta 34 70 40 55
5 Columbus Crew Columbus 34 53 49 54
6 New York RB New York RB 34 53 47 50
7 New England Revolution England 34 53 61 45
8 Philadelphia Union Philadelphia 34 50 47 42
9 CF Montréal Montréal 34 52 58 39
10 Orlando City Orlando City 34 39 58 39
11 DC United DC United 34 31 60 32
12 Portland Timbers Portland 34 60 50 53
13 Seattle Sounders Seattle 34 52 39 53
14 Vancouver Whitecaps Vancouver 34 50 49 52
15 Houston Dynamo Houston 34 57 45 50
16 Sporting Kansas City Sporting 34 40 29 49
17 San Jose Earthquakes Jose 34 39 60 46
18 FC Dallas FC Dallas 34 48 48 46
19 Real Salt Lake Real Salt L. 34 49 55 45
20 Minnesota United Minnesota 34 47 70 36
21 Colorado Rapids Colorado 34 31 51 33
22 LA Galaxy LA Galaxy 34 45 67 32
TEMPORADA 2015/2016
NASL - USA - OTOÑO
Equipo PJ GF GC Puntos
1 NY Cosmos NY Cosmos 22 44 21 47
2 Indy Eleven Indy Eleven 22 36 25 37
3 Edmonton Edmonton 22 16 14 36
4 Rayo OKC Rayo OKC 22 28 21 35
5 Miami FC Miami FC 22 31 27 33
6 Fort Lauderdale Strikers Fort 22 19 28 26
7 North Carolina North 22 25 35 26
8 Minnesota United Minnesota 22 25 25 25
9 Puerto Rico FC Puerto Rico 22 19 31 24
10 Tampa Bay Rowdies Tampa 22 29 32 23
11 Jacksonville Armada Jacksonville 22 25 35 23
12 Ottawa Fury Ottawa Fury 22 23 26 22
TEMPORADA 2014/2015
NASL - USA - OTOÑO
Equipo PJ GF GC Puntos
1 Ottawa Fury Ottawa Fury 20 37 15 45
2 Minnesota United Minnesota 20 39 26 39
3 NY Cosmos NY Cosmos 20 31 21 36
4 Fort Lauderdale Strikers Fort 20 37 27 30
5 Edmonton Edmonton 20 25 24 26
6 Atlanta Silverbacks Atlanta 20 24 27 25
7 North Carolina North 20 29 39 21
8 Tampa Bay Rowdies Tampa 20 18 28 20
9 Indy Eleven Indy Eleven 20 23 36 20
10 San Antonio Scorpions Antonio 20 30 37 19
11 Jacksonville Armada Jacksonville 20 18 31 19
TEMPORADA 2013/2014
NASL - USA - PRIMAVERA
Equipo PJ GF GC Puntos
1 Minnesota United Minnesota 9 16 9 20
2 NY Cosmos NY Cosmos 9 14 3 19
3 San Antonio Scorpions Antonio 9 13 9 17
4 North Carolina North 9 11 15 14
5 Fort Lauderdale Strikers Fort 9 18 18 13
6 Ottawa Fury Ottawa Fury 9 14 13 10
7 Tampa Bay Rowdies Tampa 9 11 16 10
8 Atlanta Silverbacks Atlanta 9 12 20 10
9 Edmonton Edmonton 9 11 11 8
10 Indy Eleven Indy Eleven 9 14 20 4
TEMPORADA 2012/2013
NASL - USA - OTOÑO
Equipo PJ GF GC Puntos
1 NY Cosmos NY Cosmos 14 22 12 31
2 North Carolina North 14 21 16 23
3 Tampa Bay Rowdies Tampa 14 30 27 20
4 Minnesota United Minnesota 14 21 19 20
5 Fort Lauderdale Strikers Fort 14 18 20 18
6 Edmonton Edmonton 14 13 14 16
7 Atlanta Silverbacks Atlanta 14 14 22 16
8 San Antonio Scorpions Antonio 14 15 24 10
TEMPORADA 2011/2012
NASL - LIGA ÚNICA
Equipo PJ GF GC Puntos
1 San Antonio Scorpions Antonio 28 46 27 47
2 Tampa Bay Rowdies Tampa 28 37 30 45
3 Puerto Rico Islanders Puerto Rico 28 32 30 41
4 North Carolina North 28 44 46 40
5 Fort Lauderdale Strikers Fort 28 40 46 36
6 Minnesota United Minnesota 28 34 33 35
7 Atlanta Silverbacks Atlanta 28 35 46 30
8 Edmonton Edmonton 28 26 36 25
TEMPORADA 2010/2011
NASL - LIGA ÚNICA
Equipo PJ GF GC Puntos
1 North Carolina North 22 41 23 42
2 Puerto Rico Islanders Puerto Rico 20 34 27 39
3 Tampa Bay Rowdies Tampa 23 46 33 38
4 Fort Lauderdale Strikers Fort 23 33 33 34
5 Minnesota United Minnesota 21 26 27 31
6 CF Montréal Montréal 23 30 30 27
7 Edmonton Edmonton 21 28 33 24
8 Atlanta Silverbacks Atlanta 21 19 51 11
TEMPORADA 2009/2010
USL FIRST DIVISION - USA
Equipo PJ GF GC Puntos
1 North Carolina North 30 44 32 47
2 Vancouver Whitecaps Vancouver 30 32 22 45
3 CF Montréal Montréal 30 36 30 43
4 Fort Lauderdale Strikers Fort 30 37 49 33
5 AC St. Louis Louis 30 32 48 29
6 Crystal Palace Baltimore Crystal 30 24 55 24
7 Rochester New York Rochester 30 38 24 54
8 Austin Aztex Austin Aztex 30 53 40 53
9 Portland Timbers Portland 30 34 23 49
10 Minnesota United Minnesota 30 32 36 40
11 Puerto Rico Islanders Puerto Rico 30 37 35 37
12 Tampa Bay Rowdies Tampa 30 41 46 32

  USO DE MEMORIA  
7,403,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5685
Total Execution Time  0.5697
  CADENA URL  
/historico/Minnesota-United
  GET DATOS  
$_GET['/historico/Minnesota-United']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0143  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 = 'Minnesota-United' 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.0126  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=17861 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=17861 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=17861 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=17861 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17861 AND type_rel = 2
0.0140  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17861 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0139  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 (50916,55796,92573,93167,107482) ORDER BY n.cover_points DESC, update_date DESC
0.0162  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '17861' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient 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 = '17861' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0169  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=17861 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0135  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 (75359,74856,71432,71035) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 74856 AND teamId = 17861
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71035 AND teamId = 17861
0.0124  SELECT count(id) as num_players from rel_players WHERE league_id = 75359 AND teamId = 17861
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17861
0.0127  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '17861' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17861' and rp.type = 4
0.0127  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '17861' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142  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 events2024 e ON e.player_id = p.id AND e.league_id = 74856 WHERE rp.league_id = 74856 AND rp.teamId = 17861 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.0138  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 events2024 e ON e.player_id = p.id AND e.league_id = 74856 WHERE rp.league_id = 74856 AND rp.teamId = 17861 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 events2024 e ON e.player_id = p.id AND e.league_id = 74856 WHERE rp.league_id = 74856 AND rp.teamId = 17861 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 17861 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0139  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 20187 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 20245 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 9113 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 11104 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 9550 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 8459 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 12841 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 12842 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` 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 = 12864 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 12866 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 27660 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC