4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del ACF Gloria Bistrita
Información
Otros Datos
  • Año de Fundación 1922
Internet

Información sobre el estadio

  • Nombre del estadio Gloria
  • Capacidad 8100
  • Dirección Str. Parcului nr. 3, Bistrita, cod 420035
  • Teléfono 0263-212 998
  • Fax 0263-217 437
Gloria

Partidos del ACF Gloria Bistrita

Ir al LIVESCORE
29 Sep 93  Finalizado Maribor Maribor
2 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
15 Sep 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
0 - 0
Maribor Maribor 0
27 Abr 94  Finalizado Inter Sibiu Inter Sibiu
2 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
24 Abr 94  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
3 - 1
UTA Arad UTA Arad 0
13 Abr 94  Finalizado Ceahlaul Piatra Neamt Ceahlaul Piatra Neamt
1 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
10 Abr 94  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
1 - 0
Universitatea Cluj Universitatea Cluj 0
06 Abr 94  Finalizado Politehnica Timisoara Politehnica Timisoara
2 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
02 Abr 94  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
3 - 2
Universitatea Craiova Universitatea Craiova 0
30 Mar 94  Finalizado FC Rapid Bucuresti FC Rapid Bucuresti
1 - 2
ACF Gloria Bistrita ACF Gloria Bistrita 0
26 Mar 94  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
1 - 0
Progresul Bucureşti Progresul Bucureşti 0
19 Mar 94  Finalizado Petrolul Ploiesti Petrolul Ploiesti
2 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
16 Mar 94  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
1 - 0
Oțelul Galați Oțelul Galați 0
09 Mar 94  Finalizado FC Farul Constanta FC Farul Constanta
1 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
05 Mar 94  Finalizado FC Brasov FC Brasov
1 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
27 Feb 94  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
0 - 1
FCSB FCSB 0
21 Dic 93  Finalizado Extensiv Craiova Extensiv Craiova
2 - 1
ACF Gloria Bistrita ACF Gloria Bistrita 0
18 Dic 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
1 - 1
Dinamo Bucureşti Dinamo Bucureşti 0
11 Dic 93  Finalizado Brăila Brăila
2 - 4
ACF Gloria Bistrita ACF Gloria Bistrita 0
04 Dic 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
5 - 0
Sportul Studenţesc Sportul Studenţesc 0
01 Dic 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
2 - 0
Inter Sibiu Inter Sibiu 0
27 Nov 93  Finalizado UTA Arad UTA Arad
1 - 1
ACF Gloria Bistrita ACF Gloria Bistrita 0
24 Nov 93  Finalizado FCSB FCSB
2 - 1
ACF Gloria Bistrita ACF Gloria Bistrita 0
20 Nov 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
2 - 0
Ceahlaul Piatra Neamt Ceahlaul Piatra Neamt 0
10 Nov 93  Finalizado Universitatea Cluj Universitatea Cluj
3 - 2
ACF Gloria Bistrita ACF Gloria Bistrita 0
06 Nov 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
4 - 0
Politehnica Timisoara Politehnica Timisoara 0
30 Oct 93  Finalizado Universitatea Craiova Universitatea Craiova
2 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
23 Oct 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
1 - 2
FC Rapid Bucuresti FC Rapid Bucuresti 0
16 Oct 93  Finalizado Progresul Bucureşti Progresul Bucureşti
6 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
06 Oct 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
2 - 1
Petrolul Ploiesti Petrolul Ploiesti 0
03 Oct 93  Finalizado Oțelul Galați Oțelul Galați
1 - 1
ACF Gloria Bistrita ACF Gloria Bistrita 0
25 Sep 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
3 - 1
FC Farul Constanta FC Farul Constanta 0
18 Sep 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
2 - 1
FC Brasov FC Brasov 0
31 Ago 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
1 - 0
Extensiv Craiova Extensiv Craiova 0
27 Ago 93  Finalizado Dinamo Bucureşti Dinamo Bucureşti
2 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0
22 Ago 93  Finalizado ACF Gloria Bistrita ACF Gloria Bistrita
3 - 0
Brăila Brăila 0
15 Ago 93  Finalizado Sportul Studenţesc Sportul Studenţesc
2 - 0
ACF Gloria Bistrita ACF Gloria Bistrita 0

Plantilla del ACF Gloria Bistrita Temporada 1993/1994

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
55 ro - - - - -
Defensa
54 ro - - - - -
56 ro - - - - -
58 ro - - - - -
54 ro - - - - -
Centrocampista
58 ro - - - - -
52 ro - - - - -
56 ro 168 64 - - -
56 ro - - - - -
63 ro - - - - -
- ro - - - - -
56 ro - - - - -
54 ro 183 75 - - -
59 ro - - - - -
Delantero
58 ro - - - - -

Noticias de Europa League

Ver últimas noticias

La sociedad ilimitada de Bérgamo

El Atalanta buscará el pase a la final de la Europa League ante el Olympique de Marsella, con quien empató a uno en la ida en el Vélodrome. Para ello, Gianluca Scamacca y Teun Koppmeiners, ambos máximos goleadores del equipo, resultarán cruciales para su equipo, al igual que lo vienen haciendo a lo largo de toda la temporada.

Xabi Alonso desconfía pese al 0-2 de la ida: "Es una situación peligrosa"

A Xabi Alonso no le importa que, en la ida de las semifinales de la Europa League ante la Roma, el encuentro terminara con un 0-2 a su favor. Cree que este encuentro será otro totalmente diferente y no se fía para nada del conjunto de De Rossi.

Gil Manzano dirigirá el Atalanta-OM

Jesús Gil Manzano, del colegio extremeño de la Federación Española, ha sido designado como el árbitro del encuentro de vuelta entre el Atalanta y el Olympique de Marsella.

Mendilibar, maestro europeo: 17 partidos, un trofeo y solo una eliminación... en 2005

Desde el debut de José Luis Mendilibar como entrenador en la Europa League el año pasado de la mano del Sevilla, el clásico estratega del fútbol español se ha convertido en todo un experto en el plano continental. De sus 17 partidos extranacionales, tan solo 3 se han resuelto con derrotas. 2 de ellas fueron tan solo la antesala de remontadas o conatos de reacciones de sus rivales en una batería de eliminatorias que tan solo se ha decantado en su contra en una ocasión que data de 2005.

De Rossi se rinde a Xabi: "El Leverkusen va a 200 por hora"

Daniele de Rossi, entrenador de la Roma, atendió a la prensa después de su derrota contra el Bayer Leverkusen en la ida de semifinales de la Europa League. El estratega italiano reconoció la superioridad del equipo de Xabi Alonso, del que elogió que va "a 200 por hora". Preguntado por el error de Rick Karsdorp en uno de los goles alemanes, rehusó señalarle porque entiende que no es lo correcto. Jamás lo haría.




  USO DE MEMORIA  
5,372,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5631
Total Execution Time  0.5649
  CADENA URL  
/Gloria-Bistrita/1994
  GET DATOS  
$_GET['/Gloria-Bistrita/1994']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0105  SELECT type FROM routes WHERE alias = 'gloria-bistrita'
0.0118  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Gloria-Bistrita' AND l.year = 1994 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0107  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3676 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3676 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3676 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0220  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 10962
0.0117  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 10517
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3676 AND type_rel = 2
0.0113  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '3676' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0112  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '3676' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0113  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 10962 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 10517 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0256  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1994 as c ON c.league_id = l.id WHERE (c.datateam1 = 3676 or c.datateam2 = 3676) AND l.year = 1994 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0225  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1994 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 3676 or c.datateam2 = 3676) AND l.year = 1994 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0225  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1994 as c ON c.league_id = l.id INNER JOIN events1994 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 3676 or c.datateam2 = 3676) AND l.year = 1994)
0.0110  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=3676 AND l.year in (1993,1994,1995) ORDER BY l.id DESC, l.year DESC ;
0.0106  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (55995,10984,10962,10518) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 10518 AND teamId = 3676
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 10962 AND teamId = 3676
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 55995 AND teamId = 3676
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 10984 AND teamId = 3676
0.0107  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1994` 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 = 10962 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0106  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '3676' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3676' and rp.type = 4
0.0111  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '3676' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0114  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1994 e ON e.player_id = p.id AND e.league_id = 10962 WHERE rp.league_id = 10962 AND rp.teamId = 3676 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1994 e ON e.player_id = p.id AND e.league_id = 10962 WHERE rp.league_id = 10962 AND rp.teamId = 3676 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0124  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1994 e ON e.player_id = p.id AND e.league_id = 10962 WHERE rp.league_id = 10962 AND rp.teamId = 3676 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 3676 AND rp.league_id = 10962 AND l.year= 1994 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0108  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=170161 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0105  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=170161
0.0108  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1994 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=170161 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0107  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1994 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=170161 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0106  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1994 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=170161 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0107   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1994 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=170161 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0107  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1994 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=170161 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC