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

Citizen AA

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Kowloon City	19	48	19	47
2	Central	20	64	27	46
3	I-Sky Yuen.	20	41	28	34
4	South China	19	40	22	30
5	Citizen AA	19	32	28	30
6	3 Sing	19	32	24	29
7	Shatin	20	42	42	25
8	Wing Yee	20	26	40	22
9	Eastern	19	35	43	17
10	Hoi King	20	22	48	17
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

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Sun Hei SC	13	45	11	35
2	Wong	13	47	13	34
3	Wing Yee	13	46	24	30
4	Citizen AA	13	35	26	22
5	Eastern	13	26	19	20
6	Double	13	18	17	19
7	Shatin	13	23	18	18
8	Tai Chung	13	20	22	17
9	Kwun Tong	13	14	17	14
10	Dreams Metro	13	23	26	13
11	Tung Sing	13	29	35	13
12	Kwai Tsing	13	19	37	10
13	Wanchai	13	15	33	7
14	Yau Tsim	13	8	70	1

TEMPORADA 2015/2016

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Wofoo	26	67	29	62
2	Hong Kong	26	66	21	57
3	Sun Hei SC	26	64	25	56
4	Wing Yee	26	66	49	47
5	Yau Tsim	26	55	35	46
6	Citizen AA	26	55	31	45
7	Shatin	26	48	39	42
8	Double	26	34	46	27
9	Wanchai	26	30	56	27
10	Tai Chung	26	34	63	23
11	Kwai Tsing	26	36	59	20
12	Kwun Tong	26	21	52	20
13	Metro	26	26	58	19
14	Lucky Mile	26	28	67	19

TEMPORADA 2014/2015

PRIMERA HONG KONG
Equipo		PJ	GF	GC	Puntos
1	Metro	28	81	24	72
2	Hong Kong	27	91	29	59
3	Southern	27	85	38	59
4	Yau Tsim	27	75	34	58
5	Citizen AA	28	68	38	52
6	Lucky Mile	27	54	45	46
7	Kwai Tsing	28	56	49	40
8	Sun Hei SC	28	58	55	40
9	Shatin	27	53	62	33
10	Kwun Tong	28	35	54	31
11	Double	28	38	65	25
12	Wanchai	28	36	63	23
13	Tai Chung	27	31	87	22
14	Happy Valley	28	30	79	17
15	Tuen Mun SA	28	25	94	12

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	46
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	17
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,673,016 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7531
Total Execution Time	0.7543

CADENA URL

/historico/Citizen-Aa

GET DATOS

$_GET['/historico/Citizen-Aa']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0201	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 = 'Citizen-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.0145	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=776 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=776 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0303	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.0148	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=776 AND type_rel = 2
0.0148	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=581 AND type_rel = 3
0.0171	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 = '776' ORDER BY l.year DESC,cat.coefficient DESC
0.0170	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 = '776' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0167	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 = '776' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155	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.0154	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=776 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 74602 AND teamId = 776
0.0149	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.0146	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 = '776' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '776' and rp.type = 4
0.0146	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 = '776' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0153	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 = 776 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.0153	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 = 776 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 = 776 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 776 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149	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.0151	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.0147	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.0147	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.0149	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.0149	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.0151	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.0147	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.0148	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.0149	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.0150	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.0149	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.0148	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.0147	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.0154	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.0149	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.0148	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.0148	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.0148	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.0147	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

Citizen AA

Citizen AA

Selecciona un equipo

Competiciones que juega

Primera Hong Kong

RIVALES EN Primera Hong Kon.