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

Feldkirchen

Temporada 2023/2024

TEMPORADA 2022/2023

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Klagenfu	32	74	36	65
2	Spittal	32	77	46	56
3	Austria	32	63	43	54
4	Ferlach	32	52	40	54
5	KAC	32	45	42	45
6	Lendorf	32	57	45	44
7	ATSV	32	69	64	44
8	St. Jakob	32	61	57	44
9	Kraig	32	39	64	43
10	Bleiburg	32	48	49	42
11	Köttmannsdo	32	56	58	42
12	Völkermarkt	32	49	58	42
13	Landskron	32	53	67	41
14	Feldkirchen	32	39	43	39
15	Maria Saal	32	58	77	38
16	Andra	32	50	73	30
17	ASKÖ Gmünd	32	26	54	29

TEMPORADA 2021/2022

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dellach	34	94	42	72
2	Klagenfurt	34	64	41	60
3	Völkermarkt	34	64	44	54
4	Köttmannsdo	34	58	46	54
5	Klagenfu	34	67	63	54
6	Ferlach	34	56	46	53
7	KAC	34	65	56	51
8	St. Jakob	34	57	40	50
9	Kraig	34	61	54	50
10	Lendorf	34	47	50	47
11	ASKÖ Gmünd	34	50	49	46
12	Feldkirchen	34	48	45	46
13	Maria Saal	34	54	72	45
14	ATSV	34	57	52	44
15	Bleiburg	34	51	62	43
16	Andra	34	39	70	32
17	Admira	34	39	93	28
18	Sankt	34	36	82	25

TEMPORADA 2020/2021

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Treibach	15	46	18	35
2	Dellach	15	45	21	31
3	St. Jakob	15	29	16	31
4	KAC	15	26	19	28
5	Köttmannsdo	15	33	26	26
6	ATSV	15	27	29	26
7	Ferlach	15	29	22	23
8	ASKÖ Gmünd	15	29	22	22
9	Klagenfurt	15	24	21	22
10	Völkermarkt	15	21	31	20
11	Feldkirchen	15	19	33	16
12	Lendorf	15	22	32	14
13	Kraig	15	20	27	12
14	Bleiburg	15	29	40	12
15	St. Michael	15	19	33	12
16	Maria Saal	15	14	42	7

TEMPORADA 2019/2020

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	ASKÖ Gmünd	16	30	14	33
2	St. Jakob	16	33	20	32
3	Treibach	16	33	23	30
4	Ferlach	16	25	19	27
5	Lendorf	16	29	21	25
6	Bleiburg	16	23	21	25
7	St. Michael	16	27	29	25
8	Maria Saal	16	31	24	22
9	Dellach	16	38	34	22
10	Spittal	16	28	28	21
11	Völkermarkt	16	21	23	21
12	Feldkirchen	16	24	32	18
13	KAC	16	18	27	17
14	Köttmannsdo	16	12	19	12
15	Kraig	16	16	37	11
16	Klagenfurt	16	17	34	10

TEMPORADA 2018/2019

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	ATSV	30	67	28	64
2	Treibach	30	96	41	63
3	Klagenfurt	30	46	41	53
4	Köttmannsdo	30	50	32	49
5	KAC	30	45	37	48
6	Maria Saal	30	65	50	47
7	Ferlach	30	57	49	47
8	ASKÖ Gmünd	30	42	49	47
9	Spittal	30	45	36	46
10	St. Jakob	30	45	61	37
11	Feldkirchen	30	40	44	34
12	Bleiburg	30	32	58	32
13	St. Michael	30	42	67	31
14	Matrei	30	47	63	27
15	ASKO	30	38	67	26
16	Lind	30	35	69	21

TEMPORADA 2017/2018

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lendorf	30	60	30	59
2	Völkermarkt	30	61	35	58
3	Klagenfurt	30	56	30	52
4	Maria Saal	30	58	53	48
5	Feldkirchen	30	56	43	47
6	Treibach	30	55	39	43
7	ATSV	30	49	40	43
8	Bleiburg	30	37	48	42
9	Spittal	30	38	42	40
10	Ferlach	30	35	35	38
11	St. Jakob	30	42	43	38
12	Köttmannsdo	30	38	40	36
13	KAC	30	45	43	34
14	ASKÖ Gmünd	30	34	58	34
15	Kraig	30	32	67	30
16	Annabichler	30	27	77	21

TEMPORADA 2016/2017

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Wolfsberger	30	89	27	71
2	Klagenfurt	30	63	33	61
3	Ferlach	30	77	45	59
4	Lendorf	30	62	47	55
5	Maria Saal	30	57	53	48
6	Treibach	30	54	53	44
7	Völkermarkt	30	44	47	44
8	Köttmannsdo	30	42	35	42
9	Feldkirchen	30	47	54	38
10	Spittal	30	55	55	37
11	Annabichler	30	41	53	36
12	Bleiburg	30	46	59	34
13	ASKÖ Gmünd	30	36	66	33
14	Lind	30	34	54	28
15	Dolomit	30	28	59	23
16	Rapid Lienz	30	25	60	20

TEMPORADA 2015/2016

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ferlach	30	81	41	68
2	ATSV	30	77	30	65
3	Klagenfurt	30	65	38	52
4	Treibach	30	53	46	46
5	Lendorf	30	50	54	45
6	ASKÖ Gmünd	30	46	44	44
7	Feldkirchen	30	49	55	44
8	Völkermarkt	30	40	38	43
9	Bleiburg	30	41	43	41
10	Köttmannsdo	30	36	36	40
11	Spittal	30	52	53	38
12	Rapid Lienz	30	36	48	35
13	Maria Saal	30	41	56	32
14	Kühnsdorf	30	30	47	29
15	Globasnitz	30	38	75	27
16	St. Michael	30	26	57	16

TEMPORADA 2014/2015

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Annabichler	30	77	34	69
2	Völkermarkt	30	61	28	65
3	Köttmannsdo	30	63	33	61
4	Ferlach	30	65	43	51
5	ASKÖ Gmünd	30	56	48	49
6	Treibach	30	58	53	44
7	Feldkirchen	30	60	43	41
8	Maria Saal	30	50	51	41
9	St. Michael	30	45	48	41
10	Lendorf	30	62	57	37
11	Bleiburg	30	40	50	36
12	Kühnsdorf	30	48	52	35
13	Spittal	30	46	62	31
14	Blau Weiss.	30	55	72	27
15	Veit Glan	30	45	71	26
16	SV Villach	30	28	114	14

TEMPORADA 2013/2014

CUARTA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	ATSV	30	58	20	65
2	Feldkirchen	30	66	32	58
3	Lendorf	30	58	39	56
4	Völkermarkt	30	50	31	53
5	Bleiburg	30	60	38	50
6	Treibach	30	51	40	48
7	Annabichler	30	54	48	46
8	Köttmannsdo	30	46	42	44
9	Maria Saal	30	57	57	42
10	ASKÖ Gmünd	30	43	48	41
11	Ferlach	30	48	47	40
12	Veit Glan	30	38	64	33
13	Spittal	30	61	72	31
14	Drautal	30	36	50	27
15	Steinfeld	30	44	91	19
16	Landskron	30	39	90	19

TEMPORADA 2012/2013

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	LASK	28	75	15	68
2	SV Pasching	28	64	19	66
3	Klagenfurt	28	54	48	47
4	Kalsdorf	28	62	48	43
5	SV Villach	28	46	40	43
6	Union	28	34	37	37
7	Allerheilige	28	46	52	36
8	Austria	28	40	48	35
9	Gratkorn	28	50	53	34
10	SV Wallern	28	24	31	34
11	Vöcklamarkt	28	38	46	33
12	Sturm Graz	28	36	47	32
13	Kapfenberger	28	27	50	27
14	Feldkirchen	28	36	69	23
15	Leoben	28	32	61	19
16	Grazer AK	0	0	0	0

TEMPORADA 2011/2012

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Feldkirchen	30	62	32	60
2	Veit Glan	30	57	35	59
3	Drautal	30	50	31	59
4	Lendorf	30	65	47	55
5	Spittal	30	61	36	50
6	ATSV	30	60	48	44
7	Treibach	30	57	54	43
8	Völkermarkt	30	43	36	41
9	Rapid Lienz	30	41	44	40
10	Sankt Andrä	30	39	43	37
11	Raiba Ruden	30	57	72	36
12	Maria Saal	30	42	58	36
13	Ferlach	30	47	60	33
14	Bleiburg	30	38	52	31
15	Hermagor	30	33	63	21
16	Eberndorfer	30	33	74	15

TEMPORADA 2010/2011

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	LASK Juniors	30	55	37	58
2	Blau-Weiß	30	55	27	57
3	Grazer AK	30	59	37	54
4	Allerheilige	30	45	29	52
5	Union	30	43	37	45
6	SV Pasching	30	38	33	45
7	Austria	30	42	37	43
8	Gleinstätte	30	49	49	41
9	Vöcklamarkt	30	45	45	38
10	Klagenfurt	30	38	40	38
11	Leoben	30	47	51	37
12	Sturm Graz	30	48	61	34
13	Wels	30	21	42	33
14	Feldkirchen	30	36	55	27
15	Weiz	30	34	53	26
16	Voitsberg	30	30	52	21

TEMPORADA 2009/2010

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Feldkirchen	30	49	29	58
2	Lendorf	30	54	32	56
3	Treibach	30	53	27	55
4	Bleiburg	30	69	40	51
5	SV Villach	30	54	39	51
6	ATSV	30	43	48	49
7	Rapid Lienz	30	48	42	47
8	Austria	30	47	44	44
9	Völkermarkt	30	53	48	43
10	Sankt Andrä	30	53	49	43
11	Maria	30	29	26	40
12	Welzenegg	30	28	49	32
13	Spittal	30	52	64	30
14	St. Michael	30	33	57	29
15	Penk	30	33	56	25
16	Sittersdorf	30	39	87	17

TEMPORADA 2008/2009

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hartberg	30	63	25	64
2	Grazer AK	30	68	32	64
3	Sturm Graz	30	52	32	56
4	Voitsberg	30	65	37	54
5	Sankt Andrä	30	41	30	54
6	Wels	30	62	51	47
7	Blau-Weiß	30	50	35	43
8	Union	30	49	41	40
9	Klagenfurt	30	46	46	38
10	Allerheilige	30	38	38	38
11	Weiz	30	48	52	34
12	Veit Glan	30	43	62	30
13	Bad Aussee	30	29	66	28
14	Feldkirchen	30	39	66	27
15	FC Kärnten	30	22	70	23
16	Spittal	30	31	63	19

TEMPORADA 2007/2008

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vöcklabruck	30	70	23	68
2	Feldkirchen	30	66	45	52
3	Grazer AK	30	57	37	52
4	Sankt Andrä	30	41	26	52
5	Sturm Graz	30	52	40	52
6	Allerheilige	30	40	35	52
7	Hartberg	30	45	38	44
8	Wels	30	57	46	43
9	Klagenfurt	30	44	43	41
10	Union	30	44	45	38
11	Austria	30	40	52	38
12	Weiz	30	45	47	35
13	Spittal	30	34	42	30
14	Gmunden	30	33	69	26
15	Grieskirchen	30	30	55	22
16	Bleiburg	30	19	74	10

TEMPORADA 2006/2007

TERCERA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bad Aussee	30	62	31	57
2	Wels	30	58	34	56
3	Feldkirchen	30	51	35	53
4	Sankt Andrä	30	43	30	51
5	Vöcklabruck	30	41	28	47
6	Spittal	30	37	43	45
7	Klagenfurt	30	45	46	44
8	Allerheilige	30	40	32	43
9	Sturm Graz	30	42	45	37
10	Union	30	35	50	35
11	Grieskirchen	30	33	38	34
12	Kärnten	30	35	46	34
13	Voitsberg	30	44	48	33
14	Blau-Weiß	30	33	38	33
15	Köflach	30	29	59	30
16	Union Perg	30	28	53	26

TEMPORADA 2005/2006

TERCERA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hartberg	30	54	28	63
2	Spittal	30	48	35	54
3	Feldkirchen	30	43	38	53
4	Voitsberg	30	44	38	48
5	Sankt Andrä	30	49	33	45
6	Union	30	45	33	44
7	Köflach	30	46	42	43
8	Wels	30	41	40	40
9	Klagenfurt	30	39	55	39
10	Bad Aussee	30	38	34	37
11	Sturm Graz	30	52	46	35
12	Blau-Weiß	30	32	42	34
13	Superfund	30	36	42	31
14	Vöcklabruck	30	37	49	31
15	Union Perg	30	27	43	31
16	Bleiburg	30	30	63	24

TEMPORADA 2004/2005

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Schwanenstad	30	43	26	62
2	Hartberg	30	55	33	50
3	Spittal	30	56	43	48
4	Superfund	30	57	41	47
5	Köflach	30	42	32	47
6	Sturm Graz	30	49	46	44
7	Union	30	36	30	43
8	Bleiburg	30	37	52	40
9	Feldkirchen	30	46	55	38
10	Blau-Weiß	30	33	32	37
11	Sankt Andrä	30	36	41	37
12	Voitsberg	30	39	42	35
13	Wels	30	34	42	35
14	Union Perg	30	31	45	34
15	Kärnten	30	30	41	31
16	Kalsdorf	30	32	55	21

TEMPORADA 2002/2003

TERCERA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Wacker	30	101	17	80
2	SCR Altach	30	108	40	68
3	SV Hall	30	52	39	56
4	Kufstein	30	71	45	52
5	Schärding	30	69	52	45
6	Juniors	30	64	56	45
7	Reichenau	30	48	48	44
8	Puch	30	53	42	41
9	Seekirchen	30	53	63	35
10	Feldkirchen	30	52	59	34
11	Salzburg	30	41	55	34
12	Salzburger	30	22	46	30
13	Rot-Weiß	30	41	69	29
14	Hohenems	30	47	83	28
15	Kundl	30	43	93	23
16	SK Rum	30	34	92	21

Comparar equipos

Feldkirchen

Selecciona un equipo

Competiciones que juega

USO DE MEMORIA

7,330,648 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1253
Total Execution Time	0.1265

CADENA URL

/historico/Feldkirchen

GET DATOS

$_GET['/historico/Feldkirchen']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0028	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 = 'Feldkirchen' 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.0019	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=18110 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=18110 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=18110 AND type_rel = 2
0.0025	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 = '18110' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '18110' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = '18110' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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=18110 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 (71432,68325) 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 = 68325 AND teamId = 18110
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18110
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 = '18110' 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 = '18110' 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 = '18110' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023	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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 18110 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.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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 18110 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 18110 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 18110 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* `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 = 68325 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.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* `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 = 63463 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* `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 = 57777 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.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* `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 = 50447 AND t.round = 16 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 = 44305 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* `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 = 38907 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 = 38903 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* `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 = 15764 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* `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 = 3935 AND t.round = 30 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* `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 = 27162 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* `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 = 24526 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* `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 = 27189 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* `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 = 24532 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* `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 = 27226 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* `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 = 24538 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* `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 = 27600 AND t.round = 30 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* `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 = 27592 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* `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 = 27576 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* `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 = 44524 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC