4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1968/1969
Equipo PJ GF GC Puntos
1 FC Vorwärts Berlin Vorwärts 26 47 28 49
2 FC Carl Zeiss Jena Carl Zeiss. 26 43 22 45
3 Magdeburg Magdeburg 26 43 41 44
4 Hansa Rostock Hansa 26 42 33 39
5 Zwickau Zwickau 26 23 19 37
6 Chemnitzer Chemnitzer 26 35 36 36
7 Rot-Weiss Erfurt Rot-Weiss 26 32 27 35
8 Chemie Leipzig Chemie 26 30 27 35
9 BFC Dynamo BFC Dynamo 26 25 36 35
10 BSG Wismut Aue Wismut 26 33 31 34
11 BSG Stahl Riesa Stahl Riesa 26 26 43 31
12 Hallescher FC Hallescher 26 32 35 28
13 Union Berlin Union Berlin 26 29 41 26
14 Lokomotive Leipzig Lokomotive 26 16 37 24
Ver
TEMPORADA 1967/1968
Equipo PJ GF GC Puntos
1 FC Carl Zeiss Jena Carl Zeiss. 26 51 19 56
2 Hansa Rostock Hansa 26 37 27 49
3 Magdeburg Magdeburg 26 43 38 46
4 FC Vorwärts Berlin Vorwärts 26 34 29 37
5 Zwickau Zwickau 26 36 34 36
6 Lokomotive Leipzig Lokomotive 26 39 35 34
7 Union Berlin Union Berlin 26 26 35 34
8 Chemnitzer Chemnitzer 26 33 30 33
9 Rot-Weiss Erfurt Rot-Weiss 26 34 39 31
10 BSG Wismut Aue Wismut 26 32 40 31
11 Hallescher FC Hallescher 26 32 41 31
12 Chemie Leipzig Chemie 26 26 32 28
13 Lok Stendal Lok Stendal 26 26 42 27
14 Dynamo Dresden Dynamo 26 25 33 26
Ver
TEMPORADA 1966/1967
Equipo PJ GF GC Puntos
1 Chemnitzer Chemnitzer 26 39 23 51
2 Lokomotive Leipzig Lokomotive 26 39 32 44
3 Dynamo Dresden Dynamo 26 35 31 38
4 FC Carl Zeiss Jena Carl Zeiss. 26 31 29 38
5 Lok Stendal Lok Stendal 26 39 44 38
6 BSG Wismut Aue Wismut 26 45 43 37
7 Hallescher FC Hallescher 26 38 41 37
8 Zwickau Zwickau 26 41 26 36
9 FC Vorwärts Berlin Vorwärts 26 43 34 36
10 Union Berlin Union Berlin 26 33 35 36
11 Hansa Rostock Hansa 26 27 27 35
12 Chemie Leipzig Chemie 26 35 38 34
13 BFC Dynamo BFC Dynamo 26 28 40 27
14 Wismut Gera Wismut Gera 26 27 57 16
Ver
TEMPORADA 1964/1965
Equipo PJ GF GC Puntos
1 FC Vorwärts Berlin Vorwärts 26 51 24 54
2 FC Carl Zeiss Jena Carl Zeiss. 26 41 27 46
3 Sachsen Leipzig Sachsen 26 53 34 42
4 Chemie Leipzig Chemie 26 47 29 42
5 Hansa Rostock Hansa 26 37 33 41
6 Lok Stendal Lok Stendal 26 47 42 35
7 Zwickau Zwickau 26 36 46 33
8 Dynamo Dresden Dynamo 26 34 38 32
9 Chemnitzer Chemnitzer 26 36 41 31
10 BFC Dynamo BFC Dynamo 26 27 37 30
11 BSG Wismut Aue Wismut 26 23 36 30
12 SV Steinach 1908 Steinach 26 28 49 27
13 Neubrandenburg 04 Neubrandenbu 26 34 58 27
14 Magdeburg Magdeburg 13 23 21 17
15 Magdeburg II Magdeburg 13 12 14 17
Ver
TEMPORADA 1963/1964
Equipo PJ GF GC Puntos
1 Chemie Leipzig Chemie 26 38 21 48
2 Hansa Rostock Hansa 26 40 23 46
3 Sachsen Leipzig Sachsen 26 34 27 44
4 Chemnitzer Chemnitzer 26 31 29 39
5 FC Vorwärts Berlin Vorwärts 26 45 36 36
6 FC Carl Zeiss Jena Carl Zeiss. 26 43 35 36
7 SV Steinach 1908 Steinach 26 30 36 33
8 Lok Stendal Lok Stendal 26 31 34 32
9 BFC Dynamo BFC Dynamo 26 35 34 31
10 Zwickau Zwickau 26 37 41 30
11 BSG Wismut Aue Wismut 26 23 32 30
12 Hallescher FC Hallescher 26 24 35 30
13 Magdeburg Magdeburg 26 25 38 30
14 Rot-Weiss Erfurt Rot-Weiss 26 23 38 25
Ver
TEMPORADA 1962/1963
Equipo PJ GF GC Puntos
1 FC Carl Zeiss Jena Carl Zeiss. 26 49 22 54
2 Hansa Rostock Hansa 26 42 24 46
3 FC Vorwärts Berlin Vorwärts 26 41 34 42
4 Lokomotive Leipzig Lokomotive 26 38 35 39
5 BSG Wismut Aue Wismut 26 43 42 38
6 Magdeburg Magdeburg 26 45 47 35
7 Zwickau Zwickau 26 38 41 35
8 Rot-Weiss Erfurt Rot-Weiss 26 45 45 34
9 Hallescher FC Hallescher 26 39 41 32
10 Sachsen Leipzig Sachsen 26 29 35 32
11 BFC Dynamo BFC Dynamo 26 37 32 31
12 Dynamo Dresden Dynamo 26 36 45 30
13 Chemnitzer Chemnitzer 26 39 44 29
14 Brieske-Senftenberg Brieske-Senf 26 22 56 23
Ver
TEMPORADA 1961/1962
Equipo PJ GF GC Puntos
Ver
TEMPORADA 1960/1961
Equipo PJ GF GC Puntos
1 FC Vorwärts Berlin Vorwärts 26 73 28 60
2 BFC Dynamo BFC Dynamo 26 44 27 44
3 BSG Wismut Aue Wismut 26 40 32 44
4 Lokomotive Leipzig Lokomotive 26 37 31 44
5 Zwickau Zwickau 26 37 33 44
6 Hansa Rostock Hansa 26 46 36 40
7 Magdeburg Magdeburg 26 47 59 39
8 FC Carl Zeiss Jena Carl Zeiss. 26 55 43 33
9 Sachsen Leipzig Sachsen 26 39 39 32
10 Brieske-Senftenberg Brieske-Senf 26 35 39 32
11 Hallescher FC Hallescher 26 37 42 30
12 SC Einheit Dresden Einheit 26 30 51 28
13 BSG Chemie Zeitz Chemie Zeitz 26 43 61 27
14 BSG Fortschritt Weißenfels Fortschritt 26 27 69 8
Ver
TEMPORADA 1959/1960
Equipo PJ GF GC Puntos
1 BSG Wismut Aue Wismut 26 44 25 56
2 FC Vorwärts Berlin Vorwärts 26 49 24 48
3 BFC Dynamo BFC Dynamo 26 46 26 47
4 Hansa Rostock Hansa 26 36 26 39
5 FC Carl Zeiss Jena Carl Zeiss. 26 29 27 39
6 BSG Fortschritt Weißenfels Fortschritt 26 36 39 37
7 Zwickau Zwickau 26 30 32 33
8 BSG Chemie Zeitz Chemie Zeitz 26 42 52 33
9 Brieske-Senftenberg Brieske-Senf 26 36 30 32
10 Lokomotive Leipzig Lokomotive 26 28 36 32
11 Sachsen Leipzig Sachsen 26 31 40 28
12 Rot-Weiss Erfurt Rot-Weiss 26 27 45 24
13 SC Einheit Dresden Einheit 26 23 42 23
14 Lok Stendal Lok Stendal 26 19 32 21
Ver
TEMPORADA 1958/1959
Equipo PJ GF GC Puntos
1 FC Vorwärts Berlin Vorwärts 26 50 24 55
2 FC Carl Zeiss Jena Carl Zeiss. 26 49 36 47
3 Brieske-Senftenberg Brieske-Senf 26 41 25 42
4 SC Einheit Dresden Einheit 26 38 39 39
5 BSG Wismut Aue Wismut 26 43 32 38
6 BFC Dynamo BFC Dynamo 26 37 34 36
7 Hansa Rostock Hansa 26 33 31 36
8 Lokomotive Leipzig Lokomotive 26 38 41 35
9 Zwickau Zwickau 26 38 41 34
10 Sachsen Leipzig Sachsen 26 40 28 33
11 Rot-Weiss Erfurt Rot-Weiss 26 33 44 30
12 BSG Fortschritt Weißenfels Fortschritt 26 30 42 30
13 Hallescher FC Hallescher 14 17 32 20
14 SV Babelsberg 03 Babelsberg 26 32 65 19
15 Hallescher FC II Hallescher 12 13 18 9
Ver
TEMPORADA 1957/1958
Equipo PJ GF GC Puntos
1 BSG Wismut Aue Wismut 26 49 28 52
2 FC Vorwärts Berlin Vorwärts 26 45 22 46
3 Sachsen Leipzig Sachsen 26 40 29 44
4 FC Carl Zeiss Jena Carl Zeiss. 26 41 29 39
5 Brieske-Senftenberg Brieske-Senf 26 33 26 39
6 Rot-Weiss Erfurt Rot-Weiss 26 37 33 37
7 Lokomotive Leipzig Lokomotive 26 36 32 35
8 SC Einheit Dresden Einheit 26 40 44 33
9 Zwickau Zwickau 26 35 43 32
10 BSG Fortschritt Weißenfels Fortschritt 26 38 38 31
11 Hallescher FC Hallescher 26 42 51 31
12 SV Babelsberg 03 Babelsberg 26 29 44 31
13 Lok Stendal Lok Stendal 26 28 43 31
14 Chemnitzer Chemnitzer 26 31 62 19
Ver
TEMPORADA 1956/1957
Equipo PJ GF GC Puntos
1 BSG Wismut Aue Wismut 26 53 21 53
2 Brieske-Senftenberg Brieske-Senf 26 34 15 50
3 Lokomotive Leipzig Lokomotive 26 45 22 48
4 Lok Stendal Lok Stendal 26 55 54 40
5 SC Einheit Dresden Einheit 26 50 46 36
6 FC Vorwärts Berlin Vorwärts 26 41 41 35
7 SV Babelsberg 03 Babelsberg 26 41 53 35
8 Sachsen Leipzig Sachsen 26 35 41 33
9 Zwickau Zwickau 26 47 52 32
10 BFC Dynamo BFC Dynamo 26 39 48 30
11 BSG Fortschritt Weißenfels Fortschritt 26 36 38 29
12 Chemnitzer Chemnitzer 26 25 50 28
13 Rot-Weiss Erfurt Rot-Weiss 26 36 38 26
14 Hansa Rostock Hansa 26 31 49 24
Ver
TEMPORADA 1955/1956
Equipo PJ GF GC Puntos
Ver
TEMPORADA 1954/1955
Equipo PJ GF GC Puntos
1 Rot-Weiss Erfurt Rot-Weiss 26 58 25 47
2 BSG Wismut Aue Wismut 26 62 38 46
3 Zwickau Zwickau 26 51 49 41
4 Sachsen Leipzig Sachsen 26 56 46 40
5 BFC Dynamo BFC Dynamo 26 50 50 38
6 Brieske-Senftenberg Brieske-Senf 26 37 44 38
7 FC Vorwärts Berlin Vorwärts 26 43 46 36
8 SV Babelsberg 03 Babelsberg 26 36 36 33
9 Lokomotive Leipzig Lokomotive 26 33 38 33
10 Chemnitzer Chemnitzer 26 34 43 33
11 SC Einheit Dresden Einheit 15 41 33 25
12 Hallescher FC Hallescher 25 25 50 25
13 Hansa Rostock II Hansa 17 18 21 23
14 BSG Fortschritt Meerane Fortschritt 26 31 58 18
15 SC Einheit Dresden II Einheit 11 23 22 17
16 Hansa Rostock Hansa 9 11 12 15
17 Hallescher FC II Hallescher 1 2 0 3
Ver
TEMPORADA 1953/1954
Equipo PJ GF GC Puntos
1 Rot-Weiss Erfurt Rot-Weiss 24 52 31 49
2 Sachsen Leipzig Sachsen 24 50 32 47
3 BSG Wismut Aue Wismut 25 52 38 42
4 Dynamo Dresden Dynamo 24 43 37 40
5 SV Babelsberg 03 Babelsberg 25 48 38 38
6 Hallescher FC Hallescher 24 25 25 34
7 BSG Empor Lauter Empor Lauter 25 38 31 33
8 Brieske-Senftenberg Brieske-Senf 24 41 39 33
9 Zwickau Zwickau 24 33 48 32
10 SC Einheit Dresden Einheit 23 36 32 29
11 BSG Fortschritt Meerane Fortschritt 24 40 41 28
12 Lokomotive Leipzig Lokomotive 24 37 51 27
13 Dessau 05 Dessau 05 24 33 45 26
14 Lok Stendal Lok Stendal 24 31 41 25
15 BSG Stahl Thale Stahl Thale 24 26 56 15
Ver
TEMPORADA 1952/1953
Equipo PJ GF GC Puntos
1 BSG Wismut Aue Wismut 32 57 48 54
2 Dynamo Dresden Dynamo 32 51 33 53
3 Zwickau Zwickau 32 54 43 53
4 SC Einheit Dresden Einheit 32 65 55 51
5 Dessau 05 Dessau 05 32 66 55 50
6 BSG Stahl Thale Stahl Thale 32 45 47 50
7 Rot-Weiss Erfurt Rot-Weiss 32 51 44 48
8 Chemie Leipzig Chemie 32 55 51 48
9 Brieske-Senftenberg Brieske-Senf 32 55 52 47
10 BSG Empor Lauter Empor Lauter 32 58 61 46
11 Lok Stendal Lok Stendal 32 56 54 45
12 SV Babelsberg 03 Babelsberg 32 58 59 45
13 Hallescher FC Hallescher 32 51 44 43
14 SV Vorwärts Leipzig Vorwärts 32 49 56 42
15 Union Berlin Union Berlin 32 47 50 39
16 FC Carl Zeiss Jena Carl Zeiss. 32 35 62 31
17 Wismut Gera Wismut Gera 32 32 71 20
Ver
TEMPORADA 1951/1952
Equipo PJ GF GC Puntos
Ver
TEMPORADA 1950/1951
Equipo PJ GF GC Puntos
1 Rot-Weiss Erfurt Rot-Weiss 34 80 37 72
2 Chemie Leipzig Chemie 34 66 33 72
3 Brieske-Senftenberg Brieske-Senf 34 87 79 63
4 Zwickau Zwickau 34 72 35 60
5 Dynamo Dresden Dynamo 34 75 40 60
6 SV Babelsberg 03 Babelsberg 34 95 78 57
7 Hallescher FC Hallescher 34 74 50 56
8 Dessau 05 Dessau 05 34 71 63 51
9 BSG Fortschritt Meerane Fortschritt 34 65 71 44
10 SC Einheit Dresden Einheit 34 64 61 42
11 Lok Stendal Lok Stendal 34 73 73 41
12 SV Motor Altenburg Motor 34 47 64 40
13 SC 1903 Weimar 1903 Weimar 34 45 71 36
14 BSG Stahl Thale II Stahl Thale 19 52 44 33
15 Wismut Gera Wismut Gera 27 47 54 29
16 Lichtenberg Lichtenberg 34 49 96 26
17 BSG Stahl Thale Stahl Thale 15 30 21 23
18 Union Berlin Union Berlin 17 32 27 23
19 Union Berlin II Union Berlin 17 17 45 12
20 BSG Einheit Pankow Einheit 34 29 131 9
Ver
TEMPORADA 1949/1950
Equipo PJ GF GC Puntos
1 Zwickau Zwickau 26 69 27 61
2 Dresdner SC Dresdner SC 26 87 29 57
3 Dessau 05 Dessau 05 26 67 36 54
4 Rot-Weiss Erfurt Rot-Weiss 26 61 34 47
5 Hallescher FC Hallescher 26 56 38 44
6 Brieske-Senftenberg Brieske-Senf 26 49 48 44
7 SV Babelsberg 03 Babelsberg 26 42 66 34
8 BSG Fortschritt Meerane Fortschritt 26 38 56 30
9 Wismut Gera Wismut Gera 26 34 54 25
10 SV Motor Altenburg Motor 26 34 50 23
11 Anker Wismar Anker Wismar 26 35 60 23
12 Sachsen Leipzig Sachsen 13 20 18 20
13 Lok Stendal Lok Stendal 13 18 19 16
14 Mecklenburg Schwerin Mecklenburg 26 30 84 15
15 Lok Stendal II Stendal 13 17 29 13
16 Chemie Leipzig Chemie 13 18 27 10

  USO DE MEMORIA  
6,882,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1298
Total Execution Time  0.1317
  CADENA URL  
/ddr_oberliga1969/grupo1/historico
  GET DATOS  
$_GET['/ddr_oberliga1969/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'ddr_oberliga1969'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ddr_oberliga' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1969 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=2082 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2082 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 = 45355 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2082 AND group_code = 1 and tables = 1 AND year <= 1969 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables1969` 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 = 45355 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 `tables1968` 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 = 45356 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 `tables1967` 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 = 45357 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 `tables1965` 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 = 45359 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 `tables1964` 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 = 45360 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 `tables1963` 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 = 45361 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 `tables1962` 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 = 45362 AND t.round = 39 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 `tables1961` 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 = 45381 AND t.round = 26 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 `tables1960` 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 = 45364 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1959` 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 = 45368 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 `tables1958` 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 = 45369 AND t.round = 26 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 `tables1957` 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 = 45370 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 `tables1956` 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 = 45371 AND t.round = 13 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 `tables1955` 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 = 45382 AND t.round = 26 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 `tables1954` 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 = 45383 AND t.round = 26 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 `tables1953` 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 = 45384 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables1952` 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 = 45385 AND t.round = 38 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 `tables1951` 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 = 45386 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1950` 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 = 45387 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 00:36:57' 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=2 AND last_update > '2024-05-04 00:36:57' 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-05-04 00:36:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 00:36:57' 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 = 'ddr_oberliga' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1969 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0089  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 events1969 e ON e.player_id = p.id AND e.league_id = 45355 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 45355 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.0041  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 events1969 e ON e.player_id = p.id AND e.league_id = 45355 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 45355 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  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 events1969 e ON e.player_id = p.id AND e.league_id = 45355 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 45355 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1969` 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 = 45355 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC