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

FK TSC

Entrenador: Zarko Lazetic

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA SERBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Crvena	31	80	24	80
2	Partizan	31	68	38	70
3	FK TSC	31	60	31	63
4	Radnički	31	50	49	53
5	Cukaricki	32	51	38	51
6	Vojvodina	31	51	45	50
7	Mladost	32	34	45	43
8	Napredak	31	32	42	39

TEMPORADA 2022/2023

LIGA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Crvena	37	96	19	97
2	FK TSC	37	66	32	75
3	Cukaricki	37	65	38	75
4	Partizan	37	68	34	71
5	Vojvodina	37	59	35	63
6	Novi Pazar	37	40	49	51
7	FK Vozdovac	37	29	52	46
8	Radnički	37	37	43	42

TEMPORADA 2021/2022

LIGA SERBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Crvena	37	95	19	100
2	Partizan	37	85	13	98
3	Cukaricki	37	54	34	60
4	Radnicki	37	40	39	51
5	FK Vozdovac	37	48	45	49
6	FK TSC	37	51	56	48
7	Vojvodina	37	44	51	45
8	Napredak	37	31	51	38

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	Spartak	38	54	53	52
10	Metalac GM	38	48	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

SEGUNDA SERBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FK TSC	7	16	8	53
2	Javor	7	17	10	46
3	Inđija	7	9	8	39
4	Radnički	7	6	4	35
5	Metalac GM	7	6	3	33
6	Zlatibor	7	7	12	32
7	Bežanija	7	8	12	28
8	Sinđelić	7	7	19	24

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

TERCERA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bratstvo	28	55	24	62
2	Omladinac	28	52	28	60
3	FK TSC	28	38	24	46
4	Borac Sakule	28	46	35	45
5	Dunav Stari	28	43	40	42
6	Bačka 1901	28	31	29	41
7	Železničar	28	36	34	36
8	Sremska	28	35	49	36
9	OFK Vršac	28	33	40	35
10	Radnički	28	37	39	33
11	Radnički	28	42	47	31
12	Cement	28	36	41	31
13	Radnički	28	24	45	31
14	Crvena	28	35	45	28
15	Sloga	28	26	49	22
16	Donji Srem	0	0	0	0

TEMPORADA 2015/2016

TERCERA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	OFK Odzaci	15	25	10	30
2	Radnički	15	16	11	30
3	Sremska	15	20	14	27
4	Bačka 1901	15	19	13	25
5	FK TSC	15	13	10	25
6	Dunav Stari	15	21	13	24
7	Senta	15	16	14	22
8	Radnički	15	13	12	21
9	Omladinac	15	15	12	20
10	Sloga	15	21	20	19
11	Cement	15	17	16	18
12	Železničar	15	17	24	18
13	Borac Sakule	15	16	22	11
14	Banat	15	8	19	11
15	Dolina	15	10	22	10
16	OFK Vršac	15	8	23	9

TEMPORADA 2012/2013

TERCERA SERBIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Dolina	30	55	28	58
2	Sloga	30	48	25	53
3	Sremska	30	43	28	49
4	Dunav Stari	30	33	38	46
5	Radnički	30	39	39	45
6	Pivara	30	32	24	44
7	Senta	30	36	31	44
8	Radnički	30	32	38	44
9	Tekstilac	30	37	38	43
10	Dinamo	30	36	35	42
11	Mladost	30	29	30	39
12	Palić	30	36	40	39
13	Jedinstvo	30	29	43	35
14	Cement	30	34	52	30
15	Srem Sremska	30	24	40	29
16	FK TSC	30	23	37	27

TEMPORADA 2011/2012

TERCERA SERBIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Radnički	28	45	20	60
2	Sloga	28	34	31	44
3	Pivara	28	34	34	43
4	Senta	28	42	33	42
5	Radnički	28	35	27	42
6	Dunav Stari	28	34	31	41
7	Tekstilac	28	32	29	39
8	Cement	28	39	34	38
9	Mladost	28	33	26	37
10	Palić	28	34	36	37
11	FK TSC	28	23	26	37
12	Dolina	28	30	36	36
13	Zadrugar	28	32	38	34
14	OFK Vršac	28	26	44	30
15	Kikinda	28	24	52	22
16	Veternik	0	0	0	0

Competiciones que juega

Europa League Grupo 1

Pos	Equipos		Pts
1		West Ham	15
2		SC Freiburg	12
3		Olympiacos Piraeus	7
4		FK TSC	1

	: West Ham
	: SC Freiburg
	: Olympiacos Piraeus
	Eliminado : FK TSC

RIVALES EN Fase Previa Cham.

RIVALES EN Copa Serbia

RIVALES EN Europa League

RIVALES EN Liga Serbia

USO DE MEMORIA

6,443,192 bytes

BENCHMARKS

Loading Time Base Classes	0.0017
Controller Execution Time ( Home / Category )	0.7257
Total Execution Time	0.7275

CADENA URL

/historico/Fk-Backa-Topola

GET DATOS

$_GET['/historico/Fk-Backa-Topola']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

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 = 'Fk-Backa-Topola' 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.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=80053 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=80053 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=80053 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=80053 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=80053 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=80053 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=80053 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0153	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73871
0.0132	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 = 72095
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80053 AND type_rel = 2
0.0132	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 = '80053' ORDER BY l.year DESC,cat.coefficient DESC
0.0132	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 = '80053' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0136	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 = '80053' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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 = 73871 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132	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 = 72238 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0163	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=80053 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0134	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 (75862,74071,73871,72095,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.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 75862 AND teamId = 80053
0.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 73871 AND teamId = 80053
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 72095 AND teamId = 80053
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 74071 AND teamId = 80053
0.0166	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 80053
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 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 = 73871 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	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 = '80053' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '80053' and rp.type = 4
0.0127	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 = '80053' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139	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 = 73871 WHERE rp.league_id = 73871 AND rp.teamId = 80053 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 = 73871 WHERE rp.league_id = 73871 AND rp.teamId = 80053 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 73871 WHERE rp.league_id = 73871 AND rp.teamId = 80053 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 80053 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.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* `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 = 75862 AND t.round = 2 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* `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 = 71506 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.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* `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 = 67315 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.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.0142	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.0139	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 = 49785 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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.0149	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 34068 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	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 = 15799 AND t.round = 15 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* `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 = 25185 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 = 25194 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 73871 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

FK TSC

FK TSC

Selecciona un equipo

Competiciones que juega

Europa League Grupo 1

RIVALES EN Fase Previa Cham.

RIVALES EN Copa Serbia

RIVALES EN Europa League

RIVALES EN Liga Serbia