4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del South Park FC
TEMPORADA 2023/2024
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Chertsey Town Chertsey 40 103 32 101
2 Marlow FC Marlow FC 40 106 49 89
3 Leatherhead Leatherhead 40 71 32 86
4 Westfield FC Westfield 40 81 50 83
5 Southall Southall 39 79 43 80
6 Raynes Park Vale Raynes Park 40 70 49 78
7 Hanworth Villa FC Hanworth 40 77 59 65
8 Thatcham Town Thatcham 40 72 62 62
9 South Park FC South Park 40 72 61 61
10 Hartley Wintney Hartley 40 64 79 55
11 Badshot Lea FC Badshot 40 65 70 54
12 Uxbridge Uxbridge 40 70 71 51
13 Ascot United Ascot United 40 56 67 45
14 Sutton Common Rovers Sutton 40 49 69 40
15 Northwood Northwood 40 69 75 39
16 Metropolitan Police Metropolitan 40 37 63 37
17 Ashford Town Ashford Town 40 42 70 36
18 Guernsey Guernsey 40 68 97 34
19 Binfield Binfield 40 59 109 34
20 Chipstead Chipstead 39 44 80 30
21 Corinthian-Casuals Corinthian-C 40 34 101 21
TEMPORADA 2022/2023
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Basingstoke Town Basingstoke 38 89 37 89
2 Walton & Hersham Walton 38 102 41 87
3 Marlow FC Marlow FC 38 64 45 67
4 Hanworth Villa FC Hanworth 38 58 50 66
5 Northwood Northwood 38 54 45 63
6 Binfield Binfield 38 63 51 57
7 Leatherhead Leatherhead 38 47 45 57
8 Chertsey Town Chertsey 38 67 52 56
9 South Park FC South Park 38 50 61 55
10 Southall Southall 38 50 48 52
11 Chipstead Chipstead 38 52 54 51
12 Westfield (Surrey) Westfield 38 54 50 49
13 Thatcham Town Thatcham 38 56 57 48
14 Uxbridge Uxbridge 38 53 55 44
15 Guernsey Guernsey 38 42 73 40
16 Ashford Town Ashford Town 38 46 91 38
17 Sutton Common Rovers Sutton 38 45 71 37
18 Merstham Merstham 38 43 66 36
19 Bedfont Sports Bedfont 38 50 62 35
20 Tooting and Mitcham Tooting 38 34 65 24
TEMPORADA 2021/2022
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Bracknell Town FC Bracknell 36 90 12 96
2 Chertsey Town Chertsey 36 81 40 76
3 Bedfont Sports Bedfont 36 86 47 74
4 Hanwell Town Hanwell Town 36 83 37 72
5 Basingstoke Town Basingstoke 36 65 49 70
6 Uxbridge Uxbridge 36 64 42 66
7 Marlow FC Marlow FC 36 52 40 61
8 Binfield Binfield 36 57 50 53
9 South Park FC South Park 36 67 53 51
10 Chipstead Chipstead 36 60 52 48
11 Northwood Northwood 36 51 67 42
12 Thatcham Town Thatcham 36 48 65 38
13 Ashford Town Ashford Town 36 42 60 38
14 Guernsey Guernsey 36 60 79 36
15 Tooting and Mitcham Tooting 36 42 56 34
16 Westfield (Surrey) Westfield 36 38 54 34
17 Sutton Common Rovers Sutton 36 46 82 34
18 Chalfont St Peter Chalfont 36 31 83 21
19 Staines Town Staines Town 36 32 127 14
20 Whyteleafe Whyteleafe 0 0 0 0
TEMPORADA 2020/2021
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Waltham Abbey Waltham 8 13 9 16
2 Staines Town Staines Town 8 17 17 16
3 Ware Ware 7 20 10 15
4 Tooting and Mitcham Tooting 7 12 3 15
5 Bracknell Town FC Bracknell 5 14 5 13
6 Chertsey Town Chertsey 7 14 9 13
7 Hanwell Town Hanwell Town 8 15 12 13
8 Ashford Town Ashford Town 8 8 8 13
9 Hertford Town Hertford 7 10 10 12
10 Marlow FC Marlow FC 7 16 8 11
11 Westfield (Surrey) Westfield 7 15 11 10
12 Barking Barking 7 9 9 10
13 Chipstead Chipstead 8 12 19 10
14 Bedfont Sports Bedfont 6 10 8 9
15 Chalfont St Peter Chalfont 8 6 10 9
16 FC Romania FC Romania 7 8 14 6
17 Uxbridge Uxbridge 6 5 11 5
18 South Park FC South Park 7 12 20 5
19 Northwood Northwood 8 7 19 4
20 Harlow Town Harlow Town 8 6 17 3
TEMPORADA 2019/2020
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Ware Ware 29 77 42 61
2 Hanwell Town Hanwell Town 28 72 32 58
3 Uxbridge Uxbridge 29 59 35 55
4 Chertsey Town Chertsey 28 74 40 52
5 Westfield (Surrey) Westfield 28 65 32 52
6 Bracknell Town FC Bracknell 26 63 33 50
7 Waltham Abbey Waltham 29 68 52 50
8 Tooting and Mitcham Tooting 27 53 29 47
9 Barking Barking 28 49 41 46
10 Chipstead Chipstead 28 53 40 45
11 Marlow FC Marlow FC 28 39 30 43
12 Bedfont Sports Bedfont 29 42 44 39
13 Chalfont St Peter Chalfont 30 45 59 37
14 Harlow Town Harlow Town 29 42 57 34
15 South Park FC South Park 26 37 52 27
16 Hertford Town Hertford 29 39 81 22
17 Ashford Town Ashford Town 29 30 70 20
18 Northwood Northwood 29 34 81 20
19 FC Romania FC Romania 28 35 84 16
20 Staines Town Staines Town 29 39 81 14
TEMPORADA 2018/2019
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Hayes & Yeading United Hayes 38 129 36 93
2 Cheshunt Cheshunt 38 79 43 76
3 Bracknell Town FC Bracknell 38 102 55 75
4 Marlow FC Marlow FC 38 66 37 73
5 Westfield (Surrey) Westfield 38 77 54 70
6 Tooting and Mitcham Tooting 38 66 52 65
7 Ware Ware 38 90 59 63
8 Hanwell Town Hanwell Town 38 71 65 60
9 Waltham Abbey Waltham 38 63 68 56
10 Northwood Northwood 38 65 71 54
11 Ashford Town Ashford Town 38 61 70 51
12 Bedfont Sports Bedfont 38 75 76 48
13 Chipstead Chipstead 38 54 63 45
14 Chalfont St Peter Chalfont 38 52 60 43
15 Uxbridge Uxbridge 38 50 71 42
16 FC Romania FC Romania 38 46 86 36
17 South Park FC South Park 38 47 92 33
18 Hertford Town Hertford 38 55 85 31
19 Molesey FC Molesey FC 38 36 76 28
20 Egham Town Egham Town 38 29 94 18
TEMPORADA 2017/2018
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Carshalton Athletic Carshalton 46 99 54 102
2 Lewes Lewes 46 93 38 99
3 Cray Wanderers Cray 46 112 46 89
4 Greenwich Borough Greenwich 46 99 47 87
5 Corinthian-Casuals Corinthian-C 46 86 47 87
6 Walton Casuals Walton 46 98 52 86
7 Hythe Town Hythe Town 46 92 63 86
8 Whyteleafe Whyteleafe 46 87 70 73
9 Hastings United Hastings 46 84 67 73
10 Thamesmead Town FC Thamesmead 46 103 81 72
11 Phoenix Sports Phoenix 46 79 68 69
12 Herne Bay Herne Bay 46 81 89 68
13 South Park FC South Park 46 79 91 63
14 Sittingbourne Sittingbourn 46 68 72 62
15 Horsham Horsham 46 71 90 56
16 Ramsgate Ramsgate 46 79 85 54
17 VCD Athletic Athletic 46 69 91 52
18 Guernsey Guernsey 46 65 98 49
19 Faversham Town Faversham 46 61 73 48
20 Chipstead Chipstead 46 64 78 46
21 Ashford United Ashford 46 60 111 38
22 East Grinstead Town East 46 63 128 36
23 Molesey FC Molesey FC 46 55 103 30
24 Shoreham FC Shoreham FC 46 33 138 8
TEMPORADA 2016/2017
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Tooting and Mitcham Tooting 46 120 54 105
2 Dorking Wanderers Dorking 46 103 44 105
3 Greenwich Borough Greenwich 46 102 52 95
4 Corinthian-Casuals Corinthian-C 46 99 59 93
5 Hastings United Hastings 46 128 64 82
6 Carshalton Athletic Carshalton 46 106 69 81
7 Hythe Town Hythe Town 46 87 65 78
8 South Park FC South Park 46 95 80 76
9 Lewes Lewes 46 88 75 76
10 Faversham Town Faversham 46 89 58 74
11 Cray Wanderers Cray 46 88 86 68
12 Ramsgate Ramsgate 46 79 75 65
13 Walton Casuals Walton 46 98 99 65
14 Whyteleafe Whyteleafe 46 81 75 64
15 Sittingbourne Sittingbourn 46 71 86 62
16 Horsham Horsham 46 79 80 61
17 Herne Bay Herne Bay 46 74 98 51
18 East Grinstead Town East 46 82 121 47
19 Molesey FC Molesey FC 46 61 116 43
20 Chipstead Chipstead 46 68 99 41
21 Guernsey Guernsey 46 66 112 38
22 Chatham Town Chatham Town 46 57 120 31
23 Three Bridges Three 46 59 114 29
24 Godalming Town Godalming 46 49 128 24
TEMPORADA 2015/2016
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Folkestone Invicta Folkestone 46 102 34 114
2 Dorking Wanderers Dorking 46 99 56 90
3 Worthing Worthing 46 96 56 88
4 Hythe Town Hythe Town 46 74 49 87
5 Corinthian-Casuals Corinthian-C 46 75 52 85
6 Faversham Town Faversham 46 76 45 83
7 Hastings United Hastings 46 99 64 81
8 Herne Bay Herne Bay 46 79 54 76
9 Ramsgate Ramsgate 46 93 76 73
10 Molesey FC Molesey FC 46 87 84 73
11 South Park FC South Park 46 78 71 72
12 Carshalton Athletic Carshalton 46 83 76 69
13 Guernsey Guernsey 46 94 88 68
14 Three Bridges Three 46 59 67 66
15 Whyteleafe Whyteleafe 46 69 77 62
16 Walton Casuals Walton 46 74 85 60
17 Tooting and Mitcham Tooting 46 66 71 58
18 Sittingbourne Sittingbourn 46 63 77 54
19 Chatham Town Chatham Town 46 61 70 46
20 East Grinstead Town East 46 56 84 44
21 Chipstead Chipstead 46 54 92 39
22 Walton & Hersham Walton 46 50 114 32
23 Whitstable Town Whitstable 46 54 118 29
24 Peacehaven & Telscombe Peacehaven 46 48 129 25
TEMPORADA 2014/2015
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Burgess Hill Town Burgess Hill 43 97 36 105
2 Faversham Town Faversham 43 103 49 91
3 Folkestone Invicta Folkestone 43 99 46 91
4 Merstham Merstham 43 98 50 84
5 Whyteleafe Whyteleafe 43 89 57 78
6 Worthing Worthing 43 86 59 70
7 Whitstable Town Whitstable 43 79 69 68
8 Three Bridges Three 43 87 89 66
9 Herne Bay Herne Bay 44 58 65 62
10 Guernsey Guernsey 42 86 90 59
11 South Park FC South Park 42 71 94 55
12 Tooting and Mitcham Tooting 43 69 63 53
13 Corinthian-Casuals Corinthian-C 42 59 75 53
14 Walton Casuals Walton 43 59 81 53
15 Hythe Town Hythe Town 43 77 73 50
16 Sittingbourne Sittingbourn 42 47 65 50
17 Carshalton Athletic Carshalton 43 58 70 48
18 Walton & Hersham Walton 43 53 70 48
19 Chipstead Chipstead 43 59 79 48
20 Hastings United Hastings 43 51 64 44
21 East Grinstead Town East 43 53 89 44
22 Ramsgate Ramsgate 42 51 80 40
23 Redhill Redhill 43 65 93 38
24 Horsham Horsham 43 47 95 36

  USO DE MEMORIA  
6,905,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5045
Total Execution Time  0.5057
  CADENA URL  
/historico/South-Park-Fc
  GET DATOS  
$_GET['/historico/South-Park-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0118  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 = 'South-Park-Fc' 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.0105  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=10382 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=10382 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=10382 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=10382 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10382 AND type_rel = 2
0.0135  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 = '10382' ORDER BY l.year DESC,cat.coefficient DESC
0.0137  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 = '10382' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0124  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 = '10382' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0123  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=10382 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0109  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 (72977,72728,72677) 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.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 72977 AND teamId = 10382
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 10382
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 10382
0.0108  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 = '10382' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10382' and rp.type = 4
0.0108  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 = '10382' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0108  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 = 72977 WHERE rp.league_id = 72977 AND rp.teamId = 10382 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.0108  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 = 72977 WHERE rp.league_id = 72977 AND rp.teamId = 10382 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 72977 WHERE rp.league_id = 72977 AND rp.teamId = 10382 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 10382 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0219  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 = 68455 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0221  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 = 63529 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 58740 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122  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 = 50967 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.0227  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 = 44457 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0235  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 = 39169 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0219  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 = 33753 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0214  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 = 15614 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 4398 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC