4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Colne FC
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 43 101 72 72
9 Isle of Man Isle of Man 45 71 75 69
10 Colne FC Colne FC 43 96 63 68
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 45 87 112 53
18 Ramsbottom United Ramsbottom 44 83 93 49
19 Glossop Glossop 45 63 81 43
20 Longridge Town Longridge 45 78 103 43
21 Pilkington FC Pilkington 44 54 91 43
22 Squires Gate Squires Gate 46 74 119 42
23 Burscough Burscough 45 72 99 41
24 Skelmersdale United Skelmersdale 45 54 130 32
TEMPORADA 2022/2023
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Macclesfield Town Macclesfield 38 95 27 90
2 Leek Town Leek Town 38 70 38 76
3 Workington Workington 38 71 39 75
4 Clitheroe Clitheroe 38 70 50 64
5 Runcorn Linnets Runcorn 38 58 38 63
6 Witton Albion Witton 38 61 50 59
7 Mossley Mossley 38 58 49 58
8 Prescot Cables Prescot 38 51 50 53
9 Kidsgrove Athletic Kidsgrove 38 49 55 51
10 Trafford Trafford 38 51 55 50
11 Skelmersdale United Skelmersdale 38 58 74 48
12 City of Liverpool City 38 50 59 46
13 Bootle FC Bootle FC 38 51 61 46
14 1874 Northwich 1874 38 44 50 45
15 Newcastle Town Newcastle 38 39 67 45
16 Hanley Town Hanley Town 38 50 61 44
17 Widnes Widnes 38 40 66 44
18 Glossop Glossop 38 44 58 39
19 Colne FC Colne FC 38 38 57 37
20 Ramsbottom United Ramsbottom 38 38 82 24
TEMPORADA 2021/2022
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Warrington Rylands 1906 FC Warrington 38 93 36 85
2 Workington Workington 38 72 27 84
3 Leek Town Leek Town 38 74 36 79
4 Marine Marine 38 63 40 77
5 Runcorn Linnets Runcorn 38 72 39 76
6 Clitheroe Clitheroe 38 78 44 71
7 Bootle FC Bootle FC 38 76 63 62
8 Mossley Mossley 38 60 59 57
9 City of Liverpool City 38 48 51 53
10 Kidsgrove Athletic Kidsgrove 38 51 53 50
11 Trafford Trafford 38 56 55 49
12 1874 Northwich 1874 38 59 58 47
13 Widnes Widnes 38 46 45 47
14 Colne FC Colne FC 38 39 54 44
15 Ramsbottom United Ramsbottom 38 47 62 42
16 Newcastle Town Newcastle 38 49 64 40
17 Glossop Glossop 38 36 55 40
18 Prescot Cables Prescot 38 49 70 39
19 Kendal Town Kendal Town 38 28 90 12
20 Market Drayton Town Market 38 21 116 12
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 7
Equipo PJ GF GC Puntos
1 Atherton Collieries Atherton 38 89 34 82
2 Radcliffe Borough Radcliffe 38 73 34 75
3 Leek Town Leek Town 38 78 34 74
4 Colne FC Colne FC 38 71 44 73
5 Ramsbottom United Ramsbottom 38 78 41 72
6 Runcorn Linnets Runcorn 38 69 50 72
7 Prescot Cables Prescot 38 84 54 69
8 Mossley Mossley 38 66 51 65
9 Trafford Trafford 38 53 44 61
10 Kidsgrove Athletic Kidsgrove 38 58 40 58
11 Colwyn Bay Colwyn Bay 38 73 66 52
12 Widnes Widnes 38 60 61 51
13 Chasetown Chasetown 38 61 63 46
14 Droylsden Droylsden 38 61 72 43
15 Newcastle Town Newcastle 38 52 74 40
16 Market Drayton Town Market 37 53 90 40
17 Glossop Glossop 38 41 74 31
18 Clitheroe Clitheroe 38 45 88 28
19 Kendal Town Kendal Town 37 28 92 16
20 Skelmersdale United Skelmersdale 38 24 111 13
TEMPORADA 2017/2018
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 South Shields South 42 112 37 103
2 Scarborough Athletic Scarborough 42 101 42 95
3 Hyde Hyde 42 90 35 92
4 Bamber Bridge Bamber 42 81 54 74
5 Prescot Cables Prescot 42 78 55 72
6 Trafford Trafford 42 61 50 66
7 Tadcaster Albion Tadcaster 42 67 46 62
8 Colne FC Colne FC 42 68 61 62
9 Colwyn Bay Colwyn Bay 42 77 58 61
10 Atherton Collieries Atherton 42 50 55 58
11 Glossop Glossop 42 66 72 53
12 Clitheroe Clitheroe 42 69 79 51
13 Droylsden Droylsden 42 67 77 50
14 Ramsbottom United Ramsbottom 42 61 70 48
15 Ossett Albion Ossett 42 56 76 47
16 Ossett Town Ossett Town 42 55 77 47
17 Brighouse Town Brighouse 42 59 93 46
18 Kendal Town Kendal Town 42 61 89 45
19 Mossley Mossley 42 57 81 44
20 Radcliffe Borough Radcliffe 42 51 89 44
21 Skelmersdale United Skelmersdale 42 53 84 37
22 Goole Goole 42 49 109 31
TEMPORADA 2016/2017
NON LEAGUE DIVISION 1 GRUPO 5
Equipo PJ GF GC Puntos
1 Lancaster City Lancaster 42 73 41 85
2 Farsley Celtic Farsley 42 100 50 84
3 Colne FC Colne FC 42 74 50 73
4 Scarborough Athletic Scarborough 42 70 47 73
5 Ossett Town Ossett Town 42 68 48 73
6 Trafford Trafford 42 79 45 70
7 Clitheroe Clitheroe 42 74 54 70
8 Glossop Glossop 42 72 70 69
9 Brighouse Town Brighouse 42 66 48 68
10 Hyde Hyde 42 78 58 62
11 Ramsbottom United Ramsbottom 42 64 81 57
12 Bamber Bridge Bamber 42 59 58 55
13 Kendal Town Kendal Town 42 61 62 54
14 Droylsden Droylsden 42 71 77 54
15 Colwyn Bay Colwyn Bay 42 61 57 50
16 Prescot Cables Prescot 42 71 81 50
17 Mossley Mossley 42 67 87 46
18 Ossett Albion Ossett 42 47 78 45
19 Tadcaster Albion Tadcaster 42 57 70 44
20 Radcliffe Borough Radcliffe 42 59 82 44
21 Goole Goole 42 39 83 36
22 Burscough Burscough 42 26 109 24

  USO DE MEMORIA  
6,307,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5541
Total Execution Time  0.5558
  CADENA URL  
/historico/Colne-Fc
  GET DATOS  
$_GET['/historico/Colne-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0143  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 = 'Colne-Fc' 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.0125  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=9923 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=9923 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9923 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9923 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
0.0133  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 = '9923' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '9923' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0161  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 = '9923' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0141  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.0144  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=9923 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0136  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,68459,68333,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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 68459 AND teamId = 9923
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73103 AND teamId = 9923
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 9923
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 68333 AND teamId = 9923
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 9923
0.0127  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 = '9923' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9923' and rp.type = 4
0.0131  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 = '9923' 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 = 73103 WHERE rp.league_id = 73103 AND rp.teamId = 9923 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 = 73103 WHERE rp.league_id = 73103 AND rp.teamId = 9923 AND (e.action = 4 or e.action = 5) 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 = 73103 WHERE rp.league_id = 73103 AND rp.teamId = 9923 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 9923 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0257  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.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 `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 = 68459 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 = 63533 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.0127  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.0158  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.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 = 44462 AND t.round = 38 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 `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 = 39170 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 = 33756 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC