4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Pafos Pafos 26 46 22 54
2 APEP APEP 26 45 26 51
3 Digenis Morphou Digenis 26 44 26 46
4 Atromitos Yeroskipou Atromitos 26 41 23 46
5 Onisilos Onisilos 26 32 23 38
6 Ermis Aradippou Ermis 26 51 43 38
7 Ayia Napa Ayia Napa 26 32 32 34
8 Omonia Aradippou Omonia 26 25 24 33
9 ASIL Lysi ASIL Lysi 26 20 24 32
10 EN THOI Lakatamia THOI 26 28 40 31
11 MEAP Nisou MEAP Nisou 26 32 49 31
12 Anagennisi Anagennisi 26 21 35 30
13 Akritas Chlorakas Akritas 26 22 39 22
14 Olympos Olympos 26 23 56 16
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 APOP Kinyras APOP Kinyras 26 65 22 58
2 Alki Alki 26 46 16 56
3 Doxa Katokopias Doxa 26 36 20 50
4 EN THOI Lakatamia THOI 26 54 36 49
5 ASIL Lysi ASIL Lysi 26 48 26 47
6 Anagennisi Anagennisi 26 30 27 36
7 Omonia Aradippou Omonia 26 38 31 35
8 MEAP Nisou MEAP Nisou 26 33 40 35
9 Onisilos Onisilos 26 39 31 33
10 APEP APEP 26 38 43 31
11 Akritas Chlorakas Akritas 26 33 41 30
12 Halkanoras Halkanoras 26 36 47 26
13 Iraklis Yerolakkou Iraklis 26 25 62 13
14 AE Mesogis AE Mesogis 26 25 104 3

  USO DE MEMORIA  
4,944,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0036
Controller Execution Time ( Home / Category )  0.0773
Total Execution Time  0.0809
  CADENA URL  
/2_division_chipre2008/grupo1/historico
  GET DATOS  
$_GET['/2_division_chipre2008/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=708 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 708 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1267270,1252536,262172,90198,9789) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=708 ORDER BY order_id ASC
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 708 AND group_code = 1 and tables = 1 AND year <= 2008 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0023  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 = 8739 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2007` 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 = 8737 AND t.round = 26 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-05 16:14:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 16:14:55' 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=4 AND last_update > '2024-05-05 16:14:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0029  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 16:14:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  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 events2008 e ON e.player_id = p.id AND e.league_id = 8739 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8739 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 events2008 e ON e.player_id = p.id AND e.league_id = 8739 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8739 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0023  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 events2008 e ON e.player_id = p.id AND e.league_id = 8739 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8739 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0067  SELECT *,(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 = 8739 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC