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

Tampico Madero

Entrenador: Gastón Obledo

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA PREMIER SERIE A GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Racing Porto	33	51	20	77
2	Tampico	33	62	29	64
3	Deportiva	33	56	39	62
4	Petroleros	33	36	22	56
5	Irapuato	32	57	22	55
6	Aguacateros	33	58	40	55
7	Inter Playa	33	41	29	53
8	Escorpiones	33	38	32	52
9	Montañeses	32	46	42	52
10	Cafetaleros	33	44	39	47
11	Reboceros	33	39	35	46
12	Pioneros	33	35	50	36
13	Lobos ULMX	33	33	48	36
14	Halcones	32	30	38	33
15	Sporting	33	42	59	28
16	Juan Aragón	33	30	65	22
17	Yalmakan	16	20	34	14
18	Inter	33	18	93	9

TEMPORADA 2022/2023

LIGA PREMIER SERIE A - CLAUSURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tampico	10	20	6	29
2	Gavilanes	10	22	11	19
3	Saltillo FC	10	17	16	16
4	Colima	10	18	15	14
5	Lobos ULMX	10	14	13	14
6	Reboceros	10	16	17	14
7	Tamaulipas	10	18	18	13
8	Tulancingo	10	12	14	13
9	Aguacateros	10	10	17	13
10	Inter	10	11	19	7
11	Catedrático	10	16	28	7

TEMPORADA 2021/2022

LIGA DE EXPANSIÓN MX - APERTURA
Equipo		PJ	GF	GC	Puntos
1	Dorados	16	34	13	41
2	Atlante FC	16	22	9	33
3	CA Morelia	16	22	18	32
4	Celaya	16	20	16	28
5	Pumas	16	16	15	28
6	Leones	16	21	18	27
7	Tampico	16	23	18	24
8	Cimarrones	16	22	22	24
9	Venados FC	16	17	19	23
10	Mineros	16	24	28	21
11	Correcaminos	16	19	27	20
12	Tepatitlán	16	17	20	19
13	Tlaxcala FC	16	15	20	19
14	Raya2	16	16	18	18
15	Alebrijes	16	14	17	16
16	CD Tapatío	16	11	27	16
17	Cancún	16	14	22	15

TEMPORADA 2020/2021

LIGA DE EXPANSIÓN MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	CA Morelia	15	26	19	33
2	Celaya	15	19	11	28
3	Cimarrones	15	20	11	27
4	Mineros	15	21	21	27
5	CD Tapatío	15	14	14	24
6	Tepatitlán	15	13	19	24
7	Atlante FC	15	18	12	23
8	Cancún	15	15	17	21
9	Dorados	15	15	16	20
10	Tlaxcala FC	15	15	17	20
11	Alebrijes	15	24	24	19
12	Venados FC	15	15	16	18
13	Pumas	15	14	19	18
14	Tampico	15	11	12	16
15	Correcaminos	15	16	20	14
16	Leones	15	11	19	12

TEMPORADA 2019/2020

ASCENSO MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Mineros	8	18	4	22
2	Correcaminos	8	16	10	18
3	Celaya	8	7	7	15
4	Zacatepec	8	13	12	14
5	Leones	8	14	14	14
6	Tampico	8	9	8	13
7	Venados FC	8	8	11	13
8	Atlante FC	8	6	7	12
9	Cimarrones	8	6	11	9
10	Alebrijes	8	6	9	6
11	Dorados	8	13	18	5
12	Cafetaleros	8	9	14	3

TEMPORADA 2018/2019

ASCENSO MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Atl. Luis	14	22	11	28
2	Mineros	14	17	9	25
3	Zacatepec	14	22	18	22
4	Cimarrones	14	12	17	22
5	Dorados	14	21	19	20
6	Venados FC	14	12	13	20
7	Alebrijes	14	12	14	19
8	Celaya	14	14	16	18
9	Atlante FC	14	26	21	17
10	Leones	14	19	18	17
11	Correcaminos	14	15	16	17
12	UAEM Potros	14	13	17	17
13	Cafetaleros	14	23	25	15
14	FC Juárez	14	12	16	15
15	Tampico	14	16	26	11

TEMPORADA 2017/2018

ASCENSO MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Mineros	15	24	17	28
2	Dorados	15	20	13	26
3	Leones	15	21	18	25
4	Zacatepec	15	17	19	24
5	Alebrijes	15	25	17	23
6	Atlante FC	15	16	12	23
7	Celaya	15	17	14	23
8	Cafetaleros	15	24	21	22
9	Tampico	15	14	11	22
10	Atl. Luis	15	18	22	20
11	Venados FC	15	15	17	19
12	Correcaminos	15	15	20	18
13	FC Juárez	15	12	16	15
14	Murciélagos	15	12	21	15
15	Cimarrones	15	16	22	14
16	UAEM Potros	15	11	17	11

TEMPORADA 2016/2017

ASCENSO MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Mineros	17	21	11	32
2	Dorados	17	29	22	31
3	Alebrijes	17	27	19	30
4	FC Juárez	17	23	17	28
5	UAEM Potros	17	21	15	28
6	Lobos BUAP	17	30	26	27
7	Zacatepec	17	23	22	27
8	Cimarrones	17	20	19	27
9	Deportivo	17	24	20	26
10	Tampico	17	15	14	23
11	Leones	17	16	18	22
12	Cafetaleros	17	20	21	21
13	Atlante FC	17	17	18	21
14	Celaya	17	26	27	19
15	Correcaminos	17	24	31	16
16	Venados FC	17	17	34	15
17	Loros	17	18	27	14
18	Murciélagos	17	13	23	14

TEMPORADA 2015/2016

LIGA PREMIER SERIE A - CLAUSURA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Real Zamora	2	7	1	6
2	UAEM Potros	2	1	0	4
3	Tampico	2	0	1	1
4	Tamaulipas	2	1	7	0

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

LIGA PREMIER SERIE A - CLAUSURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Irapuato	14	21	10	27
2	Cruz Azul P.	14	19	12	26
3	Real	14	22	19	23
4	Orizaba	14	14	12	23
5	Atl.	14	19	12	22
6	Delfines II	14	18	20	21
7	Tiburones	14	11	15	21
8	UAEM Potros	14	17	15	20
9	Linces	14	25	19	18
10	Inter Playa	14	16	19	18
11	Ocelotes	14	16	18	14
12	Tampico	14	11	19	14
13	Zacatecas	14	12	18	13
14	Teca UTN	14	13	19	12
15	Patriotas	14	17	24	12

Competiciones que juega

Liga Premier Serie A Grupo 2

Pos	Equipos		Pts
1		Racing Porto Palmeiras	77
2		Tampico Madero	64
3		Deportiva Venados	62
4		Petroleros de Salamanca	56
5		Irapuato	55
6		Aguacateros de Peribán	55
7		Inter Playa del Carmen	53
8		Escorpiones FC	52
9		Montañeses	52
10		Cafetaleros	47
11		Reboceros de la Piedad	46
12		Pioneros de Cancún	36
13		Lobos ULMX	36
14		Halcones de Zapopan	33
15		Sporting Canamy	28
16		San Juan de Aragón	22
17		Yalmakan	14
18		Inter de Querétaro	9

	Series Finales : Racing Porto Palmeiras
	Playoffs : Tampico Madero, Deportiva Venados, Petroleros de Salamanca, Irapuato, Aguacateros de Peribán, Inter Playa del Carmen

RIVALES EN Liga Premier Ser.

USO DE MEMORIA

6,171,280 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.6586
Total Execution Time	0.6606

CADENA URL

/historico/Tampico-Madero

GET DATOS

$_GET['/historico/Tampico-Madero']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0145	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 = 'Tampico-Madero' 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.0144	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=57100 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=57100 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57100 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 57100 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	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 (70775,88339,144706,163336,162996) ORDER BY n.cover_points DESC, update_date DESC
0.0149	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 = '57100' ORDER BY l.year DESC,cat.coefficient DESC
0.0140	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 = '57100' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0136	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 = '57100' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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 = 73351 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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=57100 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 (73351,71573,71296,70229) 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.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 73351 AND teamId = 57100
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 70229 AND teamId = 57100
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 71296 AND teamId = 57100
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 71573 AND teamId = 57100
0.0128	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 = '57100' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '57100' and rp.type = 4
0.0126	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 = '57100' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139	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 = 73351 WHERE rp.league_id = 73351 AND rp.teamId = 57100 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.0140	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 = 73351 WHERE rp.league_id = 73351 AND rp.teamId = 57100 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 73351 WHERE rp.league_id = 73351 AND rp.teamId = 57100 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 57100 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0127	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 = 68371 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.0127	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 = 68376 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.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* `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 = 66236 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.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* `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 = 63294 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.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* `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 = 58361 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 60392 AND t.round = 15 ORDER BY team.conference ASC,t.position 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* `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 = 49960 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.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* `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 = 53478 AND t.round = 8 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* `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 = 44040 AND t.round = 15 ORDER BY team.conference 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* `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 = 48497 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 38667 AND t.round = 15 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* `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 = 41854 AND t.round = 15 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* `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 = 33339 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 = 37587 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* `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 = 20215 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 28242 AND t.round = 1 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* `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 = 16636 AND t.round = 15 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* `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.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* `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 = 16466 AND t.round = 15 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

Tampico Madero

Tampico Madero

Selecciona un equipo

Competiciones que juega

Liga Premier Serie A Grupo 2

RIVALES EN Liga Premier Ser.