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

Crevillente Deportivo

Temporada 2018/2019

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Orihuela CF	38	62	21	86
2	Nucía	38	53	25	70
3	Olimpic	38	52	29	69
4	Saguntino	38	47	27	66
5	Crevillente	38	47	34	65
6	Atzeneta	38	48	42	58
7	Jove	38	41	44	55
8	CD Roda	38	44	42	54
9	Eldense	38	47	48	53
10	Villarreal	38	52	44	52
11	Vilamarxant	38	52	49	50
12	Silla CF	38	40	44	48
13	Paterna CF	38	42	51	46
14	UD Alzira	38	33	52	43
15	Novelda CF	38	45	51	43
16	Ilicitano	38	42	47	41
17	CD Acero	38	45	53	39
18	Rayo Ibense	38	39	53	39
19	Torre	38	28	48	36
20	Paiporta	38	30	85	19

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	At. Levante	40	72	31	84
2	Castellón	40	64	32	83
3	Orihuela CF	40	62	28	78
4	Nucía	40	67	34	71
5	Eldense	40	54	40	70
6	Torre	40	48	27	69
7	Olimpic	40	39	32	60
8	Villarreal	40	53	55	56
9	UD Alzira	40	42	46	51
10	Novelda CF	40	37	42	51
11	CD Roda	40	47	45	51
12	Crevillente	40	35	46	48
13	Paterna CF	40	40	47	47
14	Silla CF	40	47	46	46
15	Rayo Ibense	40	34	48	46
16	Paiporta	40	42	63	43
17	Ilicitano	40	38	46	42
18	Almazora	40	32	64	42
19	Buñol	40	32	44	39
20	CF Borriol	40	34	69	27
21	Recambios	40	32	66	25

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Olimpic	40	68	19	87
2	UD Alzira	40	61	25	80
3	Ontinyent	40	56	29	76
4	Castellón	40	65	31	76
5	Orihuela CF	40	62	31	71
6	Novelda CF	40	46	27	70
7	Villarreal	40	67	47	69
8	Ilicitano	40	58	37	68
9	Torre	40	58	50	61
10	Crevillente	40	39	37	58
11	Silla CF	40	51	57	51
12	Rayo Ibense	40	49	56	49
13	Almazora	40	43	48	48
14	Recambios	40	33	44	46
15	CF Borriol	40	41	55	45
16	Paterna CF	40	35	60	43
17	Buñol	40	44	62	42
18	Muro	40	39	50	39
19	Torrevieja	40	38	71	35
20	Almoradí	40	32	77	27
21	Segorbe	40	22	94	13

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Saguntino	38	62	25	82
2	Ontinyent	38	62	39	71
3	Castellón	38	60	41	70
4	Ilicitano	38	64	39	69
5	Villarreal	38	64	43	61
6	UD Alzira	38	57	50	60
7	Novelda CF	38	51	39	58
8	Orihuela CF	38	50	46	56
9	Torre	38	43	35	55
10	Rayo Ibense	38	38	40	54
11	Torrevieja	38	46	47	52
12	Crevillente	38	41	37	51
13	Muro	38	44	51	49
14	Paterna CF	38	38	53	41
15	CF Borriol	38	36	51	40
16	Recambios	38	42	61	39
17	Buñol	38	22	43	39
18	Jove	38	34	48	38
19	Benigànim	38	41	66	33
20	CD Acero	38	28	69	23

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Castellón	40	61	29	74
2	At. Levante	40	61	31	72
3	Novelda CF	40	66	36	66
4	Villarreal	40	60	51	62
5	Ontinyent	40	57	36	62
6	Muro	40	55	56	62
7	Orihuela CF	40	55	35	62
8	Crevillente	40	43	35	59
9	Benigànim	40	54	51	59
10	Torrevieja	40	44	45	57
11	Saguntino	40	51	48	54
12	CD Acero	40	51	67	53
13	Torre	40	40	42	51
14	UD Alzira	40	49	59	50
15	Paterna CF	40	42	59	49
16	Jove	40	36	54	47
17	CF Cullera	40	49	52	47
18	Ribarroja	40	31	47	45
19	Nucía	40	36	44	40
20	SC Requena	40	33	64	32
21	CD Utiel	40	31	64	26

TEMPORADA 2013/2014

PRIMERA FFCV GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	SFFCV	34	59	26	67
2	Crevillente	34	44	25	62
3	Villajoyosa	34	46	24	61
4	Rayo Ibense	34	50	31	61
5	Almoradí	34	63	43	60
6	Alicante	34	52	32	59
7	Hércules B	34	50	38	55
8	Horadada	34	49	37	51
9	Callosa	34	46	39	48
10	Thader	34	38	52	46
11	Albatera Cf	34	49	48	44
12	Santa Pola	34	52	51	44
13	El Campello	34	33	54	40
14	Petrelense	34	44	56	39
15	CD Cox	34	31	40	37
16	Aspe	34	37	61	28
17	Mutxamel	34	34	75	23
18	Ciudad	34	28	73	18

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Ilicitano	40	47	28	71
2	Novelda CF	40	50	37	71
3	UD Alzira	40	50	39	69
4	Castellón	40	58	29	68
5	Nucía	40	47	36	62
6	Muro	40	53	47	59
7	Villarreal	40	53	50	59
8	CF Borriol	40	52	39	57
9	CD Utiel	40	45	40	56
10	Eldense	40	46	39	53
11	Saguntino	40	36	45	53
12	CD Llosa	40	44	45	52
13	Torrevieja	40	45	42	52
14	Jove	40	44	48	50
15	Ribarroja	40	35	46	48
16	CD Acero	40	49	60	48
17	CD Burriana	40	40	57	47
18	CF Gandia	39	32	39	45
19	Crevillente	40	40	51	45
20	Dénia	40	43	56	42
21	Catarroja	39	29	65	28

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Catarroja	42	78	34	92
2	At. Levante	42	74	32	92
3	Muro	42	83	55	81
4	UD Alzira	42	62	33	79
5	CD Acero	42	70	42	78
6	Nucía	42	71	41	78
7	Torrevieja	42	64	36	74
8	Novelda CF	42	57	50	72
9	Castellón	42	47	40	69
10	Jove	42	66	53	62
11	Villarreal	42	82	59	62
12	CF Borriol	42	72	67	59
13	Saguntino	42	47	50	52
14	Eldense	42	54	64	50
15	Ribarroja	42	47	50	49
16	Crevillente	42	48	66	47
17	CD Llosa	42	55	67	45
18	SC Requena	42	57	72	43
19	Alicante	42	37	91	29
20	Mislata	42	45	92	27
21	Juventud	42	35	78	27
22	Altea	42	29	108	21

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Valencia	38	83	28	86
2	Olimpic	38	52	29	73
3	Novelda CF	38	62	46	68
4	Nucía	38	48	35	66
5	CF Borriol	38	61	35	66
6	Villarreal	38	75	53	64
7	Crevillente	38	43	43	54
8	Catarroja	38	35	32	50
9	Torrellano	38	52	44	50
10	Juventud	38	39	43	47
11	Saguntino	38	41	53	46
12	Mislata	38	37	52	46
13	Jove	38	44	47	45
14	Eldense	38	31	39	45
15	Ribarroja	38	34	54	45
16	Torrevieja	38	31	42	43
17	At. Levante	38	30	47	43
18	Burjassot	38	41	52	40
19	Villajoyosa	38	36	59	37
20	Puçol	38	33	75	30

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	CF Gandia	36	51	27	68
2	UD Alzira	36	51	25	67
3	Villarreal	36	57	43	62
4	Novelda CF	36	48	40	61
5	Catarroja	36	41	36	58
6	Olimpic	36	48	32	57
7	Nucía	36	60	34	57
8	Juv. Barrio	36	37	21	55
9	At. Levante	36	44	39	54
10	Crevillente	36	53	40	52
11	Burjassot	36	43	50	50
12	Jove	36	35	39	46
13	Torrevieja	36	40	38	45
14	Ribarroja	36	29	33	45
15	Puçol	36	45	55	40
16	Eldense	36	34	46	38
17	Ilicitano	36	35	90	30
18	Onda	36	27	53	28
19	Alicante	36	17	54	27

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Villajoyosa	38	58	31	74
2	Alicante	38	62	33	71
3	Nucía	38	45	27	71
4	Torrevieja	38	52	29	68
5	CF Gandia	38	41	30	64
6	Eldense	38	44	32	64
7	Burjassot	38	50	38	62
8	Catarroja	38	43	37	59
9	Villarreal	38	66	52	56
10	Onda	38	44	43	53
11	Novelda CF	38	45	33	51
12	At. Levante	38	34	38	47
13	Jove	38	50	46	44
14	Ribarroja	38	38	49	43
15	Juv. Barrio	38	42	59	41
16	Crevillente	38	40	51	39
17	Puçol	38	48	71	39
18	Castellón	38	50	66	38
19	Pego	38	26	80	24
20	CD Utiel	38	31	64	24

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	UD Alzira	40	64	28	79
2	Valencia	40	66	26	75
3	Nucía	40	59	32	72
4	Catarroja	40	60	38	72
5	Eldense	40	54	34	70
6	Novelda CF	40	58	38	69
7	CD Utiel	40	55	43	64
8	Villarreal	40	45	47	55
9	Onda	40	49	46	53
10	Jove	40	39	45	53
11	Burjassot	40	41	41	52
12	Puçol	40	39	53	51
13	Crevillente	40	32	35	50
14	Castellón	40	40	59	50
15	Torrevieja	40	51	55	49
16	Juv. Barrio	40	43	50	47
17	Pego	40	43	59	47
18	Thader	40	37	54	45
19	Olimpic	40	36	53	43
20	Ilicitano	40	36	65	33
21	Alone	40	34	80	31

TEMPORADA 2006/2007

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Dénia	39	75	35	83
2	Villarreal	39	74	25	80
3	Ontinyent	39	68	34	75
4	Torrevieja	39	62	33	74
5	Novelda CF	39	58	28	73
6	Burjassot	39	51	41	61
7	Castellón	39	54	48	56
8	Onda	39	51	43	55
9	Catarroja	39	42	46	54
10	Pego	40	42	49	54
11	Alone	39	46	59	49
12	Crevillente	39	43	50	49
13	Jove	39	43	63	46
14	Puçol	39	47	54	45
15	UD Alzira	39	37	57	44
16	Ilicitano	39	43	50	43
17	Dolores	39	36	45	43
18	SD Sueca	39	32	50	43
19	Horadada	39	45	56	42
20	UD Oliva	39	39	66	38
21	Alicante	39	34	58	37
22	Sp. Requena	40	33	65	31

TEMPORADA 1996/1997

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Alcoyano	40	81	30	90
2	Ontinyent	40	78	29	84
3	Novelda CF	40	65	35	73
4	Olimpic	40	63	44	72
5	Pinoso	40	45	21	68
6	CD Burriana	40	69	50	67
7	Jove	40	56	42	64
8	Eldense	40	64	41	62
9	Burjassot	40	42	41	56
10	CD Acero	40	44	53	51
11	Onda	40	58	59	51
12	CD Utiel	40	43	46	50
13	Vall Uxó	40	41	53	49
14	Gimnástico	40	61	56	49
15	Marcelino	40	52	50	48
16	Pego	40	40	56	46
17	SD Sueca	40	39	57	46
18	Almoradí	40	49	58	44
19	Alicante	40	31	90	26
20	Crevillente	40	27	83	22
21	Mutxamel	40	19	73	22

TEMPORADA 1995/1996

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Lliria UD	38	66	29	77
2	CD Acero	38	78	30	74
3	CF Gandia	38	64	31	70
4	Pinoso	38	51	30	65
5	Jove	38	42	29	65
6	CD Utiel	38	56	41	65
7	Onda	38	66	36	62
8	SD Sueca	38	58	44	61
9	Eldense	38	54	41	60
10	Gimnástico	38	47	43	55
11	Burjassot	38	49	41	54
12	Alicante	38	37	46	49
13	Vall Uxó	38	38	48	45
14	Crevillente	38	28	50	44
15	Almoradí	38	38	48	43
16	Olimpic	38	47	54	39
17	Mutxamel	38	43	62	36
18	Alaquas	38	30	64	36
19	Villena	38	20	79	23
20	Alberic	38	22	88	23

TEMPORADA 1994/1995

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	CF Gandia	38	64	30	58
2	Onda	38	67	26	54
3	Novelda CF	38	62	30	51
4	Pinoso	38	66	35	51
5	Lliria UD	38	56	29	49
6	Vall Uxó	38	55	38	49
7	Gimnástico	38	49	38	42
8	Eldense	38	44	47	40
9	Alberic	38	36	38	40
10	Alicante	38	52	45	39
11	Olimpic	38	44	41	39
12	SD Sueca	38	38	36	36
13	Alaquas	38	44	49	33
14	CD Utiel	38	43	48	33
15	Crevillente	38	35	47	32
16	Mutxamel	38	34	49	31
17	Villena	38	33	66	27
18	Jávea	38	23	48	26
19	UD Oliva	38	25	65	22
20	Horadada	38	25	90	8

TEMPORADA 1993/1994

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Pinoso	38	70	23	53
2	Ontinyent	38	75	37	53
3	Crevillente	38	66	35	50
4	Eldense	38	79	33	50
5	CD Utiel	38	59	37	50
6	Onda	38	60	28	49
7	Alberic	38	50	22	46
8	Alicante	38	44	26	44
9	Lliria UD	38	65	47	42
10	Mutxamel	38	57	39	41
11	SD Sueca	38	49	47	38
12	UD Oliva	38	46	47	36
13	Villena	38	45	44	35
14	Alaquas	38	34	39	31
15	Horadada	38	43	75	30
16	Jávea	38	38	45	30
17	CF Gandia	38	34	61	27
18	Orihuela	38	30	49	24
19	UD Alzira	38	32	81	19
20	Calpe	38	22	183	10

TEMPORADA 1992/1993

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Pinoso	38	49	29	49
2	Crevillente	38	51	39	49
3	Villena	38	57	38	49
4	UD Oliva	38	58	29	48
5	Calpe	38	54	43	48
6	Ontinyent	38	45	23	45
7	CF Gandia	38	61	39	44
8	Alaquas	38	45	41	42
9	SD Sueca	38	43	39	41
10	Jávea	38	43	28	40
11	Eldense	38	53	41	40
12	Alberic	38	45	48	36
13	Mutxamel	38	48	52	36
14	UD Alzira	38	31	51	35
15	Carcaixent	38	57	63	34
16	Benicarló	38	47	47	32
17	Foios	38	39	62	27
18	Torrent	38	22	42	27
19	Picassent	38	39	73	24
20	Saguntino	38	31	91	14

TEMPORADA 1980/1981

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Catarroja	38	73	47	52
2	Carcaixent	38	51	34	49
3	Dénia	38	61	44	46
4	Puzol	38	59	44	46
5	Alcoyano	38	53	35	45
6	CF Gandia	38	59	41	45
7	UD Alzira	38	53	48	40
8	Valencia	38	59	44	38
9	Vinaròs	38	53	51	38
10	Alicante	38	44	41	37
11	Ontinyent	38	35	41	37
12	Olimpic	38	37	52	37
13	Novelda CF	38	51	54	36
14	Quart Poblet	38	47	57	36
15	Paterna CF	38	45	52	35
16	Villarreal	38	59	60	34
17	Jove	38	45	52	32
18	Villena	38	43	60	29
19	Crevillente	38	41	76	26
20	CD Acero	38	46	81	22

TEMPORADA 1979/1980

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Cartagena	38	75	32	57
2	Albacete	38	55	23	55
3	Orihuela	38	63	42	48
4	CD Acero	38	43	43	41
5	Valencia	38	54	46	41
6	Carcaixent	38	48	34	41
7	CF Gandia	38	45	29	39
8	Crevillente	38	29	36	39
9	Villarreal	38	50	41	39
10	Alcoyano	38	41	38	38
11	Villena	38	52	52	38
12	AP Almansa	38	46	52	37
13	Quart Poblet	38	45	54	36
14	Alicante	38	55	53	36
15	Torrevieja	38	52	57	34
16	Olimpic	38	39	47	33
17	Lorca	38	39	56	33
18	Jove	38	33	58	31
19	UD Alzira	38	36	65	25
20	Paterna CF	38	41	83	19

Competiciones que juega

Tercera División Grupo 6

Pos	Equipos		Pts
1		Orihuela CF	86
2		CF La Nucía	70
3		Olimpic Xátiva	69
4		At. Saguntino	66
5		Crevillente Deportivo	65
6		Atzeneta	58
7		FC Jove Español	55
8		CD Roda	54
9		Eldense	53
10		Villarreal C	52
11		Vilamarxant	50
12		Silla CF	48
13		Paterna CF	46
14		UD Alzira	43
15		Novelda CF	43
16		Ilicitano	41
17		CD Acero	39
18		Rayo Ibense	39
19		Torre Levante	36
20		Paiporta	19

	Playoff Ascenso : Orihuela CF, CF La Nucía, Olimpic Xátiva, At. Saguntino
	Descenso : Rayo Ibense, Torre Levante, Paiporta

RIVALES EN Tercera División

USO DE MEMORIA

8,376,920 bytes

BENCHMARKS

Loading Time Base Classes	0.0022
Controller Execution Time ( Home / Category )	0.1875
Total Execution Time	0.1898

CADENA URL

/historico/Crevillente-Deportivo/2019

GET DATOS

$_GET['/historico/Crevillente-Deportivo/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0031	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 = 'Crevillente-Deportivo' AND l.year = 2019 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.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=4659 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=4659 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=4659 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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 = 44394
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4659 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4659 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (7478,93128,101112,120110,149933) ORDER BY n.cover_points DESC, update_date 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 = '4659' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '4659' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '4659' 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 = 44394 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=4659 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (50274,49506) 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 = 50274 AND teamId = 4659
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 4659
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 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 = 44394 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024	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 = '4659' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4659' and rp.type = 4
0.0028	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 = '4659' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 events2019 e ON e.player_id = p.id AND e.league_id = 44394 WHERE rp.league_id = 44394 AND rp.teamId = 4659 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.0031	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 events2019 e ON e.player_id = p.id AND e.league_id = 44394 WHERE rp.league_id = 44394 AND rp.teamId = 4659 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 events2019 e ON e.player_id = p.id AND e.league_id = 44394 WHERE rp.league_id = 44394 AND rp.teamId = 4659 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 4659 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 44394 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 39030 AND t.round = 42 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* `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 = 33356 AND t.round = 42 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* `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 = 15447 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 3916 AND t.round = 42 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 = 2678 AND t.round = 34 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 = 1946 AND t.round = 42 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* `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 = 1413 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 1121 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 830 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 136 AND t.round = 38 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 = 13 AND t.round = 42 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* `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 = 91 AND t.round = 40 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* `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 = 21969 AND t.round = 42 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* `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 = 21948 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 21928 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 21906 AND t.round = 38 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* `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 = 21885 AND t.round = 38 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* `tables1981` 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 = 21674 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* `tables1980` 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 = 21666 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 44394 ORDER BY nameShow LIMIT 100

Crevillente Deportivo

Crevillente Deportivo

Selecciona un equipo

Competiciones que juega

Tercera División Grupo 6

RIVALES EN Tercera División