4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del City of Liverpool
TEMPORADA 2023/2024
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Leek Town Leek Town 38 85 44 78
2 Runcorn Linnets Runcorn 38 63 39 68
3 Prescot Cables Prescot 38 59 41 67
4 Bootle FC Bootle FC 37 60 43 66
5 Witton Albion Witton 38 65 59 63
6 City of Liverpool City 37 67 47 60
7 Clitheroe Clitheroe 38 69 56 58
8 Avro Avro 38 49 43 58
9 Nantwich Town Nantwich 38 61 47 57
10 Chasetown Chasetown 38 52 50 56
11 Widnes Widnes 37 57 43 54
12 Stalybridge Celtic Stalybridge 38 56 59 53
13 Hanley Town Hanley Town 38 37 46 47
14 Newcastle Town Newcastle 38 44 51 45
15 Mossley Mossley 38 43 56 45
16 Vauxhall Motors Vauxhall 38 51 73 44
17 Kidsgrove Athletic Kidsgrove 37 56 71 39
18 Trafford Trafford 38 40 57 39
19 Hednesford Town Hednesford 38 44 68 32
20 1874 Northwich 1874 38 24 89 18
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

  USO DE MEMORIA  
5,938,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4855
Total Execution Time  0.4868
  CADENA URL  
/historico/City-Of-Liverpool-Fc
  GET DATOS  
$_GET['/historico/City-Of-Liverpool-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0137  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 = 'City-Of-Liverpool-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=102043 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=102043 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=102043 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=102043 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=102043 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 72984
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=102043 AND type_rel = 2
0.0129  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 = '102043' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  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 = 72677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 72984 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=102043 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 (72984,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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72984 AND teamId = 102043
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 102043
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 102043
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 102043
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 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 = 72984 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '102043' 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 = '102043' and rp.type = 4
0.0127  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 = '102043' 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 = 72984 WHERE rp.league_id = 72984 AND rp.teamId = 102043 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.0128  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 = 72984 WHERE rp.league_id = 72984 AND rp.teamId = 102043 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 = 72984 WHERE rp.league_id = 72984 AND rp.teamId = 102043 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 = 102043 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72984 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 `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.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 = 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