4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Kings League 2024 G 1
2023/2024

Fase regular - Split 3

Kings League 2024 G 1

  • Aniquiladores
  • Saiyans FC
  • Jijantes FC
  • Ultimate Móstoles
  • Los Troncos
  • 1K
  • Kunisports
  • Porcinos FC
  • Xbuyer Team
  • El Barrio
  • Pio FC
  • Rayo de Barcelona
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Aniquiladores Aniquiladore 11 44 34 23
2 Saiyans FC Saiyans FC 11 37 28 23
3 Jijantes FC Jijantes FC 11 32 37 21
4 Ultimate Móstoles Ultimate 11 43 20 20
5 Los Troncos Los Troncos 11 33 28 20
6 1K 1K 11 36 36 19
7 Kunisports Kunisports 11 30 32 15
8 Porcinos FC Porcinos FC 11 42 45 15
9 Xbuyer Team Xbuyer Team 11 42 39 14
10 El Barrio El Barrio 11 33 40 12
11 Pio FC Pio FC 11 31 47 11
12 Rayo de Barcelona Rayo 11 27 44 5
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Ultimate Móstoles Ultimate 11 34 27 24
2 Porcinos FC Porcinos FC 11 37 26 21
3 Los Troncos Los Troncos 11 40 34 21
4 Saiyans FC Saiyans FC 11 21 18 21
5 Kunisports Kunisports 11 23 22 21
6 Xbuyer Team Xbuyer Team 11 25 25 18
7 Aniquiladores Aniquiladore 11 29 30 18
8 El Barrio El Barrio 11 33 25 15
9 1K 1K 11 32 34 15
10 Pio FC Pio FC 11 27 29 12
11 Rayo de Barcelona Rayo 11 27 40 9
12 Jijantes FC Jijantes FC 11 23 41 3

  USO DE MEMORIA  
4,762,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0633
Total Execution Time  0.0652
  CADENA URL  
/kings-league2024/grupo1/historico
  GET DATOS  
$_GET['/kings-league2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2723 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2723 ORDER BY order_id ASC
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2723 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 = 75117 AND t.round = 11 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 = 70503 AND t.round = 11 ORDER BY team.conference ASC,t.position 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-01 00:26:43' 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-01 00:26:43' 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-01 00:26:43' 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-01 00:26:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2723 AND l.year = 2024
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75117,75783) 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, e.player_id ASC LIMIT 10
0.0023  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (75117,75783) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (429204,948643,3249337,3313593,81428,969879,823937,915184,27020,3367505) ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2723 AND l.year = 2024
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75117,75783) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0024  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (75117,75783) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (124266,3202365,3370796,3383726,23358,23574,27383,36833,72150,104130) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2723 AND l.year = 2024
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75117,75783) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0023  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (75117,75783) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (27383,91378,174555,950871,993300,3183404,3370809) ORDER BY rp.in_squad = 1 DESC