Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Schalke 04 Sub 17

Temporada 2023/2024

TEMPORADA 2023/2024

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Leverkusen	26	74	17	68
2	Dortmund	26	89	18	66
3	Schalke	26	61	24	57
4	Paderborn	26	62	33	51
5	Mönchenglad	26	55	38	46
6	Bochum	26	46	31	40
7	Köln	26	50	47	38
8	Rot-Weiss	26	45	56	26
9	Rot-Weiß	26	31	50	25
10	Duisburg	26	35	64	25
11	Fortuna	26	25	45	24
12	Arminia	26	37	72	20
13	Viktoria	26	36	78	18
14	Waltrop	26	16	89	7

TEMPORADA 2022/2023

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schalke	15	43	3	41
2	Arminia	15	56	23	35
3	Leverkusen	15	46	18	34
4	Mönchenglad	15	30	16	32
5	Dortmund	15	48	16	29
6	Köln	15	49	30	28
7	Bochum	15	34	26	27
8	Fortuna	15	33	29	21
9	Paderborn	15	25	33	19
10	Duisburg	15	19	28	17
11	Rot-Weiss	15	19	26	15
12	Hennef	15	20	32	15
13	Preußen	15	18	32	13
14	Siegen	15	19	50	9
15	Fortuna	15	14	55	7
16	Deutz	15	11	67	0

TEMPORADA 2021/2022

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Schalke	16	48	6	43
2	Fortuna	16	47	16	41
3	Mönchenglad	16	42	10	38
4	Dortmund	16	40	17	31
5	Bochum	16	47	25	30
6	Preußen	16	31	26	28
7	Paderborn	16	35	26	27
8	Köln	16	29	22	23
9	Fortuna	16	17	28	22
10	Rot-Weiss	16	18	31	22
11	Leverkusen	16	21	25	20
12	Arminia	16	26	28	20
13	Hennef	16	16	26	18
14	Alemannia	16	16	41	11
15	Lippstadt	16	13	46	9
16	Unterrath	16	12	40	7
17	Wuppertaler	16	7	52	2

TEMPORADA 2020/2021

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Mönchenglad	4	14	4	10
2	Dortmund	5	16	7	10
3	Köln	5	11	7	10
4	Fortuna	5	10	7	10
5	Preußen	5	11	7	8
6	Schalke	4	9	5	8
7	Unterrath	5	7	5	8
8	Leverkusen	3	10	3	7
9	Bochum	4	9	5	7
10	Paderborn	5	9	10	7
11	Hennef	5	8	10	6
12	Arminia	5	8	12	5
13	Fortuna	4	3	5	4
14	Rot-Weiss	3	2	5	3
15	Lippstadt	4	5	14	0
16	Alemannia	3	1	13	0
17	Wuppertaler	5	6	20	0

TEMPORADA 2019/2020

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Köln	21	85	14	54
2	Dortmund	21	65	22	52
3	Schalke	21	46	17	42
4	Mönchenglad	20	43	16	41
5	Leverkusen	20	53	26	38
6	Bochum	21	25	23	29
7	Preußen	21	20	45	23
8	Fortuna	21	29	41	22
9	Alemannia	21	37	56	19
10	Lippstadt	20	16	52	19
11	Hennef	21	21	34	18
12	Arminia	21	18	41	18
13	Unterrath	21	24	46	17
14	Wuppertaler	20	18	67	15

TEMPORADA 2018/2019

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dortmund	26	93	14	68
2	Köln	26	81	22	59
3	Leverkusen	26	81	24	59
4	Mönchenglad	26	66	27	49
5	Schalke	26	44	37	42
6	Bochum	26	47	35	41
7	Fortuna	26	27	23	39
8	Arminia	26	36	55	32
9	Preußen	26	24	41	28
10	Hennef	26	36	68	26
11	Unterrath	26	19	60	26
12	Duisburg	26	17	52	18
13	Rot-Weiss	26	16	73	10
14	Paderborn	26	22	78	8

TEMPORADA 2017/2018

BUNDESLIGA SUB 17 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dortmund	26	88	22	65
2	Leverkusen	26	55	21	56
3	Schalke	26	48	16	54
4	Mönchenglad	26	58	35	51
5	Köln	26	59	24	46
6	Bochum	26	34	22	45
7	Arminia	26	31	34	36
8	Fortuna	26	30	29	35
9	Preußen	26	23	37	22
10	Duisburg	26	23	43	22
11	Unterrath	26	19	52	21
12	Hombrucher	26	24	62	21
13	Viktoria	26	26	60	18
14	Alemannia	26	15	76	16

TEMPORADA 2016/2017

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schalke	26	64	20	65
2	Dortmund	26	69	24	56
3	Leverkusen	26	48	24	51
4	Köln	26	54	28	47
5	Bochum	26	37	26	44
6	Mönchenglad	26	53	32	40
7	Duisburg	26	41	33	40
8	Fortuna	26	41	34	34
9	Viktoria	26	46	55	34
10	Arminia	26	41	46	30
11	Hombrucher	26	21	33	29
12	Rot-Weiss	26	38	41	28
13	Hennef	26	17	83	9
14	Mönchenglad	26	11	102	2

TEMPORADA 2015/2016

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dortmund	26	82	20	67
2	Leverkusen	26	75	19	65
3	Schalke	26	82	20	62
4	Duisburg	26	34	26	42
5	Bochum	26	39	37	35
6	Mönchenglad	26	35	29	34
7	Rot-Weiss	26	47	43	34
8	Hennef	26	31	55	33
9	Köln	26	48	49	32
10	Fortuna	26	33	40	32
11	Arminia	26	30	47	31
12	Paderborn	26	25	45	23
13	Rot-Weiß	26	26	84	14
14	Siegen	26	10	83	6

TEMPORADA 2014/2015

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dortmund	26	82	28	64
2	Leverkusen	26	58	18	58
3	Köln	26	60	25	51
4	Mönchenglad	26	47	37	41
5	Schalke	26	57	33	40
6	Arminia	26	30	40	37
7	Fortuna	26	37	37	36
8	Duisburg	26	43	44	36
9	Bochum	26	49	36	34
10	Paderborn	26	34	44	33
11	Rot-Weiss	26	24	36	31
12	Preußen	26	32	54	27
13	Viktoria	26	33	83	15
14	Euskirchener	26	26	97	11

TEMPORADA 2013/2014

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dortmund	26	70	11	66
2	Bochum	26	76	32	55
3	Schalke	26	53	16	53
4	Leverkusen	26	62	25	52
5	Mönchenglad	26	68	32	47
6	Duisburg	26	41	35	39
7	Köln	26	36	38	36
8	Rot-Weiss	26	22	29	33
9	Arminia	26	26	42	33
10	Preußen	26	38	66	23
11	Euskirchener	26	27	65	23
12	Bonner	26	24	47	22
13	Düsseldorf	26	23	68	17
14	Alemannia	26	17	77	10

TEMPORADA 2012/2013

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schalke	26	110	19	70
2	Mönchenglad	26	74	24	66
3	Leverkusen	26	43	31	48
4	Bochum	26	43	22	46
5	Dortmund	26	48	27	45
6	Köln	26	55	32	43
7	Duisburg	26	48	51	36
8	Bonner	26	37	57	30
9	Alemannia	26	29	41	27
10	Rot-Weiss	26	22	37	26
11	Preußen	26	28	63	26
12	Fortuna	26	28	43	25
13	Rot-Weiß	26	20	68	20
14	Siegen	26	18	88	10

TEMPORADA 2011/2012

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Köln	26	68	24	59
2	Schalke	26	80	33	57
3	Dortmund	26	60	29	52
4	Mönchenglad	26	58	28	47
5	Leverkusen	26	46	20	44
6	Bochum	26	40	35	38
7	Duisburg	26	45	44	38
8	Preußen	26	29	43	36
9	Rot-Weiss	26	42	49	29
10	Fortuna	26	27	42	29
11	Bonner	26	21	50	24
12	Arminia	26	27	69	24
13	Paderborn	26	21	48	16
14	Bergisch	26	22	72	16

TEMPORADA 2010/2011

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Köln	26	88	27	68
2	Dortmund	26	83	34	61
3	Bochum	26	72	31	54
4	Leverkusen	26	82	39	52
5	Arminia	26	72	47	47
6	Schalke	26	62	42	43
7	Rot-Weiss	26	48	38	41
8	Duisburg	26	47	49	38
9	Mönchenglad	26	45	51	34
10	Preußen	26	49	59	32
11	Bergisch	26	26	61	19
12	Alemannia	26	33	71	17
13	Wattenscheid	26	17	81	14
14	Wuppertaler	26	16	110	4

TEMPORADA 2009/2010

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Leverkusen	26	74	25	65
2	Schalke	26	63	28	56
3	Mönchenglad	26	52	16	50
4	Köln	26	40	30	45
5	Dortmund	26	52	42	41
6	Duisburg	26	45	45	39
7	Rot-Weiss	26	36	41	38
8	Preußen	26	40	49	36
9	Arminia	26	40	48	34
10	Alemannia	26	33	43	28
11	Wattenscheid	26	32	48	24
12	Bonner	26	28	50	24
13	Fortuna	26	28	48	21
14	Troisdorf	26	15	65	9

TEMPORADA 2008/2009

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mönchenglad	26	68	14	67
2	Köln	26	65	28	55
3	Leverkusen	26	47	27	50
4	Dortmund	26	45	31	39
5	Duisburg	26	37	36	37
6	Schalke	26	40	38	36
7	Arminia	26	34	39	36
8	Rot-Weiss	26	37	48	32
9	Troisdorf	26	34	45	29
10	Alemannia	26	38	39	27
11	Preußen	26	26	43	27
12	Wuppertaler	26	21	37	25
13	Bochum	26	29	57	20
14	Eintracht	26	28	67	19

TEMPORADA 2007/2008

BUNDESLIGA SUB 17 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dortmund	26	81	38	59
2	Mönchenglad	26	58	32	50
3	Schalke	26	68	38	46
4	Leverkusen	26	59	49	46
5	Arminia	26	42	34	46
6	Bochum	26	44	29	45
7	Köln	26	56	39	38
8	Duisburg	26	34	39	29
9	Preußen	26	30	50	29
10	Rot-Weiss	26	28	49	29
11	Alemannia	26	38	48	28
12	Bonner	26	38	64	25
13	Wattenscheid	26	16	47	20
14	Fortuna	26	24	60	18

Competiciones que juega

Grupo 3

Bundesliga Sub 17 Grupo 3

Pos	Equipos		Pts
1		B. Leverkusen Sub 17	68
2		B. Dortmund Sub 17	66
3		Schalke 04 Sub 17	57
4		Paderborn Sub 17	51
5		B. Mönchengladbach Sub 17	46
6		VfL Bochum Sub 17	40
7		Köln Sub 17	38
8		Rot-Weiss Essen Sub 17	26
9		Rot-Weiß Oberhausen Sub 17	25
10		MSV Duisburg Sub 17	25
11		Fortuna Düsseldorf Sub 17	24
12		Arminia Bielefeld Sub 17	20
13		Viktoria Köln Sub 17	18
14		VFB Waltrop Sub 17	7

	Series Finales : B. Leverkusen Sub 17, B. Dortmund Sub 17
	Descenso : Arminia Bielefeld Sub 17, Viktoria Köln Sub 17, VFB Waltrop Sub 17

RIVALES EN Bundesliga Sub 1.

USO DE MEMORIA

6,760,688 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1921
Total Execution Time	0.1942

CADENA URL

/historico/Schalke-04-Sub-15

GET DATOS

$_GET['/historico/Schalke-04-Sub-15']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0029	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 = 'Schalke-04-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.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=109928 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=109928 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0046	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 = 72767
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=109928 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2021 AND type_rel = 3
0.0022	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.0035	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.0031	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 = '109928' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '109928' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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 = 72767 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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=109928 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0025	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 (72767) 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.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 72767 AND teamId = 109928
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 = 72767 WHERE rp.league_id = 72767 AND rp.teamId = 109928 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.0035	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 = 72767 WHERE rp.league_id = 72767 AND rp.teamId = 109928 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 = 72767 WHERE rp.league_id = 72767 AND rp.teamId = 109928 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 109928 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72767 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.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* `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 = 68735 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* `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 = 63886 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.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* `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 = 57819 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.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* `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 = 50612 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.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* `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 = 44486 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041	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 = 42572 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* `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 = 44043 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 44046 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* `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 = 44049 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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 = 44052 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* `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 = 44056 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 44059 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* `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 = 44062 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* `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 = 44102 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 = 44103 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* `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 = 44104 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿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

Schalke 04 Sub 17

Schalke 04 Sub 17

Selecciona un equipo

Competiciones que juega

Bundesliga Sub 17 Grupo 3

RIVALES EN Bundesliga Sub 1.