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
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 La Punxa CF A Punxa 27 103 41 65
2 Celra A Celra A 29 81 49 57
3 Comacros B Comacros B 29 76 44 56
4 Sant Feliu Guixols B Sant Feliu. 29 67 50 53
5 Sant Ponç B Sant Ponç 28 75 50 52
6 Camallera A Camallera A 29 70 45 51
7 Escola F. Girones Sabat B Escola 30 85 66 48
8 Jafre A Jafre A 29 56 48 43
9 Medes LEstartit FC Medes 30 79 82 43
10 Penya Bons Aires E B Penya Bons. 29 62 58 40
11 Pals B Pals B 30 58 72 33
12 Sant Antoni Sant Antoni 30 51 67 33
13 La Pera A La Pera A 30 48 96 33
14 Viladamat B Viladamat B 30 63 79 29
15 Fundacio Esportiva Palamos Fundacio 26 35 83 9
16 Mont-Ras B Mont-Ras B 27 39 118 8
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Sarria Ter A Sarria 31 114 49 74
2 Monells AE Monells AE 29 92 28 69
3 La Punxa CF A Punxa 28 104 48 67
4 Comacros B Comacros B 31 76 64 60
5 Escola Baix Ter A Escola Baix 30 80 54 57
6 Jafre A Jafre A 28 83 63 45
7 Camallera A Camallera A 27 58 40 45
8 Mont-Ras CE Mont-Ras CE 27 60 74 38
9 La Pera A La Pera A 30 59 82 36
10 Mas Mascort De Palafrugell Mascort 30 48 61 35
11 Medes LEstartit FC Medes 29 56 72 34
12 Sant Ponç B Sant Ponç 27 54 44 30
13 Penya Bons Aires E B Penya Bons. 27 58 72 25
14 Sant Antoni Sant Antoni 31 52 93 25
15 Pals B Pals B 29 32 78 21
16 Fundacio Esportiva Palamos Fundacio 30 34 107 12
17 Flaça B Flaça B 8 7 38 3
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Olimpic Malgrat B Olimpic 4 15 0 12
2 CE Cristinenc Cristinenc 4 19 6 12
3 Monells AE Monells AE 3 5 2 6
4 Flaça A Flaça A 3 8 6 6
5 Medes LEstartit FC Medes 4 8 10 6
6 Sarria Ter A Sarria 2 12 9 4
7 Albons Club Futbol A Albons Club 2 3 2 4
8 Penya Bons Aires E B Penya Bons. 4 7 9 4
9 Escola Baix Ter A Escola Baix 4 4 7 4
10 Camallera A Camallera A 4 3 9 4
11 La Pera A La Pera A 3 11 14 3
12 Sant Ponç B Sant Ponç 4 6 10 3
13 Pals B Pals B 4 3 15 3
14 Pontenc Club Esportiu A A Pontenc Club 4 8 10 2
15 Comacros B Comacros B 2 1 2 1
16 Sant Antoni Sant Antoni 0 0 0 0
17 Mont-Ras CE Mont-Ras CE 1 1 3 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Verges Verges 32 98 45 75
2 Caldes Malavella Caldes 32 108 61 66
3 Bellcaire 2012 Bellcaire 30 86 36 61
4 Albons Club Futbol A Albons Club 29 63 49 57
5 Sarria Ter A Sarria 31 97 65 53
6 Camallera A Camallera A 29 73 46 53
7 Viladamat CF Viladamat 29 77 52 53
8 Medes LEstartit FC Medes 30 64 57 53
9 Monells AE Monells AE 32 73 73 45
10 Jafre A Jafre A 27 46 64 37
11 La Pera A La Pera A 31 66 76 34
12 Montessori-Palau A Montessori-P 30 58 69 34
13 FE Palamós A Palamós 28 52 101 27
14 Sant Gregori B Sant Gregori 29 55 81 25
15 La Salle Girona A Salle Girona 29 49 81 24
16 Mont-Ras CE Mont-Ras CE 30 39 102 14
17 Lloretenc 2016 B Lloretenc 16 8 54 2
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Quart B Quart B 28 74 33 66
2 Sauleda Sauleda 30 96 46 65
3 Pals Atletic Pals Atletic 29 55 29 57
4 Can Gibert B Gibert 29 67 39 53
5 Sarria Ter A Sarria 28 86 64 50
6 Verges Verges 28 73 52 50
7 Viladamat CF Viladamat 30 62 51 49
8 Jafre A Jafre A 28 70 64 48
9 Bellcaire 2012 Bellcaire 28 69 51 41
10 Camallera A Camallera A 29 57 63 37
11 Flaça A Flaça A 30 62 99 27
12 Albons A Albons A 27 44 68 26
13 La Pera A La Pera A 29 54 83 26
14 Medes LEstartit FC Medes 28 41 73 24
15 Sant Gregori B Sant Gregori 29 59 98 23
16 Idem Salt Club Esportiu Idem Salt C. 26 22 78 9
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Pontenc Club Esportiu A A Pontenc Club 26 69 33 61
2 Salt Comacros Club Esportiu Salt 28 74 50 57
3 Sarria de Ter A A Sarria 28 77 52 53
4 Verges A A Verges A A 28 67 51 52
5 Pals AtlÈtic A A Pals 28 55 33 50
6 Vilablareix Futbol Club A A Vilablareix 28 63 49 48
7 La Pera A A La Pera A A 28 64 63 43
8 Quart B B Quart B B 28 63 50 40
9 Medes L'estartit A A Medes 27 65 63 39
10 Bescano B B Bescano B B 28 51 62 33
11 Bonmati A A Bonmati A A 28 58 59 31
12 Jafre A A Jafre A A 27 43 55 29
13 Flaç‡a A A Flaç‡a 27 39 85 17
14 Sant Gregori B Sant Gregori 27 30 79 17
15 Futbol Club Bellcaire 2012 Futbol Club 28 45 79 15
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Verges Verges 32 95 31 76
2 Sant Ponç At. Sant Ponç 31 101 34 73
3 Pontenc Esportiu A Pontenc 31 111 39 73
4 La Salle Girona A Salle Girona 30 109 49 70
5 Flaça A Flaça A 32 89 68 56
6 Bellcaire 2012 Bellcaire 28 70 72 46
7 Sauleda Sauleda 32 86 85 44
8 Vila-Sacra B Vila-Sacra 31 75 63 43
9 Medes LEstartit FC Medes 31 84 76 42
10 Quart B Quart B 31 81 79 40
11 Pals Atletic Pals Atletic 32 52 60 40
12 Comacros Comacros 32 57 82 36
13 Sant Gregori B Sant Gregori 32 61 89 29
14 Jafre A Jafre A 31 41 75 26
15 La Pera A La Pera A 31 45 100 25
16 Gualta A Gualta A 28 32 89 11
17 Vilobi FC B Vilobi FC B 27 36 134 10
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Lloret de Mar A Lloret 26 101 26 62
2 Malgrat Malgrat 26 83 33 59
3 La Batllòria A Batllòria 26 81 30 58
4 Cellera A Cellera A 26 84 46 58
5 CE Cristinenc Cristinenc 26 75 40 56
6 Lloret B Lloret B 26 103 38 51
7 Sporting-Vidrerenca B Sporting-Vid 26 72 61 40
8 Tossa B Tossa B 26 49 60 36
9 Guixols B Guixols B 26 43 54 32
10 Racing Blanenc A Racing 26 60 68 31
11 Breda B Breda B 26 58 63 30
12 Sant Hilari-Font Vella B Sant 26 23 108 10
13 Maçanet A Maçanet A 26 11 113 7
14 Catalonia A Catalonia A 26 20 123 4
15 Pontenc B Pontenc B 0 0 0 0

  USO DE MEMORIA  
5,260,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4793
Total Execution Time  0.4812
  CADENA URL  
/cuarta_catalana2024/grupo29/historico
  GET DATOS  
$_GET['/cuarta_catalana2024/grupo29/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0300  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 = 29 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=29 DESC LIMIT 1
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=745 AND type_rel = 3
0.0160  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.0159  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.0148  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 = 74063 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 745 AND group_code = 29 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0145  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 = 74063 AND t.round = 28 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 = 69488 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.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 `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 = 64541 AND t.round = 34 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 `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 = 58930 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 51621 AND t.round = 34 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 `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 = 44544 AND t.round = 34 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 `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 = 39213 AND t.round = 30 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 = 34319 AND t.round = 30 ORDER BY team.conference 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 `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 = 16917 AND t.round = 34 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 `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 = 4759 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 16:53:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 16:53:06' 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-05-03 16:53:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 16:53:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  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 = 74063 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74063 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.0155  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 = 74063 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74063 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0153  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 = 74063 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74063 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  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 = 74063 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC