4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
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
Ver
TEMPORADA 2020/2021
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
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Hong Kong FC Hong Kong 28 108 20 74
2 Shatin Shatin 28 60 31 57
3 Eastern District SA Eastern 28 57 49 53
4 Wing Yee Wing Yee 28 67 37 52
5 Sparta Asia FC Sparta Asia 28 55 36 49
6 Double Flower Double 28 63 49 45
7 Wong Tai Sin Wong 28 65 50 44
8 Hoi King Hoi King 28 38 39 39
9 Citizen AA Citizen AA 28 60 60 39
10 Tai Chung Tai Chung 29 52 59 38
11 South China AA South China 29 47 48 35
12 Dreams Metro Gallery Dreams Metro 28 40 67 34
13 Sun Hei SC Sun Hei SC 28 48 56 31
14 Tung Sing Tung Sing 28 35 82 19
15 Kwun Tong Kwun Tong 28 24 55 16
16 Wanchai Wanchai 28 18 99 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Sun Hei SC Sun Hei SC 13 45 11 35
2 Wong Tai Sin Wong 13 47 13 34
3 Wing Yee Wing Yee 13 46 24 30
4 Citizen AA Citizen AA 13 35 26 22
5 Eastern District SA Eastern 13 26 19 20
6 Double Flower Double 13 18 17 19
7 Shatin Shatin 13 23 18 18
8 Tai Chung Tai Chung 13 20 22 17
9 Kwun Tong Kwun Tong 13 14 17 14
10 Dreams Metro Gallery Dreams Metro 13 23 26 13
11 Tung Sing Tung Sing 13 29 35 13
12 Kwai Tsing Kwai Tsing 13 19 37 10
13 Wanchai Wanchai 13 15 33 7
14 Yau Tsim Yau Tsim 13 8 70 1
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Wofoo Tai Po FC Wofoo 26 67 29 62
2 Hong Kong FC Hong Kong 26 66 21 57
3 Sun Hei SC Sun Hei SC 26 64 25 56
4 Wing Yee Wing Yee 26 66 49 47
5 Yau Tsim Yau Tsim 26 55 35 46
6 Citizen AA Citizen AA 26 55 31 45
7 Shatin Shatin 26 48 39 42
8 Double Flower Double 26 34 46 27
9 Wanchai Wanchai 26 30 56 27
10 Tai Chung Tai Chung 26 34 63 23
11 Kwai Tsing Kwai Tsing 26 36 59 20
12 Kwun Tong Kwun Tong 26 21 52 20
13 Metro Gallery Metro 26 26 58 19
14 Lucky Mile Lucky Mile 26 28 67 19
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Metro Gallery Metro 28 81 24 72
2 Hong Kong FC Hong Kong 27 91 29 59
3 Southern District Southern 27 85 38 59
4 Yau Tsim Yau Tsim 27 75 34 58
5 Citizen AA Citizen AA 28 68 38 52
6 Lucky Mile Lucky Mile 27 54 45 46
7 Kwai Tsing Kwai Tsing 28 56 49 40
8 Sun Hei SC Sun Hei SC 28 58 55 40
9 Shatin Shatin 27 53 62 33
10 Kwun Tong Kwun Tong 28 35 54 31
11 Double Flower Double 28 38 65 25
12 Wanchai Wanchai 28 36 63 23
13 Tai Chung Tai Chung 27 31 87 22
14 Happy Valley AA Happy Valley 28 30 79 17
15 Tuen Mun SA Tuen Mun SA 28 25 94 12
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Wofoo Tai Po FC Wofoo 22 67 11 56
2 Wong Tai Sin Wong 22 56 12 54
3 Hong Kong FC Hong Kong 22 68 19 51
4 Shatin Shatin 22 54 23 44
5 Double Flower Double 22 56 36 34
6 Kwai Tsing Kwai Tsing 22 41 51 28
7 Tai Chung Tai Chung 22 40 71 25
8 Kwun Tong Kwun Tong 22 24 41 23
9 Wanchai Wanchai 22 20 44 21
10 Wing Yee Wing Yee 22 31 54 18
11 Lucky Mile Lucky Mile 22 21 58 16
12 Tuen Mun FC Tuen Mun FC 22 32 90 7
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 I-Sky Yuen Long I-Sky Yuen. 18 67 12 48
2 Tai Chung Tai Chung 18 51 21 39
3 Happy Valley AA Happy Valley 18 47 20 38
4 Eastern SC Eastern SC 18 38 20 38
5 Hong Kong FC Hong Kong 18 44 31 31
6 Wing Yee Wing Yee 18 29 34 27
7 Shatin Shatin 18 27 22 25
8 Double Flower Double 19 19 59 11
9 Wanchai Wanchai 18 22 41 9
10 Sham Shui Po Sham Shui 19 15 55 9
11 Tuen Mun FC Tuen Mun FC 18 25 69 7
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Rangers Rangers 22 69 24 50
2 Southern District Southern 22 43 23 47
3 Hong Kong FC Hong Kong 22 46 23 46
4 Wanchai Wanchai 22 35 29 40
5 Double Flower Double 22 60 35 39
6 Happy Valley AA Happy Valley 22 34 30 35
7 Shatin Shatin 22 41 43 25
8 Tai Chung Tai Chung 22 35 56 25
9 I-Sky Yuen Long I-Sky Yuen. 22 26 43 22
10 Wing Yee Wing Yee 22 36 66 21
11 Kwun Tong Kwun Tong 22 20 43 16
12 Kwai Tsing Kwai Tsing 22 25 55 9
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Sparta Asia FC Sparta Asia 22 80 27 52
2 Sham Shui Po Sham Shui 22 57 15 52
3 Double Flower Double 22 46 29 43
4 Shatin Shatin 22 40 29 42
5 Happy Valley AA Happy Valley 22 38 35 35
6 Southern District Southern 22 37 33 33
7 Rangers Rangers 22 37 38 31
8 Wing Yee Wing Yee 22 38 50 27
9 I-Sky Yuen Long I-Sky Yuen. 22 26 41 18
10 Kwai Tsing Kwai Tsing 22 26 50 18
11 Fukien AC Fukien AC 22 21 56 17
12 Lucky Mile Lucky Mile 22 21 64 10
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Hong Kong FC Hong Kong 14 43 19 31
2 Double Flower Double 14 39 16 28
3 Rangers Rangers 14 47 26 28
4 Tuen Mun SA Tuen Mun SA 14 46 16 27
5 Kwai Tsing Kwai Tsing 15 35 21 22
6 Wing Yee Wing Yee 14 47 32 19
7 Sparta Asia FC Sparta Asia 14 36 43 17
8 Fukien AC Fukien AC 15 38 41 10
9 Sai Kung Sai Kung 14 6 123 0
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Shatin Shatin 18 79 13 47
2 Tai Chung Tai Chung 18 51 20 42
3 Hong Kong FC Hong Kong 18 68 19 35
4 Wing Yee Wing Yee 18 39 31 28
5 Fukien AC Fukien AC 18 32 34 25
6 Rangers Rangers 18 32 32 23
7 Kwai Tsing Kwai Tsing 18 25 28 20
8 Double Flower Double 18 14 57 17
9 Tung Po AA Tung Po AA 18 32 65 16
10 Kwok Keung Kwok Keung 18 13 86 1

  USO DE MEMORIA  
6,193,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.5235
Total Execution Time  0.5268
  CADENA URL  
/hkfa_2nd_division2022/grupo1/historico
  GET DATOS  
$_GET['/hkfa_2nd_division2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0128  SELECT type FROM routes WHERE alias = 'hkfa_2nd_division2022'
0.0262  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'hkfa_2nd_division' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=581 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=581 ORDER BY order_id ASC
0.0128  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 581 GROUP BY l.categoryId
0.0128  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=581 GROUP BY l.year ORDER BY l.year DESC
0.0129  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 66270 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 581 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0133  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.0136  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.0146  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.0143  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.0133  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 = 38812 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 33435 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 15712 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 4444 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 3555 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2013` 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 = 23958 AND t.round = 20 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 `tables2012` 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 = 23964 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2011` 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 = 23966 AND t.round = 22 ORDER BY team.conference 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 `tables2010` 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 = 23969 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 `tables2009` 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 = 23972 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 08:50:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 08:50:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 08:50:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 08:50:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'hkfa_2nd_division' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0128  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 66270 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66270 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0128  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 66270 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66270 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0132  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 66270 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66270 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0174  SELECT *,(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