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

Sporting Atlético

Entrenador: Aitor Zulaika

Temporada 2000/2001

TEMPORADA 2000/2001

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Atlético B	38	63	27	74
2	CD Ourense	38	60	31	73
3	Zamora	38	65	37	71
4	CD Toledo	38	59	34	66
5	Sporting	38	52	45	63
6	Pájara	38	51	45	61
7	RM Castilla	38	74	53	61
8	Vecindario	38	65	65	58
9	Caudal	38	40	38	52
10	Mensajero	38	40	44	49
11	Ponferradina	38	45	50	47
12	Alcorcón	38	46	53	44
13	Universidad	38	46	60	44
14	Pontevedra	38	41	65	44
15	CD Lugo	38	36	47	43
16	Fuenlabrada	38	40	47	42
17	Club Siero	38	42	55	42
18	UD Sanse	38	42	59	38
19	Real Ávila	38	46	66	38
20	Deportivo	38	36	68	34

TEMPORADA 1999/2000

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Universidad	38	40	17	72
2	CD Ourense	38	48	29	69
3	Racing	38	67	24	68
4	Mensajero	38	53	35	66
5	RM Castilla	38	72	51	61
6	UD Sanse	38	51	42	58
7	Pontevedra	38	46	49	54
8	CD Lugo	38	42	46	52
9	Cultural	38	52	50	51
10	Pájara	38	52	51	51
11	Real Ávila	38	47	54	51
12	Sporting	38	48	51	51
13	Fuenlabrada	38	42	47	50
14	Caudal	38	37	56	45
15	Ponferradina	38	34	55	44
16	Real Avilés	38	38	43	43
17	Lanzarote	38	47	54	42
18	Real Oviedo	38	37	50	39
19	Gimnástica	38	20	47	35
20	Móstoles	38	34	56	32

TEMPORADA 1998/1999

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Getafe	38	50	23	72
2	Universidad	38	49	35	65
3	RM Castilla	38	68	39	64
4	Racing	38	61	39	64
5	Talavera CF	38	46	35	62
6	Mensajero	38	48	40	56
7	Sporting	38	46	48	56
8	Fuenlabrada	38	40	46	55
9	Real Avilés	38	48	40	51
10	Móstoles	38	40	43	51
11	CD Lugo	38	48	48	50
12	Pontevedra	38	53	47	48
13	Real Oviedo	38	42	51	47
14	UD Sanse	38	42	53	47
15	Pájara	38	42	52	46
16	Caudal	38	33	46	43
17	Deportivo	38	42	47	41
18	Langreo	38	34	60	40
19	Lalín	38	35	52	37
20	Lealtad	38	32	55	36

TEMPORADA 1997/1998

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cacereño	38	72	36	78
2	RM Castilla	38	70	40	72
3	Deportivo	38	51	27	72
4	Talavera CF	38	65	46	71
5	Racing	38	59	38	71
6	CD Lugo	38	55	46	65
7	Getafe	38	45	40	57
8	Sporting	38	48	44	57
9	Fuenlabrada	38	54	55	54
10	Pontevedra	38	43	40	53
11	Langreo	38	49	49	50
12	Real Oviedo	38	51	53	48
13	Plasencia	38	48	54	46
14	Moralo	38	38	55	43
15	Caudal	38	43	57	42
16	Real Avilés	38	37	47	40
17	As Pontes	38	38	56	39
18	Rayo	38	43	59	35
19	Carabanchel	38	29	62	28
20	Leganés B	38	35	69	26

TEMPORADA 1996/1997

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sporting	38	57	40	68
2	Talavera CF	38	54	35	67
3	CD Manchego	38	52	36	66
4	Deportivo	38	60	43	66
5	CD Lugo	38	71	34	64
6	Fuenlabrada	38	47	32	64
7	Racing	38	48	41	56
8	Carabanchel	38	40	43	56
9	Pontevedra	38	49	48	54
10	Real Avilés	38	57	58	50
11	Mallorca B	38	52	59	48
12	Real Oviedo	38	51	45	48
13	Real Madrid	38	48	60	48
14	Langreo	38	43	57	48
15	As Pontes	38	39	52	46
16	Getafe	38	44	54	45
17	Real	38	42	55	45
18	Colonia	38	48	64	45
19	Celta	38	36	51	37
20	Marino	38	19	50	23

TEMPORADA 1995/1996

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sporting	38	52	36	70
2	Osasuna	38	41	22	66
3	Real Avilés	38	45	38	66
4	Cultural	38	68	35	65
5	Real Unión	38	49	34	63
6	Real	38	43	38	57
7	Barakaldo	38	46	34	56
8	Numancia	38	43	36	56
9	Aurrera	38	39	43	53
10	Langreo	38	38	42	51
11	Club Bermeo	38	41	40	51
12	Izarra	38	29	36	48
13	Real	38	37	41	47
14	Lemona	38	35	39	46
15	Beasain KE	38	35	46	42
16	Logroñés	38	40	53	39
17	Tudelano	38	35	51	38
18	SCD Durango	38	40	61	35
19	Palencia	38	32	45	35
20	Amurrio	38	48	66	34

TEMPORADA 1994/1995

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	71	27	54
2	Mensajero	38	69	42	52
3	Las Palmas	38	81	38	51
4	Pontevedra	38	51	30	48
5	Sporting	38	50	43	45
6	UD Sanse	38	45	39	43
7	Colonia	38	40	35	41
8	Langreo	38	40	43	40
9	Atlético B	38	50	45	40
10	Real Avilés	38	54	42	39
11	CD Lugo	38	49	57	36
12	Móstoles	38	33	51	35
13	Real Madrid	38	60	57	34
14	Real	38	42	52	33
15	Real	38	54	57	31
16	Fuenlabrada	38	52	64	31
17	Real Oviedo	38	50	63	31
18	Real Ávila	38	39	66	30
19	Corralejo	38	28	64	26
20	Realejos	38	32	75	20

TEMPORADA 1993/1994

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Salamanca	38	71	26	56
2	Getafe	38	53	31	50
3	CD Ourense	38	64	53	48
4	Langreo	38	60	60	43
5	Pontevedra	38	51	41	41
6	Atlético B	38	54	44	40
7	Real Madrid	38	63	55	40
8	CD Lugo	38	38	42	38
9	Real Ávila	38	33	42	37
10	UD Sanse	38	49	48	37
11	Real Oviedo	38	39	38	37
12	Sporting	38	45	42	37
13	Racing	38	54	58	36
14	Talavera CF	38	41	44	35
15	Real Avilés	38	43	55	34
16	Arosa	38	42	48	33
17	Cultural	38	38	53	32
18	Tomelloso	38	29	42	32
19	Ponferradina	38	39	56	28
20	Celta	38	45	73	26

TEMPORADA 1992/1993

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Leganés	38	59	31	52
2	Salamanca	38	64	40	52
3	CD Toledo	38	62	26	51
4	Getafe	38	42	28	47
5	CD Ourense	38	39	28	45
6	Real Avilés	38	43	37	42
7	Atlético B	38	53	44	40
8	Ponferradina	38	48	44	40
9	Real Oviedo	38	41	43	37
10	Cultural	38	32	39	36
11	Real Ávila	38	37	37	36
12	Racing	38	56	47	36
13	Pontevedra	38	36	45	34
14	Sporting	38	40	52	34
15	Celta	38	37	47	33
16	Tomelloso	38	39	48	32
17	As Pontes	38	33	49	32
18	Valdepeñas	38	31	56	30
19	Real	38	35	51	28
20	RSD Alcalá	38	34	69	23

TEMPORADA 1991/1992

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Salamanca	38	65	22	53
2	CD Lugo	38	40	24	48
3	Sporting	38	38	22	47
4	As Pontes	38	42	30	45
5	CD Ourense	38	42	27	44
6	Cultural	38	38	26	44
7	Gimnástica	38	31	28	42
8	Real	38	44	38	40
9	Pontevedra	38	40	41	39
10	Numancia	38	39	34	37
11	Real Oviedo	38	37	40	37
12	Palencia	38	39	45	35
13	Real Ávila	38	30	36	35
14	Ponferradina	38	45	58	34
15	Tudelano	38	36	43	34
16	Logroñés	38	35	47	34
17	Lalín	38	38	44	34
18	Deportivo	38	45	56	31
19	Cambados	38	23	47	26
20	Mosconia	38	29	68	21

TEMPORADA 1990/1991

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RM Castilla	38	44	25	53
2	CD Lugo	38	38	23	47
3	Compostela	38	44	31	47
4	Getafe	38	45	24	45
5	Leganés	38	38	27	43
6	Palencia	38	34	28	43
7	CD Ourense	38	40	36	41
8	Atlético B	38	51	44	41
9	Cultural	38	40	38	40
10	Real Oviedo	38	42	44	39
11	Real Ávila	38	32	26	39
12	Sporting	38	49	48	38
13	As Pontes	38	42	36	38
14	Pontevedra	38	28	33	35
15	Ponferradina	38	32	38	35
16	Cambados	38	32	42	32
17	Galáctico	38	29	47	30
18	Langreo	38	31	51	29
19	Móstoles	38	26	41	28
20	RSD Alcalá	38	22	57	17

TEMPORADA 1989/1990

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real Avilés	38	46	24	55
2	Getafe	38	54	30	51
3	Leganés	38	53	25	48
4	Cambados	38	41	28	45
5	CD Lugo	38	48	40	43
6	Ponferradina	38	56	35	43
7	Cultural	38	33	28	42
8	Real Ávila	38	52	46	41
9	CD Toledo	38	52	53	37
10	Pontevedra	38	38	45	36
11	Sporting	38	42	45	35
12	Langreo	38	39	52	34
13	CD Ourense	38	25	32	34
14	As Pontes	38	39	53	34
15	RSD Alcalá	38	31	33	34
16	Galáctico	38	29	38	33
17	Racing	38	35	47	32
18	Colonia	38	27	41	32
19	Lalín	38	34	45	31
20	Arosa	38	31	65	20

TEMPORADA 1988/1989

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sporting	38	89	22	62
2	CD Turón	38	51	39	50
3	Caudal	38	52	30	50
4	CD Praviano	38	37	27	44
5	Mosconia	38	49	37	43
6	Real	38	51	40	43
7	Club Hispano	38	61	42	42
8	Asturias	38	30	24	42
9	Ribadesella	38	45	33	40
10	Marino	38	42	40	40
11	Deportiva	38	36	48	39
12	Lugones	38	45	49	37
13	Pumarín CF	38	44	54	36
14	Luarca CF	38	40	51	36
15	Lenense	38	40	50	32
16	Europa Nava	38	40	55	31
17	Club Siero	38	30	45	30
18	San Martín	38	29	49	29
19	Atlético	38	44	60	24
20	L´Entregu	38	24	84	10

TEMPORADA 1987/1988

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	87	27	63
2	Sporting	38	94	30	59
3	Marino	38	54	34	50
4	Europa Nava	38	67	47	49
5	Asturias	38	47	36	46
6	Lenense	38	44	35	41
7	Lugones	38	52	49	40
8	Atlético	38	57	46	40
9	L´Entregu	38	39	50	39
10	CD Turón	38	50	50	37
11	Deportiva	38	44	49	36
12	Club Siero	38	48	52	35
13	Pumarín CF	38	55	69	34
14	Club Hispano	38	49	49	34
15	San Martín	38	39	44	33
16	Mosconia	38	45	58	32
17	Luarca CF	38	32	47	32
18	CD Tuilla	38	41	67	24
19	Canicas AC	38	33	73	23
20	UC Ceares	38	30	95	13

TEMPORADA 1986/1987

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	55	20	58
2	Real Avilés	38	72	25	53
3	Langreo	38	82	36	53
4	Sporting	38	60	43	49
5	Club Siero	38	55	27	48
6	Club Hispano	38	47	35	45
7	Real Oviedo	38	57	38	44
8	Lenense	38	53	47	40
9	L´Entregu	38	45	47	38
10	Pumarín CF	38	53	61	36
11	Europa Nava	38	51	63	35
12	Lugones	38	33	46	33
13	Mosconia	38	40	61	32
14	Marino	38	40	54	31
15	Deportiva	38	28	46	31
16	CD Turón	38	25	38	30
17	Asturias	38	25	41	30
18	San Martín	38	41	59	28
19	UC Ceares	38	27	54	28
20	Atlético	38	37	85	18

TEMPORADA 1985/1986

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UE Figueres	38	71	31	55
2	Burgos	38	47	32	48
3	Salamanca	38	55	32	48
4	Lleida	38	49	25	46
5	Deportivo	38	46	31	46
6	CD Ourense	38	49	32	46
7	Palencia	38	43	34	43
8	Real	38	57	53	42
9	Pontevedra	38	48	41	39
10	L´Hospitale	38	55	52	39
11	Zamora	38	47	38	39
12	CD Binéfar	38	47	51	37
13	Andorra	38	59	58	37
14	Gimnàstic	38	43	42	36
15	FC Andorra	38	43	57	31
16	Sporting	38	39	61	29
17	Arosa	38	37	67	29
18	Compostela	38	46	72	26
19	Barcelona C	38	35	61	23
20	Lalín	38	26	72	21

TEMPORADA 1984/1985

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sestao Sport	38	59	28	55
2	Deportivo	38	56	31	54
3	Deportivo	38	70	38	50
4	Andorra	38	51	38	46
5	UE Figueres	38	65	50	43
6	Lleida	38	51	45	42
7	Pontevedra	38	56	41	41
8	CD Binéfar	38	49	40	40
9	FC Andorra	38	51	57	38
10	Sporting	38	43	48	36
11	Zamora	38	41	54	36
12	Palencia	38	47	46	36
13	Gimnàstic	38	41	44	35
14	Arosa	38	44	52	35
15	Compostela	38	41	55	34
16	Barcelona C	38	54	62	33
17	Real	38	41	47	33
18	Osasuna	38	42	55	30
19	Real Avilés	38	47	62	27
20	SD Erandio	38	38	94	16

TEMPORADA 1983/1984

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CE Sabadell	38	73	31	51
2	Logroñés	38	68	26	51
3	Deportivo	38	65	35	50
4	UE Figueres	38	56	47	48
5	Gimnàstic	38	57	38	47
6	Sestao Sport	38	57	36	46
7	CD Binéfar	38	50	40	42
8	Lleida	38	53	39	42
9	Real	38	43	38	41
10	FC Andorra	38	52	44	41
11	Osasuna	38	39	44	38
12	Andorra	38	47	50	37
13	Sporting	38	50	47	37
14	Compostela	38	41	55	33
15	Arosa	38	39	64	30
16	Real Avilés	38	50	68	29
17	SD Erandio	38	42	65	29
18	Barakaldo	38	46	75	28
19	Huesca	38	33	68	24
20	Racing	38	25	76	16

TEMPORADA 1982/1983

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bilbao Ath.	38	91	35	59
2	Tenerife	38	75	36	52
3	Burgos	38	61	31	47
4	Sestao Sport	38	56	38	46
5	Gimnàstic	38	39	30	42
6	Real	38	37	35	41
7	Logroñés	38	44	35	40
8	FC Andorra	38	43	47	39
9	Racing	38	45	48	39
10	Lleida	38	46	47	39
11	Compostela	38	30	39	39
12	Huesca	38	42	45	37
13	Osasuna	38	35	42	34
14	Barakaldo	38	37	53	34
15	Andorra	38	49	66	33
16	Sporting	38	47	53	32
17	SD Erandio	38	28	42	31
18	CD Binéfar	38	40	57	31
19	Cultural	38	34	52	28
20	Reus	38	28	76	17

TEMPORADA 1981/1982

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Barça	38	75	33	55
2	Palencia	38	50	24	52
3	Zamora	38	47	24	48
4	Sestao Sport	38	44	33	44
5	Logroñés	38	51	51	43
6	Barakaldo	38	44	42	41
7	SD Erandio	38	36	31	41
8	RSD Alcalá	38	55	42	40
9	Andorra	38	49	40	39
10	Bilbao Ath.	38	41	43	39
11	Real	38	45	45	36
12	Sporting	38	43	44	36
13	Tenerife	38	42	39	35
14	Lleida	38	41	53	35
15	Compostela	38	31	42	34
16	Huesca	38	41	58	34
17	Racing	38	36	43	33
18	Mirandés	38	39	60	29
19	Cultural	38	42	57	29
20	Ensidesa	38	27	75	17

Competiciones que juega

Segunda División B Grupo 1

Pos	Equipos		Pts
1		Atlético B	74
2		CD Ourense	73
3		Zamora	71
4		CD Toledo	66
5		Sporting Atlético	63
6		Pájara Playas Jandía	61
7		RM Castilla	61
8		Vecindario	58
9		Caudal Deportivo	52
10		CD Mensajero	49
11		Ponferradina	47
12		Alcorcón	44
13		Universidad Oviedo	44
14		Pontevedra	44
15		CD Lugo	43
16		Fuenlabrada	42
17		Club Siero	42
18		UD Sanse	38
19		Real Ávila	38
20		Deportivo Fabril	34

RIVALES EN Segunda División.

USO DE MEMORIA

8,512,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1428
Total Execution Time	0.1440

CADENA URL

/historico/Real-Sporting-B/2001

GET DATOS

$_GET['/historico/Real-Sporting-B/2001']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

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 = 5499
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2124 AND type_rel = 2
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2124 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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 (2598,2826,9629,14493,22127) ORDER BY n.cover_points DESC, update_date DESC
0.0035	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 = '2124' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 5499 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037	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=2124 AND l.year in (2000,2001,2002) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (5500) 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 = 5500 AND teamId = 2124
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 FROM* `tables2001` 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 = 5499 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2001 e ON e.player_id = p.id AND e.league_id = 5499 WHERE rp.league_id = 5499 AND rp.teamId = 2124 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.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 events2001 e ON e.player_id = p.id AND e.league_id = 5499 WHERE rp.league_id = 5499 AND rp.teamId = 2124 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 events2001 e ON e.player_id = p.id AND e.league_id = 5499 WHERE rp.league_id = 5499 AND rp.teamId = 2124 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 2124 AND l.year <= 2001 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables2001` 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 = 5499 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* `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 = 5498 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* `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 = 5497 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* `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 = 5496 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* `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 = 22262 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* `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 = 21019 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* `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 = 21018 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* `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 = 21054 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* `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 = 21053 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* `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 = 21047 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* `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 = 21058 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* `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 = 21796 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* `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 = 21777 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* `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 = 21758 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* `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 = 21052 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* `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 = 21051 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* `tables1984` 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 = 21050 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* `tables1983` 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 = 21064 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* `tables1982` 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 = 21063 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Sporting Atlético

Sporting Atlético

Selecciona un equipo

Competiciones que juega

Segunda División B Grupo 1

RIVALES EN Segunda División.