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

Ordabasy

Entrenador: Aleksandr Sednev

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	FC Aktobe	5	11	5	10
2	Astana	6	8	4	10
3	Zhetysu	5	4	3	10
4	Ordabasy	6	10	5	9
5	Tobol	5	9	5	9
6	Kyzylzhar	6	9	5	8
7	Yelimay	5	5	5	8
8	Kairat	6	5	6	8
9	Atyrau	6	5	4	7
10	Zhenis	6	3	10	7
11	Turan	6	2	6	4
12	Kaysar	5	3	8	4
13	Shakhter	5	1	9	3

TEMPORADA 2022/2023

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Ordabasy	26	48	21	58
2	Astana	26	36	24	53
3	FC Aktobe	26	44	23	50
4	Kairat	26	44	32	44
5	Kyzylzhar	26	25	23	39
6	Kaysar	26	31	30	36
7	Atyrau	26	24	27	34
8	Tobol	26	29	33	34
9	Maktaaral	26	29	32	29
10	Shakhter	26	31	36	29
11	Zhetysu	26	27	38	29
12	Okzhetpes	26	26	37	27
13	Kaspiy Aktau	26	28	44	20
14	Aksu	26	23	45	18

TEMPORADA 2021/2022

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Astana	26	65	24	53
2	FC Aktobe	26	43	28	52
3	Tobol	26	46	33	47
4	Kairat	26	34	36	42
5	Ordabasy	26	36	39	38
6	Aksu	26	32	37	36
7	Shakhter	26	34	35	32
8	Maktaaral	26	28	38	31
9	Kaspiy Aktau	26	26	42	31
10	Kyzylzhar	26	33	32	30
11	Atyrau	26	30	39	29
12	Taraz	26	27	29	28
13	Turan	26	25	35	28
14	Akzhayik	26	19	31	25

TEMPORADA 2020/2021

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Tobol	26	54	18	61
2	Astana	26	53	25	57
3	Kairat	26	52	21	51
4	Kyzylzhar	26	32	24	39
5	Ordabasy	26	36	35	38
6	FC Aktobe	26	35	40	33
7	Shakhter	26	25	34	33
8	Kaspiy Aktau	26	35	35	32
9	Akzhayik	26	25	31	32
10	Taraz	26	27	34	29
11	Atyrau	26	25	40	28
12	Turan	26	22	40	26
13	Kaysar	26	24	44	19
14	Zhetysu	26	23	47	16

TEMPORADA 2019/2020

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Kairat	20	48	19	45
2	Tobol	20	26	16	38
3	Astana	20	32	21	36
4	Shakhter	20	29	22	32
5	Ordabasy	20	27	26	31
6	Zhetysu	20	27	28	28
7	Kaysar	20	20	23	24
8	Taraz	20	19	23	23
9	Kyzylzhar	20	15	24	23
10	Kaspiy Aktau	20	15	34	17
11	Okzhetpes	20	16	38	11
12	Irtysh	0	0	0	0

TEMPORADA 2018/2019

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Astana	33	67	28	69
2	Kairat	33	65	32	68
3	Ordabasy	33	52	24	65
4	Tobol	33	45	27	63
5	Zhetysu	33	45	25	56
6	Kaysar	33	37	43	42
7	Okzhetpes	33	44	49	40
8	Irtysh	33	30	45	37
9	Shakhter	33	40	47	35
10	Taraz	33	28	60	29
11	Atyrau	33	25	58	26
12	FC Aktobe	33	35	75	15

TEMPORADA 2017/2018

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Astana	33	66	22	77
2	Kairat	33	60	33	62
3	Tobol	33	36	30	53
4	Ordabasy	33	38	44	46
5	Kaysar	33	35	31	45
6	Zhetysu	33	36	40	43
7	FC Aktobe	33	51	47	42
8	Shakhter	33	29	36	36
9	Atyrau	33	34	47	36
10	Irtysh	33	28	45	35
11	Kyzylzhar	33	27	48	35
12	Akzhayik	33	31	48	30

TEMPORADA 2016/2017

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Astana	33	74	21	79
2	Kairat	33	75	28	78
3	Ordabasy	33	44	37	58
4	Irtysh	33	35	32	48
5	Tobol	33	36	26	47
6	Kaysar	33	30	36	42
7	Shakhter	33	36	50	40
8	Atyrau	33	34	54	35
9	FC Aktobe	33	38	46	33
10	Akzhayik	33	29	47	30
11	Taraz	33	29	50	26
12	Okzhetpes	33	28	61	24

TEMPORADA 2015/2016

LIGA KAZAJISTÁN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Astana	22	34	14	53
2	Kairat	22	50	22	46
3	Irtysh	22	37	18	41
4	Okzhetpes	22	33	23	37
5	Ordabasy	22	26	27	33
6	Tobol	22	28	26	28
7	Atyrau	22	21	23	28
8	FC Aktobe	22	23	32	28
9	Zhetysu	22	22	32	23
10	Shakhter	22	10	27	21
11	Taraz	22	22	30	19
12	Akzhayik	22	12	44	11

TEMPORADA 2014/2015

LIGA KAZAJISTÁN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kairat	32	60	19	67
2	Astana	32	55	26	67
3	FC Aktobe	32	35	25	54
4	Ordabasy	32	32	31	46
5	Atyrau	32	31	33	45
6	Irtysh	32	37	39	40

TEMPORADA 2013/2014

LIGA KAZAJISTÁN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	FC Aktobe	22	34	17	43
2	Kairat	22	41	20	42
3	Astana	22	34	17	39
4	Shakhter	22	33	27	36
5	Ordabasy	22	24	22	35
6	Kaysar	22	23	23	32
7	Zhetysu	22	15	18	27
8	Tobol	22	22	29	26
9	Irtysh	22	28	35	24
10	Atyrau	22	19	27	24
11	Taraz	22	21	34	19
12	Spartak	22	16	41	14

TEMPORADA 2012/2013

LIGA KAZAJISTÁN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC Aktobe	10	16	10	43
2	Astana	10	19	11	42
3	Kairat	10	16	14	33
4	Ordabasy	10	13	17	26
5	Shakhter	10	12	22	26
6	Irtysh	10	17	19	24

TEMPORADA 2011/2012

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Shakhter	26	48	15	53
2	Irtysh	26	46	20	51
3	FC Aktobe	26	44	22	50
4	Astana	26	34	24	46
5	Taraz	26	32	30	46
6	Tobol	26	42	27	45
7	Ordabasy	26	29	24	39
8	Akzhayik	26	34	39	34
9	Kaysar	26	21	33	30
10	Kairat	26	23	34	29
11	Atyrau	26	16	32	27
12	Zhetysu	26	16	31	23
13	Zhetysu	26	27	45	23
14	Okzhetpes	26	20	56	11

TEMPORADA 2010/2011

LIGA KAZAJISTÁN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Shakhter	10	17	9	42
2	Zhetysu	10	12	11	38
3	FC Aktobe	10	14	12	34
4	Astana	10	15	18	33
5	Irtysh	10	12	16	32
6	Ordabasy	10	13	17	28

TEMPORADA 2009/2010

LIGA KAZAJISTÁN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tobol	22	37	15	47
2	Irtysh	22	30	16	43
3	FC Aktobe	22	32	22	37
4	Shakhter	22	28	19	37
5	Astana	22	33	21	36
6	Atyrau	22	29	26	36
7	Zhetysu	22	22	16	34
8	Ordabasy	22	20	20	30
9	Kairat	22	11	22	20
10	Taraz	22	21	33	18
11	Akzhayik	22	19	43	14
12	Okzhetpes	22	16	45	13

Competiciones que juega

Grupo 2

Liga Kazajistán

Pos	Equipos		Pts
1		FC Aktobe	10
2		Astana	10
3		Zhetysu Taldykorgan	10
4		Ordabasy	9
5		Tobol Kostanay	9
6		FC Kyzylzhar	8
7		Yelimay Semey	8
8		Kairat Almaty	8
9		Atyrau	7
10		Zhenis	7
11		FK Turan Turkistan	4
12		Kaysar Kyzylorda	4
13		Shakhter Karagandy	3

	Previa de Champions (1ª Ronda) : FC Aktobe
	: Astana, Zhetysu Taldykorgan
	Descenso : Kaysar Kyzylorda, Shakhter Karagandy

RIVALES EN Fase Previa Conf.

RIVALES EN Copa Kazajistán

RIVALES EN Liga Kazajistán

RIVALES EN Supercopa de Kaz.

USO DE MEMORIA

6,568,760 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.7986
Total Execution Time	0.8000

CADENA URL

/historico/Ordabasy-Shymkent

GET DATOS

$_GET['/historico/Ordabasy-Shymkent']

POST DATOS

No hay datos POST existentes

CONSULTAS (51)

0.0140	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 = 'Ordabasy-Shymkent' 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.0126	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=13787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=13787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=13787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=13787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=13787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=13787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0137	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 = 72100
0.0142	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 = 75392
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13787 AND type_rel = 2
0.0135	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13787 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0141	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 (443622,871704) ORDER BY n.cover_points DESC, update_date DESC
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 = '13787' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0166	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 = '13787' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156	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 = 72100 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	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 = 75392 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0162	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=13787 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (75582,75392,74852,72100,71432) 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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 74852 AND teamId = 13787
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 72100 AND teamId = 13787
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 75582 AND teamId = 13787
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 75392 AND teamId = 13787
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13787
0.0128	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74852 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '13787' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13787' and rp.type = 4
0.0128	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 = '13787' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 74852 WHERE rp.league_id = 74852 AND rp.teamId = 13787 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.0133	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 = 74852 WHERE rp.league_id = 74852 AND rp.teamId = 13787 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 74852 WHERE rp.league_id = 74852 AND rp.teamId = 13787 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 13787 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132	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 = 74852 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 70984 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.0129	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 = 66785 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.0129	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 = 61124 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.0131	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 = 55373 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 48914 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 42834 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 37903 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 34924 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 20348 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 10266 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 17410 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 7067 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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 = 4365 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 2899 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 10647 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 10653 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 10654 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 10655 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 10657 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Ordabasy

Ordabasy

Selecciona un equipo

Competiciones que juega

Liga Kazajistán

RIVALES EN Fase Previa Conf.

RIVALES EN Copa Kazajistán

RIVALES EN Liga Kazajistán

RIVALES EN Supercopa de Kaz.