« Temporada Anterior
Temporada 2023
Temporada Siguiente »
Segunda Federación 2023 G 1
2022/2023

segunda b,segunda division b,rfef,segunda b rfef,segunda rfef,segunda division b RFEF,segunda division rfef,segunda federacion,2 rfef,2da rfef

Segunda Federación 2023 G 1

  • Arenteiro
  • Real Avilés Industrial
  • Real Valladolid Promesas
  • SD Compostela
  • Zamora
  • Guijuelo
  • Real Oviedo Vetusta
  • Gimnástica Torrelavega
  • Marino de Luanco
  • Rayo Cantabria
  • Coruxo
  • Langreo
  • Ourense CF
  • Palencia Cristo Atlético
  • CD Laredo
  • Burgos CF B
  • CD Lugo B
  • Bergantiños FC
  • Segunda Federación:

Clasificación

Equipo PJ GF GC Puntos
1 Arenteiro Arenteiro 34 44 19 73
2 Real Avilés Industrial Real Avilés 34 45 30 59
3 Real Valladolid Promesas Real 34 49 41 56
4 SD Compostela Compostela 34 42 27 54
5 Zamora Zamora 34 38 33 54
6 Guijuelo Guijuelo 34 35 29 54
7 Real Oviedo Vetusta Real Oviedo 34 44 42 51
8 Gimnástica Torrelavega Gimnástica 34 32 31 51
9 Marino de Luanco Marino 34 33 34 49
10 Rayo Cantabria Rayo 34 41 41 48
11 Coruxo Coruxo 34 36 29 46
12 Langreo Langreo 34 36 38 45
13 Ourense CF Ourense CF 34 36 36 43
14 Palencia Cristo Atlético Palencia 34 25 32 41
15 CD Laredo CD Laredo 34 20 31 35
16 Burgos CF B Burgos CF B 34 29 54 27
17 CD Lugo B CD Lugo B 34 30 47 26
18 Bergantiños FC Bergantiños 34 33 54 22

  USO DE MEMORIA  
5,291,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2942
Total Execution Time  0.2961
  CADENA URL  
/segunda_division_rfef2023/grupo1/resumen/34
  GET DATOS  
$_GET['/segunda_division_rfef2023/grupo1/resumen/34']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0118  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2023` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 67965 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0198  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2023` e INNER JOIN calendars2023 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 34 AND e.real_date IS NOT NULL AND e.league_id = 67965 ORDER BY total DESC LIMIT 100
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 02:51:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-20 02:51:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-20 02:51:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-20 02:51:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0479  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 = 67965 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67965 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.0388  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 = 67965 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67965 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0119  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 = 67965 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67965 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0220  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 = 67965 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC