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

Shukura

Entrenador: Carlos González

Temporada 2023/2024

TEMPORADA 2022/2023

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	36	83	41	74
2	Dinamo	36	93	49	71
3	Torpedo	36	55	37	60
4	Dila Gori	36	56	39	60
5	Samgurali	36	53	51	57
6	Iberia 1999	36	58	49	51
7	Gagra	36	47	65	38
8	FC Telavi	36	34	62	37
9	Samtredia	36	50	62	33
10	Shukura	36	38	112	11

TEMPORADA 2021/2022

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Shukura	28	52	23	60
2	Spaeri	28	57	35	51
3	Samtredia	28	43	28	48
4	Merani	28	55	53	42
5	Gareji	28	38	36	36
6	Merani	28	34	56	34
7	FC Rustavi	28	34	54	23
8	WIT Georgia	28	30	58	21
9	Zugdidi	0	0	0	0
10	Shevardeni	0	0	0	0

TEMPORADA 2020/2021

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	36	73	27	75
2	Dinamo	36	59	28	70
3	Dila Gori	36	48	35	61
4	Iberia 1999	36	52	40	57
5	Locomotive	36	57	59	53
6	FC Telavi	36	35	53	44
7	Samgurali	36	34	46	41
8	Torpedo	36	38	44	40
9	Shukura	36	28	49	27
10	Samtredia	36	33	76	21

TEMPORADA 2019/2020

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Shukura	18	32	14	31
2	Samgurali	18	23	12	30
3	Gagra	18	24	10	29
4	FC Rustavi	18	35	27	26
5	Zugdidi	18	27	31	25
6	Shevardeni	18	28	38	25
7	Sioni	18	23	16	24
8	Merani	18	23	20	24
9	WIT Georgia	18	17	25	21
10	Aragvi	18	10	49	8

TEMPORADA 2018/2019

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Merani	36	87	35	81
2	Samtredia	36	63	28	77
3	FC Telavi	36	70	36	63
4	Shevardeni	36	47	48	52
5	Gagra	36	46	42	47
6	Shukura	36	36	46	46
7	Zugdidi	36	38	54	40
8	Guria	36	39	64	36
9	Kolkheti	36	31	80	34
10	Spartaki	36	38	62	32

TEMPORADA 2017/2018

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	36	60	22	76
2	WIT Georgia	36	43	23	65
3	Gagra	36	50	41	58
4	Merani	36	54	47	51
5	FC Telavi	36	45	43	48
6	Shevardeni	36	38	49	43
7	Shukura	36	48	56	41
8	Samgurali	36	40	56	41
9	Spartaki	36	36	66	36
10	Merani	36	36	47	36

TEMPORADA 2016/2017

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Torpedo	36	59	27	76
2	Dinamo	36	79	29	75
3	Samtredia	36	62	39	68
4	Iberia 1999	36	61	42	60
5	Chikhura	36	47	54	55
6	Locomotive	36	63	53	53
7	Dila Gori	36	41	51	41
8	Dinamo	36	28	60	33
9	Kolkheti	36	31	73	26
10	Shukura	36	35	78	21

TEMPORADA 2015/2016

TRANSICIÓN LIGA GEORGIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Samtredia	12	27	9	27
2	Dinamo	12	20	5	20
3	Iberia 1999	12	17	12	19
4	Kolkheti	12	10	18	18
5	Dila Gori	12	13	12	17
6	Sioni	12	13	19	11
7	Zugdidi	12	5	30	6
8	Chikhura	12	27	11	29
9	Dinamo	12	17	5	23
10	Torpedo	12	16	12	15
11	Locomotive	12	11	18	15
12	Shukura	12	10	13	12
13	Guria	12	8	21	11
14	Spartaki	12	12	21	9

TEMPORADA 2014/2015

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dila Gori	30	50	21	64
2	Dinamo	30	40	24	58
3	Dinamo	30	56	28	58
4	Spartaki	30	47	37	53
5	Chikhura	30	39	36	46
6	Samtredia	30	40	31	45
7	Torpedo	30	39	33	41
8	Shukura	30	36	38	41
9	Guria	30	38	43	39
10	Kolkheti	30	31	31	37
11	Merani	30	29	33	36
12	Zugdidi	30	24	45	33
13	Sioni	30	32	46	32
14	FC Rustavi	30	25	46	26
15	WIT Georgia	30	27	40	26
16	Zestafoni	30	40	61	26

TEMPORADA 2013/2014

SEGUNDA GEORGIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Shukura	24	72	23	57
2	Kolkheti	24	51	13	55
3	Dinamo	24	76	27	49
4	Gagra	24	44	25	42
5	Sapovnela	24	40	25	41
6	Algeti	24	38	37	34
7	Meshakhte	24	37	38	32
8	Chkherimela	24	29	54	23
9	Mertskhali	24	29	54	23
10	Skuri	24	24	52	22
11	Adeli	24	28	60	22
12	Imereti	24	26	56	21
13	FC Telavi	24	27	57	18

TEMPORADA 2012/2013

SEGUNDA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Spartaki	30	82	15	77
2	Locomotive	30	70	29	63
3	Shukura	30	56	25	61
4	Kolkheti	30	43	28	57
5	Samtredia	30	53	37	55
6	Samgurali	30	59	48	46
7	Algeti	30	39	55	33
8	Mertskhali	30	37	52	25
9	Chkherimela	30	34	91	20
10	Liakhvi	30	29	74	18
11	Adeli	30	27	75	15
12	Aeti Sokhumi	0	0	0	0

TEMPORADA 2003/2004

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Shukura	30	54	28	61
2	Samgurali	30	39	19	58
3	Milani	30	38	26	52
4	FC Rustavi	30	46	31	51
5	Dinamo	30	68	36	50
6	Chikhura	30	41	29	50
7	Tbilisi	30	38	31	50
8	TSU Tbilisi	30	59	30	47
9	Spartaki	30	45	25	46
10	Guria	30	38	37	45
11	Georgia	30	31	22	44
12	FC Ameri	30	34	24	43
13	Iveria	30	29	42	39
14	Samtredia	30	22	77	19
15	Luka Batumi	30	29	85	16
16	Metalurgi	30	18	87	7

TEMPORADA 2002/2003

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Lazika	30	64	30	64
2	Mertskhali	30	62	29	64
3	FK Mtskheta	30	50	23	58
4	Samgurali	30	42	26	53
5	Spartaki	30	49	31	49
6	Spartaki	30	37	26	48
7	Shukura	30	27	23	48
8	Dinamo	30	37	29	45
9	Locomotive	30	32	25	44
10	TSU Tbilisi	30	28	33	38
11	Iveria	30	39	41	37
12	Guria	30	32	44	34
13	Tbilisi	30	38	46	32
14	Kolkheti	30	17	44	23
15	Alazani	30	30	77	21
16	Samtredia	30	24	81	11

TEMPORADA 2001/2002

SEGUNDA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Milani	10	17	6	23
2	Shukura	10	11	6	21
3	Dila Gori	10	19	13	19
4	TSU Tbilisi	10	14	10	19
5	Locomotive	10	13	18	6
6	Spartaki	10	4	25	0

TEMPORADA 2000/2001

SEGUNDA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Guria	10	15	9	41
2	Samgurali	10	13	7	38
3	Metalurgi	10	12	12	38
4	Milani	10	16	7	37
5	Spartaki	10	9	15	29
6	Shukura	10	4	19	23

TEMPORADA 1999/2000

SEGUNDA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Margveti	22	71	18	58
2	Okeane	22	51	23	45
3	Samtredia	22	47	26	42
4	Metalurgi	22	42	27	41
5	Torpedo	22	34	30	33
6	Gagra	22	31	37	26
7	Racha	22	31	37	25
8	Guria	22	36	45	22
9	Rtsmena	22	16	29	22
10	Sulori Vani	22	30	54	21
11	Chiatura	22	28	47	15
12	Meshakhte	22	24	68	13
13	Shukura	22	66	20	56
14	Dinamo	22	65	21	51
15	Megri	22	40	17	50
16	Kolkheti	22	34	15	46
17	Lazika	22	56	24	41
18	Pazisi Poti	22	36	37	33
19	Skuri	22	26	52	21
20	Dinamo	22	26	38	20
21	Samegrelo	22	23	43	20
22	Mertskhali	22	20	43	16
23	Chela	22	19	56	10
24	Bakhmaro	22	18	63	8

TEMPORADA 1993/1994

LIGA GEORGIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	FC Rustavi	16	43	19	30
2	Zugdidi	16	38	19	29
3	Sapovnela	16	28	23	29
4	Kakheti	16	45	32	28
5	Samgurali	16	27	29	28
6	Alazani	16	25	25	27
7	Shukura	16	18	29	22
8	Chiatura	16	27	47	14
9	Mretebi	16	11	39	2

Comparar equipos

Shukura

Selecciona un equipo

Competiciones que juega

USO DE MEMORIA

6,320,400 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1217
Total Execution Time	0.1229

CADENA URL

/historico/Shukura

GET DATOS

$_GET['/historico/Shukura']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0028	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 = 'Shukura' 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.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17569 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=17569 AND type_rel = 2
0.0023	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 = '17569' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '17569' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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=17569 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (71651,71432,70913) 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.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 70913 AND teamId = 17569
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71651 AND teamId = 17569
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17569
0.0029	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 17569 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.0030	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 = 17569 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0072	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 = 17569 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 17569 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 70913 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 66336 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 61212 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 55078 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.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* `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 = 42858 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 37977 AND t.round = 36 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* `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 = 15498 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 33343 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 4149 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 3587 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 15183 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 15194 AND t.round = 30 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* `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 = 15195 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 15196 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 15197 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 15199 AND t.round = 22 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* `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 = 15200 AND t.round = 10 ORDER BY team.conference 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* `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 = 15203 AND t.round = 22 ORDER BY team.conference 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* `tables1994` 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 = 14464 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC