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

Guria Lanchkhuti

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Gonio	9	23	9	22
2	FC Irao	9	11	6	18
3	Gori FC	9	9	5	15
4	Betlemi	9	12	11	15
5	Locomotive	9	15	15	15
6	Meshakhte	9	12	8	14
7	Merani	9	16	15	12
8	Gardabani	9	11	10	12
9	Zestafoni	9	9	10	12
10	Saburtalo	9	10	9	11
11	Borjomi	9	11	13	10
12	Matchakhela	9	8	16	10
13	Varketili	9	8	10	8
14	Bakhmaro	9	5	8	8
15	Merani	9	7	13	7
16	Guria	9	6	15	6

TEMPORADA 2022/2023

TERCERA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Aragvi	30	66	21	68
2	SFC Shturmi	30	67	27	68
3	FC Rustavi	30	63	31	61
4	Varketili	30	54	35	60
5	Meshakhte	30	49	24	55
6	FC Irao	30	56	41	50
7	Saburtalo	30	45	26	45
8	Gori FC	30	46	48	43
9	Guria	30	44	55	39
10	Locomotive	30	50	42	35
11	Borjomi	30	50	78	35
12	Bakhmaro	30	47	47	33
13	Zestafoni	30	33	46	29
14	Matchakhela	30	38	81	26
15	Merani	30	30	58	22
16	Chikhura	30	23	101	7

TEMPORADA 2021/2022

TERCERA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	30	76	21	71
2	Kolkheti	30	79	30	69
3	Aragvi	30	56	22	58
4	Varketili	30	66	40	54
5	Kolkheti	29	50	31	51
6	Gori FC	30	56	38	48
7	Saburtalo	30	46	42	44
8	Borjomi	30	49	42	41
9	Merani	30	41	51	40
10	Tbilisi City	30	39	48	38
11	FC Irao	30	46	53	37
12	Guria	30	43	53	37
13	Bakhmaro	30	34	43	35
14	Meshakhte	30	29	41	32
15	Zestafoni	30	18	79	15
16	Chiatura	29	19	113	1

TEMPORADA 2020/2021

TERCERA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Spaeri	26	79	20	64
2	Kolkheti	26	54	28	49
3	Tbilisi City	26	46	30	45
4	Varketili	26	43	37	41
5	Aragvi	26	37	32	40
6	Gori FC	26	33	33	38
7	Saburtalo	26	53	36	38
8	Bakhmaro	26	26	33	33
9	Kolkheti	26	32	39	31
10	Meshakhte	26	31	42	30
11	Guria	26	33	44	29
12	Merani	26	33	50	28
13	Chiatura	26	23	46	21
14	Didube 2014	26	25	78	14

TEMPORADA 2019/2020

TERCERA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Gareji	18	33	17	43
2	Kolkheti	18	47	18	38
3	Gori FC	18	22	18	32
4	Spaeri	18	31	20	30
5	Guria	18	26	30	26
6	Kolkheti	18	27	24	22
7	Tbilisi City	18	21	23	21
8	Saburtalo	18	22	31	19
9	Bakhmaro	18	20	33	18
10	Meshakhte	18	10	45	6

TEMPORADA 2018/2019

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Merani	36	87	35	81
2	Samtredia	36	63	28	77
3	FC Telavi	36	70	36	63
4	Shevardeni	36	47	48	52
5	Gagra	36	46	42	47
6	Shukura	36	36	46	46
7	Zugdidi	36	38	54	40
8	Guria	36	39	64	36
9	Kolkheti	36	31	80	34
10	Spartaki	36	38	62	32

TEMPORADA 2017/2018

TERCERA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Zugdidi	38	65	31	84
2	Bakhmaro	38	78	40	79
3	Guria	38	59	31	73
4	Saburtalo	38	60	50	67
5	Kolkheti	38	54	35	61
6	Aragvi	38	64	55	61
7	Borjomi	38	66	56	61
8	Meshakhte	38	59	54	57
9	Gori FC	38	58	48	53
10	Betlemi	38	52	58	51
11	Samegrelo	38	63	55	48
12	Chiatura	38	39	47	47
13	Varketili	38	58	58	47
14	Algeti	38	54	64	46
15	Mark Stars	38	59	65	46
16	Imereti	38	44	52	45
17	Gardabani	38	39	63	39
18	Sulori Vani	38	38	77	36
19	Samgurali	38	40	82	31
20	Matchakhela	38	35	63	28

TEMPORADA 2016/2017

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	FC Rustavi	36	72	25	83
2	Merani	36	67	16	80
3	Sioni	36	52	48	59
4	Gagra	36	46	38	53
5	Samgurali	36	46	46	53
6	WIT Georgia	36	42	40	52
7	Spartaki	36	62	75	40
8	Guria	36	47	68	37
9	Meshakhte	36	33	75	27
10	Zugdidi	36	32	68	25

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 2
Equipo		PJ	GF	GC	Puntos
1	Dinamo	0	0	0	48
2	Zestafoni	0	0	0	40
3	Chikhura	0	0	0	38
4	FC Rustavi	0	0	0	33
5	Guria	0	0	0	33
6	Sioni	0	0	0	33

TEMPORADA 2012/2013

SEGUNDA GEORGIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Guria	33	86	20	85
2	Dinamo	33	100	42	69
3	Sasco	33	84	38	64
4	Gagra	33	63	46	53
5	Meshakhte	33	42	66	45
6	Chiatura	33	39	47	43
7	Imereti	33	37	46	43
8	Sakartvelos	33	63	75	39
9	Skuri	33	33	51	38
10	Betlemi	33	40	76	35
11	Sulori Vani	33	30	72	25
12	Racha	33	39	77	24

TEMPORADA 2011/2012

SEGUNDA GEORGIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chikhura	18	40	6	49
2	Guria	18	41	15	39
3	Imereti	18	31	25	29
4	Skuri	18	25	26	27
5	Zooveti	18	23	29	27
6	Merani	18	30	24	26
7	Samgurali	18	27	23	23
8	Adeli	18	19	36	13
9	Sulori Vani	18	11	35	12
10	Aeti Sokhumi	18	13	41	11

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

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 2006/2007

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Mglebi	34	58	24	76
2	Meskheti	34	69	19	72
3	Gagra	34	52	36	60
4	Georgia	34	60	29	58
5	FC Ameri II	34	58	36	57
6	Chiatura	34	49	32	57
7	Meshakre	34	45	36	55
8	Merani	34	50	49	52
9	Meshakhte	34	53	40	51
10	FC Tbilisi	34	52	47	50
11	Samtredia	34	35	43	47
12	Zestafoni	34	34	40	40
13	Racha	34	41	49	39
14	Dinamo	34	49	40	36
15	Guria	34	36	76	31
16	Chikhura II	34	28	67	29
17	Spartaki	34	19	51	27
18	Mertskhali	34	21	95	14

TEMPORADA 2005/2006

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Chikhura	34	87	34	78
2	Merani	34	59	27	74
3	Gagra	34	49	22	68
4	Dinamo	34	57	27	62
5	Meshakre	34	46	32	59
6	Meskheti	34	50	30	57
7	FC Ameri II	34	40	29	51
8	FC Rustavi	34	50	37	49
9	Guria	34	50	47	47
10	Georgia	34	43	45	45
11	Tbilisi	34	34	40	44
12	Meshakhte	34	38	40	42
13	Zugdidi	34	23	33	41
14	Chiatura	34	38	56	37
15	Zestafoni	34	23	44	36
16	Gareji	34	28	44	31
17	Locomotive	34	22	84	21
18	Liakhvi	34	24	90	13

Competiciones que juega

Tercera Georgia

Pos	Equipos		Pts
1		Gonio	22
2		FC Irao	18
3		Gori FC	15
4		Betlemi	15
5		Locomotive Tbilisi II	15
6		Meshakhte	14
7		Merani Martvili	12
8		Gardabani	12
9		Zestafoni	12
10		Saburtalo II	11
11		Borjomi	10
12		Matchakhela	10
13		Varketili	8
14		Bakhmaro	8
15		Merani Tbilisi	7
16		Guria Lanchkhuti	6

	Ascenso : Gonio, FC Irao
	Playoff Descenso : Gori FC, Betlemi
	Descenso : Bakhmaro, Merani Tbilisi, Guria Lanchkhuti

RIVALES EN Tercera Georgia

USO DE MEMORIA

6,783,584 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7535
Total Execution Time	0.7547

CADENA URL

/historico/Fc-Guria-Lanchkhuti

GET DATOS

$_GET['/historico/Fc-Guria-Lanchkhuti']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

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 = 'Fc-Guria-Lanchkhuti' AND l.year = 2024 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=13613 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=13613 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292	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 = 75454
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13613 AND type_rel = 2
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1618 AND type_rel = 3
0.0147	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1618 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147	SELECT /53 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 (894718,566283) ORDER BY n.cover_points DESC, update_date DESC
0.0162	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 = '13613' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0159	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 = '13613' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	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 = 75454 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	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=13613 AND l.year in (2023,2024,2025) 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 (75454,71651) 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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 75454 AND teamId = 13613
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 71651 AND teamId = 13613
0.0146	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 = '13613' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148	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 = '13613' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 75454 WHERE rp.league_id = 75454 AND rp.teamId = 13613 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 75454 WHERE rp.league_id = 75454 AND rp.teamId = 13613 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 events2024 e ON e.player_id = p.id AND e.league_id = 75454 WHERE rp.league_id = 75454 AND rp.teamId = 13613 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 = 13613 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables2024` 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 = 75454 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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* `tables2023` 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 = 71214 AND t.round = 30 ORDER BY team.conference ASC,t.position 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* `tables2022` 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 = 67095 AND t.round = 30 ORDER BY team.conference ASC,t.position 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* `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 = 61980 AND t.round = 26 ORDER BY team.conference ASC,t.position 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* `tables2020` 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 = 55370 AND t.round = 18 ORDER BY team.conference ASC,t.position 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* `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 = 48700 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167	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.0168	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 = 39909 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* `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.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* `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.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* `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.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* `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.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* `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 = 10403 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* `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.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* `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.0148	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.0148	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.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* `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.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* `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 = 15191 AND t.round = 34 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* `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 = 15192 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Guria Lanchkhuti

Guria Lanchkhuti

Selecciona un equipo

Competiciones que juega

Tercera Georgia

RIVALES EN Tercera Georgia