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

Saipa

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Kheybar	26	42	14	61
2	Chadormalu	26	39	19	55
3	Fajr Sepasi	26	34	12	54
4	Naft Masjed	26	38	23	50
5	Saipa	26	25	19	38
6	Soongoun	26	22	22	38
7	Naft va Gaz	26	28	18	36
8	Ario	26	19	19	36
9	Mes Kerman	26	21	20	35
10	Pars Jonubi	26	26	32	34
11	Shahr Babak	26	21	17	33
12	Esteqlal	26	20	21	30
13	Shahr Raz	26	18	24	30
14	Shahrdari	26	15	29	26
15	Shahin	26	19	43	22
16	Darya	26	18	33	19
17	Damash Gilan	26	19	37	19
18	Khooshe	26	13	35	17

TEMPORADA 2022/2023

SEGUNDA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Shams Azar.	32	66	24	70
2	Esteghlal	32	47	21	57
3	Saipa	32	30	22	55
4	Fajr Sepasi	32	40	25	53
5	Kheybar	32	32	16	52
6	Shahr Babak	32	24	20	45
7	Pars Naghshe	32	32	29	45
8	Chadormalu	32	32	31	45
9	Pars Jonubi	32	24	33	40
10	Darya	32	26	25	38
11	Esteqlal	32	27	42	37
12	Khooshe	32	26	33	35
13	Shahrdari	32	16	25	33
14	Arman Gohar	32	29	45	33
15	Khalij Fars	32	21	42	29
16	Shahrdari	32	16	30	28
17	Chooka	32	29	54	22
18	Padideh	0	0	0	0

TEMPORADA 2021/2022

SEGUNDA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Mes Kerman	34	40	10	70
2	Malavan	34	39	16	68
3	Arman Gohar	34	41	26	61
4	Kheybar	34	47	29	59
5	Pars Jonubi	34	37	36	52
6	Khooshe	34	48	39	50
7	Shahr Babak	34	30	23	46
8	Esteqlal	34	31	27	46
9	Shams Azar.	34	37	35	44
10	Shahrdari	34	27	24	43
11	Shahrdari	34	26	29	42
12	Esteghlal	34	37	34	40
13	Saipa	34	33	35	40
14	Vista	34	27	32	40
15	Qashqai	34	26	34	39
16	Rayka Babol	34	32	36	38
17	Shahin	34	14	55	15
18	Machine Sazi	34	29	81	12

TEMPORADA 2020/2021

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Persepolis	30	47	14	67
2	Sepahan	30	53	24	65
3	Esteghlal	30	36	19	56
4	Tractor Sazi	30	35	29	45
5	Gohar Sirjan	30	33	32	45
6	Foolad	30	27	18	44
7	Paykan	30	32	30	40
8	Rafsanjan	30	23	29	39
9	Padideh	30	27	31	38
10	Naft Abadan	30	24	29	37
11	Aluminium	30	25	33	37
12	Nassaji	30	27	34	33
13	Naft Masjed	30	21	29	31
14	Zob Ahan	30	28	39	26
15	Saipa	30	19	34	26
16	Machine Sazi	30	19	52	14

TEMPORADA 2019/2020

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Persepolis	30	46	17	67
2	Esteghlal	30	55	31	53
3	Foolad	30	28	19	51
4	Tractor Sazi	30	31	23	50
5	Sepahan	30	39	22	49
6	Padideh	30	27	25	46
7	Naft Abadan	30	29	33	41
8	Naft Masjed	30	24	22	38
9	Nassaji	30	30	32	38
10	Gohar Sirjan	30	27	34	33
11	Machine Sazi	30	28	40	31
12	Zob Ahan	30	31	39	30
13	Paykan	30	38	44	29
14	Saipa	30	24	35	29
15	Pars Jonubi	30	20	30	27
16	Shahin	30	26	57	22

TEMPORADA 2018/2019

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Persepolis	30	36	14	61
2	Sepahan	30	46	20	58
3	Esteghlal	30	40	13	57
4	Padideh	30	32	16	56
5	Tractor Sazi	30	42	25	52
6	Zob Ahan	30	28	28	40
7	Saipa	30	28	33	38
8	Foolad	30	30	39	38
9	Naft Abadan	30	31	30	37
10	Nassaji	30	29	29	36
11	Paykan	30	27	35	35
12	Pars Jonubi	30	28	33	30
13	Machine Sazi	30	19	26	29
14	Naft Masjed	30	16	34	22
15	Sepidrood	30	24	53	20
16	Esteghlal	30	19	47	12

TEMPORADA 2017/2018

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Persepolis	30	48	15	64
2	Zob Ahan	30	46	30	55
3	Esteghlal	30	43	18	54
4	Saipa	30	40	34	54
5	Pars Jonubi	30	34	24	47
6	Paykan	30	32	26	45
7	Foolad	30	28	27	44
8	Naft Abadan	30	36	36	40
9	Gostaresh	30	24	32	37
10	Tractor Sazi	30	28	33	34
11	Padideh	30	33	33	33
12	Esteghlal	30	25	42	31
13	Sepidrood	30	24	39	30
14	Sepahan	30	31	34	29
15	Naft Tehran	30	23	41	24
16	Mashhad	30	17	48	15

TEMPORADA 2016/2017

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Persepolis	30	46	14	66
2	Esteghlal	30	45	27	57
3	Tractor Sazi	30	38	24	56
4	Zob Ahan	30	39	30	46
5	Sepahan	30	38	34	45
6	Paykan	30	39	38	44
7	Esteghlal	30	36	34	41
8	Gostaresh	30	26	24	38
9	Naft Tehran	30	31	34	36
10	Foolad	30	30	32	35
11	Padideh	30	28	36	34
12	Naft Abadan	30	24	34	33
13	Saipa	30	20	30	32
14	Mashhad	30	24	35	30
15	Saba Qom	30	22	33	28
16	Machine Sazi	30	18	45	16

TEMPORADA 2015/2016

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Esteghlal	30	33	14	57
2	Persepolis	30	50	34	57
3	Esteghlal	30	43	28	52
4	Tractor Sazi	30	43	27	51
5	Naft Tehran	30	30	21	49
6	Zob Ahan	30	38	26	46
7	Saba Qom	30	30	24	42
8	Saipa	30	28	31	40
9	Gostaresh	30	36	32	39
10	Padideh	30	30	35	39
11	Sepahan	30	29	30	38
12	Foolad	30	26	37	35
13	Mashhad	30	23	34	27
14	Malavan	30	23	35	27
15	Rah Ahan	30	24	36	25
16	Esteghlal	30	16	58	13

TEMPORADA 2014/2015

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Sepahan	30	46	27	59
2	Tractor Sazi	30	58	34	58
3	Naft Tehran	30	44	29	57
4	Zob Ahan	30	46	26	52
5	Foolad	30	33	24	52
6	Esteghlal	30	40	34	47
7	Saipa	30	36	34	41
8	Persepolis	30	31	35	36
9	Saba Qom	30	25	34	34
10	Padideh	30	23	25	33
11	Gostaresh	30	30	39	31
12	Rah Ahan	30	27	48	31
13	Malavan	30	26	34	30
14	Paykan	30	17	28	28
15	Esteghlal	30	35	46	27
16	Naft Masjed	30	19	39	22

TEMPORADA 2013/2014

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Foolad	30	36	24	57
2	Persepolis	30	34	15	56
3	Naft Tehran	30	39	23	54
4	Sepahan	30	36	20	54
5	Esteghlal	30	33	25	52
6	Tractor Sazi	30	39	33	46
7	Malavan	30	40	33	45
8	Saipa	30	26	31	35
9	Gostaresh	30	31	33	33
10	Saba Qom	30	32	38	33
11	Rah Ahan	30	25	34	31
12	Esteghlal	30	26	37	29
13	Zob Ahan	30	24	36	29
14	Fajr Sepasi	30	20	34	29
15	Damash Gilan	30	30	40	27
16	Mes Kerman	30	21	36	22

TEMPORADA 2012/2013

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Esteghlal	34	42	18	67
2	Tractor Sazi	34	55	32	65
3	Sepahan	34	60	33	64
4	Foolad	34	52	35	56
5	Naft Tehran	34	42	29	55
6	Mes Kerman	34	33	22	53
7	Persepolis	34	41	31	50
8	Rah Ahan	34	32	35	46
9	Saba Qom	34	37	33	45
10	Saipa	34	37	33	45
11	Damash Gilan	34	36	43	43
12	Fajr Sepasi	34	42	38	42
13	Malavan	34	34	39	40
14	Zob Ahan	34	36	40	38
15	Aluminium	34	26	40	35
16	Naft Abadan	34	31	60	25
17	Paykan	34	26	66	25
18	Gahar Zagros	34	24	59	19

TEMPORADA 2011/2012

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Sepahan	34	54	27	67
2	Tractor Sazi	34	57	32	66
3	Esteghlal	34	58	34	66
4	Saba Qom	34	40	38	50
5	Naft Tehran	34	36	38	49
6	Zob Ahan	34	29	33	45
7	Damash Gilan	34	34	38	44
8	Saipa	34	50	39	43
9	Mes Kerman	34	35	39	43
10	Naft Abadan	34	49	57	43
11	Rah Ahan	34	43	42	42
12	Persepolis	34	50	54	42
13	Fajr Sepasi	34	31	38	41
14	Foolad	34	35	37	40
15	Malavan	34	32	33	39
16	Elmoadab	34	34	44	34
17	Shahin	34	30	43	33
18	Sarcheshme	34	23	54	24

TEMPORADA 2010/2011

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Sepahan	34	56	29	66
2	Esteghlal	34	55	34	65
3	Zob Ahan	34	49	31	63
4	Persepolis	34	50	36	58
5	Tractor Sazi	34	42	29	57
6	Foolad	34	58	36	54
7	Mes Kerman	34	41	30	52
8	Malavan	34	33	32	48
9	Naft Abadan	34	36	54	42
10	Saba Qom	34	39	40	41
11	Saipa	34	42	47	37
12	Elmoadab	34	45	53	37
13	Naft Tehran	34	38	44	36
14	Shahin	34	31	37	35
15	Rah Ahan	34	29	39	35
16	Pas Hamedan	34	30	48	35
17	Paykan	34	38	60	33
18	Steel Azin	34	30	63	28

TEMPORADA 2009/2010

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Sepahan	34	67	30	67
2	Zob Ahan	34	48	29	61
3	Esteghlal	34	49	32	59
4	Persepolis	34	46	40	53
5	Steel Azin	34	55	49	52
6	Saba Qom	34	52	45	48
7	Tractor Sazi	34	43	42	47
8	Saipa	34	48	53	46
9	Mes Kerman	34	55	56	42
10	Foolad	34	31	34	42
11	Paykan	34	40	44	41
12	Malavan	34	31	47	41
13	Shahin	34	37	37	39
14	Pas Hamedan	34	36	44	38
15	Sorinet	34	36	44	38
16	Fajr Sepasi	34	34	45	37
17	Aboomoslem	34	36	51	32
18	Esteghlal	34	38	60	30

TEMPORADA 2008/2009

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Esteghlal	34	70	34	66
2	Zob Ahan	34	58	42	66
3	Mes Kerman	34	54	36	61
4	Sepahan	34	46	34	56
5	Persepolis	34	50	41	55
6	Saba Qom	34	49	36	53
7	Foolad	34	50	41	50
8	Paykan	34	43	42	47
9	Fajr Sepasi	34	33	37	44
10	Saipa	34	43	50	42
11	Rah Ahan	34	35	41	41
12	Pas Hamedan	34	40	47	40
13	Malavan	34	31	43	40
14	Esteghlal	34	37	54	37
15	Aboomoslem	34	34	41	35
16	Payam	34	33	52	35
17	Damash Gilan	34	40	56	31
18	Bargh Shiraz	34	35	54	24

TEMPORADA 2007/2008

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Persepolis	34	57	32	62
2	Sepahan	34	53	38	58
3	Saba Qom	34	40	37	52
4	Aboomoslem	34	37	37	50
5	Pas Hamedan	34	36	28	49
6	Saipa	34	32	33	48
7	Bargh Shiraz	34	43	47	47
8	Esteghlal	34	61	51	46
9	Paykan	34	41	40	46
10	Zob Ahan	34	37	34	45
11	Esteghlal	34	44	44	43
12	Rah Ahan	34	44	41	42
13	Mes Kerman	34	35	35	42
14	Fajr Sepasi	34	35	41	42
15	Pegah Gilan	34	26	35	38
16	Naft Abadan	34	38	45	36
17	Malavan	34	32	40	36
18	Shirin-Faraz	34	24	57	21

TEMPORADA 2006/2007

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Saipa	30	45	31	56
2	Esteghlal	30	33	28	54
3	Persepolis	30	49	33	53
4	Esteghlal	30	39	30	52
5	Sepahan	30	41	28	49
6	Aboomoslem	30	40	36	43
7	Paykan	30	37	42	41
8	Zob Ahan	30	39	42	39
9	Mes Kerman	30	35	39	36
10	Fajr Sepasi	30	29	32	34
11	Pas Tehran	30	36	36	33
12	Bargh Shiraz	30	35	45	33
13	Saba Qom	30	28	31	32
14	Malavan	30	21	30	32
15	Foolad	30	24	33	28
16	Rah Ahan	30	30	45	20

TEMPORADA 2005/2006

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Esteghlal	30	44	17	59
2	Pas Hamedan	30	54	29	58
3	Saipa	30	40	20	52
4	Saba Qom	30	35	31	50
5	Aboomoslem	30	30	22	46
6	Zob Ahan	30	41	30	45
7	Sepahan	30	37	30	43
8	Foolad	30	30	41	41
9	Persepolis	30	39	40	38
10	Fajr Sepasi	30	27	33	36
11	Malavan	30	29	38	36
12	Esteghlal	30	42	44	35
13	Rah Ahan	30	25	41	34
14	Bargh Shiraz	30	23	37	28
15	Shemushack	30	18	39	23
16	Ghandi	30	21	43	19

TEMPORADA 2004/2005

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Foolad	30	41	20	64
2	Zob Ahan	30	38	19	58
3	Esteghlal	30	51	35	58
4	Persepolis	30	43	26	55
5	Esteghlal	30	41	35	44
6	Pas Hamedan	30	48	40	42
7	Malavan	30	34	27	41
8	Aboomoslem	30	33	33	38
9	Saba Qom	30	38	40	35
10	Sepahan	30	30	33	35
11	Fajr Sepasi	30	24	32	35
12	Bargh Shiraz	30	34	43	33
13	Saipa	30	24	34	31
14	Shemushack	30	27	49	31
15	Paykan	30	22	34	24
16	Damash Gilan	30	17	45	20

Competiciones que juega

Segunda Irán

Pos	Equipos		Pts
1		Kheybar	61
2		Chadormalu	55
3		Fajr Sepasi	54
4		Naft Masjed Soleyman	50
5		Saipa	38
6		Mes Soongoun Varzaghan	38
7		Naft va Gaz	36
8		Ario	36
9		Mes Kerman	35
10		Pars Jonubi	34
11		Mes Shahr Babak	33
12		Esteqlal Abi Push	30
13		Shahr Raz	30
14		Shahrdari Astara	26
15		Shahin Bandar Ameri	22
16		Darya Caspian	19
17		Damash Gilan	19
18		Khooshe Talaee	17

	Ascenso : Kheybar, Chadormalu
	Descenso : Darya Caspian, Damash Gilan, Khooshe Talaee

RIVALES EN Copa Irán

RIVALES EN Segunda Irán

USO DE MEMORIA

7,703,016 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1536
Total Execution Time	0.1548

CADENA URL

/historico/Saipa-Shomal

GET DATOS

$_GET['/historico/Saipa-Shomal']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0034	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 = 'Saipa-Shomal' 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=13853 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=13853 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=13853 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13853 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=404 AND type_rel = 3
0.0026	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 = '13853' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '13853' 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 = 73661 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=13853 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (75135,73661) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 73661 AND teamId = 13853
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 75135 AND teamId = 13853
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 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 = 73661 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '13853' 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 = '13853' and rp.type = 4
0.0020	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 = '13853' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034	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 = 73661 WHERE rp.league_id = 73661 AND rp.teamId = 13853 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.0028	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 = 73661 WHERE rp.league_id = 73661 AND rp.teamId = 13853 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 73661 WHERE rp.league_id = 73661 AND rp.teamId = 13853 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 13853 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73661 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* `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 = 68880 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.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 = 65398 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.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 = 60078 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.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 = 50109 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.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* `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 = 43571 AND t.round = 30 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* `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 = 38851 AND t.round = 30 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* `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 = 33437 AND t.round = 30 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 = 4191 AND t.round = 30 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* `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 = 2046 AND t.round = 30 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* `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 = 3196 AND t.round = 34 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 = 1588 AND t.round = 34 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 = 1589 AND t.round = 34 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* `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 = 1065 AND t.round = 34 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* `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 = 266 AND t.round = 34 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* `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 = 10597 AND t.round = 34 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* `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 = 10598 AND t.round = 30 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* `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 = 16147 AND t.round = 30 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* `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 = 16148 AND t.round = 30 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 = 73661 ORDER BY nameShow LIMIT 100

Saipa

Saipa

Selecciona un equipo

Competiciones que juega

Segunda Irán

RIVALES EN Copa Irán

RIVALES EN Segunda Irán