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

Chornomorets Odessa

Entrenador: Roman Grygorchuk

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Shakhtar	25	53	20	61
2	Dynamo Kyiv	25	59	25	57
3	FC Kryvbas	25	44	25	51
4	Dnipro-1	26	36	25	45
5	Rukh Lviv	25	36	26	41
6	Polissya	25	31	26	39
7	Cherkasy	26	25	30	32
8	Vorskla	25	23	37	30
9	Chornomorets	25	34	36	29
10	Kolos	24	18	19	28
11	Zorya	24	25	32	26
12	Oleksandriya	25	22	34	25
13	Obolon	25	16	35	21
14	Veres Rivne	24	22	35	20
15	Minai	26	20	40	19
16	Metalist	25	25	44	19

TEMPORADA 2022/2023

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Shakhtar	30	69	21	72
2	Dnipro-1	30	61	27	67
3	Zorya	30	61	34	64
4	Dynamo Kyiv	30	51	25	60
5	Vorskla	30	38	37	45
6	Oleksandriya	30	42	39	44
7	FC Kryvbas	30	26	30	41
8	Minai	30	25	30	36
9	Kolos	30	23	36	36
10	Chornomorets	30	35	40	35
11	Rukh Lviv	30	31	37	32
12	Metalist	30	23	42	32
13	Veres Rivne	30	35	45	31
14	Inhulets	30	22	34	31
15	Metalist	30	27	58	22
16	FC Lviv	30	18	52	13

TEMPORADA 2021/2022

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Shakhtar	18	49	10	47
2	Dynamo Kyiv	18	47	9	45
3	Dnipro-1	18	35	17	40
4	Zorya	18	37	19	36
5	Vorskla	18	30	18	33
6	Oleksandriya	18	19	16	26
7	Desna	18	22	27	25
8	Kolos	18	14	23	24
9	Veres Rivne	18	15	20	23
10	Metalist	18	17	29	19
11	Rukh Lviv	17	16	21	18
12	FC Lviv	18	14	30	17
13	Chornomorets	18	20	40	14
14	Inhulets	17	13	28	13
15	Minai	18	12	30	10
16	FC Mariupol	18	21	44	8

TEMPORADA 2020/2021

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Veres Rivne	30	56	21	68
2	Chornomorets	30	45	23	61
3	Metalist	30	36	22	56
4	Mykolaiv	30	49	23	53
5	Ahrobiznes	30	46	27	52
6	Alians	30	46	31	51
7	Volyn Lutsk	30	39	28	46
8	Obolon	30	44	35	43
9	Hirnyk-Sport	30	43	45	38
10	VPK-Ahro	30	30	48	37
11	Polissya	30	32	37	35
12	Avanhard	30	32	51	32
13	Nyva	30	30	50	31
14	Prykarpattia	30	25	45	30
15	Kremin	30	23	50	24
16	Krystal	30	21	61	13

TEMPORADA 2019/2020

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Minai	30	51	28	62
2	Inhulets	30	47	22	60
3	Ahrobiznes	30	52	30	60
4	Rukh Lviv	29	48	21	58
5	Volyn Lutsk	30	57	36	57
6	Obolon	30	40	31	51
7	Metalist	30	44	34	51
8	Avanhard	30	37	40	45
9	Hirnyk-Sport	30	42	48	39
10	Chornomorets	30	40	37	39
11	Mykolaiv	30	45	45	34
12	Prykarpattia	30	44	51	30
13	Kremin	30	35	57	27
14	Balkany	30	27	51	25
15	Metalurh	29	28	55	22
16	Cherkashchyn	30	23	74	7

TEMPORADA 2018/2019

LIGA UCRANIANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Vorskla	32	31	43	42
2	Desna	32	35	41	41
3	Olimpik	32	41	48	34
4	Karpaty Lviv	32	44	53	33
5	Chornomorets	32	31	49	31
6	Arsenal Kyiv	32	26	56	26

TEMPORADA 2017/2018

LIGA UCRANIANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Oleksandriya	32	32	27	45
2	Karpaty Lviv	32	28	45	37
3	Olimpik	32	29	38	36
4	Zirka	32	22	40	31
5	Chornomorets	32	26	49	29
6	Stal	32	23	44	26

TEMPORADA 2016/2017

LIGA UCRANIANA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Shakhtar	32	66	24	80
2	Dynamo Kyiv	32	69	33	67
3	Zorya	32	45	31	54
4	Olimpik	32	33	44	44
5	Oleksandriya	32	41	43	40
6	Chornomorets	32	25	37	38

TEMPORADA 2015/2016

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Dynamo Kyiv	25	54	11	70
2	Shakhtar	25	76	25	63
3	Dnipro	25	50	22	53
4	Zorya	26	51	26	48
5	Vorskla	25	32	26	42
6	Oleksandriya	26	30	29	38
7	Karpaty Lviv	25	26	37	30
8	Stal	25	22	31	29
9	Olimpik	25	22	35	25
10	Metalist	25	19	46	24
11	Chornomorets	25	20	39	22
12	Volyn Lutsk	26	36	36	20
13	Hoverla	25	13	45	7
14	Metalurh	16	7	50	3

TEMPORADA 2014/2015

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Dynamo Kyiv	26	65	12	66
2	Shakhtar	26	71	21	56
3	Dnipro	26	47	17	54
4	Zorya	26	40	31	45
5	Vorskla	26	35	22	42
6	Metalist	25	34	32	35
7	Metalurh	26	20	40	26
8	Olimpik	26	24	64	26
9	Volyn Lutsk	26	38	44	25
10	Metalurh	26	27	38	22
11	Chornomorets	25	15	31	20
12	Hoverla	26	22	47	19
13	Karpaty Lviv	26	22	31	15
14	FC Mariupol	26	25	55	14

TEMPORADA 2013/2014

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Shakhtar	28	62	23	65
2	Dnipro	28	56	28	59
3	Metalist	28	54	29	57
4	Dynamo Kyiv	28	55	33	53
5	Chornomorets	28	30	22	46
6	Metalurh	28	45	42	43
7	Zorya	28	35	30	42
8	Vorskla	28	36	38	40
9	Sevastopol	28	32	43	35
10	FC Mariupol	28	27	33	34
11	Karpaty Lviv	28	33	39	32
12	Hoverla	28	26	39	26
13	Volyn Lutsk	28	25	51	24
14	Metalurh	28	19	54	12
15	Tavriya	28	15	46	10
16	Arsenal Kyiv	0	0	0	0

TEMPORADA 2012/2013

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Shakhtar	30	82	18	79
2	Metalist	30	59	25	66
3	Dynamo Kyiv	30	55	23	62
4	Dnipro	30	54	27	56
5	Metalurh	30	45	35	49
6	Chornomorets	30	32	36	43
7	Kryvbas	30	36	41	43
8	Arsenal Kyiv	30	34	41	39
9	FC Mariupol	30	30	32	38
10	Zorya	30	32	43	37
11	Tavriya	30	27	46	32
12	Vorskla	30	31	36	31
13	Volyn Lutsk	30	26	45	29
14	Karpaty Lviv	30	37	52	27
15	Hoverla	30	29	57	22
16	Metalurh	30	12	64	11

TEMPORADA 2011/2012

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Shakhtar	30	80	18	79
2	Dynamo Kyiv	30	56	12	75
3	Metalist	30	54	32	59
4	Dnipro	30	52	35	52
5	Arsenal Kyiv	30	44	27	51
6	Tavriya	30	43	36	45
7	Metalurh	30	35	34	42
8	Vorskla	30	38	43	37
9	Chornomorets	30	32	42	37
10	Kryvbas	30	22	38	33
11	FC Mariupol	30	28	42	32
12	Volyn Lutsk	30	25	43	27
13	Zorya	30	34	58	26
14	Karpaty Lviv	30	27	51	23
15	Obolon	30	17	42	21
16	Oleksandriya	30	24	58	20

TEMPORADA 2010/2011

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Oleksandriya	34	58	25	69
2	Chornomorets	34	56	26	65
3	Stal	34	55	31	62
4	Krymteplytsi	34	46	30	61
5	FC Lviv	34	52	28	59
6	Hoverla	34	54	40	56
7	Bukovyna	34	51	45	56
8	Dynamo Kyiv	34	42	35	52
9	Arsenal Bila	34	45	43	51
10	Nyva	34	47	42	50
11	Tytan	34	35	42	44
12	Zirka	34	43	44	43
13	FK Odessa	34	42	42	42
14	Naftovyk-Ukr	34	43	44	41
15	Helios	34	34	44	40
16	Enerhetyk	34	33	47	37
17	Prykarpattia	34	28	83	14
18	Feniks-Illic	34	17	90	11

TEMPORADA 2009/2010

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Shakhtar	30	62	18	77
2	Dynamo Kyiv	30	61	16	71
3	Metalist	30	49	23	62
4	Dnipro	30	48	25	54
5	Karpaty Lviv	30	44	35	50
6	Tavriya	30	38	38	45
7	Arsenal Kyiv	30	44	41	42
8	Metalurh	30	41	33	40
9	Metalurh	30	31	48	35
10	Vorskla	30	29	32	31
11	Obolon	30	26	50	31
12	FC Mariupol	30	31	56	29
13	Zorya	30	23	47	28
14	Kryvbas	30	31	47	25
15	Chornomorets	30	21	44	24
16	Hoverla	30	18	44	19

TEMPORADA 2008/2009

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Dynamo Kyiv	30	71	19	79
2	Shakhtar	30	47	16	64
3	Metalist	30	44	25	59
4	Metalurh	30	36	27	49
5	Vorskla	30	32	26	49
6	Dnipro	30	34	25	48
7	Metalurh	30	29	30	45
8	Tavriya	30	41	45	37
9	Karpaty Lviv	30	33	39	34
10	Chornomorets	30	34	42	32
11	Arsenal Kyiv	30	26	33	32
12	Kryvbas	30	21	36	32
13	Zorya	30	29	45	31
14	FC Mariupol	30	31	54	26
15	FC Lviv	30	24	39	26
16	FC Kharkiv	30	19	50	12

TEMPORADA 2007/2008

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Shakhtar	30	75	24	74
2	Dynamo Kyiv	30	65	26	71
3	Metalist	30	51	27	63
4	Dnipro	30	40	27	59
5	Tavriya	30	38	40	47
6	Arsenal Kyiv	30	42	36	42
7	Chornomorets	30	27	33	38
8	Vorskla	29	28	30	36
9	Metalurh	30	24	32	36
10	Karpaty Lviv	30	29	41	33
11	Zorya	29	24	43	31
12	Metalurh	30	34	39	31
13	Kryvbas	30	29	39	30
14	FC Kharkiv	30	20	32	27
15	Naftovyk-Ukr	30	18	38	26
16	Hoverla	30	17	54	18

Competiciones que juega

Liga Ucraniana

Pos	Equipos		Pts
1		Shakhtar Donetsk	61
2		Dynamo Kyiv	57
3		FC Kryvbas	51
4		Dnipro-1	45
5		Rukh Lviv	41
6		Polissya Zhytomyr	39
7		LNZ Cherkasy	32
8		Vorskla Poltava	30
9		Chornomorets Odessa	29
10		Kolos Kovalivka	28
11		Zorya Luhansk	26
12		Oleksandriya	25
13		Obolon	21
14		Veres Rivne	20
15		Minai	19
16		Metalist 1925 Kharkiv	19

	Campeón : Shakhtar Donetsk
	Previa de Champions (2ª Ronda) : Dynamo Kyiv
	: FC Kryvbas, Dnipro-1
	Playoff Descenso : Obolon, Veres Rivne
	Descenso : Minai, Metalist 1925 Kharkiv

RIVALES EN Copa Ucraniana

RIVALES EN Liga Ucraniana

USO DE MEMORIA

7,129,080 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1563
Total Execution Time	0.1575

CADENA URL

/historico/Chornomorets

GET DATOS

$_GET['/historico/Chornomorets']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0055	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 = 'Chornomorets' 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.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=5825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0046	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 = 72212
0.0088	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 = '5825' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0048	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 = '5825' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0055	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=5825 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73212,72212,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.0049	SELECT count(id) as num_players from rel_players WHERE league_id = 72212 AND teamId = 5825
0.0047	SELECT count(id) as num_players from rel_players WHERE league_id = 73212 AND teamId = 5825
0.0037	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5825
0.0041	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 = 72212 WHERE rp.league_id = 72212 AND rp.teamId = 5825 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.0038	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 = 72212 WHERE rp.league_id = 72212 AND rp.teamId = 5825 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 72212 WHERE rp.league_id = 72212 AND rp.teamId = 5825 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 5825 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72212 AND t.round = 26 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 = 68061 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* `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 = 62931 AND t.round = 19 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 = 58693 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* `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 = 49999 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* `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 = 43634 AND t.round = 22 ORDER BY team.conference 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 = 49319 AND t.round = 10 ORDER BY team.conference 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* `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 = 38693 AND t.round = 22 ORDER BY team.conference 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* `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 = 43034 AND t.round = 10 ORDER BY team.conference 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* `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 = 33416 AND t.round = 22 ORDER BY team.conference 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* `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 = 38210 AND t.round = 10 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 = 15437 AND t.round = 26 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* `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 = 3827 AND t.round = 26 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* `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 = 2486 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* `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 = 1929 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* `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 = 1370 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* `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 = 14292 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 5828 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* `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 = 5827 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 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 = 5826 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Chornomorets Odessa

Chornomorets Odessa

Selecciona un equipo

Competiciones que juega

Liga Ucraniana

RIVALES EN Copa Ucraniana

RIVALES EN Liga Ucraniana