4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
13 Ago 16 Edusport AcademyEdusport 2 - 2 Colville ParkColville ...
13 Ago 16 Newton StewartNewton 0 - 4 Beith JuniorsBeith ...
13 Ago 16 Wigtown & BladnochWigtown 0 - 4 Auchinleck TalbotAuchinleck ...
14 Ago 16 Glasgow UniversityGlasgow 2 - 8 Bonnyrigg RoseBonnyrigg ...
13 Ago 16 St. Cuthbert WanderersCuthbert 0 - 3 Leith AthleticLeith ...
20 Ago 16 Colville ParkColville 1 - 0 Edusport AcademyEdusport ...
Ver jornada
Jornada 2
03 Sep 16 Threave RoversThreave 1 - 2 Linlithgow RoseLinlithgow ...
03 Sep 16 Banks O' DeeBanks 4 - 0 Golspie SutherlandGolspie ...
03 Sep 16 Beith JuniorsBeith 2 - 2 Auchinleck TalbotAuchinleck ...
03 Sep 16 Leith AthleticLeith 1 - 0 ColdstreamColdstream ...
03 Sep 16 Bonnyrigg RoseBonnyrigg 14 - 0 Burntisland ShipyardBurntisland ...
03 Sep 16 Colville ParkColville 0 - 1 GirvanGirvan ...
10 Sep 16 Auchinleck TalbotAuchinleck 0 - 3 Beith JuniorsBeith ...
Ver jornada
Jornada 3
24 Sep 16 Turriff UnitedTurriff 1 - 1 Bonnyrigg RoseBonnyrigg ...
25 Sep 16 Leith AthleticLeith 0 - 0 Cumbernauld ColtsCumbernauld ...
24 Sep 16 Fort WilliamFort 1 - 4 Brora RangersBrora ...
24 Sep 16 Forres MechanicsForres 2 - 2 LossiemouthLossiemouth ...
24 Sep 16 East KilbrideEast 9 - 1 Vale of LeithenVale ...
24 Sep 16 BSC GlasgowGlasgow 3 - 1 RothesRothes ...
24 Sep 16 DeveronvaleDeveronvale 0 - 3 Gretna 2008Gretna 2008 ...
24 Sep 16 KeithKeith 0 - 1 Banks O' DeeBanks ...
24 Sep 16 AFC Edinburgh UniversityEdinburgh 0 - 1 Whitehill WelfareWhitehill ...
24 Sep 16 Gala Fairydean RoversGala 3 - 1 FraserburghFraserburgh ...
24 Sep 16 Beith JuniorsBeith 6 - 0 Strathspey ThistleStrathspey ...
24 Sep 16 Civil Service StrollersCivil 1 - 1 Hawick Royal AlbertHawick ...
24 Sep 16 Nairn CountyNairn 2 - 3 Preston AthleticPreston ...
24 Sep 16 Inverurie Loco WorksInverurie 0 - 6 Buckie ThistleBuckie ...
24 Sep 16 ClachnacuddinClachnacudd 1 - 2 Stirling UniversityStirling ...
24 Sep 16 Dalbeattie StarDalbeattie 1 - 3 Wick AcademyWick ...
24 Sep 16 SelkirkSelkirk 0 - 3 Linlithgow RoseLinlithgow ...
24 Sep 16 GirvanGirvan 1 - 2 HuntlyHuntly ...
01 Oct 16 Bonnyrigg RoseBonnyrigg 4 - 1 Turriff UnitedTurriff ...
01 Oct 16 LossiemouthLossiemouth 0 - 4 Forres MechanicsForres ...
01 Oct 16 Hawick Royal AlbertHawick 6 - 2 Civil Service StrollersCivil ...
05 Oct 16 Cumbernauld ColtsCumbernauld 1 - 0 Leith AthleticLeith 1
Ver jornada
Jornada 4
22 Oct 16 Buckie ThistleBuckie 1 - 1 Gretna 2008Gretna 2008 ...
22 Oct 16 Gala Fairydean RoversGala 0 - 4 Elgin CityElgin City ...
22 Oct 16 ArbroathArbroath 3 - 1 Stirling UniversityStirling ...
22 Oct 16 CowdenbeathCowdenbeath 0 - 1 East KilbrideEast ...
22 Oct 16 Edinburgh CityEdinburgh 0 - 0 Forfar AthleticForfar ...
22 Oct 16 HuntlyHuntly 0 - 2 SpartansSpartans ...
22 Oct 16 Preston AthleticPreston 0 - 3 MontroseMontrose ...
22 Oct 16 Wick AcademyWick 4 - 1 Whitehill WelfareWhitehill ...
22 Oct 16 Linlithgow RoseLinlithgow 0 - 3 Stirling AlbionStirling ...
22 Oct 16 BSC GlasgowGlasgow 0 - 1 Beith JuniorsBeith ...
22 Oct 16 Brora RangersBrora 0 - 2 ClydeClyde ...
22 Oct 16 Annan AthleticAnnan 0 - 0 East StirlingshireEast ...
22 Oct 16 Banks O' DeeBanks 2 - 2 Formartine UnitedFormartine ...
22 Oct 16 Bonnyrigg RoseBonnyrigg 2 - 1 Cove RangersCove ...
22 Oct 16 Cumbernauld ColtsCumbernauld 2 - 2 Forres MechanicsForres ...
22 Oct 16 Berwick RangersBerwick 2 - 3 Hawick Royal AlbertHawick 1
29 Oct 16 East StirlingshireEast 1 - 2 Annan AthleticAnnan ...
29 Oct 16 Formartine UnitedFormartine 7 - 2 Banks O' DeeBanks 1
29 Oct 16 Forres MechanicsForres 4 - 0 Cumbernauld ColtsCumbernauld ...
29 Oct 16 Gretna 2008Gretna 2008 2 - 6 Buckie ThistleBuckie ...
01 Nov 16 Forfar AthleticForfar 0 - 1 Edinburgh CityEdinburgh ...
Ver jornada
Jornada 5
26 Nov 16 Elgin CityElgin City 8 - 1 Hawick Royal AlbertHawick ...
26 Nov 16 AirdrieoniansAirdrieonia 1 - 2 LivingstonLivingston ...
03 Dic 16 Stirling AlbionStirling 2 - 0 Wick AcademyWick ...
29 Nov 16 St. MirrenSt. Mirren 5 - 1 SpartansSpartans ...
03 Dic 16 StranraerStranraer 2 - 1 East KilbrideEast ...
29 Nov 16 Albion RoversAlbion 2 - 1 Queen of the SouthQueen South ...
06 Dic 16 ClydeClyde 5 - 0 ArbroathArbroath ...
03 Dic 16 Beith JuniorsBeith 0 - 6 Greenock MortonGreenock ...
29 Nov 16 Brechin CityBrechin 0 - 1 Ayr UnitedAyr United ...
26 Nov 16 Bonnyrigg RoseBonnyrigg 0 - 0 DumbartonDumbarton 1
26 Nov 16 PeterheadPeterhead 0 - 1 Alloa AthleticAlloa ...
29 Nov 16 Queen's ParkQueen's 2 - 0 MontroseMontrose 1
26 Nov 16 Buckie ThistleBuckie 3 - 5 Dunfermline Athletic FCDunfermline ...
26 Nov 16 Forres MechanicsForres 2 - 2 StenhousemuirStenhousemu ...
03 Dic 16 Formartine UnitedFormartine 4 - 0 Annan AthleticAnnan 1
29 Nov 16 East FifeEast Fife 1 - 1 Edinburgh CityEdinburgh 1
03 Dic 16 StenhousemuirStenhousemu 3 - 1 Forres MechanicsForres ...
06 Dic 16 DumbartonDumbarton 0 - 1 Bonnyrigg RoseBonnyrigg 1
07 Dic 16 Edinburgh CityEdinburgh 0 - 1 East FifeEast Fife 8
Ver jornada
Jornada 6
21 Ene 17 Ross County FCRoss County 6 - 2 Dundee UnitedDundee ...
21 Ene 17 St. JohnstoneJohnstone 2 - 0 StenhousemuirStenhousemu 1
21 Ene 17 LivingstonLivingston 0 - 1 East FifeEast Fife ...
21 Ene 17 AberdeenAberdeen 4 - 0 StranraerStranraer ...
21 Ene 17 Elgin CityElgin City 1 - 2 Inverness CTInverness ...
21 Ene 17 KilmarnockKilmarnock 0 - 1 Hamilton AcademicalHamilton ...
21 Ene 17 Bonnyrigg RoseBonnyrigg 1 - 8 Hibernian FCHibernian ...
21 Ene 17 Ayr UnitedAyr United 0 - 0 Queen's ParkQueen's ...
21 Ene 17 Partick ThistlePartick 4 - 0 Formartine UnitedFormartine 2
21 Ene 17 Stirling AlbionStirling 2 - 2 ClydeClyde ...
21 Ene 17 DundeeDundee 0 - 2 St. MirrenSt. Mirren ...
21 Ene 17 Greenock MortonGreenock 2 - 0 FalkirkFalkirk ...
21 Ene 17 Alloa AthleticAlloa 2 - 3 Dunfermline Athletic FCDunfermline ...
21 Ene 17 Rangers FCRangers FC 2 - 1 MotherwellMotherwell 5
22 Ene 17 Raith RoversRaith 1 - 1 Heart of MidlothianHeart 6
22 Ene 17 Albion RoversAlbion 0 - 3 CelticCeltic 3
31 Ene 17 ClydeClyde 3 - 2 Stirling AlbionStirling ...
25 Ene 17 Heart of MidlothianHeart 4 - 2 Raith RoversRaith 41
24 Ene 17 Queen's ParkQueen's 2 - 2 Ayr UnitedAyr United 10
Ver jornada
Jornada 7
11 Feb 17 Dunfermline Athletic FCDunfermline 1 - 1 Hamilton AcademicalHamilton ...
11 Feb 17 St. JohnstoneJohnstone 0 - 1 Partick ThistlePartick ...
11 Feb 17 East FifeEast Fife 2 - 3 St. MirrenSt. Mirren ...
11 Feb 17 Ross County FCRoss County 0 - 1 AberdeenAberdeen ...
11 Feb 17 CelticCeltic 6 - 0 Inverness CTInverness 11
12 Feb 17 Rangers FCRangers FC 2 - 1 Greenock MortonGreenock 7
12 Feb 17 Heart of MidlothianHeart 0 - 0 Hibernian FCHibernian 3
11 Feb 17 Ayr UnitedAyr United 1 - 1 ClydeClyde ...
14 Feb 17 ClydeClyde 1 - 2 Ayr UnitedAyr United 3
14 Feb 17 Hamilton AcademicalHamilton 1 - 1 Dunfermline Athletic FCDunfermline 3
22 Feb 17 Hibernian FCHibernian 3 - 1 Heart of MidlothianHeart 10
Ver jornada
Jornada 8
04 Mar 17 Rangers FCRangers FC 6 - 0 Hamilton AcademicalHamilton 4
05 Mar 17 CelticCeltic 4 - 1 St. MirrenSt. Mirren 18
05 Mar 17 AberdeenAberdeen 1 - 0 Partick ThistlePartick 2
04 Mar 17 Hibernian FCHibernian 3 - 1 Ayr UnitedAyr United 1
Ver jornada
Jornada 9
23 Abr 17 CelticCeltic 2 - 0 Rangers FCRangers FC 19
22 Abr 17 Hibernian FCHibernian 2 - 3 AberdeenAberdeen 7
Ver jornada
Jornada 10
27 May 17 CelticCeltic 2 - 1 AberdeenAberdeen 242

  USO DE MEMORIA  
5,083,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0052
Controller Execution Time ( Home / Category )  0.3886
Total Execution Time  0.3939
  CADENA URL  
/copa_escocia2017/grupo0/calendario
  GET DATOS  
$_GET['/copa_escocia2017/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0126  SELECT type FROM routes WHERE alias = 'copa_escocia2017'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_escocia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1500 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1500 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1311763,1259127,1228796,1222740,1141369) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = 33924 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2017 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 33924 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 22:05:42' 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=2 AND last_update > '2024-04-30 22:05:42' 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=4 AND last_update > '2024-04-30 22:05:42' 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=3 AND last_update > '2024-04-30 22:05:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1500 AND l.year = 2017
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (33924) 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.0129  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 (33924) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (299681,346993,85574,205547,85496,192455,201833,572,598,2721) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1500 AND l.year = 2017
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (33924) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0129  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 (33924) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (186647,210009,299663,39536,47408,56818,71561,85283,85496,85596) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1500 AND l.year = 2017
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (33924) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0129  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 (33924) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (186647,3687,141807,160175,160192,160710,210009,242058,243917,285639) ORDER BY rp.in_squad = 1 DESC