Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Kitchee FC

Entrenador: Dong-jin Kim

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Warriors	16	49	13	42
2	Kitchee FC	15	42	10	36
3	Eastern SC	16	35	9	34
4	Wofoo	14	28	8	32
5	Southern	16	36	15	30
6	North	15	26	34	18
7	Rangers	17	33	33	15
8	Hong Kong	14	15	35	14
9	Sham Shui	15	16	41	10
10	Hong Kong	15	9	50	6
11	Resources	17	12	53	5

TEMPORADA 2022/2023

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	18	76	7	46
2	Warriors	18	50	13	44
3	Rangers	18	41	16	33
4	Southern	18	24	25	31
5	Eastern SC	18	32	13	31
6	Hong Kong	18	18	22	26
7	Wofoo	18	20	27	20
8	Resources	18	15	34	18
9	Sham Shui	18	4	62	7
10	Hong Kong	18	6	67	1

TEMPORADA 2021/2022

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Southern	4	12	1	12
2	Kitchee FC	4	15	3	10
3	Warriors	3	9	2	7
4	Eastern SC	4	8	4	6
5	Rangers	4	11	15	6
6	Hong Kong	4	4	11	1
7	Hong Kong	4	3	16	1
8	Resources	3	3	13	0

TEMPORADA 2020/2021

LIGA HONG KONG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	17	32	12	37
2	Eastern SC	17	38	16	34
3	Warriors	17	34	21	30
4	Pegasus	17	23	27	28

TEMPORADA 2019/2020

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	11	27	9	22
2	R&F FC	9	35	10	22
3	Warriors	9	18	14	19
4	Southern	10	23	19	18
5	Eastern SC	9	15	11	16
6	Wofoo	9	16	22	9
7	Pegasus	9	12	19	6
8	Happy Valley	10	8	23	6
9	I-Sky Yuen.	9	11	23	5
10	Rangers	9	11	26	5

TEMPORADA 2018/2019

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Wofoo	18	43	22	41
2	R&F FC	18	51	26	36
3	Southern	18	30	24	32
4	Kitchee FC	18	44	20	32
5	Eastern SC	18	38	21	31
6	Pegasus	18	34	33	22
7	I-Sky Yuen.	18	36	37	18
8	HK Sapling	18	29	53	16
9	Warriors	18	12	36	11
10	Hoi King	18	13	58	8

TEMPORADA 2017/2018

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	18	67	12	50
2	Wofoo	18	36	21	37
3	Pegasus	18	37	26	34
4	Eastern SC	18	34	25	28
5	Southern	18	28	27	26
6	I-Sky Yuen.	18	21	30	23
7	R&F FC	18	27	35	22
8	Warriors	18	22	36	15
9	HK Sapling	18	18	40	15
10	Rangers	18	12	50	6

TEMPORADA 2016/2017

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	20	54	8	51
2	Eastern SC	20	60	25	49
3	Southern	20	48	21	36
4	South China	20	34	26	35
5	I-Sky Yuen.	20	36	23	31
6	Wofoo	20	29	21	31
7	Rangers	20	31	33	26
8	Pegasus	20	35	35	26
9	HK Sapling	20	24	55	10
10	R&F FC	20	13	53	10
11	Hong Kong	20	13	77	6

TEMPORADA 2015/2016

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Eastern SC	16	35	13	38
2	Kitchee FC	16	32	11	37
3	South China	16	26	21	29
4	Southern	16	26	21	23
5	Pegasus	16	22	27	17
6	Dreams Metro	16	19	30	16
7	I-Sky Yuen.	16	21	32	15
8	Wong	16	17	29	11
9	Rangers	16	15	29	11

TEMPORADA 2014/2015

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	16	40	18	36
2	Eastern SC	16	34	20	33
3	South China	16	30	17	27
4	Pegasus	16	34	23	27
5	Dreams Metro	16	25	29	26
6	I-Sky Yuen.	16	20	31	17
7	Wong	16	20	29	14
8	Rangers	16	20	33	14
9	Wofoo	16	17	40	7

TEMPORADA 2013/2014

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	18	47	12	48
2	Pegasus	18	40	28	32
3	South China	18	35	24	32
4	Eastern	18	34	37	21
5	Southern	18	25	32	21
6	Rangers	18	23	32	21
7	I-Sky Yuen.	18	25	33	20
8	Sun Hei SC	18	32	41	19
9	Citizen AA	18	25	33	18
10	Dreams Metro	18	25	39	13
11	Happy Valley	0	0	0	0
12	Tuen Mun SA	0	0	0	0

TEMPORADA 2012/2013

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	South China	18	46	21	36
2	Kitchee FC	18	39	23	32
3	Tuen Mun SA	18	29	31	28
4	Southern	18	24	27	24
5	Pegasus	18	35	29	21
6	Citizen AA	18	31	27	20
7	Sun Hei SC	18	26	33	20
8	Dreams Metro	18	25	34	20
9	Rangers	18	32	52	20
10	Wofoo	18	34	44	19

TEMPORADA 2011/2012

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	18	44	20	42
2	Pegasus	18	48	25	38
3	South China	18	47	17	36
4	Sun Hei SC	18	29	22	28
5	Tuen Mun SA	18	26	22	23
6	Citizen AA	18	29	31	23
7	Dreams Metro	18	31	38	22
8	Wofoo	18	24	40	20
9	HK Sapling	18	17	53	10
10	Sham Shui	18	9	36	6

TEMPORADA 2010/2011

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	18	52	16	44
2	South China	18	41	19	43
3	Pegasus	18	40	28	31
4	Wofoo	18	37	21	27
5	Sun Hei SC	18	36	32	27
6	Citizen AA	18	29	31	26
7	Dreams Metro	18	41	36	25
8	Tuen Mun SA	18	16	30	18
9	Tai Chung	18	19	49	11
10	Hong Kong	18	20	69	5

TEMPORADA 2009/2010

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	South China	18	49	22	40
2	Pegasus	18	33	21	35
3	Kitchee FC	18	34	18	31
4	Citizen AA	18	29	16	26
5	Sun Hei SC	18	38	27	24
6	Wofoo	18	25	27	23
7	Fourway	18	19	28	19
8	Tai Chung	18	15	25	19
9	Shatin	18	18	35	13
10	Happy Valley	18	17	58	11
11	Shek	0	0	0	0

TEMPORADA 2008/2009

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	South China	24	73	11	61
2	Kitchee FC	24	56	17	56
3	Citizen AA	24	51	23	47
4	Fourway	24	38	17	42
5	Sun Hei SC	24	39	32	42
6	Pegasus	24	51	23	41
7	Wofoo	24	40	23	41
8	Happy Valley	24	52	34	32
9	Eastern SC	24	28	33	28
10	Sheffield	24	36	43	23
11	Tuen Progoal	24	19	95	12
12	Sparta Asia	24	21	84	8
13	Shenzhen	24	12	81	5

TEMPORADA 2007/2008

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	South China	18	51	17	36
2	Citizen AA	18	31	22	34
3	Wofoo	18	36	37	27
4	Happy Valley	18	25	22	24
5	Sun Hei SC	18	26	23	23
6	Kitchee FC	18	30	33	22
7	Eastern SC	18	25	28	20
8	Lanwa	18	25	31	20
9	Rangers	18	19	35	15
10	Workable FC	18	14	34	15

TEMPORADA 2006/2007

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kitchee FC	18	51	19	42
2	South China	18	47	18	42
3	Sun Hei SC	18	33	18	31
4	Rangers	18	23	19	28
5	Sheffield	18	37	26	26
6	Happy Valley	18	27	29	25
7	Wofoo	18	28	35	24
8	Citizen AA	18	26	32	19
9	Hong Kong	18	12	46	11
10	Hong Kong	18	11	53	5

TEMPORADA 2005/2006

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Happy Valley	14	39	15	35
2	Sun Hei SC	14	30	15	26
3	Rangers	14	24	19	24
4	Kitchee FC	14	24	13	21
5	Sheffield	14	14	20	17
6	Citizen AA	14	20	25	15
7	South China	14	18	22	13
8	Hong Kong	14	3	43	2

Competiciones que juega

Grupo 6

Liga Hong Kong

Pos	Equipos		Pts
1		Lee Man Warriors	42
2		Kitchee FC	36
3		Eastern SC	34
4		Wofoo Tai Po FC	32
5		Southern District	30
6		North District	18
7		Rangers	15
8		Hong Kong FC	14
9		Sham Shui Po	10
10		Hong Kong U23 XI	6
11		Resources Capital	5

	AFC Champions League : Lee Man Warriors

RIVALES EN AFC Champions Le.

RIVALES EN Copa FA Hong Kon.

RIVALES EN Liga Hong Kong

RIVALES EN Copa Senior Shie.

USO DE MEMORIA

6,889,344 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1710
Total Execution Time	0.1730

CADENA URL

/historico/Kitchee-Fc

GET DATOS

$_GET['/historico/Kitchee-Fc']

POST DATOS

No hay datos POST existentes

CONSULTAS (58)

0.0040	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 = 'Kitchee-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.0018	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=1460 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=1460 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=1460 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=1460 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=1460 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=1460 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=1460 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=1460 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025	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 = 75720
0.0023	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 = 74315
0.0023	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 = 73684
0.0026	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 = 74318
0.0024	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 = 74209
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1460 AND type_rel = 2
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1460 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (355591,355717,359140,369204,372482) ORDER BY n.cover_points DESC, update_date DESC
0.0031	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 = '1460' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '1460' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '1460' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 73684 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 74315 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 72289 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018	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 = 74209 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030	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=1460 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (75720,74315,74209,73684,72289,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72289 AND teamId = 1460
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 73684 AND teamId = 1460
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 75720 AND teamId = 1460
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 74315 AND teamId = 1460
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 74209 AND teamId = 1460
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1460
0.0020	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 = '1460' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1460' and rp.type = 4
0.0020	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 = '1460' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032	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 = 72289 WHERE rp.league_id = 72289 AND rp.teamId = 1460 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.0028	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 = 72289 WHERE rp.league_id = 72289 AND rp.teamId = 1460 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 72289 WHERE rp.league_id = 72289 AND rp.teamId = 1460 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 1460 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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* `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 = 62631 AND t.round = 3 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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.0030	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.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* `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.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* `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.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* `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

Kitchee FC

Kitchee FC

Selecciona un equipo

Competiciones que juega

Liga Hong Kong

RIVALES EN AFC Champions Le.

RIVALES EN Copa FA Hong Kon.

RIVALES EN Liga Hong Kong

RIVALES EN Copa Senior Shie.