4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
26 Ago 23 AF ViroisAF Virois 2 - 0 Beauvais OiseBeauvais ...
26 Ago 23 ChamblyChambly 2 - 0 GranvilleGranville ...
26 Ago 23 Lorient IILorient II 2 - 3 US BoulogneBoulogne ...
26 Ago 23 AubervilliersAubervillie 1 - 2 Voltigeurs ChâteaubriantVoltigeurs ...
26 Ago 23 Racing ParisRacing 2 - 1 Bastia-BorgoBastia-Borg ...
26 Ago 23 Stade BriochinStade 0 - 0 Dinan-LéhonDinan-Lého ...
26 Ago 23 Saint-MaloSaint-Malo 1 - 0 Guingamp IIGuingamp ...
Jornada 2
02 Sep 23 AF ViroisAF Virois 1 - 2 ChamblyChambly ...
02 Sep 23 Beauvais OiseBeauvais 3 - 1 Racing ParisRacing ...
02 Sep 23 Dinan-LéhonDinan-Lého 2 - 0 AubervilliersAubervillie ...
02 Sep 23 Guingamp IIGuingamp 1 - 0 Lorient IILorient II ...
02 Sep 23 Bastia-BorgoBastia-Borg 1 - 2 Saint-MaloSaint-Malo ...
01 Sep 23 US BoulogneBoulogne 2 - 1 Stade BriochinStade ...
02 Sep 23 Voltigeurs ChâteaubriantVoltigeurs 1 - 1 GranvilleGranville ...
Jornada 3
09 Sep 23 ChamblyChambly 1 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
09 Sep 23 Lorient IILorient II 4 - 2 Bastia-BorgoBastia-Borg ...
09 Sep 23 AubervilliersAubervillie 2 - 2 US BoulogneBoulogne ...
09 Sep 23 Racing ParisRacing 3 - 2 AF ViroisAF Virois ...
08 Sep 23 Stade BriochinStade 1 - 2 Guingamp IIGuingamp ...
09 Sep 23 GranvilleGranville 3 - 1 Dinan-LéhonDinan-Lého ...
09 Sep 23 Saint-MaloSaint-Malo 1 - 1 Beauvais OiseBeauvais ...
Jornada 4
16 Sep 23 AF ViroisAF Virois 0 - 2 Saint-MaloSaint-Malo ...
16 Sep 23 Beauvais OiseBeauvais 2 - 2 Lorient IILorient II ...
16 Sep 23 Dinan-LéhonDinan-Lého 1 - 1 Voltigeurs ChâteaubriantVoltigeurs ...
16 Sep 23 Guingamp IIGuingamp 2 - 3 AubervilliersAubervillie ...
15 Sep 23 Bastia-BorgoBastia-Borg 2 - 2 Stade BriochinStade ...
16 Sep 23 Racing ParisRacing 0 - 0 ChamblyChambly ...
15 Sep 23 US BoulogneBoulogne 0 - 0 GranvilleGranville ...
Jornada 5
23 Sep 23 ChamblyChambly 1 - 1 Dinan-LéhonDinan-Lého ...
23 Sep 23 Lorient IILorient II 1 - 0 AF ViroisAF Virois ...
23 Sep 23 AubervilliersAubervillie 1 - 0 Bastia-BorgoBastia-Borg ...
22 Sep 23 Stade BriochinStade 4 - 1 Beauvais OiseBeauvais ...
23 Sep 23 GranvilleGranville 2 - 2 Guingamp IIGuingamp ...
23 Sep 23 Saint-MaloSaint-Malo 2 - 3 Racing ParisRacing ...
23 Sep 23 Voltigeurs ChâteaubriantVoltigeurs 1 - 1 US BoulogneBoulogne ...
Jornada 6
07 Oct 23 AF ViroisAF Virois 1 - 0 Stade BriochinStade ...
07 Oct 23 Beauvais OiseBeauvais 2 - 0 AubervilliersAubervillie ...
07 Oct 23 Guingamp IIGuingamp 0 - 1 Voltigeurs ChâteaubriantVoltigeurs ...
07 Oct 23 Bastia-BorgoBastia-Borg 3 - 1 GranvilleGranville ...
07 Oct 23 Racing ParisRacing 1 - 0 Lorient IILorient II ...
07 Oct 23 US BoulogneBoulogne 2 - 1 Dinan-LéhonDinan-Lého ...
07 Oct 23 Saint-MaloSaint-Malo 2 - 2 ChamblyChambly ...
Jornada 7
21 Oct 23 Dinan-LéhonDinan-Lého 2 - 1 Guingamp IIGuingamp ...
20 Oct 23 ChamblyChambly 2 - 3 US BoulogneBoulogne ...
21 Oct 23 Lorient IILorient II 0 - 3 Saint-MaloSaint-Malo ...
21 Oct 23 AubervilliersAubervillie 2 - 1 AF ViroisAF Virois ...
21 Oct 23 Stade BriochinStade 0 - 0 Racing ParisRacing ...
21 Oct 23 GranvilleGranville 2 - 1 Beauvais OiseBeauvais ...
21 Oct 23 Voltigeurs ChâteaubriantVoltigeurs 1 - 2 Bastia-BorgoBastia-Borg ...
Jornada 8
04 Nov 23 AF ViroisAF Virois 0 - 1 GranvilleGranville ...
04 Nov 23 Beauvais OiseBeauvais 0 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
04 Nov 23 Guingamp IIGuingamp 0 - 3 US BoulogneBoulogne ...
04 Nov 23 Bastia-BorgoBastia-Borg 4 - 4 Dinan-LéhonDinan-Lého ...
27 Ene 24 Lorient IILorient II 0 - 0 ChamblyChambly ...
05 Nov 23 Racing ParisRacing 0 - 1 AubervilliersAubervillie ...
04 Nov 23 Saint-MaloSaint-Malo 1 - 3 Stade BriochinStade ...
Jornada 9
11 Nov 23 Dinan-LéhonDinan-Lého 3 - 1 Beauvais OiseBeauvais ...
10 Nov 23 ChamblyChambly 4 - 1 Guingamp IIGuingamp ...
11 Nov 23 AubervilliersAubervillie 1 - 0 Saint-MaloSaint-Malo ...
10 Nov 23 Stade BriochinStade 2 - 1 Lorient IILorient II ...
10 Nov 23 US BoulogneBoulogne 2 - 0 Bastia-BorgoBastia-Borg ...
11 Nov 23 GranvilleGranville 3 - 1 Racing ParisRacing ...
11 Nov 23 Voltigeurs ChâteaubriantVoltigeurs 2 - 1 AF ViroisAF Virois ...
Jornada 10
25 Nov 23 AF ViroisAF Virois 3 - 1 Dinan-LéhonDinan-Lého ...
25 Nov 23 Beauvais OiseBeauvais 0 - 1 US BoulogneBoulogne ...
25 Nov 23 Bastia-BorgoBastia-Borg 2 - 1 Guingamp IIGuingamp ...
25 Nov 23 Lorient IILorient II 2 - 3 AubervilliersAubervillie ...
25 Nov 23 Racing ParisRacing 2 - 2 Voltigeurs ChâteaubriantVoltigeurs ...
24 Nov 23 Stade BriochinStade 0 - 1 ChamblyChambly ...
25 Nov 23 Saint-MaloSaint-Malo 1 - 1 GranvilleGranville ...
Jornada 11
02 Dic 23 Dinan-LéhonDinan-Lého 2 - 1 Racing ParisRacing ...
02 Dic 23 Guingamp IIGuingamp 0 - 1 Beauvais OiseBeauvais ...
01 Dic 23 ChamblyChambly 1 - 0 Bastia-BorgoBastia-Borg ...
02 Dic 23 AubervilliersAubervillie 3 - 1 Stade BriochinStade ...
02 Dic 23 US BoulogneBoulogne 2 - 1 AF ViroisAF Virois ...
02 Dic 23 GranvilleGranville 2 - 1 Lorient IILorient II ...
02 Dic 23 Voltigeurs ChâteaubriantVoltigeurs 0 - 3 Saint-MaloSaint-Malo ...
Jornada 12
16 Dic 23 AF ViroisAF Virois 3 - 1 Guingamp IIGuingamp ...
15 Dic 23 Beauvais OiseBeauvais 2 - 1 Bastia-BorgoBastia-Borg ...
16 Dic 23 Lorient IILorient II 1 - 1 Voltigeurs ChâteaubriantVoltigeurs ...
16 Dic 23 AubervilliersAubervillie 2 - 0 ChamblyChambly ...
16 Dic 23 Racing ParisRacing 2 - 1 US BoulogneBoulogne ...
15 Dic 23 Stade BriochinStade 0 - 0 GranvilleGranville ...
16 Dic 23 Saint-MaloSaint-Malo 1 - 2 Dinan-LéhonDinan-Lého ...
Jornada 13
12 Ene 24 Beauvais OiseBeauvais 0 - 2 ChamblyChambly 1
13 Ene 24 Dinan-LéhonDinan-Lého 4 - 1 Lorient IILorient II ...
13 Ene 24 Guingamp IIGuingamp 0 - 2 Racing ParisRacing ...
13 Ene 24 Bastia-BorgoBastia-Borg 3 - 2 AF ViroisAF Virois ...
13 Ene 24 US BoulogneBoulogne 0 - 0 Saint-MaloSaint-Malo ...
13 Ene 24 GranvilleGranville 1 - 0 AubervilliersAubervillie ...
13 Ene 24 Voltigeurs ChâteaubriantVoltigeurs 0 - 1 Stade BriochinStade ...
Jornada 14
20 Ene 24 ChamblyChambly 1 - 2 AF ViroisAF Virois ...
20 Ene 24 Lorient IILorient II 1 - 0 Guingamp IIGuingamp ...
27 Ene 24 AubervilliersAubervillie 2 - 1 Dinan-LéhonDinan-Lého ...
27 Ene 24 Racing ParisRacing 0 - 2 Beauvais OiseBeauvais ...
26 Ene 24 Stade BriochinStade 2 - 1 US BoulogneBoulogne 1
20 Ene 24 GranvilleGranville 3 - 1 Voltigeurs ChâteaubriantVoltigeurs ...
20 Ene 24 Saint-MaloSaint-Malo 3 - 0 Bastia-BorgoBastia-Borg ...
Jornada 15
03 Feb 24 AF ViroisAF Virois 0 - 2 Racing ParisRacing ...
03 Feb 24 Beauvais OiseBeauvais 0 - 0 Saint-MaloSaint-Malo ...
03 Feb 24 Dinan-LéhonDinan-Lého 1 - 2 GranvilleGranville ...
02 Feb 24 Guingamp IIGuingamp 2 - 0 Stade BriochinStade ...
03 Feb 24 Bastia-BorgoBastia-Borg 1 - 0 Lorient IILorient II ...
03 Feb 24 US BoulogneBoulogne 4 - 0 AubervilliersAubervillie ...
03 Feb 24 Voltigeurs ChâteaubriantVoltigeurs 0 - 0 ChamblyChambly ...
Jornada 16
16 Feb 24 ChamblyChambly 1 - 0 Racing ParisRacing 1
17 Feb 24 Lorient IILorient II 1 - 2 Beauvais OiseBeauvais ...
17 Feb 24 AubervilliersAubervillie 1 - 2 Guingamp IIGuingamp ...
16 Feb 24 Stade BriochinStade 3 - 1 Bastia-BorgoBastia-Borg 1
09 Feb 24 GranvilleGranville 2 - 2 US BoulogneBoulogne ...
17 Feb 24 Saint-MaloSaint-Malo 1 - 1 AF ViroisAF Virois ...
17 Feb 24 Voltigeurs ChâteaubriantVoltigeurs 2 - 1 Dinan-LéhonDinan-Lého ...
Jornada 17
13 Mar 24 AF ViroisAF Virois 1 - 1 Lorient IILorient II ...
23 Feb 24 Beauvais OiseBeauvais 2 - 0 Stade BriochinStade ...
24 Feb 24 Dinan-LéhonDinan-Lého 0 - 3 ChamblyChambly ...
24 Feb 24 Guingamp IIGuingamp 1 - 2 GranvilleGranville ...
24 Feb 24 Bastia-BorgoBastia-Borg 2 - 0 AubervilliersAubervillie ...
24 Feb 24 Racing ParisRacing 1 - 0 Saint-MaloSaint-Malo ...
24 Feb 24 US BoulogneBoulogne 2 - 1 Voltigeurs ChâteaubriantVoltigeurs ...
Jornada 18
09 Mar 24 Dinan-LéhonDinan-Lého 1 - 2 US BoulogneBoulogne ...
08 Mar 24 ChamblyChambly 1 - 2 Saint-MaloSaint-Malo ...
09 Mar 24 Lorient IILorient II 2 - 0 Racing ParisRacing ...
09 Mar 24 AubervilliersAubervillie 1 - 1 Beauvais OiseBeauvais ...
09 Mar 24 Stade BriochinStade 2 - 1 AF ViroisAF Virois ...
08 Mar 24 GranvilleGranville 1 - 0 Bastia-BorgoBastia-Borg ...
09 Mar 24 Voltigeurs ChâteaubriantVoltigeurs 3 - 1 Guingamp IIGuingamp ...
Jornada 19
16 Mar 24 AF ViroisAF Virois 2 - 0 AubervilliersAubervillie ...
15 Mar 24 Beauvais OiseBeauvais 2 - 1 GranvilleGranville 1
16 Mar 24 Guingamp IIGuingamp 3 - 1 Dinan-LéhonDinan-Lého ...
16 Mar 24 Bastia-BorgoBastia-Borg 2 - 2 Voltigeurs ChâteaubriantVoltigeurs ...
16 Mar 24 Racing ParisRacing 0 - 1 Stade BriochinStade ...
15 Mar 24 US BoulogneBoulogne 1 - 0 ChamblyChambly 1
16 Mar 24 Saint-MaloSaint-Malo 1 - 1 Lorient IILorient II ...
Jornada 20
23 Mar 24 Dinan-LéhonDinan-Lého 2 - 0 Bastia-BorgoBastia-Borg ...
23 Mar 24 ChamblyChambly 1 - 2 Lorient IILorient II ...
23 Mar 24 AubervilliersAubervillie 2 - 1 Racing ParisRacing ...
22 Mar 24 Stade BriochinStade 0 - 0 Saint-MaloSaint-Malo 8
23 Mar 24 US BoulogneBoulogne 4 - 0 Guingamp IIGuingamp ...
23 Mar 24 GranvilleGranville 1 - 0 AF ViroisAF Virois ...
23 Mar 24 Voltigeurs ChâteaubriantVoltigeurs 1 - 0 Beauvais OiseBeauvais ...
Jornada 21
06 Abr 24 AF ViroisAF Virois 2 - 1 Voltigeurs ChâteaubriantVoltigeurs ...
06 Abr 24 Beauvais OiseBeauvais 7 - 0 Dinan-LéhonDinan-Lého ...
06 Abr 24 Guingamp IIGuingamp 1 - 4 ChamblyChambly ...
05 Abr 24 Bastia-BorgoBastia-Borg 1 - 4 US BoulogneBoulogne 1
06 Abr 24 Lorient IILorient II 2 - 1 Stade BriochinStade ...
06 Abr 24 Racing ParisRacing 0 - 0 GranvilleGranville ...
06 Abr 24 Saint-MaloSaint-Malo 1 - 0 AubervilliersAubervillie ...
Jornada 22
13 Abr 24 Dinan-LéhonDinan-Lého 3 - 2 AF ViroisAF Virois ...
12 Abr 24 Guingamp IIGuingamp 0 - 2 Bastia-BorgoBastia-Borg 1
12 Abr 24 ChamblyChambly 1 - 1 Stade BriochinStade 1
13 Abr 24 AubervilliersAubervillie 1 - 1 Lorient IILorient II ...
12 Abr 24 US BoulogneBoulogne 1 - 1 Beauvais OiseBeauvais 1
13 Abr 24 GranvilleGranville 1 - 3 Saint-MaloSaint-Malo ...
13 Abr 24 Voltigeurs ChâteaubriantVoltigeurs 2 - 1 Racing ParisRacing ...
Jornada 23
20 Abr 24 AF ViroisAF Virois 1 - 0 US BoulogneBoulogne ...
20 Abr 24 Beauvais OiseBeauvais 0 - 3 Guingamp IIGuingamp ...
19 Abr 24 Bastia-BorgoBastia-Borg 0 - 3 ChamblyChambly 1
20 Abr 24 Lorient IILorient II 3 - 2 GranvilleGranville ...
20 Abr 24 Racing ParisRacing 0 - 2 Dinan-LéhonDinan-Lého ...
20 Abr 24 Stade BriochinStade 2 - 0 AubervilliersAubervillie ...
20 Abr 24 Saint-MaloSaint-Malo 2 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
Jornada 24
27 Abr 24 Dinan-LéhonDinan-Lého 2 - 0 Saint-MaloSaint-Malo ...
27 Abr 24 Guingamp IIGuingamp 2 - 2 AF ViroisAF Virois ...
26 Abr 24 Bastia-BorgoBastia-Borg 1 - 0 Beauvais OiseBeauvais 1
27 Abr 24 ChamblyChambly 5 - 2 AubervilliersAubervillie ...
27 Abr 24 US BoulogneBoulogne 3 - 1 Racing ParisRacing ...
26 Abr 24 GranvilleGranville 0 - 3 Stade BriochinStade 1
27 Abr 24 Voltigeurs ChâteaubriantVoltigeurs 2 - 2 Lorient IILorient II ...
Jornada 25
11 May 24 AF ViroisAF Virois
18:00
Bastia-BorgoBastia-Borg ...
11 May 24 ChamblyChambly
18:00
Beauvais OiseBeauvais ...
11 May 24 Lorient IILorient II
18:00
Dinan-LéhonDinan-Lého ...
11 May 24 AubervilliersAubervillie
18:00
GranvilleGranville ...
11 May 24 Racing ParisRacing
18:00
Guingamp IIGuingamp ...
11 May 24 Stade BriochinStade
18:00
Voltigeurs ChâteaubriantVoltigeurs ...
11 May 24 Saint-MaloSaint-Malo
18:00
US BoulogneBoulogne ...
Jornada 26
18 May 24 Beauvais OiseBeauvais
18:00
AF ViroisAF Virois ...
18 May 24 Dinan-LéhonDinan-Lého
18:00
Stade BriochinStade ...
18 May 24 Guingamp IIGuingamp
18:00
Saint-MaloSaint-Malo ...
18 May 24 Bastia-BorgoBastia-Borg
18:00
Racing ParisRacing ...
18 May 24 US BoulogneBoulogne
18:00
Lorient IILorient II ...
18 May 24 GranvilleGranville
18:00
ChamblyChambly ...
18 May 24 Voltigeurs ChâteaubriantVoltigeurs
18:00
AubervilliersAubervillie ...

Clasificación

Equipo PJ GF GC Puntos
1 US Boulogne US Boulogne 24 46 22 51
2 Chambly Chambly 24 38 21 42
3 Granville Granville 24 32 29 40
4 Saint-Malo Saint-Malo 24 32 21 38
5 Stade Briochin Stade 24 30 24 36
6 Dinan-Léhon Dinan-Léhon 24 38 42 34
7 Beauvais Oise Beauvais 24 31 28 33
8 Aubervilliers Aubervillier 24 28 37 33
9 Voltigeurs Châteaubriant Voltigeurs 24 27 31 30
10 Racing Paris Racing Paris 24 24 32 28
11 Lorient II Lorient II 24 31 36 28
12 AF Virois AF Virois 24 31 34 27
13 Bastia-Borgo Bastia-Borgo 24 31 43 27
14 Guingamp II Guingamp II 24 26 45 20

  USO DE MEMORIA  
6,196,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3426
Total Execution Time  0.3445
  CADENA URL  
/ligue_cfa2024/grupo3/calendario
  GET DATOS  
$_GET['/ligue_cfa2024/grupo3/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa' AND (l.group_code = 3 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=3 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=220 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 220 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0130  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 (1303338,1286561,1233296,1230274,1161224) ORDER BY n.cover_points DESC, update_date DESC
0.0127  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 = 72964 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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 72964 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 16:13:59' 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=2 AND last_update > '2024-05-02 16:13:59' 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-02 16:13:59' 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=3 AND last_update > '2024-05-02 16:13:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0181  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 = 72964 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72964 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.0200  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 = 72964 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72964 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 events2024 e ON e.player_id = p.id AND e.league_id = 72964 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72964 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0134  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 = 72964 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC