Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Melbourne City Melbourne 26 54 34 49
2 Melbourne Victory Melbourne 26 42 25 48
3 Western United FC Western 26 38 30 45
4 Adelaide United Adelaide 26 38 31 43
5 Central Coast Mariners Central 26 49 35 42
6 Wellington Phoenix Wellington 26 34 49 39
7 Macarthur FC Macarthur 26 38 47 33
8 Sydney FC Sydney FC 26 38 41 31
9 Newcastle Jets Newcastle 26 45 43 29
10 Western Sydney Wanderers Western 26 30 38 27
11 Brisbane Roar Brisbane 26 29 39 26
12 Perth Glory Perth Glory 26 20 43 18
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Melbourne City Melbourne 26 57 32 49
2 Sydney FC Sydney FC 26 39 23 47
3 Central Coast Mariners Central 26 35 31 42
4 Brisbane Roar Brisbane 26 36 28 40
5 Adelaide United Adelaide 26 39 41 39
6 Macarthur FC Macarthur 26 33 36 39
7 Wellington Phoenix Wellington 26 44 34 38
8 Western Sydney Wanderers Western 26 45 43 35
9 Perth Glory Perth Glory 26 44 44 34
10 Western United FC Western 26 30 47 28
11 Newcastle Jets Newcastle 26 24 38 21
12 Melbourne Victory Melbourne 26 31 60 19
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Sydney FC Sydney FC 26 49 25 53
2 Melbourne City Melbourne 26 49 37 47
3 Wellington Phoenix Wellington 26 38 33 41
4 Brisbane Roar Brisbane 26 29 28 40
5 Western United FC Western 26 46 37 39
6 Perth Glory Perth Glory 26 43 36 37
7 Adelaide United Adelaide 26 44 49 36
8 Newcastle Jets Newcastle 26 32 40 34
9 Western Sydney Wanderers Western 26 35 40 33
10 Melbourne Victory Melbourne 26 33 44 23
11 Central Coast Mariners Central 26 26 55 18
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Perth Glory Perth Glory 27 56 23 60
2 Sydney FC Sydney FC 27 43 29 52
3 Melbourne Victory Melbourne 27 50 32 50
4 Adelaide United Adelaide 27 37 32 44
5 Melbourne City Melbourne 27 39 32 40
6 Wellington Phoenix Wellington 27 46 43 40
7 Newcastle Jets Newcastle 27 40 36 35
8 Western Sydney Wanderers Western 27 42 54 24
9 Brisbane Roar Brisbane 27 38 71 18
10 Central Coast Mariners Central 27 31 70 13
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Sydney FC Sydney FC 27 64 22 64
2 Newcastle Jets Newcastle 27 57 37 50
3 Melbourne City Melbourne 27 41 33 43
4 Melbourne Victory Melbourne 27 43 37 41
5 Adelaide United Adelaide 27 36 38 39
6 Brisbane Roar Brisbane 27 33 40 35
7 Western Sydney Wanderers Western 27 38 47 33
8 Perth Glory Perth Glory 27 37 50 32
9 Wellington Phoenix Wellington 27 31 55 21
10 Central Coast Mariners Central 27 28 49 20
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Sydney FC Sydney FC 27 55 12 66
2 Melbourne Victory Melbourne 27 49 31 49
3 Brisbane Roar Brisbane 27 43 37 42
4 Melbourne City Melbourne 27 49 44 39
5 Perth Glory Perth Glory 27 53 53 39
6 Western Sydney Wanderers Western 27 35 35 36
7 Wellington Phoenix Wellington 27 41 46 30
8 Central Coast Mariners Central 27 31 52 23
9 Adelaide United Adelaide 27 25 46 23
10 Newcastle Jets Newcastle 27 28 53 22
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Adelaide United Adelaide 27 45 28 49
2 Western Sydney Wanderers Western 27 44 33 48
3 Brisbane Roar Brisbane 27 49 40 48
4 Melbourne City Melbourne 27 63 44 44
5 Perth Glory Perth Glory 27 49 42 43
6 Melbourne Victory Melbourne 27 40 33 41
7 Sydney FC Sydney FC 27 36 36 34
8 Newcastle Jets Newcastle 27 28 41 30
9 Wellington Phoenix Wellington 27 34 54 25
10 Central Coast Mariners Central 27 33 70 13
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Melbourne Victory Melbourne 27 57 32 53
2 Sydney FC Sydney FC 27 52 35 50
3 Perth Glory Perth Glory 27 45 35 50
4 Adelaide United Adelaide 27 47 32 46
5 Wellington Phoenix Wellington 27 45 35 46
6 Melbourne City Melbourne 27 36 41 35
7 Brisbane Roar Brisbane 27 43 44 34
8 Central Coast Mariners Central 27 26 50 23
9 Western Sydney Wanderers Western 27 29 44 18
10 Newcastle Jets Newcastle 27 23 55 17
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Brisbane Roar Brisbane 27 43 25 52
2 Western Sydney Wanderers Western 27 34 29 42
3 Central Coast Mariners Central 27 33 36 42
4 Melbourne Victory Melbourne 27 42 43 41
5 Sydney FC Sydney FC 27 40 38 39
6 Adelaide United Adelaide 27 45 36 38
7 Newcastle Jets Newcastle 27 34 34 36
8 Perth Glory Perth Glory 27 28 37 28
9 Wellington Phoenix Wellington 27 36 51 28
10 Melbourne Heart Melbourne 27 36 42 26
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Western Sydney Wanderers Western 27 41 21 57
2 Central Coast Mariners Central 27 48 22 54
3 Melbourne Victory Melbourne 27 48 45 44
4 Adelaide United Adelaide 27 38 37 41
5 Brisbane Roar Brisbane 27 33 29 35
6 Perth Glory Perth Glory 27 29 31 32
7 Sydney FC Sydney FC 27 41 51 32
8 Newcastle Jets Newcastle 27 30 45 31
9 Melbourne Heart Melbourne 27 31 40 27
10 Wellington Phoenix Wellington 27 31 49 27
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Central Coast Mariners Central 26 38 23 48
2 Brisbane Roar Brisbane 26 48 27 46
3 Perth Glory Perth Glory 26 36 33 40
4 Wellington Phoenix Wellington 26 33 30 40
5 Melbourne Heart Melbourne 26 34 33 36
6 Newcastle Jets Newcastle 26 36 38 35
7 Sydney FC Sydney FC 26 34 40 35
8 Melbourne Victory Melbourne 26 33 39 29
9 Adelaide United Adelaide 26 25 43 24
10 Gold Coast United Gold Coast. 26 29 40 21
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Brisbane Roar Brisbane 30 58 26 65
2 Central Coast Mariners Central 30 50 31 57
3 Adelaide United Adelaide 30 51 36 50
4 Gold Coast United Gold Coast. 30 40 32 46
5 Melbourne Victory Melbourne 30 45 39 43
6 Wellington Phoenix Wellington 30 39 41 41
7 Newcastle Jets Newcastle 30 29 33 35
8 Melbourne Heart Melbourne 30 32 42 35
9 Sydney FC Sydney FC 30 35 40 34
10 Perth Glory Perth Glory 30 27 54 23
11 North Queensland Fury North 30 28 60 19
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Sydney FC Sydney FC 27 35 23 48
2 Melbourne Victory Melbourne 27 47 32 47
3 Gold Coast United Gold Coast. 27 39 35 44
4 Wellington Phoenix Wellington 27 37 29 40
5 Perth Glory Perth Glory 27 40 34 39
6 Newcastle Jets Newcastle 27 33 45 34
7 North Queensland Fury North 27 29 46 32
8 Central Coast Mariners Central 27 32 29 30
9 Brisbane Roar Brisbane 27 32 42 30
10 Adelaide United Adelaide 27 24 33 29
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Melbourne Victory Melbourne 21 39 27 38
2 Adelaide United Adelaide 21 31 19 38
3 Brisbane Roar Brisbane 21 36 25 36
4 Central Coast Mariners Central 21 35 32 28
5 Sydney FC Sydney FC 21 33 32 26
6 Wellington Phoenix Wellington 21 23 31 26
7 Perth Glory Perth Glory 21 31 44 22
8 Newcastle Jets Newcastle 21 21 39 18
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Central Coast Mariners Central 21 30 25 34
2 Newcastle Jets Newcastle 21 25 21 34
3 Sydney FC Sydney FC 21 28 24 32
4 Brisbane Roar Brisbane 21 25 21 31
5 Melbourne Victory Melbourne 21 29 29 27
6 Adelaide United Adelaide 21 31 29 26
7 Perth Glory Perth Glory 21 27 34 20
8 Wellington Phoenix Wellington 21 25 37 20
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Melbourne Victory Melbourne 21 41 20 45
2 Adelaide United Adelaide 21 32 27 33
3 Newcastle Jets Newcastle 21 32 30 30
4 Sydney FC Sydney FC 21 29 19 29
5 Brisbane Roar Brisbane 21 25 27 29
6 Central Coast Mariners Central 21 22 26 24
7 Perth Glory Perth Glory 21 24 30 20
8 NZ Knights NZ Knights 21 13 39 19
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Adelaide United Adelaide 21 33 25 43
2 Sydney FC Sydney FC 21 35 28 36
3 Central Coast Mariners Central 21 35 28 32
4 Newcastle Jets Newcastle 21 27 29 31
5 Perth Glory Perth Glory 21 34 29 29
6 Brisbane Roar Brisbane 21 27 22 28
7 Melbourne Victory Melbourne 21 26 24 26
8 NZ Knights NZ Knights 21 15 47 6
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Perth Glory Perth Glory 24 56 22 57
2 Parramatta Power Parramatta 24 58 30 51
3 Adelaide United Adelaide 24 28 25 40
4 Marconi Stallions Marconi 24 29 25 38
5 South Melbourne South 24 39 21 37
6 Brisbane Strikers Brisbane 24 28 33 32
7 Spirit FC Spirit FC 24 31 33 30
8 Sydney Olympic Sydney 24 26 31 29
9 South Coast Wolves South Coast 24 34 41 29
10 Sydney United Sydney 24 18 25 29
11 Newcastle Jets Newcastle 24 18 33 24
12 FC Melbourne Knights Melbourne 24 21 41 23
13 NZ Knights NZ Knights 24 25 51 15
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Perth Glory Perth Glory 24 50 19 53
2 Sydney Olympic Sydney 24 51 28 51
3 Parramatta Power Parramatta 24 48 29 37
4 Newcastle Jets Newcastle 24 37 25 37
5 Adelaide City Adelaide 24 40 34 37
6 Spirit FC Spirit FC 24 37 44 36
7 South Melbourne South 24 36 37 35
8 Sydney United Sydney 24 23 31 27
9 FC Melbourne Knights Melbourne 24 38 52 27
10 Brisbane Strikers Brisbane 24 38 45 26
11 NZ Knights NZ Knights 24 26 45 24
12 Marconi Stallions Marconi 24 25 42 23
13 South Coast Wolves South Coast 24 25 43 23
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Perth Glory Perth Glory 24 52 23 55
2 Newcastle Jets Newcastle 24 33 21 42
3 Sydney Olympic Sydney 24 37 24 40
4 Brisbane Strikers Brisbane 24 40 33 37
5 South Melbourne South 24 30 22 36
6 FC Melbourne Knights Melbourne 24 41 40 36
7 Parramatta Power Parramatta 24 34 30 34
8 Spirit FC Spirit FC 24 36 39 34
9 Marconi Stallions Marconi 24 32 36 30
10 South Coast Wolves South Coast 24 28 43 25
11 Sydney United Sydney 24 27 37 24
12 Adelaide City Adelaide 24 27 39 20
13 NZ Knights NZ Knights 24 28 58 14
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 South Melbourne South 30 68 25 67
2 Perth Glory Perth Glory 30 73 33 61
3 South Coast Wolves South Coast 30 79 42 59
4 Sydney Olympic Sydney 30 58 37 57
5 Marconi Stallions Marconi 30 42 33 50
6 FC Melbourne Knights Melbourne 30 61 46 49
7 Adelaide City Adelaide 30 54 54 43
8 NZ Knights NZ Knights 30 52 52 43
9 Parramatta Power Parramatta 30 42 44 42
10 Sydney United Sydney 30 43 60 39
11 Brisbane Strikers Brisbane 30 52 56 35
12 Canberra Cosmos Canberra 30 47 57 34
13 Spirit FC Spirit FC 30 37 51 30
14 Newcastle Jets Newcastle 30 37 56 30
15 Eastern Pride Eastern 30 30 64 17
16 Carlton SC Carlton SC 30 13 78 12
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Perth Glory Perth Glory 34 60 42 64
2 South Coast Wolves South Coast 34 72 44 60
3 Carlton SC Carlton SC 34 55 39 58
4 Adelaide City Adelaide 34 57 37 56
5 Sydney Olympic Sydney 34 56 40 55
6 Marconi Stallions Marconi 34 53 49 55
7 Newcastle Breakers Newcastle 34 44 44 51
8 NZ Knights NZ Knights 34 57 59 50
9 Brisbane Strikers Brisbane 34 46 40 49
10 South Melbourne South 34 55 51 49
11 Parramatta Power Parramatta 34 52 47 47
12 FC Melbourne Knights Melbourne 34 44 57 45
13 Spirit FC Spirit FC 34 41 58 36
14 Canberra Cosmos Canberra 34 44 64 36
15 Gippsland Falcons Gippsland 34 23 49 29
16 Sydney United Sydney 34 19 58 20
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  
6,836,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1636
Total Execution Time  0.1657
  CADENA URL  
/australia2022/grupo1/historico
  GET DATOS  
$_GET['/australia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0021  SELECT type FROM routes WHERE alias = 'australia2022'
0.0045  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'australia' 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.0023  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 = 63330 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 54 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0033  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 = 63330 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 60104 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 49885 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 43672 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 38708 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 29628 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 15477 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 4164 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 2387 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 2050 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 1482 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 1075 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 899 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2009` 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 = 263 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2008` 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 = 8802 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2007` 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 = 8801 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2006` 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 = 8799 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2004` 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 = 9956 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2003` 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 = 9957 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2002` 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 = 9959 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2001` 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 = 9961 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2000` 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 = 9964 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 08:04:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 08:04:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 08:04:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 08:04:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'australia' 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.0148  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 = 63330 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63330 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.0207  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 = 63330 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63330 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 = 63330 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63330 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  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 = 63330 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC