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

Sitra

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Khalidiya	19	37	15	38
2	Al-Riffa	19	30	21	34
3	Al-Muharraq	18	33	24	31
4	Manama	18	22	21	26
5	Ahli Manama	18	24	25	26
6	Najma Manama	18	34	33	23
7	Al-Shabab	19	24	30	21
8	Sitra	19	25	30	21
9	East Riffa	19	21	26	21
10	Al-Hala	19	16	29	20
11	Al-Hidd	18	22	28	18
12	Busaiteen	18	20	26	18

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

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

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Hadd	18	39	15	42
2	Al-Muharraq	18	31	21	32
3	Malkiya	18	23	20	27
4	Al-Riffa	18	22	26	23
5	East Riffa	18	22	18	22
6	Ahli Manama	18	22	21	22
7	Manama	18	17	27	21
8	Al-Hala	18	22	31	20
9	Busaiteen	18	17	31	20
10	Sitra	18	20	25	18

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

LIGA BAHRÉIN
Equipo		PJ	GF	GC	Puntos
1	Al-Riffa	18	24	12	38
2	Manama	18	33	16	37
3	Al-Hadd	18	32	16	34
4	Al-Muharraq	18	26	14	34
5	Busaiteen	18	27	26	22
6	Al-Hala	18	21	20	20
7	Malkiya	18	18	24	20
8	Al-Shabab	18	18	26	17
9	Najma Manama	18	15	29	13
10	Sitra	18	14	45	6

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

Liga Bahréin

Pos	Equipos		Pts
1		Khalidiya	38
2		Al-Riffa	34
3		Al-Muharraq	31
4		Manama	26
5		Al Ahli Manama	26
6		Al Najma Manama	23
7		Al-Shabab Manama	21
8		Sitra	21
9		East Riffa	21
10		Al-Hala	20
11		Al-Hidd	18
12		Busaiteen	18

	: Khalidiya
	Playoff Descenso : East Riffa, Al-Hala
	Descenso : Al-Hidd, Busaiteen

RIVALES EN Copa Bahréin

RIVALES EN Copa del Rey de.

RIVALES EN Liga Bahréin

USO DE MEMORIA

6,258,192 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8385
Total Execution Time	0.8397

CADENA URL

/historico/Sitra

GET DATOS

$_GET['/historico/Sitra']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0212	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 = 'Sitra' 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.0148	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=15455 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=15455 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	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=15455 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=15455 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0291	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 = 73656
0.0150	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.0151	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.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15455 AND type_rel = 2
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=431 AND type_rel = 3
0.0146	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 431 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147	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 (1091300,1091289,1090156,1015512,810293) ORDER BY n.cover_points DESC, update_date DESC
0.0151	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 = '15455' ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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 = '15455' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152	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 = '15455' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151	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.0147	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.0146	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 = 73656 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	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=15455 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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,73656) 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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 73656 AND teamId = 15455
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 74466 AND teamId = 15455
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 74277 AND teamId = 15455
0.0148	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 = 73656 AND t.round = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146	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 = '15455' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15455' and rp.type = 4
0.0147	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 = '15455' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0153	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 = 73656 WHERE rp.league_id = 73656 AND rp.teamId = 15455 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.0160	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 = 73656 WHERE rp.league_id = 73656 AND rp.teamId = 15455 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0164	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 = 73656 WHERE rp.league_id = 73656 AND rp.teamId = 15455 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0193	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 = 15455 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0157	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 = 73656 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.0151	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.0147	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.0148	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.0147	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.0148	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.0148	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.0147	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.0150	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 = 15754 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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.0147	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 = 3637 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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.0149	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.0147	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.0150	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.0147	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 = 73656 ORDER BY nameShow LIMIT 100

Sitra

Sitra

Selecciona un equipo

Competiciones que juega

Liga Bahréin

RIVALES EN Copa Bahréin

RIVALES EN Copa del Rey de.

RIVALES EN Liga Bahréin