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

Zenit Izhevsk

Temporada 2023/2024

TEMPORADA 2022/2023

SEGUNDA B RUSIA - TRANSICIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Torpedo	16	33	12	36
2	Khimik-Avgus	16	19	6	31
3	Rubin Kazán	16	15	14	26
4	NoSta	16	19	14	25
5	Ural II	16	20	20	21
6	Uralets	16	8	12	18
7	Dinamo	16	28	29	17
8	Orenburg II	16	14	24	15
9	Akron	16	9	34	3

TEMPORADA 2021/2022

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Volga	28	57	20	62
2	Chelyabinsk	28	56	24	62
3	Tyumen	28	79	30	60
4	Zvezda Perm	28	52	28	52
5	Amkar Perm	28	43	28	52
6	Novosibirsk	28	40	24	50
7	Ural II	28	48	39	42
8	Irtysh Omsk	28	50	49	38
9	Torpedo	28	33	41	35
10	Spartak	28	45	67	32
11	Orenburg II	28	31	52	27
12	Dinamo	28	29	42	26
13	NoSta	28	23	54	21
14	Zenit	28	20	55	16
15	Lada	28	25	78	11

TEMPORADA 2020/2021

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tyumen	28	55	22	63
2	KamAZ	27	72	25	61
3	Volga	28	45	15	59
4	Chelyabinsk	27	59	22	56
5	Zvezda Perm	26	54	23	55
6	Novosibirsk	27	50	25	55
7	Dinamo	27	30	38	41
8	NoSta	26	38	34	36
9	Ural II	28	39	40	35
10	Volna	28	32	39	35
11	Lada Sok	28	33	34	27
12	Zenit	27	31	40	22
13	Lada	28	15	100	13
14	Orenburg II	28	15	70	12
15	Krylia	27	22	63	9

TEMPORADA 2019/2020

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Akron	17	29	16	38
2	Chelyabinsk	17	34	17	36
3	Ural II	17	34	16	35
4	KamAZ	17	37	23	32
5	Tyumen	17	25	21	26
6	Lada Sok	17	19	18	24
7	Zvezda Perm	17	20	20	22
8	NoSta	17	23	26	22
9	Volga	17	19	26	20
10	Zenit	17	27	27	18
11	Lada	17	12	47	10
12	Ufa II	17	17	39	6

TEMPORADA 2018/2019

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Neftekhimik	25	53	14	63
2	KamAZ	25	44	25	45
3	Syzran-2003	25	32	30	41
4	Zvezda Perm	25	39	34	37
5	Volga	25	26	25	37
6	NoSta	25	39	43	37
7	Zenit	24	30	29	32
8	Chelyabinsk	24	29	24	28
9	Ural II	24	37	43	24
10	Ufa II	24	23	44	18
11	Lada	24	16	57	14

TEMPORADA 2017/2018

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Mordovia	24	38	8	56
2	Chelyabinsk	24	41	19	49
3	Syzran-2003	24	35	22	46
4	KamAZ	24	37	19	45
5	Neftekhimik	24	42	21	42
6	Zenit	24	28	17	42
7	Volga	24	33	17	41
8	NoSta	23	37	30	33
9	Lada	24	25	51	25
10	Ural II	24	19	33	17
11	Anzhi-Junior	23	18	38	16
12	Orenburg II	24	15	45	13
13	Krylia	24	15	63	11
14	Dinamo Kirov	0	0	0	0

TEMPORADA 2016/2017

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Nizhny	24	47	17	55
2	Zenit	24	47	18	51
3	Chelyabinsk	24	37	21	39
4	Syzran-2003	24	21	21	35
5	NoSta	24	31	39	33
6	Volga	24	23	25	31
7	KamAZ	24	23	25	29
8	Lada	24	15	41	21
9	Dinamo Kirov	24	15	52	9

TEMPORADA 2015/2016

SEGUNDA B RUSIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Neftekhimik	27	56	15	60
2	Zenit	27	49	25	54
3	Nizhny	27	38	19	53
4	Syzran-2003	27	35	29	46
5	Chelyabinsk	27	41	27	44
6	Volga	27	33	32	35
7	NoSta	27	33	41	28
8	Khimik	27	28	54	25
9	Lada	27	23	56	22
10	Dinamo Kirov	27	18	56	9

TEMPORADA 2014/2015

SEGUNDA B RUSIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	FC Armavir	12	19	9	28
2	Vityaz	12	25	12	25
3	Afips	12	22	9	24
4	Dinamo	12	16	12	23
5	Chernomorets	12	26	12	22
6	Spartak	12	11	13	13
7	Mashuk-KMV	12	14	18	13
8	Druzhba	12	11	15	12
9	Biolog	12	10	14	12
10	Mitos	12	11	22	12
11	FK Taganrog	12	10	23	11
12	Angusht	12	9	25	6
13	Syzran-2003	5	8	1	11
14	KamAZ	5	4	5	7
15	Rubin Kazan	5	5	5	6
16	Zenit	5	5	6	5
17	Chelyabinsk	5	3	5	5
18	Volga	5	2	5	5

TEMPORADA 2013/2014

SEGUNDA B RUSIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Tyumen	22	34	13	53
2	Volga	23	34	20	53
3	KamAZ	23	41	30	42
4	Chelyabinsk	22	38	19	38
5	Syzran-2003	22	29	18	36
6	Zenit	22	21	13	33
7	Lada	22	26	28	27
8	NoSta	22	24	30	20
9	Oktan Perm	22	12	31	17
10	Spartak	22	17	33	16
11	Rubin Kazan	22	14	44	14
12	Dinamo Kirov	22	9	20	13

TEMPORADA 2012/2013

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	FC Orenburg	28	54	15	69
2	Tyumen	28	56	15	66
3	Volga	28	37	17	52
4	Chelyabinsk	28	42	23	50
5	Lada	28	39	28	48
6	Zenit	28	47	37	47
7	Syzran-2003	28	34	21	42
8	Rubin Kazan	28	29	35	35
9	Gornyak	28	22	40	31
10	Dinamo Kirov	28	16	19	30
11	KamAZ	28	23	29	30
12	NoSta	28	21	38	23
13	Oktan Perm	28	21	47	22
14	Akademiya	28	16	57	20
15	Spartak	28	26	62	12

TEMPORADA 2011/2012

SEGUNDA B RUSIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Neftekhimik	39	68	25	86
2	Ufa	39	54	19	86
3	Volga	39	54	31	73
4	Akademiya	39	61	36	65
5	Chelyabinsk	39	42	28	64
6	Tyumen	39	52	35	63
7	Gornyak	39	57	45	58
8	Syzran-2003	39	42	48	49
9	Khimik	39	41	52	48
10	Zenit	39	50	52	46
11	Oktan Perm	39	44	65	41
12	Rubin Kazan	39	32	57	29
13	Dinamo Kirov	39	23	64	26
14	NoSta	39	19	82	17

TEMPORADA 2003/2004

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Ural	36	68	18	87
2	Spartak	36	69	20	83
3	Lada	36	55	20	66
4	NoSta	36	54	29	66
5	Energetik	36	52	33	61
6	Neftyanik	36	56	43	60
7	Alnas	36	43	28	59
8	Dinamo Kirov	36	56	32	57
9	Volga	36	50	40	54
10	Rubin Kazan	36	47	43	52
11	FC Orenburg	36	39	42	46
12	Volga	36	41	46	45
13	Chelyabinsk	36	40	50	44
14	Uralets NT	36	35	43	41
15	Tobol Kurgan	36	30	50	36
16	Lokomotiv	36	33	54	34
17	Sodovik	36	43	81	34
18	Akademiya	36	19	78	19
19	Zenit	36	11	91	10

TEMPORADA 2002/2003

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	KamAZ	38	85	20	94
2	Spartak	38	85	27	93
3	Sodovik	38	87	24	90
4	Zenit	76	70	99	89
5	Volga	38	58	21	79
6	NoSta	38	66	38	77
7	Energetik	38	48	32	65
8	FC Orenburg	38	45	41	62
9	Neftyanik	38	47	41	51
10	Alnas	38	40	49	43
11	Lokomotiv	38	42	54	43
12	Akademiya	38	35	51	41
13	Volga	38	41	62	38
14	Uralets NT	38	39	63	38
15	Tobol Kurgan	38	39	65	36
16	Dinamo Kirov	38	27	61	34
17	Energiya	38	39	72	32
18	Metallurg	38	37	70	31
19	Spartak	38	30	70	31

TEMPORADA 2001/2002

SEGUNDA B RUSIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ural	28	55	11	71
2	Sodovik	28	59	12	68
3	Spartak	28	58	17	68
4	FC Orenburg	28	40	19	55
5	Neftyanik	28	51	30	54
6	KamAZ	28	41	24	51
7	Chelyabinsk	28	31	26	49
8	Dinamo Kirov	28	40	35	35
9	Alnas	28	36	49	35
10	Uralets NT	28	28	50	31
11	Metallurg	28	25	42	22
12	NoSta	28	23	46	22
13	Zenit	28	17	49	19
14	Energiya	28	19	64	15
15	Dynamo Perm	28	16	65	10

TEMPORADA 2000/2001

SEGUNDA B RUSIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ural	30	83	11	83
2	Sodovik	30	75	21	68
3	KamAZ	30	81	26	64
4	NoSta	30	76	25	59
5	Alnas	30	54	32	54
6	FC Orenburg	30	43	28	52
7	Chelyabinsk	30	43	24	47
8	Metallurg	30	45	43	45
9	Dinamo Kirov	30	42	41	42
10	Torpedo	30	32	36	40
11	Uralets NT	30	50	48	39
12	Dynamo Perm	30	35	46	33
13	Berezniki	30	30	58	29
14	Zenit	30	17	52	17
15	Energiya	30	11	109	8
16	Tobol Kurgan	30	11	128	6

TEMPORADA 1999/2000

SEGUNDA B RUSIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Neftekhimik	30	82	18	82
2	Ural	30	72	21	73
3	KamAZ	30	80	23	64
4	Tyumen	30	53	25	57
5	Sodovik	30	46	25	53
6	Metallurg	30	50	39	53
7	Chelyabinsk	30	50	47	46
8	Uralets NT	30	44	47	45
9	FC Orenburg	30	38	42	44
10	Torpedo	30	26	39	39
11	Dynamo Perm	30	30	59	29
12	Energiya	30	34	57	27
13	Dinamo Kirov	30	24	58	25
14	Zenit	30	29	66	21
15	Spartak	30	19	63	13
16	Tobol Kurgan	30	24	72	13

Comparar equipos

Zenit Izhevsk

Selecciona un equipo

Competiciones que juega

Grupo 4

USO DE MEMORIA

6,640,696 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.5831
Total Execution Time	0.5852

CADENA URL

/historico/Zenit-Izhevsk

GET DATOS

$_GET['/historico/Zenit-Izhevsk']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0152	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 = 'Zenit-Izhevsk' 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.0127	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=13441 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=13441 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13441 AND type_rel = 2
0.0137	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 = '13441' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0137	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 = '13441' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136	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=13441 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133	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 (72437,71608,71432,68667) 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.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 71608 AND teamId = 13441
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 72437 AND teamId = 13441
0.0182	SELECT count(id) as num_players from rel_players WHERE league_id = 68667 AND teamId = 13441
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13441
0.0136	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 = '13441' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13441' and rp.type = 4
0.0136	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 = '13441' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147	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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 13441 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.0138	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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 13441 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 13441 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 13441 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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 = 68307 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 71608 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 72437 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 63372 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.0129	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 = 57518 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.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* `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 = 50437 AND t.round = 17 ORDER BY team.conference ASC,t.position 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* `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 = 44475 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 39157 AND t.round = 26 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* `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 = 33932 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 15684 AND t.round = 27 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* `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 = 4370 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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.0145	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 = 2868 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* `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 = 25092 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 25114 AND t.round = 39 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* `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 = 26561 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC