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 Beroil Bupolsa B Beroil 22 70 18 50
2 Polideportivo Salas Polideportiv 21 58 14 50
3 Promesas 2000 B Promesas 22 67 20 48
4 Belorado Belorado 22 56 23 44
5 Alcázar Alcázar 22 55 21 43
6 Capiscol Capiscol 22 63 33 41
7 Gamonal Gamonal 22 63 27 39
8 CD Raudense CD Raudense 22 45 30 34
9 Arandina CF B Arandina 21 33 54 28
10 Vadillos Vadillos 21 32 29 27
11 Cerezo Cerezo 22 24 44 23
12 Aranda Riber Aranda Riber 22 30 66 19
13 San Felices San Felices 22 24 70 17
14 Montija Montija 22 22 61 16
15 Villarcayo Nela B Villarcayo 21 28 59 11
16 Real Burgos CF SAD B Real Burgos 22 12 113 7
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Vista Alegre CD Vista Alegre 27 64 39 60
2 Polideportivo Salas Polideportiv 27 49 27 55
3 CD Raudense CD Raudense 27 67 36 52
4 Capiscol Capiscol 27 66 34 48
5 Belorado Belorado 27 60 35 47
6 Alcázar Alcázar 27 54 39 46
7 Gamonal Gamonal 27 57 47 45
8 Promesas 2000 B Promesas 27 62 39 44
9 Beroil Bupolsa B Beroil 27 60 33 43
10 Vadillos Vadillos 27 56 37 43
11 San Felices San Felices 27 27 51 22
12 Cerezo Cerezo 27 39 68 22
13 Montija Montija 27 27 84 16
14 A. Castellae Castellae 28 32 77 15
15 Trespaderne Trespaderne 27 14 88 5
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Promesas 2000 B Promesas 26 90 18 61
2 Arandina CF B Arandina 26 79 26 61
3 Vista Alegre CD Vista Alegre 26 59 26 59
4 Belorado Belorado 26 67 30 53
5 Capiscol Capiscol 26 57 35 45
6 Alcázar Alcázar 26 63 52 45
7 Gamonal Gamonal 26 55 35 41
8 San Felices San Felices 26 34 49 30
9 A. Castellae Castellae 26 33 59 26
10 Real Burgos CF SAD B Real Burgos 26 41 74 26
11 Montija Montija 26 40 71 21
12 Trespaderne Trespaderne 26 27 71 19
13 Cerezo Cerezo 26 22 63 17
14 Frias Frias 26 32 90 16
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 CD Raudense CD Raudense 26 84 25 65
2 Promesas 2000 B Promesas 26 84 21 61
3 Beroil Bupolsa B Beroil 26 70 16 58
4 Alcázar Alcázar 26 66 36 58
5 Vista Alegre CD Vista Alegre 26 78 62 40
6 Belorado Belorado 26 50 34 37
7 Capiscol Capiscol 26 34 36 37
8 San Felices San Felices 26 42 42 36
9 A. Castellae Castellae 26 48 60 30
10 Trespaderne Trespaderne 26 34 65 25
11 Montija Montija 26 40 58 24
12 Frias Frias 26 41 93 23
13 Burgos CF B Burgos CF B 26 30 90 13
14 Cerezo Cerezo 26 19 82 8
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Gamonal Gamonal 28 82 18 75
2 CD Univ. Burgos Univ. Burgos 28 110 15 71
3 CD Raudense CD Raudense 28 63 49 53
4 Alcázar Alcázar 28 71 33 51
5 Beroil Bupolsa B Beroil 28 67 36 50
6 Promesas 2000 B Promesas 28 60 27 47
7 Capiscol Capiscol 28 46 47 44
8 Belorado Belorado 28 53 59 42
9 Trespaderne Trespaderne 28 43 58 37
10 A. Castellae Castellae 28 52 55 37
11 Vista Alegre CD Vista Alegre 28 50 49 34
12 Frias Frias 28 36 104 17
13 Montija Montija 28 25 80 16
14 Cerezo Cerezo 28 20 81 13
15 San Felices San Felices 28 37 104 7
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Villarcayo Nela Villarcayo 34 90 30 82
2 Gamonal Gamonal 34 80 27 75
3 Alcázar Alcázar 34 73 38 71
4 Promesas 2000 B Promesas 34 93 42 68
5 Casco Viejo Casco Viejo 34 73 41 68
6 Trespaderne Trespaderne 34 76 54 68
7 Belorado Belorado 34 69 42 66
8 U. Burgos B U. Burgos B 34 80 43 60
9 Capiscol Capiscol 34 61 42 55
10 A. Castellae Castellae 34 62 62 49
11 San Felices San Felices 34 49 67 36
12 Quintanar Quintanar 34 54 63 35
13 Quintanadueñas Quintanadue 34 67 100 32
14 Oña Oña 34 43 92 24
15 Montija Montija 34 51 88 22
16 Vista Alegre CD Vista Alegre 34 34 84 22
17 Cerezo Cerezo 34 23 88 18
18 Frias Frias 34 33 108 16

  USO DE MEMORIA  
5,519,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0993
Total Execution Time  0.1012
  CADENA URL  
/primera_castilla_y_leon2020/grupo2/historico
  GET DATOS  
$_GET['/primera_castilla_y_leon2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0044  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 = 2 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=2 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1298 AND type_rel = 3
0.0022  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.0023  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1298 ORDER BY order_id ASC
0.0020  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 = 51310 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1298 AND group_code = 2 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 = 51310 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.0024  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 = 45157 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 39777 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 34570 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 16920 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0076  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 = 7719 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 07:09:54' 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-04 07:09:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 07:09:54' 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=3 AND last_update > '2024-05-04 07:09:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0044  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 = 51310 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51310 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.0037  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 = 51310 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51310 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 = 51310 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51310 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0060  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 = 51310 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