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

Fatih Karagümrük

Entrenador: Tolunay Kafkas

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Galatasaray	34	80	21	93
2	Fenerbahçe	33	87	30	86
3	Trabzonspor	33	56	43	55
4	Beşiktaş	33	44	38	51
5	İstanbul	33	44	38	49
6	Rizespor	33	43	49	48
7	Kasımpaşa	33	55	59	46
8	Antalyaspor	33	38	38	45
9	Alanyaspor	33	43	46	45
10	Sivasspor	33	40	45	45
11	Adana	34	49	47	41
12	Samsunspor	33	37	43	39
13	Ankaragücü	33	40	43	37
14	Kayserispor	33	37	47	37
15	Konyaspor	33	34	47	36
16	Gaziantep	33	37	50	34
17	Hatayspor	33	37	46	33
18	Fatih	33	37	42	33
19	Pendikspor	33	37	68	30
20	Istanbulspor	33	26	61	16

TEMPORADA 2022/2023

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Galatasaray	36	83	27	88
2	Fenerbahçe	36	87	42	80
3	Beşiktaş	36	78	36	78
4	Adana	36	76	45	69
5	İstanbul	36	54	37	62
6	Trabzonspor	36	64	54	57
7	Fatih	36	75	63	51
8	Konyaspor	36	49	41	51
9	Kayserispor	36	55	61	47
10	Kasımpaşa	36	45	61	43
11	Ankaragücü	36	43	53	42
12	Istanbulspor	36	47	63	41
13	Antalyaspor	36	46	55	41
14	Sivasspor	36	46	54	41
15	Alanyaspor	36	54	70	41
16	Giresunspor	36	42	60	40
17	Umraniyespor	36	47	64	30
18	Gaziantep	36	31	72	25
19	Hatayspor	36	19	83	23

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

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Hatayspor	34	48	28	66
2	Erzurumspor	34	42	26	62
3	Adana	34	71	43	61
4	Akhisar	34	46	39	57
5	Fatih	34	53	39	56
6	Bursaspor	34	49	41	56
7	Altay	34	48	37	54
8	Keciorengucu	34	33	28	50
9	Menemenspor	34	42	46	44
10	Giresunspor	34	39	47	44
11	Umraniyespor	34	48	51	44
12	Istanbulspor	34	45	43	40
13	Balikesirspo	34	36	48	38
14	Altinordu	34	37	44	37
15	Boluspor	34	30	41	33
16	Ankaraspor	34	41	56	30
17	Adanaspor	34	30	55	21
18	Eskişehirsp	34	34	60	18

TEMPORADA 2018/2019

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Menemenspor	34	76	46	68
2	Fatih	33	52	34	65
3	Manisa FK	34	65	28	62
4	Tuzlaspor	34	57	25	59
5	Sanliurfaspo	34	48	33	56
6	Etimesgut	34	46	41	55
7	Pendikspor	34	54	48	51
8	Kirklarelisp	34	46	40	45
9	Sivas	34	49	53	44
10	Tarsus Idman	34	48	53	42
11	Zonguldak	34	36	49	42
12	Mamak Fk	34	37	54	41
13	Bandirmaspor	34	46	57	38
14	Kahramanmara	34	38	54	38
15	1922	34	50	60	37
16	Fethiyespor	34	35	40	35
17	Tokatspor	33	28	43	30
18	Darica	34	26	79	21

TEMPORADA 2017/2018

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Altay	34	62	32	66
2	Gumushanespo	34	55	30	64
3	Bandirmaspor	34	56	34	64
4	Sanliurfaspo	34	57	36	63
5	Sakaryaspor	34	55	40	61
6	Mamak Fk	34	55	35	56
7	Hacettepe	34	49	33	56
8	1922	34	52	45	55
9	Nigde	34	42	43	49
10	Kirklarelisp	34	43	52	42
11	Kahramanmara	34	40	54	39
12	Zonguldak	34	26	40	38
13	Pendikspor	34	34	47	37
14	Fethiyespor	34	40	49	36
15	Fatih	34	32	48	36
16	Nazilli	34	34	58	29
17	Karsiyaka	34	32	54	21
18	Silivrispor	34	26	60	17

TEMPORADA 2016/2017

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Istanbulspor	34	48	22	68
2	Amedspor	34	51	31	66
3	Erzurumspor	34	56	33	61
4	Korfez FK	34	40	35	56
5	Sivas	34	44	35	53
6	Keciorengucu	34	51	48	49
7	Nazilli	34	41	44	49
8	Zonguldak	34	48	42	47
9	Hacettepe	34	39	35	44
10	Pendikspor	34	43	47	44
11	1922	34	31	40	42
12	Fatih	34	39	42	42
13	Bucaspor	34	43	55	40
14	Kahramanmara	34	37	43	40
15	Fethiyespor	34	35	44	38
16	Anadolu	34	34	43	37
17	Tepecik	34	42	58	32
18	Ofspor	34	30	55	26

TEMPORADA 2015/2016

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Manisaspor	34	41	27	66
2	Korfez FK	34	62	37	62
3	Tuzlaspor	34	53	37	56
4	Keciorengucu	34	45	38	53
5	Gumushanespo	34	52	42	50
6	Amedspor	34	45	39	50
7	Ankaragücü	34	40	32	49
8	Inegolspor	34	37	31	49
9	Aydinspor	34	42	36	48
10	Tepecik	34	35	37	43
11	Bucaspor	34	43	51	43
12	Sivas	34	38	40	42
13	Tokatspor	34	35	37	42
14	Eyupspor	34	38	48	41
15	Fatih	34	32	49	41
16	Kartalspor	34	30	47	39
17	Ankara	34	33	49	31
18	Tarsus Idman	34	28	52	25

TEMPORADA 2014/2015

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Yeni	36	54	30	66
2	Pendikspor	36	58	44	62
3	Kartalspor	36	46	34	60
4	1461 Trabzon	36	51	33	59
5	Umraniyespor	36	47	30	59
6	Menemenspor	36	44	35	57
7	Fatih	36	41	34	57
8	Aydinspor	36	44	42	54
9	1922	36	43	42	45
10	Tokatspor	36	40	47	45
11	Bayrampasasp	36	31	43	45
12	Hacettepe	36	36	36	44
13	Keciorengucu	36	45	42	43
14	Fethiyespor	36	28	39	43
15	Tarsus Idman	36	41	47	42
16	Turgutluspor	36	34	38	39
17	Iskenderun	36	35	47	39
18	Ofspor	36	38	48	38
19	Tavsanlı	36	28	73	15

TEMPORADA 2013/2014

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Umraniyespor	34	57	32	69
2	Bergama	34	52	30	58
3	Ankara	34	40	22	58
4	Fatih	34	45	24	57
5	Kahramanmara	34	56	37	57
6	Silivrispor	34	42	30	55
7	Derince	34	40	31	55
8	Beylerbeyi	34	52	34	53
9	Sivas	34	51	32	52
10	Kanunispor	34	39	30	51
11	Kemerspor	34	47	31	48
12	Payas	34	47	37	45
13	Yeşil Bursa	34	49	40	45
14	Kizilcaboluk	34	41	36	44
15	Adiyamanspor	34	36	47	39
16	Çankaya FK	34	46	59	39
17	Siirtspor	34	9	76	11
18	Belediye	34	3	124	1

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 2008/2009

3. LIG GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Kucukkoyspor	14	14	12	28
2	Yildirim	14	15	10	23
3	Yalovaspor	14	20	15	22
4	Anadolu	14	14	12	18
5	Golcukspor	14	15	16	17
6	Yeşil Bursa	14	15	16	16
7	Orhangazi	14	16	23	13
8	Fatih	14	11	16	12

TEMPORADA 2007/2008

2. LIG GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Bozuyukspor	14	18	9	28
2	Zeytinburnus	14	18	14	23
3	İstanbul	14	20	12	22
4	Sariyer	14	23	18	21
5	Gebzespor	14	19	21	21
6	Eyupspor	14	21	22	20
7	Inegolspor	14	16	19	17
8	Fatih	14	7	27	4

TEMPORADA 2006/2007

2. LIG GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Turanspor	14	27	14	30
2	Eyupspor	14	18	13	23
3	İstanbul	14	22	17	22
4	Fatih	14	28	27	21
5	Inegolspor	14	19	17	20
6	Canakkale	14	15	19	14
7	Yalovaspor	14	18	29	14
8	Yeşil Bursa	14	16	27	7

TEMPORADA 2005/2006

2. LIG GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Pendikspor	16	23	14	30
2	Sariyer	16	17	13	30
3	Kucukkoyspor	16	15	13	23
4	İstanbul	16	18	12	22
5	Eyupspor	16	19	16	22
6	Fatih	16	18	18	22
7	Maltepespor	16	16	21	16
8	Kartal	16	9	16	14
9	Bagcilarspor	16	12	24	13

Competiciones que juega

Liga Turca

Pos	Equipos		Pts
1		Galatasaray SK	93
2		Fenerbahçe	86
3		Trabzonspor	55
4		Beşiktaş	51
5		İstanbul Başakşehir	49
6		Rizespor	48
7		Kasımpaşa	46
8		Antalyaspor	45
9		Alanyaspor	45
10		Sivasspor	45
11		Adana Demirspor	41
12		Samsunspor	39
13		Ankaragücü	37
14		Kayserispor	37
15		Konyaspor	36
16		Gaziantep	34
17		Hatayspor	33
18		Fatih Karagümrük	33
19		Pendikspor	30
20		Istanbulspor AS	16

	Campeón : Galatasaray SK
	Previa de Champions (2ª Ronda) : Fenerbahçe
	Previa de Europa League : Trabzonspor
	: Beşiktaş
	Descenso : Hatayspor, Fatih Karagümrük, Pendikspor, Istanbulspor AS

RIVALES EN Copa Turca

RIVALES EN Liga Turca

USO DE MEMORIA

7,362,896 bytes

BENCHMARKS

Loading Time Base Classes	0.0029
Controller Execution Time ( Home / Category )	0.5640
Total Execution Time	0.5670

CADENA URL

/historico/Fatih-Karagumruk

GET DATOS

$_GET['/historico/Fatih-Karagumruk']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12946 AND type_rel = 2
0.0128	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12946 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129	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 (549861,726039,796566,886144,892845) ORDER BY n.cover_points DESC, update_date DESC
0.0138	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 = '12946' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137	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=12946 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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,72225,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.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 72225 AND teamId = 12946
0.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 12946
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12946
0.0149	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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 12946 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.0148	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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 12946 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0223	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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 12946 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	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 = 12946 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0281	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.0133	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.0131	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 = 50003 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.0132	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 = 44488 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 38968 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 33785 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 16604 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 4007 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 2805 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 27098 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 27155 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 27188 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 16562 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 16571 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 50668 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 50657 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 50677 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 50683 AND t.round = 18 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

Fatih Karagümrük

Fatih Karagümrük

Selecciona un equipo

Competiciones que juega

Liga Turca

RIVALES EN Copa Turca

RIVALES EN Liga Turca