4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Merstham
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 DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Basingstoke Town Basingstoke 38 89 37 89
2 Walton & Hersham Walton 38 102 41 87
3 Marlow FC Marlow FC 38 64 45 67
4 Hanworth Villa FC Hanworth 38 58 50 66
5 Northwood Northwood 38 54 45 63
6 Binfield Binfield 38 63 51 57
7 Leatherhead Leatherhead 38 47 45 57
8 Chertsey Town Chertsey 38 67 52 56
9 South Park FC South Park 38 50 61 55
10 Southall Southall 38 50 48 52
11 Chipstead Chipstead 38 52 54 51
12 Westfield (Surrey) Westfield 38 54 50 49
13 Thatcham Town Thatcham 38 56 57 48
14 Uxbridge Uxbridge 38 53 55 44
15 Guernsey Guernsey 38 42 73 40
16 Ashford Town Ashford Town 38 46 91 38
17 Sutton Common Rovers Sutton 38 45 71 37
18 Merstham Merstham 38 43 66 36
19 Bedfont Sports Bedfont 38 50 62 35
20 Tooting and Mitcham Tooting 38 34 65 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 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 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
TEMPORADA 2011/2012
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Whitehawk Whitehawk 40 82 26 93
2 Bognor Regis Town Bognor Regis 40 105 38 88
3 Dulwich Hamlet FC Dulwich 40 73 26 86
4 Folkestone Invicta Folkestone 40 82 53 76
5 Godalming Town Godalming 40 77 53 73
6 Maidstone United Maidstone 40 68 50 67
7 Worthing Worthing 40 69 45 64
8 Hythe Town Hythe Town 40 62 62 59
9 Merstham Merstham 40 63 69 59
10 Chipstead Chipstead 40 59 57 56
11 Ramsgate Ramsgate 40 61 73 55
12 Walton & Hersham Walton 40 54 52 50
13 Corinthian-Casuals Corinthian-C 40 49 63 48
14 Eastbourne Town Eastbourne 40 49 63 46
15 Walton Casuals Walton 40 51 74 42
16 Crawley Down Gatwick Crawley Down 40 65 81 41
17 Faversham Town Faversham 40 43 67 40
18 Whitstable Town Whitstable 40 46 87 40
19 Burgess Hill Town Burgess Hill 40 39 90 33
20 Sittingbourne Sittingbourn 40 36 75 30
21 Whyteleafe Whyteleafe 40 38 67 28
22 Croydon Athletic Croydon 0 0 0 0
TEMPORADA 2010/2011
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Metropolitan Police Metropolitan 42 102 41 96
2 Bognor Regis Town Bognor Regis 42 103 43 96
3 Whitehawk Whitehawk 42 109 44 88
4 Leatherhead Leatherhead 42 100 41 88
5 Dulwich Hamlet FC Dulwich 42 79 59 65
6 Walton & Hersham Walton 42 69 58 62
7 Burgess Hill Town Burgess Hill 42 69 60 62
8 Faversham Town Faversham 42 56 48 61
9 Ramsgate Ramsgate 42 65 63 60
10 Chipstead Chipstead 42 63 67 57
11 Sittingbourne Sittingbourn 42 52 66 56
12 Walton Casuals Walton 42 65 71 53
13 Fleet Town Fleet Town 42 68 90 52
14 Worthing Worthing 42 76 73 49
15 Whitstable Town Whitstable 42 58 75 49
16 Merstham Merstham 42 60 85 45
17 Whyteleafe Whyteleafe 42 65 94 45
18 Godalming Town Godalming 42 52 82 45
19 Eastbourne Town Eastbourne 42 60 78 44
20 Corinthian-Casuals Corinthian-C 42 53 80 42
21 Chatham Town Chatham Town 42 52 80 40
22 Horsham YMCA Horsham YMCA 42 41 119 23
TEMPORADA 2009/2010
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Folkestone Invicta Folkestone 42 54 23 92
2 Croydon Athletic Croydon 42 92 39 89
3 Godalming Town Godalming 42 71 44 83
4 Worthing Worthing 42 83 53 80
5 Leatherhead Leatherhead 42 78 45 74
6 Fleet Town Fleet Town 42 74 49 72
7 Burgess Hill Town Burgess Hill 42 64 50 67
8 Walton & Hersham Walton 42 55 54 62
9 Sittingbourne Sittingbourn 42 63 48 61
10 Metropolitan Police Metropolitan 42 59 50 60
11 Horsham YMCA Horsham YMCA 42 67 61 59
12 Dulwich Hamlet FC Dulwich 42 57 64 54
13 Corinthian-Casuals Corinthian-C 42 66 79 54
14 Ramsgate Ramsgate 42 55 61 53
15 Whyteleafe Whyteleafe 42 60 64 51
16 Merstham Merstham 42 62 80 48
17 Chatham Town Chatham Town 42 55 75 46
18 Whitstable Town Whitstable 42 41 85 45
19 Chipstead Chipstead 42 47 65 43
20 Ashford Town Kent Ashford Town 42 49 90 38
21 Walton Casuals Walton 42 41 66 34
22 Eastbourne Town Eastbourne 42 29 77 29
TEMPORADA 2008/2009
NON LEAGUE DIVISION 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Kingstonian Kingstonian 42 91 48 86
2 Cray Wanderers Cray 42 87 54 79
3 Fleet Town Fleet Town 42 82 43 78
4 Metropolitan Police Metropolitan 42 72 45 77
5 Worthing Worthing 42 77 48 76
6 Sittingbourne Sittingbourn 41 62 53 69
7 Merstham Merstham 42 57 54 64
8 Ashford Town Kent Ashford Town 42 68 54 63
9 Godalming Town Godalming 42 71 50 62
10 Dulwich Hamlet FC Dulwich 42 64 50 60
11 Croydon Athletic Croydon 41 62 54 59
12 Folkestone Invicta Folkestone 42 54 46 59
13 Eastbourne Town Eastbourne 42 66 72 57
14 Walton & Hersham Walton 42 46 55 50
15 Leatherhead Leatherhead 42 57 74 50
16 Whitstable Town Whitstable 41 57 76 49
17 Walton Casuals Walton 42 43 60 44
18 Whyteleafe Whyteleafe 42 48 64 43
19 Corinthian-Casuals Corinthian-C 41 61 86 43
20 Burgess Hill Town Burgess Hill 41 45 65 40
21 Chipstead Chipstead 42 57 96 36
22 Crowborough Athletic Crowborough 41 41 121 16

  USO DE MEMORIA  
8,237,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5234
Total Execution Time  0.5247
  CADENA URL  
/historico/Merstham
  GET DATOS  
$_GET['/historico/Merstham']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16172 AND type_rel = 2
0.0130  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 = '16172' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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=16172 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72980 AND teamId = 16172
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 16172
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 16172
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16172
0.0126  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 = '16172' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16172' and rp.type = 4
0.0126  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 = '16172' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 16172 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.0126  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 = 16172 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 16172 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 16172 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0252  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.0130  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 = 68455 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.0131  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.0128  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.0130  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.0131  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.0132  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.0131  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.0130  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.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 `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.0130  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.0132  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 = 24890 AND t.round = 42 ORDER BY team.conference 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 `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 = 24902 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2010` 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 = 24914 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 25005 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC