4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
23 Ago 23 SimbaSimba 0 - 1 TP MazembeTP Mazembe ...
24 Ago 23 Motema PembeMotema 3 - 0 Kuya SportKuya Sport ...
26 Ago 23 Dauphins NoirsDauphins 0 - 0 Celeste FCCeleste FC ...
27 Ago 23 BlessingBlessing 3 - 1 Groupe BazanoGroupe ...
27 Ago 23 Lubumbashi SportLubumbashi 3 - 0 Panda 05Panda 05 ...
08 Sep 23 Sanga BalendeSanga 0 - 3 Don Bosco LubumbashiBosco ...
28 Oct 23 Maniema UnionManiema 3 - 0 RenaissanceRenaissance ...
28 Oct 23 TshinkunkuTshinkunku 0 - 1 Saint-Eloi LupopoSaint-Eloi ...
15 Sep 23 RangersRangers 1 - 0 Etoile de KivuEtoile Kivu ...
14 Sep 23 AS Vita ClubVita Club 2 - 0 Aigles du CongoAigles ...
Jornada 2
17 Sep 23 RenaissanceRenaissance 3 - 0 Motema PembeMotema ...
20 Sep 23 Kuya SportKuya Sport 1 - 1 RangersRangers ...
23 Ago 23 Aigles du CongoAigles 0 - 1 Maniema UnionManiema ...
19 Sep 23 Panda 05Panda 05 1 - 1 SimbaSimba ...
19 Sep 23 Don Bosco LubumbashiBosco 1 - 1 Lubumbashi SportLubumbashi ...
19 Sep 23 Celeste FCCeleste FC 0 - 2 AS Vita ClubVita Club ...
14 Oct 23 TP MazembeTP Mazembe 3 - 0 TshinkunkuTshinkunku ...
24 Sep 23 Groupe BazanoGroupe 0 - 3 Sanga BalendeSanga ...
07 Sep 23 Saint-Eloi LupopoSaint-Eloi 2 - 0 BlessingBlessing ...
14 Oct 23 Etoile de KivuEtoile Kivu 0 - 0 Dauphins NoirsDauphins ...
Jornada 3
24 Oct 23 Maniema UnionManiema 2 - 0 AS Vita ClubVita Club ...
23 Ago 23 Etoile de KivuEtoile Kivu 0 - 1 Celeste FCCeleste FC ...
24 Ago 23 RangersRangers 0 - 3 RenaissanceRenaissance ...
29 Oct 23 Dauphins NoirsDauphins 3 - 0 Kuya SportKuya Sport ...
03 Sep 23 Motema PembeMotema 1 - 0 Aigles du CongoAigles ...
18 Oct 23 Groupe BazanoGroupe 5 - 1 TshinkunkuTshinkunku ...
06 Oct 23 Lubumbashi SportLubumbashi 2 - 1 SimbaSimba ...
01 Oct 23 Don Bosco LubumbashiBosco 1 - 0 BlessingBlessing ...
06 Oct 23 Panda 05Panda 05 0 - 0 Sanga BalendeSanga ...
07 Oct 23 Saint-Eloi LupopoSaint-Eloi 0 - 0 TP MazembeTP Mazembe ...
Jornada 4
26 Ago 23 Aigles du CongoAigles 0 - 0 RangersRangers ...
30 Ago 23 TP MazembeTP Mazembe 4 - 0 Groupe BazanoGroupe 1
06 Oct 23 TshinkunkuTshinkunku 0 - 2 Don Bosco LubumbashiBosco ...
31 Ago 23 BlessingBlessing 1 - 0 Panda 05Panda 05 ...
08 Nov 23 Sanga BalendeSanga 0 - 4 Lubumbashi SportLubumbashi ...
13 Sep 23 RenaissanceRenaissance 0 - 1 Dauphins NoirsDauphins ...
17 Sep 23 Kuya SportKuya Sport 3 - 1 Etoile de KivuEtoile Kivu ...
23 Sep 23 Celeste FCCeleste FC 0 - 3 Maniema UnionManiema ...
22 Oct 23 SimbaSimba 0 - 2 Saint-Eloi LupopoSaint-Eloi ...
04 Oct 23 AS Vita ClubVita Club 0 - 1 Motema PembeMotema ...
Jornada 5
01 Nov 23 Etoile de KivuEtoile Kivu 1 - 1 RenaissanceRenaissance ...
01 Oct 23 Dauphins NoirsDauphins 2 - 0 Aigles du CongoAigles ...
27 Sep 23 Motema PembeMotema 1 - 2 Maniema UnionManiema ...
26 Sep 23 RangersRangers 0 - 1 AS Vita ClubVita Club ...
19 Oct 23 Kuya SportKuya Sport 0 - 0 Celeste FCCeleste FC ...
30 Sep 23 Panda 05Panda 05 2 - 1 TshinkunkuTshinkunku ...
20 Sep 23 Groupe BazanoGroupe 1 - 3 Saint-Eloi LupopoSaint-Eloi ...
07 Nov 23 Don Bosco LubumbashiBosco 2 - 2 TP MazembeTP Mazembe ...
18 Oct 23 Lubumbashi SportLubumbashi 2 - 0 BlessingBlessing ...
18 Oct 23 Sanga BalendeSanga 0 - 1 SimbaSimba ...
Jornada 6
07 Sep 23 TshinkunkuTshinkunku 0 - 3 Lubumbashi SportLubumbashi ...
08 Sep 23 Celeste FCCeleste FC 3 - 0 Motema PembeMotema ...
24 Sep 23 RenaissanceRenaissance 1 - 1 Kuya SportKuya Sport ...
11 Sep 23 Aigles du CongoAigles 2 - 0 Etoile de KivuEtoile Kivu ...
10 Sep 23 Maniema UnionManiema 3 - 0 RangersRangers ...
10 Sep 23 SimbaSimba 1 - 1 Groupe BazanoGroupe ...
10 Sep 23 AS Vita ClubVita Club 0 - 1 Dauphins NoirsDauphins ...
20 Sep 23 BlessingBlessing 2 - 0 Sanga BalendeSanga ...
25 Oct 23 Saint-Eloi LupopoSaint-Eloi 3 - 1 Don Bosco LubumbashiBosco ...
24 Sep 23 TP MazembeTP Mazembe 4 - 0 Panda 05Panda 05 ...
Jornada 7
29 Oct 23 Etoile de KivuEtoile Kivu 1 - 0 AS Vita ClubVita Club ...
22 Oct 23 Sanga BalendeSanga 2 - 2 TshinkunkuTshinkunku ...
07 Oct 23 Kuya SportKuya Sport 1 - 0 Aigles du CongoAigles ...
07 Oct 23 RenaissanceRenaissance 2 - 1 Celeste FCCeleste FC ...
06 Oct 23 Dauphins NoirsDauphins 0 - 1 Maniema UnionManiema ...
08 Oct 23 RangersRangers 0 - 0 Motema PembeMotema ...
22 Oct 23 Don Bosco LubumbashiBosco 2 - 0 Groupe BazanoGroupe ...
15 Oct 23 BlessingBlessing 1 - 0 SimbaSimba ...
10 Sep 23 Panda 05Panda 05 0 - 3 Saint-Eloi LupopoSaint-Eloi ...
10 Sep 23 Lubumbashi SportLubumbashi 0 - 3 TP MazembeTP Mazembe ...
Jornada 8
03 Nov 23 TP MazembeTP Mazembe 2 - 0 Sanga BalendeSanga ...
20 Sep 23 Motema PembeMotema 2 - 0 Dauphins NoirsDauphins 1
14 Oct 23 AS Vita ClubVita Club 2 - 0 Kuya SportKuya Sport ...
15 Oct 23 Celeste FCCeleste FC 2 - 1 RangersRangers ...
18 Oct 23 Maniema UnionManiema 3 - 0 Etoile de KivuEtoile Kivu ...
15 Oct 23 Aigles du CongoAigles 1 - 0 RenaissanceRenaissance ...
25 Oct 23 Groupe BazanoGroupe 3 - 0 Panda 05Panda 05 ...
29 Oct 23 SimbaSimba 0 - 0 Don Bosco LubumbashiBosco ...
15 Oct 23 Saint-Eloi LupopoSaint-Eloi 1 - 2 Lubumbashi SportLubumbashi ...
07 Nov 23 TshinkunkuTshinkunku 0 - 3 BlessingBlessing ...
Jornada 9
31 Ago 23 Sanga BalendeSanga 0 - 3 Saint-Eloi LupopoSaint-Eloi ...
04 Nov 23 Etoile de KivuEtoile Kivu 2 - 0 Motema PembeMotema ...
22 Oct 23 Dauphins NoirsDauphins 0 - 2 RangersRangers ...
22 Oct 23 Aigles du CongoAigles 3 - 1 Celeste FCCeleste FC ...
03 Oct 23 Kuya SportKuya Sport 1 - 0 Maniema UnionManiema ...
05 Nov 23 RenaissanceRenaissance 2 - 3 AS Vita ClubVita Club ...
25 Oct 23 TshinkunkuTshinkunku 2 - 2 SimbaSimba ...
10 Nov 23 BlessingBlessing 1 - 3 TP MazembeTP Mazembe ...
28 Oct 23 Lubumbashi SportLubumbashi 1 - 1 Groupe BazanoGroupe ...
14 Oct 23 Panda 05Panda 05 1 - 0 Don Bosco LubumbashiBosco ...
Jornada 10
11 Nov 23 Don Bosco LubumbashiBosco 2 - 1 Sanga BalendeSanga ...
14 Nov 23 Groupe BazanoGroupe 2 - 4 BlessingBlessing ...
12 Nov 23 Saint-Eloi LupopoSaint-Eloi 2 - 0 TshinkunkuTshinkunku ...
12 Nov 23 Panda 05Panda 05 1 - 1 Lubumbashi SportLubumbashi ...
15 Nov 23 TP MazembeTP Mazembe 1 - 1 SimbaSimba ...
11 Nov 23 Celeste FCCeleste FC 0 - 1 Dauphins NoirsDauphins ...
11 Nov 23 Kuya SportKuya Sport 0 - 1 Motema PembeMotema ...
12 Nov 23 RenaissanceRenaissance 2 - 3 Maniema UnionManiema ...
12 Nov 23 Etoile de KivuEtoile Kivu 3 - 0 RangersRangers ...
12 Nov 23 Aigles du CongoAigles 1 - 0 AS Vita ClubVita Club ...
Jornada 11
23 Dic 23 Sanga BalendeSanga 3 - 0 Groupe BazanoGroupe ...
18 Nov 23 Lubumbashi SportLubumbashi 3 - 1 Don Bosco LubumbashiBosco ...
19 Nov 23 SimbaSimba 1 - 0 Panda 05Panda 05 ...
19 Nov 23 BlessingBlessing 1 - 3 Saint-Eloi LupopoSaint-Eloi ...
19 Nov 23 TshinkunkuTshinkunku 0 - 4 TP MazembeTP Mazembe ...
20 Nov 23 Motema PembeMotema 0 - 0 RenaissanceRenaissance ...
31 Dic 23 Maniema UnionManiema 1 - 2 Aigles du CongoAigles 1
30 Nov 23 RangersRangers 1 - 2 Kuya SportKuya Sport ...
30 Nov 23 AS Vita ClubVita Club 1 - 0 Celeste FCCeleste FC ...
18 Dic 23 Dauphins NoirsDauphins 0 - 2 Etoile de KivuEtoile Kivu ...
Jornada 12
25 Nov 23 BlessingBlessing 0 - 0 Don Bosco LubumbashiBosco ...
30 Dic 23 TP MazembeTP Mazembe Apl Saint-Eloi LupopoSaint-Eloi ...
25 Nov 23 SimbaSimba 1 - 1 Lubumbashi SportLubumbashi ...
27 Dic 23 Sanga BalendeSanga 3 - 0 Panda 05Panda 05 ...
26 Nov 23 TshinkunkuTshinkunku 3 - 1 Groupe BazanoGroupe ...
16 Nov 23 Kuya SportKuya Sport 1 - 2 Dauphins NoirsDauphins ...
18 Nov 23 AS Vita ClubVita Club 0 - 1 Maniema UnionManiema ...
25 Nov 23 Celeste FCCeleste FC 1 - 2 Etoile de KivuEtoile Kivu ...
10 Ene 24 RangersRangers 1 - 3 RenaissanceRenaissance ...
12 Ene 24 Aigles du CongoAigles 0 - 1 Motema PembeMotema ...
Jornada 13
29 Nov 23 Don Bosco LubumbashiBosco 2 - 0 TshinkunkuTshinkunku ...
10 Ene 24 Groupe BazanoGroupe 1 - 6 TP MazembeTP Mazembe ...
29 Nov 23 Lubumbashi SportLubumbashi 0 - 0 Sanga BalendeSanga ...
30 Nov 23 Saint-Eloi LupopoSaint-Eloi 1 - 0 SimbaSimba ...
30 Nov 23 Panda 05Panda 05 1 - 1 BlessingBlessing ...
24 Ene 24 Motema PembeMotema 0 - 3 AS Vita ClubVita Club ...
10 Ene 24 Maniema UnionManiema 3 - 0 Celeste FCCeleste FC ...
13 Ene 24 Dauphins NoirsDauphins Apl RenaissanceRenaissance ...
30 Dic 23 Etoile de KivuEtoile Kivu 3 - 0 Kuya SportKuya Sport ...
04 Dic 23 RangersRangers 0 - 3 Aigles du CongoAigles ...
Jornada 14
03 Dic 23 SimbaSimba 0 - 0 Sanga BalendeSanga ...
03 Dic 23 TshinkunkuTshinkunku 1 - 1 Panda 05Panda 05 ...
03 Dic 23 BlessingBlessing 2 - 2 Lubumbashi SportLubumbashi ...
27 Dic 23 TP MazembeTP Mazembe 6 - 1 Don Bosco LubumbashiBosco ...
03 Dic 23 Saint-Eloi LupopoSaint-Eloi 3 - 0 Groupe BazanoGroupe ...
21 Nov 23 Aigles du CongoAigles 1 - 1 Dauphins NoirsDauphins ...
29 Nov 23 RenaissanceRenaissance 4 - 3 Etoile de KivuEtoile Kivu ...
27 Dic 23 AS Vita ClubVita Club 3 - 0 RangersRangers ...
27 Dic 23 Maniema UnionManiema 2 - 1 Motema PembeMotema ...
24 Dic 23 Celeste FCCeleste FC 1 - 0 Kuya SportKuya Sport ...
Jornada 15
24 Dic 23 Sanga BalendeSanga 1 - 0 BlessingBlessing ...
09 Dic 23 Groupe BazanoGroupe 2 - 4 SimbaSimba ...
09 Dic 23 Don Bosco LubumbashiBosco 1 - 4 Saint-Eloi LupopoSaint-Eloi ...
10 Dic 23 Lubumbashi SportLubumbashi 2 - 0 TshinkunkuTshinkunku ...
23 Dic 23 Panda 05Panda 05 0 - 0 TP MazembeTP Mazembe ...
15 Nov 23 RangersRangers 1 - 1 Maniema UnionManiema ...
05 Ene 24 Etoile de KivuEtoile Kivu 0 - 1 Aigles du CongoAigles ...
15 Dic 23 Dauphins NoirsDauphins 0 - 0 AS Vita ClubVita Club ...
13 Dic 23 Kuya SportKuya Sport 0 - 0 RenaissanceRenaissance ...
17 Dic 23 Motema PembeMotema 1 - 1 Celeste FCCeleste FC ...
Jornada 16
13 Dic 23 Groupe BazanoGroupe 0 - 1 Don Bosco LubumbashiBosco ...
22 Nov 23 TshinkunkuTshinkunku 0 - 2 Sanga BalendeSanga ...
04 Ene 24 TP MazembeTP Mazembe 8 - 0 Lubumbashi SportLubumbashi ...
13 Dic 23 SimbaSimba 0 - 0 BlessingBlessing ...
14 Dic 23 Saint-Eloi LupopoSaint-Eloi 1 - 0 Panda 05Panda 05 ...
07 Dic 23 Motema PembeMotema 2 - 1 RangersRangers ...
27 Nov 23 Aigles du CongoAigles 3 - 1 Kuya SportKuya Sport ...
04 Ene 24 Celeste FCCeleste FC 0 - 0 RenaissanceRenaissance ...
07 Ene 24 Maniema UnionManiema 1 - 2 Dauphins NoirsDauphins ...
06 Dic 23 AS Vita ClubVita Club 3 - 0 Etoile de KivuEtoile Kivu ...
Jornada 17
16 Dic 23 Don Bosco LubumbashiBosco 0 - 2 SimbaSimba ...
07 Ene 24 Sanga BalendeSanga Apl TP MazembeTP Mazembe ...
17 Dic 23 BlessingBlessing 1 - 1 TshinkunkuTshinkunku ...
17 Dic 23 Lubumbashi SportLubumbashi 1 - 3 Saint-Eloi LupopoSaint-Eloi ...
17 Dic 23 Panda 05Panda 05 2 - 1 Groupe BazanoGroupe ...
23 Nov 23 Kuya SportKuya Sport 0 - 1 AS Vita ClubVita Club ...
30 Dic 23 RangersRangers 2 - 1 Celeste FCCeleste FC ...
24 Dic 23 Dauphins NoirsDauphins 3 - 2 Motema PembeMotema ...
13 Dic 23 Etoile de KivuEtoile Kivu 1 - 3 Maniema UnionManiema ...
16 Dic 23 RenaissanceRenaissance 2 - 1 Aigles du CongoAigles ...
Jornada 18
04 Ene 24 Don Bosco LubumbashiBosco 3 - 0 Panda 05Panda 05 ...
23 Dic 23 SimbaSimba 3 - 0 TshinkunkuTshinkunku ...
13 Ene 24 TP MazembeTP Mazembe 5 - 1 BlessingBlessing ...
27 Dic 23 Groupe BazanoGroupe 1 - 3 Lubumbashi SportLubumbashi ...
26 Nov 23 Saint-Eloi LupopoSaint-Eloi 1 - 0 Sanga BalendeSanga ...
04 Ene 24 Maniema UnionManiema 3 - 0 Kuya SportKuya Sport ...
02 Dic 23 Motema PembeMotema 2 - 1 Etoile de KivuEtoile Kivu ...
26 Nov 23 RangersRangers 1 - 1 Dauphins NoirsDauphins ...
24 Dic 23 AS Vita ClubVita Club 2 - 0 RenaissanceRenaissance ...
13 Dic 23 Celeste FCCeleste FC 1 - 0 Aigles du CongoAigles ...

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Saint-Eloi Lupopo Saint-Eloi 17 36 7 46
2 TP Mazembe TP Mazembe 16 52 7 40
3 Lubumbashi Sport Lubumbashi 18 31 24 33
4 Don Bosco Lubumbashi Bosco 18 23 23 28
5 Simba Simba 18 18 15 23
6 Blessing Blessing 18 21 24 23
7 Sanga Balende Sanga 16 12 20 16
8 Panda 05 Panda 05 18 9 28 15
9 Groupe Bazano Groupe 17 20 44 8
10 Tshinkunku Tshinkunku 18 11 41 7
11 Maniema Union Maniema 18 36 11 43
12 AS Vita Club Vita Club 17 20 9 31
13 Motema Pembe Motema Pembe 17 22 14 31
14 Dauphins Noirs Dauphins 17 17 13 29
15 Aigles du Congo Aigles Congo 18 18 15 26
16 Renaissance Renaissance 17 21 22 21
17 Etoile de Kivu Etoile Kivu 18 20 25 20
18 Celeste FC Celeste FC 18 11 24 16
19 Kuya Sport Kuya Sport 18 11 26 16
20 Rangers Rangers 18 12 29 14

  USO DE MEMORIA  
6,258,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4716
Total Execution Time  0.4735
  CADENA URL  
/super_liga_republica_congo2024/grupo1/calendario
  GET DATOS  
$_GET['/super_liga_republica_congo2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0148  SELECT type FROM routes WHERE alias = 'super_liga_republica_congo2024'
0.0302  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_liga_republica_congo' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1420 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1420 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1285662,892035,572818,186234,155657) ORDER BY n.cover_points DESC, update_date DESC
0.0144  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1420 ORDER BY order_id ASC
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1420 GROUP BY l.categoryId
0.0145  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=1420 GROUP BY l.year ORDER BY l.year DESC
0.0153  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 72768 ORDER BY round ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 06:28:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 06:28:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 06:28:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 06:28:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_liga_republica_congo' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0158  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 events2024 e ON e.player_id = p.id AND e.league_id = 72768 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72768 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.0149  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 events2024 e ON e.player_id = p.id AND e.league_id = 72768 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72768 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  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 events2024 e ON e.player_id = p.id AND e.league_id = 72768 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72768 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0216  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 72768 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