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 2014/2015

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 3
Equipo		PJ	GF	GC	Puntos
1	Zhetysu	10	14	10	49
2	Ordabasy	10	17	14	45
3	Taraz	10	15	7	37
4	Kairat	10	6	16	29
5	Akzhayik	10	14	15	26
6	Okzhetpes	10	8	12	25

TEMPORADA 2008/2009

SEGUNDA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Kairat	26	63	21	61
2	Akzhayik	26	46	29	52
3	Astana-1964	26	57	27	51
4	Zhetysu	26	49	23	51
5	Ili-Saulet	26	53	24	45
6	Bulat-AMT	26	36	37	39
7	Spartak	26	35	41	38
8	Ekibastuzets	26	37	43	35
9	Gefest	26	26	34	29
10	Kaspiy Aktau	26	26	40	23
11	Aktobe Jas	26	25	42	20
12	Lashyn Taraz	26	31	56	19
13	Ayzharik	26	36	62	18
14	Turkestan	26	25	66	16

TEMPORADA 2007/2008

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	FC Aktobe	30	61	18	67
2	Tobol	30	58	21	67
3	Irtysh	30	58	28	62
4	Kaysar	30	29	22	49
5	Megasport	30	33	38	42
6	Zhetysu	30	28	27	41
7	Shakhter	30	43	27	40
8	FC Alma-Ata	30	33	39	37
9	Vostok	30	36	50	35
10	Okzhetpes	30	32	48	35
11	Kairat	30	25	28	34
12	Astana-1964	30	37	33	32
13	Ordabasy	30	25	44	30
14	Kyzylzhar	30	21	42	24
15	Energetik	30	21	43	23
16	Atyrau	30	22	54	19

TEMPORADA 2006/2007

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	FC Aktobe	30	55	12	72
2	Tobol	30	60	20	64
3	Shakhter	30	45	23	58
4	Irtysh	30	34	27	52
5	Zhetysu	30	33	32	46
6	FC Alma-Ata	30	35	32	44
7	Vostok	30	30	38	41
8	Astana-1964	30	34	25	38
9	Ordabasy	30	28	29	38
10	Kyzylzhar	30	24	28	37
11	Kaysar	30	27	37	37
12	Ekibastuzets	30	28	38	32
13	Atyrau	30	29	39	30
14	Kairat	30	23	43	30
15	Okzhetpes	30	26	56	29
16	Taraz	30	18	50	15

TEMPORADA 2005/2006

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Astana-1964	30	45	23	64
2	FC Aktobe	30	48	21	60
3	Tobol	30	43	22	56
4	Shakhter	30	35	24	50
5	FC Alma-Ata	30	36	29	48
6	Irtysh	30	34	24	47
7	Kairat	30	39	30	46
8	Ekibastuzets	30	29	28	42
9	Vostok	30	33	40	35
10	Taraz	30	32	34	33
11	Okzhetpes	30	23	36	33
12	Kyzylzhar	30	20	37	33
13	Ordabasy	30	29	36	32
14	Atyrau	30	25	47	29
15	Kaysar	30	29	53	28
16	Energetik	30	28	44	26

TEMPORADA 2004/2005

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	FC Aktobe	30	50	27	70
2	Tobol	30	53	21	69
3	Kairat	30	56	22	62
4	Shakhter	30	37	22	59
5	Irtysh	30	51	24	57
6	Ordabasy	30	30	27	49
7	Kyzylzhar	30	38	25	48
8	Astana-1964	30	35	23	43
9	Atyrau	30	32	36	37
10	Okzhetpes	30	26	32	37
11	Taraz	30	32	36	36
12	Ekibastuzets	30	30	32	34
13	FC Alma-Ata	30	30	43	30
14	Vostok	30	24	49	28
15	Zhetysu	30	28	60	19
16	Bolat	30	15	88	1

TEMPORADA 2003/2004

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Kairat	36	70	21	83
2	Irtysh	36	56	16	79
3	Tobol	36	87	27	77
4	FC Aktobe	36	52	19	74
5	Atyrau	36	49	31	71
6	Kyzylzhar	36	52	40	59
7	Taraz	36	35	23	59
8	Ekibastuzets	36	42	27	58
9	Shakhter	36	44	28	57
10	Astana-1964	36	45	44	51
11	Okzhetpes	36	26	39	43
12	Ordabasy	36	37	43	40
13	Vostok	36	42	54	40
14	Zhetysu	36	34	55	40
15	Yassy Sayram	36	30	49	35
16	Kaysar	36	24	60	31
17	Akzhayik	36	24	83	25
18	FC Alma-Ata	36	22	53	20
19	Spartak	36	25	84	13

TEMPORADA 2002/2003

LIGA KAZAJISTÁN
Equipo		PJ	GF	GC	Puntos
1	Irtysh	32	59	20	78
2	Tobol	32	55	19	76
3	Astana-1964	32	65	33	64
4	Atyrau	32	48	40	53
5	FC Aktobe	32	39	28	51
6	Kairat	32	51	42	49
7	Ordabasy	32	33	29	49
8	Zhetysu	32	46	38	48
9	Spartak	32	35	35	43
10	Shakhter	32	37	29	42
11	Kyzylzhar	32	42	53	36
12	Taraz	32	32	44	34
13	Kaysar	32	26	42	34
14	Vostok	32	34	46	32
15	Ekibastuzets	32	30	56	28
16	Akzhayik	32	25	74	26
17	Okzhetpes	32	13	42	15

TEMPORADA 2001/2002

LIGA KAZAJISTÁN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Irtysh	23	47	10	53
2	Atyrau	22	28	14	48
3	Astana-1964	23	33	15	41
4	Tobol	22	33	27	37
5	Shakhter	22	35	21	36
6	FC Aktobe	22	25	26	34
7	Yelimai	21	25	27	32
8	Kyzylzhar	22	18	25	25
9	Kairat	22	24	29	24
10	Vostok	22	17	31	19
11	Kaysar	22	13	46	11
12	Yesil K	21	12	39	9

Competiciones que juega

Liga Kazajistán Grupo 1

Pos	Equipos		Pts
1		Kairat Almaty	44
2		FC Aktobe	44
3		Astana	43
4		Atyrau	37
5		Ordabasy	35
6		FC Irtysh Pavlodar	30
7		Okzhetpes Kokshetau	26
8		Tobol Kostanay	25
9		Taraz	24
10		Shakhter Karagandy	18
11		Kaysar Kyzylorda	17
12		Zhetysu Taldykorgan	17

RIVALES EN Copa Kazajistán

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Kazajistán

RIVALES EN Supercopa de Kaz.

USO DE MEMORIA

6,850,736 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.2207
Total Execution Time	0.2227

CADENA URL

/historico/Kairat-Almaty/2015

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (53)

0.0052	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 = 2015 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.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.0028	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.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.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.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 = 17410
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 = 9478
0.0029	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13789 AND type_rel = 2
0.0024	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.0021	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.0031	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 = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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.0022	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 = 3839 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 = 10266 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 = 9478 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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 (2014,2015,2016) 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 (34924,23209,20349,16245,16077) 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 = 34924 AND teamId = 13789
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 16077 AND teamId = 13789
0.0068	SELECT count(id) as num_players from rel_players WHERE league_id = 23209 AND teamId = 13789
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 20349 AND teamId = 13789
0.0045	SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 13789
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 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 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 = '13789' 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 = '13789' and rp.type = 4
0.0020	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 = '13789' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044	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 events2015 e ON e.player_id = p.id AND e.league_id = 10266 WHERE rp.league_id = 10266 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.0029	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 events2015 e ON e.player_id = p.id AND e.league_id = 10266 WHERE rp.league_id = 10266 AND rp.teamId = 13789 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 events2015 e ON e.player_id = p.id AND e.league_id = 10266 WHERE rp.league_id = 10266 AND rp.teamId = 13789 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 <= 2015 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* `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.0021	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.0027	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.0027	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.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* `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.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* `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.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* `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.0021	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.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* `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.0021	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 = 10660 AND t.round = 10 ORDER BY team.conference 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* `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 = 15328 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 10671 AND t.round = 30 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* `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 = 10672 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* `tables2005` 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 = 10673 AND t.round = 30 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* `tables2004` 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 = 10674 AND t.round = 38 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* `tables2003` 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 = 10675 AND t.round = 36 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* `tables2002` 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 = 15324 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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* `tables2002` 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 = 15322 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 = 10266 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 Grupo 1

RIVALES EN Copa Kazajistán

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Kazajistán

RIVALES EN Supercopa de Kaz.