4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Brightlingsea Regent
TEMPORADA 2023/2024
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Lowestoft Town Lowestoft 34 87 38 75
2 Bowers and Pitsea Bowers 34 68 43 73
3 Felixstowe & Walton Utd Felixstowe 34 72 38 71
4 Brentwood Town Brentwood 34 67 30 69
5 Bury Town Bury Town 34 81 46 68
6 Walthamstow Walthamstow 35 59 48 59
7 Heybridge Swifts Heybridge 34 51 43 57
8 Brightlingsea Regent Brightlingse 34 64 50 54
9 Maldon & Tiptree Maldon 35 65 60 49
10 Basildon United Basildon 34 61 57 49
11 Gorleston Gorleston 34 53 49 44
12 Wroxham Wroxham 34 44 47 42
13 Redbridge Redbridge 33 50 58 41
14 Witham Town Witham Town 34 50 59 39
15 New Salamis New Salamis 34 56 73 35
16 Grays Athletic Grays 34 43 65 30
17 Ipswich Wanderers Ipswich 34 36 67 29
18 Enfield FC Enfield FC 33 29 79 19
19 Stowmarket Town Stowmarket 34 31 117 6
20 East Thurrock United FC East 0 0 0 0
TEMPORADA 2022/2023
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 Bishops Stortford Bishops 42 75 33 88
2 AFC Hornchurch Hornchurch 42 98 49 84
3 Canvey Island Canvey 42 80 44 81
4 Aveley Aveley 42 64 42 78
5 Cray Wanderers Cray 42 78 48 74
6 Lewes Lewes 42 82 54 74
7 Horsham Horsham 42 84 57 72
8 Hastings United Hastings 42 63 42 71
9 Enfield Town Enfield Town 42 73 49 69
10 Billericay Town Billericay 42 66 59 65
11 Carshalton Athletic Carshalton 42 53 53 64
12 Folkestone Invicta Folkestone 42 73 65 59
13 Potters Bar Town Potters Town 42 56 86 53
14 Bognor Regis Town Bognor Regis 42 70 72 52
15 Haringey Borough Haringey 42 67 75 51
16 Wingate & Finchley Wingate 42 53 64 48
17 Margate Margate 42 48 65 44
18 Kingstonian Kingstonian 42 43 77 39
19 Bowers and Pitsea Bowers 42 44 78 33
20 Herne Bay Herne Bay 42 60 101 33
21 Corinthian-Casuals Corinthian-C 42 37 87 26
22 Brightlingsea Regent Brightlingse 42 41 108 24
TEMPORADA 2021/2022
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Worthing Worthing 42 100 45 97
2 Bishops Stortford Bishops 42 89 33 87
3 Enfield Town Enfield Town 42 91 57 84
4 AFC Hornchurch Hornchurch 42 89 42 81
5 Cheshunt Cheshunt 42 71 40 76
6 Folkestone Invicta Folkestone 42 85 62 72
7 Lewes Lewes 42 89 63 70
8 Margate Margate 42 60 62 65
9 Bognor Regis Town Bognor Regis 42 62 58 59
10 Kingstonian Kingstonian 42 68 71 59
11 Horsham Horsham 42 66 58 57
12 Carshalton Athletic Carshalton 42 65 57 57
13 Potters Bar Town Potters Town 42 54 74 53
14 Corinthian-Casuals Corinthian-C 42 51 58 52
15 Wingate & Finchley Wingate 42 60 74 49
16 Bowers and Pitsea Bowers 42 54 72 45
17 Haringey Borough Haringey 42 57 81 42
18 Brightlingsea Regent Brightlingse 42 44 92 39
19 Cray Wanderers Cray 42 64 85 39
20 Leatherhead Leatherhead 42 43 83 36
21 East Thurrock United FC East 42 44 98 35
22 Merstham Merstham 42 43 84 33
TEMPORADA 2020/2021
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Worthing Worthing 8 22 10 21
2 Cheshunt Cheshunt 10 13 14 19
3 Enfield Town Enfield Town 10 15 17 18
4 Carshalton Athletic Carshalton 8 14 10 16
5 Cray Wanderers Cray 7 21 10 15
6 Kingstonian Kingstonian 9 15 18 15
7 Bishops Stortford Bishops 6 13 5 14
8 AFC Hornchurch Hornchurch 10 17 12 14
9 Horsham Horsham 10 19 15 14
10 Folkestone Invicta Folkestone 9 13 13 13
11 Haringey Borough Haringey 8 13 13 12
12 Leatherhead Leatherhead 9 8 15 12
13 Bowers and Pitsea Bowers 5 13 5 10
14 Bognor Regis Town Bognor Regis 7 12 6 10
15 Potters Bar Town Potters Town 9 13 11 10
16 Wingate & Finchley Wingate 8 18 17 10
17 Corinthian-Casuals Corinthian-C 9 9 13 10
18 Lewes Lewes 8 8 15 8
19 Brightlingsea Regent Brightlingse 10 11 20 7
20 Margate Margate 9 6 13 6
21 East Thurrock United FC East 9 10 21 5
22 Merstham Merstham 8 8 18 4
TEMPORADA 2019/2020
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Worthing Worthing 34 72 41 71
2 Cray Wanderers Cray 33 63 45 64
3 AFC Hornchurch Hornchurch 33 62 28 62
4 Folkestone Invicta Folkestone 32 60 34 62
5 Carshalton Athletic Carshalton 34 59 38 62
6 Horsham Horsham 33 51 35 57
7 Enfield Town Enfield Town 32 61 51 56
8 Bognor Regis Town Bognor Regis 32 58 46 53
9 Leatherhead Leatherhead 31 48 42 52
10 Kingstonian Kingstonian 31 42 36 47
11 East Thurrock United FC East 30 47 40 46
12 Margate Margate 33 47 54 43
13 Potters Bar Town Potters Town 32 47 56 41
14 Bowers and Pitsea Bowers 33 49 42 40
15 Haringey Borough Haringey 30 44 47 39
16 Lewes Lewes 34 35 55 31
17 Bishops Stortford Bishops 32 37 63 28
18 Cheshunt Cheshunt 31 39 59 27
19 Corinthian-Casuals Corinthian-C 31 33 44 26
20 Wingate & Finchley Wingate 33 34 58 25
21 Merstham Merstham 33 34 70 25
22 Brightlingsea Regent Brightlingse 33 24 62 24
TEMPORADA 2018/2019
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Dorking Wanderers Dorking 42 87 31 93
2 Carshalton Athletic Carshalton 42 70 49 71
3 Haringey Borough Haringey 42 73 54 71
4 Merstham Merstham 42 60 50 70
5 Folkestone Invicta Folkestone 42 77 58 69
6 Tonbridge Angels Tonbridge 41 59 46 69
7 Bishops Stortford Bishops 42 70 57 67
8 Leatherhead Leatherhead 42 56 42 65
9 Worthing Worthing 42 72 63 65
10 Enfield Town Enfield Town 42 76 56 61
11 Lewes Lewes 41 61 53 59
12 Margate Margate 42 45 48 59
13 Brightlingsea Regent Brightlingse 42 49 54 59
14 Bognor Regis Town Bognor Regis 42 71 62 57
15 AFC Hornchurch Hornchurch 42 57 59 50
16 Potters Bar Town Potters Town 42 51 56 49
17 Corinthian-Casuals Corinthian-C 42 48 74 47
18 Kingstonian Kingstonian 42 60 78 45
19 Wingate & Finchley Wingate 42 57 86 43
20 Whitehawk Whitehawk 42 50 72 41
21 Burgess Hill Town Burgess Hill 42 44 91 37
22 Harlow Town Harlow Town 42 53 107 34
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 DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Brightlingsea Regent Brightlingse 46 114 57 103
2 Maldon & Tiptree Maldon 46 107 51 91
3 Thurrock Thurrock 46 84 39 89
4 AFC Hornchurch Hornchurch 46 78 42 85
5 Haringey Borough Haringey 46 108 74 81
6 Bowers and Pitsea Bowers 46 102 66 78
7 Aveley Aveley 46 75 64 76
8 Phoenix Sports Phoenix 46 71 72 75
9 Norwich United Norwich 46 70 61 74
10 Cheshunt Cheshunt 46 85 72 71
11 Bury Town Bury Town 46 74 66 69
12 Tilbury Tilbury 46 67 73 64
13 Witham Town Witham Town 46 77 80 59
14 Brentwood Town Brentwood 46 63 77 56
15 VCD Athletic Athletic 46 53 76 56
16 Romford Romford 46 59 90 56
17 Thamesmead Town FC Thamesmead 46 70 78 54
18 Dereham Town Dereham Town 46 70 89 54
19 Soham Town Rangers Soham Town. 46 62 78 53
20 Waltham Abbey Waltham 46 57 73 51
21 Heybridge Swifts Heybridge 46 64 81 51
22 Ware Ware 46 66 84 51
23 Wroxham Wroxham 46 42 103 25
24 Great Wakering Rovers Great 46 49 121 25
TEMPORADA 2015/2016
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 AFC Sudbury AFC Sudbury 46 90 49 105
2 Thurrock Thurrock 46 99 52 96
3 Harlow Town Harlow Town 46 92 47 96
4 Cray Wanderers Cray 46 98 52 90
5 AFC Hornchurch Hornchurch 46 87 35 86
6 Cheshunt Cheshunt 46 88 50 80
7 Maldon & Tiptree Maldon 46 89 66 78
8 Brightlingsea Regent Brightlingse 46 76 55 77
9 Dereham Town Dereham Town 46 82 61 74
10 Thamesmead Town FC Thamesmead 46 74 63 74
11 Tilbury Tilbury 46 85 66 69
12 Aveley Aveley 46 84 71 68
13 Bury Town Bury Town 46 74 68 62
14 Phoenix Sports Phoenix 46 60 74 56
15 Haringey Borough Haringey 46 61 76 50
16 Romford Romford 46 59 83 48
17 Soham Town Rangers Soham Town. 46 61 90 48
18 Great Wakering Rovers Great 46 69 103 47
19 Witham Town Witham Town 46 59 96 45
20 Heybridge Swifts Heybridge 46 59 87 44
21 Waltham Abbey Waltham 46 54 80 41
22 Wroxham Wroxham 46 50 89 40
23 Barkingside Barkingside 46 55 97 37
24 Redbridge Redbridge 46 46 141 28
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

  USO DE MEMORIA  
7,108,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4848
Total Execution Time  0.4861
  CADENA URL  
/historico/Brightlingsea-Regent
  GET DATOS  
$_GET['/historico/Brightlingsea-Regent']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0124  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 = 'Brightlingsea-Regent' 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=16346 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=16346 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=16346 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=16346 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=16346 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0213  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 = 72975
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16346 AND type_rel = 2
0.0112  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 = '16346' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0112  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 = '16346' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 72975 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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=16346 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (72975,72728,72677,71432,68452) 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.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 68452 AND teamId = 16346
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 72975 AND teamId = 16346
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 16346
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 16346
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16346
0.0116  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72975 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0112  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 = 72975 WHERE rp.league_id = 72975 AND rp.teamId = 16346 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.0115  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 = 72975 WHERE rp.league_id = 72975 AND rp.teamId = 16346 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 = 72975 WHERE rp.league_id = 72975 AND rp.teamId = 16346 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 16346 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72975 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.0112  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 = 68452 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.0109  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 = 58613 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 50616 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.0114  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 = 44469 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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.0124  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 = 33751 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 15613 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.0120  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 = 72975 ORDER BY nameShow LIMIT 100