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

Göztepe

Entrenador: Stanimir Stoilov

Temporada 2023/2024

TEMPORADA 2023/2024

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Eyupspor	31	70	27	69
2	Göztepe	31	54	19	63
3	Corum FK	31	52	31	55
4	Sakaryaspor	31	45	31	54
5	Bodrumspor	31	39	21	52
6	Kocaelispor	31	45	35	52
7	Bandirmaspor	31	46	27	47
8	Gençlerbirl	31	37	30	47
9	Boluspor	31	28	32	47
10	Erzurumspor	31	28	27	41
11	Umraniyespor	31	34	42	37
12	Manisa FK	31	38	37	36
13	Keciorengucu	31	28	38	36
14	Sanliurfaspo	31	28	33	34
15	Tuzlaspor	31	32	46	33
16	Adanaspor	31	24	44	32
17	Altay	31	14	70	15
18	Giresunspor	31	13	65	7

TEMPORADA 2022/2023

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Samsunspor	36	70	26	78
2	Rizespor	36	64	35	68
3	Pendikspor	36	65	36	67
4	Bodrumspor	36	55	34	62
5	Sakaryaspor	36	59	47	62
6	Eyupspor	36	40	30	62
7	Göztepe	35	45	28	60
8	Manisa FK	36	53	47	56
9	Keciorengucu	36	59	47	56
10	Bandirmaspor	36	55	58	55
11	Boluspor	36	44	46	52
12	Altay	35	45	45	40
13	Erzurumspor	36	43	48	39
14	Tuzlaspor	36	42	52	38
15	Gençlerbirl	36	46	55	38
16	Altinordu	36	41	57	35
17	Adanaspor	36	32	76	25
18	Denizlispor	36	35	67	23
19	Yeni	36	22	81	16

TEMPORADA 2021/2022

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Trabzonspor	38	69	36	81
2	Fenerbahçe	38	73	38	73
3	Konyaspor	38	66	45	68
4	İstanbul	38	56	36	65
5	Alanyaspor	38	67	58	64
6	Beşiktaş	38	56	48	59
7	Antalyaspor	38	54	47	59
8	Fatih	38	47	52	57
9	Adana	38	60	47	55
10	Sivasspor	38	52	50	54
11	Kasımpaşa	38	67	57	53
12	Hatayspor	38	56	60	53
13	Galatasaray	38	51	53	52
14	Kayserispor	38	54	61	47
15	Gaziantep	38	48	56	46
16	Giresunspor	38	41	47	45
17	Rizespor	38	44	71	36
18	Altay	38	39	57	34
19	Göztepe	38	40	77	28
20	Yeni	38	27	71	20

TEMPORADA 2020/2021

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Beşiktaş	40	89	44	84
2	Galatasaray	40	80	36	84
3	Fenerbahçe	40	72	41	82
4	Trabzonspor	40	50	37	71
5	Sivasspor	40	54	43	65
6	Hatayspor	40	62	53	61
7	Alanyaspor	40	58	45	60
8	Fatih	40	64	52	60
9	Gaziantep	40	59	51	58
10	Göztepe	40	59	59	51
11	Konyaspor	40	49	48	50
12	İstanbul	40	43	55	48
13	Rizespor	40	53	69	48
14	Kasımpaşa	40	47	57	46
15	Yeni	40	49	53	45
16	Antalyaspor	40	41	55	44
17	Kayserispor	40	35	52	41
18	Erzurumspor	40	44	68	40
19	Ankaragücü	40	46	65	38
20	Gençlerbirl	40	44	76	38
21	Denizlispor	40	38	77	28

TEMPORADA 2019/2020

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	İstanbul	34	65	34	69
2	Trabzonspor	34	76	42	65
3	Beşiktaş	34	59	40	62
4	Sivasspor	34	55	38	60
5	Alanyaspor	34	61	37	57
6	Galatasaray	34	55	37	56
7	Fenerbahçe	34	58	46	53
8	Gaziantep	34	49	50	46
9	Antalyaspor	34	41	52	45
10	Kasımpaşa	34	53	58	43
11	Göztepe	34	44	49	42
12	Konyaspor	34	36	52	36
13	Gençlerbirl	34	39	56	36
14	Denizlispor	34	31	48	35
15	Rizespor	34	38	57	35
16	Yeni	34	44	51	32
17	Kayserispor	34	40	72	32
18	Ankaragücü	34	31	56	32

TEMPORADA 2018/2019

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Galatasaray	34	72	36	69
2	İstanbul	34	49	22	67
3	Beşiktaş	34	72	46	65
4	Trabzonspor	34	64	46	63
5	Yeni	34	47	46	47
6	Fenerbahçe	34	44	44	46
7	Antalyaspor	34	39	55	45
8	Konyaspor	34	40	38	44
9	Alanyaspor	34	37	43	44
10	Kayserispor	34	35	50	41
11	Rizespor	34	48	50	41
12	Sivasspor	34	49	54	41
13	Ankaragücü	34	38	53	40
14	Kasımpaşa	34	53	62	39
15	Göztepe	34	37	42	38
16	Bursaspor	34	28	37	37
17	Erzurumspor	34	36	43	35
18	Akhisar	34	33	54	27

TEMPORADA 2017/2018

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Galatasaray	34	75	33	75
2	Fenerbahçe	34	78	36	72
3	İstanbul	34	62	34	72
4	Beşiktaş	34	69	30	71
5	Trabzonspor	34	63	51	55
6	Göztepe	34	49	50	49
7	Sivasspor	34	45	53	49
8	Kasımpaşa	34	57	58	46
9	Kayserispor	34	44	55	44
10	Yeni	34	38	45	43
11	Akhisar	34	44	53	42
12	Alanyaspor	34	55	59	40
13	Bursaspor	34	43	48	39
14	Antalyaspor	34	40	59	38
15	Konyaspor	34	38	42	36
16	Ankaraspor	34	49	60	33
17	Gençlerbirl	34	37	54	33
18	Karabükspor	34	20	86	12

TEMPORADA 2016/2017

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Sivasspor	34	51	27	62
2	Yeni	34	47	40	61
3	Eskişehirsp	34	62	44	56
4	Boluspor	34	56	53	54
5	Göztepe	34	55	51	53
6	Giresunspor	34	40	34	53
7	Altinordu	34	45	37	53
8	Umraniyespor	34	42	38	48
9	Balikesirspo	34	56	48	42
10	Elazigspor	34	43	35	41
11	Denizlispor	34	46	45	40
12	Manisaspor	34	47	53	39
13	Gaziantep	34	37	46	37
14	Adana	34	47	51	36
15	Samsunspor	34	27	46	36
16	Sanliurfaspo	34	38	46	36
17	Bandirmaspor	34	43	52	35
18	Mersin	34	35	71	26

TEMPORADA 2015/2016

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Adanaspor	34	53	36	65
2	Karabükspor	34	41	27	62
3	Alanyaspor	34	60	38	61
4	Adana	34	53	40	54
5	Balikesirspo	34	40	29	52
6	Elazigspor	34	45	38	52
7	Giresunspor	34	49	40	51
8	Gaziantep	34	38	33	48
9	Samsunspor	34	45	39	47
10	Altinordu	34	39	43	44
11	Yeni	34	35	41	43
12	Boluspor	34	36	46	42
13	Denizlispor	34	41	52	39
14	Göztepe	34	38	40	38
15	Sanliurfaspo	34	34	45	38
16	1461 Trabzon	34	32	53	34
17	Kayseri	34	35	54	33
18	Karsiyaka	34	33	53	27

TEMPORADA 2014/2015

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Göztepe	34	57	30	69
2	Bandirmaspor	34	52	32	64
3	Hatayspor	34	46	32	60
4	Inegolspor	34	46	28	58
5	Sariyer	34	54	41	55
6	Nazilli	34	45	40	50
7	Korfez FK	34	36	35	45
8	Amedspor	34	46	41	44
9	Ankaragücü	34	42	39	44
10	Kirklarelisp	34	37	42	39
11	Pazarspor	34	34	42	39
12	Mamak Fk	34	27	34	38
13	Gumushanespo	34	26	35	38
14	Kahramanmara	34	33	45	38
15	Tepecik	34	49	55	36
16	Gölbaşispo	34	33	47	35
17	1461 Trabzon	34	28	47	34
18	Altay	34	25	51	27

TEMPORADA 2013/2014

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Giresunspor	35	57	34	70
2	Göztepe	35	54	30	67
3	Hatayspor	35	51	30	66
4	Kartalspor	35	52	36	59
5	Yeni	35	50	35	58
6	Inegolspor	35	47	33	57
7	Pendikspor	35	43	31	57
8	Aydinspor	35	45	39	49
9	Turgutluspor	35	44	43	46
10	Tokatspor	35	40	57	41
11	Gumushanespo	35	31	33	40
12	Kirklarelisp	35	35	53	38
13	1922	35	31	40	36
14	Sariyer	35	39	50	34
15	Tarsus Idman	35	34	52	34
16	Canakkale	35	31	42	33
17	Gaziosmanpas	35	33	53	28
18	Cankirispor	35	17	43	26

TEMPORADA 2012/2013

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Kayseri	34	59	37	63
2	Rizespor	34	53	35	59
3	1461 Trabzon	34	47	31	53
4	Manisaspor	34	41	28	53
5	Bucaspor	34	48	33	52
6	Konyaspor	34	38	35	52
7	Adana	34	54	53	51
8	Adanaspor	34	42	42	49
9	Karsiyaka	34	37	39	47
10	Boluspor	34	41	45	46
11	Denizlispor	34	35	37	43
12	Sanliurfaspo	34	32	38	43
13	Gaziantep	34	37	43	41
14	Samsunspor	34	38	39	39
15	Tavsanlı	34	34	47	38
16	Kartalspor	34	33	44	37
17	Göztepe	34	28	40	37
18	Ankaragücü	34	31	62	29

TEMPORADA 2011/2012

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Akhisar	34	46	28	63
2	Elazigspor	34	45	30	61
3	Kasımpaşa	34	50	39	59
4	Konyaspor	34	35	25	59
5	Rizespor	34	52	44	59
6	Adanaspor	34	46	32	53
7	Boluspor	34	40	33	51
8	Kayseri	34	43	39	46
9	Denizlispor	34	51	46	45
10	Kartalspor	34	37	32	45
11	Tavsanlı	34	42	39	43
12	Bucaspor	34	45	53	43
13	Göztepe	34	36	43	41
14	Gaziantep	34	36	37	40
15	Karsiyaka	34	31	37	39
16	Giresunspor	34	39	48	39
17	Sakaryaspor	34	31	66	21
18	İstanbul	34	24	58	17

TEMPORADA 2010/2011

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Göztepe	34	70	27	74
2	Bandirmaspor	34	59	28	67
3	Mamak Fk	34	52	27	66
4	Turanspor	34	45	28	60
5	Yeni	34	36	33	58
6	Corumspor	34	43	35	55
7	Iskenderun	34	57	34	54
8	Turgutluspor	34	45	42	53
9	Bozuyukspor	34	44	42	51
10	Korfez FK	34	36	38	42
11	Sariyer	34	32	41	38
12	Cankirispor	34	43	53	38
13	Mardinspor	34	23	34	36
14	Alanyaspor	34	35	54	35
15	Adiyamanspor	34	31	42	34
16	Akçaabat	34	32	53	34
17	Hacettepe	34	41	59	32
18	Gebzespor	34	26	80	11

TEMPORADA 2009/2010

2. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	İstanbul	16	22	13	31
2	Akhisar	16	23	15	30
3	Tokatspor	16	18	16	24
4	Iskenderun	16	20	16	23
5	Türk	16	18	19	22
6	Corumspor	16	22	25	22
7	Etimesgut	16	15	24	18
8	Göztepe	16	13	16	16
9	Sanliurfaspo	16	21	28	14

TEMPORADA 2008/2009

3. LIG GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Göztepe	18	24	11	40
2	Tepecik	18	24	13	38
3	Tavsanlı	18	25	13	32
4	Kahramanmara	18	33	27	31
5	Ankara	18	30	27	27
6	Hatayspor	18	24	24	22
7	Gölbaşispo	18	17	21	19
8	Bafra	18	24	30	19
9	Lüleburgazs	18	13	22	15
10	Izmirspor	18	7	33	6

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

Competiciones que juega

1. Lig

Pos	Equipos		Pts
1		Eyupspor	69
2		Göztepe	63
3		Corum FK	55
4		Sakaryaspor	54
5		Bodrumspor	52
6		Kocaelispor	52
7		Bandirmaspor	47
8		Gençlerbirliği SK	47
9		Boluspor	47
10		Erzurumspor	41
11		Umraniyespor	37
12		Manisa FK	36
13		Keciorengucu	36
14		Sanliurfaspor	34
15		Tuzlaspor	33
16		Adanaspor	32
17		Altay	15
18		Giresunspor	7

	Ascenso : Eyupspor, Göztepe
	Playoff Ascenso : Corum FK
	Siguiente Ronda : Sakaryaspor, Bodrumspor, Kocaelispor, Bandirmaspor
	Descenso : Adanaspor, Altay, Giresunspor

RIVALES EN Copa Turca

RIVALES EN 1. Lig

USO DE MEMORIA

7,791,176 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2166
Total Execution Time	0.2178

CADENA URL

/historico/Goztepe

GET DATOS

$_GET['/historico/Goztepe']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0042	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 = 'Goztepe' 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.0019	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=1248 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=1248 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028	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=1248 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=1248 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=1248 AND type_rel = 2
0.0033	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1248 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	SELECT /35 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 (237563,256202,260601,262191,263533) ORDER BY n.cover_points DESC, update_date DESC
0.0033	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 = '1248' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029	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 = '1248' 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 = 72493 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031	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=1248 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0027	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,72493,71798,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.0099	SELECT count(id) as num_players from rel_players WHERE league_id = 72493 AND teamId = 1248
0.0073	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 1248
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71798 AND teamId = 1248
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1248
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 = '1248' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1248' and rp.type = 4
0.0042	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 = '1248' 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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 1248 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.0042	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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 1248 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 1248 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046	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 = 1248 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0042	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 = 72493 AND t.round = 32 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* `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 = 68073 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.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* `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 = 62817 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.0026	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 = 58565 AND t.round = 42 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* `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 = 49948 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.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* `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 = 43610 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 38677 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 33783 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 15407 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 4008 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* `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 = 2804 AND t.round = 34 ORDER BY team.conference 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* `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 = 9932 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* `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 = 9934 AND t.round = 34 ORDER BY team.conference 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* `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 = 16532 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* `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 = 16534 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 = 16542 AND t.round = 18 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.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 = 27220 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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

Göztepe

Göztepe

Selecciona un equipo

Competiciones que juega

1. Lig

RIVALES EN Copa Turca

RIVALES EN 1. Lig