Escudo del Teleneşti
Información

Histórico de participación

Partidos del Teleneşti

Ir al LIVESCORE
28 May 22  Aplazado Codru Călărași II
-
Teleneşti 0
21 May 22  Aplazado Teleneşti
-
Inter Soroca 0
14 May 22  Aplazado FC Edinet
-
Teleneşti 0
07 May 22  Aplazado Teleneşti
-
EFA Visoca 0
30 Abr 22  Aplazado Pepeni
-
Teleneşti 0
23 Abr 22  Aplazado Teleneşti
-
FC Olimpia 0
16 Abr 22  Aplazado Teleneşti
-
Flacăra Făleşti 0
09 Abr 22  Aplazado FC Visoca
-
Teleneşti 0
02 Abr 22  Aplazado Teleneşti
-
Ocniţa 0
26 Mar 22  Aplazado Grănicerul
-
Teleneşti 0
27 Nov 21  Aplazado Teleneşti
-
Cruiz 0
20 Nov 21  Aplazado CF Riscani
-
Teleneşti 0
13 Nov 21  Aplazado Teleneşti
-
Sîngerei 0
06 Nov 21  Aplazado Teleneşti
-
Codru Călărași II 0
30 Oct 21  Aplazado Inter Soroca
-
Teleneşti 0
23 Oct 21  Aplazado Teleneşti
-
FC Edinet 0
16 Oct 21  Aplazado EFA Visoca
-
Teleneşti 0
09 Oct 21  Aplazado Teleneşti
-
Pepeni 0
02 Oct 21  Aplazado FC Olimpia
-
Teleneşti 0
25 Sep 21  Aplazado Flacăra Făleşti
-
Teleneşti 0
18 Sep 21  Aplazado Teleneşti
-
FC Visoca 0
11 Sep 21  Aplazado Ocniţa
-
Teleneşti 0
04 Sep 21  Aplazado Teleneşti
-
Grănicerul 0
28 Ago 21  Aplazado Cruiz
-
Teleneşti 0
21 Ago 21  Aplazado Teleneşti
-
CF Riscani 0
14 Ago 21  Aplazado Sîngerei
-
Teleneşti 0

Últimas noticias

Ver últimas noticias

Toluca deja a Atlético San Luis pidiendo clemencia

Toluca no tuvo piedad de Atlético San Luis. Un 1-5 le endosó a su rival en su casa. Alexis Vega hizo el primero en un encuentro que llegó a empatar Unai Bilbao. Sin embargo, Jesús Angulo, Meneses por partida doble y Brian García terminaron dándole un disgusto al Atlético San Luis, que ya está eliminado.

Dani Olmo, prioridad para el Barça: el RB Leipzig pide 60 millones

El Barça se ha puesto como prioridad para la 2024-25 el fichaje de Dani Olmo. Según 'Mundo Deportivo', los agentes del jugador y el padre se reunieron con Deco para hablar de su futuro 'culé' y ambas partes terminaron con buenas sensaciones. El RB Leipzig pide 60 millones de euros por él y la entidad catalana es consciente de que no habrá rebaja que valga.

Portadas de la prensa deportiva del 20-04-24

Se acerca el 'Clásico' y la prensa española calienta motores para el encuentro que puede ser decisivo en la pelea por LaLiga. Los medios ponen el foco también en la ida de las semifinales que el Barça femenino tendrá ante el Chelsea con el objetivo de alcanzar su quinta final.

El Niza se lo cree

El Niza volvió a la senda de la victoria tras dos jornadas sin hacerlo y consiguió el triunfo por un cómodo 3-0 ante el Lorient. Morgan Sanson, Jérémie Boga y Guessand fueron los goleadores para el conjunto dirigido por Francesco Farioli.

Atascado y sin gol

El Leganés sigue frenado en seco y sumó el cuarto empate a cero consecutivo, esta vez frente al Tenerife. Ninguno de los dos conjuntos hizo méritos suficientes para perforar la portería de su rival y todo quedó en tablas.




  USO DE MEMORIA  
5,010,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3267
Total Execution Time  0.3285
  CADENA URL  
/telenesti
  GET DATOS  
$_GET['/telenesti']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0111  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 = 'telenesti' AND l.year = 2024 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.0126  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 = 'telenesti' 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.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=61692 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=61692 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=61692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  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=61692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=61692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109  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=61692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=61692 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=61692 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=61692 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=61692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61692 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1639 AND type_rel = 3
0.0108  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 = '61692' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = '61692' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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=61692 AND l.year in (2021,2022,2023) 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 (64140,63870) 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.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 64140 AND teamId = 61692
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 63870 AND teamId = 61692
0.0107  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 = 61692 AND rp.league_id = 64140 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0106  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 = 61692 AND rp.league_id = 64140 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1