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

Rozova dolina

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	32	72	34	61
5	Dimitrovgrad	32	53	34	57
6	Zagorets	30	65	34	54
7	Rozova	32	58	41	53
8	Botev	31	64	43	48
9	Rodopa	32	58	50	46
10	Asenovets	32	50	57	43
11	Atletik	32	51	68	43
12	Sozopol	31	47	40	39
13	Lokomotiv	31	48	51	37
14	Levski	32	50	70	35
15	Karnobat	32	41	78	33
16	FK Sekirovo	32	45	71	29
17	Yambol 1915	31	39	70	29
18	Sokol	31	32	72	25
19	FK Sliven	32	31	118	20
20	Beroe Stara	32	24	91	19

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 2021/2022

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Levski	34	112	16	86
2	Haskovo 2009	34	65	17	74
3	Zagorets	34	70	30	68
4	Chernomorets	34	53	28	67
5	Asenovets	34	61	45	62
6	Nesebar	34	61	46	55
7	Levski	34	47	41	53
8	Rodopa	34	47	39	50
9	Gigant	34	35	39	46
10	Dimitrovgrad	34	41	47	45
11	Atletik	34	39	55	39
12	Rozova	34	50	68	37
13	Lokomotiv	34	42	54	34
14	Karnobat	34	36	79	32
15	Sokol	34	38	74	30
16	Beroe Stara	34	38	69	29
17	Borislav	34	45	84	29
18	Yambol 1915	34	18	67	26

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 2019/2020

TERCERA BULGARIA V AFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sozopol	19	36	8	45
2	Zagorets	19	52	15	43
3	Maritsa	19	43	15	41
4	Chernomorets	19	30	19	36
5	Gigant	19	27	19	34
6	Minyor	19	26	13	30
7	Rozova	19	38	30	30
8	Svilengrad	19	27	19	30
9	Nesebar	19	22	25	26
10	Borislav	19	28	33	23
11	Haskovo 1957	19	23	29	22
12	Levski	19	18	22	21
13	Rodopa	19	23	33	21
14	Atletik	19	19	30	20
15	Yambol 1915	19	17	38	16
16	Sokol	19	18	47	15
17	Karnobat	19	17	33	14
18	Dimitrovgrad	19	13	49	12

TEMPORADA 2018/2019

TERCERA BULGARIA V AFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Neftochimik	34	88	21	90
2	Sozopol	34	74	27	85
3	Zagorets	34	81	22	77
4	Chernomorets	34	76	35	68
5	Maritsa	34	44	29	58
6	Minyor	34	46	30	56
7	Haskovo 1957	34	54	47	50
8	Rozova	34	58	50	48
9	Atletik	34	48	46	46
10	Sokol	34	46	58	42
11	Gigant	34	32	36	41
12	Borislav	34	44	47	39
13	Karnobat	34	41	67	37
14	Levski	34	25	52	36
15	Dimitrovgrad	34	30	54	31
16	Svilengrad	34	30	69	29
17	Sadovo	34	18	90	19
18	Asenovets	34	36	91	14

TEMPORADA 2017/2018

TERCERA BULGARIA V AFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Arda	34	142	7	94
2	Zagorets	34	67	27	71
3	Minyor	34	63	34	59
4	Rozova	34	64	41	57
5	Atletik	34	55	51	56
6	Sokol	34	63	49	53
7	Karnobat	34	65	50	52
8	Levski	34	51	58	51
9	Borislav	34	65	62	50
10	Asenovets	34	53	55	49
11	Dimitrovgrad	34	46	62	48
12	Gigant	34	33	53	43
13	Svilengrad	34	52	89	43
14	Evrokolezh	34	63	71	42
15	Yambol 1915	34	62	59	38
16	Rakovski	34	44	65	35
17	Vereya II	34	45	88	33
18	Tundzha	34	15	127	2

TEMPORADA 2016/2017

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Zagorets	34	77	13	84
2	Maritsa	34	95	25	78
3	Karnobat	34	79	35	73
4	Rozova	34	69	38	64
5	Atletik	34	58	44	53
6	Borislav	34	60	48	50
7	Evrokolezh	34	64	65	46
8	Uragan	34	55	66	45
9	Asenovets	34	50	56	44
10	Dimitrovgrad	34	35	39	43
11	Vereya II	34	66	76	41
12	Svilengrad	34	41	52	41
13	Gigant	34	51	71	41
14	Rakovski	34	52	81	40
15	Minyor	34	39	58	39
16	Arda	34	49	69	39
17	Lyubimets	34	38	79	33
18	Elhovo	34	27	90	15

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

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Botev	38	127	15	112
2	Neftochimik	38	100	31	81
3	Zagorets	38	69	37	78
4	Sozopol	38	89	31	71
5	Gigant	38	66	45	70
6	Botev	38	68	39	66
7	Dimitrovgrad	38	67	42	61
8	Svilengrad	38	70	66	61
9	Maritsa	38	77	55	58
10	Arda	38	71	59	54
11	Hebros	38	61	49	54
12	Tundzha	38	67	86	53
13	Asenovets	38	58	63	49
14	Rodopa	38	63	72	47
15	Rozova	38	49	58	45
16	Levski	38	39	71	43
17	Chirpan	38	36	90	32
18	Tundzha	38	43	106	30
19	Gabrovnitsa	38	19	136	11
20	Stambolovo	38	16	104	10

TEMPORADA 2009/2010

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ravda 1954	36	111	20	96
2	Maritsa	36	101	25	96
3	Neftochimik	36	89	28	77
4	Botev	36	58	28	64
5	Levski	36	54	28	62
6	Sozopol	36	58	33	62
7	Stambolovo	36	47	35	56
8	Arda	36	42	38	56
9	Hebros	36	52	41	55
10	Tundzha	36	75	67	54
11	Gigant	36	51	43	54
12	Zagorets	36	50	60	43
13	Rozova	36	54	76	40
14	Dimitrovgrad	36	43	57	38
15	Strandzha-Me	36	39	71	37
16	Metalik	36	46	90	37
17	Gabrovnitsa	36	33	98	24
18	Tundzha	36	20	105	17
19	Haskovo 2009	36	10	90	14

TEMPORADA 2008/2009

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Brestnik	36	82	24	85
2	Tundzha	36	76	39	81
3	Pomorie	35	73	19	73
4	Chernomorec	36	79	27	69
5	Stambolovo	36	68	42	64
6	Rozova	36	64	49	54
7	Botev	36	49	37	53
8	Levski	36	54	58	53
9	Sozopol	36	47	51	51
10	Gigant	36	55	56	50
11	Gorubso	36	46	47	48
12	Arda	36	51	61	45
13	Kosmos	36	51	63	44
14	Asenovets	36	49	61	44
15	Hebros	36	28	39	40
16	Metalik	36	36	87	37
17	Haskovo 2009	35	36	78	35
18	Tundzha	36	38	89	28
19	Strandzha-Me	36	25	80	23

TEMPORADA 1982/1983

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Sofia	30	52	26	63
2	Levski Sofia	30	50	21	60
3	Botev	30	62	40	54
4	Spartak	30	46	40	44
5	Lokomotiv	30	39	40	44
6	Botev Vratsa	30	38	35	43
7	Sliven	30	46	45	43
8	Etar	30	38	41	42
9	Spartak	30	36	38	41
10	Belasitsa	30	43	54	41
11	Chernomoretz	30	41	47	40
12	Slavia Sofia	30	35	37	39
13	Cherno More	30	24	28	38
14	Haskovo 2009	30	34	41	31
15	Rozova	30	30	53	26
16	Pirin	30	26	54	26

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	61
5		Dimitrovgrad	57
6		Zagorets	54
7		Rozova dolina	53
8		Botev Plovdiv II	48
9		Rodopa Smolyan	46
10		Asenovets	43
11		Atletik Kuklen	43
12		Sozopol	39
13		Lokomotiv Plovdiv II	37
14		Levski Karlovo	35
15		Karnobat	33
16		FK Sekirovo	29
17		Yambol 1915	29
18		Sokol Markovo	25
19		FK Sliven	20
20		Beroe Stara Zagora II	19

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

RIVALES EN Copa Bulgaria

RIVALES EN Fase Previa Copa.

RIVALES EN Tercera Bulgaria.

USO DE MEMORIA

7,815,528 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1557
Total Execution Time	0.1569

CADENA URL

/historico/Rozova-Dolina

GET DATOS

$_GET['/historico/Rozova-Dolina']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0055	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 = 'Rozova-Dolina' 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.0021	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=17434 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=17434 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=17434 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=17434 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=17434 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17434 AND type_rel = 2
0.0034	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 = '17434' ORDER BY l.year DESC,cat.coefficient DESC
0.0035	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 = '17434' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0038	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 = '17434' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028	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 = 73790 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032	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=17434 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0025	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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72997 AND teamId = 17434
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 17434
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 73546 AND teamId = 17434
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17434
0.0024	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 = '17434' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0026	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 = '17434' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72997 WHERE rp.league_id = 72997 AND rp.teamId = 17434 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.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 = 72997 WHERE rp.league_id = 72997 AND rp.teamId = 17434 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 17434 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 = 17434 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0053	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.0032	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.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* `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 = 63579 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.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* `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 = 50571 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.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* `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 = 44689 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* `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 = 39348 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* `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 = 34147 AND t.round = 34 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* `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.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 = 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.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* `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.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* `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.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* `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 = 24594 AND t.round = 38 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 = 24623 AND t.round = 38 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* `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 = 24631 AND t.round = 38 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* `tables1983` 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 = 26245 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

Rozova dolina

Rozova dolina

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.