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

Resultados de Fútbol

Fajr Sepasi

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

LIGA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Esteghlal	30	39	10	68
2	Persepolis	30	41	21	61
3	Sepahan	30	43	21	56
4	Gohar Sirjan	30	37	28	51
5	Foolad	30	30	22	49
6	Rafsanjan	30	39	29	45
7	Zob Ahan	30	21	25	37
8	Aluminium	30	20	23	37
9	Paykan	30	26	27	36
10	Naft Abadan	30	26	30	36
11	Havadar SC	30	18	25	34
12	Nassaji	30	24	34	33
13	Tractor Sazi	30	26	29	32
14	Naft Masjed	30	14	35	22
15	Padideh	30	17	43	17
16	Fajr Sepasi	30	10	29	17

TEMPORADA 2020/2021

SEGUNDA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Fajr Sepasi	34	41	21	60
2	Havadar SC	34	42	26	60
3	Baadraan	34	41	28	60
4	Mes Kerman	34	32	23	55
5	Shahin	34	27	20	53
6	Esteghlal	34	31	20	52
7	Kheybar	34	45	26	49
8	Khooshe	34	34	27	49
9	Arman Gohar	34	47	44	49
10	Pars Jonubi	34	38	34	48
11	Malavan	34	30	30	46
12	Rayka Babol	34	33	38	43
13	Esteqlal	34	39	43	42
14	Qashqai	34	29	35	42
15	Shahrdari	34	35	43	41
16	Chooka	34	29	44	34
17	Navad Urmia	34	14	36	27
18	Gol Reyhan	34	25	74	18

TEMPORADA 2019/2020

SEGUNDA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Rafsanjan	34	56	29	67
2	Aluminium	34	40	20	63
3	Mes Kerman	34	42	23	63
4	Khooshe	34	43	26	59
5	Baadraan	34	50	38	55
6	Havadar SC	34	45	35	55
7	Navad Urmia	33	24	17	52
8	Gol Reyhan	34	39	27	51
9	Esteghlal	33	32	25	45
10	Fajr Sepasi	34	34	32	45
11	Arman Gohar	34	40	42	43
12	Damash Gilan	34	27	35	42
13	Rayka Babol	34	31	33	37
14	Qashqai	34	33	38	37
15	Malavan	34	31	40	35
16	Niroye	34	32	46	33
17	Sepidrood	34	25	47	30
18	Elmoadab	34	14	85	10

TEMPORADA 2018/2019

SEGUNDA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Gohar Sirjan	30	47	26	58
2	Shahin	30	34	17	54
3	Gol Reyhan	30	30	19	48
4	Aluminium	30	27	23	48
5	Mes Kerman	30	38	22	47
6	Havadar SC	30	48	38	43
7	Baadraan	30	35	32	43
8	Fajr Sepasi	31	28	24	41
9	Qashqai	30	28	34	39
10	Rafsanjan	30	40	42	36
11	Malavan	30	29	28	35
12	Navad Urmia	30	23	40	31
13	Kheybar	30	17	35	28
14	Rayka Babol	29	19	30	28
15	Elmoadab	30	27	45	28
16	Shahrdari	30	19	34	25

TEMPORADA 2017/2018

SEGUNDA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Naft Masjed	34	46	25	65
2	Nassaji	34	49	26	64
3	Rayka Babol	34	39	17	64
4	Fajr Sepasi	34	49	25	61
5	Baadraan	34	54	32	59
6	Malavan	34	39	26	55
7	Gohar Sirjan	34	47	35	52
8	Mes Kerman	34	37	33	52
9	Gol Reyhan	34	40	27	51
10	Rafsanjan	34	38	29	48
11	Shahrdari	34	42	43	41
12	Bargh Shiraz	34	30	34	41
13	Aluminium	34	29	34	39
14	Elmoadab	34	36	45	38
15	Machine Sazi	34	27	33	37
16	Iranjavan	34	33	49	33
17	Saba Qom	34	24	90	12
18	Rah Ahan	34	15	71	10

TEMPORADA 2016/2017

SEGUNDA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Pars Jonubi	34	29	14	62
2	Sepidrood	34	35	24	61
3	Gohar Sirjan	34	49	34	60
4	Malavan	34	34	27	58
5	Rayka Babol	35	47	32	57
6	Baadraan	34	34	21	56
7	Mes Kerman	34	35	25	49
8	Gol Reyhan	34	38	29	49
9	Aluminium	34	38	31	48
10	Nassaji	34	44	41	46
11	Rafsanjan	34	42	32	43
12	Iranjavan	34	39	41	38
13	Naft Masjed	34	33	32	37
14	Fajr Sepasi	34	32	38	36
15	Rah Ahan	34	31	49	36
16	Arvand	34	23	41	34
17	Foolad Yazd	34	20	42	30
18	Esteghlal	35	18	68	12

TEMPORADA 2015/2016

SEGUNDA IRÁN
Equipo		PJ	GF	GC	Puntos
1	Paykan	38	50	29	70
2	Naft Abadan	38	52	38	63
3	Machine Sazi	38	54	37	61
4	Fajr Sepasi	38	40	28	61
5	Rayka Babol	38	40	35	59
6	Rafsanjan	38	44	35	58
7	Nassaji	38	39	40	53
8	Aluminium	38	48	41	52
9	Mes Kerman	38	37	35	52
10	Arvand	38	45	43	50
11	Naft Masjed	38	39	39	48
12	Gohar Sirjan	38	35	34	47
13	Foolad Yazd	38	31	38	44
14	Iranjavan	38	42	55	44
15	Parseh	38	44	47	42
16	Pas Hamedan	38	34	40	42
17	Shahrdari	38	43	50	40
18	Giti Pasand	38	26	41	39
19	Damash Gilan	38	29	43	37
20	Aluminium	38	30	54	31

TEMPORADA 2014/2015

SEGUNDA IRÁN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Foolad	22	36	19	42
2	Mes Kerman	22	23	18	36
3	Nassaji	22	23	20	34
4	Fajr Sepasi	22	22	17	30
5	Aluminium	22	20	18	30
6	Shahrdari	22	24	23	30
7	Esteghlal	22	15	18	30
8	Giti Pasand	22	26	22	29
9	Iranjavan	22	19	21	29
10	Niroye	22	16	17	28
11	Naft va Gaz	22	22	28	25
12	Tarbiat	22	8	33	11

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

SEGUNDA IRÁN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Damash Gilan	26	39	24	48
2	Fajr Sepasi	26	24	18	41
3	Shahrdari	26	28	26	39
4	Naft Masjed	26	33	32	35
5	Shahrdari	26	26	26	35
6	Etka Gorgan	26	30	28	34
7	Gohar Sirjan	26	29	27	34
8	Tarbiat	26	24	22	33
9	Payam	26	30	30	32
10	Rafsanjan	26	20	26	32
11	Shahrdari	26	20	28	32
12	Kaveh	26	28	32	31
13	Machine Sazi	26	30	36	31
14	Foolad	26	30	36	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,763,640 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6024
Total Execution Time	0.6036

CADENA URL

/historico/Fajr-Sepasi

GET DATOS

$_GET['/historico/Fajr-Sepasi']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0115	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 = 'Fajr-Sepasi' 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.0106	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=6442 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=6442 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=6442 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0216	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 = 75135
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6442 AND type_rel = 2
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=404 AND type_rel = 3
0.0111	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 = '6442' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0111	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 = '6442' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0116	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 = 75135 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108	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.0110	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=6442 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107	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.0115	SELECT count(id) as num_players from rel_players WHERE league_id = 73661 AND teamId = 6442
0.0118	SELECT count(id) as num_players from rel_players WHERE league_id = 75135 AND teamId = 6442
0.0125	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.0118	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 = '6442' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6442' and rp.type = 4
0.0112	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 = '6442' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138	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 = 6442 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.0126	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 = 6442 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109	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 = 6442 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110	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 = 6442 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111	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.0111	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 = 65392 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.0115	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 = 60079 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.0115	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 = 51087 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.0111	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 = 44751 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118	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 = 38987 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 33438 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 15619 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 9385 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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.0137	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.0126	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.0117	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 = 16156 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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.0110	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.0110	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.0110	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.0111	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.0125	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


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Fajr Sepasi

Fajr Sepasi

Selecciona un equipo

Competiciones que juega

Segunda Irán

RIVALES EN Copa Irán

RIVALES EN Segunda Irán