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

Lisburn Distillery

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

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Annagh	14	32	14	33
2	Portstewart	14	28	13	30
3	Dollingstown	13	31	15	25
4	Bangor	12	30	21	20
5	Newington	11	16	18	18
6	Armagh City	14	15	26	14
7	Banbridge	12	16	20	13
8	Lisburn	13	13	25	13
9	Moyola Park	12	21	28	10
10	Limavady	13	21	32	9
11	Tobermore	12	14	25	8

TEMPORADA 2018/2019

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Queens	22	55	16	56
2	Annagh	22	55	26	44
3	Tobermore	22	48	32	41
4	Lisburn	22	41	37	36
5	Banbridge	22	37	27	33
6	Portstewart	22	28	28	32
7	Newington	22	31	35	29
8	Moyola Park	22	36	39	27
9	Dollingstown	22	35	48	20
10	Armagh City	22	24	44	20
11	Lurgan	22	23	48	19
12	Sport	22	32	65	14

TEMPORADA 2017/2018

TERCERA IRLANDA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dundela	22	60	27	48
2	Queens	22	53	31	43
3	Banbridge	22	43	30	40
4	Lisburn	22	39	29	39
5	Moyola Park	22	45	33	35
6	Tobermore	22	44	44	28
7	Armagh City	22	32	33	27
8	Sport	22	36	51	27
9	Portstewart	22	27	45	25
10	Annagh	22	29	52	22
11	Newington	22	29	47	20
12	Donegal	22	31	46	18

TEMPORADA 2016/2017

TERCERA IRLANDA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Limavady	22	54	22	46
2	Newry City	22	49	28	41
3	Donegal	22	43	37	37
4	Banbridge	22	34	29	35
5	Moyola Park	22	35	31	34
6	Tobermore	22	34	36	31
7	Bangor	22	43	49	26
8	Newington	21	27	39	26
9	Dundela	21	35	38	25
10	Queens	22	26	37	25
11	Lisburn	22	30	44	25
12	Sport	22	22	42	21

TEMPORADA 2015/2016

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Ards FC	26	59	35	54
2	Harland	26	54	28	51
3	Armagh City	26	64	36	44
4	Knockbreda	26	48	32	43
5	Institute	26	40	20	42
6	Larne	26	64	45	42
7	Lurgan	26	40	40	39
8	Ballyclare	26	44	40	37
9	Loughgall	26	44	55	36
10	Bangor	26	43	41	35
11	Dergview FC	26	41	40	35
12	Annagh	26	37	57	27
13	Donegal	26	34	80	10
14	Lisburn	26	20	83	10

TEMPORADA 2014/2015

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Carrick	26	57	23	64
2	Bangor	26	71	32	60
3	Ards FC	26	61	30	56
4	Harland	26	59	37	50
5	Larne	26	52	36	42
6	Dergview FC	26	41	46	32
7	Armagh City	26	38	48	32
8	Knockbreda	26	31	43	30
9	Ballyclare	26	46	48	28
10	Lisburn	26	38	58	28
11	Loughgall	26	36	54	27
12	Donegal	26	35	42	24
13	Northern	26	27	64	23
14	Dundela	26	34	65	13

TEMPORADA 2013/2014

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Bangor	27	68	42	55
2	Institute	24	67	33	48
3	Carrick	24	48	28	46
4	Dundela	25	66	47	43
5	Knockbreda	24	51	32	43
6	Harland	25	44	32	40
7	Loughgall	25	46	53	33
8	Ballyclare	24	45	44	31
9	Larne	25	28	47	30
10	Lisburn	25	41	49	28
11	Donegal	24	36	46	26
12	Dergview FC	24	28	43	23
13	Coagh United	23	34	68	19
14	Limavady	25	19	57	15

TEMPORADA 2012/2013

LIGA IRLANDA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cliftonville	33	85	31	79
2	Crusaders	33	71	33	71
3	Linfield	33	64	41	58
4	Glentoran	33	57	39	52
5	Coleraine	33	46	50	50
6	Ballinamalla	33	45	37	48
7	Portadown	33	47	46	45
8	Ballymena	33	41	62	37
9	Dungannon	33	35	51	33
10	Glenavon	33	48	56	30
11	Donegal	33	26	70	21
12	Lisburn	33	29	78	19

TEMPORADA 2011/2012

LIGA IRLANDA DEL NORTE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ballymena	5	15	6	50
2	Donegal	5	4	17	41
3	Dungannon	5	9	9	35
4	Glenavon	5	15	11	34
5	Lisburn	5	11	11	32
6	Carrick	5	11	11	31

TEMPORADA 2010/2011

LIGA IRLANDA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Linfield	33	70	27	70
2	Crusaders	33	69	51	67
3	Glentoran	33	55	32	59
4	Cliftonville	33	52	49	52
5	Lisburn	33	44	52	45
6	Portadown	33	45	53	44
7	Coleraine	33	40	46	43
8	Ballymena	33	42	50	41
9	Glenavon	33	51	53	39
10	Dungannon	33	42	49	39
11	Donegal	33	49	78	28
12	Newry City	33	37	56	26

TEMPORADA 2009/2010

LIGA IRLANDA DEL NORTE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Coleraine	5	9	7	57
2	Glenavon	5	5	10	43
3	Newry City	5	10	7	42
4	Ballymena	5	7	8	40
5	Lisburn	5	10	6	39
6	Institute	5	5	8	31

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,482,648 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.1562
Total Execution Time	0.1580

CADENA URL

/historico/Lisburn-Distillery

GET DATOS

$_GET['/historico/Lisburn-Distillery']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0036	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 = 'Lisburn-Distillery' 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=9996 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=9996 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=9996 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=9996 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=9996 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=9996 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1816 AND type_rel = 3
0.0054	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 = '9996' ORDER BY l.year DESC,cat.coefficient 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 = '9996' 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 = '9996' 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 = 72499 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=9996 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,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 = 72499 AND teamId = 9996
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 74154 AND teamId = 9996
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 73203 AND teamId = 9996
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9996
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 = '9996' 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 = '9996' 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 = '9996' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038	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 = 9996 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.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 = 72499 WHERE rp.league_id = 72499 AND rp.teamId = 9996 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 9996 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035	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 = 9996 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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 = 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.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* `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.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* `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 = 50312 AND t.round = 17 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 = 44216 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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 = 43324 AND t.round = 5 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* `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 = 38828 AND t.round = 22 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* `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 = 43327 AND t.round = 5 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 = 37175 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* `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 = 15622 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* `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 = 4203 AND t.round = 26 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 = 2793 AND t.round = 25 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 = 10131 AND t.round = 5 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* `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 = 2034 AND t.round = 33 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* `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 = 1559 AND t.round = 33 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 = 10133 AND t.round = 5 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* `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 = 10134 AND t.round = 5 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* `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 = 1369 AND t.round = 33 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* `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 = 10137 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Lisburn Distillery

Lisburn Distillery

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.