4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Spartak Plovdiv
Información

Partidos del Spartak Plovdiv

Ir al LIVESCORE
10 Feb 24  Finalizado Chernomorets 1919 Burgas
0 - 0
Spartak Plovdiv 0
07 Feb 24  Finalizado Beroe
1 - 1
Spartak Plovdiv 1
02 Feb 24  Finalizado Spartak Plovdiv
1 - 0
Etar 1
02 Jun 24  en 1 mes Spartak Plovdiv
17:00
Zagorets 0
25 May 24  en 28 días Rozova dolina
17:00
Spartak Plovdiv 0
19 May 24  en 22 días Spartak Plovdiv
17:00
Karnobat 0
15 May 24  en 18 días Atletik Kuklen
17:00
Spartak Plovdiv 1
12 May 24  en 15 días Spartak Plovdiv
17:00
Botev Plovdiv II 0
02 May 24  en 5 días Rodopa Smolyan
17:00
Spartak Plovdiv 1
28 Abr 24  en 1 día Spartak Plovdiv
17:00
Sokol Markovo 0
20 Abr 24  Finalizado Nesebar
3 - 2
Spartak Plovdiv 0
17 Abr 24  Finalizado Spartak Plovdiv
2 - 1
Sayana Haskovo 0
13 Abr 24  Finalizado Beroe Stara Zagora II
0 - 1
Spartak Plovdiv 0
07 Abr 24  Finalizado Spartak Plovdiv
4 - 1
Sozopol 0
03 Abr 24  Finalizado Yambol 1915
0 - 2
Spartak Plovdiv 0
30 Mar 24  Finalizado Levski Karlovo
1 - 2
Spartak Plovdiv 0
24 Mar 24  Finalizado Spartak Plovdiv
5 - 0
Asenovets 0
16 Mar 24  Finalizado Gigant Saedinenie
1 - 1
Spartak Plovdiv 0
10 Mar 24  Finalizado Spartak Plovdiv
3 - 0
FK Sekirovo 0
02 Mar 24  Finalizado FK Sliven
0 - 2
Spartak Plovdiv 0
25 Feb 24  Finalizado Spartak Plovdiv
5 - 0
Dimitrovgrad 0
18 Feb 24  Finalizado Lokomotiv Plovdiv II
2 - 3
Spartak Plovdiv 0

Plantilla del Spartak Plovdiv Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Defensa
28 bg 183 - - - -
Centrocampista
21 bg 175 65 - - -
Delantero
29 bg 170 - - - -

Noticias de Tercera Bulgaria V AFG

Ver últimas noticias

El CSKA Sofia incorpora al portero Georgi Kitanov

La directiva del CSKA Sofía ha recibido el consetimiento del Cherno More para llevarse a uno de sus futbolistas después de varias reuniones.

Un charco en el área provoca una surrealista pelea en Bulgaria

El Levski de Chepinets se enfrentaba al Lokomotiv de Sofía en un campo inundado por la lluvia donde jugar al fútbol era prácticamente imposible. Tras un penalti, llegó la bronca entre los jugadores de ambos equipos.

Stoichkov será homenajeado con una estatua en el estadio del CSKA de Sofía

El ex barcelonista Hristo Stoichkov será homenajeado el próximo 20 de mayo con la colocación de una estatua de bronce en el estadio del CSKA de Sofía, una escultura en cuyo diseño ha participado el jugador búlgaro y que fue presentada hoy.

Declaran en quiebra el mítico CSKA de Sofía en el que jugó Stoichkov

El Tribunal de Sofía informó hoy de que ha declarado en quiebra al club de fútbol CSKA de Sofía y ha bloqueado sus propiedades y bienes inmobiliarios.




  USO DE MEMORIA  
5,389,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2348
Total Execution Time  0.2369
  CADENA URL  
/spartak-plovdiv
  GET DATOS  
$_GET['/spartak-plovdiv']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0105  SELECT type FROM routes WHERE alias = 'spartak-plovdiv'
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 = 'spartak-plovdiv' 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.0105  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=17436 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=17436 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=17436 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=17436 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=17436 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=17436 AND type_rel = 2
0.0111  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 = '17436' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '17436' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  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 = '17436' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0106  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 events2024 e ON e.player_id = p.id AND e.league_id = 72997 WHERE rp.league_id = 72997 AND rp.teamId = 17436 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.0107  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 events2024 e ON e.player_id = p.id AND e.league_id = 72997 WHERE rp.league_id = 72997 AND rp.teamId = 17436 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0106  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 events2024 e ON e.player_id = p.id AND e.league_id = 72997 WHERE rp.league_id = 72997 AND rp.teamId = 17436 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30