4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del La Unión Santa Coloma
TEMPORADA 2022/2023
TERCERA DIVISIÓN FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Montsant FS Montsant FS 29 129 91 67
2 Olimpic Floresta FS Olimpic 30 123 85 57
3 Rubí FS Rubí FS 30 137 110 54
4 Sant Joan de Vilassar Sant Joan V. 30 144 131 53
5 La Unión Santa Coloma Unión Santa 30 136 102 52
6 Arenys de Munt Arenys Munt 30 126 104 50
7 Sant Quirze Valles FS Sant Quirze 30 120 106 46
8 Futsal Marlex Mataró B Futsal 29 111 111 41
9 Gràcia FS Gràcia FS 30 127 137 41
10 Estel Vallseca A Estel 28 108 100 39
11 Cn Caldes Fs Futsal Caldes 30 113 137 38
12 Castellar FS Castellar 30 112 117 36
13 EFS Prosperitat Prosperitat 30 106 125 36
14 Parets FS Parets FS 30 102 119 33
15 Fs Montcada Futsal Montcada 30 91 143 24
16 Vacarisses A Vacarisses 30 87 154 12
TEMPORADA 2021/2022
TERCERA DIVISIÓN FUTSAL GRUPO 1
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
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 ETB Calvia - Palma Futsal Calvia Palma 18 71 55 38
2 Sala 5 Martorell Sala 18 110 74 35
3 Hospitalet Bellsport Hospitalet 18 79 57 33
4 Escola Pia Sabadell Escola 18 79 65 31
5 Ibiza Gasifred Ibiza 18 81 62 31
6 Ripollet Ripollet 18 80 55 31
7 Cerdanyola Valles Cerdanyola 18 63 65 24
8 La Unión Santa Coloma Unión Santa 18 48 65 18
9 Palleja FS Palleja FS 18 51 89 11
10 Arenys de Munt Arenys Munt 18 42 117 6
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Hospitalet Bellsport Hospitalet 23 124 69 53
2 Futsal Marlex Mataró Futsal 23 107 69 52
3 Club Manresa FS Club Manresa 23 116 77 43
4 Barceloneta FS CE Barceloneta 23 85 69 41
5 Sala 5 Martorell Sala 23 89 81 40
6 Cerdanyola Valles Cerdanyola 23 98 88 36
7 ETB Calvia - Palma Futsal Calvia Palma 23 83 91 36
8 Natacio Sabadell Natacio 23 86 84 33
9 Escola Pia Sabadell Escola 23 78 81 32
10 Lamsauto Lleida Lamsauto 23 89 107 30
11 Salou FS Salou FS 23 77 94 29
12 La Unión Santa Coloma Unión Santa 23 86 107 27
13 Mar Denia A Mar Denia A 23 86 110 25
14 Ripollet B Ripollet B 23 84 101 22
15 Palleja FS Palleja FS 23 85 110 19
16 Industrias Santa Coloma B Industrias 23 82 117 14
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN B FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 C.C.R. Castelldefels C.C.R. 30 161 81 81
2 Club Manresa FS Club Manresa 30 185 111 66
3 Escola Pia Sabadell Escola 30 126 93 59
4 Futsal Marlex Mataró Futsal 30 121 83 58
5 Palleja FS Palleja FS 30 163 125 53
6 Hospitalet Bellsport Hospitalet 30 140 111 49
7 Natacio Sabadell Natacio 30 139 133 44
8 La Unión Santa Coloma Unión Santa 30 125 132 40
9 Salou FS Salou FS 30 128 119 39
10 Industrias Santa Coloma B Industrias 30 86 105 37
11 Cerdanyola Valles Cerdanyola 30 97 108 36
12 Barceloneta FS CE Barceloneta 30 100 119 36
13 Lamsauto Lleida Lamsauto 30 125 174 36
14 Canet A Canet A 30 96 126 35
15 Segorbe Segorbe 30 83 138 18
16 Isur Ciutat de Terrassa A Isur Ciutat 30 30 147 5
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Club Manresa FS Club Manresa 30 185 95 71
2 C.C.R. Castelldefels C.C.R. 29 133 78 67
3 Palleja FS Palleja FS 30 161 102 59
4 Escola Pia Sabadell Escola 30 138 87 58
5 Hospitalet Bellsport Hospitalet 30 160 127 57
6 Catgas Energia B Catgas 30 120 89 57
7 La Unión Santa Coloma Unión Santa 30 122 107 49
8 Salou FS Salou FS 29 123 131 43
9 Cerdanyola Valles Cerdanyola 30 92 102 38
10 Natacio Sabadell Natacio 30 153 167 38
11 Futsal Marlex Mataró Futsal 30 103 106 37
12 Barceloneta Futsal Club Esp Barceloneta 30 101 114 37
13 Canet A Canet A 30 89 125 26
14 Olimpic Floresta FS Olimpic 30 87 134 23
15 CD Dénia Futsal Dénia 30 61 155 15
16 FS Linyola FS Linyola 30 89 198 5
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN B FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Bisontes Castellón FS Bisontes 30 129 69 77
2 C.C.R. Castelldefels C.C.R. 30 140 76 76
3 La Unión-Bosco Rocafort FS Unión-Bosco 30 134 94 63
4 La Unión Santa Coloma Unión Santa 30 124 88 55
5 L'olleria Club D'Albaida L'olleria 30 131 91 53
6 Ce Escola Pia Futsal Escola 30 111 104 52
7 Cerdanyola Valles Cerdanyola 30 112 99 42
8 Hospitalet Bellsport Hospitalet 30 131 128 42
9 Club Manresa FS Club Manresa 30 107 121 36
10 Natacio Sabadell Natacio 30 110 135 35
11 Salou FS Salou FS 30 101 138 33
12 Olimpic Floresta FS Olimpic 30 87 117 31
13 Barceloneta A Barceloneta 29 90 121 27
14 Sala 5 Martorell Sala 30 86 127 27
15 Ripollet Ripollet 30 102 129 24
16 Vfs Peña Deportiva Futsal Peña 29 91 149 18
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 C.C.R. Castelldefels C.C.R. 34 159 81 79
2 La Unión Santa Coloma Unión Santa 34 147 90 70
3 Ce Escola Pia Futsal Escola 34 157 113 68
4 Playas - CD Castellón FS Playas 34 117 85 60
5 La Unión-Bosco Rocafort FS Unión-Bosco 34 138 121 56
6 Club Manresa FS Club Manresa 34 146 131 55
7 Hospitalet Bellsport Hospitalet 34 150 138 48
8 Sala 5 Martorell Sala 34 120 122 46
9 Barceloneta A Barceloneta 33 123 133 44
10 Ripollet Ripollet 34 107 137 44
11 Salou FS Salou FS 34 133 136 42
12 Palleja FS Palleja FS 34 142 160 42
13 Vfs Peña Deportiva Futsal Peña 33 123 141 41
14 Olimpic Floresta FS Olimpic 34 104 139 40
15 Aej Riera Nivell 28 Futsal Riera Nivell 34 108 121 40
16 Penya Esplugues AE Penya 34 109 146 34
17 Esparreguera CFS Esparreguera 34 113 151 28
18 Fs Montcada Futsal Montcada 34 94 145 22
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN B FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Hospitalet Bellsport Hospitalet 1 10 0 3
2 Ce Escola Pia Futsal Escola 1 8 0 3
3 Fs Montcada Futsal Montcada 1 5 2 3
4 Fsce Bar Mi Casa Futsal Fsce Casa F. 1 4 1 3
5 Fs Vilassar De Mar Futsal Vilassar 1 6 4 3
6 La Unión Santa Coloma Unión Santa 1 6 4 3
7 Sala 5 Martorell Sala 1 3 1 3
8 Rapid Santa Coloma Futsal Rapid Santa 1 2 2 1
9 Sant Andreu De La Barca Sant Andreu 1 2 2 1
10 Esparreguera CFS Esparreguera 1 4 6 0
11 Petromiralles Manresa Futsa Petromiralle 1 4 6 0
12 La Union Las Palmas Futsal Union Palmas 1 1 3 0
13 Cover Premia De Mar Futsal Cover Premia 1 2 5 0
14 Sicoris Club Futsal Sicoris Club 1 1 4 0
15 Pd Santa Eulalia Futsal Santa 1 0 8 0
16 Centelles Finques Cent. Fut Centelles 1 0 10 0

  USO DE MEMORIA  
5,782,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0769
Total Execution Time  0.0781
  CADENA URL  
/historico/Marfil-Santa-Coloma-B-Futsal
  GET DATOS  
$_GET['/historico/Marfil-Santa-Coloma-B-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0039  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 68844
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11118 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=266 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 266 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1167099,838700,803257,794536,792169) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '11118' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=11118 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0020  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (68844) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 68844 AND teamId = 11118
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 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 = 68844 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 11118 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 68844 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 = 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.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 `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 = 58896 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 `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 = 51026 AND t.round = 23 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 `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 = 44514 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 = 40226 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 `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 = 35140 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 = 16953 AND t.round = 34 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 `tables2013` 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 = 2203 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC