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

Käerjéng 97

Entrenador: Franck Rinaldo

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Differdange	26	66	18	61
2	Dudelange	26	51	31	52
3	Swift	26	55	33	49
4	Progrès	26	47	29	49
5	Jeunesse	26	47	34	42
6	Strassen	26	36	35	37
7	Victoria	26	38	40	37
8	Union Titus	26	41	39	33
9	Mondorf	26	44	46	33
10	Racing Union	26	39	54	32
11	Wiltz 71	26	36	44	30
12	Käerjéng	26	27	40	27
13	Mondercange	26	28	53	25
14	Marisca	26	36	53	23
15	Schifflangen	26	32	50	22
16	Fola Esch	26	29	53	22

TEMPORADA 2022/2023

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Swift	30	100	28	77
2	Progrès	30	67	31	70
3	Dudelange	30	86	38	67
4	Union Titus	30	62	38	59
5	Differdange	30	60	43	45
6	Mondorf	30	52	52	45
7	Jeunesse	30	44	39	43
8	Racing Union	30	43	39	43
9	Strassen	30	33	46	39
10	Wiltz 71	30	48	59	36
11	Victoria	30	48	58	32
12	Mondercange	30	41	55	29
13	Fola Esch	30	36	71	26
14	Käerjéng	30	30	69	25
15	Etzella	30	32	71	23
16	US Hostert	30	20	65	18

TEMPORADA 2021/2022

SEGUNDA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Mondercange	30	60	29	62
2	Käerjéng	30	70	36	61
3	Jeunesse	30	56	33	57
4	Mamer	30	60	33	54
5	Rumelange	30	73	48	49
6	Bettembourg	30	74	54	46
7	Schifflangen	30	63	55	42
8	Berdenia	30	49	55	42
9	Yellow Boys	30	61	63	41
10	Jeunesse	30	54	53	39
11	Blô-Weiss	30	47	56	38
12	Marisca	30	45	54	38
13	Atert Bissen	30	50	67	31
14	Alisontia	30	56	76	30
15	US Esch	30	48	77	27
16	Union	30	33	110	11

TEMPORADA 2020/2021

SEGUNDA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Rumelange	7	23	8	18
2	US Esch	7	18	7	17
3	Mondercange	7	14	8	15
4	Jeunesse	6	18	9	13
5	Marisca	7	12	9	12
6	Yellow Boys	7	14	9	11
7	Alisontia	6	11	6	11
8	Jeunesse	7	10	12	10
9	Blô-Weiss	6	12	13	8
10	Bettembourg	7	12	17	7
11	Atert Bissen	7	13	21	7
12	Mamer	7	12	14	5
13	Schifflangen	7	10	15	5
14	Union	6	5	15	5
15	Berdenia	7	9	20	5
16	Käerjéng	7	9	19	3

TEMPORADA 2019/2020

SEGUNDA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Swift	15	52	17	32
2	Wiltz 71	15	48	24	32
3	US Esch	15	32	20	28
4	Käerjéng	15	41	28	27
5	Rumelange	15	36	23	27
6	Luxembourg	15	26	14	26
7	Mondercange	15	20	18	22
8	Jeunesse	15	28	32	21
9	Alisontia	15	22	34	21
10	Mamer	15	24	33	19
11	Yellow Boys	15	13	24	14
12	Union	15	21	30	12
13	Jeunesse	15	14	35	9
14	Blô-Weiss	15	8	53	3

TEMPORADA 2018/2019

SEGUNDA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Rodange	26	58	18	61
2	Blue Boys M.	26	55	25	59
3	Swift	26	73	27	55
4	US Esch	26	47	28	52
5	Käerjéng	26	47	31	44
6	Wiltz 71	26	45	34	39
7	Union	26	41	41	35
8	Mamer	26	41	59	30
9	Jeunesse	26	25	42	27
10	Jeunesse	26	42	45	26
11	Erpeldange	26	42	63	26
12	Atert Bissen	26	31	52	25
13	Koeppchen	26	24	65	15
14	Sandweiler	26	31	72	14

TEMPORADA 2017/2018

SEGUNDA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Etzella	26	63	24	64
2	Rumelange	26	57	28	62
3	Käerjéng	26	71	38	53
4	Swift	26	55	46	44
5	Wiltz 71	26	62	35	42
6	Union	26	42	37	39
7	Blue Boys M.	26	39	47	35
8	Jeunesse	26	45	57	34
9	Sandweiler	26	36	42	32
10	Erpeldange	26	39	50	30
11	Mamer	26	42	56	25
12	Norden	26	38	62	24
13	Grevenmacher	26	24	50	23
14	Union	26	33	74	14

TEMPORADA 2016/2017

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Dudelange	26	68	14	65
2	Differdange	26	65	21	65
3	Fola Esch	26	69	34	56
4	Progrès	26	57	38	44
5	Strassen	26	39	47	37
6	Union Titus	26	38	33	35
7	Mondorf	26	29	45	30
8	Jeunesse	26	38	49	29
9	Victoria	26	38	54	28
10	Racing Union	26	38	52	27
11	Luxembourg	26	29	47	26
12	Jeunesse	26	30	54	23
13	Rumelange	26	29	53	23
14	Käerjéng	26	37	63	22

TEMPORADA 2015/2016

SEGUNDA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Käerjéng	26	58	26	59
2	Union Titus	26	60	28	58
3	Jeunesse	26	52	29	50
4	US Hostert	26	47	29	43
5	Rodange	26	39	37	42
6	Norden	26	41	46	40
7	Mondercange	26	48	52	36
8	Mamer	26	34	38	33
9	Swift	26	37	37	32
10	Sandweiler	26	39	49	30
11	Avenir	26	39	49	28
12	Erpeldange	26	32	50	26
13	Union	26	37	47	23
14	Union Remich	26	20	66	11

TEMPORADA 2014/2015

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Fola Esch	26	63	21	61
2	Differdange	26	61	31	59
3	Dudelange	26	54	20	54
4	Progrès	26	51	29	50
5	Jeunesse	26	46	34	44
6	Victoria	26	36	46	31
7	Etzella	26	36	50	30
8	Mondorf	26	30	40	29
9	Grevenmacher	26	24	48	29
10	Rumelange	26	29	38	28
11	Wiltz 71	26	29	38	27
12	Käerjéng	26	33	51	27
13	US Hostert	26	35	52	23
14	Jeunesse	26	16	45	15

TEMPORADA 2013/2014

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Dudelange	26	64	21	61
2	Fola Esch	26	53	19	59
3	Differdange	26	53	23	51
4	Jeunesse	26	47	35	43
5	Progrès	26	33	26	42
6	Etzella	26	44	46	32
7	Käerjéng	26	32	35	32
8	Grevenmacher	26	27	34	32
9	Wiltz 71	26	40	53	31
10	Jeunesse	26	27	42	30
11	Rumelange	26	25	36	28
12	Luxembourg	26	32	46	24
13	Swift	26	22	51	20
14	Racing Union	26	22	54	18

TEMPORADA 2012/2013

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Fola Esch	26	67	23	59
2	Dudelange	26	53	20	55
3	Jeunesse	26	53	31	50
4	Differdange	26	54	34	47
5	Luxembourg	26	53	38	46
6	Grevenmacher	26	43	32	42
7	Jeunesse	26	40	35	37
8	Racing Union	26	43	44	33
9	Käerjéng	26	44	53	31
10	Wiltz 71	26	42	66	30
11	Etzella	26	41	61	27
12	Progrès	26	29	45	25
13	CS Pétange	26	21	57	14
14	Union	26	29	73	12

TEMPORADA 2011/2012

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Dudelange	26	67	20	54
2	Jeunesse	26	56	37	51
3	Grevenmacher	26	50	27	49
4	Differdange	26	64	26	48
5	Käerjéng	26	37	35	43
6	Fola Esch	26	41	30	38
7	Luxembourg	26	54	47	38
8	CS Pétange	26	29	37	36
9	Progrès	26	32	35	33
10	Racing Union	26	40	41	32
11	Union	26	39	51	29
12	Swift	26	34	53	26
13	Rumelange	26	27	71	19
14	US Hostert	26	22	82	8

TEMPORADA 2010/2011

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Dudelange	26	75	24	59
2	Fola Esch	26	48	28	47
3	Käerjéng	26	54	34	44
4	Differdange	26	51	37	43
5	Progrès	26	43	43	41
6	Grevenmacher	26	43	39	39
7	CS Pétange	26	37	36	38
8	Jeunesse	26	40	37	37
9	Luxembourg	26	47	46	36
10	Swift	26	38	49	31
11	Racing Union	26	38	38	29
12	Wiltz 71	26	38	78	26
13	Etzella	26	31	60	21
14	Jeunesse	26	28	62	20

TEMPORADA 2009/2010

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Jeunesse	26	45	20	57
2	Dudelange	26	60	23	54
3	Grevenmacher	26	46	40	43
4	Differdange	26	41	30	42
5	Luxembourg	26	50	29	41
6	Fola Esch	26	49	38	41
7	Racing Union	26	39	45	41
8	Etzella	26	42	43	32
9	CS Pétange	26	36	42	32
10	Swift	26	33	42	29
11	Progrès	26	39	44	28
12	Käerjéng	26	28	36	28
13	Rumelange	26	27	63	22
14	Mondercange	26	18	58	13

TEMPORADA 2008/2009

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Dudelange	26	70	18	62
2	Differdange	26	51	37	51
3	Grevenmacher	26	55	29	46
4	Jeunesse	26	45	27	46
5	Fola Esch	26	43	42	39
6	Luxembourg	26	38	29	37
7	Progrès	26	53	44	36
8	Etzella	26	43	48	32
9	Käerjéng	26	39	42	31
10	Racing Union	26	45	48	30
11	Swift	26	29	41	29
12	Rumelange	26	34	48	27
13	Steinfort	26	21	54	21
14	Avenir	26	16	75	13

TEMPORADA 2007/2008

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Dudelange	26	74	12	71
2	Racing Union	26	50	28	50
3	Jeunesse	26	51	39	45
4	Etzella	26	54	48	44
5	Avenir	26	41	38	37
6	Grevenmacher	26	45	36	36
7	Differdange	26	43	43	35
8	Luxembourg	26	32	48	32
9	Swift	26	36	44	31
10	Käerjéng	26	30	40	30
11	Progrès	26	31	46	28
12	Wiltz 71	26	33	48	25
13	Victoria	26	29	56	24
14	CS Pétange	26	27	50	19

TEMPORADA 2006/2007

LIGA LUXEMBURGO
Equipo		PJ	GF	GC	Puntos
1	Dudelange	26	71	20	65
2	Etzella	26	60	30	52
3	Differdange	26	71	41	48
4	Racing Union	26	52	35	41
5	Swift	26	40	28	41
6	Grevenmacher	26	43	34	41
7	Progrès	26	53	61	35
8	Käerjéng	26	38	51	34
9	Jeunesse	26	29	34	32
10	CS Pétange	26	29	38	32
11	Wiltz 71	26	31	38	31
12	Victoria	26	28	47	27
13	Mondercange	26	23	59	18
14	Mamer	26	19	71	9

TEMPORADA 2005/2006

LIGA LUXEMBURGO GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	CS Pétange	6	10	7	40
2	Käerjéng	6	8	13	37
3	Victoria	6	10	8	32
4	Avenir	6	8	8	17

Competiciones que juega

Liga Luxemburgo

Pos	Equipos		Pts
1		Differdange 03	61
2		F91 Dudelange	52
3		Swift Hesperange	49
4		Progrès Niederkorn	49
5		Jeunesse d'Esch	42
6		Una Strassen	37
7		Victoria Rosport	37
8		Union Titus Pétange	33
9		US Mondorf les Bains	33
10		Racing Union	32
11		Wiltz 71	30
12		Käerjéng 97	27
13		Mondercange	25
14		Marisca Mersch	23
15		Schifflangen	22
16		Fola Esch	22

	Previa de Champions (1ª Ronda) : Differdange 03
	: F91 Dudelange, Swift Hesperange
	Playoff Descenso : Mondercange, Marisca Mersch
	Descenso : Schifflangen, Fola Esch

RIVALES EN Liga Luxemburgo

RIVALES EN Copa Luxemburgo

USO DE MEMORIA

7,277,696 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1845
Total Execution Time	0.1857

CADENA URL

/historico/Kaerjeng

GET DATOS

$_GET['/historico/Kaerjeng']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0034	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 = 'Kaerjeng' 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=4036 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=4036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026	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=4036 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=4036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	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 = 73657
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4036 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=348 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 348 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 (900743,894718,835971,820066,738616) 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 = '4036' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '4036' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 72206 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 73657 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=4036 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 (73657,72206,71806,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.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 72206 AND teamId = 4036
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71806 AND teamId = 4036
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 73657 AND teamId = 4036
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4036
0.0023	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 = '4036' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4036' and rp.type = 4
0.0026	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 = '4036' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0071	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 = 72206 WHERE rp.league_id = 72206 AND rp.teamId = 4036 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.0066	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 = 72206 WHERE rp.league_id = 72206 AND rp.teamId = 4036 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0052	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 = 72206 WHERE rp.league_id = 72206 AND rp.teamId = 4036 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041	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 = 4036 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031	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 = 72206 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.0033	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 = 68175 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.0032	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 = 63502 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.0031	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 = 58341 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* `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 = 50175 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.0031	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 = 44303 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 38948 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 33540 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 15637 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 3896 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 2786 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 10711 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 10710 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 10709 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 10708 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 10707 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 10706 AND t.round = 26 ORDER BY team.conference 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* `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 = 10705 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 10712 AND t.round = 22 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 = 10715 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 72206 ORDER BY nameShow LIMIT 100


	¿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

Käerjéng 97

Käerjéng 97

Selecciona un equipo

Competiciones que juega

Liga Luxemburgo

RIVALES EN Liga Luxemburgo

RIVALES EN Copa Luxemburgo