4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
09 Ene 22 Sporting Baie-MahaultSporting 2 - 3 Etoile de Morne-à-l'EauEtoile ...
09 Ene 22 Phare du CanalPhare Canal 2 - 1 Juventus SAJuventus ...
09 Ene 22 CERFACERFA 1 - 5 AS GosierAS Gosier ...
10 Mar 22 Vieux-HabitantsVieux-Habit 4 - 3 Solidarité ScolaireSolidarité ...
10 Mar 22 Stade LamentinoisStade 2 - 1 Amical ClubAmical Club ...
09 Ene 22 Jeunesse EvolutionJeunesse 2 - 1 Arsenal GuadalupeArsenal ...
08 Ene 22 Red StarRed Star 1 - 0 La GauloiseGauloise ...
08 Ene 22 USR Sainte-RoseSainte-Rose 0 - 5 CS MoulienCS Moulien ...
08 Ene 22 Club Amical MarquisatClub Amical 0 - 6 SirocoSiroco ...
13 Mar 22 Racing ClubRacing Club 1 - 2 US Baie-MahaultBaie-Mahaul ...
Jornada 2
16 Ene 22 AS GosierAS Gosier 3 - 2 Vieux-HabitantsVieux-Habit ...
15 Ene 22 Juventus SAJuventus 2 - 1 Red StarRed Star ...
16 Ene 22 La GauloiseGauloise 1 - 1 Jeunesse EvolutionJeunesse ...
19 Mar 22 Stade LamentinoisStade 1 - 0 Arsenal GuadalupeArsenal ...
17 Mar 22 Sporting Baie-MahaultSporting 0 - 1 Amical ClubAmical Club ...
10 Mar 22 Etoile de Morne-à-l'EauEtoile 2 - 0 Phare du CanalPhare Canal ...
15 Ene 22 US Baie-MahaultBaie-Mahaul 3 - 2 Club Amical MarquisatClub Amical ...
24 Feb 22 SirocoSiroco 2 - 0 USR Sainte-RoseSainte-Rose ...
15 Ene 22 CS MoulienCS Moulien 3 - 1 CERFACERFA ...
21 Abr 22 Solidarité ScolaireSolidarité 4 - 0 Racing ClubRacing Club ...
Jornada 3
22 Ene 22 Etoile de Morne-à-l'EauEtoile 0 - 0 Amical ClubAmical Club ...
22 Ene 22 Stade LamentinoisStade 1 - 2 La GauloiseGauloise ...
22 Ene 22 AS GosierAS Gosier 0 - 0 CS MoulienCS Moulien ...
26 Mar 22 USR Sainte-RoseSainte-Rose 0 - 2 US Baie-MahaultBaie-Mahaul ...
22 Ene 22 Club Amical MarquisatClub Amical 1 - 4 Solidarité ScolaireSolidarité ...
24 Feb 22 Sporting Baie-MahaultSporting 3 - 2 Arsenal GuadalupeArsenal ...
10 Mar 22 Jeunesse EvolutionJeunesse 0 - 0 Juventus SAJuventus ...
22 Ene 22 Phare du CanalPhare Canal 6 - 0 Red StarRed Star ...
22 Ene 22 CERFACERFA 2 - 1 SirocoSiroco ...
22 Ene 22 Vieux-HabitantsVieux-Habit 2 - 0 Racing ClubRacing Club ...
Jornada 4
03 Abr 22 US Baie-MahaultBaie-Mahaul 1 - 1 CERFACERFA ...
29 Ene 22 Red StarRed Star 1 - 2 Jeunesse EvolutionJeunesse ...
29 Ene 22 Juventus SAJuventus 2 - 1 Stade LamentinoisStade ...
30 Ene 22 La GauloiseGauloise 2 - 1 Sporting Baie-MahaultSporting ...
02 Abr 22 Etoile de Morne-à-l'EauEtoile 4 - 2 Arsenal GuadalupeArsenal ...
29 Ene 22 Amical ClubAmical Club 0 - 0 Phare du CanalPhare Canal ...
30 Ene 22 Solidarité ScolaireSolidarité 7 - 0 USR Sainte-RoseSainte-Rose ...
29 Ene 22 SirocoSiroco 2 - 2 AS GosierAS Gosier ...
29 Ene 22 CS MoulienCS Moulien 0 - 0 Vieux-HabitantsVieux-Habit ...
29 Ene 22 Racing ClubRacing Club 1 - 2 Club Amical MarquisatClub Amical ...
Jornada 5
05 Feb 22 Amical ClubAmical Club 0 - 0 Arsenal GuadalupeArsenal ...
05 Feb 22 Etoile de Morne-à-l'EauEtoile 4 - 2 La GauloiseGauloise ...
05 Feb 22 Stade LamentinoisStade 2 - 0 Red StarRed Star ...
05 Feb 22 AS GosierAS Gosier 8 - 1 US Baie-MahaultBaie-Mahaul ...
05 Feb 22 USR Sainte-RoseSainte-Rose 0 - 0 Racing ClubRacing Club ...
05 Feb 22 Sporting Baie-MahaultSporting 1 - 0 Juventus SAJuventus ...
05 Feb 22 Phare du CanalPhare Canal 4 - 0 Jeunesse EvolutionJeunesse ...
05 Feb 22 CS MoulienCS Moulien 6 - 0 SirocoSiroco ...
05 Feb 22 Vieux-HabitantsVieux-Habit 2 - 2 Club Amical MarquisatClub Amical ...
05 Feb 22 CERFACERFA 0 - 3 Solidarité ScolaireSolidarité ...
Jornada 6
12 Feb 22 Jeunesse EvolutionJeunesse 1 - 1 Stade LamentinoisStade ...
12 Feb 22 Solidarité ScolaireSolidarité 0 - 0 AS GosierAS Gosier ...
12 Feb 22 Juventus SAJuventus 0 - 1 Etoile de Morne-à-l'EauEtoile ...
12 Feb 22 Arsenal GuadalupeArsenal 0 - 0 Phare du CanalPhare Canal ...
12 Feb 22 Club Amical MarquisatClub Amical 5 - 1 USR Sainte-RoseSainte-Rose ...
12 Feb 22 Racing ClubRacing Club 1 - 4 CERFACERFA ...
12 Feb 22 US Baie-MahaultBaie-Mahaul 1 - 2 CS MoulienCS Moulien ...
12 Feb 22 SirocoSiroco 1 - 0 Vieux-HabitantsVieux-Habit ...
13 Feb 22 Red StarRed Star 3 - 2 Sporting Baie-MahaultSporting ...
12 Feb 22 La GauloiseGauloise 0 - 2 Amical ClubAmical Club ...
Jornada 7
19 Feb 22 CERFACERFA 4 - 4 Club Amical MarquisatClub Amical ...
19 Feb 22 Amical ClubAmical Club 0 - 0 Juventus SAJuventus ...
19 Feb 22 Etoile de Morne-à-l'EauEtoile 2 - 2 Red StarRed Star ...
19 Feb 22 Stade LamentinoisStade 2 - 1 Phare du CanalPhare Canal ...
19 Feb 22 Arsenal GuadalupeArsenal 0 - 2 La GauloiseGauloise ...
19 Feb 22 SirocoSiroco 0 - 0 US Baie-MahaultBaie-Mahaul ...
19 Feb 22 AS GosierAS Gosier 4 - 0 Racing ClubRacing Club ...
19 Feb 22 USR Sainte-RoseSainte-Rose 0 - 5 Vieux-HabitantsVieux-Habit ...
19 Feb 22 Sporting Baie-MahaultSporting 1 - 1 Jeunesse EvolutionJeunesse ...
19 Feb 22 CS MoulienCS Moulien 0 - 0 Solidarité ScolaireSolidarité ...
Jornada 8
27 Feb 22 Jeunesse EvolutionJeunesse 1 - 1 Etoile de Morne-à-l'EauEtoile ...
26 Feb 22 Stade LamentinoisStade 5 - 1 Sporting Baie-MahaultSporting ...
26 Feb 22 Juventus SAJuventus 0 - 2 Arsenal GuadalupeArsenal ...
06 Abr 22 USR Sainte-RoseSainte-Rose 1 - 2 CERFACERFA ...
26 Feb 22 Club Amical MarquisatClub Amical 1 - 2 AS GosierAS Gosier ...
26 Feb 22 Racing ClubRacing Club 0 - 2 CS MoulienCS Moulien ...
26 Feb 22 Red StarRed Star 2 - 1 Amical ClubAmical Club ...
27 Feb 22 Phare du CanalPhare Canal 1 - 0 La GauloiseGauloise ...
26 Feb 22 Solidarité ScolaireSolidarité 4 - 1 SirocoSiroco ...
27 Feb 22 Vieux-HabitantsVieux-Habit 1 - 3 US Baie-MahaultBaie-Mahaul ...
Jornada 9
05 Mar 22 US Baie-MahaultBaie-Mahaul 1 - 4 Solidarité ScolaireSolidarité ...
05 Mar 22 Amical ClubAmical Club 0 - 2 Jeunesse EvolutionJeunesse ...
05 Mar 22 Etoile de Morne-à-l'EauEtoile 3 - 0 Stade LamentinoisStade ...
06 Mar 22 La GauloiseGauloise 2 - 1 Juventus SAJuventus ...
05 Mar 22 Arsenal GuadalupeArsenal 1 - 1 Red StarRed Star ...
05 Mar 22 AS GosierAS Gosier 0 - 0 USR Sainte-RoseSainte-Rose ...
06 Mar 22 Sporting Baie-MahaultSporting 1 - 1 Phare du CanalPhare Canal ...
06 Mar 22 SirocoSiroco 3 - 2 Racing ClubRacing Club ...
06 Mar 22 CS MoulienCS Moulien 3 - 0 Club Amical MarquisatClub Amical ...
06 Mar 22 CERFACERFA 0 - 4 Vieux-HabitantsVieux-Habit ...
Jornada 10
13 Mar 22 AS GosierAS Gosier 3 - 0 CERFACERFA ...
13 Mar 22 Solidarité ScolaireSolidarité 1 - 0 Vieux-HabitantsVieux-Habit ...
12 Mar 22 Etoile de Morne-à-l'EauEtoile 0 - 1 Sporting Baie-MahaultSporting ...
12 Mar 22 Amical ClubAmical Club 3 - 1 Stade LamentinoisStade ...
12 Mar 22 Arsenal GuadalupeArsenal 0 - 4 Jeunesse EvolutionJeunesse ...
12 Mar 22 La GauloiseGauloise 4 - 0 Red StarRed Star ...
12 Mar 22 Juventus SAJuventus 3 - 1 Phare du CanalPhare Canal ...
13 Mar 22 CS MoulienCS Moulien 4 - 0 USR Sainte-RoseSainte-Rose ...
13 Mar 22 SirocoSiroco 1 - 2 Club Amical MarquisatClub Amical ...
24 Mar 22 US Baie-MahaultBaie-Mahaul 1 - 0 Racing ClubRacing Club ...
Jornada 11
19 Mar 22 Red StarRed Star 3 - 0 Juventus SAJuventus ...
07 Abr 22 Arsenal GuadalupeArsenal 2 - 3 Stade LamentinoisStade ...
19 Mar 22 USR Sainte-RoseSainte-Rose 1 - 3 SirocoSiroco ...
23 Abr 22 Racing ClubRacing Club 0 - 5 Solidarité ScolaireSolidarité ...
19 Mar 22 Club Amical MarquisatClub Amical 3 - 4 US Baie-MahaultBaie-Mahaul ...
20 Mar 22 Amical ClubAmical Club 1 - 0 Sporting Baie-MahaultSporting ...
28 Abr 22 Phare du CanalPhare Canal 1 - 0 Etoile de Morne-à-l'EauEtoile ...
19 Mar 22 Jeunesse EvolutionJeunesse 2 - 0 La GauloiseGauloise ...
19 Mar 22 Vieux-HabitantsVieux-Habit 1 - 1 AS GosierAS Gosier ...
28 Abr 22 CERFACERFA 0 - 0 CS MoulienCS Moulien ...
Jornada 12
07 Abr 22 Red StarRed Star 0 - 4 Phare du CanalPhare Canal ...
06 Abr 22 Solidarité ScolaireSolidarité 1 - 0 Club Amical MarquisatClub Amical ...
27 Mar 22 Amical ClubAmical Club 2 - 2 Etoile de Morne-à-l'EauEtoile ...
26 Mar 22 Arsenal GuadalupeArsenal 4 - 2 Sporting Baie-MahaultSporting ...
26 Mar 22 La GauloiseGauloise 2 - 1 Stade LamentinoisStade ...
07 Abr 22 Juventus SAJuventus 1 - 0 Jeunesse EvolutionJeunesse ...
05 May 22 CS MoulienCS Moulien 1 - 3 AS GosierAS Gosier ...
26 Mar 22 SirocoSiroco 1 - 0 CERFACERFA ...
31 Mar 22 US Baie-MahaultBaie-Mahaul 5 - 0 USR Sainte-RoseSainte-Rose ...
27 Mar 22 Racing ClubRacing Club 0 - 1 Vieux-HabitantsVieux-Habit ...
Jornada 13
15 Abr 22 Arsenal GuadalupeArsenal 0 - 0 Etoile de Morne-à-l'EauEtoile ...
02 Abr 22 Stade LamentinoisStade 2 - 2 Juventus SAJuventus ...
02 Abr 22 AS GosierAS Gosier 2 - 0 SirocoSiroco ...
02 Abr 22 Club Amical MarquisatClub Amical 2 - 3 Racing ClubRacing Club ...
02 Abr 22 USR Sainte-RoseSainte-Rose 0 - 3 Solidarité ScolaireSolidarité ...
03 Abr 22 Phare du CanalPhare Canal 3 - 1 Amical ClubAmical Club ...
03 Abr 22 Jeunesse EvolutionJeunesse 1 - 0 Red StarRed Star ...
02 Abr 22 Sporting Baie-MahaultSporting 1 - 1 La GauloiseGauloise ...
03 Abr 22 Vieux-HabitantsVieux-Habit 1 - 1 CS MoulienCS Moulien ...
08 May 22 CERFACERFA 1 - 0 US Baie-MahaultBaie-Mahaul ...
Jornada 14
14 Abr 22 SirocoSiroco 2 - 4 CS MoulienCS Moulien ...
10 Abr 22 Solidarité ScolaireSolidarité 3 - 0 CERFACERFA ...
10 Abr 22 Arsenal GuadalupeArsenal 0 - 0 Amical ClubAmical Club ...
09 Abr 22 La GauloiseGauloise 5 - 0 Etoile de Morne-à-l'EauEtoile ...
10 Abr 22 Juventus SAJuventus 0 - 1 Sporting Baie-MahaultSporting ...
10 Abr 22 Club Amical MarquisatClub Amical 2 - 2 Vieux-HabitantsVieux-Habit ...
11 Abr 22 Jeunesse EvolutionJeunesse 0 - 0 Phare du CanalPhare Canal ...
09 Abr 22 US Baie-MahaultBaie-Mahaul 2 - 0 AS GosierAS Gosier ...
14 Abr 22 Red StarRed Star 2 - 0 Stade LamentinoisStade ...
10 Abr 22 Racing ClubRacing Club 1 - 2 USR Sainte-RoseSainte-Rose ...
Jornada 15
23 Abr 22 Stade LamentinoisStade 0 - 0 Jeunesse EvolutionJeunesse ...
23 Abr 22 Sporting Baie-MahaultSporting 2 - 1 Red StarRed Star ...
23 Abr 22 Phare du CanalPhare Canal 1 - 0 Arsenal GuadalupeArsenal ...
23 Abr 22 Vieux-HabitantsVieux-Habit 0 - 1 SirocoSiroco ...
24 Abr 22 Amical ClubAmical Club 0 - 2 La GauloiseGauloise ...
24 Abr 22 Etoile de Morne-à-l'EauEtoile 3 - 0 Juventus SAJuventus ...
24 Abr 22 USR Sainte-RoseSainte-Rose 3 - 1 Club Amical MarquisatClub Amical ...
08 May 22 AS GosierAS Gosier 0 - 0 Solidarité ScolaireSolidarité ...
23 Abr 22 CS MoulienCS Moulien 0 - 0 US Baie-MahaultBaie-Mahaul ...
15 Abr 22 CERFACERFA 6 - 1 Racing ClubRacing Club ...
Jornada 16
30 Abr 22 Solidarité ScolaireSolidarité 0 - 1 CS MoulienCS Moulien ...
30 Abr 22 Club Amical MarquisatClub Amical 1 - 1 CERFACERFA ...
30 Abr 22 Jeunesse EvolutionJeunesse 3 - 0 Sporting Baie-MahaultSporting ...
07 May 22 Phare du CanalPhare Canal 7 - 1 Stade LamentinoisStade ...
30 Abr 22 US Baie-MahaultBaie-Mahaul 1 - 0 SirocoSiroco ...
01 May 22 Vieux-HabitantsVieux-Habit 1 - 2 USR Sainte-RoseSainte-Rose ...
30 Abr 22 Racing ClubRacing Club 0 - 4 AS GosierAS Gosier ...
30 Abr 22 Red StarRed Star 0 - 1 Etoile de Morne-à-l'EauEtoile ...
30 Abr 22 La GauloiseGauloise 2 - 0 Arsenal GuadalupeArsenal ...
30 Abr 22 Juventus SAJuventus 2 - 1 Amical ClubAmical Club ...
Jornada 17
14 May 22 La GauloiseGauloise 2 - 1 Phare du CanalPhare Canal ...
14 May 22 Etoile de Morne-à-l'EauEtoile 1 - 0 Jeunesse EvolutionJeunesse ...
14 May 22 Amical ClubAmical Club 1 - 3 Red StarRed Star ...
14 May 22 Arsenal GuadalupeArsenal 0 - 1 Juventus SAJuventus ...
14 May 22 Sporting Baie-MahaultSporting 1 - 1 Stade LamentinoisStade ...
15 May 22 AS GosierAS Gosier 7 - 0 Club Amical MarquisatClub Amical 1
15 May 22 CS MoulienCS Moulien 3 - 0 Racing ClubRacing Club ...
15 May 22 SirocoSiroco 2 - 3 Solidarité ScolaireSolidarité ...
15 May 22 US Baie-MahaultBaie-Mahaul 5 - 0 Vieux-HabitantsVieux-Habit ...
15 May 22 CERFACERFA 3 - 0 USR Sainte-RoseSainte-Rose ...
Jornada 18
21 May 22 Juventus SAJuventus 0 - 2 La GauloiseGauloise ...
21 May 22 Red StarRed Star 2 - 1 Arsenal GuadalupeArsenal ...
21 May 22 USR Sainte-RoseSainte-Rose 0 - 1 AS GosierAS Gosier ...
21 May 22 Jeunesse EvolutionJeunesse 2 - 0 Amical ClubAmical Club ...
21 May 22 Stade LamentinoisStade 1 - 0 Etoile de Morne-à-l'EauEtoile ...
21 May 22 Solidarité ScolaireSolidarité 3 - 1 US Baie-MahaultBaie-Mahaul ...
21 May 22 Racing ClubRacing Club 0 - 3 SirocoSiroco ...
21 May 22 Club Amical MarquisatClub Amical 5 - 7 CS MoulienCS Moulien ...
21 May 22 Vieux-HabitantsVieux-Habit 3 - 2 CERFACERFA ...
21 May 22 Phare du CanalPhare Canal 3 - 2 Sporting Baie-MahaultSporting ...

Clasificación

Equipo PJ GF GC Puntos
1 La Gauloise La Gauloise 18 31 17 35
2 Phare du Canal Phare Canal 18 36 15 34
3 Etoile de Morne-à-l'Eau Etoile 18 27 19 32
4 Jeunesse Evolution Jeunesse 18 22 12 31
5 Stade Lamentinois Stade 18 25 30 25
6 Red Star Red Star 18 22 32 23
7 Juventus SA Juventus SA 18 15 23 21
8 Sporting Baie-Mahault Sporting 18 22 32 19
9 Amical Club Amical Club 18 14 21 18
10 Arsenal Guadalupe Arsenal 18 15 28 11
11 Solidarité Scolaire Solidarité 18 48 11 42
12 AS Gosier AS Gosier 18 45 11 39
13 CS Moulien CS Moulien 18 42 13 39
14 US Baie-Mahault Baie-Mahault 18 33 26 33
15 Siroco Siroco 18 29 29 26
16 Vieux-Habitants Vieux-Habita 18 29 27 23
17 CERFA CERFA 18 28 35 22
18 Club Amical Marquisat Club Amical 18 33 55 13
19 USR Sainte-Rose Sainte-Rose 18 10 50 11
20 Racing Club Racing Club 18 10 50 4

  USO DE MEMORIA  
6,218,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.3675
Total Execution Time  0.3702
  CADENA URL  
/1_th_guadalupe2022/grupo1/calendario
  GET DATOS  
$_GET['/1_th_guadalupe2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0108  SELECT type FROM routes WHERE alias = '1_th_guadalupe2022'
0.0223  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_th_guadalupe' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0111  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=426 AND type_rel = 3
0.0110  SELECT id,name,alias,stepParent FROM categories WHERE parentId=426 ORDER BY order_id ASC
0.0115  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 = 66014 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 66014 ORDER BY round ASC
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 19:17:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 19:17:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 19:17:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 19:17:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '1_th_guadalupe' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0109  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 events2022 e ON e.player_id = p.id AND e.league_id = 66014 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66014 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.0108  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 events2022 e ON e.player_id = p.id AND e.league_id = 66014 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66014 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0108  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 events2022 e ON e.player_id = p.id AND e.league_id = 66014 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66014 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0123  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66014 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC