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

Ballinamallard United

Temporada 2016/2017

TEMPORADA 2016/2017

LIGA IRLANDA DEL NORTE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dungannon	5	13	6	52
2	Ards FC	5	13	8	47
3	Glentoran	5	7	7	46
4	Ballinamalla	5	10	9	35
5	Carrick	5	5	14	22
6	Portadown	5	5	9	13

TEMPORADA 2015/2016

LIGA IRLANDA DEL NORTE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dungannon	5	10	11	43
2	Ballymena	5	8	10	40
3	Portadown	5	5	5	38
4	Carrick	5	7	7	35
5	Warrenpoint	5	8	5	34
6	Ballinamalla	5	7	7	34

TEMPORADA 2014/2015

LIGA IRLANDA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Crusaders	33	85	39	73
2	Linfield	33	59	39	64
3	Cliftonville	33	65	38	57
4	Portadown	33	61	48	57
5	Glentoran	33	65	43	54
6	Glenavon	33	68	59	54
7	Coleraine	33	46	46	43
8	Ballymena	33	54	72	36
9	Dungannon	33	35	52	32
10	Ballinamalla	33	31	65	29
11	Warrenpoint	33	39	67	25
12	Institute	33	32	72	20

TEMPORADA 2013/2014

LIGA IRLANDA DEL NORTE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ballymena	5	3	5	47
2	Dungannon	5	6	7	44
3	Coleraine	5	4	3	42
4	Ballinamalla	5	7	3	39
5	Warrenpoint	5	7	6	36
6	Ards FC	5	3	6	24

TEMPORADA 2012/2013

LIGA IRLANDA DEL NORTE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cliftonville	5	10	7	91
2	Crusaders	5	11	8	83
3	Linfield	5	5	7	62
4	Glentoran	5	6	5	57
5	Ballinamalla	5	4	6	53
6	Coleraine	5	4	7	53

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

TEMPORADA 2009/2010

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Loughgall	26	60	24	60
2	Donegal	26	59	21	59
3	Limavady	26	56	29	57
4	Ards FC	26	49	27	45
5	Carrick	26	37	39	41
6	Ballinamalla	26	36	29	38
7	Ballymoney	26	39	33	38
8	Larne	26	34	37	37
9	Banbridge	26	33	48	27
10	Glebe	26	30	56	27
11	Bangor	26	36	48	26
12	Ballyclare	26	34	46	26
13	Coagh United	26	38	62	22
14	Armagh City	26	20	62	10

TEMPORADA 2008/2009

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Portadown	32	88	23	77
2	Donegal	32	65	27	73
3	Loughgall	32	77	29	70
4	Ards FC	32	53	26	65
5	Ballinamalla	32	73	47	63
6	Coagh United	32	60	43	61
7	Banbridge	32	66	67	50
8	Larne	32	53	56	43
9	Ballymoney	31	40	34	42
10	Carrick	32	56	53	42
11	Glebe	32	37	56	34
12	Armagh City	32	39	61	32
13	Limavady	32	46	72	30
14	Ballyclare	31	33	61	29
15	Tobermore	32	34	64	26
16	Dergview FC	32	31	84	19
17	Killymoon	32	33	81	17

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

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Institute	22	50	14	54
2	Bangor	22	49	23	47
3	Banbridge	22	45	31	43
4	Carrick	22	38	27	42
5	Ards FC	22	42	25	38
6	Dundela	22	33	35	29
7	Harland	22	30	36	27
8	Coagh United	22	32	41	24
9	Tobermore	22	39	54	20
10	Portstewart	22	29	44	20
11	Ballinamalla	22	14	42	15
12	Moyola Park	22	24	53	13

TEMPORADA 2005/2006

TERCERA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Ballinamalla	18	44	17	38
2	PSNI	19	34	25	35
3	Portstewart	16	25	10	31
4	Lurgan	17	33	27	29
5	Annagh	18	27	22	26
6	Wakehurst	19	27	24	26
7	Chimney	19	24	29	25
8	Brantwood	20	24	30	23
9	Dergview FC	18	25	34	20
10	Oxford	19	19	42	15
11	Queens	17	20	42	9

TEMPORADA 2004/2005

SEGUNDA IRLANDA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Armagh City	22	35	12	52
2	Glenavon	22	46	17	48
3	Donegal	22	34	19	36
4	Harland	22	35	29	36
5	Bangor	22	31	29	31
6	Coagh United	22	39	40	30
7	Ballyclare	22	22	24	28
8	Dundela	22	28	33	27
9	Moyola Park	22	18	29	23
10	Carrick	22	25	37	22
11	Ballymoney	22	29	46	20
12	Ballinamalla	22	15	42	12

TEMPORADA 2003/2004

SEGUNDA IRLANDA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Loughgall	22	37	20	48
2	Armagh City	22	30	15	43
3	Ballyclare	22	34	21	43
4	Bangor	22	35	20	39
5	Harland	22	29	24	33
6	Ballymoney	22	22	26	29
7	Carrick	22	30	35	25
8	Donegal	22	29	27	23
9	Ballinamalla	22	20	31	21
10	Moyola Park	22	34	41	18
11	Lurgan	22	24	44	18
12	Brantwood	22	18	38	18

Competiciones que juega

Grupo 1

Liga Irlanda del Norte Grupo 1

Pos	Equipos		Pts
1		Crusaders	78
2		Linfield	74
3		Coleraine	60
4		Cliftonville	58
5		Ballymena United	52
6		Glenavon	45
7		Dungannon Swifts	40
8		Glentoran	39
9		Ards FC	36
10		Ballinamallard United	29
11		Carrick Rangers	21
12		Portadown	7

	Playoff Ascenso : Crusaders, Linfield, Coleraine, Cliftonville, Ballymena United, Glenavon
	Playoff Descenso : Dungannon Swifts, Glentoran, Ards FC, Ballinamallard United, Carrick Rangers, Portadown

RIVALES EN Copa de Irlanda.

RIVALES EN Copa de la liga.

RIVALES EN Liga Irlanda del.

USO DE MEMORIA

6,563,744 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.2159
Total Execution Time	0.2174

CADENA URL

/historico/Ballinamallar/2017

GET DATOS

$_GET['/historico/Ballinamallar/2017']

POST DATOS

No hay datos POST existentes

CONSULTAS (56)

0.0051	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 = 'Ballinamallar' AND l.year = 2017 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=9989 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=9989 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=9989 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=9989 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=9989 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=9989 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028	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 = 33884
0.0028	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 = 38220
0.0028	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 = 36108
0.0028	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 = 33898
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9989 AND type_rel = 2
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=32 AND type_rel = 3
0.0021	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.0033	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 = '9989' ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '9989' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '9989' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 36108 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 33898 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 33884 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030	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=9989 AND l.year in (2016,2017,2018) 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 (43420,43215,41023,38945,38427) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 43215 AND teamId = 9989
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 43420 AND teamId = 9989
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 41023 AND teamId = 9989
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 38945 AND teamId = 9989
0.0157	SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 9989
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 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 = 33884 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '9989' 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 = '9989' 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 = '9989' 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 events2017 e ON e.player_id = p.id AND e.league_id = 33884 WHERE rp.league_id = 33884 AND rp.teamId = 9989 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.0051	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 events2017 e ON e.player_id = p.id AND e.league_id = 33884 WHERE rp.league_id = 33884 AND rp.teamId = 9989 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 events2017 e ON e.player_id = p.id AND e.league_id = 33884 WHERE rp.league_id = 33884 AND rp.teamId = 9989 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039	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 = 9989 AND l.year <= 2017 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* `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 = 33884 AND t.round = 33 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 = 38220 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049	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 = 15503 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* `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 = 23945 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* `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 = 15502 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* `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 = 3891 AND t.round = 33 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 = 2484 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* `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 = 10129 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* `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.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 = 10130 AND t.round = 5 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* `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.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* `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
0.0045	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 = 24012 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* `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 = 24015 AND t.round = 34 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.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* `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 = 24018 AND t.round = 22 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* `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 = 24035 AND t.round = 20 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* `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 = 24021 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* `tables2004` 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 = 27730 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 dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 33884 ORDER BY nameShow LIMIT 100

Ballinamallard United

Ballinamallard United

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.