4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hythe Town
TEMPORADA 2019/2020
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Hastings United Hastings 28 53 21 62
2 Ashford United Ashford 30 75 41 59
3 Whitehawk Whitehawk 28 61 33 56
4 Cray Valley PM Cray Valley 27 50 27 54
5 Herne Bay Herne Bay 28 53 40 51
6 Chichester City Chichester 25 46 34 45
7 Whyteleafe Whyteleafe 27 45 37 45
8 VCD Athletic Athletic 30 48 53 42
9 Sevenoaks Town Sevenoaks 29 43 37 41
10 Hythe Town Hythe Town 29 34 37 40
11 Phoenix Sports Phoenix 26 43 40 38
12 Haywards Heath Town Haywards 26 32 32 36
13 Guernsey Guernsey 28 39 47 36
14 Whitstable Town Whitstable 28 38 41 35
15 Burgess Hill Town Burgess Hill 27 47 60 31
16 Sittingbourne Sittingbourn 28 31 39 28
17 Faversham Town Faversham 29 29 46 28
18 Ramsgate Ramsgate 30 35 68 20
19 Three Bridges Three 28 33 66 17
20 East Grinstead Town East 25 23 59 9
TEMPORADA 2018/2019
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Cray Wanderers Cray 36 79 35 82
2 Horsham Horsham 36 73 38 74
3 Hastings United Hastings 36 78 45 70
4 Ashford United Ashford 36 74 36 68
5 Haywards Heath Town Haywards 36 65 52 63
6 VCD Athletic Athletic 36 74 66 62
7 Hythe Town Hythe Town 36 66 59 52
8 Whyteleafe Whyteleafe 36 59 51 49
9 Phoenix Sports Phoenix 36 65 65 49
10 Sevenoaks Town Sevenoaks 36 49 54 47
11 Ramsgate Ramsgate 36 54 53 45
12 Whitstable Town Whitstable 36 36 55 43
13 East Grinstead Town East 36 65 72 41
14 Three Bridges Three 36 51 69 41
15 Herne Bay Herne Bay 36 65 85 38
16 Sittingbourne Sittingbourn 36 49 72 37
17 Faversham Town Faversham 36 55 85 37
18 Guernsey Guernsey 36 50 77 30
19 Greenwich Borough Greenwich 36 40 78 30
20 Thamesmead Town FC Thamesmead 0 0 0 0
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
TEMPORADA 2013/2014
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Peacehaven & Telscombe Peacehaven 46 128 55 107
2 Leatherhead Leatherhead 46 93 46 92
3 Folkestone Invicta Folkestone 46 96 61 86
4 Guernsey Guernsey 46 92 65 81
5 Burgess Hill Town Burgess Hill 46 93 65 80
6 Hastings United Hastings 46 72 64 77
7 Merstham Merstham 46 81 63 76
8 Hythe Town Hythe Town 46 85 76 70
9 Walton Casuals Walton 46 89 93 70
10 Faversham Town Faversham 46 78 69 68
11 Tooting BEC Tooting BEC 46 79 75 63
12 Ramsgate Ramsgate 46 84 79 62
13 Chipstead Chipstead 46 79 82 62
14 Sittingbourne Sittingbourn 46 69 75 61
15 Worthing Worthing 46 80 98 59
16 Horsham Horsham 46 68 72 59
17 Corinthian-Casuals Corinthian-C 46 69 73 55
18 Herne Bay Herne Bay 46 69 72 54
19 Three Bridges Three 46 71 88 53
20 Whitstable Town Whitstable 46 61 78 53
21 Walton Walton 46 75 92 51
22 Redhill Redhill 46 72 96 45
23 Crawley Down Gatwick Crawley Down 46 51 139 33
24 Eastbourne Town Eastbourne 46 62 120 30
TEMPORADA 2012/2013
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Dulwich Hamlet FC Dulwich 42 91 42 89
2 Maidstone United Maidstone 42 96 39 88
3 Faversham Town Faversham 42 74 57 77
4 Hythe Town Hythe Town 42 78 55 76
5 Folkestone Invicta Folkestone 42 73 49 71
6 Leatherhead Leatherhead 42 66 44 70
7 Ramsgate Ramsgate 42 60 44 70
8 Burgess Hill Town Burgess Hill 42 54 46 63
9 Sittingbourne Sittingbourn 42 67 56 61
10 Worthing Worthing 42 77 74 57
11 Eastbourne Town Eastbourne 42 62 61 57
12 Merstham Merstham 42 67 76 56
13 Crawley Down Gatwick Crawley Down 42 72 70 55
14 Corinthian-Casuals Corinthian-C 42 39 54 46
15 Horsham Horsham 42 54 77 45
16 Tooting and Mitcham Tooting 42 52 75 45
17 Whitstable Town Whitstable 42 53 71 44
18 Walton & Hersham Walton 42 48 78 44
19 Herne Bay Herne Bay 42 45 69 43
20 Chipstead Chipstead 42 54 80 42
21 Three Bridges Three 42 58 83 40
22 Walton Casuals Walton 42 50 90 37
TEMPORADA 2011/2012
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Whitehawk Whitehawk 40 82 26 93
2 Bognor Regis Town Bognor Regis 40 105 38 88
3 Dulwich Hamlet FC Dulwich 40 73 26 86
4 Folkestone Invicta Folkestone 40 82 53 76
5 Godalming Town Godalming 40 77 53 73
6 Maidstone United Maidstone 40 68 50 67
7 Worthing Worthing 40 69 45 64
8 Hythe Town Hythe Town 40 62 62 59
9 Merstham Merstham 40 63 69 59
10 Chipstead Chipstead 40 59 57 56
11 Ramsgate Ramsgate 40 61 73 55
12 Walton & Hersham Walton 40 54 52 50
13 Corinthian-Casuals Corinthian-C 40 49 63 48
14 Eastbourne Town Eastbourne 40 49 63 46
15 Walton Casuals Walton 40 51 74 42
16 Crawley Down Gatwick Crawley Down 40 65 81 41
17 Faversham Town Faversham 40 43 67 40
18 Whitstable Town Whitstable 40 46 87 40
19 Burgess Hill Town Burgess Hill 40 39 90 33
20 Sittingbourne Sittingbourn 40 36 75 30
21 Whyteleafe Whyteleafe 40 38 67 28
22 Croydon Athletic Croydon 0 0 0 0

  USO DE MEMORIA  
6,776,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6787
Total Execution Time  0.6799
  CADENA URL  
/historico/Hythe-Town/2020
  GET DATOS  
$_GET['/historico/Hythe-Town/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0183  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 = 'Hythe-Town' AND l.year = 2020 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=5502 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=5502 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=5502 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=5502 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0259  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 = 50968
0.0156  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 = 50579
0.0154  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 = 50606
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5502 AND type_rel = 2
0.0155  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 = '5502' ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '5502' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '5502' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0243  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 = 50579 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0177  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 = 50606 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  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 = 50968 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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=5502 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0135  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 (58741,58520,58519,56547) 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 = 58741 AND teamId = 5502
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 58520 AND teamId = 5502
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 58519 AND teamId = 5502
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 5502
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 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 = 50968 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '5502' 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 = '5502' and rp.type = 4
0.0129  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 = '5502' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2020 e ON e.player_id = p.id AND e.league_id = 50968 WHERE rp.league_id = 50968 AND rp.teamId = 5502 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.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 events2020 e ON e.player_id = p.id AND e.league_id = 50968 WHERE rp.league_id = 50968 AND rp.teamId = 5502 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 events2020 e ON e.player_id = p.id AND e.league_id = 50968 WHERE rp.league_id = 50968 AND rp.teamId = 5502 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 5502 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  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 = 50968 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 = 44458 AND t.round = 38 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 `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.0137  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.0132  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.0137  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
0.0163  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 = 3490 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 24865 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 24890 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 50968 ORDER BY nameShow LIMIT 100