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

Radnik Surdulica

Entrenador: Dusan Djordjevic

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Novi Pazar	32	39	42	39
2	Spartak	32	30	44	38
3	Radnicki	32	35	41	37
4	FK Vozdovac	32	39	48	34
5	Novi Beograd	32	35	48	34
6	Javor	32	29	47	32
7	Železničar	32	35	60	28
8	Radnik	32	20	46	17

TEMPORADA 2022/2023

LIGA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Napredak	37	27	37	39
2	Spartak	37	38	49	39
3	Mladost	37	40	57	38
4	Javor	37	35	56	37
5	Kolubara	37	28	57	35
6	Radnicki	37	37	61	35
7	Radnik	37	28	50	35
8	Mladost GAT	37	25	49	30

TEMPORADA 2021/2022

LIGA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Radnik	37	37	37	51
2	Kolubara	37	42	65	46
3	Mladost	37	46	52	45
4	Spartak	37	45	60	44
5	Novi Pazar	37	39	54	41
6	Radnički	37	34	60	35
7	Metalac GM	37	42	65	33
8	Proleter	37	25	57	32

TEMPORADA 2020/2021

LIGA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Crvena	38	114	20	108
2	Partizan	38	95	20	95
3	Cukaricki	38	69	34	74
4	Vojvodina	38	62	41	71
5	FK TSC	38	68	50	58
6	Radnik	38	55	49	55
7	Mladost	38	43	59	54
8	Proleter	38	40	47	53
9	Metalac GM	38	48	53	52
10	Spartak	38	54	53	52
11	Napredak	38	44	51	50
12	Novi Pazar	38	50	60	49
13	Radnicki	38	37	39	49
14	FK Vozdovac	38	49	59	48
15	Rad Beograd	38	44	57	48
16	Javor	38	45	53	46
17	Inđija	38	29	66	35
18	Zlatibor	38	28	64	29
19	Mačva	38	26	81	25
20	Bačka	38	24	68	16

TEMPORADA 2019/2020

LIGA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Crvena	30	68	18	78
2	Partizan	30	69	25	64
3	Vojvodina	30	47	27	62
4	FK TSC	30	59	34	59
5	Radnicki	30	51	37	52
6	Cukaricki	30	42	36	51
7	Spartak	30	46	48	46
8	FK Vozdovac	30	45	41	45
9	Mladost	30	31	40	43
10	Napredak	30	33	41	33
11	Radnik	30	34	50	31
12	Proleter	30	30	42	30
13	Javor	30	43	62	28
14	Inđija	30	26	48	25
15	Rad Beograd	30	23	63	15
16	Mačva	30	18	53	13

TEMPORADA 2018/2019

LIGA SERBIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Crvena	30	80	16	84
2	Radnicki	30	58	17	75
3	Partizan	30	45	20	54
4	Cukaricki	30	48	25	54
5	Mladost	30	39	29	46
6	Napredak	30	32	35	41
7	Vojvodina	30	24	26	39
8	Proleter	30	31	29	38
9	Spartak	30	32	40	38
10	Radnik	30	25	35	38
11	FK Vozdovac	30	28	37	37
12	Mačva	30	16	26	32
13	Bačka	30	26	54	25
14	Rad Beograd	30	16	39	21
15	Dinamo	30	18	62	20
16	Zemun	30	19	47	18

TEMPORADA 2017/2018

LIGA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Radnik	7	9	8	28
2	Mladost	7	8	8	27
3	Zemun	7	9	8	26
4	Mačva	7	7	5	26
5	Rad Beograd	7	11	6	26
6	Bačka	7	11	11	25
7	Javor	7	8	9	24
8	Borac	7	6	14	15

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 2
Equipo		PJ	GF	GC	Puntos
1	Crvena	7	15	8	54
2	Partizan	7	13	7	40
3	Cukaricki	7	11	13	39
4	Vojvodina	7	13	6	36
5	Radnicki	7	14	12	35
6	Borac	7	9	14	30
7	FK Vozdovac	7	4	7	25
8	Radnik	7	7	19	25

TEMPORADA 2014/2015

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Radnik	30	41	14	64
2	Javor	30	47	19	61
3	Metalac GM	30	43	29	52
4	Bačka	30	37	30	48
5	Inđija	30	39	31	46
6	Sinđelić	30	40	39	40
7	Proleter	30	33	32	40
8	Sloga	30	37	37	40
9	Bežanija	30	25	27	40
10	BSK Borča	30	31	33	38
11	Kolubara	30	34	43	38
12	Sloboda	30	24	28	36
13	Moravac	30	32	41	35
14	Jedinstvo	30	23	36	29
15	Sloga	30	22	56	26
16	Mačva	30	23	36	25

TEMPORADA 2013/2014

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Mladost	30	42	20	60
2	Metalac GM	30	34	14	52
3	Borac	30	28	19	52
4	Bežanija	30	34	26	45
5	BSK Borča	30	37	39	43
6	Sloga	30	35	40	43
7	Sloga	30	35	31	42
8	Jedinstvo	30	30	37	41
9	Proleter	30	42	36	39
10	Radnik	30	31	36	38
11	Sinđelić	30	32	36	37
12	Inđija	30	32	41	37
13	Timok	30	26	35	34
14	Dolina	30	31	42	34
15	Teleoptik	30	35	40	31
16	Smederevo	30	26	38	31

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

Competiciones que juega

Grupo 1

Liga Serbia Grupo 3

Pos	Equipos		Pts
1		Novi Pazar	39
2		FK Spartak Subotica	38
3		Radnicki Nis	37
4		FK Vozdovac	34
5		IMT Novi Beograd	34
6		Javor Ivanjica	32
7		Železničar Pancevo	28
8		Radnik Surdulica	17

	Playoff Descenso : IMT Novi Beograd, Javor Ivanjica
	Descenso : Železničar Pancevo, Radnik Surdulica

RIVALES EN Copa Serbia

RIVALES EN Liga Serbia

USO DE MEMORIA

6,248,112 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6654
Total Execution Time	0.6666

CADENA URL

/historico/Radnik-Surdulica

GET DATOS

$_GET['/historico/Radnik-Surdulica']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0137	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 = 'Radnik-Surdulica' 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.0126	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=17392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=17392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=17392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=17392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=17392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253	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 = 75863
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17392 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17392 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127	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 (681597,681780,842600) ORDER BY n.cover_points DESC, update_date DESC
0.0137	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 = '17392' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '17392' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 75863 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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=17392 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (75863,74071,71897,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0144	SELECT count(id) as num_players from rel_players WHERE league_id = 75863 AND teamId = 17392
0.0162	SELECT count(id) as num_players from rel_players WHERE league_id = 74071 AND teamId = 17392
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 71897 AND teamId = 17392
0.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17392
0.0144	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 = 75863 WHERE rp.league_id = 75863 AND rp.teamId = 17392 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.0142	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 = 75863 WHERE rp.league_id = 75863 AND rp.teamId = 17392 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 75863 WHERE rp.league_id = 75863 AND rp.teamId = 17392 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 17392 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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 = 72238 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.0128	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 = 75863 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 67770 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.0129	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 = 71487 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 63172 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.0127	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 = 67316 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 56989 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 49967 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.0127	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.0132	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.0127	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 = 43254 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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.0129	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.0138	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.0132	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 = 23658 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 3832 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 2855 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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.0129	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

Radnik Surdulica

Radnik Surdulica

Selecciona un equipo

Competiciones que juega

Liga Serbia Grupo 3

RIVALES EN Copa Serbia

RIVALES EN Liga Serbia