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

Amedspor

Entrenador: Mesut Bakkal

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	60	26	71
4	Menemenspor	35	63	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	29	42
12	Karaman FK	35	38	53	42
13	Arnavutkoy	35	41	44	39
14	Etimesgut	35	24	37	39
15	Belediye	35	35	38	37
16	Sariyer	35	38	46	36
17	Düzcespor	35	40	61	36
18	Denizlispor	35	33	55	30
19	Usakspor	35	14	100	6

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

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 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 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 1
Equipo		PJ	GF	GC	Puntos
1	Altinordu	34	77	23	81
2	Alanyaspor	34	76	35	72
3	Ankaragücü	34	77	30	71
4	Bandirmaspor	34	68	48	61
5	Amedspor	34	40	31	60
6	Tepecik	34	41	43	52
7	Nazilli	34	41	39	50
8	Mamak Fk	34	50	43	47
9	Korfez FK	34	55	56	44
10	Ofspor	34	45	54	43
11	Altay	34	50	52	42
12	Pazarspor	34	40	55	42
13	Bayrampasasp	34	37	56	41
14	Kizilcahamam	34	43	53	37
15	Iskenderun	34	34	46	37
16	Eyupspor	34	36	61	36
17	İstanbul	34	27	54	27
18	Bozuyukspor	34	21	79	11

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

2. LIG GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Vanspor FK	16	33	12	35
2	Adiyamanspor	16	27	11	33
3	Elazigspor	16	25	11	33
4	Adana	16	28	20	27
5	Amedspor	16	21	25	22
6	Tarsus Idman	16	17	17	21
7	Mardinspor	16	15	21	12
8	Kahramanmara	16	16	35	8
9	Malatyaspor	16	8	38	6

TEMPORADA 2008/2009

2. LIG GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Bucaspor	18	34	21	37
2	Mersin	18	26	14	31
3	Tokatspor	18	27	28	29
4	Tarsus Idman	18	34	27	28
5	Corumspor	18	24	21	27
6	Vanspor FK	18	22	27	26
7	Korfez FK	18	19	24	22
8	Beykozspor	18	26	23	20
9	Eyupspor	18	24	28	19
10	Amedspor	18	14	37	4

TEMPORADA 2007/2008

2. LIG GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Adiyamanspor	14	16	14	25
2	Kahramanmara	14	22	12	24
3	Amedspor	14	23	13	22
4	Iskenderun	14	17	12	22
5	Sanliurfaspo	14	18	20	19
6	Gaskispor	14	19	19	18
7	Sanliurfa	14	16	26	16
8	Hatayspor	14	12	27	5

Competiciones que juega

Grupo 1

2. Lig Grupo 1

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

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

RIVALES EN Copa Turca

RIVALES EN 2. Lig

USO DE MEMORIA

7,441,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7129
Total Execution Time	0.7141

CADENA URL

/historico/Diyarbakir-Bb

GET DATOS

$_GET['/historico/Diyarbakir-Bb']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12908 AND type_rel = 2
0.0145	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12908 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0146	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 (39758,117971,131115,357669,399156) ORDER BY n.cover_points DESC, update_date DESC
0.0150	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 = '12908' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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.0151	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=12908 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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,71799,67320) 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.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 73213 AND teamId = 12908
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 12908
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 71799 AND teamId = 12908
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 12908
0.0293	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 = 37 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147	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 = '12908' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12908' and rp.type = 4
0.0146	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 = '12908' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159	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 = 12908 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.0157	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 = 12908 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157	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 = 12908 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 12908 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151	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.0154	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.0157	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.0157	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.0151	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.0151	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.0151	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.0152	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.0149	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.0154	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 = 2803 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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.0150	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.0149	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.0147	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 = 16536 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 16540 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 16551 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 16560 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 16569 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 16577 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

Amedspor

Amedspor

Selecciona un equipo

Competiciones que juega

2. Lig Grupo 1

RIVALES EN Copa Turca

RIVALES EN 2. Lig