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

Resultados de Fútbol

South China AA

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kowloon City	19	48	19	47
2	Central	19	62	26	43
3	I-Sky Yuen.	20	41	28	34
4	South China	18	39	20	30
5	Citizen AA	19	32	28	30
6	3 Sing	19	32	24	29
7	Shatin	19	40	39	25
8	Wing Yee	20	26	40	22
9	Eastern	19	35	43	17
10	Hoi King	19	19	46	14
11	Kung	18	17	44	13
12	Wong	19	21	55	12

TEMPORADA 2022/2023

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Central	22	63	15	60
2	Kowloon City	22	58	21	50
3	South China	22	58	28	38
4	Wing Yee	22	41	22	37
5	North	21	41	23	34
6	I-Sky Yuen.	19	32	24	33
7	Hoi King	22	52	37	31
8	Shatin	22	38	45	30
9	Citizen AA	22	39	37	27
10	Happy Valley	21	37	60	25
11	Eastern	21	38	49	22
12	Wong	22	23	47	17
13	Dreams Metro	22	20	59	11
14	Kwai Tsing	22	19	92	8

TEMPORADA 2021/2022

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Wofoo	13	37	12	28
2	Shatin	13	31	19	27
3	I-Sky Yuen.	13	27	9	26
4	North	13	29	10	25
5	Eastern	13	25	17	25
6	Sham Shui	13	20	12	22
7	Wing Yee	13	19	12	21
8	Hoi King	13	15	22	17
9	Central	13	19	24	16
10	South China	12	16	22	14
11	Happy Valley	13	24	31	13
12	Citizen AA	13	12	27	10
13	Wong	13	12	32	10
14	Dreams Metro	12	7	44	0

TEMPORADA 2020/2021

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Hong Kong	13	47	4	39
2	North	13	31	13	32
3	Sham Shui	13	33	17	24
4	South China	13	31	15	24
5	Shatin	13	24	19	20
6	Wing Yee	13	22	27	18
7	I-Sky Yuen.	13	26	29	17
8	Citizen AA	13	24	27	16
9	Central	13	23	28	16
10	Hoi King	13	23	32	15
11	Eastern	13	19	20	13
12	Wofoo	13	20	32	8
13	Dreams Metro	13	19	52	8
14	Wong	13	20	47	7

TEMPORADA 2019/2020

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Resources	13	29	11	30
2	HK Sapling	13	44	27	25
3	Hong Kong	12	38	18	25
4	South China	13	30	19	24
5	Eastern	11	29	14	22
6	Central	13	22	24	21
7	Wing Yee	12	27	27	18
8	Citizen AA	13	34	33	16
9	Hoi King	12	23	20	15
10	Shatin	13	24	27	14
11	North	12	14	23	12
12	Dreams Metro	12	14	38	11
13	Wong	13	21	36	10
14	Sham Shui	12	7	39	3

TEMPORADA 2018/2019

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Happy Valley	26	98	14	68
2	Hong Kong	26	85	19	61
3	Rangers	26	56	15	51
4	Wing Yee	26	52	28	50
5	Eastern	26	53	46	38
6	Tai Chung	25	41	38	32
7	South China	26	40	51	32
8	Central	26	40	45	31
9	Shatin	25	44	50	30
10	Citizen AA	26	38	53	30
11	Wong	26	32	68	28
12	Dreams Metro	26	39	76	24
13	Double	26	32	86	22
14	Sparta Asia	26	20	81	10

TEMPORADA 2017/2018

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Hong Kong	28	108	20	74
2	Shatin	28	60	31	57
3	Eastern	28	57	49	53
4	Wing Yee	28	67	37	52
5	Sparta Asia	28	55	36	49
6	Double	28	63	49	45
7	Wong	28	65	50	44
8	Hoi King	28	38	39	39
9	Citizen AA	28	60	60	39
10	Tai Chung	29	52	59	38
11	South China	29	47	48	35
12	Dreams Metro	28	40	67	34
13	Sun Hei SC	28	48	56	31
14	Tung Sing	28	35	82	19
15	Kwun Tong	28	24	55	16
16	Wanchai	28	18	99	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

TEMPORADA 2004/2005

LIGA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Sun Hei SC	16	28	12	34
2	Happy Valley	16	45	24	32
3	Kitchee FC	16	29	21	27
4	Rangers	16	29	22	26
5	Citizen AA	16	29	28	22
6	Sunray Cave	16	19	18	18
7	South China	16	21	33	16
8	Fukien AC	16	13	24	13
9	Xiangxue	16	9	40	8

Competiciones que juega

Primera Hong Kong

Pos	Equipos		Pts
1		Kowloon City	47
2		Central & Western	43
3		I-Sky Yuen Long	34
4		South China AA	30
5		Citizen AA	30
6		3 Sing	29
7		Shatin	25
8		Wing Yee	22
9		Eastern District SA	17
10		Hoi King	14
11		Sai Kung DSA	13
12		Wong Tai Sin	12

	Ascenso : Kowloon City
	Descenso : Sai Kung DSA, Wong Tai Sin

RIVALES EN Primera Hong Kon.

USO DE MEMORIA

6,563,968 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1548
Total Execution Time	0.1561

CADENA URL

/historico/South-China-Aa

GET DATOS

$_GET['/historico/South-China-Aa']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0056	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 = 'South-China-Aa' 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.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=2368 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=2368 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2368 AND type_rel = 2
0.0027	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2368 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020	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 (95229) ORDER BY n.cover_points DESC, update_date DESC
0.0042	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 = '2368' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0053	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 = '2368' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74602 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0040	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=2368 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 (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.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 74602 AND teamId = 2368
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 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.0023	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 = '2368' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2368' and rp.type = 4
0.0021	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 = '2368' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0045	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 = 2368 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.0042	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 = 2368 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 2368 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 2368 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.0035	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.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* `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.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* `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.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* `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.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 = 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.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* `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.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* `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.0027	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.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* `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.0027	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.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* `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.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* `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.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* `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.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* `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.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* `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


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

South China AA

South China AA

Selecciona un equipo

Competiciones que juega

Primera Hong Kong

RIVALES EN Primera Hong Kon.