4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Chiapas Chiapas 19 35 20 42
2 Pumas UNAM Pumas UNAM 19 42 19 41
3 Chivas Guadalajara Chivas 19 30 23 34
4 América América 19 34 27 32
5 Toluca Toluca 19 31 25 30
6 Atlante FC Atlante FC 19 29 26 27
7 Atlas Guadalajara Atlas 19 28 25 27
8 Pachuca Pachuca 19 32 33 26
9 Irapuato Irapuato 19 23 30 26
10 Querétaro Querétaro 19 24 27 24
11 Cruz Azul Cruz Azul 19 36 34 23
12 Tigres UANL Tigres UANL 19 37 39 23
13 CA Morelia CA Morelia 19 25 35 22
14 Santos Laguna Santos 19 31 30 21
15 Necaxa Necaxa 19 22 26 21
16 Puebla Puebla 19 27 29 20
17 Monterrey Monterrey 19 28 30 18
18 Tecos Tecos 19 32 40 18
19 San Luis San Luis 19 23 35 18
20 Veracruz Veracruz 19 25 41 17
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 CA Morelia CA Morelia 19 34 20 35
2 Atlante FC Atlante FC 19 39 26 34
3 Monterrey Monterrey 19 31 22 34
4 Tigres UANL Tigres UANL 19 25 22 34
5 Toluca Toluca 19 40 30 33
6 Atlas Guadalajara Atlas 19 29 20 32
7 Tiburones Rojos de Veracruz Tiburones 19 23 18 32
8 Chivas Guadalajara Chivas 19 32 24 31
9 Santos Laguna Santos 19 30 24 30
10 América América 19 29 20 29
11 Cruz Azul Cruz Azul 19 24 24 24
12 Necaxa Necaxa 19 25 24 23
13 Cuernavaca Cuernavaca 19 24 27 23
14 Pachuca Pachuca 19 21 23 21
15 Pumas UNAM Pumas UNAM 19 25 35 20
16 San Luis San Luis 19 25 38 20
17 Chiapas Chiapas 19 15 26 19
18 Querétaro Querétaro 19 13 23 17
19 Puebla Puebla 19 15 31 16
20 Tecos Tecos 19 15 37 7
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Reboceros de la Piedad Reboceros 18 35 17 37
2 Toluca Toluca 18 35 17 35
3 Pumas UNAM Pumas UNAM 18 30 22 32
4 Santos Laguna Santos 18 42 31 31
5 Atlas Guadalajara Atlas 18 30 28 30
6 CA Morelia CA Morelia 18 34 25 29
7 Necaxa Necaxa 18 34 23 27
8 América América 18 27 23 27
9 Cruz Azul Cruz Azul 18 32 29 27
10 Tigres UANL Tigres UANL 18 25 23 27
11 Tiburones Rojos de Veracruz Tiburones 18 22 30 24
12 Chivas Guadalajara Chivas 18 22 21 22
13 Pachuca Pachuca 18 26 33 22
14 Atlante FC Atlante FC 18 23 29 20
15 Monterrey Monterrey 18 21 28 20
16 Celaya Celaya 18 19 29 20
17 Tecos Tecos 18 25 34 14
18 Puebla Puebla 18 24 45 11
19 León León 18 17 36 10

  USO DE MEMORIA  
5,611,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1106
Total Execution Time  0.1127
  CADENA URL  
/clausura_mexico2004/grupo1/historico
  GET DATOS  
$_GET['/clausura_mexico2004/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT type FROM routes WHERE alias = 'clausura_mexico2004'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_mexico' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=141 AND type_rel = 3
0.0078  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 141 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  SELECT /*53 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 (1313503,1313338,1313327,1313232,1313168) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 13419 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 141 AND group_code = 1 and tables = 1 AND year <= 2004 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2004` 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 = 13419 AND t.round = 19 ORDER BY team.conference 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 `tables2003` 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 = 20822 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 22:26:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 22:26:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 22:26:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 22:26:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_mexico' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0136  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2004 e ON e.player_id = p.id AND e.league_id = 13419 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13419 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0157  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2004 e ON e.player_id = p.id AND e.league_id = 13419 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13419 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0085  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2004 e ON e.player_id = p.id AND e.league_id = 13419 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13419 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 13419 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC