4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
17 Oct 20 Albion RoversAlbion 1 - 3 StenhousemuirStenhousemu ...
17 Oct 20 Brechin CityBrechin 1 - 5 Edinburgh CityEdinburgh ...
17 Oct 20 CowdenbeathCowdenbeath 0 - 3 Annan AthleticAnnan ...
17 Oct 20 Stirling AlbionStirling 0 - 0 Queen's ParkQueen's ...
17 Oct 20 StranraerStranraer 1 - 4 Elgin CityElgin City ...
Ver jornada
Jornada 2
24 Oct 20 Annan AthleticAnnan 1 - 1 StranraerStranraer ...
24 Oct 20 Edinburgh CityEdinburgh 0 - 1 CowdenbeathCowdenbeath ...
24 Oct 20 Elgin CityElgin City 3 - 0 Brechin CityBrechin ...
24 Oct 20 Queen's ParkQueen's 2 - 0 Albion RoversAlbion ...
24 Oct 20 StenhousemuirStenhousemu 2 - 2 Stirling AlbionStirling ...
Ver jornada
Jornada 3
31 Oct 20 Albion RoversAlbion 0 - 2 Brechin CityBrechin ...
31 Oct 20 CowdenbeathCowdenbeath 1 - 1 StenhousemuirStenhousemu ...
31 Oct 20 Edinburgh CityEdinburgh 1 - 0 Elgin CityElgin City ...
31 Oct 20 Stirling AlbionStirling 1 - 0 Annan AthleticAnnan ...
31 Oct 20 StranraerStranraer 0 - 1 Queen's ParkQueen's ...
Ver jornada
Jornada 4
07 Nov 20 Annan AthleticAnnan 2 - 3 Albion RoversAlbion ...
07 Nov 20 Brechin CityBrechin 0 - 5 Stirling AlbionStirling ...
07 Nov 20 Elgin CityElgin City 0 - 1 Queen's ParkQueen's ...
07 Nov 20 StenhousemuirStenhousemu 2 - 0 Edinburgh CityEdinburgh ...
07 Nov 20 StranraerStranraer 2 - 0 CowdenbeathCowdenbeath ...
Ver jornada
Jornada 5
03 Abr 21 CowdenbeathCowdenbeath 0 - 1 Albion RoversAlbion ...
21 Nov 20 Edinburgh CityEdinburgh 0 - 1 StranraerStranraer ...
21 Nov 20 Queen's ParkQueen's 3 - 0 Brechin CityBrechin ...
21 Nov 20 StenhousemuirStenhousemu 1 - 2 Annan AthleticAnnan ...
21 Nov 20 Stirling AlbionStirling 1 - 2 Elgin CityElgin City ...
Ver jornada
Jornada 6
28 Nov 20 Albion RoversAlbion 0 - 1 Stirling AlbionStirling ...
28 Nov 20 Annan AthleticAnnan 0 - 4 Edinburgh CityEdinburgh ...
28 Nov 20 Brechin CityBrechin 1 - 4 StranraerStranraer ...
28 Nov 20 Elgin CityElgin City 5 - 2 CowdenbeathCowdenbeath ...
28 Nov 20 Queen's ParkQueen's 3 - 1 StenhousemuirStenhousemu ...
Ver jornada
Jornada 7
05 Dic 20 CowdenbeathCowdenbeath 0 - 3 Queen's ParkQueen's ...
05 Dic 20 Edinburgh CityEdinburgh 5 - 2 Albion RoversAlbion ...
05 Dic 20 Elgin CityElgin City 1 - 0 Annan AthleticAnnan ...
05 Dic 20 StenhousemuirStenhousemu 2 - 1 Brechin CityBrechin ...
05 Dic 20 StranraerStranraer 2 - 2 Stirling AlbionStirling ...
Ver jornada
Jornada 8
12 Dic 20 Albion RoversAlbion 3 - 1 Elgin CityElgin City ...
22 Dic 20 Brechin CityBrechin 0 - 0 Annan AthleticAnnan ...
12 Dic 20 Queen's ParkQueen's 3 - 3 Edinburgh CityEdinburgh ...
12 Dic 20 StenhousemuirStenhousemu 2 - 2 StranraerStranraer ...
12 Dic 20 Stirling AlbionStirling 1 - 0 CowdenbeathCowdenbeath ...
Ver jornada
Jornada 9
19 Dic 20 Annan AthleticAnnan 1 - 2 Queen's ParkQueen's ...
19 Dic 20 CowdenbeathCowdenbeath 2 - 0 Brechin CityBrechin ...
19 Dic 20 Edinburgh CityEdinburgh 2 - 3 Stirling AlbionStirling ...
19 Dic 20 Elgin CityElgin City 2 - 0 StenhousemuirStenhousemu ...
19 Dic 20 StranraerStranraer 4 - 0 Albion RoversAlbion ...
Ver jornada
Jornada 10
30 Mar 21 Albion RoversAlbion 0 - 3 Queen's ParkQueen's 2
30 Mar 21 Brechin CityBrechin 1 - 2 Elgin CityElgin City 2
30 Mar 21 CowdenbeathCowdenbeath 1 - 3 Edinburgh CityEdinburgh 1
30 Mar 21 Stirling AlbionStirling 1 - 0 StenhousemuirStenhousemu ...
02 Ene 21 StranraerStranraer 2 - 0 Annan AthleticAnnan ...
Ver jornada
Jornada 11
20 Mar 21 Annan AthleticAnnan 0 - 0 CowdenbeathCowdenbeath ...
20 Mar 21 Elgin CityElgin City 1 - 2 Edinburgh CityEdinburgh ...
20 Mar 21 Queen's ParkQueen's 3 - 0 StranraerStranraer ...
20 Mar 21 StenhousemuirStenhousemu 2 - 0 Albion RoversAlbion ...
20 Mar 21 Stirling AlbionStirling 1 - 0 Brechin CityBrechin ...
Ver jornada
Jornada 12
27 Mar 21 Albion RoversAlbion 1 - 1 Annan AthleticAnnan 2
27 Mar 21 Brechin CityBrechin 0 - 2 Queen's ParkQueen's ...
27 Mar 21 CowdenbeathCowdenbeath 1 - 1 StranraerStranraer ...
27 Mar 21 Edinburgh CityEdinburgh 3 - 1 StenhousemuirStenhousemu ...
27 Mar 21 Elgin CityElgin City 1 - 1 Stirling AlbionStirling ...
Ver jornada
Jornada 13
23 Mar 21 Albion RoversAlbion 1 - 2 Edinburgh CityEdinburgh ...
03 Abr 21 Annan AthleticAnnan 0 - 3 Elgin CityElgin City ...
03 Abr 21 Queen's ParkQueen's 1 - 0 Stirling AlbionStirling ...
08 Abr 21 StenhousemuirStenhousemu 1 - 0 CowdenbeathCowdenbeath 4
23 Mar 21 StranraerStranraer 2 - 0 Brechin CityBrechin 5
Ver jornada
Jornada 14
06 Abr 21 Brechin CityBrechin 1 - 1 StenhousemuirStenhousemu ...
06 Abr 21 Edinburgh CityEdinburgh 1 - 1 Annan AthleticAnnan 7
06 Abr 21 Elgin CityElgin City 2 - 1 StranraerStranraer ...
06 Abr 21 Queen's ParkQueen's 3 - 0 CowdenbeathCowdenbeath ...
06 Abr 21 Stirling AlbionStirling 1 - 1 Albion RoversAlbion 4
Ver jornada
Jornada 15
10 Abr 21 Annan AthleticAnnan 1 - 2 Stirling AlbionStirling ...
10 Abr 21 Brechin CityBrechin 2 - 4 Albion RoversAlbion ...
10 Abr 21 CowdenbeathCowdenbeath 1 - 0 Elgin CityElgin City ...
10 Abr 21 StenhousemuirStenhousemu 1 - 3 Queen's ParkQueen's ...
10 Abr 21 StranraerStranraer 0 - 1 Edinburgh CityEdinburgh ...
Ver jornada
Jornada 16
13 Abr 21 Albion RoversAlbion 0 - 0 CowdenbeathCowdenbeath ...
13 Abr 21 Edinburgh CityEdinburgh 2 - 1 Brechin CityBrechin 2
13 Abr 21 Queen's ParkQueen's 1 - 0 Annan AthleticAnnan ...
13 Abr 21 StenhousemuirStenhousemu 2 - 0 Elgin CityElgin City ...
13 Abr 21 Stirling AlbionStirling 0 - 1 StranraerStranraer ...
Ver jornada
Jornada 17
17 Abr 21 Annan AthleticAnnan 3 - 0 Brechin CityBrechin ...
17 Abr 21 CowdenbeathCowdenbeath 1 - 5 Stirling AlbionStirling ...
17 Abr 21 Edinburgh CityEdinburgh 2 - 3 Queen's ParkQueen's ...
17 Abr 21 Elgin CityElgin City 2 - 5 Albion RoversAlbion ...
15 Abr 21 StranraerStranraer 4 - 0 StenhousemuirStenhousemu 2
Ver jornada
Jornada 18
20 Abr 21 Albion RoversAlbion 0 - 2 StranraerStranraer ...
20 Abr 21 Annan AthleticAnnan 5 - 1 StenhousemuirStenhousemu ...
20 Abr 21 Brechin CityBrechin 0 - 0 CowdenbeathCowdenbeath ...
20 Abr 21 Queen's ParkQueen's 0 - 0 Elgin CityElgin City 2
20 Abr 21 Stirling AlbionStirling 0 - 1 Edinburgh CityEdinburgh ...
Ver jornada
Jornada 19
13 Mar 21 Edinburgh CityEdinburgh Apl Albion RoversAlbion ...
13 Mar 21 Elgin CityElgin City Apl Annan AthleticAnnan ...
13 Mar 21 Queen's ParkQueen's Apl Brechin CityBrechin ...
02 Ene 21 StenhousemuirStenhousemu Apl Stirling AlbionStirling ...
13 Mar 21 StranraerStranraer Apl CowdenbeathCowdenbeath ...
Ver jornada
Jornada 20
20 Mar 21 Annan AthleticAnnan Apl Albion RoversAlbion ...
20 Mar 21 Brechin CityBrechin Apl StranraerStranraer ...
20 Mar 21 CowdenbeathCowdenbeath Apl StenhousemuirStenhousemu ...
20 Mar 21 Edinburgh CityEdinburgh Apl Elgin CityElgin City ...
20 Mar 21 Stirling AlbionStirling Apl Queen's ParkQueen's ...
Ver jornada
Jornada 21
27 Mar 21 Albion RoversAlbion Apl Brechin CityBrechin ...
27 Mar 21 Elgin CityElgin City Apl CowdenbeathCowdenbeath ...
27 Mar 21 StenhousemuirStenhousemu Apl Edinburgh CityEdinburgh ...
27 Mar 21 Stirling AlbionStirling Apl Annan AthleticAnnan ...
27 Mar 21 StranraerStranraer Apl Queen's ParkQueen's ...
Ver jornada
Jornada 22
03 Abr 21 Brechin CityBrechin Apl Stirling AlbionStirling ...
03 Abr 21 CowdenbeathCowdenbeath Apl Annan AthleticAnnan ...
03 Abr 21 Edinburgh CityEdinburgh Apl StranraerStranraer ...
03 Abr 21 Elgin CityElgin City Apl StenhousemuirStenhousemu ...
03 Abr 21 Queen's ParkQueen's Apl Albion RoversAlbion ...
Ver jornada
Jornada 23
10 Abr 21 Albion RoversAlbion Apl Stirling AlbionStirling ...
10 Abr 21 Annan AthleticAnnan Apl Edinburgh CityEdinburgh ...
10 Abr 21 CowdenbeathCowdenbeath Apl Queen's ParkQueen's ...
10 Abr 21 StenhousemuirStenhousemu Apl Brechin CityBrechin ...
10 Abr 21 StranraerStranraer Apl Elgin CityElgin City ...
Ver jornada
Jornada 24
17 Abr 21 Albion RoversAlbion Apl Elgin CityElgin City ...
17 Abr 21 Annan AthleticAnnan Apl StranraerStranraer ...
17 Abr 21 Brechin CityBrechin Apl Edinburgh CityEdinburgh ...
17 Abr 21 Queen's ParkQueen's Apl StenhousemuirStenhousemu ...
17 Abr 21 Stirling AlbionStirling Apl CowdenbeathCowdenbeath ...
Ver jornada
Jornada 25
20 Abr 21 StenhousemuirStenhousemu Apl Annan AthleticAnnan ...
20 Abr 21 StranraerStranraer Apl Albion RoversAlbion ...
20 Abr 21 CowdenbeathCowdenbeath Apl Brechin CityBrechin ...
20 Abr 21 Edinburgh CityEdinburgh Apl Stirling AlbionStirling ...
20 Abr 21 Elgin CityElgin City Apl Queen's ParkQueen's ...
Ver jornada
Jornada 26
24 Abr 21 Brechin CityBrechin Apl Annan AthleticAnnan ...
24 Abr 21 CowdenbeathCowdenbeath Apl Albion RoversAlbion ...
24 Abr 21 Queen's ParkQueen's Apl Edinburgh CityEdinburgh ...
24 Abr 21 StenhousemuirStenhousemu Apl StranraerStranraer ...
24 Abr 21 Stirling AlbionStirling Apl Elgin CityElgin City ...
Ver jornada
Jornada 27
01 May 21 Albion RoversAlbion Apl StenhousemuirStenhousemu ...
01 May 21 Annan AthleticAnnan Apl Queen's ParkQueen's ...
01 May 21 Edinburgh CityEdinburgh Apl CowdenbeathCowdenbeath ...
01 May 21 Elgin CityElgin City Apl Brechin CityBrechin ...
01 May 21 StranraerStranraer Apl Stirling AlbionStirling ...

Clasificación

Equipo PJ GF GC Puntos
1 Queen's Park Queen's Park 16 34 6 44
2 Edinburgh City Edinburgh 16 34 19 32
3 Stirling Albion Stirling 16 22 13 29
4 Elgin City Elgin City 16 27 17 28
5 Stranraer Stranraer 16 24 18 25
6 Stenhousemuir Stenhousemui 16 22 22 22
7 Albion Rovers Albion 16 17 31 15
8 Cowdenbeath Cowdenbeath 16 9 24 13
9 Annan Athletic Annan 16 12 23 11
10 Brechin City Brechin City 16 10 38 5

  USO DE MEMORIA  
5,711,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1320
Total Execution Time  0.1341
  CADENA URL  
/third_division2021/grupo1/calendario
  GET DATOS  
$_GET['/third_division2021/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'third_division2021'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'third_division' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=105 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 105 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (993054,986341,823337,822097,808283) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=105 ORDER BY order_id ASC
0.0020  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 = 57748 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 calendars2021 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 57748 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 23:14:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 23:14:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 23:14:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 23:14:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'third_division' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0078  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 events2021 e ON e.player_id = p.id AND e.league_id = 57748 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57748 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.0082  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 events2021 e ON e.player_id = p.id AND e.league_id = 57748 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57748 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0026  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 events2021 e ON e.player_id = p.id AND e.league_id = 57748 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57748 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 57748 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC