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

CD Rota

Temporada 2005/2006

TEMPORADA 2005/2006

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Chiclana	30	52	25	58
2	Conil	30	56	30	55
3	Balón	30	47	38	54
4	CD Rota	30	54	30	52
5	Chipiona CF	30	34	21	51
6	Rayo	30	50	40	44
7	Florida Dst.	30	49	44	44
8	Guadalcacín	30	39	33	43
9	Chiclana B	30	40	43	37
10	Grupo	30	35	44	37
11	Vejer Bpie	30	36	49	37
12	Tarifa UD	30	29	43	36
13	Ud Bornense	30	35	59	34
14	S.Isidro	30	35	53	30
15	Palmones	30	33	57	27
16	Villamartín	30	36	51	23

TEMPORADA 2003/2004

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Puerto Real	30	54	24	60
2	Cádiz	30	85	34	58
3	Arcos CF	30	51	27	57
4	Roteña	30	42	37	49
5	Cortijillos	30	42	28	48
6	Tarifa UD	30	43	30	48
7	Algeciras	30	35	28	47
8	Barbate	30	41	38	45
9	Xerez B	30	36	38	39
10	Atletico	30	39	60	38
11	Chiclana	30	49	52	36
12	Chipiona CF	30	36	42	35
13	Guadalcacín	30	39	48	35
14	CD Rota	30	34	44	34
15	Palmones	30	36	58	33
16	Ubrique Ind.	30	26	41	32
17	Villamartín	30	31	56	27
18	Rayo	30	24	58	22

TEMPORADA 2002/2003

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Chiclana	30	57	24	63
2	Portuense	30	54	26	62
3	Cádiz	30	68	33	61
4	Cortijillos	30	46	29	58
5	Xerez B	30	55	27	56
6	Chiclana CF	30	47	38	50
7	CD Rota	30	71	38	49
8	Chipiona CF	30	44	45	44
9	Atletico	30	44	38	41
10	Villamartín	30	31	37	38
11	Nueva	30	30	41	38
12	Roteña	30	49	47	37
13	Ubrique Ind.	30	35	49	35
14	Rayo	30	44	55	34
15	Barbate	30	33	50	34
16	Grupo	30	41	56	33
17	Carolinense	30	27	56	29
18	Fernando	30	42	54	28
19	Guadiaro	30	43	71	23
20	Bernardo	30	34	81	16

TEMPORADA 1999/2000

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Algeciras	38	64	32	73
2	Fernando	38	58	31	68
3	Puerto Real	38	62	40	66
4	Portuense	38	44	41	65
5	Palacios	38	54	43	64
6	Sanluqueño	38	61	47	63
7	Pozoblanco	38	62	43	61
8	Lucena	38	45	37	55
9	Atlético	38	45	38	55
10	UD Tomares	38	55	52	55
11	Villanueva	38	43	49	51
12	Córdoba	38	53	54	48
13	AD Cartaya	38	49	54	47
14	La Palma	37	37	45	43
15	Ayamonte	38	35	53	41
16	Los Barrios	38	36	49	40
17	Chiclana CF	38	42	58	39
18	Montilla	38	38	59	38
19	Ceuta	38	43	67	28
20	CD Rota	37	32	66	26

TEMPORADA 1998/1999

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	RB Linense	38	56	19	81
2	Hermanas	38	67	28	80
3	Coria CF	38	61	18	73
4	Fernando	38	64	35	71
5	Lucena	38	52	21	64
6	Portuense	38	41	34	57
7	Chiclana CF	38	44	36	56
8	Sanluqueño	38	45	42	54
9	Montilla	38	35	35	53
10	UD Tomares	38	43	44	50
11	Palacios	38	52	46	47
12	Pozoblanco	38	37	44	46
13	CD Rota	38	42	55	46
14	Puerto Real	38	40	45	46
15	Ayamonte	38	36	51	43
16	Los Barrios	38	38	55	42
17	La Palma	38	40	50	38
18	Utrera	38	36	62	37
19	Roque Lepe	38	34	68	29
20	Serrallo CF	38	18	93	16

TEMPORADA 1997/1998

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	AgD Ceuta	38	81	27	82
2	Fernando	38	91	31	78
3	Roque Lepe	38	50	30	64
4	Algeciras	38	54	46	64
5	Lucena	38	34	21	63
6	Coria CF	38	57	36	63
7	Chiclana CF	38	54	43	58
8	Utrera	38	48	48	53
9	La Palma	38	45	60	52
10	CD Rota	38	53	65	50
11	RB Linense	38	39	60	46
12	Ayamonte	38	46	48	46
13	Puerto Real	38	49	61	45
14	Montilla	38	35	47	45
15	Sanluqueño	38	49	49	44
16	Pozoblanco	38	43	48	44
17	Palacios	38	40	53	42
18	Cádiz	38	35	47	40
19	Rambla	38	38	74	34
20	Rayo	38	36	83	24

TEMPORADA 1996/1997

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	UA. Ceutí	42	69	41	79
2	Isla	42	76	40	76
3	Algeciras	42	61	39	72
4	Ayamonte	42	64	38	71
5	Montilla	42	62	51	70
6	Palacios	42	60	44	66
7	Fernando	42	67	57	66
8	Sanluqueño	42	59	53	64
9	Pozoblanco	42	55	49	61
10	CD Rota	42	57	58	59
11	Roque Lepe	42	57	56	57
12	RB Linense	42	57	52	55
13	Cádiz	42	51	55	54
14	La Palma	42	51	54	54
15	Utrera	42	71	49	54
16	Lucena	42	53	69	50
17	Chiclana CF	42	45	59	50
18	Hermanas	42	53	60	50
19	Mairena	42	36	62	37
20	Conil	42	30	77	33
21	Roteña	42	23	90	23

TEMPORADA 1995/1996

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Fernando	38	73	34	70
2	Sanluqueño	38	60	27	67
3	Isla	38	61	39	65
4	Chiclana CF	38	53	34	64
5	Roque Lepe	38	54	43	63
6	Montilla	38	49	31	62
7	La Palma	38	65	47	59
8	Pozoblanco	38	52	41	58
9	Coria CF	38	47	39	58
10	RB Linense	38	48	36	55
11	CD Rota	38	48	44	55
12	Palacios	38	43	53	50
13	Hermanas	38	62	68	48
14	Algeciras	38	43	41	46
15	Mairena	38	41	56	44
16	Cádiz	38	55	61	43
17	Conil	38	36	67	39
18	Jerez	38	37	60	38
19	San Juan	38	29	54	37
20	O Donnell	38	25	106	12

TEMPORADA 1992/1993

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Cortegana	38	56	23	52
2	Mairena	38	48	29	50
3	Fernando	38	57	30	49
4	San Juan	38	42	34	45
5	Sanluqueño	38	43	29	44
6	Palacios	38	46	29	44
7	Coria CF	38	61	50	42
8	Cádiz	38	56	45	40
9	Lucena	38	45	42	38
10	Pozoblanco	38	49	39	37
11	Puente Genil	38	30	34	37
12	Roteña	38	35	41	36
13	Jerez	38	41	43	36
14	Montilla	38	40	49	35
15	Lebrija	38	50	48	35
16	La Palma	38	35	48	33
17	Algeciras	38	53	65	32
18	Arcos CF	38	30	58	29
19	CD Rota	38	28	60	28
20	Chiclana CF	38	27	76	18

TEMPORADA 1989/1990

TERCERA DIVISIÓN GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Betis	38	64	26	56
2	Portuense	38	65	32	53
3	Roque Lepe	38	49	35	48
4	Algeciras	38	51	31	45
5	Pozoblanco	38	53	33	45
6	Fernando	38	58	39	44
7	Lebrija	38	47	35	40
8	Écija	38	48	40	40
9	Santaella	38	54	56	39
10	Palma	38	39	40	39
11	Coria CF	38	43	44	39
12	Chiclana CF	38	44	52	38
13	Ayamonte	38	45	49	38
14	Cádiz	38	47	52	36
15	La Palma	38	43	52	35
16	Montilla	38	30	41	31
17	Puerto Real	38	27	40	30
18	Hermanas	38	43	52	29
19	CD Rota	38	34	63	24
20	Club	38	22	94	11

TEMPORADA 1988/1989

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Utrera	38	90	26	59
2	Lebrija	38	67	29	57
3	Écija	38	76	26	50
4	Coria CF	38	53	32	45
5	Ayamonte	38	57	37	45
6	Cádiz	38	66	43	45
7	Roque Lepe	38	48	29	44
8	Hermanas	38	41	42	39
9	Fernando	38	39	44	38
10	Chiclana CF	38	45	50	38
11	Portuense	38	49	47	37
12	Palma	38	47	52	37
13	CD Rota	38	40	54	36
14	Puerto Real	38	35	40	35
15	Montilla	38	42	48	35
16	Santaella	38	47	53	34
17	Pilas	38	42	63	28
18	Miramar	38	31	89	22
19	Bollullos	38	25	71	18
20	Brenes	38	22	87	18

TEMPORADA 1987/1988

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Algeciras	42	70	31	64
2	Fernando	42	64	33	57
3	Palma	42	66	40	56
4	Cádiz	42	70	44	53
5	Atlético	42	63	35	52
6	Ayamonte	42	55	32	50
7	Écija	42	59	41	50
8	Bollullos	42	57	44	46
9	Coria CF	42	55	44	44
10	Roque Lepe	42	45	41	44
11	Hermanas	42	63	53	43
12	Utrera	42	51	43	41
13	CD Rota	42	47	57	41
14	Brenes	42	41	50	40
15	Pilas	42	42	42	40
16	Montilla	42	47	48	39
17	Portuense	41	48	71	35
18	Ubrique Ind.	42	35	55	34
19	Mairena	42	35	72	29
20	UA. Ceutí	42	35	67	26
21	Imperio	42	38	85	22
22	Moguer CD	41	24	82	16

TEMPORADA 1986/1987

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Sevilla At.	38	87	24	58
2	Betis	38	97	31	58
3	Sanluqueño	38	56	37	51
4	Bollullos	38	56	30	50
5	Cádiz	38	69	34	48
6	Utrera	38	55	31	46
7	Ayamonte	38	43	40	44
8	Coria CF	38	62	51	43
9	Hermanas	38	52	46	43
10	Pilas	38	37	34	42
11	Fernando	38	43	32	41
12	Palma	38	32	50	34
13	Brenes	38	39	59	33
14	Mairena	38	34	46	33
15	Portuense	38	47	64	27
16	CD Rota	38	33	61	25
17	Moguer CD	38	36	63	23
18	Pozoblanco	38	32	64	22
19	Egabrense	38	31	89	21
20	UA. Ceutí	38	35	90	18

TEMPORADA 1985/1986

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Sevilla At.	40	112	22	70
2	Coria CF	40	80	31	63
3	Utrera	40	54	36	50
4	Sanluqueño	40	50	38	48
5	Pozoblanco	40	73	57	48
6	Pilas	40	58	24	47
7	Mairena	40	56	36	46
8	Fernando	40	47	45	45
9	Cádiz	40	68	40	44
10	Palma	40	54	40	38
11	Portuense	40	49	57	37
12	Bollullos	40	32	59	37
13	CD Rota	40	55	59	35
14	Moguer CD	40	39	66	34
15	Brenes	40	39	52	34
16	Egabrense	40	44	61	32
17	Jerez	40	43	61	32
18	Chiclana CF	40	40	60	28
19	Imperio	40	42	68	27
20	Puerto Real	40	37	66	23
21	Rute Calidad	40	29	123	22

TEMPORADA 1984/1985

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Betis	38	88	38	57
2	Córdoba CF	38	83	23	56
3	Sevilla At.	38	80	34	52
4	Moguer CD	38	46	31	47
5	Mairena	38	60	37	46
6	Pozoblanco	38	51	40	44
7	Puerto Real	38	42	45	43
8	Coria CF	38	64	45	42
9	Brenes	38	56	58	39
10	Rute Calidad	38	58	54	38
11	Sanluqueño	38	48	48	38
12	Imperio	38	49	52	36
13	Portuense	38	34	45	34
14	CD Rota	38	44	55	33
15	Atlético	38	56	61	32
16	Jerez	38	40	58	31
17	Chiclana CF	38	45	61	30
18	Palma	38	49	63	29
19	Fernando	38	38	88	18
20	Racing Ceuta	38	28	123	15

TEMPORADA 1983/1984

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Sevilla At.	38	88	36	56
2	Betis	38	79	31	54
3	Sanluqueño	38	61	32	54
4	Coria CF	38	50	28	47
5	Mairena	38	55	33	46
6	Iliturgi CF	38	61	49	45
7	Imperio	38	45	39	42
8	CD Rota	38	44	47	41
9	Pozoblanco	38	62	44	40
10	Atlético	38	63	56	39
11	Brenes	38	50	45	37
12	Moguer CD	38	36	45	36
13	Puerto Real	38	46	51	36
14	Rute Calidad	38	46	49	33
15	Jerez	38	50	61	33
16	Chiclana CF	38	41	61	31
17	Ayamonte	38	28	63	28
18	CD Alcalá	38	33	51	27
19	Lucena	38	33	83	19
20	Riotinto	38	33	100	16

TEMPORADA 1982/1983

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Sevilla At.	38	82	28	61
2	Coria CF	38	66	42	48
3	Cacereño	38	55	42	45
4	Pozoblanco	38	61	36	44
5	Brenes	38	50	43	44
6	Mérida CP	38	41	28	43
7	Diter Zafra	38	42	46	39
8	Puerto Real	38	37	37	39
9	Jerez	38	45	47	39
10	Plasencia	38	49	49	39
11	CD Rota	38	42	51	38
12	CD Alcalá	38	36	42	38
13	Extremadura	38	45	43	37
14	Betis	38	49	47	37
15	Benito	38	45	47	36
16	Iliturgi CF	38	46	55	33
17	Riotinto	38	41	55	31
18	Moralo	38	30	60	24
19	Sanluqueño	38	34	64	23
20	UD Montijo	38	32	66	22

TEMPORADA 1981/1982

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Cacereño	38	71	29	55
2	Mérida CP	38	56	26	55
3	Sevilla At.	38	86	40	54
4	Diter Zafra	38	46	36	48
5	Coria CF	38	57	45	46
6	Jerez	38	62	42	45
7	Plasencia	38	47	43	42
8	Betis	38	38	33	39
9	Puerto Real	38	49	48	38
10	RB Linense	38	37	37	38
11	Benito	38	59	60	37
12	Sanluqueño	38	35	44	34
13	Extremadura	38	45	57	33
14	CD Rota	38	38	49	32
15	Moralo	38	35	55	32
16	Pozoblanco	38	46	53	29
17	Alcalá	38	32	52	28
18	Villanovense	38	47	61	28
19	Estrella	38	32	60	26
20	Imperio	38	31	79	21

TEMPORADA 1980/1981

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Sevilla At.	38	88	37	55
2	Benito	38	48	23	51
3	Sanluqueño	38	49	28	49
4	Cacereño	38	41	28	48
5	Coria CF	38	56	36	47
6	Pozoblanco	38	50	36	45
7	Betis	38	60	38	45
8	Puerto Real	38	59	33	43
9	Moralo	38	52	57	39
10	CD Rota	38	51	46	38
11	Extremadura	38	46	57	37
12	Jerez	38	40	41	37
13	RB Linense	38	47	58	36
14	Plasencia	38	52	66	34
15	Villanovense	38	45	55	32
16	Ayamonte	38	42	44	32
17	UD Montijo	38	36	59	28
18	Llerenense	38	39	69	26
19	UA. Ceutí	38	33	64	23
20	O Donnell	38	25	84	15

TEMPORADA 1979/1980

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Mérida CP	38	63	27	56
2	RB Linense	38	56	33	46
3	Úbeda CF	38	49	40	46
4	CD Rota	38	44	29	45
5	CD Motril	38	45	38	43
6	Pedro	38	47	40	43
7	Estepona	38	41	42	41
8	Martos CD	38	40	41	40
9	Betis	38	52	43	40
10	UD Melilla	37	49	45	39
11	Malagueño	38	41	34	38
12	Extremadura	38	43	47	36
13	Vélez CF	37	43	49	36
14	Llerenense	38	40	47	36
15	Antequerano	38	45	48	34
16	Puerto Real	38	44	51	34
17	UA. Ceutí	38	44	65	31
18	Carolinense	38	36	46	29
19	Jerez	38	26	51	26
20	Melilla	38	26	58	19

Competiciones que juega

2ª Andaluza Cádiz

Pos	Equipos		Pts
1		Chiclana Ind.	58
2		Conil	55
3		CD Rota	52
4		Chipiona CF	51
5		Rayo Sanluqueño	44
6		Balón de Cádiz CF	54
7		CD Guadalcacín	43
8		Florida Dst. 5	44
9		Chiclana B	37
10		Grupo Empresa Bazán CF	37
11		Vejer Bpie	37
12		Tarifa UD	36
13		CD UD Villamartín	23
14		S.Isidro Guadalete	30
15		Ud Bornense	34
16		Palmones	27

RIVALES EN 2ª Andaluza Cádi.

USO DE MEMORIA

8,025,544 bytes

BENCHMARKS

Loading Time Base Classes	0.0023
Controller Execution Time ( Home / Category )	0.6681
Total Execution Time	0.6704

CADENA URL

/historico/Rota/2006

GET DATOS

$_GET['/historico/Rota/2006']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0136	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 = 'Rota' AND l.year = 2006 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.0125	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=2185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=2185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255	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 = 2918
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2185 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=279 AND type_rel = 3
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 279 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128	SELECT /53 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 (1242683,1162357,687224,674140,635729) ORDER BY n.cover_points DESC, update_date DESC
0.0130	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 = '2185' AND l.year = 2006 ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '2185' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 2918 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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=2185 AND l.year in (2005,2006,2007) ORDER BY l.id DESC, l.year DESC ;
0.0125	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 (2919) 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.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 2919 AND teamId = 2185
0.0126	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 = '2185' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2185' and rp.type = 4
0.0126	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 = '2185' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126	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 events2006 e ON e.player_id = p.id AND e.league_id = 2918 WHERE rp.league_id = 2918 AND rp.teamId = 2185 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.0126	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 events2006 e ON e.player_id = p.id AND e.league_id = 2918 WHERE rp.league_id = 2918 AND rp.teamId = 2185 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126	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 events2006 e ON e.player_id = p.id AND e.league_id = 2918 WHERE rp.league_id = 2918 AND rp.teamId = 2185 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 2185 AND l.year <= 2006 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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* `tables2006` 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 = 2918 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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* `tables2004` 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 = 2916 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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* `tables2003` 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 = 2915 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 22023 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 22007 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 21991 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1997` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21973 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 21952 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21889 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21824 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21804 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21785 AND t.round = 51 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 21766 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21752 AND t.round = 51 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 21738 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21723 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21710 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 21693 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 21678 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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* `tables1980` 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 = 21667 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Rota

CD Rota

Selecciona un equipo

Competiciones que juega

2ª Andaluza Cádiz

RIVALES EN 2ª Andaluza Cádi.