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

Spartak Pleven

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	51	22	63
2	Septemvri	30	41	24	58
3	Marek	30	31	21	54
4	Montana	30	38	28	50
5	Dobrudzha	30	42	28	49
6	Yantra	30	35	32	44
7	Ludogorets	30	35	30	42
8	Spartak	30	27	27	42
9	Dunav Ruse	30	27	31	42
10	Strumska	30	28	28	41
11	Litex Lovech	30	25	29	41
12	CSKA 1948 S.	30	32	34	40
13	Belasitsa	30	33	29	37
14	Chernomorets	30	28	35	34
15	Sportist	30	28	39	33
16	Maritsa	30	28	46	28
17	Chernomorets	30	28	45	27
18	Bdin	30	12	41	18

TEMPORADA 2022/2023

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	CSKA 1948 S.	34	60	17	74
2	Etar	34	47	22	63
3	Levski	34	43	33	60
4	Ludogorets	34	42	35	57
5	Sportist	34	41	40	52
6	Dunav Ruse	34	47	38	50
7	Maritsa	34	36	46	47
8	Litex Lovech	34	32	28	44
9	Montana	34	37	39	44
10	Yantra	34	31	34	44
11	Spartak	34	44	44	42
12	Belasitsa	34	33	41	41
13	Dobrudzha	34	38	40	39
14	Strumska	34	35	44	39
15	Minyor	34	33	35	38
16	Sozopol	34	32	52	38
17	Vitosha	34	34	50	36
18	Botev	34	25	52	28

TEMPORADA 2021/2022

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

TEMPORADA 2020/2021

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Levski 2020	34	86	11	90
2	Vihar	34	67	29	72
3	Yantra	33	63	38	63
4	FC Sevlievo	34	55	30	61
5	Spartak	34	76	34	60
6	Botev Vratsa	34	67	44	60
7	Partizan	33	46	40	53
8	Pavlikeni	33	41	31	50
9	Drenovets	34	55	55	49
10	Lokomotiv	34	59	58	49
11	Lokomotiv	33	44	47	43
12	Akademik	34	41	60	35
13	OFK Levski	34	36	45	34
14	Parva Atomna	33	38	60	33
15	Bdin	34	35	84	33
16	Peshtera	34	48	82	32
17	Etar II	33	42	62	29
18	Tryavna	34	21	110	8

TEMPORADA 2019/2020

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	CSKA 1948 S.	21	59	18	55
2	Septemvri	20	47	19	52
3	Montana	22	43	17	45
4	Lokomotiv	22	37	18	42
5	Neftochimik	21	35	29	33
6	Hebar	21	35	30	33
7	Litex Lovech	20	29	15	32
8	Kariana	20	30	24	32
9	Gorna	21	32	30	29
10	Botev	22	26	32	28
11	Ludogorets	22	23	25	27
12	Pirin	20	24	29	25
13	Strumska	21	21	34	22
14	Chernomorets	20	15	27	22
15	Spartak	22	9	42	13
16	Spartak	22	13	41	10
17	Pomorie	27	15	63	6

TEMPORADA 2018/2019

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	75	11	79
2	Yantra	30	90	30	70
3	FC Sevlievo	30	50	27	59
4	Vihar	30	44	25	54
5	Pavlikeni	30	46	44	48
6	Bdin	30	55	43	42
7	Partizan	30	48	44	41
8	Akademik	30	47	51	41
9	Parva Atomna	30	53	52	38
10	Botev	30	40	42	38
11	Berkovitsa	30	36	42	38
12	Lokomotiv	30	49	67	37
13	Tryavna	30	27	57	27
14	Lokomotiv	30	34	65	24
15	OFK Levski	30	34	80	24
16	Yantra	30	29	77	24

TEMPORADA 2017/2018

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kariana	30	100	19	80
2	FC Sevlievo	30	60	27	64
3	Vihar	30	68	32	58
4	Bdin	30	57	33	53
5	Parva Atomna	30	45	29	52
6	OFK Levski	30	42	40	46
7	Yantra	30	60	39	43
8	Spartak	30	39	46	39
9	Akademik	30	45	46	37
10	Partizan	30	34	50	37
11	Tryavna	30	33	47	36
12	Pavlikeni	30	34	62	32
13	Botev	30	37	64	30
14	Yantra	30	37	61	26
15	Yantra	30	26	71	23
16	Mizia 2005	30	24	75	22

TEMPORADA 2016/2017

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Etar	30	52	27	61
2	Septemvri	30	52	26	59
3	Vitosha	30	37	23	53
4	Sozopol	30	38	25	50
5	Tsarsko Selo	30	54	39	48
6	Lokomotiv	30	47	34	47
7	Pomorie	30	36	32	47
8	Ludogorets	30	39	33	44
9	Nesebar	30	39	47	40
10	Botev Vratsa	30	42	41	38
11	Oborishte	30	30	39	37
12	Botev	30	28	39	34
13	CSKA Sofia	30	44	49	33
14	Spartak	30	44	52	33
15	Bansko	30	26	55	25
16	Levski	30	24	71	16

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

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Spartak	26	92	8	71
2	Etar	26	68	20	62
3	Akademik	26	56	19	54
4	Bdin	26	61	35	52
5	OFK Levski	26	43	24	47
6	Botev	26	46	53	37
7	Yantra	26	43	54	32
8	Pavlikeni	26	40	54	30
9	Juventus	26	37	56	30
10	Berkovitsa	26	43	64	30
11	Partizan	26	39	62	29
12	Vidima-Rakov	26	23	57	24
13	Parva Atomna	26	31	45	21
14	Sitomir	26	12	83	4

TEMPORADA 2013/2014

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Lokomotiv	23	72	19	55
2	Etar	23	50	13	53
3	Botev	23	45	23	53
4	Gorna	23	80	23	52
5	Spartak	23	52	22	51
6	Partizan	23	34	35	40
7	Bdin	23	36	29	32
8	Vidima-Rakov	23	43	31	31
9	Parva Atomna	23	35	34	29
10	Gigant	22	20	39	21
11	Sitomir	23	24	46	20
12	Yantra	22	14	53	18
13	OFK Levski	23	26	50	17
14	Pavlikeni	23	22	69	16
15	Berkovitsa	23	28	48	15
16	Tryavna	23	14	61	14

TEMPORADA 2011/2012

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Lokomotiv	30	102	21	85
2	Spartak	30	111	10	83
3	Parva Atomna	30	78	24	61
4	Akademik	30	65	34	58
5	Dunav	30	49	22	55
6	Torpedo	30	62	43	55
7	Gigant	30	43	34	46
8	Partizan	30	45	63	41
9	Gorna	30	34	31	37
10	Sitomir	30	42	80	36
11	Tryavna	30	33	60	29
12	Botev	28	22	54	23
13	Yantra	29	20	60	23
14	Balkan	30	24	83	20
15	OFK Levski	30	29	85	17
16	Lokomotiv	29	13	68	11

TEMPORADA 2010/2011

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bdin	30	82	17	74
2	Parva Atomna	30	57	16	61
3	Lokomotiv	30	53	24	58
4	Yantra	30	57	34	53
5	Spartak	30	49	27	51
6	Samovodene	30	57	25	50
7	Akademik	30	52	29	48
8	Tryavna	30	42	37	45
9	Sitomir	30	39	53	41
10	Torpedo	30	39	35	35
11	Botev Dimovo	30	25	58	32
12	Balkan	30	40	65	31
13	Gorna	30	28	42	29
14	Gigant	30	25	70	26
15	Lokomotiv	30	17	76	23
16	OFK Levski	30	24	78	22

TEMPORADA 2008/2009

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Montana	30	63	21	70
2	Sportist	30	54	25	63
3	Bansko	30	52	23	60
4	Chavdar	30	45	30	54
5	Balkan	30	38	34	49
6	Rilski	30	34	39	49
7	Vidima-Rakov	30	31	25	43
8	Akademik	30	39	35	42
9	Pirin Gotse	30	48	39	40
10	Botev	30	32	46	38
11	Kom-Minyor	30	32	47	33
12	Belite Orli	30	27	43	29
13	Etar	30	36	45	28
14	Marek	30	29	48	28
15	Chavdar	30	31	41	26
16	Spartak	30	10	60	14

TEMPORADA 2007/2008

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lokomotiv	26	56	12	63
2	Minyor	26	45	31	47
3	Chavdar	26	39	23	46
4	Rilski	26	44	33	45
5	Belite Orli	26	33	31	38
6	Sportist	26	35	30	36
7	Montana	26	29	29	34
8	Etar	26	33	39	34
9	Akademik	26	41	43	32
10	Spartak	26	29	40	32
11	Pirin Gotse	26	28	33	31
12	Chavdar	26	19	34	25
13	Yantra	26	31	48	24
14	Velbazhd	26	20	56	18

TEMPORADA 2006/2007

SEGUNDA BULGARIA B PFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pirin	26	41	11	60
2	Vidima-Rakov	26	50	24	53
3	Pirin Gotse	26	38	30	42
4	Vikhar	26	33	27	40
5	Spartak	26	32	27	38
6	Etar	26	36	34	35
7	Minyor	26	30	32	32
8	Montana	26	30	33	32
9	Chavdar	26	28	32	32
10	Velbazhd	26	37	44	32
11	Belite Orli	26	27	30	31
12	Lokomotiv	26	27	42	29
13	Hebar	26	22	41	25
14	Minyor Bobov	26	18	42	21

TEMPORADA 2005/2006

SEGUNDA BULGARIA B PFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chernomoretz	26	54	15	62
2	Rilski	26	53	25	61
3	Spartak	26	58	18	59
4	Vidima-Rakov	26	39	26	43
5	Belite Orli	26	34	32	38
6	Pirin Gotse	26	39	26	37
7	Hebar	26	35	35	33
8	Etar	26	31	39	30
9	Minyor Bobov	26	34	37	29
10	Lokomotiv	26	25	46	27
11	Montana	26	23	47	26
12	Minyor	26	25	43	24
13	Yantra	26	23	52	22
14	Balkan	26	11	43	19

TEMPORADA 2004/2005

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Vihren	30	57	21	69
2	Botev	30	64	21	68
3	Pirin 1992	30	63	18	67
4	Spartak	30	60	27	61
5	Rilski	30	47	35	51
6	Svetkavitsa	30	48	45	48
7	Minyor	30	46	42	41
8	Pomorie	30	38	39	40
9	Panayot	30	43	45	40
10	Chernomoretz	30	31	40	39
11	Etar	30	38	46	36
12	Dobrudzha	30	34	53	35
13	Dorostol	30	24	43	25
14	Akademik	30	21	52	24
15	Chernomorets	30	29	64	19
16	Gorna	30	17	69	13

TEMPORADA 2003/2004

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Beroe	26	45	13	58
2	Pirin	26	44	19	49
3	Nesebar	26	37	30	46
4	Dobrudzha	26	45	27	44
5	Svetkavitsa	26	32	28	42
6	Vihren	26	34	38	34
7	Rilski	26	31	35	34
8	Spartak	26	30	36	34
9	Etar	26	31	34	32
10	Panayot	26	25	32	31
11	Chernomoretz	26	30	35	30
12	Akademik	26	25	36	24
13	Belite Orli	26	25	47	21
14	Septemvri	26	18	42	18

TEMPORADA 2002/2003

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Rodopa	30	75	26	70
2	Makedonska	30	65	19	69
3	Vidima-Rakov	30	60	24	60
4	Belasitsa	30	60	32	58
5	Pirin	30	56	32	58
6	Svetkavitsa	30	45	36	56
7	Beroe	30	36	30	48
8	Sokol 96	30	39	44	40
9	Yantra	30	42	53	40
10	Olimpik	30	47	54	38
11	Akademik	30	34	38	33
12	Belite Orli	30	29	51	28
13	Chernomoretz	30	41	61	27
14	Spartak	30	32	57	26
15	Dunav Ruse	30	19	56	18
16	Botev Vratsa	30	14	81	4

Competiciones que juega

Segunda Bulgaria B PFG

Pos	Equipos		Pts
1		Spartak Varna	63
2		Septemvri Sofia	58
3		Marek	54
4		Montana	50
5		Dobrudzha Dobrich	49
6		Yantra Gabrovo	44
7		Ludogorets II	42
8		Spartak Pleven	42
9		Dunav Ruse	42
10		Strumska Slava	41
11		Litex Lovech	41
12		CSKA 1948 Sofia II	40
13		Belasitsa	37
14		Chernomorets 1919 Burgas	34
15		Sportist Svoge	33
16		Maritsa Plovdiv	28
17		Chernomorets Balchik	27
18		Bdin	18

	Ascenso : Spartak Varna, Septemvri Sofia
	Playoff Ascenso : Marek
	Descenso : Sportist Svoge, Maritsa Plovdiv, Chernomorets Balchik, Bdin

RIVALES EN Copa Bulgaria

RIVALES EN Segunda Bulgaria.

USO DE MEMORIA

7,730,192 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5878
Total Execution Time	0.5890

CADENA URL

/historico/Spartak-Pleven

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0118	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 = 'Spartak-Pleven' 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.0106	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=17409 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=17409 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=17409 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=17409 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17409 AND type_rel = 2
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=237 AND type_rel = 3
0.0121	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 = '17409' ORDER BY l.year DESC,cat.coefficient DESC
0.0111	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 = '17409' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0110	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 = '17409' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0110	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=17409 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106	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,72088,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.0108	SELECT count(id) as num_players from rel_players WHERE league_id = 72088 AND teamId = 17409
0.0108	SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 17409
0.0107	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17409
0.0107	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 = '17409' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17409' and rp.type = 4
0.0106	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 = '17409' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0119	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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 17409 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.0125	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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 17409 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112	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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 17409 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111	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 = 17409 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111	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 = 72088 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.0110	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 = 68063 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.0110	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.0111	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 = 57816 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.0110	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 = 50137 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 44691 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 39353 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120	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.0200	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 = 4372 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 3576 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 24582 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 24592 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 14031 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 14030 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 14029 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 14021 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 14043 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108	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* `tables2004` 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 = 14042 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 14041 AND t.round = 30 ORDER BY team.conference 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

Resultados de Fútbol

Spartak Pleven

Spartak Pleven

Selecciona un equipo

Competiciones que juega

Segunda Bulgaria B PFG

RIVALES EN Copa Bulgaria

RIVALES EN Segunda Bulgaria.