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

Loughgall

Entrenador: Dean Smith

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA IRLANDA DEL NORTE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Carrick	38	54	72	50
2	Dungannon	38	64	69	47
3	Loughgall	38	60	68	45
4	Glenavon	38	45	70	37
5	Ballymena	38	29	70	28
6	Newry City	38	26	99	17

TEMPORADA 2022/2023

SEGUNDA IRLANDA DEL NORTE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Loughgall	38	76	25	77
2	Warrenpoint	38	67	45	71
3	Annagh	38	58	43	59
4	Dundela	38	57	58	58
5	Ards FC	38	72	75	56
6	Ballyclare	38	66	63	55

TEMPORADA 2021/2022

SEGUNDA IRLANDA DEL NORTE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Newry City	38	70	32	73
2	Annagh	38	73	64	67
3	Loughgall	38	68	41	63
4	Ballinamalla	38	69	56	60
5	Harland	38	62	57	59
6	Dergview FC	38	57	53	55

TEMPORADA 2020/2021

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Annagh	0	0	0	0
2	Knockbreda	0	0	0	0
3	Institute	0	0	0	0
4	Harland	0	0	0	0
5	Dergview FC	0	0	0	0
6	Ards FC	0	0	0	0
7	Queens	0	0	0	0
8	Newry City	0	0	0	0
9	Dundela	0	0	0	0
10	Ballyclare	0	0	0	0
11	Ballinamalla	0	0	0	0
12	Loughgall	0	0	0	0

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 2
Equipo		PJ	GF	GC	Puntos
1	Institute	10	18	12	68
2	Newry City	10	15	8	59
3	Harland	10	13	13	56
4	Portadown	10	13	8	51
5	Ballyclare	10	12	20	48
6	Loughgall	10	11	21	38

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

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

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Ards FC	24	56	19	59
2	Warrenpoint	24	46	23	50
3	Institute	24	50	23	47
4	Dundela	24	62	51	43
5	Carrick	24	48	32	39
6	Harland	24	37	35	34
7	Dergview FC	24	27	39	27
8	Larne	24	24	40	24
9	Coagh United	24	35	51	23
10	Bangor	24	23	42	23
11	Loughgall	24	27	48	23
12	Limavady	24	34	49	21
13	Tobermore	24	38	55	21
14	Newry City	0	0	0	0

TEMPORADA 2011/2012

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Ballinamalla	26	62	24	63
2	Newry City	26	51	22	51
3	Institute	26	37	34	43
4	Bangor	26	45	34	42
5	Ards FC	26	39	31	39
6	Limavady	26	48	43	38
7	Loughgall	26	45	41	38
8	Dergview FC	26	38	37	34
9	Harland	26	30	35	34
10	Larne	26	37	47	32
11	Tobermore	26	34	44	31
12	Warrenpoint	26	34	37	28
13	Banbridge	26	30	70	19
14	Glebe	26	25	56	16

TEMPORADA 2010/2011

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Carrick	26	57	27	58
2	Limavady	26	53	27	51
3	Dergview FC	26	51	32	48
4	Bangor	26	45	38	41
5	Ballinamalla	26	45	38	39
6	Harland	26	45	38	39
7	Ards FC	26	37	42	34
8	Institute	26	28	43	34
9	Larne	26	38	41	30
10	Loughgall	26	37	48	30
11	Banbridge	26	31	39	28
12	Glebe	26	36	46	28
13	Ballymoney	26	31	48	23
14	Ballyclare	26	28	55	21

Competiciones que juega

Grupo 1

Liga Irlanda del Norte Grupo 1

Pos	Equipos		Pts
1		Larne	80
2		Linfield	78
3		Cliftonville	70
4		Glentoran	56
5		Crusaders	55
6		Coleraine	41
7		Loughgall	39
8		Carrick Rangers	38
9		Glenavon	34
10		Dungannon Swifts	32
11		Ballymena United	19
12		Newry City	17

	Playoff Título : Larne, Linfield, Cliftonville, Glentoran, Crusaders, Coleraine
	Playoff Descenso : Loughgall, Carrick Rangers, Glenavon, Dungannon Swifts, Ballymena United, Newry City

RIVALES EN Copa de Irlanda.

RIVALES EN Copa de la liga.

RIVALES EN Liga Irlanda del.

USO DE MEMORIA

6,419,432 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.2020
Total Execution Time	0.2038

CADENA URL

/historico/Loughgall

GET DATOS

$_GET['/historico/Loughgall']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0041	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 = 'Loughgall' 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=12780 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=12780 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=12780 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=12780 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=12780 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=12780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 72214
0.0027	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 = 75764
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12780 AND type_rel = 2
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=32 AND type_rel = 3
0.0026	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 32 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022	SELECT /53 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 (1184293,1175465,1153101,1134306,1128161) ORDER BY n.cover_points DESC, update_date DESC
0.0029	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 = '12780' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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 = '12780' 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 = 75764 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029	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=12780 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0067	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 (75764,74154,73203,71443,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 = 75764 AND teamId = 12780
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 71443 AND teamId = 12780
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 74154 AND teamId = 12780
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 73203 AND teamId = 12780
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12780
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 = '12780' 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 = '12780' and rp.type = 4
0.0023	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 = '12780' 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 = 72214 WHERE rp.league_id = 72214 AND rp.teamId = 12780 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 = 72214 WHERE rp.league_id = 72214 AND rp.teamId = 12780 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0056	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 = 72214 WHERE rp.league_id = 72214 AND rp.teamId = 12780 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 = 12780 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72214 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.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* `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 = 75764 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.0031	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 = 68004 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.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* `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 = 71443 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.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 = 63536 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.0029	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 = 67175 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* `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 = 60802 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* `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.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* `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.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* `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.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* `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.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 = 43170 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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.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* `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.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* `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.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* `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.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* `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.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* `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 = 24004 AND t.round = 26 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* `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 = 24006 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* `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 = 24009 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Loughgall

Loughgall

Selecciona un equipo

Competiciones que juega

Liga Irlanda del Norte Grupo 1

RIVALES EN Copa de Irlanda.

RIVALES EN Copa de la liga.

RIVALES EN Liga Irlanda del.