4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Creteil
Información
Otros Datos
  • Año de Fundación 1936
Internet

Información sobre el estadio

  • Nombre del estadio Stade Dominique Duvauchelle
  • Capacidad 12050
  • Dirección Rue Dominique Duvauchelle
  • Teléfono +376 332941
  • Fax +376 860070
  • Año de construcción 2001
Stade Dominique Duvauchelle

Partidos del Creteil

Ir al LIVESCORE
07 Dic 19  Finalizado Gonfreville Gonfreville
5 - 2
Creteil CreteilTarjeta RojaTarjeta Roja 0
16 Nov 19  Finalizado Sarre-Union Sarre-Union
0 - 2
Creteil Creteil 0
03 Ago 19  Finalizado Sannois Gratien Sannois Gratien
0 - 1
Creteil Creteil 0
19 Jul 19  Finalizado Chateauroux Chateauroux
0 - 1
Creteil Creteil 0
09 Jul 19  Finalizado Auxerre Auxerre
2 - 1
Creteil Creteil 1
15 May 20  Aplazado Bastia-Borgo Bastia-Borgo
-
Creteil Creteil 0
08 May 20  Aplazado Creteil Creteil
-
Avranches Avranches 0
30 Abr 20  Aplazado Concarneau Concarneau
-
Creteil Creteil 0
17 Abr 20  Aplazado Gazélec Ajaccio Gazélec Ajaccio
-
Creteil Creteil 0
10 Abr 20  Aplazado Creteil Creteil
-
Stade Lavallois Stade Lavallois 0
03 Abr 20  Aplazado Villefranche Villefranche
-
Creteil Creteil 0
27 Mar 20  Aplazado Creteil Creteil
-
Pau FC Pau FC 0
20 Mar 20  Aplazado Dunkerque Dunkerque
-
Creteil Creteil 0
13 Mar 20  Aplazado Creteil Creteil
-
Bourg-Péronnas Bourg-Péronnas 0
06 Mar 20  Finalizado Sporting Toulon Var Sporting Toulon Var
1 - 2
Creteil Creteil 0
28 Feb 20  Finalizado Creteil Creteil
0 - 0
Red Star Red Star 0
21 Feb 20  Finalizado Béziers Béziers
1 - 2
Creteil Creteil 0
14 Feb 20  Finalizado Creteil Creteil
1 - 3
QRM QRM 1
07 Feb 20  Finalizado Lyon-Duchère Lyon-Duchère
3 - 2
Creteil Creteil 0
31 Ene 20  Finalizado Creteil Creteil
3 - 0
Cholet Cholet 0
24 Ene 20  Finalizado US Boulogne US Boulogne
1 - 0
Creteil Creteil 1
10 Ene 20  Finalizado Creteil Creteil
0 - 2
Le Puy Le Puy 0
20 Dic 19  Finalizado Avranches Avranches
2 - 1
Creteil Creteil 1
13 Dic 19  Finalizado Creteil Creteil
4 - 2
Concarneau ConcarneauTarjeta Roja 0
29 Nov 19  Finalizado Creteil Creteil
2 - 0
Gazélec Ajaccio Gazélec Ajaccio 0
22 Nov 19  Finalizado Stade Lavallois Stade Lavallois
0 - 0
Creteil Creteil 0
08 Nov 19  Finalizado Creteil Creteil
2 - 2
Villefranche Villefranche 0
01 Nov 19  Finalizado Pau FC Pau FC
3 - 3
Creteil CreteilTarjeta Roja 10
18 Oct 19  Finalizado Creteil Creteil
0 - 1
Dunkerque Dunkerque 0
04 Oct 19  Finalizado Bourg-Péronnas Tarjeta RojaBourg-Péronnas
0 - 0
Creteil Creteil 2
27 Sep 19  Finalizado Creteil Creteil
1 - 1
Sporting Toulon Var Sporting Toulon Var 0
20 Sep 19  Finalizado Red Star Red Star
0 - 0
Creteil CreteilTarjeta Roja 1
13 Sep 19  Finalizado Creteil Creteil
3 - 1
Béziers Béziers 0
06 Sep 19  Finalizado QRM QRM
0 - 3
Creteil Creteil 0
30 Ago 19  Finalizado Creteil Creteil
0 - 1
Lyon-Duchère Lyon-Duchère 0
23 Ago 19  Finalizado Cholet Cholet
1 - 0
Creteil Creteil 0
16 Ago 19  Finalizado Creteil Creteil
1 - 0
US Boulogne US Boulogne 0
09 Ago 19  Finalizado Le Puy Le Puy
2 - 3
Creteil Creteil 0
02 Ago 19  Finalizado Creteil Creteil
0 - 0
Bastia-Borgo Bastia-Borgo 0

Plantilla del Creteil Temporada 2019/2020

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
26 fr 186 - - - -
16 25 fr 182 72 - - -
1 38 fr 186 73 - - 1
29 fr 180 73 - - -
Defensa
34 fr 187 - - - -
12 34 pt 170 70 - - -
20 28 fr 183 - 1 - 1
25 29 fr 193 - 1 - -
4 29 fr 187 85 - - 1
32 fr 183 75 - - -
22 32 fr 180 69 - 1 6
5 31 fr 188 - 2 - 6
Centrocampista
17 28 fr 182 - - - 2
8 37 dz 175 70 9 - -
6 31 fr 174 72 - - 3
31 pt 186 82 - - -
27 33 pt 192 84 3 1 7
26 32 fr - - - - 1
29 25 ml 173 64 - - 2
10 32 fr 172 60 1 - 5
23 32 gf 177 72 1 - 3
15 31 fr 175 78 - - 2
7 35 fr 174 68 - - -
21 31 pt 177 70 - - 4
33 38 fr - - - - -
Delantero
24 30 fr 186 76 1 - -
28 26 mf 174 68 - - -
14 37 fr 183 81 3 - 4
11 29 gn 177 72 8 - 3
19 26 fr 173 - 1 - 2
34 26 bj 168 - - - -
18 25 fr 166 64 - - -
9 31 fr 180 77 1 - 1

Noticias de National

Ver últimas noticias

Otro episodio racista en Francia: imitaron gritos de mono contra 3 jugadores del Red Star

El AS Nancy denunció este jueves que varios aficionados profirieron insultos racistas -imitando gritos de mono- contra 3 futbolistas negros del Red Star, equipo al que se enfrentó el pasado fin de semana.

De Provedel a Beuve: otro portero que marca sobre la bocina

Anthony Beuve quiso imitar a Ivan Provedel en el empate entre Avranches y GOAL FC (1-1) en el Championnat National, la Tercera División Francesa. El guardameta de los locales igualó la contienda en la última jugada con un cabezazo similar al del arquero de la Lazio ante el Atlético de Madrid.

El laberinto de un descenso en cadena para 10 clubes históricos

BeSoccer Pro se centra en analizar el declive reciente de 10 clubes que hace no mucho disfrutaban del lujo de las grandes ligas y que ahora han visto cómo su realidad ha cambiado hasta tener que salir del pozo de una tercera categoría. En España, dos casos claros: Deportivo de La Coruña y Málaga.

El Monza anuncia el fichaje de Warren Bondo

El Monza hizo oficial su decimoséptimo fichaje del mercado de verano. Warrem Bondo llega procedente del Nancy con el pase en su poder. El joven centrocampista de 18 años firma hasta 2025.

OFICIAL: se confirma el descenso del Girondins a Tercera

El Comité de Apelación de la Federación Francesa de Fútbol desestimó el recurso presentado por el Girondins de Burdeos, por lo que el conjunto bordelés desciende oficialmente a Tercera División. Además, el riesgo de quiebra es severo y el club podría desaparecer.




  USO DE MEMORIA  
5,891,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1754
Total Execution Time  0.1774
  CADENA URL  
/Creteil-Lusitanos/2020
  GET DATOS  
$_GET['/Creteil-Lusitanos/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0035  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 = 'Creteil-Lusitanos' AND l.year = 2020 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.0019  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=2838 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=2838 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2838 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2838 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 50111
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2838 AND type_rel = 2
0.0055  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '2838' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0055  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 = '2838' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50111 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  (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 = 2838 or c.datateam2 = 2838) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0034  (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 = 2838 or c.datateam2 = 2838) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0024  (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 = 2838 or c.datateam2 = 2838) AND l.year = 2020)
0.0037  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=2838 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (60328,57035,56547,44575) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 57035 AND teamId = 2838
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 44575 AND teamId = 2838
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 60328 AND teamId = 2838
0.0170  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 2838
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2020` 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 = 50111 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0041  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 = 50111 WHERE rp.league_id = 50111 AND rp.teamId = 2838 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.0035  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 = 50111 WHERE rp.league_id = 50111 AND rp.teamId = 2838 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 50111 WHERE rp.league_id = 50111 AND rp.teamId = 2838 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 2838 AND rp.league_id = 50111 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0029  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=6283823 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6283823
0.0032  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=6283823 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.0030  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=6283823 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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6283823 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0022   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=6283823 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0036  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=6283823 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC