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

Gorna Lokomotiv Oryahovitsa

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Gorna	23	78	13	67
2	Akademik	22	45	10	53
3	FC Sevlievo	22	55	20	48
4	Yantra	24	52	40	44
5	Lokomotiv	23	47	27	43
6	Etar II	24	45	36	41
7	Dunav Lom	23	28	39	31
8	Boruna	23	35	50	26
9	Vihar	23	36	39	25
10	Juventus	23	34	65	22
11	Pavlikeni	22	31	56	21
12	Drenovets	24	31	61	21
13	OFK Levski	23	25	42	20
14	Partizan	22	26	56	16
15	Botev Vratsa	23	29	43	16

TEMPORADA 2022/2023

TERCERA BULGARIA V AFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bdin	30	89	29	76
2	Gorna	30	90	21	72
3	Vihar	30	63	25	66
4	Lokomotiv	30	63	27	63
5	Pavlikeni	29	54	48	52
6	FC Sevlievo	30	65	30	51
7	Yantra	30	64	44	43
8	Akademik	30	47	46	39
9	Partizan	30	36	54	33
10	Botev Vratsa	30	41	64	33
11	Juventus	30	35	74	33
12	Drenovets	30	41	76	31
13	OFK Levski	29	30	66	28
14	Etar II	30	38	68	25
15	Boruna	30	33	72	23
16	Lokomotiv	30	23	68	21

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

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

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

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

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

LIGA BULGARIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vereya	6	9	4	45
2	Botev	6	15	8	44
3	Slavia Sofia	6	7	10	37
4	Montana	6	8	17	15
5	Beroe	6	8	5	44
6	Pirin	6	11	8	43
7	Neftochimik	6	6	10	31
8	Gorna	6	10	12	30

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

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 2012/2013

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Akademik	22	61	14	50
2	Parva Atomna	22	46	15	49
3	Partizan	22	56	28	43
4	Dunav	22	39	25	40
5	Lokomotiv	22	42	38	34
6	Gorna	22	40	26	31
7	OFK Levski	22	34	32	31
8	Gigant	22	30	27	29
9	Sitomir	22	29	37	27
10	Chavdar	22	25	70	19
11	Tryavna	22	17	61	12
12	Balkan	22	19	65	10

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 2009/2010

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2008/2009

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Botev Vratsa	29	91	12	76
2	Bdin	30	80	22	72
3	Lokomotiv	30	65	33	59
4	Yantra	30	52	41	57
5	Gorna	29	46	18	54
6	Gigant	30	42	40	42
7	Marija Luiza	30	45	51	39
8	Pavlikeni	30	31	43	36
9	OFK Levski	30	36	55	36
10	Tryavna	30	30	38	35
11	Akademik	30	46	60	35
12	Storgozija	30	38	47	32
13	Botev Dimovo	30	38	59	32
14	Sitomir	30	33	70	30
15	Bali 2000 D.	30	47	68	29
16	Chumerna	30	14	77	10

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 1994/1995

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos
1	Levski Sofia	30	84	15	79
2	Lokomotiv	30	59	30	68
3	Botev	30	66	31	60
4	Slavia Sofia	30	63	35	53
5	CSKA Sofia	30	51	46	46
6	Spartak	30	33	34	43
7	Lokomotiv	30	48	38	42
8	Neftochimik	30	41	50	39
9	Shumen 2010	30	33	50	36
10	Litex Lovech	30	25	46	36
11	Etar	30	31	54	36
12	Dobrudzha	30	32	43	35
13	Montana	30	31	41	34
14	Gorna	30	35	53	33
15	Pirin	30	30	46	30
16	Beroe	30	27	77	12

TEMPORADA 1993/1994

LIGA BULGARIA
Equipo		PJ	GF	GC	Puntos

Competiciones que juega

Grupo 4

Tercera Bulgaria V AFG Grupo 4

Pos	Equipos		Pts
1		Gorna Lokomotiv Oryahovits.	67
2		Akademik Svishtov	53
3		FC Sevlievo	48
4		Yantra Polski Trambesh	44
5		Lokomotiv Mezdra	43
6		Etar II	41
7		Dunav Lom	31
8		Boruna Tsareva livada	26
9		Vihar Slavyanovo	25
10		Juventus Malchika	22
11		Pavlikeni	21
12		Drenovets	21
13		OFK Levski	20
14		Partizan	16
15		Botev Vratsa II	16

	Ascenso : Gorna Lokomotiv Oryahovitsa
	Descenso : Botev Vratsa II

RIVALES EN Copa Bulgaria

RIVALES EN Tercera Bulgaria.

USO DE MEMORIA

7,118,144 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1422
Total Execution Time	0.1434

CADENA URL

/historico/Lokomotiv-G-Oryahovitsa

GET DATOS

$_GET['/historico/Lokomotiv-G-Oryahovitsa']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0048	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 = 'Lokomotiv-G-Oryahovitsa' 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=17403 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=17403 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=17403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=17403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17403 AND type_rel = 2
0.0031	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 = '17403' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '17403' 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 = 73008 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=17403 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 (73790,73008,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 = 73008 AND teamId = 17403
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 17403
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17403
0.0033	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 = 73008 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = 73008 WHERE rp.league_id = 73008 AND rp.teamId = 17403 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.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 = 73008 WHERE rp.league_id = 73008 AND rp.teamId = 17403 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 = 73008 WHERE rp.league_id = 73008 AND rp.teamId = 17403 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0051	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 = 17403 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 = 73008 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.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 = 68507 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* `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.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* `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.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* `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.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* `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.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* `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.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* `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 = 33678 AND t.round = 26 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* `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 = 38256 AND t.round = 6 ORDER BY team.conference 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* `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.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* `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.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* `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 = 24570 AND t.round = 22 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* `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.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* `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.0020	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 = 24621 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* `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 = 24627 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* `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.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* `tables1995` 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 = 26175 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 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* `tables1994` 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 = 26177 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 = 73008 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

Gorna Lokomotiv Oryahovitsa

Gorna Lokomotiv Oryahovitsa

Selecciona un equipo

Competiciones que juega

Tercera Bulgaria V AFG Grupo 4

RIVALES EN Copa Bulgaria

RIVALES EN Tercera Bulgaria.