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

Recreativo Granada

Entrenador: Germán Crespo

Temporada 1991/1992

TEMPORADA 1991/1992

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Vélez CF	36	70	41	54
2	Mármol	36	69	24	51
3	Iliturgi CF	36	49	20	51
4	Malagueño	36	72	31	51
5	Poli	36	59	28	49
6	Baeza CF	36	48	42	41
7	Martos CD	36	42	39	39
8	Motril CF	36	46	47	38
9	Atarfe	36	66	46	38
10	Recreativo	36	49	48	37
11	Adra	36	45	33	37
12	Pedro	36	48	46	36
13	Maracena	36	46	46	32
14	Úbeda Viva	36	50	52	31
15	Guadix CF	36	42	46	30
16	Torremolinos	36	34	66	22
17	CD Ronda	36	31	76	19
18	Nerja	36	23	91	16
19	CD Mijas	36	18	85	12
20	Casino Real	0	0	0	0

TEMPORADA 1981/1982

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Fuengirola	38	71	37	50
2	Martos CD	38	83	50	49
3	Torremolinos	38	54	44	47
4	Malagueño	38	62	49	46
5	Alhaurino	38	73	54	45
6	Benamiel	38	48	43	43
7	Baza	38	47	47	41
8	UD Melilla	38	57	49	38
9	Atlético	38	46	46	38
10	Bailén	38	45	49	38
11	Pedro	38	56	47	37
12	Estepona	38	51	46	37
13	Vélez CF	38	45	46	37
14	Úbeda CF	38	53	62	34
15	CD Motril	38	34	47	34
16	Carolinense	38	48	64	33
17	Iliturgi CF	38	29	37	32
18	CD Ronda	38	46	65	31
19	Atarfe	38	43	65	30
20	Recreativo	38	26	70	20

TEMPORADA 1980/1981

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Antequerano	38	70	32	55
2	Martos CD	38	67	31	50
3	UD Melilla	38	65	45	48
4	Estepona	38	58	46	45
5	Torremolinos	38	57	48	44
6	Úbeda CF	38	61	39	42
7	Pedro	38	45	35	42
8	Baza	38	39	43	40
9	CD Ronda	38	62	57	39
10	Iliturgi CF	38	48	45	38
11	CD Motril	38	46	49	38
12	Bailén	38	56	50	38
13	Vélez CF	38	50	50	36
14	Carolinense	38	52	57	36
15	Malagueño	38	43	43	35
16	Atlético	38	53	51	35
17	Atarfe	38	47	61	33
18	Recreativo	38	49	67	26
19	Melilla	38	28	81	22
20	Loja	38	33	99	18

TEMPORADA 1970/1971

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Xerez CD	38	50	24	55
2	Recreativo	38	58	32	52
3	Cartagena	38	63	25	49
4	Portuense	38	41	37	44
5	Sevilla At.	38	54	47	44
6	AgD Ceuta	38	55	41	43
7	Real Jaén	38	45	31	42
8	Betis	38	42	41	40
9	Real Murcia	38	47	39	39
10	Jove	38	52	42	38
11	Valdepeñas	38	47	35	38
12	CD Badajoz	38	46	50	37
13	Ilicitano	38	41	56	37
14	Malagueño	38	40	44	36
15	Melilla CF	38	37	39	34
16	RB Linense	38	31	46	33
17	Mérida CP	38	42	54	31
18	Real Murcia	38	29	50	25
19	Recreativo	38	34	65	25
20	Llerenense	38	28	84	18

TEMPORADA 1969/1970

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	CF Gandia	38	71	37	51
2	Hércules	38	58	25	51
3	Cartagena	38	63	38	49
4	Alcoyano	38	68	45	48
5	Real Jaén	38	54	37	47
6	Eldense	38	55	35	47
7	Real Murcia	38	67	28	46
8	Valdepeñas	38	64	40	46
9	Recreativo	38	46	37	45
10	Albacete	38	43	45	39
11	CD Manchego	38	52	43	38
12	Linares CF	38	32	34	38
13	Novelda CF	38	44	42	37
14	Orihuela	38	55	51	36
15	Calvo Sotelo	38	57	65	33
16	Unión	38	44	48	33
17	Benidorm	38	47	63	29
18	Cartagena	38	32	71	23
19	Iliturgi CF	38	19	95	15
20	Adra	38	20	112	9

TEMPORADA 1967/1968

TERCERA DIVISIÓN GRUPO 10
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

TEMPORADA 1966/1967

TERCERA DIVISIÓN GRUPO 10
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

TEMPORADA 1965/1966

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	RB Linense	28	45	21	41
2	Atlético	28	56	32	38
3	C.D.	28	46	26	37
4	Malagueño	28	52	26	36
5	Real Jaén	28	37	26	33
6	Iliturgi CF	28	45	37	30
7	Algeciras	28	39	38	28
8	Recreativo	28	44	49	28
9	Adra	27	34	39	27
10	Fuengirola	28	35	43	23
11	Imperio	28	33	54	22
12	Torremolinos	28	34	46	21
13	Linares CF	28	35	48	21
14	Antequerano	27	20	41	19
15	Atl.	28	29	58	14
16	CD Ronda	0	0	0	0

TEMPORADA 1964/1965

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Real Jaén	30	52	23	44
2	C.D.	30	43	25	40
3	Atlético	30	49	38	36
4	Iliturgi CF	30	45	42	35
5	Malagueño	30	51	28	34
6	Fuengirola	30	47	37	31
7	Recreativo	30	40	41	30
8	Antequera	30	42	48	30
9	Atl.	30	41	43	29
10	Adra	30	41	46	28
11	Torremolinos	30	49	50	26
12	CD Ronda	30	40	59	26
13	Algeciras	30	38	45	25
14	Imperio	30	41	52	25
15	Prieguense	30	31	46	23
16	Puerto	30	27	54	18

TEMPORADA 1963/1964

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Malagueño	30	41	18	39
2	Atl.	30	56	26	37
3	Antequerano	30	43	32	35
4	Real Jaén	30	42	34	35
5	Atlético	30	54	36	34
6	Algeciras	30	39	33	34
7	CD Ronda	30	50	46	31
8	Fuengirola	30	45	47	31
9	Prieguense	30	37	36	30
10	Recreativo	30	45	43	29
11	C.D.	30	38	41	28
12	Adra	30	43	48	25
13	CD Linares	30	34	49	25
14	Iliturgi CF	30	26	40	23
15	Imperio	30	21	58	22
16	Vélez CF	30	22	49	22

TEMPORADA 1962/1963

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	C.D.	28	59	30	39
2	Malagueño	28	40	16	36
3	Antequera	28	53	27	36
4	Adra	28	38	27	35
5	Écija	28	51	32	32
6	Recreativo	28	52	41	30
7	CD Linares	28	51	44	29
8	Fuengirola	28	35	42	29
9	Prieguense	28	37	35	28
10	Atl.	28	50	37	27
11	Iliturgi CF	28	43	65	27
12	CD Ronda	28	39	43	26
13	Vélez CF	28	26	41	26
14	Imperio	28	29	51	17
15	Alhaurino	28	20	92	3
16	Peñarroya	0	0	0	0

TEMPORADA 1961/1962

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Algeciras	30	69	20	49
2	UD Melilla	30	61	15	45
3	RB Linense	30	59	40	39
4	Malagueño	30	60	35	38
5	C.D.	30	60	42	38
6	CD Linares	30	48	44	33
7	Antequera	30	50	46	33
8	Vélez CF	30	46	45	29
9	Adra	30	35	44	27
10	Iliturgi CF	30	47	54	26
11	CD Ronda	30	38	54	23
12	Peñarroya	30	52	80	23
13	Prieguense	30	39	56	22
14	Alhaurino	30	39	75	21
15	Recreativo	30	44	61	19
16	Atl.	30	43	79	15

TEMPORADA 1960/1961

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Sevilla At.	30	74	19	48
2	Melilla CF	30	58	19	43
3	CD Linares	30	57	30	40
4	RB Linense	30	68	49	35
5	Peñarroya	30	57	50	33
6	Algeciras	30	46	43	32
7	CD Ronda	30	41	54	29
8	Vélez CF	30	36	55	29
9	Malagueño	30	50	46	28
10	Adra	30	50	54	28
11	Atl.	30	49	56	26
12	Recreativo	30	51	45	25
13	Antequera	30	31	47	22
14	Baeza CF	30	28	65	21
15	Écija	30	37	59	21
16	Iliturgi CF	30	37	79	20

TEMPORADA 1959/1960

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	CD Málaga	30	80	32	45
2	RB Linense	30	74	39	42
3	Algeciras	30	60	26	42
4	CD Linares	30	74	36	37
5	Iliturgi CF	30	40	39	35
6	Adra	30	60	47	31
7	Malagueño	30	53	47	30
8	Atl.	30	50	50	29
9	Melilla CF	30	54	56	29
10	Peñarroya	30	51	50	28
11	CD Ronda	30	48	52	28
12	Recreativo	30	52	60	26
13	Antequera	30	57	79	22
14	Guadix CF	30	39	73	21
15	Pozoblanco	30	45	96	18
16	Puente Genil	30	28	83	17

TEMPORADA 1958/1959

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Adra	30	69	35	45
2	CD Linares	30	54	27	40
3	Algeciras	30	54	43	37
4	Malagueño	30	75	49	33
5	Atl.	30	77	64	33
6	Antequera	30	64	51	31
7	CD Ronda	30	55	54	31
8	Iliturgi CF	30	58	51	29
9	Guadix CF	30	49	67	29
10	Recreativo	30	47	48	28
11	Imperio	30	55	58	27
12	RB Linense	30	57	73	25
13	Melilla CF	30	51	51	24
14	Puente Genil	30	45	68	24
15	Úbeda Viva	30	31	60	22
16	Lucentina	30	31	73	22

TEMPORADA 1957/1958

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	CA Almeria	38	99	37	58
2	Adra	38	91	41	53
3	Iliturgi CF	38	103	66	52
4	CD Linares	38	89	46	46
5	Puente Genil	38	81	68	45
6	Úbeda Viva	38	70	56	44
7	Malagueño	38	88	49	42
8	Guadix CF	38	76	58	41
9	Castro	38	60	63	40
10	Lucentina	38	61	57	39
11	Antequera	38	68	57	38
12	Atl.	38	68	68	36
13	Recreativo	38	44	52	36
14	Melilla CF	38	73	76	32
15	Martos CD	38	59	69	32
16	CD Ronda	38	54	83	31
17	Pozoblanco	38	50	91	29
18	Atlético	38	48	128	27
19	Villa	38	38	71	25
20	Peñarroya	38	48	132	14

TEMPORADA 1956/1957

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	CD Linares	56	122	72	74
2	Iliturgi CF	56	144	72	70
3	Úbeda Viva	56	102	64	68
4	Recreativo	56	120	76	66
5	Peñarroya	56	136	82	66
6	CA Almeria	56	120	70	64
7	CD Ronda	56	108	96	62
8	Antequera	56	126	84	60
9	Guadix CF	56	114	108	58
10	Lucena	56	88	138	50
11	Pozoblanco	56	76	172	44
12	Martos CD	56	112	160	42
13	Malagueño	56	76	114	40
14	Atl.	56	84	126	38
15	Atlético	56	60	154	38
16	Motril CF	0	0	0	0

TEMPORADA 1955/1956

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Córdoba CF	22	52	19	32
2	CA Almeria	22	58	33	28
3	Úbeda Viva	22	50	31	28
4	Pontanés	22	51	34	26
5	Iliturgi CF	22	48	48	23
6	Motril CF	22	43	44	23
7	Antequera	22	54	47	23
8	Recreativo	22	32	49	21
9	CD Linares	22	44	55	19
10	Martos CD	22	32	47	19
11	Malagueño	22	35	54	14
12	Atlético	22	27	65	8

TEMPORADA 1954/1955

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Úbeda Viva	18	39	28	25
2	Iliturgi CF	18	54	36	23
3	CD Linares	18	56	32	22
4	CA Almeria	18	45	33	21
5	Martos CD	18	38	38	17
6	Motril CF	18	37	44	17
7	Malagueño	18	37	44	16
8	Recreativo	18	33	40	16
9	Antequera	18	36	50	13
10	Atlético	18	24	54	10

TEMPORADA 1953/1954

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Real Betis	36	77	33	52
2	Alvaro	36	85	57	46
3	Fernando	36	114	57	45
4	Cádiz	35	90	52	43
5	SD Ceuta	36	65	43	42
6	Recreativo	36	62	59	38
7	Algeciras	36	72	53	38
8	CA Almeria	34	65	43	36
9	Martos CD	36	75	67	36
10	Recreativo	36	49	61	34
11	Iliturgi CF	36	63	80	32
12	Utrera	36	54	87	32
13	Español	36	66	76	31
14	Larache	36	64	88	31
15	Malagueño	36	58	83	30
16	Córdoba	36	51	50	29
17	Valdepeñas	36	45	88	29
18	Úbeda Viva	36	45	83	27
19	Juventud	35	53	93	27

Competiciones que juega

Tercera División Grupo 10

Pos	Equipos		Pts
1		Vélez CF	54
2		Mármol Macael	51
3		Iliturgi CF	51
4		At. Malagueño	51
5		Poli Almería	49
6		Baeza CF	41
7		Martos CD	39
8		Motril CF	38
9		Atarfe Industrial	38
10		Recreativo Granada	37
11		Adra	37
12		UD San Pedro	36
13		Maracena	32
14		CD Úbeda Viva	31
15		Guadix CF	30
16		J. Torremolinos	22
17		CD Ronda	19
18		CD Nerja Fundación	16
19		CD Mijas	12
20		Casino del Real Melilla	0

RIVALES EN Tercera División

USO DE MEMORIA

7,664,960 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1543
Total Execution Time	0.1558

CADENA URL

/historico/Granada-B/1992

GET DATOS

$_GET['/historico/Granada-B/1992']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0031	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Granada-B' AND l.year = 1992 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1252 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=1252 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 21867
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1252 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1252 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020	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 (1872,1903,2601,2835,6752) ORDER BY n.cover_points DESC, update_date DESC
0.0028	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 = '1252' ORDER BY l.year DESC,cat.coefficient 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 = '1252' AND l.year = 1992 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '1252' 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 = 21867 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=1252 AND l.year in (1991,1992,1993) 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 (21888) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 21888 AND teamId = 1252
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* `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 = 21867 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1252' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1252' and rp.type = 4
0.0019	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1252' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	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 events1992 e ON e.player_id = p.id AND e.league_id = 21867 WHERE rp.league_id = 21867 AND rp.teamId = 1252 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.0019	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 events1992 e ON e.player_id = p.id AND e.league_id = 21867 WHERE rp.league_id = 21867 AND rp.teamId = 1252 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 events1992 e ON e.player_id = p.id AND e.league_id = 21867 WHERE rp.league_id = 21867 AND rp.teamId = 1252 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 1252 AND l.year <= 1992 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 21867 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* `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 = 21692 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* `tables1981` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21677 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* `tables1971` 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 = 21629 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* `tables1970` 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 = 21624 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* `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.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* `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.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* `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 = 21595 AND t.round = 30 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* `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 = 21582 AND t.round = 30 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* `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 = 21569 AND t.round = 30 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* `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 = 21557 AND t.round = 30 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* `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 = 21544 AND t.round = 30 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* `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 = 21529 AND t.round = 30 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* `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 = 21516 AND t.round = 30 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* `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 = 21503 AND t.round = 30 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* `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 = 21487 AND t.round = 30 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* `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 = 21471 AND t.round = 22 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* `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 = 21428 AND t.round = 18 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* `tables1954` 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 = 21415 AND t.round = 40 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

Resultados de Fútbol

Recreativo Granada

Recreativo Granada

Selecciona un equipo

Competiciones que juega

Tercera División Grupo 10

RIVALES EN Tercera División