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

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

Superliga Danesa 2013

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

Clasificación

Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 62 32 65
2 Nordsjaelland Nordsjaellan 33 60 37 60
3 Randers Randers 33 36 42 52
4 Esbjerg Esbjerg 33 38 32 47
5 Aalborg BK Aalborg BK 33 51 46 47
6 Midtjylland Midtjylland 33 51 47 47
7 AGF Aarhus AGF Aarhus 33 50 49 41
8 SonderjyskE SonderjyskE 33 53 57 41
9 Brøndby IF Brøndby IF 33 39 45 39
10 Odense BK Odense BK 33 52 59 38
11 AC Horsens AC Horsens 33 31 49 34
12 Silkeborg IF Silkeborg 33 38 66 31

  USO DE MEMORIA  
6,311,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1729
Total Execution Time  0.1748
  CADENA URL  
/dinamarca2013/grupo1/calendario
  GET DATOS  
$_GET['/dinamarca2013/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13 AND type_rel = 3
0.0033  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.0025  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.0020  SELECT id,name,alias,stepParent FROM categories WHERE parentId=13 ORDER BY order_id ASC
0.0055  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 calendars2013 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 2019 ORDER BY round ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 16:06:37' 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=2 AND last_update > '2024-04-30 16:06:37' 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=4 AND last_update > '2024-04-30 16:06:37' 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=3 AND last_update > '2024-04-30 16:06:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0307  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 events2013 e ON e.player_id = p.id AND e.league_id = 2019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2019 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.0304  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 events2013 e ON e.player_id = p.id AND e.league_id = 2019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2019 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025  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 events2013 e ON e.player_id = p.id AND e.league_id = 2019 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2019 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  SELECT *,(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 = 2019 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC