4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Marske United
TEMPORADA 2023/2024
NON LEAGUE PREMIER GRUPO 4
Equipo PJ GF GC Puntos
1 Radcliffe Borough Radcliffe 40 103 58 87
2 Macclesfield Town Macclesfield 40 84 47 77
3 Marine Marine 40 87 44 76
4 Warrington Rylands 1906 FC Warrington 40 65 42 75
5 Worksop Town Worksop Town 40 72 49 70
6 Hyde Hyde 40 68 48 67
7 Ashton United Ashton 40 73 63 67
8 Gainsborough Trinity Gainsborough 40 66 63 63
9 Lancaster City Lancaster 40 60 62 62
10 Guiseley Guiseley 40 69 63 61
11 Ilkeston Town FC Ilkeston 40 69 62 60
12 Whitby Town Whitby Town 40 60 50 56
13 Morpeth Town Morpeth Town 40 76 81 50
14 United of Manchester United 40 55 77 48
15 Matlock Town Matlock Town 40 62 77 47
16 Bamber Bridge Bamber 40 63 82 47
17 Workington Workington 40 67 81 44
18 Basford United Basford 40 44 65 37
19 Bradford Park Avenue Bradford 40 50 85 30
20 Stafford Rangers Stafford 40 36 81 30
21 Atherton Collieries Atherton 40 47 96 25
22 Marske United Marske 0 0 0 0
TEMPORADA 2022/2023
NON LEAGUE PREMIER GRUPO 4
Equipo PJ GF GC Puntos
1 South Shields South 42 71 39 85
2 Warrington Town Warrington 42 70 39 77
3 Bamber Bridge Bamber 42 62 63 73
4 Gainsborough Trinity Gainsborough 42 74 41 69
5 Matlock Town Matlock Town 42 56 49 68
6 Hyde Hyde 42 64 42 66
7 Radcliffe Borough Radcliffe 42 55 49 66
8 United of Manchester United 42 68 48 63
9 Marine Marine 42 56 45 61
10 Warrington Rylands 1906 FC Warrington 42 64 55 60
11 Lancaster City Lancaster 42 51 51 58
12 Stafford Rangers Stafford 42 52 53 57
13 Guiseley Guiseley 42 54 54 55
14 Ashton United Ashton 42 58 64 53
15 Whitby Town Whitby Town 42 45 54 52
16 Marske United Marske 42 57 79 50
17 Morpeth Town Morpeth Town 42 55 63 49
18 Atherton Collieries Atherton 42 38 57 47
19 Nantwich Town Nantwich 42 44 55 46
20 Stalybridge Celtic Stalybridge 42 50 64 42
21 Liversedge Liversedge 42 48 86 40
22 Belper Town FC Belper Town 42 44 86 30
TEMPORADA 2021/2022
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Liversedge Liversedge 36 98 22 93
2 Marske United Marske 36 94 34 88
3 Cleethorpes Town Cleethorpes 36 74 46 69
4 Stockton Town Stockton 36 79 41 66
5 Shildon AFC Shildon AFC 36 61 35 63
6 Dunston UTS Dunston UTS 36 67 60 54
7 Brighouse Town Brighouse 36 59 52 54
8 Worksop Town Worksop Town 36 56 53 54
9 Ossett United Ossett 36 43 59 53
10 Yorkshire Amateur Yorkshire 36 55 63 47
11 Stocksbridge Park Steels Stocksbridge 36 53 58 46
12 Pontefract Collieries Pontefract 36 41 54 43
13 Hebburn Town Hebburn Town 36 47 56 42
14 Tadcaster Albion Tadcaster 36 47 63 37
15 Bridlington Town Bridlington 36 40 65 34
16 Lincoln United FC Lincoln 36 56 91 34
17 Sheffield FC Sheffield 36 47 77 33
18 Frickley Athletic Frickley 36 30 67 30
19 Pickering Town CFC Pickering 36 52 103 26
TEMPORADA 2020/2021
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Brighouse Town Brighouse 0 0 0 0
2 Workington Workington 0 0 0 0
3 Tadcaster Albion Tadcaster 0 0 0 0
4 Runcorn Linnets Runcorn 0 0 0 0
5 Ramsbottom United Ramsbottom 0 0 0 0
6 Ossett United Ossett 0 0 0 0
7 Marine Marine 0 0 0 0
8 Kendal Town Kendal Town 0 0 0 0
9 Clitheroe Clitheroe 0 0 0 0
10 Marske United Marske 0 0 0 0
11 Widnes Widnes 0 0 0 0
12 Trafford Trafford 0 0 0 0
13 Prescot Cables Prescot 0 0 0 0
14 Pontefract Collieries Pontefract 0 0 0 0
15 Pickering Town CFC Pickering 0 0 0 0
16 Mossley Mossley 0 0 0 0
17 Dunston UTS Dunston UTS 0 0 0 0
18 City of Liverpool City 0 0 0 0
19 Colne FC Colne FC 0 0 0 0
TEMPORADA 2019/2020
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Workington Workington 30 75 25 68
2 Ramsbottom United Ramsbottom 28 71 36 61
3 Marine Marine 28 63 29 55
4 Pontefract Collieries Pontefract 25 47 24 52
5 Marske United Marske 24 45 23 47
6 Mossley Mossley 29 37 45 42
7 Clitheroe Clitheroe 29 44 39 41
8 Brighouse Town Brighouse 28 36 41 39
9 Runcorn Linnets Runcorn 27 41 40 38
10 Tadcaster Albion Tadcaster 26 36 30 37
11 Trafford Trafford 28 42 36 35
12 Dunston UTS Dunston UTS 27 38 41 35
13 Widnes Widnes 28 43 44 33
14 Prescot Cables Prescot 29 32 39 33
15 City of Liverpool City 27 32 45 32
16 Colne FC Colne FC 25 31 31 30
17 Droylsden Droylsden 30 28 75 27
18 Ossett United Ossett 28 38 57 22
19 Kendal Town Kendal Town 28 29 70 21
20 Pickering Town CFC Pickering 28 34 72 16
TEMPORADA 2018/2019
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Morpeth Town Morpeth Town 38 90 33 88
2 Pontefract Collieries Pontefract 38 91 54 76
3 Brighouse Town Brighouse 38 74 43 71
4 Sheffield FC Sheffield 38 81 63 69
5 Ossett United Ossett 38 65 37 67
6 Tadcaster Albion Tadcaster 38 71 47 66
7 Cleethorpes Town Cleethorpes 38 90 62 64
8 Loughborough Dynamo FC Loughborough 38 82 67 62
9 Belper Town FC Belper Town 38 66 60 59
10 Marske United Marske 38 63 47 58
11 Stamford Stamford 38 55 57 50
12 Frickley Athletic Frickley 38 54 60 48
13 Stocksbridge Park Steels Stocksbridge 38 41 70 43
14 Lincoln United FC Lincoln 38 53 83 43
15 AFC Mansfield Mansfield 38 55 73 42
16 Pickering Town CFC Pickering 38 45 72 35
17 Wisbech Town Wisbech Town 38 43 70 31
18 Spalding United Spalding 38 38 67 31
19 Carlton Town Carlton Town 38 46 84 27
20 Gresley Gresley 38 37 91 25

  USO DE MEMORIA  
6,217,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0881
Total Execution Time  0.0894
  CADENA URL  
/historico/Marske-United
  GET DATOS  
$_GET['/historico/Marske-United']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0040  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 = 72855
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9857 AND type_rel = 2
0.0039  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 = '9857' 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 = 72855 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=9857 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 (72855,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 = 72855 AND teamId = 9857
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 9857
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 9857
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9857
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 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 = 72855 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026  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 = 72855 WHERE rp.league_id = 72855 AND rp.teamId = 9857 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.0024  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 = 72855 WHERE rp.league_id = 72855 AND rp.teamId = 9857 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 72855 WHERE rp.league_id = 72855 AND rp.teamId = 9857 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 9857 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72855 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.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 `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 = 68453 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.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 `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 = 63531 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 = 58742 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.0030  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 = 50969 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 44461 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC