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

Al Ahed

Entrenador: Raafat Mohammad

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA LÍBANO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Al Nejmeh	19	34	16	28
2	Ansar Beirut	19	38	20	27
3	Al Ahed	19	40	11	27
4	Safa	19	31	25	23
5	Bourj	19	20	24	16
6	Racing	19	24	34	10

TEMPORADA 2022/2023

LIGA LÍBANO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Al Ahed	10	19	5	24
2	Al Nejmeh	10	16	7	22
3	Ansar Beirut	10	19	9	18
4	Sahel Shabab	10	11	18	10
5	Bourj	10	8	15	9
6	Ghazieh	10	4	23	0

TEMPORADA 2021/2022

LIGA LÍBANO GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Al Ahed	11	20	3	29
2	Bourj	11	15	6	23
3	Sahel Shabab	11	20	13	20
4	Al Nejmeh	11	13	8	17
5	Ansar Beirut	11	17	11	15
6	Tadamon Sour	11	12	10	14
7	Shabab Bourj	11	15	17	14
8	Tripoli	11	13	15	14
9	Sagesse	11	7	23	10
10	Akhaa Ahli	11	7	12	9
11	Safa	11	5	17	9
12	Sporting	11	9	18	7

TEMPORADA 2020/2021

LIGA LÍBANO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ansar Beirut	5	9	3	13
2	Al Nejmeh	5	8	2	10
3	Safa	5	7	8	8
4	Al Ahed	5	7	6	7
5	Sahel Shabab	5	2	8	3
6	Akhaa Ahli	5	0	6	1

TEMPORADA 2019/2020

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Ansar Beirut	3	7	3	6
2	Bourj	2	3	0	6
3	Al Nejmeh	2	3	1	6
4	Sahel Shabab	3	4	4	4
5	Akhaa Ahli	3	3	3	4
6	Safa	3	3	4	4
7	Al Ahed	1	3	1	3
8	Salam	2	2	2	3
9	Tripoli	2	2	3	3
10	Shabab Bourj	3	3	5	3
11	Tadamon Sour	3	2	4	1
12	Ghazieh	3	2	7	0

TEMPORADA 2018/2019

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Al Ahed	22	40	9	59
2	Ansar Beirut	22	53	18	49
3	Al Nejmeh	22	36	17	48
4	Akhaa Ahli	22	28	32	33
5	Sahel Shabab	22	32	32	28
6	Ghazieh	22	24	31	24
7	Tadamon Sour	22	16	21	23
8	Tripoli	22	14	26	23
9	Safa	22	16	29	22
10	Salam	22	15	30	22
11	Racing	22	22	32	21
12	Al-Nabi	22	19	38	13

TEMPORADA 2017/2018

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Al Ahed	22	50	9	54
2	Al Nejmeh	22	40	22	47
3	Safa	22	31	25	36
4	Ansar Beirut	22	33	24	33
5	Akhaa Ahli	22	23	19	33
6	Salam	22	30	31	32
7	Tadamon Sour	22	28	27	29
8	Tripoli	22	28	33	25
9	Racing	22	21	29	25
10	Al-Nabi	22	21	35	20
11	Arabi Beirut	22	16	31	17
12	Al Islah	22	14	50	11

TEMPORADA 2016/2017

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Al Ahed	22	41	14	49
2	Salam	22	35	29	40
3	Al Nejmeh	22	36	22	39
4	Ansar Beirut	22	35	40	32
5	Al-Nabi	22	26	24	31
6	Safa	22	32	32	30
7	Tadamon Sour	22	25	25	30
8	Racing	22	26	30	30
9	Akhaa Ahli	22	35	37	29
10	Tripoli	22	34	31	28
11	Sahel Shabab	22	21	23	25
12	Egtmaaey	22	21	60	8

TEMPORADA 2015/2016

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Safa	22	46	18	52
2	Al Ahed	22	54	14	51
3	Al Nejmeh	22	35	19	45
4	Ansar Beirut	22	37	20	42
5	Sahel Shabab	22	37	27	35
6	Al-Nabi	22	31	30	29
7	Tripoli	22	28	31	27
8	Racing	22	19	27	26
9	Egtmaaey	22	29	43	23
10	Salam	22	25	44	16
11	Ghazieh	22	18	41	10
12	Sagesse	22	17	62	9

TEMPORADA 2014/2015

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Al Ahed	22	42	10	51
2	Ansar Beirut	22	31	19	43
3	Al Nejmeh	22	26	18	39
4	Tripoli	22	36	24	33
5	Safa	22	26	28	30
6	Al-Nabi	22	30	36	30
7	Salam	22	33	40	27
8	Sahel Shabab	22	25	28	24
9	Ghazieh	22	29	38	24
10	Racing	22	18	30	23
11	Tadamon Sour	22	17	31	22
12	Akhaa Ahli	22	18	29	20

TEMPORADA 2013/2014

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Al Nejmeh	22	48	24	44
2	Safa	22	42	23	41
3	Racing	22	38	31	38
4	Al Ahed	22	30	26	37
5	Akhaa Ahli	22	36	26	31
6	Tripoli	22	23	26	31
7	Sahel Shabab	22	40	26	30
8	Ansar Beirut	22	28	23	30
9	Tadamon Sour	22	22	31	22
10	Salam	22	27	46	22
11	Al-Mabarrah	22	21	50	18
12	Egtmaaey	22	26	49	10

TEMPORADA 2012/2013

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Safa	22	47	20	53
2	Al-Nejmeh	22	47	22	45
3	Racing	22	38	32	40
4	Akhaa Ahli	22	32	22	39
5	Al Ahed	22	49	28	37
6	Sahel Shabab	22	38	30	37
7	Ansar Beirut	22	35	24	32
8	Tadamon Sour	22	33	38	28
9	Egtmaaey	22	36	40	26
10	Tripoli	22	27	30	24
11	Ghazieh	22	44	67	11
12	Salam Sour	22	18	91	1

TEMPORADA 2011/2012

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Safa	22	50	16	55
2	Al Nejmeh	22	37	16	51
3	Al Ahed	22	42	17	48
4	Ansar Beirut	22	35	24	41
5	Akhaa Ahli	22	28	32	28
6	Shabab Sahel	22	25	26	27
7	Tripoli	22	26	26	24
8	Racing	22	18	25	23
9	Salam Sour	22	28	38	21
10	Tadamon Sour	22	15	26	20
11	Al-Mabarrah	22	21	44	13
12	Ahli Sidon	22	18	53	10

TEMPORADA 2010/2011

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Al Ahed	22	51	18	55
2	Safa	22	37	21	45
3	Al Nejmeh	22	34	19	44
4	Ansar Beirut	22	40	15	43
5	Al-Mabarrah	22	34	26	36
6	Racing	22	26	20	29
7	Akhaa Ahli	22	17	25	24
8	Salam Sour	22	19	45	23
9	Shabab Sahel	22	21	33	22
10	Tadamon Sour	22	15	23	20
11	Ghazieh	22	17	36	20
12	Al Islah	22	14	44	4

TEMPORADA 2009/2010

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Al Ahed	22	49	11	56
2	Al Nejmeh	22	48	21	45
3	Safa	22	42	20	45
4	Ansar Beirut	22	33	14	44
5	Racing	22	21	21	29
6	Al-Mabarrah	22	33	37	29
7	Shabab Sahel	22	20	35	25
8	Tadamon Sour	22	21	28	24
9	Al Islah	22	23	37	20
10	Ghazieh	22	20	37	18
11	Ahli Sidon	22	12	34	17
12	Sagesse	22	18	45	11

TEMPORADA 2008/2009

LIGA LÍBANO
Equipo		PJ	GF	GC	Puntos
1	Al Nejmeh	18	40	14	44
2	Al Ahed	18	41	20	43
3	Safa	18	34	12	40
4	Ansar Beirut	19	25	14	36
5	Sahel Shabab	19	26	24	27
6	Al-Mabarrah	18	20	20	23
7	Racing	18	16	23	16
8	Tadamon Sour	18	16	34	12
9	Sagesse	18	14	28	11
10	Ghazieh	18	17	35	11
11	Salam	18	14	39	11

Competiciones que juega

Liga Líbano Grupo 1

Pos	Equipos		Pts
1		Al Ahed	28
2		Al Nejmeh	25
3		Bourj	21
4		Al Ansar Beirut	20
5		Safa	17
6		Racing Beirut	15
7		Al Sahel Shabab	14
8		Tripoli	12
9		Sagesse	7
10		Al Ahli Nabatiya	6
11		Tadamon Sour	5
12		Al Ghazieh Shabab	5

	Playoff Título : Al Ahed, Al Nejmeh, Bourj, Al Ansar Beirut, Safa, Racing Beirut
	Playoff Descenso : Al Sahel Shabab, Tripoli, Sagesse, Al Ahli Nabatiya, Tadamon Sour, Al Ghazieh Shabab

RIVALES EN AFC Cup

RIVALES EN Copa Federación.

RIVALES EN Supercopa Líbano

RIVALES EN Copa Líbano

RIVALES EN Liga Líbano

USO DE MEMORIA

6,822,664 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	6.1204
Total Execution Time	6.1216

CADENA URL

/historico/Al-Ahed-Lb

GET DATOS

$_GET['/historico/Al-Ahed-Lb']

POST DATOS

No hay datos POST existentes

CONSULTAS (58)

0.5107	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 = 'Al-Ahed-Lb' 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=17351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=17351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027	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 = 72226
0.0026	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 = 75200
0.0111	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 = 73692
0.0096	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 = 72567
0.0052	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 = 72818
0.0052	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 = 73352
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17351 AND type_rel = 2
0.1123	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17351 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0649	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 (45647,115283,739172,739300,869419) ORDER BY n.cover_points DESC, update_date DESC
0.2892	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 = '17351' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.5022	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 = '17351' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0338	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 = 74794 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155	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 = 72567 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0765	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 = 73352 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0235	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 = 72228 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0236	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 = 75200 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.4265	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=17351 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0194	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 (75200,74794,73352,72818,72228) 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.2046	SELECT count(id) as num_players from rel_players WHERE league_id = 75200 AND teamId = 17351
0.1800	SELECT count(id) as num_players from rel_players WHERE league_id = 74794 AND teamId = 17351
0.1041	SELECT count(id) as num_players from rel_players WHERE league_id = 72228 AND teamId = 17351
0.0250	SELECT count(id) as num_players from rel_players WHERE league_id = 72818 AND teamId = 17351
0.0858	SELECT count(id) as num_players from rel_players WHERE league_id = 73352 AND teamId = 17351
0.0951	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 = 72226 AND t.round = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.3753	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 = 72226 WHERE rp.league_id = 72226 AND rp.teamId = 17351 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.3636	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 = 72226 WHERE rp.league_id = 72226 AND rp.teamId = 17351 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1240	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 = 72226 WHERE rp.league_id = 72226 AND rp.teamId = 17351 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.5826	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 = 17351 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.1879	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 = 72226 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0392	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 = 75200 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1293	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 = 69233 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0173	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 = 70851 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.0392	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 = 66919 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.1134	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 = 64193 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0725	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 = 59387 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0575	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 = 61870 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1370	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 = 51285 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1276	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 = 45053 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0687	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 = 39907 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0660	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 = 36092 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0934	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 = 15643 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1075	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 = 4838 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1450	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 = 3571 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0494	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 = 3107 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0354	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 = 24087 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1523	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 = 24090 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0774	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 = 24092 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0506	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 = 24093 AND t.round = 20 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

Al Ahed

Al Ahed

Selecciona un equipo

Competiciones que juega

Liga Líbano Grupo 1

RIVALES EN AFC Cup

RIVALES EN Copa Federación.

RIVALES EN Supercopa Líbano

RIVALES EN Copa Líbano

RIVALES EN Liga Líbano