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

Belasitsa

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 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

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	32	146	10	94
2	Vitosha	32	72	16	74
3	Slivnishki	32	80	35	69
4	Strumska	32	58	36	60
5	Minyor	32	55	35	59
6	Vihren	32	48	36	55
7	Chiko Byaga	32	57	67	43
8	Septemvri	32	67	62	42
9	Belasitsa	32	41	52	39
10	Botev	32	52	66	37
11	Rilski	32	41	43	35
12	Velbazhd	32	42	56	34
13	Sofia 2010	32	51	72	34
14	Chepinets	32	35	72	32
15	Pirin Gotse	32	33	63	28
16	Germaneya	32	20	122	19
17	Balkan	32	25	80	17
18	Lokomotiv	0	0	0	0

TEMPORADA 2014/2015

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Oborishte	30	91	21	70
2	Minyor	30	56	21	65
3	Pirin Gotse	30	53	18	62
4	Vitosha	30	57	22	60
5	Slivnishki	30	69	38	58
6	Belasitsa	30	48	33	51
7	Strumska	30	38	36	42
8	Vihren	30	37	40	39
9	Velbazhd	30	38	42	37
10	Koneliano	30	46	80	37
11	Balkan	30	47	69	34
12	Germaneya	30	32	55	33
13	Chepinets	30	35	58	32
14	Rilski	30	26	46	27
15	Sportist	30	26	69	20
16	Mesta	30	15	66	15

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 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 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

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	30	57	18	69
2	CSKA Sofia	30	54	22	68
3	Cherno More	30	48	19	60
4	Litex Lovech	30	53	26	58
5	Lokomotiv	30	52	29	54
6	Chernomoretz	30	41	37	43
7	Lokomotiv	30	40	43	43
8	Slavia Sofia	30	41	38	37
9	Lokomotiv	30	39	41	37
10	Pirin	30	35	50	35
11	Minyor	30	24	39	35
12	Sliven 2000	30	32	40	32
13	Botev	30	31	50	30
14	Vihren	30	29	50	26
15	Spartak	30	19	46	25
16	Belasitsa	30	24	71	17

TEMPORADA 2007/2008

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	30	53	11	78
2	Levski Sofia	30	56	19	62
3	Lokomotiv	30	47	28	57
4	Litex Lovech	30	51	26	56
5	Cherno More	30	39	28	48
6	Slavia Sofia	30	38	28	47
7	Chernomoretz	30	39	32	47
8	Pirin	30	32	29	46
9	Lokomotiv	30	37	28	43
10	Vihren	30	26	29	33
11	Spartak	30	21	33	31
12	Botev	30	36	54	30
13	Beroe	30	23	39	26
14	Belasitsa	30	23	43	26
15	Vidima-Rakov	30	17	61	18
16	Marek	30	16	66	18

TEMPORADA 2006/2007

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	30	96	13	77
2	CSKA Sofia	30	68	13	72
3	Lokomotiv	30	70	28	72
4	Litex Lovech	30	65	29	62
5	Slavia Sofia	30	47	35	49
6	Cherno More	30	35	29	47
7	Lokomotiv	30	48	43	43
8	Belasitsa	30	38	43	38
9	Botev	30	41	45	37
10	Vihren	30	27	39	37
11	Beroe	30	34	33	36
12	Marek	30	39	57	34
13	Spartak	30	27	52	33
14	Rilski	30	31	53	30
15	Rodopa	30	22	52	19
16	Chernomorets	30	7	131	0

TEMPORADA 2005/2006

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2004/2005

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	30	81	16	79
2	Levski Sofia	30	76	19	76
3	Lokomotiv	30	65	34	58
4	Litex Lovech	30	45	27	52
5	Slavia Sofia	30	43	33	48
6	Lokomotiv	30	43	35	46
7	Beroe	30	32	36	35
8	Cherno More	30	30	38	35
9	Marek	30	34	44	35
10	Neftochimik	30	24	38	35
11	Belasitsa	30	25	47	34
12	Pirin	30	31	40	33
13	Rodopa	30	33	43	33
14	Vidima-Rakov	30	32	51	32
15	Nesebar	30	25	63	20
16	Spartak	30	18	73	18

TEMPORADA 2003/2004

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Lokomotiv	30	73	24	75
2	Levski Sofia	30	59	16	72
3	CSKA Sofia	30	65	29	65
4	Litex Lovech	30	43	20	64
5	Slavia Sofia	30	57	30	57
6	Cherno More	30	45	53	38
7	Marek	30	33	50	38
8	Neftochimik	30	49	38	35
9	Lokomotiv	30	37	48	33
10	Rodopa	30	28	47	33
11	Belasitsa	30	34	52	31
12	Spartak	30	35	46	30
13	Vidima-Rakov	30	31	48	30
14	Botev	30	33	60	27
15	Makedonska	30	32	57	26
16	Chernomorets	30	31	67	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,829,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1387
Total Execution Time	0.1398

CADENA URL

/historico/Belasitsa

GET DATOS

$_GET['/historico/Belasitsa']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17414 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=237 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 237 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	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 (856187,808709,15539) ORDER BY n.cover_points DESC, update_date DESC
0.0025	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 = '17414' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient 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 = '17414' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72088 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=17414 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 72088 AND teamId = 17414
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 17414
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17414
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 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 = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019	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 = '17414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	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 = '17414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032	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 = 17414 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.0027	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 = 17414 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 17414 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 17414 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 31 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 = 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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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 = 15844 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* `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 = 4373 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* `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.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* `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.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* `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.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 = 8792 AND t.round = 30 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* `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 = 8791 AND t.round = 30 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* `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 = 8789 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 8788 AND t.round = 30 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* `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 = 8786 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* `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 = 8784 AND t.round = 30 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* `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
0.0019	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 = 72088 ORDER BY nameShow LIMIT 100


	¿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

Belasitsa

Belasitsa

Selecciona un equipo

Competiciones que juega

Segunda Bulgaria B PFG

RIVALES EN Copa Bulgaria

RIVALES EN Segunda Bulgaria.