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

IFK Hässleholm

Temporada 2023/2024

TEMPORADA 2023/2024

CUARTA SUECIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hässleholms	5	10	1	13
2	Karlskrona	5	12	4	13
3	Österlen	4	9	4	10
4	Karlshamn	5	8	8	9
5	Kristianstad	4	10	4	8
6	Simrishamn	5	7	10	7
7	FBK Balkan	5	7	7	6
8	Högaborgs	5	8	10	6
9	Lodde	5	4	3	5
10	Hässleholm	4	4	8	4
11	Nosaby	4	2	6	4
12	Trelleborg	4	4	8	2
13	IFK Berga	4	4	7	1
14	Räppe	5	6	15	1

TEMPORADA 2022/2023

CUARTA SUECIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Rosengård	26	62	27	63
2	Hässleholms	26	60	17	62
3	Hässleholm	26	58	43	47
4	Karlskrona	26	47	32	46
5	Räppe	26	65	38	45
6	Simrishamn	26	49	45	37
7	Kristianstad	26	33	31	34
8	FBK Balkan	26	41	53	33
9	IFK Berga	26	38	47	31
10	Trelleborg	26	44	48	27
11	Nosaby	26	34	52	26
12	Österlen	26	37	54	25
13	VMA	26	26	80	17
14	IFK Malmö	26	37	64	16

TEMPORADA 2021/2022

CUARTA SUECIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Ariana FC	26	51	24	50
2	IFK Berga	26	41	25	49
3	Rosengård	26	47	32	47
4	Hässleholms	26	58	30	44
5	Nosaby	26	34	34	40
6	Österlen	26	38	34	38
7	Räppe	26	47	43	37
8	Kristianstad	26	41	40	37
9	Hässleholm	26	40	40	36
10	Karlskrona	26	36	35	35
11	FBK Balkan	26	31	47	29
12	Högsby	26	31	52	28
13	Eslövs	26	27	42	22
14	Asarum	26	32	76	19

TEMPORADA 2020/2021

CUARTA SUECIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	BK Olympic	28	44	22	54
2	Hässleholms	28	50	30	51
3	Rosengård	28	51	35	47
4	IFK Berga	28	44	33	46
5	Hässleholm	28	45	36	43
6	Räppe	28	47	38	42
7	Karlskrona	28	44	38	42
8	FBK Balkan	28	50	53	40
9	Eslövs	28	51	45	38
10	Kristianstad	28	43	42	37
11	Asarum	28	42	54	34
12	Nosaby	28	46	44	32
13	Karlshamn	28	30	41	32
14	Sölvesborg	28	44	66	31
15	Prespa	28	28	82	16

TEMPORADA 2019/2020

CUARTA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Österlen	13	30	9	31
2	Dalstorps	13	21	13	25
3	Syrianska	13	14	12	24
4	Nosaby	13	28	20	22
5	Hässleholms	13	25	21	22
6	Räppe	13	20	18	20
7	Asarum	13	24	25	19
8	Husqvarna	13	20	20	17
9	Karlshamn	13	17	23	17
10	IK Tord	13	22	21	16
11	Kristianstad	13	15	25	14
12	Hässleholm	13	22	26	13
13	Almeboda	13	19	34	11
14	Bromölla	13	13	23	9

TEMPORADA 2018/2019

CUARTA SUECIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Karlskrona	26	55	25	56
2	IFK Berga	26	53	33	51
3	Husqvarna	26	41	29	50
4	Räppe	26	45	33	43
5	Österlen	26	45	43	40
6	Dalstorps	26	36	26	37
7	Asarum	26	41	47	36
8	Nosaby	26	42	47	35
9	Hässleholm	26	50	44	34
10	Hässleholms	26	40	38	34
11	Almeboda	26	36	39	30
12	Bromölla	26	29	37	30
13	Råslätts	26	25	53	17
14	Nässjö	26	22	66	12

TEMPORADA 2017/2018

CUARTA SUECIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Assyriska	26	54	31	51
2	IFK Berga	26	49	34	46
3	Bromölla	26	34	21	45
4	Råslätts	26	47	39	42
5	Nosaby	26	48	41	41
6	Dalstorps	26	37	35	38
7	Asarum	26	52	51	38
8	Räppe	26	37	33	34
9	Hässleholm	26	32	40	32
10	Österlen	26	34	35	31
11	Nässjö	26	45	48	31
12	Hässleholms	26	41	43	30
13	Sölvesborg	26	31	47	26
14	Lindsdal	26	27	70	16

TEMPORADA 2016/2017

CUARTA SUECIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Torns	26	56	25	58
2	Lunds	26	59	34	54
3	Hässleholms	26	56	40	54
4	IFK Berga	26	49	29	47
5	Prespa	26	55	37	45
6	IFK Malmö	26	49	50	38
7	Österlen	26	52	46	36
8	Lindsdal	26	40	45	30
9	Räppe	26	44	52	30
10	Kvarnby	26	29	52	26
11	Hässleholm	26	40	57	25
12	Asarum	26	38	56	24
13	Nybro	26	33	49	23
14	Vimmerby	26	32	60	20

TEMPORADA 2015/2016

CUARTA SUECIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Karlskrona	26	71	27	59
2	Rosengård	26	66	27	55
3	Torns	26	55	39	44
4	Asarum	26	52	35	42
5	Hässleholm	26	51	41	42
6	Hässleholms	26	52	43	42
7	Lunds	26	44	41	39
8	IFK Berga	26	40	43	36
9	IFK Malmö	26	41	50	32
10	Kvarnby	26	45	53	31
11	Lindsdal	26	39	48	30
12	Nybro	26	39	58	22
13	BW 90	26	30	100	17
14	BK Olympic	26	28	48	12

TEMPORADA 2014/2015

CUARTA SUECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Prespa	26	66	23	61
2	Karlskrona	26	58	20	52
3	Kvarnby	26	54	44	41
4	Rosengård	26	36	26	40
5	Hässleholms	26	40	33	40
6	BW 90	26	26	35	39
7	Lindsdal	26	40	44	38
8	Torns	26	49	47	36
9	Asarum	26	39	48	35
10	IFK Berga	26	32	32	34
11	IFK Malmö	26	42	51	32
12	Hässleholm	26	36	51	24
13	Österlen	26	31	61	15
14	Nosaby	26	26	60	14

TEMPORADA 2009/2010

CUARTA SUECIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Motala	22	52	24	49
2	Kenty	22	35	26	40
3	Karlskrona	22	33	27	37
4	IK Tord	22	45	33	36
5	Lindsdal	22	46	37	35
6	Vimmerby	22	48	38	33
7	VMA	22	49	53	29
8	Tenhult	22	35	46	25
9	Ljungby	22	28	43	23
10	Hässleholm	22	27	42	23
11	Linköping	22	27	37	22
12	Nybro	22	29	48	18

TEMPORADA 2008/2009

CUARTA SUECIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Lunds	22	51	26	53
2	Höllviken	22	38	33	37
3	Lindsdal	22	36	26	36
4	Klagshamn	22	39	30	34
5	Karlskrona	22	47	40	28
6	Hässleholm	22	39	48	27
7	Nybro	22	36	34	25
8	Ljungby	22	28	39	24
9	Lilla Torg	22	26	40	24
10	Nike	22	48	47	23
11	IFK Malmö	22	31	43	23
12	Bromölla	22	25	38	19

TEMPORADA 2007/2008

CUARTA SUECIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Kristianstad	22	47	23	49
2	Akademi HIF	22	63	36	42
3	Lunds	22	42	23	41
4	Karlskrona	22	40	28	38
5	Hässleholm	22	40	34	30
6	Nike	22	25	33	30
7	Höllviken	22	30	34	26
8	Klagshamn	22	34	42	26
9	Asmundstorps	22	35	52	25
10	Högaborg	22	37	41	24
11	Markaryds	22	36	56	21
12	Sölvesborg	22	28	55	20

TEMPORADA 2006/2007

CUARTA SUECIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Rosengård	22	59	20	59
2	Helsingborg	22	63	26	48
3	Lunds	22	48	28	43
4	Högaborg	22	49	39	39
5	Karlskrona	22	34	39	32
6	Höllviken	22	30	39	29
7	Hässleholm	22	33	37	25
8	Sölvesborg	22	39	51	24
9	Laholms FK	22	28	39	23
10	Nike	22	24	44	21
11	Malmo City	22	25	45	18
12	Almeboda	22	23	48	16

TEMPORADA 2005/2006

TERCERA SUECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sylvia	26	56	27	54
2	Limhamn	26	43	26	47
3	Norrby	26	49	41	46
4	Västra	26	41	30	45
5	Husqvarna	26	33	23	44
6	Kristianstad	26	42	37	36
7	Trollhattan	26	33	30	36
8	Skarhamn IK	26	42	40	34
9	Ängelholm	25	36	36	33
10	IFK Varnamo	26	34	34	30
11	Carlstad	26	28	41	29
12	Vetlanda FK	26	27	42	29
13	Hässleholm	26	26	56	21
14	Lindome	25	28	55	18

TEMPORADA 1997/1998

SEGUNDA SUECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kalmar FF	26	49	23	51
2	Landskrona	26	64	37	50
3	Sylvia	26	37	26	47
4	Åtvidabergs	26	49	38	46
5	Stenungsund	26	40	34	45
6	Ljungskile	26	37	34	40
7	Falkenbergs	26	35	47	38
8	Gunnilse	26	41	42	36
9	Mjällby	26	45	52	34
10	Motala	26	31	29	33
11	Norrby	26	34	46	31
12	Hässleholm	26	34	42	26
13	Lundby	26	25	47	19
14	Halmia	26	24	48	18

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

Competiciones que juega

Grupo 3

Cuarta Suecia Grupo 3

Pos	Equipos		Pts
1		Hässleholms IF	13
2		Karlskrona	13
3		Österlen	10
4		Karlshamn	9
5		Kristianstad FC	8
6		Simrishamn	7
7		FBK Balkan	6
8		Högaborgs BK	6
9		Lodde	5
10		IFK Hässleholm	4
11		Nosaby	4
12		IFK Trelleborg	2
13		IFK Berga	1
14		Räppe	1

	Ascenso : Hässleholms IF
	Playoff Ascenso : Karlskrona
	Playoff Descenso : IFK Trelleborg
	Descenso : IFK Berga, Räppe

RIVALES EN Copa Suecia

RIVALES EN Cuarta Suecia

USO DE MEMORIA

6,806,304 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1557
Total Execution Time	0.1569

CADENA URL

/historico/Ifk-Hassleholm

GET DATOS

$_GET['/historico/Ifk-Hassleholm']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0070	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 = 'Ifk-Hassleholm' 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.0022	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=61916 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=61916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=61916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=61916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0053	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 = 75369
0.0036	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.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61916 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1652 AND type_rel = 3
0.0030	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 = '61916' ORDER BY l.year DESC,cat.coefficient 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 = '61916' 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 = '61916' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029	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.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 = 75369 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=61916 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (75369,71781,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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 75369 AND teamId = 61916
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 71781 AND teamId = 61916
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61916
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* `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 = 75369 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '61916' 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 = '61916' and rp.type = 4
0.0021	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 = '61916' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 75369 WHERE rp.league_id = 75369 AND rp.teamId = 61916 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.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 = 75369 WHERE rp.league_id = 75369 AND rp.teamId = 61916 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 = 75369 WHERE rp.league_id = 75369 AND rp.teamId = 61916 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 61916 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 75369 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* `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 = 70951 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.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* `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 = 66557 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* `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 = 62420 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.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 = 55391 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.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 = 49288 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* `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 = 43098 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* `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 = 37782 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* `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 = 20363 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 = 9554 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 = 25229 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 = 25236 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* `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 = 27378 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* `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 = 27406 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 = 16477 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* `tables1998` 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 = 13943 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* `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

IFK Hässleholm

IFK Hässleholm

Selecciona un equipo

Competiciones que juega

Cuarta Suecia Grupo 3

RIVALES EN Copa Suecia

RIVALES EN Cuarta Suecia