4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 22 51 20 48
2 Al-Wahda Al-Wahda 22 50 29 43
3 Al Ahli Dubai Ahli Dubai 22 47 36 34
4 Al Nasr Dubai Nasr Dubai 22 36 25 34
5 Al-Shaab Sharjah Al-Shaab 22 39 31 32
6 Al-Jazira Al-Jazira 22 33 32 31
7 Sharjah FC Sharjah FC 22 28 42 25
8 Al-Wasl Al-Wasl 22 27 36 23
9 Al Shabab Dubai Shabab Dubai 22 30 38 22
10 Al Ittihad Kalba Ittihad 22 22 31 22
11 Dubai Dubai 22 36 56 17
12 Al Dhafra Al Dhafra 22 29 52 17
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 22 44 23 47
2 Al-Jazira Al-Jazira 22 50 33 38
3 Al-Shaab Sharjah Al-Shaab 22 40 26 37
4 Al-Wahda Al-Wahda 22 55 38 36
5 Al Ahli Dubai Ahli Dubai 22 42 35 30
6 Al-Wasl Al-Wasl 22 34 31 30
7 Sharjah FC Sharjah FC 22 44 44 28
8 Al Nasr Dubai Nasr Dubai 22 43 43 28
9 Al Ittihad Kalba Ittihad 22 28 36 26
10 Al Shabab Dubai Shabab Dubai 22 29 39 19
11 Khorfakkan Khorfakkan 22 35 61 18
12 Baniyas Baniyas 22 22 57 16
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Al-Wahda Al-Wahda 22 62 34 50
2 Al Ahli Dubai Ahli Dubai 22 47 36 42
3 Al-Jazira Al-Jazira 22 47 33 38
4 Al-Ain Al-Ain 22 33 27 34
5 Al-Wasl Al-Wasl 22 42 32 32
6 Al-Shaab Sharjah Al-Shaab 22 32 26 32
7 Al Nasr Dubai Nasr Dubai 22 40 41 31
8 Al Shabab Dubai Shabab Dubai 22 33 36 29
9 Al Ittihad Kalba Ittihad 22 29 39 28
10 Emirates Club Emirates 22 29 38 22
11 Sharjah FC Sharjah FC 22 27 38 22
12 Al Fujairah Al Fujairah 22 15 56 6

  USO DE MEMORIA  
4,929,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.0596
Total Execution Time  0.0626
  CADENA URL  
/uae2003/grupo1/historico
  GET DATOS  
$_GET['/uae2003/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'uae2003'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'uae' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=62 ORDER BY order_id ASC
0.0019  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 = 23815 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 62 AND group_code = 1 and tables = 1 AND year <= 2003 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022  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 = 23815 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2002` 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 = 23816 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2001` 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 = 23818 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:27:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:27:04' 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-04-27 23:27:04' 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-04-27 23:27:04' 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 = 'uae' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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 events2003 e ON e.player_id = p.id AND e.league_id = 23815 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23815 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.0019  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 events2003 e ON e.player_id = p.id AND e.league_id = 23815 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23815 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2003 e ON e.player_id = p.id AND e.league_id = 23815 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23815 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  SELECT *,(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 = 23815 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC