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

RM Castilla

Entrenador: Raúl

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Castellón	33	68	32	75
2	Córdoba CF	33	60	28	67
3	UD Ibiza	33	52	28	63
4	Málaga	33	44	21	62
5	AD Ceuta FC	33	46	33	56
6	Recreativo	33	35	30	52
7	Real Murcia	33	31	31	51
8	Antequera	33	41	39	50
9	Atlético B	33	47	39	45
10	Alcoyano	33	34	34	45
11	RM Castilla	34	41	41	44
12	Intercity	33	34	40	42
13	Algeciras	33	36	35	42
14	Sanluqueño	33	32	37	38
15	AD Mérida	33	29	41	38
16	Fernando	34	32	45	35
17	Linares	33	26	45	32
18	UD Melilla	33	23	48	27
19	Atlético	33	17	52	23
20	Recreativo	33	23	52	18

TEMPORADA 2022/2023

PRIMERA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	55	25	75
2	Alcorcón	38	53	23	74
3	RM Castilla	38	58	38	69
4	Deportivo	38	53	29	67
5	Celta	38	48	38	59
6	Linares	38	53	53	59
7	Unionistas	38	38	40	56
8	AD Mérida	38	40	37	54
9	Córdoba CF	38	48	37	54
10	Cultural	38	41	43	48
11	Fuenlabrada	38	32	51	46
12	AD Ceuta FC	38	53	52	45
13	Fernando	38	46	50	45
14	Rayo	38	42	51	45
15	Algeciras	38	36	47	44
16	CD Badajoz	38	35	52	43
17	UD Sanse	38	30	46	43
18	RB Linense	38	31	34	42
19	Pontevedra	38	34	53	36
20	CF Talavera	38	36	63	33

TEMPORADA 2021/2022

PRIMERA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC Andorra	38	61	38	71
2	Villarreal	38	65	36	67
3	Albacete	38	52	34	67
4	Gimnàstic	38	41	30	61
5	Linares	38	59	47	60
6	Atlético	38	52	35	59
7	Algeciras	38	50	39	59
8	CE Sabadell	38	44	33	58
9	Barça	38	59	51	57
10	RM Castilla	38	66	47	56
11	Alcoyano	38	41	40	52
12	RB Linense	38	35	44	50
13	Castellón	38	37	50	50
14	Cornellà	38	39	48	48
15	Fernando	38	49	58	48
16	Sanluqueño	38	39	56	46
17	Sevilla At.	38	36	55	46
18	UCAM Murcia	38	42	56	35
19	Badalona	38	26	51	33
20	Betis	38	23	68	21

TEMPORADA 2020/2021

SEGUNDA DIVISIÓN B GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	UD Sanse	18	22	14	35
2	RM Castilla	18	30	21	32
3	Internaciona	18	24	16	30
4	Rayo	18	17	16	28
5	Atlético	18	26	21	24
6	Navalcarnero	18	16	18	20
7	Las Rozas	18	16	25	20
8	Atlético B	18	15	20	19
9	Poblense	18	16	21	16
10	Getafe B	18	11	21	13
11	CD Badajoz	18	32	9	41
12	Extremadura	18	24	16	31
13	CF Talavera	18	23	19	27
14	Villanovense	18	15	8	27
15	Benito	18	16	21	24
16	AD Mérida	18	12	12	23
17	UD Melilla	18	15	19	23
18	Villarrubia	18	17	24	20
19	Yugo	18	13	25	16
20	Villarrobled	18	15	29	10

TEMPORADA 2019/2020

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Atlético	28	44	22	58
2	UD Ibiza	28	41	18	56
3	Atlético B	28	52	27	53
4	Peña	28	43	41	45
5	Coruxo	28	32	30	41
6	Rayo	28	31	29	41
7	RM Castilla	28	42	35	40
8	Internaciona	28	39	37	40
9	Pontevedra	28	38	40	38
10	Langreo	28	28	33	38
11	Racing	28	33	33	37
12	Real Oviedo	28	31	38	37
13	UD Melilla	28	29	37	36
14	Celta	28	41	45	35
15	Sporting	28	36	31	34
16	Palmas	28	20	35	34
17	Las Rozas	28	32	29	33
18	Marino	28	26	37	32
19	Getafe B	28	25	37	28
20	UD Sanse	28	24	53	19

TEMPORADA 2018/2019

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fuenlabrada	38	49	21	71
2	Ponferradina	38	55	27	69
3	Atlético B	38	57	32	68
4	RM Castilla	38	62	45	65
5	Cultural	38	56	34	65
6	Pontevedra	38	45	38	62
7	Guijuelo	38	35	33	59
8	UD Sanse	38	54	45	56
9	Unionistas	38	39	37	52
10	Coruxo	38	38	41	50
11	Real	38	33	40	49
12	Salamanca	38	40	42	49
13	Burgos	38	28	32	48
14	Internaciona	38	47	54	48
15	Palmas	38	26	33	48
16	Celta	38	45	48	46
17	Rápido	38	28	55	38
18	Unión	38	42	62	36
19	Navalcarnero	38	37	70	25
20	Deportivo	38	28	55	24

TEMPORADA 2017/2018

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rayo	38	60	35	70
2	Deportivo	38	46	28	69
3	Fuenlabrada	38	56	31	65
4	Celta	38	44	32	63
5	Rápido	38	39	28	61
6	Navalcarnero	38	44	40	61
7	CF Talavera	38	40	46	56
8	RM Castilla	38	53	37	55
9	Atlético B	38	43	46	51
10	UD Sanse	38	45	46	51
11	Unión	38	43	46	51
12	Ponferradina	38	53	50	48
13	Guijuelo	38	34	34	45
14	Pontevedra	38	45	46	45
15	Real	38	41	48	44
16	Coruxo	38	37	57	43
17	CD Toledo	38	45	50	41
18	Racing	38	38	53	40
19	Gimnástica	38	33	50	39
20	CCD Cerceda	38	26	62	25

TEMPORADA 2016/2017

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Albacete	38	64	36	69
2	CD Toledo	38	38	34	65
3	Fuenlabrada	38	54	42	63
4	Rayo	38	43	35	61
5	Leioa	38	53	42	60
6	Logroñés	38	50	33	56
7	Real Unión	38	39	38	56
8	Bilbao Ath.	38	45	33	56
9	Arenas Getxo	38	50	46	55
10	Real	38	55	43	52
11	RM Castilla	38	43	47	51
12	SD Gernika	38	47	52	49
13	Barakaldo	38	46	42	49
14	Amorebieta	38	47	47	48
15	Navalcarnero	38	38	42	47
16	UD Sanse	38	47	51	47
17	Mensajero	38	40	47	46
18	Yugo	38	42	62	38
19	Sestao River	38	28	46	37
20	SD Zamudio	38	33	84	22

TEMPORADA 2015/2016

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	RM Castilla	38	72	40	80
2	Barakaldo	38	52	24	80
3	Yugo	38	51	43	64
4	CD Toledo	38	49	33	63
5	Real Unión	38	59	37	60
6	Sestao River	38	38	29	60
7	Real	38	58	44	60
8	Arenas Getxo	38	50	43	57
9	Amorebieta	38	50	43	56
10	CD Ebro	38	43	37	53
11	Fuenlabrada	38	40	40	49
12	SD Gernika	38	41	49	45
13	Mensajero	38	37	47	44
14	Rayo	38	42	50	43
15	La Roda CF	38	40	52	43
16	Leioa	38	37	59	41
17	Guadalajara	38	40	56	40
18	CF Talavera	38	42	59	37
19	Portugalete	38	29	48	32
20	Getafe B	38	43	80	32

TEMPORADA 2014/2015

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Huesca	38	61	30	69
2	Bilbao Ath.	38	65	30	66
3	Guadalajara	38	49	43	61
4	Real Unión	38	48	38	60
5	Tudelano	38	42	31	58
6	RM Castilla	38	59	40	58
7	Barakaldo	38	50	43	58
8	Yugo	38	45	45	58
9	CD Toledo	38	47	54	57
10	Amorebieta	38	59	54	52
11	Fuenlabrada	38	43	54	51
12	Getafe B	38	50	51	51
13	Sestao River	38	46	51	50
14	Real	38	51	56	48
15	Leioa	38	42	60	48
16	Palmas	38	58	60	47
17	Rayo	38	43	60	43
18	Atlético B	38	52	62	41
19	Trival	38	42	71	37
20	Conquense	38	48	67	30

TEMPORADA 2013/2014

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Eibar	42	49	28	71
2	Deportivo	42	48	36	69
3	Barça	42	60	47	66
4	Real Murcia	42	55	44	65
5	Real	42	63	51	64
6	Las Palmas	42	51	50	63
7	Córdoba CF	42	46	43	61
8	Recreativo	42	53	53	61
9	Alcorcón	42	46	40	59
10	CE Sabadell	42	52	59	59
11	Tenerife	42	46	49	54
12	CD Lugo	42	41	48	54
13	Numancia	42	42	41	54
14	Real	42	49	53	53
15	Girona	42	52	50	51
16	Ponferradina	42	46	49	51
17	Mallorca	42	46	57	51
18	Deportivo	42	57	57	51
19	Mirandés	42	39	56	50
20	RM Castilla	42	49	56	49
21	Real Jaén	42	43	49	48
22	Hércules	42	45	62	45

TEMPORADA 2012/2013

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Elche	42	54	27	82
2	Villarreal	42	68	38	77
3	Almería	42	72	50	74
4	Girona	42	74	56	71
5	Alcorcón	42	57	55	69
6	Las Palmas	42	62	55	66
7	Ponferradina	42	57	50	66
8	RM Castilla	42	80	62	59
9	Barça	42	76	71	57
10	Real	42	60	53	56
11	CD Lugo	42	46	54	56
12	Numancia	42	53	55	55
13	Recreativo	42	46	57	54
14	Córdoba CF	42	55	55	54
15	Mirandés	42	35	51	52
16	CE Sabadell	42	54	69	52
17	Hércules	42	43	53	50
18	Guadalajara	42	46	53	50
19	Real Murcia	42	43	56	47
20	Racing	42	38	51	46
21	Huesca	42	46	58	45
22	Xerez CD	42	38	74	30

TEMPORADA 2011/2012

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RM Castilla	38	77	36	78
2	Tenerife	38	51	32	64
3	CD Lugo	38	55	41	64
4	Albacete	38	56	37	63
5	Atlético B	38	58	38	60
6	Real Oviedo	38	50	43	60
7	Rayo	38	53	49	56
8	Getafe B	38	60	63	53
9	La Roda CF	38	44	45	49
10	Sporting	38	42	45	48
11	Coruxo	38	37	48	46
12	Leganés	38	50	50	45
13	Marino	38	40	53	45
14	UD Sanse	38	36	47	44
15	RSD Alcalá	38	40	47	44
16	Conquense	38	44	41	44
17	CD Toledo	38	37	42	42
18	Montañeros	38	44	63	40
19	Vecindario	38	37	66	39
20	Celta	38	42	67	38

TEMPORADA 2010/2011

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Lugo	38	64	39	75
2	Guadalajara	38	62	25	73
3	RM Castilla	38	73	38	71
4	Leganés	38	54	35	69
5	Universidad	38	41	43	62
6	Rayo	38	41	34	58
7	Getafe B	38	45	45	54
8	RSD Alcalá	38	38	39	52
9	Celta	38	43	52	52
10	Vecindario	38	37	53	51
11	Atlético B	38	43	43	50
12	Montañeros	38	50	53	49
13	Cacereño	38	34	33	48
14	Coruxo	38	40	41	47
15	CD Badajoz	38	41	44	47
16	Conquense	38	47	43	47
17	Deportivo	38	47	57	45
18	Pontevedra	38	38	49	39
19	Extremadura	38	29	50	32
20	Cerro Reyes	38	20	71	16

TEMPORADA 2009/2010

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alcorcón	38	50	30	73
2	Real Oviedo	38	58	36	68
3	Guadalajara	38	53	36	64
4	Universidad	38	59	51	64
5	Leganés	38	54	45	62
6	Puertollano	38	47	39	62
7	Atlético B	38	64	44	58
8	RM Castilla	38	68	51	56
9	Gimnástica	38	40	35	51
10	Conquense	38	50	45	50
11	Vecindario	38	45	56	49
12	Sporting	38	40	52	47
13	RSD Alcalá	38	40	52	44
14	Cerro Reyes	38	42	53	44
15	Cacereño	38	43	45	44
16	CD Toledo	38	40	57	43
17	Rayo	38	36	49	41
18	Villanovense	38	45	54	41
19	Tenerife B	38	46	51	38
20	Lanzarote	38	46	85	34

TEMPORADA 2008/2009

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cartagena	38	60	28	73
2	Lorca	38	58	34	69
3	Alcorcón	38	61	34	66
4	Leganés	38	51	37	66
5	Real Murcia	38	41	32	65
6	RM Castilla	38	60	45	63
7	Mérida UD	38	50	34	62
8	Atlético	38	39	27	62
9	Sangonera	38	46	37	56
10	Águilas CF	38	43	44	55
11	Vecindario	38	36	39	52
12	Universidad	38	32	45	48
13	Atlético B	38	43	44	47
14	Lanzarote	38	40	57	40
15	Fuerteventur	38	45	66	39
16	Palmas	38	38	54	38
17	Navalcarnero	38	37	55	37
18	Pájara	38	38	55	35
19	CD Alfaro	38	31	55	32
20	Villa Sta..	38	33	60	26

TEMPORADA 2007/2008

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rayo	38	66	31	70
2	Pontevedra	38	52	29	67
3	Fuerteventur	38	50	45	63
4	Deportivo	38	46	33	62
5	RM Castilla	38	60	42	61
6	Universidad	38	45	32	61
7	CD Lugo	38	51	49	60
8	Celta	38	56	50	56
9	Pájara	38	36	41	53
10	Atlético B	38	49	55	52
11	Vecindario	38	52	44	51
12	Leganés	38	43	44	51
13	Lanzarote	38	43	46	50
14	Alcorcón	38	38	39	48
15	Marino	38	31	42	46
16	Villa Sta..	38	39	45	46
17	CD Ourense	38	36	46	46
18	Fuenlabrada	38	29	48	33
19	UD Sanse	38	23	50	31
20	Raqui Isidro	38	41	75	25

TEMPORADA 2006/2007

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Real	42	70	35	88
2	Almería	42	73	49	80
3	Real Murcia	42	62	45	76
4	Ciudad	42	52	44	63
5	Cádiz	42	53	45	61
6	Albacete	42	49	48	60
7	Tenerife	42	48	51	60
8	Numancia	42	48	44	58
9	Xerez CD	42	47	42	58
10	Elche	42	47	46	58
11	Poli Ejido	42	52	50	58
12	Salamanca	42	53	50	57
13	Real	42	53	53	56
14	Castellón	42	48	41	56
15	Málaga	42	49	50	55
16	Hércules	42	48	52	54
17	Deportivo	42	51	60	52
18	Las Palmas	42	51	59	51
19	RM Castilla	42	55	67	49
20	Ponferradina	42	45	61	46
21	Lorca	42	37	60	37
22	Vecindario	42	42	81	34

TEMPORADA 2005/2006

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Recreativo	42	67	32	78
2	Gimnàstic	42	48	38	76
3	Levante	42	53	39	74
4	Ciudad	42	53	42	72
5	Lorca	42	56	39	69
6	Almería	42	54	43	67
7	Xerez CD	42	60	46	67
8	Numancia	42	50	55	63
9	Real	42	41	34	56
10	Real	42	54	54	55
11	RM Castilla	42	55	50	55
12	Castellón	42	46	50	54
13	Albacete	42	44	57	54
14	Elche	42	47	54	53
15	Poli Ejido	42	43	50	53
16	Real Murcia	42	41	40	52
17	Hércules	42	39	49	52
18	Tenerife	42	53	60	51
19	Lleida	42	43	53	46
20	Racing	42	44	63	37
21	Malagueño	42	42	68	36
22	Eibar	42	28	45	35

TEMPORADA 2004/2005

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RM Castilla	38	60	28	76
2	Universidad	38	44	27	70
3	Rayo	38	45	31	65
4	RSD Alcalá	38	38	28	63
5	Leganés	38	45	41	63
6	Atlético B	38	59	40	60
7	Las Palmas	38	50	33	60
8	Celta	38	47	48	57
9	CD Ourense	38	43	29	57
10	Castillo CF	38	34	33	53
11	Alcorcón	38	56	56	49
12	Vecindario	38	46	45	48
13	Lanzarote	38	44	50	46
14	UD Sanse	38	38	46	46
15	Pájara	38	41	53	44
16	Fuenlabrada	38	43	47	44
17	Fuerteventur	38	34	50	39
18	Mallorca B	38	34	45	37
19	Navalcarnero	38	29	63	30
20	At. Arteixo	38	32	69	26

Competiciones que juega

Primera Federación Grupo 2

Pos	Equipos		Pts
1		CD Castellón	75
2		Córdoba CF	67
3		UD Ibiza	63
4		Málaga	62
5		AD Ceuta FC	56
6		Recreativo	52
7		Real Murcia	51
8		Antequera CF	50
9		Atlético B	45
10		Alcoyano	45
11		RM Castilla	44
12		CF Intercity	42
13		Algeciras CF	42
14		At. Sanluqueño	38
15		AD Mérida	38
16		San Fernando CD	35
17		Linares Deportivo	32
18		UD Melilla	27
19		Atlético Baleares	23
20		Recreativo Granada	18

	Ascenso : CD Castellón
	Playoff Ascenso : Córdoba CF, UD Ibiza, Málaga, AD Ceuta FC
	Descenso : San Fernando CD, Linares Deportivo, UD Melilla, Atlético Baleares, Recreativo Granada

RIVALES EN Primera Federaci.

USO DE MEMORIA

8,623,296 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.4619
Total Execution Time	0.4631

CADENA URL

/historico/Rm-Castilla

GET DATOS

$_GET['/historico/Rm-Castilla']

POST DATOS

No hay datos POST existentes

CONSULTAS (26)

0.0110	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2170 AND type_rel = 2
0.0239	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2170 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109	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 (571,1342,1444,1488,1605) ORDER BY n.cover_points DESC, update_date DESC
0.0118	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 = '2170' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115	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=2170 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106	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 (72359,71840,71432) 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.0114	SELECT count(id) as num_players from rel_players WHERE league_id = 72359 AND teamId = 2170
0.0114	SELECT count(id) as num_players from rel_players WHERE league_id = 71840 AND teamId = 2170
0.0140	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2170
0.0191	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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 2170 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.0191	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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 2170 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169	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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 2170 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 = 2170 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0229	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 = 38806 AND t.round = 38 ORDER BY team.conference 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* `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 = 33379 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 = 15376 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* `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 = 2434 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 1901 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125	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 = 1347 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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 = 827 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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 = 128 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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 = 4 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118	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 = 81 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 534 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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* `tables2005` 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 = 172 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72359 ORDER BY nameShow LIMIT 100

RM Castilla

RM Castilla

Selecciona un equipo

Competiciones que juega

Primera Federación Grupo 2

RIVALES EN Primera Federaci.