4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
12 Ago 23 Abbey ValeAbbey Vale 0 - 5 Cupar HeartsCupar ...
12 Ago 23 Carnoustie PanmureCarnoustie 1 - 2 Beith JuniorsBeith ...
12 Ago 23 LuncartyLuncarty 3 - 1 Loch Ness FCLoch Ness ...
Ver jornada
Jornada 2
02 Sep 23 Broxburn AthleticBroxburn 3 - 0 Lochee UnitedLochee ...
02 Sep 23 Camelon JuniorsCamelon 0 - 0 Newtongrange StarNewtongrang ...
02 Sep 23 Carluke RoversCarluke 2 - 3 Dalbeattie StarDalbeattie ...
02 Sep 23 CreetownCreetown 1 - 3 Whitehill WelfareWhitehill ...
02 Sep 23 CulterCulter 3 - 2 Blackburn UnitedBlackburn ...
02 Sep 23 Cumnock Juniors FCCumnock 1 - 0 GirvanGirvan ...
02 Sep 23 Dunbar UnitedDunbar 4 - 2 Vale of LeithenVale ...
02 Sep 23 Easthouses LilyEasthouses 1 - 3 Threave RoversThreave ...
02 Sep 23 Fort WilliamFort 1 - 10 ClydebankClydebank ...
02 Sep 23 Glenafton AthleticGlenafton 0 - 3 DarvelDarvel ...
02 Sep 23 Hawick Royal AlbertHawick 1 - 2 Golspie SutherlandGolspie ...
02 Sep 23 Hill Of Beath HawthornHill Beath 0 - 1 TayportTayport ...
02 Sep 23 Irvine Meadow XI FCIrvine 1 - 2 DunipaceDunipace ...
02 Sep 23 Kilwinning Rangers FCKilwinning 4 - 0 Glasgow UniversityGlasgow ...
02 Sep 23 Musselburgh AthleticMusselburgh 6 - 0 ColdstreamColdstream ...
02 Sep 23 Penicuik AthleticPenicuik 4 - 2 Rutherglen GlencairnRutherglen ...
02 Sep 23 Pollok FCPollok FC 2 - 2 BenburbBenburb ...
02 Sep 23 Preston AthleticPreston 0 - 0 Dundonald BluebellDundonald ...
02 Sep 23 Sauchie JuniorsSauchie 4 - 0 Burntisland ShipyardBurntisland ...
02 Sep 23 St Andrews UnitedAndrews 1 - 0 Haddington AthleticHaddington ...
02 Sep 23 St. Cuthbert WanderersCuthbert 0 - 5 Dalkeith ThistleDalkeith ...
02 Sep 23 TynecastleTynecastle 0 - 1 Lothian HutchisonLothian ...
02 Sep 23 Wigtown & BladnochWigtown 0 - 12 Auchinleck TalbotAuchinleck ...
02 Sep 23 Beith JuniorsBeith 5 - 1 Bonnyton ThistleBonnyton ...
02 Sep 23 Jeanfield SwiftsJeanfield 3 - 0 Cupar HeartsCupar ...
02 Sep 23 Newton StewartNewton 1 - 4 LuncartyLuncarty ...
Ver jornada
Jornada 3
23 Sep 23 Banks O' DeeBanks 6 - 0 Dalbeattie StarDalbeattie ...
23 Sep 23 Bo'ness UnitedBo'ness 3 - 0 DarvelDarvel ...
23 Sep 23 Brechin CityBrechin 4 - 0 RothesRothes ...
24 Sep 23 Broomhill FCBroomhill 3 - 1 Cumbernauld ColtsCumbernauld ...
23 Sep 23 Brora RangersBrora 5 - 1 Berwick RangersBerwick ...
23 Sep 23 Broxburn AthleticBroxburn 2 - 1 Nairn CountyNairn ...
23 Sep 23 Caledonian BravesCaledonian 1 - 2 FraserburghFraserburgh ...
23 Sep 23 Camelon JuniorsCamelon 1 - 2 Civil Service StrollersCivil ...
23 Sep 23 ClachnacuddinClachnacudd 1 - 0 Inverurie Loco WorksInverurie ...
23 Sep 23 CowdenbeathCowdenbeath 2 - 1 Linlithgow RoseLinlithgow ...
23 Sep 23 CulterCulter 3 - 4 DeveronvaleDeveronvale ...
23 Sep 23 Dalkeith ThistleDalkeith 0 - 7 ClydebankClydebank ...
23 Sep 23 Dundonald BluebellDundonald 2 - 3 Kilwinning Rangers FCKilwinning ...
23 Sep 23 DunipaceDunipace 1 - 3 Cumnock Juniors FCCumnock ...
23 Sep 23 East KilbrideEast 8 - 0 Whitehill WelfareWhitehill ...
23 Sep 23 East StirlingshireEast 0 - 1 HuntlyHuntly ...
23 Sep 23 AFC Edinburgh UniversityEdinburgh 2 - 3 Dunbar UnitedDunbar ...
23 Sep 23 Formartine UnitedFormartine 3 - 2 Threave RoversThreave ...
23 Sep 23 Gala Fairydean RoversGala 8 - 2 Strathspey ThistleStrathspey ...
23 Sep 23 Golspie SutherlandGolspie 1 - 1 Forres MechanicsForres ...
23 Sep 23 KeithKeith 2 - 5 LuncartyLuncarty ...
23 Sep 23 LossiemouthLossiemouth 0 - 4 Beith JuniorsBeith ...
23 Sep 23 Musselburgh AthleticMusselburgh 1 - 1 Gretna 2008Gretna 2008 ...
23 Sep 23 Penicuik AthleticPenicuik 0 - 6 Pollok FCPollok FC ...
23 Sep 23 St Andrews UnitedAndrews 1 - 0 Auchinleck TalbotAuchinleck ...
23 Sep 23 TayportTayport 0 - 4 Buckie ThistleBuckie ...
23 Sep 23 Tranent Juniors FCTranent 4 - 1 Lothian HutchisonLothian ...
23 Sep 23 Turriff UnitedTurriff 2 - 1 Sauchie JuniorsSauchie ...
25 Sep 23 Stirling UniversityStirling 1 - 3 Albion RoversAlbion 2
23 Sep 23 Wick AcademyWick 1 - 3 Jeanfield SwiftsJeanfield ...
Ver jornada
Jornada 4
28 Oct 23 Albion RoversAlbion 2 - 1 St Andrews UnitedAndrews ...
28 Oct 23 Beith JuniorsBeith 1 - 3 Broomhill FCBroomhill ...
28 Oct 23 Brechin CityBrechin 1 - 2 SpartansSpartans ...
28 Oct 23 Civil Service StrollersCivil 0 - 3 StranraerStranraer ...
28 Oct 23 Cumnock Juniors FCCumnock 2 - 1 Turriff UnitedTurriff ...
28 Oct 23 DeveronvaleDeveronvale 0 - 1 Broxburn AthleticBroxburn ...
28 Oct 23 DumbartonDumbarton 3 - 2 Banks O' DeeBanks ...
28 Oct 23 Dunbar UnitedDunbar 1 - 0 East FifeEast Fife ...
28 Oct 23 Formartine UnitedFormartine 3 - 2 ClydebankClydebank ...
28 Oct 23 Forres MechanicsForres 0 - 1 Buckie ThistleBuckie ...
28 Oct 23 FraserburghFraserburgh 1 - 2 Bonnyrigg RoseBonnyrigg ...
28 Oct 23 HuntlyHuntly 1 - 4 Forfar AthleticForfar ...
28 Oct 23 Jeanfield SwiftsJeanfield 6 - 0 Elgin CityElgin City ...
28 Oct 23 Kilwinning Rangers FCKilwinning 0 - 1 CowdenbeathCowdenbeath ...
04 Nov 23 LuncartyLuncarty 0 - 1 Bo'ness UnitedBo'ness ...
30 Oct 23 Musselburgh AthleticMusselburgh 2 - 3 ClydeClyde 10
28 Oct 23 PeterheadPeterhead 3 - 1 ClachnacuddinClachnacudd ...
28 Oct 23 Pollok FCPollok FC 5 - 2 Gala Fairydean RoversGala ...
28 Oct 23 StenhousemuirStenhousemu 0 - 2 Brora RangersBrora ...
28 Oct 23 Tranent Juniors FCTranent 7 - 0 East KilbrideEast ...
Ver jornada
Jornada 5
25 Nov 23 Albion RoversAlbion 0 - 1 Bonnyrigg RoseBonnyrigg ...
25 Nov 23 Annan AthleticAnnan 4 - 5 DumbartonDumbarton ...
25 Nov 23 Brora RangersBrora 1 - 0 Pollok FCPollok FC ...
25 Nov 23 Broxburn AthleticBroxburn 2 - 2 Buckie ThistleBuckie ...
25 Nov 23 Cumnock Juniors FCCumnock 0 - 3 Broomhill FCBroomhill ...
25 Nov 23 Dunbar UnitedDunbar 1 - 2 Alloa AthleticAlloa ...
24 Nov 23 Dunfermline Athletic FCDunfermline 0 - 3 Raith RoversRaith 4
25 Nov 23 FalkirkFalkirk 3 - 0 Formartine UnitedFormartine ...
25 Nov 23 Hamilton AcademicalHamilton 0 - 2 Kelty HeartsKelty ...
25 Nov 23 Inverness CTInverness 2 - 0 CowdenbeathCowdenbeath ...
25 Nov 23 MontroseMontrose 3 - 0 Edinburgh CityEdinburgh ...
25 Nov 23 Partick ThistlePartick 3 - 0 Queen's ParkQueen's ...
25 Nov 23 PeterheadPeterhead 1 - 2 Ayr UnitedAyr United ...
25 Nov 23 Queen of the SouthQueen South 2 - 2 Dundee UnitedDundee ...
25 Nov 23 Stirling AlbionStirling 0 - 2 Cove RangersCove ...
25 Nov 23 StranraerStranraer 0 - 1 AirdrieoniansAirdrieonia ...
25 Nov 23 SpartansSpartans 2 - 1 ArbroathArbroath ...
25 Nov 23 Tranent Juniors FCTranent 0 - 1 Forfar AthleticForfar ...
24 Nov 23 ClydeClyde 2 - 0 Jeanfield SwiftsJeanfield 2
25 Nov 23 Greenock MortonGreenock 4 - 0 Bo'ness UnitedBo'ness ...
Ver jornada
Jornada 6
20 Ene 24 AirdrieoniansAirdrieonia 1 - 0 St. JohnstoneJohnstone ...
20 Ene 24 Ayr UnitedAyr United 3 - 0 Kelty HeartsKelty ...
20 Ene 24 Bonnyrigg RoseBonnyrigg 2 - 1 FalkirkFalkirk ...
30 Ene 24 Brora RangersBrora 1 - 3 Cove RangersCove 1
21 Ene 24 CelticCeltic 5 - 0 Buckie ThistleBuckie 9
19 Ene 24 ClydeClyde 0 - 2 AberdeenAberdeen 21
20 Ene 24 DumbartonDumbarton 1 - 4 Rangers FCRangers FC 5
20 Ene 24 Forfar AthleticForfar 0 - 1 Hibernian FCHibernian 3
20 Ene 24 Greenock MortonGreenock 2 - 0 MontroseMontrose ...
20 Ene 24 Inverness CTInverness 4 - 0 Broomhill FCBroomhill ...
20 Ene 24 KilmarnockKilmarnock 2 - 0 DundeeDundee ...
20 Ene 24 LivingstonLivingston 2 - 1 Raith RoversRaith ...
20 Ene 24 MotherwellMotherwell 3 - 1 Alloa AthleticAlloa ...
20 Ene 24 Ross County FCRoss County 0 - 3 Partick ThistlePartick ...
20 Ene 24 St. MirrenSt. Mirren 1 - 0 Queen of the SouthQueen South 1
20 Ene 24 SpartansSpartans 1 - 2 Heart of MidlothianHeart 24
Ver jornada
Jornada 7
10 Feb 24 AberdeenAberdeen 2 - 0 Bonnyrigg RoseBonnyrigg ...
11 Feb 24 AirdrieoniansAirdrieonia 1 - 4 Heart of MidlothianHeart 1
09 Feb 24 Greenock MortonGreenock 2 - 1 MotherwellMotherwell 1
10 Feb 24 Inverness CTInverness 1 - 3 Hibernian FCHibernian ...
10 Feb 24 Partick ThistlePartick 2 - 3 LivingstonLivingston ...
10 Feb 24 Rangers FCRangers FC 2 - 0 Ayr UnitedAyr United 13
11 Feb 24 St. MirrenSt. Mirren 0 - 2 CelticCeltic 13
10 Feb 24 KilmarnockKilmarnock 2 - 0 Cove RangersCove ...
Ver jornada
Jornada 8
09 Mar 24 AberdeenAberdeen 3 - 1 KilmarnockKilmarnock 4
10 Mar 24 CelticCeltic 4 - 2 LivingstonLivingston 38
11 Mar 24 Greenock MortonGreenock 0 - 1 Heart of MidlothianHeart 15
10 Mar 24 Hibernian FCHibernian 0 - 2 Rangers FCRangers FC 23
Ver jornada
Jornada 9
21 Abr 24 Rangers FCRangers FC 2 - 0 Heart of MidlothianHeart 10
20 Abr 24 AberdeenAberdeen 3 - 3 CelticCeltic 36
Ver jornada
Jornada 10
25 May 24 CelticCeltic
16:00
 		Rangers FCRangers FC ...

  USO DE MEMORIA  
5,162,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.3714
Total Execution Time  0.3747
  CADENA URL  
/copa_escocia2024/grupo0/calendario
  GET DATOS  
$_GET['/copa_escocia2024/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0125  SELECT type FROM routes WHERE alias = 'copa_escocia2024'
0.0255  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1500 ORDER BY order_id ASC
0.0137  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 73404 ORDER BY round ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 18:07: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-27 18:07: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=4 AND last_update > '2024-04-27 18:07: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-27 18:07:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1500 AND l.year = 2024
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (73404) 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.0128  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 (73404) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (899907,317598,427055,232883,242880,332565,365230,395280,409694,425060) ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1500 AND l.year = 2024
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (73404) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0130  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 (73404) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (13350,123667,160391,160423,160909,201829,206373,238010,279252,285745) ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1500 AND l.year = 2024
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (73404) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (73404) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (160423,201829,206373,235690,290795,298797,301366,333051,333469,342011) ORDER BY rp.in_squad = 1 DESC