Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

Sloga Kraljevo

Temporada 2022/2023

TEMPORADA 2022/2023

TERCERA SERBIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Smederevo	30	62	18	77
2	Borac	30	72	25	73
3	FAP Priboj	30	46	26	57
4	Sloga	30	36	24	48
5	Polet	30	47	50	45
6	Tutin	30	29	37	41
7	Takovo	30	37	39	37
8	Budučnost	30	27	39	37
9	Sloga Bajina	30	40	39	34
10	Proleter	30	26	39	34
11	Real	30	29	41	33
12	Mladi Radnik	30	39	52	33
13	Mačva 1929	30	39	45	32
14	Sloga	30	29	41	31
15	Radjevac	30	28	39	30
16	Buducnost	30	25	57	20

TEMPORADA 2021/2022

TERCERA SERBIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sloga	30	60	28	63
2	Sloboda	30	43	19	63
3	Jedinstvo	30	44	19	56
4	Borac	30	42	30	52
5	Mačva 1929	30	36	23	51
6	Smederevo	30	51	34	48
7	Sloga Bajina	30	30	26	45
8	Takovo	30	31	24	41
9	Real	30	34	33	41
10	Mladi Radnik	30	26	29	38
11	Radjevac	30	28	32	36
12	Sušica	30	29	47	34
13	Buducnost	30	31	55	29
14	Sloga	30	23	37	28
15	RSK Rabrovo	30	26	62	16
16	Trepča	30	18	54	15

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

TERCERA SERBIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Borac	19	50	13	50
2	Sloga	19	32	16	36
3	Budučnost	19	24	12	36
4	Jedinstvo	19	24	17	35
5	Sloga	19	31	26	32
6	Tutin	19	30	20	31
7	Loznica	19	23	21	31
8	Sušica	19	31	29	30
9	Trepča	19	24	19	29
10	Jošanica	18	18	17	27
11	Sloga	19	22	25	22
12	Takovo	19	14	28	19
13	Proleter	19	23	32	18
14	RSK Rabrovo	19	24	36	18
15	Mačva 1929	19	17	24	17
16	Mladi Radnik	19	16	28	17
17	Šumadija	19	17	35	16
18	Mokra Gora	18	10	32	13

TEMPORADA 2015/2016

TERCERA SERBIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mačva	30	48	16	62
2	Budučnost	30	42	20	56
3	Semendrija	30	46	29	55
4	Sloga	30	32	20	47
5	Šumadija	30	48	44	43
6	Mihajlovac	30	39	42	42
7	Karadjordje	30	33	30	41
8	Jedinstvo	30	28	33	41
9	Železničar	30	29	27	40
10	FAP Priboj	30	34	36	39
11	Mokra Gora	30	33	38	37
12	Polet	30	41	37	36
13	Šumadija	30	32	36	36
14	Jedinstvo	30	26	32	36
15	Sloga	30	16	40	27
16	Zvižd	30	21	68	20

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

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Napredak	34	74	25	80
2	Cukaricki	34	52	26	67
3	FK Vozdovac	34	49	22	63
4	Proleter	34	53	43	57
5	Metalac GM	34	48	32	56
6	Jedinstvo	34	40	32	56
7	Borac	34	47	25	54
8	Bežanija	34	41	32	44
9	Mladost	34	31	35	43
10	Sloga	34	32	39	43
11	Timok	34	37	48	43
12	Inđija	34	27	35	42
13	Teleoptik	34	25	43	36
14	Radnički	34	35	44	35
15	Banat	34	29	47	35
16	Mladenovac	34	21	41	32
17	Kolubara	34	30	48	27
18	Novi	34	17	71	21

TEMPORADA 2011/2012

SEGUNDA SERBIA
Equipo		PJ	GF	GC	Puntos
1	Radnicki	34	52	28	67
2	Donji Srem	34	34	15	61
3	Mladost	34	42	27	53
4	Bežanija	34	33	15	52
5	Inđija	34	35	32	52
6	Napredak	34	39	29	51
7	Sloga	34	33	33	50
8	Teleoptik	34	45	26	49
9	Proleter	34	33	34	49
10	Novi	34	37	42	43
11	Mladenovac	34	46	52	43
12	Kolubara	34	35	43	43
13	Banat	34	35	41	41
14	Cukaricki	34	31	39	41
15	Radnički	34	25	34	41
16	Mladi Radnik	34	29	38	36
17	Sinđelić	34	34	50	31
18	Srem Sremska	34	27	67	20

TEMPORADA 2010/2011

TERCERA SERBIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sloga	30	36	20	61
2	Sloga Bajina	30	49	18	57
3	Partizan	30	37	30	48
4	Radnički	30	40	35	46
5	Rudar	30	36	33	45
6	Mačva	30	44	27	42
7	Vujić	30	28	36	42
8	Sloga	30	34	33	41
9	Šumadija	30	37	45	39
10	Železničar	30	33	29	38
11	Jedinstvo	30	34	41	37
12	Sloga	30	31	43	37
13	Polet	30	30	48	37
14	Sloboda	30	31	34	36
15	FAP Priboj	30	25	39	33
16	Budućnost	30	21	35	27

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

TERCERA SERBIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sloga	30	43	17	62
2	Radnički	30	38	28	53
3	Sloboda	30	35	34	46
4	Jedinstvo	30	27	29	42
5	Radnički	30	38	28	41
6	Sloga	30	34	35	41
7	Čačak	30	29	34	41
8	Vujić	30	27	34	41
9	Mačva	30	30	28	40
10	Metalac	30	29	31	40
11	Sloga	30	33	41	40
12	Budućnost	30	35	37	39
13	FAP Priboj	30	34	46	39
14	Pozarevac	30	40	34	38
15	Železničar	30	38	35	38
16	Loznica	30	20	39	28

TEMPORADA 2007/2008

TERCERA SERBIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mladi Radnik	30	63	17	77
2	Sloga	29	48	30	54
3	Mačva	30	30	27	43
4	Radnički	30	27	24	43
5	Pozarevac	29	38	28	42
6	Sloga	30	29	32	42
7	Metalac	30	34	32	39
8	Jedinstvo	30	29	35	39
9	Vujić	30	37	40	38
10	Budućnost	30	23	38	38
11	Čačak	30	32	40	37
12	Železničar	30	25	38	34
13	Morava	29	39	40	33
14	Sloga Bajina	30	25	36	33
15	Sloboda	29	25	30	32
16	Šumadija	30	29	46	30

TEMPORADA 2006/2007

TERCERA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Metalac GM	34	45	17	73
2	Sloga	34	50	29	64
3	Morava	34	49	30	63
4	Mladi Radnik	34	61	33	59
5	Pozarevac	34	48	42	55
6	Radnički	34	49	41	50
7	Čačak	34	40	37	50
8	Budućnost	34	43	48	50
9	Metalac	34	45	43	49
10	Vujić	34	44	36	47
11	Jedinstvo	34	46	46	47
12	Sloboda	34	47	44	46
13	Rudar	34	39	58	44
14	Bane Raška	34	52	65	41
15	Sloga	34	39	49	40
16	Loznica	33	43	52	31
17	Takovo	34	30	63	22
18	Jadar Gornji	33	37	74	18

TEMPORADA 2005/2006

TERCERA SERBIA Y MONTENEGRO GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mladost	34	86	14	86
2	Metalac GM	34	47	10	77
3	Mladi Radnik	34	54	26	60
4	Pozarevac	34	42	30	57
5	Sloboda	34	36	42	52
6	Metalac	34	52	45	47
7	Vujić	34	51	42	46
8	Budućnost	34	39	37	44
9	Sloga	34	38	39	44
10	Rudar	34	49	52	44
11	Loznica	34	35	45	43
12	Takovo	34	34	35	42
13	Sloga	34	42	41	40
14	Železničar	34	43	62	39
15	Jedinstvo	34	41	48	37
16	Šumadija	34	38	51	35
17	Trgovački	34	24	94	22
18	Remont	34	31	69	17

Competiciones que juega

Tercera Serbia Grupo 4

Pos	Equipos		Pts
1		Smederevo	77
2		Borac Čačak	73
3		FAP Priboj	57
4		Sloga Požega	48
5		Polet Ljubić	45
6		Tutin	41
7		Takovo	37
8		Budučnost Krušik	37
9		Sloga Bajina Bašta	34
10		Proleter Mihajlovac	34
11		Real Podunavci	33
12		Mladi Radnik	33
13		Mačva 1929	32
14		Sloga Kraljevo	31
15		Radjevac Krupanj	30
16		Buducnost Arilje	20

	Ascenso : Smederevo
	Descenso : Sloga Kraljevo, Radjevac Krupanj, Buducnost Arilje

RIVALES EN Tercera Serbia

USO DE MEMORIA

6,719,600 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1852
Total Execution Time	0.1865

CADENA URL

/historico/Sloga-Kraljevo

GET DATOS

$_GET['/historico/Sloga-Kraljevo']

POST DATOS

No hay datos POST existentes

CONSULTAS (58)

0.0037	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 = 'Sloga-Kraljevo' 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.0051	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 = 'Sloga-Kraljevo' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 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=17394 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028	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 = 68877
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17394 AND type_rel = 2
0.0024	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 = '17394' ORDER BY l.year DESC,cat.coefficient DESC
0.0022	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '17394' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '17394' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '17394' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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 = 68877 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=17394 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (68877,64180) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 68877 AND teamId = 17394
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 64180 AND teamId = 17394
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* `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 = 68877 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 = '17394' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17394' and rp.type = 4
0.0021	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 = '17394' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2023 e ON e.player_id = p.id AND e.league_id = 68877 WHERE rp.league_id = 68877 AND rp.teamId = 17394 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 events2023 e ON e.player_id = p.id AND e.league_id = 68877 WHERE rp.league_id = 68877 AND rp.teamId = 17394 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 events2023 e ON e.player_id = p.id AND e.league_id = 68877 WHERE rp.league_id = 68877 AND rp.teamId = 17394 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 17394 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68877 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.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* `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 = 63904 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.0031	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 = 51080 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 15800 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* `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.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* `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.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 14845 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* `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 = 14846 AND t.round = 34 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 = 25208 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.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* `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 = 25233 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* `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 = 28191 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 28198 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* `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 = 14755 AND t.round = 34 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 = 68877 ORDER BY nameShow LIMIT 100


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Sloga Kraljevo

Sloga Kraljevo

Selecciona un equipo

Competiciones que juega

Tercera Serbia Grupo 4

RIVALES EN Tercera Serbia