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

Merreikh El-Fasher

Temporada 2020/2021

TEMPORADA 2020/2021

LIGA SUDÁN
Equipo		PJ	GF	GC	Puntos
1	Al-Hilal	30	75	12	77
2	Al-Merreikh	30	50	16	68
3	Hay Al Wadi	30	35	25	47
4	Al Khartoum	30	34	34	41
5	Hilal Obayed	30	25	32	41
6	Hay Al-Arab	30	26	34	40
7	Alamal	30	25	29	39
8	Al-Ahly	30	24	28	38
9	Hilal	30	35	41	38
10	Hilal Port.	30	29	33	36
11	Al Shorta	30	26	36	35
12	Ahly Shendi	30	21	27	34
13	Tuti SC	30	26	39	34
14	Ahli	30	17	28	32
15	Hilal	30	22	39	25
16	Merreikh	30	15	32	24

TEMPORADA 2019/2020

LIGA SUDÁN
Equipo		PJ	GF	GC	Puntos
1	Al-Merreikh	32	60	17	74
2	Al-Hilal	32	62	19	69
3	Hilal Obayed	32	48	25	56
4	Alamal	32	43	29	53
5	Merreikh	32	39	29	49
6	Hay Al Wadi	32	29	22	49
7	Hay Al-Arab	32	38	42	49
8	Al Khartoum	32	30	18	46
9	Ahly Shendi	32	42	35	44
10	Al-Ahly	32	28	35	41
11	Ahli	32	36	40	39
12	Hilal	31	27	37	37
13	Al Shorta	32	32	51	32
14	Al Fallah	32	29	47	30
15	Hilal	32	28	48	30
16	Rabta Kosti	31	25	56	25
17	El-Ahli	32	26	72	17

TEMPORADA 2018/2019

LIGA SUDÁN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Al-Merreikh	14	34	10	32
2	Al Khartoum	14	21	15	24
3	Hilal Obayed	14	20	17	19
4	Hay Al Wadi	14	12	16	19
5	Al Mourada	14	13	19	19
6	Alamal	14	14	22	17
7	Ahli	14	13	15	12
8	Al-Ahly	14	10	23	8
9	Al-Hilal	14	31	10	31
10	Ahly Shendi	14	16	6	28
11	Al Shorta	14	18	17	20
12	Merreikh	14	16	15	17
13	Hay Al-Arab	14	12	17	16
14	Hilal	14	13	16	15
15	Hashim	14	7	14	15
16	Rabta Kosti	14	7	25	9

TEMPORADA 2017/2018

LIGA SUDÁN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Al-Hilal	15	30	6	37
2	Al-Merreikh	15	26	10	34
3	Hilal Obayed	14	16	13	21
4	Ahly Shendi	13	19	16	20
5	Al Khartoum	14	14	22	14
6	Merreikh	14	12	24	14
7	Al-Ahly	15	10	24	12
8	Hay Al-Arab	14	8	20	11

TEMPORADA 2016/2017

LIGA SUDÁN
Equipo		PJ	GF	GC	Puntos
1	Al-Merreikh	34	66	21	79
2	Al-Hilal	34	66	23	77
3	Hilal Obayed	34	56	34	59
4	Ahly Shendi	34	47	34	57
5	Al Khartoum	34	59	31	56
6	Hilal	34	40	32	51
7	Ahli	34	45	43	51
8	Al Shorta	34	46	42	50
9	El-Ahli	34	32	40	44
10	Hay Al Wadi	34	26	38	44
11	Hay Al-Arab	34	27	30	42
12	Merreikh	34	28	43	35
13	Alamal	34	32	43	34
14	Merreikh	34	29	42	34
15	Merreikh	34	27	47	30
16	Rabta Kosti	34	23	44	29
17	Triea Albiga	34	19	50	29
18	Ahli Medani	34	24	55	25

TEMPORADA 2015/2016

LIGA SUDÁN
Equipo		PJ	GF	GC	Puntos
1	Al-Hilal	34	82	15	87
2	Al-Merreikh	34	65	29	77
3	Ahly Shendi	34	68	25	73
4	Hilal Obayed	34	48	21	70
5	Al Khartoum	34	52	22	65
6	Hilal	34	39	35	53
7	Merreikh	33	32	38	42
8	Alamal	35	29	41	41
9	Merreikh	34	28	36	40
10	Ahli Medani	34	33	39	39
11	Rabta Kosti	33	34	44	35
12	Merreikh	34	22	42	35
13	Ahli	35	22	38	34
14	El-Ahli	34	24	44	34
15	Al-Nil	34	27	53	33
16	Al Amir	35	19	57	30
17	Hilal	33	21	45	26
18	Al Nsoor	34	18	39	23

TEMPORADA 2014/2015

LIGA SUDÁN
Equipo		PJ	GF	GC	Puntos
1	Al-Merreikh	28	60	13	64
2	Al-Hilal	28	39	14	59
3	Ahly Shendi	28	40	21	53
4	Al Khartoum	28	41	24	50
5	Merreikh	28	25	16	45
6	Hilal Obayed	28	29	23	41
7	Merreikh	28	26	30	36
8	Hilal	28	24	35	35
9	Ahli Medani	28	23	29	34
10	Al Nsoor	28	30	40	28
11	Ahli	28	26	39	28
12	Rabta Kosti	28	21	34	26
13	Alamal	28	29	44	26
14	Hilal	28	23	44	26
15	Al Merghani	28	11	41	18

TEMPORADA 2013/2014

LIGA SUDÁN
Equipo		PJ	GF	GC	Puntos
1	Al-Hilal	26	53	8	65
2	Al-Merreikh	26	56	12	64
3	Ahly Shendi	26	31	20	42
4	Al Khartoum	26	31	19	41
5	Rabta Kosti	26	35	33	40
6	Merreikh	26	30	28	40
7	Ahli	26	29	28	35
8	Hilal	26	20	29	32
9	Al Nsoor	26	19	31	30
10	Alamal	26	24	35	29
11	Hilal	26	26	35	28
12	El-Ahli	26	22	34	28
13	Al Nil	26	12	45	14
14	Al Ittihad	26	10	41	10

TEMPORADA 2012/2013

LIGA SUDÁN
Equipo		PJ	GF	GC	Puntos
1	Al-Merreikh	26	51	17	63
2	Al-Hilal	26	58	17	61
3	Ahly Shendi	26	37	16	51
4	El-Ahli	26	29	27	39
5	Al Khartoum	26	25	22	38
6	Merreikh	26	26	33	36
7	Ahli	26	19	21	35
8	Al-Hilal	26	19	21	31
9	Al-Ittihad	26	21	30	28
10	Al Nsoor	26	21	39	28
11	Al-Amal	26	26	26	25
12	Al Nil	26	19	27	24
13	Al-Mawrada	26	18	45	17
14	Al-Ahli	26	17	45	16

Competiciones que juega

Liga Sudán

Pos	Equipos		Pts
1		Al-Hilal Omdurman	77
2		Al-Merreikh SC	68
3		Hay Al Wadi	47
4		Al Khartoum	41
5		Hilal Obayed	41
6		Hay Al-Arab	40
7		Alamal Atbara	39
8		Al-Ahly Merowe	38
9		Hilal El-Fasher	38
10		Al Hilal Port Sudan	36
11		Al Shorta	35
12		Al Ahly Shendi	34
13		Tuti SC	34
14		Al Ahli Khartoum	32
15		Al Hilal Kadougli	25
16		Merreikh El-Fasher	24

	CAF Champions League : Al-Hilal Omdurman, Al-Merreikh SC
	Copa Confederaciones : Hay Al Wadi
	Playoff Descenso : Tuti SC, Al Ahli Khartoum
	Descenso : Al Hilal Kadougli, Merreikh El-Fasher

RIVALES EN Liga Sudán

USO DE MEMORIA

5,691,184 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6950
Total Execution Time	0.6962

CADENA URL

/historico/Merreikh-El-Fasher

GET DATOS

$_GET['/historico/Merreikh-El-Fasher']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0134	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 = 'Merreikh-El-Fasher' 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.0145	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 = 'Merreikh-El-Fasher' 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.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=15949 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=15949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	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=15949 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=15949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=15949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=15949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=15949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=15949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=15949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=15949 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=15949 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=15949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 60559
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15949 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=486 AND type_rel = 3
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 486 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129	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 (640190,432245,425175,420140,337172) ORDER BY n.cover_points DESC, update_date DESC
0.0131	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 = '15949' ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '15949' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '15949' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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 = '15949' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 60559 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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=15949 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0125	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 (60559) 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.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 60559 AND teamId = 15949
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* `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 = 60559 AND t.round = 30 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 = '15949' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15949' and rp.type = 4
0.0130	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 = '15949' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0133	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 events2021 e ON e.player_id = p.id AND e.league_id = 60559 WHERE rp.league_id = 60559 AND rp.teamId = 15949 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.0130	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 events2021 e ON e.player_id = p.id AND e.league_id = 60559 WHERE rp.league_id = 60559 AND rp.teamId = 15949 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 events2021 e ON e.player_id = p.id AND e.league_id = 60559 WHERE rp.league_id = 60559 AND rp.teamId = 15949 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 15949 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 60559 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.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* `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 = 51166 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.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 = 48562 AND t.round = 14 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 = 42638 AND t.round = 18 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 = 44363 AND t.round = 15 ORDER BY team.conference 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* `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 = 37865 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 20343 AND t.round = 36 ORDER BY team.conference 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* `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 = 9445 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* `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 = 3556 AND t.round = 26 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* `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 = 3234 AND t.round = 26 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 = 60559 ORDER BY nameShow LIMIT 100

Merreikh El-Fasher

Merreikh El-Fasher

Selecciona un equipo

Competiciones que juega

Liga Sudán

RIVALES EN Liga Sudán