4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Hibernian Sub 20 Hibernian 26 72 35 59
2 Dundee Sub 20 Dundee 26 52 33 53
3 Hearts Sub 20 Hearts 26 62 43 52
4 Aberdeen Sub 20 Aberdeen 26 49 30 47
5 Motherwell Sub 20 Motherwell 26 45 34 45
6 Celtic Sub 20 Celtic 26 49 27 44
7 Ross County Sub 20 Ross County 26 56 52 40
8 Hamilton Academical Sub 20 Hamilton 26 46 38 39
9 Dundee United Sub 20 Dundee 26 37 61 28
10 St. Mirren Sub 20 Mirren 26 43 59 26
11 St. Johnstone Sub 20 Johnstone 26 41 57 26
12 Partick Thistle Sub 20 Partick 26 36 65 22
13 Kilmarnock Sub 20 Kilmarnock 26 29 53 19
14 Falkirk Sub 20 Falkirk 26 26 56 19
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Ross County Sub 20 Ross County 32 63 40 66
2 Hamilton Academical Sub 20 Hamilton 32 72 39 64
3 Celtic Sub 20 Celtic 32 77 26 63
4 Hibernian Sub 20 Hibernian 32 67 43 61
5 Motherwell Sub 20 Motherwell 32 66 39 57
6 Rangers FC Sub 20 Rangers 32 53 47 51
7 Falkirk Sub 20 Falkirk 32 57 52 49
8 Partick Thistle Sub 20 Partick 32 61 64 48
9 Aberdeen Sub 20 Aberdeen 32 56 74 46
10 Dunfermline Sub 20 Dunfermline 32 45 53 44
11 Hearts Sub 20 Hearts 32 48 46 43
12 Kilmarnock Sub 20 Kilmarnock 32 51 68 32
13 St. Mirren Sub 20 Mirren 32 46 70 31
14 Dundee United Sub 20 Dundee 32 49 66 30
15 Dundee Sub 20 Dundee 32 32 57 28
16 Inverness CT Sub 20 Inverness 32 32 66 27
17 St. Johnstone Sub 20 Johnstone 32 34 59 25
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Celtic Sub 20 Celtic 32 71 15 88
2 Hamilton Academical Sub 20 Hamilton 32 66 48 62
3 Aberdeen Sub 20 Aberdeen 32 58 42 54
4 St. Johnstone Sub 20 Johnstone 32 61 50 52
5 St. Mirren Sub 20 Mirren 32 52 52 51
6 Motherwell Sub 20 Motherwell 32 50 45 47
7 Hibernian Sub 20 Hibernian 32 41 46 43
8 Dundee United Sub 20 Dundee 32 64 57 40
9 Dundee Sub 20 Dundee 32 45 55 40
10 Kilmarnock Sub 20 Kilmarnock 32 49 50 39
11 Falkirk Sub 20 Falkirk 32 55 64 38
12 Hearts Sub 20 Hearts 32 39 54 38
13 Rangers FC Sub 20 Rangers 32 47 54 37
14 Inverness CT Sub 20 Inverness 32 39 52 36
15 Ross County Sub 20 Ross County 32 39 55 36
16 Partick Thistle Sub 20 Partick 32 53 65 35
17 Dunfermline Sub 20 Dunfermline 32 38 63 25
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Aberdeen Sub 20 Aberdeen 32 87 37 77
2 Celtic Sub 20 Celtic 32 70 31 69
3 Hamilton Academical Sub 20 Hamilton 32 78 42 62
4 Rangers FC Sub 20 Rangers 32 67 46 57
5 Hibernian Sub 20 Hibernian 32 75 54 51
6 Falkirk Sub 20 Falkirk 32 46 46 51
7 Partick Thistle Sub 20 Partick 32 58 72 46
8 Motherwell Sub 20 Motherwell 32 61 50 45
9 St. Johnstone Sub 20 Johnstone 32 40 46 42
10 Dundee United Sub 20 Dundee 32 57 60 40
11 Dundee Sub 20 Dundee 32 40 57 40
12 Kilmarnock Sub 20 Kilmarnock 32 49 59 39
13 St. Mirren Sub 20 Mirren 32 44 54 39
14 Dunfermline Sub 20 Dunfermline 32 52 59 33
15 Hearts Sub 20 Hearts 32 46 78 27
16 Ross County Sub 20 Ross County 32 54 82 25
17 Inverness CT Sub 20 Inverness 32 33 84 23

  USO DE MEMORIA  
5,225,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4046
Total Execution Time  0.4067
  CADENA URL  
/liga_escocesa_sub_202018/grupo1/historico
  GET DATOS  
$_GET['/liga_escocesa_sub_202018/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0124  SELECT type FROM routes WHERE alias = 'liga_escocesa_sub_202018'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_escocesa_sub_20' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1571 AND type_rel = 3
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1571 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  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 (761162,593488,254780,150869,128969) ORDER BY n.cover_points DESC, update_date DESC
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1571 ORDER BY order_id ASC
0.0129  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1571 GROUP BY l.categoryId
0.0136  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=1571 GROUP BY l.year ORDER BY l.year DESC
0.0134  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 = 39539 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1571 AND group_code = 1 and tables = 1 AND year <= 2018 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0129  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 `tables2018` 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 = 39539 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2017` 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 = 36109 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 15873 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2015` 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 = 9320 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 15:57:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 15:57:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 15:57:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 15:57:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_escocesa_sub_20' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  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 events2018 e ON e.player_id = p.id AND e.league_id = 39539 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39539 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.0126  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 events2018 e ON e.player_id = p.id AND e.league_id = 39539 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39539 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  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 events2018 e ON e.player_id = p.id AND e.league_id = 39539 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39539 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 39539 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC