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

Pohronie

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA ESLOVAQUIA
Equipo		PJ	GF	GC	Puntos
1	Komárno	27	57	21	64
2	Tatran	27	49	19	57
3	Petržalka	26	53	25	54
4	Považská	26	42	31	43
5	Humenné	26	38	29	43
6	Púchov	27	47	45	42
7	Žilina II	26	52	50	39
8	Spartak	26	35	38	36
9	Pohronie	27	40	46	35
10	Liptovsky	26	43	43	33
11	Slavoj	27	32	43	33
12	Slovan	26	39	47	32
13	Šamorín	27	43	53	31
14	Malženice	26	32	44	23
15	Dolný	27	22	60	17
16	Spišská	27	18	48	10

TEMPORADA 2022/2023

SEGUNDA ESLOVAQUIA
Equipo		PJ	GF	GC	Puntos
1	FK Košice	30	61	21	66
2	Tatran	30	49	24	62
3	Komárno	30	41	26	53
4	Žilina II	30	63	53	47
5	Pohronie	30	45	41	44
6	Spartak	30	46	41	43
7	Slovan	30	43	45	43
8	Považská	30	52	48	40
9	Šamorín	30	44	50	40
10	Púchov	30	47	44	38
11	Slavoj	30	32	44	36
12	Petržalka	30	40	43	34
13	Dolný	30	36	60	34
14	Humenné	30	24	35	32
15	FK Rača	30	25	52	26
16	Dubnica	30	38	59	25

TEMPORADA 2021/2022

LIGA ESLOVAQUIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Trenčín	32	58	43	48
2	Liptovsky	32	42	57	40
3	Zemplin	32	32	42	40
4	Senica	32	29	51	34
5	Zlaté	32	33	50	30
6	Pohronie	32	27	59	18

TEMPORADA 2020/2021

LIGA ESLOVAQUIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sered	32	37	48	41
2	Ruzomberok	32	41	44	39
3	Pohronie	32	38	38	38
4	Zemplin	32	34	53	35
5	Senica	32	31	51	33
6	Nitra	32	26	55	27

TEMPORADA 2019/2020

LIGA ESLOVAQUIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Trenčín	5	13	8	39
2	Zlaté	5	5	5	33
3	Sered	5	6	7	27
4	Pohronie	5	6	6	26
5	Senica	5	2	7	26
6	Nitra	5	6	5	25

TEMPORADA 2018/2019

SEGUNDA ESLOVAQUIA
Equipo		PJ	GF	GC	Puntos
1	Pohronie	30	48	25	61
2	Poprad	30	52	36	58
3	Skalica	30	47	32	53
4	Liptovsky	30	56	41	50
5	MFK Dukla	30	49	35	46
6	Komárno	30	48	38	46
7	Dubnica	30	55	42	45
8	Petržalka	30	41	38	45
9	Žilina II	30	54	59	41
10	Bardejov	30	41	46	39
11	Lokomotíva	30	38	44	38
12	Šamorín	30	46	48	37
13	Slavoj	30	24	44	30
14	Inter	30	37	56	29
15	Tatran	30	30	41	27
16	Odeva Lipany	30	23	64	24

TEMPORADA 2017/2018

SEGUNDA ESLOVAQUIA
Equipo		PJ	GF	GC	Puntos
1	Sered	30	73	25	66
2	Skalica	30	46	27	62
3	Poprad	30	45	25	52
4	Lokomotíva	30	50	35	51
5	Žilina II	30	71	41	49
6	Komárno	30	49	58	43
7	Šamorín	30	38	34	42
8	Inter	30	45	46	41
9	Pohronie	30	41	35	38
10	Slavoj	30	27	44	37
11	Liptovsky	30	38	39	36
12	Bardejov	30	39	47	35
13	Nove Mesto.	30	33	57	32
14	Spišská	30	32	60	30
15	Lokomotiva	30	26	53	28
16	Podbrezová	30	24	51	26

TEMPORADA 2016/2017

SEGUNDA ESLOVAQUIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kosice	12	12	20	61
2	Nitra	12	23	6	59
3	Skalica	12	19	9	58
4	Šamorín	12	17	10	55
5	Žilina II	12	37	20	51
6	Sered	12	18	15	48
7	Lokomotíva	12	15	17	47
8	Pohronie	12	20	16	46
9	Bardejov	12	20	22	46
10	Liptovsky	12	15	19	45
11	Lokomotiva	12	12	22	35
12	Spišská	12	2	34	28

TEMPORADA 2015/2016

SEGUNDA ESLOVAQUIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tatran	10	15	8	58
2	Liptovsky	10	20	11	56
3	Kosice	10	12	8	56
4	Lokomotíva	10	22	12	54
5	Bardejov	10	19	10	53
6	Pohronie	12	9	15	51
7	Nitra	12	16	13	46
8	Žilina II	12	13	14	41
9	Lokomotiva	10	5	12	39
10	Sered	12	15	20	38
11	Slovan	12	8	31	31
12	Borčice	0	0	0	0

TEMPORADA 2014/2015

SEGUNDA ESLOVAQUIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Lokomotíva	10	21	10	46
2	Sobota	10	13	11	41
3	Dolný	10	15	7	40
4	Košice II	10	15	10	37
5	Bodva	10	13	15	33
6	Slavoj	10	6	30	20
7	Pohronie	10	24	10	58
8	Slovan	10	22	17	39
9	Spartak	10	17	14	34
10	Nove Mesto.	10	12	9	30
11	Šamorín	10	7	18	29
12	Dubnica	10	6	20	21

TEMPORADA 2013/2014

SEGUNDA ESLOVAQUIA
Equipo		PJ	GF	GC	Puntos
1	Podbrezová	33	64	16	82
2	Bardejov	33	49	25	61
3	Zemplin	33	55	28	61
4	Tatran	33	56	28	60
5	Senec	33	39	32	49
6	Spartak	33	57	64	39
7	Sobota	33	32	39	38
8	Dubnica	33	30	64	35
9	Pohronie	33	38	60	34
10	Slovan Duslo	33	30	45	32
11	ŠTK 1914	33	33	55	31
12	Liptovsky	33	25	52	28

TEMPORADA 2012/2013

TERCERA ESLOVAQUIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pohronie	30	50	24	60
2	Poprad	30	40	30	51
3	Lokomotíva	30	37	30	47
4	Slavoj	30	52	46	45
5	Odeva Lipany	30	38	32	44
6	Námestovo	30	42	34	43
7	Bodva	30	29	30	43
8	Dukla II	30	30	28	42
9	Košice II	30	47	51	42
10	Vranov	30	41	36	41
11	Kremnička	30	42	46	40
12	Futura	30	42	40	39
13	Fomat Martin	30	40	51	38
14	Tatran	30	38	50	36
15	Spišská	30	37	47	32
16	LAFC	30	25	55	28

Competiciones que juega

Segunda Eslovaquia

Pos	Equipos		Pts
1		Komárno	64
2		Tatran Prešov	57
3		FC Petržalka	54
4		Považská Bystrica	43
5		Humenné	43
6		Púchov	42
7		Žilina II	39
8		Spartak Myjava	36
9		Pohronie	35
10		Liptovsky Mikulas	33
11		Slavoj Trebišov	33
12		Slovan Bratislava II	32
13		Šamorín	31
14		Malženice	23
15		Dolný Kubín	17
16		Spišská Nová Ves	10

	Ascenso : Komárno
	Playoff Ascenso : Tatran Prešov
	Descenso : Dolný Kubín, Spišská Nová Ves

RIVALES EN Copa Eslovaquia

RIVALES EN Segunda Eslovaqu.

USO DE MEMORIA

6,193,216 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8254
Total Execution Time	0.8266

CADENA URL

/historico/Fk-Pohronie

GET DATOS

$_GET['/historico/Fk-Pohronie']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0156	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-Pohronie' 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.0145	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=13520 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=13520 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=13520 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144	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=13520 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293	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 = 72189
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13520 AND type_rel = 2
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=388 AND type_rel = 3
0.0145	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 388 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0145	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 (16697) ORDER BY n.cover_points DESC, update_date DESC
0.0150	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 = '13520' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '13520' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156	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 = 72674 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 72189 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	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=13520 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147	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 (72674,72189,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.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 72189 AND teamId = 13520
0.0175	SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 13520
0.0177	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13520
0.0160	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 = 72189 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146	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 = '13520' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13520' and rp.type = 4
0.0149	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 = '13520' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0166	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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 13520 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.0176	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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 13520 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0186	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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 13520 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0171	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 = 13520 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0164	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 = 72189 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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 = 68107 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.0162	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 = 63076 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159	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 = 66879 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 57377 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 61696 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 49878 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 55614 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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 = 44175 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 39124 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 33685 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 38660 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 15807 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 23886 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 4828 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 12479 AND t.round = 10 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* `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 = 2873 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 24452 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Pohronie

Pohronie

Selecciona un equipo

Competiciones que juega

Segunda Eslovaquia

RIVALES EN Copa Eslovaquia

RIVALES EN Segunda Eslovaqu.