Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Canet FS Canet FS 30 150 72 70
2 Les Corts Esportiu FS Corts 30 133 80 67
3 EFS Prosperitat Prosperitat 30 131 122 51
4 Montsant FS Montsant FS 30 123 108 47
5 Gràcia FS Gràcia FS 30 136 142 47
6 Jesus Maria CE Jesus Maria 30 121 120 45
7 Cn Caldes Fs Futsal Caldes 30 128 124 45
8 Futsal Marlex Mataró B Futsal 30 113 105 41
9 Fs Montcada Futsal Montcada 30 115 115 40
10 Arenys de Munt Arenys Munt 30 107 104 39
11 La Unión Santa Coloma Unión Santa 30 121 133 39
12 Sant Joan de Vilassar Sant Joan V. 30 129 127 38
13 Eixample Diferoptics Eixample 30 80 107 37
14 Aecs L'Hospitalet Aecs 30 118 130 36
15 Arrahona FSC Arrahona 30 80 149 20
16 AE Xarxa Horta Xarxa Horta 30 77 124 17
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Canet FS Canet FS 16 71 33 40
2 Cn Caldes Fs Futsal Caldes 16 64 32 37
3 Futsal Marlex Mataró B Futsal 16 72 44 33
4 Montsant FS Montsant FS 16 72 50 31
5 Sant Joan de Vilassar Sant Joan V. 16 71 58 27
6 Arrels Aefs A Arrels Aefs 16 58 70 13
7 Spall Ciutat de Mataró A Spall Ciutat 16 47 79 9
8 Cover Premia de Mar Sala A Cover Premia 16 42 95 9
9 La Unión Santa Coloma B Unión Santa 16 45 81 8
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Ripollet B Ripollet B 30 198 89 80
2 Arenys de Munt Arenys Munt 29 142 91 60
3 Jesus Maria CE Jesus Maria 30 133 94 60
4 Arrahona FSC Arrahona 29 102 111 47
5 Vacarisses A Vacarisses 29 133 115 46
6 Esparreguera CFS Esparreguera 28 106 109 44
7 Sant Joan de Vilassar Sant Joan V. 30 130 121 39
8 Estel Vallseca A Estel 29 106 101 36
9 Cover Premia de Mar Sala A Cover Premia 30 97 130 34
10 Spall Ciutat de Mataró A Spall Ciutat 30 98 109 33
11 Montsant FS Montsant FS 30 78 95 33
12 Olimpic Floresta FS Olimpic 30 94 129 33
13 Arrels Aefs A Arrels Aefs 29 86 126 31
14 Sant Cugat A Sant Cugat 30 103 131 30
15 Gràcia Futbol Sala Club A Gràcia 30 107 134 28
16 Broncesval Montcada A Broncesval 29 108 136 26
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Isur La Font Magica A Isur Font M. 29 143 91 73
2 Ripollet B Ripollet B 30 152 83 71
3 Broncesval Montcada A Broncesval 30 144 112 55
4 Fundació Esportiva Grama A Fundació 30 132 100 52
5 Montsant FS Montsant FS 29 98 99 51
6 Vacarisses A Vacarisses 30 118 116 45
7 Spall Ciutat de Mataró A Spall Ciutat 29 111 105 42
8 Arrels Aefs A Arrels Aefs 28 121 119 42
9 Estel Vallseca A Estel 29 117 111 40
10 Arrahona FSC Arrahona 30 122 128 39
11 Sant Joan de Vilassar Sant Joan V. 27 91 78 36
12 Cover Premia de Mar Sala A Cover Premia 30 133 182 34
13 Sant Cugat A Sant Cugat 30 92 110 30
14 Lloret Costa Brava Cufs A Lloret Costa 30 100 122 30
15 Futsal Llic‡a D'amunt A Futsal 30 105 149 22
16 Farmacia Yanguela Castellar Farmacia 29 75 149 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Futsal Marlex Mataró Futsal 30 172 83 72
2 Braseria La Graella Canet A Braseria 30 141 68 69
3 Vacarisses A Vacarisses 29 139 95 58
4 Futsal Lliça D'amunt A Futsal 30 107 100 54
5 Fundació Esportiva Grama A Fundació 30 119 87 50
6 Fs Montcada Futsal Montcada 30 143 120 47
7 Montsant FS Montsant FS 30 101 94 47
8 Isur Hermanos Sanchez A Isur 30 130 130 45
9 Farmacia Yanguela Castellar Farmacia 30 111 118 42
10 Cover Premia de Mar Sala A Cover Premia 30 142 177 36
11 Arrels Aefs A Arrels Aefs 30 117 119 34
12 San Joan de Vilassar A Joan 30 79 112 34
13 Sant Cugat A Sant Cugat 30 104 132 33
14 Arenys de Munt Arenys Munt 30 97 132 27
15 Jamones Centelles A Jamones 30 97 148 26
16 Pineda de Mar '2a' Pineda '2a' 29 73 157 14
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Cerdanyola A Cerdanyola 30 167 64 84
2 Jamones Centelles A Jamones 30 157 109 60
3 Futsal Marlex Mataró Futsal 30 136 88 57
4 Montsant FS Montsant FS 30 122 111 49
5 Futsal Lliça D'amunt A Futsal 30 105 97 48
6 Penya Barcelonista Johan A Penya 29 114 93 47
7 Futsal Vilassar de Mar A Futsal 30 124 100 47
8 Cover Premia de Mar Sala A Cover Premia 30 131 145 47
9 San Joan de Vilassar A Joan 29 93 94 44
10 Arenys de Munt Arenys Munt 30 128 130 38
11 Arrels Aefs A Arrels Aefs 29 103 122 34
12 Pineda de Mar '2a' Pineda '2a' 29 101 122 33
13 Sagarra A Sagarra A 30 106 140 32
14 Rapid Santa Coloma A Rapid Santa 30 96 119 30
15 Parets A Parets A 30 87 166 17
16 Lloret Costa Brava Cufs A Lloret Costa 30 72 142 14
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Barceloneta A Barceloneta 30 172 95 76
2 Cerdanyola A Cerdanyola 30 153 71 70
3 Rapid Santa Coloma Futsal Rapid Santa 30 121 91 59
4 Fs Montsant Futsal Montsant 30 119 92 58
5 Sagarra Sagarra 30 158 112 54
6 Aliança Mataro Futsal Aliança 30 122 88 53
7 San Joan de Vilassar A Joan 30 94 79 48
8 Ce Arenys De Munt Futsal Arenys Munt 30 117 109 43
9 Lloret Costa Brava Futsal Lloret Costa 30 118 135 37
10 Parets A Parets A 30 118 140 37
11 Fs Vilassar De Mar Futsal Vilassar 30 99 91 36
12 Fs Pineda De Mar Futsal Pineda 30 110 135 35
13 Lliça D'Amunt A Lliça 30 115 148 34
14 Racing Pineda A Racing 30 101 146 28
15 Ripollet B Ripollet B 30 82 175 10
16 Manlleu Ue Fs Futsal Manlleu 30 105 197 9
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Fs Montcada Futsal Montcada 29 153 63 79
2 Fs Garcia Futsal Garcia 30 138 78 64
3 Natacio Sabadell Futsal Natacio 30 150 113 59
4 Ripollet Fs Futsal Ripollet 30 139 99 58
5 Fs Pineda De Mar Futsal Pineda 29 123 112 48
6 Fs Montsant Futsal Montsant 30 111 101 45
7 Lloret Costa Brava Futsal Lloret Costa 30 102 107 43
8 Cn Caldes Fs Futsal Caldes 30 105 110 41
9 Palau Solita Plegamans Futs Palau Solita 29 120 135 37
10 Vall De Tenes Cfs Futsal Vall Tenes. 30 109 125 34
11 Manlleu Ue Fs Futsal Manlleu 30 107 135 34
12 Cfs Premia De Dalt Futsal Premia Dalt 30 84 130 30
13 Ce Arenys De Munt Futsal Arenys Munt 30 100 130 29
14 Serv. Panella Riudellots Fu Serv. 29 95 127 29
15 Rialmo Bosco Rocafort Futsa Rialmo Bosco 29 76 108 29
16 Aliança Mataro Futsal Aliança 29 83 122 21

  USO DE MEMORIA  
5,815,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0912
Total Execution Time  0.0932
  CADENA URL  
/tercera_division_futsal2022/grupo1/historico
  GET DATOS  
$_GET['/tercera_division_futsal2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'tercera_division_futsal2022'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_division_futsal' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0024  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 266 GROUP BY l.categoryId
0.0021  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=266 GROUP BY l.year ORDER BY l.year DESC
0.0019  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 = 63802 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 266 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 63802 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.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 `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 = 59611 AND t.round = 18 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 `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 = 44519 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 = 41624 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 `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 = 35406 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 `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 = 17394 AND t.round = 30 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 `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 = 5271 AND t.round = 30 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 `tables2012` 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 = 1795 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-20 07:53:36' 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-20 07:53:36' 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-20 07:53:36' 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-20 07:53:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_division_futsal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 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 events2022 e ON e.player_id = p.id AND e.league_id = 63802 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63802 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 events2022 e ON e.player_id = p.id AND e.league_id = 63802 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63802 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 events2022 e ON e.player_id = p.id AND e.league_id = 63802 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63802 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 `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 = 63802 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