4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Berga B Berga B 20 68 15 50
2 Alt Berguedà Berguedà 20 78 24 46
3 Olvan CE Olvan CE 19 48 17 40
4 Montmajor Montmajor 19 33 26 35
5 Avia B Avia B 19 38 27 34
6 Casserres Casserres 18 26 22 30
7 Navas B Navas B 19 37 25 29
8 Puigcerda Puigcerda 19 51 52 28
9 Sant Salvador Cercs Sant 19 31 43 16
10 Valls de Torroella Valls 20 24 59 13
11 Sant Llorenç Morunys Sant 20 31 60 12
12 Monistrolenca Monistrolenc 19 23 64 10
13 Vilada Vilada 19 22 76 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Castellnou Castellnou 29 93 43 69
2 Navarcles Navarcles 29 105 41 67
3 Alt Berguedà Berguedà 28 82 45 53
4 Berga B Berga B 28 64 39 52
5 Montmajor Montmajor 27 48 36 48
6 Avia B Avia B 28 64 44 47
7 Olvan CE Olvan CE 28 57 49 42
8 CE Avinyo CE Avinyo 28 42 53 38
9 Navas B Navas B 29 63 71 35
10 Casserres Casserres 28 46 49 32
11 Balconada B Balconada B 29 41 61 30
12 Sant Salvador Cercs Sant 26 42 57 27
13 Sant Pau Manresa UE A Sant Manresa 28 50 75 26
14 Sant Llorenç Morunys Sant 27 55 79 20
15 Valls de Torroella Valls 27 18 109 8
16 Vilomara A Vilomara A 7 9 28 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Artes FC A Artes FC A 25 75 27 61
2 Castellnou Castellnou 25 84 35 54
3 Callus Callus 25 58 38 52
4 Calders Calders 23 66 29 44
5 Sallent B Sallent B 25 65 45 41
6 Olvan CE Olvan CE 23 41 36 37
7 Berga B Berga B 25 46 45 37
8 Alt Berguedà Berguedà 22 43 43 31
9 Montmajor Montmajor 23 35 39 29
10 Casserres Casserres 25 42 59 24
11 Monistrolenca Monistrolenc 22 44 53 22
12 Valls de Torroella Valls 24 31 61 18
13 Sant Llorenç Morunys Sant 21 28 80 14
14 Navas B Navas B 22 14 82 4
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Navàs Navàs 27 70 32 60
2 Artesa Lleida CF Artesa 27 58 27 54
3 Puigcerda Puigcerda 26 59 29 53
4 Monistrolenca Monistrolenc 28 67 46 51
5 Callus Callus 26 68 45 50
6 Calders Calders 28 50 44 49
7 Berga B Berga B 26 58 43 46
8 Sallent B Sallent B 26 56 50 41
9 Baganes Ccr A A Baganes 27 72 75 31
10 Sant Llorenç Morunys Sant 28 53 60 30
11 Montmajor Montmajor 28 37 52 28
12 Casserres Casserres 28 46 81 21
13 Minorisa Sagrada Font B B Minorisa 20 29 49 20
14 Gironella At. B Gironella 26 36 83 17
15 Valls de Torroella Valls 25 20 63 8
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Avia B Avia B 26 78 28 59
2 Sallent B Sallent B 26 80 47 58
3 Sant Salvador Cercs Sant 25 78 27 56
4 Calders Calders 26 66 36 47
5 Montmajor Montmajor 26 45 42 46
6 Casserres Casserres 26 38 53 36
7 Suria B Suria B 25 64 64 33
8 Puigcerda Puigcerda 25 58 46 32
9 Sant Llorenç Morunys Sant 26 57 69 31
10 Monistrolenca Monistrolenc 25 45 73 30
11 Puigreig B Puigreig B 26 51 69 25
12 Navarcles Navarcles 26 56 78 24
13 Vilada Vilada 26 48 101 22
14 Valls de Torroella Valls 26 39 70 16
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Pirinaica B Pirinaica B 28 83 21 74
2 Berga Berga 28 97 35 68
3 Puigcerda Puigcerda 28 81 48 56
4 Sant Salvador Cercs Sant 28 77 52 54
5 Avia B Avia B 28 71 51 48
6 Suria B Suria B 28 69 60 46
7 Sallent B Sallent B 28 56 52 41
8 Casserres Casserres 28 57 64 35
9 Valls de Torroella Valls 28 42 70 33
10 Puigreig B Puigreig B 28 45 67 30
11 Montmajor Montmajor 28 43 48 29
12 Navarcles Navarcles 28 58 74 28
13 Vilada Vilada 28 41 76 25
14 Navas B Navas B 28 28 74 17
15 Sant Llorenç Morunys Sant 28 46 102 16

  USO DE MEMORIA  
5,363,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0769
Total Execution Time  0.0787
  CADENA URL  
/cuarta_catalana2020/grupo1/historico
  GET DATOS  
$_GET['/cuarta_catalana2020/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0019  SELECT type FROM routes WHERE alias = 'cuarta_catalana2020'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_catalana' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 745 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0029  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 (1061049,983416,935979,861152,807251) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=745 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 = 51587 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 745 AND group_code = 1 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 51587 AND t.round = 21 ORDER BY team.conference ASC,t.position 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 `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 = 45618 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 39928 AND t.round = 26 ORDER BY team.conference 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 `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 = 16958 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 4731 AND t.round = 30 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-04-30 13:24:00' 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-04-30 13:24:00' 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-04-30 13:24:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 13:24:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_catalana' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2020 e ON e.player_id = p.id AND e.league_id = 51587 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51587 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 events2020 e ON e.player_id = p.id AND e.league_id = 51587 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51587 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events2020 e ON e.player_id = p.id AND e.league_id = 51587 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51587 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 `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 = 51587 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC