4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Uthai Thani

Uthai Thani

Entrenador: Jukkapant Punpee

Temporada 2023/2024
TEMPORADA 2023/2024
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Buriram United Buriram 26 57 24 59
2 Bangkok United Bangkok 26 48 19 54
3 Port FC Port FC 26 61 34 49
4 BG Pathum United Pathum 26 48 33 42
5 Muang Thong United Muang Thong 26 48 42 40
6 Ratchaburi Ratchaburi 26 33 30 35
7 Chiangrai United Chiangrai 26 29 31 32
8 Nakhon Pathom Nakhon 26 36 42 32
9 Lamphun Warrior Lamphun 26 39 41 31
10 Khon Kaen United Khon Kaen U. 26 33 44 31
11 Uthai Thani Uthai Thani 26 34 48 29
12 Sukhothai Sukhothai 26 31 47 29
13 Prachuap Prachuap 26 29 35 27
14 Chonburi Chonburi 26 29 41 26
15 Trat FC Trat FC 26 35 51 25
16 Police Tero FC Police Tero 26 33 61 24
TEMPORADA 2022/2023
THAI LEAGUE 2
Equipo PJ GF GC Puntos
1 Nakhon Pathom Nakhon 34 32 20 60
2 Trat FC Trat FC 34 55 34 60
3 Uthai Thani Uthai Thani 34 70 36 59
4 Customs Ladkrabang Customs 34 45 31 58
5 Chiangmai Utd Chiangmai 34 36 32 54
6 Suphanburi Suphanburi 34 36 35 52
7 Rayong FC Rayong FC 34 41 30 52
8 Nakhon Si United Nakhon 34 48 42 51
9 Phrae United Phrae United 34 50 43 51
10 Ayutthaya United Ayutthaya 34 50 43 51
11 Chiangmai Chiangmai 34 49 41 46
12 Krabi Krabi 34 46 46 42
13 Chainat Hornbill Chainat 34 44 48 41
14 Kasetsart Kasetsart 34 35 42 37
15 Samut Prakan City Samut Prakan 34 32 42 37
16 Raj Pracha Raj Pracha 34 29 41 37
17 Ranong Ranong 34 28 64 27
18 Udon Thani Udon Thani 34 31 87 21
TEMPORADA 2021/2022
THAI LEAGUE 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Krabi Krabi 5 8 6 10
2 Nakhon Si United Nakhon 5 9 2 9
3 North Bangkok North 5 5 2 8
4 Saraburi United Saraburi 5 6 5 8
5 Pathum Thani University Pathum Thani 5 6 8 3
6 Bangkok Bangkok 5 3 14 3
7 Uthai Thani Uthai Thani 5 14 6 12
8 Phitsanulok Phitsanulok 5 9 4 12
9 Pattaya Dolphins Pattaya 5 11 8 12
10 Muang Loei United Muang Loei. 5 5 7 3
11 Sisaket Sisaket 5 8 15 3
12 Cha Choeng Sao Choeng 5 5 12 3
TEMPORADA 2019/2020
THAI LEAGUE 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Nong Bua Pitchaya Nong 30 56 13 67
2 Chiangmai Utd Chiangmai 30 57 25 63
3 Nakhon Pathom Nakhon 30 61 31 55
4 Chainat Hornbill Chainat 30 55 39 50
5 Phrae United Phrae United 30 40 24 50
6 Chiangmai Chiangmai 30 46 40 49
7 Khon Kaen United Khon Kaen U. 30 43 33 48
8 Ranong Ranong 30 39 38 45
9 Ayutthaya United Ayutthaya 30 39 40 40
10 Khonkaen Khonkaen 30 32 33 40
11 Siam Navy Siam Navy 30 43 47 36
12 Sisaket Sisaket 30 34 38 36
13 Customs United Customs 30 34 55 36
14 Kasetsart Kasetsart 30 30 46 34
15 Lampang Lampang 30 35 41 33
16 Udon Thani Udon Thani 30 39 42 31
17 Uthai Thani Uthai Thani 30 31 41 24
18 Samut Sakhon FC Samut Sakhon 30 22 110 8
TEMPORADA 2015/2016
SEGUNDA TAILANDIA GRUPO 7
Equipo PJ GF GC Puntos
1 Ayutthaya Warrior Ayutthaya 20 38 17 46
2 Ayutthaya Ayutthaya 20 27 11 42
3 Singburi Singburi 20 40 22 41
4 Ayutthaya United Ayutthaya 20 19 15 31
5 Paknampho NSRU Paknampho 20 20 17 28
6 Nakhon Sawan Nakhon Sawan 20 16 21 24
7 Pathum Thani Seeker Pathum Thani 20 17 24 23
8 Saraburi TRU Saraburi 20 19 24 20
9 Phan Thong Phan Thong 20 14 27 17
10 Chaiyaphum United Chaiyaphum 20 13 27 15
11 Uthai Thani Uthai Thani 20 11 29 14
TEMPORADA 2013/2014
SEGUNDA TAILANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sukhothai Sukhothai 26 69 19 61
2 Phichit Phichit 26 65 26 55
3 Phayao Phayao 26 53 29 53
4 Phrae United Phrae United 26 43 30 48
5 Chiangrai Chiangrai 26 52 31 47
6 Lampang Lampang 26 35 18 43
7 Nakhon Sawan Nakhon Sawan 26 39 40 40
8 Lamphun Warrior Lamphun 26 29 27 33
9 Uttaradit Uttaradit 26 22 34 29
10 Nan FC Nan FC 26 31 40 27
11 Kamphaeng Phet Kamphaeng 26 23 44 24
12 Phetchabun Phetchabun 26 31 46 21
13 Uthai Thani Uthai Thani 26 25 60 17
14 Tak FC Tak FC 26 22 95 1

  USO DE MEMORIA  
5,966,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1335
Total Execution Time  0.1347
  CADENA URL  
/historico/Uthai-Thani
  GET DATOS  
$_GET['/historico/Uthai-Thani']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0028  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 = 'Uthai-Thani' 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.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=65011 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=65011 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=65011 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=65011 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=65011 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 72284
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65011 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=394 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 394 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1015856,1010172,983319,814468,749631) ORDER BY n.cover_points DESC, update_date 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 = '65011' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 72284 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=65011 AND l.year in (2023,2024,2025) 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 (74095,73915,72284,71685,71432) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72284 AND teamId = 65011
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71685 AND teamId = 65011
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 74095 AND teamId = 65011
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73915 AND teamId = 65011
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65011
0.0028  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 = 72284 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026  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 = '65011' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65011' and rp.type = 4
0.0026  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 = '65011' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0065  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 events2024 e ON e.player_id = p.id AND e.league_id = 72284 WHERE rp.league_id = 72284 AND rp.teamId = 65011 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.0056  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 events2024 e ON e.player_id = p.id AND e.league_id = 72284 WHERE rp.league_id = 72284 AND rp.teamId = 65011 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044  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 events2024 e ON e.player_id = p.id AND e.league_id = 72284 WHERE rp.league_id = 72284 AND rp.teamId = 65011 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 65011 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 72284 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 68168 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 64303 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 66902 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 55278 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 37986 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 16121 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC