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

Al Dhafra

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al Urooba	27	49	21	70
2	Dibba	27	46	15	55
3	Dibba Hisn	26	44	20	54
4	United FC	27	52	35	46
5	Al Dhafra	28	52	37	46
6	Al Fujairah	28	47	35	46
7	Taawon	27	38	29	39
8	Masafi	27	40	34	39
9	Jazira Hamra	27	42	51	39
10	Al Arabi SC	26	42	38	38
11	Al Dhaid	27	40	45	33
12	Al Hamriyah	26	32	39	30
13	Gulf Heroes	28	30	40	29
14	Masfut	27	31	47	26
15	Gulf United	28	25	44	23
16	Dubai City	27	27	63	11
17	Al Ramms	25	25	69	10

TEMPORADA 2022/2023

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Shabab Ahli	26	53	25	57
2	Al-Ain	26	67	31	54
3	Al-Wahda	26	48	26	52
4	Al-Wasl	26	52	32	47
5	Al-Jazira	26	50	39	46
6	Ajman	26	41	38	44
7	Sharjah FC	26	42	21	43
8	Ittihad	26	32	41	33
9	Nasr Dubai	26	27	42	27
10	Khorfakkan	26	28	44	25
11	Baniyas	26	34	46	24
12	Al Bataeh	26	30	57	21
13	Dibba	26	20	44	20
14	Al Dhafra	26	26	64	12

TEMPORADA 2021/2022

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Ain	26	57	17	65
2	Sharjah FC	26	46	25	55
3	Al-Wahda	26	51	25	53
4	Al-Jazira	26	42	34	45
5	Shabab Ahli	26	33	30	42
6	Al-Wasl	26	36	30	36
7	Ajman	26	35	40	35
8	Nasr Dubai	26	42	38	33
9	Baniyas	26	33	39	31
10	Ittihad	26	32	38	28
11	Khorfakkan	26	38	49	28
12	Al Dhafra	26	28	36	24
13	Al Urooba	26	25	57	18
14	Emirates	26	21	61	10

TEMPORADA 2020/2021

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Jazira	26	64	29	57
2	Baniyas	26	50	22	54
3	Shabab Ahli	26	52	30	50
4	Sharjah FC	26	48	29	48
5	Nasr Dubai	26	47	33	46
6	Al-Ain	26	39	33	41
7	Al-Wahda	26	48	33	40
8	Ittihad	26	29	39	39
9	Al-Wasl	26	49	47	37
10	Khorfakkan	26	35	50	25
11	Al Dhafra	26	31	58	21
12	Ajman	26	24	57	18
13	Al Fujairah	26	31	57	15
14	Hatta Club	26	19	49	12

TEMPORADA 2019/2020

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Shabab Ahli	19	41	13	43
2	Al-Ain	19	46	21	37
3	Al-Jazira	19	29	17	36
4	Al-Wahda	19	33	30	35
5	Sharjah FC	19	38	23	35
6	Nasr Dubai	19	24	19	31
7	Al-Wasl	19	31	33	29
8	Al Dhafra	19	25	24	29
9	Baniyas	19	21	27	23
10	Ajman	19	25	39	18
11	Ittihad	19	24	39	16
12	Khorfakkan	19	18	32	15
13	Hatta Club	19	15	32	13
14	Al Fujairah	19	15	36	12

TEMPORADA 2018/2019

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Sharjah FC	26	57	30	59
2	Shabab Ahli	26	57	36	53
3	Al-Wahda	26	63	40	46
4	Al-Ain	26	45	35	46
5	Al-Jazira	26	66	41	45
6	Baniyas	26	50	40	40
7	Ajman	26	41	40	37
8	Nasr Dubai	26	42	41	36
9	Al-Wasl	26	45	54	34
10	Al Dhafra	26	37	49	29
11	Ittihad	26	41	51	25
12	Al Fujairah	26	36	63	21
13	Emirates	26	30	62	18
14	Dibba	26	34	62	17

TEMPORADA 2017/2018

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Ain	22	65	23	53
2	Al-Wahda	22	50	29	46
3	Al-Wasl	22	42	27	41
4	Nasr Dubai	22	30	24	37
5	Shabab Ahli	22	25	18	31
6	Sharjah FC	22	26	30	29
7	Al-Jazira	22	34	36	28
8	Ajman	22	25	36	26
9	Dibba	22	21	36	21
10	Al Dhafra	22	24	42	18
11	Emirates	22	22	41	17
12	Hatta Club	22	30	52	16

TEMPORADA 2016/2017

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Jazira	26	72	15	68
2	Al-Wasl	26	55	26	57
3	Ahli Dubai	26	50	18	56
4	Al-Ain	26	58	37	55
5	Al-Wahda	26	54	40	39
6	Nasr Dubai	26	42	32	36
7	Al Dhafra	26	40	46	35
8	Shabab Dubai	26	24	44	30
9	Sharjah FC	26	31	47	26
10	Hatta Club	26	24	47	25
11	Dibba	26	25	54	20
12	Emirates	26	33	51	20
13	Ittihad	26	30	44	19
14	Baniyas	26	33	70	15

TEMPORADA 2015/2016

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Ahli Dubai	26	60	20	66
2	Al-Ain	26	53	24	57
3	Al-Wahda	26	45	28	43
4	Nasr Dubai	26	47	36	41
5	Shabab Dubai	26	34	27	40
6	Al-Wasl	26	42	36	39
7	Al-Jazira	26	51	50	37
8	Al Dhafra	26	37	39	34
9	Baniyas	26	41	47	33
10	Dibba	26	32	46	29
11	Sharjah FC	26	32	40	28
12	Emirates	26	34	47	27
13	Al Fujairah	26	43	62	26
14	Shaab	26	22	71	7

TEMPORADA 2014/2015

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Ain	26	62	19	60
2	Al-Jazira	26	66	46	51
3	Shabab Dubai	26	49	35	49
4	Al-Wahda	26	44	32	47
5	Nasr Dubai	26	43	32	39
6	Al-Wasl	26	53	45	39
7	Ahli Dubai	26	35	27	38
8	Baniyas	26	42	37	35
9	Al Fujairah	26	23	45	32
10	Emirates	26	34	45	30
11	Al Dhafra	26	31	33	27
12	Sharjah FC	26	36	43	26
13	Ajman	26	27	60	15
14	Ittihad	26	17	63	10

TEMPORADA 2013/2014

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Ahli Dubai	26	56	28	64
2	Al-Wahda	26	53	33	48
3	Al-Jazira	26	46	35	45
4	Shabab Dubai	26	42	28	44
5	Nasr Dubai	26	43	32	44
6	Al-Ain	26	52	33	43
7	Sharjah FC	26	29	25	40
8	Al Dhafra	26	44	45	35
9	Baniyas	26	43	42	31
10	Ajman	26	39	46	28
11	Emirates	26	40	53	25
12	Al-Wasl	26	32	47	25
13	Dubai	26	24	63	15
14	Al-Shaab	26	28	61	13

TEMPORADA 2012/2013

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Ain	26	74	26	62
2	Ahli Dubai	26	62	33	51
3	Al-Jazira	26	56	37	47
4	Baniyas	26	50	37	47
5	Al-Shaab	26	48	39	42
6	Nasr Dubai	26	51	40	39
7	Al-Wahda	26	44	41	39
8	Al Dhafra	26	37	46	36
9	Al-Wasl	26	41	45	32
10	Ajman	26	48	58	30
11	Dubai	26	32	53	27
12	Shabab Dubai	26	37	49	25
13	Dibba	26	30	55	21
14	Ittihad	26	24	75	11

TEMPORADA 2011/2012

SEGUNDA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Ittihad	21	53	28	43
2	Dibba	21	46	28	40
3	Shaab	21	42	38	35
4	Al Dhafra	21	52	47	34
5	Khorfakkan	21	35	33	27
6	Al Fujairah	21	33	30	26
7	Masafi	21	23	34	22
8	Al Urooba	21	16	62	5

TEMPORADA 2010/2011

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Jazira	22	64	27	53
2	Baniyas	22	38	24	41
3	Nasr Dubai	22	34	30	35
4	Shabab Dubai	22	42	32	34
5	Al-Wahda	22	44	31	31
6	Al-Wasl	22	31	36	31
7	Sharjah FC	22	30	34	30
8	Ahli Dubai	22	30	42	27
9	Dubai	22	33	48	26
10	Al-Ain	22	33	35	25
11	Ittihad	22	39	56	20
12	Al Dhafra	22	27	50	13

TEMPORADA 2009/2010

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Wahda	22	45	15	58
2	Al-Jazira	22	48	26	51
3	Al-Ain	22	57	29	45
4	Baniyas	22	44	37	36
5	Al-Wasl	22	41	40	29
6	Sharjah FC	22	37	36	28
7	Shabab Dubai	22	35	44	28
8	Ahli Dubai	22	42	43	26
9	Al Dhafra	22	47	55	26
10	Nasr Dubai	22	37	49	23
11	Emirates	22	37	57	14
12	Ajman	22	29	68	8

TEMPORADA 2008/2009

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Ahli Dubai	22	54	25	55
2	Al-Jazira	22	57	17	54
3	Al-Ain	22	40	20	43
4	Al-Wahda	22	40	39	34
5	Shabab Dubai	22	34	37	28
6	Nasr Dubai	22	37	40	26
7	Al-Wasl	22	38	46	26
8	Al Dhafra	22	32	32	24
9	Ajman	22	21	39	24
10	Sharjah FC	22	31	45	22
11	Al-Shaab	22	23	37	18
12	Khorfakkan	22	21	51	14

TEMPORADA 2007/2008

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Shabab Dubai	22	44	30	42
2	Al-Jazira	22	46	31	39
3	Ahli Dubai	22	47	27	37
4	Sharjah FC	22	35	35	33
5	Al-Shaab	22	39	44	33
6	Al-Ain	22	41	37	30
7	Al-Wasl	22	39	37	30
8	Al-Wahda	22	42	42	30
9	Nasr Dubai	22	37	39	28
10	Al Dhafra	22	34	41	25
11	Emirates	22	37	54	17
12	Hatta Club	22	23	47	16

TEMPORADA 2004/2005

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Wahda	26	75	35	62
2	Al-Ain	26	54	26	57
3	Al-Jazira	26	62	41	53
4	Nasr Dubai	26	48	33	46
5	Sharjah FC	26	59	44	42
6	Shabab Dubai	26	43	44	40
7	Ahli Dubai	26	58	40	39
8	Al-Wasl	26	36	36	34
9	Al-Shaab	26	37	44	34
10	Emirates	26	26	47	26
11	Dubai	27	31	54	25
12	Khorfakkan	26	36	62	19
13	Ittihad	26	27	55	19
14	Al Dhafra	26	36	67	13
15	Al Husun	1	1	1	1

TEMPORADA 2002/2003

LIGA EMIRATOS
Equipo		PJ	GF	GC	Puntos
1	Al-Ain	22	51	20	48
2	Al-Wahda	22	50	29	43
3	Ahli Dubai	22	47	36	34
4	Nasr Dubai	22	36	25	34
5	Al-Shaab	22	39	31	32
6	Al-Jazira	22	33	32	31
7	Sharjah FC	22	28	42	25
8	Al-Wasl	22	27	36	23
9	Shabab Dubai	22	30	38	22
10	Ittihad	22	22	31	22
11	Dubai	22	36	56	17
12	Al Dhafra	22	29	52	17

Competiciones que juega

Segunda Emiratos

Pos	Equipos		Pts
1		Al Urooba	70
2		Dibba Al Fujairah	55
3		Dibba Al Hisn	54
4		United FC	46
5		Al Dhafra	46
6		Al Fujairah	46
7		Al Taawon SC	39
8		Masafi	39
9		Al Jazira Al Hamra	39
10		Al Arabi SC	38
11		Al Dhaid	33
12		Al Hamriyah	30
13		Gulf Heroes	29
14		Masfut	26
15		Gulf United	23
16		Dubai City	11
17		Al Ramms	10

	Ascenso : Al Urooba, Dibba Al Fujairah
	Descenso : Dubai City, Al Ramms

RIVALES EN Copa del Preside.

RIVALES EN Segunda Emiratos

USO DE MEMORIA

7,046,912 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1678
Total Execution Time	0.1689

CADENA URL

/historico/Al-Dhafra

GET DATOS

$_GET['/historico/Al-Dhafra']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0032	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-Dhafra' 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.0020	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=107 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=107 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=107 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=107 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 = 73800
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 = 74207
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=107 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 107 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (13147,373536) ORDER BY n.cover_points DESC, update_date DESC
0.0030	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 = '107' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '107' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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 = '107' 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 = 74207 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 73800 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030	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=107 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 (74207,73800,71432,69298,68707) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 68707 AND teamId = 107
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 73800 AND teamId = 107
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 69298 AND teamId = 107
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 74207 AND teamId = 107
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 107
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 = 73800 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025	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 = '107' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '107' and rp.type = 4
0.0023	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 = '107' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0052	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 = 73800 WHERE rp.league_id = 73800 AND rp.teamId = 107 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.0022	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 = 73800 WHERE rp.league_id = 73800 AND rp.teamId = 107 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037	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 = 73800 WHERE rp.league_id = 73800 AND rp.teamId = 107 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035	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 = 107 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 = 73800 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 68707 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 63239 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 56840 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 49876 AND t.round = 19 ORDER BY team.conference ASC,t.position 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* `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 = 43562 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 38722 AND t.round = 22 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* `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 = 29627 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 15741 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 4458 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 3251 AND t.round = 26 ORDER BY team.conference 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* `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 = 2216 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 15233 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 1652 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 1651 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 463 AND t.round = 22 ORDER BY team.conference 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* `tables2008` 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 = 271 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2005` 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 = 23803 AND t.round = 27 ORDER BY team.conference 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* `tables2003` 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 = 23815 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1585 AND l.year = 2024 ORDER BY l.group_code ASC

Al Dhafra

Al Dhafra

Selecciona un equipo

Competiciones que juega

Segunda Emiratos

RIVALES EN Copa del Preside.

RIVALES EN Segunda Emiratos