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 Sant Cugat Sant Cugat 23 41 21 46
2 At. Prat Delta Prat Delta 23 51 33 46
3 Unificació Bellvitge Unificació 23 41 29 45
4 Sitges Sitges 23 49 39 44
5 Molins de Rei Molins 23 30 36 38
6 Sant Andreu de la Barca Sant Andreu 23 38 25 37
7 Valldoreix Valldoreix 23 41 37 36
8 Almeda Almeda 23 30 28 33
9 Marianao Poblet Marianao 23 39 37 32
10 Atlètic Junior FC Atlètic 23 46 37 29
11 Cubelles Cubelles 23 35 40 28
12 At. Vilafranca Vilafranca 23 43 40 27
13 Olivella Olivella 23 37 46 27
14 Fontsanta Fatjo Fontsanta 23 28 42 27
15 Can Buxeres Can Buxeres 23 28 41 23
16 Espluguenc Espluguenc 23 23 32 22
17 Sant Joan Despi UE Sant Joan D. 23 18 42 18
18 San Mauro San Mauro 23 38 51 16
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 At. Sant Just Sant Just 34 76 33 78
2 Martorell Martorell 34 60 26 68
3 Joventut Ribetana A Joventut 34 70 53 59
4 Can Trias Can Trias 34 56 37 58
5 At. Vilafranca Vilafranca 34 60 48 54
6 Unificació Bellvitge Unificació 34 47 46 54
7 Atlètic Junior FC Atlètic 34 84 66 53
8 Sant Quirze Valles Sant Quirze 34 57 48 52
9 Fontsanta Fatjo Fontsanta 34 51 54 48
10 Espluguenc Espluguenc 34 44 49 46
11 San Mauro San Mauro 34 57 67 45
12 Molins de Rei Molins 34 58 48 44
13 Marianao Poblet Marianao 34 52 62 43
14 At. Prat Delta Prat Delta 34 51 63 39
15 Prat B Prat B 34 48 64 37
16 PUD Málaga PUD Málaga 34 48 77 32
17 Olímpic Can Fatjó Olímpic 34 43 59 27
18 Begues Begues 34 28 90 12
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Vilanova Geltru CF Vilanova 34 75 41 72
2 Rubí Rubí 34 61 37 63
3 Begues Begues 34 57 40 63
4 Sant Quirze Valles Sant Quirze 34 59 44 59
5 Can Trias Can Trias 34 67 54 55
6 Fontsanta Fatjo Fontsanta 34 58 53 54
7 Prat B Prat B 34 48 48 53
8 At. Sant Just Sant Just 34 64 50 52
9 At. Vilafranca Vilafranca 34 62 57 50
10 Olímpic Can Fatjó Olímpic 34 36 36 48
11 Espluguenc Espluguenc 34 50 50 46
12 At. Prat Delta Prat Delta 34 52 42 44
13 Marianao Poblet Marianao 34 49 43 44
14 Molins de Rei Molins 34 53 62 43
15 Junior Junior 34 67 71 42
16 Suburense Suburense 34 45 58 38
17 Sant Joan Despi UE Sant Joan D. 34 50 90 23
18 Gornal Gornal 34 27 104 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Can Vidalet Can Vidalet 34 84 35 76
2 Unificació Bellvitge Unificació 34 67 20 71
3 Sant Joan Despi UE Sant Joan D. 34 82 48 63
4 Espluguenc Espluguenc 34 57 53 55
5 Fontsanta-Fatjo Fem Fontsanta-Fa 34 62 49 53
6 At. Sant Just Sant Just 34 87 76 51
7 Olímpic Can Fatjó Olímpic 34 59 53 50
8 Marianao Poblet Marianao 34 46 44 50
9 Junior Junior 34 51 56 48
10 Gornal Gornal 34 57 67 48
11 At. Prat Delta Prat Delta 34 52 52 47
12 At. Vilafranca Vilafranca 34 44 55 47
13 Martorell Martorell 34 61 64 43
14 Montserrat Igualada Montserrat 34 56 62 42
15 San Mauro San Mauro 34 47 64 35
16 Dinamic Batllo Esportiu Dinamic 34 44 81 30
17 Ciudad Cooperativa Ciudad 34 44 75 22
18 Moja Moja 34 46 92 22
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sant Cugat Sant Cugat 34 67 36 65
2 Espluguenc Espluguenc 34 58 49 60
3 Sant Joan Despi UE Sant Joan D. 34 58 44 59
4 Can Vidalet Can Vidalet 34 62 49 58
5 Junior Junior 34 54 42 56
6 Olímpic Can Fatjó Olímpic 34 58 45 55
7 Moja Moja 34 71 55 54
8 Gornal Gornal 34 58 54 50
9 Marianao Poblet Marianao 34 38 35 45
10 At. Vilafranca Vilafranca 34 44 50 43
11 Unificació Bellvitge Unificació 34 41 43 43
12 San Mauro San Mauro 34 43 48 43
13 Fontsanta-Fatjo Fem Fontsanta-Fa 34 47 57 42
14 Begues Begues 34 44 57 40
15 Prat B Prat B 34 53 61 38
16 Òdena Òdena 34 48 74 34
17 Vallirana Vallirana 34 36 52 34
18 Torrelles Torrelles 34 32 61 25
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Suburense Suburense 34 82 39 72
2 Vista Alegre Vista Alegre 34 71 41 69
3 Can Vidalet Can Vidalet 34 70 44 66
4 Unificació Bellvitge Unificació 34 58 32 66
5 Marianao Poblet Marianao 34 46 43 55
6 Gornal Gornal 34 64 45 54
7 San Mauro San Mauro 34 44 42 48
8 Begues Begues 34 52 52 45
9 Sant Joan Despi UE Sant Joan D. 34 44 46 45
10 Sant Cugat Sant Cugat 34 39 39 44
11 Prat B Prat B 34 37 48 42
12 Moja Moja 34 63 65 41
13 Junior Junior 34 50 51 40
14 Espluguenc Espluguenc 34 48 53 40
15 Martorell Martorell 34 49 60 38
16 Olivella Olivella 34 48 67 38
17 Sant Andreu de la Barca Sant Andreu 34 37 78 32
18 PUD Málaga PUD Málaga 34 41 98 19

  USO DE MEMORIA  
5,740,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0880
Total Execution Time  0.0899
  CADENA URL  
/segunda_catalana2020/grupo3/historico
  GET DATOS  
$_GET['/segunda_catalana2020/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_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 = 'segunda_catalana' AND (l.group_code = 3 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=3 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=683 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 683 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 (1235030,1214782,1117609,935979,869940) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=683 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 = 50601 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 683 AND group_code = 3 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 50601 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.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 = 44411 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 `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 = 38995 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 33987 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 16674 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 `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 = 3950 AND t.round = 34 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-05-03 08:51: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-03 08:51: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-03 08:51: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-03 08:51:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_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.0021  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 = 50601 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50601 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 = 50601 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50601 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 = 50601 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50601 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051  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 = 50601 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