4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información
  • Nombre del equipo Lokomotiv Plovdiv
  • Nombre completo PFC Lokomotiv Plovdiv
  • Nombre corto LPL
  • País Bulgaria
  • Ciudad Plovdiv
  • Entrenador Aleksandar Tomash
  • URL del equipo en RF //m.resultados-futbol.com/Lokomotiv-Plovdiv
Otros Datos
  • Año de Fundación 1926
  • Presupuesto 6100000
Internet

Información sobre el estadio

  • Nombre del estadio Stadion Lokomotiv
  • Capacidad 13800
  • Dirección Park Lauta
  • Año de construcción 1980
  • Tamaño 105x68
Stadion Lokomotiv

Partidos del Lokomotiv Plovdiv

Ir al LIVESCORE
09 Feb 24  Finalizado Lokomotiv Plovdiv
1 - 0
Etar 1
06 Feb 24  Finalizado Maritsa Plovdiv
2 - 0
Lokomotiv Plovdiv 1
03 Feb 24  Finalizado Beroe
3 - 2
Lokomotiv Plovdiv 2
27 Ene 24  Finalizado Lokomotiv Plovdiv
1 - 0
Pirin Blagoevgrad 0
20 Ene 24  Finalizado Lokomotiv Plovdiv
2 - 1
CSKA 1948 Sofia 0
21 Abr 24  en 1 día Lokomotiv Plovdiv
14:15
CSKA 1948 Sofia 0
14 Abr 24  Finalizado Beroe
2 - 2
Lokomotiv Plovdiv 1
08 Abr 24  Finalizado Lokomotiv Plovdiv
1 - 0
Cherno More Varna 53
03 Abr 24  Finalizado CSKA Sofia
1 - 2
Lokomotiv Plovdiv 88
30 Mar 24  Finalizado Lokomotiv Plovdiv
1 - 2
Ludogorets 7
16 Mar 24  Finalizado Slavia Sofia
1 - 2
Lokomotiv Plovdiv 12
08 Mar 24  Finalizado Lokomotiv Plovdiv
3 - 0
Etar 41
02 Mar 24  Finalizado Levski Krumovgrad
3 - 1
Lokomotiv PlovdivTarjeta Roja 1
24 Feb 24  Finalizado Tarjeta RojaLokomotiv Plovdiv
1 - 2
Hebar Pazardzhik 31
18 Feb 24  Finalizado Arda Kardzhali
1 - 2
Lokomotiv Plovdiv 0

Plantilla del Lokomotiv Plovdiv Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
23 25 hr 189 77 - - 2
81 21 bg 189 80 - - -
88 30 bg 188 83 - - -
Defensa
44 26 bg 180 70 2 3 10
12 21 bg - - 1 - 4
18 17 bg - - - - -
91 27 co 195 86 2 1 10
3 19 bg 195 - 1 - -
4 22 bg 186 77 - - 5
20 33 rs 180 75 - - -
71 21 fr 180 72 1 - 6
5 19 bg - - - - -
19 24 by 180 71 - 1 5
Centrocampista
6 23 bg 187 68 1 - 2
22 21 bg 176 - - - 3
17 31 bg 183 77 - - 4
Delantero
15 17 bg 182 - - - -
7 27 sn 167 70 5 - 1
14 35 bg 185 82 4 - 4
21 28 br 176 61 6 1 9
20 bg - - - - -
16 26 bg 178 - 1 - 3
15 21 bg 177 73 - - 1
9 22 be 188 77 4 - -
11 19 bg - - 3 - 5
10 27 fr 181 65 - - -

Noticias del Lokomotiv Plovdiv

Ver últimas noticias

El Lokomotiv Plovdiv acaricia la final de la Copa Búlgara

El actual campeón de la competición dio un paso de gigante tras el 2-0 que endosó al Levski Sofía.

Bulgaria sancionará a los clubes que entrenaron pese a la prohibición

En Bulgaria no existe el confinamiento total, pero está prohibido mantener reuniones al aire libre, por lo que los equipos no pueden entrenar en sus instalaciones. Una prohibición que ni el CSKA de Sofía ni el Lokomotiv Plovdiv habrían respetado.

'Lauta Army', un grupo extremadamente violento y racista

La banda denominada 'Lauta Army' fue la que protagonizó los insultos racistas hacia los jugadores de la Selección Inglesa. Pero, además, es conocida por quedar antes de partidos solo para pegarse palizas entre ellos.

Musa Muhammed llegará a Bulgaria de la mano del Lokomotiv Plovdiv

El Istanbul ha confirmado este viernes a través de las redes sociales la marcha del nigeriano, que pasará a jugar en calidad de cedido en Bulgaria.

Paulo Teles firma con el Lokomotiv Plovdiv

El centrocampista, que se quedó sin equipo tras militar en el filial del Deportivo, disputará la Liga Búlgara con el Lokomotiv Plovdiv.




  USO DE MEMORIA  
5,602,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1340
Total Execution Time  0.1360
  CADENA URL  
/Lokomotiv-Plovdiv
  GET DATOS  
$_GET['/Lokomotiv-Plovdiv']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0019  SELECT type FROM routes WHERE alias = 'lokomotiv-plovdiv'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6475 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6475 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0031  SELECT /*35 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 (45822,290620,727599,819545,844883) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '6475' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0038  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=6475 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73790,72087,71432) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72087 AND teamId = 6475
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 6475
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6475
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72087 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '6475' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6475' and rp.type = 4
0.0020  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 = '6475' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0047  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 = 72087 WHERE rp.league_id = 72087 AND rp.teamId = 6475 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.0053  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 = 72087 WHERE rp.league_id = 72087 AND rp.teamId = 6475 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 72087 WHERE rp.league_id = 72087 AND rp.teamId = 6475 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 6475 AND rp.league_id = 72087 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0023  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=6583208 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0020  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6583208
0.0034  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583208 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.0028  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583208 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0023  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583208 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0023   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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583208 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0031  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6583208 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC