4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Padiham
TEMPORADA 2023/2024
COMBINED COUNTIES LEAGUE GRUPO 6
Equipo PJ GF GC Puntos
1 Wythenshawe Amateurs Wythenshawe 45 110 43 95
2 Bury Bury 46 108 50 95
3 Wythenshawe Town Wythenshawe 46 95 44 95
4 Padiham Padiham 45 91 60 80
5 Chadderton Chadderton 45 91 71 79
6 Kendal Town Kendal Town 45 101 75 77
7 Prestwich Heys Prestwich 45 92 77 77
8 Charnock Richard Charnock 45 102 74 75
9 Colne FC Colne FC 45 97 64 71
10 Isle of Man Isle of Man 45 71 75 69
11 Lower Breck Lower Breck 44 78 70 68
12 Irlam Irlam 46 71 68 61
13 Cheadle Town Cheadle Town 46 75 92 60
14 Litherland Remyca Litherland 45 76 95 59
15 AFC Liverpool Liverpool 46 87 114 59
16 West Didsbury Chorlton West 46 73 84 54
17 Barnoldswick Town Barnoldswick 46 88 113 54
18 Ramsbottom United Ramsbottom 45 84 94 50
19 Pilkington FC Pilkington 45 56 91 46
20 Glossop Glossop 45 63 81 43
21 Longridge Town Longridge 45 78 103 43
22 Squires Gate Squires Gate 46 74 119 42
23 Burscough Burscough 45 72 99 41
24 Skelmersdale United Skelmersdale 46 54 131 32
TEMPORADA 2022/2023
COMBINED COUNTIES LEAGUE GRUPO 7
Equipo PJ GF GC Puntos
1 Vauxhall Motors Vauxhall 39 75 33 83
2 Avro Avro 40 71 31 81
3 Northwich Victoria Northwich 41 77 49 81
4 Wythenshawe Town Wythenshawe 41 102 55 77
5 Bury Bury 40 68 39 77
6 Prestwich Heys Prestwich 39 59 53 63
7 West Didsbury Chorlton West 39 78 62 62
8 Congleton Town FC Congleton 40 69 61 62
9 Litherland Remyca Litherland 40 60 59 62
10 AFC Liverpool Liverpool 40 78 66 61
11 Kendal Town Kendal Town 40 71 74 58
12 Charnock Richard Charnock 41 82 78 55
13 Longridge Town Longridge 41 75 92 51
14 Padiham Padiham 39 60 60 50
15 Winsford United Winsford 41 55 70 49
16 Irlam Irlam 40 58 63 46
17 Lower Breck Lower Breck 40 52 61 46
18 Isle of Man Isle of Man 39 66 90 46
19 Squires Gate Squires Gate 40 59 89 41
20 Barnoldswick Town Barnoldswick 41 54 88 37
21 Burscough Burscough 41 64 98 36
22 Ashton Athletic Ashton 40 42 104 17
TEMPORADA 2021/2022
COMBINED COUNTIES LEAGUE GRUPO 8
Equipo PJ GF GC Puntos
1 Macclesfield Town Macclesfield 15 29 19 32
2 Skelmersdale United Skelmersdale 14 33 16 29
3 Charnock Richard Charnock 15 51 31 27
4 Burscough Burscough 15 31 23 26
5 Irlam Irlam 15 28 23 26
6 Longridge Town Longridge 16 29 25 25
7 Northwich Victoria Northwich 16 27 27 24
8 Avro Avro 13 23 19 23
9 Lower Breck Lower Breck 14 26 23 22
10 Congleton Town FC Congleton 14 22 15 21
11 Wythenshawe Town Wythenshawe 13 19 13 21
12 Vauxhall Motors Vauxhall 15 25 30 21
13 AFC Liverpool Liverpool 14 32 36 20
14 Barnoldswick Town Barnoldswick 14 25 23 19
15 Squires Gate Squires Gate 14 20 20 17
16 Ashton Athletic Ashton 16 33 43 17
17 Prestwich Heys Prestwich 15 25 36 16
18 Runcorn Town FC Runcorn Town 14 24 31 13
19 Padiham Padiham 14 17 24 12
20 Winsford United Winsford 14 23 41 11
21 Litherland Remyca Litherland 14 14 38 6
TEMPORADA 2014/2015
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Salford City Salford City 42 92 42 95
2 Darlington FC Darlington 42 99 37 91
3 Bamber Bridge Bamber 42 88 58 83
4 Northwich Victoria Northwich 42 75 39 82
5 Spennymoor Town Spennymoor 42 76 45 77
6 Scarborough Athletic Scarborough 42 80 61 75
7 Mossley Mossley 42 79 63 75
8 Harrogate Railway Harrogate 42 85 75 67
9 Warrington Town Warrington 42 65 55 65
10 Droylsden Droylsden 42 98 84 63
11 Lancaster City Lancaster 42 65 53 62
12 Farsley Celtic Farsley 42 73 64 61
13 Clitheroe Clitheroe 42 73 81 52
14 Brighouse Town Brighouse 42 64 81 51
15 Burscough Burscough 42 62 73 48
16 Kendal Town Kendal Town 42 81 92 46
17 Ossett Albion Ossett 42 49 72 46
18 Ossett Town Ossett Town 42 48 83 42
19 Radcliffe Borough Radcliffe 42 49 91 35
20 Prescot Cables Prescot 42 47 86 33
21 New Mills New Mills 42 56 107 25
22 Padiham Padiham 42 50 112 24
TEMPORADA 2013/2014
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Curzon Ashton Curzon 42 92 36 99
2 Darlington FC Darlington 42 101 37 90
3 Warrington Town Warrington 42 86 47 87
4 Bamber Bridge Bamber 42 81 45 83
5 Ramsbottom United Ramsbottom 42 112 57 83
6 Lancaster City Lancaster 42 75 52 80
7 Farsley Celtic Farsley 42 76 51 75
8 Ossett Town Ossett Town 42 66 63 65
9 Northwich Victoria Northwich 42 73 52 63
10 Kendal Town Kendal Town 42 83 84 56
11 Cammell Laird Cammell 42 65 64 54
12 Salford City Salford City 42 68 80 52
13 Harrogate Railway Harrogate 42 52 66 48
14 Burscough Burscough 42 58 82 48
15 Mossley Mossley 42 73 90 47
16 New Mills New Mills 42 68 95 45
17 Clitheroe Clitheroe 42 55 81 43
18 Radcliffe Borough Radcliffe 42 57 93 43
19 Padiham Padiham 42 61 92 42
20 Prescot Cables Prescot 42 63 86 40
21 Ossett Albion Ossett 42 40 80 29
22 Wakefield Wakefield 42 55 127 28

  USO DE MEMORIA  
5,767,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1083
Total Execution Time  0.1095
  CADENA URL  
/historico/Padiham
  GET DATOS  
$_GET['/historico/Padiham']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0030  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 = 'Padiham' 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=9919 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=9919 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=9919 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 73103
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9919 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9919 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  SELECT /*35 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 (321472) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '9919' ORDER BY l.year DESC,cat.coefficient DESC
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 = '9919' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '9919' 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 = 73103 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=9919 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73103,72728) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73103 AND teamId = 9919
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 9919
0.0041  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 = 73103 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '9919' 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 = '9919' and rp.type = 4
0.0020  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 = '9919' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73103 WHERE rp.league_id = 73103 AND rp.teamId = 9919 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.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 = 73103 WHERE rp.league_id = 73103 AND rp.teamId = 9919 AND (e.action = 4 or e.action = 5) 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 = 73103 WHERE rp.league_id = 73103 AND rp.teamId = 9919 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 9919 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0041  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 = 73103 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.0033  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 = 68437 AND t.round = 43 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 = 63785 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 4399 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 3492 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 73103 ORDER BY nameShow LIMIT 100