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

« Temporada Anterior

Temporada 2022

Temporada Siguiente »

2021/2022

Challenge league, Nationalliga B, segunda division suiza

Eliminatoria

Segunda Suiza 2022

Ver

TEMPORADA 2021/2022

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

Ver

TEMPORADA 2020/2021

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

Ver

TEMPORADA 2019/2020

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

Ver

TEMPORADA 2018/2019

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

Ver

TEMPORADA 2017/2018

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

Ver

TEMPORADA 2016/2017

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

Ver

TEMPORADA 2015/2016

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

Ver

TEMPORADA 2014/2015

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

Ver

TEMPORADA 2013/2014

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

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Aarau	36	76	40	78
2	Bellinzona	36	62	37	71
3	Winterthur	36	61	43	62
4	FC Wil	36	59	65	51
5	Biel-Bienne	36	59	59	47
6	Chiasso	36	42	51	47
7	FC Lugano	36	52	50	44
8	Wohlen	36	39	58	39
9	FC Vaduz	36	41	52	37
10	Locarno	36	32	68	24

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	St. Gallen	30	67	31	64
2	Aarau	30	64	34	59
3	Bellinzona	30	48	21	59
4	Winterthur	30	44	29	53
5	FC Lugano	30	44	38	49
6	FC Wil	30	59	41	46
7	Chiasso	30	34	23	45
8	FC Vaduz	30	54	45	45
9	Locarno	30	47	44	45
10	Biel-Bienne	30	55	54	43
11	Wohlen	30	39	44	36
12	Stade	30	41	49	34
13	Etoile	30	25	56	30
14	Delemont	30	24	60	20
15	Kriens	30	37	66	17
16	SC Bruhl	30	30	77	16

Ver

TEMPORADA 2010/2011

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

Ver

TEMPORADA 2009/2010

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

Ver

TEMPORADA 2008/2009

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

Ver

TEMPORADA 2007/2008

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

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	Neuchâtel	34	73	28	76
2	Bellinzona	34	58	26	70
3	Kriens	34	65	36	67
4	Chiasso	34	55	39	58
5	Concordia	34	59	49	57
6	Winterthur	34	60	47	55
7	Servette	34	63	51	53
8	FC Wil	34	56	50	46
9	FC Vaduz	34	57	52	46
10	Chaux-de-Fon	34	51	47	46
11	Yverdon	34	45	60	42
12	FC Lugano	34	42	46	41
13	Lausanne	34	44	51	39
14	Locarno	34	42	60	39
15	Delemont	34	39	63	33
16	Wohlen	34	39	64	31
17	FC Baulmes	34	30	63	30
18	YF Juventus	34	29	75	19

Ver

TEMPORADA 2005/2006

Equipo		PJ	GF	GC	Puntos
1	Luzern	34	69	33	79
2	Sion	34	61	24	72
3	Lausanne	34	64	42	68
4	Chiasso	34	51	31	59
5	Chaux-de-Fon	34	60	44	58
6	Wohlen	34	50	40	52
7	FC Wil	34	61	55	51
8	FC Vaduz	34	57	54	46
9	Bellinzona	34	43	45	46
10	FC Lugano	34	41	52	41
11	FC Baulmes	34	36	45	40
12	Concordia	34	44	57	39
13	Kriens	34	42	56	39
14	YF Juventus	34	39	53	38
15	Winterthur	34	62	53	37
16	Locarno	34	35	60	28
17	Baden	34	30	59	27
18	Meyrin	34	26	68	14

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	Yverdon	34	59	26	70
2	FC Vaduz	34	58	28	69
3	Sion	34	63	33	68
4	Chiasso	34	60	37	65
5	Luzern	34	73	53	59
6	Bellinzona	34	58	46	57
7	Concordia	34	52	40	51
8	FC Lugano	34	49	46	50
9	Kriens	34	46	37	48
10	Chaux-de-Fon	34	57	56	43
11	Winterthur	34	46	53	41
12	FC Baulmes	34	31	54	41
13	FC Wil	34	45	54	40
14	Meyrin	34	39	61	35
15	Wohlen	34	38	63	31
16	YF Juventus	34	43	71	29
17	Baden	34	39	62	28
18	Bulle	34	43	79	24

Ver

TEMPORADA 2003/2004

Equipo		PJ	GF	GC	Puntos
1	Schaffhausen	21	32	22	37
2	Malcantone	21	37	29	37
3	Luzern	21	31	20	36
4	Chiasso	19	28	18	36
5	FC Vaduz	21	38	25	35
6	Concordia	21	34	37	33
7	Wohlen	21	28	25	32
8	Sion	18	31	19	30
9	Kriens	21	26	26	30
10	Bellinzona	21	31	38	29
11	Yverdon	19	33	24	27
12	Meyrin	21	29	35	24
13	Bulle	20	23	31	21
14	Delemont	21	27	39	20
15	Baden	21	25	40	18
16	Winterthur	20	21	31	16
17	Chaux-de-Fon	19	13	28	15

Ver

TEMPORADA 2002/2003

Equipo		PJ	GF	GC	Puntos
1	FC Vaduz	22	47	32	41
2	Sion	22	35	27	39
3	Kriens	22	48	36	38
4	FC Lugano	22	36	17	37
5	Yverdon	22	36	21	36
6	Schaffhausen	22	30	35	32
7	Lausanne	22	27	32	30
8	Concordia	22	29	43	27
9	Bellinzona	22	32	34	25
10	Winterthur	22	24	36	20
11	Baden	22	26	38	18
12	Wohlen	22	23	42	16

Ver

TEMPORADA 2001/2002

Equipo		PJ	GF	GC	Puntos
1	FC Wil	22	53	32	41
2	Winterthur	22	48	48	39
3	Thun	22	42	32	38
4	Delemont	22	33	26	38
5	Yverdon	22	37	31	35
6	Etoile	22	27	26	31
7	Kriens	22	28	30	30
8	Bellinzona	22	27	33	25
9	Baden	22	40	37	24
10	Locarno	22	28	35	23
11	FC Vaduz	22	34	43	22
12	Concordia	22	34	58	19

Ver

TEMPORADA 2000/2001

Equipo		PJ	GF	GC	Puntos
1	Young Boys	22	42	20	45
2	FC Wil	22	47	28	45
3	Winterthur	22	41	21	41
4	Bellinzona	22	40	27	38
5	Thun	22	43	42	32
6	Delemont	22	43	39	31
7	Kriens	22	28	37	25
8	Locarno	22	28	41	24
9	Wangen	22	26	37	22
10	Etoile	22	28	33	21
11	Baden	22	23	40	20
12	Solothurn	22	16	40	18

JUGADORES DESTACADOS

Nombre	Goles	Equipo
J. Ardaiz	20	SCH
K. Spadanuda	18	FCA
B. Labeau	16	STA
Roman Buess	16	WIN
S. Rapp	16	FCV
R. Nuzzolo	14	NEX
V. Fazliu	14	WIL
T. Cicek	14	FCV
S. Bahloul	14	WIL
K. Koné	13	YVE

Equipos de esta liga

USO DE MEMORIA

7,185,048 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1579
Total Execution Time	0.1599

CADENA URL

/segunda_suiza2022/grupo1/historico

GET DATOS

$_GET['/segunda_suiza2022/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0018	SELECT type FROM routes WHERE alias = 'segunda_suiza2022'
0.0040	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_suiza' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63180 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 355 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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 = 10176 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* `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 = 10177 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.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* `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.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* `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.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* `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 = 10182 AND t.round = 34 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* `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 = 10183 AND t.round = 34 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 = 10185 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* `tables2004` 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 = 10186 AND t.round = 34 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* `tables2003` 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 = 13528 AND t.round = 22 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* `tables2002` 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 = 13527 AND t.round = 22 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* `tables2001` 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 = 13526 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 14:59:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 14:59:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 14:59:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0031	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 14:59:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_suiza' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0152	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63180 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63180 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0173	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63180 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63180 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63180 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63180 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030	SELECT ,(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

Nombre	Rojas	Equipo
Check Ouattara	2	NEX
D. Simani	2	FCV
Lavdim Zumberi	2	WIL
M. Mujcic	1	SCH
M. Gonçalves	1	WIN
Liridon Mulaj	1	KRI
Ilan Sauter	1	WIL
K. Gazzetta	1	NEX
A. Cvetković	1	FCA
David Mistrafovic	1	KRI


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

Nombre	Amarillas	Equipo
N. Lusuena	12	YVE
V. Hamdiu	12	SCH
Allen Njie	11	FCA
Check Ouattara	11	NEX
P. Muntwiler	10	WIL
Uran Bislimi	10	SCH
Nicky Beloko	10	NEX
G. Bamba	10	STA
Hugo Fargues	10	YVE
C. Zock	10	YVE