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

KÍ II

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	B36 II	7	16	5	17
2	B71 Sandoy	7	12	6	16
3	NSÍ II	7	14	11	14
4	AB Argir	7	11	6	11
5	Suduroy	7	13	9	11
6	Tvøroyri	7	10	8	9
7	KÍ II	7	9	12	9
8	Vikingur II	7	13	13	7
9	HB II	7	7	19	2
10	FC Hoyvík	7	2	18	1

TEMPORADA 2022/2023

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	Skála ÍF	27	83	20	70
2	NSÍ	27	67	29	57
3	KÍ II	27	63	40	47
4	Vikingur II	27	61	42	47
5	B71 Sandoy	27	58	39	47
6	FC Hoyvík	27	48	53	37
7	B36 II	27	56	50	33
8	HB II	27	42	65	27
9	B68 II	27	26	82	17
10	Streymur	27	23	107	9

TEMPORADA 2021/2022

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	Fuglafjørdu	27	57	33	56
2	Vikingur II	27	81	40	55
3	Tvøroyri	27	69	39	52
4	B71 Sandoy	27	54	30	52
5	KÍ II	27	65	41	46
6	Undrid	27	46	42	42
7	HB II	27	45	59	33
8	B36 II	27	44	62	27
9	NSÍ II	27	31	92	15
10	Vestur	27	25	79	8

TEMPORADA 2020/2021

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	Skála ÍF	27	59	31	53
2	Vikingur II	27	68	42	46
3	AB Argir	27	53	37	44
4	B71 Sandoy	27	56	48	42
5	HB II	27	52	55	41
6	NSÍ II	27	57	60	40
7	KÍ II	27	43	47	33
8	B36 II	27	42	60	30
9	Suduroy	27	40	61	26
10	Streymur	27	40	69	25

TEMPORADA 2019/2020

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	Vikingur II	27	73	36	58
2	07 Vestur	27	60	33	54
3	NSÍ II	27	80	42	52
4	B68 Toftir	27	56	34	46
5	KÍ II	27	56	54	38
6	B36 II	27	43	53	34
7	HB II	27	53	79	33
8	B71 Sandoy	27	53	52	32
9	AB II	27	35	58	23
10	FC Hoyvík	27	29	97	10

TEMPORADA 2018/2019

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	KÍ II	27	75	37	57
2	Vikingur II	27	51	27	55
3	NSÍ II	27	68	40	53
4	07 Vestur	27	57	48	44
5	B68 Toftir	27	44	44	35
6	B36 II	27	52	53	30
7	B71 Sandoy	27	49	72	30
8	HB II	27	40	44	29
9	Skála	27	37	47	28
10	Streymur	27	31	92	12

TEMPORADA 2017/2018

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	Fuglafjørdu	27	91	39	66
2	NSÍ II	27	83	38	52
3	KÍ II	27	68	34	52
4	B68 Toftir	27	60	34	52
5	Vikingur II	27	43	45	38
6	HB II	27	48	46	32
7	Skála	27	46	59	32
8	B71 Sandoy	27	45	67	28
9	Giza Hoyvík	27	36	49	26
10	Royn	27	20	129	7

TEMPORADA 2016/2017

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	AB Argir	27	86	20	64
2	Vikingur II	27	52	28	51
3	KÍ II	27	64	36	49
4	B68 Toftir	27	60	43	46
5	HB II	27	62	49	39
6	NSÍ II	27	69	61	39
7	Giza Hoyvík	27	50	48	36
8	Suduroy	27	49	70	31
9	B36 II	27	82	63	27
10	IF II	27	14	170	0

TEMPORADA 2015/2016

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	Streymur	27	105	28	67
2	07 Vestur	27	98	34	65
3	Suduroy	27	67	40	54
4	Giza Hoyvík	27	60	40	48
5	NSÍ II	27	59	83	34
6	KÍ II	27	53	67	33
7	Vikingur II	27	42	60	31
8	HB II	27	50	69	30
9	AB II	27	22	73	14
10	B71 Sandoy	27	36	98	13

TEMPORADA 2014/2015

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	Skála ÍF	27	96	17	70
2	B68 Toftir	27	61	27	56
3	07 Vestur	27	66	36	48
4	AB II	27	50	41	46
5	KÍ II	27	65	50	38
6	Vikingur II	27	39	43	33
7	B71 Sandoy	27	47	56	33
8	NSÍ II	27	54	54	31
9	B36 II	27	32	71	20
10	Midvágur	27	18	133	5

TEMPORADA 2013/2014

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	Tvøroyri	27	73	21	67
2	Suduroy	27	54	34	48
3	07 Vestur	27	54	41	47
4	B36 II	27	53	52	36
5	AB II	27	49	46	35
6	NSÍ II	27	54	52	34
7	Vikingur II	27	41	51	34
8	KÍ II	27	44	62	29
9	HB II	27	41	65	29
10	Streymur	27	32	71	17

TEMPORADA 2012/2013

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	B68 Toftir	27	75	31	56
2	Skála ÍF	27	74	41	48
3	HB II	27	64	42	48
4	Suduroy	27	64	50	43
5	B36 II	27	63	49	43
6	Vikingur II	27	47	55	34
7	Streymur	27	45	63	32
8	KÍ II	27	50	56	30
9	TB II	27	42	75	28
10	B71 Sandoy	27	23	85	21

TEMPORADA 2011/2012

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	07 Vestur	27	68	19	68
2	AB Argir	27	82	25	61
3	Skála ÍF	27	58	29	54
4	HB II	27	53	34	47
5	KÍ II	27	57	58	38
6	Vikingur II	27	53	52	36
7	Streymur	27	36	59	30
8	B71 Sandoy	27	48	72	27
9	B68 II	27	29	80	14
10	NSÍ II	27	30	86	14

TEMPORADA 2010/2011

TERCERA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	KÍ II	18	79	29	49
2	B68 II	18	63	18	41
3	B36 II	18	45	21	38
4	Undrid	18	60	36	31
5	Royn	18	40	45	21
6	Suduroy II	18	33	39	21
7	AB II	18	30	55	19
8	TB II	18	32	40	17
9	IF II	18	35	61	17
10	Hoyvík	18	14	87	0

TEMPORADA 2009/2010

TERCERA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	Skála ÍF	18	67	17	41
2	Hoyvík	18	49	29	40
3	Vestur	18	60	31	36
4	B36 II	18	47	18	35
5	KÍ II	18	46	47	26
6	Suduroy II	18	38	39	25
7	TB II	18	36	55	17
8	IF II	18	26	63	14
9	Vikingur	18	24	55	12
10	Midvágur	18	22	61	11

TEMPORADA 2007/2008

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	AB Argir	27	98	32	64
2	07 Vestur	27	109	39	62
3	Suduroy	27	63	28	57
4	Tvøroyri	27	62	22	53
5	Vikingur II	27	36	73	30
6	HB II	27	35	52	28
7	NSÍ II	27	49	74	26
8	B68 II	27	49	65	25
9	KÍ II	27	33	86	20
10	Streymur	27	28	91	20

TEMPORADA 2006/2007

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	B68 Toftir	27	79	20	72
2	Fuglafjørdu	27	84	22	61
3	Vágar 2004	27	47	39	51
4	Tvøroyri	27	56	30	46
5	LÍF Leirvik	27	67	45	43
6	NSÍ II	27	49	68	31
7	HB II	27	38	61	29
8	SI Sorvagur	27	40	66	28
9	KÍ II	27	28	70	17
10	B36 II	27	22	89	12

TEMPORADA 2005/2006

SEGUNDA ISLAS FEROE
Equipo		PJ	GF	GC	Puntos
1	B71 Sandoy	21	72	26	49
2	AB Argir	21	54	27	47
3	LÍF Leirvik	21	39	25	37
4	Tvøroyri	21	33	32	30
5	HB II	21	42	49	24
6	Vágar 2004	21	28	37	22
7	KÍ II	21	36	70	21
8	SI Sorvagur	21	36	74	11

Competiciones que juega

Segunda Islas Feroe

Pos	Equipos		Pts
1		B36 II	17
2		B71 Sandoy	16
3		NSÍ II	14
4		AB Argir	11
5		Suduroy	11
6		TB Tvøroyri	9
7		KÍ II	9
8		Vikingur II	7
9		HB II	2
10		FC Hoyvík	1

	Ascenso : B36 II
	Playoff Ascenso : B71 Sandoy
	Descenso : HB II, FC Hoyvík

RIVALES EN Segunda Islas Fe.

USO DE MEMORIA

6,045,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.1256
Total Execution Time	0.1278

CADENA URL

/historico/Ki-Klaksvik-Ii

GET DATOS

$_GET['/historico/Ki-Klaksvik-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0032	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 = 'Ki-Klaksvik-Ii' 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=61640 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=61640 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 75393
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61640 AND type_rel = 2
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1634 AND type_rel = 3
0.0022	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 = '61640' ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '61640' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020	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 = '61640' 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 = 75393 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=61640 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (75393) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 75393 AND teamId = 61640
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 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 = 75393 AND t.round = 8 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 = '61640' 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 = '61640' and rp.type = 4
0.0020	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 = '61640' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028	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 = 75393 WHERE rp.league_id = 75393 AND rp.teamId = 61640 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 = 75393 WHERE rp.league_id = 75393 AND rp.teamId = 61640 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 75393 WHERE rp.league_id = 75393 AND rp.teamId = 61640 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 61640 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 = 75393 AND t.round = 8 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 = 70884 AND t.round = 27 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 = 66693 AND t.round = 27 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* `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 = 61749 AND t.round = 27 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* `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 = 55313 AND t.round = 27 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 = 48915 AND t.round = 27 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 = 43124 AND t.round = 27 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* `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 = 38051 AND t.round = 27 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* `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 = 38048 AND t.round = 27 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* `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 = 9477 AND t.round = 27 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* `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 = 16190 AND t.round = 27 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 = 16189 AND t.round = 27 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* `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 = 16188 AND t.round = 27 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* `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 = 16193 AND t.round = 18 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* `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 = 16192 AND t.round = 18 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* `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 = 16184 AND t.round = 27 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* `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 = 16183 AND t.round = 27 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* `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 = 16182 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

KÍ II

KÍ II

Selecciona un equipo

Competiciones que juega

Segunda Islas Feroe

RIVALES EN Segunda Islas Fe.