Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Kawasaki Frontale Kawasaki 38 81 28 92
2 Yokohama F. Marinos Yokohama 38 82 35 79
3 Vissel Kobe Vissel Kobe 38 62 36 73
4 Kashima Antlers Kashima 38 62 36 69
5 Nagoya Grampus Nagoya 38 44 30 66
6 Urawa Reds Urawa Reds 38 47 38 63
7 Sagan Tosu Sagan Tosu 38 43 35 59
8 Avispa Fukuoka Avispa 38 42 37 54
9 FC Tokyo FC Tokyo 38 49 53 53
10 Consadole Sapporo Consadole 38 48 50 51
11 Sanfrecce Hiroshima Sanfrecce 38 44 42 49
12 Cerezo Osaka Cerezo Osaka 38 47 51 48
13 Gamba Osaka Gamba Osaka 38 33 49 44
14 Shimizu S-Pulse Shimizu 38 37 54 42
15 Kashiwa Reysol Kashiwa 38 37 56 41
16 Shonan Bellmare Shonan 38 36 43 37
17 Tokushima Vortis Tokushima 38 34 55 36
18 Oita Trinita Oita Trinita 38 31 55 35
19 Vegalta Sendai Vegalta 38 31 62 28
20 Yokohama Yokohama 38 32 77 27
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Kawasaki Frontale Kawasaki 34 88 31 83
2 Gamba Osaka Gamba Osaka 34 46 42 65
3 Nagoya Grampus Nagoya 34 44 27 63
4 Cerezo Osaka Cerezo Osaka 34 46 37 60
5 Kashima Antlers Kashima 34 54 43 59
6 FC Tokyo FC Tokyo 34 47 42 57
7 Kashiwa Reysol Kashiwa 34 60 46 52
8 Sanfrecce Hiroshima Sanfrecce 34 46 37 48
9 Yokohama F. Marinos Yokohama 34 69 59 47
10 Urawa Reds Urawa Reds 34 43 56 46
11 Oita Trinita Oita Trinita 34 36 45 43
12 Sagan Tosu Sagan Tosu 33 37 41 36
13 Vissel Kobe Vissel Kobe 34 50 59 36
14 Consadole Sapporo Consadole 33 45 58 36
15 Yokohama Yokohama 34 38 60 33
16 Shimizu S-Pulse Shimizu 34 48 70 28
17 Vegalta Sendai Vegalta 34 36 61 28
18 Shonan Bellmare Shonan 34 29 48 27
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Yokohama F. Marinos Yokohama 34 68 38 70
2 FC Tokyo FC Tokyo 34 46 29 64
3 Kashima Antlers Kashima 34 54 30 63
4 Kawasaki Frontale Kawasaki 34 57 34 60
5 Cerezo Osaka Cerezo Osaka 34 39 25 59
6 Sanfrecce Hiroshima Sanfrecce 34 45 29 55
7 Gamba Osaka Gamba Osaka 34 54 48 47
8 Vissel Kobe Vissel Kobe 34 61 59 47
9 Oita Trinita Oita Trinita 34 35 35 47
10 Consadole Sapporo Consadole 34 54 49 46
11 Vegalta Sendai Vegalta 34 38 45 41
12 Shimizu S-Pulse Shimizu 34 45 69 39
13 Nagoya Grampus Nagoya 34 45 50 37
14 Urawa Reds Urawa Reds 34 34 50 37
15 Sagan Tosu Sagan Tosu 34 32 53 36
16 Shonan Bellmare Shonan 34 40 63 36
17 Matsumoto Yamaga Matsumoto 34 21 40 31
18 Júbilo Iwata Júbilo 34 29 51 31
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Kawasaki Frontale Kawasaki 34 57 27 69
2 Sanfrecce Hiroshima Sanfrecce 34 47 35 57
3 Kashima Antlers Kashima 34 50 39 56
4 Consadole Sapporo Consadole 34 48 48 55
5 Urawa Reds Urawa Reds 34 51 39 51
6 FC Tokyo FC Tokyo 34 39 34 50
7 Cerezo Osaka Cerezo Osaka 34 39 38 50
8 Shimizu S-Pulse Shimizu 34 56 48 49
9 Gamba Osaka Gamba Osaka 34 41 46 48
10 Vissel Kobe Vissel Kobe 34 45 52 45
11 Vegalta Sendai Vegalta 34 44 54 45
12 Yokohama F. Marinos Yokohama 34 56 56 41
13 Shonan Bellmare Shonan 34 38 43 41
14 Sagan Tosu Sagan Tosu 34 29 34 41
15 Nagoya Grampus Nagoya 34 52 59 41
16 Júbilo Iwata Júbilo 34 35 48 41
17 Kashiwa Reysol Kashiwa 34 47 54 39
18 V-Varen Nagasaki V-Varen 34 39 59 30
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Kawasaki Frontale Kawasaki 34 71 32 72
2 Kashima Antlers Kashima 34 53 31 72
3 Cerezo Osaka Cerezo Osaka 34 65 43 63
4 Kashiwa Reysol Kashiwa 34 49 33 62
5 Yokohama F. Marinos Yokohama 34 45 36 59
6 Júbilo Iwata Júbilo 34 50 30 58
7 Urawa Reds Urawa Reds 34 64 54 49
8 Sagan Tosu Sagan Tosu 34 41 44 47
9 Vissel Kobe Vissel Kobe 34 40 45 44
10 Gamba Osaka Gamba Osaka 34 48 41 43
11 Consadole Sapporo Consadole 34 39 47 43
12 Vegalta Sendai Vegalta 34 44 53 41
13 FC Tokyo FC Tokyo 34 37 42 40
14 Shimizu S-Pulse Shimizu 34 36 54 34
15 Sanfrecce Hiroshima Sanfrecce 34 32 49 33
16 Ventforet Kofu Ventforet 34 23 39 32
17 Albirex Niigata Albirex 34 28 60 28
18 Omiya Ardija Omiya Ardija 34 28 60 25
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Gamba Osaka Gamba Osaka 34 59 31 63
2 Urawa Reds Urawa Reds 34 52 32 62
3 Kashima Antlers Kashima 34 64 39 60
4 Kashiwa Reysol Kashiwa 34 48 40 60
5 Sagan Tosu Sagan Tosu 34 41 33 60
6 Kawasaki Frontale Kawasaki 34 56 43 55
7 Yokohama F. Marinos Yokohama 34 37 29 51
8 Sanfrecce Hiroshima Sanfrecce 34 44 37 50
9 FC Tokyo FC Tokyo 34 47 33 48
10 Nagoya Grampus Nagoya 34 47 48 48
11 Vissel Kobe Vissel Kobe 34 49 50 45
12 Albirex Niigata Albirex 34 30 36 44
13 Ventforet Kofu Ventforet 34 27 31 41
14 Vegalta Sendai Vegalta 34 35 50 38
15 Shimizu S-Pulse Shimizu 34 42 60 36
16 Omiya Ardija Omiya Ardija 34 44 60 35
17 Cerezo Osaka Cerezo Osaka 34 36 48 31
18 Tokushima Vortis Tokushima 34 16 74 14
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Sanfrecce Hiroshima Sanfrecce 34 51 29 63
2 Yokohama F. Marinos Yokohama 34 49 31 62
3 Kawasaki Frontale Kawasaki 34 65 51 60
4 Cerezo Osaka Cerezo Osaka 34 53 32 59
5 Kashima Antlers Kashima 34 60 52 59
6 Urawa Reds Urawa Reds 34 66 57 56
7 Albirex Niigata Albirex 34 49 42 56
8 FC Tokyo FC Tokyo 34 61 47 54
9 Shimizu S-Pulse Shimizu 34 48 57 50
10 Kashiwa Reysol Kashiwa 34 56 59 48
11 Nagoya Grampus Nagoya 34 47 48 47
12 Sagan Tosu Sagan Tosu 34 54 63 46
13 Vegalta Sendai Vegalta 34 41 38 45
14 Omiya Ardija Omiya Ardija 34 45 48 45
15 Ventforet Kofu Ventforet 34 30 41 37
16 Shonan Bellmare Shonan 34 34 62 25
17 Júbilo Iwata Júbilo 34 40 56 23
18 Oita Trinita Oita Trinita 34 31 67 14
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Sanfrecce Hiroshima Sanfrecce 34 63 34 64
2 Vegalta Sendai Vegalta 34 59 43 57
3 Urawa Reds Urawa Reds 34 47 42 55
4 Yokohama F. Marinos Yokohama 34 44 33 53
5 Sagan Tosu Sagan Tosu 34 48 39 53
6 Kashiwa Reysol Kashiwa 34 57 52 52
7 Nagoya Grampus Nagoya 34 46 47 52
8 Kawasaki Frontale Kawasaki 34 51 50 50
9 Shimizu S-Pulse Shimizu 34 39 40 49
10 FC Tokyo FC Tokyo 34 47 44 48
11 Kashima Antlers Kashima 34 50 43 46
12 Júbilo Iwata Júbilo 34 57 53 46
13 Omiya Ardija Omiya Ardija 34 38 45 44
14 Cerezo Osaka Cerezo Osaka 34 47 53 42
15 Albirex Niigata Albirex 34 29 34 40
16 Vissel Kobe Vissel Kobe 34 41 50 39
17 Gamba Osaka Gamba Osaka 34 67 65 38
18 Consadole Sapporo Consadole 34 25 88 14
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Kashiwa Reysol Kashiwa 34 65 42 72
2 Nagoya Grampus Nagoya 34 67 36 71
3 Gamba Osaka Gamba Osaka 34 78 51 70
4 Vegalta Sendai Vegalta 34 39 25 56
5 Yokohama F. Marinos Yokohama 34 46 40 56
6 Kashima Antlers Kashima 34 53 40 50
7 Sanfrecce Hiroshima Sanfrecce 34 52 49 50
8 Júbilo Iwata Júbilo 34 53 45 47
9 Vissel Kobe Vissel Kobe 34 44 45 46
10 Shimizu S-Pulse Shimizu 34 42 51 45
11 Kawasaki Frontale Kawasaki 34 52 53 44
12 Cerezo Osaka Cerezo Osaka 34 67 53 43
13 Omiya Ardija Omiya Ardija 34 38 48 42
14 Albirex Niigata Albirex 34 38 46 39
15 Urawa Reds Urawa Reds 34 36 43 36
16 Ventforet Kofu Ventforet 34 42 63 33
17 Avispa Fukuoka Avispa 34 34 75 22
18 Montedio Yamagata Montedio 34 23 64 21
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Nagoya Grampus Nagoya 34 54 37 72
2 Gamba Osaka Gamba Osaka 34 65 44 62
3 Cerezo Osaka Cerezo Osaka 34 58 32 61
4 Kashima Antlers Kashima 34 51 31 60
5 Kawasaki Frontale Kawasaki 34 61 47 54
6 Shimizu S-Pulse Shimizu 34 60 49 54
7 Sanfrecce Hiroshima Sanfrecce 34 45 38 51
8 Yokohama F. Marinos Yokohama 34 43 39 51
9 Albirex Niigata Albirex 34 48 45 49
10 Urawa Reds Urawa Reds 34 48 41 48
11 Júbilo Iwata Júbilo 34 38 49 44
12 Omiya Ardija Omiya Ardija 34 39 45 42
13 Montedio Yamagata Montedio 34 29 42 42
14 Vegalta Sendai Vegalta 34 40 46 39
15 Vissel Kobe Vissel Kobe 34 37 45 38
16 FC Tokyo FC Tokyo 34 36 41 36
17 Kyoto Sanga Kyoto Sanga 34 30 60 19
18 Shonan Bellmare Shonan 34 31 82 16
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 34 51 30 66
2 Kawasaki Frontale Kawasaki 34 64 40 64
3 Gamba Osaka Gamba Osaka 34 62 44 60
4 Sanfrecce Hiroshima Sanfrecce 34 53 44 56
5 FC Tokyo FC Tokyo 34 47 39 53
6 Urawa Reds Urawa Reds 34 43 43 52
7 Shimizu S-Pulse Shimizu 34 44 41 51
8 Albirex Niigata Albirex 34 42 31 50
9 Nagoya Grampus Nagoya 34 46 42 50
10 Yokohama F. Marinos Yokohama 34 43 37 46
11 Júbilo Iwata Júbilo 34 50 60 41
12 Kyoto Sanga Kyoto Sanga 34 35 47 41
13 Omiya Ardija Omiya Ardija 34 40 47 39
14 Vissel Kobe Vissel Kobe 34 40 48 39
15 Montedio Yamagata Montedio 34 32 40 39
16 Kashiwa Reysol Kashiwa 34 41 57 34
17 Oita Trinita Oita Trinita 34 26 45 30
18 JEF United JEF United 34 32 56 27
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 33 55 30 60
2 Nagoya Grampus Nagoya 33 48 35 58
3 Kawasaki Frontale Kawasaki 33 63 42 57
4 Oita Trinita Oita Trinita 33 33 24 55
5 FC Tokyo FC Tokyo 33 48 42 55
6 Urawa Reds Urawa Reds 33 49 36 53
7 Shimizu S-Pulse Shimizu 33 47 41 52
8 Gamba Osaka Gamba Osaka 33 44 46 50
9 Vissel Kobe Vissel Kobe 33 39 36 47
10 Yokohama F. Marinos Yokohama 33 37 31 45
11 Kashiwa Reysol Kashiwa 33 46 45 43
12 Kyoto Sanga Kyoto Sanga 33 36 43 41
13 Omiya Ardija Omiya Ardija 33 35 45 40
14 Albirex Niigata Albirex 33 29 44 39
15 Júbilo Iwata Júbilo 33 40 47 37
16 Tokyo Verdy Tokyo Verdy 33 38 48 37
17 JEF United JEF United 33 32 51 35
18 Consadole Sapporo Consadole 33 36 69 18
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 34 60 36 72
2 Urawa Reds Urawa Reds 34 55 28 70
3 Gamba Osaka Gamba Osaka 34 71 37 67
4 Shimizu S-Pulse Shimizu 34 53 36 61
5 Kawasaki Frontale Kawasaki 34 66 48 54
6 Albirex Niigata Albirex 34 48 47 51
7 Yokohama F. Marinos Yokohama 34 54 35 50
8 Kashiwa Reysol Kashiwa 34 43 36 50
9 Júbilo Iwata Júbilo 34 54 55 49
10 Vissel Kobe Vissel Kobe 34 58 48 47
11 Nagoya Grampus Nagoya 34 43 45 45
12 FC Tokyo FC Tokyo 34 49 58 45
13 JEF United JEF United 34 51 56 42
14 Oita Trinita Oita Trinita 34 42 60 41
15 Omiya Ardija Omiya Ardija 34 24 40 35
16 Sanfrecce Hiroshima Sanfrecce 34 44 71 32
17 Ventforet Kofu Ventforet 34 33 65 27
18 Yokohama Yokohama 34 19 66 16
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Urawa Reds Urawa Reds 34 67 28 72
2 Kawasaki Frontale Kawasaki 34 84 55 67
3 Gamba Osaka Gamba Osaka 34 80 48 66
4 Shimizu S-Pulse Shimizu 34 60 41 60
5 Júbilo Iwata Júbilo 34 68 51 58
6 Kashima Antlers Kashima 34 62 53 58
7 Nagoya Grampus Nagoya 34 51 49 48
8 Oita Trinita Oita Trinita 34 47 45 47
9 Yokohama F. Marinos Yokohama 34 49 43 45
10 Sanfrecce Hiroshima Sanfrecce 34 50 56 45
11 JEF United JEF United 34 57 58 44
12 Omiya Ardija Omiya Ardija 34 43 55 44
13 FC Tokyo FC Tokyo 34 56 65 43
14 Albirex Niigata Albirex 34 46 65 42
15 Ventforet Kofu Ventforet 34 42 64 42
16 Avispa Fukuoka Avispa 34 32 56 27
17 Cerezo Osaka Cerezo Osaka 34 44 70 27
18 Kyoto Sanga Kyoto Sanga 34 38 74 22
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Gamba Osaka Gamba Osaka 34 82 58 60
2 Urawa Reds Urawa Reds 34 65 37 59
3 Kashima Antlers Kashima 34 61 39 59
4 JEF United JEF United 34 56 42 59
5 Cerezo Osaka Cerezo Osaka 34 48 40 59
6 Júbilo Iwata Júbilo 34 51 41 51
7 Sanfrecce Hiroshima Sanfrecce 34 50 42 50
8 Kawasaki Frontale Kawasaki 34 54 47 50
9 Yokohama F. Marinos Yokohama 34 41 40 48
10 FC Tokyo FC Tokyo 34 43 40 47
11 Oita Trinita Oita Trinita 34 44 43 43
12 Albirex Niigata Albirex 34 47 62 42
13 Omiya Ardija Omiya Ardija 34 39 50 41
14 Nagoya Grampus Nagoya 34 43 49 39
15 Shimizu S-Pulse Shimizu 34 40 49 39
16 Kashiwa Reysol Kashiwa 34 39 54 35
17 Tokyo Verdy Tokyo Verdy 34 40 73 30
18 Vissel Kobe Vissel Kobe 34 30 67 21
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 30 61 34 62
2 Nagoya Grampus Nagoya 30 63 39 61
3 Flugels Flugels 30 58 44 61
4 Kashiwa Reysol Kashiwa 30 67 52 60
5 Júbilo Iwata Júbilo 30 53 38 60
6 Tokyo Verdy Tokyo Verdy 30 68 42 57
7 Urawa Reds Urawa Reds 30 51 31 55
8 Yokohama F. Marinos Yokohama 30 39 40 40
9 JEF United JEF United 30 45 47 40
10 Shimizu S-Pulse Shimizu 30 50 60 37
11 Shonan Bellmare Shonan 30 47 58 36
12 Gamba Osaka Gamba Osaka 30 38 59 31
13 Avispa Fukuoka Avispa 30 42 64 29
14 Cerezo Osaka Cerezo Osaka 30 38 56 28
15 Sanfrecce Hiroshima Sanfrecce 30 36 60 28
16 Kyoto Sanga Kyoto Sanga 30 22 54 24
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,533,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1839
Total Execution Time  0.1859
  CADENA URL  
/japon2021/grupo1/historico
  GET DATOS  
$_GET['/japon2021/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0018  SELECT type FROM routes WHERE alias = 'japon2021'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'japon' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=58 AND type_rel = 3
0.0032  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 58 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1302659,1301064,1285113,1277278,1270258) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=58 ORDER BY order_id ASC
0.0022  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 = 61091 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 58 AND group_code = 1 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0025  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 = 61091 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 55273 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 48456 AND t.round = 34 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 `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 = 42417 AND t.round = 34 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 `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 = 37772 AND t.round = 34 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 `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 = 3569 AND t.round = 34 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 `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 = 2286 AND t.round = 34 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 `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 = 1562 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 1350 AND t.round = 34 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 = 1066 AND t.round = 34 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 = 888 AND t.round = 34 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 `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 = 267 AND t.round = 33 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 `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 = 425 AND t.round = 34 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 `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 = 426 AND t.round = 34 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 `tables2005` 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 = 712 AND t.round = 34 ORDER BY team.conference 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 `tables1996` 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 = 44548 AND t.round = 30 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-28 18:21:13' 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-28 18:21:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 18:21:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 18:21:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'japon' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0309  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 events2021 e ON e.player_id = p.id AND e.league_id = 61091 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61091 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.0262  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 events2021 e ON e.player_id = p.id AND e.league_id = 61091 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61091 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0026  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 events2021 e ON e.player_id = p.id AND e.league_id = 61091 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61091 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 `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 = 61091 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC