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

Schaffhausen

Entrenador: Christian Wimmer

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Sion	33	65	22	70
2	Thun	33	61	35	67
3	FC Vaduz	33	61	46	47
4	Neuchâtel	33	48	42	44
5	Aarau	33	47	49	43
6	Stade	33	40	48	40
7	FC Wil	33	41	48	38
8	Bellinzona	33	34	45	38
9	Schaffhausen	33	34	47	37
10	Baden	33	26	75	24

TEMPORADA 2022/2023

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Yverdon	36	64	53	66
2	Lausanne	36	58	43	61
3	Stade	36	70	53	60
4	Aarau	36	63	57	57
5	FC Wil	36	62	52	56
6	Thun	36	62	55	49
7	Schaffhausen	36	51	59	44
8	FC Vaduz	36	54	56	37
9	Bellinzona	36	38	71	37
10	Neuchâtel	36	42	65	24

TEMPORADA 2021/2022

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Winterthur	36	76	45	65
2	Schaffhausen	36	73	49	65
3	Aarau	36	67	47	65
4	FC Vaduz	36	68	58	60
5	Thun	36	62	57	56
6	Neuchâtel	36	56	54	50
7	Stade	36	46	50	44
8	Yverdon	36	44	52	44
9	FC Wil	36	68	80	41
10	Kriens	36	25	93	13

TEMPORADA 2020/2021

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Grasshopper	36	60	43	65
2	Thun	36	57	46	64
3	Stade	36	57	39	58
4	Schaffhausen	36	59	46	58
5	Aarau	36	66	59	58
6	Winterthur	36	50	52	43
7	FC Wil	36	43	52	39
8	Kriens	36	40	48	38
9	Neuchâtel	36	36	58	36
10	Chiasso	36	35	60	36

TEMPORADA 2019/2020

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Lausanne	36	84	36	73
2	FC Vaduz	36	78	53	64
3	Grasshopper	36	69	52	61
4	Winterthur	36	56	58	55
5	Kriens	36	58	59	54
6	FC Wil	36	60	61	49
7	Stade	36	47	64	42
8	Aarau	36	65	80	41
9	Schaffhausen	36	34	62	32
10	Chiasso	36	44	70	23

TEMPORADA 2018/2019

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Servette	36	90	37	79
2	Aarau	36	63	46	64
3	Lausanne	36	64	37	63
4	Winterthur	36	57	51	56
5	FC Wil	36	33	47	42
6	FC Vaduz	36	48	70	42
7	Schaffhausen	36	43	62	39
8	Kriens	36	46	58	36
9	Chiasso	36	43	67	36
10	Rapperswil	36	47	59	35

TEMPORADA 2017/2018

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Neuchâtel	36	82	39	85
2	Schaffhausen	36	70	51	64
3	Servette	36	56	38	62
4	FC Vaduz	36	66	50	59
5	Rapperswil	36	53	45	56
6	Aarau	36	53	62	44
7	FC Wil	36	40	50	39
8	Chiasso	36	42	60	36
9	Winterthur	36	45	60	32
10	Wohlen	36	41	93	18

TEMPORADA 2016/2017

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Zurich	36	91	30	85
2	Neuchâtel	36	66	36	73
3	Servette	36	55	43	62
4	Schaffhausen	36	64	59	51
5	Aarau	36	57	64	45
6	Winterthur	36	45	62	41
7	Wohlen	36	42	60	39
8	Chiasso	36	43	63	37
9	Le Mont LS	36	31	54	35
10	FC Wil	36	35	58	34

TEMPORADA 2015/2016

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Lausanne	36	66	44	68
2	Neuchâtel	35	55	42	57
3	FC Wil	35	62	50	56
4	Aarau	36	48	41	54
5	Schaffhausen	36	50	48	50
6	Winterthur	35	41	49	46
7	Chiasso	35	41	45	40
8	Wohlen	35	36	52	39
9	Le Mont LS	35	37	54	32
10	Biel-Bienne	30	44	55	26

TEMPORADA 2014/2015

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	FC Lugano	36	64	31	74
2	Servette	36	51	39	67
3	Wohlen	36	56	43	64
4	Winterthur	36	65	49	53
5	Schaffhausen	36	55	54	47
6	Lausanne	36	47	57	44
7	Le Mont LS	36	39	56	39
8	Chiasso	36	30	49	39
9	FC Wil	36	47	63	37
10	Biel-Bienne	36	39	52	33

TEMPORADA 2013/2014

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	FC Vaduz	36	71	34	73
2	FC Lugano	36	55	46	64
3	FC Wil	36	74	45	63
4	Schaffhausen	36	57	40	62
5	Servette	36	49	48	61
6	Winterthur	36	45	50	42
7	Biel-Bienne	36	56	68	37
8	Chiasso	36	35	52	33
9	Wohlen	36	47	67	32
10	Locarno	36	31	70	26

TEMPORADA 2012/2013

TERCERA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Schaffhausen	30	75	29	68
2	FC Basel II	30	81	38	68
3	YF Juventus	30	75	29	66
4	Sion II	30	57	39	50
5	Tuggen	30	59	55	47
6	Zurich	30	58	49	44
7	Kriens	30	54	49	44
8	Delemont	30	40	43	38
9	Old Boys	30	41	48	37
10	Stade	30	43	51	33
11	Breitenrain	30	40	63	33
12	SC Bruhl	30	40	56	32
13	Gallen	30	44	61	32
14	Etoile	30	35	53	32
15	Fribourg	30	38	57	31
16	Yverdon	30	25	85	11

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

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Lausanne	30	67	28	65
2	Servette	30	75	27	62
3	FC Lugano	30	56	35	62
4	FC Vaduz	30	59	41	60
5	FC Wil	30	45	42	46
6	Stade	30	48	51	46
7	Chiasso	30	34	37	41
8	Delemont	30	47	60	40
9	Biel-Bienne	30	57	57	39
10	Wohlen	30	45	44	37
11	Aarau	30	39	51	36
12	Kriens	30	26	50	33
13	Winterthur	30	42	51	32
14	Locarno	30	40	52	31
15	Schaffhausen	30	36	53	26
16	Yverdon	30	27	64	20

TEMPORADA 2009/2010

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Thun	30	70	36	60
2	FC Lugano	30	65	29	59
3	Winterthur	30	69	46	56
4	Servette	30	49	37	52
5	Kriens	30	50	41	46
6	FC Wil	30	44	37	45
7	Biel-Bienne	30	54	39	42
8	FC Vaduz	30	44	43	41
9	Yverdon	30	50	38	39
10	Lausanne	30	40	43	39
11	Schaffhausen	30	42	51	39
12	Wohlen	30	44	55	31
13	Locarno	30	46	65	31
14	Stade	30	36	64	31
15	Le Mont LS	30	30	56	27
16	FC Gossau	30	27	80	13

TEMPORADA 2008/2009

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	St. Gallen	30	78	22	78
2	FC Lugano	30	72	30	70
3	FC Wil	30	41	25	51
4	Yverdon	30	52	41	51
5	Biel-Bienne	30	58	53	47
6	Wohlen	30	43	47	45
7	Lausanne	30	41	43	41
8	Concordia	30	48	51	40
9	Thun	30	54	65	38
10	Winterthur	30	45	46	36
11	Schaffhausen	30	40	45	34
12	Chaux-de-Fon	30	39	46	33
13	Servette	30	31	46	31
14	Stade	30	26	56	28
15	Locarno	30	46	56	26
16	FC Gossau	30	27	69	19

TEMPORADA 2007/2008

SEGUNDA SUIZA
Equipo		PJ	GF	GC	Puntos
1	FC Vaduz	34	75	40	70
2	Bellinzona	34	74	39	69
3	FC Wil	34	63	35	68
4	Wohlen	34	65	46	56
5	Winterthur	34	59	56	51
6	Schaffhausen	34	53	40	49
7	Concordia	34	55	54	49
8	Servette	34	55	46	46
9	FC Lugano	34	61	63	46
10	Yverdon	34	39	35	43
11	FC Gossau	34	50	54	43
12	Chaux-de-Fon	34	53	63	43
13	Lausanne	34	46	47	42
14	Locarno	34	37	61	41
15	Kriens	34	43	54	38
16	Delemont	34	42	58	37
17	Chiasso	34	43	68	33
18	SC Cham	34	31	85	16

TEMPORADA 2006/2007

LIGA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Zurich	36	67	32	75
2	Basel	36	77	40	74
3	Sion	36	57	42	60
4	Young Boys	36	52	42	59
5	St. Gallen	36	47	44	55
6	Grasshopper	36	54	41	50
7	Thun	36	30	58	37
8	Luzern	36	31	58	33
9	Aarau	36	28	55	26
10	Schaffhausen	36	27	58	25

TEMPORADA 2005/2006

LIGA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Zurich	36	86	36	78
2	Basel	36	87	42	78
3	Young Boys	36	60	46	62
4	Grasshopper	36	44	33	55
5	Thun	36	50	53	49
6	St. Gallen	36	51	56	40
7	Aarau	36	29	63	35
8	Schaffhausen	36	32	55	33
9	Neuchâtel	36	41	70	33
10	Yverdon	36	38	64	32

TEMPORADA 2004/2005

LIGA SUIZA
Equipo		PJ	GF	GC	Puntos
1	Basel	34	81	45	70
2	Thun	34	69	42	60
3	Grasshopper	34	51	50	50
4	Young Boys	34	60	52	49
5	Zurich	34	55	57	48
6	Neuchâtel	34	36	48	38
7	St. Gallen	34	51	60	36
8	Aarau	34	42	64	32
9	Schaffhausen	34	36	59	32
10	Servette	18	24	28	20

Competiciones que juega

Segunda Suiza

Pos	Equipos		Pts
1		Sion	70
2		Thun	67
3		FC Vaduz	47
4		Neuchâtel Xamax	44
5		Aarau	43
6		Stade Nyonnais	40
7		FC Wil	38
8		AC Bellinzona	38
9		Schaffhausen	37
10		Baden	24

	Ascenso : Sion
	Playoff Ascenso : Thun
	Descenso : Baden

RIVALES EN Copa Suiza

RIVALES EN Segunda Suiza

USO DE MEMORIA

7,027,312 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.1823
Total Execution Time	0.1845

CADENA URL

/historico/Schaffhausen

GET DATOS

$_GET['/historico/Schaffhausen']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

0.0043	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 = 'Schaffhausen' 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.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=3043 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=3043 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=3043 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=3043 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043	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 = 72224
0.0026	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 = 72510
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3043 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=355 AND type_rel = 3
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 355 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022	SELECT /53 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 (1279364,1236274,1213287,1184062,1122166) ORDER BY n.cover_points DESC, update_date DESC
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 = '3043' ORDER BY l.year DESC,cat.coefficient DESC
0.0034	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 = '3043' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient 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 = '3043' 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 = 72510 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 72224 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=3043 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (72510,72224,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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 72224 AND teamId = 3043
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 72510 AND teamId = 3043
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3043
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 = 72224 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '3043' 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 = '3043' and rp.type = 4
0.0020	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 = '3043' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041	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 = 72224 WHERE rp.league_id = 72224 AND rp.teamId = 3043 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.0034	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 = 72224 WHERE rp.league_id = 72224 AND rp.teamId = 3043 AND (e.action = 4 or e.action = 5) 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 = 72224 WHERE rp.league_id = 72224 AND rp.teamId = 3043 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 3043 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72224 AND t.round = 33 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 = 67970 AND t.round = 36 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 = 63180 AND t.round = 36 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* `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 = 58546 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 49962 AND t.round = 36 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* `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 = 43609 AND t.round = 36 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` 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 = 38785 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0060	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 = 33334 AND t.round = 36 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* `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 = 15512 AND t.round = 36 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 = 3882 AND t.round = 36 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* `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 = 2797 AND t.round = 36 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* `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 = 10187 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* `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.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* `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 = 10178 AND t.round = 30 ORDER BY team.conference 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* `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 = 10179 AND t.round = 30 ORDER BY team.conference 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* `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 = 10180 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* `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 = 10181 AND t.round = 34 ORDER BY team.conference 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* `tables2007` 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 = 676 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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* `tables2006` 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 = 677 AND t.round = 36 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* `tables2005` 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 = 678 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Schaffhausen

Schaffhausen

Selecciona un equipo

Competiciones que juega

Segunda Suiza

RIVALES EN Copa Suiza

RIVALES EN Segunda Suiza