Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 70 29 68
2 Slavia Praha Slavia Praha 30 81 25 66
3 Viktoria Plzeň Viktoria 30 55 29 57
4 Bohemians 1905 Bohemians 30 53 49 48
5 Slovácko Slovácko 30 36 38 46
6 Sigma Olomouc Sigma 30 45 40 41
7 Slovan Liberec Slovan 30 39 43 38
8 Hradec Králové Hradec 30 34 40 38
9 Mladá Boleslav Mladá 30 39 42 37
10 České Budějovice České 30 35 54 35
11 Jablonec Jablonec 30 46 57 35
12 Baník Ostrava Baník 30 43 42 35
13 Teplice Teplice 30 38 63 32
14 Zbrojovka Brno Zbrojovka 30 40 56 31
15 Pardubice Pardubice 30 29 58 28
16 FC Trinity Zlín Trinity 30 37 55 26
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 71 19 73
2 Viktoria Plzeň Viktoria 30 53 19 72
3 Sparta Praha Sparta Praha 30 65 32 66
4 Slovácko Slovácko 30 50 30 59
5 Baník Ostrava Baník 30 54 39 51
6 Hradec Králové Hradec 30 38 40 40
7 Mladá Boleslav Mladá 30 45 48 38
8 Slovan Liberec Slovan 30 29 38 37
9 Sigma Olomouc Sigma 30 39 37 37
10 České Budějovice České 30 40 46 36
11 FC Trinity Zlín Trinity 30 36 53 30
12 Teplice Teplice 30 29 49 27
13 Jablonec Jablonec 30 22 45 26
14 Bohemians 1905 Bohemians 30 34 56 26
15 Pardubice Pardubice 30 35 67 24
16 Karviná Karviná 30 30 52 17
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 34 85 20 86
2 Sparta Praha Sparta Praha 34 82 43 74
3 Jablonec Jablonec 34 59 33 69
4 Slovácko Slovácko 34 58 33 63
5 Viktoria Plzeň Viktoria 34 60 45 58
6 Slovan Liberec Slovan 34 44 32 52
7 Pardubice Pardubice 34 41 42 52
8 Baník Ostrava Baník 34 48 38 49
9 Sigma Olomouc Sigma 34 40 40 45
10 Bohemians 1905 Bohemians 34 40 37 43
11 Mladá Boleslav Mladá 34 49 54 39
12 Karviná Karviná 34 37 49 39
13 České Budějovice České 34 33 47 38
14 FC Trinity Zlín Trinity 34 30 50 32
15 Teplice Teplice 34 34 66 30
16 Zbrojovka Brno Zbrojovka 34 33 57 26
17 Pribram Pribram 34 26 65 25
18 SFC Opava SFC Opava 34 23 71 17
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 58 10 72
2 Viktoria Plzeň Viktoria 30 60 22 66
3 Sparta Praha Sparta Praha 30 55 35 50
4 Jablonec Jablonec 30 46 41 49
5 Slovan Liberec Slovan 30 50 38 47
6 Baník Ostrava Baník 30 42 34 45
7 České Budějovice České 30 46 45 43
8 Slovácko Slovácko 30 35 35 42
9 Bohemians 1905 Bohemians 30 38 41 42
10 Mladá Boleslav Mladá 30 48 52 40
11 Sigma Olomouc Sigma 30 36 37 36
12 Teplice Teplice 30 29 49 31
13 FC Trinity Zlín Trinity 30 25 47 27
14 Karviná Karviná 30 23 39 26
15 SFC Opava SFC Opava 30 16 47 23
16 Pribram Pribram 30 19 54 21
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 72 23 72
2 Viktoria Plzeň Viktoria 30 47 27 68
3 Sparta Praha Sparta Praha 30 52 27 57
4 Jablonec Jablonec 30 53 26 51
5 Baník Ostrava Baník 30 38 36 45
6 Mladá Boleslav Mladá 30 52 44 42
7 Slovan Liberec Slovan 30 33 28 42
8 Sigma Olomouc Sigma 30 37 43 40
9 FC Trinity Zlín Trinity 30 32 40 39
10 Teplice Teplice 30 32 42 36
11 Bohemians 1905 Bohemians 30 29 37 34
12 Slovácko Slovácko 30 32 45 34
13 SFC Opava SFC Opava 30 39 49 33
14 Pribram Pribram 30 33 63 31
15 Karviná Karviná 30 39 53 29
16 FK Dukla Praha Dukla Praha 30 25 62 20
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 55 23 66
2 Slavia Praha Slavia Praha 30 50 19 59
3 Jablonec Jablonec 30 49 27 56
4 Sigma Olomouc Sigma 30 41 22 55
5 Sparta Praha Sparta Praha 30 43 25 53
6 Slovan Liberec Slovan 30 37 35 46
7 Bohemians 1905 Bohemians 30 30 29 38
8 Mladá Boleslav Mladá 30 31 43 34
9 Teplice Teplice 30 32 40 34
10 FC Trinity Zlín Trinity 30 31 48 33
11 FK Dukla Praha Dukla Praha 30 32 55 32
12 Slovácko Slovácko 30 23 32 31
13 Baník Ostrava Baník 30 36 43 31
14 Karviná Karviná 30 32 40 30
15 Vysocina Jihlava Vysocina 30 30 48 30
16 Zbrojovka Brno Zbrojovka 30 20 43 24
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 65 22 69
2 Viktoria Plzeň Viktoria 30 47 21 67
3 Sparta Praha Sparta Praha 30 47 26 57
4 Mladá Boleslav Mladá 30 47 37 49
5 Teplice Teplice 30 38 25 48
6 FC Trinity Zlín Trinity 30 34 35 41
7 FK Dukla Praha Dukla Praha 30 39 35 40
8 Jablonec Jablonec 30 43 38 39
9 Slovan Liberec Slovan 30 31 28 39
10 Karviná Karviná 30 39 49 34
11 Slovácko Slovácko 30 29 38 32
12 Zbrojovka Brno Zbrojovka 30 32 45 32
13 Bohemians 1905 Bohemians 30 22 39 28
14 Vysocina Jihlava Vysocina 30 26 47 27
15 Hradec Králové Hradec 30 29 51 27
16 Pribram Pribram 30 29 61 22
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 57 25 71
2 Sparta Praha Sparta Praha 30 61 24 64
3 Slovan Liberec Slovan 30 51 35 58
4 Mladá Boleslav Mladá 30 63 37 57
5 Slavia Praha Slavia Praha 30 48 26 52
6 Zbrojovka Brno Zbrojovka 30 37 38 47
7 Jablonec Jablonec 30 46 39 41
8 Slovácko Slovácko 30 37 51 40
9 Bohemians 1905 Bohemians 30 35 37 37
10 FK Dukla Praha Dukla Praha 30 44 41 35
11 Vysocina Jihlava Vysocina 30 31 54 31
12 Teplice Teplice 30 37 52 30
13 FC Trinity Zlín Trinity 30 34 50 30
14 Sigma Olomouc Sigma 30 35 49 27
15 Pribram Pribram 30 33 53 27
16 Baník Ostrava Baník 30 27 65 14
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 70 24 72
2 Sparta Praha Sparta Praha 30 57 20 67
3 Jablonec Jablonec 30 58 22 64
4 Mladá Boleslav Mladá 30 43 34 46
5 Pribram Pribram 30 40 45 43
6 FK Dukla Praha Dukla Praha 30 34 40 41
7 Teplice Teplice 30 41 37 38
8 Bohemians 1905 Bohemians 30 35 41 38
9 Slovácko Slovácko 30 43 46 37
10 Vysocina Jihlava Vysocina 30 33 38 36
11 Slavia Praha Slavia Praha 30 40 45 34
12 Slovan Liberec Slovan 30 39 43 33
13 Zbrojovka Brno Zbrojovka 30 34 45 33
14 Baník Ostrava Baník 30 23 41 33
15 Hradec Králové Hradec 30 26 52 25
16 České Budějovice České 30 29 72 22
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 78 19 79
2 Viktoria Plzeň Viktoria 30 64 21 66
3 Mladá Boleslav Mladá 30 54 38 50
4 Slovan Liberec Slovan 30 37 46 48
5 Teplice Teplice 30 51 35 46
6 Slovácko Slovácko 30 43 40 40
7 FK Dukla Praha Dukla Praha 30 35 37 38
8 Vysocina Jihlava Vysocina 30 45 50 37
9 Zbrojovka Brno Zbrojovka 30 32 42 37
10 Baník Ostrava Baník 30 33 43 35
11 Jablonec Jablonec 30 43 53 34
12 Pribram Pribram 30 34 49 34
13 Slavia Praha Slavia Praha 30 24 51 30
14 Bohemians 1905 Bohemians 30 26 40 30
15 Sigma Olomouc Sigma 30 42 60 29
16 Znojmo Znojmo 30 32 49 27
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 54 21 65
2 Sparta Praha Sparta Praha 30 55 23 63
3 Slovan Liberec Slovan 30 46 34 54
4 Jablonec Jablonec 30 49 41 49
5 Sigma Olomouc Sigma 30 38 29 47
6 FK Dukla Praha Dukla Praha 30 48 37 46
7 Slavia Praha Slavia Praha 30 41 33 42
8 Mladá Boleslav Mladá 30 34 43 38
9 Slovácko Slovácko 30 37 41 37
10 Vysocina Jihlava Vysocina 30 36 42 36
11 Teplice Teplice 30 36 47 32
12 Pribram Pribram 30 27 39 32
13 Zbrojovka Brno Zbrojovka 30 34 53 32
14 Baník Ostrava Baník 30 34 44 29
15 České Budějovice České 30 24 49 26
16 Hradec Králové Hradec 30 27 44 25
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Slovan Liberec Slovan 30 68 29 66
2 Sparta Praha Sparta Praha 30 51 25 64
3 Viktoria Plzeň Viktoria 30 66 33 63
4 Mladá Boleslav Mladá 30 49 34 50
5 Teplice Teplice 30 36 30 46
6 FK Dukla Praha Dukla Praha 30 42 35 42
7 Slovácko Slovácko 30 29 32 41
8 Jablonec Jablonec 30 54 43 40
9 Pribram Pribram 30 44 56 39
10 České Budějovice České 30 30 51 35
11 Sigma Olomouc Sigma 30 42 38 34
12 Slavia Praha Slavia Praha 30 28 34 34
13 Hradec Králové Hradec 30 22 38 31
14 Baník Ostrava Baník 30 31 48 28
15 Bohemians 1905 Bohemians 30 20 54 24
16 Viktoria Žižkov Viktoria 30 23 55 19
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 70 28 69
2 Sparta Praha Sparta Praha 30 54 21 68
3 Jablonec Jablonec 30 65 34 58
4 Sigma Olomouc Sigma 30 47 29 47
5 Mladá Boleslav Mladá 30 49 40 46
6 Slovan Liberec Slovan 30 45 36 43
7 Bohemians 1905 Bohemians 30 33 33 43
8 Hradec Králové Hradec 30 26 36 41
9 Slavia Praha Slavia Praha 30 41 36 40
10 Teplice Teplice 30 39 46 39
11 České Budějovice České 30 30 48 33
12 Pribram Pribram 30 22 36 31
13 Slovácko Slovácko 30 27 43 31
14 Baník Ostrava Baník 30 31 46 30
15 Zbrojovka Brno Zbrojovka 30 33 55 24
16 FK Viagem Ústí nad Labem Viagem 30 22 67 19
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 42 14 62
2 Jablonec Jablonec 30 42 24 61
3 Baník Ostrava Baník 30 47 25 60
4 Teplice Teplice 30 44 25 55
5 Viktoria Plzeň Viktoria 30 42 33 48
6 Sigma Olomouc Sigma 30 49 36 47
7 Slavia Praha Slavia Praha 30 37 35 41
8 Mladá Boleslav Mladá 30 47 41 39
9 Slovan Liberec Slovan 30 34 39 37
10 Pribram Pribram 30 35 41 36
11 Zbrojovka Brno Zbrojovka 30 31 40 35
12 Bohemians 1905 Bohemians 30 21 29 34
13 České Budějovice České 30 24 35 31
14 Slovácko Slovácko 30 28 42 30
15 SK Kladno SK Kladno 30 24 50 25
16 FK Bohemians (Střížkov) Bohemians 30 27 65 0
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 57 25 62
2 Sparta Praha Sparta Praha 30 48 25 56
3 Slovan Liberec Slovan 30 41 28 52
4 Sigma Olomouc Sigma 30 39 36 48
5 Jablonec Jablonec 30 43 37 46
6 Mladá Boleslav Mladá 30 39 38 46
7 Teplice Teplice 30 33 25 43
8 Viktoria Plzeň Viktoria 30 45 38 43
9 Baník Ostrava Baník 30 38 36 39
10 České Budějovice České 30 30 37 36
11 Zbrojovka Brno Zbrojovka 30 32 36 35
12 Pribram Pribram 30 30 40 34
13 FK Bohemians (Střížkov) Bohemians 30 33 46 34
14 SK Kladno SK Kladno 30 21 41 31
15 FC Trinity Zlín Trinity 30 26 49 29
16 Viktoria Žižkov Viktoria 30 27 45 22
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 45 24 60
2 Sparta Praha Sparta Praha 30 53 26 57
3 Baník Ostrava Baník 30 51 28 55
4 Zbrojovka Brno Zbrojovka 30 43 32 55
5 Teplice Teplice 30 40 27 53
6 Slovan Liberec Slovan 30 35 31 44
7 Mladá Boleslav Mladá 30 37 36 42
8 FC Trinity Zlín Trinity 30 28 31 38
9 Viktoria Plzeň Viktoria 30 32 37 38
10 Viktoria Žižkov Viktoria 30 35 48 37
11 Sigma Olomouc Sigma 30 20 26 36
12 Jablonec Jablonec 30 24 32 33
13 České Budějovice České 30 27 35 32
14 SK Kladno SK Kladno 30 31 45 27
15 Bohemians 1905 Bohemians 30 24 40 26
16 Mostecký Mostecký 30 31 58 20
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 44 20 62
2 Slovan Liberec Slovan 30 44 22 58
3 Mladá Boleslav Mladá 30 48 27 58
4 Slavia Praha Slavia Praha 30 44 23 58
5 Baník Ostrava Baník 30 43 33 46
6 Viktoria Plzeň Viktoria 30 35 29 46
7 Zbrojovka Brno Zbrojovka 30 34 32 46
8 Teplice Teplice 30 44 39 42
9 Jablonec Jablonec 30 30 30 38
10 České Budějovice České 30 28 46 34
11 Mostecký Mostecký 30 29 40 31
12 SK Kladno SK Kladno 30 23 37 31
13 FC Trinity Zlín Trinity 30 21 34 27
14 Sigma Olomouc Sigma 30 29 43 26
15 Pribram Pribram 30 15 37 21
16 Slovácko Slovácko 30 20 39 19
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Slovan Liberec Slovan 30 43 22 59
2 Slavia Praha Slavia Praha 30 56 34 54
3 Mladá Boleslav Mladá 30 50 36 54
4 Teplice Teplice 30 38 24 52
5 Sparta Praha Sparta Praha 30 43 39 45
6 Baník Ostrava Baník 30 35 32 40
7 Slovácko Slovácko 30 29 28 38
8 Jablonec Jablonec 30 35 39 37
9 Sigma Olomouc Sigma 30 34 44 37
10 Mostecký Mostecký 30 34 41 36
11 Zbrojovka Brno Zbrojovka 30 35 36 35
12 FC Trinity Zlín Trinity 30 27 33 35
13 Pribram Pribram 30 36 36 34
14 Viktoria Plzeň Viktoria 30 30 43 31
15 Vysocina Jihlava Vysocina 30 20 36 29
16 Chmel Blšany Chmel 30 22 44 26
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 53 28 64
2 Slavia Praha Slavia Praha 30 39 25 53
3 Teplice Teplice 30 36 27 53
4 Sigma Olomouc Sigma 30 39 34 51
5 Slovan Liberec Slovan 30 45 26 46
6 Jablonec Jablonec 30 33 27 45
7 Baník Ostrava Baník 30 33 36 37
8 Drnovice Drnovice 30 30 34 35
9 Pribram Pribram 30 30 41 35
10 FC Trinity Zlín Trinity 30 29 35 33
11 Zbrojovka Brno Zbrojovka 30 30 42 33
12 Slovácko Slovácko 30 30 22 32
13 Chmel Blšany Chmel 30 25 38 32
14 Mladá Boleslav Mladá 30 26 35 31
15 České Budějovice České 30 28 39 25
16 SFC Opava SFC Opava 30 25 42 18
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Baník Ostrava Baník 30 60 25 63
2 Sparta Praha Sparta Praha 30 48 24 58
3 Sigma Olomouc Sigma 30 43 24 55
4 Slavia Praha Slavia Praha 30 43 24 52
5 Synot Synot 30 43 37 48
6 Slovan Liberec Slovan 30 38 27 46
7 FC Trinity Zlín Trinity 30 31 39 41
8 České Budějovice České 30 38 38 40
9 Teplice Teplice 30 32 32 39
10 Jablonec Jablonec 30 27 32 38
11 Pribram Pribram 30 33 37 37
12 SFC Opava SFC Opava 30 34 55 31
13 Zbrojovka Brno Zbrojovka 30 33 43 30
14 Chmel Blšany Chmel 30 34 54 30
15 Viktoria Žižkov Viktoria 30 18 34 27
16 Viktoria Plzeň Viktoria 30 23 53 19
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 51 17 65
2 Slavia Praha Slavia Praha 30 65 19 64
3 Slovan Liberec Slovan 30 43 36 50
4 Viktoria Žižkov Viktoria 30 38 33 50
5 Baník Ostrava Baník 30 41 38 45
6 Teplice Teplice 30 33 32 45
7 FC Trinity Zlín Trinity 30 34 41 42
8 Synot Synot 30 39 40 40
9 Zbrojovka Brno Zbrojovka 30 35 31 39
10 Pribram Pribram 30 34 30 39
11 Sigma Olomouc Sigma 30 29 33 34
12 Jablonec Jablonec 30 29 39 34
13 České Budějovice České 30 36 54 30
14 Chmel Blšany Chmel 30 28 39 28
15 Bohemians 1905 Bohemians 30 34 56 24
16 Hradec Králové Hradec 30 23 54 22
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Slovan Liberec Slovan 30 55 26 64
2 Sparta Praha Sparta Praha 30 55 19 63
3 Viktoria Žižkov Viktoria 30 42 20 63
4 Bohemians 1905 Bohemians 30 40 35 48
5 Slavia Praha Slavia Praha 30 45 34 47
6 Baník Ostrava Baník 30 43 36 44
7 Teplice Teplice 30 37 41 41
8 Jablonec Jablonec 30 35 33 40
9 Zbrojovka Brno Zbrojovka 30 34 42 40
10 Sigma Olomouc Sigma 30 29 31 37
11 Synot Synot 30 31 38 36
12 Hradec Králové Hradec 30 28 42 35
13 Pribram Pribram 30 27 39 34
14 Chmel Blšany Chmel 30 35 51 29
15 Drnovice Drnovice 30 31 45 26
16 SFC Opava SFC Opava 30 23 58 18

  USO DE MEMORIA  
7,895,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1741
Total Execution Time  0.1759
  CADENA URL  
/checa2023/grupo1/historico
  GET DATOS  
$_GET['/checa2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0017  SELECT type FROM routes WHERE alias = 'checa2023'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'checa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=30 ORDER BY order_id ASC
0.0020  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 = 68036 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 30 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022  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 `tables2023` 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 = 68036 AND t.round = 30 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 `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 = 63006 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 58011 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.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 `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 = 49964 AND t.round = 30 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 `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 = 38696 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 `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 = 33331 AND t.round = 30 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 `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 = 15408 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 `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 = 3883 AND t.round = 30 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 `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 = 2481 AND t.round = 30 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 `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 = 2041 AND t.round = 30 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 `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 = 1355 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 `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 = 1083 AND t.round = 30 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 `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 = 865 AND t.round = 30 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 `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 = 243 AND t.round = 30 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 = 8741 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 `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 = 8745 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 `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 = 8747 AND t.round = 30 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 `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 = 8749 AND t.round = 30 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 `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 = 8750 AND t.round = 30 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 `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 = 8751 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 `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 = 8752 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-04-18 16:33:20' 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-04-18 16:33:20' 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-04-18 16:33:20' 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-04-18 16:33:20' 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 = 'checa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0190  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 events2023 e ON e.player_id = p.id AND e.league_id = 68036 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68036 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.0285  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 events2023 e ON e.player_id = p.id AND e.league_id = 68036 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68036 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0035  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 events2023 e ON e.player_id = p.id AND e.league_id = 68036 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68036 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 68036 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC