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

Resultados de Fútbol

FC AGMK

Entrenador: Mirdzhalol Kasymov

Temporada 2020/2021

TEMPORADA 2020/2021

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Pakhtakor	26	51	18	60
2	Sogdiana	26	28	15	47
3	FC AGMK	26	34	25	47
4	Nasaf Qarshi	26	42	24	45
5	Bunyodkor	26	43	30	45
6	Navbahor	26	23	19	39
7	Lokomotiv	26	37	32	39
8	Kokand 1912	26	37	36	36
9	Qizilqum	26	26	29	31
10	Surkhon	26	17	43	25
11	Metallurg	26	22	35	25
12	Mash' al	26	21	35	23
13	Andijon	26	22	41	19
14	FK Turon	26	16	37	17

TEMPORADA 2019/2020

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Pakhtakor	26	76	18	65
2	Nasaf Qarshi	26	47	19	53
3	FC AGMK	26	39	28	49
4	Bunyodkor	26	43	36	43
5	Kokand 1912	26	35	28	42
6	Sogdiana	26	34	32	38
7	Metallurg	26	30	30	36
8	Navbahor	26	24	21	35
9	Lokomotiv	26	28	38	35
10	Mash' al	26	23	31	29
11	Qizilqum	26	19	37	25
12	Surkhon	26	17	44	17
13	Andijon	26	16	38	16
14	Buxoro	26	19	50	14

TEMPORADA 2018/2019

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Pakhtakor	26	75	18	69
2	Lokomotiv	26	40	17	49
3	Bunyodkor	26	37	33	43
4	Sogdiana	26	29	29	40
5	Metallurg	26	33	26	35
6	Surkhon	26	26	33	35
7	Nasaf Qarshi	26	34	27	33
8	Navbahor	26	26	23	32
9	FC AGMK	26	36	37	32
10	Andijon	26	23	37	28
11	Kokand 1912	26	31	45	26
12	Buxoro	26	18	37	24
13	Dinamo	26	25	47	24
14	Qizilqum	26	24	48	24

TEMPORADA 2017/2018

LIGA UZBEKISTÁN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nasaf Qarshi	10	17	11	34
2	Qizilqum	10	14	18	31
3	Kokand 1912	10	12	8	28
4	FC AGMK	10	12	13	27
5	Sogdiana	10	10	10	24
6	Neftchi	10	9	14	18

TEMPORADA 2016/2017

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Lokomotiv	30	67	20	70
2	Nasaf Qarshi	30	58	18	62
3	Pakhtakor	30	44	28	57
4	Bunyodkor	30	47	29	52
5	Navbahor	30	40	37	46
6	Buxoro	30	42	40	46
7	Mash' al	30	40	31	44
8	FC AGMK	30	31	32	44
9	Kokand 1912	30	42	47	41
10	Metallurg	30	43	39	40
11	Qizilqum	30	34	40	37
12	Sogdiana	30	33	51	31
13	Dinamo	30	21	35	30
14	Shurtan	30	31	52	27
15	Neftchi	30	26	48	27
16	Obod	30	15	67	11

TEMPORADA 2015/2016

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Lokomotiv	30	77	24	74
2	Nasaf Qarshi	30	60	24	63
3	Bunyodkor	30	46	13	63
4	Buxoro	30	42	27	58
5	Pakhtakor	30	49	30	52
6	Qizilqum	30	41	32	50
7	Metallurg	30	47	34	49
8	Mash' al	30	35	41	38
9	Shurtan	30	43	56	35
10	Sogdiana	30	23	41	34
11	Neftchi	30	28	43	31
12	Kokand 1912	30	31	55	29
13	FC AGMK	30	40	57	26
14	Obod	30	25	51	24
15	Navbahor	30	37	66	23
16	Andijon	30	20	50	23

TEMPORADA 2014/2015

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Pakhtakor	30	66	23	75
2	Lokomotiv	30	66	22	74
3	Nasaf Qarshi	30	46	20	62
4	Bunyodkor	30	44	19	59
5	Neftchi	30	41	30	52
6	FC AGMK	30	53	49	44
7	Mash' al	30	37	42	38
8	Navbahor	30	40	51	37
9	Metallurg	30	44	38	36
10	Qizilqum	30	38	49	34
11	Shurtan	30	42	53	33
12	Kokand 1912	30	31	52	31
13	Andijon	30	27	56	28
14	Buxoro	30	31	53	26
15	Sogdiana	30	31	60	26
16	Dinamo	30	28	48	25

TEMPORADA 2013/2014

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Pakhtakor	26	54	14	72
2	Lokomotiv	26	58	22	64
3	Nasaf Qarshi	26	45	21	55
4	Bunyodkor	26	44	20	51
5	Mash' al	26	37	42	36
6	FC AGMK	26	33	38	31
7	Navbahor	26	38	41	30
8	Neftchi	26	19	26	28
9	Metallurg	26	44	54	28
10	Dinamo	26	25	39	28
11	Qizilqum	26	23	34	27
12	Buxoro	26	23	43	25
13	Sogdiana	26	32	49	24
14	Andijon	26	18	50	12

TEMPORADA 2012/2013

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Bunyodkor	26	59	13	61
2	Lokomotiv	26	63	21	60
3	Nasaf Qarshi	26	64	27	58
4	Pakhtakor	26	45	25	54
5	FC AGMK	26	46	43	40
6	Metallurg	26	36	45	33
7	Buxoro	26	33	44	33
8	Dinamo	26	28	36	32
9	Neftchi	26	28	31	30
10	Sogdiana	26	34	54	28
11	Navbahor	26	30	48	27
12	Qizilqum	26	28	48	25
13	Gulistan	26	28	62	20
14	Shurtan	26	22	47	17

TEMPORADA 2011/2012

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Pakhtakor	26	51	16	59
2	Bunyodkor	26	42	16	57
3	Lokomotiv	26	43	22	49
4	Nasaf Qarshi	26	37	20	49
5	Shurtan	26	38	33	40
6	Neftchi	26	36	29	37
7	Buxoro	26	25	31	35
8	FC AGMK	26	39	46	31
9	Dinamo	26	27	29	29
10	Metallurg	26	32	47	28
11	Qizilqum	26	22	41	27
12	Navbahor	26	19	34	26
13	Mash' al	26	20	43	23
14	Andijon	26	29	53	18

TEMPORADA 2010/2011

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Bunyodkor	26	51	14	61
2	Nasaf Qarshi	26	43	15	53
3	Pakhtakor	26	33	17	51
4	Neftchi	26	36	27	44
5	Mash' al	26	32	33	40
6	Navbahor	26	26	21	36
7	Shurtan	26	29	41	32
8	Metallurg	26	35	42	31
9	Buxoro	26	23	38	31
10	Dinamo	26	23	25	29
11	FC AGMK	26	37	45	29
12	Andijon	26	29	43	28
13	Qizilqum	26	23	40	24
14	Sogdiana	26	32	51	17

TEMPORADA 2009/2010

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Bunyodkor	26	45	10	65
2	Pakhtakor	26	41	19	57
3	Nasaf Qarshi	26	30	20	46
4	Shurtan	26	35	28	42
5	Mash' al	26	22	24	37
6	Metallurg	26	29	31	35
7	Andijon	26	28	29	34
8	Qizilqum	26	25	28	34
9	Navbahor	26	32	32	31
10	Neftchi	26	36	45	29
11	FC AGMK	26	32	41	29
12	Dinamo	26	28	33	27
13	Lokomotiv	26	20	38	23
14	Xorazm	26	21	46	13

TEMPORADA 2008/2009

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Bunyodkor	30	85	13	86
2	Pakhtakor	30	69	16	64
3	Nasaf Qarshi	30	48	27	55
4	FC AGMK	30	50	38	48
5	Neftchi	30	43	38	46
6	Lokomotiv	30	34	40	42
7	Andijon	30	47	48	39
8	Shurtan	30	36	50	39
9	Dinamo	30	44	42	38
10	Xorazm	30	30	39	38
11	Qizilqum	30	33	56	35
12	Metallurg	30	36	49	31
13	Mash' al	30	32	43	30
14	Navbahor	30	21	48	28
15	Buxoro	30	40	59	24
16	Sogdiana	30	24	66	24

TEMPORADA 2007/2008

LIGA UZBEKISTÁN
Equipo		PJ	GF	GC	Puntos
1	Bunyodkor	30	75	13	79
2	Pakhtakor	30	64	14	74
3	Neftchi	30	42	25	60
4	Mash' al	30	38	26	52
5	Andijon	30	35	28	46
6	Dinamo	30	40	39	42
7	Metallurg	30	28	34	42
8	Lokomotiv	30	41	38	37
9	Nasaf Qarshi	30	28	36	35
10	FC AGMK	30	29	34	33
11	Sogdiana	30	32	48	33
12	Shurtan	30	22	44	33
13	Navbahor	30	28	39	32
14	Qizilqum	30	27	44	32
15	Buxoro	30	25	44	26
16	Uz Dong Joo	30	17	65	13

Competiciones que juega

Liga Uzbekistán

Pos	Equipos		Pts
1		Pakhtakor	60
2		Sogdiana	47
3		FC AGMK	47
4		Nasaf Qarshi	45
5		Bunyodkor	45
6		Navbahor	39
7		FK Lokomotiv Tashkent	39
8		Kokand 1912	36
9		Qizilqum	31
10		Surkhon Termez	25
11		Metallurg Bekabad	25
12		Mash' al	23
13		Andijon	19
14		FK Turon	17

	AFC Champions League : Pakhtakor, Sogdiana
	Playoff Descenso : Mash' al
	Descenso : Andijon, FK Turon

RIVALES EN Clasificación AF.

RIVALES EN AFC Champions Le.

RIVALES EN Copa Uzbekistán

RIVALES EN Liga Uzbekistán

USO DE MEMORIA

6,864,584 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.1925
Total Execution Time	0.1946

CADENA URL

/historico/Olmaliq/2021

GET DATOS

$_GET['/historico/Olmaliq/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0037	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 = 'Olmaliq' 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.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=4365 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=4365 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=4365 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=4365 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=4365 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=4365 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 61113
0.0025	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 = 61149
0.0025	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 = 63178
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4365 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=144 AND type_rel = 3
0.0024	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 = '4365' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '4365' 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 = 61147 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 61149 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 = 63178 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 = 61113 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031	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=4365 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (67474,66832,62807,61149,61147) 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 = 66832 AND teamId = 4365
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 61149 AND teamId = 4365
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 61147 AND teamId = 4365
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 67474 AND teamId = 4365
0.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 4365
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 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 = 61113 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '4365' 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 = '4365' and rp.type = 4
0.0022	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 = '4365' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2021 e ON e.player_id = p.id AND e.league_id = 61113 WHERE rp.league_id = 61113 AND rp.teamId = 4365 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.0043	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 = 61113 WHERE rp.league_id = 61113 AND rp.teamId = 4365 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041	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 = 61113 WHERE rp.league_id = 61113 AND rp.teamId = 4365 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 = 4365 AND l.year <= 2021 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* `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 = 61113 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.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* `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 = 55381 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.0074	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 = 49175 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0061	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 = 42702 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* `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 = 48127 AND t.round = 10 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* `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 = 37747 AND t.round = 30 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* `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 = 20226 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 10893 AND t.round = 30 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* `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 = 3765 AND t.round = 26 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* `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 = 2321 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042	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 = 1623 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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 = 1003 AND t.round = 26 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* `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 = 9823 AND t.round = 30 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* `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 = 14827 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 61113 ORDER BY nameShow LIMIT 100


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

FC AGMK

FC AGMK

Selecciona un equipo

Competiciones que juega

Liga Uzbekistán

RIVALES EN Clasificación AF.

RIVALES EN AFC Champions Le.

RIVALES EN Copa Uzbekistán

RIVALES EN Liga Uzbekistán