4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Taradell Taradell 16 37 16 38
2 Sant Feliu de Codines Sant Feliu. 16 51 29 34
3 FC Pradenc FC Pradenc 16 31 18 34
4 Voltregà Voltregà 15 40 18 33
5 Centelles Centelles 15 33 25 26
6 Olímpic la Garriga Olímpic 16 22 20 25
7 JE Santa Eugènia Santa 16 39 36 24
8 Tona B Tona B 16 31 32 24
9 Manlleu B Manlleu B 16 26 25 20
10 Roda de Ter Roda de Ter 16 32 37 18
11 Moià Moià 16 27 34 18
12 Castellterçol Castellterç 16 33 42 18
13 Borgonyà Borgonyà 16 21 37 18
14 Seva Seva 16 25 36 16
15 Llorençà Llorençà 16 28 36 12
16 Sant Vicenç Torelló Sant Vicenç 16 23 37 12
17 Aiguafreda Aiguafreda 16 29 50 9
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 OAR Vic OAR Vic 23 47 13 52
2 UE Gurb UE Gurb 23 63 33 52
3 Pradenc Pradenc 23 48 23 48
4 Voltregà Voltregà 22 50 26 47
5 Taradell Taradell 23 51 38 46
6 Centelles Centelles 23 48 41 40
7 Olímpic la Garriga Olímpic 23 54 33 38
8 Manlleu B Manlleu B 23 47 35 37
9 Sant Feliu de Codines Sant Feliu. 23 50 50 34
10 Tona B Tona B 23 40 42 29
11 Castellterçol Castellterç 23 33 44 27
12 Borgonyà Borgonyà 23 43 43 26
13 Roda de Ter Roda de Ter 23 38 46 23
14 JE Santa Eugènia Santa 23 33 55 23
15 Llorençà Llorençà 23 39 60 22
16 UCF Santa Perpètua B Santa 23 38 51 17
17 L'Ametlla del Vallès L'Ametlla 23 30 72 11
18 Seva Seva 22 19 66 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 CF Torelló CF Torelló 34 88 37 82
2 Sant Julià Vilatorta Sant Julià 34 79 33 75
3 Voltregà Voltregà 34 87 44 74
4 Olímpic la Garriga Olímpic 34 69 41 63
5 UE Gurb UE Gurb 34 74 46 62
6 Taradell Taradell 34 79 56 56
7 Tona B Tona B 34 56 51 54
8 Manlleu B Manlleu B 34 89 72 53
9 OAR Vic OAR Vic 34 67 66 49
10 Borgonyà Borgonyà 34 60 65 46
11 Sant Feliu de Codines Sant Feliu. 34 68 68 42
12 Llorençà Llorençà 33 68 83 37
13 Castellterçol Castellterç 33 39 59 36
14 JE Santa Eugènia Santa 34 47 58 34
15 CF Folgueroles Folgueroles 34 43 57 34
16 Seva Seva 34 48 81 32
17 Moià Moià 33 43 88 14
18 Blaugrana Sant Cugat A Blaugrana 33 44 143 2
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Joanenc Joanenc 34 103 27 87
2 Roda de Ter Roda de Ter 34 78 48 74
3 Tona B Tona B 34 65 36 68
4 Olímpic la Garriga Olímpic 34 78 41 61
5 Sant Julià Vilatorta Sant Julià 34 73 42 60
6 Taradell Taradell 34 68 51 56
7 UE Vic B UE Vic B 34 69 57 55
8 UE Gurb UE Gurb 34 69 63 51
9 Borgonyà Borgonyà 34 64 52 51
10 Voltregà Voltregà 34 96 65 50
11 Sant Feliu de Codines Sant Feliu. 34 74 69 48
12 Manlleu B Manlleu B 34 66 63 47
13 Llerona Llerona 34 63 54 47
14 CF Torelló CF Torelló 34 65 67 46
15 Seva Seva 34 39 90 27
16 FC Pradenc FC Pradenc 34 36 88 24
17 Sant Vicenç Torelló Sant Vicenç 34 28 106 8
18 Atlètic Balenyà Atlètic 34 24 139 3
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 CF Folgueroles Folgueroles 34 93 42 73
2 OAR Vic OAR Vic 34 67 32 70
3 Sant Feliu de Codines Sant Feliu. 34 76 56 68
4 UE Gurb UE Gurb 34 69 51 61
5 Voltregà Voltregà 34 69 54 57
6 Olímpic la Garriga Olímpic 34 47 40 56
7 Llerona Llerona 34 64 52 52
8 Sant Julià Vilatorta Sant Julià 34 63 53 51
9 Sant Vicenç Torelló Sant Vicenç 34 46 56 42
10 CF Torelló CF Torelló 34 50 59 40
11 Moià Moià 34 49 51 40
12 FC Pradenc FC Pradenc 34 55 63 39
13 Taradell Taradell 34 36 55 39
14 Tona B Tona B 34 44 51 38
15 Borgonyà Borgonyà 34 62 70 37
16 Atlètic Balenyà Atlètic 34 42 63 37
17 FC Viladrau FC Viladrau 34 46 88 29
18 CE Avinyo CE Avinyo 34 48 90 27
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Roda de Ter Roda de Ter 34 78 34 71
2 CF Folgueroles Folgueroles 34 66 42 68
3 Sant Vicenç Torelló Sant Vicenç 34 55 35 66
4 OAR Vic OAR Vic 34 58 54 50
5 Llerona Llerona 34 69 67 48
6 Sant Feliu de Codines Sant Feliu. 34 69 68 46
7 FC Pradenc FC Pradenc 34 58 52 45
8 CF Torelló CF Torelló 34 49 51 44
9 Olímpic la Garriga Olímpic 34 45 47 43
10 UE Gurb UE Gurb 34 66 66 43
11 CE Avinyo CE Avinyo 34 52 73 43
12 Voltregà Voltregà 34 61 62 42
13 Atlètic Balenyà Atlètic 34 65 57 41
14 Taradell Taradell 34 49 57 41
15 Tona B Tona B 34 45 55 41
16 Moià Moià 34 45 41 40
17 Seva Seva 34 46 81 35
18 UE Vic B UE Vic B 34 46 80 31
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Vic Riuprimer Riuprimer 34 91 46 75
2 FC Pradenc FC Pradenc 34 105 55 74
3 OAR Vic OAR Vic 34 66 39 69
4 CE Avinyo CE Avinyo 34 69 43 63
5 Sant Vicenç Torelló Sant Vicenç 34 64 43 63
6 Roda de Ter Roda de Ter 34 61 47 61
7 Campdevanol UE Campdevanol 34 77 57 53
8 Tona B Tona B 34 62 54 51
9 Canovelles Canovelles 34 60 66 50
10 CF Torelló CF Torelló 34 54 48 49
11 Olímpic la Garriga Olímpic 34 40 44 45
12 Voltregà Voltregà 34 67 76 41
13 Moià Moià 34 48 61 35
14 Atlètic Balenyà Atlètic 34 57 77 35
15 Sant Feliu de Codines Sant Feliu. 34 58 80 34
16 Sant Bartomeu CF Sant 34 47 85 28
17 UE Santperenca Santperenca 34 33 97 19
18 JE Santa Eugènia Santa 34 43 84 17

  USO DE MEMORIA  
5,836,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0906
Total Execution Time  0.0925
  CADENA URL  
/tercera_catalana2021/grupo5/historico
  GET DATOS  
$_GET['/tercera_catalana2021/grupo5/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0017  SELECT type FROM routes WHERE alias = 'tercera_catalana2021'
0.0043  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_catalana' AND (l.group_code = 5 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=5 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=685 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 685 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (979937,978211,935979,930202,887509) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT id,name,alias,stepParent FROM categories WHERE parentId=685 ORDER BY order_id ASC
0.0021  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 685 GROUP BY l.categoryId
0.0021  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=685 GROUP BY l.year ORDER BY l.year DESC
0.0019  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 = 58789 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 685 AND group_code = 5 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0024  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 `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 = 58789 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2020` 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 = 50747 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2019` 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 = 44420 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 39003 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 34084 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 16686 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 3963 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 14:21:56' 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-06 14:21:56' 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-06 14:21:56' 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-06 14:21:56' 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 = 'tercera_catalana' 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.0019  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 = 58789 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58789 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.0019  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 = 58789 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58789 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 = 58789 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58789 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 = 58789 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC