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 Ittifaq Maqaba

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2022/2023

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Najma Manama	21	54	17	52
2	Busaiteen	21	40	23	38
3	A'Ali	21	32	20	36
4	Alhassam	21	28	28	31
5	Qalali	21	33	24	29
6	Ittifaq	21	27	27	29
7	Buri	21	29	31	28
8	Malkiya	21	27	27	27
9	Isa Town	21	31	34	26
10	Ittihad	21	23	28	26
11	Al Reef	21	18	50	13
12	Tadamun Buri	21	14	47	7

TEMPORADA 2021/2022

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Shabab	18	43	13	42
2	Bahrain SC	18	35	19	38
3	Sitra	18	28	20	29
4	Malkiya	18	27	23	27
5	Ittifaq	18	29	25	26
6	Ittihad	18	31	32	22
7	Isa Town	18	21	31	21
8	Busaiteen	18	23	34	20
9	Qalali	18	19	25	15
10	Tadamun Buri	18	20	54	9

TEMPORADA 2020/2021

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Hala	18	43	18	41
2	Khalidiya	18	30	12	38
3	Ittifaq	18	26	12	33
4	Isa Town	18	36	22	32
5	Sitra	19	27	21	31
6	Al-Shabab	18	18	19	23
7	Bahrain SC	18	21	20	21
8	Ittihad	19	29	39	21
9	Qalali	18	17	41	11
10	Tadamun Buri	18	15	58	5

TEMPORADA 2019/2020

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Malkiya	16	31	9	41
2	Bahrain SC	16	37	16	34
3	Budaiya	16	26	8	31
4	Isa Town	16	32	15	26
5	Sitra	16	33	19	26
6	Qalali	16	27	21	24
7	Ittihad	16	20	37	13
8	Ittifaq	16	14	41	11
9	Tadamun Buri	16	6	60	0

TEMPORADA 2018/2019

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Ahli Manama	12	40	6	32
2	Sitra	11	22	15	25
3	Busaiteen	11	21	11	23
4	Isa Town	12	17	13	22
5	Ittihad	12	20	9	18
6	Bahrain SC	11	13	15	12
7	Tadamun Buri	12	14	30	7
8	Qalali	11	8	29	6
9	Ittifaq	12	5	32	1

TEMPORADA 2017/2018

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Budaiya	16	36	10	43
2	Al-Hala	16	41	14	40
3	Busaiteen	16	38	13	36
4	Isa Town	16	29	19	28
5	Bahrain SC	16	21	22	18
6	Sitra	16	33	36	17
7	Qalali	16	15	29	11
8	Tadamun Buri	16	15	32	11
9	Ittifaq	16	11	64	1

TEMPORADA 2016/2017

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Shabab	16	41	14	42
2	Al Ittihad	16	27	11	33
3	Budaiya	16	37	19	25
4	Busaiteen	16	28	27	20
5	Isa Town	16	22	36	18
6	Sitra	16	29	29	17
7	Ittifaq	16	30	33	17
8	Tadamun Buri	16	12	32	13
9	Qalali	16	20	45	12

TEMPORADA 2015/2016

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Bahrain SC	16	26	14	34
2	Najma Manama	16	35	14	33
3	Al Ittihad	16	27	13	33
4	Al-Shabab	16	36	13	31
5	Budaiya	16	24	22	26
6	Isa Town	16	17	20	20
7	Tadamun Buri	16	11	37	10
8	Ittifaq	16	15	38	8
9	Qalali	16	18	38	7

TEMPORADA 2014/2015

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Ahli Manama	16	37	12	38
2	Sitra	16	43	16	35
3	Najma Manama	16	31	14	30
4	Budaiya	16	31	23	29
5	Al Ittihad	16	35	19	24
6	Isa Town	16	33	30	21
7	Tadamun Buri	16	23	42	13
8	Qalali	16	17	54	9
9	Ittifaq	16	13	53	1

TEMPORADA 2013/2014

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	East Riffa	16	46	3	44
2	Bahrain SC	16	39	8	41
3	Ahli Manama	16	50	24	33
4	Ittihad	16	26	20	29
5	Budaiya	16	24	36	16
6	Isa Town	16	24	40	14
7	Qalali	16	18	40	14
8	Ittifaq	16	21	39	11
9	Tadamun Buri	16	19	57	5

TEMPORADA 2008/2009

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Muharraq	18	50	9	45
2	Al-Riffa	18	51	11	44
3	Ahli Manama	18	35	10	42
4	East Riffa	18	38	22	40
5	Busaiteen	18	38	22	32
6	Najma Manama	18	29	19	31
7	Manama	18	38	27	30
8	Al-Shabab	18	37	31	30
9	Malkiya	18	23	18	29
10	Al-Hala	18	29	20	28
11	Al-Hadd	18	35	32	28
12	Sitra	18	22	25	25
13	Bahrain SC	18	26	21	22
14	Budaiya	18	15	26	18
15	Qalali	18	19	40	12
16	Ittihad	18	16	41	10
17	Ittifaq	18	12	43	8
18	Isa Town	18	11	54	5
19	Tadamun Buri	18	10	63	2

TEMPORADA 2001/2002

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Muharraq	17	53	10	46
2	Ahli Manama	17	46	9	46
3	Al-Riffa	17	51	14	36
4	Busaiteen	17	33	21	32
5	Malkiya	17	31	22	30
6	Al-Shabab	17	35	29	30
7	Bahrain SC	17	29	21	28
8	Najma Manama	17	28	19	26
9	Al-Hala	17	32	25	26
10	East Riffa	17	27	23	25
11	Isa Town	17	31	27	23
12	Budaiya	17	14	28	19
13	Tadamun Buri	17	21	33	14
14	Sitra	17	19	38	14
15	Ittihad	17	15	36	13
16	Ittifaq	17	16	40	6
17	Sahel	17	18	60	6
18	Manama	17	13	57	6

Competiciones que juega

RIVALES EN Segunda Bahréin

RIVALES EN Copa Bahréin

RIVALES EN Copa del Rey de.

USO DE MEMORIA

5,821,360 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1377
Total Execution Time	0.1390

CADENA URL

/historico/Al-Ittifaq-Maqaba

GET DATOS

$_GET['/historico/Al-Ittifaq-Maqaba']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0030	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-Ittifaq-Maqaba' 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=57522 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=57522 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=57522 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=57522 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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 = 74151
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 = 74277
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 = 74466
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57522 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1428 AND type_rel = 3
0.0035	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 = '57522' ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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 = '57522' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '57522' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 74151 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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 = 74277 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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 = 74466 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036	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=57522 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 (74466,74277,74151,71768) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 74151 AND teamId = 57522
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 71768 AND teamId = 57522
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 74466 AND teamId = 57522
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 74277 AND teamId = 57522
0.0020	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 = 74151 AND t.round = 22 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 = '57522' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '57522' and rp.type = 4
0.0022	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 = '57522' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023	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 = 74151 WHERE rp.league_id = 74151 AND rp.teamId = 57522 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.0021	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 = 74151 WHERE rp.league_id = 74151 AND rp.teamId = 57522 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 = 74151 WHERE rp.league_id = 74151 AND rp.teamId = 57522 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 57522 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0020	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 = 74151 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.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* `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 = 69253 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.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* `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 = 64136 AND t.round = 18 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* `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 = 60332 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 51240 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 45913 AND t.round = 13 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 = 40386 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 37151 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 15777 AND t.round = 18 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* `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 = 8465 AND t.round = 18 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* `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 = 8955 AND t.round = 18 ORDER BY team.conference 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* `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 = 8939 AND t.round = 19 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* `tables2002` 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 = 23370 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 74151 ORDER BY nameShow LIMIT 100

Al Ittifaq Maqaba

Al Ittifaq Maqaba

Selecciona un equipo

Competiciones que juega

RIVALES EN Segunda Bahréin

RIVALES EN Copa Bahréin

RIVALES EN Copa del Rey de.