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

Adanaspor

Entrenador: Kemal Kiliç

Temporada 2020/2021

TEMPORADA 2020/2021

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Adana	34	64	27	70
2	Giresunspor	34	54	25	70
3	Samsunspor	34	58	30	70
4	Istanbulspor	34	62	34	64
5	Altay	34	66	39	63
6	Altinordu	34	58	45	60
7	Keciorengucu	34	49	28	58
8	Umraniyespor	34	46	43	51
9	Tuzlaspor	34	46	53	47
10	Bursaspor	34	56	57	46
11	Bandirmaspor	34	48	51	42
12	Boluspor	34	38	41	42
13	Balikesirspo	34	35	53	35
14	Adanaspor	34	44	55	34
15	Menemenspor	34	38	62	34
16	Akhisar	34	36	59	30
17	Ankaraspor	34	33	61	26
18	Eskişehirsp	34	23	91	8

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

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Denizlispor	34	67	32	72
2	Gençlerbirl	34	50	28	70
3	Hatayspor	34	57	22	67
4	Ankaraspor	34	49	26	62
5	Gaziantep	34	60	31	59
6	Adana	34	50	36	58
7	Altinordu	34	50	33	57
8	Umraniyespor	34	44	37	53
9	Boluspor	34	41	41	49
10	Altay	34	52	40	47
11	Istanbulspor	34	45	46	43
12	Balikesirspo	34	36	45	40
13	Adanaspor	34	41	49	37
14	Giresunspor	34	32	41	36
15	Eskişehirsp	34	44	66	35
16	Afjet	34	38	55	30
17	Elazigspor	34	38	64	25
18	Karabükspor	34	10	112	0

TEMPORADA 2017/2018

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Rizespor	34	68	38	69
2	Ankaragücü	34	55	34	63
3	Boluspor	34	53	30	60
4	Umraniyespor	34	49	35	59
5	Erzurumspor	34	56	44	53
6	Gaziantep	34	57	38	53
7	Altinordu	34	55	45	53
8	Balikesirspo	34	56	46	52
9	Istanbulspor	34	45	39	50
10	Elazigspor	34	53	44	48
11	Giresunspor	34	50	44	47
12	Adanaspor	34	41	56	43
13	Adana	34	44	47	41
14	Eskişehirsp	34	63	56	41
15	Denizlispor	34	43	47	38
16	Samsunspor	34	32	46	36
17	Manisaspor	34	31	80	12
18	Gaziantepspo	34	18	100	1

TEMPORADA 2016/2017

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Beşiktaş	34	73	30	77
2	İstanbul	34	63	28	73
3	Fenerbahçe	34	60	32	64
4	Galatasaray	34	65	40	64
5	Antalyaspor	34	47	40	58
6	Trabzonspor	34	39	34	51
7	Akhisar	34	46	42	48
8	Gençlerbirl	34	33	34	46
9	Konyaspor	34	40	45	43
10	Kasımpaşa	34	46	50	43
11	Karabükspor	34	38	48	43
12	Alanyaspor	34	54	65	40
13	Ankaraspor	34	37	45	38
14	Bursaspor	34	34	58	38
15	Kayserispor	34	47	58	38
16	Rizespor	34	44	53	36
17	Gaziantepspo	34	30	65	26
18	Adanaspor	34	33	62	25

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

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Kayserispor	34	61	24	72
2	Ankaraspor	34	64	29	66
3	Alanyaspor	34	55	40	57
4	Adana	34	57	48	56
5	Samsunspor	34	48	30	55
6	Altinordu	34	60	39	54
7	Sanliurfaspo	34	42	29	53
8	Antalyaspor	34	56	44	53
9	Karsiyaka	34	49	57	45
10	Boluspor	34	47	40	44
11	Giresunspor	34	31	36	44
12	Elazigspor	34	42	45	42
13	Gaziantep	34	38	47	41
14	Adanaspor	34	42	54	39
15	Denizlispor	34	38	51	33
16	Manisaspor	34	42	60	33
17	Bucaspor	34	39	67	32
18	Orduspor	34	19	90	11

TEMPORADA 2013/2014

1. LIG
Equipo		PJ	GF	GC	Puntos
1	İstanbul	36	76	38	78
2	Balikesirspo	36	56	33	73
3	Orduspor	36	57	30	71
4	Ankaraspor	36	61	35	66
5	Samsunspor	36	61	36	65
6	Mersin	36	56	43	60
7	Manisaspor	36	55	47	54
8	Karsiyaka	36	51	49	49
9	Bucaspor	36	47	59	46
10	Denizlispor	36	42	56	46
11	Sanliurfaspo	36	46	49	45
12	Adanaspor	36	51	55	43
13	Adana	36	58	63	43
14	Gaziantep	36	30	47	41
15	Boluspor	36	34	47	40
16	Fethiyespor	36	47	59	38
17	1461 Trabzon	36	49	58	35
18	Tavsanlı	36	39	67	34
19	Kahramanmara	36	31	76	14

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

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Samsunspor	32	45	20	58
2	Mersin	32	39	29	58
3	Gaziantep	32	43	26	57
4	Orduspor	32	47	29	54
5	Rizespor	32	36	24	54
6	Tavsanlı	32	32	28	51
7	Boluspor	32	47	31	49
8	Kayseri	32	40	29	48
9	Denizlispor	32	40	31	44
10	Karsiyaka	32	26	34	41
11	Giresunspor	32	27	32	38
12	Adanaspor	32	41	42	37
13	Kartalspor	32	21	29	34
14	Akhisar	32	27	39	33
15	İstanbul	32	19	42	33
16	Altay	32	27	43	31
17	Diyarbakirsp	32	10	59	10

TEMPORADA 2009/2010

1. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Konyaspor	3	6	3	7
2	Altay	3	4	3	5
3	Karsiyaka	3	2	3	2
4	Adanaspor	3	4	7	1

TEMPORADA 2008/2009

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Manisaspor	34	64	37	64
2	Diyarbakirsp	34	39	27	62
3	Boluspor	34	49	35	56
4	Kasımpaşa	34	45	27	55
5	Altay	34	50	39	55
6	Karsiyaka	34	35	29	51
7	Karabükspor	34	51	48	49
8	Adanaspor	34	38	38	48
9	Rizespor	34	39	44	47
10	Orduspor	34	48	44	45
11	Kayseri	34	45	43	41
12	Kartalspor	34	33	37	41
13	Gaziantep	34	35	40	40
14	Giresunspor	34	35	48	40
15	Sakaryaspor	34	44	50	39
16	Samsunspor	34	35	47	39
17	İstanbul	34	35	56	36
18	Malatyaspor	34	32	63	29

TEMPORADA 2007/2008

2. LIG GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Karabükspor	11	12	7	23
2	Adana	12	15	13	21
3	Adanaspor	11	18	14	19
4	Gaziosmanpas	11	7	11	16
5	Mersin	11	15	11	15
6	Tarsus Idman	12	15	13	15
7	Erzurumspor	11	10	14	13
8	Pendikspor	11	12	12	12
9	Etimesgut	11	13	14	12
10	Canakkale	11	4	12	9

TEMPORADA 2006/2007

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Amedspor	30	57	20	60
2	Mezitlispor	30	43	26	55
3	Adanaspor	29	52	16	54
4	Aksarayspor	29	36	27	52
5	Batman Spor	29	41	28	50
6	Batman	29	37	33	47
7	Yeni	30	33	30	47
8	Şırnakspor	30	44	32	45
9	Vanspor FK	30	47	35	44
10	Nusaybin	30	36	40	42
11	Ceyhanspor	30	36	44	37
12	Kilis	30	25	41	33
13	Kayapınar	30	29	36	28
14	İskenderun	30	25	46	26
15	Osmaniyespor	30	23	64	24
16	Karamanspor	30	16	62	14

TEMPORADA 2005/2006

2. LIG GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Marmaris	14	19	8	28
2	Nazilli	14	21	9	27
3	Adana	14	22	19	23
4	Izmirspor	14	22	16	22
5	Turgutluspor	14	21	17	20
6	Aydinspor	14	20	18	20
7	Muğlaspor	14	15	11	18
8	Adanaspor	14	0	42	0

TEMPORADA 2004/2005

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Sivasspor	34	58	24	74
2	Manisaspor	34	55	26	69
3	Kayseri	34	64	46	68
4	Bursaspor	34	61	26	63
5	Kocaelispor	34	49	28	62
6	Elazigspor	34	53	45	57
7	Mersin	34	49	53	53
8	Türk	34	44	42	49
9	İstanbul	34	34	35	46
10	Mardinspor	34	33	34	45
11	Altay	34	41	49	40
12	Canakkale	34	54	57	39
13	Karsiyaka	34	41	50	38
14	Antalyaspor	34	42	45	37
15	Yozgatspor	34	48	64	33
16	Sariyer	34	32	56	27
17	Adanaspor	34	38	70	27
18	Fatih	34	31	77	23

Competiciones que juega

1. Lig

Pos	Equipos		Pts
1		Adana Demirspor	70
2		Giresunspor	70
3		Samsunspor	70
4		Istanbulspor AS	64
5		Altay	63
6		Altinordu	60
7		Keciorengucu	58
8		Umraniyespor	51
9		Tuzlaspor	47
10		Bursaspor	46
11		Bandirmaspor	42
12		Boluspor	42
13		Balikesirspor	35
14		Adanaspor	34
15		Menemenspor	34
16		Akhisar Belediyespor	30
17		Ankaraspor	26
18		Eskişehirspor	8

	Ascenso : Adana Demirspor, Giresunspor
	Playoff Ascenso : Samsunspor, Istanbulspor AS, Altay, Altinordu
	Descenso : Akhisar Belediyespor, Ankaraspor, Eskişehirspor

RIVALES EN Copa Turca

RIVALES EN 1. Lig

USO DE MEMORIA

7,316,064 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1776
Total Execution Time	0.1789

CADENA URL

/historico/Adanaspor-Fk/2021

GET DATOS

$_GET['/historico/Adanaspor-Fk/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0041	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 = 'Adanaspor-Fk' AND l.year = 2021 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=69 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=69 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=69 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 58566
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=69 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=358 AND type_rel = 3
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 358 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	SELECT /53 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 (1309832,1307337,1307165,1294898,1267840) ORDER BY n.cover_points DESC, update_date DESC
0.0036	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 = '69' ORDER BY l.year DESC,cat.coefficient DESC
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 = '69' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '69' 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 = 58566 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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=69 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (64038,63196,62807) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 63196 AND teamId = 69
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 64038 AND teamId = 69
0.0114	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 69
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 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 = 58566 AND t.round = 34 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 = '69' 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 = '69' and rp.type = 4
0.0021	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 = '69' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041	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 events2021 e ON e.player_id = p.id AND e.league_id = 58566 WHERE rp.league_id = 58566 AND rp.teamId = 69 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 events2021 e ON e.player_id = p.id AND e.league_id = 58566 WHERE rp.league_id = 58566 AND rp.teamId = 69 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 events2021 e ON e.player_id = p.id AND e.league_id = 58566 WHERE rp.league_id = 58566 AND rp.teamId = 69 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 69 AND l.year <= 2021 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* `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 = 58566 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.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 = 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.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* `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 = 43611 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* `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 = 38966 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 = 30997 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 = 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.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* `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 = 3852 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 = 2802 AND t.round = 38 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* `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.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 = 9936 AND t.round = 34 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* `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 = 9938 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 12829 AND t.round = 3 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* `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 = 9940 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* `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.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 = 16576 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041	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 = 50225 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 = 50678 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* `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 = 50684 AND t.round = 14 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* `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 = 13093 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Adanaspor

Adanaspor

Selecciona un equipo

Competiciones que juega

1. Lig

RIVALES EN Copa Turca

RIVALES EN 1. Lig