4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Cantonigros A Cantonigros 27 92 30 78
2 Torello CF B Torello 27 96 20 72
3 Rupit Pruit A Rupit Pruit 27 72 27 57
4 AE Corcó AE Corcó 26 82 50 45
5 Sant Vicenç Torelló Sant Vicenç 27 67 51 44
6 Montesquiu Montesquiu 25 64 61 39
7 UE Santperenca Santperenca 26 67 56 38
8 RIPOLL CLUB FUTBOL A RIPOLL CLUB 26 64 56 37
9 Santa Eugenia B Santa 27 61 64 37
10 CF Vinyoles CF Vinyoles 27 52 64 34
11 Borgonyà Borgonyà 27 55 65 30
12 CF Athletic Riudeperes Athletic 27 71 114 26
13 Seva B Seva B 27 42 87 26
14 Taradell C Taradell C 27 43 81 18
15 UE Gurb B UE Gurb B 27 38 85 16
16 FC Ribetana FC Ribetana 26 33 88 13
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Bufala Bufala 26 109 36 64
2 Lloreda B Lloreda B 27 86 28 56
3 Masnou CD B Masnou CD B 26 66 41 52
4 Alella Alella 26 85 67 48
5 Cabrils B Cabrils B 26 76 57 43
6 Dosrius 2010 A Dosrius 2010 25 68 56 43
7 Molinos B Molinos B 26 80 63 42
8 Verdiblanca Mataro Verdiblanca 27 77 79 35
9 Fundació Esportiva Montgat Fundació 26 61 71 33
10 La Llantia B Llantia 27 59 83 27
11 Joventut Teia Club Futbol A Joventut 27 49 74 27
12 Alella CF A Alella CF A 27 38 70 24
13 Cabrera Cabrera 26 45 75 20
14 Masnou At. B Masnou 27 48 102 17
15 Arenys de Munt B Arenys Munt 7 5 50 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Vilassar Dalt CE B Vilassar 26 104 23 68
2 Cabrils B Cabrils B 25 67 37 54
3 Premia Club Esportiu B B Premia Club 23 79 32 51
4 Masnou CD B Masnou CD B 25 73 52 44
5 Alella Alella 23 60 39 43
6 La Roca Penya Roca Penya 23 63 47 42
7 La Torreta B Torreta 24 58 55 33
8 Dosrius 2010 A Dosrius 2010 25 56 59 27
9 Escola Salesians-Mataro A Escola 23 55 67 27
10 Valles C AT. B Valles 24 37 76 24
11 Sant Fost A Sant Fost A 24 73 88 23
12 Cabrera Cabrera 21 33 50 19
13 Joventut Teia Club Futbol A Joventut 24 35 80 15
14 Arenys de Munt A Arenys Munt 24 22 110 5
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Vilassar Mar C Vilassar 10 56 11 27
2 Masnou At. B Masnou 10 24 11 23
3 Alella Alella 10 32 10 22
4 Premia Club Esportiu B B Premia Club 10 30 14 19
5 Ametlla Valles B Ametlla 11 22 24 18
6 Masnou CD B Masnou CD B 11 20 23 15
7 Alella CF A Alella CF A 9 22 18 13
8 Premia Dalt B Premia Dalt 11 21 22 13
9 Santa Agnes A Santa Agnes 10 11 25 10
10 Juventus AC B Juventus 10 23 38 9
11 Palau Solita i Plegamans B Palau Solita 5 5 25 0
12 Sentmenat A Sentmenat A 9 7 52 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Parets B Parets B 19 79 5 57
2 Sinera United Sinera 19 85 24 50
3 Alella Alella 19 62 23 44
4 Masnou At. B Masnou 17 40 36 30
5 Alella A Alella A 17 42 28 29
6 Argentona B Argentona B 19 53 52 29
7 Premia Dalt B Premia Dalt 16 34 26 27
8 Juventus AC B Juventus 20 51 46 26
9 Martorelles B Martorelles 17 48 49 26
10 Santvicenti B Santvicenti 20 47 43 23
11 Complex Julia Sant Esteve Complex 17 31 44 21
12 L'empenta Assoc Esp A A L'empenta 17 25 54 10
13 Juventut Teia Juventut 18 35 88 10
14 Fundació Esportiva Montgat Fundació 18 24 90 9
15 Palau Solita i Plegamans B Palau Solita 19 27 75 8
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Carme Carme 25 103 28 64
2 Ateneu Igualadí Ateneu 24 65 26 53
3 Esparreguera CE A Esparreguera 26 77 35 49
4 Rebrot A Rebrot A 26 85 58 49
5 Tous A Tous A 25 55 35 47
6 Vilanova Camí Vilanova 26 63 43 46
7 Fatima A Fatima A 26 74 59 43
8 La Torre Claramunt A Torre 25 60 48 41
9 Montbui C.F. A Montbui C.F. 24 59 56 37
10 Hostalets de Pierola A Hostalets 26 49 63 26
11 La Llacuna A Llacuna 25 44 84 18
12 Cabrera D'Anoia A Cabrera 25 38 81 17
13 Masquefa B Masquefa B 25 26 106 11
14 La Paz A La Paz A 26 35 111 5
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Vilassar Dalt Vilassar 23 120 22 63
2 At. Masnou At. Masnou 24 97 26 60
3 Martorelles Martorelles 23 96 35 47
4 L'Ametlla del Vallès L'Ametlla 22 99 52 45
5 Alella 2013 Alella 2013 22 54 47 36
6 Unificación CF Santa Perpet Unificación 22 63 44 35
7 Cabrils B Cabrils B 22 58 42 34
8 Premia Dalt B Premia Dalt 22 43 41 28
9 L'empenta Assoc Esp A A L'empenta 23 35 61 25
10 La Llagosta A Llagosta 21 38 68 23
11 Lliçà d'Amunt Lliçà 24 41 113 17
12 Palau Solita i Plegamans Palau Solita 23 26 117 10
13 Sentmenat A Sentmenat A 21 13 115 4
14 Tiana B Tiana B 0 0 0 0
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Pomar A A Pomar A A 24 76 29 53
2 Premia Club Esportiu B B Premia Club 24 66 19 53
3 Montsant de La Peira Montsant 23 65 35 47
4 At. Masnou At. Masnou 22 57 25 38
5 Alzamora Alzamora 24 55 49 36
6 Alella 2013 Alella 2013 24 49 54 36
7 Cabrils B Cabrils B 24 69 47 33
8 Molinos B B Molinos B B 24 51 48 30
9 Alella A Alella A 24 39 43 28
10 Arrabal-Calaf Gramanet B Arrabal-Cala 22 38 43 28
11 Premia Dalt B Premia Dalt 22 52 59 27
12 L'empenta Assoc Esp A A L'empenta 23 31 87 10
13 Tiana B Tiana B 22 25 135 3
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 La Salut Pere Gol A Salut Pere 26 99 20 68
2 At. Masnou At. Masnou 26 72 27 58
3 Vilassar Mar B Vilassar 26 80 33 58
4 Montsana de la Peira A Montsana 25 74 34 58
5 Badalona 1897 Aguila Badalona 26 70 38 51
6 Cabrera B Cabrera B 26 59 42 45
7 Premia B Premia B 26 53 48 39
8 Cabrils B Cabrils B 26 46 65 33
9 Bufala Bufala 25 62 73 31
10 Gotic A Gotic A 26 57 59 31
11 Alella A Alella A 26 54 94 27
12 Tiana Tiana 26 42 91 19
13 Premia Dalt B Premia Dalt 26 5 77 3
14 Unificació Badalona Sud A Unificació 26 3 75 3
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 FE Grama FE Grama 26 131 15 73
2 Arrabal-Calaf Gramanet B Arrabal-Cala 25 98 39 54
3 Aguila B Aguila B 25 82 49 52
4 La Salut Pere Gol A Salut Pere 25 69 50 48
5 At. Masnou At. Masnou 25 61 37 45
6 Cabrils B Cabrils B 25 58 43 42
7 Vilassar Mar B Vilassar 25 60 47 36
8 Cabrera B Cabrera B 25 43 43 34
9 Roma Sports A Roma Sports 25 41 60 29
10 Alella A Alella A 25 51 59 28
11 Premia Dalt B Premia Dalt 25 42 81 24
12 Unificació Badalona Sud A Unificació 25 34 116 11
13 Dosrius 2010 A Dosrius 2010 25 29 131 10
14 Tiana B Tiana B 14 23 52 6
15 Singuerlin B Singuerlin 0 0 0 0
16 Vilassar Dalt A Vilassar 0 0 0 0

  USO DE MEMORIA  
5,914,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5000
Total Execution Time  0.5019
  CADENA URL  
/cuarta_catalana2024/grupo6/historico
  GET DATOS  
$_GET['/cuarta_catalana2024/grupo6/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0294  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 = 6 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=6 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=745 AND type_rel = 3
0.0154  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.0157  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.0146  SELECT id,name,alias,stepParent FROM categories WHERE parentId=745 ORDER BY order_id ASC
0.0147  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 = 74039 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 745 AND group_code = 6 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0149  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 `tables2024` 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 = 74039 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2023` 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 = 69465 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2022` 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 = 64513 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2021` 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 = 58913 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 51600 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.0148  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 = 45623 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 39933 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 36070 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 16963 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 4736 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:45:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:45:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:45:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:45:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  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 events2024 e ON e.player_id = p.id AND e.league_id = 74039 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74039 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.0146  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 events2024 e ON e.player_id = p.id AND e.league_id = 74039 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74039 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 events2024 e ON e.player_id = p.id AND e.league_id = 74039 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74039 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 74039 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC