4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Liga Noruega - Play Offs Ascenso 2023
2022/2023

eliteserien playoffs , playoffs primera division de noruega, playoffs liga profesional de noruega, playoffs superliga noruega, playoffs primera noruega,

Liga Noruega - Play Offs Ascenso 2023

Valerenga IF Valerenga
Datos equipo
Nombre Valerenga IF
Nombre completo Vålerenga Fotball
Nombre corto VIF
País
Año fundación 1913
Total plantilla 27
Estadio
Nombre estadio Ulleval Stadion
Capacidad estadio 25572
Año construcción 1926
Tipo césped Natural
Internet
Sitio web https://www.vif-fotball.no/
Twitter del equipo @ValerengaOslo
Información
Dirección Sognsveien 75
Teléfono +47 (23) 247 800
Fax +47 (23) 247 801
Otros datos
Patrocinador Den Norske Bank
Marca de ropa Adidas
Kristiansund BK Kristiansund
Datos equipo
Nombre Kristiansund BK
Nombre completo Kristiansund Ballklubb
Nombre corto KRI
País
Año fundación 2003
Total plantilla 30
Estadio
Nombre estadio Kristiansund kunstgress
Capacidad estadio 1000
Tipo césped Césped Artificial
Internet
Sitio web http://www.kristiansundbk.no/
Twitter del equipo @KristiansundBK
Otros datos
Patrocinador SpareBank 1 Nordvest
Marca de ropa Macron

Equipos de esta liga

2

  USO DE MEMORIA  
4,187,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0682
Total Execution Time  0.0703
  CADENA URL  
/liga_noruega_playoffs_ascenso2023/grupo0/equipos
  GET DATOS  
$_GET['/liga_noruega_playoffs_ascenso2023/grupo0/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0020  SELECT type FROM routes WHERE alias = 'liga_noruega_playoffs_ascenso2023'
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1996 AND type_rel = 3
0.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1996 ORDER BY order_id ASC
0.0043  SELECT t.id,t.teamId,t.total_players,dt.* FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74771 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 05:24:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 05:24:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 05:24:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 05:24:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0038  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1996 AND l.year = 2023
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74771) 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.0030  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 (74771) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (216242,676759,949665,3163326) ORDER BY rp.in_squad = 1 DESC
0.0029  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1996 AND l.year = 2023
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74771) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0040  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 (74771) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (218870,232598,286123,384411,429656,887461,949665) ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1996 AND l.year = 2023
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74771) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10