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

Chonburi

Entrenador: Withaya Laohakul

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 25 48 19 53
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 25 33 29 35
7 Nakhon Pathom Nakhon 26 36 42 32
8 Lamphun Warrior Lamphun 25 37 38 31
9 Chiangrai United Chiangrai 25 28 31 29
10 Uthai Thani Uthai Thani 26 34 48 29
11 Sukhothai Sukhothai 26 31 47 29
12 Khon Kaen United Khon Kaen U. 25 30 42 28
13 Prachuap Prachuap 25 29 35 26
14 Chonburi Chonburi 26 29 41 26
15 Police Tero FC Police Tero 25 31 57 24
16 Trat FC Trat FC 25 31 49 22
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
Equipo PJ GF GC Puntos
1 Buriram United Buriram 34 85 22 86
2 Muang Thong United Muang Thong 34 79 29 72
3 Bangkok United Bangkok 34 97 57 66
4 Chiangrai United Chiangrai 34 67 42 60
5 BG Pathum United Pathum 34 63 44 56
6 Ratchaburi Ratchaburi 34 63 49 55
7 Chonburi Chonburi 34 59 59 53
8 Samut Prakan City Samut Prakan 34 60 53 51
9 Port FC Port FC 34 60 63 50
10 Ubon UMT Ubon UMT 34 55 54 47
11 Suphanburi Suphanburi 34 52 58 43
12 Nakhon Ratchasima Nakhon 34 42 48 41
13 Siam Navy Siam Navy 34 42 50 40
14 Police Tero FC Police Tero 34 42 57 39
15 Sukhothai Sukhothai 34 54 66 36
16 Thai Honda Thai Honda 34 43 68 28
17 Sisaket Sisaket 34 43 90 23
18 Super Power Samut Prakan Super Power 34 31 128 6
TEMPORADA 2015/2016
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Muang Thong United Muang Thong 31 73 24 80
2 Bangkok United Bangkok 31 71 36 75
3 BG Pathum United Pathum 31 62 41 57
4 Buriram United Buriram 30 55 38 55
5 Chonburi Chonburi 31 52 33 51
6 Ratchaburi Ratchaburi 30 52 35 49
7 Sukhothai Sukhothai 31 50 44 45
8 Chiangrai United Chiangrai 31 42 43 45
9 Police Tero FC Police Tero 30 42 52 41
10 Suphanburi Suphanburi 31 33 35 38
11 Nakhon Ratchasima Nakhon 31 30 44 35
12 Samut Prakan City Samut Prakan 31 46 66 34
13 Sisaket Sisaket 31 41 52 33
14 Siam Navy Siam Navy 31 24 40 31
15 Super Power Samut Prakan Super Power 31 45 71 31
16 Royal Thai Fleet Royal Thai. 31 34 46 30
17 Chainat Hornbill Chainat 31 46 61 30
18 BBCU BBCU 30 32 69 13
TEMPORADA 2014/2015
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Buriram United Buriram 34 98 24 84
2 Muang Thong United Muang Thong 34 81 35 71
3 Suphanburi Suphanburi 34 60 39 59
4 Chonburi Chonburi 34 62 44 57
5 Bangkok United Bangkok 34 59 47 57
6 BG Pathum United Pathum 34 47 38 56
7 Ratchaburi Ratchaburi 34 48 50 55
8 Nakhon Ratchasima Nakhon 34 37 43 49
9 Chiangrai United Chiangrai 34 42 57 44
10 Royal Thai Fleet Royal Thai. 34 43 47 41
11 Super Power Samut Prakan Super Power 34 40 54 39
12 Chainat Hornbill Chainat 34 42 53 37
13 Sisaket Sisaket 34 30 47 36
14 Police Tero FC Police Tero 34 42 51 35
15 Saraburi Saraburi 34 41 56 35
16 Siam Navy Siam Navy 34 42 65 35
17 Port FC Port FC 34 31 49 33
18 TOT TOT 34 25 71 16
TEMPORADA 2013/2014
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Buriram United Buriram 38 69 26 79
2 Chonburi Chonburi 38 62 33 76
3 Police Tero FC Police Tero 38 66 41 68
4 Ratchaburi Ratchaburi 38 62 42 65
5 Muang Thong United Muang Thong 38 66 36 62
6 Suphanburi Suphanburi 38 55 49 59
7 Chiangrai United Chiangrai 38 55 47 55
8 Bangkok United Bangkok 38 55 56 54
9 Royal Thai Fleet Royal Thai. 38 52 55 53
10 BG Pathum United Pathum 38 70 65 49
11 Super Power Samut Prakan Super Power 38 53 49 48
12 Sisaket Sisaket 38 48 59 46
13 Port FC Port FC 38 44 52 45
14 Chainat Hornbill Chainat 38 43 50 44
15 TOT TOT 38 38 51 43
16 Police United Police 38 58 64 43
17 PTT Rayong PTT Rayong 38 49 60 42
18 Songkhla United Songkhla 38 39 72 32
19 Air Force Central Force 38 35 63 30
20 Samut Songkhram Samut 38 32 81 19
TEMPORADA 2012/2013
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Buriram United Buriram 32 73 23 78
2 Muang Thong United Muang Thong 32 61 33 71
3 Chonburi Chonburi 32 61 35 62
4 Suphanburi Suphanburi 32 40 31 51
5 BG Pathum United Pathum 32 40 31 50
6 Royal Thai Fleet Royal Thai. 32 48 40 48
7 Police Tero FC Police Tero 32 56 49 48
8 Super Power Samut Prakan Super Power 32 38 43 39
9 Police United Police 32 40 37 38
10 Chainat Hornbill Chainat 32 42 43 38
11 Chiangrai United Chiangrai 32 32 45 34
12 Songkhla United Songkhla 32 30 47 32
13 Bangkok United Bangkok 32 38 61 31
14 TOT TOT 32 27 54 31
15 Ratchaburi Ratchaburi 32 31 39 30
16 Samut Songkhram Samut 32 22 41 30
17 Samut Prakan City Samut Prakan 32 39 66 29
18 Sisaket Sisaket 0 0 0 0
TEMPORADA 2011/2012
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Muang Thong United Muang Thong 34 78 31 84
2 Chonburi Chonburi 34 65 33 70
3 Police Tero FC Police Tero 34 53 43 57
4 Buriram United Buriram 34 60 40 54
5 Super Power Samut Prakan Super Power 34 55 48 52
6 Sisaket Sisaket 34 41 42 47
7 Samut Songkhram Samut 34 37 39 46
8 BG Pathum United Pathum 34 53 39 45
9 Chiangrai United Chiangrai 34 40 47 44
10 Royal Thai Fleet Royal Thai. 34 34 38 43
11 Police United Police 34 37 38 42
12 TOT TOT 34 43 46 42
13 Songkhla United Songkhla 34 46 54 41
14 Chainat Hornbill Chainat 34 59 72 39
15 Samut Prakan City Samut Prakan 34 35 47 37
16 Port FC Port FC 34 32 48 33
17 BBCU BBCU 34 32 63 25
18 TTM Lopburi TTM Lopburi 34 25 57 18
TEMPORADA 2010/2011
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Buriram United Buriram 34 64 15 85
2 Chonburi Chonburi 34 60 30 69
3 Muang Thong United Muang Thong 34 54 32 60
4 Samut Prakan City Samut Prakan 34 38 27 53
5 BG Pathum United Pathum 34 55 41 53
6 Super Power Samut Prakan Super Power 34 47 32 51
7 Chiangrai United Chiangrai 36 49 55 47
8 Port FC Port FC 34 33 37 45
9 Police Tero FC Police Tero 34 38 35 45
10 Police United Police 34 36 40 44
11 TOT TOT 34 32 52 43
12 Royal Thai Fleet Royal Thai. 34 39 40 39
13 TTM Lopburi TTM Lopburi 32 35 51 37
14 Samut Songkhram Samut 34 31 45 36
15 Sisaket Sisaket 34 30 42 34
16 Siam Navy Siam Navy 34 29 51 34
17 Sriracha Sriracha 34 33 43 32
18 Khonkaen Khonkaen 34 33 68 27
TEMPORADA 2009/2010
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Muang Thong United Muang Thong 30 64 19 67
2 Buriram United Buriram 30 51 19 63
3 Chonburi Chonburi 30 57 28 60
4 Port FC Port FC 30 40 29 48
5 BG Pathum United Pathum 30 48 38 45
6 Samut Prakan City Samut Prakan 30 43 38 45
7 Super Power Samut Prakan Super Power 30 32 30 42
8 Samut Songkhram Samut 30 27 32 42
9 Police Tero FC Police Tero 30 39 42 35
10 Siam Navy Siam Navy 30 35 51 33
11 Police United Police 30 40 45 33
12 TOT TOT 30 23 42 33
13 TTM Lopburi TTM Lopburi 30 32 46 32
14 Sisaket Sisaket 30 35 54 26
15 Bangkok United Bangkok 30 25 52 24
16 Royal Thai Fleet Royal Thai. 30 27 53 22
TEMPORADA 2008/2009
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Muang Thong United Muang Thong 30 48 20 65
2 Chonburi Chonburi 30 50 30 62
3 BG Pathum United Pathum 30 45 31 56
4 Police Tero FC Police Tero 30 53 34 51
5 Super Power Samut Prakan Super Power 30 36 32 47
6 Port FC Port FC 30 33 30 44
7 TOT TOT 30 33 33 42
8 TTM Lopburi TTM Lopburi 30 29 32 37
9 Buriram United Buriram 30 37 41 36
10 Samut Songkhram Samut 30 22 31 34
11 Samut Prakan City Samut Prakan 30 27 33 32
12 Siam Navy Siam Navy 30 28 39 30
13 Bangkok United Bangkok 30 24 34 30
14 Sriracha Sriracha 30 28 34 30
15 BBCU BBCU 30 29 47 26
16 Nakhon Pathom Nakhon 30 32 53 25
TEMPORADA 2007/2008
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Buriram United Buriram 30 38 16 59
2 Chonburi Chonburi 30 32 14 57
3 Police Tero FC Police Tero 30 50 31 55
4 Super Power Samut Prakan Super Power 30 36 24 51
5 TOT TOT 30 36 27 50
6 Krung Thai Bank Krung Thai. 30 46 35 46
7 Samut Songkhram Samut 30 35 31 43
8 BBCU BBCU 30 47 41 39
9 Nakhon Pathom Nakhon 30 24 36 38
10 Bangkok United Bangkok 30 25 33 36
11 Samut Prakan City Samut Prakan 30 24 27 35
12 TTM Lopburi TTM Lopburi 30 19 24 33
13 Bangkok Bank Bangkok Bank 30 23 35 29
14 Port FC Port FC 30 27 44 29
15 Royal Thai Fleet Royal Thai. 30 19 42 25
16 Customs United Customs 30 18 39 20
TEMPORADA 2006/2007
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Chonburi Chonburi 30 50 25 63
2 Krung Thai Bank Krung Thai. 30 40 24 54
3 Police Tero FC Police Tero 30 47 29 51
4 Bangkok United Bangkok 30 39 36 47
5 Royal Thai Fleet Royal Thai. 30 40 33 47
6 TTM Lopburi TTM Lopburi 30 43 42 44
7 Bangkok Bank Bangkok Bank 30 28 23 44
8 Buriram United Buriram 30 35 40 42
9 Super Power Samut Prakan Super Power 30 38 36 40
10 TOT TOT 30 35 35 37
11 Nakhon Pathom Nakhon 30 30 29 37
12 Port FC Port FC 30 36 43 36
13 Suphanburi Suphanburi 30 37 45 35
14 Thai Honda Thai Honda 30 26 38 29
15 Siam Navy Siam Navy 30 21 35 27
16 Police United Police 30 19 51 19
TEMPORADA 2005/2006
THAI LEAGUE
Equipo PJ GF GC Puntos
1 Bangkok United Bangkok 22 25 17 39
2 Osotsapa Osotsapa 22 35 20 38
3 Police Tero FC Police Tero 22 32 14 36
4 Chiangmai Chiangmai 22 30 24 35
5 Bangkok Bank Bangkok Bank 22 26 28 34
6 Royal Thai Fleet Royal Thai. 22 31 38 30
7 Thai Port Thai Port 22 21 28 28
8 Chonburi Chonburi 22 29 28 27
9 Krung Thai Bank Krung Thai. 22 22 26 25
10 Buriram United Buriram 22 23 32 22
11 Thai Honda Thai Honda 22 23 26 21
12 Suphanburi Suphanburi 22 18 34 16

  USO DE MEMORIA  
7,735,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1120
Total Execution Time  0.1135
  CADENA URL  
/historico/Chonburi
  GET DATOS  
$_GET['/historico/Chonburi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13511 AND type_rel = 2
0.0039  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 = '13511' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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.0030  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 = 13511 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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.0023  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.0023  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.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 `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.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 `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 = 37724 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 20616 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 9514 AND t.round = 34 ORDER BY team.conference 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 `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 = 3568 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2013` 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 = 2879 AND t.round = 34 ORDER BY team.conference 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 `tables2012` 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 = 8673 AND t.round = 34 ORDER BY team.conference 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 `tables2011` 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 = 8674 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2010` 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 = 8675 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2009` 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 = 8676 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2008` 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 = 8677 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 `tables2007` 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 = 8678 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2006` 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 = 23792 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC