4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
10 Sep 23 E. RosellE. Rosell 4 - 1 CinctorraCinctorra 1
09 Sep 23 BenasalBenasal 1 - 0 VillafamesVillafames ...
10 Sep 23 Vilanova D'AlcoleaVilanova 7 - 2 CanetCanet ...
10 Sep 23 CaligCalig 3 - 3 VinromaVinroma ...
10 Sep 23 Benlloch ABenlloch A 1 - 2 Eture FCEture FC ...
10 Sep 23 CF AlbocàsserAlbocàsser 3 - 5 SalsadellaSalsadella ...
10 Sep 23 P. TornesaP. Tornesa 2 - 1 CatíCatí ...
Jornada 2
17 Sep 23 CinctorraCinctorra 1 - 0 P. TornesaP. Tornesa ...
16 Sep 23 VillafamesVillafames 4 - 0 E. RosellE. Rosell 1
17 Sep 23 CanetCanet 0 - 4 BenasalBenasal ...
17 Sep 23 VinromaVinroma 3 - 2 Vilanova D'AlcoleaVilanova ...
16 Sep 23 Eture FCEture FC 4 - 1 CaligCalig 1
17 Sep 23 Benlloch ABenlloch A 1 - 3 SalsadellaSalsadella ...
17 Sep 23 CatíCatí 4 - 2 UD Sant MateuSant Mateu ...
Jornada 3
24 Sep 23 CinctorraCinctorra 3 - 3 VillafamesVillafames ...
24 Sep 23 E. RosellE. Rosell 3 - 0 CanetCanet 1
23 Sep 23 BenasalBenasal 5 - 1 VinromaVinroma ...
23 Sep 23 Vilanova D'AlcoleaVilanova 0 - 4 Eture FCEture FC ...
24 Sep 23 CaligCalig 1 - 2 SalsadellaSalsadella ...
24 Sep 23 CF AlbocàsserAlbocàsser 0 - 2 CatíCatí ...
23 Sep 23 P. TornesaP. Tornesa 2 - 1 UD Sant MateuSant Mateu 1
Jornada 4
30 Sep 23 VillafamesVillafames 1 - 0 P. TornesaP. Tornesa ...
01 Oct 23 CanetCanet 2 - 2 CinctorraCinctorra ...
01 Oct 23 VinromaVinroma 1 - 3 E. RosellE. Rosell ...
30 Sep 23 Eture FCEture FC 1 - 0 BenasalBenasal ...
01 Oct 23 Vilanova D'AlcoleaVilanova 1 - 2 SalsadellaSalsadella ...
01 Oct 23 CatíCatí 4 - 1 Benlloch ABenlloch A ...
30 Sep 23 UD Sant MateuSant Mateu 2 - 2 CF AlbocàsserAlbocàsser ...
Jornada 5
08 Oct 23 VillafamesVillafames 1 - 0 CanetCanet ...
07 Oct 23 CinctorraCinctorra 1 - 0 VinromaVinroma ...
06 Oct 23 E. RosellE. Rosell 4 - 0 Eture FCEture FC 2
07 Oct 23 BenasalBenasal 3 - 0 SalsadellaSalsadella ...
07 Oct 23 CaligCalig 1 - 2 CatíCatí ...
08 Oct 23 Benlloch ABenlloch A 1 - 6 UD Sant MateuSant Mateu ...
08 Oct 23 P. TornesaP. Tornesa 3 - 1 CF AlbocàsserAlbocàsser ...
Jornada 6
22 Oct 23 CanetCanet 1 - 1 P. TornesaP. Tornesa ...
22 Oct 23 VinromaVinroma 1 - 3 VillafamesVillafames ...
22 Oct 23 Eture FCEture FC 4 - 2 CinctorraCinctorra ...
22 Oct 23 SalsadellaSalsadella 0 - 0 E. RosellE. Rosell ...
20 Oct 23 CatíCatí 3 - 0 Vilanova D'AlcoleaVilanova ...
21 Oct 23 UD Sant MateuSant Mateu 2 - 2 CaligCalig ...
21 Oct 23 CF AlbocàsserAlbocàsser 2 - 5 Benlloch ABenlloch A ...
Jornada 7
29 Oct 23 CanetCanet 4 - 2 VinromaVinroma ...
28 Oct 23 VillafamesVillafames 2 - 1 Eture FCEture FC ...
29 Oct 23 CinctorraCinctorra 0 - 0 SalsadellaSalsadella ...
28 Oct 23 BenasalBenasal 1 - 0 CatíCatí ...
29 Oct 23 Vilanova D'AlcoleaVilanova 3 - 1 UD Sant MateuSant Mateu ...
29 Oct 23 CaligCalig 2 - 3 CF AlbocàsserAlbocàsser ...
29 Oct 23 P. TornesaP. Tornesa 2 - 0 Benlloch ABenlloch A ...
Jornada 8
05 Nov 23 VinromaVinroma 2 - 1 P. TornesaP. Tornesa ...
04 Nov 23 Eture FCEture FC 7 - 0 CanetCanet ...
05 Nov 23 SalsadellaSalsadella 2 - 2 VillafamesVillafames ...
05 Nov 23 CatíCatí 2 - 3 E. RosellE. Rosell ...
05 Nov 23 UD Sant MateuSant Mateu 2 - 1 BenasalBenasal ...
05 Nov 23 CF AlbocàsserAlbocàsser 0 - 1 Vilanova D'AlcoleaVilanova ...
04 Nov 23 Benlloch ABenlloch A 3 - 3 CaligCalig ...
Jornada 9
12 Nov 23 VinromaVinroma 2 - 0 Eture FCEture FC ...
12 Nov 23 CanetCanet 1 - 2 SalsadellaSalsadella ...
11 Nov 23 CinctorraCinctorra 0 - 2 CatíCatí ...
12 Nov 23 E. RosellE. Rosell 3 - 2 UD Sant MateuSant Mateu ...
11 Nov 23 BenasalBenasal 4 - 2 CF AlbocàsserAlbocàsser ...
12 Nov 23 Vilanova D'AlcoleaVilanova 3 - 3 Benlloch ABenlloch A ...
12 Nov 23 P. TornesaP. Tornesa 2 - 3 CaligCalig ...
Jornada 10
19 Nov 23 Eture FCEture FC 3 - 0 P. TornesaP. Tornesa ...
19 Nov 23 SalsadellaSalsadella 1 - 1 VinromaVinroma ...
19 Nov 23 CatíCatí 1 - 1 VillafamesVillafames ...
17 Nov 23 UD Sant MateuSant Mateu 7 - 0 CinctorraCinctorra ...
19 Nov 23 CF AlbocàsserAlbocàsser 3 - 3 E. RosellE. Rosell ...
19 Nov 23 Benlloch ABenlloch A 3 - 3 BenasalBenasal ...
19 Nov 23 CaligCalig 0 - 2 Vilanova D'AlcoleaVilanova ...
Jornada 11
25 Nov 23 Eture FCEture FC 3 - 0 SalsadellaSalsadella ...
25 Nov 23 CanetCanet 2 - 4 CatíCatí ...
25 Nov 23 VillafamesVillafames 5 - 1 UD Sant MateuSant Mateu ...
25 Nov 23 CinctorraCinctorra 2 - 2 CF AlbocàsserAlbocàsser ...
26 Nov 23 E. RosellE. Rosell 3 - 2 Benlloch ABenlloch A ...
25 Nov 23 BenasalBenasal 5 - 0 CaligCalig ...
26 Nov 23 P. TornesaP. Tornesa 0 - 0 Vilanova D'AlcoleaVilanova ...
Jornada 12
03 Dic 23 SalsadellaSalsadella 2 - 0 P. TornesaP. Tornesa ...
02 Dic 23 CatíCatí 4 - 0 VinromaVinroma ...
02 Dic 23 UD Sant MateuSant Mateu 2 - 1 CanetCanet ...
03 Dic 23 CF AlbocàsserAlbocàsser 0 - 3 VillafamesVillafames ...
02 Dic 23 Benlloch ABenlloch A 3 - 1 CinctorraCinctorra ...
03 Dic 23 CaligCalig 2 - 1 E. RosellE. Rosell ...
03 Dic 23 Vilanova D'AlcoleaVilanova 0 - 3 BenasalBenasal ...
Jornada 13
16 Dic 23 Eture FCEture FC 1 - 1 CatíCatí ...
17 Dic 23 VinromaVinroma 1 - 2 UD Sant MateuSant Mateu ...
17 Dic 23 CanetCanet 1 - 0 CF AlbocàsserAlbocàsser ...
16 Dic 23 VillafamesVillafames 3 - 0 Benlloch ABenlloch A ...
17 Dic 23 CinctorraCinctorra 3 - 6 CaligCalig ...
16 Dic 23 E. RosellE. Rosell 3 - 2 Vilanova D'AlcoleaVilanova ...
17 Dic 23 P. TornesaP. Tornesa 1 - 0 BenasalBenasal ...
Jornada 14
14 Ene 24 CatíCatí 1 - 0 SalsadellaSalsadella ...
14 Ene 24 UD Sant MateuSant Mateu 1 - 1 Eture FCEture FC ...
14 Ene 24 CF AlbocàsserAlbocàsser 1 - 2 VinromaVinroma ...
14 Ene 24 Benlloch ABenlloch A 1 - 1 CanetCanet ...
14 Ene 24 CaligCalig 1 - 1 VillafamesVillafames ...
14 Ene 24 Vilanova D'AlcoleaVilanova 2 - 2 CinctorraCinctorra ...
13 Ene 24 BenasalBenasal 2 - 1 E. RosellE. Rosell ...
Jornada 15
21 Ene 24 SalsadellaSalsadella 3 - 1 UD Sant MateuSant Mateu ...
07 Feb 24 Eture FCEture FC 3 - 0 CF AlbocàsserAlbocàsser ...
21 Ene 24 VinromaVinroma 1 - 1 Benlloch ABenlloch A ...
21 Ene 24 CanetCanet 3 - 3 CaligCalig ...
19 Ene 24 VillafamesVillafames 5 - 1 Vilanova D'AlcoleaVilanova ...
21 Ene 24 CinctorraCinctorra 0 - 2 BenasalBenasal ...
20 Ene 24 E. RosellE. Rosell 3 - 0 P. TornesaP. Tornesa ...
Jornada 16
28 Ene 24 CinctorraCinctorra 3 - 3 E. RosellE. Rosell ...
27 Ene 24 VillafamesVillafames 1 - 1 BenasalBenasal ...
28 Ene 24 CanetCanet 0 - 1 Vilanova D'AlcoleaVilanova ...
28 Ene 24 VinromaVinroma 1 - 0 CaligCalig ...
28 Ene 24 Eture FCEture FC 2 - 0 Benlloch ABenlloch A ...
28 Ene 24 SalsadellaSalsadella 3 - 2 CF AlbocàsserAlbocàsser ...
28 Ene 24 CatíCatí 4 - 0 P. TornesaP. Tornesa ...
Jornada 17
04 Feb 24 P. TornesaP. Tornesa 3 - 0 CinctorraCinctorra ...
03 Feb 24 E. RosellE. Rosell 1 - 1 VillafamesVillafames ...
03 Feb 24 BenasalBenasal 4 - 4 CanetCanet ...
04 Feb 24 Vilanova D'AlcoleaVilanova 4 - 1 VinromaVinroma ...
04 Feb 24 CaligCalig 0 - 1 Eture FCEture FC ...
04 Feb 24 SalsadellaSalsadella 5 - 1 Benlloch ABenlloch A ...
02 Feb 24 UD Sant MateuSant Mateu 0 - 5 CatíCatí ...
Jornada 18
09 Feb 24 VillafamesVillafames 3 - 0 CinctorraCinctorra ...
09 Feb 24 CanetCanet 1 - 3 E. RosellE. Rosell ...
11 Feb 24 VinromaVinroma 1 - 1 BenasalBenasal ...
11 Feb 24 Eture FCEture FC 5 - 1 Vilanova D'AlcoleaVilanova ...
10 Feb 24 SalsadellaSalsadella 3 - 1 CaligCalig ...
10 Feb 24 CatíCatí 2 - 1 CF AlbocàsserAlbocàsser ...
10 Feb 24 UD Sant MateuSant Mateu 2 - 4 P. TornesaP. Tornesa ...
Jornada 19
18 Feb 24 P. TornesaP. Tornesa 2 - 2 VillafamesVillafames ...
17 Feb 24 CinctorraCinctorra 2 - 5 CanetCanet ...
17 Feb 24 E. RosellE. Rosell 3 - 0 VinromaVinroma ...
17 Feb 24 BenasalBenasal 3 - 1 Eture FCEture FC ...
18 Feb 24 SalsadellaSalsadella 3 - 0 Vilanova D'AlcoleaVilanova ...
18 Feb 24 Benlloch ABenlloch A 0 - 1 CatíCatí ...
17 Feb 24 CF AlbocàsserAlbocàsser 2 - 3 UD Sant MateuSant Mateu ...
Jornada 20
15 Mar 24 CanetCanet 0 - 2 VillafamesVillafames ...
25 Feb 24 VinromaVinroma Apl CinctorraCinctorra ...
27 Mar 24 Eture FCEture FC 3 - 1 E. RosellE. Rosell ...
01 May 24 SalsadellaSalsadella 0 - 1 BenasalBenasal ...
31 Mar 24 CatíCatí 3 - 1 CaligCalig ...
01 May 24 UD Sant MateuSant Mateu 3 - 2 Benlloch ABenlloch A ...
28 Mar 24 CF AlbocàsserAlbocàsser 0 - 4 P. TornesaP. Tornesa ...
Jornada 21
01 Mar 24 P. TornesaP. Tornesa 3 - 3 CanetCanet ...
01 Mar 24 VillafamesVillafames 3 - 0 VinromaVinroma ...
02 Mar 24 CinctorraCinctorra 1 - 5 Eture FCEture FC ...
01 Mar 24 E. RosellE. Rosell 4 - 3 SalsadellaSalsadella ...
01 Mar 24 Vilanova D'AlcoleaVilanova 0 - 1 CatíCatí ...
03 Mar 24 CaligCalig 2 - 0 UD Sant MateuSant Mateu ...
29 Feb 24 Benlloch ABenlloch A 4 - 2 CF AlbocàsserAlbocàsser ...
Jornada 22
10 Mar 24 VinromaVinroma 2 - 2 CanetCanet ...
10 Mar 24 Eture FCEture FC 2 - 0 VillafamesVillafames ...
08 Mar 24 SalsadellaSalsadella 0 - 0 CinctorraCinctorra ...
17 Mar 24 CatíCatí 2 - 1 BenasalBenasal ...
16 Mar 24 UD Sant MateuSant Mateu 2 - 5 Vilanova D'AlcoleaVilanova ...
08 Mar 24 CF AlbocàsserAlbocàsser 0 - 1 CaligCalig ...
17 Mar 24 Benlloch ABenlloch A 4 - 4 P. TornesaP. Tornesa ...
Jornada 23
24 Mar 24 P. TornesaP. Tornesa 1 - 1 VinromaVinroma ...
24 Mar 24 CanetCanet 1 - 2 Eture FCEture FC ...
23 Mar 24 VillafamesVillafames 3 - 1 SalsadellaSalsadella ...
23 Mar 24 E. RosellE. Rosell 2 - 2 CatíCatí ...
23 Mar 24 BenasalBenasal 2 - 0 UD Sant MateuSant Mateu ...
24 Mar 24 Vilanova D'AlcoleaVilanova 1 - 1 CF AlbocàsserAlbocàsser ...
24 Mar 24 CaligCalig 3 - 1 Benlloch ABenlloch A ...
Jornada 24
07 Abr 24 Eture FCEture FC 2 - 1 VinromaVinroma ...
07 Abr 24 SalsadellaSalsadella 5 - 2 CanetCanet ...
07 Abr 24 CatíCatí 5 - 0 CinctorraCinctorra ...
07 Abr 24 UD Sant MateuSant Mateu 1 - 3 E. RosellE. Rosell ...
07 Abr 24 CF AlbocàsserAlbocàsser 1 - 3 BenasalBenasal ...
05 Abr 24 Benlloch ABenlloch A 0 - 0 Vilanova D'AlcoleaVilanova ...
07 Abr 24 CaligCalig 1 - 2 P. TornesaP. Tornesa ...
Jornada 25
14 Abr 24 P. TornesaP. Tornesa 0 - 4 Eture FCEture FC ...
14 Abr 24 VinromaVinroma 1 - 2 SalsadellaSalsadella ...
12 Abr 24 VillafamesVillafames 2 - 0 CatíCatí ...
29 Mar 24 CinctorraCinctorra 2 - 2 UD Sant MateuSant Mateu ...
13 Abr 24 E. RosellE. Rosell 5 - 1 CF AlbocàsserAlbocàsser ...
14 Abr 24 BenasalBenasal 5 - 1 Benlloch ABenlloch A ...
14 Abr 24 Vilanova D'AlcoleaVilanova 3 - 2 CaligCalig ...
Jornada 26
21 Abr 24 SalsadellaSalsadella 2 - 2 Eture FCEture FC ...
20 Abr 24 CatíCatí 6 - 5 CanetCanet ...
20 Abr 24 UD Sant MateuSant Mateu 0 - 3 VillafamesVillafames ...
21 Abr 24 CF AlbocàsserAlbocàsser 2 - 1 CinctorraCinctorra ...
19 Abr 24 Benlloch ABenlloch A 0 - 4 E. RosellE. Rosell ...
21 Abr 24 CaligCalig 0 - 3 BenasalBenasal ...
20 Abr 24 Vilanova D'AlcoleaVilanova 3 - 3 P. TornesaP. Tornesa ...
Jornada 27
27 Abr 24 P. TornesaP. Tornesa 0 - 3 SalsadellaSalsadella ...
28 Abr 24 VinromaVinroma 2 - 2 CatíCatí ...
26 Abr 24 CanetCanet 1 - 2 UD Sant MateuSant Mateu ...
26 Abr 24 VillafamesVillafames 5 - 0 CF AlbocàsserAlbocàsser ...
26 Abr 24 CinctorraCinctorra 1 - 1 Benlloch ABenlloch A ...
28 Abr 24 E. RosellE. Rosell 4 - 0 CaligCalig ...
27 Abr 24 BenasalBenasal 4 - 0 Vilanova D'AlcoleaVilanova ...
Jornada 28
05 May 24 CatíCatí
17:30
Eture FCEture FC ...
05 May 24 UD Sant MateuSant Mateu
18:00
VinromaVinroma ...
05 May 24 CF AlbocàsserAlbocàsser
17:30
CanetCanet ...
05 May 24 Benlloch ABenlloch A
18:00
VillafamesVillafames ...
05 May 24 CaligCalig
17:00
CinctorraCinctorra ...
05 May 24 Vilanova D'AlcoleaVilanova
17:00
E. RosellE. Rosell ...
05 May 24 BenasalBenasal
16:30
P. TornesaP. Tornesa ...
Jornada 29
12 May 24 SalsadellaSalsadella
16:00
CatíCatí ...
11 May 24 Eture FCEture FC
15:00
UD Sant MateuSant Mateu ...
12 May 24 VinromaVinroma
16:30
CF AlbocàsserAlbocàsser ...
12 May 24 CanetCanet
16:30
Benlloch ABenlloch A ...
11 May 24 VillafamesVillafames
16:30
CaligCalig ...
11 May 24 CinctorraCinctorra
16:00
Vilanova D'AlcoleaVilanova ...
12 May 24 E. RosellE. Rosell
16:00
BenasalBenasal ...
Jornada 30
19 May 24 UD Sant MateuSant Mateu
16:00
SalsadellaSalsadella ...
19 May 24 CF AlbocàsserAlbocàsser
16:00
Eture FCEture FC ...
19 May 24 Benlloch ABenlloch A
12:00
VinromaVinroma ...
19 May 24 CaligCalig
16:00
CanetCanet ...
19 May 24 Vilanova D'AlcoleaVilanova
16:00
VillafamesVillafames ...
18 May 24 BenasalBenasal
16:45
CinctorraCinctorra ...
19 May 24 P. TornesaP. Tornesa
16:00
E. RosellE. Rosell ...

Clasificación

Equipo PJ GF GC Puntos
1 Eture FC Eture FC 25 63 24 57
2 Catí Catí 25 62 26 57
3 Villafames Villafames 24 54 19 52
4 E. Rosell E. Rosell 24 63 36 50
5 Benasal Benasal 23 57 22 49
6 Salsadella Salsadella 24 49 34 45
7 P. Tornesa P. Tornesa 25 40 43 34
8 Vilanova D'Alcolea Vilanova 24 42 49 30
9 Calig Calig 24 39 53 23
10 UD Sant Mateu Sant Mateu 23 42 57 22
11 Vinroma Vinroma 23 28 49 21
12 Benlloch A Benlloch A 23 36 63 16
13 Canet Canet 24 41 69 16
14 Cinctorra Cinctorra 23 27 65 14
15 CF Albocàsser Albocàsser 24 31 65 10

  USO DE MEMORIA  
6,219,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1140
Total Execution Time  0.1160
  CADENA URL  
/segunda_regional_valencia2024/grupo1/calendario
  GET DATOS  
$_GET['/segunda_regional_valencia2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_regional_valencia' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1138 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1138 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 (1101307,897109,807251,696318,583427) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1138 ORDER BY order_id ASC
0.0020  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 = 73835 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0046  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 = 73835 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-04 20:51:53' 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-04 20:51:53' 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-04 20:51:53' 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=3 AND last_update > '2024-05-04 20:51:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  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 = 73835 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73835 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.0020  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 = 73835 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73835 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 events2024 e ON e.player_id = p.id AND e.league_id = 73835 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73835 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  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 = 73835 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC