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

Shevardeni 1906

Temporada 2021/2022

TEMPORADA 2021/2022

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Shukura	28	52	23	60
2	Spaeri	28	57	35	51
3	Samtredia	28	43	28	48
4	Merani	28	55	53	42
5	Gareji	28	38	36	36
6	Merani	28	34	56	34
7	FC Rustavi	28	34	54	23
8	WIT Georgia	28	30	58	21
9	Zugdidi	0	0	0	0
10	Shevardeni	0	0	0	0

TEMPORADA 2020/2021

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Sioni	36	74	36	81
2	Gagra	36	74	27	75
3	Merani	36	65	44	64
4	Gareji	36	52	48	50
5	Merani	36	58	58	47
6	Shevardeni	36	63	58	46
7	Zugdidi	36	47	71	46
8	WIT Georgia	36	38	43	45
9	FC Rustavi	36	46	58	39
10	Chikhura	36	24	98	10

TEMPORADA 2019/2020

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Shukura	18	32	14	31
2	Samgurali	18	23	12	30
3	Gagra	18	24	10	29
4	FC Rustavi	18	35	27	26
5	Zugdidi	18	27	31	25
6	Shevardeni	18	28	38	25
7	Sioni	18	23	16	24
8	Merani	18	23	20	24
9	WIT Georgia	18	17	25	21
10	Aragvi	18	10	49	8

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

SEGUNDA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	36	60	22	76
2	WIT Georgia	36	43	23	65
3	Gagra	36	50	41	58
4	Merani	36	54	47	51
5	FC Telavi	36	45	43	48
6	Shevardeni	36	38	49	43
7	Shukura	36	48	56	41
8	Samgurali	36	40	56	41
9	Spartaki	36	36	66	36
10	Merani	36	36	47	36

TEMPORADA 2016/2017

TRANSICIÓN TERCERA GEORGIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Shevardeni	10	36	2	43
2	FC Telavi	10	41	3	39
3	Merani	10	32	11	39
4	Gardabani	10	32	6	31
5	Mark Stars	10	25	13	24
6	Imereti	10	7	19	21
7	Chiatura	10	7	29	17
8	Betlemi	10	14	33	16
9	Kolkheti	10	4	33	13
10	Samegrelo	10	3	52	8

TEMPORADA 1995/1996

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	30	109	16	79
2	Samtredia	30	96	38	68
3	Margveti	30	85	37	68
4	Kolkheti	30	69	38	68
5	FC Rustavi	30	70	36	66
6	Dinamo	30	68	28	54
7	Torpedo	30	69	49	52
8	Dila Gori	30	53	55	40
9	Sioni	30	38	64	33
10	Iveria	30	33	57	33
11	Zugdidi	30	42	63	30
12	Shevardeni	30	40	61	30
13	Guria	30	35	74	27
14	Kakheti	30	29	68	27
15	Egrisi	30	42	90	17
16	Duruji	30	23	127	4

TEMPORADA 1994/1995

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	30	125	33	78
2	Samtredia	30	75	25	74
3	Kolkheti	30	72	28	63
4	Dinamo	30	69	40	54
5	Zugdidi	30	58	54	46
6	Torpedo	30	58	47	44
7	FC Rustavi	30	48	37	44
8	Dila Gori	30	25	35	37
9	Margveti	30	35	53	36
10	Shevardeni	30	35	48	32
11	Iveria	30	42	58	31
12	Kakheti	30	37	59	31
13	Guria	30	36	81	30
14	Duruji	30	28	65	27
15	Sapovnela	30	34	76	24
16	Samgurali	30	30	68	21

TEMPORADA 1993/1994

LIGA GEORGIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dinamo	18	51	16	48
2	Kolkheti	18	51	20	44
3	Torpedo	18	33	22	31
4	Samtredia	18	31	23	29
5	Dinamo	18	32	24	28
6	Shevardeni	18	28	26	21
7	Guria	18	30	50	17
8	Margveti	18	22	41	15
9	Dila Gori	18	12	35	14
10	Iveria	18	14	47	11

TEMPORADA 1992/1993

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	32	92	35	77
2	Shevardeni	32	66	39	64
3	Alazani	32	70	47	63
4	Samgurali	32	73	51	58
5	Torpedo	32	70	54	52
6	Margveti	32	49	54	50
7	FC Rustavi	32	73	69	49
8	Kakheti	32	50	59	45
9	Kolkheti	32	47	45	42
10	Samtredia	32	33	49	40
11	Dinamo	32	56	56	39
12	Dila Gori	32	39	49	38
13	Guria	32	38	58	38
14	Zugdidi	32	52	68	36
15	Iveria	32	38	62	34
16	Mretebi	32	38	64	33
17	Tskhumi	32	59	84	25
18	Amirani	0	0	0	0
19	Kolkheti	0	0	0	0
20	Mziuri	0	0	0	0

TEMPORADA 1991/1992

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	38	115	41	87
2	Tskhumi	38	96	53	76
3	FC Rustavi	38	71	38	75
4	Guria	38	89	56	69
5	Kolkheti	38	49	45	56
6	Zugdidi	38	56	56	54
7	Margveti	38	60	58	53
8	Mziuri	38	53	65	53
9	Dinamo	38	55	58	51
10	Dila Gori	38	64	64	50
11	Torpedo	38	66	60	49
12	Mretebi	38	48	51	48
13	Samtredia	38	55	62	48
14	Kolkheti	38	57	66	48
15	Samgurali	38	41	55	48
16	Amirani	38	48	56	47
17	Shevardeni	38	56	72	47
18	Alazani	38	45	70	47
19	Sulori Vani	38	53	82	46
20	Mertskhali	38	29	98	18

TEMPORADA 1990/1991

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	19	45	9	47
2	Guria	19	38	15	46
3	Torpedo	19	34	30	35
4	Kolkheti	19	30	19	33
5	Dinamo	19	28	21	32
6	Tskhumi	19	34	26	31
7	Zugdidi	19	33	27	27
8	Margveti	19	32	32	27
9	FC Rustavi	19	34	22	26
10	Alazani	19	28	36	25
11	Dila Gori	19	29	32	24
12	Samgurali	19	21	34	24
13	Shevardeni	19	30	26	22
14	Kolkheti	19	27	30	22
15	Mziuri	19	25	28	22
16	Mertskhali	19	22	31	22
17	Sulori Vani	19	29	41	21
18	Amirani	19	27	37	18
19	Samtredia	19	19	42	18
20	Iveria	19	12	39	14

TEMPORADA 1989/1990

LIGA GEORGIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo	34	91	23	78
2	Guria	34	73	20	72
3	FC Rustavi	34	63	33	69
4	Torpedo	34	62	33	65
5	Kolkheti	34	53	31	62
6	Dinamo	34	56	28	61
7	Tskhumi	34	50	36	49
8	Zugdidi	34	47	38	46
9	Mertskhali	34	49	47	43
10	Dila Gori	34	52	58	42
11	Kolkheti	34	42	43	41
12	Samtredia	34	35	50	40
13	Mziuri	34	47	69	40
14	Samgurali	34	42	57	39
15	Shevardeni	34	39	64	38
16	Iveria	34	34	62	38
17	Amirani	34	36	55	37
18	Spartaki	34	11	135	0

Competiciones que juega

Segunda Georgia

Pos	Equipos		Pts
1		Shukura	60
2		Spaeri	51
3		Samtredia	48
4		Merani Martvili	42
5		Gareji	36
6		Merani Tbilisi	34
7		FC Rustavi	23
8		WIT Georgia	21
9		Zugdidi	0
10		Shevardeni 1906	0

	Ascenso : Shukura
	Playoff Ascenso : Spaeri, Samtredia
	Playoff Descenso : WIT Georgia, Zugdidi
	Descenso : Shevardeni 1906

RIVALES EN Segunda Georgia

USO DE MEMORIA

6,131,704 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.9853
Total Execution Time	0.9865

CADENA URL

/historico/Fc-Shevardeni-1906-Tbilisi

GET DATOS

$_GET['/historico/Fc-Shevardeni-1906-Tbilisi']

POST DATOS

No hay datos POST existentes

CONSULTAS (58)

0.0155	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-Shevardeni-1906-Tbilisi' 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.0166	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-Shevardeni-1906-Tbilisi' 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 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=64144 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0153	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=64144 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151	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=64144 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151	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=64144 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=64144 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0173	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 = 66336
0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64144 AND type_rel = 2
0.0148	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=397 AND type_rel = 3
0.0165	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 = '64144' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0151	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 = '64144' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150	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 = '64144' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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 = 66336 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	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=64144 AND l.year in (2021,2022,2023) 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 (66336,61879,56547) 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 = 66336 AND teamId = 64144
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 61879 AND teamId = 64144
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 64144
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 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 = 66336 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '64144' 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 = '64144' and rp.type = 4
0.0146	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 = '64144' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154	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 events2022 e ON e.player_id = p.id AND e.league_id = 66336 WHERE rp.league_id = 66336 AND rp.teamId = 64144 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.0159	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 events2022 e ON e.player_id = p.id AND e.league_id = 66336 WHERE rp.league_id = 66336 AND rp.teamId = 64144 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 events2022 e ON e.player_id = p.id AND e.league_id = 66336 WHERE rp.league_id = 66336 AND rp.teamId = 64144 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 64144 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 66336 AND t.round = 32 ORDER BY team.conference ASC,t.position 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* `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 = 61399 AND t.round = 36 ORDER BY team.conference ASC,t.position 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* `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 = 55078 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.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* `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.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* `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 = 42858 AND t.round = 36 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 = 36088 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* `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 = 39925 AND t.round = 10 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* `tables1996` 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 = 14466 AND t.round = 30 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* `tables1995` 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 = 14465 AND t.round = 30 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* `tables1994` 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 = 14461 AND t.round = 22 ORDER BY team.conference 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* `tables1994` 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 = 14463 AND t.round = 18 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* `tables1993` 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 = 14460 AND t.round = 36 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* `tables1990` 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 = 14457 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Shevardeni 1906

Shevardeni 1906

Selecciona un equipo

Competiciones que juega

Segunda Georgia

RIVALES EN Segunda Georgia