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 Moja Moja 23 67 25 55
2 Òdena Òdena 23 71 24 53
3 Corbera Corbera 23 68 44 48
4 Piera Piera 23 70 36 47
5 Ribes Ribes 23 48 39 43
6 Montserrat Igualada Montserrat 23 52 43 38
7 Sitges B Sitges B 23 47 44 34
8 Begues Begues 23 39 36 33
9 Penya Jove Roquetes Penya Jove. 23 45 44 32
10 Les Cabanyes Cabanyes 23 36 40 32
11 Carme Carme 23 41 51 31
12 La Granada La Granada 23 42 43 29
13 Riudebitlles Riudebitlles 23 66 53 28
14 Masquefa Masquefa 23 35 42 24
15 At. Vilanova I La Geltru Vilanova 23 41 63 19
16 Ateneu Igualadí Ateneu 23 30 58 17
17 Anoia Anoia 23 38 73 16
18 La Múnia La Múnia 23 20 98 5
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Cubelles Cubelles 34 104 24 87
2 Olivella Olivella 34 101 42 81
3 Moja Moja 34 110 44 80
4 Òdena Òdena 34 93 54 74
5 Ribes Ribes 34 70 54 57
6 Riudebitlles Riudebitlles 34 97 80 57
7 Sitges Sitges 34 79 58 54
8 La Granada La Granada 34 79 62 53
9 Sant Andreu de la Barca B Sant Andreu 34 68 90 44
10 Montserrat Igualada Montserrat 34 77 73 40
11 Piera Piera 34 55 83 37
12 Masquefa Masquefa 34 57 79 36
13 La Múnia La Múnia 34 74 94 35
14 Penya Jove Roquetes Penya Jove. 34 60 101 34
15 Anoia Anoia 34 67 106 31
16 Capellades A Capellades 34 54 74 28
17 La Pobla Claramunt Pobla 34 71 104 24
18 Mediona A Mediona A 34 24 118 9
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 San Mauro San Mauro 34 139 39 91
2 Joventut Ribetana A Joventut 34 108 36 82
3 Sitges Sitges 34 81 29 80
4 Cubelles Cubelles 34 94 35 74
5 Moja Moja 34 98 48 66
6 Anoia Anoia 34 89 75 64
7 Òdena Òdena 34 87 68 53
8 Piera Piera 34 74 84 44
9 Riudebitlles Riudebitlles 34 59 80 42
10 La Múnia La Múnia 34 71 108 42
11 Montserrat Igualada Montserrat 34 74 78 39
12 Ribes Ribes 34 48 66 39
13 Mediona A Mediona A 34 66 98 38
14 Olivella Olivella 34 55 88 35
15 La Pobla Claramunt Pobla 34 55 102 28
16 Hortonenc A Hortonenc A 34 56 98 24
17 Sant Pere Molanta Sant Pere M. 34 55 104 22
18 Martinenca A Martinenca 34 39 112 16
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Begues Begues 34 92 32 86
2 Joventut Ribetana A Joventut 34 84 38 72
3 La Múnia La Múnia 34 84 46 71
4 Sitges Sitges 34 77 45 64
5 Piera Piera 34 76 58 55
6 Cubelles Cubelles 34 67 45 51
7 Òdena Òdena 34 60 49 50
8 Riudebitlles Riudebitlles 34 58 70 49
9 Martinenca A Martinenca 34 64 67 47
10 Hortonenc A Hortonenc A 34 75 72 46
11 Anoia Anoia 34 60 79 41
12 Calaf Calaf 34 66 80 39
13 Suburense B Suburense B 34 49 64 39
14 Olivella Olivella 34 52 80 35
15 Sant Pere Molanta Sant Pere M. 34 56 75 35
16 Carme Carme 34 60 85 35
17 Hostalets de Pierola A Hostalets 34 43 75 30
18 Sant Cugat Sesgarrigues Sant Cugat. 34 48 111 15
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Montserrat Igualada Montserrat 34 114 41 81
2 Martorell B Martorell B 34 107 31 79
3 Sitges Sitges 34 92 35 79
4 Calaf Calaf 34 94 50 74
5 Cubelles Cubelles 34 91 57 63
6 La Múnia La Múnia 34 85 58 58
7 Martinenca A Martinenca 34 74 62 55
8 Piera Piera 34 79 74 53
9 Les Roquetes Roquetes 34 70 72 46
10 Anoia Anoia 34 64 80 41
11 Olivella Olivella 34 56 75 38
12 Riudebitlles Riudebitlles 34 49 64 36
13 Carme Carme 34 64 96 36
14 Sant Pere Molanta Sant Pere M. 34 60 75 35
15 Sant Cugat Sesgarrigues Sant Cugat. 34 44 85 32
16 La Granada La Granada 34 49 86 28
17 Castellvi de la Marca A Castellvi 34 49 105 18
18 Fatima A Fatima A 34 35 130 15
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Òdena Òdena 34 113 48 84
2 At. Vilafranca Vilafranca 34 85 39 76
3 Piera Piera 34 87 59 65
4 Calaf Calaf 34 95 67 63
5 Montserrat Igualada Montserrat 34 63 47 61
6 Cubelles Cubelles 34 79 54 60
7 La Granada La Granada 34 85 52 59
8 Anoia Anoia 34 92 68 54
9 Riudebitlles Riudebitlles 34 69 73 41
10 Les Roquetes Roquetes 34 53 59 41
11 La Múnia La Múnia 34 58 92 40
12 Sitges Sitges 34 55 67 39
13 Sant Pere Molanta Sant Pere M. 34 65 55 38
14 Carme Carme 34 64 90 36
15 Sant Cugat Sesgarrigues Sant Cugat. 34 59 91 36
16 Ribes Ribes 34 48 76 31
17 Penya Jove Roquetes Penya Jove. 34 39 114 22
18 Base Espirall-Les Clotes Base 34 48 106 18

  USO DE MEMORIA  
5,726,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0843
Total Execution Time  0.0865
  CADENA URL  
/tercera_catalana2020/grupo12/historico
  GET DATOS  
$_GET['/tercera_catalana2020/grupo12/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0039  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 = 12 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=12 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=685 AND type_rel = 3
0.0020  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.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 (979937,978211,935979,930202,887509) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=685 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 = 50754 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 = 12 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 = 50754 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.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 `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 = 44427 AND t.round = 34 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 = 39010 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 `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 = 34091 AND t.round = 34 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 = 16690 AND t.round = 34 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 `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 = 3970 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-05 09:46:25' 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-05 09:46:25' 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-05 09:46:25' 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-05 09:46:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 = 50754 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50754 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.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 = 50754 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50754 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 events2020 e ON e.player_id = p.id AND e.league_id = 50754 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50754 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0050  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 = 50754 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