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

Prachuap

Entrenador: Sasom Pobprasert

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
Equipo PJ GF GC Puntos
1 Buriram United Buriram 30 75 27 74
2 Bangkok United Bangkok 30 55 22 62
3 Port FC Port FC 30 52 38 52
4 Muang Thong United Muang Thong 30 56 37 50
5 Chiangrai United Chiangrai 30 44 42 44
6 Chonburi Chonburi 30 46 38 43
7 Police Tero FC Police Tero 30 41 43 43
8 BG Pathum United Pathum 30 42 39 41
9 Ratchaburi Ratchaburi 30 32 29 41
10 Lamphun Warrior Lamphun 30 27 36 36
11 Prachuap Prachuap 30 44 51 35
12 Sukhothai Sukhothai 30 27 43 34
13 Khon Kaen United Khon Kaen U. 30 24 42 33
14 Nakhon Ratchasima Nakhon 30 31 53 29
15 Nong Bua Pitchaya Nong 30 27 47 21
16 Lampang Lampang 30 24 60 19
TEMPORADA 2021/2022
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Buriram United Buriram 30 48 19 62
2 BG Pathum United Pathum 30 52 27 60
3 Bangkok United Bangkok 30 53 30 53
4 Muang Thong United Muang Thong 30 46 35 49
5 Nong Bua Pitchaya Nong 30 42 35 47
6 Chiangrai United Chiangrai 30 33 35 47
7 Chonburi Chonburi 30 50 40 44
8 Port FC Port FC 30 41 37 39
9 Police Tero FC Police Tero 30 33 39 37
10 Khon Kaen United Khon Kaen U. 30 30 43 37
11 Nakhon Ratchasima Nakhon 30 33 47 37
12 Ratchaburi Ratchaburi 30 32 36 36
13 Prachuap Prachuap 30 30 45 31
14 Suphanburi Suphanburi 30 35 49 30
15 Samut Prakan City Samut Prakan 30 29 42 28
16 Chiangmai Utd Chiangmai 30 28 56 19
TEMPORADA 2019/2020
THAI LEAGUE
Equipo PJ GF GC Puntos
1 BG Pathum United Pathum 30 54 13 77
2 Buriram United Buriram 30 63 26 63
3 Port FC Port FC 30 58 36 56
4 Chiangrai United Chiangrai 30 48 32 54
5 Bangkok United Bangkok 30 57 39 51
6 Muang Thong United Muang Thong 30 52 43 47
7 Samut Prakan City Samut Prakan 30 58 51 47
8 Ratchaburi Ratchaburi 30 48 41 46
9 Nakhon Ratchasima Nakhon 30 40 41 42
10 Prachuap Prachuap 30 35 47 37
11 Police Tero FC Police Tero 30 32 50 36
12 Chonburi Chonburi 30 30 47 32
13 Suphanburi Suphanburi 30 33 47 30
14 Sukhothai Sukhothai 30 40 57 28
15 Trat FC Trat FC 30 31 64 17
16 Rayong FC Rayong FC 30 24 69 15
TEMPORADA 2018/2019
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Chiangrai United Chiangrai 30 53 28 58
2 Buriram United Buriram 30 51 25 58
3 Port FC Port FC 30 55 36 53
4 Bangkok United Bangkok 30 55 32 50
5 Muang Thong United Muang Thong 30 45 42 46
6 Samut Prakan City Samut Prakan 30 44 50 43
7 Chonburi Chonburi 30 43 45 40
8 Ratchaburi Ratchaburi 30 48 48 38
9 Prachuap Prachuap 30 32 44 37
10 Trat FC Trat FC 30 47 47 35
11 PTT Rayong PTT Rayong 30 33 46 35
12 Sukhothai Sukhothai 30 37 37 34
13 Nakhon Ratchasima Nakhon 30 45 51 34
14 Suphanburi Suphanburi 30 29 44 32
15 Chainat Hornbill Chainat 30 31 50 30
16 Chiangmai Chiangmai 30 39 62 28
TEMPORADA 2017/2018
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Buriram United Buriram 34 76 25 87
2 Bangkok United Bangkok 34 68 36 71
3 Port FC Port FC 34 73 45 61
4 Muang Thong United Muang Thong 34 65 53 59
5 Chiangrai United Chiangrai 34 52 36 55
6 Prachuap Prachuap 34 56 46 53
7 Nakhon Ratchasima Nakhon 34 36 44 47
8 Samut Prakan City Samut Prakan 34 50 62 46
9 Chonburi Chonburi 34 45 53 46
10 Suphanburi Suphanburi 34 43 35 46
11 Sukhothai Sukhothai 34 53 63 43
12 Ratchaburi Ratchaburi 34 50 53 43
13 Chainat Hornbill Chainat 34 46 52 42
14 BG Pathum United Pathum 34 55 46 42
15 Police Tero FC Police Tero 34 53 66 36
16 Siam Navy Siam Navy 34 44 85 30
17 Ubon UMT Ubon UMT 34 39 58 26
18 Air Force Central Force 34 32 78 16
TEMPORADA 2016/2017
THAI LEAGUE 2
Equipo PJ GF GC Puntos
1 Chainat Hornbill Chainat 32 64 40 67
2 Air Force Central Force 32 61 40 62
3 Prachuap Prachuap 32 58 40 59
4 Ang Thong Ang Thong 32 65 46 53
5 PTT Rayong PTT Rayong 32 54 50 50
6 Lampang Lampang 32 45 47 47
7 Nakhon Pathom Nakhon 32 43 38 42
8 Nong Bua Pitchaya Nong 32 45 47 41
9 Royal Thai Fleet Royal Thai. 32 53 57 39
10 Chiangmai Chiangmai 32 46 52 39
11 Krabi Krabi 32 50 62 38
12 Rayong FC Rayong FC 32 55 56 38
13 Trat FC Trat FC 32 49 59 37
14 Kasetsart Kasetsart 32 61 72 37
15 Samut Songkhram Samut 32 42 57 35
16 Songkhla United Songkhla 32 38 49 34
17 Bangkok Bangkok 32 47 64 29
18 BBCU BBCU 0 0 0 0
TEMPORADA 2015/2016
THAI LEAGUE 2
Equipo PJ GF GC Puntos
1 Thai Honda Thai Honda 26 46 23 52
2 Ubon UMT Ubon UMT 26 38 23 49
3 Port FC Port FC 26 55 30 47
4 Air Force Central Force 26 44 29 42
5 Ang Thong Ang Thong 26 38 30 41
6 Songkhla United Songkhla 26 35 33 39
7 Prachuap Prachuap 26 36 36 35
8 PTT Rayong PTT Rayong 26 42 43 35
9 Chiangmai Chiangmai 26 36 34 32
10 Krabi Krabi 26 27 26 29
11 Lampang Lampang 27 39 51 28
12 Nakhon Pathom Nakhon 26 29 42 28
13 Rayong FC Rayong FC 26 24 39 24
14 Bangkok Bangkok 26 26 41 23
15 Samut Songkhram Samut 27 26 61 19
16 Khon Kaen United Khon Kaen U. 0 0 0 0
TEMPORADA 2014/2015
THAI LEAGUE 2
Equipo PJ GF GC Puntos
1 Police United Police 38 84 30 80
2 Samut Prakan City Samut Prakan 38 77 40 65
3 BBCU BBCU 38 50 42 60
4 Sukhothai Sukhothai 37 70 52 59
5 Nakhon Pathom Nakhon 37 58 46 59
6 Thai Honda Thai Honda 38 62 46 57
7 PTT Rayong PTT Rayong 38 62 60 54
8 Prachuap Prachuap 38 56 54 54
9 Air Force Central Force 38 53 50 52
10 Ang Thong Ang Thong 38 48 41 51
11 Songkhla United Songkhla 38 53 60 51
12 Samut Songkhram Samut 38 55 53 50
13 Krabi Krabi 38 46 47 49
14 Bangkok Bangkok 38 44 49 49
15 Phichit Phichit 38 59 63 48
16 Chiangmai Chiangmai 38 43 54 48
17 Ayutthaya Ayutthaya 38 47 71 43
18 Phuket Phuket 38 38 65 43
19 TTM Lopburi TTM Lopburi 38 34 51 40
20 Trat FC Trat FC 38 35 100 27
TEMPORADA 2013/2014
SEGUNDA TAILANDIA GRUPO 7
Equipo PJ GF GC Puntos
1 Prachuap Prachuap 10 20 14 19
2 Phichit Phichit 10 20 14 16
3 Udon Thani Udon Thani 10 10 9 14
4 Hua Hin City City 10 15 17 13
5 Christian College Christian 10 9 13 12
6 Prachinburi United Prachinburi 10 11 18 12
7 Thai Honda Thai Honda 10 20 11 21
8 Satun United Satun United 10 14 6 20
9 Sukhothai Sukhothai 10 16 9 20
10 Ubon Ratchathani Ubon 10 21 15 14
11 Phetchaburi Phetchaburi 10 12 13 12
12 Maptaphut Rayong Maptaphut 10 4 33 0

  USO DE MEMORIA  
6,510,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.6644
Total Execution Time  0.6656
  CADENA URL  
/historico/Prachuap
  GET DATOS  
$_GET['/historico/Prachuap']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0147  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 = 'Prachuap' 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=61744 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=61744 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=61744 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=61744 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257  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.0132  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 = 74095
0.0134  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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61744 AND type_rel = 2
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=394 AND type_rel = 3
0.0127  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.0127  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.0131  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 = '61744' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '61744' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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.0134  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 = 72284 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=61744 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 72284 AND teamId = 61744
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 74095 AND teamId = 61744
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73915 AND teamId = 61744
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 = 72284 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '61744' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61744' and rp.type = 4
0.0126  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 = '61744' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 61744 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.0136  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 = 61744 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 61744 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 61744 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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.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 = 68167 AND t.round = 30 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 = 63250 AND t.round = 30 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 `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 = 55277 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2019` 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 = 48753 AND t.round = 30 ORDER BY team.conference 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 `tables2018` 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 = 42548 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2017` 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 = 37900 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 21211 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 9515 AND t.round = 38 ORDER BY team.conference 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 `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 = 16126 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 16127 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72284 ORDER BY nameShow LIMIT 100