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

Mendrisio-Stabio

Temporada 2023/2024

TEMPORADA 2023/2024

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	YF Juventus	25	53	31	47
2	Tuggen	26	49	27	44
3	Mendrisio-St	26	36	31	44
4	Kreuzlingen	25	50	33	43
5	Winterthur	26	46	31	41
6	Wettswil-Bon	26	46	36	41
7	Eschen/Maure	26	45	32	40
8	Grasshopper	26	37	39	35
9	Linth 04	25	36	46	33
10	Hongg	26	27	36	32
11	Freienbach	26	28	46	31
12	Taverne	26	27	29	30
13	Uzwil	26	34	38	29
14	Kosova	26	23	35	28
15	FC Balzers	26	28	47	23
16	FC Gossau	25	36	64	19

TEMPORADA 2022/2023

QUINTA SUIZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mendrisio-St	27	71	21	67
2	Zug 94	28	58	27	55
3	Collina	28	39	33	45
4	SC Cham 2	28	38	40	44
5	Brunnen	28	45	37	41
6	Gambarogno	28	26	22	40
7	SC Emmen	28	40	43	40
8	Ascona	28	45	43	39
9	Kickers	28	42	40	36
10	Perlen-Buchr	27	40	38	36
11	Buochs	28	44	44	33
12	FC Sursee	28	38	48	32
13	Ibach	28	36	50	31
14	Hergiswil	28	32	46	27
15	Eschenbach	28	22	84	10

TEMPORADA 2021/2022

QUINTA SUIZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Taverne	26	54	30	56
2	Emmenbrücke	26	72	39	51
3	Ascona	26	59	42	45
4	Gambarogno	26	36	27	45
5	Perlen-Buchr	26	40	38	42
6	Kickers	26	39	32	40
7	Mendrisio-St	26	40	35	37
8	Ibach	26	44	49	37
9	Hergiswil	26	36	32	32
10	Brunnen	26	40	51	31
11	Eschenbach	26	42	56	31
12	Novazzano	26	37	62	26
13	Goldau	26	56	66	24
14	Schattdorf	26	36	72	19

TEMPORADA 2020/2021

QUINTA SUIZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Team Ticino	13	24	17	28
2	Taverne	13	22	8	27
3	Emmenbrücke	13	39	17	26
4	Mendrisio-St	13	28	15	25
5	Hergiswil	13	26	17	24
6	Brunnen	13	18	16	21
7	Ibach	13	15	18	19
8	Kickers	13	25	16	18
9	Perlen-Buchr	13	20	22	14
10	Gambarogno	13	13	20	13
11	FC Sursee	13	17	30	13
12	Novazzano	13	17	24	12
13	Willisau	13	18	38	8
14	Sarnen	13	9	33	4

TEMPORADA 2019/2020

QUINTA SUIZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Willisau	14	33	16	33
2	Mendrisio-St	14	29	14	31
3	Rotkreuz	14	40	25	28
4	Ibach	14	22	27	23
5	Novazzano	14	33	27	22
6	Emmenbrücke	13	30	21	21
7	Gambarogno	14	17	13	20
8	Kickers	14	24	21	20
9	Taverne	13	20	16	19
10	Perlen-Buchr	14	27	28	19
11	Hergiswil	14	19	26	19
12	FC Sursee	14	22	27	15
13	Aegeri	14	18	31	12
14	Brunnen	14	12	34	10
15	Sarnen	14	14	34	6

TEMPORADA 2018/2019

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Baden	26	68	34	57
2	Tuggen	26	76	38	55
3	Eschen/Maure	26	67	41	54
4	Wettswil-Bon	26	48	32	51
5	Star Zürich	26	51	43	43
6	Kosova	26	55	48	37
7	Gallen	26	64	53	36
8	Hongg	26	46	48	36
9	Linth 04	26	57	57	34
10	Winterthur	26	48	46	33
11	FC Thalwil	26	27	46	25
12	FC Gossau	26	34	61	22
13	Mendrisio-St	26	23	51	13
14	United	26	30	96	12

TEMPORADA 2017/2018

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bellinzona	26	68	25	66
2	Star Zürich	26	41	37	42
3	Mendrisio-St	26	33	31	41
4	FC Gossau	26	50	49	40
5	Gallen	26	54	48	36
6	FC Thalwil	26	34	39	34
7	Tuggen	26	46	48	33
8	Wettswil-Bon	26	33	40	32
9	Winterthur	26	47	51	31
10	Kosova	26	42	42	31
11	Hongg	26	42	45	31
12	Eschen/Maure	26	37	44	31
13	Seuzach	26	42	51	31
14	FC Balzers	26	28	47	25

TEMPORADA 2016/2017

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FC Gossau	26	54	40	51
2	Grasshopper	26	61	34	48
3	Bellinzona	26	63	37	48
4	Wettswil-Bon	26	39	39	42
5	Gallen	26	51	39	41
6	Eschen/Maure	26	40	35	40
7	Mendrisio-St	26	40	36	39
8	Star Zürich	26	48	47	37
9	Winterthur	26	42	45	33
10	FC Thalwil	26	43	49	33
11	FC Balzers	26	41	46	30
12	Seuzach	26	34	60	27
13	Seefeld	26	29	48	25
14	Locarno	26	22	52	15

TEMPORADA 2015/2016

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Baden	26	58	36	51
2	Grasshopper	26	49	33	48
3	United	26	45	33	46
4	Winterthur	26	41	33	38
5	FC Gossau	26	45	46	37
6	Locarno	26	34	30	36
7	Mendrisio-St	26	42	30	35
8	FC Thalwil	26	34	41	35
9	Seuzach	26	45	48	33
10	Wettswil-Bon	26	37	43	30
11	Eschen/Maure	26	41	43	29
12	FC Balzers	26	33	43	29
13	Dietikon	26	35	59	26
14	Kosova	26	33	54	24

TEMPORADA 2014/2015

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Wettswil-Bon	26	59	27	56
2	FC Gossau	26	55	38	49
3	Baden	26	54	32	46
4	Grasshopper	26	54	32	44
5	FC Muri	26	46	45	43
6	Mendrisio-St	26	29	28	40
7	Winterthur	26	52	45	39
8	Eschen/Maure	26	51	46	37
9	FC Balzers	26	39	37	37
10	Seuzach	26	41	45	34
11	Dietikon	26	36	54	27
12	FC Thalwil	26	24	43	21
13	Lugano II	26	31	55	21
14	Taverne	26	24	68	15

TEMPORADA 2013/2014

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Eschen/Maure	26	60	37	49
2	Rapperswil	26	55	33	44
3	SC Cham	26	51	43	41
4	Zug 94	26	43	39	40
5	FC Gossau	26	45	53	39
6	FC Balzers	26	37	31	38
7	Wettswil-Bon	26	37	33	37
8	Mendrisio-St	26	35	31	37
9	FC Muri	26	44	49	37
10	FC Thalwil	26	39	34	33
11	Team Ticino	26	32	45	31
12	Winterthur	26	30	39	29
13	Chur 97	26	43	65	26
14	Hongg	26	36	55	25

TEMPORADA 2012/2013

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	SC Cham	26	61	34	51
2	Zug 94	26	44	22	51
3	Wettswil-Bon	26	46	32	43
4	Eschen/Maure	26	56	41	41
5	Mendrisio-St	26	40	32	40
6	FC Gossau	26	39	37	38
7	Rapperswil	26	34	31	35
8	Lugano II	26	32	38	33
9	FC Muri	26	34	42	33
10	Winterthur	26	41	50	33
11	Hongg	26	33	45	31
12	FC Balzers	26	29	38	30
13	Kreuzlingen	26	34	46	27
14	Biaschesi	26	21	56	14

TEMPORADA 2011/2012

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tuggen	30	69	31	69
2	Schaffhausen	30	88	28	66
3	YF Juventus	30	83	34	64
4	Eschen/Maure	30	56	43	53
5	Gallen	30	52	43	50
6	Rapperswil	30	60	51	47
7	SC Cham	30	58	46	45
8	Mendrisio-St	30	38	33	42
9	Luzern II	30	56	59	40
10	FC Balzers	30	48	66	35
11	Winterthur	30	37	57	32
12	Biaschesi	30	39	53	29
13	Lugano II	30	36	64	28
14	FC Muri	30	35	66	28
15	Hongg	30	31	70	23
16	FC Gossau	30	42	84	20

TEMPORADA 2010/2011

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	SC Bruhl	30	47	29	57
2	Tuggen	30	64	43	54
3	Baden	30	57	35	53
4	Rapperswil	30	60	44	50
5	YF Juventus	30	59	41	49
6	Eschen/Maure	30	59	50	48
7	SC Cham	30	51	42	48
8	Luzern II	30	57	50	45
9	Winterthur	30	53	51	42
10	Gallen	30	59	59	42
11	Biaschesi	30	48	49	37
12	Mendrisio-St	30	39	47	33
13	Lugano II	30	39	50	32
14	FC Gossau	30	46	72	32
15	Zug 94	30	47	65	31
16	Buochs	30	32	90	13

TEMPORADA 2009/2010

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Chiasso	30	63	26	64
2	Rapperswil	30	69	44	61
3	Tuggen	30	69	48	51
4	Baden	30	59	34	49
5	Luzern II	30	44	43	46
6	Zug 94	30	48	55	44
7	Mendrisio-St	30	34	38	42
8	Biaschesi	30	45	53	41
9	Eschen/Maure	30	53	57	40
10	Gallen	30	48	59	38
11	SC Zofingen	30	53	56	37
12	Lugano II	30	44	54	36
13	Schotz	30	43	54	34
14	SC Cham	30	35	43	33
15	Emmenbrücke	30	43	54	33
16	Chur 97	30	32	64	26

TEMPORADA 2008/2009

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Chiasso	30	69	28	68
2	Tuggen	30	70	35	62
3	Rapperswil	30	63	35	61
4	Zurich	30	63	41	54
5	Eschen/Maure	30	47	36	52
6	Hongg	30	44	45	44
7	Baden	30	51	44	43
8	YF Juventus	30	53	43	42
9	Grasshopper	29	53	56	40
10	Gallen	29	51	60	35
11	Winterthur	30	47	51	34
12	Schaffhausen	30	40	46	34
13	Biaschesi	30	37	62	31
14	Mendrisio-St	30	31	52	30
15	Kreuzlingen	30	35	82	20
16	Star Zürich	30	28	66	13

TEMPORADA 2007/2008

CUARTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Baden	30	56	31	63
2	Biaschesi	30	62	31	61
3	Rapperswil	30	63	34	56
4	Schaffhausen	30	67	45	56
5	Grasshopper	30	67	44	53
6	Tuggen	30	55	37	50
7	Star Zürich	30	44	40	45
8	Winterthur	30	55	50	39
9	Zurich	30	59	55	39
10	Mendrisio-St	30	41	42	39
11	Gallen	30	52	53	38
12	YF Juventus	30	43	57	33
13	Kreuzlingen	30	31	53	28
14	FC Brugg	30	34	68	23
15	Küsnacht	30	37	85	21
16	Herisau	30	29	70	20

Competiciones que juega

Grupo 3

Cuarta Suiza Grupo 3

Pos	Equipos		Pts
1		YF Juventus	47
2		Tuggen	44
3		Mendrisio-Stabio	44
4		Kreuzlingen	43
5		Winterthur II	41
6		FC Wettswil-Bonstetten	41
7		Eschen/Mauren	40
8		Grasshopper II	35
9		Linth 04	33
10		Hongg	32
11		Freienbach	31
12		Taverne	30
13		Uzwil	29
14		Kosova	28
15		FC Balzers	23
16		FC Gossau	19

	Playoff Ascenso : YF Juventus, Tuggen
	Posible siguiente ronda : Mendrisio-Stabio
	Descenso : FC Balzers, FC Gossau

RIVALES EN Copa Suiza

RIVALES EN Erste Liga Cup

RIVALES EN Cuarta Suiza

USO DE MEMORIA

7,303,544 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.5673
Total Execution Time	0.5691

CADENA URL

/historico/Mendrisio-Stabio

GET DATOS

$_GET['/historico/Mendrisio-Stabio']

POST DATOS

No hay datos POST existentes

CONSULTAS (28)

0.0147	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12879 AND type_rel = 2
0.0156	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 = '12879' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156	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=12879 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0154	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 (72765,72694,72510,71432,68403) 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.0162	SELECT count(id) as num_players from rel_players WHERE league_id = 72694 AND teamId = 12879
0.0159	SELECT count(id) as num_players from rel_players WHERE league_id = 68403 AND teamId = 12879
0.0170	SELECT count(id) as num_players from rel_players WHERE league_id = 72510 AND teamId = 12879
0.0169	SELECT count(id) as num_players from rel_players WHERE league_id = 72765 AND teamId = 12879
0.0172	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12879
0.0255	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 = 72694 WHERE rp.league_id = 72694 AND rp.teamId = 12879 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.0164	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 = 72694 WHERE rp.league_id = 72694 AND rp.teamId = 12879 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	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 = 72694 WHERE rp.league_id = 72694 AND rp.teamId = 12879 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150	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 = 12879 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* `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 = 68403 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.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* `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 = 63978 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.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* `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 = 57523 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.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* `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 = 50506 AND t.round = 15 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 = 44260 AND t.round = 26 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* `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 = 38832 AND t.round = 26 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* `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 = 33465 AND t.round = 26 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* `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 = 15805 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 2801 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 27076 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 27080 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 27083 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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 = 27087 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 27092 AND t.round = 30 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* `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 = 27096 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Mendrisio-Stabio

Mendrisio-Stabio

Selecciona un equipo

Competiciones que juega

Cuarta Suiza Grupo 3

RIVALES EN Copa Suiza

RIVALES EN Erste Liga Cup

RIVALES EN Cuarta Suiza