4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Raj Pracha
TEMPORADA 2023/2024
THAI LEAGUE 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Pathum Thani University Pathum Thani 20 51 16 42
2 Raj Pracha Raj Pracha 20 41 15 40
3 Ang Thong Ang Thong 20 42 20 40
4 Saraburi United Saraburi 20 39 22 36
5 Lopburi City Lopburi City 20 35 16 34
6 Kanchanaburi City Kanchanaburi 20 31 17 32
7 Hua Hin Maraleina Maraleina 20 40 20 27
8 Thap Luang United Thap Luang. 20 20 27 22
9 Assumption United Assumption 20 24 35 19
10 Hua Hin City City 20 24 38 13
11 Chainat United Chainat 20 5 126 0
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 2
Equipo PJ GF GC Puntos
1 Lamphun Warrior Lamphun 34 66 30 74
2 Sukhothai Sukhothai 34 78 44 73
3 Trat FC Trat FC 34 55 33 68
4 Lampang Lampang 34 67 38 57
5 Chainat Hornbill Chainat 34 58 46 57
6 Phrae United Phrae United 34 51 35 54
7 Muangkan Muangkan 34 70 62 52
8 Udon Thani Udon Thani 34 53 58 47
9 Rayong FC Rayong FC 34 45 41 46
10 Nakhon Pathom Nakhon 34 42 47 42
11 Ayutthaya United Ayutthaya 34 40 50 41
12 Ranong Ranong 34 35 45 41
13 Kasetsart Kasetsart 34 32 47 39
14 Chiangmai Chiangmai 34 39 55 38
15 Customs Ladkrabang Customs 34 44 63 35
16 Raj Pracha Raj Pracha 34 34 44 33
17 Khonkaen Khonkaen 34 32 60 24
18 Siam Navy Siam Navy 34 28 71 11
TEMPORADA 2020/2021
THAI LEAGUE 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Lamphun Warrior Lamphun 5 8 5 12
2 Udon United Udon United 5 8 3 10
3 Cha Choeng Sao Choeng 5 11 5 9
4 Rayong United Rayong 5 10 5 7
5 Phitsanulok Phitsanulok 5 2 8 4
6 Muang Loei United Muang Loei. 5 2 15 1
7 Muangkan Muangkan 5 7 1 11
8 Raj Pracha Raj Pracha 5 10 5 10
9 Krabi Krabi 5 6 6 7
10 Songkhla Songkhla 5 6 10 5
11 North Bangkok North 5 3 5 4
12 Bangkok Bangkok 5 7 12 4
TEMPORADA 2019/2020
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Bangkok Bangkok 2 6 1 6
2 North Bangkok North 2 2 0 4
3 Pattani Pattani 2 4 3 4
4 Pathum Thani University Pathum Thani 2 2 1 4
5 Trang Trang 2 2 1 4
6 Kasem Bundit Kasem Bundit 2 5 3 3
7 Raj Pracha Raj Pracha 2 2 2 3
8 Krabi Krabi 2 1 2 1
9 Nakhon Si United Nakhon 2 1 2 1
10 Nara United Nara United 2 0 1 1
11 BTU United BTU United 2 2 4 1
12 Banbueng Banbueng 2 1 8 0
TEMPORADA 2018/2019
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Nakhon Pathom Nakhon 26 57 18 61
2 Ranong Ranong 26 45 20 50
3 Nara United Nara United 26 42 26 44
4 Trang Trang 26 31 27 41
5 Phuket City Phuket City 26 34 35 40
6 North Bangkok North 26 28 21 37
7 Krabi Krabi 26 34 29 36
8 Kasem Bundit Kasem Bundit 26 36 36 35
9 BTU United BTU United 26 36 31 33
10 Nakhon Si United Nakhon 26 29 38 32
11 Chamchuri United Chamchuri 26 33 42 29
12 Raj Pracha Raj Pracha 26 19 33 27
13 Army FC Army FC 26 29 45 19
14 Surat Thani Surat Thani 26 20 72 8
TEMPORADA 2017/2018
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Customs United Customs 26 43 23 54
2 Nara United Nara United 26 45 18 50
3 Trang Trang 26 34 16 50
4 Chamchuri United Chamchuri 26 32 27 41
5 Banbung United Banbung 26 29 23 40
6 BTU United BTU United 26 38 32 38
7 Army FC Army FC 26 30 31 35
8 Nakhon Si United Nakhon 26 31 31 34
9 Ranong Ranong 26 30 33 31
10 Surat Thani Surat Thani 26 34 49 26
11 Kasem Bundit Kasem Bundit 26 26 33 25
12 Bangkok U. Deffo Bangkok 26 24 36 23
13 Raj Pracha Raj Pracha 26 25 42 23
14 Simork Simork 26 30 57 23
TEMPORADA 2016/2017
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Samut Sakhon FC Samut Sakhon 28 54 25 65
2 Trang Trang 28 47 19 61
3 Bangkok U. Deffo Bangkok 28 49 32 50
4 Army FC Army FC 28 46 39 45
5 Nara United Nara United 28 39 28 44
6 Ranong Ranong 28 36 34 42
7 Chamchuri United Chamchuri 28 50 38 42
8 Nakhon Si United Nakhon 28 25 30 38
9 Customs United Customs 28 32 40 35
10 Banbung United Banbung 28 29 48 30
11 Surat Thani Surat Thani 28 34 40 30
12 Kasem Bundit Kasem Bundit 28 40 48 30
13 Simork Simork 28 31 42 27
14 Raj Pracha Raj Pracha 28 26 52 22
15 Krung Thonburi Krung 28 43 66 21
TEMPORADA 2015/2016
SEGUNDA TAILANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Raj Pracha Raj Pracha 18 27 5 37
2 Customs United Customs 18 34 13 33
3 Banbung United Banbung 18 30 19 32
4 Kasem Bundit Kasem Bundit 18 32 24 30
5 Look Esan Look Esan 18 25 24 24
6 Samut Prakan United Samut Prakan 18 26 31 22
7 Pattaya FC Pattaya FC 18 16 35 19
8 Royal Thai Fleet Royal Thai. 18 14 26 17
9 Pathum Thani United Pathum Thani 18 22 35 17
10 Sinthana Kabinburi Sinthana 18 15 29 14
11 Inter Pattaya Inter 0 0 0 0
TEMPORADA 2014/2015
SEGUNDA TAILANDIA GRUPO 3
Equipo PJ GF GC Puntos
1 Samut Sakhon FC Samut Sakhon 24 42 16 52
2 Simork Simork 24 40 16 51
3 Thonburi City Thonburi 24 42 21 51
4 Hua Hin City City 24 38 22 42
5 Krung Thonburi Krung 24 25 15 42
6 Raj Pracha Raj Pracha 24 35 22 39
7 JW Police JW Police 24 34 40 30
8 Phetchaburi Phetchaburi 24 24 31 28
9 Looktabfah Looktabfah 24 23 31 23
10 Pathum Thani Seeker Pathum Thani 24 19 47 21
11 Ratchaphruek College Ratchaphruek 24 22 39 19
12 Globlex Globlex 24 28 45 18
13 Nonthaburi Nonthaburi 24 20 47 14
TEMPORADA 2013/2014
SEGUNDA TAILANDIA GRUPO 4
Equipo PJ GF GC Puntos
1 Hua Hin City City 26 45 19 51
2 Phetchaburi Phetchaburi 26 37 23 49
3 Muangkan Muangkan 26 31 16 48
4 Samut Sakhon FC Samut Sakhon 26 38 29 48
5 Singburi Singburi 26 42 38 42
6 Looktabfah Looktabfah 26 41 30 37
7 Ratchaphruek College Ratchaphruek 26 40 38 37
8 Thonburi City Thonburi 26 28 29 33
9 Krung Thonburi Krung 26 20 23 33
10 Raj Pracha Raj Pracha 26 34 43 29
11 Nonthaburi Nonthaburi 26 23 31 27
12 JW Police JW Police 26 23 39 23
13 Globlex Globlex 26 26 45 20
14 Futera Seeker Futera 26 30 55 18
TEMPORADA 2011/2012
THAI LEAGUE 2
Equipo PJ GF GC Puntos
1 Ratchaburi Ratchaburi 34 85 31 78
2 Suphanburi Suphanburi 34 58 17 75
3 Bangkok United Bangkok 34 57 29 74
4 Taweewattana Taweewattana 34 70 41 67
5 PTT Rayong PTT Rayong 34 62 33 62
6 Krabi Krabi 34 49 28 57
7 Siam Navy Siam Navy 34 54 42 50
8 Nakhon Ratchasima Nakhon 34 42 46 47
9 Air Force Central Force 34 45 45 44
10 Bangkok Bangkok 34 62 57 42
11 Khonkaen Khonkaen 34 36 50 42
12 Saraburi Saraburi 34 49 53 41
13 Phuket Phuket 34 41 48 40
14 Songkhala FC Songkhala 34 38 51 37
15 Phattalung Phattalung 34 38 59 34
16 Rangsit JW Rangsit JW 34 36 65 31
17 Raj Pracha Raj Pracha 34 33 66 25
18 Chanthaburi Chanthaburi 34 21 115 4
TEMPORADA 2010/2011
THAI LEAGUE 2
Equipo PJ GF GC Puntos
1 Songkhla United Songkhla 34 84 18 83
2 Chainat Hornbill Chainat 34 68 42 66
3 BBCU BBCU 34 39 25 63
4 PTT Rayong PTT Rayong 34 54 28 59
5 Songkhala FC Songkhala 34 54 39 56
6 Bangkok United Bangkok 34 54 49 51
7 Saraburi Saraburi 34 41 31 50
8 Raj Pracha Raj Pracha 34 40 54 46
9 Phuket Phuket 34 45 47 45
10 Suphanburi Suphanburi 34 40 37 44
11 Bangkok Bangkok 34 56 63 42
12 Chanthaburi Chanthaburi 34 39 48 41
13 Rangsit JW Rangsit JW 34 31 42 40
14 Air Force Central Force 34 36 53 40
15 Customs United Customs 34 41 55 36
16 Chiangmai Chiangmai 34 36 55 30
17 RBAC Mittraphap RBAC 34 25 61 25
18 Thai Honda Thai Honda 34 33 69 24
TEMPORADA 2009/2010
THAI LEAGUE 2
Equipo PJ GF GC Puntos
1 Taweewattana Taweewattana 30 62 33 62
2 Khonkaen Khonkaen 30 51 35 54
3 Chiangrai United Chiangrai 30 44 32 53
4 Nakhon Pathom Nakhon 30 55 36 51
5 Songkhala FC Songkhala 30 47 34 51
6 Air Force Central Force 30 48 33 48
7 Customs United Customs 30 42 37 45
8 Thai Honda Thai Honda 30 32 32 40
9 Raj Pracha Raj Pracha 30 33 40 39
10 BBCU BBCU 30 59 48 38
11 PTT Rayong PTT Rayong 30 47 51 38
12 Chanthaburi Chanthaburi 30 38 40 37
13 Rayong United Rayong 30 29 36 35
14 RBAC Mittraphap RBAC 30 35 65 27
15 Suphanburi Suphanburi 30 31 53 23
16 Narathiwat Narathiwat 30 16 64 15

  USO DE MEMORIA  
6,683,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5922
Total Execution Time  0.5934
  CADENA URL  
/historico/Raj-Pracha
  GET DATOS  
$_GET['/historico/Raj-Pracha']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62120 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1929 AND type_rel = 3
0.0153  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 = '62120' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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=62120 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (74102,74095,73915,68168,67320) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 68168 AND teamId = 62120
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 74102 AND teamId = 62120
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 74095 AND teamId = 62120
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73915 AND teamId = 62120
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 62120
0.0146  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 = '62120' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62120' and rp.type = 4
0.0146  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 = '62120' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 = 74102 WHERE rp.league_id = 74102 AND rp.teamId = 62120 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.0146  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 = 74102 WHERE rp.league_id = 74102 AND rp.teamId = 62120 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 74102 WHERE rp.league_id = 74102 AND rp.teamId = 62120 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 62120 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148  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 = 74102 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.0291  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.0151  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 = 64197 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.0148  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 = 60181 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.0147  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 = 61193 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.0147  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 = 55382 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 48916 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 42645 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 20618 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 9734 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 16124 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 16117 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 16116 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 16115 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC