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

Septemvri Simitli

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

TERCERA BULGARIA V AFG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Marek	10	14	6	43
2	Vihren	10	19	9	33
3	Kyustendil	10	12	12	29
4	Chavdar	10	11	12	28
5	Bansko	9	11	12	21
6	CSKA Sofia	9	15	15	19
7	Slivnishki	10	12	13	19
8	Balkan	10	19	21	19
9	Kostinbrod	10	9	17	18
10	Septemvri	10	9	14	17

TEMPORADA 2021/2022

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Septemvri	36	77	35	70
2	Spartak	36	64	39	70
3	Hebar	36	54	33	70
4	Etar	36	69	42	68
5	Minyor	36	50	35	63
6	Ludogorets	36	70	48	61
7	Montana	36	39	31	58
8	Strumska	36	40	37	54
9	Maritsa	36	51	48	50
10	Sportist	36	38	46	48
11	CSKA 1948 S.	36	53	50	45
12	Dobrudzha	36	39	45	45
13	Litex Lovech	36	41	42	45
14	Yantra	36	30	46	40
15	Sozopol	36	40	56	39
16	Botev	36	34	47	38
17	Marek	36	29	46	36
18	Septemvri	36	41	68	33
19	Levski 2020	36	12	77	8
20	Neftochimik	0	0	0	0

TEMPORADA 2020/2021

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Pirin	29	63	26	62
2	Lokomotiv	30	65	30	62
3	Septemvri	29	51	29	53
4	Ludogorets	30	56	38	50
5	Sportist	30	43	36	49
6	Hebar	30	50	36	48
7	Sozopol	30	35	40	39
8	Litex Lovech	29	33	31	36
9	Minyor	29	27	37	36
10	Strumska	30	31	37	34
11	Yantra	30	30	47	34
12	Septemvri	30	34	42	33
13	Kariana	25	29	44	31
14	Dobrudzha	29	25	46	27
15	Neftochimik	30	27	61	27
16	Gorna	30	24	43	25
17	Vitosha	0	0	0	0

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

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Septemvri	15	24	7	35
2	Pirin	15	32	6	34
3	Slivnishki	15	32	9	33
4	Minyor	15	29	7	32
5	Oborishte	15	25	16	29
6	Vihren	15	17	17	22
7	Belasitsa	15	19	15	20
8	Velbazhd	15	19	21	20
9	Mesta	15	14	25	20
10	Balkan	15	18	20	19
11	Strumska	15	11	14	16
12	Sportist	15	15	21	15
13	Germaneya	15	11	19	15
14	Chepinets	15	17	27	14
15	Botev	15	10	30	9
16	Septemvri	15	9	48	6

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

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pirin Gotse	27	41	12	62
2	Sportist	27	44	23	56
3	Bdin	27	42	20	51
4	Bansko	27	36	24	40
5	Chavdar	27	36	33	39
6	Septemvri	27	35	33	34
7	Akademik	27	25	33	31
8	Slivnishki	27	28	48	25
9	Malesh	27	19	38	22
10	Chavdar	27	14	56	12

TEMPORADA 2010/2011

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Botev Vratsa	30	52	28	62
2	Sportist	30	36	15	52
3	Etar	30	33	19	51
4	Bansko	30	42	35	48
5	Chavdar	30	37	34	44
6	Septemvri	30	30	31	43
7	Vihren	30	37	32	42
8	Pirin Gotse	30	27	38	36
9	Chavdar	30	27	36	34
10	Malesh	30	22	37	32
11	Botev	30	25	63	17
12	Kom-Minyor	0	0	0	0

TEMPORADA 2009/2010

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vidima-Rakov	30	53	32	60
2	Bansko	30	50	22	59
3	Akademik	30	49	37	59
4	Vihren	30	45	24	56
5	Etar	30	47	38	47
6	Botev Vratsa	30	39	26	45
7	Septemvri	30	40	34	43
8	Chavdar	30	34	32	43
9	Balkan	30	35	28	41
10	Marek	30	36	36	41
11	Pirin Gotse	30	35	38	40
12	Kom-Minyor	30	36	43	38
13	Botev	30	21	40	31
14	Rilski	30	32	49	30
15	Bdin	30	26	48	20
16	Belite Orli	30	20	71	10

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	81
2		CSKA Sofia II	67
3		Vihren	54
4		Botev Ihtiman	52
5		Slivnishki Geroy	51
6		Balkan Botevgrad	45
7		Kyustendil	44
8		Rilski Sportist	42
9		Chavdar Etropole	41
10		Levski Sofia II	40
11		Vitosha Bistritsa	38
12		Kostinbrod	38
13		Bansko	38
14		Septemvri Sofia II	37
15		Septemvri Simitli	37
16		CSKA 1948 Sofia III	36
17		Slavia Sofia II	34
18		Oborishte	33
19		Pirin Razlog	27
20		Hebar II	27

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

RIVALES EN Tercera Bulgaria.

USO DE MEMORIA

6,882,584 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.5529
Total Execution Time	0.5547

CADENA URL

/historico/Septemvri-Simitli

GET DATOS

$_GET['/historico/Septemvri-Simitli']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0135	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 = 'Septemvri-Simitli' 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.0125	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=7485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=7485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=7485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7485 AND type_rel = 2
0.0131	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 = '7485' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133	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 = '7485' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0140	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=7485 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0134	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,68483) 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.0137	SELECT count(id) as num_players from rel_players WHERE league_id = 73001 AND teamId = 7485
0.0143	SELECT count(id) as num_players from rel_players WHERE league_id = 68483 AND teamId = 7485
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7485
0.0141	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 = 7485 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.0132	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 = 7485 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 7485 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 7485 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0256	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 = 31 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* `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.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* `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 = 71263 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 63160 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.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* `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 = 57213 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* `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.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* `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.0136	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.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* `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.0133	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.0132	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 = 3577 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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.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* `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 = 1738 AND t.round = 27 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* `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 = 14033 AND t.round = 33 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* `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 = 14032 AND t.round = 30 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* `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

Septemvri Simitli

Septemvri Simitli

Selecciona un equipo

Competiciones que juega

Tercera Bulgaria V AFG Grupo 2

RIVALES EN Tercera Bulgaria.