4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
01 Oct 23 Real Avilés BReal 8 - 1 UD CastrosUD Castros 1
01 Oct 23 La CaridadLa Caridad 0 - 1 Racing de PraviaRacing ...
01 Oct 23 CornellanaCornellana 2 - 2 Astur VegadenseAstur ...
01 Oct 23 Boal CFBoal CF 3 - 0 Marino de CudilleroMarino 1
01 Oct 23 C. Hispano BHispano 2 - 1 CD PillarnoPillarno ...
01 Oct 23 Praviano BPraviano B 6 - 0 La EspinaLa Espina 2
01 Oct 23 Real Tapia CFReal Tapia 2 - 0 Puerto Vega BPuerto Vega ...
Jornada 2
08 Oct 23 Racing de PraviaRacing 3 - 2 Real Avilés BReal ...
08 Oct 23 Astur VegadenseAstur 1 - 0 La CaridadLa Caridad ...
08 Oct 23 Marino de CudilleroMarino 3 - 2 CornellanaCornellana ...
08 Oct 23 CD PillarnoPillarno 2 - 4 Boal CFBoal CF ...
08 Oct 23 La EspinaLa Espina 0 - 3 C. Hispano BHispano ...
07 Oct 23 Puerto Vega BPuerto Vega 1 - 4 Praviano BPraviano B ...
08 Oct 23 Llaranes BLlaranes B 0 - 3 Real Tapia CFReal Tapia ...
Jornada 3
12 Oct 23 UD CastrosUD Castros 3 - 4 Racing de PraviaRacing ...
12 Oct 23 Real Avilés BReal 2 - 3 Astur VegadenseAstur 2
12 Oct 23 La CaridadLa Caridad 2 - 0 Marino de CudilleroMarino ...
12 Oct 23 CornellanaCornellana 3 - 0 CD PillarnoPillarno ...
12 Oct 23 Boal CFBoal CF 5 - 0 La EspinaLa Espina ...
12 Oct 23 C. Hispano BHispano 3 - 0 Puerto Vega BPuerto Vega ...
12 Oct 23 Praviano BPraviano B 3 - 0 Llaranes BLlaranes B ...
Jornada 4
15 Oct 23 Astur VegadenseAstur 2 - 1 UD CastrosUD Castros ...
15 Oct 23 Marino de CudilleroMarino 0 - 2 Real Avilés BReal 2
15 Oct 23 CD PillarnoPillarno 1 - 1 La CaridadLa Caridad ...
15 Oct 23 La EspinaLa Espina 2 - 1 CornellanaCornellana ...
15 Oct 23 Puerto Vega BPuerto Vega 0 - 4 Boal CFBoal CF 1
15 Oct 23 Llaranes BLlaranes B 0 - 2 C. Hispano BHispano ...
15 Oct 23 Real Tapia CFReal Tapia 1 - 1 Praviano BPraviano B ...
Jornada 5
22 Oct 23 Racing de PraviaRacing 2 - 4 Astur VegadenseAstur ...
22 Oct 23 UD CastrosUD Castros 1 - 4 Marino de CudilleroMarino ...
22 Oct 23 Real Avilés BReal 2 - 0 CD PillarnoPillarno 1
22 Oct 23 La CaridadLa Caridad 3 - 0 La EspinaLa Espina ...
22 Oct 23 CornellanaCornellana 1 - 1 Puerto Vega BPuerto Vega ...
22 Oct 23 Boal CFBoal CF 4 - 1 Llaranes BLlaranes B ...
22 Oct 23 C. Hispano BHispano 1 - 1 Real Tapia CFReal Tapia ...
Jornada 6
29 Oct 23 Marino de CudilleroMarino 1 - 3 Racing de PraviaRacing ...
29 Oct 23 CD PillarnoPillarno 1 - 0 UD CastrosUD Castros ...
29 Oct 23 La EspinaLa Espina 1 - 5 Real Avilés BReal ...
29 Oct 23 Puerto Vega BPuerto Vega 1 - 2 La CaridadLa Caridad ...
29 Oct 23 Llaranes BLlaranes B 2 - 1 CornellanaCornellana ...
29 Oct 23 Boal CFBoal CF 1 - 1 Real Tapia CFReal Tapia ...
29 Oct 23 Praviano BPraviano B 2 - 0 C. Hispano BHispano ...
Jornada 7
05 Nov 23 Astur VegadenseAstur 3 - 1 Marino de CudilleroMarino ...
05 Nov 23 Racing de PraviaRacing 4 - 2 CD PillarnoPillarno ...
05 Nov 23 UD CastrosUD Castros 2 - 0 La EspinaLa Espina ...
05 Nov 23 Real Avilés BReal 2 - 1 Puerto Vega BPuerto Vega ...
05 Nov 23 La CaridadLa Caridad 5 - 1 Llaranes BLlaranes B ...
05 Nov 23 CornellanaCornellana 1 - 2 Real Tapia CFReal Tapia ...
05 Nov 23 Boal CFBoal CF 4 - 1 Praviano BPraviano B ...
Jornada 8
12 Nov 23 CD PillarnoPillarno 0 - 5 Astur VegadenseAstur ...
12 Nov 23 La EspinaLa Espina 0 - 5 Racing de PraviaRacing ...
11 Nov 23 Puerto Vega BPuerto Vega 2 - 1 UD CastrosUD Castros ...
12 Nov 23 Llaranes BLlaranes B 0 - 3 Real Avilés BReal ...
12 Nov 23 Real Tapia CFReal Tapia 1 - 0 La CaridadLa Caridad ...
12 Nov 23 Praviano BPraviano B 2 - 2 CornellanaCornellana ...
12 Nov 23 C. Hispano BHispano 0 - 1 Boal CFBoal CF ...
Jornada 9
19 Nov 23 Marino de CudilleroMarino 0 - 1 CD PillarnoPillarno ...
19 Nov 23 Astur VegadenseAstur 3 - 0 La EspinaLa Espina ...
19 Nov 23 Racing de PraviaRacing 3 - 0 Puerto Vega BPuerto Vega ...
19 Nov 23 UD CastrosUD Castros 4 - 1 Llaranes BLlaranes B ...
19 Nov 23 Real Avilés BReal 1 - 0 Real Tapia CFReal Tapia ...
19 Nov 23 La CaridadLa Caridad 1 - 3 Praviano BPraviano B ...
19 Nov 23 CornellanaCornellana 3 - 1 C. Hispano BHispano ...
Jornada 10
26 Nov 23 La EspinaLa Espina 0 - 1 Marino de CudilleroMarino ...
26 Nov 23 Puerto Vega BPuerto Vega 0 - 1 Astur VegadenseAstur ...
26 Nov 23 Llaranes BLlaranes B 0 - 2 Racing de PraviaRacing ...
26 Nov 23 Real Tapia CFReal Tapia 1 - 1 UD CastrosUD Castros ...
26 Nov 23 Praviano BPraviano B 5 - 0 Real Avilés BReal ...
26 Nov 23 C. Hispano BHispano 0 - 0 La CaridadLa Caridad ...
26 Nov 23 Boal CFBoal CF 3 - 2 CornellanaCornellana ...
Jornada 11
03 Dic 23 CD PillarnoPillarno 1 - 0 La EspinaLa Espina ...
03 Dic 23 Marino de CudilleroMarino 1 - 1 Puerto Vega BPuerto Vega ...
03 Dic 23 Astur VegadenseAstur 8 - 0 Llaranes BLlaranes B ...
03 Dic 23 Racing de PraviaRacing 3 - 1 Real Tapia CFReal Tapia ...
02 Dic 23 UD CastrosUD Castros 2 - 3 Praviano BPraviano B ...
03 Dic 23 Real Avilés BReal 4 - 1 C. Hispano BHispano ...
03 Dic 23 La CaridadLa Caridad 1 - 1 Boal CFBoal CF 3
Jornada 12
08 Dic 23 Puerto Vega BPuerto Vega 4 - 3 CD PillarnoPillarno ...
10 Dic 23 Llaranes BLlaranes B 1 - 3 Marino de CudilleroMarino ...
10 Dic 23 Real Tapia CFReal Tapia 0 - 0 Astur VegadenseAstur ...
06 Dic 23 Praviano BPraviano B 1 - 2 Racing de PraviaRacing 1
09 Dic 23 C. Hispano BHispano 2 - 0 UD CastrosUD Castros ...
10 Dic 23 Boal CFBoal CF 3 - 2 Real Avilés BReal ...
10 Dic 23 CornellanaCornellana 0 - 1 La CaridadLa Caridad ...
Jornada 13
17 Dic 23 La EspinaLa Espina 1 - 1 Puerto Vega BPuerto Vega ...
17 Dic 23 CD PillarnoPillarno 2 - 0 Llaranes BLlaranes B ...
17 Dic 23 Marino de CudilleroMarino 0 - 2 Real Tapia CFReal Tapia ...
16 Dic 23 Astur VegadenseAstur 0 - 1 Praviano BPraviano B ...
17 Dic 23 Racing de PraviaRacing 3 - 2 C. Hispano BHispano ...
17 Dic 23 UD CastrosUD Castros 2 - 1 Boal CFBoal CF ...
17 Dic 23 Real Avilés BReal 4 - 0 CornellanaCornellana ...
Jornada 14
07 Ene 24 Llaranes BLlaranes B 3 - 1 La EspinaLa Espina ...
07 Ene 24 Real Tapia CFReal Tapia 0 - 0 CD PillarnoPillarno ...
07 Ene 24 Praviano BPraviano B 0 - 0 Marino de CudilleroMarino ...
07 Ene 24 C. Hispano BHispano 4 - 1 Astur VegadenseAstur ...
07 Ene 24 Boal CFBoal CF 4 - 1 Racing de PraviaRacing 1
07 Ene 24 CornellanaCornellana 2 - 0 UD CastrosUD Castros ...
07 Ene 24 La CaridadLa Caridad 0 - 2 Real Avilés BReal ...
Jornada 15
14 Ene 24 Puerto Vega BPuerto Vega 2 - 0 Llaranes BLlaranes B ...
14 Ene 24 La EspinaLa Espina 1 - 3 Real Tapia CFReal Tapia ...
14 Ene 24 CD PillarnoPillarno 3 - 1 Praviano BPraviano B ...
14 Ene 24 Marino de CudilleroMarino 0 - 3 C. Hispano BHispano ...
14 Ene 24 Astur VegadenseAstur 3 - 1 Boal CFBoal CF 1
14 Ene 24 Racing de PraviaRacing 3 - 1 CornellanaCornellana ...
14 Ene 24 UD CastrosUD Castros 0 - 0 La CaridadLa Caridad ...
Jornada 16
21 Ene 24 UD CastrosUD Castros 0 - 1 Real Avilés BReal ...
21 Ene 24 Racing de PraviaRacing 1 - 2 La CaridadLa Caridad ...
21 Ene 24 Astur VegadenseAstur 2 - 0 CornellanaCornellana ...
21 Ene 24 Marino de CudilleroMarino 0 - 6 Boal CFBoal CF ...
21 Ene 24 CD PillarnoPillarno 2 - 1 C. Hispano BHispano ...
21 Ene 24 La EspinaLa Espina 0 - 4 Praviano BPraviano B ...
20 Ene 24 Puerto Vega BPuerto Vega 0 - 0 Real Tapia CFReal Tapia ...
Jornada 17
28 Ene 24 Real Avilés BReal 2 - 3 Racing de PraviaRacing ...
28 Ene 24 La CaridadLa Caridad 3 - 2 Astur VegadenseAstur ...
28 Ene 24 CornellanaCornellana 1 - 0 Marino de CudilleroMarino ...
28 Ene 24 Boal CFBoal CF 2 - 0 CD PillarnoPillarno ...
28 Ene 24 C. Hispano BHispano 5 - 2 La EspinaLa Espina ...
28 Ene 24 Praviano BPraviano B 6 - 1 Puerto Vega BPuerto Vega ...
28 Ene 24 Real Tapia CFReal Tapia 3 - 1 Llaranes BLlaranes B ...
Jornada 18
04 Feb 24 Racing de PraviaRacing 4 - 0 UD CastrosUD Castros ...
03 Feb 24 Astur VegadenseAstur 1 - 1 Real Avilés BReal ...
04 Feb 24 Marino de CudilleroMarino 5 - 0 La CaridadLa Caridad ...
04 Feb 24 CD PillarnoPillarno 2 - 0 CornellanaCornellana ...
04 Feb 24 La EspinaLa Espina 0 - 2 Boal CFBoal CF ...
04 Feb 24 Puerto Vega BPuerto Vega 1 - 5 C. Hispano BHispano ...
03 Feb 24 Llaranes BLlaranes B 0 - 4 Praviano BPraviano B ...
Jornada 19
11 Feb 24 UD CastrosUD Castros 1 - 2 Astur VegadenseAstur ...
11 Feb 24 Real Avilés BReal 1 - 1 Marino de CudilleroMarino ...
11 Feb 24 La CaridadLa Caridad 1 - 3 CD PillarnoPillarno ...
11 Feb 24 CornellanaCornellana 2 - 1 La EspinaLa Espina ...
11 Feb 24 Boal CFBoal CF 2 - 0 Puerto Vega BPuerto Vega ...
11 Feb 24 C. Hispano BHispano 6 - 0 Llaranes BLlaranes B ...
11 Feb 24 Praviano BPraviano B 3 - 1 Real Tapia CFReal Tapia ...
Jornada 20
18 Feb 24 Astur VegadenseAstur 4 - 2 Racing de PraviaRacing ...
18 Feb 24 Marino de CudilleroMarino 4 - 0 UD CastrosUD Castros ...
18 Feb 24 CD PillarnoPillarno 2 - 0 Real Avilés BReal ...
18 Feb 24 La EspinaLa Espina 0 - 2 La CaridadLa Caridad ...
18 Feb 24 Puerto Vega BPuerto Vega 0 - 1 CornellanaCornellana ...
18 Feb 24 Llaranes BLlaranes B 1 - 6 Boal CFBoal CF ...
18 Feb 24 Real Tapia CFReal Tapia 3 - 0 C. Hispano BHispano ...
Jornada 21
25 Feb 24 Racing de PraviaRacing 1 - 1 Marino de CudilleroMarino ...
24 Feb 24 UD CastrosUD Castros 1 - 2 CD PillarnoPillarno ...
25 Feb 24 Real Avilés BReal 6 - 1 La EspinaLa Espina ...
25 Feb 24 La CaridadLa Caridad 1 - 0 Puerto Vega BPuerto Vega ...
25 Feb 24 CornellanaCornellana 1 - 0 Llaranes BLlaranes B ...
25 Feb 24 Real Tapia CFReal Tapia 3 - 4 Boal CFBoal CF ...
24 Feb 24 C. Hispano BHispano 1 - 2 Praviano BPraviano B ...
Jornada 22
03 Mar 24 Marino de CudilleroMarino 0 - 3 Astur VegadenseAstur ...
03 Mar 24 CD PillarnoPillarno 3 - 1 Racing de PraviaRacing ...
03 Mar 24 La EspinaLa Espina 0 - 3 UD CastrosUD Castros ...
03 Mar 24 Puerto Vega BPuerto Vega 3 - 0 Real Avilés BReal ...
03 Mar 24 Llaranes BLlaranes B 2 - 1 La CaridadLa Caridad ...
03 Mar 24 Real Tapia CFReal Tapia 2 - 0 CornellanaCornellana ...
03 Mar 24 Praviano BPraviano B 1 - 0 Boal CFBoal CF ...
Jornada 23
10 Mar 24 Astur VegadenseAstur 5 - 1 CD PillarnoPillarno ...
10 Mar 24 Racing de PraviaRacing 6 - 1 La EspinaLa Espina ...
10 Mar 24 UD CastrosUD Castros 1 - 1 Puerto Vega BPuerto Vega ...
10 Mar 24 Real Avilés BReal 4 - 3 Llaranes BLlaranes B ...
10 Mar 24 La CaridadLa Caridad 0 - 5 Real Tapia CFReal Tapia ...
09 Mar 24 CornellanaCornellana 2 - 3 Praviano BPraviano B ...
10 Mar 24 Boal CFBoal CF 0 - 1 C. Hispano BHispano ...
Jornada 24
17 Mar 24 CD PillarnoPillarno 1 - 1 Marino de CudilleroMarino ...
17 Mar 24 La EspinaLa Espina 0 - 3 Astur VegadenseAstur ...
17 Mar 24 Puerto Vega BPuerto Vega 2 - 8 Racing de PraviaRacing ...
17 Mar 24 Llaranes BLlaranes B 2 - 1 UD CastrosUD Castros ...
17 Mar 24 Real Tapia CFReal Tapia 3 - 2 Real Avilés BReal ...
17 Mar 24 Praviano BPraviano B 7 - 0 La CaridadLa Caridad ...
17 Mar 24 C. Hispano BHispano 2 - 0 CornellanaCornellana ...
Jornada 25
24 Mar 24 Marino de CudilleroMarino 5 - 0 La EspinaLa Espina ...
23 Mar 24 Astur VegadenseAstur 7 - 1 Puerto Vega BPuerto Vega ...
24 Mar 24 Racing de PraviaRacing 4 - 2 Llaranes BLlaranes B ...
24 Mar 24 UD CastrosUD Castros 0 - 1 Real Tapia CFReal Tapia ...
24 Mar 24 Real Avilés BReal 4 - 1 Praviano BPraviano B 1
24 Mar 24 La CaridadLa Caridad 2 - 1 C. Hispano BHispano ...
24 Mar 24 CornellanaCornellana 1 - 2 Boal CFBoal CF ...
Jornada 26
07 Abr 24 La EspinaLa Espina 2 - 2 CD PillarnoPillarno ...
07 Abr 24 Puerto Vega BPuerto Vega 2 - 2 Marino de CudilleroMarino ...
07 Abr 24 Llaranes BLlaranes B 2 - 6 Astur VegadenseAstur ...
07 Abr 24 Real Tapia CFReal Tapia 0 - 2 Racing de PraviaRacing ...
06 Abr 24 Praviano BPraviano B 4 - 0 UD CastrosUD Castros ...
07 Abr 24 C. Hispano BHispano 1 - 2 Real Avilés BReal ...
07 Abr 24 Boal CFBoal CF 3 - 0 La CaridadLa Caridad ...
Jornada 27
14 Abr 24 CD PillarnoPillarno 3 - 1 Puerto Vega BPuerto Vega ...
14 Abr 24 Marino de CudilleroMarino 7 - 1 Llaranes BLlaranes B ...
14 Abr 24 Astur VegadenseAstur 3 - 0 Real Tapia CFReal Tapia ...
14 Abr 24 Racing de PraviaRacing 1 - 2 Praviano BPraviano B 1
14 Abr 24 UD CastrosUD Castros 1 - 2 C. Hispano BHispano ...
14 Abr 24 Real Avilés BReal 3 - 2 Boal CFBoal CF 1
14 Abr 24 La CaridadLa Caridad 3 - 1 CornellanaCornellana ...
Jornada 28
21 Abr 24 Puerto Vega BPuerto Vega 0 - 1 La EspinaLa Espina ...
21 Abr 24 Llaranes BLlaranes B 2 - 1 CD PillarnoPillarno ...
21 Abr 24 Real Tapia CFReal Tapia 3 - 0 Marino de CudilleroMarino ...
21 Abr 24 Praviano BPraviano B 1 - 0 Astur VegadenseAstur ...
21 Abr 24 C. Hispano BHispano 3 - 1 Racing de PraviaRacing ...
21 Abr 24 Boal CFBoal CF 4 - 1 UD CastrosUD Castros ...
21 Abr 24 CornellanaCornellana 0 - 2 Real Avilés BReal ...
Jornada 29
28 Abr 24 La EspinaLa Espina 1 - 1 Llaranes BLlaranes B ...
28 Abr 24 CD PillarnoPillarno 2 - 2 Real Tapia CFReal Tapia ...
28 Abr 24 Marino de CudilleroMarino 1 - 3 Praviano BPraviano B ...
27 Abr 24 Astur VegadenseAstur 2 - 0 C. Hispano BHispano ...
28 Abr 24 Racing de PraviaRacing 3 - 1 Boal CFBoal CF ...
27 Abr 24 UD CastrosUD Castros 2 - 1 CornellanaCornellana ...
28 Abr 24 Real Avilés BReal 2 - 1 La CaridadLa Caridad ...
Jornada 30
04 May 24 Llaranes BLlaranes B 5 - 3 Puerto Vega BPuerto Vega ...
05 May 24 Real Tapia CFReal Tapia 1 - 0 La EspinaLa Espina ...
05 May 24 Praviano BPraviano B 6 - 0 CD PillarnoPillarno ...
04 May 24 C. Hispano BHispano 4 - 1 Marino de CudilleroMarino ...
05 May 24 Boal CFBoal CF 3 - 1 Astur VegadenseAstur 2
05 May 24 CornellanaCornellana 5 - 6 Racing de PraviaRacing ...
04 May 24 La CaridadLa Caridad 0 - 3 UD CastrosUD Castros ...

Clasificación

Equipo PJ GF GC Puntos
1 Praviano B Praviano B 28 80 27 66
2 Astur Vegadense Astur 28 77 29 63
3 Boal CF Boal CF 28 76 31 62
4 Racing de Pravia Racing 28 82 49 61
5 Real Avilés B Real Avilés 28 69 40 56
6 Real Tapia CF Real Tapia 28 45 27 50
7 C. Hispano B Hispano 28 56 35 47
8 CD Pillarno CD Pillarno 28 41 51 41
9 La Caridad La Caridad 28 32 47 37
10 Marino de Cudillero Marino 28 42 50 30
11 Cornellana Cornellana 28 36 53 24
12 UD Castros UD Castros 28 32 59 21
13 Llaranes B Llaranes B 28 31 91 19
14 Puerto Vega B Puerto Vega 28 29 70 18
15 La Espina La Espina 28 15 84 9

  USO DE MEMORIA  
6,190,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1305
Total Execution Time  0.1324
  CADENA URL  
/segunda_regional_asturias2024/grupo4/calendario
  GET DATOS  
$_GET['/segunda_regional_asturias2024/grupo4/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0020  SELECT type FROM routes WHERE alias = 'segunda_regional_asturias2024'
0.0044  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_regional_asturias' 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.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=710 AND type_rel = 3
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 710 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027  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 (510396,510516) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=710 ORDER BY order_id ASC
0.0026  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 = 73717 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0058  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 = 73717 ORDER BY round ASC
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 04:48:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 04:48:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 04:48:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 04:48:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0028  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_regional_asturias' 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.0026  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 = 73717 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73717 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.0025  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 = 73717 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73717 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025  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 = 73717 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73717 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0071  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 = 73717 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC