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

Chernomorets Novorossisk

Temporada 2015/2016

TEMPORADA 2015/2016

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Spartak	26	43	6	63
2	Afips	26	35	27	49
3	Krasnodar	26	53	26	48
4	Chernomorets	26	35	22	48
5	Angusht	26	24	17	41
6	SKA Rostov	26	34	24	38
7	Dinamo	26	30	30	35
8	Mashuk-KMV	26	26	32	35
9	Akhmat	26	32	31	31
10	Biolog	26	21	34	27
11	Alaniya	26	19	37	25
12	Mitos	26	30	48	23
13	Astrakhan	26	23	49	21
14	Druzhba	26	22	44	20

TEMPORADA 2014/2015

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	14	28	14	31
2	Afips	14	19	12	29
3	Vityaz	14	22	17	28
4	FC Armavir	14	24	18	24
5	Biolog	14	16	20	16
6	Druzhba	14	13	20	11
7	Krasnodar	14	15	24	10
8	FK Sochi	14	14	26	10
9	SKChF	0	0	0	0
10	Simferopol'	0	0	0	0
11	Zhemchuzhyna	0	0	0	0
12	Dinamo	21	24	11	41
13	Mitos	20	30	13	34
14	Spartak	20	28	16	33
15	Mashuk-KMV	20	25	22	33
16	FK Taganrog	20	18	18	28
17	Rotor	20	26	24	27
18	Angusht	20	13	23	23
19	Anzhi II	20	14	22	22
20	Alaniya	20	21	33	21
21	Akhmat	20	12	18	18
22	Astrakhan	21	19	30	17

TEMPORADA 2013/2014

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Volgar	34	73	15	90
2	Chernomorets	34	74	19	85
3	Vityaz	34	48	31	60
4	Olimpia	34	51	35	58
5	Dagdizel	34	41	36	55
6	Mitos	34	42	27	54
7	Astrakhan	34	43	36	51
8	SKA Rostov	34	39	30	50
9	Gazprom	34	37	32	47
10	FC Armavir	34	41	41	46
11	FK Taganrog	34	38	47	43
12	Mashuk-KMV	34	28	54	34
13	Biolog	34	37	53	33
14	Alania	34	43	65	33
15	Druzhba	34	26	47	32
16	Akhmat	34	30	53	30
17	Krasnodar	34	35	66	27
18	Energiya	34	31	70	21

TEMPORADA 2012/2013

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	32	53	17	69
2	Angusht	32	45	19	69
3	FC Armavir	32	51	25	63
4	Astrakhan	32	62	31	62
5	Mashuk-KMV	32	37	20	53
6	FK Taganrog	32	50	34	51
7	Alania	32	50	37	49
8	Dagdizel	32	35	27	48
9	Biolog	32	41	38	45
10	Mitos	32	47	47	45
11	Energiya	32	36	42	44
12	Slavyanskiy	32	42	44	39
13	Druzhba	32	33	48	35
14	Gazprom	32	34	50	28
15	Olimpia	32	25	55	24
16	Volgar	32	27	62	20
17	SKA Rostov	32	8	80	9

TEMPORADA 2011/2012

PRIMERA RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	KamAZ	10	5	10	67
2	Yenisey	10	8	10	66
3	SKA-Khabarov	10	11	9	62
4	Torpedo	10	17	12	61
5	FC Orenburg	10	14	4	59
6	Baltika	10	11	9	59
7	Volgar	10	8	8	59
8	FK Khimki	10	7	13	56
9	Luch	10	7	7	54
10	Chernomorets	10	8	9	52
11	Fakel	10	8	13	40

TEMPORADA 2009/2010

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	32	63	20	76
2	FC Armavir	32	41	15	69
3	Mashuk-KMV	32	53	27	62
4	Astrakhan	32	58	35	58
5	Krasnodar	32	51	27	56
6	FK Beslan	32	36	37	45
7	Gazprom	32	40	51	44
8	Mitos	32	47	45	42
9	Druzhba	32	37	40	41
10	Angusht	32	37	43	40
11	Energiya	32	43	52	39
12	Dagdizel	32	42	42	37
13	Dinamo	32	34	47	37
14	SKA Rostov	32	34	39	36
15	FK Taganrog	32	28	53	28
16	Avtodor	32	31	50	23
17	Bataisk 2007	32	19	71	15

TEMPORADA 2008/2009

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Anzhi	38	61	31	75
2	Sibir	38	60	21	73
3	Alaniya	38	57	30	70
4	Volga	38	54	32	65
5	KamAZ	38	50	31	64
6	Salyut	38	54	41	61
7	Shinnik	38	46	35	61
8	Ural	38	40	32	60
9	Krasnodar	38	50	47	52
10	Baltika	38	41	42	52
11	Vityaz	38	46	39	51
12	Volgar	38	40	41	51
13	Luch	38	42	43	50
14	Nizhny	38	37	47	50
15	SKA-Khabarov	38	43	42	47
16	NoSta	38	47	59	40
17	FK Chita	38	27	65	35
18	Chernomorets	38	31	51	34
19	Metallurg	38	30	62	31
20	MVD Rossii	38	10	75	17

TEMPORADA 2007/2008

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	FK Rostov	42	78	29	96
2	FC Kuban	42	84	36	87
3	KamAZ	42	68	41	79
4	Ural	42	69	39	75
5	NoSta	42	59	37	73
6	Anzhi	42	63	35	72
7	Baltika	42	43	34	65
8	Chernomorets	42	51	38	61
9	SKA-Khabarov	42	63	60	61
10	Alaniya	42	50	47	59
11	Sibir	42	51	41	58
12	SKA Rostov	42	52	50	58
13	Salyut	42	51	51	58
14	Vityaz	42	49	57	58
15	Metallurg-Ku	42	44	42	57
16	SAC Moskva	42	55	57	57
17	Volga	42	50	65	49
18	Torpedo	42	47	69	49
19	Mashuk-KMV	42	39	79	32
20	Dinamo	42	31	80	27
21	Zvezda	42	36	95	23
22	Dinamo	42	30	81	22

TEMPORADA 2006/2007

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	28	68	25	67
2	Dinamo	28	47	28	56
3	Bataisk 2007	28	46	28	55
4	Rotor	28	56	29	53
5	Druzhba	28	39	32	51
6	Gazprom	28	40	36	46
7	FK Taganrog	27	41	27	43
8	Krasnodar	27	33	31	38
9	FK Sochi	28	35	39	34
10	Olimpia	28	30	46	33
11	Energiya	28	33	43	28
12	Astrakhan	28	24	38	28
13	Avtodor	28	28	48	25
14	Spartak	28	22	49	19
15	Tekstilshchi	28	15	58	13

TEMPORADA 2005/2006

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2003/2004

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Akhmat	42	70	22	100
2	Tom Tomsk	42	71	40	86
3	Sokol	42	71	39	83
4	KamAZ	42	52	49	69
5	FK Khimki	42	39	33	61
6	SKA-Khabarov	42	42	37	61
7	FC Oryol	42	37	34	61
8	Metallurg	42	48	43	60
9	Anzhi	42	50	53	60
10	FK Chita	42	47	48	59
11	Dynamo	42	44	48	59
12	Spartak	42	53	46	58
13	Arsenal Tula	42	39	32	58
14	Luch	42	50	50	56
15	Dinamo	42	49	51	55
16	Metallurg-Ku	42	53	53	52
17	Chernomorets	42	47	44	51
18	Elista	42	48	57	50
19	Neftekhimik	42	38	57	45
20	Baltika	42	37	60	39
21	Mordovia	42	24	62	26
22	Soyuz	42	40	91	22

TEMPORADA 2002/2003

PREMIER LEAGUE RUSIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Moskva	30	56	32	59
2	Zenit	30	48	32	56
3	Rubin Kazán	30	44	29	53
4	Lokomotiv	30	54	33	52
5	Shinnik	30	43	34	47
6	Dinamo	30	42	29	46
7	Saturn	30	40	37	45
8	Torpedo	30	42	38	43
9	Krylia	30	38	33	42
10	Spartak	30	38	48	36
11	FK Rostov	30	30	42	34
12	Rotor	30	33	44	32
13	Alaniya	30	23	43	31
14	FK Moskva	30	25	39	29
15	Elista	30	23	47	28
16	Chernomorets	30	30	49	24

TEMPORADA 2001/2002

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Rubin Kazán	34	51	14	72
2	Chernomorets	34	59	29	70
3	Tom Tomsk	34	51	23	61
4	Amkar Perm	34	47	31	54
5	FC Kuban	34	44	30	54
6	Spartak	34	42	30	53
7	FK Khimki	34	38	27	52
8	Lada	34	54	35	50
9	FK Chita	34	38	46	45
10	Soyuz	34	34	32	44
11	Kristall	34	39	43	44
12	SKA-Khabarov	34	35	37	42
13	Fakel	34	34	42	40
14	Neftekhimik	34	34	49	38
15	Volgar	34	34	51	36
16	Dynamo	34	28	56	36
17	SKA Rostov	34	38	62	31
18	Yenisey	34	24	87	16

TEMPORADA 2000/2001

PREMIER LEAGUE RUSIA
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	56	30	60
2	Lokomotiv	30	53	24	56
3	Zenit	30	52	35	56
4	Torpedo	30	53	42	52
5	Krylia	30	38	23	49
6	Saturn	30	45	22	47
7	CSKA Moskva	30	39	30	47
8	Sokol	30	31	42	41
9	Dinamo	30	43	51	38
10	Rotor	30	38	42	32
11	FK Rostov	30	29	43	32
12	Alaniya	30	31	47	32
13	Anzhi	30	28	34	32
14	FK Moskva	30	22	35	31
15	Fakel	30	30	53	28
16	Chernomorets	30	19	54	23

TEMPORADA 1999/2000

PREMIER LEAGUE RUSIA
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	69	30	70
2	Lokomotiv	30	50	20	62
3	Torpedo	30	42	29	55
4	Anzhi	30	44	31	52
5	Dinamo	30	45	35	50
6	Chernomorets	30	47	28	49
7	Zenit	30	38	26	47
8	CSKA Moskva	30	45	39	41
9	Saturn	30	26	29	40
10	Alaniya	30	34	36	38
11	Rotor	30	35	54	32
12	FK Rostov	30	24	27	32
13	Fakel	30	25	45	30
14	Krylia	30	25	45	29
15	Lokomotiv	30	16	47	18
16	Elista	30	17	61	12

TEMPORADA 1998/1999

PREMIER LEAGUE RUSIA
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	75	24	72
2	Lokomotiv	30	62	30	65
3	CSKA Moskva	30	56	29	55
4	Torpedo	30	38	33	50
5	Dinamo	30	44	41	44
6	Alaniya	30	52	46	41
7	FK Rostov	30	32	37	41
8	Zenit	30	36	34	39
9	Elista	30	27	34	36
10	Saturn	30	30	38	34
11	Lokomotiv	30	33	48	33
12	Rotor	30	37	49	32
13	Krylia	30	39	49	31
14	Chernomorets	30	30	49	29
15	Zhemchuzhina	30	29	55	26
16	Shinnik	30	21	45	24

TEMPORADA 1997/1998

PREMIER LEAGUE RUSIA
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	58	27	59
2	CSKA Moskva	30	50	22	56
3	Lokomotiv	30	45	28	55
4	Rotor	30	52	37	48
5	Zenit	30	42	25	47
6	FK Rostov	30	42	38	44
7	Elista	30	39	41	42
8	Alaniya	30	46	39	40
9	Dinamo	30	31	30	39
10	Chernomorets	30	38	38	38
11	Torpedo	30	38	34	37
12	Krylia	30	25	37	35
13	Zhemchuzhina	30	31	48	35
14	Shinnik	30	30	40	35
15	Baltika	30	32	43	32
16	Tyumen	30	17	89	8

TEMPORADA 1996/1997

PREMIER LEAGUE RUSIA
Equipo		PJ	GF	GC	Puntos
1	Spartak	34	67	30	73
2	Rotor	34	54	27	68
3	Dinamo	34	50	20	68
4	Shinnik	34	38	35	55
5	Lokomotiv	34	47	37	54
6	Chernomorets	34	40	26	53
7	Krylia	34	32	30	49
8	Zenit	34	28	29	49
9	Baltika	34	38	33	49
10	Alaniya	34	52	42	46
11	Torpedo	34	50	46	45
12	CSKA Moskva	34	31	42	42
13	FK Rostov	34	34	38	41
14	Zhemchuzhina	34	38	51	40
15	Tyumen	34	28	46	34
16	Fakel	34	25	49	26
17	Lokomotiv	34	26	60	23
18	KamAZ	34	38	75	21

Competiciones que juega

Segunda B Rusia Grupo 1

Pos	Equipos		Pts
1		Spartak Nalchik	63
2		Afips	49
3		FC Krasnodar II	48
4		Chernomorets Novorossisk	48
5		Angusht	41
6		SKA Rostov	38
7		Dinamo Stavropol	35
8		Mashuk-KMV	35
9		Akhmat Grozny II	31
10		Biolog Novokubansk	27
11		Alaniya Vladikavkaz	25
12		Mitos	23
13		Astrakhan	21
14		Druzhba Maykop	20

RIVALES EN Segunda B Rusia

USO DE MEMORIA

7,148,920 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.6182
Total Execution Time	0.6196

CADENA URL

/historico/Chernomorets-Novorossijsk/2016

GET DATOS

$_GET['/historico/Chernomorets-Novorossijsk/2016']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0154	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 = 'Chernomorets-Novorossijsk' AND l.year = 2016 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.0112	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=2938 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0115	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=2938 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0236	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 = 15682
0.0109	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2938 AND type_rel = 2
0.0121	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2938 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108	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 (509674) ORDER BY n.cover_points DESC, update_date DESC
0.0113	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 = '2938' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0113	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 = '2938' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107	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 = 15682 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112	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=2938 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0108	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 (33934,33758,30386) 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.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 33934 AND teamId = 2938
0.0110	SELECT count(id) as num_players from rel_players WHERE league_id = 33758 AND teamId = 2938
0.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 2938
0.0111	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 15682 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0109	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 = '2938' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2938' and rp.type = 4
0.0107	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 = '2938' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0118	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 events2016 e ON e.player_id = p.id AND e.league_id = 15682 WHERE rp.league_id = 15682 AND rp.teamId = 2938 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.0117	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 events2016 e ON e.player_id = p.id AND e.league_id = 15682 WHERE rp.league_id = 15682 AND rp.teamId = 2938 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112	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 events2016 e ON e.player_id = p.id AND e.league_id = 15682 WHERE rp.league_id = 15682 AND rp.teamId = 2938 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114	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 = 2938 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0118	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 = 15682 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 14064 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 4367 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 2870 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 25089 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 10498 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 10500 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116	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 = 25116 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 10502 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 12949 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 25158 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 25169 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121	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 = 12953 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 572 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116	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 = 26508 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121	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 = 570 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 569 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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 = 567 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 568 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 5807 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107	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 = 15682 ORDER BY nameShow LIMIT 100

Chernomorets Novorossisk

Chernomorets Novorossisk

Selecciona un equipo

Competiciones que juega

Segunda B Rusia Grupo 1

RIVALES EN Segunda B Rusia