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

Pardubice

Entrenador: Radoslav Kovac

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bohemians	31	30	42	35
2	Jablonec	31	38	47	33
3	Pardubice	31	31	42	31
4	České	31	36	63	27
5	Karviná	31	32	55	25
6	Trinity	31	36	63	25

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	Jablonec	35	27	48	34
4	Bohemians	35	45	61	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

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Zbrojovka	30	75	29	67
2	Pardubice	29	54	19	67
3	Dukla Praha	30	62	40	59
4	Hradec	30	54	29	54
5	Vysocina	30	59	46	49
6	Viktoria	30	45	40	49
7	Viagem	30	46	47	41
8	SK Líšeň	30	49	47	36
9	Chrudim	30	44	61	36
10	Prostějov	30	33	42	35
11	Vlašim	29	30	42	34
12	Slavoj	30	40	55	33
13	Třinec	28	39	52	31
14	Baník	30	34	51	26
15	Varnsdorf	30	37	65	26
16	Vitkovice	30	35	71	17

TEMPORADA 2018/2019

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	České	30	60	24	72
2	Vysocina	30	50	33	58
3	Zbrojovka	30	63	31	57
4	Hradec	30	36	18	53
5	Viagem	30	44	39	49
6	Varnsdorf	30	33	26	48
7	Pardubice	30	45	34	44
8	Vitkovice	30	32	44	40
9	Třinec	30	36	42	36
10	Prostějov	30	28	37	36
11	Baník	30	28	40	33
12	Vlašim	30	30	38	32
13	Chrudim	30	39	56	29
14	Viktoria	30	33	59	27
15	Táborsko	30	37	53	25
16	Znojmo	30	40	60	25

TEMPORADA 2017/2018

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	SFC Opava	30	76	33	63
2	Pribram	30	56	32	58
3	Pardubice	30	44	30	51
4	Hradec	30	50	36	50
5	Třinec	30	42	30	47
6	České	30	44	33	44
7	Baník	30	34	39	41
8	Vlašim	30	42	49	38
9	Znojmo	30	36	49	37
10	Viagem	30	37	47	36
11	Varnsdorf	30	40	46	35
12	Viktoria	30	42	52	35
13	Olympia	30	33	45	34
14	Táborsko	30	36	46	33
15	Vitkovice	30	35	52	30
16	Frýdek-Mís	30	26	54	27

TEMPORADA 2016/2017

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sigma	30	59	22	69
2	Baník	30	48	20	64
3	SFC Opava	30	61	33	63
4	Vlašim	30	61	34	54
5	České	30	39	31	46
6	Znojmo	30	49	47	41
7	Viktoria	30	49	41	39
8	Pardubice	30	31	33	39
9	Viagem	30	34	41	37
10	Táborsko	30	38	48	36
11	Varnsdorf	30	44	46	35
12	Třinec	30	40	52	34
13	Baník	30	28	44	32
14	Vitkovice	30	35	47	31
15	Frýdek-Mís	30	40	57	29
16	Prostějov	30	20	80	12

TEMPORADA 2015/2016

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Karviná	28	50	17	59
2	Hradec	28	45	16	59
3	Znojmo	28	62	33	56
4	Baník	28	32	26	41
5	Táborsko	28	39	34	39
6	Pardubice	28	29	29	38
7	Vlašim	28	35	33	35
8	Viagem	28	39	38	35
9	Varnsdorf	28	35	44	34
10	Frýdek-Mís	28	30	37	33
11	SFC Opava	28	34	37	32
12	České	28	41	48	32
13	Třinec	28	29	41	27
14	Sigma	28	23	49	21
15	Slavoj	28	20	61	20

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

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chrudim	34	67	34	77
2	Pardubice	34	81	32	68
3	FK Kunice	34	59	32	60
4	Mladá	34	71	50	52
5	Chomutov	34	55	61	51
6	Jiskra	34	65	50	50
7	Roudnice	34	68	63	50
8	Králův	34	44	50	50
9	Loko Vltavin	34	50	51	48
10	Sokol Ovcary	34	50	47	47
11	Ceská Lípa	34	39	54	45
12	Karlovy Vary	34	37	58	44
13	Viktoria	34	55	63	42
14	Písek	34	45	56	42
15	Slovan	34	45	72	38
16	Hlavice	34	44	67	37
17	SK Kladno	34	48	64	33
18	Letohrad	34	44	63	33

TEMPORADA 2010/2011

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bohemians	34	87	34	80
2	Mladá	34	68	36	63
3	Pardubice	34	61	27	61
4	FK Kunice	34	42	30	58
5	Sokol Ovcary	34	57	39	54
6	Písek	34	48	49	51
7	Loko Vltavin	34	36	46	51
8	Chomutov	34	59	58	49
9	Hlavice	34	41	48	49
10	Karlovy Vary	34	48	48	47
11	Ceská Lípa	34	39	52	45
12	Viktoria	34	54	52	44
13	Králův	34	39	52	43
14	České	34	45	59	43
15	Slovan	34	49	62	36
16	Viktoria	34	29	53	35
17	Slavia Praha	34	38	59	26
18	Jablonec II	34	27	63	23

TEMPORADA 2009/2010

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pardubice	30	70	16	78
2	Chrudim	30	49	39	51
3	Ústí	30	43	34	47
4	Horní	30	37	40	47
5	Nová Paka	30	37	36	44
6	Letohrad	30	35	38	44
7	Hradec	30	41	30	42
8	Velim	30	35	36	42
9	Podjestedsky	30	36	46	42
10	Union Nový	30	41	43	41
11	Dvůr	30	42	48	41
12	Náchod	30	37	42	40
13	Sokol	30	44	51	37
14	Pěnčín-Tu	30	36	45	37
15	Převýšov	30	34	49	32
16	Dobrovice	30	30	54	15

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

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hlavice	30	65	21	66
2	Sokol Ovcary	30	57	28	56
3	Dvůr	30	55	38	54
4	Pardubice	30	60	31	50
5	Velim	30	50	35	49
6	Hradec	30	56	37	48
7	Pěnčín-Tu	30	48	39	47
8	Chrudim	30	61	41	45
9	Převýšov	30	33	33	42
10	Týnište	30	40	48	40
11	SK Holice	30	32	56	37
12	Union	30	35	51	36
13	Dobrovice	30	51	44	34
14	Trutnov	30	43	58	34
15	Agria Chocen	30	33	48	30
16	Predmerice	30	9	120	6

Competiciones que juega

Grupo 1

Liga Checa Grupo 3

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

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

RIVALES EN Copa Checa

RIVALES EN Liga Checa

USO DE MEMORIA

7,093,744 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1811
Total Execution Time	0.1824

CADENA URL

/historico/Pardubice

GET DATOS

$_GET['/historico/Pardubice']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0071	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 = 'Pardubice' 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.0023	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=13171 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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=13171 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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=13171 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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=13171 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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=13171 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024	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=13171 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045	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.0042	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 = 74937
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13171 AND type_rel = 2
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30 AND type_rel = 3
0.0030	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 30 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025	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 (1309048,1282203,1277727,1267785,1247365) ORDER BY n.cover_points DESC, update_date DESC
0.0038	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 = '13171' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0036	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 = '13171' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 75934 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030	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=13171 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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,74937,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.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 75934 AND teamId = 13171
0.0057	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 13171
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 71877 AND teamId = 13171
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13171
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 74937 AND teamId = 13171
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 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.0024	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 = 13171 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 = 75934 WHERE rp.league_id = 75934 AND rp.teamId = 13171 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 = 13171 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035	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 = 13171 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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 = 50144 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.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* `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 = 44039 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* `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 = 38788 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 = 33332 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* `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 = 15518 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* `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.0034	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.0046	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 = 24658 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 24652 AND t.round = 34 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* `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 = 25130 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* `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.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* `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 = 27571 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Pardubice

Pardubice

Selecciona un equipo

Competiciones que juega

Liga Checa Grupo 3

RIVALES EN Copa Checa

RIVALES EN Liga Checa