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

Ourense UD

Entrenador: De Dios

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bergantiños	32	47	18	70
2	Celta Gran.	32	46	30	57
3	Arosa	32	36	21	54
4	Ourense UD	32	44	34	51
5	SD Sarriana	32	42	29	50
6	At. Arteixo	32	45	35	47
7	Alondras CF	32	37	34	43
8	Silva SD	32	35	32	43
9	CD Lugo B	32	32	32	43
10	Estradense	32	29	30	42
11	Viveiro	32	37	41	40
12	Betanzos CF	32	34	31	39
13	Somozas	32	38	39	39
14	Rápido	32	33	38	39
15	Barbadás	32	30	34	38
16	UD Paiosaco	32	29	39	38
17	Pontevedra	32	25	61	23
18	CSD Arzua	32	23	64	15

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	30	47	18	61
2	Arosa	30	45	26	58
3	Rápido	30	39	24	56
4	Villalbés	30	35	24	46
5	Ourense UD	30	38	30	45
6	Alondras CF	30	36	29	41
7	At. Arteixo	30	37	42	41
8	Somozas	30	32	37	40
9	Estradense	30	33	38	39
10	Celta Gran.	30	47	37	38
11	UD Paiosaco	30	31	42	37
12	Silva SD	30	38	46	37
13	Viveiro	30	29	37	37
14	CSD Arzua	30	28	48	31
15	Barco	30	26	38	31
16	Choco	30	27	52	15

TEMPORADA 2021/2022

PREFERENTE GALICIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Ourense UD	10	20	6	29
2	Celta Gran.	10	14	11	23
3	Pontevedra	10	23	19	20
4	Portonovo	10	17	13	20
5	Barbadás	10	14	15	20
6	Umia	10	19	14	17
7	Cultural	10	16	17	15
8	Villalonga	10	9	15	12
9	Pontellas	10	12	23	8
10	Verín	10	10	21	8

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bergantiños	22	37	16	48
2	CD Lugo B	22	34	17	42
3	Somozas	22	41	21	41
4	Villalbés	22	34	26	40
5	Deportivo	22	41	27	32
6	Silva SD	22	21	20	30
7	CSD Arzua	22	32	23	29
8	Viveiro	22	25	39	28
9	Estudiantil	22	27	45	20
10	As Pontes	22	18	40	19
11	SD Fisterra	22	22	35	17
12	UD Paiosaco	22	16	39	12
13	Arenteiro	22	33	13	47
14	Arosa	22	27	14	41
15	Alondras CF	22	31	15	37
16	Estradense	22	35	34	31
17	Choco	22	28	22	31
18	Rápido	22	25	25	31
19	Barco	22	26	27	30
20	Ourense CF	22	33	29	28
21	Ribadumia	22	24	36	26
22	Ourense UD	22	25	32	25
23	UD Atios	22	18	32	20
24	Pontellas	22	12	38	9

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Compostela	27	50	15	61
2	Ourense CF	27	50	21	60
3	Arosa	27	42	31	47
4	Barco	27	40	40	47
5	Choco	27	40	28	43
6	CSD Arzua	27	40	39	41
7	Deportivo	27	38	28	40
8	Ourense UD	27	32	36	40
9	Arenteiro	27	29	31	35
10	Estradense	27	33	32	35
11	CD Lugo B	27	51	33	35
12	Silva SD	27	24	25	35
13	Bergantiños	27	27	31	34
14	Villalbés	27	30	30	34
15	Somozas	27	31	43	32
16	Alondras CF	27	32	45	32
17	As Pontes	27	39	44	28
18	Rápido	27	36	54	23
19	Pontellas	27	22	56	20
20	UD Paiosaco	27	23	47	17

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	80	35	78
2	Bergantiños	38	58	42	74
3	Compostela	38	80	47	68
4	Alondras CF	38	47	36	65
5	Barco	38	58	43	64
6	Ourense CF	38	51	24	64
7	Choco	38	59	47	59
8	Ourense UD	38	45	39	59
9	Arosa	38	57	44	57
10	CD Lugo B	38	55	53	52
11	Villalbés	38	47	48	52
12	Silva SD	38	52	56	48
13	Arenteiro	38	41	53	47
14	Somozas	38	45	52	46
15	UD Paiosaco	38	46	59	45
16	Céltiga FC	38	36	66	41
17	Laracha	38	42	49	40
18	Ribadumia	38	41	65	38
19	Boiro	38	34	79	31
20	Porriño	38	37	74	27

TEMPORADA 2017/2018

PREFERENTE GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ourense UD	38	70	29	79
2	Porriño	38	77	37	79
3	UD Atios	38	80	35	76
4	Estradense	38	74	36	71
5	CD Moaña	38	71	40	66
6	SD Bande	38	60	44	66
7	Sanxenxo	38	80	56	62
8	USD O Grove	38	63	58	60
9	CD Beluso	38	73	64	56
10	Pontellas	38	73	63	52
11	Valladares	38	55	71	51
12	Mondariz CF	38	50	65	48
13	Alertanavia	38	53	60	46
14	Marcón	38	45	78	46
15	Caselas	38	57	67	45
16	Campo	38	46	59	45
17	Gondomar Cf	38	63	89	38
18	Erizana	38	57	77	34
19	Nogueira	38	31	67	28
20	Ribeiro FC	38	26	109	14

TEMPORADA 2016/2017

PRIMERA GALICIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	SD Bande	33	102	22	90
2	Ourense UD	33	81	25	81
3	Ribeiro FC	34	68	34	60
4	CD Velle	34	72	44	57
5	At. Arnoia	34	77	61	54
6	Maside	34	68	59	54
7	CD Allariz	34	53	56	49
8	Monterrey	34	46	54	48
9	Atletico	34	50	55	47
10	Sporting	34	62	62	44
11	Antela FC	34	53	67	43
12	A Peroxa CF	34	56	68	42
13	Francelos	34	52	68	39
14	Viana	34	58	94	39
15	Cortegada	34	40	56	37
16	Taboadela	34	43	72	32
17	A Manchica	34	49	85	23
18	Xunqueira	34	37	85	16

TEMPORADA 2015/2016

SEGUNDA GALICIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Ourense UD	34	135	37	86
2	At. Arnoia	34	78	36	76
3	Loñoá	34	99	54	66
4	Arrabaldo	34	90	61	64
5	Santa	34	91	54	62
6	Amoeiro	34	71	45	62
7	Covadonga	34	96	75	57
8	Ribadavia	34	70	75	43
9	CD Cea	34	57	75	41
10	Melias	34	77	76	39
11	Atlético	34	65	84	39
12	Leiro	34	55	65	39
13	Caldelao	34	49	82	38
14	Palmes CD	34	65	94	35
15	Coles	34	46	85	31
16	Barra Miño	34	56	103	30
17	Trives	34	45	90	28
18	Atlético	34	44	98	20

TEMPORADA 2014/2015

TERCERA GALICIA GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Ourense UD	27	156	10	81
2	Palmes CD	27	96	48	68
3	Ribadavia	27	86	49	53
4	Barra Miño	27	78	48	51
5	Cenlle CD	27	61	50	50
6	Sporting	27	78	47	48
7	Parada	26	64	51	36
8	A Peroxa B	27	59	70	36
9	Salamonde	26	50	63	28
10	Loureiro CF	27	43	80	27
11	Piñor SD	27	38	66	25
12	Razamonde	27	39	68	23
13	Arcos CF	14	33	29	20
14	Castrelo	27	41	96	18
15	Os Chaos CF	27	11	158	0

Competiciones que juega

Tercera Federación Grupo 1

Pos	Equipos		Pts
1		Bergantiños FC	70
2		Celta C – Gran Peña	57
3		Arosa	54
4		Ourense UD	51
5		SD Sarriana	50
6		At. Arteixo	47
7		Alondras CF	43
8		Silva SD	43
9		CD Lugo B	43
10		CD Estradense	42
11		Viveiro	40
12		Betanzos CF	39
13		Somozas	39
14		Rápido de Bouzas	39
15		Barbadás	38
16		UD Paiosaco	38
17		Pontevedra B	23
18		CSD Arzua	15

	Ascenso : Bergantiños FC
	Playoff Ascenso : Celta C – Gran Peña, Arosa, Ourense UD, SD Sarriana
	Descenso : UD Paiosaco, Pontevedra B, CSD Arzua

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

6,474,536 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1430
Total Execution Time	0.1443

CADENA URL

/historico/Ourense-Ud

GET DATOS

$_GET['/historico/Ourense-Ud']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0046	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 = 'Ourense-Ud' 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.0022	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=27634 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=27634 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024	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=27634 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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=27634 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0055	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 = 72260
0.0045	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 = 72729
0.0022	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27634 AND type_rel = 2
0.0029	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 27634 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0036	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 (300426,351981,750598,822157,886617) ORDER BY n.cover_points DESC, update_date DESC
0.0037	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 = '27634' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 72729 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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 = 72260 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032	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=27634 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0027	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 (72729,72260,71489,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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72260 AND teamId = 27634
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 27634
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72729 AND teamId = 27634
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 27634
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72260 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '27634' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '27634' and rp.type = 4
0.0022	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 = '27634' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038	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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 27634 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.0030	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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 27634 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 27634 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 27634 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 = 72260 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 67975 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 = 64091 AND t.round = 26 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* `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 = 67010 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 58579 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 = 50269 AND t.round = 27 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 = 44389 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 39343 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 34038 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 16825 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* `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 = 5016 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Ourense UD

Ourense UD

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 1

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.