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

Dobrudzha Dobrich

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

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 3
Equipo		PJ	GF	GC	Puntos
1	Dobrudzha	15	51	7	45
2	Ustrem	16	31	22	34
3	Suvorovo	16	42	16	32
4	Chernolomets	15	34	14	30
5	Septemvri	16	29	12	28
6	Svetkavitsa	16	30	32	24
7	Shumen 2007	15	30	23	22
8	Topoli	15	18	19	21
9	Hitrino	16	17	30	14
10	Kaliakra	13	18	34	13
11	Kubrat	15	11	34	13
12	Benkovski	15	12	43	5
13	Botev Novi.	15	10	47	2
14	Lokomotiv	0	0	0	0

TEMPORADA 2018/2019

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Tsarsko Selo	30	68	27	76
2	Montana	30	49	22	63
3	Arda	30	44	18	62
4	CSKA 1948 S.	30	39	18	59
5	Litex Lovech	30	43	26	45
6	Strumska	30	36	44	37
7	Chernomorets	30	27	35	37
8	Lokomotiv	30	25	28	36
9	Gorna	30	30	43	36
10	Pomorie	30	35	49	36
11	Ludogorets	30	31	43	32
12	Botev	30	32	38	31
13	Kariana	30	29	38	31
14	Pirin	30	29	49	31
15	Nesebar	30	33	51	27
16	Dobrudzha	30	17	38	22

TEMPORADA 2017/2018

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dobrudzha	30	101	10	86
2	Suvorovo	30	81	21	64
3	Lokomotiv	30	49	31	51
4	Hitrino	30	43	36	51
5	Septemvri	30	48	49	46
6	Svetkavitsa	30	44	26	42
7	Kaliakra	30	40	43	42
8	Spartak	30	43	61	36
9	Botev Novi.	30	25	78	21
10	Kubrat	30	22	61	17
11	Benkovski	30	20	100	12
12	Dorostol	0	0	0	0

TEMPORADA 2016/2017

TERCERA BULGARIA V AFG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	6	18	2	16
2	Suvorovo	6	10	8	13
3	Dobrudzha	6	14	5	11
4	Lokomotiv	6	4	6	8
5	Kaliakra	6	9	14	4
6	Septemvri	6	5	13	4
7	Botev Novi.	6	2	14	3

TEMPORADA 2015/2016

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

TEMPORADA 2014/2015

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

TEMPORADA 2013/2014

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

TEMPORADA 2012/2013

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dobrudzha	28	82	8	78
2	Dunav Ruse	28	86	15	74
3	Belitsa	28	57	32	51
4	Kubrat	28	38	19	50
5	Suvorovo	28	48	35	50
6	Septemvri	28	39	33	42
7	Chernomorets	28	37	31	41
8	Benkovski	28	37	46	39
9	Dve Mogili	28	33	58	35
10	Silistra	28	32	31	33
11	Chernomorets	28	28	36	31
12	Veliki	28	37	76	24
13	Provadia	28	24	57	20
14	Ariston Ruse	27	22	52	17
15	Himik Devnya	27	5	76	7
16	Lokomotiv	0	0	0	0

TEMPORADA 2011/2012

SEGUNDA BULGARIA B PFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Etar	27	31	14	53
2	Botev	27	40	17	51
3	Neftochimik	27	46	28	49
4	Lyubimets	27	42	22	48
5	Chernomorets	27	38	29	37
6	Sliven 2000	27	29	23	36
7	Spartak	27	27	35	36
8	Dobrudzha	27	22	28	32
9	Nesebar	27	24	44	26
10	Dorostol	27	6	65	2

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

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos

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

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,291,584 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1533
Total Execution Time	0.1547

CADENA URL

/historico/Dobrudzha-1919

GET DATOS

$_GET['/historico/Dobrudzha-1919']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0032	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 = 'Dobrudzha-1919' 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.0018	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=7477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=7477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	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=7477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	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=7477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72088
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7477 AND type_rel = 2
0.0027	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 = '7477' 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 = '7477' 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.0034	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=7477 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.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 72088 AND teamId = 7477
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 7477
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7477
0.0047	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 = 7477 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.0057	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 = 7477 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0059	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 = 7477 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043	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 = 7477 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.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* `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.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 = 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.0031	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 = 51128 AND t.round = 17 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* `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 = 43937 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* `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 = 39351 AND t.round = 33 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* `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 = 34146 AND t.round = 26 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* `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 = 38346 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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.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* `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.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* `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2454 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 = 24559 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* `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 = 1737 AND t.round = 27 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* `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.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* `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.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* `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 = 24629 AND t.round = 38 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* `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.0035	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.0031	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.0031	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 237 AND l.year = 2024 ORDER BY l.group_code 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

Dobrudzha Dobrich

Dobrudzha Dobrich

Selecciona un equipo

Competiciones que juega

Segunda Bulgaria B PFG

RIVALES EN Copa Bulgaria

RIVALES EN Segunda Bulgaria.