4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Lee Man Warriors Warriors 16 49 13 42
2 Kitchee FC Kitchee FC 15 42 10 36
3 Eastern SC Eastern SC 16 35 9 34
4 Wofoo Tai Po FC Wofoo 14 28 8 32
5 Southern District Southern 16 36 15 30
6 North District North 15 26 34 18
7 Rangers Rangers 17 33 33 15
8 Hong Kong FC Hong Kong 14 15 35 14
9 Sham Shui Po Sham Shui 15 16 41 10
10 Hong Kong U23 XI Hong Kong 15 9 50 6
11 Resources Capital Resources 17 12 53 5
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 76 7 46
2 Lee Man Warriors Warriors 18 50 13 44
3 Rangers Rangers 18 41 16 33
4 Southern District Southern 18 24 25 31
5 Eastern SC Eastern SC 18 32 13 31
6 Hong Kong FC Hong Kong 18 18 22 26
7 Wofoo Tai Po FC Wofoo 18 20 27 20
8 Resources Capital Resources 18 15 34 18
9 Sham Shui Po Sham Shui 18 4 62 7
10 Hong Kong U23 XI Hong Kong 18 6 67 1
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Southern District Southern 4 12 1 12
2 Kitchee FC Kitchee FC 4 15 3 10
3 Lee Man Warriors Warriors 3 9 2 7
4 Eastern SC Eastern SC 4 8 4 6
5 Rangers Rangers 4 11 15 6
6 Hong Kong FC Hong Kong 4 4 11 1
7 Hong Kong U23 XI Hong Kong 4 3 16 1
8 Resources Capital Resources 3 3 13 0
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 14 29 9 34
2 Eastern SC Eastern SC 14 33 12 31
3 Pegasus Pegasus 14 20 17 25
4 Lee Man Warriors Warriors 14 26 19 21
5 Southern District Southern 14 24 30 12
6 Resources Capital Resources 14 11 35 12
7 Rangers Rangers 14 14 23 11
8 Happy Valley AA Happy Valley 14 14 26 9
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 11 27 9 22
2 R&F FC R&F FC 9 35 10 22
3 Lee Man Warriors Warriors 9 18 14 19
4 Southern District Southern 10 23 19 18
5 Eastern SC Eastern SC 9 15 11 16
6 Wofoo Tai Po FC Wofoo 9 16 22 9
7 Pegasus Pegasus 9 12 19 6
8 Happy Valley AA Happy Valley 10 8 23 6
9 I-Sky Yuen Long I-Sky Yuen. 9 11 23 5
10 Rangers Rangers 9 11 26 5
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Wofoo Tai Po FC Wofoo 18 43 22 41
2 R&F FC R&F FC 18 51 26 36
3 Southern District Southern 18 30 24 32
4 Kitchee FC Kitchee FC 18 44 20 32
5 Eastern SC Eastern SC 18 38 21 31
6 Pegasus Pegasus 18 34 33 22
7 I-Sky Yuen Long I-Sky Yuen. 18 36 37 18
8 HK Sapling HK Sapling 18 29 53 16
9 Lee Man Warriors Warriors 18 12 36 11
10 Hoi King Hoi King 18 13 58 8
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 67 12 50
2 Wofoo Tai Po FC Wofoo 18 36 21 37
3 Pegasus Pegasus 18 37 26 34
4 Eastern SC Eastern SC 18 34 25 28
5 Southern District Southern 18 28 27 26
6 I-Sky Yuen Long I-Sky Yuen. 18 21 30 23
7 R&F FC R&F FC 18 27 35 22
8 Lee Man Warriors Warriors 18 22 36 15
9 HK Sapling HK Sapling 18 18 40 15
10 Rangers Rangers 18 12 50 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 20 54 8 51
2 Eastern SC Eastern SC 20 60 25 49
3 Southern District Southern 20 48 21 36
4 South China AA South China 20 34 26 35
5 I-Sky Yuen Long I-Sky Yuen. 20 36 23 31
6 Wofoo Tai Po FC Wofoo 20 29 21 31
7 Rangers Rangers 20 31 33 26
8 Pegasus Pegasus 20 35 35 26
9 HK Sapling HK Sapling 20 24 55 10
10 R&F FC R&F FC 20 13 53 10
11 Hong Kong FC Hong Kong 20 13 77 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Eastern SC Eastern SC 16 35 13 38
2 Kitchee FC Kitchee FC 16 32 11 37
3 South China AA South China 16 26 21 29
4 Southern District Southern 16 26 21 23
5 Pegasus Pegasus 16 22 27 17
6 Dreams Metro Gallery Dreams Metro 16 19 30 16
7 I-Sky Yuen Long I-Sky Yuen. 16 21 32 15
8 Wong Tai Sin Wong 16 17 29 11
9 Rangers Rangers 16 15 29 11
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 16 40 18 36
2 Eastern SC Eastern SC 16 34 20 33
3 South China AA South China 16 30 17 27
4 Pegasus Pegasus 16 34 23 27
5 Dreams Metro Gallery Dreams Metro 16 25 29 26
6 I-Sky Yuen Long I-Sky Yuen. 16 20 31 17
7 Wong Tai Sin Wong 16 20 29 14
8 Rangers Rangers 16 20 33 14
9 Wofoo Tai Po FC Wofoo 16 17 40 7
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 47 12 48
2 TSW Pegasus FC Pegasus 18 40 28 32
3 South China AA South China 18 35 24 32
4 Eastern Salon Eastern 18 34 37 21
5 Southern District Southern 18 25 32 21
6 Rangers Rangers 18 23 32 21
7 I-Sky Yuen Long I-Sky Yuen. 18 25 33 20
8 Sun Hei SC Sun Hei SC 18 32 41 19
9 Citizen AA Citizen AA 18 25 33 18
10 Dreams Metro Gallery Dreams Metro 18 25 39 13
11 Happy Valley AA Happy Valley 0 0 0 0
12 Tuen Mun SA Tuen Mun SA 0 0 0 0
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 South China AA South China 18 46 21 36
2 Kitchee FC Kitchee FC 18 39 23 32
3 Tuen Mun SA Tuen Mun SA 18 29 31 28
4 Southern District Southern 18 24 27 24
5 Pegasus Pegasus 18 35 29 21
6 Citizen AA Citizen AA 18 31 27 20
7 Sun Hei SC Sun Hei SC 18 26 33 20
8 Dreams Metro Gallery Dreams Metro 18 25 34 20
9 Rangers Rangers 18 32 52 20
10 Wofoo Tai Po FC Wofoo 18 34 44 19
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 44 20 42
2 TSW Pegasus FC Pegasus 18 48 25 38
3 South China AA South China 18 47 17 36
4 Sun Hei SC Sun Hei SC 18 29 22 28
5 Tuen Mun SA Tuen Mun SA 18 26 22 23
6 Citizen AA Citizen AA 18 29 31 23
7 Dreams Metro Gallery Dreams Metro 18 31 38 22
8 Wofoo Tai Po FC Wofoo 18 24 40 20
9 HK Sapling HK Sapling 18 17 53 10
10 Sham Shui Po Sham Shui 18 9 36 6
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 52 16 44
2 South China AA South China 18 41 19 43
3 TSW Pegasus FC Pegasus 18 40 28 31
4 Wofoo Tai Po FC Wofoo 18 37 21 27
5 Sun Hei SC Sun Hei SC 18 36 32 27
6 Citizen AA Citizen AA 18 29 31 26
7 Dreams Metro Gallery Dreams Metro 18 41 36 25
8 Tuen Mun SA Tuen Mun SA 18 16 30 18
9 Tai Chung Tai Chung 18 19 49 11
10 Hong Kong FC Hong Kong 18 20 69 5
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 South China AA South China 18 49 22 40
2 TSW Pegasus FC Pegasus 18 33 21 35
3 Kitchee FC Kitchee FC 18 34 18 31
4 Citizen AA Citizen AA 18 29 16 26
5 Sun Hei SC Sun Hei SC 18 38 27 24
6 Wofoo Tai Po FC Wofoo 18 25 27 23
7 Fourway Rangers Fourway 18 19 28 19
8 Tai Chung Tai Chung 18 15 25 19
9 Shatin Shatin 18 18 35 13
10 Happy Valley AA Happy Valley 18 17 58 11
11 Shek Kip Mei Shek 0 0 0 0
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 South China AA South China 24 73 11 61
2 Kitchee FC Kitchee FC 24 56 17 56
3 Citizen AA Citizen AA 24 51 23 47
4 Fourway Rangers Fourway 24 38 17 42
5 Sun Hei SC Sun Hei SC 24 39 32 42
6 TSW Pegasus FC Pegasus 24 51 23 41
7 Wofoo Tai Po FC Wofoo 24 40 23 41
8 Happy Valley AA Happy Valley 24 52 34 32
9 Eastern SC Eastern SC 24 28 33 28
10 Sheffield United HK Sheffield 24 36 43 23
11 Tuen Mun Progoal Tuen Progoal 24 19 95 12
12 Sparta Asia FC Sparta Asia 24 21 84 8
13 Shenzhen Xiangxue Eisiti Shenzhen 24 12 81 5
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 South China AA South China 18 51 17 36
2 Citizen AA Citizen AA 18 31 22 34
3 Wofoo Tai Po FC Wofoo 18 36 37 27
4 Happy Valley AA Happy Valley 18 25 22 24
5 Sun Hei SC Sun Hei SC 18 26 23 23
6 Kitchee FC Kitchee FC 18 30 33 22
7 Eastern SC Eastern SC 18 25 28 20
8 Lanwa Redbull Lanwa 18 25 31 20
9 Rangers Rangers 18 19 35 15
10 Workable FC Workable FC 18 14 34 15
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 51 19 42
2 South China AA South China 18 47 18 42
3 Sun Hei SC Sun Hei SC 18 33 18 31
4 Rangers Rangers 18 23 19 28
5 Sheffield United HK Sheffield 18 37 26 26
6 Happy Valley AA Happy Valley 18 27 29 25
7 Wofoo Tai Po FC Wofoo 18 28 35 24
8 Citizen AA Citizen AA 18 26 32 19
9 Hong Kong FC Hong Kong 18 12 46 11
10 Hong Kong 08 Hong Kong 18 11 53 5
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Happy Valley AA Happy Valley 14 39 15 35
2 Sun Hei SC Sun Hei SC 14 30 15 26
3 Rangers Rangers 14 24 19 24
4 Kitchee FC Kitchee FC 14 24 13 21
5 Sheffield United HK Sheffield 14 14 20 17
6 Citizen AA Citizen AA 14 20 25 15
7 South China AA South China 14 18 22 13
8 Hong Kong 08 Hong Kong 14 3 43 2
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Sun Hei SC Sun Hei SC 16 28 12 34
2 Happy Valley AA Happy Valley 16 45 24 32
3 Kitchee FC Kitchee FC 16 29 21 27
4 Rangers Rangers 16 29 22 26
5 Citizen AA Citizen AA 16 29 28 22
6 Sunray Cave Sunray Cave 16 19 18 18
7 South China AA South China 16 21 33 16
8 Fukien AC Fukien AC 16 13 24 13
9 Xiangxue Xiangxue 16 9 40 8
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Sun Hei SC Sun Hei SC 18 47 18 44
2 Kitchee FC Kitchee FC 18 43 19 42
3 Happy Valley AA Happy Valley 17 41 21 38
4 Rangers Rangers 18 32 25 27
5 Xiangxue Xiangxue 18 28 26 22
6 Nancheng Nancheng 18 25 28 20
7 South China AA South China 18 21 28 20
8 Sunray Cave Sunray Cave 19 17 33 18
9 Fukien AC Fukien AC 17 15 30 15
10 Fire Services Fire 19 15 56 6

  USO DE MEMORIA  
6,453,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.1475
Total Execution Time  0.1499
  CADENA URL  
/liga_hong_kong2024/grupo1/historico
  GET DATOS  
$_GET['/liga_hong_kong2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_hong_kong2024'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_hong_kong' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=55 ORDER BY order_id ASC
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 55 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 72289 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 68878 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 65420 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 59981 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 49915 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 43695 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 38783 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 33436 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 15711 AND t.round = 18 ORDER BY team.conference 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 `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 = 4441 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 3023 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 2180 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 1587 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 1586 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 1061 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 1060 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2008` 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 = 264 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2007` 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 = 10470 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2006` 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 = 15644 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2005` 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 = 15645 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2004` 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 = 15647 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 18:58:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 18:58:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0032  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 18:58:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 18:58:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_hong_kong' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0074  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 events2024 e ON e.player_id = p.id AND e.league_id = 72289 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72289 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.0148  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 events2024 e ON e.player_id = p.id AND e.league_id = 72289 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72289 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0026  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 events2024 e ON e.player_id = p.id AND e.league_id = 72289 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72289 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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 = 72289 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC