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

Adana Demirspor

Entrenador: Hikmet Karaman

Temporada 2001/2002

TEMPORADA 1999/2000

2. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kayserispor	32	59	22	65
2	Kahramanmara	32	43	21	61
3	Adana	32	57	40	57
4	Körfez	32	56	38	49
5	Gaskispor	32	38	34	49
6	Tarsus Idman	32	36	34	47
7	Silifke	32	44	35	46
8	Niğdespor	32	39	44	46
9	Kayseri	31	36	31	43
10	Mezitlispor	32	45	36	41
11	İskenderuns	32	40	86	41
12	Nevşehir	32	34	39	38
13	Kilis	32	31	45	38
14	Ceyhanspor	31	29	32	35
15	Kozan	32	33	39	33
16	Fırat	32	31	43	31
17	İslahiyespo	32	16	48	21

TEMPORADA 1998/1999

1. LIG GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Bakırköysp	14	22	11	25
2	Gaziantep	14	31	23	23
3	Hatayspor	14	25	21	22
4	Mersin	14	22	19	21
5	Adana	14	18	20	17
6	Zeytinburnus	14	16	17	16
7	Kilimli	14	13	24	14
8	Konyaspor	14	11	23	12

TEMPORADA 1997/1998

1. LIG GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Marmaris	16	21	9	30
2	Turgutluspor	16	20	16	29
3	Bucaspor	16	17	14	27
4	Soma	16	21	19	26
5	Yeni	16	13	18	22
6	Karsiyaka	16	23	20	18
7	Aydinspor	16	16	20	17
8	Afjet	16	12	17	14
9	Adana	16	12	22	10

TEMPORADA 1996/1997

1. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Adana	14	21	10	30
2	Eskişehirsp	14	20	7	27
3	Konyaspor	14	22	12	22
4	Kemerspor	14	16	14	20
5	Düzcespor	14	18	22	19
6	Afjet	14	18	21	17
7	Inegolspor	14	17	25	12
8	Alanyaspor	14	10	31	8

TEMPORADA 1995/1996

1. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Kemerspor	14	22	12	30
2	Turanspor	14	17	12	26
3	Adanaspor	14	17	13	25
4	Adana	14	14	10	21
5	Beypazarı	14	12	15	16
6	Alanyaspor	14	15	21	15
7	Yozgatspor	14	8	14	13
8	Silifke	14	12	20	9

TEMPORADA 1994/1995

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Beşiktaş	34	80	26	79
2	Trabzonspor	34	80	28	76
3	Galatasaray	34	76	38	69
4	Fenerbahçe	34	78	35	67
5	Gençlerbirl	34	61	45	59
6	Bursaspor	34	47	39	51
7	Gaziantepspo	34	50	51	48
8	Samsunspor	34	54	60	45
9	Kocaelispor	34	57	60	44
10	Altay	34	44	57	44
11	Kayserispor	34	62	70	42
12	Belediye	34	38	50	39
13	Antalyaspor	34	39	46	38
14	Ankaragücü	34	39	57	38
15	Denizlispor	34	42	55	35
16	Zeytinburnus	34	35	74	30
17	Petrol Ofisi	34	38	73	29
18	Adana	34	25	81	15

TEMPORADA 1993/1994

1. LIG GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Petrol Ofisi	18	25	14	35
2	Denizlispor	18	36	27	35
3	Vanspor	18	19	21	28
4	Bakırköysp	18	23	16	27
5	Adana	18	20	19	26
6	Antalyaspor	18	28	26	23
7	Sakaryaspor	18	16	18	22
8	Aydinspor	18	20	33	21
9	Boluspor	18	14	20	19
10	Turgutluspor	18	15	22	18

TEMPORADA 1992/1993

1. LIG GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Muş Spor	14	15	16	26
2	Vanspor	14	15	8	24
3	Kahramanmara	14	13	9	22
4	Diyarbakirsp	14	23	16	21
5	Adanaspor	14	17	13	20
6	İskenderuns	14	17	15	19
7	Batman Spor	14	17	31	11
8	Adana	14	12	21	9

TEMPORADA 1991/1992

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Beşiktaş	30	58	20	76
2	Fenerbahçe	30	81	35	71
3	Galatasaray	30	54	35	60
4	Trabzonspor	30	56	31	55
5	Aydinspor	30	38	39	44
6	Bursaspor	30	44	43	40
7	Sariyer	30	34	44	38
8	Ankaragücü	30	42	44	37
9	Altay	30	34	46	36
10	Gençlerbirl	30	40	46	34
11	Bakırköysp	30	42	46	33
12	Konyaspor	30	28	34	32
13	Gaziantepspo	30	34	53	32
14	Boluspor	30	29	38	31
15	Adana	30	27	61	24
16	Samsunspor	30	36	62	18

TEMPORADA 1990/1991

1. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Adana	32	82	31	73
2	Malatyaspor	32	61	24	65
3	Mersin	32	69	36	64
4	Petrol Ofisi	32	53	40	61
5	Siirtspor	32	41	34	55
6	Keciorengucu	32	58	50	44
7	Erzurumspor	32	29	35	43
8	Vanspor	32	36	39	40
9	Turanspor	32	28	33	40
10	Hatayspor	32	39	48	40
11	Elazigspor	32	35	46	40
12	Türk	32	41	52	39
13	Diyarbakirsp	32	38	52	39
14	Kahramanmara	32	33	46	33
15	Nevşehir	32	28	43	33
16	Niğdespor	32	35	58	31
17	Polatlıspor	32	21	60	19

TEMPORADA 1989/1990

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Beşiktaş	34	77	20	75
2	Fenerbahçe	34	70	38	70
3	Trabzonspor	34	58	28	68
4	Galatasaray	34	59	26	63
5	Sariyer	34	52	38	59
6	Bursaspor	34	46	45	47
7	Konyaspor	34	41	42	46
8	Karsiyaka	34	47	50	46
9	Ankaragücü	34	32	42	46
10	Zeytinburnus	34	39	39	45
11	Gençlerbirl	34	50	51	45
12	Adanaspor	34	48	53	45
13	Boluspor	34	32	39	45
14	Malatyaspor	34	43	46	44
15	Altay	34	38	57	35
16	Samsunspor	34	24	50	27
17	Adana	34	31	83	23
18	Sakaryaspor	34	33	73	21

TEMPORADA 1988/1989

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Fenerbahçe	36	103	27	93
2	Beşiktaş	36	81	21	83
3	Galatasaray	36	76	31	69
4	Sariyer	36	70	43	68
5	Trabzonspor	36	59	38	64
6	Ankaragücü	36	53	41	60
7	Boluspor	36	48	43	52
8	Konyaspor	36	43	59	46
9	Bursaspor	36	42	53	44
10	Sakaryaspor	36	43	57	44
11	Karsiyaka	36	50	54	43
12	Malatyaspor	36	59	68	43
13	Adanaspor	36	53	56	42
14	Adana	36	51	73	42
15	Altay	36	46	58	41
16	Eskişehirsp	36	38	57	41
17	Rizespor	36	36	65	35
18	Kahramanmara	36	22	71	23
19	Samsunspor	36	12	70	19

TEMPORADA 1987/1988

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Galatasaray	38	86	35	90
2	Beşiktaş	38	68	29	78
3	Malatyaspor	38	64	61	62
4	Samsunspor	38	43	41	60
5	Bursaspor	38	63	56	57
6	Trabzonspor	38	57	51	57
7	Karsiyaka	38	43	34	56
8	Fenerbahçe	38	45	43	55
9	Sariyer	38	60	51	52
10	Adana	38	59	64	52
11	Sakaryaspor	38	54	67	51
12	Altay	38	60	57	48
13	Ankaragücü	38	46	47	46
14	Boluspor	38	45	52	46
15	Eskişehirsp	38	45	53	46
16	Rizespor	38	37	56	46
17	Denizlispor	38	35	48	45
18	Kocaelispor	38	44	61	34
19	Gençlerbirl	38	41	65	30
20	Zonguldak	38	37	61	27

TEMPORADA 1986/1987

1. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Adana	32	78	26	78
2	Kayseri	31	52	23	60
3	Kahramanmara	31	58	28	58
4	Gaziantepspo	32	35	41	47
5	Kırıkkales	32	37	36	46
6	İskenderuns	32	40	31	45
7	Erzincanspor	32	35	37	44
8	Çarşambasp	32	34	33	43
9	Siirtspor	32	31	32	42
10	Vanspor	32	30	31	42
11	Erzurumspor	32	34	33	40
12	Turanspor	32	32	33	40
13	Bayburtspor	31	38	40	40
14	Akçaabat	32	26	39	39
15	Osmaniyespor	32	26	51	27
16	Reyhanlıspo	31	16	44	27
17	Elazigspor	32	28	72	19

Competiciones que juega

Grupo 2

RIVALES EN 2. Lig

USO DE MEMORIA

6,138,680 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.7882
Total Execution Time	0.7896

CADENA URL

/historico/Adana-Demirspor/2002

GET DATOS

$_GET['/historico/Adana-Demirspor/2002']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0168	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 = 'Adana-Demirspor' AND l.year = 2002 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.0146	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=68 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=68 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0303	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 = 50700
0.0146	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 2
0.0149	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 68 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151	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 (476498,712235,996201,1001918,1008111) ORDER BY n.cover_points DESC, update_date DESC
0.0163	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 = '68' ORDER BY l.year DESC,cat.coefficient DESC
0.0158	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 = '68' AND l.year = 2002 ORDER BY l.year DESC,cat.coefficient DESC
0.0158	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 = '68' 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 = 50700 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153	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=68 AND l.year in (2001,2002,2003) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (50700) 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.0144	SELECT count(id) as num_players from rel_players WHERE league_id = 50700 AND teamId = 68
0.0146	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2002` 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 = 50700 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146	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 = '68' 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 = '68' 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 = '68' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146	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 events2002 e ON e.player_id = p.id AND e.league_id = 50700 WHERE rp.league_id = 50700 AND rp.teamId = 68 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.0147	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 events2002 e ON e.player_id = p.id AND e.league_id = 50700 WHERE rp.league_id = 50700 AND rp.teamId = 68 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145	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 events2002 e ON e.player_id = p.id AND e.league_id = 50700 WHERE rp.league_id = 50700 AND rp.teamId = 68 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	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 = 68 AND l.year <= 2002 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* `tables2000` 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 = 50709 AND t.round = 34 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* `tables1999` 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 = 50299 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* `tables1999` 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 = 50305 AND t.round = 14 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* `tables1998` 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 = 50315 AND t.round = 22 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* `tables1998` 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 = 50321 AND t.round = 18 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* `tables1997` 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 = 50328 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	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* `tables1997` 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 = 50334 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162	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* `tables1996` 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 = 50340 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* `tables1996` 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 = 50346 AND t.round = 14 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* `tables1995` 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 = 424 AND t.round = 34 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* `tables1994` 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 = 50367 AND t.round = 18 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* `tables1994` 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 = 50368 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* `tables1993` 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 = 50379 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* `tables1993` 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 = 50385 AND t.round = 14 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* `tables1992` 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 = 9870 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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* `tables1991` 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 = 50394 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171	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* `tables1990` 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 = 9875 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0181	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* `tables1989` 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 = 9880 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166	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* `tables1988` 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 = 9879 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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* `tables1987` 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 = 50413 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 50700 ORDER BY nameShow LIMIT 100

Adana Demirspor

Adana Demirspor

Selecciona un equipo

Competiciones que juega

RIVALES EN 2. Lig