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,513,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3667
Total Execution Time  0.3688
  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 (19)  
0.0263  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.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1298 ORDER BY order_id ASC
0.0127  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.0129  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.0135  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.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 = 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.0141  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.0146  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.0146  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.0155  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.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 01:28:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 01:28:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 01:28:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 01:28:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0143  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.0128  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.0129  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.0131  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.0154  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