Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Louisville City Louisville 34 65 28 72
2 Memphis 901 Memphis 901 34 67 33 68
3 Tampa Bay Rowdies Tampa 34 73 33 67
4 Birmingham Legion Birmingham 34 56 37 58
5 Pittsburgh Riverhounds Pittsburgh 34 50 38 57
6 Miami FC Miami FC 34 47 32 55
7 Detroit City Detroit City 34 44 30 54
8 FC Tulsa FC Tulsa 34 48 58 42
9 Indy Eleven Indy Eleven 34 41 55 41
10 Hartford Athletic Hartford 34 47 57 36
11 Loudoun United Loudoun 34 36 74 28
12 Charleston Battery Charleston 34 41 77 25
13 Atlanta United II Atlanta 34 39 85 23
14 New York RB II York 34 24 76 15
15 San Antonio San Antonio 34 54 26 77
16 San Diego Loyal Diego Loyal 34 68 55 60
17 Colorado Springs Switchback Colorado 34 59 53 55
18 Sacramento Republic Sacramento 34 48 34 53
19 New Mexico United Mexico 34 49 40 51
20 Rio Grande Valley Grande 34 51 40 49
21 Oakland Roots Oakland 34 51 46 46
22 El Paso Locomotive Paso 34 56 52 46
23 Las Vegas Lights Vegas Lights 34 40 50 45
24 Phoenix Rising Phoenix 34 50 58 42
25 LA Galaxy II Galaxy 34 53 63 40
26 Monterey Bay Monterey 34 42 59 40
27 Orange County SC Orange 34 49 59 34
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Tampa Bay Rowdies Tampa 32 55 23 71
2 Charlotte Independence Charlotte 32 57 36 59
3 Pittsburgh Riverhounds Pittsburgh 32 51 34 56
4 Miami FC Miami FC 32 55 39 55
5 Hartford Athletic Hartford 32 50 50 41
6 Charleston Battery Charleston 32 44 56 36
7 New York RB II York 32 39 65 26
8 Loudoun United Loudoun 32 31 78 15
9 Louisville City Louisville 32 61 37 61
10 Birmingham Legion Birmingham 32 49 31 58
11 Memphis 901 Memphis 901 32 47 42 50
12 FC Tulsa FC Tulsa 32 49 48 47
13 OKC Energy OKC Energy 32 30 38 37
14 Indy Eleven Indy Eleven 32 32 47 35
15 Atlanta United II Atlanta 32 44 55 32
16 Sporting Kansas City II Sporting 32 34 61 23
17 El Paso Locomotive Paso 32 56 34 64
18 San Antonio San Antonio 32 50 38 52
19 Colorado Springs Switchback Colorado 32 60 50 49
20 Rio Grande Valley Grande 32 49 42 47
21 New Mexico United Mexico 32 44 40 46
22 Austin Bold Austin Bold 32 32 42 42
23 Real Monarchs Real 32 28 56 22
24 Phoenix Rising Phoenix 32 68 32 70
25 Orange County SC Orange 32 44 37 52
26 San Diego Loyal Diego Loyal 32 51 43 48
27 LA Galaxy II Galaxy 32 54 54 40
28 Tacoma Defiance Tacoma 32 37 41 39
29 Oakland Roots Oakland 32 33 43 38
30 Sacramento Republic Sacramento 32 36 42 36
31 Las Vegas Lights Vegas Lights 32 41 77 21
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Reno 1868 Reno 1868 16 43 21 36
2 Sacramento Republic Sacramento 17 29 18 33
3 Tacoma Defiance Tacoma 15 25 29 14
4 Portland Timbers II Portland 15 17 50 6
5 Phoenix Rising Phoenix 16 46 17 35
6 LA Galaxy II Galaxy 16 29 32 26
7 Orange County SC Orange 17 19 20 24
8 San Diego Loyal Diego Loyal 16 17 18 23
9 Las Vegas Lights Vegas Lights 16 24 34 11
10 El Paso Locomotive Paso 16 24 14 32
11 New Mexico United Mexico 14 21 17 24
12 Colorado Springs Switchback Colorado 16 19 28 13
13 Real Monarchs Real 15 14 23 11
14 San Antonio San Antonio 16 30 14 33
15 Austin Bold Austin Bold 16 31 26 23
16 FC Tulsa FC Tulsa 15 19 15 23
17 OKC Energy OKC Energy 15 10 26 10
18 Rio Grande Valley Grande 13 15 28 6
19 Louisville City Louisville 16 28 12 35
20 Indy Eleven Indy Eleven 16 21 19 23
21 Saint Louis Saint Louis 15 19 20 22
22 Sporting Kansas City II Sporting 15 20 27 16
23 Pittsburgh Riverhounds Pittsburgh 15 39 9 34
24 Hartford Athletic Hartford 15 30 24 32
25 New York RB II York 16 30 37 15
26 Philadelphia Union II Philadelphia 16 20 45 9
27 Loudoun United Loudoun 13 10 28 6
28 Charlotte Independence Charlotte 16 24 22 28
29 Birmingham Legion Birmingham 15 28 17 25
30 North Carolina North 14 15 20 16
31 Memphis 901 Memphis 901 15 24 31 16
32 Tampa Bay Rowdies Tampa 16 25 11 33
33 Charleston Battery Charleston 15 26 15 30
34 Miami FC Miami FC 16 20 34 16
35 Atlanta United II Atlanta 16 23 33 12
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Pittsburgh Riverhounds Pittsburgh 35 59 30 71
2 Nashville SC Nashville 34 59 26 67
3 Indy Eleven Indy Eleven 34 48 29 63
4 Louisville City Louisville 34 58 41 60
5 Tampa Bay Rowdies Tampa 34 61 33 58
6 New York RB II York 34 74 51 57
7 North Carolina North 34 57 37 56
8 Ottawa Fury Ottawa Fury 34 50 43 52
9 Charleston Battery Charleston 34 44 44 46
10 Birmingham Legion Birmingham 34 35 51 43
11 Saint Louis Saint Louis 34 40 41 42
12 Loudoun United Loudoun 34 59 65 39
13 Charlotte Independence Charlotte 34 42 53 38
14 Atlanta United II Atlanta 34 45 77 35
15 Memphis 901 Memphis 901 35 37 53 34
16 Philadelphia Union II Philadelphia 34 49 78 31
17 Hartford Athletic Hartford 34 49 80 29
18 Sporting Kansas City II Sporting 34 46 80 26
19 Phoenix Rising Phoenix 34 89 36 78
20 Reno 1868 Reno 1868 34 72 51 60
21 Fresno FC Fresno FC 34 58 44 57
22 Real Monarchs Real 34 71 53 56
23 Orange County SC Orange 34 54 43 54
24 El Paso Locomotive Paso 34 42 36 50
25 Sacramento Republic Sacramento 34 50 43 48
26 Austin Bold Austin Bold 34 53 52 48
27 LA Galaxy II Galaxy 34 59 62 48
28 New Mexico United Mexico 34 59 57 46
29 San Antonio San Antonio 34 62 57 45
30 Rio Grande Valley Grande 34 50 58 41
31 Las Vegas Lights Vegas Lights 34 46 56 41
32 Portland Timbers II Portland 34 65 71 38
33 OKC Energy OKC Energy 34 45 58 38
34 FC Tulsa FC Tulsa 34 45 69 34
35 Tacoma Defiance Tacoma 34 42 82 31
36 Colorado Springs Switchback Colorado 34 31 65 27
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Cincinnati Cincinnati 35 74 36 78
2 Louisville City Louisville 36 73 40 69
3 Pittsburgh Riverhounds Pittsburgh 35 48 26 62
4 Charleston Battery Charleston 34 47 34 56
5 New York RB II York 34 73 58 53
6 Nashville SC Nashville 35 42 31 50
7 Indy Eleven Indy Eleven 34 47 44 49
8 Philadelphia Union II Philadelphia 34 55 43 48
9 North Carolina North 34 60 50 47
10 Ottawa Fury Ottawa Fury 34 31 43 45
11 Tampa Bay Rowdies Tampa 36 48 47 44
12 Charlotte Independence Charlotte 34 44 57 42
13 Penn FC Penn FC 35 38 50 34
14 Atlanta United II Atlanta 34 37 72 31
15 Richmond Kickers Richmond 35 33 80 28
16 Toronto II Toronto II 35 43 80 18
17 Orange County SC Orange 36 72 41 70
18 Sacramento Republic Sacramento 35 50 33 68
19 Phoenix Rising Phoenix 35 64 39 64
20 Real Monarchs Real 35 55 50 60
21 Reno 1868 Reno 1868 34 57 37 59
22 Portland Timbers II Portland 35 60 53 55
23 Saint Louis Saint Louis 34 44 38 53
24 Sporting Kansas City II Sporting 35 53 56 53
25 San Antonio San Antonio 34 45 48 50
26 Fresno FC Fresno FC 35 48 40 42
27 OKC Energy OKC Energy 34 43 47 41
28 Colorado Springs Switchback Colorado 35 37 40 40
29 LA Galaxy II Galaxy 35 65 70 40
30 Rio Grande Valley Grande 34 36 42 38
31 Las Vegas Lights Vegas Lights 33 49 72 31
32 Seattle Sounders II Seattle 35 43 76 25
33 FC Tulsa FC Tulsa 34 36 77 21
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Louisville City Louisville 32 58 31 62
2 Charleston Battery Charleston 32 53 33 54
3 Tampa Bay Rowdies Tampa 32 50 35 53
4 Rochester New York Rochester 32 36 28 53
5 Charlotte Independence Charlotte 32 52 40 48
6 Cincinnati Cincinnati 32 46 48 46
7 Philadelphia Union II Philadelphia 32 46 45 44
8 New York RB II York 32 57 60 44
9 Orlando City II Orlando City 32 37 36 42
10 Ottawa Fury Ottawa Fury 32 42 41 38
11 Penn FC Penn FC 32 28 47 37
12 Pittsburgh Riverhounds Pittsburgh 32 33 42 36
13 Saint Louis Saint Louis 32 35 48 36
14 Richmond Kickers Richmond 32 24 36 32
15 Toronto II Toronto II 32 27 54 25
16 Real Monarchs Real 32 59 31 67
17 San Antonio San Antonio 32 45 24 62
18 Reno 1868 Reno 1868 32 75 39 59
19 Sporting Kansas City II Sporting 32 55 37 58
20 Phoenix Rising Phoenix 32 50 37 58
21 OKC Energy OKC Energy 32 46 41 49
22 Sacramento Republic Sacramento 32 45 43 46
23 FC Tulsa FC Tulsa 32 46 49 46
24 Colorado Springs Switchback Colorado 32 55 51 44
25 Orange County SC Orange 32 43 47 43
26 Rio Grande Valley Grande 32 37 50 35
27 Seattle Sounders II Seattle 32 42 61 31
28 LA Galaxy II Galaxy 32 32 64 29
29 Vancouver Whitecaps II Vancouver 32 32 52 24
30 Portland Timbers II Portland 32 27 63 15
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 New York RB II York 30 61 21 69
2 Louisville City Louisville 30 52 27 60
3 Cincinnati Cincinnati 30 41 27 56
4 Rochester New York Rochester 30 38 25 51
5 Charlotte Independence Charlotte 30 48 29 50
6 Charleston Battery Charleston 30 38 33 48
7 Richmond Kickers Richmond 30 33 26 45
8 Orlando City II Orlando City 30 35 49 35
9 Wilmington Hammerheads Wilmington 30 37 47 34
10 Penn FC Penn FC 30 37 54 31
11 Philadelphia Union II Philadelphia 30 32 43 28
12 Toronto II Toronto II 30 36 58 26
13 Pittsburgh Riverhounds Pittsburgh 30 31 50 25
14 FC Montreal FC Montreal 30 35 57 23
15 Sacramento Republic Sacramento 30 43 27 52
16 Rio Grande Valley Grande 30 47 24 51
17 Colorado Springs Switchback Colorado 30 37 27 49
18 Sporting Kansas City II Sporting 30 45 36 48
19 LA Galaxy II Galaxy 30 52 42 47
20 Vancouver Whitecaps II Vancouver 30 44 44 45
21 OKC Energy OKC Energy 30 32 30 43
22 Orange County SC Orange 30 39 41 40
23 Portland Timbers II Portland 30 38 42 40
24 San Antonio San Antonio 30 36 36 38
25 Real Monarchs Real 30 31 41 36
26 Seattle Sounders II Seattle 30 35 50 35
27 Saint Louis Saint Louis 30 42 44 34
28 Phoenix Rising Phoenix 30 40 46 34
29 FC Tulsa FC Tulsa 30 25 64 19
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Rochester New York Rochester 28 40 15 61
2 Louisville City Louisville 28 55 34 48
3 Charleston Battery Charleston 28 43 28 46
4 New York RB II York 28 46 45 42
5 Pittsburgh Riverhounds Pittsburgh 28 53 42 41
6 Richmond Kickers Richmond 28 41 35 41
7 Charlotte Independence Charlotte 28 38 35 40
8 Penn FC Penn FC 28 49 53 39
9 Saint Louis Saint Louis 28 30 40 33
10 FC Montreal FC Montreal 28 32 46 28
11 Toronto II Toronto II 28 26 52 23
12 Wilmington Hammerheads Wilmington 28 22 42 19
13 Colorado Springs Switchback Colorado 29 56 36 49
14 LA Galaxy II Galaxy 28 40 30 48
15 OKC Energy OKC Energy 28 44 36 47
16 Sacramento Republic Sacramento 28 43 31 46
17 Orange County SC Orange 28 37 35 44
18 Seattle Sounders II Seattle 28 45 42 42
19 FC Tulsa FC Tulsa 28 49 46 39
20 Portland Timbers II Portland 29 39 48 35
21 Austin Aztex Austin Aztex 28 32 41 33
22 Phoenix Rising Phoenix 28 31 55 32
23 Vancouver Whitecaps II Vancouver 28 39 53 30
24 Real Monarchs Real 28 32 42 29
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 LA Galaxy II Galaxy 2 4 2 4
2 Charleston Battery Charleston 2 3 3 2
3 Orlando City Orlando City 2 2 2 2
4 Richmond Kickers Richmond 1 2 2 1
5 Pittsburgh Riverhounds Pittsburgh 1 1 1 1
6 Sacramento Republic Sacramento 1 1 1 1
7 Charlotte Eagles Charlotte 0 0 0 0
8 OKC Energy OKC Energy 0 0 0 0
9 Penn FC Penn FC 0 0 0 0
10 Phoenix Rising Phoenix 0 0 0 0
11 Rochester New York Rochester 0 0 0 0
12 Wilmington Hammerheads Wilmington 0 0 0 0
13 Orange County SC Orange 1 1 3 0
14 Dayton Dutch Lions Dayton Dutch 1 0 3 0
15 FC Dallas Reservas Dallas 2 4 0 6
16 New York RB Reservas York 2 4 2 3
17 Chicago Fire Reservas Chicago Fire 1 2 1 3
18 Montreal Impact II Montreal 1 0 2 0
19 Colorado Rapid Reservas Colorado 0 0 0 0
20 Real Salt Lake Reservas Real Salt L. 0 0 0 0
21 Seattle Sounders II Seattle 0 0 0 0
22 Chivas USA Reservas Chivas 1 0 2 0
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Richmond Kickers Richmond 24 48 22 51
2 Orlando City II Orlando City 24 50 26 48
3 Penn FC Penn FC 24 52 35 41
4 Orange County SC Orange 24 48 32 39
5 Charleston Battery Charleston 24 43 28 39
6 Dayton Dutch Lions Dayton Dutch 24 38 39 36
7 Charlotte Eagles Charlotte 24 40 37 35
8 Pittsburgh Riverhounds Pittsburgh 24 34 32 34
9 VSI Tampa Bay Tampa 24 36 33 31
10 Wilmington Hammerheads Wilmington 24 32 38 31
11 Rochester New York Rochester 24 24 38 26
12 Phoenix Rising Phoenix 24 28 41 20
13 Antigua Barracuda Antigua 24 10 82 0
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Orlando City Orlando City 24 50 18 57
2 Rochester New York Rochester 24 27 23 41
3 Penn FC Penn FC 24 35 29 38
4 Wilmington Hammerheads Wilmington 24 35 32 38
5 Charlotte Eagles Charlotte 24 34 26 36
6 Richmond Kickers Richmond 24 31 28 36
7 Charleston Battery Charleston 23 33 26 35
8 Orange County SC Orange 24 26 30 28
9 Dayton Dutch Lions Dayton Dutch 24 20 29 22
10 Pittsburgh Riverhounds Pittsburgh 24 20 39 17
11 Antigua Barracuda Antigua 23 16 47 16
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Wilmington Hammerheads Wilmington 24 42 30 45
2 FC New York FC New York 24 27 37 25
3 Orlando City Orlando City 23 34 14 50
4 Richmond Kickers Richmond 24 35 21 41
5 Charleston Battery Charleston 24 24 25 35
6 Charlotte Eagles Charlotte 24 31 30 30
7 Antigua Barracuda Antigua 18 18 29 14
8 Rochester New York Rochester 24 31 23 40
9 Penn FC Penn FC 24 37 30 37
10 Orange County SC Orange 21 27 25 29
11 Pittsburgh Riverhounds Pittsburgh 24 23 32 27
12 Dayton Dutch Lions Dayton Dutch 24 21 54 12
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
7,879,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5184
Total Execution Time  0.5203
  CADENA URL  
/usl_pro_usa2022/grupo1/historico
  GET DATOS  
$_GET['/usl_pro_usa2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0035  SELECT type FROM routes WHERE alias = 'usl_pro_usa2022'
0.0076  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usl_pro_usa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0035  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1666 AND type_rel = 3
0.0039  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1666 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0041  SELECT /*53 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 (1282492,1272547,1261789,1137367,1108384) ORDER BY n.cover_points DESC, update_date DESC
0.0034  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1666 ORDER BY order_id ASC
0.0037  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 66327 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0038  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1666 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0078  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 `tables2022` 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 = 66327 AND t.round = 46 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0071  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 `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 = 62000 AND t.round = 50 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 `tables2020` 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 = 53559 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0077  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 `tables2019` 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 = 48501 AND t.round = 62 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 `tables2018` 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 = 42470 AND t.round = 57 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 `tables2017` 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 = 37877 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 20259 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 9545 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0603  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 = 14027 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 14044 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 14045 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 14046 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 10:48:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0207  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 10:48:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 10:48:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 10:48:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usl_pro_usa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.1086  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 66327 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66327 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.1386  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 66327 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66327 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0104  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 66327 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66327 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0082  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66327 AND t.round = 46 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC