4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Lernayin Lernayin 28 65 12 73
2 Shirak Shirak 28 83 19 69
3 Gandzasar Gandzasar 28 38 47 37
4 Pyunik II Pyunik II 28 57 54 34
5 Ararat-Armenia II Ararat-Armen 28 33 42 31
6 Urartu II Urartu II 28 39 51 29
7 BKMA II BKMA II 28 35 58 29
8 Alashkert II Alashkert 28 24 91 12
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 BKMA BKMA 29 93 23 71
2 Sevan FC Sevan FC 27 75 23 68
3 West Armenia West Armenia 29 80 38 56
4 Noravank Noravank 28 47 33 51
5 Lernayin Lernayin 29 43 53 44
6 Urartu II Urartu II 29 45 54 39
7 Ararat II Ararat II 28 45 56 35
8 Pyunik II Pyunik II 29 29 74 24
9 Ararat-Armenia II Ararat-Armen 28 30 63 20
10 Shirak II Shirak II 27 21 68 17
11 Alashkert II Alashkert 13 12 35 3
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 FC Van FC Van 28 90 18 70
2 Lokomotiv Yerevan Lokomotiv 27 76 23 70
3 West Armenia West Armenia 27 80 37 66
4 BKMA BKMA 27 63 35 50
5 Ararat-Armenia II Ararat-Armen 27 75 47 48
6 Alashkert II Alashkert 27 69 39 47
7 Sevan FC Sevan FC 28 52 42 47
8 Urartu II Urartu II 28 72 40 45
9 Ararat II Ararat II 27 60 52 40
10 Aragats Aragats 28 56 71 27
11 Torpedo Yerevan Torpedo 28 48 92 27
12 Shirak II Shirak II 29 37 73 24
13 Lernayin Lernayin 24 43 44 23
14 Ani Yerevan Ani Yerevan 27 31 108 20
15 Masis Masis 27 44 82 20
16 Dilijan Dilijan 26 36 97 19
17 Pyunik II Pyunik II 27 44 76 17
18 Makaravank Makaravank 0 0 0 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Sevan FC Sevan FC 33 90 26 81
2 Urartu II Urartu II 34 65 31 71
3 Patani Yerevan Patani 33 112 46 70
4 Ararat-Armenia II Ararat-Armen 33 71 41 61
5 Lokomotiv Yerevan Lokomotiv 34 61 37 56
6 Alashkert II Alashkert 33 63 39 55
7 Pyunik II Pyunik II 33 48 57 40
8 Shirak II Shirak II 33 38 56 37
9 Banants III Banants III 33 38 57 33
10 Gandzasar II Gandzasar 33 43 94 27
11 Ararat II Ararat II 33 40 94 25
12 Erebuni FC Erebuni FC 33 12 103 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 FC Lori FC Lori 27 74 16 69
2 Noah Noah 26 74 16 62
3 Ararat-Armenia Ararat-Armen 27 65 41 46
4 Urartu II Urartu II 27 45 42 45
5 Pyunik II Pyunik II 27 49 44 40
6 Alashkert II Alashkert 27 48 42 40
7 Ararat II Ararat II 27 36 55 25
8 Erebuni FC Erebuni FC 27 33 91 22
9 Gandzasar II Gandzasar 27 31 74 20
10 Shirak II Shirak II 26 22 56 18
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Urartu II Urartu II 24 63 23 55
2 Pyunik II Pyunik II 24 65 28 47
3 Ararat II Ararat II 24 36 20 42
4 Gandzasar II Gandzasar 24 33 37 38
5 Alashkert II Alashkert 24 25 40 22
6 Shirak II Shirak II 24 23 46 21
7 Erebuni FC Erebuni FC 24 20 71 9
8 Kotayk Kotayk 0 0 0 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Alashkert II Alashkert 28 65 22 69
2 Mika II Mika II 28 50 28 54
3 Urartu II Urartu II 28 67 30 48
4 Pyunik II Pyunik II 28 55 45 44
5 Ararat II Ararat II 28 37 39 41
6 Shirak II Shirak II 28 47 48 38
7 Gandzasar II Gandzasar 28 25 80 19
8 Ulisses II Ulisses II 28 34 88 11
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Alashkert II Alashkert 28 83 27 63
2 Urartu II Urartu II 28 73 30 60
3 Pyunik II Pyunik II 28 55 39 52
4 Ararat II Ararat II 28 56 63 37
5 Gandzasar II Gandzasar 28 36 77 27
6 Shirak II Shirak II 28 36 49 26
7 Ulisses II Ulisses II 28 49 86 26
8 Mika II Mika II 28 43 60 25
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Urartu II Urartu II 28 59 34 56
2 Alashkert II Alashkert 28 58 33 52
3 Ararat II Ararat II 28 60 47 45
4 Pyunik II Pyunik II 28 48 42 43
5 Gandzasar II Gandzasar 29 48 48 39
6 Shengavit Shengavit 29 45 52 35
7 Shirak II Shirak II 28 34 49 32
8 Mika II Mika II 29 40 62 31
9 Banants III Banants III 29 57 82 24
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Alashkert Alashkert 36 80 31 78
2 Pyunik II Pyunik II 36 69 53 61
3 Mika II Mika II 36 60 51 61
4 Gandzasar II Gandzasar 36 76 59 60
5 Ararat II Ararat II 36 60 51 57
6 Urartu II Urartu II 36 57 47 54
7 Shengavit Shengavit 36 46 57 46
8 Shirak II Shirak II 36 49 54 41
9 King Deliux King Deliux 36 44 79 33
10 Impuls II Impuls II 36 46 105 20
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Shengavit Shengavit 24 53 24 53
2 Mika II Mika II 24 51 19 46
3 Pyunik II Pyunik II 24 44 30 39
4 Shirak II Shirak II 24 29 25 37
5 Gandzasar II Gandzasar 24 48 42 36
6 Impuls II Impuls II 24 38 40 35
7 Urartu II Urartu II 24 35 35 34
8 Pyunik III Pyunik III 24 27 61 19
9 Ararat II Ararat II 24 15 64 8
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Ararat Yerevan Ararat 22 48 18 52
2 Urartu II Urartu II 21 49 33 44
3 Pyunik II Pyunik II 21 41 20 41
4 Gandzasar II Gandzasar 22 33 18 40
5 Shengavit Shengavit 21 37 38 25
6 Mika II Mika II 21 24 41 20
7 Impuls II Impuls II 21 21 34 19
8 Pyunik III Pyunik III 22 21 48 17
9 Shirak II Shirak II 21 17 41 14
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Impuls Impuls 22 55 18 57
2 Shengavit Shengavit 21 52 28 43
3 Pyunik II Pyunik II 21 49 25 36
4 Urartu II Urartu II 21 37 21 33
5 Mika II Mika II 22 32 30 32
6 Gandzasar II Gandzasar 21 34 42 26
7 Pyunik III Pyunik III 21 32 52 23
8 Shirak II Shirak II 22 19 53 15
9 Banants III Banants III 21 16 57 9
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Shengavit Shengavit 28 57 19 60
2 Pyunik II Pyunik II 27 47 40 46
3 Urartu II Urartu II 28 62 52 45
4 Mika II Mika II 28 31 26 42
5 Gandzasar II Gandzasar 28 50 45 41
6 Ararat II Ararat II 27 29 36 28
7 Shirak II Shirak II 29 26 56 24
8 Patani Yerevan Patani 29 33 61 19
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Pyunik II Pyunik II 21 54 19 44
2 Mika II Mika II 21 42 23 39
3 Ararat II Ararat II 21 43 26 34
4 Dinamo Yerevan Dinamo 21 47 38 33
5 Urartu II Urartu II 21 35 38 28
6 Gandzasar II Gandzasar 21 26 37 28
7 Shirak II Shirak II 21 23 44 19
8 Patani Yerevan Patani 21 19 64 7

  USO DE MEMORIA  
5,864,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1268
Total Execution Time  0.1288
  CADENA URL  
/armenia_primera_liga2022/grupo1/historico
  GET DATOS  
$_GET['/armenia_primera_liga2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0020  SELECT type FROM routes WHERE alias = 'armenia_primera_liga2022'
0.0062  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'armenia_primera_liga' 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.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1426 AND type_rel = 3
0.0020  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1426 ORDER BY order_id ASC
0.0024  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 = 63426 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1426 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 63426 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 57833 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 50433 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 44603 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 39926 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 34031 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 15720 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 8462 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 8899 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 8898 AND t.round = 36 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 = 8896 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 8894 AND t.round = 24 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 `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 = 8892 AND t.round = 24 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 = 8891 AND t.round = 28 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 `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 = 8889 AND t.round = 21 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-24 15:48:48' 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-24 15:48:48' 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=4 AND last_update > '2024-04-24 15:48:48' 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-04-24 15:48:48' 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 = 'armenia_primera_liga' 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.0082  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 = 63426 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63426 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.0059  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 = 63426 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63426 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0023  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 = 63426 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63426 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0026  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 = 63426 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC