4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
14 Ago 19 SpratzernSpratzern 0 - 3 Kremser SCKremser SC ...
14 Ago 19 St. Pölten IIPölten 2 - 0 KilbKilb ...
14 Ago 19 OrtmannOrtmann 3 - 5 Scheiblingkirchen-WarthScheiblingk ...
14 Ago 19 ArdaggerArdagger 4 - 1 Waidhofen / ThayaWaidhofen ...
14 Ago 19 RohrbachRohrbach 0 - 3 SC RetzSC Retz ...
14 Ago 19 SchremsSchrems 3 - 1 LangenrohrLangenrohr ...
14 Ago 19 MannersdorfMannersdorf 4 - 4 ZwettlZwettl ...
15 Ago 19 GaflenzGaflenz 1 - 0 KottingbrunnKottingbrun ...
Jornada 2
09 Ago 19 KottingbrunnKottingbrun 2 - 0 KilbKilb ...
09 Ago 19 ZwettlZwettl 2 - 2 SpratzernSpratzern ...
09 Ago 19 LangenrohrLangenrohr 2 - 2 St. Pölten IIPölten ...
09 Ago 19 Kremser SCKremser SC 10 - 1 OrtmannOrtmann ...
10 Ago 19 GaflenzGaflenz 1 - 1 ArdaggerArdagger ...
10 Ago 19 Scheiblingkirchen-WarthScheiblingk 1 - 2 RohrbachRohrbach ...
27 Ago 19 SchremsSchrems 0 - 0 SC RetzSC Retz ...
27 Ago 19 Waidhofen / ThayaWaidhofen 0 - 0 MannersdorfMannersdorf ...
Jornada 3
17 Ago 19 OrtmannOrtmann 0 - 0 ZwettlZwettl ...
18 Ago 19 St. Pölten IIPölten 1 - 3 SC RetzSC Retz ...
17 Ago 19 SchremsSchrems 2 - 3 Scheiblingkirchen-WarthScheiblingk ...
17 Ago 19 ArdaggerArdagger 0 - 1 KottingbrunnKottingbrun ...
17 Ago 19 SpratzernSpratzern 3 - 4 Waidhofen / ThayaWaidhofen ...
17 Ago 19 MannersdorfMannersdorf 2 - 4 GaflenzGaflenz ...
17 Ago 19 RohrbachRohrbach 1 - 0 Kremser SCKremser SC ...
17 Ago 19 LangenrohrLangenrohr 3 - 0 KilbKilb ...
Jornada 4
22 Ago 19 Kremser SCKremser SC 5 - 2 SchremsSchrems ...
23 Ago 19 Scheiblingkirchen-WarthScheiblingk 3 - 0 St. Pölten IIPölten ...
23 Ago 19 ArdaggerArdagger 1 - 0 MannersdorfMannersdorf ...
23 Ago 19 KottingbrunnKottingbrun 4 - 0 LangenrohrLangenrohr ...
24 Ago 19 SC RetzSC Retz 4 - 0 KilbKilb ...
23 Ago 19 ZwettlZwettl 2 - 4 RohrbachRohrbach ...
23 Ago 19 Waidhofen / ThayaWaidhofen 2 - 2 OrtmannOrtmann ...
25 Ago 19 GaflenzGaflenz 2 - 1 SpratzernSpratzern ...
Jornada 5
30 Ago 19 RohrbachRohrbach 2 - 2 Waidhofen / ThayaWaidhofen ...
30 Ago 19 Kremser SCKremser SC 1 - 1 St. Pölten IIPölten ...
30 Ago 19 KilbKilb 0 - 2 Scheiblingkirchen-WarthScheiblingk ...
01 Sep 19 LangenrohrLangenrohr 0 - 0 SC RetzSC Retz ...
30 Ago 19 SchremsSchrems 1 - 0 ZwettlZwettl ...
30 Ago 19 OrtmannOrtmann 2 - 0 GaflenzGaflenz ...
31 Ago 19 MannersdorfMannersdorf 1 - 2 KottingbrunnKottingbrun ...
31 Ago 19 SpratzernSpratzern 1 - 2 ArdaggerArdagger ...
30 Ago 19 Scheiblingkirchen-WarthScheiblingk 0 - 2 KilbKilb ...
Jornada 6
07 Sep 19 ZwettlZwettl 1 - 4 St. Pölten IIPölten ...
07 Sep 19 GaflenzGaflenz 3 - 0 RohrbachRohrbach ...
06 Sep 19 Kremser SCKremser SC 1 - 0 KilbKilb ...
08 Sep 19 MannersdorfMannersdorf 1 - 0 SpratzernSpratzern ...
06 Sep 19 KottingbrunnKottingbrun 5 - 0 SC RetzSC Retz ...
06 Sep 19 Waidhofen / ThayaWaidhofen 1 - 1 SchremsSchrems ...
06 Sep 19 ArdaggerArdagger 2 - 0 OrtmannOrtmann ...
08 Sep 19 Scheiblingkirchen-WarthScheiblingk 2 - 2 LangenrohrLangenrohr ...
Jornada 7
13 Sep 19 St. Pölten IIPölten 4 - 0 Waidhofen / ThayaWaidhofen ...
13 Sep 19 LangenrohrLangenrohr 0 - 0 Kremser SCKremser SC ...
14 Sep 19 SpratzernSpratzern 0 - 4 KottingbrunnKottingbrun ...
14 Sep 19 SC RetzSC Retz 1 - 1 Scheiblingkirchen-WarthScheiblingk ...
14 Sep 19 KilbKilb 2 - 1 ZwettlZwettl ...
13 Sep 19 SchremsSchrems 1 - 1 GaflenzGaflenz ...
13 Sep 19 RohrbachRohrbach 1 - 1 ArdaggerArdagger ...
13 Sep 19 OrtmannOrtmann 1 - 1 MannersdorfMannersdorf ...
Jornada 8
20 Sep 19 Kremser SCKremser SC 0 - 1 SC RetzSC Retz ...
20 Sep 19 MannersdorfMannersdorf 0 - 1 RohrbachRohrbach ...
20 Sep 19 KottingbrunnKottingbrun 2 - 1 Scheiblingkirchen-WarthScheiblingk ...
20 Sep 19 ArdaggerArdagger 3 - 0 SchremsSchrems ...
21 Sep 19 SpratzernSpratzern 3 - 2 OrtmannOrtmann ...
21 Sep 19 GaflenzGaflenz 2 - 3 St. Pölten IIPölten ...
20 Sep 19 Waidhofen / ThayaWaidhofen 2 - 2 KilbKilb ...
20 Sep 19 ZwettlZwettl 0 - 0 LangenrohrLangenrohr ...
Jornada 9
27 Sep 19 SchremsSchrems 0 - 1 MannersdorfMannersdorf ...
28 Sep 19 SC RetzSC Retz 4 - 3 ZwettlZwettl ...
27 Sep 19 KilbKilb 4 - 0 GaflenzGaflenz ...
27 Sep 19 Scheiblingkirchen-WarthScheiblingk 1 - 0 Kremser SCKremser SC ...
27 Sep 19 OrtmannOrtmann 2 - 2 KottingbrunnKottingbrun ...
27 Sep 19 RohrbachRohrbach 6 - 2 SpratzernSpratzern ...
27 Sep 19 LangenrohrLangenrohr 4 - 1 Waidhofen / ThayaWaidhofen ...
27 Sep 19 St. Pölten IIPölten 1 - 1 ArdaggerArdagger ...
Jornada 10
04 Oct 19 ZwettlZwettl 2 - 0 Scheiblingkirchen-WarthScheiblingk ...
04 Oct 19 Waidhofen / ThayaWaidhofen 0 - 5 SC RetzSC Retz ...
04 Oct 19 MannersdorfMannersdorf 1 - 2 St. Pölten IIPölten ...
04 Oct 19 KottingbrunnKottingbrun 1 - 1 Kremser SCKremser SC ...
10 Nov 19 SpratzernSpratzern 0 - 1 SchremsSchrems ...
04 Oct 19 ArdaggerArdagger 1 - 2 KilbKilb ...
05 Oct 19 OrtmannOrtmann 1 - 4 RohrbachRohrbach ...
05 Oct 19 GaflenzGaflenz 5 - 2 LangenrohrLangenrohr ...
Jornada 11
11 Oct 19 Kremser SCKremser SC 2 - 1 ZwettlZwettl ...
11 Oct 19 SchremsSchrems 5 - 3 OrtmannOrtmann ...
11 Oct 19 KilbKilb 3 - 3 MannersdorfMannersdorf ...
11 Oct 19 LangenrohrLangenrohr 1 - 1 ArdaggerArdagger ...
11 Oct 19 RohrbachRohrbach 0 - 1 KottingbrunnKottingbrun ...
12 Oct 19 SC RetzSC Retz 4 - 2 GaflenzGaflenz ...
12 Oct 19 Scheiblingkirchen-WarthScheiblingk 2 - 0 Waidhofen / ThayaWaidhofen ...
11 Oct 19 St. Pölten IIPölten 3 - 0 SpratzernSpratzern ...
Jornada 12
19 Oct 19 OrtmannOrtmann 1 - 3 St. Pölten IIPölten ...
18 Oct 19 KottingbrunnKottingbrun 0 - 0 ZwettlZwettl ...
18 Oct 19 RohrbachRohrbach 3 - 2 SchremsSchrems ...
19 Oct 19 SpratzernSpratzern 1 - 1 KilbKilb ...
18 Oct 19 Waidhofen / ThayaWaidhofen 1 - 3 Kremser SCKremser SC ...
19 Oct 19 GaflenzGaflenz 1 - 5 Scheiblingkirchen-WarthScheiblingk ...
19 Oct 19 ArdaggerArdagger 1 - 1 SC RetzSC Retz ...
18 Oct 19 MannersdorfMannersdorf 0 - 0 LangenrohrLangenrohr ...
Jornada 13
25 Oct 19 LangenrohrLangenrohr 2 - 3 SpratzernSpratzern ...
26 Oct 19 SchremsSchrems 1 - 3 KottingbrunnKottingbrun ...
25 Oct 19 St. Pölten IIPölten 1 - 1 RohrbachRohrbach ...
25 Oct 19 ZwettlZwettl 0 - 2 Waidhofen / ThayaWaidhofen ...
26 Oct 19 Scheiblingkirchen-WarthScheiblingk 1 - 1 ArdaggerArdagger ...
26 Oct 19 SC RetzSC Retz 4 - 0 MannersdorfMannersdorf ...
25 Oct 19 KilbKilb 3 - 3 OrtmannOrtmann ...
25 Oct 19 Kremser SCKremser SC 1 - 0 GaflenzGaflenz ...
Jornada 14
03 Nov 19 MannersdorfMannersdorf 1 - 1 Scheiblingkirchen-WarthScheiblingk ...
02 Nov 19 SpratzernSpratzern 0 - 1 SC RetzSC Retz ...
03 Nov 19 SchremsSchrems 1 - 3 St. Pölten IIPölten ...
02 Nov 19 OrtmannOrtmann 2 - 1 LangenrohrLangenrohr ...
02 Nov 19 GaflenzGaflenz 2 - 2 ZwettlZwettl ...
31 Oct 19 KottingbrunnKottingbrun 3 - 0 Waidhofen / ThayaWaidhofen ...
31 Oct 19 ArdaggerArdagger 1 - 1 Kremser SCKremser SC ...
02 Nov 19 RohrbachRohrbach 3 - 0 KilbKilb ...
Jornada 15
08 Nov 19 ZwettlZwettl 2 - 0 ArdaggerArdagger ...
08 Nov 19 LangenrohrLangenrohr 1 - 5 RohrbachRohrbach ...
08 Nov 19 St. Pölten IIPölten 1 - 0 KottingbrunnKottingbrun ...
08 Nov 19 Kremser SCKremser SC 6 - 1 MannersdorfMannersdorf ...
08 Nov 19 Scheiblingkirchen-WarthScheiblingk 4 - 0 SpratzernSpratzern ...
09 Nov 19 SC RetzSC Retz 2 - 1 OrtmannOrtmann ...
08 Nov 19 Waidhofen / ThayaWaidhofen 1 - 2 GaflenzGaflenz ...
08 Nov 19 KilbKilb 1 - 1 SchremsSchrems ...
Jornada 16
07 Mar 20 Scheiblingkirchen-WarthScheiblingk 1 - 0 OrtmannOrtmann ...
24 Mar 20 KottingbrunnKottingbrun Apl GaflenzGaflenz ...
06 Mar 20 ZwettlZwettl 2 - 1 MannersdorfMannersdorf ...
06 Mar 20 Waidhofen / ThayaWaidhofen 0 - 0 ArdaggerArdagger ...
06 Mar 20 LangenrohrLangenrohr 1 - 2 SchremsSchrems ...
07 Mar 20 SC RetzSC Retz 0 - 4 RohrbachRohrbach ...
07 Mar 20 KilbKilb 3 - 2 St. Pölten IIPölten ...
06 Mar 20 Kremser SCKremser SC 2 - 2 SpratzernSpratzern ...
Jornada 17
14 Mar 20 SC RetzSC Retz Apl SchremsSchrems ...
13 Mar 20 RohrbachRohrbach Apl Scheiblingkirchen-WarthScheiblingk ...
14 Mar 20 SpratzernSpratzern Apl ZwettlZwettl ...
13 Mar 20 MannersdorfMannersdorf Apl Waidhofen / ThayaWaidhofen ...
14 Mar 20 OrtmannOrtmann Apl Kremser SCKremser SC ...
13 Mar 20 ArdaggerArdagger Apl GaflenzGaflenz ...
13 Mar 20 KilbKilb Apl KottingbrunnKottingbrun ...
13 Mar 20 St. Pölten IIPölten Apl LangenrohrLangenrohr ...
Jornada 18
20 Mar 20 Kremser SCKremser SC Apl RohrbachRohrbach ...
22 Mar 20 LangenrohrLangenrohr Apl KilbKilb ...
20 Mar 20 ZwettlZwettl Apl OrtmannOrtmann ...
21 Mar 20 SC RetzSC Retz Apl St. Pölten IIPölten ...
21 Mar 20 GaflenzGaflenz Apl MannersdorfMannersdorf ...
20 Mar 20 KottingbrunnKottingbrun Apl ArdaggerArdagger ...
20 Mar 20 Waidhofen / ThayaWaidhofen Apl SpratzernSpratzern ...
22 Mar 20 Scheiblingkirchen-WarthScheiblingk Apl SchremsSchrems ...
20 Mar 20 KilbKilb Apl LangenrohrLangenrohr ...
Jornada 19
29 Mar 20 MannersdorfMannersdorf Apl ArdaggerArdagger ...
29 Mar 20 RohrbachRohrbach Apl ZwettlZwettl ...
27 Mar 20 KilbKilb Apl SC RetzSC Retz ...
29 Mar 20 OrtmannOrtmann Apl Waidhofen / ThayaWaidhofen ...
27 Mar 20 St. Pölten IIPölten Apl Scheiblingkirchen-WarthScheiblingk ...
29 Mar 20 SpratzernSpratzern Apl GaflenzGaflenz ...
29 Mar 20 LangenrohrLangenrohr Apl KottingbrunnKottingbrun ...
29 Mar 20 SchremsSchrems Apl Kremser SCKremser SC ...
Jornada 20
05 Abr 20 St. Pölten IIPölten Apl Kremser SCKremser SC ...
05 Abr 20 Waidhofen / ThayaWaidhofen Apl RohrbachRohrbach ...
05 Abr 20 KottingbrunnKottingbrun Apl MannersdorfMannersdorf ...
05 Abr 20 ZwettlZwettl Apl SchremsSchrems ...
05 Abr 20 ArdaggerArdagger Apl SpratzernSpratzern ...
05 Abr 20 GaflenzGaflenz Apl OrtmannOrtmann ...
05 Abr 20 SC RetzSC Retz Apl LangenrohrLangenrohr ...
05 Abr 20 Scheiblingkirchen-WarthScheiblingk Apl KilbKilb ...
05 Abr 20 KilbKilb Apl Scheiblingkirchen-WarthScheiblingk ...
Jornada 21
12 Abr 20 KilbKilb Apl Kremser SCKremser SC ...
12 Abr 20 RohrbachRohrbach Apl GaflenzGaflenz ...
12 Abr 20 SchremsSchrems Apl Waidhofen / ThayaWaidhofen ...
12 Abr 20 LangenrohrLangenrohr Apl Scheiblingkirchen-WarthScheiblingk ...
12 Abr 20 OrtmannOrtmann Apl ArdaggerArdagger ...
12 Abr 20 SpratzernSpratzern Apl MannersdorfMannersdorf ...
12 Abr 20 SC RetzSC Retz Apl KottingbrunnKottingbrun ...
12 Abr 20 St. Pölten IIPölten Apl ZwettlZwettl ...
Jornada 22
19 Abr 20 Waidhofen / ThayaWaidhofen Apl St. Pölten IIPölten ...
19 Abr 20 GaflenzGaflenz Apl SchremsSchrems ...
19 Abr 20 Scheiblingkirchen-WarthScheiblingk Apl SC RetzSC Retz ...
19 Abr 20 KottingbrunnKottingbrun Apl SpratzernSpratzern ...
19 Abr 20 MannersdorfMannersdorf Apl OrtmannOrtmann ...
19 Abr 20 Kremser SCKremser SC Apl LangenrohrLangenrohr ...
19 Abr 20 ArdaggerArdagger Apl RohrbachRohrbach ...
19 Abr 20 ZwettlZwettl Apl KilbKilb ...
Jornada 23
26 Abr 20 St. Pölten IIPölten Apl GaflenzGaflenz ...
26 Abr 20 SC RetzSC Retz Apl Kremser SCKremser SC ...
26 Abr 20 LangenrohrLangenrohr Apl ZwettlZwettl ...
26 Abr 20 SchremsSchrems Apl ArdaggerArdagger ...
26 Abr 20 RohrbachRohrbach Apl MannersdorfMannersdorf ...
26 Abr 20 Scheiblingkirchen-WarthScheiblingk Apl KottingbrunnKottingbrun ...
26 Abr 20 OrtmannOrtmann Apl SpratzernSpratzern ...
26 Abr 20 KilbKilb Apl Waidhofen / ThayaWaidhofen ...
Jornada 24
03 May 20 Kremser SCKremser SC Apl Scheiblingkirchen-WarthScheiblingk ...
03 May 20 KottingbrunnKottingbrun Apl OrtmannOrtmann ...
03 May 20 MannersdorfMannersdorf Apl SchremsSchrems ...
03 May 20 GaflenzGaflenz Apl KilbKilb ...
03 May 20 ZwettlZwettl Apl SC RetzSC Retz ...
03 May 20 ArdaggerArdagger Apl St. Pölten IIPölten ...
03 May 20 Waidhofen / ThayaWaidhofen Apl LangenrohrLangenrohr ...
03 May 20 SpratzernSpratzern Apl RohrbachRohrbach ...
Jornada 25
10 May 20 Kremser SCKremser SC Apl KottingbrunnKottingbrun ...
10 May 20 RohrbachRohrbach Apl OrtmannOrtmann ...
10 May 20 Scheiblingkirchen-WarthScheiblingk Apl ZwettlZwettl ...
10 May 20 St. Pölten IIPölten Apl MannersdorfMannersdorf ...
10 May 20 SC RetzSC Retz Apl Waidhofen / ThayaWaidhofen ...
10 May 20 SchremsSchrems Apl SpratzernSpratzern ...
10 May 20 KilbKilb Apl ArdaggerArdagger ...
10 May 20 LangenrohrLangenrohr Apl GaflenzGaflenz ...
Jornada 26
17 May 20 KottingbrunnKottingbrun Apl RohrbachRohrbach ...
17 May 20 GaflenzGaflenz Apl SC RetzSC Retz ...
17 May 20 ArdaggerArdagger Apl LangenrohrLangenrohr ...
17 May 20 MannersdorfMannersdorf Apl KilbKilb ...
17 May 20 SpratzernSpratzern Apl St. Pölten IIPölten ...
17 May 20 ZwettlZwettl Apl Kremser SCKremser SC ...
17 May 20 OrtmannOrtmann Apl SchremsSchrems ...
17 May 20 Waidhofen / ThayaWaidhofen Apl Scheiblingkirchen-WarthScheiblingk ...
Jornada 27
24 May 20 SC RetzSC Retz Apl ArdaggerArdagger ...
24 May 20 St. Pölten IIPölten Apl OrtmannOrtmann ...
24 May 20 SchremsSchrems Apl RohrbachRohrbach ...
24 May 20 KilbKilb Apl SpratzernSpratzern ...
24 May 20 LangenrohrLangenrohr Apl MannersdorfMannersdorf ...
24 May 20 ZwettlZwettl Apl KottingbrunnKottingbrun ...
24 May 20 Scheiblingkirchen-WarthScheiblingk Apl GaflenzGaflenz ...
24 May 20 Kremser SCKremser SC Apl Waidhofen / ThayaWaidhofen ...
Jornada 28
31 May 20 KottingbrunnKottingbrun Apl SchremsSchrems ...
31 May 20 GaflenzGaflenz Apl Kremser SCKremser SC ...
31 May 20 Waidhofen / ThayaWaidhofen Apl ZwettlZwettl ...
31 May 20 ArdaggerArdagger Apl Scheiblingkirchen-WarthScheiblingk ...
31 May 20 MannersdorfMannersdorf Apl SC RetzSC Retz ...
31 May 20 OrtmannOrtmann Apl KilbKilb ...
31 May 20 SpratzernSpratzern Apl LangenrohrLangenrohr ...
31 May 20 RohrbachRohrbach Apl St. Pölten IIPölten ...
Jornada 29
07 Jun 20 LangenrohrLangenrohr Apl OrtmannOrtmann ...
07 Jun 20 ZwettlZwettl Apl GaflenzGaflenz ...
07 Jun 20 Kremser SCKremser SC Apl ArdaggerArdagger ...
07 Jun 20 SC RetzSC Retz Apl SpratzernSpratzern ...
07 Jun 20 St. Pölten IIPölten Apl SchremsSchrems ...
07 Jun 20 KilbKilb Apl RohrbachRohrbach ...
07 Jun 20 Scheiblingkirchen-WarthScheiblingk Apl MannersdorfMannersdorf ...
07 Jun 20 Waidhofen / ThayaWaidhofen Apl KottingbrunnKottingbrun ...
Jornada 30
14 Jun 20 OrtmannOrtmann Apl SC RetzSC Retz ...
14 Jun 20 GaflenzGaflenz Apl Waidhofen / ThayaWaidhofen ...
14 Jun 20 SpratzernSpratzern Apl Scheiblingkirchen-WarthScheiblingk ...
14 Jun 20 SchremsSchrems Apl KilbKilb ...
14 Jun 20 ArdaggerArdagger Apl ZwettlZwettl ...
14 Jun 20 RohrbachRohrbach Apl LangenrohrLangenrohr ...
14 Jun 20 MannersdorfMannersdorf Apl Kremser SCKremser SC ...
14 Jun 20 KottingbrunnKottingbrun Apl St. Pölten IIPölten ...

Clasificación

Equipo PJ GF GC Puntos
1 SC Retz SC Retz 16 33 18 34
2 Kottingbrunn Kottingbrunn 15 30 8 33
3 Rohrbach Rohrbach 16 37 20 33
4 Scheiblingkirchen-Warth Scheiblingki 17 33 19 31
5 St. Pölten II Pölten 16 33 20 31
6 Kremser SC Kremser SC 16 36 14 29
7 Ardagger Ardagger 16 20 14 23
8 Gaflenz Gaflenz 15 26 29 21
9 Kilb Kilb 17 23 31 20
10 Schrems Schrems 16 23 29 19
11 Zwettl Zwettl 16 22 28 15
12 Langenrohr Langenrohr 16 20 30 13
13 Mannersdorf Mannersdorf 16 17 31 12
14 Waidhofen / Thaya Waidhofen 16 17 37 12
15 Ortmann Ortmann 16 24 44 11
16 Spratzern Spratzern 16 18 40 9

  USO DE MEMORIA  
6,505,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1117
Total Execution Time  0.1137
  CADENA URL  
/landesliga_austria2020/grupo4/calendario
  GET DATOS  
$_GET['/landesliga_austria2020/grupo4/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'landesliga_austria' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
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 = 50450 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  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 calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 50450 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 09:18:35' 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-30 09:18:35' 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-30 09:18:35' 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-30 09:18:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  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 events2020 e ON e.player_id = p.id AND e.league_id = 50450 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50450 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.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 50450 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50450 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 50450 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50450 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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 = 50450 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC