4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 UB Conquense Sub 19 Conquense 31 90 26 78
2 Albacete Balompié Sub 19 B Albacete 31 77 23 69
3 CD Cazalegas Sub 19 Cazalegas 31 62 43 58
4 CD Toledo Sub 19 Toledo 31 57 36 57
5 CD Azuqueca Sub 19 Azuqueca 31 68 47 54
6 CD Alameda MESA Sub 19 Alameda MESA 31 52 36 51
7 Guadalajara Sub 19 Guadalajara 31 71 37 51
8 EFUD Albacer Sub 19 EFUD Albacer 31 53 51 50
9 Almansa Sub 19 Almansa 31 64 57 47
10 AD Illescas Sub 19 Illescas 31 46 49 44
11 Atlético Puertollano Sub 19 Atlético 31 47 66 43
12 Arges Sub 19 Arges 31 44 49 41
13 EFFB Ciudad Real Sub 19 EFFB Ciudad 31 48 52 32
14 Jesus de La Ossa Sub 19 Jesus Ossa 31 42 69 31
15 Talavera de la Reina Sub 19 Talavera 31 41 62 29
16 Odelot Toletum Sub 19 Odelot 31 46 74 23
17 Torrijos CD Sub 19 Torrijos 31 26 57 23
18 CD Miguelturreño Sub 19 Miguelturre 31 24 124 8
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Albacete Balompié Sub 19 B Albacete 33 96 36 69
2 EFB Miguelturra Sub 19 Miguelturra 34 62 37 67
3 Almansa Sub 19 Almansa 34 79 41 65
4 UB Conquense Sub 19 Conquense 34 70 45 61
5 CD Azuqueca Sub 19 Azuqueca 34 65 45 61
6 Elite Talavera Sub 19 Elite 34 65 48 59
7 Torrijos CD Sub 19 Torrijos 34 64 49 56
8 Arges Sub 19 Arges 33 63 49 54
9 Talavera de la Reina Sub 19 Talavera 34 58 59 48
10 AD Illescas Sub 19 Illescas 34 58 57 48
11 EFUD Albacer Sub 19 EFUD Albacer 34 50 60 44
12 Atlético Puertollano Sub 19 Atlético 34 61 66 39
13 Jesus de La Ossa Sub 19 Jesus Ossa 34 45 67 39
14 CD Miguelturreño Sub 19 Miguelturre 34 48 74 37
15 CDEFB Valdepeñas Sub 19 CDEFB 34 45 64 36
16 Atlético Tomelloso Sub 19 Atlético 34 45 64 35
17 Cabanillas Sub 19 Cabanillas 34 33 75 27
18 CD Goalsoccer Sub 19 Goalsoccer 34 28 99 22
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CD Toledo Sub 19 Toledo 34 90 38 79
2 Torrijos CD Sub 19 Torrijos 34 70 39 71
3 AD Illescas Sub 19 Illescas 34 67 48 65
4 CD Azuqueca Sub 19 Azuqueca 34 67 43 61
5 Albacete Balompié Sub 19 B Albacete 34 66 48 59
6 EFUD Albacer Sub 19 EFUD Albacer 34 63 43 57
7 Atlético Puertollano Sub 19 Atlético 34 88 74 54
8 Elite Talavera Sub 19 Elite 34 57 49 53
9 EFB Miguelturra Sub 19 Miguelturra 34 58 57 52
10 CDEFB Valdepeñas Sub 19 CDEFB 34 79 54 49
11 CD Miguelturreño Sub 19 Miguelturre 34 64 63 45
12 Atlético Tomelloso Sub 19 Atlético 34 51 57 44
13 CD Goalsoccer Sub 19 Goalsoccer 34 63 53 43
14 Sporting de Alcázar Sub 19 Sporting 34 50 47 43
15 Odelot Toletum Sub 19 Odelot 34 53 73 40
16 Mora CF Sub 19 Mora 34 46 59 37
17 Manchego Ciudad Real Sub 19 Manchego 34 23 132 5
18 Ciudad de Talavera Sub 19 Ciudad 34 25 103 0
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Villarreal Sub 19 B Villarreal 22 49 19 45
2 La Nucia Sub 19 Nucia 22 32 20 43
3 Elche Sub 19 B Elche 22 39 16 41
4 CF Inter San José Sub 19 Inter José 22 44 22 41
5 U.D. Alzira 'B' U.D. Alzira 22 29 21 33
6 CD Castellón Sub 19 B Castellón 22 33 29 30
7 C.D. San Marcelino 'A' C.D. 22 32 39 30
8 Torre Levante Sub 19 B Torre 22 30 34 28
9 CF Benidorm Sub 19 Benidorm 22 18 29 25
10 Denia Sub 19 Denia 22 25 48 21
11 C.D. Don Bosco A C.D. Bosco 22 32 51 19
12 Tavernes Blanques Sub 19 Tavernes 22 15 50 12
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 EFUD Albacer Sub 19 EFUD Albacer 34 61 33 63
2 Almagro CF Almagro CF 34 67 52 62
3 Ciudad de Cuenca CF Ciudad 34 68 47 60
4 Atlético Tomelloso Sub 19 Atlético 34 51 37 56
5 Albacete Balompié Sub 19 B Albacete 34 61 44 55
6 Guadalajara Sub 19 Guadalajara 34 55 36 54
7 CD Toledo Sub 19 Toledo 34 74 54 54
8 CD Azuqueca Sub 19 Azuqueca 34 51 43 48
9 FD Talavera FD Talavera 34 44 52 47
10 Sonseca Sonseca 34 48 52 47
11 Ud Almansa Ud Almansa 34 33 59 46
12 Cabanillas Sub 19 Cabanillas 34 54 58 45
13 AD Illescas Sub 19 Illescas 34 35 36 44
14 Villarrobledo Villarrobled 34 46 46 44
15 CD Ciudad Real Juvenil Ciudad Real 34 45 49 38
16 Hellín CF Sub 19 Hellín 34 51 67 38
17 CD Miguelturreño Sub 19 Miguelturre 34 36 69 24
18 EFB La Roda EFB La Roda 34 23 69 20
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 UB Conquense Sub 19 Conquense 34 85 24 85
2 Almagro CF Almagro CF 34 64 32 65
3 CD Toledo Sub 19 Toledo 34 66 42 61
4 CD Ciudad Real Juvenil Ciudad Real 34 51 43 55
5 Albacete Balompié Sub 19 B Albacete 34 64 46 53
6 Ud Almansa Ud Almansa 34 52 57 52
7 Gimnástico De Alcázar Gimnástico 34 54 49 50
8 CD Azuqueca Sub 19 Azuqueca 34 61 61 49
9 AD Illescas Sub 19 Illescas 34 51 49 48
10 Ciudad de Cuenca CF Ciudad 34 50 54 47
11 Atlético Tomelloso Sub 19 Atlético 34 56 52 47
12 EFUD Albacer Sub 19 EFUD Albacer 34 53 68 44
13 EFB La Roda EFB La Roda 34 48 51 43
14 CD Quintanar Quintanar 34 56 79 43
15 Cd Puertollano Puertollano 34 68 60 43
16 Torrijos CD Sub 19 Torrijos 34 53 75 36
17 Cristo De La Vega Cf Cristo Vega 34 42 80 24
18 E Zona 5 Albacete Zona 34 25 77 21
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 CD Toledo Sub 19 Toledo 34 71 31 73
2 Guadalajara Sub 19 Guadalajara 34 87 48 66
3 UB Conquense Sub 19 Conquense 34 51 34 62
4 Ciudad de Cuenca CF Ciudad 34 64 42 62
5 La Roda Juvenil Roda Juvenil 34 68 49 53
6 Albacete Balompié Sub 19 B Albacete 34 55 48 49
7 AD Illescas Sub 19 Illescas 34 46 53 47
8 Torrijos CD Sub 19 Torrijos 34 43 52 46
9 Almagro CF Almagro CF 34 51 62 45
10 Cd Puertollano Puertollano 34 54 58 45
11 EFUD Albacer Sub 19 EFUD Albacer 34 48 57 42
12 CF Gimnástico Gimnástico 34 44 46 42
13 Tomelloso Cf Juvenil Tomelloso 34 48 56 41
14 Talavera de la Reina Sub 19 Talavera 34 47 63 38
15 E Zona 5 Albacete Zona 34 58 70 38
16 Cristo De La Vega Cf Cristo Vega 34 52 61 37
17 CDEEFB Ciudad de Talavera CDEEFB 34 44 69 31
18 CDE AV Industria Industria 34 46 78 27
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 CD Ciudad Real Juvenil Ciudad Real 34 61 20 76
2 Cf Gimnástico Gimnástico 34 70 29 74
3 Albacete Balompié Sub 19 B Albacete 34 82 40 70
4 CD Toledo Sub 19 Toledo 34 72 40 66
5 UB Conquense Sub 19 Conquense 33 71 54 56
6 E Zona 5 Albacete Zona 34 61 60 54
7 Talavera de la Reina Sub 19 Talavera 34 63 56 52
8 Guadalajara Sub 19 Guadalajara 34 62 58 50
9 Tomelloso Cf Juvenil Tomelloso 33 51 59 40
10 Cristo De La Vega Cf Cristo Vega 34 46 57 40
11 Torrijos CD Sub 19 Torrijos 34 41 52 39
12 EFUD Albacer Sub 19 EFUD Albacer 34 50 62 39
13 Daimiel Cf Daimiel Cf 34 44 75 38
14 Cd Puertollano Puertollano 34 52 59 36
15 Ud Almansa Ud Almansa 34 45 59 36
16 CD Miguelturreño Sub 19 Miguelturre 34 51 66 36
17 Hellín Deportivo Hellín 34 52 88 33
18 Cd Mota Del Cuervo Mota Cuervo 34 49 89 18
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 UD Talavera UD Talavera 32 89 28 81
2 Guadalajara Sub 19 Guadalajara 31 63 23 72
3 Cd Puertollano Puertollano 31 76 50 58
4 Albacete Balompié Sub 19 B Albacete 32 53 39 58
5 Ud Almansa Ud Almansa 32 49 37 56
6 EFUD Albacer Sub 19 EFUD Albacer 32 63 51 55
7 CD Toledo Sub 19 Toledo 32 53 33 51
8 Cf Gimnástico Gimnástico 32 63 40 50
9 UB Conquense Sub 19 Conquense 32 49 60 44
10 Daimiel Daimiel 32 49 57 43
11 E Zona 5 Albacete Zona 32 48 52 42
12 CD Ciudad Real Juvenil Ciudad Real 32 41 46 39
13 Mora CF Sub 19 Mora 32 57 67 39
14 Torrijos CD Sub 19 Torrijos 32 44 46 37
15 AD Illescas Sub 19 Illescas 32 51 71 25
16 San José Obrero José Obrero 32 41 75 25
17 Cd Caudetano Caudetano 32 39 80 25
18 Sonseca Sonseca 32 36 109 13
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Tomelloso Cf Juvenil Tomelloso 34 67 37 68
2 Albacete Balompié Sub 19 B Albacete 34 67 38 64
3 CD Ciudad Real Juvenil Ciudad Real 34 56 33 61
4 UD Talavera UD Talavera 34 71 39 60
5 Ud Almansa Ud Almansa 34 54 43 52
6 Talavera de la Reina Sub 19 Talavera 34 57 61 47
7 Daimiel Cf Daimiel Cf 34 42 53 47
8 San José Obrero José Obrero 34 63 64 46
9 Pdm Mora Pdm Mora 34 43 50 46
10 Guadalajara Sub 19 Guadalajara 34 41 51 46
11 Gimnástico De Alcázar Gimnástico 34 38 38 44
12 E Zona 5 Albacete Zona 34 57 59 44
13 Cd San Vicente Vicente 34 54 59 44
14 UB Conquense Sub 19 Conquense 34 44 46 43
15 Cristo De La Vega Cristo Vega 34 25 25 39
16 Villanueva De La Torre Villanueva 34 48 62 36
17 Fundación Albacete Fundación 34 47 66 36
18 Edm Villacañas Villacañas 34 24 74 18
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Albacete Balompié Sub 19 B Albacete 34 89 35 75
2 CD Toledo Sub 19 Toledo 34 83 35 67
3 SD Tarazona SD Tarazona 34 69 54 66
4 Villanueva De La Torre Villanueva 34 58 40 56
5 Ud Almansa Ud Almansa 34 58 51 54
6 Fundación Albacete Fundación 34 59 46 53
7 Guadalajara Sub 19 Guadalajara 34 56 45 52
8 Cristo De La Vega Cristo Vega 34 63 55 51
9 Hellín CF Sub 19 Hellín 34 54 47 46
10 Gimnástico De Alcázar Gimnástico 34 56 72 46
11 Villacañas Villacañas 34 54 70 45
12 Daimiel Daimiel 34 67 67 43
13 Tomelloso Cf Juvenil Tomelloso 34 56 72 43
14 Cd Puertollano Puertollano 34 64 66 42
15 Torrijos CD Sub 19 Torrijos 34 55 76 42
16 CD Miguelturreño Sub 19 Miguelturre 34 54 69 41
17 Odelot Toletum Sub 19 Odelot 34 58 99 22
18 Cd Quintanar Quintanar 34 27 81 21
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Balompédica Conquense Balompédica 34 92 41 67
2 Daimiel Daimiel 34 65 41 67
3 Gimnástico De Alcázar Gimnástico 34 65 47 66
4 Guadalajara Sub 19 Guadalajara 34 64 36 63
5 Albacete Balompié Sub 19 B Albacete 34 66 35 62
6 Cristo De La Vega Cristo Vega 34 49 42 55
7 CD Toledo Sub 19 Toledo 34 54 50 52
8 Villacañas Villacañas 34 41 42 52
9 Odelot Toletum Sub 19 Odelot 34 58 47 51
10 Ud Almansa Ud Almansa 34 54 55 51
11 Hellín CF Sub 19 Hellín 34 63 61 49
12 Manchego C. Real Sub 19 Manchego 34 49 43 48
13 Quintanar Del Rey Quintanar 34 36 43 43
14 Valdepeñas Valdepeñas 34 43 67 34
15 Talavera Talavera 34 46 74 29
16 Sonseca Sonseca 34 43 81 28
17 La Roda Juvenil Roda Juvenil 34 41 82 24
18 Albacer Albacer 34 39 81 18

  USO DE MEMORIA  
6,746,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4598
Total Execution Time  0.4617
  CADENA URL  
/nacional_juvenil2024/grupo15/historico
  GET DATOS  
$_GET['/nacional_juvenil2024/grupo15/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0165  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 112 AND group_code = 15 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0267  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 73391 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 68420 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 63628 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 59011 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 50795 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 44721 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 39230 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` 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 = 34241 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 16669 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 4218 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 2733 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 2131 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` 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 = 1522 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 1170 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 911 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 761 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 16:23:40' 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-04-28 16:23:40' 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-04-28 16:23:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 16:23:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0229  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 = 73391 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73391 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.0266  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 = 73391 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73391 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0140  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 = 73391 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73391 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10