4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
SKA-Khabarovsk SKA-Khabarov
Datos equipo
Nombre SKA-Khabarovsk
Nombre completo Football Club SKA-Energia Khabarovsk
Nombre corto SKA
País
Año fundación 1946
Total plantilla 27
Internet
Sitio web http://fcska.ru/
FK Khimki FK Khimki
Datos equipo
Nombre FK Khimki
Nombre completo Futbolni Klub Khimki
Nombre corto KHI
País
Año fundación 1996
Total plantilla 29
Estadio
Nombre estadio Arena Khimki
Capacidad estadio 18000
Tipo césped Natural
Internet
Sitio web https://fckhimki.com/
Twitter del equipo @fc_khimki
FC Orenburg FC Orenburg
Datos equipo
Nombre FC Orenburg
Nombre completo FC Orenburg
Nombre corto GAZ
País
Total plantilla 26
Estadio
Nombre estadio Estadio Gazovik
Capacidad estadio 7500
Año construcción 2002
Internet
Twitter del equipo @fcorenburg
Datos equipo
Nombre Ufa
Nombre completo Futbolnyĭ Klub Ufa
Nombre corto UFA
País
Año fundación 2009
Total plantilla 24
Estadio
Nombre estadio Neftyanik Stadium
Capacidad estadio 15200
Internet
Sitio web http://fcufa.pro/
Twitter del equipo @UfaFc
Información
Dirección ul. Karla Marksa 2

Equipos de esta liga

4

  USO DE MEMORIA  
4,246,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3515
Total Execution Time  0.3538
  CADENA URL  
/rusia_ascenso2022/grupo0/equipos
  GET DATOS  
$_GET['/rusia_ascenso2022/grupo0/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0126  SELECT type FROM routes WHERE alias = 'rusia_ascenso2022'
0.0261  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'rusia_ascenso' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 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=632 AND type_rel = 3
0.0129  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=27 ORDER BY l.group_code ASC
0.0127  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 = 67666 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139  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 = 67666 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 05:24:07' 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-10 05:24:07' 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-10 05:24:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 05:24:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 632 AND l.year = 2022
0.0137  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (67666) 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.0141  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 (67666) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (287827,22823,190064,218845,284729,304708,308000,322024,406934,476975) ORDER BY rp.in_squad = 1 DESC
0.0132  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 632 AND l.year = 2022
0.0132  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (67666) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0137  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 (67666) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (287827,308000,379978,776592,3171381,66303,69060,182511,214668,266888) ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 632 AND l.year = 2022
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (67666) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0140  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 (67666) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (287828) ORDER BY rp.in_squad = 1 DESC