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

Resultados de Fútbol

Ue Sant Andreu

Temporada 2022/2023

TEMPORADA 2022/2023

DIVISIÓN HONOR CATALANA CADETE
Equipo		PJ	GF	GC	Puntos
1	Barcelona	30	107	11	83
2	Espanyol	30	85	25	75
3	Damm	30	60	44	53
4	Sant Cugat.	30	44	39	51
5	Girona	30	64	49	50
6	Cornellà	30	42	35	44
7	Riuprimer	30	30	42	42
8	Gimnàstic	30	35	41	40
9	Gimnastic	30	30	40	37
10	Sant Gabriel	30	34	34	36
11	Fundación	30	39	58	35
12	Escola Gava	30	31	61	30
13	Granollers	30	37	57	27
14	Segre A	30	26	54	26
15	Sant Andreu	30	27	58	22
16	Cf Badalona	30	20	63	17

TEMPORADA 2021/2022

DIVISIÓN HONOR CATALANA CADETE
Equipo		PJ	GF	GC	Puntos
1	Barcelona	30	103	23	81
2	Espanyol	29	65	24	65
3	Damm	29	63	37	63
4	Girona	30	76	41	51
5	Granollers	29	43	39	46
6	Fundación	30	46	48	46
7	Sant Andreu	30	56	49	45
8	Gimnastic	30	41	38	41
9	Gimnàstic	28	31	30	40
10	Sant Gabriel	29	41	40	37
11	Escola Gava	30	43	55	34
12	Sant Cugat.	28	25	54	27
13	Atletic Sant	29	29	58	24
14	Vilassar	30	26	58	21
15	Sabadell	30	34	79	21
16	Manresa	29	32	81	20

TEMPORADA 2020/2021

DIVISIÓN HONOR CATALANA CADETE
Equipo		PJ	GF	GC	Puntos
1	Espanyol	2	7	1	6
2	Sant Andreu	2	6	0	6
3	Barcelona	2	6	1	6
4	Fundación	2	6	3	6
5	Gimnastic	2	6	2	4
6	Girona	2	7	4	4
7	Manresa	2	4	3	4
8	Escola Gava	2	3	3	3
9	Gimnàstic	2	4	5	1
10	Granollers	2	2	4	1
11	Damm	2	2	4	1
12	Llagostera	2	2	5	0
13	Europa	2	3	7	0
14	Jabac	1	1	5	0
15	Cornellà	1	0	4	0
16	Sant Gabriel	2	1	9	0

TEMPORADA 2019/2020

DIVISIÓN HONOR CATALANA CADETE
Equipo		PJ	GF	GC	Puntos
1	Barcelona	19	64	11	55
2	Espanyol	19	51	5	52
3	Girona	20	47	25	44
4	Damm	20	45	21	39
5	Fundación	21	25	23	30
6	Gimnastic	21	34	30	28
7	Gimnàstic	21	27	35	28
8	Cornellà	20	18	24	26
9	Sant Gabriel	21	29	38	23
10	Sant Andreu	20	20	28	21
11	Granollers	20	28	39	19
12	Jabac	21	18	37	19
13	Escola Gava	20	17	41	19
14	Llagostera	20	22	41	18
15	Manresa	21	15	40	18
16	Europa	20	20	42	11

TEMPORADA 2018/2019

DIVISIÓN HONOR CATALANA CADETE
Equipo		PJ	GF	GC	Puntos
1	Barcelona	30	86	17	70
2	Espanyol	30	59	19	65
3	Girona	28	66	24	60
4	Cornellà	29	63	26	60
5	Gimnastic	29	43	31	54
6	Gimnàstic	28	39	30	44
7	Sant Andreu	30	45	38	44
8	Jabac	29	32	32	43
9	Damm	30	46	53	37
10	Sant Gabriel	29	35	44	33
11	Llagostera	30	29	49	30
12	Escola Gava	28	23	32	27
13	Mercantil A	29	37	56	26
14	AEC Manlleu	29	24	69	23
15	Segre	30	26	81	18
16	Rapitenca	30	18	70	12

TEMPORADA 2017/2018

PREFERENTE CATALANA CADETE GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Espanyol	30	102	26	78
2	Sant Andreu	29	68	19	70
3	Damm	30	69	41	58
4	Sants	29	65	41	58
5	Cornella C	30	53	31	54
6	Sant Gabriel	30	48	34	49
7	Jupiter A	30	51	45	48
8	L'hospitalet	30	47	42	42
9	Europa B	29	51	37	40
10	Cf Badalona	30	56	55	38
11	Vidalet	29	34	42	35
12	Martinenc A	29	40	60	30
13	Sarria	30	33	62	28
14	Montañesa	29	35	80	18
15	Manlleu B	30	41	99	16
16	Espluguenc	30	19	98	6

TEMPORADA 2016/2017

PREFERENTE CATALANA CADETE GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Espanyol	30	92	26	75
2	Sant Cugat	29	92	33	65
3	Sant Andreu	30	75	42	61
4	Damm	30	78	41	60
5	Europa	30	54	36	55
6	Sant	30	50	41	51
7	Vidalet	29	50	45	43
8	Sarria	30	47	43	43
9	L'hospitalet	30	38	58	34
10	Montañesa	30	35	57	34
11	Grama A	30	41	61	31
12	Martinenc A	30	40	67	29
13	Sants	30	38	72	24
14	Escola	30	40	91	23
15	Santa	29	37	67	22
16	Llefia A	29	28	55	20

TEMPORADA 2015/2016

PREFERENTE CATALANA CADETE GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Espanyol	30	100	19	84
2	L'Hospitalet	30	80	37	65
3	Sant Andreu	30	71	35	62
4	Damm	29	41	25	50
5	Sants	30	48	45	44
6	Cornella C	30	61	57	41
7	Europa	30	50	46	41
8	Sant	30	38	43	38
9	Santa	29	42	52	37
10	Sant Cugat	30	41	63	36
11	Vidalet	30	39	52	34
12	Sarria	30	38	55	31
13	Horta A	30	43	63	30
14	Jupiter A	30	32	78	29
15	Badalona B	30	42	69	26
16	Escola Gava	30	46	73	21

TEMPORADA 2014/2015

DIVISIÓN HONOR CATALANA CADETE
Equipo		PJ	GF	GC	Puntos
1	Barcelona	30	115	18	80
2	Espanyol	30	71	31	70
3	Cornellà	30	54	25	54
4	Jabac	30	53	38	53
5	Gimnàstic	30	53	48	49
6	Damm	30	46	34	44
7	Gironès-Sà	30	39	48	43
8	Girona	30	46	53	42
9	Cf Badalona	30	50	54	40
10	Escola	30	35	40	35
11	Lleida	30	36	52	33
12	Mataró EFCE	30	40	53	30
13	Sant Cugat.	30	27	60	29
14	Sant Andreu	30	32	67	29
15	Bordeta	30	24	61	25
16	Rapitenca	30	31	70	18

TEMPORADA 2013/2014

DIVISIÓN HONOR CATALANA CADETE
Equipo		PJ	GF	GC	Puntos
1	Barcelona	30	95	23	82
2	Espanyol	30	75	25	68
3	Cornellà	30	61	37	62
4	Girona	30	63	39	49
5	Jabac	30	42	32	46
6	Club	30	49	43	44
7	Damm	30	52	45	43
8	Sant Andreu	30	54	51	38
9	Escola	30	39	44	36
10	Gironès-Sà	30	32	58	36
11	Lleida	30	38	45	33
12	Bordeta	30	42	57	33
13	AEC Manlleu	30	29	67	30
14	Sabadell	30	35	59	25
15	Europa	30	34	69	24
16	Ce Manresa	30	28	74	23

TEMPORADA 2011/2012

DIVISIÓN HONOR CATALANA CADETE
Equipo		PJ	GF	GC	Puntos
1	Barcelona	30	113	19	81
2	Espanyol	30	76	19	75
3	Gimnàstic	30	57	28	59
4	Cornellà	30	43	34	49
5	Girona	30	52	47	49
6	Cf Badalona	30	55	59	46
7	Jabac	30	44	43	44
8	Club Lleida	30	55	47	43
9	Damm	30	50	58	38
10	Europa	30	41	58	35
11	Mercantil	30	25	48	32
12	Ce Manresa	30	33	46	32
13	Sant Andreu	30	39	69	31
14	Vilassar	30	37	54	29
15	Escola	30	29	69	17
16	Ce Premià	30	26	77	17

Competiciones que juega

RIVALES EN División Honor C.

USO DE MEMORIA

5,912,440 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1349
Total Execution Time	0.1361

CADENA URL

/historico/Ue-Sant-Andreu-Cadete

GET DATOS

$_GET['/historico/Ue-Sant-Andreu-Cadete']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0025	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 = 'Ue-Sant-Andreu-Cadete' 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.0056	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 = 'Ue-Sant-Andreu-Cadete' 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.0019	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=7681 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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=7681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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 = 68629
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7681 AND type_rel = 2
0.0036	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 = '7681' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0031	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 = '7681' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026	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 = '7681' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 68629 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=7681 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (68629) 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.0019	SELECT count(id) as num_players from rel_players_base WHERE league_id = 68629 AND teamId = 7681
0.0020	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68629 AND t.round = 30 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 = '7681' 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 = '7681' and rp.type = 4
0.0023	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 = '7681' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026	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 = 7681 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables2023_base` 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 = 68629 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.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* `tables2022_base` 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 = 64563 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.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* `tables2021_base` 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 = 59251 AND t.round = 7 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_base` 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 = 52961 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.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* `tables2019_base` 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 = 45900 AND t.round = 30 ORDER BY team.conference 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* `tables2018_base` 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 = 40131 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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_base` 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 = 34324 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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_base` 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 = 17244 AND t.round = 30 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_base` 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 = 4296 AND t.round = 30 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* `tables2014_base` 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 = 2815 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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_base` 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 = 1751 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Ue Sant Andreu

Ue Sant Andreu

Selecciona un equipo

Competiciones que juega

RIVALES EN División Honor C.