4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Needham Market
TEMPORADA 2023/2024
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 AFC Telford United Telford 42 76 34 86
2 Needham Market Needham 41 74 36 85
3 Mickleover Sports FC Mickleover 41 79 43 84
4 Leamington Leamington 41 62 33 72
5 Redditch United Redditch 41 65 54 70
6 Stratford Town Stratford 41 69 60 69
7 Stamford Stamford 41 83 61 67
8 St Ives Town Ives Town 42 91 72 64
9 Halesowen Town Halesowen 41 55 52 62
10 Royston Town Royston Town 41 63 62 57
11 Coalville Town Coalville 41 69 61 55
12 Leiston Leiston 41 59 71 55
13 Barwell Barwell 41 66 66 54
14 Stourbridge Stourbridge 40 52 50 52
15 Kettering Town Kettering 41 49 76 48
16 AFC Sudbury AFC Sudbury 42 58 64 46
17 Alvechurch FC Alvechurch 41 51 73 45
18 Bromsgrove Sporting Bromsgrove 41 44 53 44
19 Hitchin Town Hitchin Town 42 51 66 43
20 Nuneaton Town Nuneaton 24 33 39 34
21 Berkhamsted Berkhamsted 41 33 85 24
22 Long Eaton United Long Eaton. 41 40 111 22
TEMPORADA 2022/2023
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Tamworth Tamworth 42 93 40 89
2 Coalville Town Coalville 42 92 42 89
3 Leiston Leiston 42 84 47 85
4 Nuneaton Town Nuneaton 42 67 45 79
5 Rushall Olympic Rushall 42 71 52 73
6 Mickleover Sports FC Mickleover 42 82 66 72
7 Ilkeston Town FC Ilkeston 42 79 66 61
8 Barwell Barwell 42 69 63 61
9 Redditch United Redditch 42 57 59 61
10 Stourbridge Stourbridge 42 69 56 59
11 Alvechurch FC Alvechurch 42 63 65 59
12 Hitchin Town Hitchin Town 42 52 60 59
13 Royston Town Royston Town 42 63 73 55
14 Stratford Town Stratford 42 58 70 52
15 Basford United Basford 42 49 62 52
16 St Ives Town Ives Town 42 64 72 50
17 Needham Market Needham 42 46 54 48
18 Bromsgrove Sporting Bromsgrove 42 58 78 48
19 Kings Langley Kings 42 45 69 39
20 Hednesford Town Hednesford 42 45 76 31
21 Rushden & Diamonds Rushden 42 40 87 31
22 Bedford Town Bedford Town 42 49 93 30
TEMPORADA 2021/2022
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Banbury United Banbury 40 92 32 102
2 Peterborough Sports Peterborough 40 94 46 79
3 Coalville Town Coalville 40 86 47 78
4 Rushall Olympic Rushall 40 80 54 69
5 Alvechurch FC Alvechurch 40 57 41 65
6 Rushden & Diamonds Rushden 40 57 49 65
7 Leiston Leiston 40 59 65 60
8 Royston Town Royston Town 40 65 51 59
9 Hednesford Town Hednesford 40 66 64 54
10 Tamworth Tamworth 40 58 58 54
11 Stourbridge Stourbridge 40 61 71 53
12 Needham Market Needham 40 66 69 49
13 Stratford Town Stratford 40 48 70 47
14 St Ives Town Ives Town 40 57 90 47
15 Redditch United Redditch 40 38 50 45
16 Nuneaton Town Nuneaton 40 51 62 42
17 Hitchin Town Hitchin Town 40 47 58 42
18 Bromsgrove Sporting Bromsgrove 40 36 59 42
19 Barwell Barwell 40 57 78 41
20 Biggleswade Town Biggleswade 40 47 64 34
21 Lowestoft Town Lowestoft 40 49 93 33
TEMPORADA 2020/2021
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Coalville Town Coalville 7 21 5 17
2 Needham Market Needham 7 17 7 17
3 Stratford Town Stratford 8 17 16 15
4 Rushall Olympic Rushall 8 14 12 13
5 Tamworth Tamworth 7 13 8 12
6 Redditch United Redditch 8 14 11 12
7 Royston Town Royston Town 8 12 11 11
8 Kings Langley Kings 9 11 11 11
9 Stourbridge Stourbridge 7 8 5 10
10 Hitchin Town Hitchin Town 7 12 14 10
11 St Ives Town Ives Town 6 11 13 10
12 Peterborough Sports Peterborough 6 10 5 9
13 Rushden & Diamonds Rushden 7 14 11 9
14 Lowestoft Town Lowestoft 7 8 9 9
15 Nuneaton Town Nuneaton 8 14 13 8
16 Alvechurch FC Alvechurch 9 12 16 8
17 Banbury United Banbury 7 9 13 8
18 Bromsgrove Sporting Bromsgrove 8 9 17 8
19 Hednesford Town Hednesford 8 12 16 7
20 Biggleswade Town Biggleswade 7 11 15 7
21 Leiston Leiston 8 11 21 5
22 Barwell Barwell 7 6 17 4
TEMPORADA 2019/2020
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Tamworth Tamworth 30 63 27 65
2 Peterborough Sports Peterborough 32 87 43 64
3 Royston Town Royston Town 30 62 28 63
4 Bromsgrove Sporting Bromsgrove 32 80 43 57
5 Rushall Olympic Rushall 33 58 43 53
6 Banbury United Banbury 32 48 31 52
7 Coalville Town Coalville 30 51 32 51
8 Nuneaton Town Nuneaton 33 57 46 50
9 Kings Langley Kings 30 51 41 50
10 Stourbridge Stourbridge 31 50 52 50
11 Rushden & Diamonds Rushden 29 49 43 49
12 Barwell Barwell 32 58 53 48
13 Hednesford Town Hednesford 31 47 41 46
14 Needham Market Needham 32 41 39 45
15 Lowestoft Town Lowestoft 32 48 60 41
16 Biggleswade Town Biggleswade 29 42 46 40
17 Hitchin Town Hitchin Town 32 43 49 39
18 Stratford Town Stratford 33 42 74 28
19 Leiston Leiston 32 39 87 26
20 St Ives Town Ives Town 33 33 76 23
21 Alvechurch FC Alvechurch 29 25 55 17
22 Redditch United Redditch 33 24 89 12
TEMPORADA 2018/2019
NON LEAGUE PREMIER GRUPO 2
Equipo PJ GF GC Puntos
1 Kettering Town Kettering 42 84 41 94
2 Kings Lynn Town Kings Lynn. 42 80 41 80
3 Stourbridge Stourbridge 42 79 40 78
4 Alvechurch FC Alvechurch 42 66 53 73
5 Stratford Town Stratford 42 55 49 72
6 Coalville Town Coalville 42 78 66 67
7 Biggleswade Town Biggleswade 42 67 54 66
8 Rushall Olympic Rushall 42 56 49 62
9 Rushden & Diamonds Rushden 42 60 49 61
10 Royston Town Royston Town 42 59 53 61
11 Needham Market Needham 42 68 65 60
12 Tamworth Tamworth 42 64 46 58
13 St Ives Town Ives Town 42 36 43 55
14 Banbury United Banbury 42 53 55 53
15 Lowestoft Town Lowestoft 42 55 60 51
16 Redditch United Redditch 42 63 79 50
17 Barwell Barwell 42 55 55 49
18 Hitchin Town Hitchin Town 42 50 71 48
19 Leiston Leiston 42 54 73 47
20 St. Neots Town Neots Town 42 32 73 36
21 Halesowen Town Halesowen 42 26 66 32
22 Bedworth United Bedworth 42 32 91 19
TEMPORADA 2017/2018
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Billericay Town Billericay 46 110 50 99
2 Dulwich Hamlet FC Dulwich 46 91 41 95
3 Hendon Hendon 46 96 59 85
4 Folkestone Invicta Folkestone 46 104 71 85
5 Leiston Leiston 46 82 53 79
6 Leatherhead Leatherhead 46 68 49 79
7 Margate Margate 46 77 53 77
8 Staines Town Staines Town 46 106 83 75
9 Wingate & Finchley Wingate 46 63 71 69
10 Metropolitan Police Metropolitan 46 76 71 66
11 Tonbridge Angels Tonbridge 46 58 63 64
12 Harrow Borough Harrow 46 69 76 63
13 Kingstonian Kingstonian 46 57 70 59
14 Dorking Wanderers Dorking 46 77 80 58
15 Thurrock Thurrock 46 68 79 57
16 Worthing Worthing 46 71 84 57
17 Enfield Town Enfield Town 46 72 80 56
18 Merstham Merstham 46 69 80 56
19 Needham Market Needham 46 65 84 49
20 Brightlingsea Regent Brightlingse 46 67 89 48
21 Harlow Town Harlow Town 46 55 88 47
22 Lowestoft Town Lowestoft 46 52 92 43
23 Burgess Hill Town Burgess Hill 46 64 102 36
24 Tooting and Mitcham Tooting 46 52 101 36
TEMPORADA 2016/2017
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Havant & Waterlooville Havant 46 88 43 94
2 Bognor Regis Town Bognor Regis 46 87 42 90
3 Dulwich Hamlet FC Dulwich 46 89 55 80
4 Enfield Town Enfield Town 46 86 57 76
5 Wingate & Finchley Wingate 46 63 61 75
6 Leiston Leiston 46 99 66 74
7 Tonbridge Angels Tonbridge 46 66 55 74
8 Billericay Town Billericay 46 77 56 72
9 Needham Market Needham 46 76 80 72
10 Harlow Town Harlow Town 46 78 73 67
11 Lowestoft Town Lowestoft 46 64 72 65
12 Leatherhead Leatherhead 46 73 74 60
13 Staines Town Staines Town 46 77 69 59
14 Merstham Merstham 46 70 72 56
15 Worthing Worthing 46 74 85 56
16 Folkestone Invicta Folkestone 46 75 82 55
17 Kingstonian Kingstonian 46 65 73 55
18 Metropolitan Police Metropolitan 46 54 72 54
19 Hendon Hendon 46 68 88 54
20 Burgess Hill Town Burgess Hill 46 59 80 54
21 Harrow Borough Harrow 46 60 80 53
22 Canvey Island Canvey 46 63 93 52
23 AFC Sudbury AFC Sudbury 46 57 85 46
24 Grays Athletic Grays 46 46 101 38
TEMPORADA 2015/2016
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Hampton & Richmond Hampton 46 105 52 95
2 Bognor Regis Town Bognor Regis 46 95 42 94
3 East Thurrock United FC East 46 107 53 91
4 Tonbridge Angels Tonbridge 46 90 49 85
5 Dulwich Hamlet FC Dulwich 46 93 58 81
6 Enfield Town Enfield Town 46 74 47 80
7 Kingstonian Kingstonian 46 78 64 73
8 Leiston Leiston 46 72 57 72
9 Billericay Town Billericay 46 76 53 71
10 Merstham Merstham 46 74 80 62
11 Leatherhead Leatherhead 46 67 81 62
12 Metropolitan Police Metropolitan 46 60 79 61
13 Wingate & Finchley Wingate 46 66 70 60
14 Canvey Island Canvey 46 69 89 60
15 Grays Athletic Grays 46 63 75 56
16 Staines Town Staines Town 46 53 74 55
17 Harrow Borough Harrow 46 66 80 54
18 Farnborough Farnborough 46 65 88 53
19 Needham Market Needham 46 52 76 53
20 Hendon Hendon 46 68 85 52
21 Burgess Hill Town Burgess Hill 46 57 73 50
22 Brentwood Town Brentwood 46 51 80 40
23 Lewes Lewes 46 48 87 34
24 VCD Athletic Athletic 46 46 103 34
TEMPORADA 2014/2015
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Needham Market Needham 41 90 38 95
2 Harlow Town Harlow Town 41 99 51 93
3 AFC Sudbury AFC Sudbury 41 74 45 80
4 Brentwood Town Brentwood 40 73 54 78
5 Wroxham Wroxham 41 92 50 76
6 Thurrock Thurrock 42 90 50 75
7 Dereham Town Dereham Town 41 77 58 73
8 Brightlingsea Regent Brightlingse 41 72 50 70
9 Ware Ware 41 70 52 60
10 Aveley Aveley 41 72 67 60
11 Tilbury Tilbury 41 59 65 56
12 Soham Town Rangers Soham Town. 41 68 79 56
13 Heybridge Swifts Heybridge 42 64 73 55
14 Thamesmead Town FC Thamesmead 41 54 62 51
15 Waltham Abbey Waltham 40 69 74 49
16 Great Wakering Rovers Great 41 75 79 48
17 Cheshunt Cheshunt 41 59 73 48
18 Maldon & Tiptree Maldon 41 53 70 45
19 Redbridge Redbridge 41 59 96 41
20 Chatham Town Chatham Town 41 45 64 40
21 Romford Romford 41 61 86 39
22 Barkingside Barkingside 40 50 84 37
23 Cray Wanderers Cray 40 58 83 34
24 Burnham Ramblers Burnham 41 47 127 18
TEMPORADA 2013/2014
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 VCD Athletic Athletic 46 115 54 99
2 Witham Town Witham Town 46 109 54 98
3 Heybridge Swifts Heybridge 46 108 59 93
4 Harlow Town Harlow Town 46 105 59 91
5 Thurrock Thurrock 46 99 60 87
6 Needham Market Needham 46 85 44 87
7 Dereham Town Dereham Town 46 98 65 77
8 Soham Town Rangers Soham Town. 46 92 75 76
9 AFC Sudbury AFC Sudbury 46 76 63 76
10 Maldon & Tiptree Maldon 46 82 68 76
11 Romford Romford 46 76 69 68
12 Chatham Town Chatham Town 46 74 76 68
13 Aveley Aveley 46 81 81 65
14 Redbridge Redbridge 46 78 84 59
15 Cheshunt Cheshunt 46 74 75 53
16 Burnham Ramblers Burnham 46 69 100 52
17 Waltham Abbey Waltham 46 71 89 50
18 Tilbury Tilbury 46 55 75 50
19 Brentwood Town Brentwood 46 72 91 49
20 Barkingside Barkingside 46 76 120 46
21 Ware Ware 46 73 93 45
22 Wroxham Wroxham 46 77 123 36
23 Walthamstow Walthamstow 46 43 118 25
24 Erith & Belvedere Erith 46 44 137 22
TEMPORADA 2012/2013
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Grays Athletic Grays 42 96 38 102
2 Maldon & Tiptree Maldon 42 101 48 89
3 Thamesmead Town FC Thamesmead 42 85 49 88
4 Witham Town Witham Town 42 71 47 79
5 Aveley Aveley 42 92 58 78
6 Heybridge Swifts Heybridge 42 102 55 73
7 Soham Town Rangers Soham Town. 42 95 75 73
8 Romford Romford 42 72 72 64
9 Tilbury Tilbury 42 69 62 63
10 Brentwood Town Brentwood 42 63 62 59
11 Cheshunt Cheshunt 42 75 73 58
12 Potters Bar Town Potters Town 42 64 68 58
13 Waltham Abbey Waltham 42 60 70 53
14 Chatham Town Chatham Town 42 59 65 52
15 Wroxham Wroxham 42 68 64 50
16 Needham Market Needham 42 61 62 49
17 AFC Sudbury AFC Sudbury 42 57 84 45
18 Walthamstow Walthamstow 42 54 72 40
19 Ware Ware 42 59 105 36
20 Harlow Town Harlow Town 42 45 82 35
21 Redbridge Redbridge 42 42 105 27
22 Ilford FC Ilford FC 42 32 106 20
TEMPORADA 2011/2012
NON LEAGUE DIVISION 1 GRUPO 5
Equipo PJ GF GC Puntos
1 Leiston Leiston 42 99 41 91
2 Enfield Town Enfield Town 42 96 46 90
3 Grays Athletic Grays 42 80 47 80
4 Tilbury Tilbury 42 82 62 80
5 Needham Market Needham 42 104 56 77
6 Redbridge Redbridge 42 80 59 73
7 Harlow Town Harlow Town 42 70 49 71
8 AFC Sudbury AFC Sudbury 42 65 57 69
9 Brentwood Town Brentwood 42 58 42 62
10 Thamesmead Town FC Thamesmead 42 68 71 58
11 Maldon & Tiptree Maldon 42 62 66 58
12 Potters Bar Town Potters Town 42 67 76 57
13 Romford Romford 42 64 73 57
14 Waltham Abbey Waltham 42 79 76 55
15 Chatham Town Chatham Town 42 54 63 54
16 Heybridge Swifts Heybridge 42 59 64 52
17 Walthamstow Walthamstow 42 59 95 43
18 Cheshunt Cheshunt 42 42 83 39
19 Soham Town Rangers Soham Town. 42 55 93 34
20 Ilford FC Ilford FC 42 47 85 30
21 Ware Ware 42 40 78 30
22 Great Wakering Rovers Great 42 43 91 29
TEMPORADA 2010/2011
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 East Thurrock United FC East 40 92 38 95
2 Needham Market Needham 40 95 49 87
3 Wingate & Finchley Wingate 40 72 54 72
4 Harlow Town Harlow Town 40 61 51 71
5 Brentwood Town Brentwood 40 75 55 69
6 Enfield Town Enfield Town 40 76 44 68
7 AFC Sudbury AFC Sudbury 40 82 64 66
8 Maldon & Tiptree Maldon 40 70 67 63
9 Heybridge Swifts Heybridge 40 81 59 61
10 Grays Athletic Grays 40 69 51 61
11 Waltham Abbey Waltham 40 75 63 58
12 Romford Romford 40 63 66 55
13 Potters Bar Town Potters Town 40 60 68 51
14 Ware Ware 40 57 77 45
15 Great Wakering Rovers Great 40 60 82 44
16 Redbridge Redbridge 40 51 79 39
17 Thamesmead Town FC Thamesmead 40 42 71 39
18 Cheshunt Cheshunt 40 49 81 38
19 Tilbury Tilbury 40 41 66 37
20 Ilford FC Ilford FC 40 42 81 32
21 Walthamstow Walthamstow 40 43 90 26

  USO DE MEMORIA  
7,851,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3803
Total Execution Time  0.3821
  CADENA URL  
/historico/Needham-Market
  GET DATOS  
$_GET['/historico/Needham-Market']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10480 AND type_rel = 2
0.0143  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 = '10480' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 10480 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0267  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 = 72852 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 68450 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 63526 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 58614 AND t.round = 9 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 `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 = 50618 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.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 `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 = 44470 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 39017 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 33744 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 `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 = 15599 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 4392 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 3489 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 24863 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 24888 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 24900 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC