4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Central & Western
TEMPORADA 2023/2024
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Kowloon City Kowloon City 19 48 19 47
2 Central & Western Central 20 64 27 46
3 I-Sky Yuen Long I-Sky Yuen. 20 41 28 34
4 South China AA South China 19 40 22 30
5 Citizen AA Citizen AA 19 32 28 30
6 3 Sing 3 Sing 19 32 24 29
7 Shatin Shatin 20 42 42 25
8 Wing Yee Wing Yee 20 26 40 22
9 Eastern District SA Eastern 19 35 43 17
10 Hoi King Hoi King 20 22 48 17
11 Sai Kung DSA Kung 18 17 44 13
12 Wong Tai Sin Wong 19 21 55 12
TEMPORADA 2022/2023
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Central & Western Central 22 63 15 60
2 Kowloon City Kowloon City 22 58 21 50
3 South China AA South China 22 58 28 38
4 Wing Yee Wing Yee 22 41 22 37
5 North District North 21 41 23 34
6 I-Sky Yuen Long I-Sky Yuen. 19 32 24 33
7 Hoi King Hoi King 22 52 37 31
8 Shatin Shatin 22 38 45 30
9 Citizen AA Citizen AA 22 39 37 27
10 Happy Valley AA Happy Valley 21 37 60 25
11 Eastern District SA Eastern 21 38 49 22
12 Wong Tai Sin Wong 22 23 47 17
13 Dreams Metro Gallery Dreams Metro 22 20 59 11
14 Kwai Tsing Kwai Tsing 22 19 92 8
TEMPORADA 2021/2022
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Wofoo Tai Po FC Wofoo 13 37 12 28
2 Shatin Shatin 13 31 19 27
3 I-Sky Yuen Long I-Sky Yuen. 13 27 9 26
4 North District North 13 29 10 25
5 Eastern District SA Eastern 13 25 17 25
6 Sham Shui Po Sham Shui 13 20 12 22
7 Wing Yee Wing Yee 13 19 12 21
8 Hoi King Hoi King 13 15 22 17
9 Central & Western Central 13 19 24 16
10 South China AA South China 12 16 22 14
11 Happy Valley AA Happy Valley 13 24 31 13
12 Citizen AA Citizen AA 13 12 27 10
13 Wong Tai Sin Wong 13 12 32 10
14 Dreams Metro Gallery Dreams Metro 12 7 44 0
TEMPORADA 2020/2021
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Hong Kong FC Hong Kong 13 47 4 39
2 North District North 13 31 13 32
3 Sham Shui Po Sham Shui 13 33 17 24
4 South China AA South China 13 31 15 24
5 Shatin Shatin 13 24 19 20
6 Wing Yee Wing Yee 13 22 27 18
7 I-Sky Yuen Long I-Sky Yuen. 13 26 29 17
8 Citizen AA Citizen AA 13 24 27 16
9 Central & Western Central 13 23 28 16
10 Hoi King Hoi King 13 23 32 15
11 Eastern District SA Eastern 13 19 20 13
12 Wofoo Tai Po FC Wofoo 13 20 32 8
13 Dreams Metro Gallery Dreams Metro 13 19 52 8
14 Wong Tai Sin Wong 13 20 47 7
TEMPORADA 2019/2020
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Resources Capital Resources 13 29 11 30
2 HK Sapling HK Sapling 13 44 27 25
3 Hong Kong FC Hong Kong 12 38 18 25
4 South China AA South China 13 30 19 24
5 Eastern District SA Eastern 11 29 14 22
6 Central & Western Central 13 22 24 21
7 Wing Yee Wing Yee 12 27 27 18
8 Citizen AA Citizen AA 13 34 33 16
9 Hoi King Hoi King 12 23 20 15
10 Shatin Shatin 13 24 27 14
11 North District North 12 14 23 12
12 Dreams Metro Gallery Dreams Metro 12 14 38 11
13 Wong Tai Sin Wong 13 21 36 10
14 Sham Shui Po Sham Shui 12 7 39 3
TEMPORADA 2018/2019
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Happy Valley AA Happy Valley 26 98 14 68
2 Hong Kong FC Hong Kong 26 85 19 61
3 Rangers Rangers 26 56 15 51
4 Wing Yee Wing Yee 26 52 28 50
5 Eastern District SA Eastern 26 53 46 38
6 Tai Chung Tai Chung 25 41 38 32
7 South China AA South China 26 40 51 32
8 Central & Western Central 26 40 45 31
9 Shatin Shatin 25 44 50 30
10 Citizen AA Citizen AA 26 38 53 30
11 Wong Tai Sin Wong 26 32 68 28
12 Dreams Metro Gallery Dreams Metro 26 39 76 24
13 Double Flower Double 26 32 86 22
14 Sparta Asia FC Sparta Asia 26 20 81 10
TEMPORADA 2017/2018
SEGUNDA HONG KONG
Equipo PJ GF GC Puntos
1 Happy Valley AA Happy Valley 26 58 16 63
2 Central & Western Central 26 48 21 51
3 Tuen Mun SA Tuen Mun SA 26 34 35 46
4 Sun Source FC Source 26 48 44 44
5 Fu Moon AA Fu Moon AA 26 35 42 39
6 Sham Shui Po Sham Shui 26 36 24 38
7 Kowloon City Kowloon City 26 43 42 36
8 Kwong Wah AA Kwong 26 34 31 34
9 Yau Tsim Yau Tsim 26 29 44 30
10 Lucky Mile Lucky Mile 26 38 43 26
11 Kwai Tsing Kwai Tsing 26 27 42 26
12 Fukien AC Fukien AC 26 20 26 24
13 Sai Kung DSA Kung 26 28 45 24
14 Sai Kung Sai Kung 26 25 48 24
TEMPORADA 2016/2017
SEGUNDA HONG KONG
Equipo PJ GF GC Puntos
1 Sparta Asia FC Sparta Asia 22 43 20 50
2 Central & Western Central 22 46 14 46
3 Hoi King Hoi King 22 46 22 44
4 Lucky Mile Lucky Mile 22 38 25 44
5 Kowloon City Kowloon City 22 28 21 38
6 Sham Shui Po Sham Shui 22 21 27 29
7 Sun Source FC Source 22 33 31 28
8 Tuen Mun SA Tuen Mun SA 22 27 31 27
9 Sai Kung DSA Kung 22 13 36 17
10 Kwong Wah AA Kwong 22 15 41 15
11 Kwok Keung Kwok Keung 22 18 35 15
12 Tuen Mun FC Tuen Mun FC 22 25 50 15
TEMPORADA 2015/2016
TERCERA HONG KONG
Equipo PJ GF GC Puntos
1 Hoi King Hoi King 30 77 16 80
2 Central & Western Central 30 101 11 79
3 Leaper FC Leaper FC 30 63 24 60
4 North District North 30 65 46 56
5 Wing Go Wing Go 30 55 44 51
6 Kowloon City DRSC Kowloon City 30 57 48 51
7 Gospel FC Gospel FC 30 60 33 48
8 V Sports V Sports 30 43 40 46
9 Fukien AC Fukien AC 30 54 49 41
10 Ornaments FC Ornaments 30 47 56 40
11 Islands District Islands 30 38 61 31
12 PCCW-HKT Telephone Ltd PCCW-HKT 29 42 61 29
13 New Fair Kui Tan Fair 29 37 55 26
14 King Mountain SA King 30 29 94 20
15 Kowloon CC Kowloon CC 30 36 74 17
16 HKFYG HKFYG 30 16 108 5
TEMPORADA 2014/2015
TERCERA HONG KONG
Equipo PJ GF GC Puntos
1 Tung Sing Tung Sing 26 93 12 69
2 Central & Western Central 26 81 16 63
3 Leaper FC Leaper FC 26 60 26 54
4 Fukien AC Fukien AC 26 60 27 53
5 Sai Kung Sai Kung 26 64 26 47
6 North District North 26 54 31 46
7 Islands District Islands 26 58 49 43
8 Kowloon City DRSC Kowloon City 26 43 38 34
9 Ornaments FC Ornaments 26 49 87 27
10 PCCW-HKT Telephone Ltd PCCW-HKT 26 43 60 26
11 Fu Moon AA Fu Moon AA 26 35 66 19
12 King Mountain SA King 26 29 76 19
13 Kowloon CC Kowloon CC 26 21 74 14
14 Lung Moon Lung Moon 26 22 124 4
TEMPORADA 2013/2014
TERCERA HONG KONG
Equipo PJ GF GC Puntos
1 Sai Kung DSA Kung 20 86 10 52
2 Sai Kung Sai Kung 20 41 21 46
3 Central & Western Central 20 47 20 38
4 Tung Sing Tung Sing 20 51 18 37
5 Ornaments FC Ornaments 20 31 46 31
6 Islands District Islands 20 39 44 29
7 Leaper FC Leaper FC 20 32 28 25
8 Fukien AC Fukien AC 20 41 30 24
9 North District North 20 30 51 18
10 Lung Moon Lung Moon 20 27 46 15
11 Solon Solon 20 7 118 0

  USO DE MEMORIA  
5,856,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4524
Total Execution Time  0.4537
  CADENA URL  
/historico/Central-Western-District-Rsa
  GET DATOS  
$_GET['/historico/Central-Western-District-Rsa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0114  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 = 'Central-Western-District-Rsa' 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.0106  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=114165 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=114165 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0214  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 = 74602
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=114165 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=581 AND type_rel = 3
0.0108  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 = '114165' ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '114165' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0107  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 = '114165' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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 = 74602 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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=114165 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0105  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 (74602) 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.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 74602 AND teamId = 114165
0.0108  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 = 74602 AND t.round = 20 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '114165' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '114165' and rp.type = 4
0.0107  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 = '114165' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0123  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 = 74602 WHERE rp.league_id = 74602 AND rp.teamId = 114165 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.0129  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 = 74602 WHERE rp.league_id = 74602 AND rp.teamId = 114165 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  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 = 74602 WHERE rp.league_id = 74602 AND rp.teamId = 114165 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 = 114165 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0113  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 = 74602 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119  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 = 70754 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 66270 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.0117  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 = 61912 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.0118  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 = 50118 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.0120  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 = 45910 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 56405 AND t.round = 26 ORDER BY team.conference 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 `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 = 56406 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2016` 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 = 56413 AND t.round = 30 ORDER BY team.conference 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 `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 = 56414 AND t.round = 26 ORDER BY team.conference 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 `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 = 56415 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC