Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

El Dakhleya

Entrenador: Koshari

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA EGIPTO
Equipo		PJ	GF	GC	Puntos
1	Pyramids	18	28	13	41
2	Al-Masry	20	30	25	37
3	ZED	21	28	19	33
4	ENPPI	21	26	19	32
5	Ittihad	20	26	24	32
6	Smouha SC	20	20	17	31
7	Ceramica	19	31	21	28
8	Talaea	19	16	14	28
9	El Gounah	20	24	29	28
10	Al-Ahly	13	29	14	27
11	Future FC	19	19	16	26
12	Zamalek	15	23	15	24
13	Ismaily	21	21	24	22
14	Baladiyyat	20	22	42	19
15	National	21	26	34	18
16	Mokawloon	20	18	31	15
17	Pharco FC	19	17	29	13
18	El Dakhleya	20	7	25	11

TEMPORADA 2022/2023

LIGA EGIPTO
Equipo		PJ	GF	GC	Puntos
1	Al-Ahly	34	63	13	83
2	Pyramids	34	58	24	73
3	Zamalek	34	52	36	60
4	Future FC	34	34	23	58
5	Al-Masry	34	34	33	48
6	ENPPI	34	34	40	45
7	Mokawloon	34	35	33	44
8	Ittihad	34	36	43	43
9	Pharco FC	34	31	34	42
10	Smouha SC	34	36	43	42
11	Ismaily	34	35	38	40
12	National	34	35	40	39
13	Ceramica	34	31	32	37
14	Talaea	34	33	45	36
15	El Dakhleya	34	32	43	35
16	Aswan SC	34	31	45	33
17	Ghazl	34	26	47	33
18	Haras	34	21	45	25

TEMPORADA 2021/2022

SEGUNDA EGIPTO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	El Dakhleya	30	48	25	69
2	PetroJet	30	42	26	56
3	Wadi Degla	30	46	36	48
4	ZED	30	28	22	47
5	Olympic	30	29	21	46
6	Al Tersana	30	43	36	45
7	Porto Suez	30	49	48	45
8	Sekka Hadid	30	33	31	44
9	Itesalat	30	33	24	42
10	Entag Harby	30	34	32	40
11	Montakhab	30	24	27	39
12	Al Nasr	30	33	36	37
13	Al Merreikh	30	25	36	26
14	Bur Fouad	30	26	45	23
15	Belbeis	30	26	43	21
16	Banha	30	15	46	11

TEMPORADA 2020/2021

SEGUNDA EGIPTO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Porto Suez	24	22	19	38
2	Olympic	24	22	15	36
3	Al Tersana	24	23	17	36
4	El Dakhleya	24	24	21	36
5	Future FC	23	25	19	35
6	Montakhab	24	17	14	35
7	Al Nasr	24	34	32	32
8	PetroJet	24	20	16	31
9	Al Merreikh	23	16	14	30
10	Gomhoreyat	24	25	25	29
11	ZED	24	19	21	29
12	Sekka Hadid	24	18	20	29
13	Nogoom	24	18	22	27
14	El Zarqa	23	16	27	24
15	Sers Elyan	24	18	29	23
16	Tanta	23	17	23	21

TEMPORADA 2019/2020

SEGUNDA EGIPTO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ceramica	22	29	13	43
2	PetroJet	22	22	10	42
3	El Dakhleya	22	32	16	41
4	Al Nasr	22	27	22	33
5	Olympic	22	20	16	33
6	Montakhab	22	18	14	33
7	Gomhoreyat	22	12	11	26
8	Nogoom	22	25	24	25
9	Al Merreikh	22	22	33	21
10	Future FC	22	16	28	20
11	Al Tersana	22	13	30	17
12	El Zarqa	22	15	34	13

TEMPORADA 2018/2019

LIGA EGIPTO
Equipo		PJ	GF	GC	Puntos
1	Al-Ahly	34	56	20	80
2	Zamalek	34	65	31	72
3	Pyramids	34	61	31	70
4	Al-Masry	34	45	38	52
5	Mokawloon	34	45	38	48
6	Misr	34	34	36	46
7	Ismaily	34	30	36	43
8	Talaea	34	41	39	41
9	ENPPI	34	39	42	40
10	Wadi Degla	34	41	47	40
11	Ittihad	34	41	56	39
12	Haras	34	30	37	38
13	Entag Harby	34	36	44	38
14	Smouha SC	34	33	41	38
15	El Gounah	34	38	52	38
16	PetroJet	34	30	43	35
17	El Dakhleya	34	34	52	27
18	Nogoom	34	30	46	26

TEMPORADA 2017/2018

LIGA EGIPTO
Equipo		PJ	GF	GC	Puntos
1	Al-Ahly	34	75	19	88
2	Ismaily	34	50	27	68
3	Al-Masry	34	52	34	63
4	Zamalek	34	45	30	61
5	Smouha SC	34	37	26	51
6	ENPPI	34	39	38	50
7	Entag Harby	34	36	36	47
8	Misr	34	48	44	46
9	Pyramids	34	43	41	42
10	Mokawloon	34	42	49	42
11	Ittihad	34	41	43	41
12	PetroJet	34	32	40	38
13	Talaea	34	26	42	38
14	El Dakhleya	34	37	46	37
15	Wadi Degla	34	31	46	34
16	El Raja	34	24	53	27
17	Tanta	34	27	44	26
18	Al Nasr	34	33	60	22

TEMPORADA 2016/2017

LIGA EGIPTO
Equipo		PJ	GF	GC	Puntos
1	Al-Ahly	34	62	14	84
2	Misr	34	65	34	74
3	Zamalek	34	42	24	66
4	Al-Masry	34	51	36	62
5	Smouha SC	34	49	40	57
6	Ismaily	34	48	28	54
7	Talaea	34	38	43	45
8	Ittihad	34	34	36	44
9	Mokawloon	34	34	39	44
10	PetroJet	34	24	26	43
11	ENPPI	34	45	38	43
12	Wadi Degla	34	35	38	38
13	Entag Harby	34	32	40	33
14	El Dakhleya	34	31	52	31
15	Tanta	34	21	39	31
16	Aswan SC	34	28	49	29
17	Nasr Taadeen	34	27	66	26
18	Sharkia	34	24	48	23

TEMPORADA 2015/2016

LIGA EGIPTO
Equipo		PJ	GF	GC	Puntos
1	Al-Ahly	34	65	24	76
2	Zamalek	34	49	25	69
3	Smouha SC	34	45	37	55
4	Al-Masry	34	50	37	55
5	Wadi Degla	34	38	31	54
6	Ismaily	34	47	36	53
7	Entag Harby	34	38	26	52
8	El Dakhleya	34	35	33	50
9	Misr	34	47	41	47
10	ENPPI	34	42	39	47
11	PetroJet	34	35	31	46
12	Mokawloon	34	34	42	41
13	Talaea	34	34	35	41
14	Ittihad	34	26	44	39
15	Aswan SC	34	28	44	35
16	Ittihad	34	30	48	25
17	Haras	34	17	52	19
18	Ghazl	34	16	51	13

TEMPORADA 2014/2015

LIGA EGIPTO
Equipo		PJ	GF	GC	Puntos
1	Zamalek	38	69	21	87
2	Al-Ahly	38	65	26	79
3	ENPPI	38	65	29	70
4	Misr	38	57	51	64
5	Wadi Degla	38	46	36	57
6	Ismaily	38	44	32	55
7	Mokawloon	38	47	41	55
8	Haras	38	30	31	52
9	Talaea	38	49	56	52
10	Smouha SC	38	43	37	51
11	Al-Masry	38	37	41	50
12	El Dakhleya	38	43	41	49
13	PetroJet	38	49	53	49
14	Ittihad	38	39	38	48
15	Ittihad	38	36	42	47
16	El Gounah	38	33	35	46
17	El Raja	38	47	57	43
18	Al Nasr	38	34	70	29
19	Pyramids	38	40	88	16
20	Alaab	38	34	82	14

TEMPORADA 2013/2014

LIGA EGIPTO GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Al-Ahly	20	30	10	40
2	Smouha SC	20	24	20	35
3	Al-Ittihad	20	20	17	31
4	Mokawloon	20	27	17	30
5	El Gounah	20	17	16	26
6	El Dakhleya	20	18	19	25
7	Misr	20	17	22	24
8	ENPPI	20	19	19	22
9	El Raja	20	23	34	21
10	Ghazl	20	13	21	19
11	Entag Harby	20	15	28	14

TEMPORADA 2012/2013

LIGA EGIPTO
Equipo		PJ	GF	GC	Puntos
1	Al-Ahly	15	27	10	39
2	ENPPI	15	24	15	29
3	Smouha SC	16	19	9	27
4	Telephonat	15	10	10	21
5	Haras	15	14	16	17
6	El Gounah	15	12	19	14
7	Wadi Degla	15	12	20	14
8	Misr	15	9	17	12
9	Ghazl	15	14	25	11
10	Zamalek	15	26	11	39
11	Ismaily	16	20	11	30
12	Ittihad	15	21	15	22
13	Talaea	15	19	21	20
14	Mokawloon	15	21	20	19
15	El Dakhleya	15	10	11	19
16	PetroJet	15	16	21	17
17	Ittihad Bnei	15	10	19	14
18	Entag Harby	15	9	23	6

TEMPORADA 2011/2012

LIGA EGIPTO
Equipo		PJ	GF	GC	Puntos
1	Haras	14	25	9	37
2	Al-Ahly	15	28	12	36
3	Zamalek	14	27	11	32
4	Al-Masry	15	17	10	26
5	Ittihad	15	16	10	26
6	Ismaily	14	17	13	25
7	Misr	15	29	19	24
8	ENPPI	16	28	25	24
9	El Gounah	16	22	18	22
10	Wadi Degla	14	17	15	19
11	Telephonat	16	16	21	19
12	Talaea	16	19	21	17
13	Ittihad Bnei	16	14	21	15
14	Smouha SC	15	15	23	13
15	PetroJet	14	12	21	11
16	Ghazl	14	11	29	11
17	Mokawloon	15	17	24	10
18	Entag Harby	17	8	26	9
19	El Dakhleya	15	12	22	8

Competiciones que juega

Liga Egipto

Pos	Equipos		Pts
1		Pyramids	41
2		Al-Masry	37
3		ZED	33
4		ENPPI	32
5		Al Ittihad Alexandria	32
6		Smouha SC	31
7		Ceramica Cleopatra	28
8		Talaea El-Gaish	28
9		El Gounah	28
10		Al-Ahly	27
11		Future FC	26
12		Zamalek	24
13		Ismaily	22
14		Baladiyyat	19
15		National Bank of Egypt	18
16		Al Mokawloon	15
17		Pharco FC	13
18		El Dakhleya	11

	CAF Champions League : Pyramids, Al-Masry
	Copa Confederaciones : ZED, ENPPI
	Descenso : Al Mokawloon, Pharco FC, El Dakhleya

RIVALES EN Copa de la Liga.

RIVALES EN Liga Egipto

USO DE MEMORIA

6,657,232 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1434
Total Execution Time	0.1446

CADENA URL

/historico/Daklyeh

GET DATOS

$_GET['/historico/Daklyeh']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0027	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 = 'Daklyeh' 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=6398 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=6398 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=6398 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 73594
0.0023	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 = 75081
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6398 AND type_rel = 2
0.0026	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 = '6398' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '6398' 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 = '6398' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 75081 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 73594 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=6398 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (75081,73594,71621) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 73594 AND teamId = 6398
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 75081 AND teamId = 6398
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 71621 AND teamId = 6398
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 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 = 73594 AND t.round = 21 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '6398' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021	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 = '6398' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0043	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 = 73594 WHERE rp.league_id = 73594 AND rp.teamId = 6398 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.0041	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 = 73594 WHERE rp.league_id = 73594 AND rp.teamId = 6398 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 73594 WHERE rp.league_id = 73594 AND rp.teamId = 6398 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 6398 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73594 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 70087 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.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* `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 = 64657 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 = 60166 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* `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 = 58506 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 44243 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 39904 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 35508 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 19337 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 8378 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 3574 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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 = 2212 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0060	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 = 1570 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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 = 73594 ORDER BY nameShow LIMIT 100

El Dakhleya

El Dakhleya

Selecciona un equipo

Competiciones que juega

Liga Egipto

RIVALES EN Copa de la Liga.

RIVALES EN Liga Egipto