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

Pohronie

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA ESLOVAQUIA
Equipo		PJ	GF	GC	Puntos
1	Komárno	27	57	21	64
2	Tatran	27	50	19	59
3	Petržalka	27	57	27	57
4	Považská	27	46	33	46
5	Humenné	27	39	30	44
6	Púchov	27	47	45	42
7	Žilina II	27	54	54	39
8	Spartak	27	38	39	39
9	Pohronie	27	40	46	35
10	Liptovsky	27	45	47	33
11	Slovan	27	40	50	32
12	Slavoj	27	32	44	32
13	Šamorín	27	43	53	31
14	Malženice	27	33	45	24
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	59
3		FC Petržalka	57
4		Považská Bystrica	46
5		Humenné	44
6		Púchov	42
7		Žilina II	39
8		Spartak Myjava	39
9		Pohronie	35
10		Liptovsky Mikulas	33
11		Slovan Bratislava II	32
12		Slavoj Trebišov	32
13		Šamorín	31
14		Malženice	24
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,215,856 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1395
Total Execution Time	0.1414

CADENA URL

/historico/Fk-Pohronie

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0043	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.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=13520 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=13520 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=13520 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=13520 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13520 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=388 AND type_rel = 3
0.0020	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.0020	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.0025	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' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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.0022	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.0023	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.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 (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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72189 AND teamId = 13520
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 13520
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13520
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 = '13520' 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 = '13520' 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 = '13520' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0048	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.0031	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.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 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.0025	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.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* `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.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* `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.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* `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.0020	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.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* `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.0020	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.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* `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.0020	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.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 = 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.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* `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.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 = 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.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 = 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.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 = 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.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 = 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.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* `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.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* `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.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 = 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.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 = 24452 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿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

Pohronie

Pohronie

Selecciona un equipo

Competiciones que juega

Segunda Eslovaquia

RIVALES EN Copa Eslovaquia

RIVALES EN Segunda Eslovaqu.