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

Dinamo Vranje

Temporada 2021/2022

TEMPORADA 2021/2022

TERCERA SERBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Trajal	28	42	9	68
2	Budućnost	28	43	24	54
3	Radnički	28	48	30	48
4	Radnički	28	62	31	47
5	Jagodina	28	33	28	43
6	Dubočica	28	48	34	42
7	Timočanin	28	46	42	41
8	Vlasina	28	38	40	40
9	Pcinja	28	38	40	39
10	Jedinstvo	28	28	31	34
11	FK Mesevo	28	31	40	34
12	Brzi Brod	28	27	45	32
13	Hajduk	28	24	42	31
14	Rembas	28	32	47	27
15	Sloga	28	18	75	6
16	Dinamo	0	0	0	0

TEMPORADA 2020/2021

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Radnički	34	52	26	69
2	Kolubara	34	53	31	69
3	Kabel Novi	34	41	18	65
4	Novi Beograd	34	57	35	60
5	Loznica	34	57	42	54
6	Žarkovo	34	35	34	53
7	Grafičar	34	46	34	51
8	Budućnost	34	39	37	50
9	Sremska	34	37	31	45
10	Železničar	34	38	43	44
11	Borac	34	38	37	42
12	Dinamo	34	40	51	39
13	Dubočica	34	30	43	39
14	Radnički	34	32	46	39
15	Trajal	34	31	44	35
16	Jagodina	34	30	48	35
17	Zemun	34	24	51	27
18	Sloga	34	24	53	26

TEMPORADA 2019/2020

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Zlatibor	30	33	18	54
2	Grafičar	30	49	27	54
3	Bačka	30	40	26	53
4	Metalac GM	30	41	34	53
5	Kolubara	30	35	25	47
6	Radnički	30	34	33	43
7	Kabel Novi	30	31	20	42
8	Radnički	30	31	26	42
9	Novi Pazar	30	32	31	40
10	Žarkovo	30	35	36	40
11	Dinamo	30	34	38	37
12	Zemun	30	25	29	33
13	Trajal	30	21	30	31
14	Sinđelić	30	27	55	25
15	Semendrija	30	27	47	22
16	Budućnost	30	21	41	22

TEMPORADA 2018/2019

LIGA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Radnik	7	13	10	28
2	Spartak	7	9	9	27
3	FK Vozdovac	7	8	11	25
4	Mačva	7	8	12	25
5	Dinamo	7	6	5	23
6	Rad Beograd	7	6	5	23
7	Zemun	7	17	6	21
8	Bačka	7	5	14	18

TEMPORADA 2017/2018

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Proleter	30	63	25	65
2	Dinamo	30	47	24	63
3	Metalac GM	30	43	21	57
4	FK TSC	30	49	22	54
5	Inđija	30	30	25	45
6	Sinđelić	30	31	32	45
7	Bežanija	30	35	32	44
8	Teleoptik	30	39	32	40
9	Novi Pazar	30	28	33	40
10	Budućnost	30	33	33	38
11	Radnički	30	32	39	36
12	Sloboda	30	23	35	34
13	Radnički	30	28	39	31
14	Temnic 1924	30	24	47	26
15	Pivara	30	30	53	22
16	Jagodina	30	16	59	10

TEMPORADA 2016/2017

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Mačva	30	49	26	62
2	Zemun	30	44	18	61
3	Sloboda	30	43	28	54
4	Bežanija	30	36	22	48
5	Inđija	30	34	30	48
6	Radnički	30	30	31	43
7	Jagodina	30	39	35	41
8	Budućnost	31	33	43	40
9	Dinamo	30	33	43	39
10	Sinđelić	30	32	31	37
11	Proleter	30	34	40	36
12	Pivara	30	31	32	35
13	BSK Borča	30	27	39	33
14	Kolubara	31	28	36	32
15	OFK Odzaci	30	24	35	26
16	OFK Beograd	30	25	53	18

TEMPORADA 2015/2016

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Napredak	30	48	26	68
2	Bačka	30	52	30	56
3	Pivara	30	28	19	48
4	Inđija	30	46	28	45
5	Bežanija	30	35	27	43
6	Sinđelić	30	32	25	42
7	Kolubara	30	29	28	42
8	Proleter	30	32	29	40
9	BSK Borča	30	32	38	40
10	Sloga	30	34	36	39
11	Zemun	30	29	33	39
12	Dinamo	30	27	38	38
13	Sloboda	30	35	34	35
14	Donji Srem	30	24	38	34
15	Loznica	30	21	35	31
16	Radnički	30	23	63	12

TEMPORADA 2014/2015

TERCERA SERBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dinamo	30	57	30	65
2	Radnički	30	68	25	59
3	Trstenik	30	51	35	51
4	Konstantin	30	46	37	48
5	Timok	30	36	27	48
6	Radan	30	32	26	48
7	Tabane	30	40	30	45
8	Radnički	30	42	44	42
9	Bor	30	46	52	42
10	Ozren	30	48	43	39
11	Timočanin	30	36	49	39
12	Sloga	30	36	63	38
13	Sinđelić	30	40	46	36
14	Kopaonik	30	33	43	36
15	Djerdap	30	34	51	28
16	Hajduk	30	32	76	22

TEMPORADA 2012/2013

TERCERA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Radnik	30	62	33	66
2	Sinđelić	30	32	14	65
3	Radnički	30	46	14	61
4	Moravac	30	49	30	49
5	Žitorađa	30	36	26	47
6	Dubočica	30	36	31	44
7	Hajduk	30	36	36	41
8	Sloga	30	43	47	41
9	Morava	30	32	53	41
10	Kopaonik	30	32	43	40
11	Radnički	30	51	56	38
12	Tabane	30	49	53	37
13	Trstenik	30	35	34	36
14	Konstantin	30	52	53	36
15	Dinamo	30	38	50	31
16	Borac	30	16	72	6

TEMPORADA 2011/2012

TERCERA SERBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Timok	30	43	18	63
2	Radnički	30	44	24	50
3	Konstantin	30	61	50	50
4	Radnik	30	55	48	48
5	Hajduk	30	42	37	47
6	Trstenik	30	40	34	45
7	Sloga	30	42	39	44
8	Dinamo	30	35	38	41
9	Žitorađa	30	38	42	41
10	Radnički	30	34	30	40
11	Kopaonik	30	31	35	40
12	Tabane	30	35	40	37
13	Borac	30	28	42	35
14	Balkanski	30	29	40	34
15	Vlasina	30	32	49	32
16	Svrljig	30	22	45	30

TEMPORADA 2010/2011

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	BASK	34	54	21	77
2	Radnički	34	61	22	74
3	Novi Pazar	34	46	20	71
4	Banat	34	41	31	56
5	Sinđelić	34	41	34	53
6	Napredak	34	35	32	49
7	Radnički	34	30	29	49
8	Proleter	34	46	40	45
9	Mladost	34	29	32	45
10	Mladi Radnik	34	38	49	43
11	Novi	34	37	42	42
12	Bežanija	34	26	28	40
13	Teleoptik	34	35	44	39
14	Srem Sremska	34	30	43	36
15	Zemun	34	34	40	33
16	Kolubara	34	33	43	33
17	Big Bul	34	26	50	26
18	Dinamo	34	23	65	26

TEMPORADA 2009/2010

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Inđija	34	47	26	60
2	Sloboda	34	40	24	58
3	Kolubara	34	37	31	56
4	Bežanija	34	34	28	53
5	Novi	34	34	29	51
6	Teleoptik	34	38	31	50
7	Proleter	34	41	35	46
8	Srem Sremska	34	34	37	46
9	Novi Pazar	34	33	38	46
10	Banat	34	31	28	45
11	Radnički	34	30	32	45
12	Zemun	34	39	36	43
13	Dinamo	34	32	38	43
14	Mladost	34	33	31	42
15	Radnicki	34	33	35	41
16	Sloga	34	28	32	39
17	Pivara	34	32	48	32
18	Mladost	34	24	61	28

TEMPORADA 2008/2009

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	BSK Borča	34	44	17	70
2	Smederevo	34	48	23	66
3	Mladi Radnik	34	37	24	62
4	Spartak	34	46	27	60
5	Inđija	34	49	34	55
6	Metalac GM	34	38	30	55
7	Sloboda	34	53	37	51
8	Pivara	34	31	35	50
9	Srem Sremska	34	33	35	44
10	Mladost	34	29	30	43
11	Novi	34	41	42	42
12	Kolubara	34	33	36	42
13	Dinamo	34	36	39	39
14	Mladost	34	25	43	38
15	Bežanija	34	34	40	37
16	Novi Pazar	34	33	47	36
17	FK Vozdovac	34	32	43	32
18	Hajduk	34	20	80	10

TEMPORADA 2007/2008

TERCERA SERBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sinđelić	30	64	25	62
2	Dinamo	29	55	20	62
3	Dubočica	30	59	19	61
4	Svrljig	30	49	28	55
5	Kopaonik	30	45	27	54
6	Timok	30	45	36	43
7	Balkanski	30	34	44	43
8	Železničar	30	44	38	42
9	Župa	30	38	37	41
10	Železničar	30	38	38	41
11	Morava	30	42	43	41
12	Trajal	30	34	46	38
13	Sloga	30	30	44	33
14	Ozren	29	21	47	26
15	Rudar Alpos	30	29	86	16
16	OFK Nis	30	21	70	12

TEMPORADA 2006/2007

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Mladost	38	49	19	82
2	Cukaricki	38	42	15	70
3	Napredak	38	52	38	65
4	BSK Borča	38	55	36	62
5	Rad Beograd	38	53	34	62
6	Radnički	38	52	36	59
7	Sloboda	38	47	42	59
8	Pivara	38	38	26	56
9	Vlasina	38	38	37	56
10	Mladenovac	38	55	44	55
11	Radnicki	38	45	35	55
12	Javor	38	35	42	54
13	Novi Pazar	38	45	51	53
14	Srem Sremska	38	39	47	48
15	Inđija	38	42	51	46
16	Dinamo	38	33	37	45
17	Mačva	38	27	49	41
18	BASK	38	32	46	35
19	Spartak Sub	38	35	64	26
20	FK Obilic	38	16	81	6

TEMPORADA 2005/2006

TERCERA SERBIA Y MONTENEGRO GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Dinamo	34	68	26	82
2	Sinđelić	34	68	26	70
3	Železničar	34	64	33	68
4	Sloga	34	56	32	60
5	Jedinstvo	34	70	51	56
6	Dubočica	34	65	40	55
7	Timok	34	49	38	51
8	Rudar Alpos	34	61	56	51
9	Jedinstvo	34	42	46	49
10	Djerdap	34	62	46	48
11	Kopaonik	34	46	48	45
12	Konstantin	34	51	51	42
13	Morava	34	45	53	40
14	Kosanica	34	48	58	40
15	Radnički	34	44	52	38
16	Radan	34	37	78	32
17	Pukovac	34	39	107	24
18	Morava	34	28	102	13

Competiciones que juega

Tercera Serbia Grupo 2

Pos	Equipos		Pts
1		Trajal Krusevac	68
2		Budućnost Popovac	54
3		Radnički Svilajnac	48
4		Radnički Pirot	47
5		Jagodina	43
6		Dubočica	42
7		Timočanin	41
8		Vlasina	40
9		Pcinja Trgoviste	39
10		Jedinstvo Paraćin	34
11		FK Mesevo	34
12		Brzi Brod	32
13		Hajduk Veljko	31
14		Rembas	27
15		Sloga Leskovac	6
16		Dinamo Vranje	0

	Playoff Ascenso : Trajal Krusevac
	Playoff Descenso : Timočanin, Vlasina, Pcinja Trgoviste, Jedinstvo Paraćin, FK Mesevo, Brzi Brod, Hajduk Veljko
	Descenso : Rembas, Sloga Leskovac, Dinamo Vranje

RIVALES EN Copa Serbia

RIVALES EN Tercera Serbia

USO DE MEMORIA

7,075,880 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.2207
Total Execution Time	0.2227

CADENA URL

/historico/Dinamo-Vranje

GET DATOS

$_GET['/historico/Dinamo-Vranje']

POST DATOS

No hay datos POST existentes

CONSULTAS (74)

0.0033	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 = 'Dinamo-Vranje' 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.0080	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 = 'Dinamo-Vranje' 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.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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 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=60190 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025	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 = 63902
0.0026	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 = 64180
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60190 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1526 AND type_rel = 3
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1526 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020	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 (1029868) ORDER BY n.cover_points DESC, update_date DESC
0.0025	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 = '60190' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '60190' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = '60190' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 64180 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 63902 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=60190 AND l.year in (2021,2022,2023) 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 (64180,63902,62807,56990) 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 = 56990 AND teamId = 60190
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 63902 AND teamId = 60190
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 64180 AND teamId = 60190
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 60190
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 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 = 63902 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 events2022 e ON e.player_id = p.id AND e.league_id = 63902 WHERE rp.league_id = 63902 AND rp.teamId = 60190 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.0020	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 events2022 e ON e.player_id = p.id AND e.league_id = 63902 WHERE rp.league_id = 63902 AND rp.teamId = 60190 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 events2022 e ON e.player_id = p.id AND e.league_id = 63902 WHERE rp.league_id = 63902 AND rp.teamId = 60190 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 60190 AND l.year <= 2022 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* `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 = 63902 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.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* `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 = 56990 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.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* `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 = 50068 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.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* `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 = 43962 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* `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 = 49453 AND t.round = 7 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* `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 = 39255 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* `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 = 33950 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* `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 = 15515 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* `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 = 9197 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* `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 = 25183 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* `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 = 25192 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* `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 = 14847 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* `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 = 14848 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* `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 = 14849 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* `tables2008` 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 = 28190 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* `tables2007` 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 = 14851 AND t.round = 38 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* `tables2006` 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 = 14758 AND t.round = 34 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 = 63902 ORDER BY nameShow LIMIT 100

Dinamo Vranje

Dinamo Vranje

Selecciona un equipo

Competiciones que juega

Tercera Serbia Grupo 2

RIVALES EN Copa Serbia

RIVALES EN Tercera Serbia