4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Samgurali II
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
TERCERA GEORGIA GRUPO 3
Equipo PJ GF GC Puntos
1 Margveti Margveti 12 28 5 28
2 Sairme Sairme 12 30 7 27
3 Torpedo Kutaisi II Torpedo 12 30 13 21
4 Racha Ambrolauri Racha 12 20 21 17
5 Samgurali II Samgurali 12 16 20 13
6 Imereti II Imereti II 12 10 29 9
7 Meshakhte II Meshakhte 12 8 47 3
8 Betlemi Betlemi 14 45 15 34
9 Mertskhali Mertskhali 14 29 15 32
10 Salkhino Martvili Salkhino 14 27 13 24
11 Lesitchine Lesitchine 14 25 16 23
12 Matchakhela Matchakhela 14 25 23 22
13 Egrisi Egrisi 14 15 23 17
14 Chela Chela 14 14 48 6
15 Kolkheti Khobi II Kolkheti 14 14 41 3
16 Samegrelo Samegrelo 12 37 12 31
17 Bakhmaro Bakhmaro 12 33 19 28
18 Khikhani Khikhani 12 28 16 24
19 Dinamo Batumi II Dinamo 12 28 25 14
20 Zana Abasha Zana Abasha 12 24 29 9
21 Lazika II Lazika II 12 15 42 8
22 Enguri Jvari Enguri Jvari 12 11 33 6
TEMPORADA 2015/2016
TERCERA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Sulori Vani Sulori Vani 26 77 13 72
2 Margveti Margveti 26 80 23 66
3 Sairme Sairme 26 69 15 64
4 Khikhani Khikhani 26 71 28 51
5 Egrisi Egrisi 26 55 34 46
6 Bakhmaro Bakhmaro 26 48 38 43
7 Mertskhali II Mertskhali 26 46 59 30
8 Racha Ambrolauri Racha 26 50 58 29
9 Kolkheti Khobi II Kolkheti 26 30 61 27
10 Zana Abasha Zana Abasha 26 28 64 26
11 Samgurali II Samgurali 26 44 50 25
12 Meshakhte II Meshakhte 26 33 61 22
13 Imereti II Imereti II 26 24 78 15
14 Samegrelo II Samegrelo 26 30 103 12
TEMPORADA 2014/2015
TERCERA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Imereti Imereti 28 89 11 75
2 FC Sulori Vani Sulori Vani 28 87 10 75
3 Sairme Sairme 28 59 30 60
4 Samegrelo Samegrelo 28 58 37 51
5 Kolkheti Khobi II Kolkheti 28 52 45 51
6 Bakhmaro Bakhmaro 28 53 48 46
7 Margveti Margveti 28 54 46 44
8 Egrisi Egrisi 28 55 57 39
9 Racha Ambrolauri Racha 28 42 39 37
10 Sapovnela II Sapovnela 28 58 71 36
11 Odishi Zugdidi 1919 Odishi 28 47 44 30
12 Samgurali II Samgurali 28 37 58 30
13 Martve Kutaisi Martve 28 35 79 20
14 Mertskhali II Mertskhali 28 36 76 12
15 SSS Chiatura II Chiatura 28 9 120 0

  USO DE MEMORIA  
5,224,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5093
Total Execution Time  0.5106
  CADENA URL  
/historico/Samgurali-Ii/2021
  GET DATOS  
$_GET['/historico/Samgurali-Ii/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0156  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 = 'Samgurali-Ii' 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.0145  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=61402 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=61402 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61402 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1504 AND type_rel = 3
0.0149  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 = '61402' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '61402' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '61402' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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.0147  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=61402 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0145  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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 67540 AND teamId = 61402
0.0146  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.0148  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 = '61402' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61402' and rp.type = 4
0.0147  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 = '61402' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0155  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 = 61402 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.0150  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 = 61402 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 61402 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 61402 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0156  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.0157  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 = 36090 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 15920 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 9438 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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