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

Crevillente Deportivo

Temporada 2023/2024

TEMPORADA 2023/2024

LLIGA COMUNITAT FFCV GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Callosa	0	0	0	0
2	Calpe	0	0	0	0
3	CF Benidorm	0	0	0	0
4	Alicante	0	0	0	0
5	Crevillente	0	0	0	0
6	Dénia	0	0	0	0
7	Eldense B	0	0	0	0
8	Hércules B	0	0	0	0
9	Jávea	0	0	0	0
10	L'Olleria	0	0	0	0
11	La Nucia B	0	0	0	0
12	Olimpic	0	0	0	0
13	Redovan	0	0	0	0
14	Santa Pola	0	0	0	0
15	Tavernes	0	0	0	0
16	Thader	0	0	0	0

TEMPORADA 2022/2023

PRIMERA FFCV GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Callosa	34	52	20	78
2	La Nucia B	34	76	31	71
3	Crevillente	34	66	25	70
4	Eldense B	34	80	40	65
5	CF Benidorm	34	54	34	61
6	Alicante	34	50	42	57
7	Redovan	34	47	29	56
8	Santa Pola	34	41	35	47
9	Thader	34	49	46	47
10	Murada	34	57	54	45
11	Atlético	34	43	40	42
12	Novelda UCF	34	44	54	38
13	Villena	34	36	57	38
14	Almoradí	34	39	61	35
15	Villajoyosa	34	37	66	31
16	Carrús	34	31	69	29
17	Benferri	34	27	67	19
18	Novelda CF	34	33	92	17

TEMPORADA 2021/2022

PRIMERA FFCV GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Crevillente	30	65	22	74
2	Rayo Ibense	30	65	19	68
3	Thader	30	55	24	60
4	Alicante	30	54	29	59
5	Redovan	30	52	28	57
6	Santa Pola	30	46	48	40
7	Benferri	30	36	37	38
8	Almoradí	30	42	34	37
9	Murada	30	41	39	37
10	Novelda CF	30	44	62	37
11	Carrús	30	49	57	34
12	Novelda UCF	30	44	51	33
13	Il-Licitana	30	39	53	31
14	UD Aspe	30	33	71	26
15	Univ.	30	31	72	22
16	Betis	30	36	86	14

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	UD Alzira	20	29	12	38
2	CD Roda	20	28	16	35
3	Saguntino	20	30	27	31
4	Villarreal	20	32	18	30
5	Silla CF	20	20	21	25
6	Recambios	20	16	19	23
7	Benicarló	20	22	21	22
8	Torrent	20	17	25	21
9	CD Acero	20	18	25	20
10	Paterna CF	20	14	25	20
11	Vilamarxant	20	13	30	15
12	Eldense	18	30	11	41
13	Ilicitano	18	33	17	38
14	Intercity	18	30	8	37
15	Olimpic	18	22	24	25
16	Benigànim	18	14	30	20
17	Jove	18	17	23	19
18	Crevillente	18	17	24	19
19	Hércules B	18	13	17	18
20	Villajoyosa	18	17	27	17
21	Novelda CF	18	15	27	12

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Alcoyano	28	55	14	65
2	UD Alzira	28	36	21	54
3	Atzeneta	28	40	22	50
4	Villarreal	28	46	29	48
5	Intercity	28	49	33	48
6	Eldense	28	36	27	40
7	Saguntino	28	35	28	40
8	Recambios	28	34	32	40
9	Novelda CF	28	35	33	39
10	Olimpic	28	30	29	39
11	Jove	28	37	34	38
12	CD Roda	28	32	41	38
13	Crevillente	28	25	36	34
14	Hércules B	28	27	28	32
15	Ilicitano	28	26	32	30
16	Paterna CF	28	26	37	29
17	Vilamarxant	28	37	54	29
18	CD Acero	28	24	35	26
19	Silla CF	28	20	39	25
20	Benigànim	28	20	66	16

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

Competiciones que juega

Lliga Comunitat FFCV Grupo 2

Pos	Equipos		Pts
1		Callosa Deportiva CF	0
2		Calpe	0
3		CF Benidorm	0
4		CFI Alicante	0
5		Crevillente Deportivo	0
6		Dénia	0
7		Eldense B	0
8		Hércules B	0
9		Jávea	0
10		L'Olleria	0
11		La Nucia B	0
12		Olimpic Xátiva	0
13		Redovan	0
14		Santa Pola	0
15		Tavernes de la Valldigna	0
16		Thader	0

	Ascenso : Callosa Deportiva CF
	Playoff Ascenso : Calpe, CF Benidorm
	Descenso : Santa Pola, Tavernes de la Valldigna, Thader

RIVALES EN Lliga Comunitat.

USO DE MEMORIA

8,139,904 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2633
Total Execution Time	0.2645

CADENA URL

/historico/Crevillente-Deportivo

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0029	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 = 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.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.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.0044	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 = 73540
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4659 AND type_rel = 2
0.0020	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.0021	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.0024	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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = 73540 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (73540,71823) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 73540 AND teamId = 4659
0.0042	SELECT count(id) as num_players from rel_players WHERE league_id = 71823 AND teamId = 4659
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 FROM* `tables2024` 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 = 73540 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0045	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 = 73540 WHERE rp.league_id = 73540 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.0032	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 = 73540 WHERE rp.league_id = 73540 AND rp.teamId = 4659 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73540 WHERE rp.league_id = 73540 AND rp.teamId = 4659 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables2024` 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 = 73540 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.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* `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 = 68784 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 63640 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 58584 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50274 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.0029	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.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* `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.0037	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.0047	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.0041	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0032	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.0036	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.0032	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.0041	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0038	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.0036	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.0029	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.0031	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0031	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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

Crevillente Deportivo

Crevillente Deportivo

Selecciona un equipo

Competiciones que juega

Lliga Comunitat FFCV Grupo 2

RIVALES EN Lliga Comunitat.