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

Partidos del Nakhon Ratchasima

Ir al LIVESCORE
27 Abr 24  Finalizado Chanthaburi
1 - 1
Nakhon Ratchasima 0
20 Abr 24  Finalizado Nakhon Ratchasima
3 - 0
Nong Bua PitchayaTarjeta Roja 0
06 Abr 24  Finalizado Suphanburi
1 - 2
Nakhon Ratchasima 0
30 Mar 24  Finalizado Nakhon Ratchasima
2 - 2
Chiangmai Utd 0
24 Mar 24  Finalizado Nakhon Ratchasima
5 - 0
Phrae United 0
17 Mar 24  Finalizado Nakhon Ratchasima
1 - 0
Ayutthaya United 0
08 Mar 24  Finalizado Customs Ladkrabang
1 - 3
Nakhon Ratchasima 0
02 Mar 24  Finalizado Nakhon Ratchasima
3 - 1
Kanchanaburi 0
25 Feb 24  Finalizado Nakhon Ratchasima
2 - 1
Nakhon Si United 0
18 Feb 24  Finalizado Tarjeta RojaTarjeta RojaChiangmai
1 - 2
Nakhon Ratchasima 0
11 Feb 24  Finalizado Nakhon Ratchasima
0 - 0
Pattaya Dolphins 0
07 Feb 24  Finalizado Tarjeta RojaRayong FC
1 - 1
Nakhon Ratchasima 0
03 Feb 24  Finalizado Nakhon Ratchasima
5 - 1
Samut Prakan City 0
28 Ene 24  Finalizado Krabi
2 - 2
Nakhon Ratchasima 0
21 Ene 24  Finalizado Nakhon Ratchasima
2 - 0
Lampang 0
14 Ene 24  Finalizado Kasetsart
1 - 4
Nakhon Ratchasima 0
07 Ene 24  Finalizado Nakhon Ratchasima
1 - 1
Chainat Hornbill 3

Plantilla del Nakhon Ratchasima Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
25 21 th 180 - - - -
1 23 th - - - - -
36 32 th 185 - - - 2
Defensa
6 25 iq 186 - 1 1 3
26 34 th 185 - - - 1
16 24 th - - - - -
37 32 th 176 - - - 4
88 26 th 173 - - - 1
24 25 th 185 - - - -
5 28 th 188 - - - 2
5 28 th 187 82 - - -
15 26 th - - - - -
3 27 th - - - - 7
17 29 th 180 - 2 - 7
15 26 th 173 - - - 6
Centrocampista
21 33 th 175 - 1 - 4
21 33 th 175 - - - -
33 th - - - - -
39 23 th - - - - 5
63 19 th - - - - -
4 25 th - - - - 7
29 30 th 174 - 2 - -
91 27 th - - 7 - 2
92 22 th 164 - - - -
Delantero
18 26 mm 182 - 3 - 1
40 19 th - - - - -
10 32 br 185 - 22 - 3
7 35 fr 172 64 13 - 7
9 29 de 188 86 16 - 3
19 22 th - - 3 - 2
31 br - - 14 - 8
30 18 th - - - - -
33 22 th 170 62 - - 3

Noticias del Nakhon Ratchasima

Ver últimas noticias

La increíble doble chilena de Oliver y Benji... ¡en un partido oficial!

Dos jugadores del Nakhon Ratchasima en la Liga de Tailanda se lanzaron a hacer una chilena y golpearon al balón al mismo tiempo para marcar un gol al estilo de la serie animada 'Oliver y Benji'.

De Messi a Pogba, pasando por Maradona y... ¡Adiyiah!

Maradona, Messi, Pogba, Agüero... Ellos y muchos más fueron ganadores del Balón de Oro en un Mundial Sub 20. Muchos llegaron a la cima del fútbol, pero otros tantos no cumplieron las expectativas.

El campeón del mundo Sub 20 que juega la Liga de Tailandia

Cuando en el año 2009, con tan solo 20 años de edad, Dominic Adiyiah se proclamó campeón del mundo Sub 20, no podría ni imaginar que su carrera deportiva se iba a desarrollar en equipos de segundo nivel de la Serie B italiana, Ucrania o Serbia.




  USO DE MEMORIA  
5,726,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3123
Total Execution Time  0.3142
  CADENA URL  
/Nakhon-Ratchasima-Fc/
  GET DATOS  
$_GET['/Nakhon-Ratchasima-Fc/']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0164  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 = 'Nakhon-Ratchasima-Fc' 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.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=61734 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=61734 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=61734 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=61734 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=61734 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0273  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 = 73915
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61734 AND type_rel = 2
0.0140  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 61734 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0132  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 (358205,537178,720322) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '61734' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 74095 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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 = 73915 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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 = 73186 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC