4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Coreses Coreses 14 40 19 33
2 Fresno de La Ribera Fresno 14 41 12 31
3 CD Villaralbo B Villaralbo 15 38 24 29
4 Camarzana Y Los Valles Camarzana 15 33 36 27
5 Villalpando Villalpando 15 38 31 26
6 Morales Vino Morales Vino 15 34 35 19
7 C D San Cristobal Cristobal 14 25 25 17
8 Toresana Toresana 15 33 41 17
9 Santa Croya Santa Croya 15 28 44 15
10 Racing Club Benavente Racing Club 15 26 38 13
11 Sporting Zamora Sporting 15 23 36 11
12 Atlético Zamora Atlético 14 24 42 8
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 CD Navega CD Navega 22 72 14 55
2 Helmántica B Helmántica 22 55 35 47
3 Real Salamanca Monterrey Real 22 74 21 45
4 CDF Helmántico Helmántico 22 49 25 45
5 M. Pizarrales Pizarrales 22 47 41 33
6 Carbajosa De La Sagrada Carbajosa 22 49 37 32
7 Villamayor Villamayor 22 42 32 30
8 Guijuelo B Guijuelo B 22 38 46 29
9 Villares de La Reina Villares 22 37 50 22
10 Capuchinos Capuchinos 22 25 60 17
11 Jai Alai Bolivar Alai Bolivar 22 35 61 15
12 Cristo Rey Barrio Vidal Cristo 22 13 114 6
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Benavente Benavente 26 90 19 71
2 Bovedana Bovedana 26 112 28 65
3 Morales Vino Morales Vino 26 101 38 54
4 Fresno de La Ribera Fresno 26 89 36 54
5 Villalpando Villalpando 26 48 37 46
6 Santa Croya Santa Croya 26 80 82 45
7 Coreses Coreses 26 81 54 42
8 Sporting Zamora Sporting 26 71 53 37
9 Racing Club Benavente Racing Club 26 54 81 34
10 CD Villaralbo B Villaralbo 26 39 74 28
11 Camarzana Y Los Valles Camarzana 26 41 87 20
12 C D San Cristobal Cristobal 26 35 96 11
13 San Lorenzo de Zamora Lorenzo 26 40 106 11
14 Atlético Zamora Atlético 26 31 121 3
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Toresana Toresana 26 76 19 68
2 Racing Club Benavente Racing Club 25 67 25 61
3 Bovedana Bovedana 26 81 34 55
4 Morales Vino Morales Vino 26 69 41 48
5 Coreses Coreses 26 80 41 47
6 CD Villaralbo B Villaralbo 26 45 42 40
7 Sporting Zamora Sporting 26 55 53 40
8 Villalpando Villalpando 25 53 42 39
9 Santa Croya Santa Croya 26 58 62 32
10 Moraleja CF Moraleja CF 26 42 62 30
11 San Lorenzo de Zamora Lorenzo 26 56 86 20
12 Villaseco Villaseco 26 29 68 17
13 Atlético Zamora Atlético 26 27 96 12
14 A. Toresano A. Toresano 26 33 100 11
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Benavente Benavente 31 117 26 85
2 Morales Vino Morales Vino 32 108 48 66
3 Coreses Coreses 31 85 28 66
4 CD Villaralbo B Villaralbo 31 70 36 65
5 Villalpando Villalpando 32 101 47 62
6 Toresana Toresana 32 98 39 62
7 Santa Croya Santa Croya 31 88 67 56
8 Bovedana Bovedana 30 79 36 53
9 Benavente Benavente 31 69 51 49
10 Sporting Zamora Sporting 32 58 93 37
11 Villaseco Villaseco 31 39 60 29
12 Atlético Zamora Atlético 31 57 80 28
13 San Lorenzo de Zamora Lorenzo 31 50 99 27
14 A. Toresano A. Toresano 31 47 104 22
15 Moraleja CF Moraleja CF 32 27 80 19
16 X. Ferreruela Ferreruela 20 28 78 12
17 C. Tábara C. Tábara 31 18 167 4
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Fresno de La Ribera Fresno 29 115 21 83
2 Morales Vino Morales Vino 29 102 29 75
3 Santa Croya Santa Croya 29 88 65 58
4 Benavente Benavente 29 64 42 56
5 CD Villaralbo B Villaralbo 29 51 45 50
6 Bovedana Bovedana 29 52 51 46
7 Coreses Coreses 29 60 46 43
8 Toresana Toresana 29 65 56 41
9 Atlético Zamora Atlético 29 50 64 35
10 Villalpando Villalpando 29 69 73 34
11 V. Escuderos Escuderos 29 52 59 32
12 Sayagues Sayagues 29 38 60 24
13 A. Burganes A. Burganes 29 56 93 24
14 Fuentesauco Fuentesauco 29 38 101 21
15 Fuentespreadas Fuentespread 29 33 87 19
16 Pozuelo Pozuelo 29 35 76 17

  USO DE MEMORIA  
5,304,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.3751
Total Execution Time  0.3784
  CADENA URL  
/primera_castilla_y_leon2020/grupo9/historico
  GET DATOS  
$_GET['/primera_castilla_y_leon2020/grupo9/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_castilla_y_leon' AND (l.group_code = 9 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=9 DESC LIMIT 1
0.0145  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 = 51317 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1298 AND group_code = 9 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0150  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 = 51317 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 45244 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 39784 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 34577 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 16933 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 7733 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:35:12' 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-04-27 21:35:12' 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-04-27 21:35:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:35:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  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 events2020 e ON e.player_id = p.id AND e.league_id = 51317 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51317 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.0146  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 events2020 e ON e.player_id = p.id AND e.league_id = 51317 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51317 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0147  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 events2020 e ON e.player_id = p.id AND e.league_id = 51317 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51317 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0157  SELECT *,(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 = 51317 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC