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

Novi Pazar

Entrenador: Slavko Matic

Temporada 2018/2019

TEMPORADA 2018/2019

SEGUNDA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Budućnost	7	9	6	33
2	Borac	7	11	5	28
3	Sloboda	7	6	14	26
4	FK Becej	7	6	7	25
5	Teleoptik	7	5	14	25
6	Trajal	7	11	8	24
7	Novi Pazar	7	15	8	23
8	Žarkovo	7	5	6	19

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

LIGA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Cukaricki	7	14	7	32
2	Spartak	7	9	8	32
3	Rad Beograd	7	3	8	25
4	Radnik	7	11	6	25
5	Bačka	7	10	9	23
6	Borac	7	7	6	22
7	Metalac GM	7	7	9	21
8	Novi Pazar	7	7	15	17

TEMPORADA 2015/2016

LIGA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Mladost	7	9	6	31
2	Spartak	7	17	5	29
3	Metalac GM	7	12	13	28
4	Rad Beograd	7	10	6	27
5	Javor	7	4	5	26
6	Novi Pazar	7	8	11	25
7	OFK Beograd	7	11	14	18
8	Jagodina	7	7	18	15

TEMPORADA 2014/2015

LIGA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Partizan	30	67	22	71
2	Crvena	30	46	20	64
3	Cukaricki	30	48	24	57
4	Vojvodina	30	44	36	52
5	Novi Pazar	30	39	28	47
6	Rad Beograd	30	33	38	43
7	Mladost	30	41	47	40
8	OFK Beograd	30	35	43	39
9	Radnicki	30	25	31	37
10	Jagodina	30	38	45	35
11	Spartak	30	23	33	34
12	FK Vozdovac	30	24	37	34
13	Borac	30	29	35	33
14	Napredak	30	23	34	31
15	Donji Srem	30	25	42	26
16	Radnički	30	17	42	19

TEMPORADA 2013/2014

LIGA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Crvena	30	66	27	72
2	Partizan	30	64	20	71
3	Jagodina	30	40	30	48
4	Vojvodina	30	38	32	45
5	Cukaricki	30	30	31	44
6	Radnicki	30	28	22	43
7	FK Vozdovac	30	34	35	42
8	Novi Pazar	30	32	34	39
9	Napredak	30	42	44	35
10	Spartak	30	24	37	34
11	OFK Beograd	30	31	43	33
12	Donji Srem	30	29	40	32
13	Radnički	30	30	49	32
14	Rad Beograd	30	19	37	29
15	Javor	30	29	38	29
16	Sloboda	30	21	38	28

TEMPORADA 2012/2013

LIGA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Partizan	30	71	16	73
2	Crvena	30	55	35	62
3	Vojvodina	30	40	20	61
4	Jagodina	30	35	26	50
5	Sloboda	30	39	37	45
6	OFK Beograd	30	34	32	45
7	Rad Beograd	30	32	30	44
8	Hajduk Kula	30	36	32	38
9	Spartak	30	36	39	36
10	Javor	30	38	40	34
11	Donji Srem	30	26	34	34
12	Radnicki	30	30	44	34
13	Radnički	30	25	35	31
14	Novi Pazar	30	29	40	30
15	BSK Borča	30	26	57	30
16	Smederevo	30	18	53	15

TEMPORADA 2011/2012

LIGA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Partizan	30	67	12	80
2	Crvena	30	57	18	68
3	Vojvodina	30	44	26	52
4	Jagodina	30	34	20	51
5	Sloboda	30	42	35	51
6	Radnički	30	38	27	47
7	Spartak	30	31	31	43
8	OFK Beograd	30	34	36	40
9	Javor	30	28	32	39
10	Rad Beograd	30	33	31	37
11	Hajduk Kula	30	28	44	33
12	BSK Borča	30	18	39	30
13	Smederevo	30	22	42	29
14	Novi Pazar	30	21	41	28
15	Borac	30	16	45	19
16	Metalac GM	30	14	48	15

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

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Javor	34	38	12	70
2	Jagodina	34	37	19	58
3	BSK Borča	34	38	21	58
4	Rad Beograd	34	50	34	57
5	FK Vozdovac	34	37	27	57
6	Metalac GM	34	33	26	49
7	Srem Sremska	34	43	41	47
8	Mladost	34	30	31	47
9	Pivara	34	34	29	46
10	Novi	34	31	30	46
11	Sloboda	34	34	34	45
12	Novi Pazar	34	29	39	45
13	Hajduk	34	28	33	44
14	Radnicki	34	29	31	43
15	Zemun	34	28	38	42
16	Vlasina	34	35	47	37
17	Mladenovac	34	28	51	30
18	Radnički	34	16	55	9

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

SEGUNDA SERBIA Y MONTENEGRO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bežanija	38	69	25	82
2	Mladost	38	56	18	78
3	Pivara	38	59	28	76
4	Cukaricki	38	64	29	75
5	Srem Sremska	38	46	41	59
6	Napredak	38	49	43	58
7	Mačva	38	54	55	55
8	Sloboda	38	44	42	52
9	Spartak	38	43	41	51
10	Radnicki	38	37	40	51
11	BASK	38	47	54	50
12	Mladenovac	38	36	46	47
13	Radnički	38	50	52	46
14	Vlasina	38	37	46	44
15	Novi Pazar	38	34	54	44
16	PSK Pancevo	38	47	58	40
17	Jedinstvo	38	37	54	40
18	Radnički	38	36	59	39
19	Novi	38	31	53	35
20	OFK Nis	38	26	64	27

TEMPORADA 2004/2005

SEGUNDA SERBIA Y MONTENEGRO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Buducnost	38	69	34	76
2	Javor	38	44	30	74
3	Rad Beograd	38	64	30	71
4	Mladost	38	50	30	63
5	Bežanija	38	58	53	58
6	Napredak	38	46	37	55
7	Jedinstvo	38	44	35	53
8	Spartak	38	53	44	52
9	Srem Sremska	38	50	48	52
10	Novi Pazar	38	37	39	52
11	Mačva	38	44	51	52
12	FK Vozdovac	38	46	37	51
13	Novi	38	43	40	51
14	OFK Nis	38	39	46	50
15	Radnicki	38	40	44	49
16	Vlasina	38	45	53	48
17	Radnički	38	26	50	43
18	Proleter	38	38	58	40
19	Kosanica	38	20	64	29
20	Mladost	38	27	60	26

Competiciones que juega

Grupo 1

Segunda Serbia Grupo 1

Pos	Equipos		Pts
1		FK TSC	68
2		Javor Ivanjica	63
3		Inđija	57
4		FK Zlatibor Cajetina	50
5		Radnički Kragujevac	49
6		Metalac GM	48
7		Bežanija	45
8		Sinđelić Beograd	44
9		Žarkovo	41
10		Trajal Krusevac	41
11		FK Becej	36
12		Budućnost Dobanovci	33
13		Teleoptik	27
14		Borac Čačak	25
15		Sloboda Uzice	21
16		Novi Pazar	17

	Playoff Ascenso : FK TSC, Javor Ivanjica, Inđija, FK Zlatibor Cajetina, Radnički Kragujevac, Metalac GM, Bežanija, Sinđelić Beograd
	Playoff Descenso : Žarkovo, Trajal Krusevac, FK Becej, Budućnost Dobanovci, Teleoptik, Borac Čačak, Sloboda Uzice, Novi Pazar

RIVALES EN Copa Serbia

RIVALES EN Segunda Serbia

USO DE MEMORIA

7,042,472 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1681
Total Execution Time	0.1693

CADENA URL

/historico/Novi-Pazar/2019

GET DATOS

$_GET['/historico/Novi-Pazar/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

0.0039	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 = 'Novi-Pazar' AND l.year = 2019 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.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=13472 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=13472 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=13472 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=13472 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=13472 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 43971
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 = 49786
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 = 45283
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 = 43475
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13472 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13472 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (337114) ORDER BY n.cover_points DESC, update_date DESC
0.0028	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 = '13472' AND l.year = 2019 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 = '13472' 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 = 45283 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 49786 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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=13472 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (51367,50068,43475) 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 = 50068 AND teamId = 13472
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 51367 AND teamId = 13472
0.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 13472
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 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 = 43971 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '13472' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13472' and rp.type = 4
0.0022	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '13472' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 events2019 e ON e.player_id = p.id AND e.league_id = 43971 WHERE rp.league_id = 43971 AND rp.teamId = 13472 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2019 e ON e.player_id = p.id AND e.league_id = 43971 WHERE rp.league_id = 43971 AND rp.teamId = 13472 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 events2019 e ON e.player_id = p.id AND e.league_id = 43971 WHERE rp.league_id = 43971 AND rp.teamId = 13472 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 = 13472 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 43971 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* `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 = 49786 AND t.round = 7 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* `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.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* `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 = 33340 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 = 38289 AND t.round = 7 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 = 15339 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* `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 = 23659 AND t.round = 7 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* `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 = 3820 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* `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 = 2872 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 = 10480 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* `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 = 10481 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* `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.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* `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 = 14850 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* `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.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* `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 = 14739 AND t.round = 38 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 = 14741 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 43971 ORDER BY nameShow LIMIT 100

Novi Pazar

Novi Pazar

Selecciona un equipo

Competiciones que juega

Segunda Serbia Grupo 1

RIVALES EN Copa Serbia

RIVALES EN Segunda Serbia