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

PSNI

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Limavady	24	67	31	52
2	Armagh City	25	52	34	49
3	Rathfriland	25	46	24	46
4	Ballymacash	24	52	34	43
5	Queens	24	55	39	40
6	Dollingstown	25	47	45	38
7	Coagh United	24	38	34	33
8	Lisburn	24	29	39	31
9	Warrenpoint	25	38	39	30
10	Banbridge	25	44	56	30
11	Moyola Park	24	31	43	29
12	Portstewart	25	26	44	25
13	Tobermore	24	24	48	22
14	PSNI	24	26	65	16

TEMPORADA 2022/2023

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Bangor	22	55	8	59
2	Ballymacash	22	58	19	47
3	Queens	22	45	32	45
4	Limavady	22	40	22	41
5	Moyola Park	22	34	26	32
6	Tobermore	22	35	38	28
7	Lisburn	22	26	43	27
8	Dollingstown	22	34	36	24
9	Portstewart	22	26	41	21
10	Banbridge	22	27	46	20
11	Armagh City	22	29	53	18
12	PSNI	22	25	70	12

TEMPORADA 2021/2022

TERCERA IRLANDA DEL NORTE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Portstewart	24	42	28	32
2	Lisburn	24	38	39	32
3	Moyola Park	24	31	54	20
4	PSNI	24	27	72	16
5	Tobermore	24	16	70	7

TEMPORADA 2019/2020

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Portadown	31	72	30	66
2	Loughgall	31	66	40	62
3	Ballinamalla	30	71	34	60
4	Ards FC	31	65	44	52
5	Newry City	30	55	32	51
6	Dundela	31	43	49	46
7	Ballyclare	30	53	49	40
8	Harland	31	52	63	35
9	Queens	31	59	69	34
10	Dergview FC	30	38	54	29
11	PSNI	30	40	98	23
12	Knockbreda	30	34	86	22

TEMPORADA 2018/2019

SEGUNDA IRLANDA DEL NORTE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dergview FC	10	22	5	25
2	Limavady	10	16	15	14
3	Loughgall	10	17	13	13
4	Knockbreda	10	13	18	12
5	Ballyclare	10	18	21	11
6	PSNI	10	12	26	8

TEMPORADA 2017/2018

SEGUNDA IRLANDA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Institute	22	37	24	49
2	Harland	22	41	29	40
3	Newry City	22	43	23	39
4	Ballyclare	22	44	32	39
5	Loughgall	22	33	39	34
6	Portadown	22	48	28	33
7	Larne	22	33	38	29
8	Knockbreda	22	28	30	25
9	Limavady	22	36	42	25
10	PSNI	22	27	38	22
11	Dergview FC	22	24	47	16
12	Lurgan	22	27	51	15

TEMPORADA 2016/2017

SEGUNDA IRLANDA DEL NORTE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Warrenpoint	10	21	9	22
2	Institute	10	22	11	20
3	PSNI	10	14	10	17
4	Ballyclare	10	10	20	10
5	Loughgall	10	8	16	9
6	Dergview FC	10	11	20	9

TEMPORADA 2015/2016

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Limavady	26	66	27	59
2	PSNI	26	59	23	59
3	Sport	26	59	28	47
4	Tobermore	26	38	31	44
5	Moyola Park	26	40	34	41
6	Banbridge	26	35	34	36
7	Queens	26	35	37	36
8	Dundela	26	38	47	36
9	Newington	26	38	38	34
10	Dollingstown	26	46	51	34
11	Glebe	26	34	46	32
12	Coagh United	26	28	54	22
13	Portstewart	26	34	58	21
14	Wakehurst	26	25	67	7

TEMPORADA 2013/2014

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Armagh City	30	90	26	77
2	PSNI	30	84	28	66
3	Queens	30	47	32	63
4	Newington	30	56	32	54
5	Annagh	30	75	53	52
6	Banbridge	30	60	44	50
7	Moyola Park	30	61	53	46
8	Portstewart	30	52	46	43
9	Ballymoney	30	61	59	39
10	Tobermore	30	47	63	34
11	Glebe	30	48	64	33
12	Lurgan	30	41	67	33
13	Wakehurst	30	47	75	27
14	Chimney	30	38	75	23
15	Sport	30	37	70	22
16	Killymoon	30	33	90	18

TEMPORADA 2012/2013

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Knockbreda	30	106	25	77
2	Ballyclare	30	77	28	71
3	Armagh City	30	81	34	66
4	Lurgan	30	71	43	63
5	Glebe	30	58	41	52
6	Wakehurst	30	61	50	52
7	Queens	30	65	43	45
8	PSNI	30	60	48	43
9	Banbridge	30	57	58	40
10	Ballymoney	30	53	67	37
11	Annagh	30	39	53	34
12	Moyola Park	30	35	51	28
13	Portstewart	30	37	70	22
14	Sport	30	41	101	20
15	Killymoon	30	38	85	19
16	Chimney	30	26	108	11

TEMPORADA 2011/2012

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Coagh United	30	81	41	63
2	Dundela	30	79	46	62
3	Knockbreda	30	70	31	61
4	Lurgan	30	73	40	57
5	Queens	30	63	38	55
6	Ballyclare	30	60	46	52
7	Annagh	30	59	51	51
8	Wakehurst	30	59	48	47
9	Ballymoney	30	51	45	39
10	Portstewart	30	43	56	37
11	Armagh City	30	39	52	33
12	Sport	30	46	59	32
13	PSNI	30	36	67	29
14	Moyola Park	30	34	71	29
15	Killymoon	30	34	72	24
16	Chimney	30	26	90	17

TEMPORADA 2010/2011

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Warrenpoint	30	84	26	73
2	Tobermore	30	67	36	64
3	Knockbreda	30	59	32	62
4	Dundela	30	74	41	57
5	Queens	30	61	35	55
6	Coagh United	30	66	48	54
7	Wakehurst	30	62	54	46
8	Sport	30	52	58	42
9	Portstewart	30	51	52	38
10	PSNI	30	56	58	37
11	Lurgan	30	48	62	33
12	Armagh City	30	43	60	33
13	Annagh	30	34	66	26
14	Killymoon	30	37	64	24
15	Moyola Park	30	31	67	23
16	Chimney	30	35	101	7

TEMPORADA 2009/2010

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Harland	27	72	27	71
2	Dergview FC	26	67	18	58
3	Dundela	26	62	28	57
4	PSNI	26	48	35	47
5	Tobermore	26	43	34	45
6	Knockbreda	26	36	30	42
7	Queens	27	42	40	34
8	Portstewart	26	34	37	34
9	Lurgan	26	37	45	34
10	Sport	26	38	56	31
11	Moyola Park	26	36	40	29
12	Annagh	26	27	60	23
13	Killymoon	26	36	54	22
14	Wakehurst	26	30	49	19
15	Chimney	26	29	84	10

TEMPORADA 2008/2009

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Harland	22	55	18	59
2	Dundela	22	70	19	56
3	PSNI	22	38	27	40
4	Queens	22	36	24	35
5	Lurgan	22	44	36	35
6	Annagh	22	33	30	30
7	Oxford	22	26	31	29
8	Portstewart	22	23	38	25
9	Moyola Park	22	24	37	24
10	Wakehurst	22	22	36	17
11	Brantwood	22	23	56	14
12	Chimney	22	19	61	11

TEMPORADA 2007/2008

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Dergview FC	22	65	18	54
2	Ballymoney	22	44	20	48
3	Ballinamalla	23	47	15	43
4	Glebe	21	40	24	39
5	Annagh	22	33	24	39
6	PSNI	21	36	28	30
7	Wakehurst	22	32	27	30
8	Oxford	22	33	37	29
9	Brantwood	23	26	44	22
10	Queens	22	25	45	17
11	Chimney	22	25	75	15
12	Moyola Park	22	18	67	7

TEMPORADA 2006/2007

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Ballyclare	21	45	13	55
2	Lurgan	23	46	21	46
3	Wakehurst	22	40	31	35
4	Oxford	22	26	28	33
5	Ballymoney	22	31	27	32
6	PSNI	21	35	39	29
7	Brantwood	22	38	36	27
8	Annagh	22	21	21	26
9	Chimney	23	28	54	24
10	Dergview FC	22	20	36	21
11	Queens	22	25	40	20
12	Glebe	22	17	26	19

Competiciones que juega

Tercera Irlanda del Norte

Pos	Equipos		Pts
1		Limavady	52
2		Armagh City	49
3		Rathfriland Rangers	46
4		Ballymacash Rangers	43
5		Queens University Belfast	40
6		Dollingstown	38
7		Coagh United	33
8		Lisburn Distillery	31
9		Warrenpoint Town	30
10		Banbridge Town	30
11		Moyola Park	29
12		Portstewart	25
13		Tobermore United	22
14		PSNI	16

	Ascenso : Limavady
	Playoff Ascenso : Armagh City
	Descenso : PSNI

RIVALES EN Copa de Irlanda.

RIVALES EN Copa de la liga.

RIVALES EN Tercera Irlanda.

USO DE MEMORIA

6,711,392 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1680
Total Execution Time	0.1699

CADENA URL

/historico/Psni

GET DATOS

$_GET['/historico/Psni']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0064	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 = 'Psni' 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=65080 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=65080 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=65080 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=65080 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0049	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 = 72499
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65080 AND type_rel = 2
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1816 AND type_rel = 3
0.0036	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 = '65080' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0039	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 = '65080' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 72499 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035	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=65080 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 (74154,73203,72499) 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 = 72499 AND teamId = 65080
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 74154 AND teamId = 65080
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 73203 AND teamId = 65080
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 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 = 72499 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '65080' 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 = '65080' and rp.type = 4
0.0022	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 = '65080' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040	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 = 72499 WHERE rp.league_id = 72499 AND rp.teamId = 65080 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.0040	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 = 72499 WHERE rp.league_id = 72499 AND rp.teamId = 65080 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72499 WHERE rp.league_id = 72499 AND rp.teamId = 65080 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 = 65080 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 = 72499 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.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* `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 = 68005 AND t.round = 22 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 = 63537 AND t.round = 22 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 = 67356 AND t.round = 5 ORDER BY team.conference ASC,t.position 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* `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 = 50173 AND t.round = 33 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* `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 = 44215 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* `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 = 48929 AND t.round = 10 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 = 43171 AND t.round = 10 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* `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 = 38814 AND t.round = 22 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* `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 = 37174 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* `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 = 38064 AND t.round = 10 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 = 16175 AND t.round = 26 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* `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 = 24016 AND t.round = 30 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* `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 = 24019 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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 = 24022 AND t.round = 30 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* `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 = 24023 AND t.round = 30 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* `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 = 24028 AND t.round = 28 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* `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 = 24030 AND t.round = 22 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* `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 = 24032 AND t.round = 22 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* `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 = 24034 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

PSNI

PSNI

Selecciona un equipo

Competiciones que juega

Tercera Irlanda del Norte

RIVALES EN Copa de Irlanda.

RIVALES EN Copa de la liga.

RIVALES EN Tercera Irlanda.