Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

IK Oddevold

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA SUECIA
Equipo		PJ	GF	GC	Puntos
1	Landskrona	5	8	2	11
2	Degerfors	4	7	4	8
3	Osters IF	5	7	5	8
4	IK Brage	4	5	3	8
5	Utsiktens	5	4	3	8
6	IK Oddevold	4	5	4	7
7	Sundsvall	5	5	5	7
8	Skovde AIK	4	3	3	7
9	Sandvikens	5	5	8	7
10	Helsingborgs	4	6	6	5
11	Varbergs	5	5	7	4
12	Östersunds	4	2	4	4
13	Gefle	5	7	9	3
14	Örgryte	5	5	7	3
15	Orebro SK	4	4	6	3
16	Trelleborgs	4	2	4	3

TEMPORADA 2022/2023

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	IK Oddevold	30	65	18	74
2	Falkenbergs	30	72	24	67
3	Lunds	30	48	32	55
4	Eskilsminne	30	51	34	50
5	Trollhattan	30	66	38	49
6	Norrby	30	57	44	44
7	Tvååker	30	31	39	37
8	Ariana FC	30	38	41	35
9	BK Olympic	30	39	49	35
10	Ljungskile	30	36	45	34
11	Oskarshamns	30	36	60	34
12	Torns	30	28	47	33
13	Ängelholm	30	22	53	32
14	Vänersborgs	30	30	39	31
15	Åtvidabergs	30	29	50	31
16	Ahlafors	30	22	57	31

TEMPORADA 2021/2022

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	GAIS	30	63	20	70
2	Falkenbergs	30	64	21	64
3	IK Oddevold	30	47	21	59
4	Trollhattan	30	42	23	57
5	Ljungskile	30	50	39	47
6	BK Olympic	30	49	41	47
7	Tvååker	30	42	31	45
8	Ängelholm	30	40	48	44
9	Lunds	30	44	42	42
10	Torns	30	49	48	41
11	Oskarshamns	30	30	44	31
12	Vänersborgs	30	31	45	30
13	Åtvidabergs	30	27	52	27
14	Qviding FIF	30	36	64	26
15	Lindome	30	47	74	25
16	IFK Malmö	30	21	69	11

TEMPORADA 2020/2021

CUARTA SUECIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	IK Oddevold	28	75	12	71
2	BK Forward	28	93	32	71
3	Angered	28	78	48	54
4	Ahlafors	28	58	48	48
5	Stenungsund	28	55	53	46
6	Gauthiod	28	48	54	39
7	Nordvärmlan	28	44	45	35
8	Kumla	28	43	50	34
9	Vänersborgs	28	44	69	34
10	Yxhults IK	28	45	48	33
11	Grebbestad	28	45	53	32
12	Lidköping	28	44	49	30
13	Karlstad	28	46	65	30
14	IFK Skövde	28	44	64	23
15	Tidaholms	28	23	95	12

TEMPORADA 2019/2020

CUARTA SUECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Vänersborgs	13	30	13	33
2	IK Oddevold	13	31	11	31
3	Stenungsund	13	24	16	24
4	Grebbestad	13	24	20	21
5	Ahlafors	13	33	32	21
6	Lidköping	13	25	20	19
7	Gauthiod	13	16	12	18
8	Vänersborgs	13	37	35	18
9	Nordvärmlan	13	20	20	17
10	Sävedalen	13	28	30	17
11	Carlstad	13	25	32	12
12	Tidaholms	13	18	29	8
13	Vårgårda	13	14	27	8
14	IFK Amal	13	13	41	5

TEMPORADA 2018/2019

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ljungskile	30	63	25	66
2	Landskrona	30	47	19	58
3	Utsiktens	30	49	36	51
4	Skovde AIK	30	44	33	49
5	Trollhattan	30	40	38	46
6	Tvååker	30	41	37	44
7	IFK Varnamo	30	45	45	43
8	Lunds	30	45	45	40
9	Eskilsminne	30	39	41	37
10	Lindome	30	33	36	37
11	Assyriska	30	33	41	37
12	Torns	30	35	41	36
13	Oskarshamns	30	44	56	33
14	Åtvidabergs	30	35	51	31
15	Kristianstad	30	29	63	28
16	IK Oddevold	30	30	45	23

TEMPORADA 2017/2018

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mjällby	30	73	29	69
2	Oskarshamns	30	59	36	57
3	Tvååker	30	46	34	55
4	Eskilsminne	30	51	35	53
5	Torns	30	41	31	50
6	Ljungskile	30	50	30	46
7	Lunds	30	53	49	42
8	Utsiktens	30	47	47	37
9	IK Oddevold	30	35	52	37
10	Skovde AIK	30	33	41	33
11	Åtvidabergs	30	42	52	33
12	Kristianstad	30	38	51	33
13	Karlskrona	30	39	60	33
14	Grebbestad	30	45	54	32
15	Ängelholm	30	28	61	29
16	Husqvarna	30	44	62	23

TEMPORADA 2016/2017

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Landskrona	26	51	18	58
2	Mjällby	26	60	29	53
3	Utsiktens	26	51	42	47
4	Kristianstad	26	48	32	39
5	Oskarshamns	26	42	44	39
6	Karlskrona	26	43	39	38
7	Ljungskile	26	36	37	38
8	Ängelholm	26	35	36	36
9	IK Oddevold	26	42	42	35
10	Husqvarna	26	49	42	32
11	Skovde AIK	26	30	36	31
12	Assyriska	26	34	58	28
13	Qviding FIF	26	19	52	20
14	Rosengård	26	32	65	15

TEMPORADA 2015/2016

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Osters IF	26	45	15	58
2	Norrby	26	54	33	51
3	Landskrona	26	50	25	46
4	Utsiktens	26	40	28	42
5	Kristianstad	26	35	35	37
6	Husqvarna	26	39	32	35
7	IK Oddevold	26	39	42	33
8	Mjällby	26	35	39	31
9	Qviding FIF	26	27	32	31
10	Oskarshamns	26	34	46	30
11	Trollhattan	26	29	39	29
12	Tvååker	26	30	48	28
13	Prespa	26	35	50	27
14	Höllviken	26	23	51	19

TEMPORADA 2014/2015

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Trelleborgs	26	65	25	64
2	Örgryte	26	70	26	57
3	Osters IF	26	39	19	50
4	IK Oddevold	26	46	35	40
5	Kristianstad	26	38	51	38
6	Landskrona	26	37	32	37
7	Höllviken	26	38	33	35
8	Oskarshamns	26	41	42	35
9	Qviding FIF	26	30	41	29
10	Norrby	26	45	57	29
11	Husqvarna	26	36	51	29
12	Halmia	26	41	54	25
13	Eskilsminne	26	35	51	25
14	Lunds	26	21	65	15

TEMPORADA 2013/2014

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Utsiktens	26	47	26	55
2	Örgryte	26	45	33	48
3	Lunds	26	66	45	44
4	Motala	26	53	37	44
5	IK Oddevold	26	43	44	41
6	Norrby	26	51	45	36
7	Halmia	26	39	37	36
8	Qviding FIF	26	35	38	35
9	Oskarshamns	26	39	45	34
10	Kristianstad	26	33	44	34
11	Trelleborgs	26	36	34	32
12	Trollhattan	26	42	44	32
13	Skovde AIK	26	29	50	19
14	Uddevalla	26	23	59	15

TEMPORADA 2012/2013

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Husqvarna	26	42	17	56
2	IK Oddevold	26	49	29	49
3	Trelleborgs	26	41	38	45
4	Halmia	26	40	30	43
5	Utsiktens	26	33	29	41
6	Trollhattan	26	39	36	41
7	Sylvia	26	44	41	38
8	Qviding FIF	26	34	36	34
9	Skovde AIK	26	34	36	33
10	Lunds	26	46	41	32
11	Kristianstad	26	38	43	31
12	Torslanda	26	24	39	23
13	Limhamn	26	30	56	23
14	Karlstad BK	26	25	48	17

TEMPORADA 2011/2012

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Örgryte	26	65	17	61
2	Lunds	26	49	21	56
3	IK Oddevold	26	49	30	52
4	Kristianstad	26	36	33	39
5	Trollhattan	26	47	43	36
6	Skovde AIK	26	41	42	35
7	Sylvia	26	40	55	31
8	Karlstad BK	26	37	46	30
9	Qviding FIF	26	31	40	30
10	Utsiktens	26	32	39	29
11	Limhamn	26	37	45	28
12	Sleipner	26	37	53	28
13	Norrby	26	34	53	25
14	Gauthiod	26	35	53	23

TEMPORADA 2010/2011

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Varbergs	26	56	27	54
2	Sylvia	26	54	33	49
3	Örgryte	26	49	32	47
4	IK Oddevold	26	40	39	41
5	Lunds	26	35	26	39
6	Kristianstad	26	46	38	37
7	Sleipner	26	36	50	37
8	Norrby	26	39	38	35
9	Trollhattan	26	45	45	34
10	Limhamn	26	38	41	34
11	Skovde AIK	26	31	42	33
12	Rosengård	26	34	40	28
13	Husqvarna	26	23	48	24
14	Motala	26	31	58	19

TEMPORADA 2009/2010

CUARTA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	IK Oddevold	22	64	20	52
2	Karlstad BK	22	56	30	51
3	Gunnilse	22	66	28	50
4	Utsiktens	22	39	32	34
5	Karlskoga	22	35	37	33
6	Jonsered	22	51	56	28
7	Götene	22	40	53	25
8	Gauthiod	22	37	51	25
9	Kinna	22	34	45	24
10	Annelund	22	38	50	24
11	Skarhamn IK	22	21	49	15
12	Holmalund	22	31	61	15

TEMPORADA 2008/2009

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Osters IF	26	47	35	46
2	Skovde AIK	26	44	37	46
3	Sleipner	26	44	29	45
4	Kristianstad	26	52	41	45
5	Limhamn	26	41	33	40
6	Husqvarna	26	41	34	40
7	IFK Varnamo	26	38	35	38
8	Rosengård	26	39	36	35
9	Sylvia	26	38	48	34
10	Västra	26	39	37	33
11	Torslanda	26	32	37	29
12	Motala	26	28	47	29
13	IK Oddevold	26	32	44	25
14	Lindome	26	25	47	20

TEMPORADA 2007/2008

CUARTA SUECIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	IK Oddevold	22	40	15	49
2	Gunnilse	22	43	15	48
3	Melleruds	22	44	41	39
4	Varbergs	22	47	31	37
5	Utsiktens	22	45	31	33
6	Ahlafors	22	33	31	33
7	Kinna	22	29	33	31
8	Jonsered	22	40	33	28
9	Fässberg	22	30	45	25
10	Annelund	22	28	52	22
11	Laholms FK	22	23	41	18
12	Lärje-Anger	22	22	56	12

TEMPORADA 2006/2007

CUARTA SUECIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Lindome	22	37	20	45
2	Varbergs	22	40	25	42
3	Jonsered	22	38	23	40
4	Kinna	22	30	20	36
5	Melleruds	22	30	30	33
6	Fässberg	22	28	34	32
7	Lärje-Anger	22	30	24	29
8	Ahlafors	22	38	41	26
9	Gunnilse	22	32	46	26
10	IK Oddevold	22	26	25	25
11	Sandareds	22	15	39	16
12	Skene	22	18	35	15

TEMPORADA 1996/1997

SEGUNDA SUECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Västra	26	72	24	54
2	Häcken	26	64	29	51
3	Gunnilse	26	55	23	51
4	Åtvidabergs	26	37	38	42
5	Stenungsund	26	43	35	40
6	Mjällby	26	42	38	37
7	Hässleholm	26	46	44	37
8	Motala	26	31	35	37
9	Falkenbergs	26	50	38	35
10	Norrby	26	41	45	33
11	Hertzöga	26	34	53	26
12	Vetlanda FK	26	27	65	20
13	IFK Malmö	26	30	63	17
14	IK Oddevold	26	24	66	15

TEMPORADA 1995/1996

LIGA SUECA
Equipo		PJ	GF	GC	Puntos
1	Göteborg	26	61	23	56
2	Malmö FF	26	33	26	46
3	Helsingborgs	26	39	26	44
4	AIK Solna	26	36	23	43
5	Orebro SK	26	34	29	42
6	Osters IF	26	37	39	36
7	Halmstads	26	34	37	35
8	Norrköping	26	31	29	34
9	Degerfors	26	34	41	34
10	Örgryte	26	27	30	31
11	Umeå	26	35	45	30
12	Trelleborgs	26	33	48	30
13	Djurgårdens	26	28	43	27
14	IK Oddevold	26	20	43	19

Competiciones que juega

Segunda Suecia

Pos	Equipos		Pts
1		Landskrona BoIS	11
2		Degerfors IF	8
3		Osters IF	8
4		IK Brage	8
5		Utsiktens BK	8
6		IK Oddevold	7
7		GIF Sundsvall	7
8		Skovde AIK	7
9		Sandvikens IF	7
10		Helsingborgs IF	5
11		Varbergs BoIS	4
12		Östersunds FK	4
13		Gefle	3
14		Örgryte	3
15		Orebro SK	3
16		Trelleborgs FF	3

	Ascenso : Landskrona BoIS, Degerfors IF
	Playoff Ascenso : Osters IF
	Playoff Descenso : Gefle, Örgryte
	Descenso : Orebro SK, Trelleborgs FF

RIVALES EN Copa Suecia

RIVALES EN Segunda Suecia

USO DE MEMORIA

7,333,960 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1323
Total Execution Time	0.1335

CADENA URL

/historico/Ik-Oddevold

GET DATOS

$_GET['/historico/Ik-Oddevold']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

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 = 71781
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12803 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=353 AND type_rel = 3
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 353 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	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 (1238866,1199318,1175002,919661,672477) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '12803' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '12803' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 71781 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 = 74951 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=12803 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 (74951,71781,71432,70856) 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 = 74951 AND teamId = 12803
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 70856 AND teamId = 12803
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71781 AND teamId = 12803
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12803
0.0019	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 = '12803' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '12803' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 74951 WHERE rp.league_id = 74951 AND rp.teamId = 12803 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.0026	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 = 74951 WHERE rp.league_id = 74951 AND rp.teamId = 12803 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 74951 WHERE rp.league_id = 74951 AND rp.teamId = 12803 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 = 12803 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* `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 = 66534 AND t.round = 30 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 = 62418 AND t.round = 30 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 = 55390 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.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* `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 = 48619 AND t.round = 30 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* `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 = 42430 AND t.round = 30 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* `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 = 37775 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* `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 = 20223 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* `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 = 9523 AND t.round = 26 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 = 3647 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* `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 = 2795 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* `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 = 10463 AND t.round = 26 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 = 10464 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* `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 = 25220 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* `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 = 10466 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* `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 = 27387 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 = 27412 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* `tables1997` 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 = 13946 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* `tables1996` 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 = 13064 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

IK Oddevold

IK Oddevold

Selecciona un equipo

Competiciones que juega

Segunda Suecia

RIVALES EN Copa Suecia

RIVALES EN Segunda Suecia