4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Algeti
TEMPORADA 2017/2018
TERCERA GEORGIA
Equipo PJ GF GC Puntos
1 Zugdidi Zugdidi 38 65 31 84
2 Bakhmaro Bakhmaro 38 78 40 79
3 Guria Lanchkhuti Guria 38 59 31 73
4 Saburtalo II Saburtalo 38 60 50 67
5 Kolkheti Khobi Kolkheti 38 54 35 61
6 Aragvi Dusheti Aragvi 38 64 55 61
7 Borjomi Borjomi 38 66 56 61
8 Meshakhte Meshakhte 38 59 54 57
9 Gori FC Gori FC 38 58 48 53
10 Betlemi Betlemi 38 52 58 51
11 Samegrelo Samegrelo 38 63 55 48
12 Chiatura Chiatura 38 39 47 47
13 Varketili Varketili 38 58 58 47
14 Algeti Algeti 38 54 64 46
15 Mark Stars Mark Stars 38 59 65 46
16 Imereti Imereti 38 44 52 45
17 Gardabani Gardabani 38 39 63 39
18 FC Sulori Vani Sulori Vani 38 38 77 36
19 Samgurali II Samgurali 38 40 82 31
20 Matchakhela Matchakhela 38 35 63 28
TEMPORADA 2016/2017
TRANSICIÓN TERCERA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 Chiatura Chiatura 18 32 14 40
2 Imereti Imereti 18 20 10 33
3 Kolkheti Khobi Kolkheti 18 25 18 29
4 Betlemi Betlemi 18 34 20 28
5 Samegrelo Samegrelo 18 20 14 27
6 FC Sulori Vani Sulori Vani 18 20 19 24
7 Margveti Margveti 18 21 28 21
8 FC Skuri Tsalenjikha Skuri 18 16 27 17
9 Lazika Lazika 18 13 27 14
10 Sapovnela Sapovnela 18 7 31 9
11 Shevardeni 1906 Shevardeni 18 36 19 38
12 FC Telavi FC Telavi 18 30 18 35
13 Merani Tbilisi Merani 18 39 24 34
14 Mark Stars Mark Stars 18 31 29 25
15 Gardabani Gardabani 18 26 24 24
16 Gori FC Gori FC 18 26 24 23
17 Borjomi Borjomi 18 16 21 22
18 Algeti Algeti 18 25 27 21
19 Chkherimela Chkherimela 18 18 31 15
20 Liakhvi Tskhinvali Liakhvi 18 17 47 9
TEMPORADA 2015/2016
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Liakhvi Tskhinvali Liakhvi 34 82 36 69
2 WIT Georgia WIT Georgia 34 61 26 64
3 Kolkheti Khobi Kolkheti 34 61 30 64
4 Borjomi Borjomi 34 45 32 61
5 Gagra Gagra 34 54 38 52
6 Samgurali Samgurali 34 60 46 51
7 Lazika Lazika 34 52 58 48
8 FC Rustavi FC Rustavi 34 33 33 43
9 FC Skuri Tsalenjikha Skuri 34 32 33 43
10 Chkherimela Chkherimela 34 39 50 43
11 Meshakhte Meshakhte 34 28 31 42
12 Chiatura Chiatura 34 41 48 42
13 Imereti Imereti 34 34 53 41
14 Betlemi Betlemi 34 42 66 40
15 Samegrelo Samegrelo 34 32 50 38
16 Matchakhela Matchakhela 34 30 43 37
17 Algeti Algeti 34 34 52 34
18 Mertskhali Mertskhali 34 42 77 26
TEMPORADA 2014/2015
SEGUNDA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sapovnela Sapovnela 36 64 28 77
2 Borjomi Borjomi 36 40 43 54
3 Gagra Gagra 36 59 44 51
4 Betlemi Betlemi 36 51 50 49
5 Mertskhali Mertskhali 36 45 68 48
6 Algeti Algeti 36 47 39 47
7 Meshakhte Meshakhte 36 57 55 47
8 Kolkheti Khobi Kolkheti 36 46 48 47
9 FC Skuri Tsalenjikha Skuri 36 47 55 46
10 Dinamo Tbilisi II Dinamo 36 42 68 33
TEMPORADA 2013/2014
SEGUNDA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 Shukura Shukura 24 72 23 57
2 Kolkheti Poti Kolkheti 24 51 13 55
3 Dinamo Tbilisi II Dinamo 24 76 27 49
4 Gagra Gagra 24 44 25 42
5 Sapovnela Sapovnela 24 40 25 41
6 Algeti Algeti 24 38 37 34
7 Meshakhte Meshakhte 24 37 38 32
8 Chkherimela Chkherimela 24 29 54 23
9 Mertskhali Mertskhali 24 29 54 23
10 FC Skuri Tsalenjikha Skuri 24 24 52 22
11 Adeli Adeli 24 28 60 22
12 Imereti Imereti 24 26 56 21
13 FC Telavi FC Telavi 24 27 57 18
TEMPORADA 2012/2013
SEGUNDA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Spartaki Tskhinvali Spartaki 30 82 15 77
2 Locomotive Tbilisi Locomotive 30 70 29 63
3 Shukura Shukura 30 56 25 61
4 Kolkheti Khobi Kolkheti 30 43 28 57
5 Samtredia Samtredia 30 53 37 55
6 Samgurali Samgurali 30 59 48 46
7 Algeti Algeti 30 39 55 33
8 Mertskhali Mertskhali 30 37 52 25
9 Chkherimela Chkherimela 30 34 91 20
10 Liakhvi Achabeti Liakhvi 30 29 74 18
11 Adeli Adeli 30 27 75 15
12 Aeti Sokhumi Aeti Sokhumi 0 0 0 0

  USO DE MEMORIA  
5,411,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5053
Total Execution Time  0.5066
  CADENA URL  
/historico/Algeti/2021
  GET DATOS  
$_GET['/historico/Algeti/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0133  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Algeti' AND l.year = 2021 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17563 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17563 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257  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 = 61879
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17563 AND type_rel = 2
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1504 AND type_rel = 3
0.0129  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '17563' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '17563' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '17563' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0139  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 = 61879 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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=17563 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (67540) 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 = 67540 AND teamId = 17563
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 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 = 61879 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130  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 = '17563' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17563' and rp.type = 4
0.0135  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 = '17563' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  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 events2021 e ON e.player_id = p.id AND e.league_id = 61879 WHERE rp.league_id = 61879 AND rp.teamId = 17563 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.0141  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 events2021 e ON e.player_id = p.id AND e.league_id = 61879 WHERE rp.league_id = 61879 AND rp.teamId = 17563 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 events2021 e ON e.player_id = p.id AND e.league_id = 61879 WHERE rp.league_id = 61879 AND rp.teamId = 17563 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 17563 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  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 = 42880 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39924 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 36088 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 39923 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 `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 = 15751 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 4177 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 3587 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 15183 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 61879 ORDER BY nameShow LIMIT 100