Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

2021/2022

Azadegan League

Eliminatoria

Segunda Irán 2022

Ver

TEMPORADA 2021/2022

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

Ver

TEMPORADA 2020/2021

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

Ver

TEMPORADA 2019/2020

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

Ver

TEMPORADA 2018/2019

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

Ver

TEMPORADA 2017/2018

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

Ver

TEMPORADA 2016/2017

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

Ver

TEMPORADA 2015/2016

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

Ver

TEMPORADA 2014/2015

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

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Padideh	24	32	15	46
2	Mashhad	24	27	17	45
3	Nassaji	24	27	22	37
4	Naft Abadan	24	24	20	35
5	Giti Pasand	24	29	28	35
6	Shahrdari	24	23	21	33
7	Gohar Sirjan	24	29	22	32
8	Esteghlal	24	27	29	31
9	Niroye	24	25	27	31
10	Foolad Yazd	24	20	18	29
11	Shahrdari	24	21	23	28
12	Alvand	24	23	34	22
13	Gahar Zagros	24	15	46	12

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Gostaresh	26	44	25	50
2	Sarcheshme	26	29	15	47
3	Naft Masjed	26	41	31	45
4	Alvand	26	33	23	43
5	Gohar Sirjan	26	29	25	41
6	Aboomoslem	26	39	34	38
7	Nassaji	26	33	27	36
8	Tarbiat	26	37	32	34
9	Parseh	26	30	30	31
10	Esteghlal	26	26	35	30
11	Etka Gorgan	26	15	24	30
12	Shahin	26	18	30	26
13	Shahrdari	26	16	30	25
14	Machine Sazi	26	18	47	13

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Paykan	26	44	26	50
2	Iranjavan	26	31	16	48
3	Steel Azin	26	29	22	40
4	Shahrdari	26	26	27	38
5	Shahrdari	26	19	17	37
6	Foolad Yazd	26	25	23	36
7	Aboomoslem	26	21	18	34
8	Etka Gorgan	26	21	20	34
9	Persepolis	26	26	26	33
10	Gostaresh	26	25	30	32
11	Parseh	26	20	29	28
12	Rafsanjan	26	22	28	26
13	Sanat Sari	26	20	34	26
14	Payam	26	15	28	25

Ver

TEMPORADA 2010/2011

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

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Elmoadab	26	43	11	62
2	Naft Abadan	26	38	26	45
3	Tarbiat	26	29	18	44
4	Sepahan	26	42	31	41
5	Etka Gorgan	26	21	21	37
6	Shahrdari	26	34	25	36
7	Rafsanjan	26	30	24	36
8	Payam	26	33	36	34
9	Kaveh	26	27	30	34
10	Iranjavan	26	31	34	32
11	Gahar Zagros	26	23	33	29
12	Payam	26	23	30	28
13	Shemushack	26	29	37	26
14	Shahin Ahvaz	26	11	58	8

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Steel Azin	26	49	32	55
2	Elmoadab	26	39	25	48
3	Petroshmi	26	43	32	46
4	Sanaye Arak	26	37	23	45
5	Gohar Sirjan	26	33	30	39
6	Sepahan	26	35	31	38
7	Naft Abadan	26	28	27	33
8	Kowsar	26	20	29	33
9	Mehrkam Pars	26	31	34	31
10	Moghavemat	26	26	33	26
11	Shahrdari	26	26	33	26
12	Nassaji	26	24	35	25
13	Homa Tehran	26	21	32	21
14	Shahdari	26	20	36	19

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Steel Azin	22	41	28	38
2	Payam	22	29	21	38
3	Niroye	22	26	19	37
4	Sorkhpoushan	22	19	19	32
5	Tractor Sazi	22	23	19	31
6	Gohar Sirjan	22	26	24	31
7	Shahrdari	22	26	21	29
8	Gahar Zagros	22	24	26	28
9	Shahdari	22	18	18	26
10	Moghavemat	22	22	25	26
11	Shemushack	22	19	28	25
12	Shahin Ahvaz	22	20	45	14

JUGADORES DESTACADOS

Nombre	Goles	Equipo
A. Vaziri	20	ARM
B. Salari	12	AKF
A. Shahim	9	MAC
H. Kazemi	9	MAL
A. Sarabadani	8	SAQ
A. Abadi	6	ARM
M. Ghorbanzadeh	6	RAY
M. Barani	6	MAL
F. Padash	6	AST
F. Janfaza	6	EKU

Equipos de esta liga

USO DE MEMORIA

6,910,552 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.5099
Total Execution Time	0.5118

CADENA URL

/premier_league_azadegan2022/grupo1/historico

GET DATOS

$_GET['/premier_league_azadegan2022/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0125	SELECT type FROM routes WHERE alias = 'premier_league_azadegan2022'
0.0252	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_azadegan' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=404 AND type_rel = 3
0.0125	SELECT id,name,alias,stepParent FROM categories WHERE parentId=404 ORDER BY order_id ASC
0.0126	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 65398 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 404 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0129	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.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* `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.0130	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.0129	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.0130	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.0129	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.0130	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.0129	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 = 2902 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 16150 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 16153 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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.0129	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 = 16159 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 16162 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 16165 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 12:07:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 12:07:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 12:07:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 12:07:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_azadegan' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0184	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 65398 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65398 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 65398 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65398 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0128	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 65398 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65398 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136	SELECT ,(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

Nombre	Rojas	Equipo
Amir Mirbozorgi	1	KHO
M. Beladi	1	FCV
M. Azhir	1	RAY
H. Masoud	1	MAC
J. Abbasi M.	1	AKF
Rouzbeh Sinaki	1	PAR
M. Shabanloo	1	MSB
F. Padash	1	AST
A. Goudarzi	1	RAY


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