4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Haringey Borough
TEMPORADA 2023/2024
NON LEAGUE PREMIER GRUPO 3
Equipo PJ GF GC Puntos
1 AFC Hornchurch Hornchurch 42 95 34 100
2 Chatham Town Chatham Town 42 87 61 79
3 Enfield Town Enfield Town 42 81 54 77
4 Wingate & Finchley Wingate 42 78 62 76
5 Horsham Horsham 42 64 50 76
6 Billericay Town Billericay 42 78 52 73
7 Hastings United Hastings 42 71 54 67
8 Lewes Lewes 42 68 70 67
9 Whitehawk Whitehawk 42 63 54 65
10 Bognor Regis Town Bognor Regis 42 78 63 62
11 Carshalton Athletic Carshalton 42 73 59 62
12 Dulwich Hamlet FC Dulwich 42 77 72 62
13 Hashtag United Hashtag 42 82 75 59
14 Canvey Island Canvey 42 62 74 54
15 Potters Bar Town Potters Town 42 65 70 51
16 Folkestone Invicta Folkestone 42 60 71 50
17 Cray Wanderers Cray 42 54 66 50
18 Cheshunt Cheshunt 42 58 72 43
19 Margate Margate 42 50 80 39
20 Haringey Borough Haringey 42 32 88 27
21 Concord Rangers Concord 42 34 82 26
22 Kingstonian Kingstonian 42 55 102 21
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 DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 AFC Hornchurch Hornchurch 46 97 35 103
2 Potters Bar Town Potters Town 46 87 42 93
3 Bowers and Pitsea Bowers 46 94 48 89
4 Haringey Borough Haringey 46 84 49 89
5 Heybridge Swifts Heybridge 46 105 53 87
6 Canvey Island Canvey 46 100 65 80
7 Dereham Town Dereham Town 46 75 63 71
8 Maldon & Tiptree Maldon 46 94 83 69
9 Bury Town Bury Town 46 67 65 65
10 Barking Barking 45 63 62 64
11 Witham Town Witham Town 46 59 66 62
12 AFC Sudbury AFC Sudbury 46 57 66 59
13 Soham Town Rangers Soham Town. 46 67 73 58
14 Aveley Aveley 46 61 67 57
15 Hertford Town Hertford 46 55 85 57
16 Tilbury Tilbury 46 73 95 56
17 Grays Athletic Grays 45 71 80 53
18 Cheshunt Cheshunt 46 72 103 50
19 Waltham Abbey Waltham 46 73 87 49
20 Ware Ware 46 49 81 48
21 Brentwood Town Brentwood 46 71 96 46
22 Mildenhall Town FC Mildenhall 46 54 86 46
23 Romford Romford 46 51 97 41
24 Norwich United Norwich 46 63 95 40
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

  USO DE MEMORIA  
6,977,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1422
Total Execution Time  0.1434
  CADENA URL  
/historico/Haringey-Borough
  GET DATOS  
$_GET['/historico/Haringey-Borough']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0058  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 = 'Haringey-Borough' 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.0022  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=16179 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=16179 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=16179 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=16179 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=16179 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0047  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 = 72854
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16179 AND type_rel = 2
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16179 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (729435) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = '16179' ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '16179' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '16179' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 72854 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=16179 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72854,72728,72677,71432) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72854 AND teamId = 16179
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 16179
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 16179
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16179
0.0040  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 = 72854 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '16179' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16179' and rp.type = 4
0.0021  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 = '16179' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 = 72854 WHERE rp.league_id = 72854 AND rp.teamId = 16179 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.0025  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 = 72854 WHERE rp.league_id = 72854 AND rp.teamId = 16179 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 72854 WHERE rp.league_id = 72854 AND rp.teamId = 16179 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 16179 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0036  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 = 72854 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.0024  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.0024  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 = 63524 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.0023  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.0025  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.0028  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.0025  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 = 39168 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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.0025  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