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

FK Kolín

Temporada 2023/2024

TEMPORADA 2023/2024

3. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Velvary	24	49	17	55
2	Sokol Zápy	24	49	24	48
3	Viagem	24	43	29	46
4	Banik Most.	24	36	23	42
5	Sokol	24	34	27	40
6	Jablonec II	24	32	33	33
7	FK Kolín	24	35	37	33
8	Slovan	24	36	32	32
9	Chlumec	24	39	44	30
10	Pardubice	24	37	45	29
11	Sokol	24	32	38	26
12	Ceská Lípa	24	27	40	26
13	Hradec	24	32	50	25
14	Mladá	24	33	35	22
15	Prepere	24	27	48	20
16	Teplice II	24	26	45	19

TEMPORADA 2022/2023

3. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	66	19	72
2	Velvary	30	59	32	60
3	Sokol	30	43	30	54
4	FK Kolín	30	53	50	50
5	Chlumec	30	44	42	47
6	Sokol Zápy	30	46	37	44
7	Mladá	30	43	38	40
8	Teplice II	30	57	60	40
9	Hradec	30	27	43	37
10	Baník Souš	30	38	46	36
11	Jablonec II	30	44	45	32
12	Sokol	30	46	48	32
13	Viagem	30	45	68	32
14	Pardubice	30	33	42	31
15	Prepere	30	36	59	29
16	Benešov	30	33	54	26

TEMPORADA 2021/2022

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FK Kolín	30	96	35	79
2	Vysoké	30	81	32	63
3	Velke Hamry	30	75	39	57
4	Kosmonosy	30	70	55	48
5	FK Caslav	30	56	49	48
6	Benátky	30	62	32	46
7	Letohrad	30	48	46	41
8	Trutnov	30	40	55	40
9	Sokol Libiš	30	55	67	38
10	Dvůr	30	41	50	34
11	Hlinsko	30	41	54	34
12	Náchod	30	28	55	34
13	Tochovice	30	53	73	30
14	Poříčany	30	38	71	30
15	Horky	30	38	65	26
16	Kutna Hora	30	41	85	26

TEMPORADA 2020/2021

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FK Kolín	8	36	7	22
2	Náchod	8	31	9	21
3	Vysoké	8	21	8	19
4	Velke Hamry	8	19	9	19
5	Kosmonosy	8	23	22	15
6	Benátky	8	23	17	13
7	Poříčany	8	12	10	11
8	Hlinsko	8	7	12	10
9	Dvůr	8	15	14	9
10	FK Caslav	8	15	18	9
11	Letohrad	8	11	16	8
12	Trutnov	8	14	17	7
13	Kutna Hora	8	12	37	6
14	Horky	7	13	19	5
15	Sokol Libiš	7	8	22	3
16	Polaban	8	6	29	3

TEMPORADA 2019/2020

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Vysoké	16	42	16	40
2	Benátky	16	33	17	37
3	Náchod	16	39	14	34
4	Dvůr	16	36	24	28
5	FK Kolín	16	29	18	27
6	Trutnov	16	24	35	24
7	Velke Hamry	16	29	22	23
8	Letohrad	16	24	24	22
9	Horky	16	25	33	22
10	Hlinsko	16	27	24	21
11	Ostrá	16	25	23	21
12	FK Caslav	16	27	35	18
13	Sokol Libiš	16	22	30	16
14	Kutna Hora	16	17	35	14
15	Poříčany	16	20	41	12
16	Polaban	16	13	41	10

TEMPORADA 2018/2019

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Jiskra	28	79	29	60
2	Prepere	28	62	42	49
3	Pardubice	28	48	34	46
4	Benátky	28	46	40	44
5	Velke Hamry	28	59	66	43
6	Český Brod	28	43	35	41
7	Dvůr	28	38	36	40
8	FK Kolín	28	41	35	39
9	Vysoké	27	44	41	38
10	Trutnov	28	52	56	38
11	FK Caslav	28	42	42	36
12	Spartak	27	46	55	35
13	Horky	28	40	53	31
14	Náchod	28	36	65	29
15	Pěnčín-Tu	28	30	77	18
16	Olympia	0	0	0	0

TEMPORADA 2017/2018

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sokol	15	34	14	38
2	Vysoké	15	33	20	28
3	Jiskra	15	36	25	28
4	FK Kolín	15	28	23	25
5	FK Zbuzany	15	38	30	21
6	Brandýs	15	34	30	21
7	Admira Praha	15	27	28	21
8	Sokol	15	30	33	21
9	Pardubice	15	22	24	20
10	FK Caslav	15	33	36	20
11	Spartak	15	36	41	19
12	Dvůr	15	19	20	18
13	Pěnčín-Tu	15	34	39	16
14	Trutnov	15	23	33	16
15	Cechy Vykan	15	29	37	15
16	Letohrad	15	16	39	8

TEMPORADA 2016/2017

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ústí	30	56	20	67
2	Sokol	30	76	33	60
3	Vysoké	30	52	27	56
4	FK Caslav	30	65	35	55
5	FK Kolín	30	49	31	53
6	Ostrá	30	41	30	42
7	Pěnčín-Tu	30	58	61	42
8	Letohrad	30	35	39	41
9	Pardubice	30	54	55	40
10	Dvůr	30	41	48	40
11	Spartak	30	58	65	37
12	Sokol	30	50	49	36
13	Trutnov	30	49	60	36
14	Přední	30	37	71	26
15	Kutna Hora	30	23	58	25
16	Náchod	30	34	96	11

TEMPORADA 2015/2016

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sokol Zápy	36	69	36	83
2	Viktorie	36	71	44	79
3	Viktoria	36	89	35	78
4	Loko Vltavin	36	84	43	75
5	Chrudim	36	85	37	73
6	Jiskra	36	67	56	63
7	Králův	36	59	48	61
8	Dobrovice	36	76	56	59
9	Písek	36	54	48	59
10	Převýšov	36	63	53	52
11	Tachov	36	63	65	50
12	Benátky	36	48	65	48
13	Benešov	36	51	67	46
14	Táborsko	36	49	76	44
15	Povltavská	36	43	53	42
16	FK Kolín	36	45	58	41
17	Mostecký	36	29	87	19
18	FK Caslav	36	26	90	16
19	Sokol	36	32	86	15
20	Union Nový	0	0	0	0

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

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Viktorie	32	56	36	61
2	FK Kolín	32	54	30	60
3	Sparta Praha	32	54	38	55
4	Chrudim	32	60	44	53
5	Chomutov	32	60	45	52
6	FK Caslav	32	50	42	51
7	Králův	32	46	47	51
8	Jiskra	32	49	42	49
9	Povltavská	32	42	35	47
10	Admira Praha	32	51	45	46
11	Sokol Zápy	32	55	44	45
12	Meteor Praha	32	49	60	44
13	Převýšov	32	56	43	43
14	Roudnice	32	53	49	40
15	Karlovy Vary	32	47	64	34
16	FK Kunice	32	44	65	34
17	Horní	32	29	66	24
18	Strakonice	32	27	87	12

TEMPORADA 2012/2013

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Loko Vltavin	34	59	37	71
2	FK Kolín	34	63	38	66
3	FK Kunice	34	63	46	62
4	Jiskra	34	81	52	59
5	Roudnice	34	69	50	58
6	Sparta Praha	34	60	35	56
7	Chrudim	34	58	43	52
8	Chomutov	34	59	45	50
9	Sokol Zápy	34	41	36	49
10	Ceská Lípa	34	58	52	48
11	Převýšov	34	43	38	47
12	Karlovy Vary	34	53	59	42
13	Horní	34	48	61	41
14	Králův	34	54	62	40
15	Strakonice	34	38	48	40
16	SK Kladno	34	42	51	38
17	Písek	34	36	65	24
18	Hlavice	34	27	134	7

TEMPORADA 2011/2012

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FK Kolín	30	72	18	73
2	Převýšov	30	70	33	61
3	Velim	30	53	40	57
4	Ústí	30	63	43	49
5	Dvůr	30	66	51	45
6	Jiskra	30	54	44	44
7	Hradec	30	43	38	44
8	Pěnčín-Tu	30	42	44	41
9	Polepy	30	54	69	40
10	Pardubice	30	51	48	39
11	Admira Praha	30	42	55	37
12	Jablonec II	30	54	63	36
13	Nová Paka	30	41	49	35
14	Náchod	30	39	53	34
15	Union Nový	30	28	68	23
16	Trutnov	30	18	74	12

TEMPORADA 2010/2011

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Letohrad	28	61	22	64
2	Chrudim	28	64	28	59
3	Velim	28	47	40	51
4	Hradec	28	50	28	48
5	FK Kolín	28	44	27	45
6	Náchod	28	47	38	39
7	Horní	28	41	36	37
8	Ústí	28	41	38	37
9	Trutnov	28	57	51	36
10	Union Nový	28	33	51	36
11	Dvůr	28	40	39	35
12	Pěnčín-Tu	28	39	52	35
13	Nová Paka	28	29	47	35
14	Semily	28	33	68	20
15	Jicín	28	12	73	10

TEMPORADA 2008/2009

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sokol Ovcary	30	57	24	60
2	Hradec	30	45	34	52
3	Chrudim	30	46	41	50
4	Union Nový	30	37	30	49
5	Dvůr	30	46	51	47
6	Bohemians	30	40	39	46
7	FK Kunice	30	54	38	44
8	FK Kolín	30	51	47	44
9	Sokol	30	38	34	43
10	Horní	30	36	32	43
11	Pardubice	30	37	31	41
12	Pěnčín-Tu	30	35	29	41
13	Velim	30	41	47	36
14	Převýšov	30	30	44	36
15	Týnište	30	28	41	28
16	SK Holice	30	22	81	9

TEMPORADA 2007/2008

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	34	61	22	72
2	Vlašim	34	69	40	66
3	Táborsko	33	51	45	64
4	Mladá	34	47	33	58
5	Karlovy Vary	34	55	41	57
6	Varnsdorf	34	46	35	56
7	České	34	46	37	50
8	Jablonec II	34	59	56	48
9	Viktoria	34	45	41	45
10	Slovan	33	55	52	44
11	Náchod	34	47	53	43
12	Slavoj	34	43	45	42
13	Letohrad	34	39	48	42
14	Slavia Praha	34	41	36	41
15	Hvězda Cheb	34	32	40	41
16	FK Kolín	34	31	47	36
17	Příbram	34	37	63	27
18	Chmel	34	25	95	16

TEMPORADA 2006/2007

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bohemians	34	69	26	71
2	Sparta Krč	34	47	37	59
3	Varnsdorf	34	43	26	56
4	Slavia Praha	34	45	28	55
5	FK Kolín	34	40	27	55
6	Sparta Praha	34	50	29	54
7	Karlovy Vary	34	55	47	54
8	České	34	37	35	50
9	Příbram	34	40	44	49
10	Hvězda Cheb	34	38	44	49
11	Tatran	34	29	37	43
12	Náchod	34	40	54	42
13	Jablonec II	34	46	49	38
14	Sokol Ovcary	34	32	53	37
15	Mladá	34	43	46	36
16	Viktoria	34	40	51	36
17	Hradec	34	29	48	35
18	Teplice II	34	27	69	27

TEMPORADA 2005/2006

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FK Kolín	30	63	15	66
2	Velim	30	56	36	54
3	Dobrovice	30	47	28	52
4	Letohrad	30	41	26	51
5	Dvůr	30	39	28	50
6	Predmerice	30	45	48	44
7	Chrudim	30	29	32	42
8	Kacov	30	44	45	41
9	Ústí	30	33	39	38
10	Agria Chocen	30	39	29	37
11	Pardubice	30	31	30	36
12	Hlavice	30	23	34	34
13	Týnište	30	42	56	34
14	Pardubice	30	36	54	33
15	SK Skalice	30	34	54	33
16	Svitavy	30	24	72	13

TEMPORADA 2004/2005

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Slovan	30	42	30	56
2	Xaverov	30	38	26	53
3	FK Caslav	30	44	29	51
4	Náchod	30	49	34	48
5	Hradec	31	34	30	42
6	Varnsdorf	30	47	49	42
7	Bohemians	30	35	40	41
8	Strakonice	31	30	43	40
9	Příbram	31	36	39	39
10	Slavia Praha	30	37	38	38
11	Chomutov	29	39	41	38
12	FK Kolín	30	35	41	38
13	České	31	38	34	36
14	Brevnov	30	26	32	36
15	Baník Most	30	43	51	36
16	Karlovy Vary	29	44	52	35
17	Letohrad	30	34	42	35

TEMPORADA 2003/2004

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Viagem	34	62	22	70
2	Náchod	34	58	48	54
3	Brevnov	34	35	35	51
4	Bohemians	34	44	52	49
5	Slavia Praha	34	42	33	48
6	Varnsdorf	34	50	52	48
7	Hradec	34	45	35	47
8	Chomutov	34	50	47	47
9	Karlovy Vary	34	42	51	46
10	České	34	54	55	45
11	Letohrad	34	42	45	43
12	FK Kolín	34	40	49	43
13	Semily	34	31	44	43
14	Příbram	34	54	52	42
15	Slovan	34	39	43	42
16	Chrudim	34	41	44	41
17	Teplice II	34	38	41	39
18	Sparta Krč	34	36	55	32

Competiciones que juega

Grupo 3

3. Liga Checa Grupo 3

Pos	Equipos		Pts
1		Velvary	55
2		Sokol Zápy	48
3		FK Viagem Ústí nad Labem	46
4		Banik Most - Sous	42
5		Sokol Brozany	40
6		Jablonec II	33
7		FK Kolín	33
8		Slovan Liberec II	32
9		Chlumec nad Cidlinou	30
10		FK Pardubice II	29
11		Sokol Živanice	26
12		Ceská Lípa	26
13		Hradec Králové II	25
14		Mladá Boleslav II	22
15		Prepere	20
16		Teplice II	19

	Ascenso : Velvary
	Descenso : Prepere, Teplice II

RIVALES EN 3. Liga Checa

RIVALES EN Copa Checa

USO DE MEMORIA

7,828,368 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Home / Category )	0.6989
Total Execution Time	0.7005

CADENA URL

/historico/Fk-Kolin

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0141	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-Kolin' 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.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=18068 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=18068 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=18068 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=18068 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18068 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1524 AND type_rel = 3
0.0135	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 = '18068' ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '18068' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0138	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 = '18068' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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=18068 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (72506,72396,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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 72396 AND teamId = 18068
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 18068
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18068
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 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 = 72396 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0131	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 = '18068' 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 = '18068' 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 = '18068' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137	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 = 72396 WHERE rp.league_id = 72396 AND rp.teamId = 18068 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.0148	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 = 72396 WHERE rp.league_id = 72396 AND rp.teamId = 18068 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 72396 WHERE rp.league_id = 72396 AND rp.teamId = 18068 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 = 18068 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72396 AND t.round = 24 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* `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 = 68187 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.0145	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 = 63520 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.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* `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 = 57124 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 50443 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 44436 AND t.round = 30 ORDER BY team.conference 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* `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 = 39717 AND t.round = 15 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* `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 = 33442 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 15611 AND t.round = 38 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* `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.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* `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 = 33761 AND t.round = 32 ORDER BY team.conference 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* `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 = 24660 AND t.round = 34 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 = 25122 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* `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 = 25108 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 25138 AND t.round = 30 ORDER BY team.conference 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* `tables2008` 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 = 24515 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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* `tables2007` 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 = 24506 AND t.round = 34 ORDER BY team.conference 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* `tables2006` 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 = 27593 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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* `tables2005` 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 = 24492 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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* `tables2004` 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 = 24482 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

FK Kolín

FK Kolín

Selecciona un equipo

Competiciones que juega

3. Liga Checa Grupo 3

RIVALES EN 3. Liga Checa

RIVALES EN Copa Checa