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

Pirin Razlog

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Minyor	32	66	21	84
2	CSKA Sofia	31	56	26	70
3	Vihren	32	55	39	57
4	Botev	32	58	43	55
5	Slivnishki	32	45	36	51
6	Balkan	31	52	49	45
7	Kyustendil	32	50	41	44
8	Levski Sofia	31	50	45	43
9	Rilski	32	45	53	42
10	Vitosha	32	25	27	41
11	Chavdar	32	46	56	41
12	Kostinbrod	32	36	52	39
13	Septemvri	32	41	44	38
14	Bansko	32	37	44	38
15	CSKA 1948 S.	32	42	45	37
16	Septemvri	32	41	41	37
17	Slavia Sofia	31	40	54	34
18	Oborishte	32	39	67	34
19	Pirin Razlog	32	24	49	30
20	Hebar II	32	29	45	30

TEMPORADA 2022/2023

TERCERA BULGARIA V AFG GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Oborishte	12	19	12	41
2	Levski Sofia	12	28	17	40
3	CSKA 1948 S.	12	17	7	38
4	Septemvri	12	22	14	37
5	Rilski	12	11	20	36
6	Botev	12	18	15	34
7	Slavia Sofia	12	27	31	33
8	Pirin Razlog	12	14	15	31
9	Levski	12	11	13	27
10	Nadezhda	12	16	19	23
11	Pirin Gotse	12	12	18	21
12	Granit	12	10	24	13

TEMPORADA 2021/2022

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Belasitsa	38	90	26	88
2	Vitosha	38	81	25	81
3	Chavdar	38	70	20	80
4	Kyustendil	38	75	26	80
5	Oborishte	38	69	51	74
6	Balkan	38	62	38	71
7	Bansko	38	56	36	68
8	Pirin Gotse	38	48	51	51
9	Granit	38	40	60	48
10	Rilski	38	56	64	48
11	Pirin Razlog	38	49	50	47
12	Nadezhda	38	50	62	46
13	Kostinbrod	38	44	53	46
14	Septemvri	38	64	77	45
15	Slivnishki	38	44	47	44
16	Botev	38	40	55	43
17	Vihren	38	58	70	43
18	Hebar II	38	43	56	41
19	Pirin	38	24	82	17
20	Levski	38	17	131	3

TEMPORADA 2020/2021

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Marek	34	84	24	82
2	Kyustendil	34	63	14	82
3	Belasitsa	34	68	27	78
4	Vihren	34	63	25	75
5	Oborishte	34	55	41	60
6	Balkan	34	62	34	58
7	Chavdar	34	62	46	51
8	Botev	34	53	41	46
9	Pirin Gotse	34	37	32	45
10	Pirin Razlog	34	40	59	41
11	Slivnishki	34	38	44	36
12	Nadezhda	34	40	56	36
13	Rilski	34	30	45	34
14	Bansko	34	28	47	34
15	Levski	34	34	72	34
16	Granit	34	34	65	32
17	Perun	34	25	77	22
18	Velbazhd	34	16	83	16

TEMPORADA 2019/2020

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Minyor	18	34	6	42
2	Septemvri	17	31	11	41
3	Sportist	18	31	21	37
4	Vihren	18	29	14	37
5	Oborishte	18	30	10	34
6	Kyustendil	18	27	17	32
7	Slivnishki	18	27	22	27
8	Bansko	17	26	18	26
9	Chavdar	18	30	26	23
10	Belasitsa	18	21	26	22
11	Botev	18	14	24	22
12	Nadezhda	18	28	35	18
13	Pirin Razlog	18	12	22	17
14	Marek	18	19	39	16
15	Balkan	18	16	33	15
16	Rilski	18	13	33	11
17	Perun	18	9	40	7

TEMPORADA 2018/2019

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hebar	34	73	19	90
2	Oborishte	34	60	27	75
3	Vihren	34	52	35	62
4	Slivnishki	34	60	35	58
5	Minyor	34	57	37	58
6	Bansko	34	56	37	57
7	Pirin Razlog	34	47	35	51
8	Rilski	34	47	42	49
9	Belasitsa	34	43	37	46
10	Marek	34	35	37	41
11	Chavdar	34	54	47	40
12	Septemvri	34	34	36	40
13	Balkan	34	41	57	38
14	Sportist	34	45	61	37
15	Nadezhda	34	40	61	37
16	Botev	34	35	75	32
17	Germaneya	34	36	70	30
18	Velbazhd	34	22	89	8

TEMPORADA 2017/2018

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CSKA 1948 S.	34	95	16	92
2	Hebar	34	72	24	84
3	Vihren	34	70	49	62
4	Minyor	34	53	42	54
5	Bansko	34	48	34	53
6	Chavdar	34	63	49	52
7	Septemvri	34	46	37	50
8	Slivnishki	34	50	41	46
9	Belasitsa	34	40	46	42
10	Balkan	34	49	60	41
11	Botev	34	41	64	40
12	Pirin Razlog	34	40	40	38
13	Svoboda	34	37	59	38
14	Marek	34	35	48	37
15	Rilski	34	40	51	36
16	Germaneya	34	38	63	35
17	Pirin Gotse	34	27	66	32
18	Elin Pelin	34	34	89	21

TEMPORADA 2016/2017

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Strumska	34	76	20	78
2	Septemvri	34	62	28	72
3	Minyor	34	58	37	68
4	Slivnishki	34	69	39	59
5	Belasitsa	34	52	34	59
6	Hebar	34	68	41	58
7	Chavdar	34	60	46	53
8	Marek	34	51	50	52
9	Rilski	34	53	61	43
10	Pirin Gotse	34	45	41	42
11	Pirin Razlog	34	36	55	41
12	Balkan	34	54	55	40
13	Germaneya	34	52	52	38
14	Botev	34	49	72	38
15	Svoboda	34	36	75	37
16	Vihren	34	36	46	37
17	Velbazhd	34	44	63	32
18	Chepinets	34	33	119	18

TEMPORADA 2015/2016

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Dunav Ruse	30	53	19	64
2	Pomorie	30	36	23	54
3	Gorna	30	42	26	50
4	Sozopol	30	44	28	49
5	Lovech II	30	50	38	49
6	Botev	30	32	47	41
7	Ludogorets	30	41	41	41
8	Vereya	30	33	27	40
9	Bansko	30	42	38	39
10	Oborishte	30	29	33	39
11	Pirin Razlog	30	31	41	38
12	Neftochimik	30	31	39	38
13	Spartak	30	35	42	36
14	Dobrudzha	30	27	33	34
15	Septemvri	30	26	50	23
16	Lokomotiv	30	28	55	20

TEMPORADA 2014/2015

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Montana	30	72	16	78
2	Pirin	30	52	15	61
3	Gorna	30	60	34	59
4	Bansko	30	38	18	53
5	Sozopol	30	39	25	46
6	Dobrudzha	30	41	28	46
7	Master	30	34	30	43
8	Botev	30	35	40	42
9	Lokomotiv	30	43	41	41
10	Pirin Razlog	30	33	38	40
11	Vereya	30	25	24	37
12	Septemvri	30	30	47	36
13	Botev Vratsa	30	26	43	29
14	Chernomoretz	30	25	40	28
15	Rakovski	29	25	71	19
16	Spartak	29	9	77	6

TEMPORADA 2013/2014

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Marek	26	40	17	54
2	Haskovo 2009	26	35	20	46
3	Dobrudzha	26	33	20	46
4	Montana	26	36	24	44
5	Bansko	26	40	24	42
6	Botev Vratsa	26	32	23	38
7	Pirin Razlog	26	30	43	36
8	Spartak	26	24	29	34
9	Rakovski	26	28	35	32
10	Vitosha	26	22	24	28
11	Kaliakra	26	23	34	28
12	Botev	26	20	31	28
13	Dunav Ruse	26	24	32	27
14	Akademik	26	12	43	15

TEMPORADA 2012/2013

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Neftochimik	26	49	22	54
2	Lyubimets	26	44	28	51
3	Rakovski	26	38	28	48
4	Svetkavitsa	26	34	20	47
5	Bansko	26	48	26	46
6	Spartak 1919	26	33	25	42
7	Spartak	26	26	19	38
8	Chavdar	26	31	32	37
9	Kaliakra	26	33	31	34
10	Pirin Razlog	26	33	28	33
11	Vidima-Rakov	26	33	31	29
12	Shumen 2010	26	32	52	29
13	Septemvri	26	18	39	15
14	Sliven 2000	26	4	75	0

TEMPORADA 2011/2012

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Pirin Razlog	36	93	20	93
2	Perun	36	83	20	89
3	Rilski	36	66	29	68
4	Oborishte	36	76	35	67
5	Marek	36	62	31	63
6	Vitosha	36	53	36	61
7	Velbazhd	36	57	54	57
8	Germaneya	36	50	51	52
9	Chepinets	36	68	50	49
10	Belasitsa	36	54	47	48
11	Mesta	36	51	51	46
12	Kostinbrod	36	42	50	46
13	Septemvri	36	38	49	44
14	Hebar 2011	71	61	218	43
15	Minyor Bobov	36	45	62	42
16	Vitosha	36	48	68	42
17	Strumska	36	44	63	36
18	Levski Elin	35	28	85	20
19	Balkan	0	0	0	0

TEMPORADA 2010/2011

TERCERA BULGARIA V AFG GRUPO 1
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

TEMPORADA 2009/2010

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Malesh	36	96	27	91
2	Minyor Bobov	36	60	15	78
3	Slivnishki	36	79	34	75
4	Pirin Razlog	36	59	25	68
5	Benkovski	36	53	38	59
6	Vitosha	36	49	50	55
7	Perun	36	46	44	53
8	Strumska	36	55	43	51
9	Germaneya	36	37	47	45
10	Belasitsa	36	40	51	45
11	Mesta	36	55	67	42
12	Vitosha	36	39	61	42
13	Botev	36	42	77	39
14	Chepinets	36	62	88	37
15	Levski Elin	36	52	72	36
16	Kostinbrod	36	45	67	36
17	Hebar	36	50	75	36
18	Velbazhd	36	44	61	35
19	Novi Iskar	36	30	51	35

TEMPORADA 2008/2009

TERCERA BULGARIA V AFG GRUPO 1
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

Competiciones que juega

Grupo 2

Tercera Bulgaria V AFG Grupo 2

Pos	Equipos		Pts
1		FK Minyor Pernik	84
2		CSKA Sofia II	70
3		Vihren	57
4		Botev Ihtiman	55
5		Slivnishki Geroy	51
6		Balkan Botevgrad	45
7		Kyustendil	44
8		Levski Sofia II	43
9		Rilski Sportist	42
10		Vitosha Bistritsa	41
11		Chavdar Etropole	41
12		Kostinbrod	39
13		Septemvri Simitli	38
14		Bansko	38
15		CSKA 1948 Sofia III	37
16		Septemvri Sofia II	37
17		Slavia Sofia II	34
18		Oborishte	34
19		Pirin Razlog	30
20		Hebar II	30

	Ascenso : FK Minyor Pernik
	Descenso : Pirin Razlog, Hebar II

RIVALES EN Tercera Bulgaria.

USO DE MEMORIA

7,075,096 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.7795
Total Execution Time	0.7808

CADENA URL

/historico/Pirin-Razlog

GET DATOS

$_GET['/historico/Pirin-Razlog']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0159	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 = 'Pirin-Razlog' 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.0146	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=9956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	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=9956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=9956 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9956 AND type_rel = 2
0.0146	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=238 AND type_rel = 3
0.0153	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.0149	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.0151	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 = '9956' ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '9956' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152	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 = '9956' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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=9956 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (73001,71432) 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.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 73001 AND teamId = 9956
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9956
0.0147	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 = '9956' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9956' and rp.type = 4
0.0146	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 = '9956' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146	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 = 73001 WHERE rp.league_id = 73001 AND rp.teamId = 9956 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.0146	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 = 73001 WHERE rp.league_id = 73001 AND rp.teamId = 9956 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147	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 = 73001 WHERE rp.league_id = 73001 AND rp.teamId = 9956 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 = 9956 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0292	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 = 73001 AND t.round = 32 ORDER BY team.conference ASC,t.position 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* `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 = 68508 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 71264 AND t.round = 12 ORDER BY team.conference ASC,t.position 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* `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 = 63580 AND t.round = 38 ORDER BY team.conference ASC,t.position 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* `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 = 57814 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.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* `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 = 51127 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.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* `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 = 44690 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* `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 = 39352 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* `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 = 34149 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* `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 = 15730 AND t.round = 30 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* `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 = 4440 AND t.round = 30 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* `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 = 2454 AND t.round = 26 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* `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 = 2029 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0595	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 = 24584 AND t.round = 38 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* `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.0175	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 = 24624 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* `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

Pirin Razlog

Pirin Razlog

Selecciona un equipo

Competiciones que juega

Tercera Bulgaria V AFG Grupo 2

RIVALES EN Tercera Bulgaria.