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

Locomotive Tbilisi

Temporada 2014/2015

TEMPORADA 2014/2015

SEGUNDA GEORGIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Iberia 1999	36	92	25	87
2	Locomotive	36	87	42	68
3	Lazika	36	69	41	66
4	Samgurali	36	76	50	60
5	Chiatura	36	53	52	54
6	Matchakhela	36	48	66	45
7	Sasco	36	61	67	42
8	Chkherimela	36	35	71	40
9	Sakartvelos	36	47	97	35
10	Adeli	36	37	94	22

TEMPORADA 2013/2014

SEGUNDA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Samtredia	26	64	24	65
2	Dinamo	26	65	17	59
3	Matchakhela	26	44	21	54
4	Sasco	26	50	30	49
5	Locomotive	26	68	35	47
6	Chiatura	26	44	46	40
7	Samgurali	26	49	49	39
8	Iberia 1999	26	38	34	32
9	Kolkheti	26	31	54	30
10	Sakartvelos	26	43	63	24
11	Betlemi	26	28	50	24
12	Bakhmaro	26	35	65	23
13	Dila II	26	27	53	21
14	Sulori Vani	26	14	59	9

TEMPORADA 2012/2013

SEGUNDA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Spartaki	30	82	15	77
2	Locomotive	30	70	29	63
3	Shukura	30	56	25	61
4	Kolkheti	30	43	28	57
5	Samtredia	30	53	37	55
6	Samgurali	30	59	48	46
7	Algeti	30	39	55	33
8	Mertskhali	30	37	52	25
9	Chkherimela	30	34	91	20
10	Liakhvi	30	29	74	18
11	Adeli	30	27	75	15
12	Aeti Sokhumi	0	0	0	0

TEMPORADA 2011/2012

SEGUNDA GEORGIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dinamo	18	28	9	42
2	Mertskhali	18	24	17	38
3	Chiatura	18	30	16	37
4	Chkherimela	18	24	24	28
5	Sakartvelos	18	39	42	26
6	Locomotive	18	30	28	20
7	Kolkheti	18	18	19	20
8	Meskheti	18	19	25	17
9	Samtredia	18	15	30	14
10	Meshakhte	18	16	33	10

TEMPORADA 2010/2011

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Gagra	32	73	19	75
2	Merani	32	60	15	73
3	Dila Gori	32	58	21	69
4	Chikhura	32	58	25	66
5	Dinamo	32	66	18	63
6	Kolkheti	32	28	34	46
7	Guria	32	50	59	46
8	Imereti	32	36	43	37
9	Chkherimela	32	35	45	35
10	Meshakhte	32	32	48	35
11	Merani	32	39	58	35
12	Adeli	32	38	54	32
13	Mertskhali	32	41	68	32
14	Samgurali	32	38	64	30
15	Skuri	32	28	52	29
16	Chiatura	32	28	69	29
17	Locomotive	32	30	46	28

TEMPORADA 2009/2010

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	FC Rustavi	36	70	24	83
2	Dinamo	36	62	19	74
3	Zestafoni	36	59	31	68
4	WIT Georgia	36	48	31	64
5	Spartaki	36	44	58	43
6	Sioni	36	27	43	38
7	Samtredia	36	43	68	37
8	Baia Zugdidi	36	29	48	32
9	Locomotive	36	19	50	26
10	Gagra	36	30	59	24

TEMPORADA 2008/2009

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	WIT Georgia	30	57	19	69
2	Dinamo	30	70	21	63
3	FC Rustavi	30	40	20	57
4	Zestafoni	30	43	27	52
5	Sioni	30	35	29	44
6	Locomotive	30	35	33	38
7	Mglebi	30	36	41	36
8	Meskheti	30	23	42	29
9	Gagra	30	23	48	28
10	Spartaki	30	28	46	25
11	Borjomi	30	21	85	13

TEMPORADA 2007/2008

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	26	67	18	70
2	WIT Georgia	26	45	14	60
3	Zestafoni	26	56	16	59
4	FC Rustavi	26	26	16	52
5	FC Ameri	26	48	27	48
6	Meskheti	26	29	30	39
7	Mglebi	26	27	33	33
8	Sioni	26	34	35	32
9	Borjomi	26	32	39	31
10	Locomotive	26	27	35	27
11	Spartaki	26	15	28	23
12	Merani	26	15	54	19
13	Dinamo	26	16	51	16
14	Dila Gori	26	12	53	8

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 2
Equipo		PJ	GF	GC	Puntos
1	Sioni	10	14	5	41
2	WIT Georgia	10	10	3	41
3	Dinamo	10	15	10	40
4	FC Tbilisi	10	12	8	32
5	Locomotive	10	6	11	25
6	Dila Gori	10	2	22	19

TEMPORADA 2002/2003

LIGA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dinamo	10	17	7	48
2	Torpedo	10	15	5	46
3	WIT Georgia	10	10	7	41
4	Locomotive	10	16	10	38
5	Sioni	10	9	20	23
6	Kolkheti	10	5	23	20

TEMPORADA 2001/2002

LIGA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Torpedo	10	12	5	48
2	Locomotive	10	18	6	47
3	Dinamo	10	20	1	44
4	Kolkheti	10	9	16	26
5	Dinamo	10	5	19	23
6	Merani	10	7	24	23

TEMPORADA 2000/2001

LIGA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Torpedo	10	15	7	20
2	WIT Georgia	10	14	9	16
3	Dinamo	10	13	9	14
4	Locomotive	10	8	9	13
5	Kolkheti	10	10	16	9
6	Merani	10	2	12	7

Competiciones que juega

Segunda Georgia Grupo 1

Pos	Equipos		Pts
1		FC Iberia 1999	87
2		Locomotive Tbilisi	68
3		Lazika	66
4		Samgurali	60
5		Chiatura	54
6		Matchakhela	45
7		Sasco Tiblisi	42
8		Chkherimela	40
9		Sakartvelos TU	35
10		Adeli	22

RIVALES EN Copa Georgia

RIVALES EN Segunda Georgia

USO DE MEMORIA

6,304,232 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1609
Total Execution Time	0.1623

CADENA URL

/historico/Lokomotivi-Tbilisi/2015

GET DATOS

$_GET['/historico/Lokomotivi-Tbilisi/2015']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

0.0047	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 = 'Lokomotivi-Tbilisi' AND l.year = 2015 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.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=17555 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=17555 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=17555 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=17555 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 14777
0.0024	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 = 9121
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17555 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17555 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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 (19564,871704,880849,887653,887820) 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 = '17555' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '17555' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 9121 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 = 14777 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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=17555 AND l.year in (2014,2015,2016) 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 (33349,33343,21290,20315,16245,15498,14777) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 15498 AND teamId = 17555
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 33343 AND teamId = 17555
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 14777 AND teamId = 17555
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 33349 AND teamId = 17555
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 21290 AND teamId = 17555
0.0047	SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 17555
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 20315 AND teamId = 17555
0.0022	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 = '17555' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17555' and rp.type = 4
0.0021	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 = '17555' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040	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 events2015 e ON e.player_id = p.id AND e.league_id = 4175 WHERE rp.league_id = 4175 AND rp.teamId = 17555 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.0032	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 events2015 e ON e.player_id = p.id AND e.league_id = 4175 WHERE rp.league_id = 4175 AND rp.teamId = 17555 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 events2015 e ON e.player_id = p.id AND e.league_id = 4175 WHERE rp.league_id = 4175 AND rp.teamId = 17555 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 17555 AND l.year <= 2015 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 4175 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* `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 = 3586 AND t.round = 26 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* `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.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* `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.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* `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 = 15184 AND t.round = 18 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* `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.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* `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 = 10410 AND t.round = 36 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* `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 = 10411 AND t.round = 33 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 = 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.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* `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.0020	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 = 10436 AND t.round = 10 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* `tables2003` 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 = 14480 AND t.round = 22 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* `tables2003` 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 = 14481 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* `tables2002` 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 = 14477 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables2002` 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 = 14478 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* `tables2001` 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 = 14474 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* `tables2001` 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 = 14475 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Locomotive Tbilisi

Locomotive Tbilisi

Selecciona un equipo

Competiciones que juega

Segunda Georgia Grupo 1

RIVALES EN Copa Georgia

RIVALES EN Segunda Georgia