Ver
TEMPORADA 2021/2022
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
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 La Massana La Massana 14 29 9 35
2 FC Ordino FC Ordino 14 42 10 35
3 Encamp Encamp 14 24 15 26
4 Jenlai Jenlai 14 27 30 18
5 Atlètic Amèrica Atlètic 14 11 19 16
6 UE Santa Coloma B Santa Coloma 14 18 35 14
7 Engordany II Engordany 14 15 36 10
8 FC Rangers FC Rangers 14 19 31 8
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Penya Encarnada Penya 16 54 7 46
2 La Massana La Massana 16 85 17 45
3 Encamp Encamp 16 42 36 27
4 FC Rangers FC Rangers 15 31 37 24
5 Lusitanos Lusitanos 15 48 22 20
6 Inter Club D'Escaldes II Inter Club. 16 28 36 20
7 UE Santa Coloma B Santa Coloma 15 39 49 19
8 Atlètic Amèrica Atlètic 16 30 64 9
9 Carroi II Carroi II 16 25 53 7
10 UE Extremenya Extremenya 15 10 71 3
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Atlètic Escaldes Atlètic 18 82 15 46
2 Carroi Carroi 18 62 22 45
3 La Massana La Massana 18 79 24 40
4 Penya Encarnada Penya 18 53 21 38
5 Inter Club D'Escaldes II Inter Club. 18 43 30 25
6 UE Santa Coloma B Santa Coloma 18 31 45 22
7 Encamp II Encamp II 18 23 43 20
8 FC Rangers FC Rangers 18 31 74 13
9 UE Extremenya Extremenya 18 30 60 12
10 Sporting Escaldes Sporting 18 20 120 3
11 Jenlai Jenlai 0 0 0 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 FC Ordino FC Ordino 18 81 19 43
2 Atlètic Escaldes Atlètic 18 57 18 43
3 Carroi Carroi 18 66 23 38
4 La Massana La Massana 18 60 35 35
5 UE Santa Coloma B Santa Coloma 18 28 34 21
6 Encamp II Encamp II 18 38 52 21
7 Atlètic Amèrica Atlètic 18 31 52 17
8 Jenlai Jenlai 18 43 67 14
9 FC Rangers FC Rangers 18 23 79 13
10 Lusitanos II Lusitanos 18 25 73 1
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
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
Ver
TEMPORADA 2014/2015
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
Ver
TEMPORADA 2013/2014
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
Ver
TEMPORADA 2012/2013
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
Ver
TEMPORADA 2011/2012
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
Ver
TEMPORADA 2010/2011
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
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Casa Estrella Benfica Casa 14 37 15 32
2 Jenlai Jenlai 14 44 15 31
3 UE Extremenya Extremenya 14 36 16 31
4 Lusitanos II Lusitanos 14 37 11 30
5 FC Rangers FC Rangers 14 28 22 18
6 Atlètic Escaldes Atlètic 14 13 37 6
7 Penya Encarnada Penya 14 13 57 3
8 Principat II Principat 14 17 52 0
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Encamp Encamp 11 42 12 27
2 Atlètic Escaldes Atlètic 11 32 19 23
3 Lusitanos II Lusitanos 10 29 13 19
4 Casa Estrella Benfica Casa 9 21 18 11
5 UE Extremenya Extremenya 9 18 19 11
6 Principat II Principat 10 11 29 7
7 Jenlai Jenlai 10 10 53 1
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 UE Santa Coloma Santa Coloma 15 62 11 41
2 UE Extremenya Extremenya 13 32 11 33
3 Encamp Encamp 15 37 12 30
4 Lusitanos II Lusitanos 15 37 32 19
5 Atlètic Escaldes Atlètic 13 30 25 17
6 Principat II Principat 14 31 35 15
7 FC Rangers II Rangers 14 21 44 14
8 Sporting Escaldes Sporting 14 22 57 9
9 Inter Club D'Escaldes II Inter Club. 15 14 59 8
Ver
TEMPORADA 2006/2007
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 cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,022,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.1090
Total Execution Time  0.1113
  CADENA URL  
/2_nd_division_andorra2022/grupo1/historico
  GET DATOS  
$_GET['/2_nd_division_andorra2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0018  SELECT type FROM routes WHERE alias = '2_nd_division_andorra2022'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_nd_division_andorra' 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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=418 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=418 ORDER BY order_id ASC
0.0021  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 = 64310 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 418 AND group_code = 1 and tables = 1 AND year <= 2022 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 `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.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 `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 = 59739 AND t.round = 14 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 = 50147 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.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 `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 = 45914 AND t.round = 22 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 = 39927 AND t.round = 18 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 = 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.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 `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.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 = 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.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 `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.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 `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.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 `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.0027  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.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 `tables2010` 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 = 8843 AND t.round = 14 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 `tables2009` 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 = 8841 AND t.round = 12 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 `tables2008` 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 = 8839 AND t.round = 16 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 `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
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 11:03: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-03-28 11:03: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=4 AND last_update > '2024-03-28 11:03: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-03-28 11:03:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_nd_division_andorra' 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 = 64310 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64310 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 = 64310 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64310 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 = 64310 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64310 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 = 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