4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Slavia Sofia Sub 19 Slavia Sofia 32 66 23 71
2 Lovech Sub 19 Lovech 32 88 30 69
3 Ludogorets Sub 19 Ludogorets 32 82 32 66
4 Botev Plovdiv Sub 19 Botev 32 72 29 65
5 CSKA Sofia Sub 19 CSKA Sofia 32 55 32 57
6 Septemvri Sofia Sub 19 Septemvri 32 80 54 56
7 Beroe Stara Sub 19 Beroe Stara 32 47 38 56
8 Levski Sofia Sub 19 Levski Sofia 32 77 52 54
9 Cherno More Varna Sub 19 Cherno More 32 52 59 47
10 Montana Sub 19 Montana 32 37 57 42
11 Neftohimik Sub 19 Neftohimik 32 35 51 37
12 Pirin Blagoevgrad Sub 19 Pirin 32 46 63 34
13 Vereya Sub 19 Vereya 32 35 60 34
14 Chernomoretz Burgas Sub 19 Chernomoretz 32 37 91 33
15 Lokomotiv Plovdiv Sub 19 Lokomotiv 32 39 54 31
16 Sofia 2010 Sub 19 Sofia 2010 32 16 81 15
17 Gorna Lokomotiv Sub 19 Gorna 32 27 85 10
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Lovech Sub 19 Lovech 30 109 23 74
2 Levski Sofia Sub 19 Levski Sofia 30 91 17 74
3 CSKA Sofia Sub 19 CSKA Sofia 30 75 20 67
4 Cherno More Varna Sub 19 Cherno More 30 59 25 67
5 Botev Plovdiv Sub 19 Botev 30 63 20 57
6 Beroe Stara Sub 19 Beroe Stara 30 55 33 49
7 Chernomoretz Burgas Sub 19 Chernomoretz 30 54 44 44
8 Slavia Sofia Sub 19 Slavia Sofia 30 36 33 44
9 Chavdar Etropole Sub 19 Chavdar 30 51 37 40
10 Vidima Sub 19 Vidima 30 36 50 36
11 Oskar El Sub 19 Oskar 30 45 59 29
12 Svetkavitsa Targovishte Sub Svetkavitsa 30 27 67 26
13 Pirin 2001 Blagoevgrad Sub Pirin 2001. 30 20 66 25
14 Velbazhd Kyustendil Sub 19 Velbazhd 30 32 97 21
15 Lyubimets Sub 19 Lyubimets 30 29 124 19
16 Spartak Varna Sub 19 Spartak 30 22 89 17

  USO DE MEMORIA  
5,113,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.4060
Total Execution Time  0.4087
  CADENA URL  
/liga_bulgaria_sub192016/grupo1/historico
  GET DATOS  
$_GET['/liga_bulgaria_sub192016/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0146  SELECT type FROM routes WHERE alias = 'liga_bulgaria_sub192016'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_bulgaria_sub19' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2374 AND type_rel = 3
0.0146  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2374 ORDER BY order_id ASC
0.0146  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2374 GROUP BY l.categoryId
0.0147  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=2374 GROUP BY l.year ORDER BY l.year DESC
0.0148  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 = 59263 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2374 AND group_code = 1 and tables = 1 AND year <= 2016 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2016` 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 = 59263 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2014` 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 = 59265 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:04:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:04:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:04:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:04: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 = 'liga_bulgaria_sub19' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0147  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 events2016 e ON e.player_id = p.id AND e.league_id = 59263 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59263 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.0146  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 events2016 e ON e.player_id = p.id AND e.league_id = 59263 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59263 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 events2016 e ON e.player_id = p.id AND e.league_id = 59263 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59263 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0157  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 59263 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC