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

Suvorovo

Temporada 2019/2020

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

TERCERA BULGARIA V AFG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Spartak	5	13	3	13
2	Suvorovo	5	14	3	10
3	Septemvri	5	6	7	7
4	Svetkavitsa	5	9	6	5
5	Hitrino	5	4	5	4
6	Botev Novi.	5	2	24	1

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 1
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	22	49	7	60
2	Dobrudzha	22	55	8	55
3	Suvorovo	22	42	20	39
4	Kaliakra	22	33	24	36
5	Botev Novi.	22	21	38	34
6	Septemvri	22	21	25	28
7	Lokomotiv	22	28	24	27
8	Svetkavitsa	22	15	28	23
9	Kubrat	22	21	39	22
10	Hitrino	22	18	32	20
11	Dorostol	22	15	43	15
12	Spartak	22	21	51	13
13	Inter	0	0	0	0

TEMPORADA 2015/2016

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	26	79	14	73
2	Kaliakra	26	66	24	58
3	Suvorovo	26	46	32	48
4	Svetkavitsa	26	41	32	42
5	Botev Novi.	26	43	27	38
6	Inter	26	34	33	38
7	Marisan Ruse	26	42	47	38
8	Benkovski	26	30	56	32
9	Himik Devnya	26	36	64	32
10	Septemvri	26	42	39	31
11	Shumen 1929	26	40	39	30
12	Kubrat	26	26	37	29
13	Ticha	25	21	56	18
14	Dve Mogili	25	18	64	11

TEMPORADA 2014/2015

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dunav Ruse	29	119	10	82
2	Chernomorets	30	85	14	76
3	Kaliakra	30	93	21	72
4	Suvorovo	29	46	36	59
5	Ticha	30	59	38	53
6	Benkovski	30	46	39	49
7	Septemvri	30	43	46	46
8	Kubrat	30	48	45	45
9	Svetkavitsa	30	42	44	45
10	Botev Novi.	30	45	61	38
11	Belitsa	30	39	58	34
12	Shumen 1929	30	41	52	32
13	Dve Mogili	30	19	53	22
14	Chernomorets	30	25	68	21
15	Provadia	30	30	109	13
16	Dorostol	30	12	98	8

TEMPORADA 2013/2014

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Benkovski	28	87	18	69
2	Svetkavitsa	27	69	8	66
3	Septemvri	28	68	20	62
4	Ticha	28	80	19	57
5	Kubrat	27	56	17	55
6	Suvorovo	27	55	31	52
7	Belitsa	28	51	29	46
8	Chernomorets	27	40	23	46
9	Dve Mogili	28	47	50	32
10	Provadia	28	29	66	30
11	Shumen 1929	28	32	60	27
12	Botev Novi.	28	33	63	26
13	Silistra	28	25	47	25
14	Chernomorets	28	35	61	23
15	Shumen 2010	28	40	87	15
16	Veliki	28	18	166	7

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

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Shumen 2010	28	69	24	63
2	Dve Mogili	28	75	28	62
3	Suvorovo	27	60	23	59
4	Belitsa	28	51	24	50
5	Septemvri	28	45	27	49
6	Dunav Ruse	28	48	19	46
7	Chernolomets	28	45	29	43
8	Benkovski	28	52	60	41
9	Himik Devnya	27	33	38	39
10	Chernomorets	28	43	34	36
11	Chernomorets	28	40	31	31
12	Veliki	28	24	74	24
13	Rapid	27	33	57	22
14	Lokomotiv	28	19	88	15
15	Botev Novi.	27	3	84	2

TEMPORADA 2010/2011

TERCERA BULGARIA V AFG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	91	20	76
2	Septemvri	30	54	27	62
3	Dve Mogili	30	58	29	59
4	Shumen 2010	30	65	31	56
5	Suvorovo	30	45	24	55
6	Rapid	30	39	40	44
7	Chernomorets	30	49	50	43
8	Belitsa	30	43	42	40
9	Chernolomets	30	42	45	38
10	Skrita Sila	30	51	58	38
11	Benkovski	30	58	58	37
12	Topoli	29	34	54	32
13	Veliki	30	26	54	30
14	Himik Devnya	30	21	52	25
15	Shabla	29	23	59	25
16	Botev Novi.	30	19	75	20

TEMPORADA 2009/2010

TERCERA BULGARIA V AFG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dorostol	34	81	23	82
2	Ludogorets	34	79	28	80
3	Chernolomets	34	66	38	59
4	Septemvri	34	47	30	59
5	Dve Mogili	34	61	32	57
6	Chernomorets	34	62	35	57
7	Rapid	34	65	41	57
8	Shabla	34	65	56	57
9	Benkovski	34	82	57	55
10	Suvorovo	34	59	52	47
11	Skrita Sila	34	57	62	45
12	Veliki	34	49	57	38
13	Sportist	34	42	61	37
14	Topoli	34	50	77	36
15	Botev Novi.	34	34	66	36
16	Kubrat	34	43	81	33
17	Aksakovo	34	35	86	33
18	Endzhe	34	9	104	10

TEMPORADA 2008/2009

TERCERA BULGARIA V AFG GRUPO 3
Equipo		PJ	GF	GC	Puntos

Competiciones que juega

Tercera Bulgaria V AFG Grupo 3

Pos	Equipos		Pts
1		Dobrudzha Dobrich	45
2		Ustrem Donchevo	34
3		Suvorovo	32
4		Chernolomets 1919	30
5		Septemvri Tervel	28
6		Svetkavitsa Targovishte	24
7		Shumen 2007	22
8		Topoli	21
9		Hitrino	14
10		Kaliakra	13
11		Kubrat	13
12		Benkovski Byala	5
13		Botev Novi Pazar	2
14		Lokomotiv Ruse	0

	Playoff Ascenso : Dobrudzha Dobrich, Ustrem Donchevo, Suvorovo, Chernolomets 1919, Septemvri Tervel, Svetkavitsa Targovishte
	Playoff Descenso : Shumen 2007, Topoli, Hitrino, Kaliakra, Kubrat, Benkovski Byala, Botev Novi Pazar
	Descenso : Lokomotiv Ruse

RIVALES EN Copa Bulgaria

RIVALES EN Tercera Bulgaria.

USO DE MEMORIA

6,011,992 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.9434
Total Execution Time	0.9446

CADENA URL

/historico/Suvorovo

GET DATOS

$_GET['/historico/Suvorovo']

POST DATOS

No hay datos POST existentes

CONSULTAS (56)

0.0149	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 = 'Suvorovo' 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.0169	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 = 'Suvorovo' 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.0145	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=17453 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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 = 51128
0.0153	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 = 51121
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17453 AND type_rel = 2
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=238 AND type_rel = 3
0.0146	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 238 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147	SELECT /53 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 (77796,59747,55420,15539) ORDER BY n.cover_points DESC, update_date DESC
0.0147	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 = '17453' ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '17453' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0148	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 = '17453' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = '17453' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = 51121 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 51128 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	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=17453 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (51128,51121) 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.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 51128 AND teamId = 17453
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 51121 AND teamId = 17453
0.0154	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146	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 = '17453' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146	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 = '17453' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147	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 events2020 e ON e.player_id = p.id AND e.league_id = 51128 WHERE rp.league_id = 51128 AND rp.teamId = 17453 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.0146	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 events2020 e ON e.player_id = p.id AND e.league_id = 51128 WHERE rp.league_id = 51128 AND rp.teamId = 17453 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 events2020 e ON e.player_id = p.id AND e.league_id = 51128 WHERE rp.league_id = 51128 AND rp.teamId = 17453 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148	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 = 17453 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0147	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.0149	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 = 44692 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 49733 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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.0149	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.0148	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.0148	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 = 15843 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 4374 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 3579 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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.0149	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 = 24578 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 24591 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 24600 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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.0146	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 = 51128 ORDER BY nameShow LIMIT 100

Suvorovo

Suvorovo

Selecciona un equipo

Competiciones que juega

Tercera Bulgaria V AFG Grupo 3

RIVALES EN Copa Bulgaria

RIVALES EN Tercera Bulgaria.