Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Torpedo Kutaisi

Entrenador: Steve Kean

Temporada 2018/2019

TEMPORADA 2018/2019

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	36	70	31	75
2	Dinamo	36	57	31	70
3	Iberia 1999	36	67	36	70
4	Locomotive	36	44	46	55
5	Chikhura	36	48	44	47
6	Torpedo	36	53	54	44
7	Dila Gori	36	40	44	43
8	FC Rustavi	36	40	56	38
9	Sioni	36	38	80	38
10	WIT Georgia	36	15	50	20

TEMPORADA 2017/2018

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Iberia 1999	36	64	29	79
2	Dinamo	36	73	38	69
3	Torpedo	36	66	25	69
4	Chikhura	36	54	33	64
5	Dila Gori	36	60	40	63
6	Locomotive	36	43	55	44
7	FC Rustavi	36	33	44	37
8	Sioni	36	39	65	31
9	Samtredia	36	28	81	21
10	Kolkheti	36	26	76	14

TEMPORADA 2016/2017

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Torpedo	36	59	27	76
2	Dinamo	36	79	29	75
3	Samtredia	36	62	39	68
4	Iberia 1999	36	61	42	60
5	Chikhura	36	47	54	55
6	Locomotive	36	63	53	53
7	Dila Gori	36	41	51	41
8	Dinamo	36	28	60	33
9	Kolkheti	36	31	73	26
10	Shukura	36	35	78	21

TEMPORADA 2015/2016

TRANSICIÓN LIGA GEORGIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Samtredia	12	27	9	27
2	Dinamo	12	20	5	20
3	Iberia 1999	12	17	12	19
4	Kolkheti	12	10	18	18
5	Dila Gori	12	13	12	17
6	Sioni	12	13	19	11
7	Zugdidi	12	5	30	6
8	Chikhura	12	27	11	29
9	Dinamo	12	17	5	23
10	Torpedo	12	16	12	15
11	Locomotive	12	11	18	15
12	Shukura	12	10	13	12
13	Guria	12	8	21	11
14	Spartaki	12	12	21	9

TEMPORADA 2014/2015

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dila Gori	30	50	21	64
2	Dinamo	30	40	24	58
3	Dinamo	30	56	28	58
4	Spartaki	30	47	37	53
5	Chikhura	30	39	36	46
6	Samtredia	30	40	31	45
7	Torpedo	30	39	33	41
8	Shukura	30	36	38	41
9	Guria	30	38	43	39
10	Kolkheti	30	31	31	37
11	Merani	30	29	33	36
12	Zugdidi	30	24	45	33
13	Sioni	30	32	46	32
14	FC Rustavi	30	25	46	26
15	WIT Georgia	30	27	40	26
16	Zestafoni	30	40	61	26

TEMPORADA 2013/2014

LIGA GEORGIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dila Gori	0	0	0	32
2	Torpedo	0	0	0	29
3	WIT Georgia	0	0	0	29
4	Spartaki	0	0	0	20
5	Zugdidi	0	0	0	20
6	Merani	0	0	0	15

TEMPORADA 2012/2013

LIGA GEORGIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dinamo	22	63	19	52
2	Dila Gori	22	36	15	49
3	Torpedo	22	41	18	45
4	Chikhura	22	35	21	43
5	Zestafoni	22	30	20	37
6	Zugdidi	22	27	26	35
7	FC Rustavi	22	21	26	31
8	Merani	22	23	36	23
9	WIT Georgia	22	15	29	22
10	Sioni	22	14	38	18
11	Dinamo	22	22	47	13
12	Kolkheti	22	11	43	4

TEMPORADA 2011/2012

LIGA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Zestafoni	14	28	16	55
2	FC Rustavi	14	21	9	55
3	Torpedo	14	17	13	48
4	Kolkheti	14	17	23	42
5	Dinamo	14	20	15	40
6	Dila Gori	14	22	15	36
7	Merani	14	19	33	23
8	Zugdidi	14	14	34	22

TEMPORADA 2010/2011

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Zestafoni	36	72	19	78
2	Dinamo	36	55	22	72
3	FC Rustavi	36	52	31	66
4	Torpedo	36	31	22	55
5	WIT Georgia	36	35	41	48
6	Baia Zugdidi	36	36	51	44
7	Kolkheti	36	25	47	40
8	Sioni	36	27	45	39
9	Spartaki	36	32	42	32
10	Samtredia	36	27	72	25

TEMPORADA 2009/2010

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Torpedo	28	70	12	70
2	Kolkheti	28	63	21	61
3	Dinamo	28	44	17	53
4	Guria	28	53	32	53
5	Merani	28	44	31	53
6	Chikhura	28	41	28	49
7	IBSU FC	28	45	40	34
8	Merani	28	38	57	32
9	Mertskhali	28	29	45	31
10	Kolkheti	28	36	52	30
11	Chiatura	28	36	58	30
12	Meshakhte	28	36	68	25
13	35-e Skola	28	30	49	24
14	Lagodekhi	28	27	60	23
15	Meskheti	28	26	48	22

TEMPORADA 2008/2009

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Samtredia	30	56	23	66
2	Mglebi	30	58	20	63
3	Merani	30	45	24	60
4	Torpedo	30	32	22	45
5	Kolkheti	30	45	38	45
6	Chiatura	30	38	48	39
7	Dinamo	30	33	42	36
8	Kolkheti	30	30	47	36
9	Guria	30	38	49	35
10	Zestafoni	30	26	47	27
11	Meshakhte	30	20	61	16
12	FC Ameri	30	57	16	68
13	Chikhura	30	56	21	64
14	Dinamo	30	59	25	60
15	Georgia	30	50	18	60
16	Dila Gori	30	48	31	45
17	FC Tbilisi	30	55	46	42
18	Lagodekhi	30	34	55	32
19	Sioni II	30	35	64	30
20	Gagra II	30	38	58	27
21	Merani	30	28	72	16
22	Kakheti	30	20	74	15

TEMPORADA 2007/2008

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Chiatura	27	56	17	67
2	Merani	27	36	25	44
3	Meshakhte	27	39	41	44
4	Zestafoni	27	39	28	40
5	Kolkheti	27	36	33	40
6	Torpedo	27	37	31	39
7	Kolkheti	27	35	27	38
8	Samtredia	27	35	50	32
9	Universiteti	27	24	29	30
10	Racha	27	17	73	8
11	Gagra	27	59	36	54
12	Dinamo	27	41	24	49
13	Georgia	27	41	21	48
14	Meshakre	27	34	22	48
15	Chikhura	27	40	37	43
16	FC Tbilisi	27	35	41	35
17	Kakheti	27	38	41	34
18	FC Ameri II	27	42	44	29
19	Olimpiki	27	38	52	25
20	Merani	27	20	70	10

TEMPORADA 2006/2007

LIGA GEORGIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	FC Rustavi	26	57	9	63
2	Dinamo	26	57	19	62
3	Zestafoni	26	55	11	57
4	FC Ameri	26	53	14	57
5	WIT Georgia	26	40	28	45
6	Sioni	26	28	26	37
7	Torpedo	26	24	35	31
8	Dinamo	26	27	30	30
9	Borjomi	26	29	35	30
10	Locomotive	26	25	34	30
11	Merani	26	20	41	26
12	Chikhura	26	13	46	21
13	Dila Gori	26	21	56	15
14	Kakheti	26	21	86	2

TEMPORADA 2005/2006

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Sioni	30	57	16	73
2	WIT Georgia	30	53	17	68
3	Dinamo	30	61	22	64
4	Zestafoni	30	44	22	61
5	Borjomi	30	50	26	59
6	Dinamo	30	42	21	58
7	FC Ameri	30	32	26	49
8	Locomotive	30	41	48	37
9	Kakheti	30	32	46	34
10	Kolkheti	30	26	36	32
11	Dila Gori	30	35	44	31
12	Torpedo	30	28	42	30
13	FC Tbilisi	30	29	44	29
14	Tskhinvali	30	30	61	27
15	Dinamo	30	26	70	18
16	Spartaki	30	12	57	15

TEMPORADA 2004/2005

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	36	73	27	75
2	Torpedo	36	57	28	73
3	FC Tbilisi	36	60	38	69
4	Locomotive	36	42	24	63
5	Zestafoni	36	38	48	53
6	WIT Georgia	36	54	41	48
7	Sioni	36	35	56	40
8	Dinamo	36	35	33	39
9	Kolkheti	36	32	63	32
10	Dila Gori	36	20	88	10

TEMPORADA 2003/2004

LIGA GEORGIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dinamo	22	49	8	50
2	WIT Georgia	22	38	15	42
3	Sioni	22	31	18	40
4	FC Tbilisi	22	41	26	35
5	Locomotive	22	32	24	34
6	Dila Gori	22	28	20	34
7	Torpedo	22	27	26	34
8	Dinamo	22	26	28	32
9	Kolkheti	22	18	35	24
10	FK Mtskheta	22	25	55	20
11	Lazika	22	14	47	16
12	Mertskhali	22	18	45	10

Competiciones que juega

Grupo 1

Liga Georgia

Pos	Equipos		Pts
1		Dinamo Tbilisi	75
2		Dinamo Batumi	70
3		FC Iberia 1999	70
4		Locomotive Tbilisi	55
5		Chikhura	47
6		Torpedo Kutaisi	44
7		Dila Gori	43
8		FC Rustavi	38
9		Sioni	38
10		WIT Georgia	20

	Eliminatoria Champions/UEFA : Dinamo Tbilisi
	Europa League : Dinamo Batumi, FC Iberia 1999
	Playoff Descenso : FC Rustavi, Sioni
	Descenso : WIT Georgia

RIVALES EN Fase Previa Cham.

RIVALES EN Copa Georgia

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Georgia

RIVALES EN Supercopa Georgi.

USO DE MEMORIA

7,388,432 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2017
Total Execution Time	0.2029

CADENA URL

/historico/Fc-Torpedo-Kutaisi/2019

GET DATOS

$_GET['/historico/Fc-Torpedo-Kutaisi/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (61)

0.0040	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 = 'Fc-Torpedo-Kutaisi' AND l.year = 2019 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.0020	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=9166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=9166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=9166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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=9166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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=9166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=9166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026	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 = 48699
0.0029	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 = 43947
0.0031	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 = 43957
0.0029	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 = 44847
0.0027	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 = 49362
0.0027	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 = 48861
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9166 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9166 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (336573,465124,478253) ORDER BY n.cover_points DESC, update_date DESC
0.0029	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 = '9166' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '9166' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 43947 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 49362 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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 = 43957 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 48699 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 48861 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=9166 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (60348,57379,55077,50131,48861,43947,43475) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 55077 AND teamId = 9166
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 43947 AND teamId = 9166
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 50131 AND teamId = 9166
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 60348 AND teamId = 9166
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 57379 AND teamId = 9166
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 48861 AND teamId = 9166
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 9166
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 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 = 48699 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0048	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 events2019 e ON e.player_id = p.id AND e.league_id = 48699 WHERE rp.league_id = 48699 AND rp.teamId = 9166 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.0042	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 events2019 e ON e.player_id = p.id AND e.league_id = 48699 WHERE rp.league_id = 48699 AND rp.teamId = 9166 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 events2019 e ON e.player_id = p.id AND e.league_id = 48699 WHERE rp.league_id = 48699 AND rp.teamId = 9166 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 9166 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 48699 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 42713 AND t.round = 36 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* `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 = 37977 AND t.round = 36 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* `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 = 15498 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 33343 AND t.round = 14 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* `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 = 4149 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 2882 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 10404 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 10405 AND t.round = 10 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* `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 = 2206 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* `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 = 10407 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* `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 = 10408 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* `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 = 10409 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* `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 = 15188 AND t.round = 30 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* `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 = 15189 AND t.round = 33 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* `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 = 15190 AND t.round = 27 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* `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 = 10421 AND t.round = 26 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* `tables2006` 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 = 10433 AND t.round = 30 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* `tables2005` 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 = 10434 AND t.round = 36 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* `tables2004` 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 = 10435 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 48699 ORDER BY nameShow LIMIT 100

Torpedo Kutaisi

Torpedo Kutaisi

Selecciona un equipo

Competiciones que juega

Liga Georgia

RIVALES EN Fase Previa Cham.

RIVALES EN Copa Georgia

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Georgia

RIVALES EN Supercopa Georgi.