4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
22 jugadores
Lyn 1896 FK Lyn 1896 FK
V. Engh V. Engh 19 años 192cm POR
A. Pedersen A. Pedersen 28 años 190cm POR
W. Sell W. Sell 25 años 184cm 75kg DEF
E. Sivertsen E. Sivertsen 33 años 179cm 82kg DEF
E. Kristiansen E. Kristiansen 31 años DEF
H. Meinseth H. Meinseth 25 años 184cm DEF
C. Lindquist C. Lindquist 28 años 181cm 69kg DEF
D. Schneider D. Schneider 22 años 186cm DEF
H. Nilsen H. Nilsen 25 años 186cm 75kg DEF
A. Randers A. Randers 23 años DEF
R. Isegran R. Isegran 31 años DEF
Jacob Hanstad Jacob Hanstad 21 años MED
J. Skaug J. Skaug 26 años 183cm MED
Henrik Kristiansen Henrik Kristiansen 25 años 171cm 71kg MED
E. Bydal E. Bydal 26 años 177cm MED
H. Elvevold H. Elvevold 24 años 188cm MED
M. Ingebrigtsen M. Ingebrigtsen 24 años 190cm MED
A. Olsen A. Olsen 24 años 188cm DEL
I. Laajab I. Laajab 38 años 190cm 78kg DEL
O. Breistøl O. Breistøl 25 años 185cm 73kg DEL
B. Hylen B. Hylen 18 años DEL
A. Hellum A. Hellum 26 años 185cm 70kg DEL
23 jugadores
Hødd Hødd
B. Kazige B. Kazige
M. Elveseter M. Elveseter
O. Alme O. Alme 27 años 182cm POR
M. Andersen M. Andersen 22 años 185cm POR
S. Sundnes S. Sundnes 24 años 187cm DEF
T. Romo Lillo T. Romo Lillo 26 años 186cm DEF
Bernardo Morgado Bernardo Morgado 26 años 187cm DEF
M. Mirza M. Mirza 18 años DEF
Renato Ziko Renato Ziko 26 años 180cm DEF
P. Nersveen P. Nersveen 31 años 183cm DEF
E. Larsen E. Larsen 28 años 183cm DEF
M. Alm M. Alm 26 años 197cm 81kg DEF
S. Okland S. Okland 30 años 177cm 72kg MED
M. Håheim-Elveseter M. Håheim-Elveseter 18 años MED
I. Skotheim I. Skotheim 23 años MED
K. Tosse K. Tosse 27 años MED
T. Kallevag T. Kallevag 30 años 179cm 65kg MED
H. Urnes H. Urnes 21 años MED
Syver Skeide Syver Skeide 19 años 185cm MED
R. Hjelmeseth R. Hjelmeseth 30 años 182cm DEL
Gustav Mogensen Gustav Mogensen 23 años 190cm 78kg DEL
A. Scriven A. Scriven 26 años 187cm 83kg DEL
V. Håheim Elvester V. Håheim Elvester 20 años DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,357,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3855
Total Execution Time  0.3875
  CADENA URL  
/segunda_noruega_playoffs_ascenso2023/grupo0/jugadores
  GET DATOS  
$_GET['/segunda_noruega_playoffs_ascenso2023/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0126  SELECT type FROM routes WHERE alias = 'segunda_noruega_playoffs_ascenso2023'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_noruega_playoffs_ascenso' 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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2413 AND type_rel = 3
0.0140  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=350 ORDER BY l.group_code ASC
0.0130  SELECT id,name,alias,stepParent FROM categories WHERE parentId=350 ORDER BY order_id ASC
0.0130  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2413 GROUP BY l.categoryId
0.0129  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2413 GROUP BY l.year ORDER BY l.year DESC
0.0128  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 = 74594 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74594 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0133  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 74594 AND dt.id IN (1082,11821) ORDER BY dt.relations DESC,dp.role ASC
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 10:42:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 10:42:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 10:42:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 10:42:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2413 AND l.year = 2023
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74594) 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.0127  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 (74594) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (384835,370817,797997,864534,922938) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2413 AND l.year = 2023
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74594) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (74594) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (332012,289053,334769,383521,385604,864534,922938,3171086) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2413 AND l.year = 2023
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74594) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10