4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
24 Sep 23 Híjar FCHíjar FC 5 - 2 CalaceiteCalaceite ...
24 Sep 23 Sportin Alcañiz CfSportin 3 - 1 FuensportFuensport ...
24 Sep 23 Polideportivo MontalbanPolideporti 0 - 2 Teruel BTeruel B ...
24 Sep 23 ValdealgorfaValdealgorf 1 - 3 Utrillas BUtrillas B ...
24 Sep 23 TorrecillaTorrecilla 1 - 4 ValderrobresValderrobre ...
24 Sep 23 Samper de CalandaSamper 3 - 2 Maella C.D.Maella C.D. ...
24 Sep 23 CD CalandaCD Calanda 4 - 0 EscatronEscatron ...
Jornada 2
01 Oct 23 FuensportFuensport 6 - 2 Híjar FCHíjar FC ...
30 Sep 23 Teruel BTeruel B 2 - 4 Sportin Alcañiz CfSportin ...
01 Oct 23 Utrillas BUtrillas B 3 - 0 Polideportivo MontalbanPolideporti ...
01 Oct 23 ValderrobresValderrobre 7 - 0 ValdealgorfaValdealgorf 2
01 Oct 23 Maella C.D.Maella C.D. 5 - 0 TorrecillaTorrecilla ...
01 Oct 23 EscatronEscatron 2 - 4 Samper de CalandaSamper ...
01 Oct 23 AlcorisaAlcorisa 1 - 0 CD CalandaCD Calanda ...
Jornada 3
08 Oct 23 CalaceiteCalaceite 2 - 1 FuensportFuensport ...
08 Oct 23 Híjar FCHíjar FC 3 - 2 Teruel BTeruel B ...
07 Oct 23 Sportin Alcañiz CfSportin 6 - 0 Utrillas BUtrillas B ...
08 Oct 23 Polideportivo MontalbanPolideporti 1 - 1 ValderrobresValderrobre ...
08 Oct 23 ValdealgorfaValdealgorf 0 - 2 Maella C.D.Maella C.D. ...
08 Oct 23 TorrecillaTorrecilla 2 - 1 EscatronEscatron ...
08 Oct 23 Samper de CalandaSamper 2 - 0 AlcorisaAlcorisa ...
Jornada 4
15 Oct 23 Teruel BTeruel B 3 - 1 CalaceiteCalaceite ...
15 Oct 23 Utrillas BUtrillas B 0 - 1 Híjar FCHíjar FC ...
15 Oct 23 ValderrobresValderrobre 2 - 3 Sportin Alcañiz CfSportin ...
15 Oct 23 Maella C.D.Maella C.D. 1 - 0 Polideportivo MontalbanPolideporti ...
15 Oct 23 EscatronEscatron 0 - 0 ValdealgorfaValdealgorf ...
15 Oct 23 AlcorisaAlcorisa 6 - 2 TorrecillaTorrecilla ...
15 Oct 23 CD CalandaCD Calanda 2 - 2 Samper de CalandaSamper ...
Jornada 5
22 Oct 23 FuensportFuensport 3 - 2 Teruel BTeruel B ...
22 Oct 23 CalaceiteCalaceite 1 - 2 Utrillas BUtrillas B ...
22 Oct 23 Híjar FCHíjar FC 3 - 1 ValderrobresValderrobre ...
21 Oct 23 Sportin Alcañiz CfSportin 3 - 0 Maella C.D.Maella C.D. ...
22 Oct 23 Polideportivo MontalbanPolideporti 1 - 0 EscatronEscatron ...
22 Oct 23 ValdealgorfaValdealgorf 3 - 4 AlcorisaAlcorisa ...
22 Oct 23 TorrecillaTorrecilla 1 - 1 CD CalandaCD Calanda ...
Jornada 6
29 Oct 23 Utrillas BUtrillas B 1 - 0 FuensportFuensport ...
29 Oct 23 ValderrobresValderrobre 2 - 1 CalaceiteCalaceite ...
29 Oct 23 Maella C.D.Maella C.D. 3 - 2 Híjar FCHíjar FC ...
29 Oct 23 EscatronEscatron 0 - 2 Sportin Alcañiz CfSportin ...
29 Oct 23 AlcorisaAlcorisa 3 - 0 Polideportivo MontalbanPolideporti ...
29 Oct 23 CD CalandaCD Calanda 7 - 1 ValdealgorfaValdealgorf ...
29 Oct 23 Samper de CalandaSamper 2 - 1 TorrecillaTorrecilla ...
Jornada 7
05 Nov 23 Teruel BTeruel B 4 - 1 Utrillas BUtrillas B ...
05 Nov 23 FuensportFuensport 0 - 3 ValderrobresValderrobre ...
05 Nov 23 CalaceiteCalaceite 0 - 3 Maella C.D.Maella C.D. ...
05 Nov 23 Híjar FCHíjar FC 0 - 0 EscatronEscatron ...
05 Nov 23 Sportin Alcañiz CfSportin 6 - 0 AlcorisaAlcorisa ...
05 Nov 23 Polideportivo MontalbanPolideporti 0 - 3 CD CalandaCD Calanda ...
05 Nov 23 ValdealgorfaValdealgorf 0 - 0 Samper de CalandaSamper ...
Jornada 8
12 Nov 23 ValderrobresValderrobre 2 - 1 Teruel BTeruel B ...
12 Nov 23 Maella C.D.Maella C.D. 4 - 3 FuensportFuensport ...
12 Nov 23 EscatronEscatron 0 - 2 CalaceiteCalaceite ...
12 Nov 23 AlcorisaAlcorisa 2 - 0 Híjar FCHíjar FC ...
12 Nov 23 CD CalandaCD Calanda 0 - 2 Sportin Alcañiz CfSportin ...
12 Nov 23 Samper de CalandaSamper 1 - 0 Polideportivo MontalbanPolideporti ...
12 Nov 23 TorrecillaTorrecilla 4 - 0 ValdealgorfaValdealgorf ...
Jornada 9
19 Nov 23 Utrillas BUtrillas B 0 - 2 ValderrobresValderrobre ...
19 Nov 23 Teruel BTeruel B 0 - 3 Maella C.D.Maella C.D. ...
19 Nov 23 FuensportFuensport 7 - 0 EscatronEscatron ...
19 Nov 23 CalaceiteCalaceite 3 - 3 AlcorisaAlcorisa ...
19 Nov 23 Híjar FCHíjar FC 1 - 1 CD CalandaCD Calanda ...
19 Nov 23 Sportin Alcañiz CfSportin 5 - 0 Samper de CalandaSamper ...
19 Nov 23 Polideportivo MontalbanPolideporti 2 - 2 TorrecillaTorrecilla ...
Jornada 10
26 Nov 23 Maella C.D.Maella C.D. 1 - 0 Utrillas BUtrillas B ...
26 Nov 23 EscatronEscatron 2 - 8 Teruel BTeruel B ...
26 Nov 23 AlcorisaAlcorisa 2 - 1 FuensportFuensport ...
26 Nov 23 CD CalandaCD Calanda 3 - 0 CalaceiteCalaceite ...
26 Nov 23 Samper de CalandaSamper 2 - 1 Híjar FCHíjar FC ...
26 Nov 23 TorrecillaTorrecilla 2 - 4 Sportin Alcañiz CfSportin ...
26 Nov 23 ValdealgorfaValdealgorf 1 - 1 Polideportivo MontalbanPolideporti ...
Jornada 11
03 Dic 23 ValderrobresValderrobre 1 - 1 Maella C.D.Maella C.D. ...
03 Dic 23 Utrillas BUtrillas B 3 - 0 EscatronEscatron ...
03 Dic 23 Teruel BTeruel B 2 - 3 AlcorisaAlcorisa ...
03 Dic 23 FuensportFuensport 1 - 1 CD CalandaCD Calanda ...
03 Dic 23 CalaceiteCalaceite 5 - 2 Samper de CalandaSamper ...
03 Dic 23 Híjar FCHíjar FC 2 - 3 TorrecillaTorrecilla ...
03 Dic 23 Sportin Alcañiz CfSportin 6 - 0 ValdealgorfaValdealgorf ...
Jornada 12
17 Dic 23 EscatronEscatron 0 - 7 ValderrobresValderrobre ...
16 Dic 23 AlcorisaAlcorisa 2 - 0 Utrillas BUtrillas B ...
17 Dic 23 CD CalandaCD Calanda 1 - 3 Teruel BTeruel B ...
17 Dic 23 Samper de CalandaSamper 2 - 2 FuensportFuensport ...
17 Dic 23 TorrecillaTorrecilla 3 - 5 CalaceiteCalaceite ...
17 Dic 23 ValdealgorfaValdealgorf 3 - 2 Híjar FCHíjar FC ...
16 Dic 23 Polideportivo MontalbanPolideporti 0 - 2 Sportin Alcañiz CfSportin ...
Jornada 13
07 Ene 24 Maella C.D.Maella C.D. 3 - 0 EscatronEscatron ...
07 Ene 24 ValderrobresValderrobre 3 - 0 AlcorisaAlcorisa ...
07 Ene 24 Utrillas BUtrillas B 1 - 0 CD CalandaCD Calanda ...
07 Ene 24 Teruel BTeruel B 1 - 1 Samper de CalandaSamper ...
07 Ene 24 FuensportFuensport 3 - 0 TorrecillaTorrecilla ...
07 Ene 24 CalaceiteCalaceite 3 - 0 ValdealgorfaValdealgorf ...
07 Ene 24 Híjar FCHíjar FC 3 - 2 Polideportivo MontalbanPolideporti ...
Jornada 14
14 Ene 24 AlcorisaAlcorisa 2 - 1 Maella C.D.Maella C.D. ...
13 Ene 24 CD CalandaCD Calanda 1 - 2 ValderrobresValderrobre ...
14 Ene 24 Samper de CalandaSamper 1 - 0 Utrillas BUtrillas B ...
14 Ene 24 TorrecillaTorrecilla 0 - 2 Teruel BTeruel B ...
14 Ene 24 ValdealgorfaValdealgorf 2 - 1 FuensportFuensport ...
14 Ene 24 Polideportivo MontalbanPolideporti 1 - 0 CalaceiteCalaceite ...
14 Ene 24 Sportin Alcañiz CfSportin 1 - 0 Híjar FCHíjar FC ...
Jornada 15
21 Ene 24 EscatronEscatron 0 - 5 AlcorisaAlcorisa ...
21 Ene 24 Maella C.D.Maella C.D. 1 - 2 CD CalandaCD Calanda ...
21 Ene 24 ValderrobresValderrobre 3 - 1 Samper de CalandaSamper ...
21 Ene 24 Utrillas BUtrillas B 3 - 3 TorrecillaTorrecilla ...
21 Ene 24 ValdealgorfaValdealgorf 3 - 5 Teruel BTeruel B ...
21 Ene 24 FuensportFuensport 3 - 0 Polideportivo MontalbanPolideporti ...
21 Ene 24 CalaceiteCalaceite 2 - 4 Sportin Alcañiz CfSportin ...
Jornada 16
28 Ene 24 CalaceiteCalaceite 2 - 3 Híjar FCHíjar FC ...
28 Ene 24 FuensportFuensport 0 - 1 Sportin Alcañiz CfSportin ...
28 Ene 24 Teruel BTeruel B 1 - 0 Polideportivo MontalbanPolideporti ...
28 Ene 24 Utrillas BUtrillas B 2 - 4 ValdealgorfaValdealgorf ...
28 Ene 24 ValderrobresValderrobre 3 - 0 TorrecillaTorrecilla ...
28 Ene 24 Maella C.D.Maella C.D. 3 - 1 Samper de CalandaSamper ...
28 Ene 24 EscatronEscatron 1 - 4 CD CalandaCD Calanda ...
Jornada 17
04 Feb 24 Híjar FCHíjar FC 3 - 0 FuensportFuensport ...
04 Feb 24 Sportin Alcañiz CfSportin 5 - 1 Teruel BTeruel B ...
04 Feb 24 Polideportivo MontalbanPolideporti 1 - 1 Utrillas BUtrillas B ...
04 Feb 24 ValdealgorfaValdealgorf 0 - 1 ValderrobresValderrobre ...
04 Feb 24 TorrecillaTorrecilla 4 - 2 Maella C.D.Maella C.D. ...
04 Feb 24 Samper de CalandaSamper 4 - 0 EscatronEscatron ...
04 Feb 24 CD CalandaCD Calanda 1 - 2 AlcorisaAlcorisa ...
Jornada 18
11 Feb 24 FuensportFuensport 2 - 2 CalaceiteCalaceite ...
11 Feb 24 Teruel BTeruel B 1 - 4 Híjar FCHíjar FC ...
11 Feb 24 Utrillas BUtrillas B 1 - 3 Sportin Alcañiz CfSportin ...
11 Feb 24 ValderrobresValderrobre 5 - 1 Polideportivo MontalbanPolideporti ...
11 Feb 24 Maella C.D.Maella C.D. 1 - 1 ValdealgorfaValdealgorf ...
11 Feb 24 EscatronEscatron 2 - 2 TorrecillaTorrecilla ...
11 Feb 24 AlcorisaAlcorisa 5 - 0 Samper de CalandaSamper ...
Jornada 19
18 Feb 24 CalaceiteCalaceite 5 - 1 Teruel BTeruel B ...
18 Feb 24 Híjar FCHíjar FC 4 - 1 Utrillas BUtrillas B ...
17 Feb 24 Sportin Alcañiz CfSportin 4 - 2 ValderrobresValderrobre ...
18 Feb 24 Polideportivo MontalbanPolideporti 1 - 0 Maella C.D.Maella C.D. ...
18 Feb 24 ValdealgorfaValdealgorf 1 - 1 EscatronEscatron ...
18 Feb 24 TorrecillaTorrecilla 1 - 3 AlcorisaAlcorisa ...
18 Feb 24 Samper de CalandaSamper 0 - 2 CD CalandaCD Calanda ...
Jornada 20
03 Mar 24 Teruel BTeruel B 2 - 0 FuensportFuensport ...
03 Mar 24 Utrillas BUtrillas B 4 - 2 CalaceiteCalaceite ...
03 Mar 24 ValderrobresValderrobre 0 - 3 Híjar FCHíjar FC ...
25 Feb 24 Maella C.D.Maella C.D. 0 - 5 Sportin Alcañiz CfSportin ...
03 Mar 24 EscatronEscatron 1 - 1 Polideportivo MontalbanPolideporti ...
03 Mar 24 AlcorisaAlcorisa 4 - 0 ValdealgorfaValdealgorf ...
03 Mar 24 CD CalandaCD Calanda 3 - 0 TorrecillaTorrecilla ...
Jornada 21
10 Mar 24 FuensportFuensport Apl Utrillas BUtrillas B ...
10 Mar 24 CalaceiteCalaceite 2 - 3 ValderrobresValderrobre ...
10 Mar 24 Híjar FCHíjar FC 4 - 2 Maella C.D.Maella C.D. ...
10 Mar 24 Sportin Alcañiz CfSportin 5 - 0 EscatronEscatron ...
10 Mar 24 Polideportivo MontalbanPolideporti 2 - 3 AlcorisaAlcorisa ...
10 Mar 24 ValdealgorfaValdealgorf 0 - 2 CD CalandaCD Calanda ...
10 Mar 24 TorrecillaTorrecilla 3 - 0 Samper de CalandaSamper ...
Jornada 22
16 Mar 24 Utrillas BUtrillas B 1 - 2 Teruel BTeruel B ...
17 Mar 24 ValderrobresValderrobre Apl FuensportFuensport ...
17 Mar 24 Maella C.D.Maella C.D. 3 - 2 CalaceiteCalaceite ...
17 Mar 24 EscatronEscatron 1 - 2 Híjar FCHíjar FC ...
17 Mar 24 AlcorisaAlcorisa 1 - 1 Sportin Alcañiz CfSportin ...
17 Mar 24 CD CalandaCD Calanda 1 - 0 Polideportivo MontalbanPolideporti ...
17 Mar 24 Samper de CalandaSamper 1 - 3 ValdealgorfaValdealgorf ...
Jornada 23
24 Mar 24 Teruel BTeruel B 5 - 3 ValderrobresValderrobre ...
24 Mar 24 FuensportFuensport Apl Maella C.D.Maella C.D. ...
24 Mar 24 CalaceiteCalaceite 0 - 1 EscatronEscatron ...
24 Mar 24 Híjar FCHíjar FC 1 - 3 AlcorisaAlcorisa ...
23 Mar 24 Sportin Alcañiz CfSportin 0 - 0 CD CalandaCD Calanda ...
24 Mar 24 Polideportivo MontalbanPolideporti 2 - 0 Samper de CalandaSamper ...
24 Mar 24 ValdealgorfaValdealgorf 0 - 4 TorrecillaTorrecilla ...
Jornada 24
07 Abr 24 ValderrobresValderrobre 3 - 1 Utrillas BUtrillas B ...
07 Abr 24 Maella C.D.Maella C.D. 0 - 0 Teruel BTeruel B ...
07 Abr 24 EscatronEscatron 2 - 0 FuensportFuensport ...
07 Abr 24 AlcorisaAlcorisa 2 - 0 CalaceiteCalaceite ...
07 Abr 24 CD CalandaCD Calanda 3 - 1 Híjar FCHíjar FC ...
07 Abr 24 Samper de CalandaSamper 1 - 3 Sportin Alcañiz CfSportin ...
07 Abr 24 TorrecillaTorrecilla 2 - 1 Polideportivo MontalbanPolideporti ...
Jornada 25
14 Abr 24 Utrillas BUtrillas B 2 - 1 Maella C.D.Maella C.D. ...
14 Abr 24 Teruel BTeruel B 7 - 0 EscatronEscatron ...
14 Abr 24 FuensportFuensport Apl AlcorisaAlcorisa ...
14 Abr 24 CalaceiteCalaceite 3 - 1 CD CalandaCD Calanda ...
14 Abr 24 Híjar FCHíjar FC 2 - 2 Samper de CalandaSamper ...
13 Abr 24 Sportin Alcañiz CfSportin 6 - 0 TorrecillaTorrecilla ...
14 Abr 24 Polideportivo MontalbanPolideporti 2 - 1 ValdealgorfaValdealgorf ...
Jornada 26
21 Abr 24 Maella C.D.Maella C.D. 1 - 0 ValderrobresValderrobre ...
21 Abr 24 EscatronEscatron 1 - 1 Utrillas BUtrillas B ...
21 Abr 24 AlcorisaAlcorisa 0 - 1 Teruel BTeruel B ...
21 Abr 24 CD CalandaCD Calanda Apl FuensportFuensport ...
21 Abr 24 Samper de CalandaSamper 1 - 0 CalaceiteCalaceite ...
21 Abr 24 TorrecillaTorrecilla 0 - 2 Híjar FCHíjar FC ...
21 Abr 24 ValdealgorfaValdealgorf 3 - 5 Sportin Alcañiz CfSportin ...
Jornada 27
28 Abr 24 ValderrobresValderrobre 6 - 0 EscatronEscatron ...
28 Abr 24 Utrillas BUtrillas B 3 - 3 AlcorisaAlcorisa ...
28 Abr 24 Teruel BTeruel B 1 - 2 CD CalandaCD Calanda ...
28 Abr 24 FuensportFuensport Apl Samper de CalandaSamper ...
28 Abr 24 CalaceiteCalaceite 1 - 2 TorrecillaTorrecilla ...
28 Abr 24 Híjar FCHíjar FC 2 - 2 ValdealgorfaValdealgorf ...
28 Abr 24 Sportin Alcañiz CfSportin 2 - 1 Polideportivo MontalbanPolideporti ...
Jornada 28
05 May 24 EscatronEscatron 1 - 5 Maella C.D.Maella C.D. ...
05 May 24 AlcorisaAlcorisa 3 - 1 ValderrobresValderrobre ...
05 May 24 CD CalandaCD Calanda 2 - 1 Utrillas BUtrillas B ...
05 May 24 Samper de CalandaSamper 0 - 2 Teruel BTeruel B ...
05 May 24 TorrecillaTorrecilla 2 - 0 FuensportFuensport ...
05 May 24 ValdealgorfaValdealgorf 3 - 5 CalaceiteCalaceite ...
05 May 24 Polideportivo MontalbanPolideporti 1 - 1 Híjar FCHíjar FC ...
Jornada 29
12 May 24 Maella C.D.Maella C.D.
18:00
AlcorisaAlcorisa ...
12 May 24 ValderrobresValderrobre
18:00
CD CalandaCD Calanda ...
12 May 24 Utrillas BUtrillas B
17:00
Samper de CalandaSamper ...
12 May 24 Teruel BTeruel B
17:30
TorrecillaTorrecilla ...
12 May 24 FuensportFuensport Apl ValdealgorfaValdealgorf ...
12 May 24 CalaceiteCalaceite
17:00
Polideportivo MontalbanPolideporti ...
12 May 24 Híjar FCHíjar FC
18:00
Sportin Alcañiz CfSportin ...
Jornada 30
19 May 24 AlcorisaAlcorisa x - x EscatronEscatron ...
19 May 24 CD CalandaCD Calanda x - x Maella C.D.Maella C.D. ...
19 May 24 Samper de CalandaSamper
17:00
ValderrobresValderrobre ...
19 May 24 TorrecillaTorrecilla
19:00
Utrillas BUtrillas B ...
19 May 24 Teruel BTeruel B x - x ValdealgorfaValdealgorf ...
19 May 24 Polideportivo MontalbanPolideporti x - x FuensportFuensport ...
19 May 24 Sportin Alcañiz CfSportin x - x CalaceiteCalaceite ...

Clasificación

Equipo PJ GF GC Puntos
1 Sportin Alcañiz Cf Sportin 26 91 19 74
2 Alcorisa Alcorisa 25 62 34 57
3 Valderrobres Valderrobres 25 67 33 50
4 CD Calanda CD Calanda 25 47 25 44
5 Híjar FC Híjar FC 27 57 46 44
6 Teruel B Teruel B 26 61 47 44
7 Maella C.D. Maella C.D. 25 48 37 42
8 Samper de Calanda Samper 25 33 49 32
9 Torrecilla Torrecilla 26 44 63 31
10 Utrillas B Utrillas B 25 35 48 28
11 Calaceite Calaceite 26 51 58 26
12 Polideportivo Montalban Polideportiv 26 21 43 21
13 Fuensport Fuensport 20 34 36 18
14 Valdealgorfa Valdealgorfa 26 32 75 18
15 Escatron Escatron 27 16 86 12

  USO DE MEMORIA  
6,364,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4116
Total Execution Time  0.4135
  CADENA URL  
/primera_regional_aragon2024/grupo4/calendario
  GET DATOS  
$_GET['/primera_regional_aragon2024/grupo4/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0295  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_aragon' AND (l.group_code = 4 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=4 DESC LIMIT 1
0.0150  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=700 AND type_rel = 3
0.0155  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 700 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0160  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 (148779,146890,146556,146375) ORDER BY n.cover_points DESC, update_date DESC
0.0149  SELECT id,name,alias,stepParent FROM categories WHERE parentId=700 ORDER BY order_id ASC
0.0146  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 = 73610 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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 = 73610 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-05-09 09:45:50' 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-05-09 09:45:50' 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-05-09 09:45:50' 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=3 AND last_update > '2024-05-09 09:45:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0213  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 = 73610 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73610 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.0226  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 = 73610 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73610 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0160  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 = 73610 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73610 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0161  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 = 73610 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC