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

Resultados de Fútbol

« Temporada Anterior

Temporada 1968

Temporada Siguiente »

1967/1968

G11

Tercera División 1968 G 10

Tercera División:

Ver

TEMPORADA 1967/1968

Equipo		PJ	GF	GC	Puntos
1	RB Linense	30	56	20	46
2	C.D.	30	57	24	44
3	Algeciras	30	62	26	43
4	UD Melilla	30	51	30	37
5	Linares CF	30	57	26	36
6	Atlético	30	50	35	35
7	Estepona	30	42	49	34
8	Malagueño	30	36	28	33
9	Iliturgi CF	30	50	37	32
10	Adra	30	32	38	31
11	Fuengirola	30	45	43	29
12	Recreativo	30	40	44	27
13	Torremolinos	30	29	54	20
14	C.D.Hispania	30	27	64	12
15	Olimpica	30	19	88	11
16	Vandalia	30	22	69	10

Ver

TEMPORADA 1966/1967

Equipo		PJ	GF	GC	Puntos
1	Real Jaén	30	67	27	45
2	C.D.	30	55	28	42
3	RB Linense	30	57	25	42
4	UD Melilla	30	53	33	33
5	Atlético	30	40	35	33
6	Malagueño	30	48	38	33
7	Estepona	30	47	51	32
8	Linares CF	30	43	44	28
9	Iliturgi CF	30	35	43	28
10	Algeciras	30	28	37	28
11	Olimpica	30	37	51	25
12	Fuengirola	30	39	55	24
13	Recreativo	30	31	49	24
14	Adra	30	29	48	24
15	Imperio	30	31	57	21
16	Torremolinos	30	40	59	18

Ver

TEMPORADA 1965/1966

Equipo		PJ	GF	GC	Puntos
1	Eldense	30	76	17	50
2	Cartagena	30	64	23	48
3	Albacete	30	47	33	42
4	Alicante	30	65	48	35
5	Águilas CF	30	49	37	34
6	Real Murcia	30	67	47	33
7	Rayo Ibense	30	60	48	32
8	Jumilla	30	48	56	27
9	Atlético	30	49	61	27
10	Orihuela	30	40	43	26
11	Novelda CF	30	46	50	25
12	Ilicitano	30	45	60	22
13	La Roda CF	30	30	66	22
14	Cieza	29	25	56	22
15	CD Abarán	29	33	54	19
16	CD Lorca	30	31	76	14

Ver

TEMPORADA 1964/1965

Equipo		PJ	GF	GC	Puntos
1	Albacete	30	68	25	47
2	Cartagena	30	65	21	42
3	Real Murcia	30	58	30	41
4	Eldense	30	62	31	38
5	Alicante	30	49	35	33
6	Jumilla	30	38	45	31
7	Rayo Ibense	30	47	53	30
8	Ilicitano	30	49	52	30
9	La Roda CF	30	42	59	27
10	Atlético	30	43	52	24
11	Cieza	30	40	55	24
12	CD Lorca	30	37	70	24
13	Orihuela	30	40	56	23
14	AP Almansa	30	41	48	23
15	Aspense	30	36	57	23
16	Monovar	30	40	66	20

Ver

TEMPORADA 1963/1964

Equipo		PJ	GF	GC	Puntos
1	Albacete	30	68	21	52
2	Cartagena	30	72	17	48
3	Real Murcia	30	56	40	32
4	Jumilla	30	47	37	32
5	Atlético	30	56	46	30
6	Cieza	30	55	34	30
7	Rayo Ibense	30	43	54	29
8	Alicante	30	28	31	29
9	La Roda CF	30	51	59	28
10	Orihuela	30	36	52	28
11	AP Almansa	30	47	55	27
12	Ilicitano	30	53	58	26
13	CD Lorca	30	35	50	25
14	Monovar	30	46	70	25
15	Águilas CF	30	38	68	21
16	Madrigueras	30	26	65	18

Ver

TEMPORADA 1962/1963

Equipo		PJ	GF	GC	Puntos
1	CD Abarán	30	75	30	44
2	Orihuela	30	59	30	42
3	Jumilla	30	69	33	39
4	AP Almansa	30	50	46	35
5	Albacete	30	59	32	35
6	Cieza	30	52	55	33
7	Real Murcia	30	55	44	29
8	CD Lorca	30	46	58	29
9	Alicante	30	47	43	27
10	Rayo Ibense	30	51	57	27
11	La Roda CF	30	44	57	25
12	Madrigueras	30	42	65	25
13	Monovar	30	47	74	25
14	Águilas CF	30	59	64	23
15	Crevillente	30	50	59	23
16	Almoradí	30	30	88	19

Ver

TEMPORADA 1961/1962

Equipo		PJ	GF	GC	Puntos
1	Constància	10	18	7	17
2	CD Menorca	10	19	16	12
3	Soledad	10	14	15	10
4	Manacor	10	16	11	10
5	SD Ibiza	10	16	17	8
6	Atlètic	10	11	28	3

Ver

TEMPORADA 1960/1961

Equipo		PJ	GF	GC	Puntos
1	Albacete	30	101	27	50
2	Cartagena	30	97	30	47
3	Real Murcia	30	75	39	44
4	Eldense	30	83	52	37
5	Alicante	30	58	35	35
6	Orihuela	30	64	53	34
7	CD Lorca	30	49	48	30
8	CD Abarán	30	55	59	28
9	Cieza	30	56	63	27
10	Madrigueras	30	45	65	27
11	Novelda CF	30	49	75	25
12	Rayo Ibense	30	51	80	24
13	Almoradí	29	45	70	23
14	Crevillente	30	48	84	22
15	Águilas CF	30	55	76	18
16	Callosa	29	19	94	5

Ver

TEMPORADA 1959/1960

Equipo		PJ	GF	GC	Puntos
1	Hércules	30	84	19	52
2	Crevillente	30	58	38	40
3	Albacete	30	57	30	39
4	Real Murcia	30	64	40	39
5	Eldense	30	58	49	31
6	Cartagena	30	64	46	31
7	CD Lorca	30	41	44	29
8	Novelda CF	30	43	58	29
9	Orihuela	30	47	52	28
10	Alicante	30	51	44	28
11	Cieza	30	50	58	27
12	Callosa	30	54	78	26
13	Rayo Ibense	30	49	65	26
14	Águilas CF	30	48	76	22
15	Almoradí	30	41	68	18
16	Villajoyosa	30	38	82	15

Ver

TEMPORADA 1958/1959

Equipo		PJ	GF	GC	Puntos
1	Albacete	30	66	23	46
2	Alicante	30	81	30	44
3	Cartagena	30	84	37	44
4	Orihuela	30	76	48	36
5	CD Lorca	30	58	53	32
6	Almoradí	30	70	56	29
7	Novelda CF	30	47	50	29
8	Villajoyosa	30	53	63	28
9	Callosa	30	54	80	27
10	Águilas CF	30	42	53	26
11	Real Murcia	30	55	71	26
12	Thader	30	62	75	26
13	Crevillente	30	52	66	25
14	Cieza	30	48	70	25
15	Hellin	30	46	68	24
16	Élitei	30	35	86	13

Ver

TEMPORADA 1957/1958

Equipo		PJ	GF	GC	Puntos
1	Elche	32	129	34	57
2	Cartagena	32	100	43	41
3	Albacete	32	83	57	37
4	Real Murcia	32	81	66	37
5	Orihuela	32	68	54	36
6	Thader	32	83	71	35
7	Lorca FC	32	66	70	33
8	Villajoyosa	32	85	74	32
9	Águilas CF	32	64	73	31
10	Novelda CF	32	68	61	30
11	Almoradí	32	57	75	30
12	Callosa	32	54	62	28
13	Cieza	32	54	71	28
14	Hellin	32	59	73	27
15	Élitei	32	47	106	22
16	Deportiva	32	42	70	22
17	AP Almansa	32	51	131	18
18	CD Yeclano	0	0	0	0

Ver

TEMPORADA 1956/1957

Equipo		PJ	GF	GC	Puntos
1	Elche	34	99	36	50
2	Élitei	34	81	46	47
3	Cartagena	34	108	60	45
4	Real Murcia	34	89	45	43
5	Albacete	34	100	50	41
6	Hellin	34	79	54	37
7	Callosa	34	95	76	36
8	AP Almansa	34	80	111	34
9	CD Yeclano	34	71	74	32
10	Orihuela	34	84	85	32
11	Deportiva	34	71	80	32
12	CD Lorca	34	60	65	31
13	Thader	34	72	82	30
14	Cieza	34	49	99	29
15	Águilas CF	34	72	91	28
16	Almoradí	34	54	87	28
17	Novelda CF	34	39	81	22
18	Aspense	34	32	113	15

Ver

TEMPORADA 1955/1956

Equipo		PJ	GF	GC	Puntos
1	Levante	18	43	17	28
2	Alicante	18	48	22	26
3	CF Gandia	18	27	24	19
4	Alcoyano	18	26	21	19
5	CD Acero	18	30	29	18
6	UD Alzira	18	30	37	16
7	CD Burriana	18	23	33	15
8	Ontinyent	18	27	34	13
9	Peña	18	22	45	13
10	Albacete	18	25	39	13

Ver

TEMPORADA 1954/1955

Equipo		PJ	GF	GC	Puntos
1	Alcoyano	18	41	19	26
2	Valencia	18	47	24	23
3	CD Burriana	18	22	20	21
4	CF Gandia	18	39	41	20
5	Alicante	18	42	31	19
6	UD Alzira	18	40	36	18
7	Peña	18	38	47	16
8	Albacete	18	40	42	15
9	Villena	18	31	50	14
10	Catarroja	18	19	49	8

Ver

TEMPORADA 1946/1947

Equipo		PJ	GF	GC	Puntos
1	Recreativo	18	63	18	31
2	Real Jaén	18	55	18	28
3	CD Badajoz	18	43	17	25
4	Coria CF	18	42	19	25
5	Egabrense	18	52	30	22
6	Electromecá	18	24	47	14
7	Mérida CP	18	28	65	10
8	Calavera	17	17	54	8
9	CD Linares	17	18	48	6
10	Lucena	16	21	47	4

Ver

TEMPORADA 1945/1946

Equipo		PJ	GF	GC	Puntos
1	CD Málaga	18	54	18	27
2	Real Jaén	18	40	26	25
3	UD Melilla	18	43	37	23
4	Larache	18	36	36	17
5	RB Linense	18	33	40	16
6	Coria CF	18	33	37	15
7	Recreativo	18	38	42	15
8	Cádiz	18	28	47	15
9	CD Linares	18	28	37	14
10	Algeciras	18	28	41	13

Equipos de esta liga

USO DE MEMORIA

6,748,408 bytes

BENCHMARKS

Loading Time Base Classes	0.0027
Controller Execution Time ( Home / Category )	2.2249
Total Execution Time	2.2276

CADENA URL

/tercera1968/grupo10/historico

GET DATOS

$_GET['/tercera1968/grupo10/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0018	SELECT type FROM routes WHERE alias = 'tercera1968'
0.0829	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 10 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1968 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=10 DESC LIMIT 1
0.0172	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 21608 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.1050	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 4 AND group_code = 10 and tables = 1 AND year <= 1968 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.1808	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* `tables1968` 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 = 21608 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0924	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* `tables1967` 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 = 22205 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1133	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* `tables1966` 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 = 21594 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0753	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* `tables1965` 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 = 21581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2012	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* `tables1964` 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 = 21568 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0506	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* `tables1963` 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 = 21556 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0378	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* `tables1962` 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 = 21541 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0902	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* `tables1961` 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 = 21528 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0758	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* `tables1960` 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 = 21515 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2406	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* `tables1959` 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 = 21502 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1855	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* `tables1958` 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 = 21455 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1541	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* `tables1957` 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 = 21486 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0670	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* `tables1956` 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 = 21468 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0281	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* `tables1955` 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 = 21425 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0535	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* `tables1947` 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 = 21358 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0272	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* `tables1946` 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 = 21355 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0059	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 14:14:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0282	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 14:14:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 14:14:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0235	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 14:14:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0460	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1968 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0041	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1968 e ON e.player_id = p.id AND e.league_id = 21608 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21608 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0429	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1968 e ON e.player_id = p.id AND e.league_id = 21608 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21608 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0333	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1968 e ON e.player_id = p.id AND e.league_id = 21608 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21608 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.1104	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1968` 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 = 21608 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos