4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
09 Jul 21 Kelty HeartsKelty 0 - 1 Dundee UnitedDundee 15
09 Jul 21 Edinburgh CityEdinburgh 0 - 1 Hamilton AcademicalHamilton 3
10 Jul 21 Cove RangersCove 2 - 3 Stirling AlbionStirling 3
10 Jul 21 PeterheadPeterhead 0 - 2 Heart of MidlothianHeart 1
10 Jul 21 Elgin CityElgin City 0 - 1 ArbroathArbroath ...
10 Jul 21 Forfar AthleticForfar 3 - 0 Ross County FCRoss County ...
10 Jul 21 MontroseMontrose 3 - 0 Brora RangersBrora ...
10 Jul 21 Brechin CityBrechin 0 - 3 LivingstonLivingston 2
10 Jul 21 CowdenbeathCowdenbeath 0 - 1 Raith RoversRaith ...
10 Jul 21 Albion RoversAlbion 0 - 0 Ayr UnitedAyr United 2
Ver jornada
Jornada 2
10 Jul 21 AirdrieoniansAirdrieonia 1 - 1 Annan AthleticAnnan 1
10 Jul 21 Queen of the SouthQueen South 0 - 1 Queen's ParkQueen's ...
10 Jul 21 East KilbrideEast 0 - 2 KilmarnockKilmarnock ...
10 Jul 21 StranraerStranraer 3 - 0 Greenock MortonGreenock ...
10 Jul 21 DumbartonDumbarton 0 - 3 St. MirrenSt. Mirren ...
10 Jul 21 Partick ThistlePartick 2 - 4 Dunfermline Athletic FCDunfermline 1
13 Jul 21 ClydeClyde 1 - 0 StranraerStranraer 3
13 Jul 21 Greenock MortonGreenock 0 - 0 East KilbrideEast ...
13 Jul 21 Heart of MidlothianHeart 3 - 0 Cove RangersCove 1
13 Jul 21 Inverness CTInverness 2 - 0 PeterheadPeterhead 1
13 Jul 21 DundeeDundee 4 - 0 Brora RangersBrora 1
13 Jul 21 Forfar AthleticForfar 0 - 0 MontroseMontrose 2
13 Jul 21 Alloa AthleticAlloa 0 - 1 CowdenbeathCowdenbeath ...
13 Jul 21 Raith RoversRaith 4 - 0 Brechin CityBrechin ...
13 Jul 21 Ayr UnitedAyr United 3 - 0 Edinburgh CityEdinburgh ...
13 Jul 21 FalkirkFalkirk 5 - 1 Albion RoversAlbion 2
13 Jul 21 Annan AthleticAnnan 1 - 3 Queen of the SouthQueen South 1
13 Jul 21 DumbartonDumbarton 1 - 2 StenhousemuirStenhousemu ...
13 Jul 21 St. MirrenSt. Mirren 1 - 0 Dunfermline Athletic FCDunfermline 1
Ver jornada
Jornada 3
14 Jul 21 ArbroathArbroath 2 - 0 East FifeEast Fife 9
14 Jul 21 Dundee UnitedDundee 6 - 1 Elgin CityElgin City 13
14 Jul 21 Queen's ParkQueen's 0 - 1 MotherwellMotherwell 11
Ver jornada
Jornada 4
17 Jul 21 Inverness CTInverness 2 - 2 Stirling AlbionStirling ...
17 Jul 21 PeterheadPeterhead 3 - 1 Cove RangersCove 1
17 Jul 21 Dundee UnitedDundee 1 - 0 ArbroathArbroath ...
17 Jul 21 Kelty HeartsKelty 3 - 0 East FifeEast Fife ...
17 Jul 21 Brora RangersBrora 0 - 1 Forfar AthleticForfar 1
17 Jul 21 Alloa AthleticAlloa 2 - 1 LivingstonLivingston 1
17 Jul 21 CowdenbeathCowdenbeath 3 - 2 Brechin CityBrechin ...
17 Jul 21 Albion RoversAlbion 1 - 1 Edinburgh CityEdinburgh ...
17 Jul 21 FalkirkFalkirk 1 - 2 Hamilton AcademicalHamilton ...
17 Jul 21 MotherwellMotherwell 3 - 2 Queen of the SouthQueen South 1
17 Jul 21 Queen's ParkQueen's 0 - 0 AirdrieoniansAirdrieonia ...
17 Jul 21 ClydeClyde 1 - 2 KilmarnockKilmarnock ...
17 Jul 21 StranraerStranraer 1 - 0 East KilbrideEast ...
17 Jul 21 Dunfermline Athletic FCDunfermline 5 - 1 DumbartonDumbarton ...
17 Jul 21 StenhousemuirStenhousemu 1 - 2 Partick ThistlePartick ...
Ver jornada
Jornada 5
18 Jul 21 Ross County FCRoss County 0 - 3 DundeeDundee ...
20 Jul 21 StenhousemuirStenhousemu 1 - 3 St. MirrenSt. Mirren 8
20 Jul 21 Cove RangersCove 3 - 1 Inverness CTInverness ...
20 Jul 21 Stirling AlbionStirling 0 - 2 Heart of MidlothianHeart 5
20 Jul 21 East FifeEast Fife 0 - 1 Dundee UnitedDundee 3
20 Jul 21 Elgin CityElgin City 1 - 3 Kelty HeartsKelty 3
20 Jul 21 Brechin CityBrechin 1 - 0 Alloa AthleticAlloa 4
20 Jul 21 Hamilton AcademicalHamilton 0 - 1 Ayr UnitedAyr United 20
20 Jul 21 Annan AthleticAnnan 1 - 2 Queen's ParkQueen's ...
20 Jul 21 East KilbrideEast 2 - 2 ClydeClyde ...
20 Jul 21 KilmarnockKilmarnock 1 - 1 Greenock MortonGreenock 12
20 Jul 21 Partick ThistlePartick 2 - 0 DumbartonDumbarton 1
Ver jornada
Jornada 7
21 Jul 21 AirdrieoniansAirdrieonia 2 - 0 MotherwellMotherwell 2
21 Jul 21 Brora RangersBrora 0 - 1 Ross County FCRoss County ...
21 Jul 21 MontroseMontrose 0 - 2 DundeeDundee 1
21 Jul 21 LivingstonLivingston 0 - 0 Raith RoversRaith 5
21 Jul 21 Edinburgh CityEdinburgh 3 - 0 FalkirkFalkirk 1
24 Jul 21 Stirling AlbionStirling 3 - 1 PeterheadPeterhead ...
24 Jul 21 ArbroathArbroath 3 - 2 Kelty HeartsKelty ...
24 Jul 21 East FifeEast Fife 2 - 3 Elgin CityElgin City ...
24 Jul 21 DundeeDundee 5 - 2 Forfar AthleticForfar ...
24 Jul 21 Ross County FCRoss County 4 - 1 MontroseMontrose ...
24 Jul 21 LivingstonLivingston 3 - 1 CowdenbeathCowdenbeath ...
24 Jul 21 Raith RoversRaith 0 - 0 Alloa AthleticAlloa ...
24 Jul 21 Ayr UnitedAyr United 3 - 0 FalkirkFalkirk ...
24 Jul 21 Hamilton AcademicalHamilton 2 - 2 Albion RoversAlbion ...
24 Jul 21 MotherwellMotherwell 2 - 0 Annan AthleticAnnan ...
24 Jul 21 Queen of the SouthQueen South 4 - 1 AirdrieoniansAirdrieonia ...
24 Jul 21 KilmarnockKilmarnock 2 - 1 StranraerStranraer 1
24 Jul 21 Greenock MortonGreenock 2 - 1 ClydeClyde ...
24 Jul 21 Dunfermline Athletic FCDunfermline 4 - 1 StenhousemuirStenhousemu ...
Ver jornada
Jornada 8
25 Jul 21 St. MirrenSt. Mirren 2 - 0 Partick ThistlePartick ...
25 Jul 21 Heart of MidlothianHeart 1 - 0 Inverness CTInverness 4

Clasificación

Equipo PJ GF GC Puntos
1 Heart of Midlothian Heart 4 8 0 12
2 Stirling Albion Stirling 4 8 7 7
3 Inverness CT Inverness 4 5 6 4
4 Cove Rangers Cove Rangers 4 6 10 3
5 Peterhead Peterhead 4 4 8 3
6 Dundee United Dundee 4 9 1 12
7 Arbroath Arbroath 4 6 3 9
8 Kelty Hearts Kelty Hearts 4 8 5 6
9 Elgin City Elgin City 4 5 12 3
10 East Fife East Fife 4 2 9 0
11 Dundee Dundee 4 14 2 12
12 Forfar Athletic Forfar 4 6 5 7
13 Ross County FC Ross County 4 5 7 6
14 Montrose Montrose 4 4 6 4
15 Brora Rangers Brora 4 0 9 0
16 Raith Rovers Raith Rovers 4 5 0 8
17 Livingston Livingston 4 7 3 7
18 Cowdenbeath Cowdenbeath 4 5 6 6
19 Alloa Athletic Alloa 4 2 3 4
20 Brechin City Brechin City 4 3 10 3
21 Ayr United Ayr United 4 7 0 10
22 Hamilton Academical Hamilton 4 5 4 7
23 Edinburgh City Edinburgh 4 4 5 4
24 Falkirk Falkirk 4 6 9 3
25 Albion Rovers Albion 4 4 8 3
26 Motherwell Motherwell 4 6 4 9
27 Queen's Park Queen's Park 4 3 2 7
28 Queen of the South Queen South 4 9 6 6
29 Airdrieonians Airdrieonian 4 4 5 5
30 Annan Athletic Annan 4 3 8 1
31 Kilmarnock Kilmarnock 4 7 3 10
32 Stranraer Stranraer 4 5 3 6
33 Greenock Morton Greenock 4 3 5 5
34 Clyde Clyde 4 5 6 4
35 East Kilbride East 4 2 5 2
36 St. Mirren St. Mirren 4 9 1 12
37 Dunfermline Athletic FC Dunfermline 4 13 5 9
38 Partick Thistle Partick 4 6 7 6
39 Stenhousemuir Stenhousemui 4 5 10 3
40 Dumbarton Dumbarton 4 2 12 0

  USO DE MEMORIA  
6,368,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5009
Total Execution Time  0.5029
  CADENA URL  
/copa_liga_escocia2022/grupo1/calendario
  GET DATOS  
$_GET['/copa_liga_escocia2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0144  SELECT type FROM routes WHERE alias = 'copa_liga_escocia2022'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_liga_escocia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1499 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1499 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (1233000,1046612,1031286,758465,670976) ORDER BY n.cover_points DESC, update_date DESC
0.0148  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1499 ORDER BY order_id ASC
0.0147  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 = 62930 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 62930 ORDER BY round ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 21:26:54' 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-26 21:26:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 21:26:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 21:26:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_liga_escocia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0157  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1499 AND l.year = 2022
0.0149  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62930,63468) 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.0151  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 (62930,63468) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (299670,160332,161028,201792,331893,66428,93942,160716,192455,201858) ORDER BY rp.in_squad = 1 DESC
0.0158  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1499 AND l.year = 2022
0.0150  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62930,63468) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0152  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 (62930,63468) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (294787,297304,13136,30134,47279,160207,160233,160240,160636,160832) ORDER BY rp.in_squad = 1 DESC
0.0157  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1499 AND l.year = 2022
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62930,63468) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0147  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 (62930,63468) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2726,141806,141923,141980,238010,295606) ORDER BY rp.in_squad = 1 DESC
0.0164  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 62930 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC