4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Juárez

FC Juárez

Entrenador: Maurício Barbieri

Temporada 2019/2020

¿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 FC Juárez

Enviar Datos
Información
  • Nombre del equipo FC Juárez
  • Nombre completo Fútbol Club Juárez
  • Nombre corto JUA
  • País México
  • Ciudad Ciudad Juárez
  • Entrenador Maurício Barbieri
  • URL del equipo en RF //m.resultados-futbol.com/Fc-Juarez
Otros Datos
  • Año de Fundación 2015
Internet

Información sobre el estadio

  • Nombre del estadio Estadio Olímpico Benito Juárez
  • Capacidad 22300
  • Dirección Ciudad Juárez, Chihuahua
Estadio Olímpico Benito Juárez

Partidos del FC Juárez

Ir al LIVESCORE
Liga MX - Clausura Liga MX - Clausura »
11 May 20  Aplazado FC Juárez
-
 Cruz Azul 0
03 May 20  Aplazado Querétaro
-
 FC Juárez 0
27 Abr 20  Aplazado FC Juárez
-
 Puebla 0
17 Abr 20  Aplazado Tijuana
-
 FC Juárez 0
13 Abr 20  Aplazado FC Juárez
-
 Pachuca 0
05 Abr 20  Aplazado Toluca
-
 FC Juárez 0
23 Mar 20  Aplazado FC Juárez
-
 Atlas Guadalajara 1
15 Mar 20  Finalizado Tigres UANL
3 - 2
 FC Juárez 175
09 Mar 20  Finalizado FC Juárez
1 - 4
 León 46
29 Feb 20  Finalizado Atl. San Luis
0 - 3
 FC JuárezTarjeta Roja 70
24 Feb 20  Finalizado FC Juárez
1 - 2
 Santos LagunaTarjeta Roja 57
16 Feb 20  Finalizado Monterrey
1 - 1
 FC Juárez 78
10 Feb 20  Finalizado FC Juárez
2 - 1
 Necaxa 77
02 Feb 20  Finalizado Tarjeta RojaAmérica
1 - 3
 FC Juárez 36
27 Ene 20  Finalizado FC Juárez
3 - 0
 CA Morelia 38
17 Ene 20  Finalizado FC Juárez
4 - 4
 Pumas UNAM 91
12 Ene 20  Finalizado Chivas Guadalajara
2 - 0
 FC Juárez 53
Liga MX - Apertura Liga MX - Apertura »
25 Nov 19  Finalizado FC Juárez
1 - 2
 Tigres UANL 89
10 Nov 19  Finalizado Pumas UNAM
1 - 1
 FC Juárez 29
04 Nov 19  Finalizado FC Juárez
3 - 0
 Tijuana 95
01 Nov 19  Finalizado CA Morelia
6 - 1
 FC Juárez 45
28 Oct 19  Finalizado Tarjeta RojaFC Juárez
1 - 2
 Chivas Guadalajara 101
20 Oct 19  Finalizado Pachuca
0 - 1
 FC Juárez 63
07 Oct 19  Finalizado FC Juárez
1 - 2
 Atl. San Luis 65
29 Sep 19  Finalizado Necaxa
0 - 0
 FC Juárez 54
26 Sep 19  Finalizado FC Juárez
1 - 1
 América 72
23 Sep 19  Finalizado FC Juárez
2 - 0
 Veracruz 20
15 Sep 19  Finalizado León
3 - 1
 FC JuárezTarjeta Roja 79
02 Sep 19  Finalizado FC Juárez
1 - 0
 Monterrey 58
30 Ago 19  Finalizado Puebla
2 - 1
 FC Juárez 59
19 Ago 19  Finalizado Tarjeta RojaFC Juárez
0 - 2
 Querétaro 59
11 Ago 19  Finalizado Cruz Azul
2 - 0
 FC Juárez 30
05 Ago 19  Finalizado FC Juárez
2 - 0
 Toluca 45
29 Jul 19  Finalizado Santos Laguna
3 - 0
 FC Juárez 61
20 Jul 19  Finalizado Atlas Guadalajara
1 - 0
 FC Juárez 106
Partidos Amistosos Partidos Amistosos »
20 Dic 19  Finalizado FC Juárez
7 - 0
 Puebla Sub 20 0
11 Jul 19  Finalizado Detroit City
1 - 3
 FC Juárez 1
Copa MX Copa MX »
12 Mar 20  Finalizado Monterrey
2 - 0
 FC Juárez 97
05 Mar 20  Finalizado Tarjeta RojaFC Juárez
2 - 0
 Monterrey 92
20 Feb 20  Finalizado FC Juárez
3 - 0
 Dorados 14
13 Feb 20  Finalizado Dorados
0 - 0
 FC Juárez 72
30 Ene 20  Finalizado FC Juárez
3 - 1
 QuerétaroTarjeta Roja 30
22 Ene 20  Finalizado Querétaro
3 - 2
 FC Juárez 4
03 Oct 19  Finalizado FC Juárez
1 - 0
 Atlante FC 38
05 Sep 19  Finalizado Tarjeta RojaVenados FC
1 - 2
 FC Juárez 20
14 Ago 19  Finalizado Atlante FC
0 - 2
 FC Juárez 38
07 Ago 19  Finalizado FC Juárez
1 - 1
 Venados FC 44

Plantilla del FC Juárez Temporada 2019/2020

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
31 41 mx 182 80 - - 2
1 37 mx 190 82 - - -
22 22 mx 177 78 - - -
Defensa
26 36 mx 169 72 - - -
19 34 cl 185 86 2 - -
33 25 mx 185 77 - - -
4 35 mx 188 85 - - 1
21 23 mx 178 72 - - -
24 25 mx 179 64 - - 1
3 30 mx 188 81 - - 1
7 32 uy 182 80 1 - 1
25 33 py 180 78 1 - 3
Centrocampista
10 38 mx 172 66 - - -
16 26 mx 180 76 - - 1
15 27 ec 172 69 - - 4
22 30 uy 184 72 1 - 1
20 36 mx 180 79 - - -
14 35 py 178 76 - - -
Delantero
23 27 mx 186 80 1 - 1
8 33 py 178 77 6 - 3
17 37 mx 175 72 3 1 3
29 26 mx 178 73 - - -
11 35 ar 169 74 - - 1
- ar - - - - -

Noticias del FC Juárez

Ver últimas noticias

Juárez se asegura los tres puntos ante un Dorados insuficiente

Miguel Moreno - Jueves, 16 Febrero 2017
0 319

Juárez ha sumado su segunda victoria en tres partidos de Copa México al imponerse a Dorados por 2-1 en el Olímpico Benito Juárez.

Así vivimos el directo de la Copa México

Ángel Mateo - Jueves, 19 Enero 2017
0 2.877

Vive con nosotros el directo de los encuentros: Querétaro-Cruz Azul, Atlante-Venados, América-Santos Laguna, León-Morelia y Dorados-FC Juárez.

Briseño se une a Veracruz

BeSoccer - Jueves, 08 Diciembre 2016
0 468

El zaguero ha decido cambiar de aires ante la falta de minutos en Juárez. Los 'tiburones rojos' de Veracruz hicieron oficial el fichaje de este jugador para la próxima temporada.

Necaxa regresa a la Liga MX

BeSoccer - Domingo, 22 Mayo 2016
0 1.215

Tras su victoria en el partido de ida ante Juárez, Necaxa consigue rematar la faena y volver a la Primera División del campeonato mexicano.

La final del Ascenso al Clausura Mexicano ya tiene fecha

BeSoccer - Martes, 10 Mayo 2016
0 796

Necaxa y FC Juárez disputarán la final para ascender al Clausura 2016. Será una eliminatoria en la que el ganador subirá a la primera categoría mexicana.

Ver más noticias del equipo»



  USO DE MEMORIA  
6,000,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.1802
Total Execution Time  0.1827
  CADENA URL  
/Fc-Juarez/2020
  GET DATOS  
$_GET['/Fc-Juarez/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0034  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 = 'Fc-Juarez' 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.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=64675 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=64675 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=64675 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=64675 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=64675 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=64675 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 51325
0.0024  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 = 49953
0.0027  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 = 50020
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64675 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 64675 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (68620,72621,144696,164013,178794) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '64675' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '64675' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 51697 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 51325 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 49953 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 calendars2020 as c ON c.league_id = l.id WHERE (c.datateam1 = 64675 or c.datateam2 = 64675) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0035  (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 = 64675 or c.datateam2 = 64675) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0028  (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 = 64675 or c.datateam2 = 64675) AND l.year = 2020)
0.0035  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=64675 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (60360,56984,56547,51697,49048,48497,47885,45344) 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 = 60360 AND teamId = 64675
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 56984 AND teamId = 64675
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 47885 AND teamId = 64675
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 48497 AND teamId = 64675
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 51697 AND teamId = 64675
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 45344 AND teamId = 64675
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 49048 AND teamId = 64675
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 64675
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 = 51325 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0033  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 = 51325 WHERE rp.league_id = 51325 AND rp.teamId = 64675 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.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 = 51325 WHERE rp.league_id = 51325 AND rp.teamId = 64675 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 51325 WHERE rp.league_id = 51325 AND rp.teamId = 64675 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 64675 AND rp.league_id = 51325 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0022  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=6306992 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=6306992
0.0024  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=6306992 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.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=6306992 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=6306992 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=6306992 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0026  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=6306992 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 51325 ORDER BY nameShow LIMIT 100