4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2020
Temporada Siguiente »
Superliga Danesa 2020 G 1
2019/2020

Temporada Regular

Superliga Danesa 2020 G 1

  • Midtjylland
  • Kobenhavn
  • AGF Aarhus
  • Brøndby IF
  • Nordsjaelland
  • Aalborg BK
  • Randers
  • AC Horsens
  • Odense BK
  • Lyngby BK
  • SonderjyskE
  • Hobro
  • Esbjerg
  • Silkeborg IF
Ver jornada
Jornada 1
14 Jul 19 SonderjyskESonderjyskE 2 - 1 RandersRanders 2
12 Jul 19 MidtjyllandMidtjylland 1 - 0 EsbjergEsbjerg 75
14 Jul 19 Brøndby IFBrøndby 3 - 0 Silkeborg IFSilkeborg 2
14 Jul 19 Odense BKOdense BK 2 - 3 KobenhavnKobenhavn 18
14 Jul 19 AC HorsensAC Horsens 0 - 3 NordsjaellandNordsjaella 2
15 Jul 19 HobroHobro 1 - 1 AGF AarhusAGF Aarhus 23
14 Jul 19 Lyngby BKLyngby BK 2 - 0 Aalborg BKAalborg BK 3
Ver jornada
Jornada 2
19 Jul 19 KobenhavnKobenhavn 2 - 1 AGF AarhusAGF Aarhus 6
21 Jul 19 MidtjyllandMidtjylland 2 - 1 NordsjaellandNordsjaella 6
21 Jul 19 Aalborg BKAalborg BK 1 - 1 SonderjyskESonderjyskE 2
21 Jul 19 RandersRanders 2 - 2 Brøndby IFBrøndby 4
22 Jul 19 Odense BKOdense BK 4 - 1 Lyngby BKLyngby BK 21
21 Jul 19 EsbjergEsbjerg 1 - 1 HobroHobro 2
21 Jul 19 Silkeborg IFSilkeborg 0 - 3 AC HorsensAC Horsens 4
Ver jornada
Jornada 3
28 Jul 19 Brøndby IFBrøndby 3 - 2 Odense BKOdense BK 6
29 Jul 19 Aalborg BKAalborg BK 3 - 1 Silkeborg IFSilkeborg 7
27 Jul 19 AC HorsensAC Horsens 0 - 2 KobenhavnKobenhavn 1
28 Jul 19 NordsjaellandNordsjaella 2 - 0 EsbjergEsbjerg 18
28 Jul 19 AGF AarhusAGF Aarhus 0 - 1 MidtjyllandMidtjylland 11
28 Jul 19 HobroHobro 2 - 2 RandersRanders ...
26 Jul 19 Lyngby BKLyngby BK 0 - 3 SonderjyskESonderjyskE ...
Ver jornada
Jornada 4
03 Ago 19 SonderjyskESonderjyskE 1 - 2 KobenhavnKobenhavn 7
04 Ago 19 MidtjyllandMidtjylland 1 - 0 Aalborg BKAalborg BK 22
04 Ago 19 Brøndby IFBrøndby 1 - 2 AC HorsensAC Horsens 24
04 Ago 19 RandersRanders 3 - 1 NordsjaellandNordsjaella 9
04 Ago 19 EsbjergEsbjerg 0 - 1 Odense BKOdense BK 4
05 Ago 19 Lyngby BKLyngby BK 2 - 1 AGF AarhusAGF Aarhus 11
02 Ago 19 Silkeborg IFSilkeborg 2 - 3 HobroHobro ...
Ver jornada
Jornada 5
09 Ago 19 KobenhavnKobenhavn 2 - 0 Lyngby BKLyngby BK 84
12 Ago 19 SonderjyskESonderjyskE 0 - 0 AGF AarhusAGF Aarhus 19
11 Ago 19 Aalborg BKAalborg BK 4 - 0 EsbjergEsbjerg 3
09 Ago 19 Odense BKOdense BK 1 - 0 RandersRanders 4
11 Ago 19 AC HorsensAC Horsens 0 - 2 MidtjyllandMidtjylland 7
11 Ago 19 NordsjaellandNordsjaella 2 - 2 Silkeborg IFSilkeborg 11
11 Ago 19 HobroHobro 0 - 2 Brøndby IFBrøndby 4
Ver jornada
Jornada 6
18 Ago 19 MidtjyllandMidtjylland 1 - 1 HobroHobro 24
18 Ago 19 Brøndby IFBrøndby 2 - 1 Aalborg BKAalborg BK 4
16 Ago 19 RandersRanders 0 - 1 KobenhavnKobenhavn 78
16 Ago 19 NordsjaellandNordsjaella 2 - 0 Odense BKOdense BK 12
19 Ago 19 AGF AarhusAGF Aarhus 2 - 0 AC HorsensAC Horsens 10
18 Ago 19 EsbjergEsbjerg 1 - 0 Lyngby BKLyngby BK 2
18 Ago 19 Silkeborg IFSilkeborg 3 - 3 SonderjyskESonderjyskE 6
Ver jornada
Jornada 7
25 Ago 19 KobenhavnKobenhavn 3 - 1 NordsjaellandNordsjaella 4
25 Ago 19 SonderjyskESonderjyskE 0 - 2 MidtjyllandMidtjylland 2
25 Ago 19 Brøndby IFBrøndby 0 - 3 AGF AarhusAGF Aarhus 1
26 Ago 19 AC HorsensAC Horsens 0 - 5 Aalborg BKAalborg BK 7
23 Ago 19 HobroHobro 0 - 0 Odense BKOdense BK 4
25 Ago 19 EsbjergEsbjerg 2 - 2 Silkeborg IFSilkeborg 2
25 Ago 19 Lyngby BKLyngby BK 2 - 0 RandersRanders 12
Ver jornada
Jornada 8
01 Sep 19 MidtjyllandMidtjylland 1 - 0 Brøndby IFBrøndby 4
01 Sep 19 Aalborg BKAalborg BK 1 - 0 KobenhavnKobenhavn 4
01 Sep 19 RandersRanders 2 - 0 Silkeborg IFSilkeborg 3
30 Ago 19 Odense BKOdense BK 0 - 0 SonderjyskESonderjyskE 2
01 Sep 19 AC HorsensAC Horsens 2 - 1 Lyngby BKLyngby BK ...
31 Ago 19 NordsjaellandNordsjaella 2 - 1 HobroHobro 2
01 Sep 19 AGF AarhusAGF Aarhus 1 - 0 EsbjergEsbjerg ...
Ver jornada
Jornada 9
13 Sep 19 SonderjyskESonderjyskE 0 - 0 AC HorsensAC Horsens 7
15 Sep 19 Brøndby IFBrøndby 4 - 2 NordsjaellandNordsjaella 2
15 Sep 19 AGF AarhusAGF Aarhus 3 - 0 Aalborg BKAalborg BK 1
15 Sep 19 HobroHobro 2 - 1 KobenhavnKobenhavn 5
15 Sep 19 EsbjergEsbjerg 0 - 3 RandersRanders ...
15 Sep 19 Lyngby BKLyngby BK 0 - 3 MidtjyllandMidtjylland 3
16 Sep 19 Silkeborg IFSilkeborg 0 - 3 Odense BKOdense BK 1
Ver jornada
Jornada 10
22 Sep 19 KobenhavnKobenhavn 0 - 0 MidtjyllandMidtjylland 7
23 Sep 19 RandersRanders 2 - 1 AC HorsensAC Horsens 10
20 Sep 19 Odense BKOdense BK 1 - 2 AGF AarhusAGF Aarhus 2
22 Sep 19 NordsjaellandNordsjaella 2 - 1 Aalborg BKAalborg BK ...
22 Sep 19 HobroHobro 1 - 1 SonderjyskESonderjyskE 2
22 Sep 19 EsbjergEsbjerg 3 - 1 Brøndby IFBrøndby 5
22 Sep 19 Silkeborg IFSilkeborg 2 - 3 Lyngby BKLyngby BK ...
Ver jornada
Jornada 11
28 Sep 19 KobenhavnKobenhavn 4 - 2 Silkeborg IFSilkeborg 2
29 Sep 19 SonderjyskESonderjyskE 2 - 1 Brøndby IFBrøndby 1
29 Sep 19 MidtjyllandMidtjylland 0 - 1 Odense BKOdense BK 10
29 Sep 19 Aalborg BKAalborg BK 0 - 3 RandersRanders 1
30 Sep 19 AC HorsensAC Horsens 1 - 1 EsbjergEsbjerg 3
29 Sep 19 AGF AarhusAGF Aarhus 3 - 1 NordsjaellandNordsjaella 1
27 Sep 19 Lyngby BKLyngby BK 2 - 1 HobroHobro 7
Ver jornada
Jornada 12
06 Oct 19 Brøndby IFBrøndby 3 - 1 KobenhavnKobenhavn 5
06 Oct 19 RandersRanders 2 - 0 AGF AarhusAGF Aarhus 1
06 Oct 19 Odense BKOdense BK 3 - 0 AC HorsensAC Horsens ...
04 Oct 19 NordsjaellandNordsjaella 1 - 1 Lyngby BKLyngby BK 4
05 Oct 19 HobroHobro 0 - 2 Aalborg BKAalborg BK ...
06 Oct 19 EsbjergEsbjerg 1 - 2 SonderjyskESonderjyskE 2
06 Oct 19 Silkeborg IFSilkeborg 1 - 2 MidtjyllandMidtjylland ...
Ver jornada
Jornada 13
20 Oct 19 KobenhavnKobenhavn 3 - 1 EsbjergEsbjerg 1
20 Oct 19 SonderjyskESonderjyskE 1 - 4 NordsjaellandNordsjaella ...
21 Oct 19 MidtjyllandMidtjylland 2 - 1 RandersRanders 13
18 Oct 19 Aalborg BKAalborg BK 1 - 0 Odense BKOdense BK 14
20 Oct 19 AC HorsensAC Horsens 1 - 0 HobroHobro 5
20 Oct 19 AGF AarhusAGF Aarhus 3 - 4 Silkeborg IFSilkeborg 1
20 Oct 19 Lyngby BKLyngby BK 0 - 3 Brøndby IFBrøndby ...
Ver jornada
Jornada 14
27 Oct 19 SonderjyskESonderjyskE 1 - 3 Aalborg BKAalborg BK 1
27 Oct 19 Brøndby IFBrøndby 5 - 2 RandersRanders 3
27 Oct 19 Odense BKOdense BK 3 - 1 NordsjaellandNordsjaella ...
28 Oct 19 AGF AarhusAGF Aarhus 1 - 2 KobenhavnKobenhavn 22
27 Oct 19 HobroHobro 1 - 1 Silkeborg IFSilkeborg ...
25 Oct 19 EsbjergEsbjerg 1 - 2 MidtjyllandMidtjylland 15
27 Oct 19 Lyngby BKLyngby BK 2 - 1 AC HorsensAC Horsens 1
Ver jornada
Jornada 15
03 Nov 19 KobenhavnKobenhavn 3 - 0 SonderjyskESonderjyskE 5
03 Nov 19 Aalborg BKAalborg BK 0 - 1 MidtjyllandMidtjylland 2
03 Nov 19 RandersRanders 2 - 1 Lyngby BKLyngby BK ...
03 Nov 19 Odense BKOdense BK 2 - 1 HobroHobro ...
03 Nov 19 NordsjaellandNordsjaella 0 - 1 AGF AarhusAGF Aarhus 1
01 Nov 19 EsbjergEsbjerg 1 - 1 AC HorsensAC Horsens 8
04 Nov 19 Silkeborg IFSilkeborg 0 - 1 Brøndby IFBrøndby 12
Ver jornada
Jornada 16
10 Nov 19 MidtjyllandMidtjylland 4 - 1 KobenhavnKobenhavn 8
10 Nov 19 Brøndby IFBrøndby 2 - 1 EsbjergEsbjerg 2
08 Nov 19 RandersRanders 3 - 3 Aalborg BKAalborg BK 3
09 Nov 19 AC HorsensAC Horsens 2 - 1 Silkeborg IFSilkeborg ...
10 Nov 19 AGF AarhusAGF Aarhus 4 - 2 SonderjyskESonderjyskE ...
10 Nov 19 HobroHobro 2 - 2 NordsjaellandNordsjaella 1
10 Nov 19 Lyngby BKLyngby BK 4 - 3 Odense BKOdense BK ...
Ver jornada
Jornada 17
24 Nov 19 KobenhavnKobenhavn 2 - 1 HobroHobro 29
24 Nov 19 SonderjyskESonderjyskE 2 - 2 Lyngby BKLyngby BK 2
24 Nov 19 Aalborg BKAalborg BK 4 - 0 AC HorsensAC Horsens 3
25 Nov 19 Odense BKOdense BK 1 - 2 MidtjyllandMidtjylland 22
22 Nov 19 NordsjaellandNordsjaella 3 - 0 RandersRanders 20
24 Nov 19 AGF AarhusAGF Aarhus 2 - 1 Brøndby IFBrøndby 2
24 Nov 19 Silkeborg IFSilkeborg 1 - 2 EsbjergEsbjerg ...
Ver jornada
Jornada 18
01 Dic 19 KobenhavnKobenhavn 2 - 1 Brøndby IFBrøndby 4
02 Dic 19 MidtjyllandMidtjylland 2 - 1 Silkeborg IFSilkeborg 28
01 Dic 19 Aalborg BKAalborg BK 1 - 1 HobroHobro 2
01 Dic 19 RandersRanders 3 - 0 SonderjyskESonderjyskE 2
01 Dic 19 AC HorsensAC Horsens 2 - 1 Odense BKOdense BK ...
01 Dic 19 EsbjergEsbjerg 1 - 2 AGF AarhusAGF Aarhus 1
29 Nov 19 Lyngby BKLyngby BK 1 - 1 NordsjaellandNordsjaella 16
Ver jornada
Jornada 19
08 Dic 19 SonderjyskESonderjyskE 2 - 1 EsbjergEsbjerg 2
08 Dic 19 Brøndby IFBrøndby 1 - 2 MidtjyllandMidtjylland 10
09 Dic 19 Odense BKOdense BK 0 - 0 Aalborg BKAalborg BK 83
08 Dic 19 NordsjaellandNordsjaella 0 - 1 KobenhavnKobenhavn 7
08 Dic 19 AGF AarhusAGF Aarhus 1 - 1 Lyngby BKLyngby BK 6
06 Dic 19 HobroHobro 0 - 0 AC HorsensAC Horsens 4
08 Dic 19 Silkeborg IFSilkeborg 2 - 1 RandersRanders 1
Ver jornada
Jornada 20
16 Dic 19 KobenhavnKobenhavn 2 - 1 Odense BKOdense BK 152
15 Dic 19 MidtjyllandMidtjylland 1 - 3 AGF AarhusAGF Aarhus 11
15 Dic 19 Brøndby IFBrøndby 1 - 1 HobroHobro 3
13 Dic 19 Aalborg BKAalborg BK 1 - 3 NordsjaellandNordsjaella 22
15 Dic 19 RandersRanders 3 - 0 EsbjergEsbjerg ...
15 Dic 19 AC HorsensAC Horsens 2 - 1 SonderjyskESonderjyskE 1
15 Dic 19 Lyngby BKLyngby BK 1 - 0 Silkeborg IFSilkeborg 1
Ver jornada
Jornada 21
16 Feb 20 SonderjyskESonderjyskE 3 - 1 HobroHobro ...
17 Feb 20 MidtjyllandMidtjylland 2 - 0 Lyngby BKLyngby BK 13
16 Feb 20 Odense BKOdense BK 0 - 2 Brøndby IFBrøndby 1
19 Feb 20 NordsjaellandNordsjaella 6 - 0 AC HorsensAC Horsens ...
28 May 20 AGF AarhusAGF Aarhus 1 - 1 RandersRanders 66
14 Feb 20 EsbjergEsbjerg 1 - 0 KobenhavnKobenhavn 38
16 Feb 20 Silkeborg IFSilkeborg 0 - 2 Aalborg BKAalborg BK 6
Ver jornada
Jornada 22
23 Feb 20 Aalborg BKAalborg BK 3 - 2 Brøndby IFBrøndby 6
23 Feb 20 RandersRanders 0 - 0 Odense BKOdense BK ...
24 Feb 20 AC HorsensAC Horsens 1 - 2 AGF AarhusAGF Aarhus 17
23 Feb 20 NordsjaellandNordsjaella 2 - 1 SonderjyskESonderjyskE 2
21 Feb 20 HobroHobro 0 - 2 MidtjyllandMidtjylland 15
23 Feb 20 Lyngby BKLyngby BK 2 - 0 EsbjergEsbjerg ...
23 Feb 20 Silkeborg IFSilkeborg 1 - 1 KobenhavnKobenhavn 14
Ver jornada
Jornada 23
01 Mar 20 KobenhavnKobenhavn 3 - 2 Aalborg BKAalborg BK 7
02 Mar 20 MidtjyllandMidtjylland 3 - 0 SonderjyskESonderjyskE 14
01 Mar 20 Brøndby IFBrøndby 1 - 0 Lyngby BKLyngby BK 1
01 Mar 20 Odense BKOdense BK 1 - 1 Silkeborg IFSilkeborg ...
01 Mar 20 AC HorsensAC Horsens 1 - 2 RandersRanders ...
28 Feb 20 AGF AarhusAGF Aarhus 0 - 0 HobroHobro 16
29 Feb 20 EsbjergEsbjerg 1 - 2 NordsjaellandNordsjaella ...
Ver jornada
Jornada 24
08 Mar 20 KobenhavnKobenhavn 0 - 1 AC HorsensAC Horsens 27
08 Mar 20 SonderjyskESonderjyskE 1 - 1 Odense BKOdense BK 1
08 Mar 20 Aalborg BKAalborg BK 3 - 0 Lyngby BKLyngby BK ...
08 Mar 20 RandersRanders 0 - 2 MidtjyllandMidtjylland 22
08 Mar 20 NordsjaellandNordsjaella 2 - 2 Brøndby IFBrøndby 5
08 Mar 20 HobroHobro 1 - 1 EsbjergEsbjerg 1
09 Mar 20 Silkeborg IFSilkeborg 2 - 1 AGF AarhusAGF Aarhus 17
Ver jornada
Jornada 25
01 Jun 20 MidtjyllandMidtjylland 0 - 1 AC HorsensAC Horsens 107
02 Jun 20 Brøndby IFBrøndby 1 - 0 SonderjyskESonderjyskE 57
01 Jun 20 RandersRanders 0 - 1 HobroHobro 95
01 Jun 20 AGF AarhusAGF Aarhus 1 - 0 Odense BKOdense BK 58
31 May 20 EsbjergEsbjerg 1 - 1 Aalborg BKAalborg BK 19
01 Jun 20 Lyngby BKLyngby BK 1 - 4 KobenhavnKobenhavn 51
29 May 20 Silkeborg IFSilkeborg 0 - 2 NordsjaellandNordsjaella 22
Ver jornada
Jornada 26
07 Jun 20 KobenhavnKobenhavn 2 - 1 RandersRanders 5
07 Jun 20 SonderjyskESonderjyskE 2 - 2 Silkeborg IFSilkeborg 1
07 Jun 20 Aalborg BKAalborg BK 2 - 3 AGF AarhusAGF Aarhus 8
07 Jun 20 Odense BKOdense BK 3 - 1 EsbjergEsbjerg 12
07 Jun 20 AC HorsensAC Horsens 3 - 2 Brøndby IFBrøndby 8
07 Jun 20 NordsjaellandNordsjaella 0 - 1 MidtjyllandMidtjylland 30
07 Jun 20 HobroHobro 2 - 2 Lyngby BKLyngby BK 3

Clasificación

Equipo PJ GF GC Puntos
1 Midtjylland Midtjylland 26 42 14 65
2 Kobenhavn Kobenhavn 26 47 29 56
3 AGF Aarhus AGF Aarhus 26 42 28 47
4 Brøndby IF Brøndby IF 26 47 37 42
5 Nordsjaelland Nordsjaellan 26 48 35 41
6 Aalborg BK Aalborg BK 26 44 33 38
7 Randers Randers 26 39 35 35
8 AC Horsens AC Horsens 26 25 44 34
9 Odense BK Odense BK 26 34 30 33
10 Lyngby BK Lyngby BK 26 31 45 32
11 SonderjyskE SonderjyskE 26 31 44 27
12 Hobro Hobro 26 25 35 23
13 Esbjerg Esbjerg 26 22 44 18
14 Silkeborg IF Silkeborg 26 31 55 16

  USO DE MEMORIA  
6,261,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1761
Total Execution Time  0.1781
  CADENA URL  
/dinamarca2020/grupo1/calendario
  GET DATOS  
$_GET['/dinamarca2020/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'dinamarca2020'
0.0044  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13 AND type_rel = 3
0.0026  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.0023  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.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=13 ORDER BY order_id ASC
0.0021  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 = 49908 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0045  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 = 49908 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-27 07:13:55' 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=2 AND last_update > '2024-04-27 07:13:55' 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=4 AND last_update > '2024-04-27 07:13:55' 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-27 07:13:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0282  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 = 49908 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49908 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.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 events2020 e ON e.player_id = p.id AND e.league_id = 49908 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49908 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  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 = 49908 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49908 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 `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 = 49908 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC