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

Kickers Luzern

Temporada 2023/2024

TEMPORADA 2023/2024

QUINTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Collina	19	38	17	44
2	Locarno	18	33	18	36
3	Brunnen	20	32	23	31
4	Zug 94	18	39	27	30
5	FC Sursee	19	32	34	30
6	Gambarogno	20	21	16	29
7	Star Zürich	19	27	21	27
8	SC Cham 2	20	28	38	27
9	Buochs	18	25	22	26
10	SC Emmen	20	30	33	25
11	Goldau	20	28	37	24
12	Perlen-Buchr	20	29	33	23
13	Ascona	20	19	33	18
14	Unterstrass	20	26	34	17
15	Kickers	19	21	42	15
16	SC Zofingen	0	0	0	0

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

QUINTA SUIZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	FC Paradiso	26	55	18	65
2	Lugano II	26	69	30	61
3	Taverne	26	50	34	41
4	FC Sursee	26	57	46	38
5	Willisau	26	58	47	35
6	Novazzano	26	46	47	35
7	Ibach	26	39	41	35
8	Brunnen	26	33	41	35
9	Perlen-Buchr	26	48	51	33
10	Kickers	26	43	53	33
11	Sarnen	26	34	49	32
12	Hergiswil	26	46	53	31
13	FC Altdorf	26	31	55	24
14	Eschenbach	26	29	73	7

TEMPORADA 2017/2018

CUARTA SUIZA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Solothurn	26	56	15	66
2	Munsingen	26	51	21	51
3	Black Stars	26	63	32	48
4	Luzern II	26	59	39	48
5	Buochs	26	56	38	45
6	Grasshopper	26	62	45	40
7	Schotz	26	46	53	35
8	Zug 94	26	37	40	33
9	Delemont	26	42	53	33
10	Baden	26	41	53	28
11	Langenthal	26	34	53	25
12	Bassecourt	26	31	54	21
13	FC Sursee	26	34	60	20
14	Kickers	26	12	68	11

TEMPORADA 2016/2017

QUINTA SUIZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kickers	26	52	29	51
2	SC Zofingen	26	52	41	43
3	Brunnen	26	53	32	42
4	Hochdorf	26	36	41	39
5	Lugano II	26	42	34	38
6	Ibach	26	38	33	37
7	Hergiswil	26	44	39	36
8	Taverne	26	37	36	36
9	Ascona	26	38	43	36
10	Perlen-Buchr	26	41	57	35
11	Goldau	26	52	60	33
12	Eschenbach	26	31	42	32
13	Vedeggio	26	40	31	31
14	AS Castello	26	25	63	19

TEMPORADA 2015/2016

QUINTA SUIZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Bellinzona	26	75	21	65
2	Team Ticino	26	57	32	48
3	Ascona	26	46	34	47
4	Goldau	26	72	53	41
5	Hergiswil	26	55	48	40
6	Ibach	26	39	34	40
7	Eschenbach	26	41	33	39
8	AS Castello	26	43	41	39
9	Taverne	26	41	34	36
10	Hochdorf	26	36	51	29
11	Kickers	26	42	57	27
12	Küssnacht	26	24	74	21
13	Willisau	26	48	75	18
14	Sarnen	26	22	54	16

TEMPORADA 2012/2013

QUINTA SUIZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	FC Sursee	26	61	16	52
2	Eschenbach	26	48	44	47
3	Buochs	26	64	41	44
4	Ruswil	26	50	46	43
5	Ascona	26	39	36	41
6	Goldau	26	51	36	40
7	Sarnen	26	46	47	40
8	Hergiswil	26	44	49	34
9	Emmenbrücke	26	36	42	33
10	Gunzwil	26	35	44	33
11	Ibach	26	43	51	29
12	Aegeri	26	38	56	28
13	Baar	26	22	46	25
14	Kickers	26	25	48	21

TEMPORADA 2010/2011

QUINTA SUIZA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	FC Muri	26	51	26	51
2	Aarau II	26	77	42	49
3	FC Sursee	26	51	35	49
4	Eschenbach	26	42	43	45
5	Losone	26	53	43	44
6	Goldau	26	52	46	43
7	Ibach	26	55	38	42
8	Sarnen	26	44	41	38
9	Hergiswil	26	50	56	36
10	Emmenbrücke	26	45	47	29
11	Aegeri	26	46	62	29
12	Kickers	26	37	52	26
13	Taverne	26	23	50	20
14	Balerna	26	31	76	11

TEMPORADA 2009/2010

QUINTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Aarau II	26	46	21	56
2	Buochs	26	62	36	49
3	Losone	26	52	38	48
4	Goldau	26	48	36	41
5	FC Muri	26	43	40	38
6	Ibach	26	32	31	38
7	Sarnen	26	37	43	35
8	Schöftland	26	43	48	32
9	FC Sursee	26	34	40	32
10	Aegeri	26	39	44	28
11	Kickers	26	32	40	28
12	Olten	26	34	49	28
13	Malcantone	26	32	43	26
14	Sementina	26	22	47	20

TEMPORADA 2008/2009

QUINTA SUIZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Lugano II	26	77	21	64
2	FC Sursee	26	47	27	52
3	Aarau II	26	64	32	51
4	Sarnen	26	59	44	49
5	Buochs	26	45	23	43
6	Malcantone	25	45	40	42
7	Ibach	26	46	38	35
8	Losone	26	53	50	34
9	Goldau	26	27	38	27
10	Schöftland	26	39	58	27
11	Kickers	26	38	55	26
12	Küssnacht	26	38	57	25
13	SAR Rivera	26	29	49	25
14	FC Brugg	25	15	90	5

TEMPORADA 2006/2007

CUARTA SUIZA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC Basel II	30	100	23	75
2	Biel-Bienne	30	60	18	65
3	Solothurn	30	55	22	62
4	SC Cham	30	46	33	54
5	SC Zofingen	30	49	49	45
6	Muttenz	30	53	54	41
7	Luzern II	30	48	51	41
8	Wangen	30	48	58	41
9	Young Boys	30	42	51	38
10	Zug 94	30	37	40	36
11	Laufen	30	39	39	34
12	Olten	30	38	56	34
13	Munsingen	30	33	40	32
14	FC Grenchen	30	43	65	32
15	Dornach	30	33	72	19
16	Kickers	30	32	85	14

TEMPORADA 2005/2006

CUARTA SUIZA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Biel-Bienne	30	65	20	68
2	Delemont	30	56	40	52
3	FC Basel II	31	80	50	50
4	Kickers	30	49	41	49
5	Solothurn	30	51	40	46
6	SC Zofingen	30	52	55	40
7	Wangen	31	53	57	39
8	FC Grenchen	30	51	46	38
9	Laufen	30	37	45	36
10	Young Boys	30	44	45	35
11	Munsingen	30	37	42	35
12	Dornach	30	42	63	35
13	Muttenz	30	43	67	35
14	Luzern II	30	45	53	34
15	Schotz	30	46	64	31
16	Buochs	30	39	62	24

Competiciones que juega

Grupo 3

Quinta Suiza Grupo 3

Pos	Equipos		Pts
1		Collina d'Oro	44
2		Locarno	36
3		Brunnen	31
4		Zug 94	30
5		FC Sursee	30
6		Gambarogno - Contone	29
7		Red Star Zürich	27
8		SC Cham 2	27
9		Buochs	26
10		SC Emmen	25
11		Goldau	24
12		Perlen-Buchrain	23
13		Ascona	18
14		Unterstrass	17
15		Kickers Luzern	15
16		SC Zofingen	0

	Ascenso : Collina d'Oro
	Descenso : Ascona, Unterstrass, Kickers Luzern, SC Zofingen

RIVALES EN 2. Liga Interrre.

RIVALES EN Quinta Suiza

USO DE MEMORIA

6,629,464 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1487
Total Execution Time	0.1500

CADENA URL

/historico/Kickers-Luzern

GET DATOS

$_GET['/historico/Kickers-Luzern']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0069	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 = 'Kickers-Luzern' 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.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=65301 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=65301 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=65301 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0051	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 = 74875
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65301 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1527 AND type_rel = 3
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1527 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023	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 (130213) ORDER BY n.cover_points DESC, update_date DESC
0.0029	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 = '65301' ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '65301' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '65301' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025	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 = 74875 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 72777 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=65301 AND l.year in (2023,2024,2025) 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 (74875,72777) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72777 AND teamId = 65301
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 74875 AND teamId = 65301
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 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 = 72777 AND t.round = 25 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 = '65301' 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 = '65301' 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 = '65301' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028	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 = 72777 WHERE rp.league_id = 72777 AND rp.teamId = 65301 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.0028	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 = 72777 WHERE rp.league_id = 72777 AND rp.teamId = 65301 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 72777 WHERE rp.league_id = 72777 AND rp.teamId = 65301 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 65301 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72777 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.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` 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.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* `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.0036	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.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* `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.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* `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 = 44265 AND t.round = 26 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 = 38831 AND t.round = 26 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* `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 = 34004 AND t.round = 26 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 = 15881 AND t.round = 26 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* `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 = 27129 AND t.round = 26 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 = 27148 AND t.round = 26 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* `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 = 27146 AND t.round = 26 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* `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 = 27156 AND t.round = 26 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* `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 = 63204 AND t.round = 30 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 = 63133 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 72777 ORDER BY nameShow LIMIT 100

Kickers Luzern

Kickers Luzern

Selecciona un equipo

Competiciones que juega

Quinta Suiza Grupo 3

RIVALES EN 2. Liga Interrre.

RIVALES EN Quinta Suiza