4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dunston UTS
TEMPORADA 2023/2024
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Hebburn Town Hebburn Town 37 82 36 81
2 Stockton Town Stockton 38 78 31 80
3 Dunston UTS Dunston UTS 38 77 45 72
4 Pontefract Collieries Pontefract 38 73 38 70
5 Carlton Town Carlton Town 38 59 52 65
6 Newton Aycliffe Newton 38 68 67 60
7 Belper Town FC Belper Town 37 62 62 57
8 North Ferriby United North 38 57 65 57
9 Cleethorpes Town Cleethorpes 38 58 47 56
10 Liversedge Liversedge 36 52 42 51
11 Grimsby Borough Grimsby 38 51 60 50
12 Consett AFC Consett AFC 38 58 62 49
13 Sheffield FC Sheffield 38 62 64 48
14 Ashington AFC Ashington 38 62 68 46
15 Stocksbridge Park Steels Stocksbridge 38 42 48 40
16 Bridlington Town Bridlington 38 47 72 36
17 Brighouse Town Brighouse 38 49 81 36
18 Ossett United Ossett 37 37 70 35
19 Winterton Rangers FC Winterton 38 37 74 35
20 Grantham Town Grantham 37 47 74 34
TEMPORADA 2022/2023
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Worksop Town Worksop Town 38 112 25 99
2 Stockton Town Stockton 38 74 40 68
3 Hebburn Town Hebburn Town 38 59 58 66
4 Long Eaton United Long Eaton. 38 67 52 65
5 Stocksbridge Park Steels Stocksbridge 38 58 41 63
6 Dunston UTS Dunston UTS 38 63 50 60
7 North Shields North 38 50 45 53
8 Brighouse Town Brighouse 38 65 64 51
9 Sheffield FC Sheffield 38 51 58 50
10 Pontefract Collieries Pontefract 38 68 62 49
11 Cleethorpes Town Cleethorpes 38 48 51 49
12 Grimsby Borough Grimsby 38 54 60 49
13 Consett AFC Consett AFC 38 54 63 46
14 Bridlington Town Bridlington 38 45 65 46
15 Ossett United Ossett 38 46 55 44
16 Grantham Town Grantham 38 37 42 43
17 Carlton Town Carlton Town 38 45 69 42
18 Lincoln United FC Lincoln 38 54 70 41
19 Shildon AFC Shildon AFC 38 46 70 40
20 Tadcaster Albion Tadcaster 38 28 84 21
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

  USO DE MEMORIA  
5,934,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2754
Total Execution Time  0.2767
  CADENA URL  
/historico/Dunston-Uts
  GET DATOS  
$_GET['/historico/Dunston-Uts']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9832 AND type_rel = 2
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=565 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 565 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  SELECT /*53 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 (1222282,1006257,894718,815160,813452) ORDER BY n.cover_points DESC, update_date DESC
0.0109  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 = '9832' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = '9832' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9832' and rp.type = 4
0.0109  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 = '9832' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0114  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 = 72981 WHERE rp.league_id = 72981 AND rp.teamId = 9832 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.0111  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 = 72981 WHERE rp.league_id = 72981 AND rp.teamId = 9832 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108  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 = 72981 WHERE rp.league_id = 72981 AND rp.teamId = 9832 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 9832 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0220  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 = 72981 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.0112  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 = 68457 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.0111  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.0109  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