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 Esplais CF Esplais CF 27 80 14 73
2 Borrassa FC Borrassa FC 26 85 30 61
3 Base Roses B Base Roses 26 81 29 60
4 Roses CIty B Roses CIty 26 79 25 57
5 Llado A Llado A 26 57 40 47
6 Marca de L'Ham B Marca L'Ham 26 64 39 43
7 Sant Llorenç Muga A Sant 26 50 37 39
8 Cistella CF Cistella CF 26 51 61 35
9 Cabanes UE Cabanes UE 26 46 51 33
10 Garriguella A Garriguella 26 44 61 31
11 Espolla A A Espolla A A 26 39 79 27
12 Cadaqués Cadaqués 26 52 77 26
13 Vilafant FC A Vilafant 26 47 75 23
14 Llers CF Llers CF 27 21 63 19
15 Recreativo Marca Recreativo 27 33 82 17
16 Selvatans A Selvatans A 27 39 105 13
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 CE Avinyo CE Avinyo 27 99 28 63
2 Sant Salvador Cercs Sant 27 89 28 59
3 Casserres Casserres 27 81 35 58
4 Callus B Callus B 27 98 34 57
5 Montmajor Montmajor 27 80 25 57
6 Gironella B Gironella B 26 71 32 49
7 Sant Feliu Sasserra Sant Feliu. 27 72 43 49
8 Palillo Palillo 27 71 54 44
9 Puigcerda Puigcerda 27 65 60 37
10 Olvan CE Olvan CE 26 36 53 31
11 Sant Llorenç Morunys Sant 26 40 95 16
12 Vilada Vilada 26 26 87 13
13 Monistrolenca Monistrolenc 27 33 124 9
14 Balconada B Balconada B 27 33 158 7
15 Navarcles B Navarcles B 10 10 48 3
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Calders Calders 24 85 20 59
2 Gironella B Gironella B 26 57 26 58
3 CE Avinyo CE Avinyo 25 70 25 54
4 Avia B Avia B 25 97 45 52
5 Montmajor Montmajor 24 78 28 49
6 Casserres Casserres 25 80 42 46
7 Olvan CE Olvan CE 25 45 42 39
8 Puigcerda Puigcerda 24 69 67 30
9 Vilada Vilada 25 31 65 24
10 Cardona B Cardona B 22 35 61 19
11 Sant Llorenç Morunys Sant 22 33 83 17
12 Alt BerguedÀ Ccr B BerguedÀ 24 44 71 16
13 Callus Callus 26 33 99 12
14 Suria B Suria B 25 19 102 12
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Navas B Navas B 9 26 8 27
2 Puigcerda Puigcerda 8 25 16 19
3 Gironella B Gironella B 8 19 7 18
4 Montmajor Montmajor 8 16 11 11
5 Avia B Avia B 8 24 16 10
6 Valls de Torroella Valls 9 19 23 7
7 Alt BerguedÀ Ccr B BerguedÀ 7 11 18 7
8 Vilada A Vilada A 7 11 19 6
9 CE Avinyo CE Avinyo 2 1 2 1
10 Avinyonet A Avinyonet A 3 3 8 1
11 Sant Llorenç Morunys A Sant 7 5 32 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Berga B Berga B 20 68 15 50
2 Alt Berguedà Berguedà 20 78 24 46
3 Olvan CE Olvan CE 19 48 17 40
4 Montmajor Montmajor 19 33 26 35
5 Avia B Avia B 19 38 27 34
6 Casserres Casserres 18 26 22 30
7 Navas B Navas B 19 37 25 29
8 Puigcerda Puigcerda 19 51 52 28
9 Sant Salvador Cercs Sant 19 31 43 16
10 Valls de Torroella Valls 20 24 59 13
11 Sant Llorenç Morunys Sant 20 31 60 12
12 Monistrolenca Monistrolenc 19 23 64 10
13 Vilada Vilada 19 22 76 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Castellnou Castellnou 29 93 43 69
2 Navarcles Navarcles 29 105 41 67
3 Alt Berguedà Berguedà 28 82 45 53
4 Berga B Berga B 28 64 39 52
5 Montmajor Montmajor 27 48 36 48
6 Avia B Avia B 28 64 44 47
7 Olvan CE Olvan CE 28 57 49 42
8 CE Avinyo CE Avinyo 28 42 53 38
9 Navas B Navas B 29 63 71 35
10 Casserres Casserres 28 46 49 32
11 Balconada B Balconada B 29 41 61 30
12 Sant Salvador Cercs Sant 26 42 57 27
13 Sant Pau Manresa UE A Sant Manresa 28 50 75 26
14 Sant Llorenç Morunys Sant 27 55 79 20
15 Valls de Torroella Valls 27 18 109 8
16 Vilomara A Vilomara A 7 9 28 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Artes FC A Artes FC A 25 75 27 61
2 Castellnou Castellnou 25 84 35 54
3 Callus Callus 25 58 38 52
4 Calders Calders 23 66 29 44
5 Sallent B Sallent B 25 65 45 41
6 Olvan CE Olvan CE 23 41 36 37
7 Berga B Berga B 25 46 45 37
8 Alt Berguedà Berguedà 22 43 43 31
9 Montmajor Montmajor 23 35 39 29
10 Casserres Casserres 25 42 59 24
11 Monistrolenca Monistrolenc 22 44 53 22
12 Valls de Torroella Valls 24 31 61 18
13 Sant Llorenç Morunys Sant 21 28 80 14
14 Navas B Navas B 22 14 82 4
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Navàs Navàs 27 70 32 60
2 Artesa Lleida CF Artesa 27 58 27 54
3 Puigcerda Puigcerda 26 59 29 53
4 Monistrolenca Monistrolenc 28 67 46 51
5 Callus Callus 26 68 45 50
6 Calders Calders 28 50 44 49
7 Berga B Berga B 26 58 43 46
8 Sallent B Sallent B 26 56 50 41
9 Baganes Ccr A A Baganes 27 72 75 31
10 Sant Llorenç Morunys Sant 28 53 60 30
11 Montmajor Montmajor 28 37 52 28
12 Casserres Casserres 28 46 81 21
13 Minorisa Sagrada Font B B Minorisa 20 29 49 20
14 Gironella At. B Gironella 26 36 83 17
15 Valls de Torroella Valls 25 20 63 8
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Avia B Avia B 26 78 28 59
2 Sallent B Sallent B 26 80 47 58
3 Sant Salvador Cercs Sant 25 78 27 56
4 Calders Calders 26 66 36 47
5 Montmajor Montmajor 26 45 42 46
6 Casserres Casserres 26 38 53 36
7 Suria B Suria B 25 64 64 33
8 Puigcerda Puigcerda 25 58 46 32
9 Sant Llorenç Morunys Sant 26 57 69 31
10 Monistrolenca Monistrolenc 25 45 73 30
11 Puigreig B Puigreig B 26 51 69 25
12 Navarcles Navarcles 26 56 78 24
13 Vilada Vilada 26 48 101 22
14 Valls de Torroella Valls 26 39 70 16
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Pirinaica B Pirinaica B 28 83 21 74
2 Berga Berga 28 97 35 68
3 Puigcerda Puigcerda 28 81 48 56
4 Sant Salvador Cercs Sant 28 77 52 54
5 Avia B Avia B 28 71 51 48
6 Suria B Suria B 28 69 60 46
7 Sallent B Sallent B 28 56 52 41
8 Casserres Casserres 28 57 64 35
9 Valls de Torroella Valls 28 42 70 33
10 Puigreig B Puigreig B 28 45 67 30
11 Montmajor Montmajor 28 43 48 29
12 Navarcles Navarcles 28 58 74 28
13 Vilada Vilada 28 41 76 25
14 Navas B Navas B 28 28 74 17
15 Sant Llorenç Morunys Sant 28 46 102 16

  USO DE MEMORIA  
5,941,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.1079
Total Execution Time  0.1105
  CADENA URL  
/cuarta_catalana2024/grupo1/historico
  GET DATOS  
$_GET['/cuarta_catalana2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0027  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 745 AND group_code = 1 and tables = 1 AND year <= 2024 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 `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 = 73763 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.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 `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 = 69460 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.0065  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 = 64508 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0094  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 = 58908 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.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 `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 = 51587 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.0047  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 = 45618 AND t.round = 30 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 `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 = 39928 AND t.round = 26 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 `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 = 35397 AND t.round = 30 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 `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 = 16958 AND t.round = 26 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 = 4731 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:18:38' 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-04-27 16:18:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:18:38' 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-04-27 16:18:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  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 = 73763 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73763 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 events2024 e ON e.player_id = p.id AND e.league_id = 73763 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73763 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0023  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 = 73763 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73763 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10