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

SD Indautxu

Temporada 2023/2024

TEMPORADA 2023/2024

DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Santurtzi	27	51	26	58
2	Sodupe	27	35	29	50
3	Zalla	27	33	20	48
4	SD Zamudio	27	39	28	47
5	Club Bermeo	27	25	21	43
6	CD Getxo	27	24	22	37
7	Pedro	28	41	42	37
8	Galdakao	27	29	30	37
9	Santutxu	27	38	28	36
10	Uritarra CD	27	28	21	36
11	SD Erandio	27	33	34	34
12	Somorrostro	28	33	41	33
13	Dínamo Juan	27	40	40	32
14	Arratia CD	27	22	30	29
15	Iurretako	27	28	43	27
16	Balmaseda	27	25	33	26
17	Iturrigorri	27	24	46	26
18	SD Indautxu	27	23	37	23

TEMPORADA 2022/2023

DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Derio	38	63	29	79
2	Santurtzi	38	79	40	74
3	SD Erandio	38	54	37	63
4	Somorrostro	38	60	50	63
5	Uritarra CD	38	55	47	61
6	Club Bermeo	38	39	25	60
7	Pedro	38	59	55	58
8	Santutxu	38	49	32	56
9	Zalla	38	59	47	55
10	SD Zamudio	38	49	48	54
11	Balmaseda	38	45	44	52
12	Sodupe	38	63	60	51
13	SD Indautxu	38	43	47	50
14	Dínamo Juan	38	50	55	47
15	Galdakao	38	48	65	44
16	CD Getxo	38	47	41	43
17	Iurretako	38	39	47	42
18	Abanto Club	38	43	70	41
19	Abadiño KE	38	36	67	30
20	CD Elorrio	38	31	105	10

TEMPORADA 2021/2022

DIVISIÓN HONOR PAÍS VASCO GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	CD Padura	30	40	24	57
2	Dínamo Juan	30	47	29	55
3	SD Erandio	30	40	20	53
4	Santurtzi	30	37	21	53
5	SD Zamudio	30	56	45	49
6	CD Derio	30	41	36	43
7	Balmaseda	30	41	42	41
8	Club Bermeo	30	34	39	41
9	SD Indautxu	30	31	29	40
10	Pedro	30	27	32	37

TEMPORADA 2020/2021

DIVISIÓN HONOR PAÍS VASCO GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Uritarra CD	19	33	14	42
2	SD Zamudio	19	33	14	40
3	Galdakao	19	33	19	36
4	Dínamo Juan	19	24	14	35
5	Club Bermeo	19	33	21	34
6	SD Erandio	19	29	21	31
7	SD Indautxu	19	19	17	31
8	CD Getxo	19	32	19	29
9	Iurretako	19	19	18	26
10	CD Elorrio	19	20	21	24
11	CD Derio	19	23	29	24
12	CD Padura	19	18	23	23
13	Cd Sondika	19	24	30	23
14	Pedro	19	16	20	22
15	Abanto Club	19	22	26	20
16	Gatika KT	19	13	28	20
17	SD Basurto	19	17	33	19
18	Otxarkoaga	19	18	27	18
19	Gernika B	19	14	33	17
20	Abadiño KE	19	13	26	14

TEMPORADA 2019/2020

DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Aurrera KE	24	35	18	46
2	CD Elorrio	24	29	13	45
3	CD Getxo	24	38	22	44
4	Gernika B	24	37	28	41
5	Pedro	24	34	28	39
6	SD Zamudio	24	33	34	36
7	Gatika KT	24	21	22	36
8	Uritarra CD	24	32	23	34
9	CD Padura	24	30	23	33
10	CD Derio	24	26	30	33
11	Abanto Club	24	35	33	30
12	Club Bermeo	24	22	27	30
13	Iurretako	24	29	25	29
14	Dínamo Juan	24	18	27	26
15	SD Indautxu	24	28	36	24
16	SD Erandio	24	24	36	24
17	Galdakao	24	20	38	24
18	Cd Sondika	24	19	47	14

TEMPORADA 2014/2015

DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deusto	34	48	24	70
2	CD Getxo	34	56	29	64
3	Somorrostro	34	52	27	63
4	Retuerto	34	37	21	57
5	Sodupe	34	39	30	56
6	Iurretako	34	46	28	53
7	Apurtuarte	34	42	41	52
8	Sondika	34	32	26	51
9	Gallarta	34	37	38	47
10	Gatika KT	34	38	40	44
11	Derio	34	26	31	42
12	CD Elorrio	34	35	36	40
13	Urduliz FT	34	39	50	40
14	CD Loiu	34	40	48	39
15	Abanto Club	34	39	48	36
16	CD Padura	34	28	44	34
17	Gurutzeta	34	28	57	24
18	SD Indautxu	34	31	75	20

TEMPORADA 2011/2012

DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Getxo	34	58	38	66
2	Club Bermeo	34	63	38	65
3	Somorrostro	34	44	34	58
4	Deusto	34	52	35	56
5	Sondika	34	53	45	50
6	Apurtuarte	34	47	55	49
7	Gallarta	34	46	59	49
8	Gatika KT	34	49	40	48
9	Sodupe	34	47	42	48
10	Derio	34	37	32	47
11	SD Erandio	34	41	40	47
12	Santurtzi	34	39	52	39
13	Gurutzeta	34	36	39	37
14	Pedro	34	45	53	37
15	CD Elorrio	34	26	32	35
16	Ugeraga	34	34	48	34
17	Galdakao	34	36	54	32
18	SD Indautxu	34	30	47	27

TEMPORADA 2010/2011

DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Balmaseda	34	56	26	71
2	Somorrostro	34	51	26	66
3	Sondika	34	60	40	61
4	Club Bermeo	34	61	49	56
5	Gallarta	34	42	39	50
6	Deusto	34	37	34	50
7	CD Getxo	34	48	40	48
8	SD Indautxu	34	44	38	47
9	Derio	34	38	49	44
10	Sodupe	34	33	37	40
11	Apurtuarte	34	40	51	40
12	Pedro	34	41	47	39
13	Galdakao	34	28	38	39
14	Gurutzeta	34	37	46	35
15	Berriz	34	40	67	35
16	Retuerto	34	38	43	34
17	Ugeraga	34	36	46	34
18	SD Basurto	34	35	49	31

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sestao River	38	71	14	90
2	SD Gernika	38	47	23	69
3	Amorebieta	38	44	26	67
4	CD Basconia	38	53	33	64
5	Arenas Getxo	38	39	39	56
6	Laudio	38	50	53	54
7	Pedro	38	50	40	53
8	Lagun Onak	38	40	42	53
9	Eibar B	38	38	30	52
10	Vasconia	38	33	33	51
11	CD Elgoibar	38	32	37	51
12	Santurtzi	38	38	38	49
13	Tolosa CF	38	39	31	49
14	Beasain KE	38	38	37	47
15	Aurrera	38	39	43	47
16	SD Zamudio	38	35	46	41
17	SD Indautxu	38	32	42	38
18	CD Getxo	38	27	53	33
19	Aurrera KE	38	30	50	30
20	Salvatierra	38	27	92	23

TEMPORADA 2004/2005

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Portugalete	38	75	29	83
2	Zalla	38	58	29	75
3	SD Gernika	38	51	25	74
4	SCD Durango	38	52	30	70
5	SD Zamudio	38	40	26	65
6	Beasain KE	38	47	38	64
7	Arenas Getxo	38	39	32	52
8	CD Basconia	38	53	46	51
9	SD Indautxu	38	42	49	50
10	Aurrera KE	38	29	36	50
11	Lagun Onak	38	37	42	47
12	Pedro	38	51	50	47
13	Amorebieta	38	43	47	47
14	Laudio	38	44	46	45
15	Eibar B	38	33	47	45
16	CD Elgoibar	37	51	55	43
17	Aurrera	37	37	46	43
18	Deportivo	38	44	52	39
19	Real	38	31	58	31
20	Bruno	38	23	97	16

TEMPORADA 2003/2004

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sestao River	76	124	48	156
2	Lemona	76	136	52	152
3	CD Basconia	76	128	64	142
4	Eibar B	76	86	50	140
5	Portugalete	76	126	76	138
6	Beasain KE	76	84	70	130
7	Zalla	76	78	64	116
8	SD Gernika	76	74	54	110
9	SD Indautxu	76	74	96	100
10	SD Zamudio	76	90	92	96
11	Aurrera	76	62	66	96
12	Arenas Getxo	76	70	84	96
13	Amorebieta	76	68	80	94
14	Lagun Onak	76	68	64	94
15	Aurrera KE	76	72	110	78
16	Deportivo	76	76	112	74
17	Laudio	76	62	114	72
18	Pasajes	76	76	118	70
19	Vasconia	76	62	138	54
20	Club Bermeo	76	70	134	54

TEMPORADA 2002/2003

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	CD Basconia	38	56	34	71
2	Real	38	64	33	70
3	Zalla	38	40	31	66
4	Lemona	38	55	31	62
5	SD Indautxu	38	50	29	61
6	Beasain KE	38	37	31	61
7	Lagun Onak	38	47	41	58
8	Sestao River	38	46	31	57
9	Aurrera KE	38	49	47	52
10	Arenas Getxo	38	38	44	49
11	Portugalete	38	50	48	49
12	Eibar B	38	42	40	47
13	Amorebieta	38	39	43	47
14	Club Bermeo	38	34	41	46
15	Vasconia	38	33	47	46
16	Deportivo	38	31	39	45
17	SCD Durango	38	34	40	44
18	Pedro	38	24	52	32
19	San Ignacio	38	30	68	32
20	Aurrera	38	25	54	26

TEMPORADA 1969/1970

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Racing	38	104	26	63
2	Júpiter	38	82	36	58
3	Sestao Sport	38	93	35	56
4	Gimnástica	38	76	34	54
5	Barakaldo	38	62	41	47
6	Ponferradina	38	57	49	45
7	Palencia	38	65	51	44
8	CD Basconia	38	65	44	43
9	Deportivo	38	71	39	43
10	SD Indautxu	38	55	48	38
11	CD Getxo	38	54	47	37
12	Cacabelense	38	53	66	36
13	Laudio	38	54	75	31
14	SD Erandio	38	45	68	28
15	Arenas Getxo	38	44	68	28
16	CD Laredo	38	42	77	27
17	Rayo	38	38	73	25
18	Cultural	38	34	82	25
19	Hullera	38	38	103	16
20	Sporting	38	30	100	16

TEMPORADA 1968/1969

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Sevilla	38	56	30	53
2	Celta	38	63	28	52
3	Mallorca	38	62	37	50
4	Racing	38	55	39	47
5	Real	38	60	46	42
6	Puertollano	38	47	41	42
7	Real Betis	38	69	51	41
8	Real Murcia	38	52	48	40
9	Rayo	38	51	44	40
10	Real	38	61	48	39
11	Real Oviedo	38	45	45	38
12	Burgos	38	47	53	38
13	Alcoyano	38	51	55	35
14	Deportivo	38	47	62	35
15	Ontinyent	38	47	54	34
16	Ilicitano	38	50	58	32
17	Valencia	38	53	62	30
18	Cádiz	38	44	65	30
19	SD Indautxu	38	40	79	24
20	Jerez	38	36	91	18

TEMPORADA 1967/1968

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	SD Indautxu	30	68	28	48
2	Barakaldo	30	66	25	44
3	Bilbao Ath.	30	71	30	43
4	Laudio	30	60	33	40
5	Sestao Sport	30	56	42	34
6	CD Basconia	30	47	48	33
7	Arenas Getxo	30	37	38	29
8	CD Getxo	30	40	38	27
9	Rayo	30	45	48	27
10	SD Erandio	30	35	41	27
11	Santurtzi	30	43	48	26
12	Amorebieta	30	47	62	23
13	Deusto	30	34	62	22
14	Portugalete	30	28	54	21
15	UM Escobedo	30	36	73	21
16	Galdakao	30	23	66	15

TEMPORADA 1966/1967

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real	30	46	22	46
2	Real	30	55	22	45
3	Celta	30	43	25	36
4	Osasuna	30	52	39	35
5	Real Oviedo	30	57	38	35
6	Rayo	30	45	31	30
7	Racing	30	41	30	30
8	Puertollano	30	38	38	30
9	Real	30	38	43	29
10	Gimnástica	30	33	53	28
11	Tenerife	30	40	47	28
12	Racing	30	42	53	26
13	Langreo	30	32	42	25
14	Burgos	30	40	49	23
15	Logroñés	30	16	47	18
16	SD Indautxu	30	17	56	16

TEMPORADA 1965/1966

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	30	53	19	43
2	Celta	30	54	28	39
3	Real	30	67	50	36
4	Real Oviedo	30	38	22	34
5	Burgos	30	42	41	32
6	SD Indautxu	30	47	47	32
7	Condal CD	30	55	46	32
8	Racing	30	38	40	31
9	Osasuna	30	39	41	31
10	Real	30	50	48	31
11	Lleida	30	37	31	30
12	Badalona	30	32	41	30
13	Langreo	30	37	58	23
14	CE Europa	30	33	49	23
15	L´Hospitale	30	37	63	19
16	Barakaldo	30	24	59	14

TEMPORADA 1964/1965

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pontevedra	30	48	17	45
2	CE Sabadell	30	46	28	39
3	Real	30	61	32	38
4	Real	30	60	44	32
5	Celta	30	35	34	30
6	Burgos	30	47	46	29
7	Racing	30	52	51	29
8	SD Indautxu	30	47	44	29
9	Barakaldo	30	41	44	28
10	Osasuna	30	30	35	28
11	L´Hospitale	30	48	56	27
12	Langreo	30	40	51	27
13	CE Europa	30	30	43	27
14	Badalona	30	31	43	25
15	CD Ourense	30	33	50	25
16	Real Unión	30	24	55	22

TEMPORADA 1963/1964

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	30	74	31	42
2	Real	30	53	33	39
3	CE Europa	30	36	27	37
4	Racing	30	45	32	35
5	Osasuna	30	53	44	34
6	Real	30	48	35	33
7	Burgos	30	40	38	32
8	CD Ourense	30	34	36	31
9	Celta	30	39	37	29
10	Constància	30	33	45	28
11	Langreo	30	33	40	27
12	SD Indautxu	30	34	38	26
13	L´Hospitale	30	39	51	26
14	Badalona	30	39	57	24
15	Salamanca	30	25	46	21
16	Deportivo	30	36	71	16

Competiciones que juega

Grupo 2

División Honor País Vasco Grupo 2

Pos	Equipos		Pts
1		Santurtzi	58
2		Sodupe	50
3		Zalla	48
4		SD Zamudio	47
5		Club Bermeo	43
6		CD Getxo	37
7		SD San Pedro	37
8		Galdakao	37
9		Santutxu	36
10		Uritarra CD	36
11		SD Erandio	34
12		JD Somorrostro	33
13		Dínamo San Juan	32
14		Arratia CD	29
15		Iurretako KT	27
16		Balmaseda FC	26
17		SD Iturrigorri	26
18		SD Indautxu	23

	Ascenso : Santurtzi
	Descenso : SD Iturrigorri, SD Indautxu

RIVALES EN División Honor P.

USO DE MEMORIA

7,569,776 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.1363
Total Execution Time	0.1382

CADENA URL

/historico/Sd-Indautxu

GET DATOS

$_GET['/historico/Sd-Indautxu']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0035	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 = 'Sd-Indautxu' 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.0018	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=4711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	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=4711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4711 AND type_rel = 2
0.0027	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 = '4711' 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 = '4711' 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 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=4711 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0017	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 (73549) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 73549 AND teamId = 4711
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 = '4711' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4711' and rp.type = 4
0.0019	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 = '4711' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020	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 = 73549 WHERE rp.league_id = 73549 AND rp.teamId = 4711 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.0019	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 = 73549 WHERE rp.league_id = 73549 AND rp.teamId = 4711 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 = 73549 WHERE rp.league_id = 73549 AND rp.teamId = 4711 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 4711 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68809 AND t.round = 38 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* `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 = 66948 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 60094 AND t.round = 19 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 = 51264 AND t.round = 24 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* `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 = 4069 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* `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 = 1455 AND t.round = 34 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* `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 = 1134 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* `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 = 22116 AND t.round = 38 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 = 22097 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046	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 = 22081 AND t.round = 38 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* `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 = 22065 AND t.round = 38 ORDER BY team.conference 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* `tables1970` 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 = 21620 AND t.round = 38 ORDER BY team.conference 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* `tables1969` 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 = 5465 AND t.round = 38 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* `tables1968` 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 = 21601 AND t.round = 30 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* `tables1967` 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 = 5463 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* `tables1966` 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 = 5462 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* `tables1965` 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 = 5461 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* `tables1964` 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 = 5460 AND t.round = 30 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

SD Indautxu

SD Indautxu

Selecciona un equipo

Competiciones que juega

División Honor País Vasco Grupo 2

RIVALES EN División Honor P.