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

Luch Vladivostok

Temporada 2023/2024

TEMPORADA 2021/2022

LIGA DE FÚTBOL AMATEUR DE RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rosich	19	75	16	49
2	Zelenograd	19	56	18	45
3	FSHM Moscow	19	46	20	41
4	Letniy	19	28	32	24
5	FK Rim	19	33	40	23
6	Luch	19	23	34	23
7	Avrora	19	33	50	21
8	Rodina	19	25	42	18
9	Lokomotiv	19	24	53	16
10	FK Kurkino	19	29	67	13

TEMPORADA 2020/2021

LIGA DE FÚTBOL AMATEUR DE RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rosich	30	119	19	81
2	Zelenograd	30	106	29	70
3	Sakhalinets	30	96	21	64
4	FSHM Moscow	30	88	46	61
5	Sportakademk	30	76	50	60
6	Geraklion	30	79	43	53
7	Avrora	30	69	65	52
8	DYuSSh-75	30	64	56	51
9	Rodina	30	92	62	49
10	Letniy	30	51	72	39
11	Lokomotiv	30	45	58	38
12	Luch	30	60	84	32
13	Yunost	30	33	83	25
14	Trudovye	30	28	130	11
15	Smena Moskva	30	28	127	8
16	Stolitsa	30	30	119	2

TEMPORADA 2019/2020

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Rotor	27	41	21	56
2	FK Khimki	27	50	19	54
3	Chertanovo	27	37	19	54
4	Torpedo	27	39	25	53
5	Neftekhimik	27	38	25	48
6	SKA-Khabarov	27	42	30	43
7	Baltika	27	34	23	43
8	Shinnik	27	43	35	43
9	Tom Tomsk	27	32	26	39
10	Chayka	27	31	29	38
11	Nizhny	27	28	29	36
12	FC Armavir	27	23	29	30
13	Avangard	27	29	39	29
14	Yenisey	27	23	40	28
15	Krasnodar	27	32	34	28
16	Luch	27	28	40	27
17	Spartak	27	38	45	26
18	Tekstilshchi	27	25	52	19
19	Fakel	27	14	44	19
20	Mordovia	27	21	44	19

TEMPORADA 2018/2019

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Tambov	38	55	35	73
2	Sochi	38	63	34	69
3	Tom Tomsk	38	40	25	64
4	Nizhny	38	41	31	62
5	Chertanovo	38	65	53	61
6	Shinnik	38	42	31	60
7	SKA-Khabarov	38	46	41	58
8	Avangard	38	48	42	56
9	FK Khimki	38	47	49	53
10	Krasnodar	38	45	52	51
11	Rotor	38	34	36	50
12	Luch	38	29	28	47
13	Mordovia	38	37	46	47
14	Spartak	38	45	47	46
15	FC Armavir	38	32	44	44
16	Baltika	38	38	52	42
17	Fakel	38	36	40	41
18	Sibir	38	28	45	37
19	Tyumen	38	30	46	31
20	Zenit II	38	33	57	28

TEMPORADA 2017/2018

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	FC Orenburg	38	59	26	84
2	Krylia	38	60	23	82
3	Yenisey	38	68	32	81
4	Tambov	38	57	36	68
5	Baltika	38	44	35	64
6	Dynamo	38	52	47	55
7	Shinnik	38	45	45	53
8	Sibir	38	38	31	53
9	FC Kuban	38	47	47	49
10	Volgar	38	40	46	45
11	Avangard	38	43	46	45
12	Nizhny	38	37	50	44
13	FK Khimki	38	33	49	43
14	Spartak	38	47	64	42
15	Tom Tomsk	38	36	56	41
16	Luch	38	40	52	40
17	Zenit II	38	43	59	40
18	Rotor	38	38	45	40
19	Tyumen	38	41	54	39
20	Fakel	38	27	52	35

TEMPORADA 2016/2017

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	38	64	25	87
2	Tosno	38	63	30	75
3	Yenisey	38	54	42	63
4	SKA-Khabarov	38	45	33	59
5	Tambov	38	42	34	57
6	Spartak	38	56	43	56
7	FC Kuban	38	44	37	55
8	Shinnik	38	41	39	54
9	Tyumen	38	48	43	53
10	Fakel	38	38	40	53
11	FK Khimki	38	40	47	49
12	Volgar	38	39	49	45
13	Zenit II	38	44	51	43
14	Sibir	38	31	46	42
15	Baltika	38	25	35	42
16	Luch	38	27	41	42
17	Mordovia	38	39	50	40
18	Sokol	38	34	53	39
19	Spartak	38	26	37	38
20	Neftekhimik	38	28	53	27

TEMPORADA 2015/2016

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	FC Orenburg	38	61	20	86
2	Arsenal Tula	38	64	36	82
3	Tom Tomsk	38	58	35	74
4	Volgar	38	57	37	63
5	Spartak	38	52	49	59
6	Fakel	38	51	42	56
7	Tosno	38	57	53	55
8	Tyumen	38	44	45	54
9	Sokol	38	43	38	53
10	Volga	38	39	37	51
11	Sibir	38	47	50	51
12	Shinnik	38	50	49	50
13	Zenit II	38	61	56	50
14	SKA-Khabarov	38	36	35	49
15	Luch	38	31	46	45
16	Yenisey	38	36	49	44
17	Baltika	38	37	47	44
18	FC Armavir	38	28	44	40
19	Radian-Bayka	38	29	73	26
20	KamAZ	38	20	60	24

TEMPORADA 2014/2015

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Krylia	34	53	19	73
2	Anzhi	34	60	22	71
3	Tosno	34	50	36	65
4	Tom Tomsk	34	57	34	64
5	FC Orenburg	34	52	31	58
6	Shinnik	34	44	33	53
7	Volgar	34	48	39	52
8	Tyumen	34	41	38	42
9	Yenisey	34	39	42	42
10	Luch	34	40	46	42
11	Sibir	34	35	46	42
12	Sokol	34	38	41	41
13	Volga	34	44	57	40
14	Baltika	34	25	37	37
15	SKA-Khabarov	34	32	46	37
16	Sakhalin	34	28	50	35
17	Khimik	34	35	59	27
18	Dynamo	34	18	63	13

TEMPORADA 2013/2014

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Mordovia	36	59	30	73
2	Arsenal Tula	36	62	39	69
3	Torpedo	36	45	22	65
4	FC Orenburg	36	46	28	61
5	Ufa	36	46	35	61
6	Shinnik	36	47	37	57
7	SKA-Khabarov	36	43	34	56
8	Luch	36	40	25	55
9	Baltika	36	39	31	54
10	Spartak	36	36	34	51
11	Sibir	36	38	39	51
12	Alaniya	35	29	52	46
13	Yenisey	36	40	47	45
14	Dynamo	36	38	46	43
15	Rotor	36	43	40	41
16	Khimik	36	29	49	37
17	Neftekhimik	36	38	45	33
18	Salyut	35	23	53	27
19	Angusht	36	23	78	14

TEMPORADA 2012/2013

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Luch	30	48	27	62
2	FK Chita	30	42	22	59
3	Amur-2010	30	50	21	55
4	Sakhalin	30	42	23	55
5	Smena	30	41	29	50
6	Dinamo	30	41	44	37
7	Yakutiya	30	37	46	35
8	Radian-Bayka	30	36	61	28
9	Irtysh Omsk	30	37	62	24
10	Sibiryak	30	27	50	23
11	Sibir	30	33	49	21

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

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	FC Kuban	38	51	20	80
2	Volga	38	62	25	71
3	Nizhny	38	60	41	70
4	KamAZ	38	55	43	66
5	Krasnodar	38	60	44	61
6	Mordovia	38	53	40	58
7	Ural	38	38	28	58
8	Zhemchuzhina	38	45	44	57
9	Volgar	38	45	48	57
10	Shinnik	38	43	31	55
11	SKA-Khabarov	38	37	39	53
12	Luch	38	42	42	52
13	FK Khimki	38	39	38	50
14	Dinamo	38	53	54	44
15	Baltika	38	38	47	43
16	Dynamo	38	32	53	37
17	Salyut	38	30	47	34
18	Rotor	38	27	64	34
19	Irtysh Omsk	38	26	52	28
20	Avangard	38	31	67	27

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

PREMIER LEAGUE RUSIA
Equipo		PJ	GF	GC	Puntos
1	Rubin Kazán	30	44	26	60
2	CSKA Moskva	30	53	24	56
3	Dinamo	30	41	29	54
4	Amkar Perm	30	31	22	51
5	Zenit	30	59	37	48
6	Krylia	30	46	28	48
7	Lokomotiv	30	37	32	47
8	Spartak	30	43	39	44
9	FK Moskva	30	34	36	38
10	Akhmat	30	28	42	35
11	Saturn	30	26	30	33
12	Spartak	30	30	39	32
13	Tom Tomsk	30	23	39	29
14	FK Khimki	30	34	54	27
15	Shinnik	30	25	48	22
16	Luch	30	24	53	21

TEMPORADA 2006/2007

PREMIER LEAGUE RUSIA
Equipo		PJ	GF	GC	Puntos
1	Zenit	30	54	32	61
2	Spartak	30	50	30	59
3	CSKA Moskva	30	43	24	53
4	FK Moskva	30	40	32	52
5	Saturn	30	34	28	45
6	Dinamo	30	37	35	41
7	Lokomotiv	30	39	42	41
8	Amkar Perm	30	30	27	41
9	FK Khimki	30	32	33	37
10	Rubin Kazán	30	31	39	35
11	Tom Tomsk	30	37	35	35
12	Spartak	30	29	38	33
13	Krylia	30	35	46	32
14	Luch	30	26	39	32
15	FC Kuban	30	27	38	32
16	FK Rostov	30	18	44	18

TEMPORADA 2005/2006

PREMIER LEAGUE RUSIA
Equipo		PJ	GF	GC	Puntos
1	CSKA Moskva	30	47	28	58
2	Spartak	30	60	36	58
3	Lokomotiv	30	47	34	53
4	Zenit	30	42	30	50
5	Rubin Kazán	30	43	37	46
6	FK Moskva	30	41	37	43
7	Luch	30	37	39	41
8	Tom Tomsk	30	35	33	41
9	Spartak	30	33	32	41
10	Krylia	30	37	35	38
11	Saturn	30	29	24	37
12	FK Rostov	30	42	48	36
13	Amkar Perm	30	22	36	35
14	Dinamo	30	31	40	34
15	Torpedo	30	22	40	22
16	Shinnik	30	17	56	11

TEMPORADA 2004/2005

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Luch	42	81	32	92
2	Spartak	42	67	36	86
3	KamAZ	42	80	32	84
4	FK Khimki	42	75	36	82
5	FC Kuban	42	55	25	81
6	Dynamo	42	64	41	76
7	Ural	42	51	34	73
8	FC Oryol	42	55	48	63
9	Spartak	42	60	53	61
10	Sibir	42	51	53	56
11	Anzhi	42	47	48	55
12	SKA-Khabarov	42	40	43	54
13	Dinamo	42	44	49	52
14	Volgar	42	50	56	51
15	FK Chita	42	57	67	50
16	Avangard	42	36	45	48
17	Fakel	42	39	60	46
18	Metallurg-Ku	42	48	61	45
19	Amur-2010	42	44	70	37
20	Metallurg	42	40	78	26
21	Dynamo	42	37	107	26
22	Sokol	42	37	84	25

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

SEGUNDA B RUSIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Luch	24	53	23	52
2	Dinamo	24	41	22	47
3	Zvezda	24	39	18	43
4	Irtysh Omsk	24	28	28	43
5	Smena	24	44	21	42
6	Sibir	24	38	27	40
7	Sibiryak	24	31	24	39
8	Amur-2010	24	27	22	32
9	Okean	23	19	24	32
10	Chkalovets-O	24	23	35	22
11	Yenisey	24	18	38	16
12	Burevestnik-	24	24	57	13
13	Selenga	25	16	62	13

Comparar equipos

Luch Vladivostok

Selecciona un equipo

Competiciones que juega

USO DE MEMORIA

7,410,888 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1547
Total Execution Time	0.1560

CADENA URL

/historico/Luch-Vladivostok

GET DATOS

$_GET['/historico/Luch-Vladivostok']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0037	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 = 'Luch-Vladivostok' 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=1597 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=1597 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1597 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1597 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (192832,404171,414606) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '1597' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '1597' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027	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 = '1597' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028	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=1597 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (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.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1597
0.0022	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1597' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1597' and rp.type = 4
0.0021	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1597' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028	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 = 1597 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.0027	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 = 1597 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0089	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 = 1597 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 1597 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* `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 = 67358 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.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* `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 = 62438 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* `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 = 49957 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 43602 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 38675 AND t.round = 38 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* `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 = 33004 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 15403 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 3881 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 2478 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 25084 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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.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* `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.0030	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 = 10501 AND t.round = 40 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* `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.0036	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 = 318 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* `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 = 237 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 238 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 12952 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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.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* `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 = 26563 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC