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

Nevşehir Belediyespor

Temporada 2005/2006

TEMPORADA 2005/2006

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Erzincanspor	29	60	19	69
2	Gaskispor	30	74	23	64
3	Batman Spor	30	44	26	55
4	Kilis	30	46	42	50
5	Mezitlispor	30	59	47	45
6	Şırnakspor	30	39	41	40
7	Karamanspor	30	35	35	38
8	Amedspor	30	55	49	37
9	Kayapınar	30	36	35	36
10	Karsspor	29	29	26	35
11	İskenderun	30	38	38	35
12	Ceyhanspor	30	32	54	34
13	Nusaybin	30	26	50	31
14	Iğdırspor	30	37	62	30
15	Bitlis	30	28	53	30
16	Nevşehir	30	32	70	29

TEMPORADA 2004/2005

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Körfez	30	55	19	64
2	Nevşehir	30	58	26	57
3	Bitlis	30	54	29	57
4	Ceyhanspor	29	49	27	54
5	İskenderun	30	52	38	48
6	Gaskispor	30	57	37	46
7	Mezitlispor	30	36	24	45
8	Amedspor	30	41	35	42
9	Kilis	30	40	38	42
10	Batman Spor	30	36	34	38
11	Şırnakspor	30	36	39	36
12	Iğdırspor	30	32	52	33
13	Nusaybin	30	29	37	32
14	Kayapınar	30	41	60	31
15	Muş Spor	30	24	48	28
16	Niğdespor	29	12	109	6

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

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Hacettepe	32	68	21	68
2	Mobellaspor	32	70	26	68
3	Side	32	53	57	49
4	Kütahyaspor	31	45	27	48
5	Afjet	32	56	59	47
6	Aksarayspor	32	45	40	46
7	Kemerspor	32	43	40	44
8	Mamak Fk	31	43	41	44
9	Ispartaspor	31	36	43	43
10	Sidespor	31	44	37	41
11	Nevşehir	32	40	53	39
12	Anamur	32	44	60	38
13	Karamanspor	32	40	52	37
14	Eskişehir	32	40	50	34
15	Alanyaspor	32	35	46	33
16	Eskişehir	32	38	65	32
17	Afyon	32	43	66	26

TEMPORADA 1997/1998

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Petrol Ofisi	32	80	31	73
2	Kütahyaspor	32	61	25	69
3	Nevşehir	32	74	37	68
4	Mamak Fk	32	46	29	56
5	Aksarayspor	32	52	40	55
6	Tarsus Idman	32	51	46	55
7	Alanyaspor	32	53	48	52
8	Eskişehir	32	51	43	47
9	Afjet	32	41	42	41
10	Side	32	39	40	40
11	Mobellaspor	32	57	55	39
12	Ispartaspor	32	45	44	38
13	Simav	32	36	44	33
14	Karamanspor	32	37	52	32
15	Silifke	32	29	53	30
16	Konya	32	36	63	24
17	Kütahya	32	0	96	0

TEMPORADA 1996/1997

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ankaraspor	32	56	20	75
2	Petrol Ofisi	32	72	33	74
3	Ispartaspor	32	55	31	56
4	Aksarayspor	32	51	36	53
5	Kütahyaspor	32	59	50	47
6	Mobellaspor	32	52	43	46
7	Kütahya	31	45	47	46
8	Karamanspor	32	55	42	45
9	Nevşehir	32	40	39	44
10	Side	32	54	50	41
11	Mamak Fk	32	27	32	37
12	Eskişehir	32	41	58	35
13	Konya	32	41	59	34
14	Afjet	32	29	56	33
15	Tarımspor	32	27	46	32
16	Seydişehir	31	26	65	27
17	Antalya Köy	32	31	54	26

TEMPORADA 1995/1996

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Ankara	26	59	25	56
2	Aksarayspor	26	40	17	51
3	Nevşehir	26	42	22	50
4	Kırıkkales	26	35	30	39
5	Karamanspor	26	33	31	36
6	Kozan Spor	26	25	37	33
7	Keskinspor	26	31	34	32
8	Kayserispor	26	40	44	32
9	Mamak Fk	26	21	27	29
10	Kayseri	25	29	29	28
11	Tarımspor	26	25	45	28
12	Tarsus Idman	26	25	36	26
13	Niğdespor	26	23	35	25
14	Kızılcaham	25	17	33	24

TEMPORADA 1994/1995

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Türk	26	75	27	61
2	Keciorengucu	26	71	18	60
3	Kırıkkales	26	51	26	55
4	Ankara	26	60	28	54
5	Aksarayspor	26	37	40	33
6	Kayserispor	26	33	33	30
7	Keskinspor	25	23	29	30
8	Nevşehir	26	33	46	30
9	Niğdespor	26	33	46	26
10	Kayseri	26	22	46	26
11	DHMİ Ankara	26	31	46	25
12	Kızılcaham	26	30	49	25
13	Ankara	26	24	51	21
14	Polatlıspor	25	27	65	18

TEMPORADA 1993/1994

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Turanspor	24	42	10	54
2	Nevşehir	24	44	21	53
3	Ankara	24	50	24	46
4	Kırıkkales	24	38	23	45
5	Çubukspor	24	36	26	40
6	Beypazarı	24	30	25	29
7	Niğdespor	24	32	35	29
8	Aksarayspor	24	23	30	29
9	Ankara	24	31	36	28
10	Polatlıspor	24	26	41	27
11	Keciorengucu	24	33	35	26
12	Tarımspor	24	37	44	23
13	Ankara DSİ	24	0	72	0

TEMPORADA 1992/1993

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Yeni	30	64	24	68
2	Nevşehir	30	72	21	66
3	Turanspor	30	54	29	53
4	Beypazarı	30	52	35	50
5	Karamanspor	30	53	47	49
6	Silifkespor	30	52	46	49
7	Ankara	30	41	35	43
8	Aksarayspor	29	33	30	42
9	Tarımspor	30	47	51	40
10	Ankara	30	42	31	39
11	Polatlıspor	29	42	44	38
12	Ankara DSİ	30	39	47	37
13	Kirsehirspor	30	36	63	31
14	Konya	30	38	71	29
15	Konya	30	27	63	14
16	Silifke	30	34	89	14

TEMPORADA 1991/1992

2. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	İskenderuns	36	76	18	83
2	Aksarayspor	36	57	27	74
3	Osmaniyespor	36	65	27	73
4	Nevşehir	36	69	29	71
5	Niğdespor	36	56	41	59
6	Adana	36	50	41	51
7	Adana	36	43	50	49
8	Kozan Spor	36	42	48	47
9	Kadirli	36	48	53	45
10	Adiyamanspor	36	46	45	44
11	Elbistan	36	48	53	44
12	Nizipspor	36	47	63	44
13	Hatay	36	36	54	44
14	Ceyhanspor	36	53	56	43
15	Besnispor	36	38	46	40
16	İslahiyespo	36	41	78	38
17	Kilis	36	37	57	37
18	Kirikhanspor	36	31	52	32
19	Reyhanlıspo	36	35	80	27

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

1. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gaziantepspo	32	60	32	69
2	Petrol Ofisi	32	38	21	52
3	Mersin	32	43	37	52
4	Keciorengucu	32	56	47	49
5	Siirtspor	32	38	26	48
6	Diyarbakirsp	32	38	37	47
7	Polatlıspor	32	31	40	47
8	Niğdespor	32	30	32	44
9	Türk	32	45	41	43
10	Turanspor	32	41	41	43
11	Nevşehir	32	37	40	42
12	Vanspor	32	27	26	41
13	Erzurumspor	32	38	44	40
14	Kahramanmara	32	38	52	40
15	İskenderuns	32	29	38	39
16	Sanliurfaspo	32	27	38	39
17	Erzincanspor	32	32	56	32

TEMPORADA 1988/1989

1. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Gençlerbirl	32	73	24	76
2	Orduspor	32	61	30	60
3	Gaziantepspo	32	49	42	49
4	İskenderuns	32	48	43	49
5	Erzurumspor	32	45	45	45
6	Petrol Ofisi	32	42	36	44
7	Siirtspor	32	31	36	42
8	Erzincanspor	31	41	42	40
9	Nevşehir	32	33	48	40
10	Turanspor	32	41	34	39
11	Diyarbakirsp	32	32	45	39
12	Vanspor	32	36	44	38
13	Polatlıspor	32	39	49	38
14	Mardinspor	32	36	46	38
15	Çarşambasp	31	29	42	37
16	Bitlisspor	32	30	44	36
17	Kayseri	32	37	53	29

TEMPORADA 1987/1988

2. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nevşehir	32	68	12	80
2	Hatayspor	32	76	15	75
3	Elbistan	32	41	28	53
4	Ceyhanspor	32	50	36	50
5	Kozan Spor	32	40	35	46
6	Osmaniyespor	32	48	46	44
7	Hatay	32	32	35	44
8	Reyhanlıspo	32	29	35	43
9	Kirikhanspor	32	32	37	42
10	Kamanspor	32	33	34	39
11	Kadirli	32	33	48	39
12	Sanliurfaspo	32	32	45	37
13	Nizipspor	32	26	53	34
14	Kilis	32	27	50	32
15	İslahiyespo	32	33	56	31
16	Afşin	32	23	35	29
17	Malatya	32	26	49	23

TEMPORADA 1986/1987

2. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Niğdespor	32	61	26	72
2	Nevşehir	32	49	18	65
3	Elbistan	32	39	26	58
4	Aksarayspor	32	33	23	52
5	Hatayspor	32	31	21	50
6	Kozan Spor	32	40	33	47
7	Ceyhanspor	32	35	33	42
8	Kilis	32	29	31	42
9	Kadirli	32	32	37	41
10	Nizipspor	32	29	35	39
11	Körfez	32	30	33	38
12	Kirikhanspor	32	28	34	38
13	Afşin	32	25	28	36
14	Pazarcık	32	23	43	32
15	İslahiyespo	32	25	34	31
16	İçel	32	28	52	27
17	Borspor	32	18	48	19

TEMPORADA 1985/1986

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Sitespor	24	47	13	60
2	Kirsehirspor	24	34	11	60
3	Keciorengucu	24	21	14	41
4	Niğdespor	24	30	26	40
5	Ankara	24	25	22	38
6	Aksarayspor	24	13	16	30
7	Yeni	24	20	20	29
8	Çubukspor	24	23	27	29
9	Konya	24	25	33	26
10	Karamanspor	24	22	29	24
11	Polatlıspor	24	17	31	21
12	Nevşehir	24	12	29	18
13	Borspor	24	8	26	16

TEMPORADA 1984/1985

2. LIG GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Seydişehir	22	46	14	48
2	Ankara	22	29	8	46
3	Kirsehirspor	22	37	13	43
4	Eskişehir	22	37	17	37
5	Konya	22	19	21	32
6	Niğdespor	22	21	25	29
7	Karamanspor	22	22	27	26
8	Nevşehir	22	18	27	24
9	Sanayispor	22	18	38	23
10	Keciorengucu	22	18	25	19
11	Aksarayspor	22	15	31	17
12	Borspor	22	13	47	12

TEMPORADA 1976/1977

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sanliurfaspo	18	25	11	34
2	Akçaabat	18	19	10	31
3	Tokatspor	18	21	14	29
4	Erzurumspor	18	18	8	28
5	Tarsus Idman	18	18	15	27
6	Hatayspor	18	14	13	24
7	Erzincanspor	18	12	15	24
8	Ceyhanspor	18	15	25	21
9	Amasyaspor	18	10	27	15
10	Nevşehir	18	14	28	13

TEMPORADA 1975/1976

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Diyarbakirsp	30	62	11	72
2	Erzurumspor	30	43	19	57
3	Petrol Ofisi	30	46	21	52
4	Tokatspor	30	36	17	50
5	Akçaabat	30	32	24	50
6	Tarsus Idman	30	30	21	47
7	Sanliurfaspo	30	29	24	46
8	Erzincanspor	30	22	25	41
9	Konya	30	25	26	40
10	Nevşehir	30	34	39	40
11	Fatih	30	21	39	30
12	Ceyhanspor	30	30	43	28
13	Üsküdar	30	14	33	26
14	Amasyaspor	30	22	51	26
15	Kastamonuspo	30	15	39	24
16	Galata	30	22	51	18

Competiciones que juega

3. Lig Grupo 1

Pos	Equipos		Pts
1		Erzincanspor	69
2		Gaskispor	64
3		72 Batman Spor	55
4		Kilis Belediyespor	50
5		Mezitlispor	45
6		Şırnakspor	40
7		Karamanspor	38
8		Amedspor	37
9		Kayapınar Belediyespor	36
10		Karsspor	35
11		İskenderun Belediyesi	35
12		Ceyhanspor Adana	34
13		Nusaybin Demirspor	31
14		Iğdırspor	30
15		Bitlis Özgüzelderespor	30
16		Nevşehir Belediyespor	29

	Ascenso : Erzincanspor, Gaskispor
	Playoff Ascenso : 72 Batman Spor
	Descenso : Bitlis Özgüzelderespor, Nevşehir Belediyespor

RIVALES EN 3. Lig

USO DE MEMORIA

7,235,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	1.1852
Total Execution Time	1.1865

CADENA URL

/historico/Nevsehir-Belediye-Spor

GET DATOS

$_GET['/historico/Nevsehir-Belediye-Spor']

POST DATOS

No hay datos POST existentes

CONSULTAS (70)

0.0155	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 = 'Nevsehir-Belediye-Spor' 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.0352	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 = 'Nevsehir-Belediye-Spor' 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.0148	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=121185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0153	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 = 50230
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121185 AND type_rel = 2
0.0148	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 = '121185' ORDER BY l.year DESC,cat.coefficient DESC
0.0148	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 = '121185' AND l.year = 2006 ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '121185' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '121185' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145	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 = 50230 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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=121185 AND l.year in (2005,2006,2007) 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 (50237) 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.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 50237 AND teamId = 121185
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 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 = 50230 AND t.round = 30 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 = '121185' 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 = '121185' and rp.type = 4
0.0149	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 = '121185' 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 events2006 e ON e.player_id = p.id AND e.league_id = 50230 WHERE rp.league_id = 50230 AND rp.teamId = 121185 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.0149	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 events2006 e ON e.player_id = p.id AND e.league_id = 50230 WHERE rp.league_id = 50230 AND rp.teamId = 121185 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150	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 events2006 e ON e.player_id = p.id AND e.league_id = 50230 WHERE rp.league_id = 50230 AND rp.teamId = 121185 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156	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 = 121185 AND l.year <= 2006 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 50230 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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 = 50237 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167	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.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* `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 = 50731 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* `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 = 50765 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* `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 = 50774 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* `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 = 50803 AND t.round = 26 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* `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 = 50814 AND t.round = 26 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 = 50830 AND t.round = 26 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* `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 = 50837 AND t.round = 30 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* `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 = 50846 AND t.round = 38 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* `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.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* `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 = 50397 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* `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 = 50405 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* `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 = 50893 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* `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 = 50909 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* `tables1986` 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 = 50929 AND t.round = 26 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* `tables1985` 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 = 50943 AND t.round = 22 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* `tables1977` 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 = 50995 AND t.round = 18 ORDER BY team.conference 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* `tables1976` 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 = 50998 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Nevşehir Belediyespor

Nevşehir Belediyespor

Selecciona un equipo

Competiciones que juega

3. Lig Grupo 1

RIVALES EN 3. Lig