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

Sariyer

Entrenador: Gürses Kilic

Temporada 2023/2024

TEMPORADA 2023/2024

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Amedspor	35	72	26	78
2	Kastamonuspo	35	58	24	75
3	76 Iğdır	35	58	26	71
4	Menemenspor	35	61	40	64
5	Erzincanspor	35	54	32	63
6	İskenderuns	35	61	43	60
7	Ispartaspor	35	39	43	55
8	Inegolspor	35	45	45	49
9	Somaspor	35	38	40	48
10	Fethiyespor	35	45	44	44
11	Aksaray	36	28	28	43
12	Karaman FK	35	38	51	42
13	Arnavutkoy	35	41	44	39
14	Etimesgut	35	24	37	39
15	Belediye	35	35	36	37
16	Sariyer	35	38	46	36
17	Düzcespor	35	39	61	34
18	Denizlispor	35	33	54	32
19	Usakspor	35	13	100	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 2
Equipo		PJ	GF	GC	Puntos
1	Sakaryaspor	38	75	24	84
2	1461 Trabzon	38	63	32	74
3	Bodrumspor	38	61	27	72
4	Sivas	38	66	34	69
5	Bayburt	38	50	35	66
6	Vanspor FK	38	55	46	66
7	Corum FK	38	58	41	65
8	Afjet	38	67	44	62
9	Ankaraspor	38	53	40	55
10	Somaspor	38	50	50	53
11	Inegolspor	38	51	54	51
12	Etimesgut	38	45	54	47
13	Serik	38	47	55	45
14	Sariyer	38	50	59	43
15	Diyarbekirsp	38	34	46	41
16	Adıyaman	38	47	71	41
17	Turgutluspor	38	31	62	37
18	Ergene	38	38	72	35
19	Nigde	38	45	84	29
20	Kahramanmara	38	23	79	19

TEMPORADA 2020/2021

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Manisa FK	36	84	22	84
2	1461 Trabzon	36	80	37	71
3	Kocaelispor	36	59	32	68
4	Ankara	36	56	36	65
5	Erzincanspor	36	51	31	62
6	Sariyer	36	51	33	61
7	Afjet	36	52	45	57
8	Amedspor	36	52	46	57
9	Usakspor	36	56	47	55
10	Corum FK	36	61	37	54
11	Kahramanmara	36	44	63	37
12	Nigde	36	38	53	36
13	Zonguldak	36	32	48	36
14	Inegolspor	36	40	52	35
15	Sanliurfaspo	36	41	70	34
16	Ergene	36	43	71	31
17	Gumushanespo	36	36	79	30
18	Sancaktepe	36	34	78	26
19	Hacettepe	36	26	56	25

TEMPORADA 2019/2020

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Samsunspor	28	64	11	73
2	Manisa FK	28	79	31	63
3	1461 Trabzon	28	51	34	55
4	Sancaktepe	28	51	23	52
5	Inegolspor	28	41	30	45
6	Afjet	28	47	30	43
7	Tarsus Idman	28	45	39	43
8	Pendikspor	28	40	39	40
9	Sariyer	28	34	33	40
10	Zonguldak	28	35	37	36
11	Corum FK	28	36	42	36
12	Hacettepe	28	37	48	35
13	1922	28	38	45	33
14	Kirklarelisp	28	25	41	33
15	Mamak Fk	27	34	41	28
16	Amedspor	28	28	46	28
17	Gumushanespo	27	31	54	25
18	Sanliurfaspo	28	10	102	1

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

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Umraniyespor	34	56	29	75
2	Istanbulspor	34	49	20	71
3	Bandirmaspor	34	64	40	60
4	Hacettepe	34	45	28	57
5	Sariyer	34	37	27	55
6	Menemenspor	34	49	36	53
7	Kirklarelisp	34	38	32	51
8	Nazilli	34	38	30	48
9	Pendikspor	34	35	35	45
10	Fethiyespor	34	37	39	44
11	Mamak Fk	34	29	36	43
12	1922	34	34	39	38
13	Kahramanmara	34	35	43	37
14	Hatayspor	34	31	39	35
15	Anadolu	34	39	49	34
16	Bayrampasasp	34	24	39	33
17	Orduspor	34	28	59	24
18	Pazarspor	34	32	80	24

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

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kahramanmara	32	53	30	62
2	Hatayspor	32	46	26	55
3	Mamak Fk	32	42	31	55
4	Tepecik	32	47	36	54
5	Nazilli	32	54	34	53
6	Fethiyespor	32	49	32	53
7	Bandirmaspor	32	36	34	44
8	Cankirispor	32	36	39	43
9	Pendikspor	32	35	33	41
10	Bozuyukspor	32	37	38	41
11	Tarsus Idman	32	32	35	38
12	Turgutluspor	32	29	33	37
13	Sariyer	32	37	49	35
14	İstanbul	32	23	32	34
15	Giresunspor	32	32	42	34
16	Unyespor	32	18	47	25
17	Sakaryaspor	32	30	65	21

TEMPORADA 2011/2012

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	1461 Trabzon	32	50	23	62
2	Bandirmaspor	32	37	22	56
3	Adana	32	46	31	55
4	Fethiyespor	32	54	38	54
5	Gölbaşispo	32	48	34	53
6	Korfez FK	32	39	26	52
7	Denizli	32	39	32	45
8	Kirklarelisp	32	34	26	44
9	Eyupspor	32	34	35	44
10	Sariyer	32	39	37	43
11	Cankirispor	32	40	41	42
12	Alanyaspor	32	26	28	42
13	Unyespor	32	32	32	40
14	Turanspor	32	37	45	39
15	Altinordu	32	31	33	38
16	Adiyamanspor	32	23	51	20
17	Mardinspor	32	11	86	6

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 6
Equipo		PJ	GF	GC	Puntos
1	Eyupspor	16	22	11	30
2	1922	16	27	12	29
3	Fethiyespor	16	24	19	28
4	Sariyer	16	22	17	25
5	Tepecik	16	21	20	25
6	Istanbulspor	16	25	26	18
7	Turgutluspor	16	21	34	18
8	Denizli	16	16	28	16
9	Alanyaspor	16	23	34	14

TEMPORADA 2008/2009

2. LIG GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Canakkale	16	30	19	55
2	Gebzespor	16	19	16	51
3	Sariyer	16	24	24	50
4	Bozuyukspor	16	18	18	49
5	Pendikspor	16	20	21	49
6	Gaziosmanpas	16	19	12	47
7	Mamak Fk	16	13	15	47
8	Darica	16	18	26	42
9	Beylerbeyi	16	28	38	41

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

Competiciones que juega

Grupo 1

2. Lig Grupo 1

Pos	Equipos		Pts
1		Amedspor	78
2		Kastamonuspor	75
3		76 Iğdır	69
4		Erzincanspor	63
5		Menemenspor	62
6		İskenderunspor	60
7		Ispartaspor	55
8		Inegolspor	49
9		Somaspor	48
10		Fethiyespor	44
11		68 Aksaray Belediyespor	43
12		Karaman FK	43
13		Arnavutkoy	39
14		Etimesgut	39
15		Belediye Derincespor	38
16		Sariyer	36
17		Düzcespor	34
18		Denizlispor	30
19		Usakspor	6

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

RIVALES EN Copa Turca

RIVALES EN 2. Lig

USO DE MEMORIA

7,426,408 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6004
Total Execution Time	0.6016

CADENA URL

/historico/Sariyer

GET DATOS

$_GET['/historico/Sariyer']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0083	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 = 'Sariyer' 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=12924 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=12924 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=12924 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=12924 AND type_rel = 2
0.0073	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 = '12924' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0047	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 = '12924' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0046	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=12924 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.0043	SELECT count(id) as num_players from rel_players WHERE league_id = 73213 AND teamId = 12924
0.0064	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 12924
0.0049	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 = 12924 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.0067	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 = 12924 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 12924 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0059	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 = 12924 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0046	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.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 = 63658 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.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* `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 = 58623 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.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* `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 = 50822 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.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* `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.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 = 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.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* `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.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* `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 = 16603 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* `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.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* `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.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* `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 = 16525 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* `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 = 16528 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* `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 = 16538 AND t.round = 18 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* `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 = 16547 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* `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 = 16552 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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.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 = 16571 AND t.round = 14 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

Sariyer

Sariyer

Selecciona un equipo

Competiciones que juega

2. Lig Grupo 1

RIVALES EN Copa Turca

RIVALES EN 2. Lig