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

Tecos

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA PREMIER SERIE A GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Los Cabos	32	55	27	71
2	Durango	32	53	22	67
3	Gavilanes	32	46	33	57
4	Tamaulipas	32	48	47	57
5	Tecos	32	54	36	53
6	Leones	32	47	45	52
7	Cimarrones	32	32	31	48
8	Zacatecas	32	46	38	47
9	Orgullo	32	31	29	47
10	Tritones	32	33	27	46
11	Saltillo FC	32	30	31	46
12	Real Apodaca	32	42	41	45
13	Mineros	32	38	41	40
14	Club Calor	32	31	50	37
15	Mexicali FC	32	22	56	29
16	Colima	32	31	62	25
17	Coras	32	25	48	21
18	Chihuahua	0	0	0	0

TEMPORADA 2022/2023

LIGA PREMIER SERIE A - CLAUSURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chihuahua	10	21	10	25
2	Tecos	10	14	4	25
3	Tritones	10	17	5	24
4	Los Cabos	10	14	8	18
5	Cimarrones	10	16	11	18
6	Zacatecas	10	14	12	17
7	Coras	10	9	13	13
8	Mineros	10	7	16	10
9	Mexicali FC	10	10	18	8
10	Halcones	10	6	17	6
11	Leones	10	4	18	1

TEMPORADA 2021/2022

LIGA PREMIER SERIE A - CLAUSURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mazorqueros	13	30	10	33
2	Tritones	13	23	12	29
3	Durango	13	32	11	27
4	Coras	13	20	12	26
5	Saltillo FC	13	24	18	25
6	Cimarrones	13	19	15	19
7	Gavilanes	13	14	9	17
8	Zacatecas	13	22	20	16
9	Tecos	13	13	19	16
10	Leones	13	13	22	13
11	Colima	13	11	21	10
12	Mineros	13	17	29	9
13	Tamaulipas	13	10	29	8
14	Catedrático	13	9	30	5

TEMPORADA 2020/2021

LIGA PREMIER SERIE A GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Durango	22	44	15	52
2	Reboceros	22	44	25	46
3	Colima	22	36	19	46
4	Gavilanes	22	22	14	46
5	Mineros	22	35	29	34
6	Atlético	22	22	24	32
7	Zacatecas	22	25	28	32
8	Tecos	22	23	29	25
9	Mazorqueros	22	23	36	24
10	Saltillo FC	22	23	40	22
11	Leones	22	25	42	19
12	Cimarrones	22	13	34	11

TEMPORADA 2019/2020

LIGA PREMIER SERIE A GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tepatitlán	23	55	14	62
2	Zacatecas	24	47	24	56
3	Reynosa F.C.	23	51	22	53
4	Gavilanes	23	41	24	48
5	Durango	23	48	25	46
6	Coras	22	36	25	44
7	Murciélagos	24	45	36	39
8	Chihuahua	23	34	30	38
9	Saltillo FC	24	28	23	37
10	Tecos	22	30	41	25
11	Tamaulipas	23	26	41	21
12	Leones	23	29	49	17
13	Atlético	24	18	65	15
14	Mineros	24	17	51	13
15	Cimarrones	23	15	50	12
16	Coyotes	20	30	14	43
17	Irapuato	20	42	28	40
18	Pioneros	20	37	25	34
19	Pumas UNAM.	21	38	31	33
20	Cafessa	20	28	22	33
21	Cruz Azul	20	31	19	31
22	Inter Playa	20	32	26	27
23	Reboceros	21	26	33	27
24	Yalmakan	21	35	42	25
25	Cafetaleros	20	26	33	24
26	Cañoneros	20	19	33	23
27	Sporting	20	15	33	11
28	Atlético	21	18	38	11
29	Orizaba	0	0	0	0

TEMPORADA 2018/2019

LIGA PREMIER SERIE A - APERTURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Guadalajara	30	46	28	61
2	Loros	30	72	33	58
3	Tepatitlán	30	52	40	54
4	Reynosa F.C.	30	42	23	52
5	Murciélagos	30	56	39	52
6	Necaxa	30	38	33	52
7	Chihuahua	30	47	30	51
8	Coras	30	42	31	51
9	Gavilanes	30	41	33	48
10	Tamaulipas	31	41	50	38
11	Monarcas	30	50	41	37
12	Leones	30	35	49	34
13	Tecos	31	43	52	31
14	Durango	30	25	45	23
15	Pacific	30	32	71	22
16	Cimarrones	30	18	82	9
17	Irapuato	30	57	19	70
18	Zacatecas	30	46	34	52
19	Tuxtla FC	30	45	28	50
20	Pumas UNAM.	30	47	34	49
21	Cruz Azul	30	38	30	47
22	Real Zamora	30	44	38	47
23	Inter Playa	30	35	30	47
24	Toluca	30	41	40	42
25	Coyotes	30	39	34	40
26	Reboceros	30	39	39	39
27	Pioneros	30	30	37	33
28	Orizaba	30	25	40	33
29	Sporting	30	31	57	28
30	América	30	30	47	27
31	Cocodrilos	30	23	41	26
32	Yalmakan	30	28	50	22

TEMPORADA 2017/2018

LIGA PREMIER SERIE A - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Loros	17	36	14	36
2	Necaxa	17	22	18	31
3	Tigres UANL	17	22	12	29
4	Durango	17	23	19	27
5	Atlas	17	23	23	26
6	Reynosa F.C.	17	24	12	25
7	Tepatitlán	17	25	19	25
8	Pacific	17	24	19	25
9	Guadalajara	17	15	15	23
10	Monarcas	17	20	20	22
11	Tecos	17	16	17	22
12	Gavilanes	17	18	24	21
13	Santos	17	20	24	20
14	Club Leon P.	17	16	23	20
15	Deportivo	17	11	25	20
16	Chihuahua	17	16	30	16
17	Club Tijuana	17	25	30	15
18	Rayados	17	14	26	13
19	Tuxtla FC	17	31	12	38
20	Irapuato	17	32	23	32
21	Reboceros	17	28	19	32
22	Pioneros	17	18	13	32
23	Inter Playa	17	23	14	31
24	América	17	26	20	27
25	Puebla F.C.	17	22	22	23
26	Real Zamora	17	21	21	23
27	Gallos	17	22	18	22
28	Cruz Azul	17	20	19	20
29	Halcones	17	15	18	20
30	Sporting	17	20	29	20
31	Tiburones	17	16	17	19
32	Lobos BUAP.	17	19	26	18
33	Toluca	17	18	24	17
34	Cruz Azul P.	17	20	28	17
35	Pachuca	17	14	30	13
36	Pumas UNAM.	17	21	33	12

TEMPORADA 2014/2015

LIGA PREMIER SERIE A - CLAUSURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Reynosa F.C.	12	23	10	26
2	Tampico	12	22	14	24
3	Cimarrones	12	19	9	23
4	Loros	12	24	14	22
5	Gallos	12	22	16	18
6	Chihuahua	12	16	18	17
7	Tecos	12	15	17	15
8	Ciudad	12	11	16	14
9	Murciélagos	12	12	19	13
10	Deportivo	12	12	21	12
11	Santos	12	19	22	11
12	Zacatecas	12	12	20	10
13	Durango	12	9	20	10

TEMPORADA 2013/2014

ASCENSO MX - APERTURA
Equipo		PJ	GF	GC	Puntos
1	Alebrijes	14	28	17	25
2	Necaxa	14	21	15	25
3	Delfines	14	24	12	24
4	Venados FC	14	22	13	23
5	Leones	14	21	21	23
6	Correcaminos	14	25	20	22
7	Atl. Luis	14	19	17	22
8	Dorados	14	15	11	18
9	Cafetaleros	14	26	26	18
10	Cruz Azul	14	16	18	17
11	Lobos BUAP	14	9	17	17
12	Tecos	14	21	20	16
13	Celaya	14	18	25	14
14	Ballenas	14	14	28	13
15	Zacatepec	14	9	28	5

TEMPORADA 2012/2013

ASCENSO MX - APERTURA
Equipo		PJ	GF	GC	Puntos
1	Necaxa	14	30	18	31
2	Toros Neza	14	19	14	24
3	Tecos	14	16	12	23
4	Lobos BUAP	14	20	17	23
5	Venados FC	14	14	12	23
6	Reboceros	14	21	16	22
7	Dorados	14	23	22	22
8	Correcaminos	14	19	16	18
9	Cruz Azul	14	14	17	17
10	Celaya	14	18	19	16
11	Irapuato	14	16	19	16
12	Veracruz	14	14	16	14
13	Cafetaleros	14	14	20	14
14	Leones	14	14	23	12
15	Pumas	14	8	19	8

TEMPORADA 2011/2012

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Santos	17	33	18	36
2	Monterrey	17	32	15	32
3	América	17	30	18	32
4	CA Morelia	17	25	18	31
5	Tigres UANL	17	22	16	31
6	Pachuca	17	24	17	28
7	Tijuana	17	18	11	28
8	Chiapas	17	26	20	27
9	Cruz Azul	17	29	21	25
10	Toluca	17	24	27	22
11	Atlas	17	7	13	20
12	Puebla	17	19	23	19
13	Pumas UNAM	17	13	18	16
14	Atlante FC	17	20	31	16
15	Chivas	17	12	21	15
16	San Luis	17	15	30	12
17	Querétaro	17	14	30	12
18	Tecos	17	12	28	12

TEMPORADA 2010/2011

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Tigres UANL	17	26	9	35
2	Monterrey	17	23	20	26
3	Chivas	17	23	15	25
4	Santos	17	23	23	23
5	Tecos	17	21	34	17
6	Necaxa	17	10	15	15
7	Atlante FC	17	28	17	27
8	América	17	31	28	26
9	Atlas	17	19	19	23
10	San Luis	17	20	18	21
11	Toluca	17	28	27	21
12	Pachuca	17	16	25	18
13	Pumas UNAM	17	27	13	35
14	CA Morelia	17	31	24	31
15	Cruz Azul	17	25	20	26
16	Puebla	17	16	26	18
17	Querétaro	17	16	35	16
18	Chiapas	17	15	30	14

Competiciones que juega

RIVALES EN Liga Premier Ser.

USO DE MEMORIA

6,599,424 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5653
Total Execution Time	0.5665

CADENA URL

/historico/Estudiantes-Tecos

GET DATOS

$_GET['/historico/Estudiantes-Tecos']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0035	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 = 'Estudiantes-Tecos' 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=4347 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=4347 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=4347 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 73350
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4347 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4347 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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 (5980,801563) ORDER BY n.cover_points DESC, update_date DESC
0.0038	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 = '4347' ORDER BY l.year DESC,cat.coefficient DESC
0.0029	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 = '4347' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0031	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 = '4347' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 73350 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033	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=4347 AND l.year in (2023,2024,2025) 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 (75941,71296,68370) 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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 75941 AND teamId = 4347
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71296 AND teamId = 4347
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 68370 AND teamId = 4347
0.0024	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 = '4347' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4347' and rp.type = 4
0.0025	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 = '4347' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '4347' and rp.type = 4
0.0022	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 = 75941 WHERE rp.league_id = 75941 AND rp.teamId = 4347 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.0020	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 = 75941 WHERE rp.league_id = 75941 AND rp.teamId = 4347 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 75941 WHERE rp.league_id = 75941 AND rp.teamId = 4347 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041	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 = 4347 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* `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 = 68370 AND t.round = 11 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* `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 = 68375 AND t.round = 11 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* `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 = 64143 AND t.round = 13 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* `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 = 66329 AND t.round = 13 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* `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 = 58750 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.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* `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 = 51046 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053	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 = 44592 AND t.round = 30 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* `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 = 39021 AND t.round = 17 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* `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 = 41348 AND t.round = 17 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* `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 = 9258 AND t.round = 13 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* `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 = 8620 AND t.round = 13 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* `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 = 12850 AND t.round = 15 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* `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 = 45192 AND t.round = 15 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* `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 = 2371 AND t.round = 15 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* `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 = 45193 AND t.round = 15 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* `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 = 1397 AND t.round = 17 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 = 1534 AND t.round = 17 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* `tables2011` 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 = 1208 AND t.round = 17 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* `tables2011` 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 = 1278 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Tecos

Tecos

Selecciona un equipo

Competiciones que juega

RIVALES EN Liga Premier Ser.