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

Botev Vratsa

Entrenador: Daniel Morales

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA BULGARIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Beroe	30	24	42	33
2	Hebar	30	32	44	30
3	Pirin	31	24	43	30
4	Lokomotiv	30	22	56	28
5	Botev Vratsa	31	24	54	25
6	Etar	30	17	56	14

TEMPORADA 2022/2023

LIGA BULGARIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pirin	35	28	43	34
2	Hebar	35	30	59	32
3	Botev Vratsa	35	29	64	32
4	Beroe	35	31	54	32
5	Septemvri	35	31	52	28
6	Spartak	35	32	65	25

TEMPORADA 2021/2022

LIGA BULGARIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Lokomotiv	32	27	46	34
2	Pirin	32	40	53	33
3	Botev Vratsa	32	30	55	28
4	Tsarsko Selo	32	22	38	26

TEMPORADA 2020/2021

LIGA BULGARIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Slavia Sofia	32	28	44	34
2	Botev Vratsa	32	31	45	30
3	Montana	32	26	52	28
4	Etar	32	25	53	28

TEMPORADA 2019/2020

LIGA BULGARIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Cherno More	3	7	3	47
2	Etar	3	3	3	31
3	Tsarsko Selo	3	3	4	31
4	Vitosha	3	0	3	6
5	Botev	3	6	4	36
6	Arda	3	1	2	35
7	Botev Vratsa	3	5	4	26
8	Dunav Ruse	3	4	6	22

TEMPORADA 2018/2019

LIGA BULGARIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Botev Vratsa	6	20	4	14
2	Etar	6	9	4	11
3	Vitosha	6	9	10	9
4	Vereya	6	1	21	0
5	Septemvri	6	9	6	12
6	Dunav Ruse	6	11	8	9
7	Slavia Sofia	6	9	11	6
8	Lokomotiv	6	5	9	3

TEMPORADA 2017/2018

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Botev Vratsa	30	46	20	64
2	Lokomotiv	30	51	27	63
3	Tsarsko Selo	30	56	28	63
4	Montana	30	50	20	56
5	Nesebar	30	42	43	44
6	Pomorie	30	36	32	41
7	Botev	30	37	40	41
8	Gorna	30	42	39	40
9	Ludogorets	30	40	50	40
10	Litex Lovech	30	26	26	39
11	Chernomorets	30	37	40	39
12	Strumska	30	31	43	36
13	Oborishte	30	26	32	33
14	Maritsa	30	34	45	33
15	Sozopol	30	25	47	24
16	Neftochimik	30	15	62	9

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

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Etar	30	100	16	82
2	Botev Vratsa	30	101	17	81
3	Akademik	30	58	34	59
4	OFK Levski	30	49	33	48
5	Kariana	30	49	44	47
6	Vihar	30	44	38	46
7	Pavlikeni	30	39	52	46
8	Partizan	30	47	40	44
9	FC Sevlievo	30	49	56	42
10	Botev	30	47	56	41
11	Tryavna	30	36	42	36
12	Bdin	30	48	75	34
13	Juventus	30	32	62	31
14	Yantra	30	29	50	29
15	Parva Atomna	30	23	65	15
16	Gigant	30	21	92	11

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

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Ludogorets	30	58	13	72
2	Levski Sofia	30	59	20	71
3	CSKA Sofia	30	54	20	63
4	Botev	30	51	21	60
5	Litex Lovech	30	56	24	50
6	Chernomoretz	30	32	29	47
7	Beroe	30	36	38	45
8	Slavia Sofia	30	40	35	42
9	Lokomotiv	30	37	34	39
10	Cherno More	30	33	39	35
11	Pirin Gotse	30	27	57	34
12	Lokomotiv	30	27	38	31
13	Botev Vratsa	30	23	51	31
14	Minyor	30	20	49	20
15	Montana	30	27	57	16
16	Etar	30	20	75	13

TEMPORADA 2011/2012

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Ludogorets	30	73	16	70
2	CSKA Sofia	30	60	19	69
3	Levski Sofia	30	61	28	62
4	Chernomoretz	30	57	23	60
5	Litex Lovech	30	57	28	59
6	Lokomotiv	30	44	39	57
7	Cherno More	30	46	25	52
8	Slavia Sofia	30	42	36	51
9	Minyor	30	35	40	36
10	Beroe	30	30	37	35
11	Montana	30	29	51	31
12	Botev Vratsa	30	30	44	29
13	Lokomotiv	30	26	50	24
14	Vidima-Rakov	30	19	59	15
15	Kaliakra	30	26	77	11
16	Svetkavitsa	30	8	71	8

Competiciones que juega

Grupo 1

Liga Bulgaria Grupo 3

Pos	Equipos		Pts
1		Beroe	33
2		Hebar Pazardzhik	30
3		Pirin Blagoevgrad	30
4		Lokomotiv Sofia	28
5		Botev Vratsa	25
6		Etar	14

	Playoff Descenso : Lokomotiv Sofia
	Descenso : Botev Vratsa, Etar

RIVALES EN Liga Bulgaria

RIVALES EN Copa Bulgaria

USO DE MEMORIA

6,170,784 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1704
Total Execution Time	0.1717

CADENA URL

/historico/Botev-Vratsa

GET DATOS

$_GET['/historico/Botev-Vratsa']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0044	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 = 'Botev-Vratsa' 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=6470 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026	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=6470 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=6470 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6470 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6470 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043	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 = 75897
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6470 AND type_rel = 2
0.0026	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6470 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	SELECT /35 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 (700733) ORDER BY n.cover_points DESC, update_date DESC
0.0059	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 = '6470' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0068	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 = '6470' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 75897 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042	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=6470 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (75897,73790,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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 75897 AND teamId = 6470
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 6470
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6470
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 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 = 75897 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0031	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 = '6470' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6470' and rp.type = 4
0.0022	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 = '6470' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023	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 = 75897 WHERE rp.league_id = 75897 AND rp.teamId = 6470 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.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 = 75897 WHERE rp.league_id = 75897 AND rp.teamId = 6470 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 75897 WHERE rp.league_id = 75897 AND rp.teamId = 6470 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 6470 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72087 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.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* `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 = 75897 AND t.round = 1 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* `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 = 67855 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.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 = 71635 AND t.round = 5 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 = 67308 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 57193 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 62411 AND t.round = 6 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* `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 = 49907 AND t.round = 26 ORDER BY team.conference ASC,t.position 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* `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 = 56898 AND t.round = 1 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* `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 = 56790 AND t.round = 3 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* `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 = 43917 AND t.round = 26 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* `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 = 49313 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 38793 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 34065 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 15845 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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.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* `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.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* `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 = 1934 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 1621 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 75897 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

Botev Vratsa

Botev Vratsa

Selecciona un equipo

Competiciones que juega

Liga Bulgaria Grupo 3

RIVALES EN Liga Bulgaria

RIVALES EN Copa Bulgaria