4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Bylis Ballsh Bylis Ballsh 30 57 26 69
2 KF Elbasani KF Elbasani 30 56 25 62
3 Kamza Kamza 30 50 21 62
4 Lushnja Lushnja 30 59 10 60
5 Partizani Tirana Partizani 30 49 35 57
6 Pogradeci Pogradeci 30 40 39 48
7 Ada Velipojë Velipojë 30 46 34 42
8 KF Luftëtari Luftëtari 30 38 45 36
9 Besëlidhja Lezhë Besëlidhja 30 32 40 35
10 Gramshi Gramshi 30 23 34 32
11 Bilisht Sporti Bilisht 30 30 50 32
12 Burreli Burreli 30 26 41 31
13 Skrapari Skrapari 30 29 56 31
14 Memaliaj Memaliaj 30 23 37 29
15 Turbina Cërrik Turbina 30 35 53 28
16 Sopoti Librazhd Sopoti 30 14 61 15
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Laçi Laçi 30 54 22 68
2 Skënderbeu Korçë Skënderbeu 30 60 32 65
3 Kastrioti Krujë Kastrioti 30 52 24 63
4 Gramozi Ersekë Gramozi 30 54 35 54
5 Burreli Burreli 30 38 27 47
6 Kamza Kamza 30 34 28 44
7 Turbina Cërrik Turbina 30 45 42 41
8 Ada Velipojë Velipojë 30 43 58 38
9 KF Luftëtari Luftëtari 30 30 37 37
10 Besëlidhja Lezhë Besëlidhja 30 40 51 37
11 Sopoti Librazhd Sopoti 30 32 43 37
12 Skrapari Skrapari 30 30 41 35
13 Pogradeci Pogradeci 30 34 44 34
14 Bilisht Sporti Bilisht 30 40 47 28
15 Tërbuni Pukë Tërbuni 30 23 41 27
16 Naftëtari Kuçovë Naftëtari 30 28 65 20
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Bylis Ballsh Bylis Ballsh 34 70 20 74
2 Apolonia Fier Apolonia 34 70 23 73
3 Lushnja Lushnja 34 57 26 73
4 Burreli Burreli 34 51 26 67
5 Laçi Laçi 34 57 29 66
6 Ada Velipojë Velipojë 34 50 37 57
7 KF Luftëtari Luftëtari 34 48 43 48
8 Skrapari Skrapari 34 39 39 48
9 Kamza Kamza 34 37 29 44
10 Turbina Cërrik Turbina 34 34 48 44
11 Pogradeci Pogradeci 34 33 33 43
12 Bilisht Sporti Bilisht 34 37 48 43
13 Sopoti Librazhd Sopoti 34 30 42 43
14 Naftëtari Kuçovë Naftëtari 34 36 51 40
15 Erzeni Shijak Erzeni 34 29 42 39
16 Tomori Berat Tomori Berat 34 29 56 31
17 Gramshi Gramshi 34 28 58 29
18 Tepelena Tepelena 34 23 108 10

  USO DE MEMORIA  
5,151,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3700
Total Execution Time  0.3719
  CADENA URL  
/primera_division_albania2010/grupo1/historico
  GET DATOS  
$_GET['/primera_division_albania2010/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0146  SELECT type FROM routes WHERE alias = 'primera_division_albania2010'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_albania' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0155  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 = 8877 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 288 AND group_code = 1 and tables = 1 AND year <= 2010 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2010` 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 = 8877 AND t.round = 30 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 `tables2009` 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 = 8875 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2008` 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 = 8873 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 11:08:41' 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=2 AND last_update > '2024-04-28 11:08:41' 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-04-28 11:08:41' 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-04-28 11:08:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0163  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_albania' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0155  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 events2010 e ON e.player_id = p.id AND e.league_id = 8877 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8877 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.0152  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 events2010 e ON e.player_id = p.id AND e.league_id = 8877 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8877 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  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 events2010 e ON e.player_id = p.id AND e.league_id = 8877 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8877 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0171  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 8877 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC