4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CFR Cluj CFR Cluj
Datos equipo
Nombre CFR Cluj
Nombre completo SCS CFR 1907 Cluj
Nombre corto CLU
País
Año fundación 1907
Total plantilla 39
Estadio
Nombre estadio Stadionul Dr. Constantin Rădulescu
Capacidad estadio 23200
Año construcción 1972
Tipo césped Natural
Dimensiones campo 102 x 86 metros
Internet
Sitio web http://www.cfr1907.ro
Twitter del equipo @CFR_1907_Cluj
Información
Dirección Strada Romulus Vuia, nr. 23
Teléfono +40 (264) 598 831
Fax +40 (264) 598 833
Otros datos
Socios 4500
Universitatea Craiova Universitate
Datos equipo
Nombre Universitatea Craiova
Nombre completo U Craiova 1948 Club Sportiv
Nombre corto CSU
País
Año fundación 1948
Total plantilla 36
Estadio
Nombre estadio Stadionul Ion Oblemenco
Capacidad estadio 25252
Año construcción 1967
Dimensiones campo 105x68m
Internet
Sitio web http://www.csuc.ro/ro/
Twitter del equipo @OfficialUCV
Otros datos
Equipo filial CS U II Craiova
Equipos de esta liga
2
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,157,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.1074
Total Execution Time  0.1104
  CADENA URL  
/supercopa_rumania2022/grupo0/equipos
  GET DATOS  
$_GET['/supercopa_rumania2022/grupo0/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0035  SELECT type FROM routes WHERE alias = 'supercopa_rumania2022'
0.0071  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_rumania' 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.0034  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=299 AND type_rel = 3
0.0036  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 299 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0057  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (667734) ORDER BY n.cover_points DESC, update_date DESC
0.0035  SELECT id,name,alias,stepParent FROM categories WHERE parentId=299 ORDER BY order_id ASC
0.0036  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 = 63036 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0039  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 = 63036 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 08:36:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0036  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 08:36:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 08:36:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0036  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 08:36:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0037  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 299 AND l.year = 2022
0.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (63036) 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.0036  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 299 AND l.year = 2022
0.0034  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (63036) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0039  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 (63036) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (230174,814700) ORDER BY rp.in_squad = 1 DESC
0.0035  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 299 AND l.year = 2022
0.0034  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (63036) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10