Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Düzcespor

Entrenador: Ahmet Yavuz

Temporada 2023/2024

TEMPORADA 2023/2024

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Amedspor	34	72	26	77
2	Kastamonuspo	34	58	24	74
3	76 Iğdır	34	57	26	68
4	Erzincanspor	35	54	32	63
5	Menemenspor	34	60	40	61
6	İskenderuns	34	61	43	59
7	Ispartaspor	34	39	43	54
8	Inegolspor	34	45	45	48
9	Somaspor	34	38	40	47
10	Fethiyespor	34	45	44	43
11	Aksaray	35	28	28	42
12	Karaman FK	34	38	50	42
13	Arnavutkoy	34	41	44	38
14	Etimesgut	34	24	37	38
15	Belediye	34	35	35	37
16	Sariyer	34	38	46	35
17	Düzcespor	34	39	61	33
18	Denizlispor	34	32	54	29
19	Usakspor	34	13	99	5

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

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Düzcespor	36	59	30	78
2	İskenderuns	36	72	31	74
3	76 Iğdır	36	64	39	72
4	Aksaray	36	49	43	59
5	52 Orduspor	36	48	41	58
6	Kestel	36	46	34	57
7	Kuşadasısp	36	42	48	47
8	Sile	36	39	46	47
9	Bayrampasasp	36	41	33	45
10	Kalecik FK	36	41	48	45
11	23 Elazig	36	40	36	43
12	Halide Edip	36	33	39	41
13	Yomraspor	36	35	45	41
14	Siirt Özel	36	38	57	41
15	Darica	36	33	46	38
16	Kizilcaboluk	36	41	51	37
17	Yeşilyurt	36	31	44	36
18	Çarşambasp	36	32	52	34
19	Hacettepe	36	24	45	31

TEMPORADA 2020/2021

3. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Adiyamanspor	32	43	27	57
2	Bursa	32	41	25	56
3	Düzcespor	32	45	33	54
4	Aksaray	32	40	27	53
5	1954 Kelkit	32	34	27	51
6	Bayrampasasp	32	44	37	45
7	52 Orduspor	32	44	33	44
8	Kestel	32	37	35	42
9	Karaköprü	32	45	42	40
10	Kırıkkales	32	37	45	40
11	Bergama	32	35	36	39
12	Siirt Özel	32	28	48	39
13	Kozanspor	32	27	32	38
14	Modafenspor	32	34	41	38
15	Sultanbeyli	32	25	36	37
16	Silivrispor	32	31	46	35
17	Muğlaspor	32	29	49	24

TEMPORADA 2019/2020

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Serik	28	49	24	55
2	Erzincanspor	28	47	22	52
3	Aksaray	28	43	27	50
4	Buca FK	28	47	34	49
5	Artvin	28	38	21	47
6	Düzcespor	28	32	18	46
7	Karaköprü	28	25	22	42
8	Çatalca	28	39	28	41
9	Silivrispor	28	37	31	38
10	Sultanbeyli	28	33	27	38
11	Kizilcaboluk	28	39	37	36
12	Yomraspor	28	28	30	36
13	52 Orduspor	28	21	20	35
14	Çankaya FK	28	33	37	34
15	Sile	28	23	30	29
16	İskenderuns	28	27	34	28
17	Tokatspor	28	16	66	7
18	Manisaspor	28	16	85	0

TEMPORADA 2018/2019

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kirsehirspor	34	54	38	63
2	Erokspor	34	56	30	62
3	Vanspor FK	34	60	27	60
4	Kizilcaboluk	34	60	39	55
5	Karsiyaka	34	39	32	55
6	Kalecik FK	34	46	30	54
7	Çatalca	34	39	45	48
8	Pazarspor	34	39	42	47
9	52 Orduspor	34	49	38	46
10	Osmaniyespor	34	40	42	44
11	Sultanbeyli	34	32	39	43
12	Kemerspor	34	36	45	43
13	Düzcespor	34	35	44	43
14	Ofspor	34	37	39	42
15	23 Elazig	34	34	50	41
16	Adıyaman	34	35	51	37
17	Alibeykoyspo	34	40	51	33
18	Bergama	34	25	74	15

TEMPORADA 2017/2018

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Manisa FK	34	60	27	75
2	Bayburt	34	51	33	62
3	Kemerspor	34	62	44	57
4	Bayrampasasp	34	43	34	57
5	Ofspor	34	41	27	55
6	Düzcespor	34	41	34	55
7	Halide Edip	34	45	33	51
8	Batman	34	43	36	48
9	Erbaaspor	34	46	41	48
10	Kalecik FK	34	42	44	42
11	Çatalca	34	33	37	41
12	Kozanspor	34	42	52	39
13	Yomraspor	34	23	42	37
14	İskenderuns	34	35	53	36
15	Bingölspor	34	28	42	34
16	Bergama	34	35	54	34
17	Orhangazispo	34	34	52	31
18	Canakkale	34	35	54	26

TEMPORADA 2016/2017

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bodrumspor	34	59	31	65
2	Erbaaspor	34	48	29	60
3	Manisa FK	34	59	37	58
4	Silivrispor	34	34	25	58
5	Çatalca	34	42	33	55
6	Düzcespor	34	55	46	54
7	Halide Edip	34	46	39	53
8	Kirikhanspor	34	36	39	47
9	Kemerspor	34	52	45	45
10	Yomraspor	34	28	29	44
11	Batman	34	38	38	43
12	Buca FK	34	41	46	43
13	Yeşil Bursa	34	40	35	41
14	Canakkale	34	42	54	41
15	Pazarspor	34	34	46	39
16	Dersim Spor	34	33	54	33
17	Derince	34	31	59	26
18	Turk Metal.	34	28	61	23

TEMPORADA 2015/2016

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Erzurumspor	36	67	32	74
2	Kizilcaboluk	36	52	34	68
3	Buca FK	36	53	38	63
4	Zonguldak	36	55	42	60
5	1461 Trabzon	36	46	34	60
6	İskenderuns	36	55	37	58
7	Yeşil Bursa	36	47	32	56
8	Tekirdağspo	36	44	44	47
9	Kirikhanspor	36	35	40	47
10	Maltepespor	36	38	31	46
11	Altay	36	45	45	45
12	Bursa	36	37	46	45
13	Düzcespor	36	41	47	44
14	Silivrispor	36	36	41	43
15	Kozanspor	36	44	52	42
16	Arsinspor	36	38	47	42
17	Gölbaşispo	36	36	49	38
18	Turgutluspor	36	33	48	38
19	Cizre Basra	36	16	79	16

TEMPORADA 2009/2010

3. LIG GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Keciorengucu	16	26	12	66
2	Beylerbeyi	16	22	15	54
3	Golcukspor	16	23	17	52
4	Ankara	16	23	16	46
5	Kırıkkales	16	21	26	45
6	Orhangazispo	16	17	24	42
7	Kartal	16	19	18	40
8	Düzcespor	16	15	21	40
9	Maltepespor	16	9	26	30

TEMPORADA 2008/2009

3. LIG GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Bursa	14	28	17	28
2	Inegolspor	14	27	14	27
3	Aksarayspor	14	28	22	27
4	Keciorengucu	14	22	12	25
5	Düzcespor	14	19	12	23
6	Kecioren	14	20	22	15
7	Orhangazispo	14	18	21	14
8	Usakspor	14	0	42	0

TEMPORADA 2002/2003

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Aksarayspor	26	50	23	56
2	Eskişehir	26	50	20	54
3	Hacettepe	26	49	20	54
4	Boluspor	26	46	21	53
5	Mamak Fk	26	43	16	48
6	Karamanspor	26	42	30	43
7	Afjet	26	42	35	41
8	Keciorengucu	26	41	33	40
9	Yeni	26	42	33	39
10	Alanyaspor	27	32	32	34
11	Bilecikspor	26	36	38	30
12	Düzcespor	27	29	39	30
13	Kızılcaham	26	34	46	30
14	Kayseri	26	3	75	3
15	Mobellaspor	26	0	78	0

TEMPORADA 1998/1999

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kırıkkales	32	49	19	62
2	Bilecikspor	32	49	25	58
3	Cankirispor	32	44	26	58
4	Düzcespor	31	51	30	56
5	Keciorengucu	32	44	32	52
6	ASKİspor	32	35	24	51
7	Türk	32	42	39	44
8	Akçakocaspo	32	43	46	42
9	Keskinspor	32	49	50	41
10	Kastamonuspo	31	44	51	40
11	Erdemir	32	37	40	38
12	Karadeniz	32	44	48	37
13	Mudurnuspor	32	32	36	37
14	Çubukspor	31	32	47	36
15	Çaycumaspor	32	32	49	33
16	Beypazarı	32	22	51	32
17	Bartinspor	31	24	60	25

TEMPORADA 1997/1998

1. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Kartalspor	14	21	14	29
2	Edirnespor	14	26	19	26
3	Kuşadasısp	14	28	21	23
4	Göztepe	14	17	13	21
5	Kasımpaşa	14	20	25	19
6	Fenerspor	14	15	20	18
7	Düzcespor	14	10	18	13
8	Beylerbeyisp	14	16	23	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 4
Equipo		PJ	GF	GC	Puntos
1	Sakaryaspor	18	35	16	38
2	Karabükspor	18	32	14	38
3	Fenerspor	18	20	22	25
4	Corumspor	18	25	26	22
5	Rizespor	18	19	28	22
6	Boluspor	18	27	24	20
7	Erzurumspor	18	23	23	20
8	Orduspor	18	22	30	20
9	Erzincanspor	18	21	31	19
10	Düzcespor	18	20	30	16

Competiciones que juega

Grupo 1

2. Lig Grupo 1

Pos	Equipos		Pts
1		Amedspor	77
2		Kastamonuspor	74
3		76 Iğdır	68
4		Erzincanspor	63
5		Menemenspor	61
6		İskenderunspor	59
7		Ispartaspor	54
8		Inegolspor	48
9		Somaspor	47
10		Fethiyespor	43
11		68 Aksaray Belediyespor	42
12		Karaman FK	42
13		Arnavutkoy	38
14		Etimesgut	38
15		Belediye Derincespor	37
16		Sariyer	35
17		Düzcespor	33
18		Denizlispor	29
19		Usakspor	5

	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,037,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.6067
Total Execution Time	0.6081

CADENA URL

/historico/Duzcespor

GET DATOS

$_GET['/historico/Duzcespor']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0142	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 = 'Duzcespor' 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.0125	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=65749 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=65749 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=65749 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65749 AND type_rel = 2
0.0133	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 = '65749' ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '65749' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '65749' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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=65749 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,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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 73213 AND teamId = 65749
0.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 65749
0.0126	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 = '65749' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65749' and rp.type = 4
0.0126	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 = '65749' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0141	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 = 65749 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.0142	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 = 65749 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 = 65749 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 65749 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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 = 63655 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.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* `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 = 58628 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.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* `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 = 50977 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.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* `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 = 44490 AND t.round = 34 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* `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 = 38978 AND t.round = 34 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* `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 = 33914 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* `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 = 15823 AND t.round = 38 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* `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 = 27128 AND t.round = 22 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* `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 = 27159 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 = 27163 AND t.round = 18 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 = 27196 AND t.round = 14 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* `tables2003` 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 = 50248 AND t.round = 28 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* `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 = 50730 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* `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 = 50316 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* `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 = 50322 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* `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.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* `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.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* `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 = 50341 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Düzcespor

Düzcespor

Selecciona un equipo

Competiciones que juega

2. Lig Grupo 1

RIVALES EN Copa Turca

RIVALES EN 2. Lig