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

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

Superliga Danesa 2009

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

Clasificación

Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 67 26 74
2 Odense BK Odense BK 33 65 31 69
3 Brøndby IF Brøndby IF 33 55 31 68
4 Midtjylland Midtjylland 33 55 46 55
5 Randers Randers 33 52 50 46
6 AGF Aarhus AGF Aarhus 33 39 44 45
7 Aalborg BK Aalborg BK 33 40 49 39
8 Nordsjaelland Nordsjaellan 33 44 53 35
9 Esbjerg Esbjerg 33 32 41 32
10 SonderjyskE SonderjyskE 33 30 56 28
11 Vejle BK Vejle BK 33 30 59 25
12 AC Horsens AC Horsens 33 35 58 24

  USO DE MEMORIA  
6,301,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3731
Total Execution Time  0.3750
  CADENA URL  
/dinamarca2009/grupo1/calendario
  GET DATOS  
$_GET['/dinamarca2009/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0124  SELECT type FROM routes WHERE alias = 'dinamarca2009'
0.0251  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 = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0126  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 = 319 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0258  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 calendars2009 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 319 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 18:24:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 18:24:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 18:24:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 18:24:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0252  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 = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0202  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 events2009 e ON e.player_id = p.id AND e.league_id = 319 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 319 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.0201  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 events2009 e ON e.player_id = p.id AND e.league_id = 319 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 319 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0175  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 events2009 e ON e.player_id = p.id AND e.league_id = 319 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 319 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0257  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 319 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC