Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Meteor Praha

Temporada 2023/2024

TEMPORADA 2023/2024

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chomutov	15	43	14	39
2	Újezd Praha	15	32	20	29
3	Meteor Praha	15	32	23	29
4	SK Kladno	15	38	18	27
5	Slaný	15	24	19	27
6	Neratovice-B	15	25	14	26
7	Hřebeč	15	33	25	25
8	FK Ostrov	15	24	24	25
9	Brandýs	15	28	27	22
10	Olympie	15	25	27	20
11	Štětí	15	21	20	19
12	Admira Praha	15	15	23	17
13	Český Brod	15	23	31	15
14	Hvězda Cheb	15	7	39	9
15	Sokol	15	18	45	8
16	FK Louny	15	10	29	5

TEMPORADA 2022/2023

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ceská Lípa	30	63	24	69
2	Újezd Praha	30	65	31	66
3	SK Kladno	29	76	34	56
4	Kosmonosy	30	67	43	52
5	Chomutov	30	47	28	52
6	Neratovice-B	30	42	27	51
7	Olympie	30	54	50	44
8	FK Louny	30	42	53	40
9	Meteor Praha	30	59	48	39
10	Český Brod	30	48	42	37
11	Štětí	30	52	67	33
12	Slaný	30	42	62	31
13	Admira Praha	29	38	45	30
14	Hvězda Cheb	30	40	77	28
15	Sokol Libiš	30	38	80	26
16	Vilémov	30	36	98	12

TEMPORADA 2021/2022

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Banik Most.	30	72	23	66
2	Neratovice-B	30	66	33	63
3	Ceská Lípa	30	78	42	57
4	SK Kladno	30	61	37	56
5	Český Brod	30	48	33	49
6	Aritma Praha	30	59	42	48
7	Štětí	30	51	41	45
8	FK Louny	30	53	38	44
9	Brandýs	30	51	56	40
10	Meteor Praha	30	55	51	39
11	Olympie	30	49	52	38
12	Chomutov	30	47	45	36
13	FK Ostrov	30	34	55	33
14	Slaný	30	36	64	33
15	Dobris	30	31	70	20
16	Tatran	30	12	121	3

TEMPORADA 2020/2021

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Banik Most.	7	15	4	17
2	SK Kladno	8	15	12	16
3	Český Brod	8	13	4	15
4	Neratovice-B	8	15	6	14
5	Ceská Lípa	8	18	10	14
6	Meteor Praha	7	16	11	13
7	Chomutov	8	17	17	12
8	Aritma Praha	8	9	7	11
9	Slaný	8	7	13	11
10	FK Ostrov	8	14	21	10
11	Brandýs	8	15	14	9
12	FK Louny	8	13	14	7
13	Dobris	8	11	21	7
14	Tatran	8	10	16	6
15	Štětí	7	13	21	4
16	Olympie	7	5	15	4

TEMPORADA 2019/2020

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Český Brod	16	24	9	43
2	Baník Souš	16	37	22	32
3	Meteor Praha	16	28	21	28
4	Chomutov	16	27	17	26
5	FK Ostrov	16	35	29	24
6	Aritma Praha	16	19	15	24
7	Olympie	16	35	36	24
8	Neratovice-B	16	32	22	23
9	SK Kladno	16	31	27	22
10	Brandýs	16	21	22	20
11	Slaný	16	26	33	19
12	Tatran	16	24	33	18
13	FK Louny	16	26	31	16
14	Štětí	16	30	42	16
15	Dobris	16	25	49	11
16	Ceská Lípa	16	25	37	9

TEMPORADA 2018/2019

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FK Zbuzany	32	81	33	67
2	Sokol	32	81	37	66
3	Baník Souš	32	61	44	62
4	Motorlet	32	62	47	53
5	FK Ostrov	41	62	80	51
6	SK Kladno	32	41	39	50
7	Chomutov	31	47	53	49
8	Neratovice-B	31	58	51	48
9	Olympie	31	47	57	46
10	Meteor Praha	32	45	36	45
11	Brandýs	31	47	43	44
12	Ostrá	41	50	69	42
13	Sokol Libiš	31	54	66	34
14	Polaban	32	31	56	32
15	Tatran	32	52	74	28
16	Mostecký	31	47	81	26

TEMPORADA 2017/2018

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Velvary	30	55	21	73
2	Sokol	30	67	30	64
3	Motorlet	30	56	32	59
4	Český Brod	30	64	42	56
5	Ostrá	30	53	36	50
6	Baník Souš	30	66	55	48
7	Neratovice-B	30	53	43	48
8	Úvaly	30	52	45	46
9	SK Kladno	30	46	40	45
10	Chomutov	30	67	51	44
11	Meteor Praha	30	48	48	40
12	Ceská Lípa	30	39	63	33
13	Tatran	30	39	48	32
14	FK Louny	30	47	54	29
15	Nový Bor	30	15	75	8
16	SK Hrobce	30	22	106	8

TEMPORADA 2016/2017

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sokol	30	73	28	68
2	Polaban	30	65	29	63
3	Český Brod	30	58	31	56
4	Baník Souš	30	51	38	51
5	SK Kladno	30	54	43	48
6	Neratovice-B	30	35	36	44
7	Velvary	30	47	42	43
8	Meteor Praha	30	47	41	41
9	Chomutov	30	40	42	40
10	Rakovník	30	38	45	36
11	Sokol	30	41	47	35
12	Nový Bor	30	35	54	34
13	Úvaly	30	26	38	33
14	Mostecký	30	42	68	31
15	Štětí	30	35	72	25
16	Sokol Libiš	30	27	60	16

TEMPORADA 2015/2016

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lovosice	30	61	31	62
2	Český Brod	30	65	29	60
3	SK Kladno	30	63	32	56
4	Sokol Libiš	30	52	37	53
5	Meteor Praha	30	57	38	47
6	Baník Souš	30	47	40	46
7	Neratovice-B	30	44	43	44
8	Rakovník	30	44	44	41
9	Chomutov	30	45	45	40
10	Polaban	30	31	37	39
11	Horní	30	33	43	37
12	Úvaly	30	48	54	36
13	Litomericko	30	40	58	36
14	Vilémov	30	31	63	25
15	Litvínov	30	28	62	22
16	FK Louny	30	32	65	20

TEMPORADA 2014/2015

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bohemians	34	68	25	81
2	Slavoj	34	68	57	64
3	Jiskra	34	72	43	62
4	Viktorie	34	59	43	62
5	Chrudim	34	54	41	58
6	Louňovice	34	58	46	55
7	Králův	34	60	47	53
8	Loko Vltavin	34	50	41	51
9	Sokol Zápy	34	54	54	48
10	Převýšov	34	58	49	47
11	Písek	34	52	56	46
12	FK Caslav	34	37	53	44
13	Povltavská	34	40	37	43
14	Benešov	34	44	54	43
15	Union Nový	34	40	61	38
16	Chomutov	34	40	74	34
17	Admira Praha	34	38	67	32
18	Meteor Praha	34	36	80	24

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

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Meteor Praha	30	59	21	66
2	Slavoj	30	72	28	62
3	Motorlet	30	52	33	55
4	Sokol	30	43	32	55
5	Úvaly	30	46	28	52
6	Neratovice-B	30	47	29	51
7	Slavoj	30	57	34	49
8	Baník Souš	30	47	42	47
9	Lovosice	30	57	43	41
10	Nový Bor	30	48	59	40
11	Litol	30	46	68	37
12	Český Brod	30	46	49	36
13	Sokol Libiš	30	32	54	29
14	Vilémov	30	38	60	25
15	Toužim	30	35	73	21
16	Union	30	24	96	8

TEMPORADA 2011/2012

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Viktorie	30	115	32	79
2	Sokol Zápy	30	67	24	67
3	Motorlet	30	74	35	63
4	Meteor Praha	30	66	36	56
5	Sokol	30	65	36	53
6	Slavoj	30	54	46	53
7	Slavoj	30	60	43	51
8	Vilémov	30	59	43	49
9	Baník Souš	30	64	63	44
10	Neratovice-B	30	34	46	34
11	Litol	30	42	81	33
12	Teplice II	30	64	62	32
13	Union	30	39	68	30
14	Přední	30	29	64	25
15	Český Brod	30	23	88	12
16	Chmel	30	23	111	6

TEMPORADA 2010/2011

4. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Viktorie	30	88	27	76
2	Roudnice	30	84	38	65
3	Sokol	30	63	42	55
4	Slavoj	30	55	37	55
5	Admira Praha	30	55	29	54
6	Meteor Praha	30	37	47	45
7	Teplice II	30	55	45	44
8	Polepy	30	59	61	44
9	Vilémov	30	44	54	42
10	Český Brod	30	56	49	38
11	Přední	30	43	53	37
12	Baník Most	30	47	61	36
13	Union	30	35	48	35
14	Litvínov	30	31	66	30
15	Kladno II	30	34	68	19
16	Rezuz Decín	30	29	90	8

TEMPORADA 2009/2010

4. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	FK Kunice	30	51	14	67
2	Příbram	30	62	32	60
3	Votice	30	48	29	49
4	Jiskra	30	46	43	44
5	Meteor Praha	30	52	45	43
6	Jiskra	30	47	43	43
7	Benešov	30	36	38	43
8	Tábor	30	37	42	42
9	Doubravka	30	49	50	40
10	Bohemians	30	45	43	39
11	Strakonice	30	34	44	38
12	Slavoj	30	46	48	37
13	Dukla Praha	30	42	54	35
14	Hořovicko	30	39	52	35
15	Malše	30	31	52	29
16	Tachov	30	38	74	24

TEMPORADA 2008/2009

4. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Loko Vltavin	30	59	23	65
2	Motorlet	30	56	22	55
3	Tatran	30	60	37	51
4	Admira Praha	30	57	48	48
5	Strakonice	30	55	46	47
6	Jiskra	29	50	45	46
7	Benešov	30	66	59	45
8	Jiskra	30	45	34	43
9	Hořovicko	30	39	40	43
10	Tachov	30	52	53	42
11	Meteor Praha	30	51	51	41
12	Příbram	30	47	47	41
13	Votice	29	43	47	41
14	Milevsko	30	34	43	35
15	Klatovy	30	26	97	17
16	Slavia	30	22	70	10

Competiciones que juega

Grupo 2

4. Liga Checa Grupo 2

Pos	Equipos		Pts
1		Chomutov	39
2		Újezd Praha 4	29
3		Meteor Praha	29
4		SK Kladno	27
5		Slaný	27
6		Neratovice-Byškovice	26
7		Hřebeč	25
8		FK Ostrov	25
9		Brandýs nad Labem	22
10		Olympie Brezova	20
11		Štětí	19
12		Admira Praha II	17
13		Český Brod	15
14		Hvězda Cheb	9
15		TJ Sokol Nespeky	8
16		FK Louny	5

	Ascenso : Chomutov
	Descenso : TJ Sokol Nespeky, FK Louny

RIVALES EN 4. Liga Checa

USO DE MEMORIA

6,816,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.5790
Total Execution Time	0.5801

CADENA URL

/historico/Meteor-Praha

GET DATOS

$_GET['/historico/Meteor-Praha']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0112	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 = 'Meteor-Praha' 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=30980 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=30980 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=30980 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0061	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 = 72420
0.0021	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30980 AND type_rel = 2
0.0045	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 = '30980' ORDER BY l.year DESC,cat.coefficient DESC
0.0044	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 = '30980' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0037	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 = '30980' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 72420 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032	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=30980 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022	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 (72420,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 = 72420 AND teamId = 30980
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30980
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 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 = 72420 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '30980' 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 = '30980' 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 = '30980' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 72420 WHERE rp.league_id = 72420 AND rp.teamId = 30980 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 = 72420 WHERE rp.league_id = 72420 AND rp.teamId = 30980 AND (e.action = 4 or e.action = 5) 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 = 72420 WHERE rp.league_id = 72420 AND rp.teamId = 30980 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 = 30980 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 72420 AND t.round = 15 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 = 68189 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* `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 = 63519 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* `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 = 57123 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.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 = 50442 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.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* `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 = 44435 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 = 39716 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 = 33748 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* `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 = 16000 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 = 9182 AND t.round = 34 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* `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.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* `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 = 25091 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* `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 = 25118 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* `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 = 25105 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 = 25126 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* `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 = 25136 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 72420 ORDER BY nameShow LIMIT 100

Meteor Praha

Meteor Praha

Selecciona un equipo

Competiciones que juega

4. Liga Checa Grupo 2

RIVALES EN 4. Liga Checa