4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
08 Ago 20 Grorud IIGrorud II Apl Lorenskog IFLorenskog ...
08 Ago 20 Lillestrom IILillestrom Apl BrumunddalBrumunddal ...
08 Ago 20 Nybergsund IL-TrysilNybergsund Apl Kongsvinger IIKongsvinger ...
08 Ago 20 Funnefoss / VormsundFunnefoss Apl ElverumElverum ...
11 Ago 20 Raufoss IIRaufoss II Apl GjelleråsenGjelleråse ...
08 Ago 20 Ullensaker/Kisa IIUllensaker/ Apl Gjøvik-LynGjøvik-Lyn ...
08 Ago 20 Rommen SKRommen SK Apl TotenToten ...
Ver jornada
Jornada 2
15 Ago 20 Kongsvinger IIKongsvinger Apl Rommen SKRommen SK ...
15 Ago 20 GjelleråsenGjelleråse Apl Funnefoss / VormsundFunnefoss ...
15 Ago 20 TotenToten Apl Nybergsund IL-TrysilNybergsund ...
15 Ago 20 ElverumElverum Apl Raufoss IIRaufoss II ...
15 Ago 20 Gjøvik-LynGjøvik-Lyn Apl Lillestrom IILillestrom ...
15 Ago 20 BrumunddalBrumunddal Apl Grorud IIGrorud II ...
15 Ago 20 Lorenskog IFLorenskog Apl Ullensaker/Kisa IIUllensaker/ ...
Ver jornada
Jornada 3
22 Ago 20 Nybergsund IL-TrysilNybergsund Apl Lorenskog IFLorenskog ...
25 Ago 20 Grorud IIGrorud II Apl GjelleråsenGjelleråse ...
22 Ago 20 Funnefoss / VormsundFunnefoss Apl Gjøvik-LynGjøvik-Lyn ...
22 Ago 20 Raufoss IIRaufoss II Apl TotenToten ...
22 Ago 20 Ullensaker/Kisa IIUllensaker/ Apl ElverumElverum ...
22 Ago 20 Rommen SKRommen SK Apl BrumunddalBrumunddal ...
22 Ago 20 Lillestrom IILillestrom Apl Kongsvinger IIKongsvinger ...
Ver jornada
Jornada 4
29 Ago 20 BrumunddalBrumunddal Apl Nybergsund IL-TrysilNybergsund ...
29 Ago 20 Kongsvinger IIKongsvinger Apl Grorud IIGrorud II ...
29 Ago 20 GjelleråsenGjelleråse Apl Ullensaker/Kisa IIUllensaker/ ...
29 Ago 20 ElverumElverum Apl Lillestrom IILillestrom ...
29 Ago 20 TotenToten Apl Funnefoss / VormsundFunnefoss ...
29 Ago 20 Lorenskog IFLorenskog Apl Rommen SKRommen SK ...
29 Ago 20 Gjøvik-LynGjøvik-Lyn Apl Raufoss IIRaufoss II ...
Ver jornada
Jornada 5
05 Sep 20 TotenToten Apl Gjøvik-LynGjøvik-Lyn ...
05 Sep 20 Kongsvinger IIKongsvinger Apl BrumunddalBrumunddal ...
05 Sep 20 Funnefoss / VormsundFunnefoss Apl Ullensaker/Kisa IIUllensaker/ ...
05 Sep 20 Rommen SKRommen SK Apl Lillestrom IILillestrom ...
06 Sep 20 Nybergsund IL-TrysilNybergsund Apl GjelleråsenGjelleråse ...
05 Sep 20 Grorud IIGrorud II Apl Raufoss IIRaufoss II ...
05 Sep 20 Lorenskog IFLorenskog Apl ElverumElverum ...
Ver jornada
Jornada 6
12 Sep 20 ElverumElverum Apl Kongsvinger IIKongsvinger ...
12 Sep 20 Lillestrom IILillestrom Apl Nybergsund IL-TrysilNybergsund ...
12 Sep 20 GjelleråsenGjelleråse Apl TotenToten ...
12 Sep 20 BrumunddalBrumunddal Apl Lorenskog IFLorenskog ...
12 Sep 20 Raufoss IIRaufoss II Apl Funnefoss / VormsundFunnefoss ...
12 Sep 20 Gjøvik-LynGjøvik-Lyn Apl Grorud IIGrorud II ...
12 Sep 20 Ullensaker/Kisa IIUllensaker/ Apl Rommen SKRommen SK ...
Ver jornada
Jornada 7
19 Sep 20 Grorud IIGrorud II Apl Lillestrom IILillestrom ...
19 Sep 20 Lorenskog IFLorenskog Apl Funnefoss / VormsundFunnefoss ...
19 Sep 20 Kongsvinger IIKongsvinger Apl Raufoss IIRaufoss II ...
19 Sep 20 Gjøvik-LynGjøvik-Lyn Apl GjelleråsenGjelleråse ...
19 Sep 20 Nybergsund IL-TrysilNybergsund Apl Rommen SKRommen SK ...
19 Sep 20 BrumunddalBrumunddal Apl Ullensaker/Kisa IIUllensaker/ ...
19 Sep 20 TotenToten Apl ElverumElverum ...
Ver jornada
Jornada 8
26 Sep 20 Rommen SKRommen SK Apl Grorud IIGrorud II ...
26 Sep 20 Raufoss IIRaufoss II Apl BrumunddalBrumunddal ...
26 Sep 20 GjelleråsenGjelleråse Apl Kongsvinger IIKongsvinger ...
26 Sep 20 Lillestrom IILillestrom Apl Lorenskog IFLorenskog ...
26 Sep 20 Funnefoss / VormsundFunnefoss Apl Nybergsund IL-TrysilNybergsund ...
26 Sep 20 ElverumElverum Apl Gjøvik-LynGjøvik-Lyn ...
26 Sep 20 Ullensaker/Kisa IIUllensaker/ Apl TotenToten ...
Ver jornada
Jornada 9
03 Oct 20 ElverumElverum Apl GjelleråsenGjelleråse ...
03 Oct 20 Nybergsund IL-TrysilNybergsund Apl Grorud IIGrorud II ...
03 Oct 20 Ullensaker/Kisa IIUllensaker/ Apl Raufoss IIRaufoss II ...
03 Oct 20 Lorenskog IFLorenskog Apl Kongsvinger IIKongsvinger ...
03 Oct 20 TotenToten Apl Lillestrom IILillestrom ...
03 Oct 20 BrumunddalBrumunddal Apl Funnefoss / VormsundFunnefoss ...
03 Oct 20 Gjøvik-LynGjøvik-Lyn Apl Rommen SKRommen SK ...
Ver jornada
Jornada 10
10 Oct 20 Grorud IIGrorud II Apl Funnefoss / VormsundFunnefoss ...
10 Oct 20 BrumunddalBrumunddal Apl Gjøvik-LynGjøvik-Lyn ...
10 Oct 20 Lillestrom IILillestrom Apl Ullensaker/Kisa IIUllensaker/ ...
10 Oct 20 Rommen SKRommen SK Apl GjelleråsenGjelleråse ...
10 Oct 20 Kongsvinger IIKongsvinger Apl TotenToten ...
10 Oct 20 Lorenskog IFLorenskog Apl Raufoss IIRaufoss II ...
10 Oct 20 Nybergsund IL-TrysilNybergsund Apl ElverumElverum ...
Ver jornada
Jornada 11
17 Oct 20 Gjøvik-LynGjøvik-Lyn Apl Lorenskog IFLorenskog ...
17 Oct 20 ElverumElverum Apl BrumunddalBrumunddal ...
17 Oct 20 GjelleråsenGjelleråse Apl Lillestrom IILillestrom ...
17 Oct 20 TotenToten Apl Grorud IIGrorud II ...
17 Oct 20 Raufoss IIRaufoss II Apl Rommen SKRommen SK ...
17 Oct 20 Funnefoss / VormsundFunnefoss Apl Kongsvinger IIKongsvinger ...
17 Oct 20 Ullensaker/Kisa IIUllensaker/ Apl Nybergsund IL-TrysilNybergsund ...
Ver jornada
Jornada 12
24 Oct 20 Lorenskog IFLorenskog Apl GjelleråsenGjelleråse ...
24 Oct 20 Rommen SKRommen SK Apl Funnefoss / VormsundFunnefoss ...
24 Oct 20 Nybergsund IL-TrysilNybergsund Apl Gjøvik-LynGjøvik-Lyn ...
24 Oct 20 BrumunddalBrumunddal Apl TotenToten ...
24 Oct 20 Lillestrom IILillestrom Apl Raufoss IIRaufoss II ...
24 Oct 20 Grorud IIGrorud II Apl ElverumElverum ...
24 Oct 20 Kongsvinger IIKongsvinger Apl Ullensaker/Kisa IIUllensaker/ ...
Ver jornada
Jornada 13
31 Oct 20 Ullensaker/Kisa IIUllensaker/ Apl Grorud IIGrorud II ...
31 Oct 20 Raufoss IIRaufoss II Apl Nybergsund IL-TrysilNybergsund ...
31 Oct 20 GjelleråsenGjelleråse Apl BrumunddalBrumunddal ...
31 Oct 20 TotenToten Apl Lorenskog IFLorenskog ...
31 Oct 20 Gjøvik-LynGjøvik-Lyn Apl Kongsvinger IIKongsvinger ...
31 Oct 20 Funnefoss / VormsundFunnefoss Apl Lillestrom IILillestrom ...
31 Oct 20 ElverumElverum Apl Rommen SKRommen SK ...
Ver jornada
Jornada 14
13 Jul 20 Raufoss IIRaufoss II Apl Kongsvinger IIKongsvinger ...
12 Jul 20 Funnefoss / VormsundFunnefoss Apl TotenToten ...
12 Jul 20 Gjøvik-LynGjøvik-Lyn Apl GjelleråsenGjelleråse ...
12 Jul 20 Grorud IIGrorud II Apl Lillestrom IILillestrom ...
12 Jul 20 Ullensaker/Kisa IIUllensaker/ Apl Nybergsund IL-TrysilNybergsund ...
11 Jul 20 BrumunddalBrumunddal Apl Lorenskog IFLorenskog ...
11 Jul 20 Rommen SKRommen SK Apl ElverumElverum ...
Ver jornada
Jornada 15
11 Ago 20 Lorenskog IFLorenskog Apl Raufoss IIRaufoss II ...
10 Ago 20 Lillestrom IILillestrom Apl Ullensaker/Kisa IIUllensaker/ ...
19 Jul 20 ElverumElverum Apl BrumunddalBrumunddal ...
18 Jul 20 GjelleråsenGjelleråse Apl Rommen SKRommen SK ...
18 Jul 20 Kongsvinger IIKongsvinger Apl Grorud IIGrorud II ...
18 Jul 20 Nybergsund IL-TrysilNybergsund Apl Funnefoss / VormsundFunnefoss ...
18 Jul 20 TotenToten Apl Gjøvik-LynGjøvik-Lyn ...
Ver jornada
Jornada 16
17 Ago 20 BrumunddalBrumunddal Apl Raufoss IIRaufoss II ...
17 Ago 20 Funnefoss / VormsundFunnefoss Apl Lillestrom IILillestrom ...
17 Ago 20 Grorud IIGrorud II Apl ElverumElverum ...
17 Ago 20 Rommen SKRommen SK Apl Kongsvinger IIKongsvinger ...
17 Ago 20 Ullensaker/Kisa IIUllensaker/ Apl TotenToten ...
15 Ago 20 GjelleråsenGjelleråse Apl Nybergsund IL-TrysilNybergsund ...
15 Ago 20 Gjøvik-LynGjøvik-Lyn Apl Lorenskog IFLorenskog ...
Ver jornada
Jornada 17
24 Ago 20 ElverumElverum Apl Ullensaker/Kisa IIUllensaker/ ...
24 Ago 20 Kongsvinger IIKongsvinger Apl GjelleråsenGjelleråse ...
24 Ago 20 Lillestrom IILillestrom Apl BrumunddalBrumunddal ...
24 Ago 20 Raufoss IIRaufoss II Apl Gjøvik-LynGjøvik-Lyn ...
24 Ago 20 TotenToten Apl Grorud IIGrorud II ...
22 Ago 20 Lorenskog IFLorenskog Apl Funnefoss / VormsundFunnefoss ...
22 Ago 20 Nybergsund IL-TrysilNybergsund Apl Rommen SKRommen SK ...
Ver jornada
Jornada 18
31 Ago 20 ElverumElverum Apl Raufoss IIRaufoss II ...
31 Ago 20 Grorud IIGrorud II Apl Lorenskog IFLorenskog ...
31 Ago 20 Nybergsund IL-TrysilNybergsund Apl Kongsvinger IIKongsvinger ...
31 Ago 20 Rommen SKRommen SK Apl Lillestrom IILillestrom ...
31 Ago 20 Ullensaker/Kisa IIUllensaker/ Apl Funnefoss / VormsundFunnefoss ...
29 Ago 20 BrumunddalBrumunddal Apl Gjøvik-LynGjøvik-Lyn ...
29 Ago 20 GjelleråsenGjelleråse Apl TotenToten ...
Ver jornada
Jornada 19
07 Sep 20 Lillestrom IILillestrom Apl ElverumElverum ...
07 Sep 20 Raufoss IIRaufoss II Apl Nybergsund IL-TrysilNybergsund ...
05 Sep 20 BrumunddalBrumunddal Apl GjelleråsenGjelleråse ...
05 Sep 20 Funnefoss / VormsundFunnefoss Apl Kongsvinger IIKongsvinger ...
05 Sep 20 Gjøvik-LynGjøvik-Lyn Apl Grorud IIGrorud II ...
05 Sep 20 TotenToten Apl Rommen SKRommen SK ...
04 Sep 20 Lorenskog IFLorenskog Apl Ullensaker/Kisa IIUllensaker/ ...
Ver jornada
Jornada 20
14 Sep 20 Grorud IIGrorud II Apl BrumunddalBrumunddal ...
14 Sep 20 Kongsvinger IIKongsvinger Apl Lillestrom IILillestrom ...
14 Sep 20 Ullensaker/Kisa IIUllensaker/ Apl Raufoss IIRaufoss II ...
12 Sep 20 ElverumElverum Apl Gjøvik-LynGjøvik-Lyn ...
12 Sep 20 GjelleråsenGjelleråse Apl Funnefoss / VormsundFunnefoss ...
12 Sep 20 Nybergsund IL-TrysilNybergsund Apl TotenToten ...
12 Sep 20 Rommen SKRommen SK Apl Lorenskog IFLorenskog ...
Ver jornada
Jornada 21
21 Sep 20 Gjøvik-LynGjøvik-Lyn Apl Ullensaker/Kisa IIUllensaker/ ...
21 Sep 20 Lillestrom IILillestrom Apl GjelleråsenGjelleråse ...
21 Sep 20 Raufoss IIRaufoss II Apl Grorud IIGrorud II ...
21 Sep 20 TotenToten Apl Kongsvinger IIKongsvinger ...
19 Sep 20 BrumunddalBrumunddal Apl Nybergsund IL-TrysilNybergsund ...
19 Sep 20 Funnefoss / VormsundFunnefoss Apl Rommen SKRommen SK ...
19 Sep 20 Lorenskog IFLorenskog Apl ElverumElverum ...
Ver jornada
Jornada 22
28 Sep 20 Funnefoss / VormsundFunnefoss Apl Raufoss IIRaufoss II ...
28 Sep 20 Kongsvinger IIKongsvinger Apl ElverumElverum ...
28 Sep 20 Rommen SKRommen SK Apl Grorud IIGrorud II ...
28 Sep 20 Ullensaker/Kisa IIUllensaker/ Apl BrumunddalBrumunddal ...
26 Sep 20 GjelleråsenGjelleråse Apl Lorenskog IFLorenskog ...
26 Sep 20 Nybergsund IL-TrysilNybergsund Apl Gjøvik-LynGjøvik-Lyn ...
26 Sep 20 TotenToten Apl Lillestrom IILillestrom ...
Ver jornada
Jornada 23
05 Oct 20 Grorud IIGrorud II Apl Ullensaker/Kisa IIUllensaker/ ...
05 Oct 20 Lorenskog IFLorenskog Apl Kongsvinger IIKongsvinger ...
05 Oct 20 Raufoss IIRaufoss II Apl GjelleråsenGjelleråse ...
03 Oct 20 BrumunddalBrumunddal Apl Rommen SKRommen SK ...
03 Oct 20 ElverumElverum Apl TotenToten ...
03 Oct 20 Gjøvik-LynGjøvik-Lyn Apl Funnefoss / VormsundFunnefoss ...
03 Oct 20 Lillestrom IILillestrom Apl Nybergsund IL-TrysilNybergsund ...
Ver jornada
Jornada 24
12 Oct 20 Lillestrom IILillestrom Apl Gjøvik-LynGjøvik-Lyn ...
10 Oct 20 Funnefoss / VormsundFunnefoss Apl ElverumElverum ...
10 Oct 20 GjelleråsenGjelleråse Apl Grorud IIGrorud II ...
10 Oct 20 Kongsvinger IIKongsvinger Apl BrumunddalBrumunddal ...
10 Oct 20 Nybergsund IL-TrysilNybergsund Apl Lorenskog IFLorenskog ...
10 Oct 20 TotenToten Apl Raufoss IIRaufoss II ...
08 Oct 20 Rommen SKRommen SK Apl Ullensaker/Kisa IIUllensaker/ ...
Ver jornada
Jornada 25
17 Oct 20 BrumunddalBrumunddal Apl TotenToten ...
17 Oct 20 ElverumElverum Apl Nybergsund IL-TrysilNybergsund ...
17 Oct 20 Gjøvik-LynGjøvik-Lyn Apl Kongsvinger IIKongsvinger ...
17 Oct 20 Grorud IIGrorud II Apl Funnefoss / VormsundFunnefoss ...
17 Oct 20 Lorenskog IFLorenskog Apl Lillestrom IILillestrom ...
17 Oct 20 Raufoss IIRaufoss II Apl Rommen SKRommen SK ...
17 Oct 20 Ullensaker/Kisa IIUllensaker/ Apl GjelleråsenGjelleråse ...
Ver jornada
Jornada 26
24 Oct 20 Funnefoss / VormsundFunnefoss Apl BrumunddalBrumunddal ...
24 Oct 20 GjelleråsenGjelleråse Apl ElverumElverum ...
24 Oct 20 Kongsvinger IIKongsvinger Apl Ullensaker/Kisa IIUllensaker/ ...
24 Oct 20 Lillestrom IILillestrom Apl Raufoss IIRaufoss II ...
24 Oct 20 Nybergsund IL-TrysilNybergsund Apl Grorud IIGrorud II ...
24 Oct 20 Rommen SKRommen SK Apl Gjøvik-LynGjøvik-Lyn ...
24 Oct 20 TotenToten Apl Lorenskog IFLorenskog ...

Clasificación

Equipo PJ GF GC Puntos
1 Brumunddal Brumunddal 0 0 0 0
2 Elverum Elverum 0 0 0 0
3 Funnefoss / Vormsund Funnefoss 0 0 0 0
4 Gjelleråsen Gjelleråsen 0 0 0 0
5 Gjøvik-Lyn Gjøvik-Lyn 0 0 0 0
6 Grorud II Grorud II 0 0 0 0
7 Kongsvinger II Kongsvinger 0 0 0 0
8 Lillestrom II Lillestrom 0 0 0 0
9 Lorenskog IF Lorenskog 0 0 0 0
10 Nybergsund IL-Trysil Nybergsund 0 0 0 0
11 Raufoss II Raufoss II 0 0 0 0
12 Rommen SK Rommen SK 0 0 0 0
13 Toten Toten 0 0 0 0
14 Ullensaker/Kisa II Ullensaker/K 0 0 0 0

  USO DE MEMORIA  
5,931,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1107
Total Execution Time  0.1127
  CADENA URL  
/cuarta_noruega2020/grupo1/calendario
  GET DATOS  
$_GET['/cuarta_noruega2020/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'cuarta_noruega2020'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_noruega' 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=1937 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1937 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (694715,651476,517291) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1937 ORDER BY order_id ASC
0.0021  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1937 GROUP BY l.categoryId
0.0021  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1937 GROUP BY l.year ORDER BY l.year DESC
0.0019  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 = 53745 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0040  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 = 53745 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-05-02 07:52:42' 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-05-02 07:52:42' 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-05-02 07:52:42' 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-05-02 07:52:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_noruega' 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.0023  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 = 53745 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53745 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 = 53745 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53745 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 = 53745 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53745 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0033  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 = 53745 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC