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

Tallya KSE

Temporada 2021/2022

TEMPORADA 2021/2022

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kazincbarcik	38	106	24	101
2	Debreceni	38	93	31	83
3	BKV Előre	38	64	45	74
4	Hajdúszobos	38	74	39	70
5	Tiszaújvár	38	79	54	69
6	Kisvárda	38	67	47	65
7	Sényő	38	66	59	62
8	Putnok VSE	38	66	48	59
9	Újpest	38	67	53	57
10	Füzesgyarma	38	49	53	51
11	Bekescsaba	38	82	75	50
12	Diósgyőr	38	73	71	50
13	Tiszafuredi	38	57	60	47
14	Debreceni	38	63	67	45
15	Eger	38	47	66	44
16	Jászberény	38	44	71	35
17	Salgótarjá	38	38	65	31
18	Hidasnémeti	38	39	109	27
19	Törökszent	38	36	93	21
20	Tallya KSE	38	27	107	21

TEMPORADA 2020/2021

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tiszakécske	38	94	27	94
2	Budapest	38	75	39	78
3	Jászberény	38	78	41	73
4	Füzesgyarma	38	70	44	72
5	Kisvárda	38	57	45	68
6	Eger	38	62	36	66
7	Balassagyarm	38	46	32	64
8	Sényő	38	65	58	57
9	Diósgyőr	38	65	57	54
10	Cegledi	38	45	47	50
11	Tiszafuredi	38	59	68	48
12	Tiszaújvár	38	51	62	48
13	Debreceni	38	58	59	46
14	Tallya KSE	38	52	57	43
15	Putnok VSE	38	57	75	42
16	Salgótarjá	38	54	76	41
17	Gyöngyös	38	54	80	39
18	FC Hatvan	38	46	64	38
19	Sajóbábony	38	41	102	24
20	Mezőkövesd	38	43	103	20

TEMPORADA 2019/2020

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Debreceni	17	45	20	38
2	Füzesgyarma	18	30	18	38
3	Cegledi	18	36	24	36
4	Sényő	17	37	28	32
5	ESMTK	18	29	20	31
6	Jászberény	18	37	31	29
7	Tiszaújvár	18	30	27	26
8	Putnok VSE	18	27	25	25
9	Balassagyarm	18	27	28	24
10	Eger	18	19	31	20
11	Gyöngyös	18	28	36	20
12	Tallya KSE	17	20	25	18
13	Debreceni	18	29	36	16
14	FC Hatvan	17	16	33	10
15	Diósgyőr	18	19	47	8
16	Ózdi FC	0	0	0	0

TEMPORADA 2018/2019

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Szolnoki	30	61	31	65
2	Jászberény	30	75	31	64
3	ESMTK	30	50	28	60
4	Füzesgyarma	30	65	32	55
5	Sényő	30	56	46	49
6	Putnok VSE	30	49	50	49
7	Tiszaújvár	30	54	37	48
8	Nyírbátori	30	39	39	46
9	Debreceni	30	57	58	44
10	Eger	30	33	43	36
11	Gyöngyös	30	40	52	30
12	Diósgyőr	30	36	59	30
13	Tallya KSE	30	27	47	29
14	Salgótarjá	30	33	60	29
15	Sajóbábony	30	33	67	25
16	Cigánd SE	30	30	58	22

TEMPORADA 2017/2018

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Monori SE	28	77	18	76
2	ESMTK	28	37	24	50
3	Putnok VSE	28	46	40	46
4	Tiszaújvár	28	43	40	43
5	Jászberény	28	36	35	38
6	Diósgyőr	28	41	34	38
7	Nyírbátori	28	47	42	37
8	Füzesgyarma	28	38	39	36
9	Gyöngyös	28	41	45	36
10	Cigánd SE	28	41	51	35
11	Budapest	28	45	40	34
12	Debreceni	28	42	57	34
13	Tallya KSE	28	32	49	29
14	Balassagyarm	28	33	59	25
15	Tiszafuredi	28	32	58	24
16	Salgótarjá	0	0	0	0

TEMPORADA 2016/2017

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kazincbarcik	34	88	33	79
2	Monori SE	34	53	34	66
3	Jászberény	34	63	33	65
4	Budapest	34	64	37	56
5	Diósgyőr	34	53	49	50
6	Putnok VSE	34	46	49	49
7	Tallya KSE	34	53	58	49
8	Rákosmenti	34	69	54	48
9	Salgótarjá	34	56	45	48
10	ESMTK	34	41	45	47
11	Nyírbátori	34	51	42	46
12	BKV Előre	34	57	58	45
13	Tiszaújvár	34	38	40	45
14	Debreceni	34	49	50	42
15	FC Hatvan	34	48	50	40
16	REAC	34	42	55	40
17	Hajdúbösz�	34	33	72	29
18	Újpest	34	24	124	6

TEMPORADA 2015/2016

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Nyíregyház	32	74	19	83
2	Cegledi	32	62	25	76
3	Cigánd SE	32	82	40	66
4	Putnok VSE	32	58	37	59
5	Kazincbarcik	32	56	32	55
6	FC Hatvan	32	48	36	55
7	Rákosmenti	32	70	48	51
8	Jászberény	32	57	45	43
9	Somos SE	32	37	50	41
10	Újpest	32	34	62	41
11	Debreceni	32	46	48	39
12	Diósgyőr	32	38	48	37
13	Tallya KSE	32	31	54	25
14	Tiszaújvár	32	24	52	25
15	Nyírbátori	32	30	68	25
16	REAC	32	36	73	24
17	Felsőtárk�	32	28	74	21

Competiciones que juega

Tercera Hungría Grupo 1

Pos	Equipos		Pts
1		Kazincbarcika	101
2		Debreceni EAC	83
3		BKV Előre	74
4		Hajdúszoboszlói SE	70
5		Tiszaújváros	69
6		Kisvárda II	65
7		Sényő Carnifex	62
8		Putnok VSE	59
9		Újpest FC II	57
10		Füzesgyarmati	51
11		Bekescsaba B	50
12		Diósgyőr VTK II	50
13		Tiszafuredi	47
14		Debreceni VSC II	45
15		Eger	44
16		Jászberényi Vasas	35
17		Salgótarjáni BTC	31
18		Hidasnémeti VSC	27
19		Törökszentmiklós	21
20		Tallya KSE	21

	Ascenso : Kazincbarcika
	Descenso : Salgótarjáni BTC, Hidasnémeti VSC, Törökszentmiklós, Tallya KSE

RIVALES EN Copa Hungría

RIVALES EN Tercera Hungría

USO DE MEMORIA

5,910,096 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.1542
Total Execution Time	0.1557

CADENA URL

/historico/Tallya-Kse

GET DATOS

$_GET['/historico/Tallya-Kse']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0025	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 = 'Tallya-Kse' 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.0050	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 = 'Tallya-Kse' 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=65986 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=65986 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=65986 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=65986 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=65986 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=65986 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=65986 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=65986 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=65986 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=65986 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=65986 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=65986 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=65986 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=65986 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=65986 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=65986 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=65986 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0030	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 = 63660
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65986 AND type_rel = 2
0.0027	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 = '65986' ORDER BY l.year DESC,cat.coefficient 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 = '65986' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '65986' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030	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 = '65986' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028	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 = 63660 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 63554 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029	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=65986 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (68494,63554,62807) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 63554 AND teamId = 65986
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 68494 AND teamId = 65986
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 65986
0.0024	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 = '65986' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65986' and rp.type = 4
0.0020	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 = '65986' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023	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 events2022 e ON e.player_id = p.id AND e.league_id = 63554 WHERE rp.league_id = 63554 AND rp.teamId = 65986 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.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 events2022 e ON e.player_id = p.id AND e.league_id = 63554 WHERE rp.league_id = 63554 AND rp.teamId = 65986 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2022 e ON e.player_id = p.id AND e.league_id = 63554 WHERE rp.league_id = 63554 AND rp.teamId = 65986 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 65986 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 63554 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.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* `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 = 57109 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.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* `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 = 50572 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.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* `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 = 44610 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 = 39609 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* `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 = 33938 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* `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 = 15966 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Tallya KSE

Tallya KSE

Selecciona un equipo

Competiciones que juega

Tercera Hungría Grupo 1

RIVALES EN Copa Hungría

RIVALES EN Tercera Hungría