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

Ispartaspor

Entrenador: Hakan Hayati Karaca

Temporada 2023/2024

TEMPORADA 2023/2024

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Amedspor	35	73	26	80
2	Kastamonuspo	35	61	24	77
3	76 Iğdır	35	64	27	71
4	Menemenspor	35	65	41	64
5	Erzincanspor	35	54	32	63
6	İskenderuns	35	61	44	59
7	Ispartaspor	35	39	46	54
8	Inegolspor	35	45	46	48
9	Somaspor	35	38	41	47
10	Fethiyespor	35	45	44	44
11	Aksaray	36	29	30	42
12	Karaman FK	35	39	57	42
13	Arnavutkoy	35	42	44	41
14	Etimesgut	35	24	37	39
15	Sariyer	35	39	46	38
16	Belediye	35	36	40	37
17	Düzcespor	35	41	62	36
18	Denizlispor	35	36	55	32
19	Usakspor	35	14	103	5

TEMPORADA 2022/2023

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Corum FK	36	65	24	79
2	Sanliurfaspo	36	75	25	75
3	Erokspor	36	77	35	62
4	Amedspor	36	63	36	60
5	Erzincanspor	36	50	34	58
6	Ankaraspor	36	58	42	58
7	Somaspor	36	54	35	57
8	Düzcespor	36	55	46	52
9	Menemenspor	36	57	44	51
10	Afjet	36	48	47	47
11	Inegolspor	36	40	53	47
12	Ispartaspor	36	43	42	46
13	Nazilli	36	48	48	46
14	Arnavutkoy	36	41	42	46
15	Bursaspor	36	51	57	46
16	Batman	36	40	44	45
17	Tarsus Idman	36	26	125	21
18	Bayburt	36	25	68	19
19	Sivas	36	27	96	15

TEMPORADA 2021/2022

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pendikspor	34	56	25	77
2	Amedspor	34	43	35	57
3	Karacabey	34	58	41	56
4	Ispartaspor	34	39	28	55
5	Tarsus Idman	34	43	34	55
6	Erzincanspor	34	59	42	54
7	Bucaspor	34	50	42	53
8	Ankara	34	44	35	49
9	Kirsehirspor	34	44	35	49
10	Kirklarelisp	34	40	35	47
11	Sanliurfaspo	34	50	41	46
12	Nazilli	34	36	37	45
13	Usakspor	34	31	47	40
14	Zonguldak	34	37	47	38
15	Pazarspor	34	35	60	34
16	Akhisar	34	34	56	31
17	1922	34	36	52	29
18	Eskişehirsp	34	31	74	22
19	Kastamonuspo	0	0	0	0

TEMPORADA 2020/2021

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Somaspor	32	64	30	69
2	Erokspor	32	59	27	64
3	Ispartaspor	32	49	35	50
4	İçel	32	41	32	50
5	Çatalca	32	35	31	49
6	Çarşambasp	32	37	29	45
7	Osmaniyespor	32	35	32	44
8	Karsiyaka	32	36	39	44
9	Kalecik FK	32	36	34	43
10	Sile	32	38	39	43
11	23 Elazig	32	37	38	42
12	Erbaaspor	32	29	35	40
13	Batman	32	24	30	39
14	Cizrespor	32	30	55	32
15	Golcukspor	32	27	39	30
16	Arhavispor	32	23	49	27
17	Yalovaspor	32	26	52	22

TEMPORADA 2010/2011

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kirklarelisp	34	62	27	73
2	Afyonkarahis	34	57	23	69
3	Gumushanespo	34	47	19	67
4	Altinordu	34	57	33	61
5	Darica	34	45	27	61
6	Sivas	34	61	37	60
7	Orhangazispo	34	48	24	60
8	Yeşil Bursa	34	52	26	58
9	Anadolu	34	51	35	56
10	İskenderuns	34	39	31	48
11	Batman	34	39	38	43
12	Akçaabat	34	38	41	41
13	Kahramanmara	34	38	43	40
14	Keçiören	34	47	57	33
15	Yozgatspor	34	30	49	32
16	Beykozspor	34	39	83	28
17	Ispartaspor	34	26	81	19
18	Erzurumspor	34	0	102	0

TEMPORADA 2009/2010

3. LIG GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Menemenspor	16	28	17	67
2	Altinordu	16	24	14	60
3	Afyonkarahis	16	17	14	59
4	Ispartaspor	16	19	19	56
5	Nazilli	16	15	8	52
6	Izmirspor	16	25	12	46
7	Kemerspor	16	22	16	46
8	Muğlaspor	16	19	21	32
9	Marmaris	16	0	48	0

TEMPORADA 2008/2009

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Göztepe	18	24	18	31
2	Izmirspor	18	21	16	30
3	Nazilli	18	22	15	29
4	Menemenspor	18	27	21	28
5	Aydinspor	18	23	22	28
6	Ispartaspor	18	23	24	25
7	Bandirmaspor	18	18	17	24
8	Balikesirspo	18	27	34	23
9	Torbalispor	18	17	23	19
10	Mustafakemal	18	17	29	16

TEMPORADA 2007/2008

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Denizli	30	56	27	58
2	Akhisar	30	42	23	57
3	1922	30	44	26	54
4	Altinordu	30	40	23	54
5	Balikesirspo	30	38	28	50
6	Nazilli	30	33	19	49
7	Tavsanlı	30	39	40	42
8	Torbalispor	30	31	28	39
9	Göztepe	30	28	26	39
10	Karacabeyspo	30	32	33	38
11	Ispartaspor	30	27	53	36
12	Kütahyaspor	30	27	34	33
13	Aydinspor	30	30	43	33
14	Yeşil Bursa	30	33	36	32
15	Muğlaspor	30	23	35	29
16	Yeni	31	24	44	22
17	Yeni Burdur	31	22	51	22

TEMPORADA 2006/2007

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sidespor	58	74	51	103
2	Bursa	30	47	32	52
3	Afyonkarahis	30	43	29	52
4	Sarayköy	30	36	26	50
5	Göztepe	30	37	24	47
6	Altinordu	29	27	28	42
7	Kütahyaspor	30	28	34	39
8	Karacabeyspo	30	35	36	37
9	Balikesirspo	30	35	34	35
10	Mustafakemal	30	27	29	34
11	Aydinspor	29	27	37	31
12	Ispartaspor	30	25	37	31
13	Yeni Burdur	30	25	38	30
14	Akhisar	30	26	31	29
15	Aliağa	30	23	50	28
16	Bozuyukspor	2	1	0	4

TEMPORADA 2005/2006

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Keciorengucu	30	48	24	65
2	Fethiyespor	30	48	25	64
3	Sarayköy	30	51	32	58
4	Akhisar	30	52	38	54
5	Ispartaspor	30	37	27	49
6	Afyonkarahis	30	36	38	41
7	Yeni	30	40	42	40
8	Göztepe	30	40	43	40
9	Sidespor	30	39	40	39
10	Yeni Burdur	30	36	44	36
11	Karacabeyspo	30	34	30	35
12	Aliağa	30	29	31	35
13	Altinordu	30	34	41	34
14	Kütahyaspor	30	36	44	32
15	Anadolu	30	29	45	29
16	Akseki	30	16	61	9

TEMPORADA 2004/2005

3. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Turgutluspor	30	58	31	56
2	Mamak Fk	30	41	29	51
3	Sarayköy	30	50	29	50
4	Altinordu	30	35	25	50
5	Göztepe	30	50	31	47
6	Yeni Burdur	30	35	37	45
7	Kütahyaspor	30	41	36	43
8	Ispartaspor	30	28	23	40
9	Yeni	30	42	44	40
10	Fethiyespor	29	25	22	39
11	Akhisar	30	29	37	36
12	Sidespor	30	32	46	34
13	Akseki	29	33	54	32
14	Eskispor	29	30	43	31
15	Akşehirspor	30	23	42	29
16	Petkimspor	29	30	53	19

TEMPORADA 2003/2004

3. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Alanyaspor	30	55	29	60
2	Yeşil Bursa	30	54	40	53
3	Sarayköy	30	39	27	51
4	Turgutluspor	30	41	31	51
5	Göztepe	30	35	26	48
6	Eskispor	31	32	22	47
7	Ispartaspor	30	42	35	42
8	Altinordu	30	34	33	42
9	Fethiyespor	30	37	32	41
10	Golcukspor	31	27	37	40
11	Akhisar	30	28	23	38
12	Petkimspor	30	42	42	36
13	Kütahyaspor	30	43	51	36
14	Orhangazispo	30	32	43	35
15	Bandirmaspor	30	27	43	35
16	Afjet	30	26	44	27
17	Kestel	30	17	53	21

TEMPORADA 2002/2003

3. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Yalovaspor	30	63	26	62
2	Sarayköy	29	57	32	57
3	Petkimspor	30	43	22	54
4	Bandirmaspor	30	45	35	51
5	Eskispor	29	48	40	46
6	Göztepe	29	49	37	45
7	Fethiyespor	30	46	38	45
8	Yeşil Bursa	30	43	35	43
9	Tavşancıls	30	32	37	42
10	Akhisar	30	43	44	39
11	Kestel	29	28	32	39
12	Sapancaspor	30	36	40	35
13	Ispartaspor	30	41	55	32
14	Turgutluspor	30	32	49	32
15	Bergama	30	32	64	27
16	Dalaman	30	16	68	15

TEMPORADA 1999/2000

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ispartaspor	32	63	18	68
2	Afjet	32	55	24	65
3	Petrol Ofisi	32	38	22	54
4	Keciorengucu	31	44	34	52
5	Mamak Fk	31	40	29	49
6	Aksarayspor	32	44	45	46
7	Seydişehir	32	24	25	46
8	Side	32	43	47	42
9	Eskişehir	32	46	45	41
10	Kemerspor	32	30	44	38
11	Dalaman	32	27	32	37
12	Sidespor	31	37	40	36
13	Alanyaspor	32	32	43	36
14	Karamanspor	32	30	42	36
15	Fethiyespor	32	30	46	35
16	Anamur	32	29	51	34
17	Manavgat	31	26	51	24

TEMPORADA 1998/1999

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Hacettepe	32	68	21	68
2	Mobellaspor	32	70	26	68
3	Side	32	53	57	49
4	Kütahyaspor	31	45	27	48
5	Afjet	32	56	59	47
6	Aksarayspor	32	45	40	46
7	Kemerspor	32	43	40	44
8	Mamak Fk	31	43	41	44
9	Ispartaspor	31	36	43	43
10	Sidespor	31	44	37	41
11	Nevşehir	32	40	53	39
12	Anamur	32	44	60	38
13	Karamanspor	32	40	52	37
14	Eskişehir	32	40	50	34
15	Alanyaspor	32	35	46	33
16	Eskişehir	32	38	65	32
17	Afyon	32	43	66	26

TEMPORADA 1997/1998

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Petrol Ofisi	32	80	31	73
2	Kütahyaspor	32	61	25	69
3	Nevşehir	32	74	37	68
4	Mamak Fk	32	46	29	56
5	Aksarayspor	32	52	40	55
6	Tarsus Idman	32	51	46	55
7	Alanyaspor	32	53	48	52
8	Eskişehir	32	51	43	47
9	Afjet	32	41	42	41
10	Side	32	39	40	40
11	Mobellaspor	32	57	55	39
12	Ispartaspor	32	45	44	38
13	Simav	32	36	44	33
14	Karamanspor	32	37	52	32
15	Silifke	32	29	53	30
16	Konya	32	36	63	24
17	Kütahya	32	0	96	0

TEMPORADA 1996/1997

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ankaraspor	32	56	20	75
2	Petrol Ofisi	32	72	33	74
3	Ispartaspor	32	55	31	56
4	Aksarayspor	32	51	36	53
5	Kütahyaspor	32	59	50	47
6	Mobellaspor	32	52	43	46
7	Kütahya	31	45	47	46
8	Karamanspor	32	55	42	45
9	Nevşehir	32	40	39	44
10	Side	32	54	50	41
11	Mamak Fk	32	27	32	37
12	Eskişehir	32	41	58	35
13	Konya	32	41	59	34
14	Afjet	32	29	56	33
15	Tarımspor	32	27	46	32
16	Seydişehir	31	26	65	27
17	Antalya Köy	32	31	54	26

TEMPORADA 1995/1996

2. LIG GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Muğlaspor	26	56	18	61
2	Marmaris	25	41	17	53
3	Ispartaspor	26	48	32	47
4	Yeni	26	29	26	41
5	Usakspor	26	42	34	35
6	Nazilli	26	25	27	35
7	Afjet	26	39	42	34
8	Mobellaspor	26	30	34	33
9	Simav	26	24	28	32
10	Seydişehir	26	20	27	29
11	Kütahyaspor	26	22	34	28
12	Antalya Köy	25	19	37	28
13	Bodrumspor	25	27	45	21
14	Tavsanlı	25	21	42	21

Competiciones que juega

Grupo 1

2. Lig Grupo 1

Pos	Equipos		Pts
1		Amedspor	80
2		Kastamonuspor	77
3		76 Iğdır	71
4		Menemenspor	64
5		Erzincanspor	63
6		İskenderunspor	59
7		Ispartaspor	54
8		Inegolspor	48
9		Somaspor	47
10		Fethiyespor	44
11		68 Aksaray Belediyespor	42
12		Karaman FK	42
13		Arnavutkoy	41
14		Etimesgut	39
15		Sariyer	38
16		Belediye Derincespor	37
17		Düzcespor	36
18		Denizlispor	32
19		Usakspor	5

	Ascenso : Amedspor
	Playoff Ascenso : Kastamonuspor, 76 Iğdır, Menemenspor, Erzincanspor
	Descenso : Belediye Derincespor, Düzcespor, Denizlispor, Usakspor

RIVALES EN Copa Turca

RIVALES EN 2. Lig

USO DE MEMORIA

7,501,176 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.1597
Total Execution Time	0.1615

CADENA URL

/historico/Ispartaspor-Kulubu

GET DATOS

$_GET['/historico/Ispartaspor-Kulubu']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0043	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 = 'Ispartaspor-Kulubu' 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=87922 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=87922 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=87922 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=87922 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=359 AND type_rel = 3
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 359 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 (1307337,1244348,1234831,1117729,1085507) ORDER BY n.cover_points DESC, update_date DESC
0.0046	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 = '87922' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0037	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 = '87922' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028	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 = 74094 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032	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=87922 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 (74094,73213) 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.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 73213 AND teamId = 87922
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 87922
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 = '87922' 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 = '87922' 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 = '87922' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0047	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 = 73213 WHERE rp.league_id = 73213 AND rp.teamId = 87922 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.0040	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 = 73213 WHERE rp.league_id = 73213 AND rp.teamId = 87922 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73213 WHERE rp.league_id = 73213 AND rp.teamId = 87922 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 87922 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0044	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 = 68198 AND t.round = 38 ORDER BY team.conference ASC,t.position 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* `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 = 63657 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 58627 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 27117 AND t.round = 34 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* `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 = 27122 AND t.round = 22 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* `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 = 27153 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* `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 = 27190 AND t.round = 14 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 = 27160 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 49309 AND t.round = 32 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 = 50227 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* `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 = 50232 AND t.round = 30 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* `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 = 50240 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* `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 = 50245 AND t.round = 32 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* `tables2003` 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 = 50249 AND t.round = 30 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* `tables2000` 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 = 50711 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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* `tables1999` 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 = 50731 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 50765 AND t.round = 34 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* `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 = 50774 AND t.round = 34 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* `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 = 50805 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿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

Ispartaspor

Ispartaspor

Selecciona un equipo

Competiciones que juega

2. Lig Grupo 1

RIVALES EN Copa Turca

RIVALES EN 2. Lig