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

Resultados de Fútbol

HK Kopavogur

Entrenador: Ómar Ingi Gudmundsson

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Víkingur	3	7	1	9
2	ÍA Akranes	3	9	3	6
3	Breidablik	3	7	4	6
4	Reykjavík	3	7	5	6
5	Fram	3	3	1	6
6	Hafnarfjordu	3	5	4	6
7	Valur	3	2	1	4
8	Stjarnan	3	2	5	3
9	Vestri	3	1	6	3
10	KA Akureyri	3	3	5	1
11	Fylkir	3	4	9	1
12	Kopavogur	3	1	7	1

TEMPORADA 2022/2023

LIGA ISLANDIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	KA Akureyri	27	42	45	41
2	Fylkir	27	43	55	29
3	Fram	27	40	56	27
4	Kopavogur	27	41	55	27
5	ÍBV	27	31	50	25
6	Keflavik	27	27	54	16

TEMPORADA 2021/2022

LIGA ISLANDIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Breidablik	22	55	23	51
2	Víkingur	22	58	32	43
3	KA Akureyri	22	45	26	43
4	Valur	22	38	32	32
5	Reykjavík	22	37	34	31
6	Stjarnan	22	40	42	31
7	Keflavik	22	39	40	28
8	Fram	22	44	51	25
9	ÍBV	22	33	44	20
10	Leiknir	22	21	49	20
11	Hafnarfjordu	22	27	35	19
12	ÍA Akranes	22	24	53	15

TEMPORADA 2020/2021

LIGA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Víkingur	22	38	21	48
2	Breidablik	22	55	21	47
3	Reykjavík	22	35	19	41
4	KA Akureyri	22	36	20	40
5	Valur	22	37	26	39
6	Hafnarfjordu	22	39	26	33
7	Stjarnan	22	24	36	22
8	Leiknir	22	18	32	22
9	ÍA Akranes	22	29	44	21
10	Keflavik	22	23	38	21
11	Kopavogur	22	21	39	20
12	Fylkir	22	18	51	16

TEMPORADA 2019/2020

LIGA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Valur	18	50	17	44
2	Hafnarfjordu	18	37	23	36
3	Stjarnan	17	27	20	31
4	Breidablik	18	37	27	31
5	Reykjavík	17	30	21	28
6	Fylkir	18	27	30	28
7	KA Akureyri	18	20	21	21
8	ÍA Akranes	18	39	43	21
9	Kopavogur	18	29	36	20
10	Víkingur	18	25	30	17
11	IF Grótta	18	15	43	8
12	Fjölnir	18	15	40	6

TEMPORADA 2018/2019

LIGA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Reykjavík	22	44	23	52
2	Breidablik	22	45	31	38
3	Hafnarfjordu	22	40	36	37
4	Stjarnan	22	40	34	35
5	KA Akureyri	22	34	34	31
6	Valur	22	38	34	29
7	Víkingur	22	37	35	28
8	Fylkir	22	38	44	28
9	Kopavogur	22	29	29	27
10	ÍA Akranes	22	27	32	27
11	Grindavík	22	17	28	20
12	ÍBV	22	23	52	10

TEMPORADA 2017/2018

SEGUNDA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	ÍA Akranes	22	42	16	48
2	Kopavogur	22	38	13	48
3	Thór	22	46	37	43
4	Víkingur	22	38	22	42
5	Throttur	22	52	40	36
6	Njardvík	22	24	34	27
7	Leiknir	22	23	29	25
8	Haukar	22	33	45	25
9	Fram	22	37	38	24
10	IF Magni	22	27	48	19
11	Reykjavík	22	23	48	18
12	Selfoss	22	35	48	15

TEMPORADA 2016/2017

SEGUNDA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Fylkir	22	50	19	48
2	Keflavik	22	43	24	46
3	Throttur	22	37	21	42
4	Kopavogur	22	36	28	42
5	Leiknir	22	38	31	36
6	Thór	22	35	31	34
7	Haukar	22	34	39	33
8	Selfoss	22	27	29	28
9	Fram	22	32	39	27
10	Reykjavík	22	27	38	19
11	Leiknir	22	23	53	10
12	IF Grótta	22	16	46	9

TEMPORADA 2015/2016

SEGUNDA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	KA Akureyri	22	42	16	51
2	Grindavík	22	50	21	42
3	Keflavik	22	31	20	35
4	Thór	22	34	38	33
5	Haukar	22	31	35	31
6	Fram	22	25	29	30
7	Leiknir	22	21	28	29
8	Selfoss	22	28	25	28
9	Kopavogur	22	32	45	22
10	Leiknir	22	32	45	21
11	Huginn	22	20	34	21
12	Fjardabyggd	22	26	36	17

TEMPORADA 2014/2015

SEGUNDA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Víkingur	22	53	14	54
2	Throttur	22	45	21	44
3	KA Akureyri	22	42	22	41
4	Thór	22	40	34	38
5	Grindavík	22	41	30	36
6	Haukar	22	32	28	34
7	Fjardabyggd	22	35	37	31
8	Kopavogur	22	26	33	31
9	Fram	22	34	45	21
10	Selfoss	22	20	38	20
11	IF Grótta	22	10	39	15
12	BI/Bolungarv	22	22	59	10

TEMPORADA 2013/2014

SEGUNDA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Leiknir	22	43	19	48
2	ÍA Akranes	22	46	24	43
3	Throttur	22	35	27	37
4	Víkingur	22	38	32	36
5	Grindavík	22	39	24	35
6	Kopavogur	22	34	28	34
7	Haukar	22	37	32	32
8	KA Akureyri	22	42	33	31
9	Selfoss	22	24	33	26
10	BI/Bolungarv	22	34	45	25
11	Reykjavík	22	34	53	18
12	Tindastoll	22	15	71	4

TEMPORADA 2012/2013

TERCERA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Kopavogur	22	50	30	40
2	Reykjavík	22	45	30	40
3	Afturelding	22	49	32	39
4	Reykjavík	22	42	32	39
5	IF Grótta	22	30	21	38
6	Njardvík	22	43	35	31
7	Dalvík	22	32	37	30
8	Reynir	22	34	41	27
9	Sindri	22	31	38	26
10	Ægir	22	25	40	23
11	IF Höttur	22	25	39	19
12	Hamar	22	17	48	13

TEMPORADA 2011/2012

TERCERA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Völsungur	22	36	21	46
2	Fjallabyggda	22	51	23	43
3	Kopavogur	22	43	27	43
4	Reykjavík	22	43	26	40
5	Afturelding	22	50	46	40
6	Dalvík	22	38	25	36
7	Reynir	22	35	41	31
8	Njardvík	22	31	35	30
9	Hamar	22	36	41	21
10	IF Grótta	22	31	41	20
11	Fjardabyggd	22	31	48	15
12	KFR	22	20	71	6

TEMPORADA 2010/2011

SEGUNDA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	ÍA Akranes	22	53	17	51
2	Selfoss	22	44	22	47
3	Haukar	22	33	23	36
4	Víkingur	22	35	26	34
5	Fjölnir	22	34	38	32
6	BI/Bolungarv	22	27	37	31
7	Throttur	22	34	45	30
8	KA Akureyri	22	32	40	29
9	Reykjavík	22	27	42	22
10	Leiknir	22	31	32	20
11	IF Grótta	22	16	29	20
12	Kopavogur	22	23	38	16

TEMPORADA 2009/2010

SEGUNDA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Víkingur	22	46	23	48
2	Thór	22	53	23	43
3	Leiknir	22	32	19	43
4	Fjölnir	22	42	28	40
5	ÍA Akranes	22	44	28	35
6	Reykjavík	22	31	38	30
7	Throttur	22	32	37	29
8	Kopavogur	22	30	38	25
9	KA Akureyri	22	29	43	24
10	IF Grótta	22	29	47	18
11	Fjardabyggd	22	26	47	17
12	Njardvík	22	14	37	13

TEMPORADA 2008/2009

SEGUNDA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Selfoss	22	53	26	47
2	Haukar	22	44	28	44
3	KA Akureyri	23	35	26	38
4	Kopavogur	22	36	28	36
5	Fjardabyggd	21	29	31	33
6	Thór	22	33	35	31
7	Leiknir	22	32	33	29
8	Reykjavík	22	40	46	29
9	ÍA Akranes	22	26	27	28
10	Víkingur	22	36	34	26
11	Afturelding	22	25	45	16
12	Víkingur	22	24	54	13

TEMPORADA 2007/2008

LIGA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Hafnarfjordu	22	50	25	47
2	Keflavik	22	54	31	46
3	Fram	22	31	21	40
4	Reykjavík	22	38	23	39
5	Valur	22	34	28	35
6	Fjölnir	22	39	33	31
7	Grindavík	22	29	36	31
8	Breidablik	22	41	36	30
9	Fylkir	22	24	40	22
10	Throttur	22	28	46	22
11	Kopavogur	22	26	47	18
12	ÍA Akranes	22	18	46	13

TEMPORADA 2006/2007

LIGA ISLANDIA
Equipo		PJ	GF	GC	Puntos
1	Valur	18	41	20	38
2	Hafnarfjordu	18	42	26	37
3	ÍA Akranes	18	34	27	30
4	Fylkir	18	23	18	29
5	Breidablik	18	29	20	24
6	Keflavik	18	26	32	21
7	Fram	18	25	31	16
8	Reykjavík	18	17	30	16
9	Kopavogur	18	17	35	16
10	Víkingur	18	15	30	14

Competiciones que juega

Grupo 3

Liga Islandia

Pos	Equipos		Pts
1		Víkingur Reykjavík	9
2		ÍA Akranes	6
3		Breidablik	6
4		KR Reykjavík	6
5		Fram	6
6		FH Hafnarfjordur	6
7		Valur Reykjavík	4
8		Stjarnan	3
9		Vestri	3
10		KA Akureyri	1
11		Fylkir	1
12		HK Kopavogur	1

	Playoff Título : Víkingur Reykjavík, ÍA Akranes, Breidablik, KR Reykjavík, Fram, FH Hafnarfjordur
	Playoff Descenso : Valur Reykjavík, Stjarnan, Vestri, KA Akureyri, Fylkir, HK Kopavogur

RIVALES EN Copa Islandia

RIVALES EN Copa de la Liga.

RIVALES EN Liga Islandia

USO DE MEMORIA

6,690,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1431
Total Execution Time	0.1450

CADENA URL

/historico/Hk

GET DATOS

$_GET['/historico/Hk']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0044	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 = 'Hk' 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=17939 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=17939 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=17939 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=17939 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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 = 74853
0.0024	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 = 74827
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17939 AND type_rel = 2
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 = '17939' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0030	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 = '17939' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74827 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018	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 = 74853 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=17939 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 (75316,74853,74827) 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 = 74853 AND teamId = 17939
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 75316 AND teamId = 17939
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 74827 AND teamId = 17939
0.0029	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 = 74853 WHERE rp.league_id = 74853 AND rp.teamId = 17939 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.0025	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 = 74853 WHERE rp.league_id = 74853 AND rp.teamId = 17939 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 = 74853 WHERE rp.league_id = 74853 AND rp.teamId = 17939 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 = 17939 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 = 74853 AND t.round = 4 ORDER BY team.conference ASC,t.position 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* `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 = 70788 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* `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 = 73967 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.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 = 66301 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 = 66300 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 = 55072 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.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 = 48622 AND t.round = 22 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 = 42426 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 = 37967 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 = 20270 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* `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 = 9816 AND t.round = 22 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* `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 = 3755 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* `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 = 24051 AND t.round = 22 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 = 24052 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* `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 = 10558 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* `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 = 21175 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* `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 = 21174 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* `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 = 10535 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 = 10543 AND t.round = 18 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 = 74853 ORDER BY nameShow LIMIT 100


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

HK Kopavogur

HK Kopavogur

Selecciona un equipo

Competiciones que juega

Liga Islandia

RIVALES EN Copa Islandia

RIVALES EN Copa de la Liga.

RIVALES EN Liga Islandia