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

UD Bellavista B

Temporada 2023/2024

TEMPORADA 2023/2024

3ª ANDALUZA SEVILLA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Triana CF	26	76	24	67
2	Cerro	26	58	33	52
3	Vistahermosa	27	62	39	51
4	Torre Reina	27	69	36	51
5	Club Atl. C.	26	44	21	50
6	Calavera	26	50	33	45
7	Union Gerena	26	67	46	41
8	Guillena Cf	27	50	42	41
9	Ciudad	26	62	41	40
10	Tabladilla	28	56	50	37
11	Atlético	26	51	54	30
12	Jeronimo	26	42	67	28
13	Bellavista	27	30	54	19
14	Colspe	26	23	88	12
15	Ventas	16	24	42	9
16	Atletico	26	20	114	2

TEMPORADA 2022/2023

3ª ANDALUZA SEVILLA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Real Betis	30	134	22	84
2	Colegio	30	92	38	73
3	Ciudad	30	79	36	64
4	Club Atl. C.	30	81	28	64
5	Torre Reina	30	70	48	54
6	Vistahermosa	30	85	51	53
7	Bellavista	30	58	51	52
8	Hermanas	30	78	69	43
9	Santiponce	30	72	68	39
10	Aznalcollar	30	48	65	38
11	Triana CF	30	57	54	36
12	Tabladilla	30	45	72	25
13	Atletico	30	61	99	23
14	AD. Carmona	30	30	88	12
15	Colspe	30	34	132	8
16	Einstein-P.	30	28	131	8

TEMPORADA 2021/2022

3ª ANDALUZA SEVILLA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Tomares	26	138	31	71
2	Triana CF	26	92	31	64
3	Bellavista	26	69	29	53
4	Club Atl. C.	26	75	40	52
5	Peña Betica	25	61	31	46
6	Mosquito CD	26	48	48	38
7	Colspe	26	54	49	32
8	Ciudad	26	46	44	32
9	Atletico	26	45	46	31
10	AD. Carmona	25	34	45	31
11	Atl. Oromana	26	56	74	30
12	Einstein-P.	26	32	66	18
13	C.D. Rabesa	26	37	78	13
14	CD Hispalis	26	13	188	6

TEMPORADA 2020/2021

3ª ANDALUZA SEVILLA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Calavera	27	61	25	64
2	Colegio	28	67	36	59
3	Atlético	27	68	34	55
4	Guadalcanal	26	60	49	47
5	Campana	26	61	45	44
6	CD Demo B	28	58	52	43
7	Ciudad	26	38	36	39
8	Cantillana	27	44	45	36
9	CD Alanis	27	52	56	33
10	Torre Reina	27	38	50	32
11	Priorato	25	41	59	32
12	Bellavista	27	47	60	24
13	Minas CF	17	20	28	15
14	Santa Olalla	22	37	74	14
15	Atletico	26	26	69	9

TEMPORADA 2019/2020

3ª ANDALUZA SEVILLA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Marchena	25	51	18	59
2	JD Bormujos	25	59	36	51
3	Marismillas	25	69	46	47
4	Colegio	25	64	34	46
5	Bellavista	25	47	27	44
6	Lebrijana	25	49	41	44
7	Ciudad	25	36	30	40
8	Cantarrana	25	49	42	39
9	Hermanas	25	39	45	36
10	Atl.	25	45	55	36
11	Ciudad	24	48	52	34
12	Huévar C.F.	25	50	50	30
13	Atlético	25	43	51	26
14	Palmar	24	29	41	26
15	Benacazón	25	29	46	20
16	Martin C.D.	24	29	57	17
17	Cuervo	25	28	57	17
18	Pilas	24	37	73	8

TEMPORADA 2018/2019

3ª ANDALUZA SEVILLA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Arahal	33	82	23	79
2	Roque	34	86	32	79
3	Montequinto	33	85	30	70
4	Juan Cala	33	68	44	62
5	Atlético	34	58	53	57
6	Atl.	33	88	64	55
7	La Motilla	34	71	59	55
8	Mairena	33	63	64	51
9	Lebrijana	33	43	38	50
10	Palmar	33	62	67	46
11	C.D. Rabesa	34	70	82	46
12	Bellavista	34	49	43	45
13	José	34	55	68	38
14	Hermanas	34	54	66	30
15	Almensilla	34	64	82	30
16	Pilas	34	31	66	27
17	Cantarrana	31	38	86	26
18	Marismillas	34	34	134	10

TEMPORADA 2017/2018

2ª ANDALUZA SEVILLA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alcalá Río	34	49	17	74
2	Camino Viejo	34	63	37	72
3	Rinconada	34	80	51	67
4	Hermanas	34	83	48	59
5	Andalucia	33	54	34	56
6	Puebla CF	34	87	50	55
7	Pilas	34	65	35	55
8	CD Albaida	33	64	55	55
9	Mosqueo	34	70	62	54
10	CDF Cazalla	34	73	54	52
11	UD Loreto	34	53	50	47
12	Atlético	33	57	70	44
13	Calavera	34	56	49	40
14	Atlético	34	54	89	33
15	Bellavista	34	38	75	26
16	Olivarense	34	43	103	25
17	UD Soleá	34	42	84	16
18	Benacazón	33	34	102	16

TEMPORADA 2016/2017

3ª ANDALUZA SEVILLA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Calavera	32	86	34	71
2	CD Albaida	33	81	28	69
3	Bellavista	33	82	43	68
4	Guillena Cf	33	80	41	65
5	Peñaflor	32	82	38	64
6	Aznalcollar	32	70	43	60
7	Pino Montano	33	69	66	44
8	Constantina	32	61	56	43
9	Cantillana	33	48	63	41
10	Guadalcanal	32	62	70	40
11	Liceo C.D.C.	33	57	67	40
12	Alcolea Río	32	54	74	40
13	Priorato	32	48	48	39
14	Minas CF	33	35	65	34
15	Castillo	32	55	115	27
16	Navas	33	51	105	24
17	Santiponce	32	45	84	19
18	C.D. Pedroso	12	15	41	7

TEMPORADA 2013/2014

3ª ANDALUZA SEVILLA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Santiponce	30	72	20	70
2	Eminencia	30	80	31	66
3	Gelves C.D	30	69	48	57
4	C.D.	30	63	39	51
5	Almensilla	30	54	45	51
6	Aznalcollar	30	66	41	51
7	Mairena	30	60	41	49
8	Centro	30	61	60	44
9	Pilas	30	42	50	44
10	Bellavista	30	51	44	40
11	Carrión	30	36	45	35
12	Aznalcazar,	30	48	70	30
13	Umbrete	30	40	67	29
14	Hermanas	30	39	81	20
15	Martin	30	36	72	20
16	Buhaira	30	34	97	15

TEMPORADA 2012/2013

3ª ANDALUZA SEVILLA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Antonio	30	89	33	74
2	Mairena	30	96	32	66
3	San Gines	30	69	39	66
4	Atlético	30	92	41	60
5	Padre Pío	29	71	41	55
6	Pilas	30	56	47	51
7	Atlético	30	49	56	47
8	Umbrete	29	66	59	46
9	Bellavista	30	56	52	43
10	Nueva	30	44	36	39
11	Claret C.F.	30	51	72	35
12	Buhaira	30	55	78	35
13	Mures CF	30	30	69	22
14	Olivarense	30	46	92	21
15	Espartinas	30	35	95	16
16	Hermanas	30	23	86	7

TEMPORADA 2010/2011

3ª ANDALUZA SEVILLA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	JD Bormujos	32	91	47	70
2	Montequinto	32	65	34	70
3	San Gines	32	51	28	68
4	Antonio	32	85	37	62
5	Hermanas	32	88	59	58
6	Pinzón CD	32	65	59	51
7	Tinte Utrera	32	73	48	50
8	Almensilla	32	55	60	49
9	Buhaira	32	59	60	42
10	Espartinas	32	69	90	42
11	Círculo	32	57	64	40
12	Trobal	32	50	70	40
13	Mota Cuervo	32	48	60	36
14	Bellavista	32	58	65	34
15	Mairena	32	58	81	28
16	Pilas	32	39	70	27
17	Olivarense	32	24	103	8

Competiciones que juega

Grupo 4

3ª Andaluza Sevilla Grupo 4

Pos	Equipos		Pts
1		Triana CF	67
2		A. Cerro Águila	52
3		Vistahermosa C.F.	51
4		Torre Reina CD	51
5		Club Atl. Central B	50
6		Calavera	45
7		Union Gerena	41
8		Guillena Cf	41
9		Ciudad Jardin	40
10		CD Tabladilla	37
11		Atlético Libertad	30
12		San Jeronimo	28
13		UD Bellavista B	19
14		AA. AA. Colspe	12
15		Ventas de las Pajanosas	9
16		CD Atletico Sumi	2

	Ascenso : Triana CF
	Playoff Ascenso : A. Cerro Águila, Vistahermosa C.F.

RIVALES EN 3ª Andaluza Sevi.

USO DE MEMORIA

6,074,824 bytes

BENCHMARKS

Loading Time Base Classes	0.0017
Controller Execution Time ( Home / Category )	0.6030
Total Execution Time	0.6047

CADENA URL

/historico/Union-Deportiva-Bellavista-B

GET DATOS

$_GET['/historico/Union-Deportiva-Bellavista-B']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0160	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 = 'Union-Deportiva-Bellavista-B' 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.0145	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=102847 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=102847 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294	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 = 73751
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=102847 AND type_rel = 2
0.0148	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 = '102847' ORDER BY l.year DESC,cat.coefficient DESC
0.0148	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 = '102847' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0146	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 = '102847' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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 = 73751 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	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=102847 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (73751) 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.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 73751 AND teamId = 102847
0.0151	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 = 73751 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146	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 = '102847' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '102847' and rp.type = 4
0.0146	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 = '102847' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147	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 = 73751 WHERE rp.league_id = 73751 AND rp.teamId = 102847 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.0146	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 = 73751 WHERE rp.league_id = 73751 AND rp.teamId = 102847 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 = 73751 WHERE rp.league_id = 73751 AND rp.teamId = 102847 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148	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 = 102847 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149	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 = 73751 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.0149	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 = 69280 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.0151	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 = 64476 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.0149	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 = 60374 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.0149	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 = 51520 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.0149	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 = 45328 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 39685 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 35348 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 3017 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 3016 AND t.round = 30 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* `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 = 3005 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 73751 ORDER BY nameShow LIMIT 100

UD Bellavista B

UD Bellavista B

Selecciona un equipo

Competiciones que juega

3ª Andaluza Sevilla Grupo 4

RIVALES EN 3ª Andaluza Sevi.