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

Resultados de Fútbol

Tigres UANL

Entrenador: Robert Siboldi

Temporada 2020/2021

TEMPORADA 2020/2021

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Cruz Azul	17	26	11	41
2	América	17	26	14	38
3	Puebla	17	25	14	28
4	Monterrey	17	22	13	28
5	Santos	17	18	13	26
6	León	17	25	23	26
7	Atlas	17	20	15	25
8	Pachuca	17	20	19	23
9	Chivas	17	21	21	23
10	Tigres UANL	17	19	20	23
11	Toluca	17	26	24	22
12	Querétaro	17	19	25	21
13	Mazatlán	17	19	26	21
14	Tijuana	17	19	21	20
15	Pumas UNAM	17	10	12	18
16	FC Juárez	17	13	29	15
17	Atl. Luis	17	20	33	12
18	Necaxa	17	14	29	11

TEMPORADA 2019/2020

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Cruz Azul	10	24	14	22
2	León	10	23	14	21
3	Santos	10	14	14	17
4	América	10	11	11	17
5	Chivas	10	13	11	16
6	Pumas UNAM	10	20	19	15
7	Tigres UANL	10	13	10	14
8	FC Juárez	10	20	18	14
9	CA Morelia	10	17	16	14
10	Puebla	10	7	7	14
11	Pachuca	10	11	12	14
12	Querétaro	10	13	15	14
13	Atl. Luis	10	11	15	13
14	Necaxa	10	17	16	11
15	Toluca	10	16	18	10
16	Tijuana	10	10	16	9
17	Atlas	10	10	17	9
18	Monterrey	10	10	17	5

TEMPORADA 2018/2019

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	León	17	41	14	41
2	Tigres UANL	17	33	16	37
3	Monterrey	17	33	21	30
4	Cruz Azul	17	26	15	30
5	América	17	28	19	29
6	Necaxa	17	32	24	29
7	Pachuca	17	32	26	28
8	Tijuana	17	25	20	28
9	Toluca	17	28	23	25
10	Puebla	17	18	21	24
11	Santos	17	21	23	22
12	Lobos BUAP	17	17	34	20
13	Atlas	17	19	28	19
14	Chivas	17	16	21	18
15	Pumas UNAM	17	19	26	17
16	CA Morelia	17	20	31	13
17	Querétaro	17	11	30	11
18	Veracruz	17	7	34	0

TEMPORADA 2017/2018

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Toluca	17	24	13	36
2	América	17	24	14	29
3	Monterrey	17	30	21	29
4	Santos	17	29	20	29
5	Tigres UANL	17	23	16	28
6	Tijuana	17	18	12	25
7	Pumas UNAM	17	24	24	24
8	CA Morelia	17	22	24	24
9	Pachuca	17	29	27	23
10	Puebla	17	23	24	23
11	Necaxa	17	21	15	22
12	Cruz Azul	17	22	18	22
13	León	17	24	33	22
14	Querétaro	17	13	18	18
15	Atlas	17	17	26	18
16	Veracruz	17	12	25	18
17	Chivas	17	14	24	15
18	Lobos BUAP	17	18	33	9

TEMPORADA 2016/2017

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

TEMPORADA 2015/2016

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

TEMPORADA 2014/2015

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

TEMPORADA 2013/2014

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

TEMPORADA 2012/2013

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

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

Competiciones que juega

Grupo 1

Liga MX - Clausura

Pos	Equipos		Pts
1		Cruz Azul	41
2		América	38
3		Puebla	28
4		Monterrey	28
5		Santos Laguna	26
6		León	26
7		Atlas Guadalajara	25
8		Pachuca	23
9		Chivas Guadalajara	23
10		Tigres UANL	23
11		Toluca	22
12		Querétaro	21
13		Mazatlán	21
14		Tijuana	20
15		Pumas UNAM	18
16		FC Juárez	15
17		Atl. San Luis	12
18		Necaxa	11

	Playoff Título : Cruz Azul, América, Puebla, Monterrey
	Siguiente Ronda : Santos Laguna, León, Atlas Guadalajara, Pachuca, Chivas Guadalajara, Tigres UANL, Toluca, Querétaro

RIVALES EN Mundial de Clube.

RIVALES EN Leagues Cup

RIVALES EN Liga MX - Clausu.

RIVALES EN Liga MX - Apertu.

RIVALES EN Etapas Finales A.

RIVALES EN Etapas Finales C.

USO DE MEMORIA

7,103,920 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8235
Total Execution Time	0.8247

CADENA URL

/historico/Tigres-Uanl/2021

GET DATOS

$_GET['/historico/Tigres-Uanl/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0254	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 = 60360
0.0132	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 = 60411
0.0131	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 = 62423
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4348 AND type_rel = 2
0.0152	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4348 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (196,442,532,698,2589) ORDER BY n.cover_points DESC, update_date DESC
0.0137	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 = '4348' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0137	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 = '4348' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 60411 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125	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 = 63288 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 60360 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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 = 56984 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 60012 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 62423 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0141	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=4348 AND l.year in (2020,2021,2022) 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 (70661,67466,66176,65761,63288,63173,62807,60411,53440) 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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 66176 AND teamId = 4348
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 63173 AND teamId = 4348
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 60411 AND teamId = 4348
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 65761 AND teamId = 4348
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 67466 AND teamId = 4348
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 53440 AND teamId = 4348
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 63288 AND teamId = 4348
0.0310	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 4348
0.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 70661 AND teamId = 4348
0.0136	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 60360 AND t.round = 17 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0189	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 events2021 e ON e.player_id = p.id AND e.league_id = 60360 WHERE rp.league_id = 60360 AND rp.teamId = 4348 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.0189	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 events2021 e ON e.player_id = p.id AND e.league_id = 60360 WHERE rp.league_id = 60360 AND rp.teamId = 4348 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0182	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 events2021 e ON e.player_id = p.id AND e.league_id = 60360 WHERE rp.league_id = 60360 AND rp.teamId = 4348 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0197	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 = 4348 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0140	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 = 56984 AND t.round = 17 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* `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 = 60360 AND t.round = 17 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* `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 = 49953 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.0128	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 = 51325 AND t.round = 10 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* `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 = 43804 AND t.round = 17 ORDER BY team.conference 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* `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 = 48493 AND t.round = 17 ORDER BY team.conference 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* `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 = 38666 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 41853 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 33338 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 37583 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 15261 AND t.round = 17 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 = 20080 AND t.round = 17 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* `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 = 3802 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 9007 AND t.round = 17 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* `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 = 3431 AND t.round = 17 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* `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 = 2398 AND t.round = 17 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* `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 = 2062 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 2258 AND t.round = 17 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* `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.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* `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


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Tigres UANL

Tigres UANL

Selecciona un equipo

Competiciones que juega

Liga MX - Clausura

RIVALES EN Mundial de Clube.

RIVALES EN Leagues Cup

RIVALES EN Liga MX - Clausu.

RIVALES EN Liga MX - Apertu.

RIVALES EN Etapas Finales A.

RIVALES EN Etapas Finales C.