4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Nasaf Qarshi Nasaf Qarshi 4 11 3 12
2 Kuwait SC Kuwait SC 4 11 3 10
3 Dalian Shide Dalian Shide 4 15 3 9
4 Happy Valley AA Happy Valley 4 15 8 9
5 Kashima Antlers Kashima 3 8 1 9
6 Al Zawraa Al Zawraa 4 10 5 9
7 FC Seoul FC Seoul 2 11 0 6
8 Police Tero FC Police Tero 4 8 5 6
9 Muktijoddha Sangsad Muktijoddha 4 3 12 6
10 Hilal Al Quds Hilal Quds 4 5 10 4
11 Suwon Bluewings Suwon 1 18 0 3
12 Al-Wahda Al-Wahda 2 4 3 3
13 Al-Ittihad Al-Ittihad 2 4 4 3
14 FC Esteghlal Esteghlal 2 4 4 3
15 El Ahli Sanaa Ahli Sanaa 2 1 2 1
16 Jableh SC Jableh SC 2 0 2 1
17 Al Ahli Amman Ahli Amman 0 0 0 0
18 Sagesse Sagesse 0 0 0 0
19 Song Lam Nghe An Song Nghe 0 0 0 0
20 New Radiant New Radiant 2 1 3 0
21 Persija Persija 1 1 4 0
22 Umed Dushanbe Umed 2 3 7 0
23 Köpetdag Aşgabat Köpetdag 2 0 4 0
24 Al-Wakrah Al-Wakrah 2 1 7 0
25 Warriors Warriors 2 1 8 0
26 Selangor Selangor 2 0 7 0
27 Lam Pak Lam Pak 2 0 12 0
28 Saunders Saunders 1 0 18 0
Ver
TEMPORADA 1994/1995
Equipo PJ GF GC Puntos
1 Neftchi Neftchi 4 17 1 12
2 Köpetdag Aşgabat Köpetdag 4 11 3 9
3 FC Irtysh Pavlodar Irtysh 4 4 6 3
4 FK Sitora Dushanbe Sitora 4 4 15 3
5 Alga Bishkek Alga Bishkek 4 2 13 3
6 Mohun Bagan SG Mohun Bagan 2 12 2 6
7 Club Valencia Club 2 3 8 3
8 Ratnam Ratnam 2 2 7 0
Ver
TEMPORADA 1990/1991
Equipo PJ GF GC Puntos
1 Al Karkh Al Karkh 2 3 1 6
2 Al Yarmouk Al Yarmouk 2 1 4 0
3 FC Esteghlal Esteghlal 2 2 1 4
4 Al-Nassr Al-Nassr 2 2 0 4
5 Al Arabi Al Arabi 2 4 3 3
6 Sharjah FC Sharjah FC 2 1 2 1
7 Pia FC Pia FC 2 1 0 4
8 Ranipokhari Ranipokhari 2 0 3 0
9 Mohammedan Dhaka Mohammedan 2 7 1 6
10 Salgaocar Salgaocar 2 4 3 3
11 Club Lagoons Club Lagoons 2 1 8 0
12 Madura United Madura 2 2 1 4
13 Bangkok Bank Bangkok Bank 2 3 3 3
14 Geylang International Geylang 2 1 2 1
15 April 25 April 25 2 2 0 6
16 Liaoning Whowin Liaoning 2 3 3 3
17 Yokohama F. Marinos Yokohama 2 2 4 0
Ver
TEMPORADA 1989/1990
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 3 4 1 7
2 Al Karkh Al Karkh 3 5 2 6
3 Al-Sadd Al-Sadd 2 2 3 3
4 Al Ansar Beirut Ansar Beirut 2 0 2 1
5 El Ahli Sanaa Ahli Sanaa 2 0 3 0
6 Fanja Fanja 5 13 3 13
7 Al-Wasl Al-Wasl 3 4 3 6
8 Al Arabi Al Arabi 3 4 4 4
9 Al-Muharraq Al-Muharraq 2 3 3 3
10 Al-Hilal SFC Al-Hilal 2 1 3 0
11 Salgaocar Salgaocar 3 4 3 4
12 Punjab FC Punjab FC 3 1 3 2
13 Kathmandu Club Kathmandu 3 1 9 1
14 Shahin Ahvaz Shahin Ahvaz 3 11 0 9
15 Mohammedan Dhaka Mohammedan 3 10 4 6
16 Old Benedictans Benedictans 3 4 9 3
17 Victory SC Victory SC 3 3 15 0
18 Kuala Lumpur Kuala Lumpur 3 15 2 9
19 Geylang International Geylang 2 8 1 6
20 Madura United Madura 2 3 3 3
21 Philippine Air Force Philippine 2 0 9 0
22 Muara Stars FC Muara Stars 3 3 14 0
23 Liaoning Whowin Liaoning 3 7 2 7
24 Yokohama F. Marinos Yokohama 3 11 1 6
25 Ch'ongjin Chandongcha Ch'ongjin 3 3 3 4
26 CD Hap Kuang Kuang 3 1 16 0
Ver
TEMPORADA 1988/1989
Equipo PJ GF GC Puntos
1 Al Karkh Al Karkh 3 9 0 7
2 Al-Sadd Al-Sadd 3 5 1 7
3 Al Fotuwa Al Fotuwa 3 2 7 3
4 Al Ansar Beirut Ansar Beirut 3 0 8 0
5 Al-Ettifaq Al-Ettifaq 3 5 1 9
6 Fanja Fanja 5 14 7 6
7 Kazma SC Kazma SC 2 5 1 6
8 Sharjah FC Sharjah FC 2 2 1 3
9 Al-Riffa Al-Riffa 3 1 7 0
10 Mohun Bagan SG Mohun Bagan 3 13 2 9
11 Crescent Textile Mills FC Crescent 3 3 17 3
12 Kathmandu Club Kathmandu 3 4 11 0
13 Mohammedan Dhaka Mohammedan 2 2 1 4
14 Persepolis Persepolis 2 6 2 3
15 Saunders Saunders 2 0 5 1
16 Air Force Central Force 3 13 2 9
17 Mitra Kukar Mitra Kukar 3 4 3 4
18 Geylang International Geylang 2 3 10 3
19 Pahang Pahang 2 1 2 1
20 Kuala Belait Kuala Belait 2 2 6 0
21 April 25 April 25 2 7 0 6
22 Guangdong Hongyuan Guangdong 2 4 1 6
23 Júbilo Iwata Júbilo 3 11 6 4
24 South China AA South China 3 1 5 1
25 CD Wa Cheng CD Wa Cheng 2 2 13 0
Ver
TEMPORADA 1987/1988
Equipo PJ GF GC Puntos
1 Kazma SC Kazma SC 4 6 1 9
2 Al-Hilal SFC Al-Hilal 4 6 3 7
3 Al-Muharraq Al-Muharraq 4 5 7 6
4 Al Nasr Dubai Nasr Dubai 4 3 4 4
5 Fanja Fanja 4 4 9 3
6 Al Karkh Al Karkh 4 23 2 12
7 Mohun Bagan SG Mohun Bagan 5 13 10 7
8 Mohammedan Dhaka Mohammedan 4 12 10 7
9 Manang Marshyangdi Manang 4 8 19 3
10 Pakistan Air Force Pakistan 3 2 17 0
11 Bangkok Bank Bangkok Bank 2 7 0 4
12 Blue Eagles Blue Eagles 2 1 1 2
13 Victory SC Victory SC 2 1 8 1
14 Kuala Lumpur Kuala Lumpur 3 10 1 7
15 Krama YTB Krama YTB 3 8 3 6
16 Tanjong Pagar Tanjong 3 3 5 4
17 Kota Ranger Kota Ranger 3 4 16 0
18 Bayi Xiangtan Bayi 2 5 0 6
19 April 25 April 25 2 2 3 3
20 CD Hap Kuang Kuang 2 1 5 0
21 Tokyo Verdy Tokyo Verdy 2 3 0 6
22 South China AA South China 2 0 3 0
Ver
TEMPORADA 1985/1986
Equipo PJ GF GC Puntos
1 Al Karkh Al Karkh 1 4 0 3
2 East Bengal Club East Bengal 1 0 4 0
3 Pia FC Pia FC 4 0 12 0
4 Krama YTB Krama YTB 4 15 1 10
5 Bangkok Bank Bangkok Bank 4 10 2 10
6 Melaka United FC Melaka 4 2 7 4
7 Tanjong Pagar Tanjong 4 2 7 4
8 Seiko SA Seiko SA 4 6 6 9
9 April 25 April 25 4 8 4 7
10 Liaoning Whowin Liaoning 4 2 6 1
11 Busan I Park Busan Park 2 14 1 6
12 CD Wa Cheng CD Wa Cheng 2 1 14 0

  USO DE MEMORIA  
5,264,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5655
Total Execution Time  0.5675
  CADENA URL  
/clasificacion_afc_champions_league2024/grupo1/historico
  GET DATOS  
$_GET['/clasificacion_afc_champions_league2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0144  SELECT type FROM routes WHERE alias = 'clasificacion_afc_champions_league2024'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_afc_champions_league' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2822 AND type_rel = 3
0.0148  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2822 ORDER BY order_id ASC
0.0149  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2822 GROUP BY l.categoryId
0.0149  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2822 GROUP BY l.year ORDER BY l.year DESC
0.0149  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 = 72328 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2822 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0169  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 = 27264 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 `tables1995` 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 = 56492 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 `tables1991` 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 = 56579 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1990` 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 = 56582 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1989` 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 = 56586 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1988` 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 = 56590 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1986` 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 = 56596 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 03:29:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0153  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 03:29:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 03:29:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 03:29:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0162  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_afc_champions_league' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0159  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2822 AND l.year = 2024
0.0153  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72328,72329) 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, e.player_id ASC LIMIT 10
0.0167  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72328,72329) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (178179,229055,180944,186316,397534,832746,46190,61263,86542,86621) ORDER BY rp.in_squad = 1 DESC
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2822 AND l.year = 2024
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72328,72329) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0157  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72328,72329) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (335753,438330,795976,3270,61263,62596,148215,154287,182550,186575) ORDER BY rp.in_squad = 1 DESC
0.0151  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2822 AND l.year = 2024
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72328,72329) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0157  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72328,72329) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (335753,795976) ORDER BY rp.in_squad = 1 DESC