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

Bahrain SC

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Bahrain SC	21	48	20	46
2	A'Ali	21	45	16	43
3	Ittihad	22	39	25	43
4	Malkiya	21	36	8	42
5	Budaiya	22	32	12	41
6	Ittifaq	22	41	28	32
7	Isa Town	21	25	30	27
8	Buri	22	19	27	24
9	Hassam	21	22	35	18
10	Qalali	22	15	39	18
11	Etehad Reef	21	19	54	17
12	Tadamun Buri	22	8	55	3

TEMPORADA 2022/2023

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Khalidiya	22	45	23	42
2	Manama	22	35	16	41
3	Al-Muharraq	22	34	12	40
4	Al-Riffa	22	37	19	39
5	Sitra	22	30	20	38
6	Ahli Manama	22	24	23	31
7	Al-Hidd	22	29	38	27
8	Al-Shabab	22	21	25	27
9	East Riffa	22	24	26	24
10	Al-Hala	22	22	34	21
11	Bahrain SC	22	22	32	19
12	Budaiya	22	10	65	5

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

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Malkiya	18	24	16	33
2	Al-Riffa	18	32	16	31
3	Al-Hadd	18	27	23	31
4	Manama	18	29	19	30
5	Al-Muharraq	18	30	23	29
6	East Riffa	18	23	25	22
7	Ahli Manama	18	16	24	20
8	Najma Manama	18	20	32	17
9	Bahrain SC	18	18	27	16
10	Al-Hala	18	11	25	14

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

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Muharraq	18	41	18	40
2	Al-Hadd	18	30	15	39
3	Manama	18	31	20	33
4	East Riffa	18	30	24	33
5	Al-Riffa	18	26	17	31
6	Busaiteen	18	17	31	19
7	Al-Hala	18	22	39	19
8	Malkiya	18	17	29	18
9	Bahrain SC	18	22	29	13
10	Al-Shabab	18	12	26	8

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 2012/2013

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Busaiteen	18	44	12	44
2	Al-Muharraq	18	48	17	42
3	Al-Hadd	18	38	19	37
4	Al-Riffa	18	25	25	28
5	Manama	18	36	31	23
6	Najma Manama	18	18	30	22
7	Al-Hala	18	26	33	16
8	Al-Shabab	18	22	38	13
9	Malkiya	18	18	35	13
10	Bahrain SC	18	24	59	11

TEMPORADA 2011/2012

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Riffa	18	34	16	45
2	Al-Muharraq	18	41	13	38
3	Busaiteen	18	34	28	34
4	Al-Hadd	18	23	26	22
5	Al-Hala	18	29	33	21
6	Bahrain SC	18	25	29	21
7	Najma Manama	18	24	26	20
8	Manama	18	20	29	20
9	Ahli Manama	18	15	28	18
10	East Riffa	18	19	36	15

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 2007/2008

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Muharraq	22	66	14	52
2	Busaiteen	22	45	23	42
3	Ahli Manama	22	36	28	42
4	Al-Riffa	22	40	22	40
5	East Riffa	22	28	36	30
6	Najma Manama	22	33	26	28
7	Manama	22	27	36	28
8	Ittihad	22	26	39	24
9	Al-Hala	22	28	50	22
10	Al-Shabab	22	30	44	21
11	Al-Hadd	22	20	39	20
12	Bahrain SC	22	19	41	19

TEMPORADA 2006/2007

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Muharraq	22	56	17	53
2	Al-Riffa	22	34	16	41
3	Najma Manama	22	32	23	38
4	Busaiteen	22	35	27	33
5	Bahrain SC	22	27	32	29
6	Al-Hala	22	42	44	28
7	Al-Shabab	22	30	29	27
8	Ahli Manama	22	30	31	27
9	East Riffa	22	27	32	27
10	Malkiya	22	22	30	22
11	Manama	22	23	38	22
12	Sitra	22	16	55	12

TEMPORADA 2005/2006

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Muharraq	18	29	17	38
2	Ahli Manama	18	47	20	37
3	Al-Riffa	18	36	17	33
4	Najma Manama	18	29	28	25
5	Sitra	18	25	33	22
6	Malkiya	18	27	23	20
7	East Riffa	18	29	36	20
8	Busaiteen	18	19	29	20
9	Al-Shabab	18	21	39	18
10	Bahrain SC	18	16	36	13

TEMPORADA 2004/2005

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Riffa	18	40	18	40
2	Al-Muharraq	18	36	18	36
3	Ahli Manama	18	30	26	33
4	Al-Shabab	18	33	28	32
5	Najma Manama	18	33	18	31
6	Busaiteen	18	25	28	23
7	Bahrain SC	18	21	30	18
8	East Riffa	18	26	33	17
9	Manama	18	22	41	15
10	Al-Hala	18	16	42	8

TEMPORADA 2003/2004

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Muharraq	18	45	9	48
2	Al-Riffa	18	42	17	36
3	Ahli Manama	18	30	20	30
4	Busaiteen	18	32	30	23
5	Bahrain SC	18	30	33	23
6	Al-Shabab	18	24	27	21
7	East Riffa	18	21	39	19
8	Al-Hala	18	30	36	18
9	Najma Manama	18	23	37	17
10	Al-Hadd	18	16	45	10

TEMPORADA 2002/2003

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Riffa	18	48	20	40
2	Al-Muharraq	18	44	22	34
3	Ahli Manama	18	46	30	32
4	Busaiteen	18	28	23	28
5	Al-Hala	18	36	40	22
6	East Riffa	18	29	42	22
7	Bahrain SC	18	22	26	21
8	Al-Shabab	18	25	40	19
9	Najma Manama	18	25	36	18
10	Malkiya	18	20	44	13

Competiciones que juega

Segunda Bahréin

Pos	Equipos		Pts
1		Bahrain SC	46
2		A'Ali	43
3		Al Ittihad Bahrain	43
4		Malkiya	42
5		Budaiya	41
6		Al Ittifaq Maqaba	32
7		Isa Town	27
8		Buri	24
9		Umm Al Hassam	18
10		Qalali	18
11		Etehad Al Reef	17
12		Al Tadamun Buri	3

	Ascenso : Bahrain SC, A'Ali
	Playoff Ascenso : Al Ittihad Bahrain, Malkiya

RIVALES EN Segunda Bahréin

RIVALES EN Copa Bahréin

RIVALES EN Copa del Rey de.

USO DE MEMORIA

6,643,496 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1598
Total Execution Time	0.1611

CADENA URL

/historico/Bahrain-Fc-Manama

GET DATOS

$_GET['/historico/Bahrain-Fc-Manama']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0039	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 = 'Bahrain-Fc-Manama' 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=25042 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=25042 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=25042 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=25042 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038	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.0025	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.0024	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=25042 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1428 AND type_rel = 3
0.0032	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 = '25042' 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 = '25042' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0037	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 = '25042' 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 = 74151 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 = 74277 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 = 74466 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0044	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=25042 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024	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,69339) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 69339 AND teamId = 25042
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 74151 AND teamId = 25042
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 74466 AND teamId = 25042
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 74277 AND teamId = 25042
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 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 = '25042' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25042' and rp.type = 4
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 = '25042' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 25042 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.0020	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 = 25042 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 25042 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037	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 = 25042 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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 = 69339 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.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* `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.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* `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.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 = 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.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* `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.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* `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 = 37150 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* `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.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* `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 = 4835 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* `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.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* `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 = 3022 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* `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 = 8945 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* `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.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* `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 = 8937 AND t.round = 22 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* `tables2007` 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 = 8935 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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* `tables2006` 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 = 8934 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* `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 = 8930 AND t.round = 18 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* `tables2004` 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 = 23367 AND t.round = 18 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* `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 = 23369 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Bahrain SC

Bahrain SC

Selecciona un equipo

Competiciones que juega

Segunda Bahréin

RIVALES EN Segunda Bahréin

RIVALES EN Copa Bahréin

RIVALES EN Copa del Rey de.