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 Palencia Cristo Atlético B Palencia 26 64 17 62
2 Monzon Monzon 26 70 25 58
3 Villada Villada 26 54 34 50
4 Guardense Guardense 25 59 33 46
5 Baltanás Baltanás 26 45 26 46
6 CD Cervera CD Cervera 24 68 31 44
7 Villalobon Villalobon 26 51 35 44
8 Atlético Aguilar Atlético 25 42 36 43
9 Venta De Baños Venta Baños 25 58 31 41
10 San Telmo San Telmo 26 68 48 41
11 Fromista Fromista 26 60 47 40
12 Saldaña Saldaña 25 34 30 40
13 San Antonio Hyuconsa Antonio 25 54 72 33
14 Alar Alar 26 35 53 30
15 Jovenes Promesas Jovenes 25 34 40 25
16 Astudillo Astudillo 26 40 55 24
17 Cd Velilla Cd Velilla 26 41 77 21
18 Castilla de Dueñas Castilla 26 37 64 20
19 UP Palencia UP Palencia 26 27 64 16
20 CD Grijota CD Grijota 26 19 142 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Carejas Paredes Carejas 32 75 21 72
2 Atlético Aguilar Atlético 32 60 29 69
3 Baltanás Baltanás 31 67 34 64
4 CD Cervera CD Cervera 31 77 38 63
5 Monzon Monzon 32 64 29 61
6 San Telmo San Telmo 32 71 51 58
7 Cristo A. B Cristo A. B 31 54 42 55
8 Villalobon Villalobon 32 47 46 45
9 Fromista Fromista 32 36 50 43
10 Villada Villada 32 54 55 39
11 Astudillo Astudillo 31 49 52 39
12 Castilla Dueñas Castilla 31 54 79 36
13 Saldaña Saldaña 30 29 50 31
14 Cd Velilla Cd Velilla 30 44 61 23
15 Alar Alar 30 26 65 18
16 San Antonio Hyuconsa Antonio 31 33 92 17
17 San Juanillo Juanillo 32 27 73 16
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Monzon Monzon 26 60 32 55
2 CD Cervera CD Cervera 26 57 18 51
3 Venta De Baños Venta Baños 26 59 26 50
4 Saldaña Saldaña 26 42 24 49
5 Atlético Aguilar Atlético 26 43 33 45
6 Castilla Dueñas Castilla 26 57 53 45
7 San Telmo San Telmo 26 45 36 44
8 Villada Villada 26 47 47 39
9 Astudillo Astudillo 26 55 38 38
10 Fromista Fromista 26 44 62 23
11 Villalobon Villalobon 26 36 68 22
12 Cd Velilla Cd Velilla 26 39 73 19
13 Palencia Cristo Atlético B Palencia 26 35 71 17
14 Alar Alar 26 41 79 16
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 CD Cervera CD Cervera 30 104 25 72
2 Carejas Paredes Carejas 30 90 21 70
3 Astudillo Astudillo 30 84 44 55
4 Monzon Monzon 30 83 54 54
5 Castilla Palencia Balompié Castilla 30 70 43 53
6 Atlético Aguilar Atlético 30 44 39 48
7 Saldaña Saldaña 30 47 37 47
8 Fromista Fromista 30 54 39 46
9 Castilla Dueñas Castilla 30 45 38 46
10 San Telmo San Telmo 30 53 49 41
11 Alar Alar 30 49 66 41
12 Cd Velilla Cd Velilla 30 62 68 40
13 San Juanillo Juanillo 30 50 72 28
14 Villada Villada 30 52 95 28
15 Pan Y Guindas Guindas 30 29 131 10
16 Villalobon Villalobon 30 33 128 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 CD Cervera CD Cervera 32 85 29 78
2 Alar Alar 32 82 36 66
3 Castilla Palencia Castilla 32 62 33 59
4 Astudillo Astudillo 32 67 40 56
5 San Telmo San Telmo 32 48 38 55
6 Fromista Fromista 32 69 55 55
7 Saldaña Saldaña 32 47 45 48
8 Villada Villada 32 59 64 48
9 Monzon Monzon 32 62 48 47
10 Castilla Dueñas Castilla 32 67 44 45
11 I de La Amistad Amistad 32 49 42 45
12 Carejas Paredes Carejas 32 40 45 43
13 Villalobon Villalobon 32 56 81 34
14 Cd Velilla Cd Velilla 32 53 69 30
15 San Juanillo Juanillo 32 48 77 30
16 Pan Y Guindas Guindas 32 41 111 14
17 Villarramiel Villarramiel 32 39 117 8
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CD Cervera CD Cervera 29 98 29 70
2 Palencia CF Palencia CF 29 73 23 69
3 Monzon Monzon 29 59 41 57
4 Castilla Dueñas Castilla 29 55 27 56
5 Fromista Fromista 29 65 42 53
6 Castilla Palencia Castilla 29 61 46 48
7 Cristo A. B Cristo A. B 29 57 47 47
8 Carejas Paredes Carejas 29 50 30 46
9 Villada Villada 29 57 52 39
10 Astudillo Astudillo 29 50 46 36
11 H. Pisuerga H. Pisuerga 29 32 56 28
12 Villalobon Villalobon 29 45 70 27
13 Villarramiel Villarramiel 29 43 105 24
14 San Juanillo Juanillo 29 40 73 22
15 Alar Alar 29 39 59 21
16 Pan Y Guindas Guindas 29 26 104 9

  USO DE MEMORIA  
5,743,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0915
Total Execution Time  0.0935
  CADENA URL  
/primera_castilla_y_leon2020/grupo4/historico
  GET DATOS  
$_GET['/primera_castilla_y_leon2020/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0017  SELECT type FROM routes WHERE alias = 'primera_castilla_y_leon2020'
0.0039  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 = 4 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=4 DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1298 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1298 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1312772,1202745,912076,807251,716314) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1298 ORDER BY order_id ASC
0.0021  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 = 51312 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1298 AND group_code = 4 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0025  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 = 51312 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 45159 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 39779 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 34572 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 16922 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 = 7727 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 15:07:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 15:07:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 15:07:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 15:07:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0029  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 = 0 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=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 events2020 e ON e.player_id = p.id AND e.league_id = 51312 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51312 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.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 events2020 e ON e.player_id = p.id AND e.league_id = 51312 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51312 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0024  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 = 51312 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51312 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0056  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 = 51312 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC