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

Beitar Tel Aviv Bat Yam

Temporada 2023/2024

TEMPORADA 2023/2024

CUARTA ISRAEL GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Hapoel Bnei	21	62	38	33
2	Maccabi Ahva	22	50	51	31
3	Maccabi Bnei	22	39	42	30
4	Ironi Bnei.	22	32	40	23
5	Ahva Kafr M.	22	38	57	22
6	Ahi Acre FC	21	26	50	17
7	Maccabi	22	25	92	10
8	Maccabi	22	15	106	3
9	Hapoel Tirat	21	61	17	44
10	Hapoel Bnei	22	35	33	32
11	Ihud Bnei B.	22	41	43	29
12	Hapoel	20	43	45	27
13	Bnei	22	48	60	22
14	Maccabi	22	26	57	13
15	Hapoel Bnei	21	21	89	12
16	Ihud Bnei K.	22	19	55	9
17	Beitar Ramat	22	30	35	31
18	Ironi Beit.	22	33	27	29
19	Hapoel	22	31	32	29
20	Beitar Petah	22	35	35	26
21	Hakoah	22	26	28	25
22	Beitar Aviv	22	25	35	23
23	Sporting	22	16	41	15
24	Inter Aly'aa	22	20	68	11
25	Shikun	20	17	23	28
26	Hapoel Bnei	19	33	35	25
27	Ramla	20	32	40	25
28	Maccabi	20	36	37	23
29	Maccabi	20	30	34	22
30	Hapoel	20	23	51	17
31	Hapoel	19	18	51	9

TEMPORADA 2022/2023

TERCERA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Maccabi	30	69	32	63
2	Hapoel Kfar	30	57	25	63
3	Maccabi	30	41	25	53
4	Hapoel	30	45	24	52
5	MS Dimona	30	53	32	51
6	Hapoel Bikat	30	54	37	51
7	Hapoel	30	39	33	45
8	Maccabi	30	31	41	35
9	Shimshon	30	36	49	35
10	Holon	30	29	42	34
11	Ironi	30	36	52	34
12	Ironi	30	40	40	33
13	Shimshon	30	28	67	30
14	Maccabi	30	26	39	27
15	Bnei Eilat	30	40	58	27
16	Beitar Aviv	30	28	56	21

TEMPORADA 2021/2022

SEGUNDA ISRAEL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Maccabi	37	41	45	50
2	Hapoel Afula	37	39	57	47
3	Hapoel Ramat	37	43	47	46
4	Hapoel Acre	37	38	34	46
5	Hapoel Ramat	37	39	40	45
6	Hapoel	37	42	46	43
7	Hapoel	37	40	50	42
8	Beitar Aviv	37	39	55	33

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

SEGUNDA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bnei Sakhnin	7	14	2	19
2	Hapoel Ramat	7	14	7	16
3	Kafr Qasim	7	12	8	12
4	Hapoel	7	5	3	10
5	Beitar Aviv	7	11	14	9
6	Maccabi	7	4	9	7
7	Hapoel	7	6	14	4
8	Hapoel Ramat	7	8	17	3

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

SEGUNDA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hapoel Aviv	7	13	9	76
2	Hapoel	7	5	3	65
3	Hapoel	7	8	4	64
4	Beitar Aviv	7	16	5	60
5	Hapoel	7	7	10	55
6	Maccabi	7	5	13	53
7	Hapoel	7	7	11	49
8	Hapoel Afula	7	6	12	48

TEMPORADA 2016/2017

SEGUNDA ISRAEL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Maccabi	7	15	9	16
2	Beitar Aviv	7	18	4	15
3	Hapoel	7	15	10	11
4	Hapoel Petah	7	16	13	11
5	Hapoel Bnei	7	10	10	8
6	Hapoel Acre	7	8	11	8
7	Maccabi	7	8	22	5
8	Hapoel Ramat	7	7	18	3

TEMPORADA 2015/2016

SEGUNDA ISRAEL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Beitar Aviv	7	18	4	19
2	Hapoel	7	18	7	16
3	Hapoel Ramat	7	14	11	10
4	Hapoel	7	13	13	9
5	Hapoel Afula	7	10	14	9
6	Hapoel	7	9	10	7
7	Ironi Kiryat	7	10	23	7
8	Maccabi	7	7	17	3

TEMPORADA 2014/2015

SEGUNDA ISRAEL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hapoel	7	10	6	50
2	Hapoel	7	10	8	48
3	Hapoel Ramat	7	6	7	48
4	Beitar Aviv	7	14	8	47
5	Maccabi	7	5	11	44
6	Hapoel	7	7	7	39
7	Ironi	7	10	10	37
8	Hakoah	7	5	10	22

TEMPORADA 2013/2014

SEGUNDA ISRAEL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Maccabi	30	51	26	67
2	Hapoel Petah	30	38	30	52
3	Hapoel Bnei	30	56	29	49
4	Maccabi	30	41	34	45
5	Hapoel	30	29	34	43
6	Hapoel Ramat	30	40	30	41
7	Hapoel Afula	30	48	32	40
8	Beitar Aviv	30	32	30	40
9	Maccabi	30	36	32	39
10	Hapoel	30	43	47	39
11	Hapoel	30	41	45	39
12	Hakoah	30	33	37	39
13	Hapoel	30	47	34	38
14	Hapoel	30	35	31	37
15	Maccabi	30	43	45	36
16	Maccabi	30	14	111	0

Competiciones que juega

Grupo 2

Cuarta Israel Grupo 2

Pos	Equipos		Pts
1		HaMakhtesh Givatayim	33
2		Tzeirey Tira	31
3		Bnei Jaffa Ortodoxim	29
4		Hapoel Kafr Qasim Shouaa	27
5		Hapoel Azor	26
6		Maccabi Ironi Amishav	25
7		Hapoel Hod Hasharon	25
8		Ironi Beit Dagan	22
9		Hapoel Kiryat Ono	22
10		Hakoah Maccabi Ramat Gan	21
11		Hapoel Mahane Yehuda	20
12		Beitar Tel Aviv Bat Yam	12
13		Beitar Ramat Gan	12
14		Beitar Petah Tikva	10
15		Sporting Tel Aviv	9
16		Inter Aly'aa Tel Aviv	7

	Ascenso : HaMakhtesh Givatayim
	Playoff Ascenso : Tzeirey Tira, Bnei Jaffa Ortodoxim, Hapoel Kafr Qasim Shouaa, Hapoel Azor
	Playoff Descenso : Beitar Ramat Gan, Beitar Petah Tikva
	Descenso : Sporting Tel Aviv, Inter Aly'aa Tel Aviv

RIVALES EN Copa Israel

RIVALES EN Cuarta Israel

USO DE MEMORIA

6,036,688 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7591
Total Execution Time	0.7603

CADENA URL

/historico/Beitar-Tel-Aviv-Ramla

GET DATOS

$_GET['/historico/Beitar-Tel-Aviv-Ramla']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0149	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 = 'Beitar-Tel-Aviv-Ramla' 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.0129	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=13205 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=13205 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=13205 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=13205 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0266	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 = 74115
0.0152	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 = 75648
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13205 AND type_rel = 2
0.0134	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13205 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	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 (329900) ORDER BY n.cover_points DESC, update_date DESC
0.0163	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 = '13205' ORDER BY l.year DESC,cat.coefficient DESC
0.0153	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 = '13205' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0155	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 = '13205' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0139	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 = 75648 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155	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=13205 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0136	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 (75648,73841,68503,67320) 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.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 68503 AND teamId = 13205
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 75648 AND teamId = 13205
0.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 73841 AND teamId = 13205
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 13205
0.0132	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 = 74115 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '13205' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13205' and rp.type = 4
0.0127	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 = '13205' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127	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 = 74115 WHERE rp.league_id = 74115 AND rp.teamId = 13205 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.0126	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 = 74115 WHERE rp.league_id = 74115 AND rp.teamId = 13205 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126	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 = 74115 WHERE rp.league_id = 74115 AND rp.teamId = 13205 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 13205 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 74115 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.0132	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 = 75648 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* `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 = 68503 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 = 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.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* `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 = 67027 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* `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.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* `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 = 50129 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* `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 = 56758 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.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* `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 = 38846 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* `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 = 43314 AND t.round = 7 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* `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 = 34063 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* `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 = 38540 AND t.round = 7 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* `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 = 15461 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* `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 = 23948 AND t.round = 7 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* `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 = 4183 AND t.round = 30 ORDER BY team.conference 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* `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 = 12955 AND t.round = 7 ORDER BY team.conference 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* `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 = 14789 AND t.round = 7 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* `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 = 2851 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Beitar Tel Aviv Bat Yam

Beitar Tel Aviv Bat Yam

Selecciona un equipo

Competiciones que juega

Cuarta Israel Grupo 2

RIVALES EN Copa Israel

RIVALES EN Cuarta Israel