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

Lorca Deportiva

Entrenador: Alberto Castillo

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Deportiva	30	46	15	71
2	Real Murcia	30	58	27	59
3	Cieza	30	39	22	58
4	UCAM Murcia	30	35	22	55
5	Caravaca	30	48	30	52
6	Lorca	30	51	26	52
7	Unión	30	49	27	50
8	Pulpileño	30	33	20	43
9	Racing	30	32	39	40
10	Muleño CF	30	33	39	37
11	El Palmar	30	33	40	36
12	Plus Ultra	30	35	48	35
13	Alcantarilla	30	30	36	31
14	CD Bullense	30	32	59	30
15	Balsicas	30	31	48	30
16	Ciudad	30	24	39	26
17	CD Algar	30	27	55	25
18	Montecasilla	30	28	72	20

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Águilas FC	30	55	15	69
2	Lorca	30	54	28	58
3	Unión Atl.	30	39	23	56
4	Racing	30	42	30	53
5	Pulpileño	30	45	33	51
6	Unión	30	44	31	50
7	Real Murcia	30	39	32	44
8	UCAM Murcia	30	35	37	41
9	Cieza	30	43	39	40
10	El Palmar	30	44	51	37
11	Ciudad	30	26	31	35
12	Caravaca	30	33	43	34
13	Deportiva	30	34	47	30
14	Alcantarilla	30	20	38	25
15	Muleño CF	30	33	63	21
16	CD Bullense	30	22	67	18

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Yeclano	34	71	21	80
2	Cartagena	34	61	32	60
3	Racing	34	48	27	57
4	UCAM Murcia	34	49	34	54
5	Unión Atl.	34	44	31	54
6	Lorca	34	52	42	53
7	Real Murcia	34	49	46	51
8	Caravaca	34	44	40	50
9	Ciudad	34	47	45	47
10	CD Bullense	34	34	50	43
11	El Palmar	34	41	44	43
12	Archena	34	48	49	43
13	Deportiva	34	39	51	42
14	Bala Azul	34	30	45	40
15	Cartagena	34	35	49	38
16	Mazarrón	34	33	48	37
17	Huércal-Ove	34	26	54	25
18	Garres	34	23	66	20

TEMPORADA 2020/2021

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Algeciras	18	21	17	32
2	Fernando	18	22	15	31
3	Sanluqueño	18	18	17	31
4	RB Linense	18	17	12	28
5	Tamaraceite	18	19	15	27
6	Cádiz	18	20	19	23
7	Palmas	18	13	16	21
8	Recreativo	18	29	27	20
9	Marbella FC	18	20	19	18
10	Marino	18	11	33	10
11	UCAM Murcia	18	22	15	33
12	Linares	18	22	16	33
13	Betis	18	23	15	30
14	Sevilla At.	18	27	19	30
15	Córdoba CF	18	21	16	27
16	Real Murcia	18	22	21	25
17	Recreativo	18	20	19	23
18	Pvo. Ejido	18	17	21	19
19	Yeclano	18	13	27	11
20	Lorca	18	15	33	9

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Lorca	28	63	23	60
2	Pulpileño	28	52	19	57
3	Racing	28	52	19	56
4	Real Murcia	28	51	28	54
5	Mazarrón	28	44	32	54
6	UCAM Murcia	28	45	30	47
7	Lorca FC	28	37	28	46
8	Minerva	28	46	38	42
9	Muleño CF	28	39	39	40
10	Garres	28	34	30	35
11	Deportiva	28	39	47	33
12	EDMF Churra	28	31	42	33
13	Cartagena	28	35	36	33
14	El Palmar	28	26	51	31
15	Huércal-Ove	28	29	34	30
16	Águilas FC	28	30	38	27
17	Cartagena	28	28	49	26
18	Olímpico	28	25	49	24
19	Ciudad	28	21	51	19
20	Plus Ultra	28	18	62	15

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Yeclano	42	88	30	89
2	Lorca	42	69	28	89
3	Lorca FC	42	73	28	80
4	EDMF Churra	42	63	50	77
5	Pulpileño	42	65	41	76
6	Águilas FC	42	56	33	74
7	Racing	42	55	49	65
8	UCAM Murcia	42	52	42	63
9	Deportiva	42	45	55	55
10	Mazarrón	42	48	56	54
11	Olímpico	42	54	64	54
12	Garres	42	36	48	53
13	Real Murcia	42	56	64	51
14	Muleño CF	42	44	59	49
15	Minerva	42	42	55	48
16	Huércal-Ove	42	56	68	48
17	Cartagena	42	51	53	48
18	Ciudad	42	43	70	44
19	Unión Atl.	42	42	55	43
20	Estudiantes	42	37	55	42
21	CD Algar	42	29	71	35
22	Cieza	42	36	66	32

TEMPORADA 2017/2018

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Cartagena	38	51	33	71
2	Marbella FC	38	49	27	70
3	Real Murcia	38	49	33	65
4	Extremadura	38	59	38	60
5	UD Melilla	38	43	24	60
6	Villanovense	38	29	33	54
7	UCAM Murcia	38	38	42	52
8	Recreativo	38	34	35	51
9	Fernando	38	47	46	49
10	Pvo. Ejido	38	54	55	49
11	RB Linense	38	44	37	48
12	CD Badajoz	38	46	44	48
13	Jumilla	38	30	42	47
14	Palmas	38	45	44	47
15	Recreativo	38	33	36	47
16	AD Mérida	38	34	42	46
17	Écija	38	38	56	45
18	Córdoba	38	40	51	43
19	Betis	38	47	61	40
20	Lorca	38	33	64	32

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Lorca	38	96	38	85
2	Lorca FC B	38	87	34	85
3	Águilas FC	38	78	30	81
4	Racing	38	54	27	67
5	Yeclano	38	61	38	65
6	Real Murcia	38	67	44	59
7	El Palmar	38	54	48	58
8	UCAM Murcia	38	71	51	55
9	Estudiantes	38	58	52	53
10	Unión Atl.	38	47	54	52
11	Cieza	38	58	66	52
12	Pulpileño	38	50	55	49
13	Huércal-Ove	38	40	59	43
14	EDMF Churra	38	53	57	42
15	Muleño CF	38	44	60	42
16	Deportiva	38	40	56	41
17	Pinatar	38	39	47	39
18	Ciudad	38	41	63	37
19	CD Algar	38	39	68	33
20	Olímpico	38	27	157	17

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Lorca	34	64	16	78
2	Águilas FC	34	62	29	77
3	El Palmar	34	71	30	66
4	Racing	34	58	39	63
5	Yeclano	34	52	27	62
6	Unión Atl.	34	51	38	59
7	Huércal-Ove	34	42	41	50
8	Real Murcia	34	45	39	49
9	Deportiva	34	56	61	46
10	Muleño CF	34	40	48	45
11	Estudiantes	34	50	42	41
12	EDMF Churra	34	37	45	41
13	Ciudad	34	45	56	36
14	Pulpileño	34	33	43	35
15	Pinatar	34	41	59	31
16	Plus Ultra	34	35	55	31
17	EF Alhama	34	39	69	26
18	Caravaca	34	29	113	16

TEMPORADA 2014/2015

PREFERENTE MURCIA
Equipo		PJ	GF	GC	Puntos
1	Lorca	34	71	31	71
2	Ciudad	34	61	27	71
3	Pulpileño	34	60	29	69
4	EDMF Churra	34	59	23	67
5	Olímpico	34	69	42	64
6	UCAM Murcia	34	64	41	57
7	Montecasilla	34	50	39	55
8	Sporting	34	48	41	52
9	CD Algar	34	52	53	50
10	Garres	34	57	57	45
11	Alquerias	34	54	49	42
12	Bala Azul	34	52	84	41
13	CD Bullense	34	51	76	35
14	Jumilla CD	34	37	59	33
15	AD Soho CF	34	55	72	32
16	Calasparra	34	45	79	32
17	Abarán CF	34	37	85	22
18	Balsicas	34	33	68	18

Comparar equipos

Lorca Deportiva

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Tercera Federaci.

USO DE MEMORIA

6,684,800 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.5638
Total Execution Time	0.5652

CADENA URL

/historico/Cf-Lorca-Deportiva

GET DATOS

$_GET['/historico/Cf-Lorca-Deportiva']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0180	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 = 'Cf-Lorca-Deportiva' 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.0128	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=13670 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=13670 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=13670 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=13670 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13670 AND type_rel = 2
0.0128	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13670 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130	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 (48848,70823,75296,90219,91778) ORDER BY n.cover_points DESC, update_date DESC
0.0131	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 = '13670' ORDER BY l.year DESC,cat.coefficient DESC
0.0146	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 = '13670' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0132	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 = '13670' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133	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=13670 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (72273,71759,71489,71432,69379) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 72273 AND teamId = 13670
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 13670
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 13670
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 69379 AND teamId = 13670
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13670
0.0129	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 = '13670' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13670' and rp.type = 4
0.0128	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 = '13670' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0171	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 = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 13670 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.0142	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 = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 13670 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 = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 13670 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 13670 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 = 67987 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.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* `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 = 62397 AND t.round = 34 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 = 58611 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.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* `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 = 50281 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 44401 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 38809 AND t.round = 38 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 = 33363 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 15455 AND t.round = 34 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 = 4096 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC