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

Información sobre el estadio

  • Nombre del estadio Beijing Olympic Sports Centre Stadium
  • Capacidad 36228
Beijing Olympic Sports Centre Stadium

Partidos del Beijing BSU

Ir al LIVESCORE
07 Dic 22  Finalizado Beijing BSU
0 - 1
Jiangxi Lushan 12
04 Dic 22  Finalizado Suzhou Dongwu
0 - 0
Beijing BSU 13
30 Nov 22  Finalizado Beijing BSU
0 - 2
Kunshan FC 22
26 Nov 22  Finalizado Zibo Cuju
2 - 1
Beijing BSU 7
22 Nov 22  Finalizado Beijing BSU
0 - 2
Shenzhen Peng City 17
12 Nov 22  Finalizado Tarjeta RojaJiangxi Lushan
0 - 1
Beijing BSU 10
08 Nov 22  Finalizado Beijing BSU
2 - 2
Suzhou Dongwu 0
03 Nov 22  Finalizado Kunshan FC
4 - 0
Beijing BSU 0
30 Oct 22  Finalizado Beijing BSU
0 - 1
Zibo Cuju 0
26 Oct 22  Finalizado Shenzhen Peng City
5 - 0
Beijing BSU 0
28 Sep 22  Finalizado Qingdao Hainiu
3 - 0
Beijing BSU 6
24 Sep 22  Finalizado Beijing Technology
1 - 1
Beijing BSU 1
19 Sep 22  Finalizado Tarjeta RojaShijiazhuang Gongfu
1 - 0
Beijing BSU 11
16 Sep 22  Finalizado Beijing BSU
0 - 1
Nantong Zhiyun 10
12 Sep 22  Finalizado Beijing BSU
0 - 2
Qingdao Hainiu 1
08 Sep 22  Finalizado Beijing BSU
4 - 0
Beijing Technology 16
04 Sep 22  Finalizado Beijing BSU
0 - 2
Shijiazhuang Gongfu 0
30 Ago 22  Finalizado Nantong Zhiyun
3 - 0
Beijing BSU 13
18 Ago 22  Finalizado Guangxi Pingguo Haliao
2 - 1
Beijing BSU 5
14 Ago 22  Finalizado Qingdao West Coast
2 - 1
Beijing BSU 2
09 Ago 22  Finalizado Nanjing City
2 - 0
Beijing BSU 0
05 Ago 22  Finalizado Beijing BSU
0 - 3
Shaanxi Chang'an 0
01 Ago 22  Finalizado Tarjeta RojaBeijing BSU
1 - 0
Guangxi Pingguo Haliao 5
27 Jul 22  Finalizado Beijing BSU
2 - 2
Qingdao West CoastTarjeta Roja 4
24 Jul 22  Finalizado Beijing BSU
1 - 3
Nanjing City 2
19 Jul 22  Finalizado Shaanxi Chang'an
1 - 1
Beijing BSU 7
09 Jul 22  Finalizado Liaoning Tieren
0 - 1
Beijing BSU 2
04 Jul 22  Finalizado Xinjiang Tianshan
1 - 0
Beijing BSU 28
30 Jun 22  Finalizado Shanghai Jiading Huilong
2 - 0
Beijing BSU 2
27 Jun 22  Finalizado Beijing BSU
3 - 1
Heilongjiang Ice City 2
21 Jun 22  Finalizado Tarjeta RojaBeijing BSU
1 - 2
Liaoning Tieren 72
17 Jun 22  Finalizado Beijing BSU
1 - 1
Xinjiang Tianshan 50
13 Jun 22  Finalizado Beijing BSU
2 - 1
Shanghai Jiading Huilong 6
08 Jun 22  Finalizado Heilongjiang Ice City
4 - 0
Beijing BSU 14

Plantilla del Beijing BSU Temporada 2021/2022

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
37 30 cn 186 78 - - 3
26 21 cn - - - - -
1 19 cn - - - - -
Defensa
22 23 cn - - - - 6
29 30 cn 185 76 3 - 2
39 19 cn - - - - -
43 25 cn 183 - - - 2
42 21 cn - - - - 7
45 19 cn 170 - - - -
11 20 cn - - - - -
41 21 cn 185 - 1 - 5
3 25 cn 192 77 1 1 6
28 22 cn 190 - - - 3
17 23 cn 184 - - - -
5 25 cn 175 67 - - 2
19 29 cn 177 73 - - 2
4 23 cn 180 - - - 3
18 22 cn - - - - -
Centrocampista
13 24 cn 187 - - - 6
12 23 cn - - 1 - 2
40 19 cn - - - - -
16 22 cn 176 - - - -
32 23 cn - - - - -
9 22 cn 183 - - - -
10 23 cn 182 67 6 - 9
44 20 cn - - - - -
17 19 cn - - - - -
8 24 cn 175 68 2 - 4
19 29 cn - - - - -
Delantero
15 36 cn - - 3 - 3
6 25 cn 175 - 4 1 4
7 25 cn 188 75 2 - 3

Noticias del Beijing BSU

Ver últimas noticias

"Tioté se levantó, dio un par de tumbos y se desplomó"

La repentina muerte de Cheick Tioté sigue dando de qué hablar y Pablo Franco, uno de los que estuvo presente en aquel trágico momento, ha explicado cómo fue.

Fallece Tioté, ex jugador del Newcastle

El ex jugador del Newcastle sufrió un paro cardiaco durante un entrenamiento y habría fallecido en el hospital, según las primeras informaciones que llegan desde China.

La mujer del fallecido Tioté esperaba un bebé esta misma semana

Ed Aarons, periodista de 'The Guardian', desveló una noticia que todavía hace más trágica la pérdida del ex futbolista del Newcastle.

El Newcastle confirma la marcha de Tiote a China

El Newcastle United de Rafa Benítez ha confirmado este jueves el traspaso del centrocampista internacional marfileño Cheick Tiote al Beijing Enterprises, de la segunda división china.

De la Segunda China... a regresar a Osasuna

Osasuna ha conseguido reforzarse con el defensa central montenegrino Nikola Vujadinovic, quien ya vistió la camiseta 'rojilla' en la temporada 2014/15.




  USO DE MEMORIA  
5,638,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1526
Total Execution Time  0.1545
  CADENA URL  
/beijing-baxy
  GET DATOS  
$_GET['/beijing-baxy']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0025  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 = 'beijing-baxy' AND l.year = 2024 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.0060  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 = 'beijing-baxy' 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 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=7491 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7491 AND type_rel = 2
0.0030  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7491 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0028  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 (167514,175354,237954,238040,238904) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '7491' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '7491' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020