4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Skuri Tsalenjikha
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
TRANSICIÓN SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 FC Rustavi FC Rustavi 15 40 12 38
2 WIT Georgia WIT Georgia 16 34 14 36
3 Merani Martvili Merani 15 31 8 32
4 Samgurali Samgurali 16 29 24 32
5 Gagra Gagra 16 29 21 31
6 Meshakhte Meshakhte 16 25 12 29
7 Borjomi Borjomi 16 22 17 25
8 FC Sulori Vani Sulori Vani 16 20 21 24
9 Chiatura Chiatura 16 15 21 23
10 Lazika Lazika 16 31 32 22
11 FC Skuri Tsalenjikha Skuri 16 32 24 21
12 Kolkheti Khobi Kolkheti 16 20 24 21
13 Sapovnela Sapovnela 16 14 18 19
14 Imereti Imereti 13 20 20 15
15 Liakhvi Tskhinvali Liakhvi 15 16 36 10
16 Mark Stars Mark Stars 15 15 31 6
17 Chkherimela Chkherimela 15 13 42 6
18 Gardabani Gardabani 16 13 42 4
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 1
Equipo PJ GF GC Puntos
1 Guria Lanchkhuti Guria 33 86 20 85
2 Dinamo Tbilisi II Dinamo 33 100 42 69
3 Sasco Tiblisi Sasco 33 84 38 64
4 Gagra Gagra 33 63 46 53
5 Meshakhte Meshakhte 33 42 66 45
6 Chiatura Chiatura 33 39 47 43
7 Imereti Imereti 33 37 46 43
8 Sakartvelos TU Sakartvelos 33 63 75 39
9 FC Skuri Tsalenjikha Skuri 33 33 51 38
10 Betlemi Betlemi 33 40 76 35
11 FC Sulori Vani Sulori Vani 33 30 72 25
12 Racha Ambrolauri Racha 33 39 77 24
TEMPORADA 2011/2012
SEGUNDA GEORGIA GRUPO 3
Equipo PJ GF GC Puntos
1 Chiatura Chiatura 14 22 18 37
2 Kolkheti Khobi Kolkheti 14 20 8 34
3 Samtredia Samtredia 14 15 4 33
4 Samgurali Samgurali 14 19 8 31
5 FC Skuri Tsalenjikha Skuri 14 10 14 27
6 Meskheti Akhaltsikhe Meskheti 14 6 11 25
7 Zooveti Tbilisi Zooveti 14 10 24 25
8 Aeti Sokhumi Aeti Sokhumi 14 8 23 7
9 Merani Tbilisi Merani 14 33 22 44
10 Imereti Imereti 14 27 18 39
11 Sakartvelos TU Sakartvelos 14 34 30 35
12 Meshakhte Meshakhte 14 30 15 30
13 Chkherimela Chkherimela 14 19 15 30
14 Locomotive Tbilisi Locomotive 14 19 23 26
15 FC Sulori Vani Sulori Vani 14 13 32 13
16 Adeli Adeli 14 17 37 10
TEMPORADA 2010/2011
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Gagra Gagra 32 73 19 75
2 Merani Martvili Merani 32 60 15 73
3 Dila Gori Dila Gori 32 58 21 69
4 Chikhura Chikhura 32 58 25 66
5 Dinamo Batumi Dinamo 32 66 18 63
6 Kolkheti Khobi Kolkheti 32 28 34 46
7 Guria Lanchkhuti Guria 32 50 59 46
8 Imereti Imereti 32 36 43 37
9 Chkherimela Chkherimela 32 35 45 35
10 Meshakhte Meshakhte 32 32 48 35
11 Merani Tbilisi Merani 32 39 58 35
12 Adeli Adeli 32 38 54 32
13 Mertskhali Mertskhali 32 41 68 32
14 Samgurali Samgurali 32 38 64 30
15 FC Skuri Tsalenjikha Skuri 32 28 52 29
16 Chiatura Chiatura 32 28 69 29
17 Locomotive Tbilisi Locomotive 32 30 46 28
TEMPORADA 1999/2000
SEGUNDA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Margveti Margveti 22 71 18 58
2 Okeane Okeane 22 51 23 45
3 Samtredia II Samtredia 22 47 26 42
4 FC Metalurgi Zestafoni Metalurgi 22 42 27 41
5 Torpedo Kutaisi II Torpedo 22 34 30 33
6 Gagra Gagra 22 31 37 26
7 Racha Ambrolauri Racha 22 31 37 25
8 Guria Lanchkhuti Guria 22 36 45 22
9 Rtsmena Rtsmena 22 16 29 22
10 FC Sulori Vani Sulori Vani 22 30 54 21
11 Chiatura Chiatura 22 28 47 15
12 Meshakhte Meshakhte 22 24 68 13
13 Shukura Shukura 22 66 20 56
14 Dinamo Zugdidi Dinamo 22 65 21 51
15 Megri Megri 22 40 17 50
16 Kolkheti Poti II Kolkheti 22 34 15 46
17 Lazika Lazika 22 56 24 41
18 Pazisi Poti Pazisi Poti 22 36 37 33
19 FC Skuri Tsalenjikha Skuri 22 26 52 21
20 Dinamo Batumi II Dinamo 22 26 38 20
21 Samegrelo Samegrelo 22 23 43 20
22 Mertskhali Mertskhali 22 20 43 16
23 Chela Chela 22 19 56 10
24 Bakhmaro Bakhmaro 22 18 63 8

  USO DE MEMORIA  
5,735,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.6301
Total Execution Time  0.6318
  CADENA URL  
/historico/Skuri/2021
  GET DATOS  
$_GET['/historico/Skuri/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0158  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 = 'Skuri' 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=17570 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17570 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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=17570 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 = '17570' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '17570' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '17570' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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.0151  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=17570 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0146  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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 67540 AND teamId = 17570
0.0149  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.0153  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 = '17570' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17570' 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 = '17570' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 17570 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.0149  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 = 17570 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 = 17570 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 17570 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0150  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.0149  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.0151  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 = 33771 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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.0166  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.0155  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 = 15182 AND t.round = 33 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 `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 = 15185 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 15186 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 15187 AND t.round = 34 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 `tables2000` 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 = 15203 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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