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 Premia Club C Premia Club 26 95 39 63
2 Juvesport A Juvesport A 27 81 41 56
3 Cabrils C Cabrils C 27 81 44 55
4 Arenys de Munt A Arenys Munt 27 81 50 55
5 Molinos B Molinos B 26 77 56 53
6 Canet A Canet A 26 74 38 51
7 Llavaneres B Llavaneres 27 65 45 47
8 La Llantia B Llantia 27 70 63 44
9 Olimpic Malgrat Olimpic 26 63 66 39
10 Pla D'en Boet A D'en Boet 26 59 55 37
11 Cerdanyola Mataro Cerdanyola 27 62 71 30
12 Verdiblanca Mataro Verdiblanca 26 48 73 23
13 Arenys de Mar B Arenys 25 38 75 19
14 Sinera United FC B Sinera 26 35 77 14
15 Cuatro Vientos Cuatro 25 37 76 12
16 Santvicenti B Santvicenti 26 30 127 8
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Sant Pere Molanta Sant Pere M. 30 121 31 79
2 Canyelles Assoc Esp A Canyelles 30 88 39 72
3 Hortonenc A Hortonenc A 30 97 55 54
4 Sant Pau D'Ordal A Sant D'Ordal 30 81 54 52
5 Gelida CF A Gelida CF A 29 91 46 51
6 Sant Cugat Sesgarrigues Sant Cugat. 30 74 49 49
7 Canyelles Canyelles 30 73 63 48
8 Monjos Monjos 29 49 42 48
9 Riudebitlles B Riudebitlles 29 59 56 44
10 Martinenca A Martinenca 29 59 64 44
11 Sant Sadurni A Sant Sadurni 30 58 73 34
12 Puigdalber A Puigdalber 28 52 73 25
13 Olivella B Olivella B 28 46 85 21
14 Base Vilanova 2015 CNF A Base 30 48 116 17
15 Avinyonet A Avinyonet A 30 37 106 13
16 La Torre Claramunt B Torre 28 42 123 9
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Can Cartro A Cartro 29 118 26 78
2 Base Vilanova 2015 CNF A Base 30 84 49 60
3 Martinenca A Martinenca 29 84 44 59
4 Gelida CF A Gelida CF A 29 97 59 56
5 Hortonenc A Hortonenc A 29 102 63 53
6 Sant Pere Molanta Sant Pere M. 28 102 59 49
7 Quintinenc A Quintinenc 29 72 53 48
8 Sant Sadurni A Sant Sadurni 29 79 64 46
9 Sant Pau D'Ordal A Sant D'Ordal 26 80 60 45
10 Canyelles Assoc Esp A Canyelles 29 59 73 37
11 Sant Cugat Sesgarrigues Sant Cugat. 28 56 86 33
12 Avinyonet A Avinyonet A 29 71 90 31
13 Puigdalber A Puigdalber 28 43 91 26
14 Olivella B Olivella B 29 50 135 19
15 Capellades B Capellades 30 47 114 9
16 Monjos Monjos 29 44 122 9
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Base Espirall Les Clotes A Base 8 21 7 17
2 Martinenca A Martinenca 8 18 8 17
3 Sant Pere Molanta Sant Pere M. 8 26 13 14
4 Cubelles CF B Cubelles 7 19 12 12
5 Can Cartro A Cartro 7 20 12 11
6 Hortonenc A Hortonenc A 7 24 13 10
7 Avinyonet A Avinyonet A 7 9 19 6
8 Quintinenc A Quintinenc 8 10 24 6
9 Mediona A Mediona A 8 9 23 6
10 Pla del Penedes Penedes 8 5 30 2
11 Sant Pau D'Ordal A Sant D'Ordal 0 0 0 0
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  
6,066,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.0877
Total Execution Time  0.0904
  CADENA URL  
/cuarta_catalana2024/grupo10/historico
  GET DATOS  
$_GET['/cuarta_catalana2024/grupo10/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0039  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=10 DESC LIMIT 1
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 = 74043 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 745 AND group_code = 10 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 74043 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.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 `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 = 69469 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.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 `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 = 64522 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.0021  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 = 58917 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.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 `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
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 `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.0041  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.0021  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.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 `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.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 `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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 10:30:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 10:30:09' 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-04-28 10:30:09' 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-04-28 10:30:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  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 = 74043 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74043 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.0022  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 = 74043 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74043 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 events2024 e ON e.player_id = p.id AND e.league_id = 74043 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74043 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  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 = 74043 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