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 UD Serranillos Serranillos 23 100 37 54
2 CD Casavieja Casavieja 23 103 34 52
3 Arevalo CF Arevalo CF 23 85 51 47
4 Pedro Bernardo CF Pedro 23 69 64 33
5 El Tiemblo El Tiemblo 23 57 52 30
6 FC Navaluenga Navaluenga 24 52 105 15
7 La Adrada La Adrada 23 18 141 6
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Sariegos del Bernesca Sariegos 18 77 17 45
2 CDF Cubillos Cubillos 18 54 24 41
3 CDF San Andrés Andrés 18 54 30 36
4 Cultural Leonesa C Cultural 18 41 12 35
5 CD Coyanza CD Coyanza 18 27 38 20
6 Onzonilla B Onzonilla B 18 32 46 18
7 Atlético Trobajo Atlético 18 18 58 14
8 Fútbol Eria Fútbol Eria 18 20 41 13
9 Casa de Asturias en León Casa 18 19 57 13
10 Cacabelense Cacabelense 18 19 38 12
11 Cultural Leonesa D Cultural 0 0 0 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Ribera Carrizo Ribera 18 51 19 44
2 Lliones Lliones 17 40 31 29
3 Villabalter Villabalter 17 38 29 29
4 CDF Eria CDF Eria 17 31 37 20
5 Soto De La Vega Soto Vega 17 30 39 18
6 Onzonilla B Onzonilla B 17 24 37 18
7 CDF San Andrés Andrés 17 27 49 14
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 La Valdoncina Valdoncina 24 61 29 49
2 Lliones Lliones 24 53 38 47
3 Boñar Boñar 23 48 42 39
4 Villabalter Villabalter 24 47 40 34
5 Onzonilla B Onzonilla B 24 47 50 29
6 Ribera Carrizo Ribera 24 47 62 23
7 Soto De La Vega Soto Vega 23 29 71 12
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Laciana Laciana 26 90 26 67
2 Atlético Pinilla Atlético 26 83 26 64
3 La Valdoncina Valdoncina 26 62 43 51
4 Ribera Carrizo Ribera 26 56 45 43
5 Boñar Boñar 26 56 70 35
6 Villabalter Villabalter 26 54 54 31
7 Lliones Lliones 26 47 55 26
8 Onzonilla B Onzonilla B 26 57 67 22
9 Caboalles De Abajo Caboalles 26 42 89 21
10 Soto De La Vega Soto Vega 26 36 108 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Benavides Benavides 26 109 34 62
2 Fútbol Eria Fútbol Eria 26 90 31 61
3 La Robla La Robla 26 87 39 61
4 Villabalter Villabalter 26 68 38 54
5 Atlético Pinilla Atlético 26 80 49 46
6 Lliones Lliones 25 69 52 46
7 La Valdoncina Valdoncina 26 59 43 42
8 Ribera Carrizo Ribera 26 53 49 39
9 Sahagún P. Sahagún P. 26 44 72 25
10 Soto De La Vega Soto Vega 26 47 85 22
11 Onzonilla B Onzonilla B 26 50 78 20
12 Garaballes Garaballes 25 31 120 15
13 Caboalles De Abajo Caboalles 26 50 88 14
14 Boñar Boñar 26 27 86 14
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Cd Fútbol Peña Fútbol 28 72 22 59
2 Santa Ana FS Santa 28 69 30 58
3 A. Paramés A. Paramés 28 79 31 57
4 Atlético Pinilla Atlético 28 64 42 50
5 CD Huracán Z Huracán 27 62 42 48
6 Fútbol Eria Fútbol Eria 28 67 48 48
7 Sahagún P. Sahagún P. 27 51 45 44
8 Onzonilla B Onzonilla B 27 59 44 38
9 Villabalter Villabalter 28 56 48 35
10 C. Abajo C. Abajo 26 60 80 30
11 Boñar Boñar 27 50 70 30
12 Garaballes Garaballes 28 46 91 29
13 Lliones Lliones 28 46 91 24
14 Soto Vega Soto Vega 26 30 60 22
15 Villamañán Villamañán 28 31 98 13
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Ponferradina B Ponferradina 24 92 16 58
2 Villadepalos Villadepalos 24 87 30 51
3 Santa Ana FS Santa 24 64 34 44
4 A. Paramés A. Paramés 24 52 46 41
5 Lliones Lliones 24 46 54 39
6 Sahagún P. Sahagún P. 24 67 63 35
7 Soto Vega Soto Vega 24 58 36 32
8 Boñar Boñar 24 36 73 22
9 Fútbol Eria Fútbol Eria 24 31 60 19
10 Villamañán Villamañán 24 29 88 14
11 Garaballes Garaballes 24 28 97 13
12 CD Huracán Z Huracán 24 24 95 8
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 CD Fabero CD Fabero 32 81 32 79
2 Onzonilla Onzonilla 32 82 31 71
3 Soto De La Vega Soto Vega 32 96 56 62
4 Villaobispo Villaobispo 32 81 48 62
5 Naraya De Halterofilia Naraya 32 79 52 61
6 La Valderia La Valderia 32 74 41 58
7 Caboalles De Abajo Caboalles 32 68 49 54
8 San Feliz De Torio Feliz Torio 32 67 55 50
9 Matarrosa Del Sil Matarrosa 32 51 44 50
10 Atlético Pinilla Atlético 32 68 49 49
11 La Robla La Robla 32 69 52 49
12 Santa Ana B Santa Ana B 32 55 50 44
13 Sahagún Promesas Sahagún 32 53 67 30
14 Atl. León Castilla Atl. León C. 32 36 113 16
15 Infanzones Infanzones 32 41 102 13
16 Eria Eria 32 42 108 12
17 Garaballes Garaballes 32 27 121 11

  USO DE MEMORIA  
5,250,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0793
Total Execution Time  0.0812
  CADENA URL  
/segunda_leon2024/grupo1/historico
  GET DATOS  
$_GET['/segunda_leon2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_leon2024'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_leon' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=111 ORDER BY order_id ASC
0.0019  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 = 74032 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 111 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0021  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 = 74032 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 69055 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.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 `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 = 51496 AND t.round = 20 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 = 45261 AND t.round = 28 ORDER BY team.conference 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 `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 = 39818 AND t.round = 27 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 = 34597 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 16940 AND t.round = 30 ORDER BY team.conference 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 `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 = 7721 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 746 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 19:33:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 19:33:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-06 19:33:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 19:33:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_leon' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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 = 74032 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74032 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.0019  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 = 74032 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74032 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 = 74032 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74032 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  SELECT *,(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 = 74032 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC