4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Witham Town
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 DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Hashtag United Hashtag 38 101 35 98
2 AFC Sudbury AFC Sudbury 38 91 33 91
3 Lowestoft Town Lowestoft 38 89 50 77
4 Grays Athletic Grays 38 62 40 72
5 Felixstowe & Walton Utd Felixstowe 38 74 44 69
6 Heybridge Swifts Heybridge 38 66 40 69
7 Stowmarket Town Stowmarket 38 63 44 66
8 Brentwood Town Brentwood 38 57 50 55
9 New Salamis New Salamis 38 63 65 55
10 Wroxham Wroxham 38 52 55 50
11 Bury Town Bury Town 38 37 41 50
12 East Thurrock United FC East 38 46 55 49
13 Gorleston Gorleston 38 49 71 44
14 Basildon United Basildon 38 44 63 40
15 Maldon & Tiptree Maldon 38 40 58 39
16 Witham Town Witham Town 38 43 75 35
17 Great Wakering Rovers Great 38 49 88 30
18 Coggeshall Town Coggeshall 38 28 60 28
19 Tilbury Tilbury 38 36 77 27
20 Hullbridge Sports Hullbridge 38 35 81 22
TEMPORADA 2021/2022
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Aveley Aveley 38 94 37 80
2 Canvey Island Canvey 38 100 42 78
3 Brentwood Town Brentwood 38 73 41 75
4 Stowmarket Town Stowmarket 38 75 39 73
5 Felixstowe & Walton Utd Felixstowe 38 60 45 72
6 Grays Athletic Grays 38 69 38 68
7 AFC Sudbury AFC Sudbury 38 57 46 63
8 Hashtag United Hashtag 38 60 49 62
9 Maldon & Tiptree Maldon 38 74 63 60
10 Dereham Town Dereham Town 38 63 53 60
11 Heybridge Swifts Heybridge 38 77 73 53
12 Bury Town Bury Town 38 63 71 44
13 Coggeshall Town Coggeshall 38 53 68 43
14 Tilbury Tilbury 38 57 68 41
15 Great Wakering Rovers Great 38 58 74 40
16 Hullbridge Sports Hullbridge 38 43 72 39
17 Basildon United Basildon 38 35 60 35
18 Barking Barking 38 51 79 35
19 Witham Town Witham Town 38 40 71 33
20 Romford Romford 38 26 139 13
TEMPORADA 2020/2021
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Tilbury Tilbury 8 14 9 16
2 AFC Sudbury AFC Sudbury 8 15 14 12
3 Maldon & Tiptree Maldon 5 9 3 11
4 Bury Town Bury Town 4 9 2 10
5 Heybridge Swifts Heybridge 8 10 9 10
6 Histon Histon 6 10 9 10
7 Soham Town Rangers Soham Town. 7 7 7 10
8 Grays Athletic Grays 6 5 6 10
9 Aveley Aveley 6 8 9 9
10 Romford Romford 8 7 10 9
11 Coggeshall Town Coggeshall 6 7 6 8
12 Dereham Town Dereham Town 7 7 7 8
13 Felixstowe & Walton Utd Felixstowe 5 7 7 8
14 Great Wakering Rovers Great 7 11 14 8
15 Canvey Island Canvey 5 8 5 6
16 Hullbridge Sports Hullbridge 5 11 9 6
17 Cambridge City Cambridge 4 3 3 6
18 Brentwood Town Brentwood 5 5 6 6
19 Basildon United Basildon 6 11 9 5
20 Witham Town Witham Town 8 7 27 3
TEMPORADA 2019/2020
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Maldon & Tiptree Maldon 26 65 20 65
2 Aveley Aveley 26 66 31 51
3 Tilbury Tilbury 27 49 30 50
4 Heybridge Swifts Heybridge 29 54 43 50
5 Bury Town Bury Town 29 49 41 50
6 Coggeshall Town Coggeshall 26 40 24 46
7 Great Wakering Rovers Great 28 45 36 43
8 Dereham Town Dereham Town 29 52 43 41
9 Cambridge City Cambridge 28 42 39 39
10 Canvey Island Canvey 27 49 54 38
11 AFC Sudbury AFC Sudbury 26 42 42 37
12 Histon Histon 28 40 53 36
13 Soham Town Rangers Soham Town. 28 41 47 34
14 Grays Athletic Grays 29 41 47 31
15 Witham Town Witham Town 28 36 63 29
16 Hullbridge Sports Hullbridge 27 33 53 28
17 Brentwood Town Brentwood 28 41 54 26
18 Felixstowe & Walton Utd Felixstowe 29 40 62 25
19 Romford Romford 25 41 66 24
20 Basildon United Basildon 25 29 47 23
TEMPORADA 2018/2019
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Bowers and Pitsea Bowers 38 96 25 92
2 Aveley Aveley 38 84 49 80
3 Maldon & Tiptree Maldon 38 86 46 79
4 Coggeshall Town Coggeshall 38 79 43 74
5 Heybridge Swifts Heybridge 38 70 51 74
6 Bury Town Bury Town 38 72 63 59
7 Grays Athletic Grays 38 65 64 53
8 AFC Sudbury AFC Sudbury 38 71 72 52
9 Canvey Island Canvey 38 51 50 51
10 Tilbury Tilbury 38 64 64 50
11 Felixstowe & Walton Utd Felixstowe 38 56 66 50
12 Dereham Town Dereham Town 38 71 82 47
13 Barking Barking 38 49 63 47
14 Brentwood Town Brentwood 38 71 77 45
15 Great Wakering Rovers Great 38 55 72 41
16 Soham Town Rangers Soham Town. 38 44 64 40
17 Basildon United Basildon 38 37 71 39
18 Witham Town Witham Town 38 38 68 34
19 Romford Romford 38 48 82 34
20 Mildenhall Town FC Mildenhall 38 47 82 27
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
TEMPORADA 2014/2015
NON LEAGUE PREMIER GRUPO 1
Equipo PJ GF GC Puntos
1 Maidstone United Maidstone 46 85 41 98
2 Hendon Hendon 46 82 55 95
3 Margate Margate 46 94 59 85
4 Dulwich Hamlet FC Dulwich 46 66 51 76
5 Enfield Town Enfield Town 46 70 56 76
6 Metropolitan Police Metropolitan 46 73 51 75
7 Grays Athletic Grays 46 70 57 74
8 Leatherhead Leatherhead 46 75 63 70
9 Kingstonian Kingstonian 46 64 56 68
10 Leiston Leiston 46 73 58 67
11 Wingate & Finchley Wingate 46 72 70 67
12 East Thurrock United FC East 46 66 71 66
13 Billericay Town Billericay 46 74 68 65
14 Bognor Regis Town Bognor Regis 46 71 65 61
15 Hampton & Richmond Hampton 46 62 79 57
16 Harrow Borough Harrow 46 64 77 53
17 Canvey Island Canvey 46 61 77 53
18 VCD Athletic Athletic 46 53 70 53
19 Lewes Lewes 46 45 67 53
20 Tonbridge Angels Tonbridge 46 63 67 52
21 Peacehaven & Telscombe Peacehaven 46 58 85 48
22 Witham Town Witham Town 46 61 84 42
23 AFC Hornchurch Hornchurch 46 46 70 40
24 Bury Town Bury Town 46 35 86 32
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 2008/2009
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Aveley Aveley 42 81 40 96
2 East Thurrock United FC East 41 111 50 92
3 Brentwood Town Brentwood 42 77 32 88
4 Concord Rangers Concord 42 83 34 79
5 Waltham Abbey Waltham 41 84 45 79
6 Northwood Northwood 42 65 39 78
7 Wingate & Finchley Wingate 43 69 52 70
8 Redbridge Redbridge 42 61 50 64
9 Ware Ware 42 69 75 61
10 Chatham Town Chatham Town 42 58 60 60
11 Tilbury Tilbury 41 62 52 58
12 Enfield Town Enfield Town 41 71 67 58
13 Great Wakering Rovers Great 42 56 62 58
14 Cheshunt Cheshunt 42 60 71 56
15 Leyton FC Leyton FC 42 63 56 51
16 Maldon & Tiptree Maldon 42 48 63 48
17 Ilford FC Ilford FC 42 27 68 41
18 Thamesmead Town FC Thamesmead 42 46 73 40
19 Potters Bar Town Potters Town 43 53 75 37
20 Walthamstow Walthamstow 42 39 81 34
21 Witham Town Witham Town 42 37 103 27
22 Hillingdon Borough Hillingdon 42 35 107 16
TEMPORADA 2007/2008
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Dartford Dartford 43 112 42 92
2 Ware Ware 43 113 59 82
3 Redbridge Redbridge 42 70 43 81
4 AFC Sudbury AFC Sudbury 42 86 40 80
5 Canvey Island Canvey 42 82 39 79
6 Brentwood Town Brentwood 41 68 48 74
7 Edgware & Kingsbury Edgware 42 53 39 74
8 Bury Town Bury Town 41 74 53 72
9 Maldon & Tiptree Maldon 41 77 61 67
10 Northwood Northwood 42 71 61 66
11 Aveley Aveley 42 68 65 66
12 Enfield Town Enfield Town 41 59 63 60
13 Great Wakering Rovers Great 43 65 69 48
14 Waltham Abbey Waltham 42 42 78 46
15 Arlesey Town Arlesey Town 41 64 83 45
16 Witham Town Witham Town 42 75 109 41
17 Potters Bar Town Potters Town 42 45 77 39
18 Wingate & Finchley Wingate 42 45 72 35
19 Walthamstow Walthamstow 41 44 72 33
20 Tilbury Tilbury 43 49 101 33
21 Ilford FC Ilford FC 42 47 95 32
22 Wivenhoe Town FC Wivenhoe 42 46 86 31
TEMPORADA 2006/2007
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 AFC Hornchurch Hornchurch 42 96 27 103
2 Harlow Town Harlow Town 42 71 31 82
3 Enfield Town Enfield Town 42 74 39 79
4 Maldon & Tiptree Maldon 42 50 42 71
5 AFC Sudbury AFC Sudbury 42 67 41 70
6 Canvey Island Canvey 42 65 47 67
7 Ware Ware 42 70 56 67
8 Walthamstow Walthamstow 42 60 56 65
9 Wingate & Finchley Wingate 42 58 49 59
10 Waltham Abbey Waltham 42 65 51 58
11 Wivenhoe Town FC Wivenhoe 42 50 52 57
12 Great Wakering Rovers Great 42 57 64 57
13 Enfield FC Enfield FC 41 64 62 53
14 Potters Bar Town Potters Town 42 60 62 51
15 Redbridge Redbridge 42 42 48 50
16 Aveley Aveley 41 46 56 50
17 Bury Town Bury Town 42 57 69 50
18 Arlesey Town Arlesey Town 42 44 63 50
19 Tilbury Tilbury 42 43 72 43
20 Witham Town Witham Town 42 52 90 37
21 Ilford FC Ilford FC 42 36 97 32
22 Flackwell Heath Flackwell 42 37 90 30

  USO DE MEMORIA  
7,929,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1464
Total Execution Time  0.1479
  CADENA URL  
/historico/Witham-Town
  GET DATOS  
$_GET['/historico/Witham-Town']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0034  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 = 'Witham-Town' 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.0019  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=10861 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=10861 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=10861 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=10861 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10861 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 = '10861' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '10861' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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.0028  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=10861 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 (72975,72728,72677,67320) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72975 AND teamId = 10861
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 10861
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 10861
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 10861
0.0023  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 = '10861' 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 = '10861' 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 = '10861' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72975 WHERE rp.league_id = 72975 AND rp.teamId = 10861 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 = 72975 WHERE rp.league_id = 72975 AND rp.teamId = 10861 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 = 72975 WHERE rp.league_id = 72975 AND rp.teamId = 10861 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 10861 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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.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 = 68454 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 `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 = 63528 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.0022  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 = 58739 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.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 `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 = 50966 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.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 `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 = 44456 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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.0038  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.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 = 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.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 `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 = 4012 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 `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.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 `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.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 `tables2009` 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 = 25008 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 `tables2008` 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 = 25015 AND t.round = 42 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 `tables2007` 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 = 25046 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC