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

Spartak Plovdiv

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA BULGARIA V AFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Spartak	31	101	18	77
2	Sayana	31	77	23	75
3	Nesebar	31	93	36	74
4	Gigant	31	70	32	60
5	Dimitrovgrad	31	48	34	54
6	Zagorets	30	65	34	54
7	Rozova	31	58	36	53
8	Botev	29	62	39	47
9	Rodopa	31	57	45	46
10	Atletik	31	49	62	43
11	Asenovets	31	45	56	40
12	Sozopol	31	47	40	39
13	Lokomotiv	30	46	51	34
14	Karnobat	31	40	76	33
15	Levski	31	49	70	32
16	Yambol 1915	31	39	70	29
17	FK Sekirovo	31	39	69	26
18	Sokol	31	32	72	25
19	Beroe Stara	31	24	90	19
20	FK Sliven	31	29	117	17

TEMPORADA 2022/2023

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nesebar	38	84	32	83
2	Chernomorets	38	82	26	80
3	Gigant	38	69	28	78
4	Zagorets	38	64	19	76
5	Haskovo 2009	38	68	36	69
6	Rozova	38	66	29	68
7	Spartak	38	73	43	65
8	Lokomotiv	38	57	33	64
9	Asenovets	38	69	41	64
10	Yambol 1915	38	57	48	57
11	Rodopa	38	51	48	55
12	Dimitrovgrad	38	52	54	52
13	Sokol	38	54	58	48
14	Levski	38	45	69	42
15	Karnobat	38	37	57	41
16	Beroe Stara	38	45	74	37
17	FK Sliven	38	58	93	36
18	Atletik	38	37	83	36
19	Borislav	38	34	92	21
20	Vereya	38	24	163	6

TEMPORADA 2020/2021

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

TEMPORADA 2015/2016

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

TEMPORADA 2014/2015

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

TEMPORADA 2013/2014

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

TEMPORADA 2012/2013

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

TEMPORADA 2011/2012

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

TEMPORADA 2010/2011

SEGUNDA BULGARIA B PFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ludogorets	24	38	16	44
2	Spartak	24	26	17	36
3	Chernomorets	24	23	19	36
4	Svetkavitsa	24	24	23	33
5	Nesebar	24	20	22	32
6	Lyubimets	24	22	26	30
7	Dorostol	24	17	22	28
8	Brestnik	24	21	30	26
9	Dobrudzha	24	14	30	26
10	Chernomorets	0	0	0	0
11	Dunav Ruse	0	0	0	0
12	Ravda 1954	0	0	0	0

TEMPORADA 2009/2010

SEGUNDA BULGARIA B PFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Nesebar	28	56	24	57
2	Kaliakra	28	44	20	57
3	Dunav Ruse	28	48	29	54
4	Spartak	28	36	24	47
5	Lyubimets	28	39	24	45
6	Brestnik	28	42	29	45
7	Chernomorets	28	46	36	43
8	Chernomorets	28	37	30	42
9	Spartak	28	33	41	37
10	Panayot	28	37	40	33
11	Svetkavitsa	28	28	31	32
12	Svilengrad	28	36	58	31
13	Minyor	28	34	46	30
14	Dobrudzha	28	27	39	30
15	Rodopa	28	6	78	5

TEMPORADA 2008/2009

SEGUNDA BULGARIA B PFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Beroe	28	48	19	66
2	Chernomorets	28	59	21	61
3	Kaliakra	28	39	28	48
4	Spartak	28	30	33	41
5	Dunav Ruse	28	35	34	39
6	Nesebar	28	36	32	38
7	Lyubimets	28	30	29	38
8	Svetkavitsa	28	37	40	35
9	Svilengrad	28	32	40	34
10	Minyor	28	35	47	33
11	Lokomotiv	28	31	36	32
12	Chernomorets	28	30	39	31
13	Rodopa	28	33	48	31
14	Panayot	28	22	34	30
15	Maritsa	28	21	38	29

TEMPORADA 2007/2008

SEGUNDA BULGARIA B PFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sliven	26	63	23	60
2	Kaliakra	26	49	17	54
3	Rodopa	26	44	18	53
4	Nesebar	26	43	29	50
5	Dunav Ruse	26	35	28	42
6	Spartak	26	28	34	35
7	Maritsa	26	34	41	35
8	Chernomorets	26	40	35	34
9	Panayot	26	23	35	31
10	Svetkavitsa	26	26	46	28
11	Minyor	26	32	50	26
12	Svilengrad	26	30	43	25
13	Benkovski	26	26	41	22
14	Haskovo 2009	26	24	57	21

TEMPORADA 2006/2007

SEGUNDA BULGARIA B PFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chernomoretz	26	57	20	63
2	Chernomorets	26	51	10	60
3	Haskovo 2009	26	38	27	43
4	Nesebar	26	40	32	40
5	Dunav Ruse	26	46	35	39
6	Spartak	26	32	28	38
7	Panayot	26	29	36	37
8	Kaliakra	26	25	31	36
9	Svetkavitsa	26	36	41	34
10	Maritsa	26	35	36	32
11	Minyor	26	34	45	25
12	Sliven	26	32	52	23
13	Dobrudzha	26	25	51	20
14	Lokomotiv	26	22	58	13

TEMPORADA 2005/2006

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Spartak	26	34	12	56
2	Maritsa	26	41	21	49
3	Haskovo 2009	26	37	19	48
4	Spartak	26	32	26	43
5	AKB Minyor	26	30	32	39
6	Dunav Ruse	26	27	35	36
7	Dobrudzha	26	27	26	34
8	Nesebar	26	37	37	34
9	Panayot	26	32	33	34
10	Svetkavitsa	26	27	26	33
11	Kaliakra	26	27	36	32
12	Sliven	26	22	30	31
13	Pomorie	26	22	38	24
14	Zagorets	26	21	45	16

TEMPORADA 1994/1995

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	30	84	15	79
2	Lokomotiv	30	59	30	68
3	Botev	30	66	31	60
4	Slavia Sofia	30	63	35	53
5	CSKA Sofia	30	51	46	46
6	Spartak	30	33	34	43
7	Lokomotiv	30	48	38	42
8	Neftochimik	30	41	50	39
9	Shumen 2010	30	33	50	36
10	Litex Lovech	30	25	46	36
11	Etar	30	31	54	36
12	Dobrudzha	30	32	43	35
13	Montana	30	31	41	34
14	Gorna	30	35	53	33
15	Pirin	30	30	46	30
16	Beroe	30	27	77	12

TEMPORADA 1966/1967

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Botev	30	39	24	51
2	Slavia Sofia	30	33	27	50
3	Levski Sofia	30	46	32	49
4	Spartak	30	40	26	48
5	Cherno More	30	40	29	45
6	CSKA Sofia	30	42	34	45
7	Botev Vratsa	30	45	40	45
8	Lokomotiv	30	39	34	43
9	Chernomoretz	30	38	35	40
10	Beroe	30	37	41	39
11	Lokomotiv	30	30	31	35
12	Spartak	30	26	35	35
13	Dobrudzha	30	24	43	35
14	Dunav Ruse	30	35	60	31
15	Minyor	30	24	30	29
16	Marek	30	24	41	29

TEMPORADA 1965/1966

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	30	53	30	59
2	Levski Sofia	30	59	31	56
3	Slavia Sofia	30	38	25	55
4	Spartak	30	45	30	50
5	Lokomotiv	30	36	33	43
6	Dunav Ruse	30	29	40	42
7	Beroe	30	41	41	40
8	Lokomotiv	30	46	35	39
9	Spartak	30	28	42	37
10	Botev	30	41	39	36
11	Marek	30	39	51	36
12	Cherno More	30	30	35	35
13	Botev Vratsa	30	30	41	34
14	Chernomoretz	30	34	48	33
15	Spartak	30	32	48	28
16	Spartak	30	30	42	27

TEMPORADA 1964/1965

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	30	59	28	60
2	Lokomotiv	30	42	33	55
3	CSKA Sofia	30	48	26	48
4	Slavia Sofia	30	45	33	46
5	Lokomotiv	30	43	40	42
6	Beroe	30	48	41	41
7	Spartak	30	30	47	40
8	Spartak	30	42	42	39
9	Cherno More	30	37	37	39
10	Botev Vratsa	30	29	35	39
11	Spartak	30	32	34	37
12	Botev	30	40	49	36
13	Marek	30	34	41	35
14	Dunav Ruse	30	28	41	35
15	Sliven 2000	30	29	40	34
16	Akademik	30	29	48	28

TEMPORADA 1959/1960

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	22	42	18	44
2	Levski Sofia	22	32	21	39
3	Lokomotiv	22	30	22	30
4	Slavia Sofia	22	30	28	30
5	Minyor	22	27	25	30
6	Septemvri	22	34	31	29
7	Botev	22	30	31	29
8	Dunav Ruse	22	29	34	27
9	Spartak	22	27	38	26
10	Spartak	22	21	28	24
11	Spartak	22	21	29	24
12	Spartak	22	14	32	17

TEMPORADA 1957/1958

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	11	19	9	25
2	Spartak	22	27	40	23
3	Levski Sofia	11	18	9	20
4	Spartak	11	12	9	19
5	Slavia Sofia	11	23	17	16
6	Minyor	11	20	19	16
7	Lokomotiv	11	17	17	16
8	Spartak	11	18	16	14
9	Botev	11	14	18	12
10	Beroe	11	13	19	11
11	Dunav Ruse	11	11	19	10

Competiciones que juega

Grupo 1

Tercera Bulgaria V AFG Grupo 1

Pos	Equipos		Pts
1		Spartak Plovdiv	77
2		Sayana Haskovo	75
3		Nesebar	74
4		Gigant Saedinenie	60
5		Dimitrovgrad	54
6		Zagorets	54
7		Rozova dolina	53
8		Botev Plovdiv II	47
9		Rodopa Smolyan	46
10		Atletik Kuklen	43
11		Asenovets	40
12		Sozopol	39
13		Lokomotiv Plovdiv II	34
14		Karnobat	33
15		Levski Karlovo	32
16		Yambol 1915	29
17		FK Sekirovo	26
18		Sokol Markovo	25
19		Beroe Stara Zagora II	19
20		FK Sliven	17

	Ascenso : Spartak Plovdiv
	Descenso : Beroe Stara Zagora II, FK Sliven

RIVALES EN Copa Bulgaria

RIVALES EN Fase Previa Copa.

RIVALES EN Tercera Bulgaria.

USO DE MEMORIA

7,864,344 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1404
Total Execution Time	0.1424

CADENA URL

/historico/Spartak-Plovdiv

GET DATOS

$_GET['/historico/Spartak-Plovdiv']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17436 AND type_rel = 2
0.0023	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=238 AND type_rel = 3
0.0026	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.0022	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.0030	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 = '17436' 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=17436 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (73790,73546,72997,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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72997 AND teamId = 17436
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 17436
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 73546 AND teamId = 17436
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17436
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 = '17436' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021	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 = '17436' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020	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 = 72997 WHERE rp.league_id = 72997 AND rp.teamId = 17436 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.0020	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 = 72997 WHERE rp.league_id = 72997 AND rp.teamId = 17436 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 72997 WHERE rp.league_id = 72997 AND rp.teamId = 17436 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 = 17436 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0047	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 = 72997 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.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* `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 = 68509 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.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* `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.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* `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.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* `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.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* `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.0028	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.0030	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.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* `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 = 14026 AND t.round = 31 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* `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 = 14025 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 = 14024 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* `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 = 14023 AND t.round = 26 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* `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 = 14022 AND t.round = 26 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* `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 = 14028 AND t.round = 26 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* `tables1995` 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 = 26175 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* `tables1967` 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 = 26289 AND t.round = 30 ORDER BY team.conference 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* `tables1966` 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 = 26290 AND t.round = 30 ORDER BY team.conference 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* `tables1965` 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 = 26292 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* `tables1960` 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 = 26294 AND t.round = 22 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* `tables1958` 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 = 26296 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72997 ORDER BY nameShow LIMIT 100

Spartak Plovdiv

Spartak Plovdiv

Selecciona un equipo

Competiciones que juega

Tercera Bulgaria V AFG Grupo 1

RIVALES EN Copa Bulgaria

RIVALES EN Fase Previa Copa.

RIVALES EN Tercera Bulgaria.