4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Nakhon Mae Sot United
TEMPORADA 2023/2024
THAI LEAGUE 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Wat Bot City City 20 33 18 43
2 Maejo United Maejo United 20 36 17 40
3 Phitsanulok Phitsanulok 20 43 22 38
4 Mae Chai Thanachotiwat Chai 20 28 24 31
5 Nakhon Mae Sot United Nakhon 20 23 28 23
6 Uttaradit Uttaradit 20 24 26 22
7 Kong Krailas United Kong Krailas 20 29 45 22
8 Khelang United Khelang 20 17 26 21
9 Kamphaeng Phet Kamphaeng 20 17 24 19
10 Chiangrai Chiangrai 20 23 30 18
11 See Khwae City Khwae City 20 13 26 17
TEMPORADA 2022/2023
THAI LEAGUE 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Phitsanulok Phitsanulok 22 60 17 56
2 Uttaradit Uttaradit 22 45 19 48
3 Mae Chai Thanachotiwat Chai 22 40 32 38
4 Wat Bot City City 22 35 23 37
5 Nan FC Nan FC 22 22 20 33
6 Maejo United Maejo United 22 25 22 30
7 See Kwae See Kwae 21 22 21 30
8 Chiangrai Chiangrai 21 24 30 25
9 Kamphaeng Phet Kamphaeng 21 19 29 20
10 Nakhon Mae Sot United Nakhon 22 12 25 19
11 Kong Krailas United Kong Krailas 22 15 39 14
12 Chiangrai Lanna Chiangrai 21 19 61 8
TEMPORADA 2021/2022
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Uthai Thani Uthai Thani 22 63 11 56
2 Phitsanulok Phitsanulok 22 28 15 41
3 Maejo United Maejo United 22 23 21 38
4 See Kwae See Kwae 22 27 23 35
5 Wat Bot City City 22 26 26 35
6 Chiangrai Chiangrai 22 19 14 34
7 Uttaradit Uttaradit 22 27 22 28
8 Nakhon Mae Sot United Nakhon 22 13 22 20
9 Kamphaeng Phet Kamphaeng 22 18 35 19
10 Chiangrai Lanna Chiangrai 22 16 38 18
11 Nan FC Nan FC 22 18 33 17
12 Northern Tak United Northern 22 16 34 16

  USO DE MEMORIA  
5,004,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3500
Total Execution Time  0.3513
  CADENA URL  
/historico/Nakhon-Mae-Sot-United-Fc
  GET DATOS  
$_GET['/historico/Nakhon-Mae-Sot-United-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=110760 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1929 AND type_rel = 3
0.0132  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 = '110760' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  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.0126  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 = 74099 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=110760 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (74099,73915) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 74099 AND teamId = 110760
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73915 AND teamId = 110760
0.0130  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 = 74099 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130  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 = '110760' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '110760' and rp.type = 4
0.0135  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 = '110760' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142  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 = 74099 WHERE rp.league_id = 74099 AND rp.teamId = 110760 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.0126  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 = 74099 WHERE rp.league_id = 74099 AND rp.teamId = 110760 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 74099 WHERE rp.league_id = 74099 AND rp.teamId = 110760 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 110760 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 74099 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.0128  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 = 69591 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.0129  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