4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Santa Coloma B
TEMPORADA 2023/2024
SEGUNDA ANDORRA
Equipo PJ GF GC Puntos
1 La Massana La Massana 11 38 13 27
2 Atletic Escaldes B Atletic 12 18 20 18
3 UE Santa Coloma B Santa Coloma 12 20 24 18
4 FC Santa Coloma B Santa Coloma 12 17 25 10
5 FC Rangers FC Rangers 11 16 27 7
6 Sant Julià Sant Julià 0 0 0 0
TEMPORADA 2022/2023
SEGUNDA ANDORRA
Equipo PJ GF GC Puntos
1 Pas de la Casa Casa 18 99 7 48
2 Atlètic Amèrica Atlètic 18 57 21 44
3 Esperança d'Andorra Esperança 18 49 17 40
4 Carroi Carroi 18 50 30 33
5 La Massana La Massana 18 48 28 28
6 Encamp Encamp 18 42 41 28
7 FC Rangers FC Rangers 18 35 54 22
8 UE Santa Coloma B Santa Coloma 18 18 72 6
9 Engordany II Engordany 18 12 70 6
10 FC Santa Coloma B Santa Coloma 18 17 87 6
11 Ordino II Ordino II 0 0 0 0
TEMPORADA 2021/2022
SEGUNDA ANDORRA GRUPO 1
Equipo PJ GF GC Puntos
1 Penya Encarnada Penya 20 106 13 54
2 La Massana La Massana 20 63 19 48
3 UE Extremenya Extremenya 20 65 27 41
4 UE Santa Coloma B Santa Coloma 20 58 25 38
5 Atlètic Amèrica Atlètic 20 52 33 34
6 Encamp Encamp 20 36 39 28
7 UE Sant Julia II Sant Julia 20 34 50 21
8 Atletic Escaldes B Atletic 20 26 62 19
9 FC Santa Coloma B Santa Coloma 20 32 79 18
10 FC Rangers FC Rangers 20 33 67 15
11 Engordany II Engordany 20 22 113 4
12 Jenlai Jenlai 0 0 0 0
TEMPORADA 2016/2017
SEGUNDA ANDORRA
Equipo PJ GF GC Puntos
1 Inter Escaldes Inter 18 54 12 43
2 Penya Encarnada Penya 18 66 24 42
3 Atlètic Amèrica Atlètic 18 43 22 37
4 Encamp II Encamp II 18 43 35 32
5 Atlètic Escaldes Atlètic 18 55 31 27
6 FC Santa Coloma B Santa Coloma 18 28 39 23
7 La Massana La Massana 18 41 43 21
8 UE Santa Coloma B Santa Coloma 18 28 47 19
9 FC Rangers FC Rangers 18 17 57 10
10 Lusitanos II Lusitanos 18 21 86 6
TEMPORADA 2015/2016
SEGUNDA ANDORRA
Equipo PJ GF GC Puntos
1 Jenlai Jenlai 22 106 15 61
2 Atlètic Escaldes Atlètic 22 53 12 53
3 Carroi Carroi 21 63 23 52
4 UE Extremenya Extremenya 22 78 24 49
5 Inter Escaldes Inter 22 56 28 40
6 Encamp II Encamp II 22 41 42 29
7 Atlètic Amèrica Atlètic 21 42 53 23
8 La Massana La Massana 22 45 58 21
9 FC Santa Coloma B Santa Coloma 22 43 57 21
10 UE Santa Coloma B Santa Coloma 22 35 73 19
11 FC Rangers FC Rangers 22 32 94 12
12 Ordino II Ordino II 0 0 0 0
13 Lusitanos II Lusitanos 22 10 125 0
TEMPORADA 2014/2015
SEGUNDA ANDORRA GRUPO 1
Equipo PJ GF GC Puntos
1 Penya Encarnada Penya 10 52 16 26
2 FC Rangers FC Rangers 10 28 11 25
3 Atlètic Escaldes Atlètic 10 33 16 18
4 UE Santa Coloma B Santa Coloma 10 42 24 17
5 Lusitanos II Lusitanos 10 30 28 17
6 La Massana La Massana 10 33 20 15
7 Ordino II Ordino II 10 25 26 13
8 UE Extremenya Extremenya 10 15 18 12
9 Encamp II Encamp II 10 17 25 9
10 Engordany II Engordany 10 11 59 3
11 FC Santa Coloma B Santa Coloma 0 0 0 0
12 Principat Principat 0 0 0 0
13 UE Sant Julia II Sant Julia 0 0 0 0
14 Jenlai Jenlai 10 5 48 0
TEMPORADA 2013/2014
SEGUNDA ANDORRA
Equipo PJ GF GC Puntos
1 Engordany Engordany 13 46 12 36
2 Jenlai Jenlai 13 62 33 30
3 UE Santa Coloma B Santa Coloma 13 50 18 27
4 FC Rangers FC Rangers 13 49 22 27
5 Lusitanos II Lusitanos 13 28 21 24
6 Ordino II Ordino II 13 32 20 23
7 UE Extremenya Extremenya 13 42 23 21
8 Encamp II Encamp II 13 30 21 20
9 La Massana La Massana 13 21 35 16
10 UE Sant Julia II Sant Julia 13 16 32 15
11 FC Santa Coloma B Santa Coloma 13 34 40 13
12 Atlètic Escaldes Atlètic 14 25 48 10
13 Principat II Principat 13 13 47 9
14 Penya Encarnada Penya 13 12 73 3
15 Casa Estrella Benfica Casa 13 21 36 1
TEMPORADA 2012/2013
SEGUNDA ANDORRA
Equipo PJ GF GC Puntos
1 FC Ordino FC Ordino 22 119 10 66
2 Lusitanos II Lusitanos 22 60 32 44
3 FC Santa Coloma B Santa Coloma 22 48 39 41
4 Atlètic Escaldes Atlètic 22 53 40 38
5 Principat II Principat 22 55 56 34
6 Casa Estrella Benfica Casa 22 43 42 33
7 UE Santa Coloma B Santa Coloma 22 41 48 31
8 UE Extremenya Extremenya 22 41 33 29
9 FC Rangers FC Rangers 22 57 72 28
10 Encamp II Encamp II 22 38 60 17
11 Penya Encarnada Penya 22 30 103 15
12 La Massana La Massana 22 16 66 7
TEMPORADA 2011/2012
SEGUNDA ANDORRA
Equipo PJ GF GC Puntos
1 UE Extremenya Extremenya 16 51 14 38
2 Encamp Encamp 14 43 16 33
3 Lusitanos II Lusitanos 15 42 14 29
4 UE Santa Coloma B Santa Coloma 14 40 24 26
5 Casa Estrella Benfica Casa 15 32 34 25
6 Atlètic Escaldes Atlètic 15 22 29 25
7 FC Santa Coloma B Santa Coloma 16 53 31 24
8 Principat II Principat 14 16 50 7
9 Penya Encarnada Penya 14 20 53 5
10 La Massana La Massana 15 15 69 3
TEMPORADA 2010/2011
SEGUNDA ANDORRA
Equipo PJ GF GC Puntos
1 FC Rangers FC Rangers 18 63 16 44
2 Lusitanos II Lusitanos 18 69 19 43
3 Engordany Engordany 18 47 25 40
4 UE Extremenya Extremenya 18 63 24 35
5 FC Santa Coloma B Santa Coloma 18 42 40 34
6 Atlètic Escaldes Atlètic 18 32 54 17
7 Penya Encarnada Penya 18 27 50 13
8 La Massana La Massana 18 25 55 13
9 Principat II Principat 18 24 66 13
10 Jenlai Jenlai 18 25 68 10
TEMPORADA 2006/2007
SEGUNDA ANDORRA
Equipo PJ GF GC Puntos
1 Casa Estrella Benfica Casa 14 25 12 33
2 FC Santa Coloma B Santa Coloma 14 38 18 28
3 Engordany Engordany 14 29 19 25
4 Principat II Principat 13 31 25 19
5 UE Extremenya Extremenya 13 28 25 15
6 Sporting Escaldes Sporting 14 19 38 13
7 Lusitanos II Lusitanos 14 26 41 12
8 FC Rangers II Rangers 14 17 35 9

  USO DE MEMORIA  
5,574,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4660
Total Execution Time  0.4673
  CADENA URL  
/historico/Fc-Santa-Coloma-Ii
  GET DATOS  
$_GET['/historico/Fc-Santa-Coloma-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0267  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 = 73195
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17360 AND type_rel = 2
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=418 AND type_rel = 3
0.0140  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 = '17360' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73195 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139  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=17360 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (73195) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73195 AND teamId = 17360
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73195 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '17360' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17360' and rp.type = 4
0.0127  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '17360' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73195 WHERE rp.league_id = 73195 AND rp.teamId = 17360 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73195 WHERE rp.league_id = 73195 AND rp.teamId = 17360 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 73195 WHERE rp.league_id = 73195 AND rp.teamId = 17360 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 17360 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 73195 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.0130  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 = 68121 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 64310 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 37153 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 15560 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 4047 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 `tables2014` 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 = 8849 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 8847 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 8846 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2011` 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 = 8844 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables2007` 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 = 8837 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC