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

Olimpic Xátiva

Temporada 2023/2024

TEMPORADA 2023/2024

LLIGA COMUNITAT FFCV GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CF Benidorm	28	55	22	68
2	Crevillente	28	48	25	55
3	Olimpic	28	33	24	48
4	Calpe	28	40	31	45
5	Eldense B	28	47	39	43
6	Redovan	28	37	35	43
7	Tavernes	28	38	34	38
8	Alicante	28	41	41	38
9	Hércules B	28	39	33	36
10	L'Olleria	28	43	49	33
11	Dénia	28	26	39	32
12	La Nucia B	28	24	39	31
13	Thader	28	34	59	31
14	Jávea	28	27	47	29
15	Santa Pola	28	28	34	27
16	Callosa	28	31	40	27

TEMPORADA 2022/2023

PRIMERA FFCV GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ontinyent	34	80	20	86
2	L'Olleria	34	76	35	75
3	Castellonens	34	66	33	66
4	Olimpic	34	53	27	65
5	Tavernes	34	66	43	55
6	SD Sueca	34	46	41	52
7	Dénia	34	62	47	51
8	Jávea	34	50	45	50
9	Calpe	34	44	36	47
10	Carcaixent	34	47	44	45
11	Font	34	48	56	45
12	Promeses	34	36	50	41
13	Alberic	34	40	48	40
14	Ontinyent	34	41	48	39
15	Canals	34	39	55	32
16	CF Cullera	34	37	93	22
17	Benigànim	34	29	92	21
18	Muro	34	24	71	18

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Valencia	36	65	27	74
2	Saguntino	36	46	30	64
3	Atzeneta	36	46	25	63
4	CD Acero	36	36	27	62
5	Torrent	36	42	32	60
6	Orihuela CF	36	50	35	58
7	CD Roda	36	34	23	56
8	Ilicitano	36	56	29	54
9	Villarreal	36	52	39	51
10	Torrellano	36	37	37	51
11	Hércules B	36	35	36	49
12	Silla CF	36	44	46	47
13	Castellón	36	32	34	46
14	Jove	36	23	31	45
15	Olimpic	36	29	44	40
16	Callosa	36	27	39	37
17	Recambios	36	22	46	31
18	Benigànim	36	32	78	25
19	Villajoyosa	36	14	64	19

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

SEGUNDA DIVISIÓN B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Reus	38	52	31	73
2	Villarreal	38	62	32	71
3	Hércules	38	51	28	71
4	Lleida	38	49	22	67
5	Cornellà	38	46	36	63
6	Alcoyano	38	47	34	61
7	CE Sabadell	38	49	40	55
8	Valencia	38	45	39	53
9	Atlético	38	48	47	53
10	Eldense	38	48	63	51
11	Barça	38	40	40	51
12	Espanyol B	38	50	45	48
13	Badalona	38	32	39	46
14	At. Levante	38	38	48	45
15	L´Hospitale	38	31	49	43
16	Olimpic	38	29	46	42
17	Pobla	38	34	47	38
18	Olot	38	37	53	37
19	Llosetense	38	26	54	35
20	Huracán	38	17	38	0

TEMPORADA 2014/2015

SEGUNDA DIVISIÓN B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gimnàstic	38	51	30	73
2	Huracán	38	46	30	65
3	Reus	38	44	33	63
4	Hércules	38	41	29	63
5	Lleida	38	45	34	61
6	Alcoyano	38	37	40	59
7	Badalona	38	37	37	56
8	Olimpic	38	38	37	55
9	L´Hospitale	38	41	36	54
10	Villarreal	38	51	45	53
11	Espanyol B	38	50	42	53
12	Atlético	38	48	45	49
13	Olot	38	37	38	48
14	Valencia	38	43	41	48
15	Cornellà	38	41	50	45
16	Eldense	38	45	49	45
17	Mallorca B	38	40	58	44
18	Sant Andreu	38	37	48	39
19	Ilicitano	38	38	60	35
20	Deportivo	38	39	67	34

TEMPORADA 2013/2014

SEGUNDA DIVISIÓN B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Badalona	38	61	36	69
2	Lleida	38	52	35	68
3	Gimnàstic	38	52	34	68
4	L´Hospitale	38	58	32	66
5	Ilicitano	38	60	41	64
6	Alcoyano	38	52	34	64
7	Atlético	38	50	36	64
8	Espanyol B	38	43	45	54
9	Huracán	38	40	38	52
10	Olimpic	38	37	35	52
11	Villarreal	38	45	42	51
12	Reus	38	38	49	51
13	Badalona	38	38	39	46
14	Olot	38	47	60	45
15	Sant Andreu	38	33	44	44
16	Valencia	38	39	50	41
17	AE Prat	38	31	45	38
18	At. Levante	38	42	59	36
19	Constància	38	23	52	34
20	Ontinyent	38	34	69	27

TEMPORADA 2012/2013

SEGUNDA DIVISIÓN B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	L´Hospitale	40	66	28	80
2	Huracán	40	52	24	80
3	At. Levante	40	60	46	72
4	Alcoyano	40	56	33	72
5	Olimpic	40	41	25	71
6	Gimnàstic	40	53	35	60
7	Sant Andreu	40	39	37	58
8	Espanyol B	40	44	42	55
9	Villarreal	40	59	57	54
10	Badalona	40	45	44	50
11	Atlético	40	40	40	48
12	AE Prat	40	36	35	48
13	Badalona	40	36	41	48
14	Reus	40	46	56	46
15	Ontinyent	40	34	46	46
16	Valencia	40	41	55	45
17	Constància	40	29	39	44
18	Mallorca B	40	34	53	44
19	Orihuela CF	40	29	44	39
20	Yeclano	40	39	60	35
21	Binissalem	40	22	61	30

TEMPORADA 2011/2012

SEGUNDA DIVISIÓN B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Atlético	38	65	39	72
2	Orihuela CF	38	50	33	68
3	Huracán	38	48	30	66
4	Badalona	38	48	26	65
5	Badalona	38	44	28	64
6	L´Hospitale	38	46	34	62
7	Lleida	38	50	40	59
8	Reus	38	43	37	57
9	Olimpic	38	41	28	57
10	Sant Andreu	38	47	44	53
11	CD Teruel	38	45	43	52
12	Mallorca B	38	49	47	51
13	Valencia	38	52	54	50
14	Ontinyent	38	39	44	49
15	Dénia	38	39	38	47
16	Deportivo	38	46	60	44
17	Andorra	38	40	55	40
18	CF Gandia	38	34	49	37
19	Manacor	38	39	74	24
20	Mahonès	38	13	75	16

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

PRIMERA FFCV GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Olimpic	34	77	29	73
2	Alberic	34	68	27	69
3	Muro	34	49	33	65
4	Benigànim	34	65	35	62
5	Canals	34	73	40	61
6	UD Oliva	34	50	44	52
7	Jávea	34	47	49	50
8	Benifaio	34	47	67	45
9	Torrent	34	42	53	44
10	Tavernes	34	53	57	42
11	Alginet	34	38	38	41
12	CD Llosa	34	32	44	41
13	Benisa	34	40	50	40
14	Carlet	34	39	49	39
15	Guadasuar	34	32	45	39
16	Carcaixent	34	35	45	37
17	EMFU	34	28	69	21

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

PRIMERA FFCV GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Olimpic	36	86	22	79
2	Canals	36	77	30	76
3	Alberic	36	64	34	70
4	CF Gandia	36	52	24	63
5	Guadasuar	36	55	38	61
6	Quart Poblet	36	58	46	58
7	Carcaixent	36	52	38	54
8	Torrent	36	59	48	54
9	Tavernes	36	55	48	54
10	Paterna CF	36	65	54	53
11	Benigànim	36	43	43	53
12	EMFU	36	54	47	51
13	CD Torrent	36	44	58	49
14	Benifaio	36	48	68	39
15	Alacuas	36	34	56	37
16	Manises	36	24	84	21
17	Picassent	36	22	73	14
18	Xirivella	36	21	91	14

TEMPORADA 1999/2000

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Onda	38	83	42	76
2	CD Burriana	38	57	34	74
3	Benidorm	38	55	31	71
4	Alicante	38	61	32	70
5	Eldense	38	43	43	59
6	At. Levante	38	47	35	55
7	Ilicitano	38	46	44	55
8	Dénia	38	39	29	54
9	Burjassot	38	55	44	53
10	Santa Pola	38	36	45	50
11	Pinoso	38	26	42	49
12	Alcoyano	38	43	38	49
13	Pego	38	44	43	49
14	Foios	38	39	52	47
15	Buñol	38	36	46	47
16	Vall Uxó	38	42	51	45
17	Gimnástico	38	31	40	43
18	Marcelino	38	42	48	41
19	Olimpic	38	31	66	26
20	Pobla Llarga	38	29	80	21

TEMPORADA 1998/1999

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Ilicitano	38	55	28	71
2	Novelda CF	38	52	32	67
3	Alcoyano	38	33	21	65
4	UD Alzira	38	53	33	63
5	Pego	38	37	21	63
6	CD Burriana	38	56	31	59
7	Burjassot	38	40	32	57
8	Pinoso	38	38	33	56
9	Onda	38	49	52	53
10	Eldense	38	54	43	53
11	Foios	38	38	37	51
12	Gimnástico	38	34	36	51
13	Dénia	38	41	42	44
14	Olimpic	38	43	60	41
15	Vall Uxó	38	31	47	40
16	Marcelino	38	39	68	39
17	Santa Pola	38	30	54	39
18	SD Sueca	38	29	43	39
19	CD Utiel	38	34	61	36
20	Torrevieja	38	42	54	35

Competiciones que juega

Lliga Comunitat FFCV Grupo 2

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

	Ascenso : CF Benidorm
	Playoff Ascenso : Crevillente Deportivo, Olimpic Xátiva
	Descenso : Jávea, Santa Pola, Callosa Deportiva CF

RIVALES EN Lliga Comunitat.

USO DE MEMORIA

8,142,272 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1419
Total Execution Time	0.1431

CADENA URL

/historico/Olimpic

GET DATOS

$_GET['/historico/Olimpic']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1854 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1854 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 (2832,6660,7135,7860,10285) ORDER BY n.cover_points DESC, update_date DESC
0.0029	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 = '1854' 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.0026	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=1854 AND l.year in (2023,2024,2025) 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 (73540,68783) 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 = 1854
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 68783 AND teamId = 1854
0.0022	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.0037	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 = 1854 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.0040	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 = 1854 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 1854 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035	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 = 1854 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68783 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.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* `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 = 62390 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.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* `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.0022	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.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* `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.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* `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 = 15377 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 3864 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* `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 = 2468 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* `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 = 1904 AND t.round = 42 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* `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 = 1348 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* `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.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* `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.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* `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 = 328 AND t.round = 34 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* `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.0022	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 = 125 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* `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 = 22019 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* `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 = 22003 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Olimpic Xátiva

Olimpic Xátiva

Selecciona un equipo

Competiciones que juega

Lliga Comunitat FFCV Grupo 2

RIVALES EN Lliga Comunitat.