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

MFK Mykolaiv

Temporada 2016/2017

TEMPORADA 2016/2017

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	FC Mariupol	34	61	21	81
2	Desna	34	55	23	74
3	Veres Rivne	34	62	32	67
4	Helios	34	31	22	58
5	Kolos	34	52	38	57
6	Naftovyk-Ukr	34	47	29	54
7	Avanhard	34	32	28	52
8	Cherkashchyn	34	30	29	48
9	Obolon	34	37	37	45
10	Arsenal Kyiv	34	38	39	45
11	Hirnyk-Sport	34	47	54	43
12	Poltava	34	33	43	40
13	Inhulets	34	33	45	38
14	Mykolaiv	34	35	44	37
15	Sumy	34	34	44	36
16	Bukovyna	34	27	40	33
17	Skala Stryi	34	25	58	20
18	Ternopil'	34	17	70	15

TEMPORADA 2015/2016

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Zirka	30	52	22	65
2	Cherkashchyn	30	45	27	55
3	Obolon	30	48	35	54
4	FC Mariupol	30	37	24	53
5	Helios	30	36	24	51
6	Hirnyk	30	42	27	49
7	Mykolaiv	30	38	27	44
8	Desna	30	33	30	40
9	Naftovyk-Ukr	30	34	33	40
10	Poltava	30	32	32	38
11	Dynamo Kyiv	30	30	34	36
12	Hirnyk-Sport	30	30	35	33
13	Avanhard	30	32	42	32
14	Sumy	30	35	54	30
15	Ternopil'	30	21	47	22
16	Nyva	30	10	62	7

TEMPORADA 2014/2015

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Oleksandriya	30	56	15	72
2	Stal	30	48	21	60
3	Hirnyk-Sport	30	47	24	57
4	Zirka	30	42	27	49
5	Desna	30	47	27	47
6	Helios	30	33	25	44
7	Dynamo Kyiv	30	35	29	44
8	Sumy	30	38	41	43
9	Hirnyk	30	35	26	42
10	Poltava	30	32	27	42
11	Ternopil'	30	36	49	41
12	Naftovyk-Ukr	30	35	34	40
13	Nyva	30	28	52	27
14	Mykolaiv	30	37	67	24
15	Bukovyna	30	27	61	15
16	Stal	30	16	67	15

TEMPORADA 2013/2014

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Olimpik	30	45	33	55
2	Oleksandriya	30	47	28	52
3	Stal	30	44	33	51
4	Poltava	30	39	34	46
5	Desna	30	33	27	44
6	Zirka	30	36	34	44
7	Naftovyk-Ukr	30	40	35	43
8	UkrAhroKom	30	27	27	42
9	Helios	30	32	35	41
10	Nyva	30	33	32	39
11	Sumy	30	32	39	39
12	Tytan	30	32	41	38
13	Bukovyna	30	26	36	36
14	Dynamo Kyiv	30	29	30	32
15	Mykolaiv	30	34	49	31
16	Avanhard	30	23	39	31

TEMPORADA 2012/2013

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Sevastopol	34	74	22	74
2	Stal	34	58	35	66
3	Oleksandriya	34	51	35	60
4	Bukovyna	34	49	33	58
5	Mykolaiv	34	48	41	57
6	Naftovyk-Ukr	34	42	31	54
7	Avanhard	34	40	26	53
8	Zirka	34	49	37	52
9	Sumy	34	32	35	50
10	Helios	34	36	21	49
11	Olimpik	34	37	37	49
12	Tytan	34	44	40	48
13	Poltava	34	38	35	45
14	Krymteplytsi	34	33	45	35
15	Dynamo Kyiv	34	34	55	30
16	FK Odessa	34	24	63	24
17	Obolon	34	19	67	22
18	Arsenal Bila	34	26	76	20

TEMPORADA 2011/2012

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Hoverla	34	67	16	84
2	Metalurh	34	77	32	76
3	Sevastopol	34	60	22	76
4	Arsenal Bila	34	51	39	62
5	Krymteplytsi	34	50	38	60
6	Bukovyna	34	38	29	57
7	Dynamo Kyiv	34	42	39	50
8	Stal	34	51	50	50
9	Helios	34	54	46	48
10	Naftovyk-Ukr	34	49	43	44
11	Zirka	34	53	49	44
12	Olimpik	34	38	44	40
13	Nyva	34	21	39	32
14	Tytan	34	33	59	32
15	FK Odessa	34	37	51	31
16	Mykolaiv	34	33	51	31
17	FC Lviv	34	24	79	21
18	Enerhetyk	34	26	78	19

TEMPORADA 2010/2011

TERCERA UCRANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mykolaiv	22	29	12	46
2	Sumy	22	38	13	45
3	Enerhiya	22	38	17	42
4	Bastion	22	38	16	41
5	Desna	22	38	24	40
6	Chornomorets	22	27	17	34
7	Skala Stryi	22	26	19	33
8	Yednist	22	39	26	32
9	Dynamo	22	19	29	20
10	Nyva	22	17	51	12
11	Bila Tserkva	22	20	58	8
12	Veres Rivne	22	4	51	4

TEMPORADA 2009/2010

TERCERA UCRANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bukovyna	20	35	12	48
2	Nyva	20	43	16	40
3	Bastion	20	44	20	40
4	Mykolaiv	20	30	13	39
5	Dynamo	20	28	16	33
6	Yednist	20	22	21	29
7	Bila Tserkva	20	18	30	21
8	Lviv II	20	13	25	19
9	Veres Rivne	20	16	41	16
10	Karpaty II	20	17	43	16
11	Skala Stryi	20	11	40	6

TEMPORADA 2008/2009

TERCERA UCRANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Nyva	32	50	26	65
2	Arsenal Bila	32	51	31	61
3	Nyva	32	42	30	59
4	CSKA Kyiv	31	40	22	53
5	Dnipro	32	37	20	49
6	Nafkom	31	44	33	47
7	Bastion	32	36	40	46
8	Mykolaiv	32	28	27	41
9	Dynamo	32	32	38	41
10	Bila Tserkva	32	38	38	39
11	Bukovyna	32	29	39	38
12	Korosten	32	24	39	35
13	Yednist	32	31	41	34
14	Veres Rivne	32	21	32	33
15	Obolon II	32	20	30	31
16	Karpaty II	32	28	45	28
17	Knyazha	32	15	35	26

TEMPORADA 2007/2008

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	FC Mariupol	38	65	26	85
2	FC Lviv	38	58	29	74
3	Obolon	38	67	42	72
4	Desna	38	61	44	67
5	Dynamo Kyiv	38	64	52	63
6	Ihroservice	38	50	45	60
7	Stal	38	52	44	58
8	Volyn Lutsk	38	61	55	56
9	Oleksandriya	38	41	32	55
10	Mykolaiv	38	33	27	52
11	Krymteplytsi	38	49	43	50
12	FK Odessa	38	33	39	49
13	Enerhetyk	38	39	44	48
14	Helios	38	31	41	47
15	Sevastopol	38	38	55	43
16	Cherkashchyn	38	43	43	42
17	Feniks-Illic	38	35	56	41
18	Prykarpattia	38	37	67	39
19	CSKA Kyiv	38	36	74	27
20	Stal	38	23	58	20

TEMPORADA 2006/2007

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Naftovyk-Ukr	36	61	29	81
2	Hoverla	36	56	22	80
3	Obolon	36	50	27	73
4	Krymteplytsi	36	56	37	70
5	Oleksandriya	36	41	27	61
6	Dynamo Kyiv	36	56	37	59
7	Helios	36	47	35	58
8	Enerhetyk	36	47	33	56
9	Ihroservice	36	49	44	51
10	Stal	36	42	37	51
11	FC Lviv	36	44	44	47
12	Mykolaiv	36	36	40	46
13	Volyn Lutsk	36	43	48	46
14	Desna	36	54	58	41
15	Cherkashchyn	36	34	46	39
16	CSKA Kyiv	36	27	44	38
17	Spartak	36	27	52	33
18	Dynamo	36	20	63	10
19	Borysfen	36	10	77	2

TEMPORADA 2004/2005

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Stal	34	63	24	77
2	Arsenal	34	50	24	73
3	Zorya	34	57	21	66
4	Dynamo Kyiv	34	51	33	54
5	Nyva	34	52	38	53
6	Karpaty Lviv	34	42	35	52
7	CSKA Kyiv	34	34	38	51
8	Spartak	34	37	33	50
9	Naftovyk-Ukr	34	40	29	49
10	Stal	34	45	47	49
11	Shakhtar	34	51	53	44
12	Gazovik-Skal	34	37	42	43
13	Dynamo	34	48	54	43
14	Ihroservice	34	41	57	41
15	Spartak Sumy	34	37	41	39
16	Nafkom	34	29	38	37
17	Mykolaiv	34	21	40	31
18	Zhytomyr	34	5	93	2

TEMPORADA 2003/2004

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Goverla	34	49	27	70
2	Metalist	34	51	24	66
3	Naftovyk-Ukr	34	52	33	62
4	Dynamo Kyiv	34	65	35	59
5	Stal	34	45	27	58
6	Spartak	34	42	38	55
7	Nyva	34	34	24	52
8	Arsenal	34	41	40	52
9	Spartak Sumy	34	40	41	46
10	Shakhtar	34	43	43	44
11	Mykolaiv	34	31	31	42
12	CSKA Kyiv	34	29	39	42
13	Krasyliv	34	34	54	40
14	Nafkom	34	35	43	38
15	Zorya	34	28	41	37
16	Karpaty II	34	37	48	33
17	Inter	34	29	52	29
18	Zhytomyr	34	22	67	16

TEMPORADA 2002/2003

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Zirka	34	46	22	71
2	Borisfen	34	45	16	66
3	Dynamo Kyiv	34	57	28	64
4	Stal	34	38	33	52
5	Mykolaiv	34	32	37	52
6	Naftovyk-Ukr	34	37	27	51
7	Goverla	34	29	26	51
8	Krasyliv	34	43	37	49
9	Arsenal	34	38	43	46
10	Spartak Sumy	34	34	43	45
11	Zhytomyr	34	31	38	43
12	Shakhtar	34	34	40	42
13	Karpaty II	34	35	39	41
14	CSKA Kyiv	34	33	38	41
15	Inter	34	28	28	40
16	Nyva	34	18	31	36
17	Spartak	34	27	54	29
18	Sokil	34	24	49	22

TEMPORADA 2001/2002

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Volyn Lutsk	34	56	24	78
2	Chornomorets	34	48	21	67
3	Obolon	34	49	26	62
4	Zhytomyr	33	41	32	58
5	Spartak	34	41	27	53
6	Stal	34	42	34	50
7	Naftovyk-Ukr	34	35	32	49
8	Dynamo Kyiv	34	42	32	47
9	Shakhtar	34	50	46	46
10	Zirka	34	29	28	46
11	Mykolaiv	34	37	44	46
12	Karpaty II	34	41	52	42
13	Borisfen	33	43	45	40
14	CSKA Kyiv	34	32	39	39
15	Nyva	34	35	52	38
16	Elektrometal	34	30	41	37
17	Dnipro II	34	29	48	31
18	Nyva	34	20	77	13

TEMPORADA 2000/2001

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Dynamo Kyiv	34	61	25	68
2	Goverla	34	50	38	64
3	Oleksandriya	34	50	22	63
4	Mykolaiv	34	41	30	59
5	FC Lviv	34	40	31	58
6	Chornomorets	34	44	28	57
7	Elektrometal	34	31	34	50
8	CSKA Kyiv	34	36	43	46
9	Volyn Lutsk	34	42	38	44
10	Nyva	34	35	41	44
11	Dnipro II	34	41	43	43
12	Borisfen	34	28	34	43
13	Shakhtar	34	31	39	43
14	Spartak	34	36	46	42
15	Zirka	34	27	35	40
16	Dnipro	34	35	52	34
17	Spartak Sumy	34	21	47	31
18	Bukovyna	34	19	42	26

TEMPORADA 1999/2000

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Dynamo Kyiv	34	76	22	73
2	Stal	34	59	36	70
3	Dnipro	34	49	34	59
4	Shakhtar	34	48	38	56
5	CSKA Kyiv	34	40	26	54
6	Mykolaiv	34	41	38	52
7	FC Lviv	34	35	31	51
8	Oleksandriya	34	35	34	49
9	Volyn Lutsk	34	44	41	48
10	Spartak Sumy	34	43	45	48
11	Elektrometal	34	32	34	48
12	Nyva	34	30	39	48
13	Goverla	34	37	49	48
14	Naftovyk-Ukr	34	43	51	44
15	Zhytomyr	34	37	51	40
16	Obolon	34	24	52	27
17	Chornomorets	34	27	51	23
18	Torpedo	34	21	49	16

TEMPORADA 1998/1999

LIGA UCRANIANA
Equipo		PJ	GF	GC	Puntos
1	Dynamo Kyiv	30	75	17	74
2	Shakhtar	30	70	25	65
3	Kryvbas	30	43	18	59
4	Karpaty Lviv	30	54	34	55
5	FC Mariupol	30	35	27	48
6	Metalist	30	31	32	47
7	Arsenal Kyiv	30	37	35	43
8	Metalurh	30	46	43	42
9	Tavriya	30	33	39	37
10	Vorskla	30	36	43	35
11	Zirka	30	31	40	34
12	Dnipro	30	28	46	32
13	Nyva	30	29	41	31
14	Metalurh	30	27	51	28
15	Spartak	30	24	59	24
16	Mykolaiv	30	18	67	12

TEMPORADA 1997/1998

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Mykolaiv	41	94	31	95
2	Dynamo Kyiv	42	90	31	93
3	Metalist	42	74	29	89
4	Stal	42	95	53	77
5	Nyva	42	58	34	73
6	Zhytomyr	42	58	64	68
7	Naftovyk-Ukr	42	56	50	67
8	Dnipro	41	51	41	65
9	Volyn Lutsk	41	56	45	62
10	Spartak Sumy	42	52	48	62
11	CSKA Kyiv	42	56	44	59
12	Elektrometal	41	44	61	58
13	Makiivvuhill	42	65	77	56
14	Kremin	42	55	53	55
15	FC Lviv	41	65	54	54
16	Oleksandriya	42	51	49	54
17	Desna	42	45	53	54
18	Bukovyna	41	36	50	50
19	Zorya	42	43	84	39
20	Goverla	42	42	79	32
21	Hirnyk	42	15	107	16
22	Khimik	38	26	90	13

TEMPORADA 1996/1997

SEGUNDA UCRANIA
Equipo		PJ	GF	GC	Puntos
1	Elektrometal	46	77	39	101
2	Dynamo Kyiv	46	91	33	95
3	FC Mariupol	46	92	56	93
4	Volyn Lutsk	46	62	47	83
5	Naftovyk-Ukr	46	76	44	81
6	Stal	46	76	43	78
7	Mykolaiv	45	66	37	72
8	FC Lviv	46	56	43	69
9	Bukovyna	46	64	51	67
10	Oleksandriya	46	55	50	65
11	Metalurh	46	60	66	64
12	Metalist	46	55	53	63
13	Spartak Sumy	46	61	61	61
14	Khimik	46	64	62	59
15	Zhytomyr	46	44	61	55
16	Goverla	45	56	78	55
17	Dnipro	46	46	78	55
18	Makiivvuhill	45	55	62	53
19	Zorya	46	57	83	53
20	CSKA Kyiv	44	37	56	51
21	SKA Odesa	46	47	79	50
22	Dynamo	45	40	66	46
23	Veres Rivne	45	36	79	42
24	Chortkiv	45	31	77	33

Competiciones que juega

Segunda Ucrania

Pos	Equipos		Pts
1		FC Mariupol	81
2		Desna Chernihiv	74
3		Veres Rivne	67
4		Helios Kharkiv	58
5		Kolos Kovalivka	57
6		Naftovyk-Ukrnafta Okhtyrka	54
7		Avanhard Kramatorsk	52
8		Cherkashchyna-Akademiya	48
9		Obolon	45
10		Arsenal Kyiv	45
11		Hirnyk-Sport	43
12		Poltava	40
13		Inhulets	38
14		MFK Mykolaiv	37
15		Sumy	36
16		Bukovyna Chernivtsi	33
17		Skala Stryi	20
18		Ternopil'	15

	Ascenso : FC Mariupol, Desna Chernihiv
	Playoff Descenso : Sumy
	Descenso : Bukovyna Chernivtsi, Skala Stryi, Ternopil'

RIVALES EN Copa Ucraniana

RIVALES EN Segunda Ucrania

USO DE MEMORIA

7,978,080 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.9086
Total Execution Time	0.9098

CADENA URL

/historico/Mfk-Mykolaiv/2017

GET DATOS

$_GET['/historico/Mfk-Mykolaiv/2017']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0158	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 = 'Mfk-Mykolaiv' AND l.year = 2017 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.0145	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=13534 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=13534 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=13534 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=13534 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0296	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 = 33937
0.0163	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 = 33800
0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13534 AND type_rel = 2
0.0155	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13534 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (170806) ORDER BY n.cover_points DESC, update_date DESC
0.0172	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 = '13534' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0156	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 = '13534' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0154	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 = '13534' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152	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 = 33800 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150	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 = 33937 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157	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=13534 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0153	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 (38867,38758,38427) 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.0171	SELECT count(id) as num_players from rel_players WHERE league_id = 38758 AND teamId = 13534
0.0183	SELECT count(id) as num_players from rel_players WHERE league_id = 38867 AND teamId = 13534
0.0160	SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 13534
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 33937 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148	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 = '13534' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13534' and rp.type = 4
0.0150	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 = '13534' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0199	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 events2017 e ON e.player_id = p.id AND e.league_id = 33937 WHERE rp.league_id = 33937 AND rp.teamId = 13534 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.0211	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 events2017 e ON e.player_id = p.id AND e.league_id = 33937 WHERE rp.league_id = 33937 AND rp.teamId = 13534 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0192	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 events2017 e ON e.player_id = p.id AND e.league_id = 33937 WHERE rp.league_id = 33937 AND rp.teamId = 13534 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	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 = 13534 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153	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 = 33937 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 15509 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 4159 AND t.round = 30 ORDER BY team.conference 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* `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 = 2875 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 14290 AND t.round = 34 ORDER BY team.conference 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* `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 = 14291 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 16273 AND t.round = 22 ORDER BY team.conference 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* `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 = 16275 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 16277 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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 = 14295 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166	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 = 14296 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167	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 = 14298 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169	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 = 26472 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166	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* `tables2003` 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 = 26473 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167	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* `tables2002` 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 = 26474 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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* `tables2001` 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 = 26475 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168	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* `tables2000` 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 = 26476 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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* `tables1999` 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 = 5817 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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* `tables1998` 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 = 26478 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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* `tables1997` 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 = 26480 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

MFK Mykolaiv

MFK Mykolaiv

Selecciona un equipo

Competiciones que juega

Segunda Ucrania

RIVALES EN Copa Ucraniana

RIVALES EN Segunda Ucrania