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 S. Cristóbal B Cristóbal 21 79 27 50
2 Pueblo Nuevo 2002 Pueblo Nuevo 21 64 32 48
3 Les Fonts A Les Fonts A 20 58 28 48
4 Jabac I Terrassa Jabac 21 71 22 47
5 Fundació Terrassa 1906 A Fundació 20 42 23 41
6 Escola Viladecavalls A Escola 20 49 29 39
7 Juventud 25 de Septiembre B Juventud 21 48 34 36
8 Can Parellada B Parellada 21 53 41 34
9 Maurina Egara A Maurina 20 44 34 32
10 Escola Pia Terrassa Escola 21 53 37 27
11 Pª Blaugrana Sant Cugat B Blaugrana 21 57 45 25
12 Can Boada Can Boada 21 31 69 16
13 Escuela F. Bonaire A Escuela 21 24 45 13
14 Vacarisses CE Vacarisses 21 19 63 6
15 Ullastrell CF Ullastrell 20 27 117 6
16 Can Trias B Can Trias B 20 28 101 3
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Tintoreria Pau Tintoreria 29 116 32 72
2 MBD Lions MBD Lions 26 79 26 64
3 Fundacio Hospitalet A Fundacio 27 75 35 59
4 Valldoreix C Valldoreix 28 87 50 52
5 La Salle Bonanova Salle 27 72 51 48
6 Vallvidrera Senglars B Vallvidrera 29 59 42 46
7 Sant Ignasi B Sant Ignasi 27 62 55 39
8 Gp3 Futbol Club A A Futbol Club 26 56 57 37
9 Guinardo A Guinardo A 24 32 43 33
10 Congrés Club Esportiu A Congrés 27 67 72 29
11 Sant Genis-Penitentes B Sant 25 53 69 29
12 Atlanta-El Raval A Atlanta-El 26 45 75 27
13 Catalonia A Catalonia A 26 36 82 18
14 Sistrells A Sistrells A 20 38 75 16
15 Can Clota - La Plana C Clota Plana 26 19 106 4
16 Atletic La Palma Atletic 7 6 32 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Pª Blaugrana Sant Cugat A Pª 28 92 39 64
2 Sant Quirze Valles B Sant Quirze 28 71 40 61
3 Matadepera B Matadepera 27 89 53 59
4 Polinya At. Polinya At. 27 66 28 58
5 Maurina Egara A Maurina 27 71 51 54
6 Valles FC A Valles FC A 25 57 48 40
7 Can Boada B Can Boada B 28 52 48 40
8 Olimpic Can Fatjo B Olimpic 26 62 52 39
9 Can Colapi de Terrassa A Colapi 27 63 61 39
10 San Lorenzo B Lorenzo 28 57 53 35
11 Les Fonts A Les Fonts A 28 69 72 34
12 Rubí B Rubí B 27 52 71 32
13 Escuela Bonaire B B Escuela 28 55 82 19
14 PB Ramon Llorens Ramon 25 23 89 6
15 Ullastrell CF Ullastrell 27 20 112 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Cerdanyola del Valles B Cerdanyola 28 79 27 65
2 Sant Cugat Esport B B Sant Cugat. 26 84 24 61
3 Rubí B Rubí B 27 62 28 60
4 Pª Blaugrana Sant Cugat A Pª 28 91 43 53
5 Olimpic Can Fatjo B Olimpic 27 77 44 52
6 Maurina Egara A Maurina 28 97 72 49
7 Can Colapi de Terrassa A Colapi 28 68 65 47
8 Sant Quirze Valles B Sant Quirze 27 48 53 43
9 Can Trias B Can Trias B 28 76 60 40
10 Can Boada B Can Boada B 27 46 49 31
11 Les Fonts A Les Fonts A 28 44 76 30
12 Escuela Bonaire B B Escuela 27 47 69 29
13 Sant Pere Nord B Sant Pere N. 27 40 85 14
14 Valldoreix C C Valldoreix 28 28 117 10
15 PB Ramon Llorens Ramon 26 21 96 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Escuela F. Bonaire A Escuela 24 89 30 59
2 Bellaterra A Bellaterra 24 61 36 51
3 Can Colapi de Terrassa A Colapi 24 63 39 49
4 Blaugrana Sant Cugat A Blaugrana 24 73 42 48
5 Maurina Egara A Maurina 24 67 46 45
6 Can Boada Can Boada 24 63 50 36
7 Rubí B Rubí B 24 68 61 35
8 Olimpic Can Fatjo B Olimpic 24 53 56 32
9 Ullastrell CF Ullastrell 24 57 66 28
10 Les Fonts A Les Fonts A 24 52 58 28
11 Escola Viladecavalls A Escola 24 51 82 21
12 Sant Pere Nord B Sant Pere N. 24 42 95 11
13 Valldoreix C Valldoreix 24 29 107 5
14 Per L'amistad L'amistad 0 0 0 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Martorell B Martorell B 27 102 30 75
2 Abrera Abrera 28 86 37 61
3 Esparreguera Athletic Club Esparreguera 28 85 55 53
4 Corbera B Corbera B 28 66 50 47
5 Sant Vicenç Vicenti A Sant Vicenç 27 62 47 46
6 PB Sant Vicenç H. Sant Vicenç 28 71 56 44
7 Sant Esteve Sesrovires B Sant Esteve 28 66 62 43
8 San Pancracio A Pancracio 28 44 58 37
9 Sant Andreu de la Barca B Sant Andreu 28 61 60 36
10 Incresa B Incresa B 28 57 64 36
11 Casablanca A Casablanca 27 64 84 31
12 Cervello B Cervello B 28 42 71 25
13 Piera B Piera B 27 39 64 23
14 Blanc Blava Sant Feliu A Blanc Blava 28 60 108 17
15 Sant Feliu Llobregat B Sant Feliu. 28 36 95 13

  USO DE MEMORIA  
5,502,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.0976
Total Execution Time  0.1006
  CADENA URL  
/cuarta_catalana2020/grupo13/historico
  GET DATOS  
$_GET['/cuarta_catalana2020/grupo13/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'cuarta_catalana2020'
0.0041  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 = 13 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=13 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=745 AND type_rel = 3
0.0020  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.0039  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.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=745 ORDER BY order_id ASC
0.0024  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 = 51611 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 745 AND group_code = 13 and tables = 1 AND year <= 2020 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 `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 = 51611 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.0025  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 = 45629 AND t.round = 30 ORDER BY team.conference 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 `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 = 39940 AND t.round = 30 ORDER BY team.conference 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 `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 = 36078 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 17049 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 4743 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 08:36:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 08:36:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 08:36:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 08:36:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  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.0024  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 = 51611 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51611 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.0025  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 = 51611 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51611 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025  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 = 51611 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51611 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0085  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 = 51611 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