4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
25 Ago 18 Raon-l'EtapeRaon-l'Etap 2 - 2 Saint-Louis NeuwegSaint-Louis ...
25 Ago 18 FC MulhouseMulhouse 3 - 0 RC Épernay ChampagneÉpernay ...
25 Ago 18 Sarre-UnionSarre-Union 4 - 1 SarregueminesSarreguemin ...
25 Ago 18 FCA TroyesFCA Troyes 2 - 0 AmnévilleAmnéville ...
25 Ago 18 Vauban StrasbourgVauban 0 - 2 ThaonThaon ...
25 Ago 18 Strasbourg IIStrasbourg 1 - 1 Troyes IITroyes II ...
25 Ago 18 Nancy IINancy II 0 - 2 BiesheimBiesheim ...
Jornada 2
01 Sep 18 RC Épernay ChampagneÉpernay 0 - 3 Raon-l'EtapeRaon-l'Etap ...
02 Sep 18 BiesheimBiesheim 1 - 2 Strasbourg IIStrasbourg ...
01 Sep 18 SarregueminesSarreguemin 0 - 2 FCA TroyesFCA Troyes ...
01 Sep 18 ThaonThaon 1 - 0 Nancy IINancy II ...
01 Sep 18 AmnévilleAmnéville 2 - 1 FC MulhouseMulhouse ...
01 Sep 18 Troyes IITroyes II 2 - 2 Sarre-UnionSarre-Union ...
01 Sep 18 Saint-Louis NeuwegSaint-Louis 1 - 0 Vauban StrasbourgVauban ...
Jornada 3
08 Sep 18 Raon-l'EtapeRaon-l'Etap 2 - 1 AmnévilleAmnéville ...
08 Sep 18 Vauban StrasbourgVauban 3 - 2 RC Épernay ChampagneÉpernay ...
08 Sep 18 Sarre-UnionSarre-Union 1 - 0 FCA TroyesFCA Troyes ...
08 Sep 18 Troyes IITroyes II 4 - 0 BiesheimBiesheim ...
08 Sep 18 FC MulhouseMulhouse 0 - 1 SarregueminesSarreguemin ...
08 Sep 18 Strasbourg IIStrasbourg 4 - 2 ThaonThaon ...
08 Sep 18 Nancy IINancy II 2 - 2 Saint-Louis NeuwegSaint-Louis ...
Jornada 4
22 Sep 18 AmnévilleAmnéville 4 - 2 Vauban StrasbourgVauban ...
22 Sep 18 RC Épernay ChampagneÉpernay 0 - 2 Nancy IINancy II ...
22 Sep 18 ThaonThaon 0 - 0 Troyes IITroyes II ...
22 Sep 18 BiesheimBiesheim 2 - 3 Sarre-UnionSarre-Union ...
22 Sep 18 SarregueminesSarreguemin 1 - 2 Raon-l'EtapeRaon-l'Etap ...
22 Sep 18 Saint-Louis NeuwegSaint-Louis 2 - 3 Strasbourg IIStrasbourg ...
23 Sep 18 FCA TroyesFCA Troyes 0 - 1 FC MulhouseMulhouse ...
Jornada 5
06 Oct 18 BiesheimBiesheim 1 - 2 ThaonThaon ...
06 Oct 18 Raon-l'EtapeRaon-l'Etap 0 - 1 FCA TroyesFCA Troyes ...
06 Oct 18 Vauban StrasbourgVauban 3 - 3 SarregueminesSarreguemin ...
06 Oct 18 Troyes IITroyes II 2 - 1 Saint-Louis NeuwegSaint-Louis ...
06 Oct 18 Sarre-UnionSarre-Union 0 - 0 FC MulhouseMulhouse ...
07 Oct 18 Strasbourg IIStrasbourg 1 - 0 RC Épernay ChampagneÉpernay ...
06 Oct 18 Nancy IINancy II 1 - 1 AmnévilleAmnéville ...
Jornada 6
20 Oct 18 Saint-Louis NeuwegSaint-Louis 0 - 1 BiesheimBiesheim ...
20 Oct 18 RC Épernay ChampagneÉpernay 0 - 0 Troyes IITroyes II ...
20 Oct 18 SarregueminesSarreguemin 2 - 2 Nancy IINancy II ...
20 Oct 18 AmnévilleAmnéville 0 - 1 Strasbourg IIStrasbourg ...
20 Oct 18 ThaonThaon 0 - 0 Sarre-UnionSarre-Union ...
21 Oct 18 FCA TroyesFCA Troyes 3 - 1 Vauban StrasbourgVauban ...
21 Oct 18 FC MulhouseMulhouse 3 - 1 Raon-l'EtapeRaon-l'Etap ...
Jornada 7
03 Nov 18 Sarre-UnionSarre-Union 0 - 0 Raon-l'EtapeRaon-l'Etap ...
03 Nov 18 Vauban StrasbourgVauban 1 - 2 FC MulhouseMulhouse ...
03 Nov 18 ThaonThaon 2 - 2 Saint-Louis NeuwegSaint-Louis ...
03 Nov 18 Troyes IITroyes II 2 - 1 AmnévilleAmnéville ...
03 Nov 18 BiesheimBiesheim 3 - 1 RC Épernay ChampagneÉpernay ...
03 Nov 18 Nancy IINancy II 1 - 0 FCA TroyesFCA Troyes ...
04 Nov 18 Strasbourg IIStrasbourg 1 - 1 SarregueminesSarreguemin ...
Jornada 8
10 Nov 18 RC Épernay ChampagneÉpernay 2 - 2 ThaonThaon ...
10 Nov 18 SarregueminesSarreguemin 2 - 0 Troyes IITroyes II ...
10 Nov 18 AmnévilleAmnéville 3 - 1 BiesheimBiesheim ...
10 Nov 18 Saint-Louis NeuwegSaint-Louis 1 - 2 Sarre-UnionSarre-Union ...
10 Nov 18 Raon-l'EtapeRaon-l'Etap 1 - 4 Vauban StrasbourgVauban ...
11 Nov 18 FC MulhouseMulhouse 2 - 0 Nancy IINancy II ...
11 Nov 18 FCA TroyesFCA Troyes 3 - 1 Strasbourg IIStrasbourg ...
Jornada 9
20 Abr 19 BiesheimBiesheim 1 - 1 SarregueminesSarreguemin ...
02 Feb 19 Troyes IITroyes II 1 - 0 FCA TroyesFCA Troyes ...
24 Nov 18 Sarre-UnionSarre-Union 0 - 0 Vauban StrasbourgVauban ...
09 Mar 19 Saint-Louis NeuwegSaint-Louis 0 - 2 RC Épernay ChampagneÉpernay ...
24 Nov 18 ThaonThaon 3 - 1 AmnévilleAmnéville ...
24 Nov 18 Nancy IINancy II 2 - 1 Raon-l'EtapeRaon-l'Etap ...
14 Nov 18 Strasbourg IIStrasbourg 1 - 1 FC MulhouseMulhouse ...
Jornada 10
01 Dic 18 Vauban StrasbourgVauban 3 - 2 Nancy IINancy II ...
01 Dic 18 SarregueminesSarreguemin 2 - 0 ThaonThaon ...
01 Dic 18 Raon-l'EtapeRaon-l'Etap 3 - 1 Strasbourg IIStrasbourg ...
01 Dic 18 AmnévilleAmnéville 1 - 1 Saint-Louis NeuwegSaint-Louis ...
01 Dic 18 RC Épernay ChampagneÉpernay 1 - 2 Sarre-UnionSarre-Union ...
19 Ene 19 FCA TroyesFCA Troyes 2 - 1 BiesheimBiesheim ...
02 Dic 18 FC MulhouseMulhouse 3 - 2 Troyes IITroyes II ...
Jornada 11
15 Dic 18 BiesheimBiesheim 2 - 0 FC MulhouseMulhouse ...
15 Dic 18 ThaonThaon 1 - 0 FCA TroyesFCA Troyes ...
15 Dic 18 Troyes IITroyes II 3 - 0 Raon-l'EtapeRaon-l'Etap ...
15 Dic 18 Saint-Louis NeuwegSaint-Louis 3 - 1 SarregueminesSarreguemin ...
03 Feb 19 RC Épernay ChampagneÉpernay 1 - 2 AmnévilleAmnéville ...
15 Dic 18 Sarre-UnionSarre-Union 3 - 0 Nancy IINancy II ...
09 Mar 19 Vauban StrasbourgVauban 2 - 1 Strasbourg IIStrasbourg ...
Jornada 12
18 Ago 18 Vauban StrasbourgVauban 0 - 0 Troyes IITroyes II ...
18 Ago 18 FCA TroyesFCA Troyes 0 - 1 Saint-Louis NeuwegSaint-Louis ...
18 Ago 18 AmnévilleAmnéville 1 - 1 Sarre-UnionSarre-Union ...
18 Ago 18 FC MulhouseMulhouse 2 - 3 ThaonThaon ...
18 Ago 18 SarregueminesSarreguemin 2 - 2 RC Épernay ChampagneÉpernay ...
18 Ago 18 Raon-l'EtapeRaon-l'Etap 1 - 1 BiesheimBiesheim ...
18 Ago 18 Nancy IINancy II 2 - 1 Strasbourg IIStrasbourg ...
Jornada 13
29 Ago 18 RC Épernay ChampagneÉpernay 1 - 0 FCA TroyesFCA Troyes ...
29 Ago 18 Saint-Louis NeuwegSaint-Louis 0 - 0 FC MulhouseMulhouse ...
29 Ago 18 AmnévilleAmnéville 2 - 1 SarregueminesSarreguemin ...
29 Ago 18 Troyes IITroyes II 1 - 1 Nancy IINancy II ...
29 Ago 18 Sarre-UnionSarre-Union 2 - 2 Strasbourg IIStrasbourg ...
29 Ago 18 BiesheimBiesheim 0 - 2 Vauban StrasbourgVauban ...
29 Ago 18 ThaonThaon 3 - 1 Raon-l'EtapeRaon-l'Etap ...
Jornada 14
23 Feb 19 RC Épernay ChampagneÉpernay 1 - 0 FC MulhouseMulhouse ...
23 Feb 19 Saint-Louis NeuwegSaint-Louis 2 - 3 Raon-l'EtapeRaon-l'Etap ...
23 Feb 19 Troyes IITroyes II 2 - 2 Strasbourg IIStrasbourg ...
23 Feb 19 BiesheimBiesheim 3 - 1 Nancy IINancy II ...
23 Feb 19 AmnévilleAmnéville 1 - 0 FCA TroyesFCA Troyes ...
23 Feb 19 ThaonThaon 1 - 1 Vauban StrasbourgVauban ...
23 Feb 19 SarregueminesSarreguemin 4 - 0 Sarre-UnionSarre-Union ...
Jornada 15
02 Mar 19 Sarre-UnionSarre-Union 2 - 1 Troyes IITroyes II ...
02 Mar 19 Vauban StrasbourgVauban 1 - 0 Saint-Louis NeuwegSaint-Louis ...
02 Mar 19 Raon-l'EtapeRaon-l'Etap 0 - 2 RC Épernay ChampagneÉpernay ...
02 Mar 19 Nancy IINancy II 2 - 2 ThaonThaon ...
03 Mar 19 FCA TroyesFCA Troyes 2 - 2 SarregueminesSarreguemin ...
03 Mar 19 FC MulhouseMulhouse 2 - 2 AmnévilleAmnéville ...
03 Mar 19 Strasbourg IIStrasbourg 1 - 0 BiesheimBiesheim ...
Jornada 16
16 Mar 19 Saint-Louis NeuwegSaint-Louis 1 - 1 Nancy IINancy II ...
16 Mar 19 AmnévilleAmnéville 2 - 4 Raon-l'EtapeRaon-l'Etap ...
16 Mar 19 SarregueminesSarreguemin 2 - 2 FC MulhouseMulhouse ...
16 Mar 19 ThaonThaon 3 - 0 Strasbourg IIStrasbourg ...
16 Mar 19 BiesheimBiesheim 0 - 0 Troyes IITroyes II ...
16 Mar 19 RC Épernay ChampagneÉpernay 2 - 2 Vauban StrasbourgVauban ...
17 Mar 19 FCA TroyesFCA Troyes 0 - 0 Sarre-UnionSarre-Union ...
Jornada 17
23 Mar 19 Troyes IITroyes II 2 - 2 ThaonThaon ...
23 Mar 19 Raon-l'EtapeRaon-l'Etap 2 - 2 SarregueminesSarreguemin ...
23 Mar 19 Vauban StrasbourgVauban 1 - 0 AmnévilleAmnéville ...
23 Mar 19 Sarre-UnionSarre-Union 2 - 1 BiesheimBiesheim ...
23 Mar 19 Nancy IINancy II 2 - 1 RC Épernay ChampagneÉpernay ...
24 Mar 19 FC MulhouseMulhouse 3 - 0 FCA TroyesFCA Troyes ...
24 Mar 19 Strasbourg IIStrasbourg 0 - 0 Saint-Louis NeuwegSaint-Louis ...
Jornada 18
06 Abr 19 Saint-Louis NeuwegSaint-Louis 3 - 2 Troyes IITroyes II ...
06 Abr 19 ThaonThaon 4 - 1 BiesheimBiesheim ...
06 Abr 19 AmnévilleAmnéville 4 - 0 Nancy IINancy II ...
06 Abr 19 SarregueminesSarreguemin 1 - 3 Vauban StrasbourgVauban ...
06 Abr 19 RC Épernay ChampagneÉpernay 0 - 3 Strasbourg IIStrasbourg ...
07 Abr 19 FCA TroyesFCA Troyes 0 - 0 Raon-l'EtapeRaon-l'Etap ...
07 Abr 19 FC MulhouseMulhouse 1 - 0 Sarre-UnionSarre-Union ...
Jornada 19
13 Abr 19 Raon-l'EtapeRaon-l'Etap 0 - 1 FC MulhouseMulhouse ...
13 Abr 19 BiesheimBiesheim 1 - 0 Saint-Louis NeuwegSaint-Louis ...
13 Abr 19 Troyes IITroyes II 3 - 1 RC Épernay ChampagneÉpernay ...
13 Abr 19 Sarre-UnionSarre-Union 4 - 1 ThaonThaon ...
13 Abr 19 Vauban StrasbourgVauban 1 - 2 FCA TroyesFCA Troyes ...
14 Abr 19 Strasbourg IIStrasbourg 5 - 1 AmnévilleAmnéville ...
13 Abr 19 Nancy IINancy II 0 - 1 SarregueminesSarreguemin ...
Jornada 20
22 Abr 19 Saint-Louis NeuwegSaint-Louis 2 - 1 ThaonThaon ...
10 Abr 19 AmnévilleAmnéville 1 - 1 Troyes IITroyes II ...
01 May 19 Raon-l'EtapeRaon-l'Etap 1 - 1 Sarre-UnionSarre-Union ...
01 May 19 RC Épernay ChampagneÉpernay 0 - 2 BiesheimBiesheim ...
28 Mar 19 SarregueminesSarreguemin 1 - 1 Strasbourg IIStrasbourg 2
20 Abr 19 FC MulhouseMulhouse 4 - 0 Vauban StrasbourgVauban ...
31 Mar 19 FCA TroyesFCA Troyes 1 - 1 Nancy IINancy II ...
Jornada 21
04 May 19 Sarre-UnionSarre-Union 1 - 2 Saint-Louis NeuwegSaint-Louis ...
04 May 19 BiesheimBiesheim 4 - 1 AmnévilleAmnéville ...
04 May 19 ThaonThaon 2 - 4 RC Épernay ChampagneÉpernay ...
04 May 19 Vauban StrasbourgVauban 1 - 3 Raon-l'EtapeRaon-l'Etap ...
04 May 19 Troyes IITroyes II 6 - 0 SarregueminesSarreguemin ...
04 May 19 Strasbourg IIStrasbourg 1 - 1 FCA TroyesFCA Troyes ...
04 May 19 Nancy IINancy II 0 - 2 FC MulhouseMulhouse ...
Jornada 22
11 May 19 AmnévilleAmnéville 0 - 0 ThaonThaon ...
11 May 19 Raon-l'EtapeRaon-l'Etap 1 - 3 Nancy IINancy II ...
11 May 19 Vauban StrasbourgVauban 0 - 2 Sarre-UnionSarre-Union ...
11 May 19 SarregueminesSarreguemin 5 - 0 BiesheimBiesheim ...
11 May 19 RC Épernay ChampagneÉpernay 1 - 2 Saint-Louis NeuwegSaint-Louis ...
12 May 19 FC MulhouseMulhouse 1 - 2 Strasbourg IIStrasbourg ...
11 May 19 FCA TroyesFCA Troyes 0 - 0 Troyes IITroyes II ...
Jornada 23
25 May 19 ThaonThaon 4 - 2 SarregueminesSarreguemin ...
25 May 19 Saint-Louis NeuwegSaint-Louis 0 - 0 AmnévilleAmnéville ...
25 May 19 Sarre-UnionSarre-Union 0 - 0 RC Épernay ChampagneÉpernay ...
25 May 19 Troyes IITroyes II 0 - 1 FC MulhouseMulhouse ...
25 May 19 BiesheimBiesheim 0 - 0 FCA TroyesFCA Troyes ...
25 May 19 Strasbourg IIStrasbourg 4 - 1 Raon-l'EtapeRaon-l'Etap ...
25 May 19 Nancy IINancy II 1 - 2 Vauban StrasbourgVauban ...
Jornada 24
08 May 19 AmnévilleAmnéville 3 - 1 RC Épernay ChampagneÉpernay ...
01 May 19 SarregueminesSarreguemin 2 - 3 Saint-Louis NeuwegSaint-Louis ...
15 May 19 Raon-l'EtapeRaon-l'Etap 2 - 1 Troyes IITroyes II ...
27 Ene 19 FC MulhouseMulhouse 1 - 1 BiesheimBiesheim ...
03 Feb 19 Nancy IINancy II 3 - 1 Sarre-UnionSarre-Union ...
17 Feb 19 FCA TroyesFCA Troyes 3 - 0 ThaonThaon ...
16 Feb 19 Strasbourg IIStrasbourg 2 - 0 Vauban StrasbourgVauban ...
Jornada 25
09 Feb 19 BiesheimBiesheim 2 - 1 Raon-l'EtapeRaon-l'Etap ...
09 Feb 19 Saint-Louis NeuwegSaint-Louis 1 - 0 FCA TroyesFCA Troyes ...
09 Feb 19 ThaonThaon 0 - 1 FC MulhouseMulhouse ...
09 Feb 19 RC Épernay ChampagneÉpernay 2 - 3 SarregueminesSarreguemin ...
09 Feb 19 Troyes IITroyes II 1 - 0 Vauban StrasbourgVauban ...
09 Feb 19 Sarre-UnionSarre-Union 3 - 1 AmnévilleAmnéville ...
20 Mar 19 Strasbourg IIStrasbourg 4 - 1 Nancy IINancy II ...
Jornada 26
18 May 19 Raon-l'EtapeRaon-l'Etap 3 - 1 ThaonThaon ...
18 May 19 SarregueminesSarreguemin 1 - 1 AmnévilleAmnéville ...
18 May 19 Vauban StrasbourgVauban 1 - 1 BiesheimBiesheim ...
18 May 19 Nancy IINancy II 1 - 1 Troyes IITroyes II ...
18 May 19 FC MulhouseMulhouse 3 - 0 Saint-Louis NeuwegSaint-Louis ...
18 May 19 FCA TroyesFCA Troyes 2 - 1 RC Épernay ChampagneÉpernay ...
18 May 19 Strasbourg IIStrasbourg 3 - 1 Sarre-UnionSarre-Union ...

Clasificación

Equipo PJ GF GC Puntos
1 FC Mulhouse FC Mulhouse 26 40 21 48
2 Strasbourg II Strasbourg 26 48 32 47
3 Sarre-Union Sarre-Union 26 37 28 43
4 Thaon Thaon 26 42 40 38
5 Troyes II Troyes II 26 38 26 36
6 Saint-Louis Neuweg Saint-Louis 26 32 34 35
7 FCA Troyes FCA Troyes 26 24 21 34
8 Vauban Strasbourg Vauban 26 34 41 33
9 Biesheim Biesheim 26 32 38 33
10 Raon-l'Etape Raon-l'Etape 26 38 44 33
11 Amnéville Amnéville 26 36 41 32
12 Sarreguemines Sarreguemine 26 44 48 31
13 Nancy II Nancy II 26 31 43 29
14 RC Épernay Champagne Épernay 26 28 47 20

  USO DE MEMORIA  
6,222,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3747
Total Execution Time  0.3769
  CADENA URL  
/ligue_cfa_22019/grupo6/calendario
  GET DATOS  
$_GET['/ligue_cfa_22019/grupo6/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0126  SELECT type FROM routes WHERE alias = 'ligue_cfa_22019'
0.0261  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa_2' AND (l.group_code = 6 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=6 DESC LIMIT 1
0.0143  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 221 GROUP BY l.categoryId
0.0127  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=221 GROUP BY l.year ORDER BY l.year DESC
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 = 44565 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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 calendars2019 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 44565 ORDER BY round ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 15:22:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 15:22:31' 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-09 15:22:31' 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-09 15:22:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa_2' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2019 e ON e.player_id = p.id AND e.league_id = 44565 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44565 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.0216  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 events2019 e ON e.player_id = p.id AND e.league_id = 44565 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44565 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  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 events2019 e ON e.player_id = p.id AND e.league_id = 44565 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44565 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 `tables2019` 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 = 44565 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC