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 Chemnitzer
  • Nombre completo Chemnitzer
  • Nombre corto CHE
  • País Alemania
  • Ciudad Chemnitz
  • Entrenador Christian Tiffert
  • URL del equipo en RF //m.resultados-futbol.com/Chemnitzer
Internet

Partidos del Chemnitzer

Ir al LIVESCORE
11 Ago 19  Finalizado Chemnitzer
2 - 2
Hamburger SV 16
11 Feb 20  Finalizado Auerbach
2 - 2
Chemnitzer 2
18 Ene 20  Finalizado Energie Cottbus
2 - 1
Chemnitzer 0
14 Nov 19  Finalizado Dynamo Dresden
0 - 2
Chemnitzer 2
05 Sep 19  Finalizado Union Berlin
3 - 1
Chemnitzer 2
09 Jul 19  Finalizado Chemnitzer
0 - 1
Larne 0
06 Jul 19  Finalizado Chemnitzer
2 - 2
Arka Gdynia 0
04 Jul 20  Finalizado Chemnitzer
4 - 2
Hansa Rostock 1
01 Jul 20  Finalizado Zwickau
2 - 1
Chemnitzer 1
26 Jun 20  Finalizado KFC Uerdingen 05
1 - 1
Chemnitzer 3
23 Jun 20  Finalizado Chemnitzer
1 - 2
Eintracht Braunschweig 2
19 Jun 20  Finalizado Würzburger Kickers
3 - 0
ChemnitzerTarjeta Roja 1
16 Jun 20  Finalizado Chemnitzer
1 - 0
Preußen Münster 2
13 Jun 20  Finalizado Kaiserslautern
2 - 0
Chemnitzer 3
10 Jun 20  Finalizado Chemnitzer
0 - 1
Ingolstadt 04 0
06 Jun 20  Finalizado MSV Duisburg
2 - 1
Chemnitzer 0
03 Jun 20  Finalizado Chemnitzer
0 - 1
Sonnenhof Großaspach 0
31 May 20  Finalizado FC Carl Zeiss Jena
0 - 1
Chemnitzer 6
07 Mar 20  Finalizado Chemnitzer
1 - 0
Unterhaching 0
29 Feb 20  Finalizado 1860 München
4 - 3
Chemnitzer 0
24 Feb 20  Finalizado Chemnitzer
1 - 0
Bayern München IITarjeta Roja 50
15 Feb 20  Finalizado Magdeburg
1 - 1
Chemnitzer 0
09 Feb 20  Finalizado Chemnitzer
3 - 0
Hallescher FC 1
01 Feb 20  Finalizado SV Meppen
1 - 2
Chemnitzer 0
25 Ene 20  Finalizado Chemnitzer
2 - 2
Viktoria Köln 0
21 Dic 19  Finalizado Waldhof Mannheim
4 - 3
Chemnitzer 0
14 Dic 19  Finalizado Hansa Rostock
1 - 2
Chemnitzer 0
06 Dic 19  Finalizado Chemnitzer
2 - 2
ZwickauTarjeta Roja 4
30 Nov 19  Finalizado Chemnitzer
1 - 1
KFC Uerdingen 05Tarjeta Roja 0
23 Nov 19  Finalizado Eintracht Braunschweig
2 - 1
Chemnitzer 1
10 Nov 19  Finalizado Chemnitzer
0 - 0
Würzburger Kickers 0
02 Nov 19  Finalizado Preußen Münster
3 - 3
Chemnitzer 0
27 Oct 19  Finalizado Chemnitzer
3 - 1
Kaiserslautern 0
19 Oct 19  Finalizado Ingolstadt 04
1 - 1
Chemnitzer 2
06 Oct 19  Finalizado Chemnitzer
3 - 1
MSV Duisburg 0
28 Sep 19  Finalizado Sonnenhof Großaspach
2 - 0
ChemnitzerTarjeta Roja 0
21 Sep 19  Finalizado Chemnitzer
3 - 2
FC Carl Zeiss JenaTarjeta Roja 1
16 Sep 19  Finalizado Unterhaching
2 - 1
Chemnitzer 2
30 Ago 19  Finalizado Chemnitzer
0 - 1
1860 München 3
24 Ago 19  Finalizado Bayern München II
2 - 2
Chemnitzer 4
16 Ago 19  Finalizado Chemnitzer
0 - 0
Magdeburg 2
03 Ago 19  Finalizado Hallescher FC
3 - 1
Chemnitzer 0
31 Jul 19  Finalizado Chemnitzer
2 - 4
SV Meppen 1
28 Jul 19  Finalizado Viktoria Köln
3 - 2
Chemnitzer 0
21 Jul 19  Finalizado Chemnitzer
1 - 1
Waldhof Mannheim 0

Plantilla del Chemnitzer Temporada 2019/2020

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
40 21 de 194 82 - - -
1 35 cz 194 - - - 2
22 27 de 187 - - - -
22 de 190 72 - - -
Defensa
13 32 de 185 77 - - 1
14 24 de 186 - - - 2
5 35 bg 184 79 - - -
3 37 at 190 82 3 - 8
20 29 de 177 75 1 - 7
25 27 de 191 79 2 - 8
8 35 de 182 73 - - 4
23 31 nz 183 73 - - 2
Centrocampista
18 29 de 176 - 1 - 11
9 25 de 188 71 - - -
38 37 de 175 71 - - 1
30 gr 178 74 - - -
2 24 us 187 89 - 1 3
29 34 de 189 - 3 - 9
24 33 de 177 73 - - 1
31 29 de 178 73 - - 6
27 25 at 176 70 - - 1
16 30 de 181 75 5 - 7
38 30 de 180 75 1 1 6
Delantero
33 31 de 194 - 5 - 5
7 27 de 179 - 1 - 1
17 24 de 178 73 6 - 2
15 24 de 182 84 1 - -
19 27 de 172 62 - - 3
26 34 at 178 77 19 - 10
32 27 de 197 93 4 - 2

Noticias del Chemnitzer

Ver últimas noticias

El Chemnitzer despide a su capitán por apoyar a grupos neonazis

El Chemnitzer, de la tercera categoría alemana, ha ejecutado una cláusula 'anti-racista' para despedir a Daniel Frahn, delantero y capitán del equipo, por ser visto apoyando a grupos neonazis.

Posible coacción en el homenaje a un neonazi en Alemania

Un homenaje póstumo al ultra neonazi Thomas Haller en un partido de la Cuarta División alemana ha desatado una nueva polémica sobre la ultraderecha en el fútbol y el club directamente afectado, el Chemnitzer FC, se ha distanciado de la acción que inicialmente había defendido.

Lío en un club alemán por aceptar un minuto de silencio a un líder neonazi

La Regionalliga alemana vive unas horas de intensa polémica. El Chemnitz FC, equipo que milita en dicha categoría, aceptó la celebración de un minuto de silencio en honor a Thomas Haller, líder de una organización neonazi.

El Bayern se pasea ante un combativo Chemnitzer

Dos goles de Lewandowski dejan encarrilado el choque para una 'manita' de los bávaros ante el Chemnitzer en la DFB Pokal.

El Borussia también solventa con comodidad su primer partido de Copa

El equipo de Dortmund derrota al Chemnitzer por 0-2 gracias a los tantos de Aubameyang y Mkhitaryan.




  USO DE MEMORIA  
5,953,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.4597
Total Execution Time  0.4621
  CADENA URL  
/Chemnitzer/2020
  GET DATOS  
$_GET['/Chemnitzer/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0125  SELECT type FROM routes WHERE alias = 'chemnitzer'
0.0140  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2917 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2917 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129  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 (5626,274610,596901,596331,684877) ORDER BY n.cover_points DESC, update_date DESC
0.0136  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 = '2917' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  (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 calendars2020 as c ON c.league_id = l.id WHERE (c.datateam1 = 2917 or c.datateam2 = 2917) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0138  (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 calendars2020 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 = 2917 or c.datateam2 = 2917) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0131  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2020 as c ON c.league_id = l.id INNER JOIN events2020 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 = 2917 or c.datateam2 = 2917) AND l.year = 2020)
0.0140  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=2917 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (57335,57315,56547,49902) 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.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 49902 AND teamId = 2917
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 57335 AND teamId = 2917
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 57315 AND teamId = 2917
0.0223  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 2917
0.0154  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 events2020 e ON e.player_id = p.id AND e.league_id = 49902 WHERE rp.league_id = 49902 AND rp.teamId = 2917 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.0142  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 events2020 e ON e.player_id = p.id AND e.league_id = 49902 WHERE rp.league_id = 49902 AND rp.teamId = 2917 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 events2020 e ON e.player_id = p.id AND e.league_id = 49902 WHERE rp.league_id = 49902 AND rp.teamId = 2917 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 2917 AND rp.league_id = 49902 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0134  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=6280997 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0126  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6280997
0.0141  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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280997 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.0137  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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280997 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0133  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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280997 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0133   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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280997 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0136  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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280997 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC