4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Superliga Danesa 2012
2011/2012

Superliga, liga dinamarca, primera division dinamarca, superliga dinamarca, superliga danesa,liga danesa

Superliga Danesa 2012

  • Nordsjaelland
  • Kobenhavn
  • Midtjylland
  • AC Horsens
  • AGF Aarhus
  • SonderjyskE
  • Aalborg BK
  • Silkeborg IF
  • Brøndby IF
  • Odense BK
  • Lyngby BK
  • Køge BK
Jornada 1
16 Jul 11 Odense BKOdense BK 2 - 0 NordsjaellandNordsjaella ...
17 Jul 11 MidtjyllandMidtjylland 1 - 2 Silkeborg IFSilkeborg ...
17 Jul 11 AC HorsensAC Horsens 3 - 0 Køge BKKøge BK ...
17 Jul 11 SonderjyskESonderjyskE 0 - 2 KobenhavnKobenhavn ...
17 Jul 11 Brøndby IFBrøndby 2 - 2 Aalborg BKAalborg BK ...
18 Jul 11 AGF AarhusAGF Aarhus 2 - 1 Lyngby BKLyngby BK ...
Jornada 2
23 Jul 11 Silkeborg IFSilkeborg 0 - 1 Brøndby IFBrøndby 1
23 Jul 11 KobenhavnKobenhavn 2 - 2 Odense BKOdense BK ...
24 Jul 11 NordsjaellandNordsjaella 1 - 1 AC HorsensAC Horsens 1
24 Jul 11 Lyngby BKLyngby BK 0 - 1 SonderjyskESonderjyskE ...
24 Jul 11 Aalborg BKAalborg BK 2 - 1 AGF AarhusAGF Aarhus ...
25 Jul 11 Køge BKKøge BK 2 - 3 MidtjyllandMidtjylland ...
Jornada 3
30 Jul 11 AGF AarhusAGF Aarhus 2 - 2 Odense BKOdense BK ...
30 Jul 11 KobenhavnKobenhavn 2 - 0 NordsjaellandNordsjaella 1
31 Jul 11 Silkeborg IFSilkeborg 1 - 1 SonderjyskESonderjyskE ...
31 Jul 11 Lyngby BKLyngby BK 3 - 1 Køge BKKøge BK ...
31 Jul 11 Brøndby IFBrøndby 1 - 4 AC HorsensAC Horsens 1
01 Ago 11 Aalborg BKAalborg BK 1 - 0 MidtjyllandMidtjylland ...
Jornada 4
06 Ago 11 SonderjyskESonderjyskE 3 - 1 AGF AarhusAGF Aarhus 1
06 Ago 11 AC HorsensAC Horsens 3 - 3 Aalborg BKAalborg BK ...
07 Ago 11 MidtjyllandMidtjylland 2 - 1 Lyngby BKLyngby BK ...
07 Ago 11 Køge BKKøge BK 2 - 4 KobenhavnKobenhavn ...
07 Ago 11 NordsjaellandNordsjaella 2 - 1 Silkeborg IFSilkeborg ...
07 Ago 11 Odense BKOdense BK 2 - 1 Brøndby IFBrøndby ...
Jornada 5
13 Ago 11 Aalborg BKAalborg BK 2 - 1 Odense BKOdense BK ...
13 Ago 11 KobenhavnKobenhavn 2 - 0 MidtjyllandMidtjylland ...
14 Ago 11 Lyngby BKLyngby BK 1 - 1 AC HorsensAC Horsens ...
14 Ago 11 Brøndby IFBrøndby 2 - 2 SonderjyskESonderjyskE ...
14 Ago 11 NordsjaellandNordsjaella 2 - 0 Køge BKKøge BK ...
15 Ago 11 Silkeborg IFSilkeborg 1 - 1 AGF AarhusAGF Aarhus ...
Jornada 6
20 Ago 11 Odense BKOdense BK 3 - 1 Lyngby BKLyngby BK ...
20 Ago 11 AC HorsensAC Horsens 0 - 1 KobenhavnKobenhavn 2
21 Ago 11 MidtjyllandMidtjylland 2 - 1 NordsjaellandNordsjaella ...
21 Ago 11 Køge BKKøge BK 3 - 0 Silkeborg IFSilkeborg ...
21 Ago 11 AGF AarhusAGF Aarhus 0 - 0 Brøndby IFBrøndby ...
22 Ago 11 SonderjyskESonderjyskE 0 - 0 Aalborg BKAalborg BK 1
Jornada 7
27 Ago 11 Køge BKKøge BK 1 - 4 Aalborg BKAalborg BK ...
28 Ago 11 Odense BKOdense BK 2 - 4 SonderjyskESonderjyskE ...
28 Ago 11 NordsjaellandNordsjaella 4 - 0 Lyngby BKLyngby BK ...
28 Ago 11 KobenhavnKobenhavn 2 - 1 Silkeborg IFSilkeborg 1
28 Ago 11 MidtjyllandMidtjylland 2 - 1 Brøndby IFBrøndby ...
29 Ago 11 AC HorsensAC Horsens 0 - 3 AGF AarhusAGF Aarhus ...
Jornada 8
10 Sep 11 Silkeborg IFSilkeborg 1 - 3 Odense BKOdense BK 1
12 Sep 11 AGF AarhusAGF Aarhus 4 - 2 MidtjyllandMidtjylland 1
11 Sep 11 SonderjyskESonderjyskE 1 - 3 AC HorsensAC Horsens ...
10 Sep 11 Lyngby BKLyngby BK 0 - 1 KobenhavnKobenhavn ...
11 Sep 11 Brøndby IFBrøndby 5 - 0 Køge BKKøge BK ...
11 Sep 11 Aalborg BKAalborg BK 1 - 2 NordsjaellandNordsjaella ...
Jornada 9
19 Sep 11 AC HorsensAC Horsens 4 - 3 Odense BKOdense BK ...
18 Sep 11 Lyngby BKLyngby BK 0 - 2 Silkeborg IFSilkeborg ...
18 Sep 11 NordsjaellandNordsjaella 2 - 0 Brøndby IFBrøndby ...
18 Sep 11 MidtjyllandMidtjylland 2 - 0 SonderjyskESonderjyskE ...
18 Sep 11 KobenhavnKobenhavn 2 - 0 Aalborg BKAalborg BK ...
17 Sep 11 Køge BKKøge BK 0 - 2 AGF AarhusAGF Aarhus ...
Jornada 10
25 Sep 11 Silkeborg IFSilkeborg 1 - 1 AC HorsensAC Horsens ...
24 Sep 11 AGF AarhusAGF Aarhus 1 - 0 NordsjaellandNordsjaella ...
25 Sep 11 SonderjyskESonderjyskE 0 - 0 Køge BKKøge BK ...
24 Sep 11 Brøndby IFBrøndby 1 - 2 KobenhavnKobenhavn ...
26 Sep 11 Aalborg BKAalborg BK 1 - 2 Lyngby BKLyngby BK ...
25 Sep 11 Odense BKOdense BK 1 - 4 MidtjyllandMidtjylland ...
Jornada 11
02 Oct 11 Odense BKOdense BK 2 - 1 Køge BKKøge BK ...
02 Oct 11 Brøndby IFBrøndby 1 - 0 Lyngby BKLyngby BK ...
02 Oct 11 NordsjaellandNordsjaella 1 - 0 SonderjyskESonderjyskE ...
03 Oct 11 MidtjyllandMidtjylland 1 - 0 AC HorsensAC Horsens 1
01 Oct 11 Silkeborg IFSilkeborg 1 - 1 Aalborg BKAalborg BK 1
02 Oct 11 KobenhavnKobenhavn 1 - 1 AGF AarhusAGF Aarhus ...
Jornada 12
16 Oct 11 Køge BKKøge BK 1 - 3 SonderjyskESonderjyskE ...
16 Oct 11 AGF AarhusAGF Aarhus 0 - 0 Odense BKOdense BK ...
16 Oct 11 MidtjyllandMidtjylland 1 - 0 Brøndby IFBrøndby ...
15 Oct 11 NordsjaellandNordsjaella 1 - 0 Aalborg BKAalborg BK ...
16 Oct 11 Lyngby BKLyngby BK 2 - 3 Silkeborg IFSilkeborg ...
17 Oct 11 AC HorsensAC Horsens 2 - 0 KobenhavnKobenhavn 2
Jornada 13
23 Oct 11 Aalborg BKAalborg BK 2 - 1 Odense BKOdense BK ...
23 Oct 11 SonderjyskESonderjyskE 1 - 4 AC HorsensAC Horsens ...
22 Oct 11 Lyngby BKLyngby BK 1 - 1 AGF AarhusAGF Aarhus ...
24 Oct 11 KobenhavnKobenhavn 1 - 3 NordsjaellandNordsjaella 1
23 Oct 11 Køge BKKøge BK 1 - 1 MidtjyllandMidtjylland ...
23 Oct 11 Silkeborg IFSilkeborg 2 - 1 Brøndby IFBrøndby 1
Jornada 14
30 Oct 11 Odense BKOdense BK 1 - 3 KobenhavnKobenhavn ...
31 Oct 11 MidtjyllandMidtjylland 1 - 1 SonderjyskESonderjyskE ...
30 Oct 11 AGF AarhusAGF Aarhus 2 - 0 Køge BKKøge BK ...
30 Oct 11 NordsjaellandNordsjaella 0 - 1 Lyngby BKLyngby BK ...
30 Oct 11 Brøndby IFBrøndby 1 - 1 Aalborg BKAalborg BK ...
29 Oct 11 AC HorsensAC Horsens 1 - 1 Silkeborg IFSilkeborg ...
Jornada 15
05 Nov 11 Aalborg BKAalborg BK 2 - 0 AC HorsensAC Horsens 1
07 Nov 11 SonderjyskESonderjyskE 1 - 1 AGF AarhusAGF Aarhus 1
06 Nov 11 Køge BKKøge BK 0 - 2 NordsjaellandNordsjaella ...
06 Nov 11 KobenhavnKobenhavn 3 - 0 Lyngby BKLyngby BK ...
06 Nov 11 Odense BKOdense BK 0 - 0 Brøndby IFBrøndby ...
06 Nov 11 Silkeborg IFSilkeborg 4 - 1 MidtjyllandMidtjylland ...
Jornada 16
20 Nov 11 Lyngby BKLyngby BK 2 - 2 Køge BKKøge BK ...
21 Nov 11 AGF AarhusAGF Aarhus 0 - 2 Silkeborg IFSilkeborg 1
20 Nov 11 MidtjyllandMidtjylland 1 - 3 Aalborg BKAalborg BK ...
20 Nov 11 NordsjaellandNordsjaella 2 - 0 SonderjyskESonderjyskE ...
19 Nov 11 AC HorsensAC Horsens 0 - 1 Odense BKOdense BK ...
20 Nov 11 Brøndby IFBrøndby 2 - 1 KobenhavnKobenhavn ...
Jornada 17
28 Nov 11 Brøndby IFBrøndby 0 - 1 AC HorsensAC Horsens 1
27 Nov 11 Aalborg BKAalborg BK 0 - 2 AGF AarhusAGF Aarhus ...
27 Nov 11 SonderjyskESonderjyskE 3 - 1 Lyngby BKLyngby BK ...
27 Nov 11 KobenhavnKobenhavn 2 - 1 Køge BKKøge BK ...
27 Nov 11 Silkeborg IFSilkeborg 1 - 2 NordsjaellandNordsjaella ...
26 Nov 11 Odense BKOdense BK 2 - 3 MidtjyllandMidtjylland ...
Jornada 18
03 Dic 11 Silkeborg IFSilkeborg 4 - 2 Aalborg BKAalborg BK 1
04 Dic 11 KobenhavnKobenhavn 0 - 0 AGF AarhusAGF Aarhus ...
04 Dic 11 Køge BKKøge BK 1 - 1 Brøndby IFBrøndby ...
05 Dic 11 SonderjyskESonderjyskE 0 - 4 Odense BKOdense BK 1
04 Dic 11 Lyngby BKLyngby BK 1 - 2 AC HorsensAC Horsens ...
04 Dic 11 NordsjaellandNordsjaella 0 - 0 MidtjyllandMidtjylland ...
Jornada 19
04 Mar 12 Aalborg BKAalborg BK 1 - 1 KobenhavnKobenhavn 2
04 Mar 12 Brøndby IFBrøndby 1 - 0 SonderjyskESonderjyskE ...
04 Mar 12 AC HorsensAC Horsens 2 - 1 Køge BKKøge BK ...
04 Mar 12 MidtjyllandMidtjylland 1 - 2 Lyngby BKLyngby BK ...
03 Mar 12 AGF AarhusAGF Aarhus 1 - 1 NordsjaellandNordsjaella ...
05 Mar 12 Odense BKOdense BK 2 - 2 Silkeborg IFSilkeborg ...
Jornada 20
10 Mar 12 Odense BKOdense BK 0 - 1 NordsjaellandNordsjaella ...
11 Mar 12 Silkeborg IFSilkeborg 0 - 1 Køge BKKøge BK ...
12 Mar 12 MidtjyllandMidtjylland 4 - 1 AC HorsensAC Horsens 1
11 Mar 12 KobenhavnKobenhavn 2 - 0 SonderjyskESonderjyskE ...
11 Mar 12 Brøndby IFBrøndby 0 - 0 AGF AarhusAGF Aarhus ...
11 Mar 12 Aalborg BKAalborg BK 1 - 0 Lyngby BKLyngby BK ...
Jornada 21
18 Mar 12 NordsjaellandNordsjaella 1 - 2 Brøndby IFBrøndby ...
18 Mar 12 KobenhavnKobenhavn 0 - 0 MidtjyllandMidtjylland ...
19 Mar 12 Køge BKKøge BK 1 - 1 Aalborg BKAalborg BK ...
17 Mar 12 AGF AarhusAGF Aarhus 1 - 3 AC HorsensAC Horsens ...
18 Mar 12 Lyngby BKLyngby BK 1 - 0 Odense BKOdense BK ...
18 Mar 12 SonderjyskESonderjyskE 2 - 4 Silkeborg IFSilkeborg ...
Jornada 22
26 Mar 12 MidtjyllandMidtjylland 0 - 2 AGF AarhusAGF Aarhus 1
24 Mar 12 Aalborg BKAalborg BK 1 - 2 SonderjyskESonderjyskE ...
25 Mar 12 Brøndby IFBrøndby 2 - 1 Lyngby BKLyngby BK ...
25 Mar 12 AC HorsensAC Horsens 0 - 2 NordsjaellandNordsjaella ...
25 Mar 12 Silkeborg IFSilkeborg 0 - 0 KobenhavnKobenhavn ...
25 Mar 12 Odense BKOdense BK 2 - 4 Køge BKKøge BK ...
Jornada 23
31 Mar 12 AC HorsensAC Horsens 1 - 0 Aalborg BKAalborg BK ...
01 Abr 12 Brøndby IFBrøndby 1 - 0 Odense BKOdense BK ...
01 Abr 12 NordsjaellandNordsjaella 2 - 0 Køge BKKøge BK ...
02 Abr 12 AGF AarhusAGF Aarhus 1 - 3 SonderjyskESonderjyskE ...
01 Abr 12 Lyngby BKLyngby BK 1 - 3 KobenhavnKobenhavn ...
01 Abr 12 MidtjyllandMidtjylland 2 - 2 Silkeborg IFSilkeborg ...
Jornada 24
05 Abr 12 SonderjyskESonderjyskE 1 - 0 NordsjaellandNordsjaella ...
05 Abr 12 Køge BKKøge BK 1 - 4 Lyngby BKLyngby BK ...
05 Abr 12 Silkeborg IFSilkeborg 2 - 1 AGF AarhusAGF Aarhus ...
05 Abr 12 KobenhavnKobenhavn 3 - 1 Brøndby IFBrøndby ...
04 Abr 12 Aalborg BKAalborg BK 1 - 2 MidtjyllandMidtjylland ...
06 Abr 12 Odense BKOdense BK 0 - 1 AC HorsensAC Horsens ...
Jornada 25
09 Abr 12 Odense BKOdense BK 1 - 1 SonderjyskESonderjyskE ...
09 Abr 12 Brøndby IFBrøndby 1 - 1 Køge BKKøge BK ...
09 Abr 12 AC HorsensAC Horsens 0 - 0 Lyngby BKLyngby BK ...
08 Abr 12 Aalborg BKAalborg BK 3 - 1 Silkeborg IFSilkeborg ...
08 Abr 12 MidtjyllandMidtjylland 1 - 1 NordsjaellandNordsjaella ...
09 Abr 12 AGF AarhusAGF Aarhus 0 - 0 KobenhavnKobenhavn ...
Jornada 26
16 Abr 12 AGF AarhusAGF Aarhus 1 - 1 Aalborg BKAalborg BK ...
14 Abr 12 MidtjyllandMidtjylland 2 - 0 Odense BKOdense BK ...
15 Abr 12 Lyngby BKLyngby BK 0 - 4 SonderjyskESonderjyskE ...
15 Abr 12 Køge BKKøge BK 0 - 5 KobenhavnKobenhavn ...
15 Abr 12 AC HorsensAC Horsens 2 - 0 Brøndby IFBrøndby ...
15 Abr 12 NordsjaellandNordsjaella 2 - 1 Silkeborg IFSilkeborg ...
Jornada 27
22 Abr 12 Brøndby IFBrøndby 0 - 2 MidtjyllandMidtjylland ...
21 Abr 12 Aalborg BKAalborg BK 0 - 2 NordsjaellandNordsjaella ...
22 Abr 12 Silkeborg IFSilkeborg 3 - 0 Lyngby BKLyngby BK ...
22 Abr 12 KobenhavnKobenhavn 2 - 1 AC HorsensAC Horsens ...
22 Abr 12 SonderjyskESonderjyskE 2 - 1 Køge BKKøge BK ...
23 Abr 12 Odense BKOdense BK 1 - 2 AGF AarhusAGF Aarhus ...
Jornada 28
29 Abr 12 KobenhavnKobenhavn 3 - 0 Aalborg BKAalborg BK ...
29 Abr 12 Køge BKKøge BK 2 - 1 AC HorsensAC Horsens ...
30 Abr 12 Silkeborg IFSilkeborg 1 - 1 Odense BKOdense BK 1
28 Abr 12 NordsjaellandNordsjaella 5 - 3 AGF AarhusAGF Aarhus ...
29 Abr 12 SonderjyskESonderjyskE 3 - 3 Brøndby IFBrøndby ...
29 Abr 12 Lyngby BKLyngby BK 1 - 2 MidtjyllandMidtjylland ...
Jornada 29
02 May 12 NordsjaellandNordsjaella 1 - 0 KobenhavnKobenhavn ...
03 May 12 Brøndby IFBrøndby 3 - 2 Silkeborg IFSilkeborg ...
03 May 12 AC HorsensAC Horsens 5 - 0 SonderjyskESonderjyskE ...
03 May 12 MidtjyllandMidtjylland 2 - 1 Køge BKKøge BK ...
02 May 12 AGF AarhusAGF Aarhus 2 - 1 Lyngby BKLyngby BK ...
03 May 12 Odense BKOdense BK 1 - 2 Aalborg BKAalborg BK ...
Jornada 30
06 May 12 Silkeborg IFSilkeborg 0 - 1 AC HorsensAC Horsens ...
06 May 12 Køge BKKøge BK 1 - 3 AGF AarhusAGF Aarhus ...
06 May 12 KobenhavnKobenhavn 1 - 1 Odense BKOdense BK ...
06 May 12 Aalborg BKAalborg BK 1 - 0 Brøndby IFBrøndby ...
05 May 12 Lyngby BKLyngby BK 0 - 2 NordsjaellandNordsjaella ...
07 May 12 SonderjyskESonderjyskE 1 - 1 MidtjyllandMidtjylland ...
Jornada 31
13 May 12 SonderjyskESonderjyskE 2 - 2 KobenhavnKobenhavn ...
13 May 12 Lyngby BKLyngby BK 3 - 2 Aalborg BKAalborg BK ...
14 May 12 NordsjaellandNordsjaella 0 - 0 Odense BKOdense BK ...
12 May 12 AC HorsensAC Horsens 2 - 1 MidtjyllandMidtjylland ...
13 May 12 Køge BKKøge BK 1 - 3 Silkeborg IFSilkeborg ...
13 May 12 AGF AarhusAGF Aarhus 5 - 1 Brøndby IFBrøndby ...
Jornada 32
20 May 12 MidtjyllandMidtjylland 1 - 0 KobenhavnKobenhavn ...
20 May 12 Silkeborg IFSilkeborg 1 - 1 SonderjyskESonderjyskE ...
20 May 12 AC HorsensAC Horsens 3 - 1 AGF AarhusAGF Aarhus ...
20 May 12 Brøndby IFBrøndby 0 - 1 NordsjaellandNordsjaella ...
20 May 12 Aalborg BKAalborg BK 1 - 0 Køge BKKøge BK ...
20 May 12 Odense BKOdense BK 4 - 0 Lyngby BKLyngby BK ...
Jornada 33
23 May 12 NordsjaellandNordsjaella 3 - 0 AC HorsensAC Horsens 1
23 May 12 Lyngby BKLyngby BK 1 - 0 Brøndby IFBrøndby 2
23 May 12 SonderjyskESonderjyskE 5 - 0 Aalborg BKAalborg BK 1
23 May 12 Køge BKKøge BK 1 - 1 Odense BKOdense BK 1
23 May 12 KobenhavnKobenhavn 2 - 1 Silkeborg IFSilkeborg 1
23 May 12 AGF AarhusAGF Aarhus 0 - 2 MidtjyllandMidtjylland 1

Clasificación

Equipo PJ GF GC Puntos
1 Nordsjaelland Nordsjaellan 33 49 22 68
2 Kobenhavn Kobenhavn 33 55 26 66
3 Midtjylland Midtjylland 33 50 40 58
4 AC Horsens AC Horsens 33 53 39 57
5 AGF Aarhus AGF Aarhus 33 47 40 48
6 SonderjyskE SonderjyskE 33 48 51 44
7 Aalborg BK Aalborg BK 33 42 48 44
8 Silkeborg IF Silkeborg 33 51 47 43
9 Brøndby IF Brøndby IF 33 35 46 36
10 Odense BK Odense BK 33 46 50 34
11 Lyngby BK Lyngby BK 33 32 60 28
12 Køge BK Køge BK 33 32 71 19

  USO DE MEMORIA  
6,316,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3973
Total Execution Time  0.3991
  CADENA URL  
/dinamarca2012/grupo1/calendario
  GET DATOS  
$_GET['/dinamarca2012/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0125  SELECT type FROM routes WHERE alias = 'dinamarca2012'
0.0255  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'dinamarca' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13 AND type_rel = 3
0.0132  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 13 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (1306083,1303988,1294370,1279491,1277888) ORDER BY n.cover_points DESC, update_date DESC
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=13 ORDER BY order_id ASC
0.0127  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 = 1360 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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 calendars2012 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 1360 ORDER BY round ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 20:54: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=2 AND last_update > '2024-05-03 20:54:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 20:54: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=3 AND last_update > '2024-05-03 20:54:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'dinamarca' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0203  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 events2012 e ON e.player_id = p.id AND e.league_id = 1360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1360 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.0320  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 events2012 e ON e.player_id = p.id AND e.league_id = 1360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1360 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0131  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 events2012 e ON e.player_id = p.id AND e.league_id = 1360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1360 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(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 = 1360 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC