4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pskov 747

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Pskov 747

Enviar Datos
Información

Partidos del Pskov 747

Ir al LIVESCORE

Estadísticas

GOLEADORES
A. Shishaev1
V. Fedorov1

Noticias de Copa Rusa

Ver últimas noticias

Los penaltis le dan al CSKA la Copa una década después

BeSoccer - Domingo, 11 Junio 2023
0 1.397

El CSKA de Moscú se proclamó campeón de la Copa Rusa tras derrotar al Krasnodar en la tanda de penaltis. Tras el 1-1 del tiempo reglamentario, los de la capital se llevaron el título con un resultado de 6-5 tras una década de sequía.

Crisis en el fútbol ruso: el sistema Fan ID vacía los estadios

BeSoccer - Martes, 14 Marzo 2023
2 9.878

En el fútbol estadio se instaló el Fan ID, el sistema de identificación de aficionados al fútbol, y, desde entonces, ha provocado que las gradas estén más vacías. " Jugamos para los aficionados, pero no están", afirmó Alexandr Sóbolev, delantero del Spartak de Moscú.

¿Hasta cuándo? A Wendel y a Douglas Santos le lanzaron una banana desde la grada

BeSoccer - Sábado, 25 Febrero 2023
1 1.051

Durante el partido entre el Volga Ulyanovsk y el Zenit por la Copa Rusa, los futbolistas del equipo visitante Wendel y Douglas Santos fueron víctimas de un hecho racista. En el momento que el técnico decidió sustituirlos, la grada del cuadro local les lanzó una banana.

A falta de guerra en Rusia... ¡batalla campal en el Zenit-Spartak y 6 expulsados!

BeSoccer - Domingo, 27 Noviembre 2022
7 7.079

El partido entre el Zenit de San Petersburgo y el Spartak de Moscú quedó manchado absolutamente por una batalla campal pocas veces vista. La mayoría de los protagonistas acabaron pegándose y hasta seis futbolistas fueron expulsados.

Rusia se hace el sueco con el Mundial: su Copa seguirá jugándose

BeSoccer - Sábado, 12 Noviembre 2022
0 1.377

El fútbol ruso, marginado por la campaña militar rusa en Ucrania, no parará durante el Mundial de Catar. La Liga rusa se suspende durante casi cuatro meses a partir de este domingo, pero la Copa se jugará hasta finales de noviembre.

Ver más noticias del equipo»



  USO DE MEMORIA  
4,704,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0550
Total Execution Time  0.0570
  CADENA URL  
/Pskov-747
  GET DATOS  
$_GET['/Pskov-747']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0019  SELECT type FROM routes WHERE alias = 'pskov-747'
0.0041  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 = 73402
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13684 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=602 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 602 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027  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 (1261189,1237482,1232679,1206831,1201675) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '13684' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  (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 calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 13684 or c.datateam2 = 13684) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0022  (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 calendars2024 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 = 13684 or c.datateam2 = 13684) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0021  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 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 = 13684 or c.datateam2 = 13684) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0020  (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 calendars2024_base as c ON c.league_id = l.id WHERE (c.datateam1 = 13684 or c.datateam2 = 13684) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0021  (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 calendars2024_base 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 = 13684 or c.datateam2 = 13684) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0020  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024_base as c ON c.league_id = l.id INNER JOIN events2024_base as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players_base 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 = 13684 or c.datateam2 = 13684) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)