4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
17 Ago 68 FC Carl Zeiss JenaCarl Zeiss 0 - 1 ZwickauZwickau ...
17 Ago 68 FC Vorwärts BerlinVorwärts 3 - 0 Lokomotive LeipzigLokomotive ...
17 Ago 68 MagdeburgMagdeburg 3 - 1 ChemnitzerChemnitzer ...
17 Ago 68 BSG Wismut AueWismut 1 - 0 Rot-Weiss ErfurtRot-Weiss ...
17 Ago 68 Chemie LeipzigChemie 2 - 0 BFC DynamoBFC Dynamo ...
17 Ago 68 Hallescher FCHallescher 3 - 0 BSG Stahl RiesaStahl Riesa ...
17 Ago 68 Union BerlinUnion 3 - 4 Hansa RostockHansa ...
Jornada 2
24 Ago 68 ZwickauZwickau 0 - 1 Union BerlinUnion ...
24 Ago 68 BFC DynamoBFC Dynamo 1 - 0 Lokomotive LeipzigLokomotive ...
24 Ago 68 BSG Stahl RiesaStahl Riesa 1 - 2 FC Carl Zeiss JenaCarl Zeiss ...
24 Ago 68 Rot-Weiss ErfurtRot-Weiss 5 - 2 Hallescher FCHallescher ...
24 Ago 68 ChemnitzerChemnitzer 2 - 3 BSG Wismut AueWismut ...
24 Ago 68 Chemie LeipzigChemie 2 - 1 MagdeburgMagdeburg ...
24 Ago 68 Hansa RostockHansa 3 - 1 FC Vorwärts BerlinVorwärts ...
Jornada 3
31 Ago 68 Lokomotive LeipzigLokomotive 1 - 1 Hansa RostockHansa ...
31 Ago 68 FC Carl Zeiss JenaCarl Zeiss 1 - 0 Rot-Weiss ErfurtRot-Weiss ...
31 Ago 68 MagdeburgMagdeburg 4 - 1 BFC DynamoBFC Dynamo ...
31 Ago 68 FC Vorwärts BerlinVorwärts 1 - 0 ZwickauZwickau ...
31 Ago 68 Hallescher FCHallescher 2 - 0 ChemnitzerChemnitzer ...
31 Ago 68 BSG Wismut AueWismut 1 - 0 Chemie LeipzigChemie ...
31 Ago 68 Union BerlinUnion 2 - 0 BSG Stahl RiesaStahl Riesa ...
Jornada 4
07 Sep 68 ChemnitzerChemnitzer 1 - 0 FC Carl Zeiss JenaCarl Zeiss ...
07 Sep 68 MagdeburgMagdeburg 3 - 2 BSG Wismut AueWismut ...
07 Sep 68 BSG Stahl RiesaStahl Riesa 1 - 0 FC Vorwärts BerlinVorwärts ...
07 Sep 68 Chemie LeipzigChemie 3 - 1 Hallescher FCHallescher ...
07 Sep 68 Rot-Weiss ErfurtRot-Weiss 0 - 0 Union BerlinUnion ...
07 Sep 68 ZwickauZwickau 3 - 0 Lokomotive LeipzigLokomotive ...
07 Sep 68 BFC DynamoBFC Dynamo 1 - 3 Hansa RostockHansa ...
Jornada 5
14 Sep 68 FC Vorwärts BerlinVorwärts 5 - 0 Rot-Weiss ErfurtRot-Weiss ...
14 Sep 68 FC Carl Zeiss JenaCarl Zeiss 2 - 2 Chemie LeipzigChemie ...
14 Sep 68 Hansa RostockHansa 0 - 1 ZwickauZwickau ...
14 Sep 68 Hallescher FCHallescher 4 - 1 MagdeburgMagdeburg ...
14 Sep 68 Union BerlinUnion 1 - 2 ChemnitzerChemnitzer ...
14 Sep 68 BSG Wismut AueWismut 0 - 0 BFC DynamoBFC Dynamo ...
14 Sep 68 Lokomotive LeipzigLokomotive 1 - 1 BSG Stahl RiesaStahl Riesa ...
Jornada 6
21 Sep 68 MagdeburgMagdeburg 0 - 0 FC Carl Zeiss JenaCarl Zeiss ...
21 Sep 68 BSG Wismut AueWismut 4 - 1 Hallescher FCHallescher ...
21 Sep 68 ChemnitzerChemnitzer 2 - 2 FC Vorwärts BerlinVorwärts ...
21 Sep 68 Rot-Weiss ErfurtRot-Weiss 3 - 0 Lokomotive LeipzigLokomotive ...
21 Sep 68 BFC DynamoBFC Dynamo 1 - 1 ZwickauZwickau ...
21 Sep 68 BSG Stahl RiesaStahl Riesa 0 - 2 Hansa RostockHansa ...
21 Sep 68 Chemie LeipzigChemie 1 - 2 Union BerlinUnion ...
Jornada 7
28 Sep 68 FC Carl Zeiss JenaCarl Zeiss 1 - 0 BSG Wismut AueWismut ...
28 Sep 68 Lokomotive LeipzigLokomotive 1 - 2 ChemnitzerChemnitzer ...
28 Sep 68 Hallescher FCHallescher 2 - 0 BFC DynamoBFC Dynamo ...
28 Sep 68 FC Vorwärts BerlinVorwärts 3 - 1 Chemie LeipzigChemie ...
28 Sep 68 ZwickauZwickau 4 - 2 BSG Stahl RiesaStahl Riesa ...
28 Sep 68 Union BerlinUnion 3 - 3 MagdeburgMagdeburg ...
28 Sep 68 Hansa RostockHansa 1 - 1 Rot-Weiss ErfurtRot-Weiss ...
Jornada 8
05 Oct 68 BFC DynamoBFC Dynamo 3 - 1 BSG Stahl RiesaStahl Riesa ...
05 Oct 68 ChemnitzerChemnitzer 3 - 4 Hansa RostockHansa ...
05 Oct 68 Rot-Weiss ErfurtRot-Weiss 1 - 0 ZwickauZwickau ...
05 Oct 68 Hallescher FCHallescher 1 - 1 FC Carl Zeiss JenaCarl Zeiss ...
05 Oct 68 BSG Wismut AueWismut 2 - 0 Union BerlinUnion ...
05 Oct 68 MagdeburgMagdeburg 4 - 3 FC Vorwärts BerlinVorwärts ...
05 Oct 68 Chemie LeipzigChemie 1 - 0 Lokomotive LeipzigLokomotive ...
Jornada 9
12 Oct 68 FC Carl Zeiss JenaCarl Zeiss 4 - 0 BFC DynamoBFC Dynamo ...
12 Oct 68 BSG Stahl RiesaStahl Riesa 1 - 0 Rot-Weiss ErfurtRot-Weiss ...
12 Oct 68 Union BerlinUnion 0 - 1 Hallescher FCHallescher ...
12 Oct 68 ZwickauZwickau 0 - 1 ChemnitzerChemnitzer ...
12 Oct 68 Hansa RostockHansa 2 - 2 Chemie LeipzigChemie ...
12 Oct 68 Lokomotive LeipzigLokomotive 1 - 3 MagdeburgMagdeburg ...
12 Oct 68 FC Vorwärts BerlinVorwärts 2 - 1 BSG Wismut AueWismut ...
Jornada 10
23 Oct 68 BFC DynamoBFC Dynamo 1 - 0 Rot-Weiss ErfurtRot-Weiss ...
23 Oct 68 Chemie LeipzigChemie 2 - 1 ZwickauZwickau ...
23 Oct 68 ChemnitzerChemnitzer 3 - 1 BSG Stahl RiesaStahl Riesa ...
23 Oct 68 Hallescher FCHallescher 1 - 2 FC Vorwärts BerlinVorwärts ...
23 Oct 68 MagdeburgMagdeburg 1 - 1 Hansa RostockHansa ...
23 Oct 68 BSG Wismut AueWismut 0 - 0 Lokomotive LeipzigLokomotive ...
23 Oct 68 FC Carl Zeiss JenaCarl Zeiss 6 - 0 Union BerlinUnion ...
Jornada 11
26 Oct 68 Lokomotive LeipzigLokomotive 1 - 0 Hallescher FCHallescher ...
26 Oct 68 Union BerlinUnion 1 - 1 BFC DynamoBFC Dynamo ...
26 Oct 68 BSG Stahl RiesaStahl Riesa 1 - 0 Chemie LeipzigChemie ...
26 Oct 68 ZwickauZwickau 0 - 0 MagdeburgMagdeburg ...
26 Oct 68 Hansa RostockHansa 3 - 1 BSG Wismut AueWismut ...
26 Oct 68 Rot-Weiss ErfurtRot-Weiss 1 - 0 ChemnitzerChemnitzer ...
26 Oct 68 FC Vorwärts BerlinVorwärts 1 - 0 FC Carl Zeiss JenaCarl Zeiss ...
Jornada 12
02 Nov 68 Chemie LeipzigChemie 2 - 0 Rot-Weiss ErfurtRot-Weiss ...
02 Nov 68 BFC DynamoBFC Dynamo 1 - 0 ChemnitzerChemnitzer ...
02 Nov 68 Union BerlinUnion 0 - 2 FC Vorwärts BerlinVorwärts ...
02 Nov 68 FC Carl Zeiss JenaCarl Zeiss 3 - 0 Lokomotive LeipzigLokomotive ...
02 Nov 68 Hallescher FCHallescher 1 - 1 Hansa RostockHansa ...
02 Nov 68 MagdeburgMagdeburg 3 - 1 BSG Stahl RiesaStahl Riesa ...
02 Nov 68 BSG Wismut AueWismut 0 - 0 ZwickauZwickau ...
Jornada 13
09 Nov 68 FC Vorwärts BerlinVorwärts 2 - 1 BFC DynamoBFC Dynamo ...
09 Nov 68 ChemnitzerChemnitzer 1 - 0 Chemie LeipzigChemie ...
09 Nov 68 Rot-Weiss ErfurtRot-Weiss 6 - 1 MagdeburgMagdeburg ...
09 Nov 68 BSG Stahl RiesaStahl Riesa 1 - 1 BSG Wismut AueWismut ...
09 Nov 68 ZwickauZwickau 0 - 0 Hallescher FCHallescher ...
09 Nov 68 Hansa RostockHansa 4 - 1 FC Carl Zeiss JenaCarl Zeiss ...
09 Nov 68 Lokomotive LeipzigLokomotive 2 - 0 Union BerlinUnion ...
Jornada 14
15 Feb 69 ZwickauZwickau 0 - 0 FC Carl Zeiss JenaCarl Zeiss ...
15 Feb 69 Lokomotive LeipzigLokomotive 2 - 0 FC Vorwärts BerlinVorwärts ...
15 Feb 69 ChemnitzerChemnitzer 3 - 0 MagdeburgMagdeburg ...
15 Feb 69 Rot-Weiss ErfurtRot-Weiss 0 - 2 BSG Wismut AueWismut ...
15 Feb 69 BFC DynamoBFC Dynamo 2 - 1 Chemie LeipzigChemie ...
15 Feb 69 BSG Stahl RiesaStahl Riesa 1 - 1 Hallescher FCHallescher ...
15 Feb 69 Hansa RostockHansa 1 - 1 Union BerlinUnion ...
Jornada 15
22 Feb 69 Union BerlinUnion 2 - 3 ZwickauZwickau ...
22 Feb 69 Lokomotive LeipzigLokomotive 1 - 2 BFC DynamoBFC Dynamo ...
22 Feb 69 FC Carl Zeiss JenaCarl Zeiss 3 - 0 BSG Stahl RiesaStahl Riesa ...
22 Feb 69 Hallescher FCHallescher 2 - 0 Rot-Weiss ErfurtRot-Weiss ...
22 Feb 69 BSG Wismut AueWismut 1 - 2 ChemnitzerChemnitzer ...
22 Feb 69 MagdeburgMagdeburg 3 - 1 Chemie LeipzigChemie ...
22 Feb 69 FC Vorwärts BerlinVorwärts 3 - 1 Hansa RostockHansa ...
Jornada 16
01 Mar 69 Hansa RostockHansa 5 - 0 Lokomotive LeipzigLokomotive ...
01 Mar 69 Rot-Weiss ErfurtRot-Weiss 2 - 1 FC Carl Zeiss JenaCarl Zeiss ...
01 Mar 69 BFC DynamoBFC Dynamo 0 - 1 MagdeburgMagdeburg ...
01 Mar 69 ZwickauZwickau 1 - 0 FC Vorwärts BerlinVorwärts ...
01 Mar 69 ChemnitzerChemnitzer 0 - 0 Hallescher FCHallescher ...
01 Mar 69 Chemie LeipzigChemie 3 - 1 BSG Wismut AueWismut ...
01 Mar 69 BSG Stahl RiesaStahl Riesa 1 - 0 Union BerlinUnion ...
Jornada 17
12 Mar 69 FC Carl Zeiss JenaCarl Zeiss 2 - 0 ChemnitzerChemnitzer ...
12 Mar 69 BSG Wismut AueWismut 3 - 1 MagdeburgMagdeburg ...
12 Mar 69 FC Vorwärts BerlinVorwärts 6 - 1 BSG Stahl RiesaStahl Riesa ...
12 Mar 69 Hallescher FCHallescher 2 - 2 Chemie LeipzigChemie ...
12 Mar 69 Union BerlinUnion 2 - 0 Rot-Weiss ErfurtRot-Weiss ...
12 Mar 69 Lokomotive LeipzigLokomotive 1 - 0 ZwickauZwickau ...
12 Mar 69 Hansa RostockHansa 1 - 0 BFC DynamoBFC Dynamo ...
Jornada 18
15 Mar 69 Rot-Weiss ErfurtRot-Weiss 4 - 0 FC Vorwärts BerlinVorwärts ...
15 Mar 69 Chemie LeipzigChemie 0 - 0 FC Carl Zeiss JenaCarl Zeiss ...
15 Mar 69 ZwickauZwickau 1 - 0 Hansa RostockHansa ...
15 Mar 69 MagdeburgMagdeburg 2 - 1 Hallescher FCHallescher ...
15 Mar 69 ChemnitzerChemnitzer 2 - 2 Union BerlinUnion ...
15 Mar 69 BFC DynamoBFC Dynamo 0 - 0 BSG Wismut AueWismut ...
15 Mar 69 BSG Stahl RiesaStahl Riesa 1 - 1 Lokomotive LeipzigLokomotive ...
Jornada 19
19 Mar 69 FC Carl Zeiss JenaCarl Zeiss 3 - 1 MagdeburgMagdeburg ...
19 Mar 69 Hallescher FCHallescher 2 - 2 BSG Wismut AueWismut ...
19 Mar 69 FC Vorwärts BerlinVorwärts 5 - 1 ChemnitzerChemnitzer ...
19 Mar 69 Lokomotive LeipzigLokomotive 1 - 0 Rot-Weiss ErfurtRot-Weiss ...
19 Mar 69 ZwickauZwickau 1 - 2 BFC DynamoBFC Dynamo ...
19 Mar 69 Hansa RostockHansa 1 - 0 BSG Stahl RiesaStahl Riesa ...
19 Mar 69 Union BerlinUnion 1 - 1 Chemie LeipzigChemie ...
Jornada 20
02 Abr 69 ChemnitzerChemnitzer 3 - 0 Lokomotive LeipzigLokomotive ...
02 Abr 69 BFC DynamoBFC Dynamo 1 - 0 Hallescher FCHallescher ...
02 Abr 69 BSG Wismut AueWismut 3 - 2 FC Carl Zeiss JenaCarl Zeiss ...
02 Abr 69 BSG Stahl RiesaStahl Riesa 2 - 1 ZwickauZwickau ...
02 Abr 69 MagdeburgMagdeburg 2 - 1 Union BerlinUnion ...
02 Abr 69 Chemie LeipzigChemie 0 - 0 FC Vorwärts BerlinVorwärts ...
02 Abr 69 Rot-Weiss ErfurtRot-Weiss 0 - 0 Hansa RostockHansa ...
Jornada 21
05 Abr 69 BSG Stahl RiesaStahl Riesa 4 - 0 BFC DynamoBFC Dynamo ...
05 Abr 69 Hansa RostockHansa 1 - 2 ChemnitzerChemnitzer ...
05 Abr 69 ZwickauZwickau 1 - 0 Rot-Weiss ErfurtRot-Weiss ...
05 Abr 69 FC Carl Zeiss JenaCarl Zeiss 3 - 2 Hallescher FCHallescher ...
05 Abr 69 Union BerlinUnion 2 - 1 BSG Wismut AueWismut ...
05 Abr 69 FC Vorwärts BerlinVorwärts 0 - 0 MagdeburgMagdeburg ...
05 Abr 69 Lokomotive LeipzigLokomotive 0 - 0 Chemie LeipzigChemie ...
Jornada 22
19 Abr 69 BFC DynamoBFC Dynamo 2 - 1 FC Carl Zeiss JenaCarl Zeiss ...
19 Abr 69 Rot-Weiss ErfurtRot-Weiss 4 - 0 BSG Stahl RiesaStahl Riesa ...
19 Abr 69 Hallescher FCHallescher 0 - 2 Union BerlinUnion ...
19 Abr 69 ChemnitzerChemnitzer 1 - 1 ZwickauZwickau ...
19 Abr 69 Chemie LeipzigChemie 1 - 1 Hansa RostockHansa ...
19 Abr 69 MagdeburgMagdeburg 2 - 0 Lokomotive LeipzigLokomotive ...
19 Abr 69 BSG Wismut AueWismut 0 - 1 FC Vorwärts BerlinVorwärts ...
Jornada 23
26 Abr 69 Rot-Weiss ErfurtRot-Weiss 2 - 1 BFC DynamoBFC Dynamo ...
26 Abr 69 ZwickauZwickau 0 - 0 Chemie LeipzigChemie ...
26 Abr 69 BSG Stahl RiesaStahl Riesa 2 - 1 ChemnitzerChemnitzer ...
26 Abr 69 FC Vorwärts BerlinVorwärts 1 - 1 Hallescher FCHallescher ...
26 Abr 69 Hansa RostockHansa 0 - 1 MagdeburgMagdeburg ...
26 Abr 69 Lokomotive LeipzigLokomotive 1 - 1 BSG Wismut AueWismut ...
26 Abr 69 Union BerlinUnion 1 - 2 FC Carl Zeiss JenaCarl Zeiss ...
Jornada 24
03 May 69 Hallescher FCHallescher 1 - 1 Lokomotive LeipzigLokomotive ...
03 May 69 BFC DynamoBFC Dynamo 1 - 1 Union BerlinUnion ...
03 May 69 Chemie LeipzigChemie 1 - 0 BSG Stahl RiesaStahl Riesa ...
03 May 69 MagdeburgMagdeburg 2 - 0 ZwickauZwickau ...
03 May 69 BSG Wismut AueWismut 3 - 1 Hansa RostockHansa ...
03 May 69 ChemnitzerChemnitzer 0 - 0 Rot-Weiss ErfurtRot-Weiss ...
03 May 69 FC Carl Zeiss JenaCarl Zeiss 2 - 0 FC Vorwärts BerlinVorwärts ...
Jornada 25
10 May 69 Rot-Weiss ErfurtRot-Weiss 1 - 1 Chemie LeipzigChemie ...
10 May 69 ChemnitzerChemnitzer 1 - 2 BFC DynamoBFC Dynamo ...
10 May 69 FC Vorwärts BerlinVorwärts 2 - 0 Union BerlinUnion ...
10 May 69 Lokomotive LeipzigLokomotive 0 - 0 FC Carl Zeiss JenaCarl Zeiss ...
10 May 69 Hansa RostockHansa 1 - 1 Hallescher FCHallescher ...
10 May 69 BSG Stahl RiesaStahl Riesa 2 - 0 MagdeburgMagdeburg ...
10 May 69 ZwickauZwickau 2 - 0 BSG Wismut AueWismut ...
Jornada 26
17 May 69 BFC DynamoBFC Dynamo 1 - 2 FC Vorwärts BerlinVorwärts ...
17 May 69 Chemie LeipzigChemie 1 - 1 ChemnitzerChemnitzer ...
17 May 69 MagdeburgMagdeburg 1 - 2 Rot-Weiss ErfurtRot-Weiss ...
17 May 69 BSG Wismut AueWismut 0 - 1 BSG Stahl RiesaStahl Riesa ...
17 May 69 Hallescher FCHallescher 0 - 1 ZwickauZwickau ...
17 May 69 FC Carl Zeiss JenaCarl Zeiss 3 - 0 Hansa RostockHansa ...
17 May 69 Union BerlinUnion 1 - 1 Lokomotive LeipzigLokomotive ...

Clasificación

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

  USO DE MEMORIA  
6,157,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4111
Total Execution Time  0.4130
  CADENA URL  
/ddr_oberliga1969/grupo1/calendario
  GET DATOS  
$_GET['/ddr_oberliga1969/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0131  SELECT type FROM routes WHERE alias = 'ddr_oberliga1969'
0.0258  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.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2082 AND type_rel = 3
0.0127  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2082 ORDER BY order_id ASC
0.0135  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2082 GROUP BY l.categoryId
0.0137  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2082 GROUP BY l.year ORDER BY l.year DESC
0.0137  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.0180  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars1969 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 45355 ORDER BY round ASC
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 02:23:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 02:23:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 02:23:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 02:23:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  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.0332  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.0141  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.0143  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.0137  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