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

« Temporada Anterior

Temporada 2022

Temporada Siguiente »

2021/2022

Noroeste

Eliminatoria

Tercera Bulgaria V AFG 2022 G 1

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Spartak	32	89	19	81
2	FC Sevlievo	32	64	22	73
3	Gorna	32	70	31	69
4	Bdin	32	65	26	59
5	Vihar	32	56	31	59
6	Yantra	32	47	41	52
7	Partizan	32	49	50	52
8	Pavlikeni	32	48	33	51
9	OFK Levski	32	41	47	40
10	Botev Vratsa	32	30	47	36
11	Drenovets	32	39	66	35
12	Akademik	32	43	56	33
13	Lokomotiv	32	35	47	32
14	Juventus	32	30	64	28
15	Lokomotiv	32	33	63	27
16	Etar II	32	46	90	24
17	Peshtera	32	26	78	23

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Zagorets	34	87	22	83
2	Maritsa	34	79	26	83
3	Chernomorets	34	78	22	81
4	Rozova	34	66	47	62
5	Gigant	34	53	30	56
6	Atletik	34	41	35	52
7	Dimitrovgrad	34	38	40	47
8	Levski	34	47	55	47
9	Rodopa	34	58	43	46
10	Izvor Gorski	34	43	35	45
11	Borislav	34	50	45	43
12	Haskovo 1957	34	31	41	40
13	Sokol	34	44	69	38
14	Karnobat	34	35	58	37
15	Yambol 1915	34	29	52	33
16	Nesebar	34	41	68	33
17	Spartak	34	35	58	30
18	Vereya	34	22	131	3

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Sozopol	19	36	8	45
2	Zagorets	19	52	15	43
3	Maritsa	19	43	15	41
4	Chernomorets	19	30	19	36
5	Gigant	19	27	19	34
6	Minyor	19	26	13	30
7	Rozova	19	38	30	30
8	Svilengrad	19	27	19	30
9	Nesebar	19	22	25	26
10	Borislav	19	28	33	23
11	Haskovo 1957	19	23	29	22
12	Levski	19	18	22	21
13	Rodopa	19	23	33	21
14	Atletik	19	19	30	20
15	Yambol 1915	19	17	38	16
16	Sokol	19	18	47	15
17	Karnobat	19	17	33	14
18	Dimitrovgrad	19	13	49	12

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Neftochimik	34	88	21	90
2	Sozopol	34	74	27	85
3	Zagorets	34	81	22	77
4	Chernomorets	34	76	35	68
5	Maritsa	34	44	29	58
6	Minyor	34	46	30	56
7	Haskovo 1957	34	54	47	50
8	Rozova	34	58	50	48
9	Atletik	34	48	46	46
10	Sokol	34	46	58	42
11	Gigant	34	32	36	41
12	Borislav	34	44	47	39
13	Karnobat	34	41	67	37
14	Levski	34	25	52	36
15	Dimitrovgrad	34	30	54	31
16	Svilengrad	34	30	69	29
17	Sadovo	34	18	90	19
18	Asenovets	34	36	91	14

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Arda	34	142	7	94
2	Zagorets	34	67	27	71
3	Minyor	34	63	34	59
4	Rozova	34	64	41	57
5	Atletik	34	55	51	56
6	Sokol	34	63	49	53
7	Karnobat	34	65	50	52
8	Levski	34	51	58	51
9	Borislav	34	65	62	50
10	Asenovets	34	53	55	49
11	Dimitrovgrad	34	46	62	48
12	Gigant	34	33	53	43
13	Svilengrad	34	52	89	43
14	Evrokolezh	34	63	71	42
15	Yambol 1915	34	62	59	38
16	Rakovski	34	44	65	35
17	Vereya II	34	45	88	33
18	Tundzha	34	15	127	2

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Chernomorets	22	49	7	60
2	Dobrudzha	22	55	8	55
3	Suvorovo	22	42	20	39
4	Kaliakra	22	33	24	36
5	Botev Novi.	22	21	38	34
6	Septemvri	22	21	25	28
7	Lokomotiv	22	28	24	27
8	Svetkavitsa	22	15	28	23
9	Kubrat	22	21	39	22
10	Hitrino	22	18	32	20
11	Dorostol	22	15	43	15
12	Spartak	22	21	51	13
13	Inter	0	0	0	0

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Nesebar	34	88	20	90
2	Rozova	34	81	30	76
3	Zagorets	33	64	20	72
4	Uragan	34	93	45	64
5	Dimitrovgrad	34	62	38	62
6	Gigant	34	67	58	58
7	Svilengrad	33	72	53	56
8	Asenovets	34	57	46	53
9	Maritsa	34	45	29	51
10	Evrokolezh	34	69	74	46
11	Karnobat	34	56	56	43
12	Spartak	34	36	38	42
13	Levski	34	43	75	35
14	Rakovski	34	45	68	34
15	Borislav	34	34	59	29
16	Minyor	34	32	84	27
17	Chernomoretz	34	42	101	22
18	Sliven	34	20	112	10

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Pomorie	30	66	16	73
2	Gigant	30	63	25	61
3	Dimitrovgrad	30	51	23	58
4	Rozova	30	47	30	51
5	Minyor	30	48	38	50
6	Evrokolezh	30	43	33	50
7	Asenovets	30	58	35	46
8	Zagorets	30	50	31	46
9	Svilengrad	30	50	39	45
10	Nesebar	30	47	36	43
11	Maritsa	30	38	53	39
12	Tundzha	30	34	45	35
13	Spartak	30	27	49	32
14	Levski	30	23	48	28
15	Sliven 2000	30	26	95	15
16	Stara Zagora	30	17	92	4
17	Elhovo	0	0	0	0
18	Rodopa	0	0	0	0

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Sozopol	30	99	24	75
2	Master	30	86	21	74
3	Vereya	29	94	25	66
4	Spartak	30	64	20	64
5	Asenovets	31	65	32	60
6	Nesebar	30	68	39	56
7	Gigant	30	55	31	54
8	Minyor	30	52	48	46
9	Svilengrad	31	51	50	40
10	Evrokolezh	29	40	42	38
11	Zagorets	30	33	51	34
12	Dimitrovgrad	31	39	49	29
13	Rozova	30	33	46	29
14	Levski	31	41	77	28
15	Tundzha	30	19	65	24
16	Sliven 2000	30	28	162	9
17	Straldzha	30	23	102	8
18	Brestnik	2	0	6	0

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Botev	34	56	17	73
2	Haskovo 2009	34	62	25	69
3	Master	34	53	25	67
4	Svilengrad	34	62	34	63
5	Vereya	34	47	29	60
6	Nesebar	34	58	31	58
7	Asenovets	34	58	45	55
8	Spartak	34	45	37	52
9	Sozopol	34	51	32	51
10	Tundzha	34	60	56	50
11	Levski	34	52	53	50
12	Gigant	34	42	39	45
13	Rozova	34	34	51	42
14	Dimitrovgrad	34	36	47	41
15	Zagorets	34	30	41	38
16	Brestnik	34	35	92	27
17	Hebros	34	20	76	16
18	Arda	34	10	81	9

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Rakovski	34	91	30	75
2	Tundzha	34	71	24	75
3	Botev	34	57	23	66
4	Svilengrad	34	68	29	65
5	Asenovets	34	59	54	63
6	Master	34	45	34	59
7	Dimitrovgrad	34	64	47	58
8	Sozopol	34	54	31	56
9	Brestnik	34	60	45	50
10	Zagorets	34	42	40	46
11	Arda	34	42	49	44
12	Spartak	34	51	57	37
13	Gigant	34	45	64	36
14	Levski	34	32	64	34
15	Rozova	34	38	60	32
16	Hebros	34	43	58	30
17	Sportist	34	21	98	18
18	Chirpan	34	13	89	15
19	Rodopa	0	0	0	0
20	Tundzha	0	0	0	0

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Slivnishki	38	108	24	93
2	Pirin Razlog	38	89	28	85
3	Vitosha	38	70	24	85
4	Perun	38	89	31	79
5	Mesta	38	71	38	69
6	Kostinbrod	38	82	47	61
7	Lokomotiv	38	75	55	59
8	Balkan	38	61	51	56
9	Septemvri	38	59	54	56
10	Velbazhd	38	73	59	54
11	Minyor Bobov	38	62	58	54
12	Vitosha	38	58	53	53
13	Benkovski	38	57	57	48
14	Strumska	38	57	78	47
15	Chepinets	38	49	75	42
16	Germaneya	38	39	58	39
17	Levski Elin	38	52	100	36
18	Hebar	38	54	93	32
19	Botev	37	20	133	16
20	Avangard	37	37	146	14

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Dorostol	34	81	23	82
2	Ludogorets	34	79	28	80
3	Chernolomets	34	66	38	59
4	Septemvri	34	47	30	59
5	Dve Mogili	34	61	32	57
6	Chernomorets	34	62	35	57
7	Rapid	34	65	41	57
8	Shabla	34	65	56	57
9	Benkovski	34	82	57	55
10	Suvorovo	34	59	52	47
11	Skrita Sila	34	57	62	45
12	Veliki	34	49	57	38
13	Sportist	34	42	61	37
14	Topoli	34	50	77	36
15	Botev Novi.	34	34	66	36
16	Kubrat	34	43	81	33
17	Aksakovo	34	35	86	33
18	Endzhe	34	9	104	10

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Septemvri	38	75	28	90
2	Malesh	38	83	30	88
3	Minyor Bobov	38	83	32	86
4	Levski Elin	38	70	44	66
5	Hebar	38	55	42	66
6	Bansko 1951	38	60	30	62
7	Strumska	38	64	43	57
8	Vitosha	38	58	52	53
9	Mesta	38	57	63	48
10	Germaneya	38	40	62	48
11	Slivnishki	38	40	48	47
12	Velbazhd	38	49	48	46
13	Velbazhd	38	40	56	44
14	Minyor 1919	38	49	59	43
15	Pirin Razlog	38	49	63	42
16	Chepinets	38	42	70	41
17	Pirin 2001.	38	38	57	40
18	Botev	38	41	78	39
19	Ljulin Sofia	38	44	71	36
20	Levski Dolna	38	32	93	29

Equipos de esta liga

USO DE MEMORIA

6,911,744 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.6221
Total Execution Time	0.6240

CADENA URL

/v_afg_bulgaria2022/grupo1/historico

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0147	SELECT type FROM routes WHERE alias = 'v_afg_bulgaria2022'
0.0295	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'v_afg_bulgaria' 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.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=238 AND type_rel = 3
0.0148	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 238 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0155	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (77796,59747,55420,15539) ORDER BY n.cover_points DESC, update_date DESC
0.0149	SELECT id,name,alias,stepParent FROM categories WHERE parentId=238 ORDER BY order_id ASC
0.0156	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 = 63578 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0163	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 238 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0165	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 = 63578 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.0172	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 = 57215 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.0164	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 = 50571 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166	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 = 44689 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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 = 39348 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162	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 = 34146 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162	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 = 15842 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 4371 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 3578 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 24555 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 24576 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 24587 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 24600 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 24626 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 08:11:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 08:11:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 08:11:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0153	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 08:11:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0165	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'v_afg_bulgaria' 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.0160	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 = 63578 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63578 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.0157	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 = 63578 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63578 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0159	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 = 63578 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63578 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0206	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 = 63578 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


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