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 Torrellenc Torrellenc 24 66 24 61
2 Monjos Monjos 23 73 42 51
3 Hortonenc A Hortonenc A 24 54 32 47
4 Can Cartro A Cartro 22 70 31 46
5 Sant Pau D'Ordal A Sant D'Ordal 24 57 42 46
6 Base Espirall Les Clotes A Base 24 74 34 45
7 Mediona A Mediona A 22 52 39 42
8 Sant Cugat Sesgarrigues Sant Cugat. 24 57 48 37
9 Sant Pere Molanta Sant Pere M. 23 43 37 33
10 Quintinenc A Quintinenc 22 29 42 24
11 Ribes CD B Ribes CD B 23 38 52 24
12 Martinenca A Martinenca 23 30 53 24
13 Cubelles CF B Cubelles 24 54 63 23
14 Sant Sadurni A Sant Sadurni 23 41 63 21
15 Gelida CF A Gelida CF A 21 46 65 19
16 Pla del Penedes Penedes 22 32 74 9
17 Avinyonet A Avinyonet A 24 22 97 5
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 At. Vilanova I La Geltru Vilanova 32 128 39 77
2 Les Cabanyes Cabanyes 33 90 36 77
3 Torrellenc Torrellenc 32 92 45 68
4 Can Cartro A Cartro 30 102 49 66
5 Sant Cugat Sesgarrigues Sant Cugat. 31 64 36 65
6 Base Espirall Les Clotes A Base 32 86 37 64
7 Sant Pau D'Ordal A Sant D'Ordal 33 75 72 52
8 Martinenca A Martinenca 33 54 70 44
9 Sant Sadurni A Sant Sadurni 33 63 69 43
10 Sant Pere Molanta Sant Pere M. 30 65 58 40
11 Gelida CF A Gelida CF A 32 78 74 40
12 Ribes CD B Ribes CD B 31 54 68 40
13 Hortonenc A Hortonenc A 31 67 75 36
14 Pla del Penedes Penedes 32 55 91 36
15 Monjos Monjos 32 51 97 23
16 Quintinenc A Quintinenc 33 36 102 18
17 Castellvi de la Marca A Castellvi 33 29 125 6
18 Sant Miquel - Montagut Sant Miquel 15 15 61 1
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 La Granada La Granada 29 99 18 75
2 Pª Jove de Les Roquetes A Pª Jove Ro. 27 84 37 62
3 Les Cabanyes Cabanyes 30 95 56 61
4 Torrellenc Torrellenc 30 86 41 60
5 Can Cartro A Cartro 27 72 38 54
6 At. Vilanova I La Geltru Vilanova 30 72 46 53
7 Base Espirall Les Clotes A Base 29 58 47 47
8 Sant Sadurni A Sant Sadurni 30 66 69 39
9 Sant Pau D'Ordal A Sant D'Ordal 30 53 55 34
10 Monjos Monjos 29 57 77 34
11 Ribes CD B Ribes CD B 29 60 81 33
12 Sant Cugat Sesgarrigues Sant Cugat. 26 48 62 28
13 Gelida CF A Gelida CF A 27 50 65 28
14 Avinyonet A Avinyonet A 26 37 81 22
15 Castellvi de la Marca A Castellvi 28 41 82 19
16 Puigdalber A Puigdalber 27 14 137 0
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Mediona A Mediona A 28 82 42 69
2 Can Cartro A Cartro 28 93 32 64
3 Ribes Ribes 27 65 17 63
4 Les Cabanyes Cabanyes 28 78 35 58
5 Base Espirall Les Clotes A Base 27 76 32 49
6 Pª Jove de Les Roquetes A Pª Jove Ro. 28 75 59 44
7 La Granada B Granada 25 56 36 39
8 Sant Sadurni A Sant Sadurni 25 50 44 39
9 Avinyonet A Avinyonet A 28 52 60 38
10 Castellvi de la Marca A Castellvi 26 52 52 37
11 Puigdalber A Puigdalber 25 55 62 23
12 Monjos Monjos 27 41 83 23
13 Sant Pau D'Ordal A Sant D'Ordal 27 48 68 15
14 Newell's Vilanova i la Gelt Newell's 24 24 125 7
15 Torrellenc Torrellenc 27 19 119 3
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Suburense B Suburense B 30 106 31 82
2 Hortonenc A Hortonenc A 30 97 26 76
3 Can Cartro A Cartro 30 93 36 69
4 Les Cabanyes Cabanyes 30 94 43 59
5 La Plana Rodona A Plana Rodona 30 78 47 57
6 Base Espirall-Les Clotes Base 30 75 40 55
7 Ribes Ribes 29 96 71 53
8 Penya Jove Roquetes Penya Jove. 30 79 80 45
9 Sant Sadurni A Sant Sadurni 29 61 65 37
10 Torrellenc Torrellenc 29 72 92 34
11 Sant Pau D'Ordal A Sant D'Ordal 30 46 80 25
12 Monjos Monjos 30 45 86 22
13 Canyelles Assoc. Esp. CF A Canyelles 30 34 94 21
14 Puigdalber A Puigdalber 28 26 84 17
15 La Granada B Granada 30 36 104 16
16 Avinyonet A Avinyonet A 29 43 102 12
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Martinenca A Martinenca 29 116 24 74
2 Castellvi de la Marca A Castellvi 30 93 36 73
3 Can Cartro A Cartro 30 71 30 66
4 Les Cabanyes Cabanyes 30 89 48 64
5 Hortonenc A Hortonenc A 29 96 40 62
6 Mediona A Mediona A 30 67 58 52
7 Sant Sadurni A Sant Sadurni 30 70 54 45
8 Monjos Monjos 29 73 75 45
9 La Plana Rodona A Plana Rodona 29 50 58 42
10 Sant Pau D'Ordal A Sant D'Ordal 30 69 82 37
11 Torrellenc Torrellenc 29 54 75 31
12 La Granada B Granada 29 50 65 29
13 Rapit Catala A Rapit Catala 30 42 91 23
14 Puigdalber A Puigdalber 30 33 106 19
15 Avinyonet A Avinyonet A 30 42 94 10
16 Quintinenc A Quintinenc 24 20 99 3

  USO DE MEMORIA  
5,622,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0850
Total Execution Time  0.0869
  CADENA URL  
/cuarta_catalana2020/grupo10/historico
  GET DATOS  
$_GET['/cuarta_catalana2020/grupo10/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'cuarta_catalana2020'
0.0042  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 = 10 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=10 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=745 AND type_rel = 3
0.0032  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.0031  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.0026  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 745 AND group_code = 10 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0033  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 = 44761 AND t.round = 34 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 `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 = 39937 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 `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 = 36074 AND t.round = 30 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 `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 = 17043 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 `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 = 4740 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-05-04 11:39:16' 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-04 11:39:16' 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-04 11:39:16' 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=3 AND last_update > '2024-05-04 11:39:16' 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 = '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 = 51608 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51608 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 = 51608 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51608 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 = 51608 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51608 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  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 = 51608 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC