Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

CD Santa Úrsula

Entrenador: Ruben Garcia

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Tenerife B	33	64	22	77
2	Lanzarote	33	64	28	74
3	Union Yaiza	33	62	19	73
4	Palmas	33	72	24	71
5	Panadería	33	52	38	55
6	Arucas	33	49	41	44
7	Santa	33	34	36	43
8	Bartolomé	33	42	40	42
9	Villa Santa	33	38	33	40
10	Tamaraceite	33	39	53	40
11	Marino	33	42	51	39
12	Herbania	33	30	44	38
13	CD Buzanada	33	28	42	36
14	Ibarra	33	31	45	33
15	Atletico	33	31	52	29
16	UD Teror	33	29	63	26
17	Gran Tarajal	33	21	50	24
18	Unión	33	24	71	19

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Mensajero	30	53	36	58
2	Lanzarote	30	51	29	53
3	Fernando	30	39	25	51
4	Palmas	30	43	28	50
5	Villa Santa	30	38	26	50
6	Tenerife B	30	44	33	49
7	Panadería	30	36	28	47
8	Santa	30	42	34	44
9	Tamaraceite	30	33	33	38
10	Union Yaiza	30	40	49	38
11	Marino	30	38	44	37
12	Arucas	30	37	47	37
13	Unión	30	49	38	37
14	Ibarra	30	31	58	26
15	Gran Tarajal	30	29	49	25
16	Estrella	30	19	65	17

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Atlético	32	44	27	59
2	Palmas	32	47	30	58
3	Tenerife B	32	49	31	57
4	Arucas	32	44	30	56
5	Villa Santa	32	45	37	48
6	Union Yaiza	32	42	43	47
7	Gran Tarajal	32	46	40	47
8	Santa	32	35	37	46
9	Unión	32	46	35	46
10	Marino	32	37	30	45
11	Lanzarote	32	28	24	44
12	CD Buzanada	32	35	33	44
13	Herbania	32	27	33	43
14	Tenisca	32	38	43	42
15	Vera	32	27	37	40
16	Unión Viera	32	22	52	29
17	Las Zocas	32	14	64	13

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Fernando	18	27	17	33
2	Panadería	18	22	14	32
3	Palmas	18	26	22	30
4	Gran Tarajal	18	18	12	29
5	Unión Viera	18	26	30	26
6	Lanzarote	18	18	17	24
7	Unión	18	25	30	24
8	UD Guía	18	18	28	19
9	Villa Santa	18	18	21	18
10	Arucas	18	20	27	16
11	Mensajero	20	28	17	40
12	Tenisca	20	37	20	35
13	Atlético	20	28	15	33
14	CD Buzanada	20	29	21	32
15	Tenerife B	20	33	26	31
16	Santa	20	22	19	29
17	Vera	20	24	24	29
18	Atlético	20	21	28	25
19	Atletico	20	16	30	21
20	AU Güímar	20	19	34	14
21	Ibarra	20	10	33	10

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Tenisca	28	57	36	54
2	Tamaraceite	28	49	31	53
3	Marino	27	41	30	53
4	Fernando	27	58	29	52
5	Atlético	27	54	31	49
6	Tenerife B	27	41	32	45
7	Vera	28	54	52	43
8	Panadería	28	52	39	41
9	Gran Tarajal	28	52	44	41
10	Unión Viera	28	32	42	39
11	Unión	27	32	37	35
12	Mensajero	27	51	51	34
13	Santa	28	32	39	34
14	Palmas	28	33	31	32
15	Lanzarote	27	33	32	31
16	Atlético	27	34	47	30
17	AU Güímar	28	34	53	25
18	Ibarra	28	24	48	25
19	CD Buzanada	27	23	55	21
20	Villa Santa	27	27	54	16

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Tamaraceite	38	61	33	67
2	Mensajero	38	61	38	64
3	Unión Viera	38	53	45	63
4	Tenerife B	38	47	28	61
5	Lanzarote	38	58	43	60
6	Palmas	38	45	28	59
7	Villa Santa	38	51	38	57
8	Fernando	38	66	59	56
9	Santa	38	37	36	53
10	Ibarra	38	43	58	52
11	AU Güímar	38	48	49	48
12	Marino	38	53	48	47
13	Atlético	38	39	45	45
14	CD Buzanada	38	38	50	45
15	Unión	38	43	46	45
16	Tenisca	38	41	50	45
17	Panadería	38	62	68	44
18	Union Yaiza	38	32	55	43
19	El Cotillo	38	39	62	41
20	Las Zocas	38	37	75	35

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Tenerife B	40	71	20	85
2	Mensajero	40	77	36	79
3	Fernando	40	85	40	77
4	Lanzarote	40	75	43	73
5	Ibarra	40	68	41	71
6	Palmas	40	63	44	66
7	Santa	40	69	63	64
8	Villa Santa	40	61	56	60
9	Las Zocas	40	52	55	59
10	Union Yaiza	40	42	50	59
11	Tenisca	40	58	57	54
12	Panadería	40	65	64	53
13	Marino	40	48	50	50
14	AU Güímar	40	55	65	48
15	CD Buzanada	40	44	58	46
16	El Cotillo	40	38	60	44
17	Unión	40	28	53	41
18	Vera	40	45	61	38
19	Estrella	40	32	68	38
20	Llanos	40	40	78	31
21	Haría CF	40	29	83	19

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Palmas	38	92	20	94
2	Fernando	38	54	38	66
3	Villa Santa	38	64	44	65
4	Ibarra	38	61	41	65
5	Tenerife B	38	57	42	56
6	Marino	38	51	45	56
7	Union Yaiza	38	55	44	55
8	Panadería	38	52	49	55
9	Unión	38	45	50	51
10	CD Buzanada	38	45	48	51
11	Tenisca	38	66	70	51
12	Lanzarote	38	53	60	49
13	Las Zocas	38	43	56	48
14	El Cotillo	38	62	64	47
15	Estrella	38	40	42	46
16	Santa	38	54	61	44
17	Vera	38	44	60	44
18	Unión Viera	38	57	80	42
19	Arucas	38	41	58	37
20	Telde	38	22	86	20

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Villa Santa	38	59	26	81
2	Lanzarote	38	67	28	75
3	Palmas	38	70	37	73
4	Tenisca	38	60	38	71
5	Fernando	38	41	26	64
6	Las Zocas	38	47	34	63
7	El Cotillo	38	58	52	62
8	Telde	38	59	38	60
9	Tenerife B	38	56	36	59
10	Ibarra	38	63	46	57
11	Union Yaiza	38	47	43	52
12	Vera	38	59	52	52
13	Santa	38	41	47	47
14	Arucas	38	36	41	46
15	Unión Viera	38	44	54	43
16	Unión	38	36	61	37
17	Marino	38	35	67	33
18	Real	38	28	63	28
19	Cruz Santa	38	23	61	24
20	Granadilla	38	27	106	17

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Mensajero	38	61	35	71
2	Lanzarote	38	60	44	68
3	Marino	38	58	42	65
4	Real	38	57	38	60
5	Union Yaiza	38	40	35	56
6	Villa Santa	38	55	50	53
7	Tenerife B	38	53	42	52
8	Unión Viera	38	61	54	51
9	Arucas	38	46	52	50
10	Ibarra	38	51	58	49
11	Tenisca	38	54	48	47
12	Granadilla	38	45	53	47
13	Santa	38	41	49	47
14	El Cotillo	38	40	62	47
15	Telde	38	44	51	46
16	Las Zocas	38	53	67	46
17	Vera	38	56	69	45
18	Estrella	38	49	45	44
19	CD Laguna	38	45	58	44
20	Atletico	38	42	59	41

TEMPORADA 2013/2014

PREFERENTE CANARIAS GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Realejos B	34	73	39	69
2	Andrés	34	46	28	69
3	Valle Guerra	34	58	37	60
4	CD Laguna	34	48	23	59
5	Santa	34	50	40	59
6	Atlético	34	52	34	56
7	Ud Orotava	34	46	42	51
8	CD Buzanada	34	49	51	46
9	Atlético	34	50	61	41
10	Llanos	33	35	42	39
11	Charco Pino	34	33	39	38
12	Atlético	34	46	52	37
13	Fuencaliente	34	45	54	37
14	Arguijón	34	38	61	37
15	UD Icodense	34	46	70	36
16	Valle	34	38	49	35
17	Andrés	33	39	57	33
18	Zona Norte	34	52	65	31

TEMPORADA 2011/2012

PREFERENTE CANARIAS GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Raqui Isidro	34	62	39	70
2	UD Gomera	34	75	35	69
3	Lauburu	34	72	37	68
4	Orotava	34	62	32	67
5	Santa	34	44	37	51
6	At. Paso	34	49	44	51
7	UD Icodense	34	51	49	50
8	Andrés	34	45	44	50
9	Llanos	34	46	43	47
10	Valle	34	39	37	46
11	Zona Norte	34	55	70	42
12	Fuencaliente	34	49	51	39
13	Realejos	34	34	41	38
14	Valle Guerra	34	43	54	37
15	Arguijón	34	32	51	37
16	Victoria	34	41	57	35
17	Tegueste	34	43	55	33
18	Ud Médano	34	25	91	17

Competiciones que juega

Tercera Federación Grupo 12

Pos	Equipos		Pts
1		Tenerife B	77
2		Lanzarote	74
3		Union Sur Yaiza	73
4		Las Palmas At.	71
5		Panadería Pulido	55
6		Arucas	44
7		CD Santa Úrsula	43
8		San Bartolomé CF	42
9		Villa Santa Brígida	40
10		Tamaraceite	40
11		Marino	39
12		Herbania	38
13		CD Buzanada	36
14		Ibarra	33
15		Atletico Victoria	29
16		UD Teror	26
17		Gran Tarajal	24
18		Unión Puerto	19

	Ascenso : Tenerife B
	Playoff Ascenso : Lanzarote, Union Sur Yaiza, Las Palmas At., Panadería Pulido
	Descenso : UD Teror, Gran Tarajal, Unión Puerto

RIVALES EN Tercera Federaci.

USO DE MEMORIA

6,682,304 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.1320
Total Execution Time	0.1341

CADENA URL

/historico/Cd-Santa-Ursula

GET DATOS

$_GET['/historico/Cd-Santa-Ursula']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0032	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 = 'Cd-Santa-Ursula' 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.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=6141 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=6141 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038	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 = 72271
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6141 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6141 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024	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 (64844,129945,142085,143855,163354) ORDER BY n.cover_points DESC, update_date 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 = '6141' ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '6141' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '6141' 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 = 72271 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=6141 AND l.year in (2023,2024,2025) 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 (72271,67320) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 72271 AND teamId = 6141
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 6141
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* `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 = 72271 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '6141' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6141' and rp.type = 4
0.0021	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 = '6141' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032	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 = 72271 WHERE rp.league_id = 72271 AND rp.teamId = 6141 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.0029	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 = 72271 WHERE rp.league_id = 72271 AND rp.teamId = 6141 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 72271 WHERE rp.league_id = 72271 AND rp.teamId = 6141 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 6141 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72271 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.0022	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 = 67986 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.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* `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 = 62396 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.0022	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 = 58591 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.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* `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 = 50280 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 44400 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* `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 = 39036 AND t.round = 42 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* `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 = 33362 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* `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 = 15453 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* `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 = 3921 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* `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 = 2687 AND t.round = 34 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* `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 = 1472 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 72271 ORDER BY nameShow LIMIT 100

CD Santa Úrsula

CD Santa Úrsula

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 12

RIVALES EN Tercera Federaci.