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

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
01 May 22  Finalizado Querétaro
4 - 0
FC JuárezTarjeta RojaTarjeta Roja 45
23 Abr 22  Finalizado FC Juárez
0 - 2
Mazatlán 129
20 Abr 22  Finalizado Toluca
0 - 1
FC Juárez 241
16 Abr 22  Finalizado FC Juárez
1 - 2
Pachuca 175
10 Abr 22  Finalizado América
3 - 0
FC Juárez 110
03 Abr 22  Finalizado FC Juárez
0 - 1
Pumas UNAM 119
21 Mar 22  Finalizado Tarjeta RojaTijuana
1 - 0
FC Juárez 170
16 Mar 22  Finalizado Monterrey
3 - 0
FC JuárezTarjeta Roja 176
12 Mar 22  Finalizado FC Juárez
1 - 2
Atlas Guadalajara 131
05 Mar 22  Finalizado FC Juárez
0 - 1
León 159
02 Mar 22  Finalizado Puebla
1 - 1
FC Juárez 309
26 Feb 22  Finalizado FC Juárez
2 - 3
Tigres UANL 168
19 Feb 22  Finalizado FC Juárez
0 - 0
Santos Laguna 207
10 Feb 22  Finalizado FC Juárez
1 - 3
Chivas GuadalajaraTarjeta Roja 218
21 Ene 22  Finalizado Tarjeta RojaAtl. San Luis
0 - 1
FC Juárez 349
16 Ene 22  Finalizado Cruz Azul
1 - 0
FC Juárez 111
08 Ene 22  Finalizado FC Juárez
2 - 1
NecaxaTarjeta Roja 200
07 Nov 21  Finalizado Tigres UANL
3 - 0
FC Juárez 125
30 Oct 21  Finalizado FC Juárez
0 - 2
Puebla 182
25 Oct 21  Finalizado Pachuca
1 - 1
FC Juárez 175
17 Oct 21  Finalizado Pumas UNAM
1 - 0
FC Juárez 74
09 Oct 21  Finalizado FC Juárez
0 - 0
QuerétaroTarjeta Roja 193
02 Oct 21  Finalizado FC Juárez
3 - 1
Monterrey 293
29 Sep 21  Finalizado Mazatlán
3 - 1
FC Juárez 128
22 Sep 21  Finalizado Tarjeta RojaFC Juárez
1 - 0
Atl. San Luis 182
19 Sep 21  Finalizado León
0 - 1
FC Juárez 233
11 Sep 21  Finalizado FC Juárez
2 - 1
Cruz Azul 149
30 Ago 21  Finalizado Santos Laguna
2 - 0
FC JuárezTarjeta Roja 128
23 Ago 21  Finalizado Necaxa
1 - 0
FC Juárez 116
19 Ago 21  Finalizado Tarjeta RojaFC Juárez
1 - 2
América 216
14 Ago 21  Finalizado FC Juárez
1 - 1
TijuanaTarjeta Roja 111
08 Ago 21  Finalizado Chivas Guadalajara
2 - 2
FC Juárez 92
01 Ago 21  Finalizado Atlas Guadalajara
2 - 0
FC Juárez 84
24 Jul 21  Finalizado FC Juárez
1 - 3
Toluca 132
07 Jul 21  Finalizado Toluca
0 - 1
FC Juárez 0

Plantilla del FC Juárez Temporada 2021/2022

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
33 35 mx 183 85 - - -
1 33 mx 184 82 - - -
Defensa
26 36 mx 169 72 - - 2
3 34 es 182 77 1 - 1
2 26 mx 192 83 - - 2
21 23 mx 178 72 - - -
5 30 mx 175 78 - - 1
24 28 mx 184 75 - - 4
15 32 uy 182 80 - 1 6
4 33 ar 188 80 - - 1
22 38 mx 180 80 - - -
23 31 us 182 76 - - 3
Centrocampista
20 30 br 183 80 1 - 1
18 21 mx 176 70 - - -
12 30 mx 170 67 - - 1
6 27 us 185 78 4 1 3
14 24 mx 174 73 - - -
27 27 mx 183 83 - - -
16 26 mx 180 76 - - 5
13 24 mx 175 72 - - -
10 31 mx 179 71 - - -
Delantero
29 28 mx 165 68 - - 1
28 29 mx 172 77 - - -
8 33 py 178 77 - - -
9 31 uy 178 70 2 - -
11 31 co 171 80 - - -
17 37 mx 175 72 1 - 2
32 32 ar 174 71 - - 2
7 26 uy 176 68 - 1 1
19 29 uy 186 80 1 - 1

Noticias del FC Juárez

Ver últimas noticias

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

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

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

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

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

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.




  USO DE MEMORIA  
5,715,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.6988
Total Execution Time  0.7010
  CADENA URL  
/fc-juarez/2022
  GET DATOS  
$_GET['/fc-juarez/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0125  SELECT type FROM routes WHERE alias = 'fc-juarez'
0.0142  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 = 2022 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.0125  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.0127  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.0126  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.0125  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.0255  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 = 66176
0.0131  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 = 63173
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64675 AND type_rel = 2
0.0128  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.0128  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.0132  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' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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.0127  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 = 66176 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 63173 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  (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 calendars2022 as c ON c.league_id = l.id WHERE (c.datateam1 = 64675 or c.datateam2 = 64675) AND l.year = 2022 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0135  (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 calendars2022 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 = 2022 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0131  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2022 as c ON c.league_id = l.id INNER JOIN events2022 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 = 2022)
0.0131  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 (2021,2022,2023) 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 (73396,70544,69834,67724,67320) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 70544 AND teamId = 64675
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 67724 AND teamId = 64675
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 69834 AND teamId = 64675
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 73396 AND teamId = 64675
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 64675
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 = 66176 AND t.round = 17 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '64675' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64675' and rp.type = 4
0.0126  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 = '64675' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 events2022 e ON e.player_id = p.id AND e.league_id = 66176 WHERE rp.league_id = 66176 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.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 events2022 e ON e.player_id = p.id AND e.league_id = 66176 WHERE rp.league_id = 66176 AND rp.teamId = 64675 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2022 e ON e.player_id = p.id AND e.league_id = 66176 WHERE rp.league_id = 66176 AND rp.teamId = 64675 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 66176 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0131  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=6496352 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=6496352
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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6496352 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.0132  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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6496352 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0129  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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6496352 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0134   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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6496352 AND (e.action = 22) 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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6496352 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC