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

Sektzia Ness Ziona

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA ISRAEL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bnei Yehuda	30	57	36	61
2	Ironi Kiryat	30	50	19	60
3	Ironi	30	46	28	54
4	Maccabi	30	58	40	50
5	Hapoel	30	46	34	47
6	Hapoel Ramat	30	55	48	45
7	Hapoel	30	38	34	42
8	Maccabi	30	34	41	42
9	Hapoel Acre	30	41	40	41
10	Kafr Qasim	30	31	39	37
11	Hapoel	30	27	39	35
12	Hapoel Ramat	30	36	35	34
13	Sektzia Ness	30	38	53	34
14	Hapoel Kfar	30	28	40	31
15	Hapoel Afula	30	33	53	24
16	Ihud Bnei S.	30	27	66	16

TEMPORADA 2022/2023

LIGA ISRAEL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hapoel Haifa	33	35	35	41
2	Beitar	33	52	58	40
3	Bnei Sakhnin	33	39	44	37
4	Hapoel Aviv	33	37	51	37
5	Maccabi Bnei	33	32	54	35
6	Hapoel	33	35	53	34
7	Ironi Kiryat	33	40	49	32
8	Sektzia Ness	33	31	56	25

TEMPORADA 2021/2022

SEGUNDA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Maccabi Bnei	37	43	28	64
2	Sektzia Ness	37	59	39	61
3	Kafr Qasim	37	51	35	61
4	Agudat Sport	37	48	41	54
5	Hapoel Petah	37	36	35	54
6	Hapoel Kfar	37	51	44	52
7	Hapoel	37	47	54	43
8	Bnei Yehuda	37	41	47	42

TEMPORADA 2020/2021

SEGUNDA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hapoel	7	15	4	17
2	Hapoel	7	18	6	15
3	Sektzia Ness	7	9	8	13
4	Hapoel	7	9	8	11
5	Hapoel Ramat	7	11	10	8
6	Beitar Aviv	7	11	12	7
7	Hapoel Ramat	7	5	7	4
8	Hapoel Iksal	7	2	25	1

TEMPORADA 2019/2020

LIGA ISRAEL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bnei Yehuda	7	17	4	49
2	FC Ashdod	7	18	14	41
3	Maccabi	7	12	14	40
4	Hapoel	7	9	14	40
5	Hapoel Kfar	7	6	3	38
6	Sektzia Ness	7	6	6	32
7	Ironi Kiryat	7	6	8	32
8	Hapoel	7	7	18	17

TEMPORADA 2018/2019

SEGUNDA ISRAEL
Equipo		PJ	GF	GC	Puntos
1	Hapoel	30	42	25	54
2	Hapoel	30	40	33	48
3	Sektzia Ness	30	48	35	47
4	Hapoel Afula	30	38	28	47
5	Hapoel	30	34	35	44
6	Beitar Aviv	29	40	37	42
7	Hapoel Kfar	30	40	37	42
8	Hapoel Ramat	30	35	35	39
9	Maccabi	30	33	38	39
10	Hapoel Acre	30	27	31	35
11	Hapoel Petah	29	39	30	34
12	Hapoel	30	34	43	34
13	Hapoel	30	29	47	33
14	Hapoel Bnei	30	31	40	32
15	Hapoel Ramat	30	32	38	31
16	Hapoel Iksal	30	33	43	30

TEMPORADA 2017/2018

TERCERA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sektzia Ness	30	78	21	73
2	Maccabi	30	57	37	57
3	Maccabi	30	40	27	51
4	Beitar	30	35	26	49
5	Holon Yaniv	30	39	22	46
6	Hapoel Bikat	30	49	37	44
7	Kfar Kasem	30	36	25	44
8	Hapoel Kfar	30	37	43	44
9	Hapoel Azor	30	23	25	40
10	Hakoah	30	39	45	38
11	Maccabi	30	32	39	37
12	Beitar Kfar	30	33	41	37
13	Ironi Kiryat	30	49	46	35
14	Hapoel	30	30	44	32
15	MS Dimona	30	31	60	27
16	Hapoel	30	16	86	1

TEMPORADA 2016/2017

TERCERA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hapoel	30	73	26	68
2	Sektzia Ness	30	55	19	66
3	Hapoel Kfar	30	58	36	56
4	Maccabi	30	42	26	56
5	Kfar Kasem	30	41	38	49
6	Hakoah	30	48	45	47
7	Maccabi	30	40	30	46
8	MS Dimona	30	42	39	46
9	Hapoel Bikat	30	37	39	35
10	Ironi Kiryat	30	33	43	33
11	Hapoel	30	33	48	33
12	Hapoel Azor	30	25	40	33
13	Hapoel	30	28	44	32
14	Beitar Kfar	30	33	43	26
15	Bnei Jaffa.	30	32	74	22
16	Shikun	30	29	59	18

TEMPORADA 2015/2016

TERCERA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Maccabi	30	54	19	67
2	Sektzia Ness	30	51	24	59
3	Maccabi	30	42	25	50
4	Kfar Kasem	30	45	27	49
5	Hapoel Azor	30	42	28	49
6	Hapoel Kfar	30	49	40	49
7	Hapoel	30	34	26	48
8	Hapoel Bikat	30	39	35	44
9	Hapoel	30	25	28	38
10	Beitar Kfar	30	35	40	37
11	Hapoel	30	35	42	37
12	Shikun	30	30	50	37
13	Hakoah	30	26	43	33
14	Maccabi	30	29	43	31
15	Bnei Eilat	30	27	45	27
16	Morasha	30	16	64	12

TEMPORADA 2014/2015

TERCERA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hapoel	30	52	15	71
2	Maccabi	30	45	23	59
3	Sektzia Ness	30	56	47	46
4	Hapoel	30	40	37	46
5	Beitar Kfar	30	49	42	45
6	Hapoel	30	45	34	44
7	Hapoel Kfar	30	37	35	38
8	Hapoel	30	42	43	38
9	Kfar Kasem	30	35	39	37
10	Morasha	30	30	34	36
11	Shikun	30	38	42	35
12	Maccabi	30	29	40	35
13	Hapoel Azor	30	26	40	34
14	Maccabi	30	28	32	30
15	Maccabi	30	39	61	27
16	Maccabi	30	25	52	17

TEMPORADA 2013/2014

TERCERA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ironi Kiryat	30	53	16	68
2	Maccabi	30	47	27	53
3	Hapoel Azor	30	47	29	53
4	Hapoel	30	37	18	52
5	Beitar Kfar	30	30	26	46
6	Kfar Kasem	30	35	37	43
7	Sektzia Ness	30	31	37	42
8	Maccabi	30	34	29	41
9	Hapoel Kfar	30	29	28	41
10	Maccabi	30	37	40	38
11	Hapoel	30	30	42	38
12	Maccabi	30	31	32	37
13	Ironi	30	35	35	35
14	Maccabi	30	30	42	34
15	Maccabi	30	33	54	28
16	Bnei Eilat	30	20	67	14

TEMPORADA 2012/2013

SEGUNDA ISRAEL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Maccabi	7	10	10	49
2	Maccabi	7	13	6	47
3	Hakoah	7	11	10	44
4	Maccabi	7	10	11	41
5	Hapoel	7	8	9	41
6	Beitar Aviv	7	11	8	40
7	Sektzia Ness	7	4	10	37
8	Hapoel Kfar	7	5	8	32

TEMPORADA 2011/2012

SEGUNDA ISRAEL GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hapoel	5	10	5	25
2	Hakoah	5	9	5	25
3	Sektzia Ness	5	6	11	25
4	Ironi	5	4	5	21
5	Maccabi	5	6	7	17
6	Hapoel	5	5	7	16

Competiciones que juega

Grupo 1

Segunda Israel Grupo 3

Pos	Equipos		Pts
1		Hapoel Acre	45
2		Hapoel Ramat Gan	38
3		Kafr Qasim	37
4		Sektzia Ness Ziona	36
5		Hapoel Kfar Saba	35
6		Hapoel Rishon LeZion	35
7		Hapoel Afula	30
8		Ihud Bnei Shfaram	17

	Playoff Descenso : Hapoel Rishon LeZion
	Descenso : Hapoel Afula, Ihud Bnei Shfaram

RIVALES EN Copa Toto Segund.

RIVALES EN Copa Israel

RIVALES EN Segunda Israel

USO DE MEMORIA

6,537,544 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.8363
Total Execution Time	0.8378

CADENA URL

/historico/Sektzia-Nes-Tziona

GET DATOS

$_GET['/historico/Sektzia-Nes-Tziona']

POST DATOS

No hay datos POST existentes

CONSULTAS (56)

0.0139	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 = 'Sektzia-Nes-Tziona' 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.0125	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=60725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=60725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=60725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=60725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=60725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=60725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=60725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133	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 = 75859
0.0131	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 = 72213
0.0132	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 = 72227
0.0132	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 = 73553
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60725 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=370 AND type_rel = 3
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 370 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128	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 (1283612,992067,974879,913858,841957) ORDER BY n.cover_points DESC, update_date DESC
0.0136	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 = '60725' ORDER BY l.year DESC,cat.coefficient DESC
0.0132	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 = '60725' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '60725' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 72227 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125	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 = 75859 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140	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=60725 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (75859,73841,73553,71432,71237,67935) 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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 71237 AND teamId = 60725
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 75859 AND teamId = 60725
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 73841 AND teamId = 60725
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 73553 AND teamId = 60725
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 67935 AND teamId = 60725
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 60725
0.0129	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 = 75859 AND t.round = 2 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0136	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 = '60725' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60725' and rp.type = 4
0.0132	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 = '60725' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159	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 = 75859 WHERE rp.league_id = 75859 AND rp.teamId = 60725 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.0139	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 = 75859 WHERE rp.league_id = 75859 AND rp.teamId = 60725 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 75859 WHERE rp.league_id = 75859 AND rp.teamId = 60725 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 60725 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128	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 = 75859 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 72213 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.0127	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 = 71237 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 63161 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.0129	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 = 67026 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 58423 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.0128	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 = 62045 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 55619 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 44217 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 39729 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 36094 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 15641 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 9316 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 24862 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 14791 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 14793 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 14794 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 14797 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 75859 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

Sektzia Ness Ziona

Sektzia Ness Ziona

Selecciona un equipo

Competiciones que juega

Segunda Israel Grupo 3

RIVALES EN Copa Toto Segund.

RIVALES EN Copa Israel

RIVALES EN Segunda Israel