4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Samut Prakan
TEMPORADA 2023/2024
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Bangkok Bangkok 26 59 19 61
2 North Bangkok North 26 44 17 57
3 Samut Sakhon FC Samut Sakhon 26 65 21 56
4 Thonburi United Thonburi 26 56 32 56
5 Kasem Bundit Kasem Bundit 26 64 19 52
6 Prime Bangkok Prime 26 52 23 48
7 Welfare Royal Air Force Welfare 26 41 47 30
8 Chamchuri United Chamchuri 26 28 41 26
9 Muangnont Muangnont 26 18 35 21
10 Army FC Army FC 26 27 59 21
11 Inter Bangkok Inter 26 24 49 20
12 Samut Prakan Samut Prakan 26 20 59 20
13 Nonthaburi Nonthaburi 26 26 50 17
14 Icon RSU Icon RSU 26 19 72 16
TEMPORADA 2022/2023
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 North Bangkok North 26 39 16 53
2 Samut Sakhon FC Samut Sakhon 26 48 35 53
3 Bangkok Bangkok 26 45 28 51
4 Prime Bangkok Prime 26 36 22 46
5 Chamchuri United Chamchuri 26 33 31 38
6 Kasem Bundit Kasem Bundit 26 30 29 37
7 Samut Prakan Samut Prakan 26 33 27 36
8 Nonthaburi Nonthaburi 26 35 36 31
9 Army FC Army FC 26 25 39 30
10 Inter Bangkok Inter 26 26 28 27
11 Muangnont Muangnont 26 28 38 26
12 Thonburi United Thonburi 26 25 35 25
13 Welfare Royal Air Force Welfare 26 31 49 21
14 Siam Siam 26 17 38 20
TEMPORADA 2021/2022
THAI LEAGUE 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Bangkok Bangkok 26 55 19 53
2 North Bangkok North 26 41 13 53
3 Nonthaburi Nonthaburi 26 51 29 47
4 Chamchuri United Chamchuri 26 44 23 46
5 Kasem Bundit Kasem Bundit 26 35 29 44
6 Siam Siam 26 26 32 35
7 Prime Bangkok Prime 26 27 30 34
8 Army FC Army FC 26 24 23 33
9 Muangnont Muangnont 26 29 40 33
10 Welfare Royal Air Force Welfare 26 23 30 31
11 Thonburi United Thonburi 26 32 33 28
12 Inter Bangkok Inter 26 16 60 16
13 Samut Prakan Samut Prakan 26 23 38 15
14 Grakcu Sai Mai United Grakcu 26 27 54 15
TEMPORADA 2020/2021
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 North Bangkok North 12 23 5 29
2 Chamchuri United Chamchuri 12 33 9 27
3 Nonthaburi Nonthaburi 12 21 7 26
4 Bangkok Bangkok 12 26 13 24
5 Muangnont Muangnont 12 16 6 23
6 Prime Bangkok Prime 12 16 16 21
7 Kasem Bundit Kasem Bundit 12 14 15 20
8 Thonburi United Thonburi 12 20 18 16
9 Grakcu Sai Mai United Grakcu 12 13 17 13
10 Welfare Royal Air Force Welfare 12 12 26 13
11 Army FC Army FC 12 11 25 12
12 Samut Prakan Samut Prakan 12 11 30 5
13 Siam Siam 12 12 26 4
14 Inter Bangkok Inter 12 9 24 4
TEMPORADA 2015/2016
SEGUNDA TAILANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 Trat FC Trat FC 22 45 19 52
2 Cha Choeng Sao Choeng 22 46 22 40
3 Prachinburi United Prachinburi 22 38 25 37
4 Sa Kaeo City Kaeo City 22 35 26 35
5 Nakhon Nayok Nakhon Nayok 22 33 23 34
6 Rayong United Rayong 22 30 19 33
7 Samut Prakan Samut Prakan 22 28 28 29
8 Pattaya City Pattaya City 22 35 36 26
9 Chanthaburi Chanthaburi 22 21 22 26
10 Marines Maptaphut Marines 22 22 28 26
11 Kabinburi Kabinburi 22 21 34 23
12 Benjamarachutit Benjamarachu 22 8 80 5
TEMPORADA 2014/2015
SEGUNDA TAILANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Rayong FC Rayong FC 26 50 17 62
2 Cha Choeng Sao Choeng 26 54 31 51
3 Samut Prakan Samut Prakan 26 36 22 50
4 Prachinburi United Prachinburi 26 38 27 44
5 Chanthaburi Chanthaburi 26 37 33 43
6 Saraburi TRU Saraburi 26 46 36 42
7 Sa Kaeo City Kaeo City 26 33 36 33
8 Kabinburi Kabinburi 26 39 46 31
9 Maptaphut Rayong Maptaphut 26 28 34 30
10 Phatum Thani United Phatum Thani 26 33 38 29
11 Phan Thong Phan Thong 26 47 59 25
12 Nakhon Nayok Nakhon Nayok 26 29 58 21
13 Taweewattana Taweewattana 26 28 44 20
14 Royal Thai Fleet Royal Thai. 26 33 50 18
TEMPORADA 2013/2014
SEGUNDA TAILANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 Prachinburi United Prachinburi 26 44 15 54
2 Maptaphut Rayong Maptaphut 26 52 37 51
3 Rayong FC Rayong FC 26 59 26 49
4 Nakhon Nayok Nakhon Nayok 26 50 21 49
5 Sa Kaeo City Kaeo City 26 55 35 48
6 Cha Choeng Sao Choeng 26 48 36 40
7 Royal Thai Fleet Royal Thai. 26 35 31 35
8 Chanthaburi Chanthaburi 26 38 41 35
9 Samut Prakan Samut Prakan 26 33 38 34
10 Phatum Thani United Phatum Thani 26 33 40 31
11 Phan Thong Phan Thong 26 35 60 23
12 Look Esan Look Esan 26 31 73 18
13 TG Rayong TG Rayong 26 31 61 14
14 Kabinburi Kabinburi 26 31 61 13

  USO DE MEMORIA  
5,344,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1093
Total Execution Time  0.1106
  CADENA URL  
/historico/Samut-Prakan
  GET DATOS  
$_GET['/historico/Samut-Prakan']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0031  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 = 'Samut-Prakan' 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=62114 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=62114 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62114 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1929 AND type_rel = 3
0.0027  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '62114' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '62114' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '62114' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=62114 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (74097,69562,68820) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74097 AND teamId = 62114
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 69562 AND teamId = 62114
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 68820 AND teamId = 62114
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 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 = 74097 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0029  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 = '62114' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62114' and rp.type = 4
0.0027  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 = '62114' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 = 74097 WHERE rp.league_id = 74097 AND rp.teamId = 62114 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.0027  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 = 74097 WHERE rp.league_id = 74097 AND rp.teamId = 62114 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 74097 WHERE rp.league_id = 74097 AND rp.teamId = 62114 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 62114 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74097 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.0035  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 = 69589 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.0035  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 = 64308 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.0034  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 `tables2021` 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 = 60176 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.0036  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 = 20619 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 `tables2015` 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 = 9733 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 16123 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC