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

Kastamonuspor

Entrenador: Firat Gül

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 2
Equipo		PJ	GF	GC	Puntos
1	Kocaelispor	38	73	28	84
2	Bucaspor	38	63	22	81
3	İskenderuns	38	65	31	77
4	1461 Trabzon	38	62	27	74
5	Vanspor FK	38	58	27	74
6	Ankara	38	65	32	71
7	Karacabey	38	55	31	68
8	Fethiyespor	38	59	51	55
9	Zonguldak	38	45	50	53
10	Serik	38	54	43	50
11	Kirsehirspor	38	49	54	48
12	Kirklarelisp	38	38	35	46
13	Etimesgut	38	43	51	45
14	Kastamonuspo	38	41	47	43
15	Sariyer	38	46	57	42
16	Usakspor	38	37	64	33
17	Balikesirspo	38	32	76	25
18	Adıyaman	37	22	70	23
19	Pazarspor	38	29	79	23
20	Diyarbekirsp	37	18	79	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

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eyupspor	38	82	25	92
2	Sakaryaspor	38	74	35	75
3	Kirsehirspor	38	57	32	72
4	Kirklarelisp	38	60	32	70
5	Vanspor FK	38	59	35	69
6	Bodrumspor	38	80	48	63
7	Etimesgut	38	63	36	61
8	Karacabey	38	52	41	56
9	Turgutluspor	38	44	56	54
10	Serik	38	51	48	53
11	Pendikspor	38	66	53	52
12	Pazarspor	38	60	64	50
13	Tarsus Idman	38	56	55	49
14	Bayburt	38	52	61	48
15	Sivas	38	63	58	46
16	1922	38	47	49	42
17	Kastamonuspo	38	31	58	36
18	Elazigspor	38	61	90	33
19	Mamak Fk	38	32	121	24
20	Karabükspor	38	16	109	3

TEMPORADA 2019/2020

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bandirmaspor	28	58	26	60
2	Ankara	28	46	21	57
3	Sakaryaspor	28	36	21	54
4	Kastamonuspo	28	49	28	53
5	Tuzlaspor	27	42	25	50
6	Kirsehirspor	28	33	24	47
7	Vanspor FK	28	46	32	44
8	Usakspor	27	40	34	44
9	Kahramanmara	28	30	32	41
10	Ergene	28	43	34	37
11	Bodrumspor	28	40	41	36
12	Sivas	28	36	38	36
13	Bayburt	28	30	40	35
14	Eyupspor	28	25	39	29
15	Etimesgut	28	28	34	28
16	Elazigspor	26	18	53	19
17	Nigde	28	28	52	17
18	Karabükspor	28	11	65	9

TEMPORADA 2018/2019

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Keciorengucu	34	69	24	76
2	Kastamonuspo	34	67	23	74
3	Samsunspor	34	60	25	73
4	Sakaryaspor	34	63	31	69
5	Sariyer	34	56	32	68
6	Sancaktepe	34	52	36	53
7	Bodrumspor	34	56	48	52
8	Amedspor	34	44	42	49
9	Eyupspor	34	50	46	46
10	Inegolspor	34	45	48	45
11	Usakspor	34	40	39	40
12	Gumushanespo	34	41	42	40
13	Nigde	34	38	47	37
14	Ankara	34	36	50	34
15	Hacettepe	34	45	58	33
16	Bayrampasasp	34	32	53	33
17	Manisaspor	34	31	100	15
18	Gaziantepspo	34	11	92	11

TEMPORADA 2017/2018

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hatayspor	34	63	15	76
2	Menemenspor	34	68	26	74
3	Afjet	34	62	31	70
4	Sivas	34	57	29	67
5	Keciorengucu	34	77	41	64
6	Sancaktepe	34	58	32	59
7	Inegolspor	34	53	41	59
8	Sariyer	34	44	45	44
9	Tokatspor	34	37	45	43
10	Etimesgut	34	44	47	42
11	Kastamonuspo	34	46	49	40
12	Amedspor	34	37	41	40
13	Eyupspor	34	52	62	39
14	Tuzlaspor	34	42	51	38
15	Bodrumspor	34	39	53	38
16	Bucaspor	34	51	60	36
17	Korfez FK	34	30	78	13
18	Mersin	34	19	133	1

TEMPORADA 2016/2017

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ankaragücü	34	58	28	72
2	Gumushanespo	34	53	29	65
3	Kastamonuspo	34	54	33	60
4	Hatayspor	34	39	25	59
5	Menemenspor	34	65	45	58
6	Karsiyaka	34	58	42	54
7	Sariyer	34	50	41	51
8	Etimesgut	34	41	32	51
9	Nigde	34	32	34	46
10	Eyupspor	34	49	64	44
11	Tokatspor	34	34	37	42
12	Inegolspor	34	42	43	41
13	Tuzlaspor	34	36	42	39
14	Kirklarelisp	34	39	44	38
15	Mamak Fk	34	33	37	37
16	Aydinspor	34	38	48	37
17	1461 Trabzon	34	44	50	33
18	Kayseri	34	21	112	0

TEMPORADA 2015/2016

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kastamonuspo	36	58	31	74
2	Nigde	36	52	34	61
3	Bayburt	36	37	26	61
4	Corum FK	36	47	36	59
5	Beylerbeyi	36	45	37	59
6	Golcukspor	36	43	33	58
7	Darica	36	50	36	54
8	Erzincan	36	42	29	54
9	Dersim Spor	36	40	44	51
10	Canakkale	36	45	38	49
11	Çatalca	36	37	33	47
12	Batman	36	37	42	47
13	Manavgat	36	50	52	44
14	Bergama	36	39	46	42
15	Vanspor FK	36	33	46	42
16	Iskenderun	36	37	55	40
17	Tavsanlı	36	31	44	34
18	Çine	36	27	48	31
19	Sandiklispor	36	35	75	21

TEMPORADA 2012/2013

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Amedspor	34	62	23	69
2	Fatih	34	59	35	63
3	Istanbulspor	34	49	32	58
4	Pazarspor	34	52	35	57
5	Kemerspor	34	62	46	57
6	Kirikhanspor	34	46	36	53
7	Orhangazispo	34	36	28	53
8	Kayseri	34	48	44	47
9	Ankara	34	40	36	46
10	Anadolu	34	40	39	45
11	Golcukspor	34	45	48	44
12	Vanspor FK	34	28	39	40
13	Sandiklispor	34	45	56	39
14	Bergama	34	35	50	39
15	Siirtspor	34	39	58	39
16	Kastamonuspo	34	53	55	38
17	Beşikdüzü	34	31	33	38
18	Corumspor	34	29	106	12

TEMPORADA 2011/2012

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Inegolspor	36	62	19	77
2	Bayrampasasp	36	61	28	71
3	Amedspor	36	57	30	67
4	Hacettepe	36	60	38	64
5	Gumushanespo	36	46	37	63
6	Manavgatspor	36	52	33	61
7	Menemenspor	36	49	40	56
8	Sandiklispor	36	55	41	53
9	Vanspor FK	36	47	39	53
10	Beşikdüzü	36	42	38	53
11	Kastamonuspo	36	38	42	49
12	Kirikhanspor	36	47	48	48
13	Umraniyespor	36	52	54	46
14	23 Elazig	36	41	46	43
15	Gebzespor	36	36	61	37
16	Kırıkkales	36	33	60	34
17	Lüleburgazs	36	27	44	33
18	Keçiören	36	31	52	25
19	Akçaabat	36	19	105	7

TEMPORADA 2010/2011

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gaziosmanpas	34	47	23	69
2	Beylerbeyi	34	48	27	63
3	Amedspor	34	54	46	56
4	Sancaktepe	34	36	34	56
5	Denizli	34	37	26	54
6	Golcukspor	34	38	27	51
7	Keciorengucu	34	52	41	50
8	Kastamonuspo	34	36	33	49
9	Karsspor	34	38	39	48
10	Kirikhanspor	34	41	42	47
11	Pazarspor	34	48	43	45
12	Kırıkkales	34	59	45	43
13	Araklispor	34	36	42	43
14	Siirtspor	34	37	37	41
15	Kepez	34	31	42	39
16	Yalovaspor	34	34	41	35
17	Torbalispor	34	33	45	35
18	Zeytinburnus	34	18	90	7

TEMPORADA 2009/2010

3. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Yozgatspor	16	23	13	59
2	Akçaabat	16	20	11	58
3	Unyespor	16	27	19	57
4	Gumushanespo	16	24	16	50
5	Surmenespor	16	23	13	49
6	Kastamonuspo	16	25	18	49
7	Arsinspor	16	21	21	49
8	Bafra	16	17	22	40
9	Bulancakspor	16	5	52	8

TEMPORADA 2008/2009

3. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Kastamonuspo	14	25	14	58
2	Araklispor	14	24	14	50
3	Gumushanespo	14	12	17	48
4	Surmenespor	14	18	15	46
5	Bulancakspor	14	9	18	39
6	Erzincanspor	14	17	12	37
7	Unyespor	14	18	19	37
8	Divrigispor	14	10	24	24

TEMPORADA 2007/2008

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tokatspor	30	43	27	57
2	Ofspor	30	43	28	55
3	Corumspor	30	39	25	51
4	Kastamonuspo	30	31	22	50
5	Keciorengucu	30	43	27	48
6	Surmenespor	30	28	25	44
7	Ankara	30	42	39	41
8	Tarım	30	29	22	39
9	Unyespor	30	31	37	38
10	Gumushanespo	30	27	31	37
11	Divrigispor	30	28	25	36
12	Bulancakspor	30	35	40	36
13	Keçiören	30	32	43	36
14	İlkadım	30	32	47	30
15	Artvin	30	22	33	29
16	Bafraspor	30	20	54	26

TEMPORADA 2006/2007

3. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Gaziosmanpas	30	60	22	68
2	Alibeykoyspo	30	49	35	53
3	Tepecik	29	43	27	51
4	Golcukspor	30	40	29	49
5	Bilecikspor	30	33	23	48
6	Orhangazispo	30	47	40	48
7	Kastamonuspo	30	44	42	42
8	Fenerspor	30	38	42	37
9	Orhangazi	30	30	37	36
10	Beykozspor	30	25	33	36
11	Bagcilarspor	30	39	54	36
12	Küçükçek	30	34	40	35
13	Kartal	30	32	44	31
14	Beylerbeyisp	29	30	42	31
15	Corluspor	30	27	50	30
16	Bakırköysp	30	30	41	26

TEMPORADA 2005/2006

3. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Gebzespor	30	78	37	64
2	Zeytinburnus	30	58	33	56
3	Gaziosmanpas	30	52	40	53
4	Alibeykoyspo	29	45	26	49
5	Beykozspor	30	48	36	48
6	Golcukspor	30	38	31	43
7	Orhangazispo	29	37	27	42
8	Bakırköysp	30	46	48	42
9	Küçükçek	30	40	42	40
10	Corluspor	30	35	41	38
11	Kastamonuspo	30	29	36	32
12	Mustafakemal	30	28	41	32
13	Beylerbeyisp	30	26	49	32
14	Bilecikspor	30	33	43	31
15	Eskispor	30	29	47	29
16	Mecidiyeköy	30	14	59	12

TEMPORADA 2004/2005

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kasımpaşa	30	44	21	64
2	Boluspor	29	46	22	61
3	Kastamonuspo	30	41	29	50
4	Mecidiyeköy	30	35	36	40
5	Bilecikspor	30	35	32	39
6	Alibeykoyspo	30	36	42	39
7	Gebzespor	30	30	39	38
8	Beykozspor	30	37	35	37
9	Beylerbeyisp	30	42	42	37
10	Zeytinburnus	30	41	42	37
11	Gaziosmanpas	30	32	34	37
12	Bakırköysp	30	38	37	36
13	Mustafakemal	29	28	38	36
14	Golcukspor	30	32	39	35
15	Yeniköyspor	30	32	40	33
16	Bandirmaspor	30	24	45	30

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,627,904 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1474
Total Execution Time	0.1486

CADENA URL

/historico/Kastamonuspor

GET DATOS

$_GET['/historico/Kastamonuspor']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0076	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 = 'Kastamonuspor' 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=65758 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=65758 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=65758 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=65758 AND type_rel = 2
0.0029	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 = '65758' ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '65758' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '65758' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 73213 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=65758 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 73213 AND teamId = 65758
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 65758
0.0026	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 = 73213 AND t.round = 38 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 = '65758' 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 = '65758' 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 = '65758' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039	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 = 65758 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.0034	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 = 65758 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73213 WHERE rp.league_id = 73213 AND rp.teamId = 65758 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 65758 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68199 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.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* `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 = 58624 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.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* `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 = 50823 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 44487 AND t.round = 34 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 = 38969 AND t.round = 34 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 = 33786 AND t.round = 34 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* `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 = 15825 AND t.round = 38 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* `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 = 27105 AND t.round = 38 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* `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 = 27126 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* `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 = 27132 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* `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 = 27165 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 = 27169 AND t.round = 18 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* `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 = 27205 AND t.round = 14 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* `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 = 49307 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* `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 = 50228 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* `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 = 50233 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* `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 = 50239 AND t.round = 30 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 = 73213 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

Kastamonuspor

Kastamonuspor

Selecciona un equipo

Competiciones que juega

2. Lig Grupo 1

RIVALES EN Copa Turca

RIVALES EN 2. Lig