4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Racing Ferrol Racing 38 55 25 75
2 Alcorcón Alcorcón 38 53 23 74
3 RM Castilla RM Castilla 38 58 38 69
4 RC Deportivo Deportivo 38 53 29 67
5 Celta Fortuna Celta 38 48 38 59
6 Linares Deportivo Linares 38 53 53 59
7 Unionistas CF Unionistas 38 38 40 56
8 AD Mérida AD Mérida 38 40 37 54
9 Córdoba CF Córdoba CF 38 48 37 54
10 Cultural Leonesa Cultural 38 41 43 48
11 Fuenlabrada Fuenlabrada 38 32 51 46
12 AD Ceuta FC AD Ceuta FC 38 53 52 45
13 San Fernando CD Fernando 38 46 50 45
14 Rayo Majadahonda Rayo 38 42 51 45
15 Algeciras CF Algeciras 38 36 47 44
16 CD Badajoz CD Badajoz 38 35 52 43
17 UD Sanse UD Sanse 38 30 46 43
18 RB Linense RB Linense 38 31 34 42
19 Pontevedra Pontevedra 38 34 53 36
20 CF Talavera CF Talavera 38 36 63 33
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Racing Racing 38 61 31 82
2 RC Deportivo Deportivo 38 59 29 74
3 Racing Ferrol Racing 38 50 26 72
4 Rayo Majadahonda Rayo 38 50 47 62
5 UD Logroñés Logroñés 38 41 37 62
6 Celta Fortuna Celta 38 60 46 61
7 Unionistas CF Unionistas 38 55 37 61
8 Real Unión Club Real Unión 38 51 45 60
9 CD Badajoz CD Badajoz 38 40 30 56
10 UD Sanse UD Sanse 38 40 41 53
11 CD Calahorra Calahorra 38 48 43 52
12 Cultural Leonesa Cultural 38 61 55 49
13 SD Logroñés Logroñés 38 43 43 48
14 Internacional de Madrid Internaciona 38 46 51 46
15 Bilbao Ath. Bilbao Ath. 38 36 46 45
16 CF Talavera CF Talavera 38 39 54 42
17 Zamora Zamora 38 30 48 37
18 Real Valladolid Promesas Real 38 42 64 36
19 Tudelano Tudelano 38 33 54 28
20 Extremadura Extremadura 38 22 80 0

  USO DE MEMORIA  
5,473,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2954
Total Execution Time  0.2973
  CADENA URL  
/primera_division_rfef2023/grupo1/historico
  GET DATOS  
$_GET['/primera_division_rfef2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0105  SELECT type FROM routes WHERE alias = 'primera_division_rfef2023'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_rfef' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2468 AND type_rel = 3
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2468 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0112  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 `tables2022` 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 = 62378 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 14:05:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 14:05:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 14:05:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 14:05:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_rfef' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0222  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 events2023 e ON e.player_id = p.id AND e.league_id = 67959 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67959 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.0439  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 events2023 e ON e.player_id = p.id AND e.league_id = 67959 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67959 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0123  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 events2023 e ON e.player_id = p.id AND e.league_id = 67959 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67959 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0120  SELECT *,(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 = 67959 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC