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

Kairat Almaty

Entrenador: Kirill Keker

Temporada 2023/2024

TEMPORADA 2023/2024

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

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 1
Equipo		PJ	GF	GC	Puntos
1	Kairat	22	43	14	44
2	FC Aktobe	22	27	12	44
3	Astana	22	40	19	43
4	Atyrau	22	25	19	37
5	Ordabasy	22	21	18	35
6	Irtysh	22	26	23	30
7	Okzhetpes	22	24	33	26
8	Tobol	22	22	32	25
9	Taraz	22	17	25	24
10	Shakhter	22	16	38	18
11	Kaysar	22	12	25	17
12	Zhetysu	22	17	32	17

TEMPORADA 2013/2014

LIGA KAZAJISTÁN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Astana	10	29	9	45
2	FC Aktobe	10	18	14	40
3	Kairat	10	17	11	38
4	Kaysar	10	7	11	27
5	Ordabasy	10	10	22	27
6	Shakhter	10	8	22	21

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 3
Equipo		PJ	GF	GC	Puntos
1	Tobol	10	18	16	32
2	Kaysar	10	16	9	27
3	Taraz	10	15	15	25
4	Atyrau	10	13	13	24
5	Kairat	10	10	12	22
6	Vostok	10	8	15	17

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

Liga Kazajistán

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

	Previa de Champions (1ª Ronda) : Kairat Almaty
	: FC Kyzylzhar, Ordabasy
	Descenso : Zhenis, Kaysar Kyzylorda

RIVALES EN Copa Kazajistán

RIVALES EN Liga Kazajistán

USO DE MEMORIA

6,325,152 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1907
Total Execution Time	0.1928

CADENA URL

/historico/Kairat-Almaty

GET DATOS

$_GET['/historico/Kairat-Almaty']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0036	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 = 'Kairat-Almaty' 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.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=13789 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=13789 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=13789 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=13789 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	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 = 74852
0.0026	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 = 75582
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13789 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13789 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 (12916,45779,52333,58341,88074) ORDER BY n.cover_points DESC, update_date DESC
0.0034	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 = '13789' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0034	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 = '13789' 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 = 75582 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 = 74852 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033	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=13789 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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,74852,71432,67756) 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.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 74852 AND teamId = 13789
0.0041	SELECT count(id) as num_players from rel_players WHERE league_id = 67756 AND teamId = 13789
0.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 75582 AND teamId = 13789
0.0116	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13789
0.0040	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 = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0089	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 = 13789 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.0069	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 = 13789 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 74852 WHERE rp.league_id = 74852 AND rp.teamId = 13789 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0086	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 = 13789 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031	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 = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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.0032	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.0031	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.0031	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.0038	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.0031	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.0035	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.0029	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.0029	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.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* `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.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 = 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.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* `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.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 = 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.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* `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.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 = 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.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 = 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.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* `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.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* `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 = 10656 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* `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
0.0019	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 = 74852 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

Kairat Almaty

Kairat Almaty

Selecciona un equipo

Competiciones que juega

Liga Kazajistán

RIVALES EN Copa Kazajistán

RIVALES EN Liga Kazajistán