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

Sala 10 Zaragoza

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Sala	28	129	59	70
2	Antequera	28	103	65	61
3	Burela FS	28	93	59	56
4	Union	28	88	69	50
5	Full	28	100	94	49
6	Inagroup	28	88	76	43
7	Parrulo	28	99	88	40
8	Sala	28	83	90	40
9	Levante	28	80	91	38
10	Ibiza	28	90	91	31
11	Melistar	28	67	88	30
12	Barça	28	68	80	27
13	Leganes	28	61	87	25
14	Real Betis.	28	59	97	23
15	Atlético	28	66	99	21
16	Bisontes	28	50	91	21

TEMPORADA 2022/2023

SEGUNDA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Peñíscola	30	154	59	83
2	Burela FS	30	129	71	68
3	Parrulo	30	128	93	60
4	Alzira FS	30	96	78	56
5	Sala	30	118	72	55
6	Union	30	125	101	52
7	Inagroup	30	92	75	47
8	Real Betis.	30	93	106	41
9	Full	30	116	113	39
10	Barça	30	116	99	38
11	Leganes	30	82	93	37
12	Bisontes	30	69	91	35
13	Sala	30	96	141	25
14	CD El Valle	30	80	145	18
15	Atletico	30	82	163	16
16	Gran Canaria	30	81	157	13

TEMPORADA 2021/2022

PRIMERA DIVISIÓN FUTSAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Barça	30	122	63	68
2	Inter FS	30	87	68	58
3	Palma Futsal	30	78	55	58
4	Viña Albali	30	91	81	56
5	Jimbee	30	99	70	55
6	Ribera	30	88	96	45
7	Jaén FS	30	85	73	44
8	ElPozo	30	87	72	43
9	Industrias	30	90	78	42
10	Levante	30	84	91	37
11	Córdoba	30	90	91	36
12	Manzanares	30	82	100	30
13	Osasuna	30	65	98	30
14	Real Betis.	30	67	100	26
15	Sala	30	85	112	24
16	Burela FS	30	62	114	14

TEMPORADA 2020/2021

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	ElPozo	34	108	79	68
2	Palma Futsal	34	98	67	68
3	Barça	34	109	63	66
4	Jimbee	34	134	93	64
5	Levante	34	113	99	64
6	Inter FS	34	121	84	57
7	Sala	34	108	104	48
8	Viña Albali	34	107	91	47
9	Industrias	34	95	89	47
10	Real Betis.	34	86	101	46
11	Ribera	34	104	105	41
12	Osasuna	34	83	96	40
13	Córdoba	34	80	90	40
14	Jaén FS	34	73	95	38
15	Burela FS	34	102	120	38
16	Peñíscola	34	83	108	34
17	Antequera	34	75	129	22
18	Parrulo	34	80	146	20

TEMPORADA 2019/2020

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Inter FS	23	96	51	56
2	Barça	23	107	60	54
3	Viña Albali	23	81	61	45
4	ElPozo	23	75	54	44
5	Palma Futsal	23	64	38	43
6	Osasuna	23	83	67	39
7	Levante	23	82	77	34
8	Jaén FS	23	66	70	33
9	Jimbee	23	67	74	27
10	Parrulo	23	68	81	26
11	Peñíscola	23	70	72	26
12	Industrias	23	61	83	25
13	Ribera	23	52	76	19
14	Córdoba	23	51	89	17
15	Sala	23	63	86	15
16	Burela FS	23	40	87	13

TEMPORADA 2018/2019

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Barça	30	134	65	67
2	ElPozo	30	122	78	62
3	Osasuna	30	104	75	59
4	Inter FS	30	125	66	57
5	Palma Futsal	30	102	70	55
6	Jaén FS	30	94	81	49
7	Ribera	30	108	92	46
8	Levante	30	105	99	45
9	Peñíscola	30	77	79	44
10	Jimbee	30	104	109	40
11	Sala	30	82	117	33
12	Industrias	30	79	98	32
13	Parrulo	30	80	116	27
14	Viña Albali	30	83	136	22
15	Naturpellet	30	59	115	18
16	Antequera	30	67	129	14

TEMPORADA 2017/2018

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Inter FS	30	137	64	71
2	Barça	30	149	66	70
3	ElPozo	30	131	70	68
4	Jaén FS	30	119	69	64
5	Osasuna	30	123	88	62
6	Palma Futsal	30	94	77	46
7	Sala	30	96	110	45
8	Ribera	30	80	91	40
9	Jimbee	30	107	111	39
10	Levante	30	104	111	31
11	Naturpellet	30	94	142	31
12	Industrias	30	90	108	29
13	Peñíscola	30	67	92	26
14	Parrulo	30	80	116	24
15	Santiago	30	84	121	19
16	Gran Canaria	30	66	185	10

TEMPORADA 2016/2017

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Inter FS	30	151	59	75
2	ElPozo	30	148	61	71
3	Barça	30	135	70	70
4	Jaén FS	30	103	72	53
5	Palma Futsal	30	106	72	51
6	Osasuna	30	96	73	51
7	Peñíscola	30	105	94	48
8	Industrias	30	106	104	40
9	Ribera	30	70	85	34
10	Sala	30	94	119	32
11	Santiago	30	89	118	31
12	Levante	30	82	110	30
13	Gran Canaria	30	85	130	30
14	Jimbee	30	80	115	26
15	Burela FS	30	88	132	25
16	Jumilla	30	69	193	9

TEMPORADA 2015/2016

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Inter FS	30	158	57	83
2	Barça	30	157	78	74
3	ElPozo	30	130	81	63
4	Palma Futsal	30	107	80	57
5	Ribera	30	91	75	52
6	Osasuna	30	111	85	48
7	Industrias	30	129	125	44
8	Peñíscola	30	117	116	41
9	Burela FS	30	92	108	40
10	Santiago	30	99	117	31
11	Sala	30	109	125	31
12	Jaén FS	30	86	111	28
13	Levante	30	72	128	23
14	Jumilla	30	85	135	21
15	Elche Sala	30	75	156	17
16	Antequera	30	97	138	17

TEMPORADA 2014/2015

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Inter FS	30	152	60	79
2	Barça	30	149	67	74
3	ElPozo	30	152	71	73
4	Jaén FS	30	113	79	54
5	Palma Futsal	30	122	105	53
6	Osasuna	30	115	98	52
7	Ribera	30	101	91	51
8	Peñíscola	30	116	93	47
9	Burela FS	30	97	100	37
10	Sala	30	105	119	36
11	Industrias	30	140	134	32
12	Santiago	30	80	103	32
13	Jumilla	30	119	135	28
14	Levante	30	75	124	26
15	Uruguay	30	72	205	9
16	Prone Lugo	30	59	183	5

TEMPORADA 2013/2014

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Inter FS	28	148	58	76
2	ElPozo	28	139	69	68
3	Barça	28	115	46	68
4	Industrias	28	115	98	50
5	Osasuna	28	92	95	44
6	Jumilla	28	90	92	41
7	Ribera	28	74	80	39
8	Santiago	28	76	79	37
9	Burela FS	28	71	77	37
10	Jaén FS	28	59	83	27
11	Palma Futsal	28	87	117	26
12	Peñíscola	28	57	90	25
13	Sala	28	74	108	23
14	Prone Lugo	28	70	108	22
15	Gran Canaria	28	64	131	11

TEMPORADA 2012/2013

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Barça	26	133	45	67
2	ElPozo	26	117	62	59
3	Inter FS	26	103	50	57
4	Naturpellet	26	103	79	53
5	Sala	26	83	75	47
6	Osasuna	26	91	82	45
7	Santiago	26	85	71	43
8	Ribera	26	88	96	36
9	Industrias	26	110	123	32
10	Palma Futsal	26	64	81	21
11	Prone Lugo	26	75	115	21
12	Burela FS	26	48	87	19
13	Puertollano	26	37	116	11
14	Gran Canaria	26	54	109	8

TEMPORADA 2011/2012

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	ElPozo	30	153	69	79
2	Barça	30	149	65	74
3	Inter FS	30	123	61	64
4	Naturpellet	30	98	81	49
5	Santiago	30	85	75	47
6	Carnicer	30	101	95	45
7	Osasuna	30	92	100	45
8	Sala	30	95	96	43
9	Puertollano	30	88	98	39
10	Palma Futsal	30	98	108	37
11	Talavera	30	83	112	36
12	Ribera	30	84	106	33
13	Prone Lugo	30	93	125	29
14	Industrias	30	71	106	28
15	Cartagena	30	80	142	24
16	Benicarló	30	41	95	11

TEMPORADA 2010/2011

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	Barça	30	127	63	70
2	ElPozo	30	138	90	65
3	Inter FS	30	111	75	61
4	Santiago	30	133	94	59
5	Palma Futsal	30	107	87	56
6	Benicarló	32	87	80	50
7	Naturpellet	30	104	95	48
8	Osasuna	30	100	96	42
9	Sala	30	93	91	40
10	Carnicer	30	95	101	35
11	Prone Lugo	30	98	105	35
12	Talavera	30	78	96	35
13	Cartagena	30	102	116	34
14	Industrias	32	85	107	30
15	Playas	30	59	108	28
16	Gestesa	30	55	168	3

TEMPORADA 2009/2010

PRIMERA DIVISIÓN FUTSAL
Equipo		PJ	GF	GC	Puntos
1	ElPozo	30	143	84	72
2	Inter FS	30	103	68	64
3	Naturpellet	30	112	77	61
4	Santiago	30	120	86	60
5	Barça	30	97	57	57
6	Industrias	30	106	107	43
7	Osasuna	30	94	92	42
8	Carnicer	30	117	124	40
9	Prone Lugo	30	92	113	40
10	Gestesa	30	106	119	38
11	Playas	30	61	84	33
12	Sala	30	93	103	32
13	Cartagena	30	103	120	32
14	Benicarló	30	70	90	23
15	Arcebansa	30	92	122	22
16	Punctum	30	67	130	15

TEMPORADA 2008/2009

SEGUNDA DIVISIÓN FUTSAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Arcebansa	20	74	44	44
2	Sala	20	92	65	44
3	Burela FS	20	74	36	42
4	Ramos	20	75	65	33
5	Sport Sala.	20	77	88	29
6	Bp Andorra	20	78	79	28
7	Forma	20	72	72	22
8	Bilbo	20	61	75	20
9	Ocaña	20	53	76	18
10	La Rápita	20	52	75	18
11	Obras	20	54	87	13

Competiciones que juega

Segunda División Futsal

Pos	Equipos		Pts
1		Sala 10 Zaragoza	70
2		CD UMA Antequera	61
3		Burela FS	56
4		Union África Ceutí	50
5		Full Energía Zaragoza	49
6		Inagroup El Ejido	43
7		O Parrulo Ferrol	40
8		Sala 5 Martorell	40
9		Levante UD FS	38
10		Ibiza Gasifred	31
11		Melistar Futsal	30
12		Barça Atlétic	27
13		CD Leganes FS	25
14		Real Betis Futsal B	23
15		Atlético Mengíbar FS	21
16		Bisontes Castellón FS	21

	Ascenso : Sala 10 Zaragoza
	Playoff Ascenso : CD UMA Antequera, Burela FS, Union África Ceutí, Full Energía Zaragoza
	Descenso : Real Betis Futsal B, Atlético Mengíbar FS, Bisontes Castellón FS

RIVALES EN Copa del Rey Fut.

RIVALES EN Segunda División.

USO DE MEMORIA

7,179,464 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1137
Total Execution Time	0.1150

CADENA URL

/historico/Sala-10-Zaragoza

GET DATOS

$_GET['/historico/Sala-10-Zaragoza']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3096 AND type_rel = 2
0.0025	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3096 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	SELECT /35 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 (516001,522698,522290,526399,527157) ORDER BY n.cover_points DESC, update_date DESC
0.0029	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 = '3096' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026	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=3096 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74080,73235,71723) 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 = 73235 AND teamId = 3096
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 74080 AND teamId = 3096
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71723 AND teamId = 3096
0.0025	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 = '3096' 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 = '3096' and rp.type = 4
0.0028	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 = '3096' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '3096' and rp.type = 4
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 = 73235 WHERE rp.league_id = 73235 AND rp.teamId = 3096 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.0021	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 = 73235 WHERE rp.league_id = 73235 AND rp.teamId = 3096 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73235 WHERE rp.league_id = 73235 AND rp.teamId = 3096 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 3096 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73235 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 68743 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.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* `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 = 63424 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 58753 AND t.round = 34 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* `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 = 50469 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44361 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* `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 = 39112 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* `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 = 33893 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* `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 = 16598 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* `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 = 4455 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* `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 = 3019 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* `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 = 1935 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 1527 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* `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 = 1159 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* `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 = 923 AND t.round = 30 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* `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 = 735 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

Sala 10 Zaragoza

Sala 10 Zaragoza

Selecciona un equipo

Competiciones que juega

Segunda División Futsal

RIVALES EN Copa del Rey Fut.

RIVALES EN Segunda División.