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

Stuttgart Sub 17

Temporada 2023/2024

TEMPORADA 2023/2024

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eintracht	26	82	42	63
2	Stuttgart	26	86	30	59
3	Bayern	26	75	25	59
4	Nürnberg	26	66	44	53
5	Hoffenheim	26	67	52	43
6	Augsburg	26	57	40	41
7	Karlsruher	26	40	41	37
8	Mainz	26	41	47	35
9	Freiburg	26	36	54	32
10	Kaiserslaute	26	43	60	23
11	Jahn	26	34	85	22
12	1860	26	38	73	21
13	Ingolstadt	26	31	71	20
14	Heidenheim	26	31	63	9

TEMPORADA 2022/2023

BUNDESLIGA SUB 17 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Stuttgart	3	12	2	9
2	Nürnberg	3	13	6	9
3	1860	3	9	5	6
4	Leipzig	3	9	7	6
5	Hannover	3	7	5	6
6	Hertha	3	6	5	6
7	Stuttgarter	3	5	5	6
8	Hansa	3	5	4	5
9	Chemnitzer	3	3	2	5
10	Leverkusen	3	8	7	4
11	Niendorfer	2	4	3	4
12	Köln	3	5	5	4
13	Karlsruher	3	2	2	4
14	Wolfsburg	3	7	9	4
15	Werder	3	7	10	4
16	Bochum	3	6	7	3
17	Arminia	3	5	6	3
18	Hoffenheim	3	4	5	3
19	Bayern	3	5	8	3
20	Eintracht	3	3	8	3
21	Preußen	2	4	5	1
22	Dortmund	3	5	7	1
23	Darmstadt	3	2	7	0
24	Mainz	3	4	10	0

TEMPORADA 2021/2022

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Stuttgart	20	67	17	54
2	SpVgg	20	48	30	48
3	Hoffenheim	20	49	30	40
4	Freiburg	20	56	32	39
5	Mainz	20	51	26	38
6	Bayern	20	53	32	38
7	Nürnberg	20	51	29	33
8	Augsburg	20	41	32	33
9	Darmstadt	20	37	40	33
10	Greuther	20	30	29	31
11	Karlsruher	20	31	27	27
12	Eintracht	20	30	33	26
13	1860	20	26	29	26
14	Stuttgarter	20	31	37	25
15	Kaiserslaute	20	43	45	23
16	Frankfurt	20	25	35	20
17	Heidenheim	20	32	51	19
18	Wehen	20	24	50	19
19	Ingolstadt	20	22	49	17
20	Elversberg	20	11	61	8
21	Reutlingen	20	14	58	3

TEMPORADA 2020/2021

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Augsburg	5	11	1	13
2	1860	5	10	4	13
3	Bayern	5	16	6	12
4	Nürnberg	5	15	7	12
5	Hoffenheim	5	6	1	11
6	Stuttgart	4	14	5	9
7	Eintracht	5	8	6	7
8	Mainz	5	9	10	7
9	Kaiserslaute	5	7	8	5
10	Karlsruher	5	6	8	5
11	SpVgg	5	7	10	5
12	Greuther	5	4	9	5
13	Stuttgarter	4	3	4	4
14	Frankfurt	5	7	9	4
15	Freiburg	5	4	11	4
16	Heidenheim	5	1	10	4
17	Darmstadt	5	5	16	3
18	Wehen	5	5	13	0

TEMPORADA 2019/2020

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mainz	21	50	20	50
2	Hoffenheim	21	69	25	46
3	Bayern	21	43	24	45
4	Stuttgart	21	41	34	32
5	Augsburg	21	46	34	30
6	Eintracht	21	37	41	30
7	SpVgg	21	33	33	28
8	Wehen	21	33	42	28
9	Nürnberg	20	28	32	27
10	Karlsruher	20	11	24	21
11	Greuther	21	26	42	20
12	Darmstadt	21	26	45	19
13	Freiburg	21	19	36	16
14	Stuttgarter	21	19	49	16

TEMPORADA 2018/2019

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bayern	26	64	29	64
2	Hoffenheim	26	83	30	61
3	Eintracht	26	53	25	56
4	Mainz	26	49	29	54
5	Augsburg	26	58	32	45
6	Stuttgart	26	51	36	44
7	Stuttgarter	26	36	41	36
8	Nürnberg	26	32	42	32
9	Wehen	26	30	54	29
10	Karlsruher	26	32	42	27
11	SpVgg	26	29	46	25
12	Heidenheim	26	21	41	22
13	Ingolstadt	26	28	46	21
14	1846	26	10	83	9

TEMPORADA 2017/2018

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bayern	26	93	20	61
2	Stuttgart	26	86	32	61
3	Hoffenheim	26	71	24	56
4	Mainz	26	74	35	46
5	Eintracht	26	56	51	41
6	Nürnberg	26	42	38	41
7	Heidenheim	26	40	44	33
8	SpVgg	26	41	52	33
9	Karlsruher	26	21	40	28
10	Augsburg	26	38	62	28
11	Stuttgarter	26	34	59	27
12	Kaiserslaute	26	23	55	23
13	Freiburg	26	27	78	18
14	Elversberg	26	18	74	12

TEMPORADA 2016/2017

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bayern	26	65	32	55
2	Stuttgart	26	62	32	50
3	Karlsruher	26	57	28	48
4	Mainz	26	48	33	47
5	Eintracht	26	74	46	44
6	Augsburg	26	56	45	44
7	Kaiserslaute	26	42	39	41
8	Hoffenheim	26	49	44	38
9	Freiburg	26	40	48	30
10	SpVgg	26	33	48	29
11	Stuttgarter	26	30	49	28
12	Sandhausen	26	33	72	21
13	1860	26	29	52	20
14	Kickers	26	28	78	14

TEMPORADA 2015/2016

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Stuttgart	26	61	25	62
2	Bayern	26	78	46	59
3	Hoffenheim	26	62	37	50
4	Augsburg	26	41	35	42
5	Karlsruher	26	48	49	41
6	Stuttgarter	26	35	34	40
7	Eintracht	26	41	43	35
8	Kaiserslaute	26	46	51	35
9	Mainz	26	36	44	33
10	1860	26	32	36	30
11	Freiburg	26	29	40	26
12	Greuther	26	36	43	25
13	Nürnberg	26	30	50	18
14	Elversberg	26	27	69	12

TEMPORADA 2014/2015

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Stuttgart	26	62	29	59
2	Hoffenheim	26	72	36	54
3	Karlsruher	26	59	34	50
4	Greuther	26	73	51	47
5	Bayern	26	58	42	45
6	Kaiserslaute	26	40	32	43
7	Mainz	26	53	41	41
8	Freiburg	26	56	38	40
9	Nürnberg	26	41	36	37
10	1860	26	40	38	34
11	Eintracht	26	30	39	28
12	SpVgg	26	24	76	21
13	1846	26	27	67	11
14	Saarbrücken	26	14	90	3

TEMPORADA 2013/2014

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Mainz	26	51	28	58
2	Stuttgart	26	73	31	51
3	Greuther	26	61	40	48
4	Hoffenheim	26	65	42	47
5	Karlsruher	26	61	47	45
6	Bayern	26	54	46	41
7	1860	26	46	34	40
8	Nürnberg	26	47	54	36
9	Freiburg	26	44	47	34
10	Kaiserslaute	26	32	44	29
11	Eintracht	26	42	60	28
12	Frankfurt	26	47	76	24
13	Augsburg	26	29	60	15
14	Ingolstadt	26	24	67	11

TEMPORADA 2012/2013

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Stuttgart	26	59	26	55
2	Freiburg	26	51	21	53
3	Nürnberg	26	43	23	53
4	Greuther	26	55	34	51
5	Hoffenheim	26	49	36	44
6	1860	26	36	31	42
7	Mainz	26	58	35	39
8	Bayern	26	52	48	39
9	Eintracht	26	38	36	37
10	Augsburg	26	31	44	35
11	Karlsruher	26	29	51	24
12	Kaiserslaute	26	31	56	19
13	Jahn	26	24	75	16
14	Waldhof	26	27	67	13

TEMPORADA 2011/2012

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nürnberg	26	61	31	53
2	Stuttgart	26	62	27	52
3	Eintracht	26	55	25	50
4	Bayern	26	59	34	46
5	1860	26	53	35	46
6	Mainz	26	49	30	44
7	Karlsruher	26	40	29	44
8	Hoffenheim	26	48	40	38
9	Freiburg	26	58	44	36
10	Augsburg	26	36	41	31
11	Greuther	26	30	50	25
12	SpVgg	26	41	69	22
13	Freiberg	26	21	89	10
14	Frankfurt	26	23	92	9

TEMPORADA 2010/2011

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Stuttgart	26	67	21	60
2	Hoffenheim	26	46	22	53
3	Eintracht	26	65	25	52
4	Bayern	26	56	16	52
5	Freiburg	26	46	25	50
6	Nürnberg	26	41	30	42
7	1860	26	26	31	38
8	Mainz	26	39	59	34
9	Karlsruher	26	38	44	32
10	Greuther	26	32	50	29
11	Augsburg	26	30	52	22
12	Waldhof	26	28	61	20
13	1846	26	20	54	17
14	Kaiserslaute	26	14	58	13

TEMPORADA 2009/2010

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Eintracht	26	57	11	62
2	Stuttgart	26	58	36	49
3	1860	26	46	28	47
4	Nürnberg	26	54	34	46
5	Freiburg	26	53	35	45
6	Bayern	26	59	36	42
7	Greuther	26	38	25	41
8	Hoffenheim	26	34	33	36
9	Kaiserslaute	26	42	43	36
10	1846	26	36	44	36
11	Karlsruher	26	38	40	32
12	Wacker	26	40	45	27
13	Pirmasens	26	18	72	8
14	Ergenzingen	26	18	109	5

TEMPORADA 2008/2009

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bayern	26	57	23	61
2	Stuttgart	26	69	21	55
3	1860	26	61	29	54
4	Kaiserslaute	26	56	32	48
5	Nürnberg	26	45	36	48
6	Hoffenheim	26	39	48	33
7	Greuther	26	49	50	31
8	Karlsruher	26	37	53	31
9	Freiburg	26	39	58	31
10	Eintracht	26	32	39	30
11	1846	26	34	55	25
12	Mainz	26	34	46	22
13	Saarbrücken	26	27	49	22
14	Kickers	26	32	72	11

TEMPORADA 2007/2008

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hoffenheim	26	71	26	63
2	Kaiserslaute	26	61	31	60
3	Stuttgart	26	59	32	50
4	Eintracht	26	59	42	44
5	Nürnberg	26	43	24	39
6	Bayern	26	44	33	39
7	Karlsruher	26	42	41	38
8	Mainz	26	40	41	36
9	Saarbrücken	26	41	50	31
10	1860	26	29	35	29
11	Freiburg	26	38	52	28
12	Stuttgarter	26	34	56	24
13	Jahn	26	17	46	24
14	Rosenhöhe	26	21	90	6

Competiciones que juega

Grupo 2

Bundesliga Sub 17 Grupo 2

Pos	Equipos		Pts
1		Eintracht Frankfurt Sub 17	63
2		Stuttgart Sub 17	59
3		Bayern München Sub 17	59
4		1. FC Nürnberg Sub 17	53
5		Hoffenheim Sub 17	43
6		FC Augsburg Sub 17	41
7		Karlsruher SC Sub 17	37
8		Mainz 05 Sub 17	35
9		SC Freiburg Sub 17	32
10		1. FC Kaiserslautern Sub 1.	23
11		SSV Jahn Regensburg Sub 17	22
12		TSV 1860 München Sub 17	21
13		Ingolstadt Sub 17	20
14		Heidenheim Sub 17	9

	Series Finales : Eintracht Frankfurt Sub 17
	Descenso : TSV 1860 München Sub 17, Ingolstadt Sub 17, Heidenheim Sub 17

RIVALES EN Bundesliga Sub 1.

USO DE MEMORIA

6,884,952 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8079
Total Execution Time	0.8091

CADENA URL

/historico/Stuttgart-Sub-15

GET DATOS

$_GET['/historico/Stuttgart-Sub-15']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0157	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 = 'Stuttgart-Sub-15' 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.0146	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=109906 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=109906 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0298	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 = 72766
0.0151	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=109906 AND type_rel = 2
0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2021 AND type_rel = 3
0.0156	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2021 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0164	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 (1241729,1237020,1178797,1135514,949672) ORDER BY n.cover_points DESC, update_date DESC
0.0165	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 = '109906' ORDER BY l.year DESC,cat.coefficient DESC
0.0171	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 = '109906' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0163	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 = '109906' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0154	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 = 72766 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0164	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=109906 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0150	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 (72766) 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 = 72766 AND teamId = 109906
0.0162	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 = 72766 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0153	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 = '109906' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '109906' and rp.type = 4
0.0154	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 = '109906' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0197	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 = 72766 WHERE rp.league_id = 72766 AND rp.teamId = 109906 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.0154	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 = 72766 WHERE rp.league_id = 72766 AND rp.teamId = 109906 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 = 72766 WHERE rp.league_id = 72766 AND rp.teamId = 109906 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 109906 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152	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 = 72766 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.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* `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 = 68736 AND t.round = 17 ORDER BY team.conference ASC,t.position 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* `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 = 71424 AND t.round = 5 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* `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 = 71661 AND t.round = 3 ORDER BY team.conference ASC,t.position 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* `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 = 63885 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 57818 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	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 = 50611 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169	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 = 44485 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 42571 AND t.round = 26 ORDER BY team.conference 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* `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 = 44044 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 44047 AND t.round = 26 ORDER BY team.conference 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* `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 = 44050 AND t.round = 26 ORDER BY team.conference 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* `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 = 44053 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* `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 = 44057 AND t.round = 26 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* `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 = 44060 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 44063 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 44105 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 44106 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 44107 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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 = 72766 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

Stuttgart Sub 17

Stuttgart Sub 17

Selecciona un equipo

Competiciones que juega

Bundesliga Sub 17 Grupo 2

RIVALES EN Bundesliga Sub 1.