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 Ronda

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA ANDALUZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Atlco.	30	77	21	75
2	Marbella	29	77	23	67
3	CD Cártama	29	58	38	60
4	CD Ronda	30	63	34	58
5	Pizarra CF	29	58	33	51
6	CD Mijas	30	48	31	51
7	Athletic	29	43	39	45
8	Benamiel	30	44	57	39
9	CD La Cala	29	53	53	38
10	Llano	29	41	63	38
11	CD Trabuco	30	48	53	34
12	Campillos	29	49	60	33
13	Algarrobo	30	35	69	32
14	Athletic	30	24	68	19
15	Fútbol	23	23	48	12
16	Malaka	30	34	85	9

TEMPORADA 2022/2023

PRIMERA ANDALUZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Marbella	30	79	28	66
2	Benagalbón	30	65	36	61
3	CD Mijas	30	61	43	61
4	CD Cártama	30	72	45	56
5	Algarrobo	30	49	36	56
6	Pizarra CF	30	54	41	48
7	Malaka	30	68	54	45
8	CD La Cala	30	62	59	41
9	Athletic	30	33	41	40
10	Athletic	30	37	45	38
11	CD Trabuco	30	48	61	34
12	Fútbol	30	47	63	31
13	CD Ronda	30	37	57	31
14	Fuengirola	30	36	52	25
15	Atlético	30	40	64	25
16	Churriana	30	30	93	15

TEMPORADA 2021/2022

PRIMERA ANDALUZA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Mijas	34	86	38	73
2	CD Mijas	34	77	44	68
3	Algarrobo	34	59	43	65
4	CD Cártama	34	67	42	63
5	Malaka	34	70	56	61
6	CD Trabuco	34	72	48	55
7	Marbella	34	73	49	54
8	CD Ronda	34	64	51	50
9	Athletic	34	59	49	49
10	Benagalbón	34	44	39	48
11	Tiro Pichón	34	49	55	46
12	Athletic	34	58	50	46
13	Atlético	34	50	47	45
14	Fuengirola	34	51	58	43
15	Alhaurín	34	54	85	39
16	Nerja	34	48	99	23
17	CD Torrox	34	39	80	19
18	CD Almargen	34	33	120	7

TEMPORADA 2020/2021

PRIMERA ANDALUZA GRUPO 25
Equipo		PJ	GF	GC	Puntos
1	Málaga City	26	64	24	55
2	CD Ronda	28	56	26	59
3	CD Cártama	28	65	38	55
4	CD Trabuco	28	56	33	54
5	CD Mijas	26	33	32	43
6	Atlético	28	58	44	43
7	Malaka	26	40	45	33
8	CD Torrox	26	34	41	33

TEMPORADA 2019/2020

PRIMERA ANDALUZA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Torre	25	57	20	59
2	Mijas	25	65	21	58
3	CD Ronda	25	61	26	57
4	CD Mijas	25	48	37	49
5	Marbella	25	48	30	45
6	Atlético	25	47	30	39
7	CD Cártama	25	60	49	38
8	Athletic	25	48	50	36
9	Benamiel	25	53	60	32
10	Torcal CF	25	47	68	30
11	CD Torrox	25	36	50	27
12	Benagalbón	25	44	50	26
13	CD Almargen	24	37	46	26
14	Malaka	25	34	46	25
15	Villanueva	25	40	58	24
16	Algarrobo	24	28	58	21
17	Barrio NSR	25	29	46	18
18	Atlético	25	36	73	16

TEMPORADA 2018/2019

PRIMERA ANDALUZA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Churriana	34	67	44	71
2	Athletic	33	72	44	61
3	Atlético	34	78	50	60
4	Marbella	34	75	47	56
5	CD Mijas	33	57	49	51
6	Torcal CF	34	59	56	51
7	Mijas	33	44	42	49
8	CD Torrox	33	54	45	48
9	Benamiel	34	55	68	45
10	Zenit	27	64	39	43
11	CD Ronda	33	41	44	43
12	Barrio NSR	34	46	58	41
13	Campillos	34	63	61	40
14	CD Trabuco	34	43	53	40
15	Atlético	34	56	77	39
16	Villanueva	33	37	61	36
17	CD Monda	33	33	55	31
18	Cala Mijas	34	50	101	20

TEMPORADA 2017/2018

PRIMERA ANDALUZA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Casabermeja	34	72	19	80
2	CD Cártama	34	76	28	76
3	Churriana	34	64	34	64
4	CD Torrox	34	71	48	60
5	CD Trabuco	34	65	53	56
6	CD Mijas	34	57	46	54
7	Benamiel	34	49	31	53
8	Athletic	34	58	49	53
9	Campillos	34	56	54	49
10	Palo	34	54	54	49
11	CD Ronda	33	68	52	44
12	Barrio NSR	34	53	61	43
13	Atlético	34	41	42	42
14	Villanueva	34	33	52	39
15	Marbella	34	64	62	37
16	Archidona	33	36	61	28
17	Fuengirola	34	39	122	13
18	CD La Cala	34	27	115	10

TEMPORADA 2016/2017

DIVISIÓN HONOR SENIOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Torremolinos	36	96	28	86
2	Villacarrill	36	70	43	78
3	Athletic	36	62	40	69
4	Atletico	36	73	53	68
5	Torreperogil	36	71	55	61
6	Arenas	36	52	41	56
7	Estudiantes	36	59	53	56
8	Adra	36	61	65	48
9	CD Estepona	36	55	45	47
10	Poli	36	55	60	47
11	Cullar Vega	36	45	56	47
12	Linares	36	56	57	46
13	Atlético	36	50	56	45
14	UD Pavía	36	36	46	40
15	CD Ronda	36	45	71	38
16	Tiro Pichón	36	46	68	37
17	Cd Oriente	36	39	66	34
18	Cañada	36	38	70	31
19	Comarca	36	44	80	28

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Mancha Real	38	73	25	86
2	Malagueño	38	96	34	86
3	Loja	38	68	26	81
4	Pvo. Ejido	38	77	32	79
5	El Palo FC	38	69	24	76
6	Antequera	38	67	33	71
7	Guadix CF	38	68	46	70
8	Vélez CF	38	55	33	65
9	Huétor	38	60	37	59
10	Martos CD	38	58	55	56
11	Pedro	38	55	67	48
12	Villares	38	46	57	44
13	CD Rincón	38	48	59	41
14	Alhaurín	38	42	67	40
15	Atarfe	38	45	71	36
16	Maracena	38	48	69	36
17	River	38	44	88	32
18	Comarca	38	30	62	31
19	CD Ronda	38	32	97	24
20	Español	38	11	110	4

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Linares	38	88	26	88
2	Malagueño	38	69	36	75
3	Pedro	38	65	35	73
4	Martos CD	38	66	42	71
5	Loja	38	55	36	69
6	Huétor	38	53	37	62
7	Villares	38	43	37	58
8	Maracena	38	66	52	57
9	Guadix CF	38	49	49	51
10	Mancha Real	38	36	34	50
11	Vélez CF	38	49	47	49
12	Español	38	53	70	48
13	Pvo. Ejido	38	55	75	47
14	CD Ronda	38	52	63	43
15	Antequera	38	51	55	42
16	Alhaurín	38	43	74	41
17	Atarfe	38	53	70	37
18	Villacarrill	38	32	64	31
19	Atletico	38	29	58	30
20	Los Molinos	38	32	79	26

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Marbella FC	38	81	37	86
2	Linares	38	71	28	82
3	Malagueño	38	74	34	82
4	Loja	38	88	44	79
5	Mancha Real	38	51	31	72
6	Vélez CF	38	60	31	67
7	Martos CD	38	65	49	60
8	Villacarrill	38	63	46	59
9	Huétor	38	36	42	53
10	Atarfe	38	48	49	50
11	Maracena	38	44	44	49
12	Español	38	58	71	49
13	Antequera	38	43	54	44
14	Pedro	38	34	54	44
15	CD Ronda	38	48	58	43
16	Los Molinos	38	53	64	43
17	Villares	38	36	55	42
18	Melilla	38	44	66	40
19	CD Huercal	38	29	106	13
20	Unión	38	16	79	0

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	El Palo FC	38	72	36	74
2	Mancha Real	38	50	27	72
3	Recreativo	38	73	35	72
4	Malagueño	38	71	27	71
5	Linares	38	52	30	70
6	Villacarrill	38	66	41	65
7	Martos CD	38	52	44	64
8	Vélez CF	38	51	47	56
9	Atarfe	38	58	48	53
10	Maracena	38	47	49	51
11	Marbella FC	38	52	53	49
12	Casino Real	38	43	44	48
13	Pedro	38	50	45	47
14	CD Ronda	38	53	56	45
15	Unión	38	45	55	45
16	Huétor	38	44	67	41
17	CD Huercal	38	33	73	31
18	Torremolinos	38	32	67	30
19	Alhaurín	38	29	79	23
20	Comarca	38	24	74	23

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Loja	40	87	33	86
2	Unión	40	76	37	85
3	Marbella FC	40	66	28	78
4	Malagueño	39	77	34	76
5	Maracena	39	62	40	73
6	Comarca	40	57	34	70
7	Mancha Real	40	53	34	70
8	Pedro	40	67	46	67
9	El Palo FC	40	63	57	65
10	Martos CD	40	49	45	59
11	Casino Real	39	44	49	54
12	CD Ronda	40	49	60	51
13	Alhaurín	40	59	63	50
14	Huétor	39	50	56	49
15	Motril CF	40	51	45	48
16	Nerja	39	42	57	45
17	Vélez CF	39	36	60	39
18	Arenas	40	35	51	37
19	Antequera	40	47	70	37
20	Ciudad	40	22	80	18
21	Carboneras	40	6	119	4

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Comarca	38	57	29	79
2	Alhaurín	38	61	25	78
3	Loja	38	60	35	74
4	Malagueño	38	62	35	70
5	CD Ronda	38	68	37	68
6	Maracena	38	51	36	63
7	Antequera	38	72	47	62
8	Motril CF	38	50	33	58
9	Martos CD	38	38	39	53
10	Marbella FC	38	52	50	50
11	Mancha Real	38	49	42	49
12	Huétor	38	37	54	46
13	El Palo FC	38	57	65	46
14	Ciudad	38	46	54	45
15	Vélez CF	38	56	57	44
16	Carboneras	38	57	71	40
17	Casino Real	38	44	65	40
18	Baza	38	30	60	34
19	Alhaurino	38	38	58	30
20	Adra	38	13	106	6

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Mancha Real	36	53	26	68
2	Motril CF	36	54	24	66
3	El Palo FC	36	59	44	63
4	Almería B	36	62	37	61
5	CD Ronda	36	64	51	60
6	Malagueño	36	56	44	59
7	Comarca	36	52	34	57
8	Ciudad	36	52	48	53
9	Loja	36	42	40	49
10	Antequera	36	43	38	47
11	Vélez CF	36	50	52	47
12	Alhaurino	36	53	54	45
13	Adra	36	47	59	45
14	CD Santa Fe	36	40	55	41
15	Carboneras	36	43	63	38
16	Huétor	36	44	67	38
17	Baza	36	36	54	37
18	Arenas	36	33	63	35
19	Polideportiv	19	21	22	24
20	CD Vera	19	17	46	10

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Unión	35	71	31	80
2	Almería B	35	80	35	75
3	Motril CF	35	66	36	71
4	Baza	35	53	29	61
5	Malagueño	34	59	30	60
6	Polideportiv	34	53	36	56
7	Comarca	35	46	38	56
8	Vélez CF	34	52	45	51
9	Loja	34	26	37	45
10	Ciudad	34	52	47	44
11	CD Ronda	35	48	54	43
12	Alhaurino	35	52	56	42
13	Granada	34	40	47	42
14	Arenas	34	33	41	38
15	Adra	34	37	59	36
16	CD Vera	34	30	56	35
17	Granada 74	34	41	54	34
18	CD Santa Fe	35	38	63	34
19	Imperio	34	26	66	27
20	Casino Real	34	26	69	26

TEMPORADA 2007/2008

PRIMERA ANDALUZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Ronda	34	73	18	83
2	Unión	33	77	20	75
3	Mancha Real	34	60	32	61
4	Unión	34	48	42	52
5	Alcalá CF	34	58	58	45
6	CD Mijas	34	48	45	44
7	Nerja	34	40	50	44
8	Baeza CF	34	34	38	43
9	Martos CD	34	30	39	43
10	Barrio	34	29	32	42
11	Real Jaén	34	47	45	41
12	La Puerta	34	37	60	40
13	Carolinense	34	42	70	40
14	Torre	35	47	64	32
15	Jódar CF	34	29	55	26
16	CD Tugia	34	34	74	25

TEMPORADA 2006/2007

PRIMERA ANDALUZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Iliturgi CF	30	56	20	74
2	Mengibar	30	70	28	66
3	Unión	30	64	37	59
4	CD Ronda	30	47	26	53
5	Unión	30	48	35	46
6	Mancha Real	30	34	30	46
7	Nerja	30	38	36	45
8	Real Jaén	30	44	42	43
9	Jódar CF	30	39	47	36
10	Baeza CF	30	30	40	34
11	CD Tugia	30	39	50	34
12	Campillos	30	25	54	25
13	Linares	30	22	46	22
14	Úbeda Viva	30	14	64	12

TEMPORADA 2003/2004

2ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	CD Ronda	30	77	29	73
2	Fuengirola	30	104	24	72
3	Torremolinos	30	67	36	62
4	Unión	30	59	38	57
5	Vélez CF	30	54	34	52
6	Manilva-Sabi	30	63	45	52
7	Alhaurín	30	52	28	50
8	Torre	30	41	34	46
9	CD Mijas	30	45	51	37
10	CD Álora	30	45	56	37
11	Benagalbón	30	38	50	37
12	Nerja	30	39	59	37
13	Marbella B	30	56	59	35
14	Nueva	30	38	83	28
15	CD Cártama	30	40	63	27
16	Julian	30	32	62	27
17	Benamiel	30	32	59	25
18	Sierra	30	33	105	16

Competiciones que juega

Grupo 3

Primera Andaluza Grupo 3

Pos	Equipos		Pts
1		Atlco. Marbellí	75
2		At. Marbella Balompié	67
3		CD Cártama	60
4		CD Ronda	58
5		Pizarra CF	51
6		CD Mijas	51
7		Athletic Coín	45
8		At. Benamiel	39
9		CD La Cala	38
10		CD Llano Perchel	38
11		CD Trabuco	34
12		Campillos	33
13		Algarrobo UD	32
14		Athletic Fuengirola	19
15		Fútbol Romeral	12
16		Malaka	9

	Playoff Ascenso : Atlco. Marbellí, At. Marbella Balompié, CD Cártama, CD Ronda
	Descenso : Athletic Fuengirola, Fútbol Romeral, Malaka

RIVALES EN Primera Andaluza

USO DE MEMORIA

7,719,200 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6589
Total Execution Time	0.6601

CADENA URL

/historico/Ronda

GET DATOS

$_GET['/historico/Ronda']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0139	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 = 'Ronda' AND l.year = 2024 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=2177 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=2177 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254	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 = 73626
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2177 AND type_rel = 2
0.0132	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 = '2177' ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '2177' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '2177' 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 = 73626 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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=2177 AND l.year in (2023,2024,2025) 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 (73626) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 73626 AND teamId = 2177
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 FROM* `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73626 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '2177' 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 = '2177' and rp.type = 4
0.0128	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 = '2177' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2177' and rp.type = 4
0.0136	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73626 WHERE rp.league_id = 73626 AND rp.teamId = 2177 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.0134	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73626 WHERE rp.league_id = 73626 AND rp.teamId = 2177 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73626 WHERE rp.league_id = 73626 AND rp.teamId = 2177 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 = 2177 AND l.year <= 2024 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* `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73626 AND t.round = 30 ORDER BY team.conference ASC,t.position 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* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68701 AND t.round = 30 ORDER BY team.conference ASC,t.position 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* `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 64029 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 59039 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 62150 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 51260 AND t.round = 25 ORDER BY team.conference ASC,t.position 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* `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44625 AND t.round = 34 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* `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 39569 AND t.round = 34 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* `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 34071 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* `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15450 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* `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3918 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* `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2708 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* `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1953 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* `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1405 AND t.round = 42 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* `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1122 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* `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 839 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* `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 139 AND t.round = 38 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* `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 112 AND t.round = 34 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* `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 117 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 = 2973 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Ronda

CD Ronda

Selecciona un equipo

Competiciones que juega

Primera Andaluza Grupo 3

RIVALES EN Primera Andaluza