4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Shaanxi Union
Información

Histórico de participación

Partidos del Shaanxi Union

Ir al LIVESCORE
18 May 24  en 17 días Shaanxi Union Shaanxi Union
08:00
Guangzhou FC Guangzhou FC 0
20 Abr 24  Finalizado Changchun Xidu Changchun Xidu
0 - 5
Shaanxi Union Shaanxi Union 0
28 Jul 24  en 2 meses Dalian K'un City Dalian K'un City
10:00
Shaanxi Union Shaanxi Union 0
21 Jul 24  en 2 meses Shaanxi Union Shaanxi Union
10:00
Rizhao Yuqi Rizhao Yuqi 0
13 Jul 24  en 2 meses Shaanxi Union Shaanxi Union
11:00
Langfang Glory City Langfang Glory City 0
07 Jul 24  en 2 meses Taian Tiankuang Taian Tiankuang
10:00
Shaanxi Union Shaanxi Union 0
29 Jun 24  en 1 mes Shaanxi Union Shaanxi Union
11:00
Shandong Taishan B Shandong Taishan B 0
22 Jun 24  en 1 mes Haimen Codion Haimen Codion
13:30
Shaanxi Union Shaanxi Union 0
16 Jun 24  en 1 mes Beijing Technology Beijing Technology
11:00
Shaanxi Union Shaanxi Union 0
09 Jun 24  en 1 mes Shaanxi Union Shaanxi Union
11:00
Xi'an Ronghai Xi'an Ronghai 0
02 Jun 24  en 1 mes Shaanxi Union Shaanxi Union
11:00
Hubei Istar Hubei Istar 0
25 May 24  en 24 días Shaanxi Union Shaanxi Union
11:00
Dalian K'un City Dalian K'un City 0
11 May 24  en 10 días Rizhao Yuqi Rizhao Yuqi
13:30
Shaanxi Union Shaanxi Union 0
05 May 24  en 4 días Langfang Glory City Langfang Glory City
09:00
Shaanxi Union Shaanxi Union 0
27 Abr 24  Finalizado Shaanxi Union Shaanxi Union
4 - 0
Taian Tiankuang Taian Tiankuang 0
16 Abr 24  Finalizado Shandong Taishan B Shandong Taishan B
0 - 2
Shaanxi Union Shaanxi Union 3
11 Abr 24  Finalizado Shaanxi Union Shaanxi Union
1 - 1
Haimen Codion Haimen Codion 0
06 Abr 24  Finalizado Shaanxi Union Shaanxi Union
2 - 2
Beijing Technology Beijing Technology 0
30 Mar 24  Finalizado Xi'an Ronghai Xi'an Ronghai
0 - 5
Shaanxi Union Shaanxi Union 0
23 Mar 24  Finalizado Hubei Istar Hubei Istar
0 - 2
Shaanxi Union Shaanxi Union 0

Plantilla del Shaanxi Union Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Defensa
19 cn - - 1 - -
31 cn 175 90 3 - -
Centrocampista
29 cn 181 - - - -
26 cn 178 75 2 - -
33 cn 170 61 1 - -
29 cn 185 69 1 - -
19 cn - - - - -
Delantero
37 cn 177 62 1 - -
33 cn 192 78 4 - -
29 cn 190 - 2 - -

Noticias de Liga Dos China

Ver últimas noticias

China congela el regreso de la competición por miedo a un rebrote

China fue el primer país con contagios por coronavirus y también el primero que ha dejado atrás la pandemia. Con todo, las autoridades gubernamentales congelarán temporalmente "las actividades deportivas multitudinarias" por miedo a un posible rebrote.

"Wuhan es una ciudad fantasma"

Pedro Morilla, director deportivo del Wuhan Three Towns y ex entrenador del Granada, habló en 'El Partidazo de COPE' sobre cómo se está viviendo la situación en la ciudad china.

Carlos Granero, míster ascenso

Tener a Carlos Granero en la plantilla es sinónimo de ascenso. El técnico valenciano lleva ha logrado subir de categoría siete veces a lo largo de su carrera, las dos últimas de forma consecutiva.

Carlos Granero consigue su segundo ascenso consecutivo en China

El entrenador español Carlos Granero ha conseguido su segundo ascenso consecutivo en el fútbol chino tras pasar en un año de la cuarta a la segunda categoría al frente del Chengdu Better City.

Los dueños del Manchester City compran un equipo chino

City Football Group (CFG), el consorcio propietario del conocido equipo de fútbol inglés Manchester City, compró el Sichuan Jiuniu, club de la tercera división de China, informó hoy la agencia estatal 'Xinhua'.




  USO DE MEMORIA  
5,161,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0645
Total Execution Time  0.0667
  CADENA URL  
/Shaanxi-Union-Fc
  GET DATOS  
$_GET['/Shaanxi-Union-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0042  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 = 75650
0.0030  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 = 75481
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=163344 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2093 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2093 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 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 (815734,787681,718637,718000,587186) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '163344' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  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 = 75481 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 75650 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  (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 calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 163344 or c.datateam2 = 163344) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0032  (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 calendars2024 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 = 163344 or c.datateam2 = 163344) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0025  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 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 = 163344 or c.datateam2 = 163344) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0026  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 = 75650 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC