4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Herne Bay
TEMPORADA 2023/2024
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Cray Valley PM Cray Valley 38 103 32 95
2 Ramsgate Ramsgate 38 106 41 89
3 Sittingbourne Sittingbourn 38 82 41 75
4 Three Bridges Three 38 98 68 73
5 Chichester City Chichester 38 83 43 69
6 Lancing Lancing 38 71 66 64
7 Sheppey United Sheppey 38 76 57 61
8 Herne Bay Herne Bay 38 74 63 59
9 Broadbridge Heath Broadbridge 38 59 56 52
10 Sevenoaks Town Sevenoaks 38 61 65 46
11 Ashford United Ashford 38 57 82 45
12 Burgess Hill Town Burgess Hill 38 59 70 44
13 Hythe Town Hythe Town 38 54 71 44
14 Horndean Horndean 38 57 76 43
15 Merstham Merstham 38 58 72 41
16 Phoenix Sports Phoenix 38 52 91 38
17 Littlehampton Town Littlehampto 38 49 76 37
18 East Grinstead Town East 38 52 86 34
19 Beckenham Town Beckenham 38 57 93 29
20 Erith & Belvedere Erith 38 27 86 26
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 DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Hastings United Hastings 38 82 33 85
2 Ashford United Ashford 38 79 48 72
3 Herne Bay Herne Bay 38 63 34 70
4 Haywards Heath Town Haywards 38 51 33 67
5 Cray Valley PM Cray Valley 38 70 48 66
6 Ramsgate Ramsgate 38 80 52 65
7 Burgess Hill Town Burgess Hill 38 57 47 62
8 Corinthian Corinthian 38 50 39 59
9 VCD Athletic Athletic 38 66 54 54
10 Sittingbourne Sittingbourn 38 47 51 52
11 Chichester City Chichester 38 48 43 49
12 Faversham Town Faversham 38 43 56 49
13 Sevenoaks Town Sevenoaks 38 54 66 48
14 Three Bridges Three 38 60 75 44
15 East Grinstead Town East 38 36 66 41
16 Whitehawk Whitehawk 38 39 54 39
17 Hythe Town Hythe Town 38 40 72 39
18 Lancing Lancing 38 34 65 36
19 Phoenix Sports Phoenix 38 35 64 33
20 Whitstable Town Whitstable 38 39 73 30
TEMPORADA 2020/2021
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Hastings United Hastings 7 13 3 17
2 VCD Athletic Athletic 8 18 7 16
3 East Grinstead Town East 6 16 6 14
4 Whyteleafe Whyteleafe 6 15 7 13
5 Sevenoaks Town Sevenoaks 8 14 10 13
6 Faversham Town Faversham 6 8 3 12
7 Whitstable Town Whitstable 9 12 20 11
8 Hythe Town Hythe Town 6 14 12 10
9 Ramsgate Ramsgate 6 10 10 7
10 Herne Bay Herne Bay 6 9 9 7
11 Ashford United Ashford 6 9 11 7
12 Cray Valley PM Cray Valley 5 6 6 6
13 Three Bridges Three 6 11 15 6
14 Chichester City Chichester 5 7 11 6
15 Phoenix Sports Phoenix 7 7 16 6
16 Whitehawk Whitehawk 6 7 9 5
17 Haywards Heath Town Haywards 7 11 19 5
18 Sittingbourne Sittingbourn 5 8 12 4
19 Burgess Hill Town Burgess Hill 7 5 14 4
20 Guernsey Guernsey 0 0 0 0
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

  USO DE MEMORIA  
7,416,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1404
Total Execution Time  0.1416
  CADENA URL  
/historico/Herne-Bay
  GET DATOS  
$_GET['/historico/Herne-Bay']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0033  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 = 'Herne-Bay' 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.0018  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=16227 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=16227 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=16227 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=16227 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=16227 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 72980
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16227 AND type_rel = 2
0.0024  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 = '16227' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '16227' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030  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 = 72677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 72980 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=16227 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72980,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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68452 AND teamId = 16227
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 72980 AND teamId = 16227
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 16227
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 16227
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16227
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 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 = 72980 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = 72980 WHERE rp.league_id = 72980 AND rp.teamId = 16227 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.0020  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 = 72980 WHERE rp.league_id = 72980 AND rp.teamId = 16227 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 72980 WHERE rp.league_id = 72980 AND rp.teamId = 16227 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 16227 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72980 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.0039  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.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 `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 = 63530 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.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 = 58741 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.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 `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.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 `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.0048  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.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 `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.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 `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.0029  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.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 `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.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 `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.0020  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 = 72980 ORDER BY nameShow LIMIT 100