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

FC Trinity Zlín

Entrenador: Bronislav Cervenka

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bohemians	30	29	40	35
2	Jablonec	30	35	45	30
3	Pardubice	30	29	42	28
4	Karviná	30	30	52	25
5	Trinity	30	36	61	25
6	České	30	34	62	24

TEMPORADA 2022/2023

LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Baník	35	53	50	42
2	Teplice	35	45	67	42
3	Jablonec	35	49	63	40
4	Pardubice	35	38	63	37
5	Trinity	35	43	60	34
6	Zbrojovka	35	41	64	33

TEMPORADA 2021/2022

LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pardubice	35	42	68	37
2	Trinity	35	43	60	36
3	Bohemians	35	45	61	34
4	Jablonec	35	27	48	34
5	Teplice	35	33	59	29
6	Karviná	35	33	63	19

TEMPORADA 2020/2021

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	34	85	20	86
2	Sparta Praha	34	82	43	74
3	Jablonec	34	59	33	69
4	Slovácko	34	58	33	63
5	Viktoria	34	60	45	58
6	Slovan	34	44	32	52
7	Pardubice	34	41	42	52
8	Baník	34	48	38	49
9	Sigma	34	40	40	45
10	Bohemians	34	40	37	43
11	Mladá	34	49	54	39
12	Karviná	34	37	49	39
13	České	34	33	47	38
14	Trinity	34	30	50	32
15	Teplice	34	34	66	30
16	Zbrojovka	34	33	57	26
17	Pribram	34	26	65	25
18	SFC Opava	34	23	71	17

TEMPORADA 2019/2020

LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sigma	3	3	3	40
2	Teplice	3	8	2	38
3	Trinity	3	5	5	33
4	Karviná	3	2	7	27
5	Pribram	3	2	1	25
6	SFC Opava	3	1	3	25

TEMPORADA 2018/2019

LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	30	72	23	72
2	Viktoria	30	47	27	68
3	Sparta Praha	30	52	27	57
4	Jablonec	30	53	26	51
5	Baník	30	38	36	45
6	Mladá	30	52	44	42
7	Slovan	30	33	28	42
8	Sigma	30	37	43	40
9	Trinity	30	32	40	39
10	Teplice	30	32	42	36
11	Bohemians	30	29	37	34
12	Slovácko	30	32	45	34
13	SFC Opava	30	39	49	33
14	Pribram	30	33	63	31
15	Karviná	30	39	53	29
16	Dukla Praha	30	25	62	20

TEMPORADA 2017/2018

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	55	23	66
2	Slavia Praha	30	50	19	59
3	Jablonec	30	49	27	56
4	Sigma	30	41	22	55
5	Sparta Praha	30	43	25	53
6	Slovan	30	37	35	46
7	Bohemians	30	30	29	38
8	Mladá	30	31	43	34
9	Teplice	30	32	40	34
10	Trinity	30	31	48	33
11	Dukla Praha	30	32	55	32
12	Slovácko	30	23	32	31
13	Baník	30	36	43	31
14	Karviná	30	32	40	30
15	Vysocina	30	30	48	30
16	Zbrojovka	30	20	43	24

TEMPORADA 2016/2017

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	30	65	22	69
2	Viktoria	30	47	21	67
3	Sparta Praha	30	47	26	57
4	Mladá	30	47	37	49
5	Teplice	30	38	25	48
6	Trinity	30	34	35	41
7	Dukla Praha	30	39	35	40
8	Jablonec	30	43	38	39
9	Slovan	30	31	28	39
10	Karviná	30	39	49	34
11	Slovácko	30	29	38	32
12	Zbrojovka	30	32	45	32
13	Bohemians	30	22	39	28
14	Vysocina	30	26	47	27
15	Hradec	30	29	51	27
16	Pribram	30	29	61	22

TEMPORADA 2015/2016

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	57	25	71
2	Sparta Praha	30	61	24	64
3	Slovan	30	51	35	58
4	Mladá	30	63	37	57
5	Slavia Praha	30	48	26	52
6	Zbrojovka	30	37	38	47
7	Jablonec	30	46	39	41
8	Slovácko	30	37	51	40
9	Bohemians	30	35	37	37
10	Dukla Praha	30	44	41	35
11	Vysocina	30	31	54	31
12	Teplice	30	37	52	30
13	Trinity	30	34	50	30
14	Sigma	30	35	49	27
15	Pribram	30	33	53	27
16	Baník	30	27	65	14

TEMPORADA 2014/2015

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sigma	30	64	25	63
2	Varnsdorf	30	47	27	59
3	Viktoria	30	50	23	55
4	Trinity	30	53	32	55
5	Baník	30	44	39	48
6	Táborsko	30	55	42	47
7	Karviná	30	39	31	46
8	Pardubice	30	37	34	45
9	SFC Opava	30	36	35	42
10	Vlašim	30	36	50	39
11	Znojmo	30	37	43	38
12	Viagem	30	34	46	34
13	Třinec	30	33	51	30
14	Frýdek-Mís	30	28	41	28
15	Mostecký	30	25	51	21
16	FK Kolín	30	26	74	15

TEMPORADA 2013/2014

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	České	30	57	20	62
2	Hradec	30	54	27	61
3	Táborsko	30	46	27	59
4	Varnsdorf	30	42	31	47
5	Viktoria	30	39	30	47
6	Baník	30	33	37	46
7	Karviná	30	46	37	45
8	Viagem	30	38	37	43
9	Třinec	30	37	44	39
10	Trinity	30	33	30	37
11	Mostecký	30	34	46	37
12	Vlašim	30	29	46	36
13	Pardubice	30	30	34	34
14	Frýdek-Mís	30	33	40	34
15	Bohemians	30	30	66	22
16	Loko Vltavin	30	25	54	20

TEMPORADA 2012/2013

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Bohemians	31	51	25	59
2	Znojmo	30	45	24	58
3	Baník	30	36	26	50
4	HFK Olomouc	30	41	44	50
5	Varnsdorf	30	49	37	49
6	Trinity	30	49	37	48
7	Pardubice	30	47	31	46
8	Viktoria	30	38	30	45
9	Karviná	30	43	43	42
10	Viagem	30	32	42	39
11	Bohemians	30	30	33	35
12	Táborsko	30	35	42	34
13	Mostecký	30	33	48	31
14	Vlašim	30	37	58	31
15	FK Caslav	30	24	43	25
16	SFC Opava	30	34	60	21
17	Pardubice	1	0	1	0

TEMPORADA 2011/2012

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viagem	30	52	35	61
2	Vysocina	30	45	29	55
3	Baník	30	43	31	52
4	Zbrojovka	30	37	29	49
5	Bohemians	30	43	31	48
6	Karviná	30	36	35	43
7	Varnsdorf	30	33	34	42
8	SFC Opava	30	46	36	41
9	Mostecký	30	31	44	38
10	Vlašim	30	36	38	36
11	Trinity	30	28	36	36
12	Znojmo	30	28	35	34
13	FK Caslav	30	27	39	34
14	Táborsko	30	37	51	34
15	Třinec	30	31	41	30
16	Sparta Praha	30	37	46	27

TEMPORADA 2010/2011

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Dukla Praha	30	55	18	63
2	Viktoria	30	44	31	55
3	Vysocina	30	49	29	53
4	Karviná	30	42	36	46
5	Třinec	30	32	34	44
6	Baník	30	53	51	43
7	Vlašim	30	38	32	42
8	FK Caslav	30	37	48	41
9	Táborsko	30	42	40	40
10	Sparta Praha	30	35	47	39
11	Trinity	30	46	45	38
12	Varnsdorf	30	33	38	37
13	Mostecký	30	35	46	37
14	Znojmo	30	30	40	36
15	SK Kladno	30	42	48	31
16	Hlučín	30	36	66	21

TEMPORADA 2009/2010

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Hradec	30	47	18	68
2	Viagem	30	52	27	65
3	Trinity	30	48	35	54
4	Vysocina	30	57	37	52
5	Viktoria	30	42	41	46
6	Dukla Praha	30	45	41	44
7	Vlašim	30	40	41	40
8	Karviná	30	44	36	39
9	Třinec	30	34	38	38
10	Mostecký	30	37	37	37
11	Baník	30	37	43	37
12	SFC Opava	30	30	37	29
13	Hlučín	30	27	43	29
14	Sparta Praha	30	33	50	29
15	FK Caslav	30	28	49	29
16	Vitkovice	30	23	51	18

TEMPORADA 2008/2009

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	30	57	25	62
2	Sparta Praha	30	48	25	56
3	Slovan	30	41	28	52
4	Sigma	30	39	36	48
5	Jablonec	30	43	37	46
6	Mladá	30	39	38	46
7	Teplice	30	33	25	43
8	Viktoria	30	45	38	43
9	Baník	30	38	36	39
10	České	30	30	37	36
11	Zbrojovka	30	32	36	35
12	Pribram	30	30	40	34
13	Bohemians	30	33	46	34
14	SK Kladno	30	21	41	31
15	Trinity	30	26	49	29
16	Viktoria	30	27	45	22

Competiciones que juega

Grupo 1

Liga Checa Grupo 3

Pos	Equipos		Pts
1		Bohemians 1905	35
2		Jablonec	30
3		Pardubice	28
4		Karviná	25
5		FC Trinity Zlín	25
6		České Budějovice	24

	Playoff Descenso : Karviná, FC Trinity Zlín
	Descenso : České Budějovice

RIVALES EN Copa Checa

RIVALES EN Liga Checa

USO DE MEMORIA

6,860,408 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1823
Total Execution Time	0.1836

CADENA URL

/historico/Zlin

GET DATOS

$_GET['/historico/Zlin']

POST DATOS

No hay datos POST existentes

CONSULTAS (53)

0.0067	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 = 'Zlin' 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.0022	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=13174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=13174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=13174 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=13174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=13174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=13174 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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 = 75934
0.0038	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 = 72209
0.0035	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 = 74938
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13174 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13174 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0027	SELECT /35 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 (141883,235690,281721,314834) ORDER BY n.cover_points DESC, update_date DESC
0.0039	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 = '13174' ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '13174' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0042	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 = '13174' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 75934 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034	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=13174 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 (75934,74938,72506,71877,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 75934 AND teamId = 13174
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 13174
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71877 AND teamId = 13174
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13174
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 74938 AND teamId = 13174
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 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 = 75934 AND t.round = 1 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 = '13174' 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 = '13174' 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 = '13174' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 75934 WHERE rp.league_id = 75934 AND rp.teamId = 13174 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 events2024 e ON e.player_id = p.id AND e.league_id = 75934 WHERE rp.league_id = 75934 AND rp.teamId = 13174 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 = 75934 WHERE rp.league_id = 75934 AND rp.teamId = 13174 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 13174 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72209 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.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* `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 = 75934 AND t.round = 1 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 = 68036 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.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* `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 = 71576 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* `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 = 63006 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 = 67403 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.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 = 58011 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.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 = 49964 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.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* `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 = 56779 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 = 43592 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 38696 AND t.round = 30 ORDER BY team.conference 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* `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 = 33331 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 15408 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 3884 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 2835 AND t.round = 30 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* `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 = 8760 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* `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 = 8761 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 8762 AND t.round = 30 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* `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 = 8763 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 243 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 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 = 75934 ORDER BY nameShow LIMIT 100

FC Trinity Zlín

FC Trinity Zlín

Selecciona un equipo

Competiciones que juega

Liga Checa Grupo 3

RIVALES EN Copa Checa

RIVALES EN Liga Checa