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

Akademik Svishtov

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

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Levski 2020	34	86	11	90
2	Vihar	34	67	29	72
3	Yantra	33	63	38	63
4	FC Sevlievo	34	55	30	61
5	Spartak	34	76	34	60
6	Botev Vratsa	34	67	44	60
7	Partizan	33	46	40	53
8	Pavlikeni	33	41	31	50
9	Drenovets	34	55	55	49
10	Lokomotiv	34	59	58	49
11	Lokomotiv	33	44	47	43
12	Akademik	34	41	60	35
13	OFK Levski	34	36	45	34
14	Parva Atomna	33	38	60	33
15	Bdin	34	35	84	33
16	Peshtera	34	48	82	32
17	Etar II	33	42	62	29
18	Tryavna	34	21	110	8

TEMPORADA 2019/2020

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Yantra	13	33	8	33
2	FC Sevlievo	13	33	13	29
3	Vihar	13	28	15	28
4	Partizan	13	34	13	25
5	Pavlikeni	13	22	16	22
6	Drenovets	13	19	22	20
7	Lokomotiv	13	23	19	17
8	Akademik	13	29	23	16
9	Lokomotiv	13	15	20	15
10	Berkovitsa	13	25	26	13
11	Tryavna	13	16	24	11
12	Parva Atomna	13	13	28	11
13	Bdin	13	9	37	7
14	Juventus	13	14	49	3

TEMPORADA 2018/2019

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	75	11	79
2	Yantra	30	90	30	70
3	FC Sevlievo	30	50	27	59
4	Vihar	30	44	25	54
5	Pavlikeni	30	46	44	48
6	Bdin	30	55	43	42
7	Partizan	30	48	44	41
8	Akademik	30	47	51	41
9	Parva Atomna	30	53	52	38
10	Botev	30	40	42	38
11	Berkovitsa	30	36	42	38
12	Lokomotiv	30	49	67	37
13	Tryavna	30	27	57	27
14	Lokomotiv	30	34	65	24
15	OFK Levski	30	34	80	24
16	Yantra	30	29	77	24

TEMPORADA 2017/2018

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kariana	30	100	19	80
2	FC Sevlievo	30	60	27	64
3	Vihar	30	68	32	58
4	Bdin	30	57	33	53
5	Parva Atomna	30	45	29	52
6	OFK Levski	30	42	40	46
7	Yantra	30	60	39	43
8	Spartak	30	39	46	39
9	Akademik	30	45	46	37
10	Partizan	30	34	50	37
11	Tryavna	30	33	47	36
12	Pavlikeni	30	34	62	32
13	Botev	30	37	64	30
14	Yantra	30	37	61	26
15	Yantra	30	26	71	23
16	Mizia 2005	30	24	75	22

TEMPORADA 2016/2017

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Litex Lovech	28	114	9	77
2	Kariana	28	90	18	67
3	FC Sevlievo	28	69	33	58
4	OFK Levski	28	50	26	55
5	Bdin	28	82	33	52
6	Vihar	28	70	29	50
7	Akademik	28	43	41	38
8	Parva Atomna	28	43	56	35
9	Pavlikeni	28	42	49	34
10	Yantra	28	49	61	34
11	Tryavna	28	35	50	31
12	Mizia 2005	28	38	59	31
13	Partizan	28	23	72	23
14	Berkovitsa	28	20	140	7
15	Juventus	28	18	110	5

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

TERCERA BULGARIA V AFG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Spartak	26	92	8	71
2	Etar	26	68	20	62
3	Akademik	26	56	19	54
4	Bdin	26	61	35	52
5	OFK Levski	26	43	24	47
6	Botev	26	46	53	37
7	Yantra	26	43	54	32
8	Pavlikeni	26	40	54	30
9	Juventus	26	37	56	30
10	Berkovitsa	26	43	64	30
11	Partizan	26	39	62	29
12	Vidima-Rakov	26	23	57	24
13	Parva Atomna	26	31	45	21
14	Sitomir	26	12	83	4

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 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 2003/2004

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Beroe	26	45	13	58
2	Pirin	26	44	19	49
3	Nesebar	26	37	30	46
4	Dobrudzha	26	45	27	44
5	Svetkavitsa	26	32	28	42
6	Vihren	26	34	38	34
7	Rilski	26	31	35	34
8	Spartak	26	30	36	34
9	Etar	26	31	34	32
10	Panayot	26	25	32	31
11	Chernomoretz	26	30	35	30
12	Akademik	26	25	36	24
13	Belite Orli	26	25	47	21
14	Septemvri	26	18	42	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

TEMPORADA 2001/2002

SEGUNDA BULGARIA B PFG
Equipo		PJ	GF	GC	Puntos
1	Rilski	24	45	16	51
2	Dobrudzha	24	42	22	48
3	Botev	24	36	19	46
4	Svetkavitsa	24	35	24	41
5	Vidima-Rakov	24	39	20	40
6	Akademik	24	35	28	37
7	Pirin	24	32	29	33
8	Botev Vratsa	24	35	40	33
9	Belite Orli	24	26	35	27
10	Dunav Ruse	24	21	26	26
11	Svilengrad	24	24	46	20
12	Minyor	24	10	47	16
13	Devnya	24	14	42	11

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 Tercera Bulgaria.

USO DE MEMORIA

7,133,040 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1259
Total Execution Time	0.1271

CADENA URL

/historico/Akademik-Svishtov

GET DATOS

$_GET['/historico/Akademik-Svishtov']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0027	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 = 'Akademik-Svishtov' 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=11760 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=11760 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=11760 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=11760 AND type_rel = 2
0.0022	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 = '11760' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '11760' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026	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=11760 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 (73008,71432,68483) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 73008 AND teamId = 11760
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 68483 AND teamId = 11760
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11760
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 = '11760' 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 = '11760' and rp.type = 4
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 = '11760' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	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 = 11760 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 = 11760 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 = 11760 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 = 11760 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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* `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.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 = 57816 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.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 = 51129 AND t.round = 13 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 = 44691 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* `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 = 39353 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* `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 = 34148 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* `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.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* `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 = 4372 AND t.round = 26 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* `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.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* `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.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 = 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.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 = 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.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* `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.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* `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.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* `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 = 14042 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* `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.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* `tables2002` 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 = 14040 AND t.round = 26 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

Akademik Svishtov

Akademik Svishtov

Selecciona un equipo

Competiciones que juega

Tercera Bulgaria V AFG Grupo 4

RIVALES EN Tercera Bulgaria.