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

CD Pedroñeras

Temporada 2019/2020

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 18
Equipo		PJ	GF	GC	Puntos
1	Yugo	28	50	15	61
2	Quintanar	28	44	22	54
3	CD Toledo	28	46	19	49
4	Guadalajara	27	32	18	48
5	Atlético	27	40	22	47
6	Puertollano	28	39	24	46
7	Conquense	27	40	30	46
8	CD Tarancon	28	39	33	42
9	Atlético	28	46	39	40
10	Solana	28	26	25	39
11	CD Torrijos	28	33	39	37
12	CD Azuqueca	28	44	53	33
13	Manchego	28	28	29	31
14	Villacañas	28	26	36	31
15	La Roda CF	28	26	36	29
16	Almagro CF	28	24	47	27
17	CD Illescas	28	27	39	27
18	Pedroñeras	28	20	44	26
19	Madridejos	28	20	47	23
20	UD Almansa	27	27	60	22

TEMPORADA 2018/2019

PREFERENTE C. LA MANCHA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pedroñeras	34	67	16	80
2	UD Almansa	34	77	27	79
3	Huracan	34	51	20	71
4	La Gineta	34	70	28	68
5	Manzanares	34	58	41	65
6	Miguelturre�	34	49	54	49
7	Clemente	34	51	41	46
8	AD Campillo	34	49	46	45
9	Daimiel	34	36	40	45
10	Fuente	34	51	60	45
11	UD Carrión	34	46	52	44
12	Sporting	34	45	57	40
13	Cultural	34	51	65	39
14	Miguel	34	47	58	38
15	Membrilla	34	29	47	38
16	Hellin CF	34	26	61	25
17	Caudetano	34	35	79	23
18	Atletico	34	21	67	19

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 18
Equipo		PJ	GF	GC	Puntos
1	Conquense	38	69	37	80
2	Villarrobled	38	81	33	79
3	Yugo	38	80	34	71
4	Villarrubia	38	56	39	65
5	Atlético	38	58	39	64
6	Guadalajara	38	59	40	64
7	Atlético	38	52	42	60
8	Mora CF	38	53	45	59
9	Manchego	38	35	53	53
10	CD Azuqueca	38	52	44	51
11	La Roda CF	38	43	49	47
12	Marchamalo	38	49	55	44
13	Madridejos	38	34	62	44
14	Villacañas	38	44	53	43
15	Atlético	38	49	54	43
16	Quintanar	38	37	56	41
17	Almagro CF	38	33	48	41
18	Pedroñeras	38	35	53	36
19	UD Almansa	38	41	59	34
20	Miguelturre�	38	24	89	18

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 18
Equipo		PJ	GF	GC	Puntos
1	CF Talavera	38	89	37	83
2	Conquense	38	74	43	75
3	Villarrobled	38	75	42	70
4	Guadalajara	38	64	43	70
5	Villarrubia	38	61	38	67
6	UD Almansa	38	68	54	63
7	Manchego	38	53	40	62
8	Quintanar	38	61	52	52
9	CD Azuqueca	38	67	57	52
10	Madridejos	38	43	53	51
11	Marchamalo	38	43	49	50
12	Almagro CF	38	44	52	49
13	Atlético	38	46	53	48
14	Mora CF	38	46	66	46
15	Atlético	38	49	56	45
16	Pedroñeras	38	46	45	45
17	CD Toledo B	38	47	61	44
18	CD Illescas	38	56	82	39
19	UD Carrión	38	37	90	26
20	CD Yuncos	38	24	80	16

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 18
Equipo		PJ	GF	GC	Puntos
1	Conquense	38	54	26	76
2	Almagro CF	38	64	33	76
3	CD Azuqueca	38	58	31	70
4	UD Almansa	38	54	35	66
5	Quintanar	38	38	29	62
6	Madridejos	38	47	45	60
7	CD Illescas	38	50	47	58
8	Villarrobled	38	44	38	54
9	Marchamalo	38	51	53	52
10	Manchego	38	41	36	51
11	CD Toledo B	38	50	48	51
12	Villarrubia	38	34	34	48
13	Pedroñeras	38	36	42	48
14	Atlético	38	47	51	46
15	Mora CF	38	43	48	46
16	Manzanares	38	39	43	45
17	Atlético	38	29	42	42
18	La Gineta	38	41	61	32
19	Jose Obrero	38	37	70	31
20	Munera	38	28	73	22

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 18
Equipo		PJ	GF	GC	Puntos
1	CF Talavera	38	85	27	84
2	UD Almansa	38	62	32	79
3	Quintanar	38	48	19	75
4	Manzanares	38	59	24	73
5	Madridejos	38	43	21	72
6	Villarrubia	38	50	35	65
7	Marchamalo	38	55	51	59
8	Mora CF	38	51	39	57
9	Villarrobled	38	58	49	54
10	Puertollano	38	54	46	53
11	Pedroñeras	38	45	37	51
12	CD Toledo B	38	47	55	50
13	Atlético	38	42	40	48
14	Atlético	38	59	56	47
15	Manchego	38	47	57	46
16	Almagro CF	38	43	44	44
17	La Gineta	38	39	53	43
18	Daimiel	38	39	67	40
19	Gimnástico	38	21	117	11
20	Hellin	38	3	81	2

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 18
Equipo		PJ	GF	GC	Puntos
1	Puertollano	38	88	18	98
2	Yugo	38	72	26	83
3	Villarrobled	38	80	32	76
4	UD Almansa	38	53	36	72
5	CF Talavera	38	72	34	72
6	Villarrubia	38	48	56	58
7	Pedroñeras	38	42	50	54
8	La Gineta	38	51	55	48
9	Atlético	38	44	50	47
10	Quintanar	38	44	56	47
11	Manzanares	38	41	46	45
12	Atlético	38	45	58	43
13	Manchego	38	43	54	43
14	Hellin	38	35	40	43
15	Gimnástico	38	46	56	41
16	Mora CF	38	37	63	40
17	Madridejos	38	30	41	38
18	CD Illescas	38	39	59	36
19	CD Azuqueca	38	36	53	36
20	EF Zona 5	38	34	97	15

TEMPORADA 2011/2012

PREFERENTE C. LA MANCHA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Manchego	34	77	33	71
2	Daimiel	34	65	33	64
3	Almagro CF	34	57	31	64
4	Solana	34	62	47	57
5	Pedroñeras	34	46	33	55
6	Piedrabuena	34	58	45	54
7	Mota Cuervo	34	56	47	51
8	Atlético	34	51	51	50
9	Motilla Cf	34	52	60	49
10	EF Zona 5	34	67	47	48
11	Herencia	34	57	61	47
12	Munera	34	44	53	46
13	Ud Carrión	34	42	51	44
14	Miguelturre�	34	42	51	42
15	Villamalea	34	45	63	37
16	Unión	34	52	66	35
17	Efud Albacer	34	27	65	24
18	Deportivo	34	35	98	23

TEMPORADA 2009/2010

PREFERENTE C. LA MANCHA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Manzanares	34	67	32	70
2	Solana	34	82	51	69
3	Villarrubia	34	55	33	69
4	Aldea	34	113	49	65
5	Puertollano	34	77	48	61
6	Miguelturre�	34	56	49	52
7	Atlético	34	49	56	51
8	Atlético	34	57	61	49
9	Albacer	34	46	42	47
10	Almagro CF	34	65	56	45
11	Manchego	34	49	62	44
12	Villamalea	34	45	50	41
13	Bolañego	34	40	50	40
14	Deportivo	34	48	54	39
15	Hellín B	34	44	56	38
16	Quintanar	34	39	63	36
17	Atlético	34	39	58	33
18	Pedroñeras	34	19	120	7

Comparar equipos

CD Pedroñeras

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Tercera División

USO DE MEMORIA

6,352,424 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1339
Total Execution Time	0.1351

CADENA URL

/historico/Pedroneras/2020

GET DATOS

$_GET['/historico/Pedroneras/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0027	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 = 'Pedroneras' AND l.year = 2020 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=4273 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=4273 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=4273 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045	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 = 51355
0.0027	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 = 50286
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4273 AND type_rel = 2
0.0026	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4273 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025	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 (241122,294399,324990,325047,325051) ORDER BY n.cover_points DESC, update_date DESC
0.0024	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 = '4273' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '4273' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '4273' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027	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 = 51355 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 50286 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=4273 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (61821,58597,56547,51355,44768) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 58597 AND teamId = 4273
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 44768 AND teamId = 4273
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 51355 AND teamId = 4273
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 61821 AND teamId = 4273
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 4273
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 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 = 51355 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '4273' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4273' and rp.type = 4
0.0023	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 = '4273' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044	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 events2020 e ON e.player_id = p.id AND e.league_id = 51355 WHERE rp.league_id = 51355 AND rp.teamId = 4273 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 events2020 e ON e.player_id = p.id AND e.league_id = 51355 WHERE rp.league_id = 51355 AND rp.teamId = 4273 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 events2020 e ON e.player_id = p.id AND e.league_id = 51355 WHERE rp.league_id = 51355 AND rp.teamId = 4273 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 4273 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 50286 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.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* `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 = 44768 AND t.round = 34 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* `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 = 39042 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* `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 = 33368 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 = 15460 AND t.round = 38 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* `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 = 3927 AND t.round = 38 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* `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 = 2566 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 = 1479 AND t.round = 34 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* `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 = 948 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC