26 May 19	Finalizado	Kayserispor	0 - 2	Erzurumspor	0
19 May 19	Finalizado	Akhisar Belediyespor	2 - 2	Kayserispor	11
12 May 19	Finalizado	Kayserispor	2 - 1	Kasımpaşa	4
06 May 19	Finalizado	Trabzonspor	4 - 2	Kayserispor	21
28 Abr 19	Finalizado	Kayserispor	1 - 1	Alanyaspor	5
20 Abr 19	Finalizado	Galatasaray SK	3 - 1	Kayserispor	2
14 Abr 19	Finalizado	Kayserispor	0 - 2	Ankaragücü	4
06 Abr 19	Finalizado	Sivasspor	1 - 3	Kayserispor	0
17 Mar 19	Finalizado	Kayserispor	1 - 1	İstanbul Başakşehir	8
10 Mar 19	Finalizado	Rizespor	3 - 0	Kayserispor	1
02 Mar 19	Finalizado	Kayserispor	2 - 2	Beşiktaş	17
24 Feb 19	Finalizado	Konyaspor	0 - 1	Kayserispor	1
17 Feb 19	Finalizado	Kayserispor	2 - 1	Göztepe	2
08 Feb 19	Finalizado	Kayserispor	1 - 0	Fenerbahçe	68
02 Feb 19	Finalizado	Yeni Malatyaspor	1 - 1	Kayserispor	24
26 Ene 19	Finalizado	Kayserispor	1 - 1	Bursaspor	9
19 Ene 19	Finalizado	Antalyaspor	0 - 0	Kayserispor	7
23 Dic 18	Finalizado	Erzurumspor	1 - 1	Kayserispor	16
16 Dic 18	Finalizado	Kayserispor	1 - 0	Akhisar Belediyespor	15
10 Dic 18	Finalizado	Kasımpaşa	0 - 3	Kayserispor	125
01 Dic 18	Finalizado	Kayserispor	0 - 2	Trabzonspor	3
24 Nov 18	Finalizado	Alanyaspor	5 - 0	Kayserispor	4
10 Nov 18	Finalizado	Kayserispor	0 - 3	Galatasaray SK	1
04 Nov 18	Finalizado	Ankaragücü	3 - 1	Kayserispor	0
28 Oct 18	Finalizado	Kayserispor	2 - 0	Sivasspor	5
20 Oct 18	Finalizado	İstanbul Başakşehir	1 - 0	Kayserispor	6
06 Oct 18	Finalizado	Kayserispor	2 - 2	Rizespor	4
29 Sep 18	Finalizado	Beşiktaş	2 - 0	Kayserispor	8
22 Sep 18	Finalizado	Kayserispor	0 - 2	Konyaspor	0
15 Sep 18	Finalizado	Göztepe	2 - 0	Kayserispor	2
01 Sep 18	Finalizado	Fenerbahçe	2 - 3	Kayserispor	32
25 Ago 18	Finalizado	Kayserispor	0 - 0	Yeni Malatyaspor	1
18 Ago 18	Finalizado	Bursaspor	0 - 0	Kayserispor	1
13 Ago 18	Finalizado	Kayserispor	2 - 0	Antalyaspor	39

Partidos Amistosos »

30 Mar 19	Finalizado	Kayserispor	1 - 2	Adana Demirspor	0
10 Ene 19	Finalizado	Kayserispor	0 - 1	Ankaraspor	9
29 Jul 18	Finalizado	Konyaspor	0 - 2	Kayserispor	0
24 Jul 18	Finalizado	NEC Nijmegen	2 - 1	Kayserispor	5
21 Jul 18	Finalizado	Heerenveen	2 - 1	Kayserispor	0

Copa Turca »

22 Ene 19	Finalizado	Akhisar Belediyespor	0 - 0	Kayserispor	29
15 Ene 19	Finalizado	Kayserispor	1 - 2	Akhisar Belediyespor	17
19 Dic 18	Finalizado	Kayserispor	4 - 1	Altay	11
05 Dic 18	Finalizado	Altay	1 - 2	Kayserispor	19
31 Oct 18	Finalizado	Kayserispor	6 - 1	Pazarspor	4

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Kayserispor Temporada 2018/2019

		Edad	Altura	Peso
Portero
1	M. Yildirim	33	190	81	-	-	1
33	S. Lung Jr.	34	189	85	-	1	3
39	Vedat Karakus	26	185	80	-	-	-
Defensa
30	A. Doğan	22	180	65	-	-	-
19	A. Gürbüz	24	-	-	-	-	-
89	Atila Turan	32	176	79	-	-	8
22	C. Sapunaru	40	187	81	2	-	8
76	J. Kana-Biyik	34	183	90	-	1	3
4	Levent Gülen	30	186	70	-	-	2
12	O. Berber	32	176	67	-	-	-
50	O. Kucher	41	184	77	-	-	7
99	S. Aytac	32	187	77	-	-	-
2	Tiago Lopes	35	180	66	-	2	13
Centrocampista
26	B. Kök	26	173	66	-	-	-
43	B. Mensah	29	180	65	3	1	5
14	E. Demir	20	175	67	-	-	-
	Ercan Cifci	23	184	70	-	-	-
8	H. Acar	29	183	70	3	-	2
25	H. Citak	25	-	-	-	-	-
38	M. Ozyildirim	29	175	-	-	-	3
6	S. Cinaz	38	187	78	2	1	6
20	T. Chery	35	171	68	9	-	3
Delantero
3	A. Gyan	38	186	80	4	-	-
11	A. Kravets	34	185	75	5	-	3
7	B. Basaçikoglu	29	179	70	-	-	3
10	D. Turuç	31	177	79	3	-	6
29	K. Çelik	24	-	-	-	-	-
17	Nurettin Korkmaz	21	178	70	-	-	-
18	S. Varela	39	180	75	1	-	1
9	U. Bulut	41	184	75	2	-	4

Noticias del Kayserispor

Ver últimas noticias

Hakan Kutlu deja de ser entrenador del Kayserispor

BeSoccer - Martes, 06 Diciembre 2016

0 126

Hakan Kutlu ha presentado su renuncia como entrenador del Kayserispor por la mala racha de resultados. No ganan desde hace más de cinco jornadas.

Reparto de puntos entre el Osmanlispor y el Kayserispor

BeSoccer - Domingo, 06 Noviembre 2016

0 197

El Osmanlispor, tres días después de asaltar El Madrigal en La Liga Europa, no pudo pasar del empate a uno ante el Kayserispor en partido de la décima jornada de la Liga turca.

Diego Biseswar, nuevo fichaje del PAOK

Jaime González Pons - Sábado, 02 Julio 2016

0 363

El futbolista holandés, de 28 años, ha jugado las cuatro últimas temporadas en Turquía y llega libre al conjunto griego.

Tolunay Kafkas dimite como técnico del Kayserispor

Jaime González Pons - Jueves, 03 Marzo 2016

0 149

Una mala racha de cinco jornadas sin conocer la victoria ha empujado al entrenador a presentar su dimisión.

Tighadouini sale cedido al Kayserispor turco

Miguel Moreno - Sábado, 30 Enero 2016

0 1.651

El delantero marroquí, que llegó al Málaga este verano para buscar solución al mediocre ataque del conjunto boquerón, no ha rendido como se esperaba y ha sido cedido a Kayserispor turco.

Ver más noticias del equipo»

Competiciones que juega

Liga Turca

Pos	Equipos		Pts
1		Galatasaray SK	69
2		İstanbul Başakşehir	67
3		Beşiktaş	65
4		Trabzonspor	63
5		Yeni Malatyaspor	47
6		Fenerbahçe	46
7		Antalyaspor	45
8		Konyaspor	44
9		Alanyaspor	44
10		Kayserispor	41
11		Rizespor	41
12		Sivasspor	41
13		Ankaragücü	40
14		Kasımpaşa	39
15		Göztepe	38
16		Bursaspor	37
17		Erzurumspor	35
18		Akhisar Belediyespor	27

	Champions League : Galatasaray SK
	Previa de Champions : İstanbul Başakşehir
	Europa League : Beşiktaş
	Previa de Europa League : Trabzonspor, Yeni Malatyaspor
	Descenso : Bursaspor, Erzurumspor, Akhisar Belediyespor

RIVALES EN Copa Turca

RIVALES EN Liga Turca

USO DE MEMORIA

5,940,472 bytes

BENCHMARKS

Loading Time Base Classes	0.0032
Controller Execution Time ( Home / Category )	0.7363
Total Execution Time	0.7396

CADENA URL

/Kayserispor/2019

GET DATOS

$_GET['/Kayserispor/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0163	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 = 'Kayserispor' AND l.year = 2019 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.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=1452 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=1452 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=1452 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=1452 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0157	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 = 43610
0.0147	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1452 AND type_rel = 2
0.0153	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1452 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0152	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 (38183,47798,86485,130274,143816) ORDER BY n.cover_points DESC, update_date DESC
0.0151	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 = '1452' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0156	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 = '1452' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153	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 = 44782 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150	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 = 43610 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0160	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2019 as c ON c.league_id = l.id WHERE (c.datateam1 = 1452 or c.datateam2 = 1452) AND l.year = 2019 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0191	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2019 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 1452 or c.datateam2 = 1452) AND l.year = 2019 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0155	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2019 as c ON c.league_id = l.id INNER JOIN events2019 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 1452 or c.datateam2 = 1452) AND l.year = 2019)
0.0158	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=1452 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0149	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 (51106,49948,49506) 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.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 49948 AND teamId = 1452
0.0159	SELECT count(id) as num_players from rel_players WHERE league_id = 51106 AND teamId = 1452
0.0335	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 1452
0.0154	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 43610 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0213	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 events2019 e ON e.player_id = p.id AND e.league_id = 43610 WHERE rp.league_id = 43610 AND rp.teamId = 1452 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.0212	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 events2019 e ON e.player_id = p.id AND e.league_id = 43610 WHERE rp.league_id = 43610 AND rp.teamId = 1452 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0204	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 events2019 e ON e.player_id = p.id AND e.league_id = 43610 WHERE rp.league_id = 43610 AND rp.teamId = 1452 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0176	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1452 AND rp.league_id = 43610 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0172	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6186246 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0151	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6186246
0.0198	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6186246 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0200	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6186246 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0177	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6186246 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0186	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6186246 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0188	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6186246 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0158	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 = 43610 ORDER BY nameShow LIMIT 100

Resultados de Fútbol

Kayserispor

Información sobre Kayserispor

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Copa Turca

Liga Turca

2. Lig Grupo 3

Partidos Amistosos

1. Lig

Europa League Grupo 0

Fase Previa Europa League

Copa Intertoto

Supercopa Turquía

Partidos del Kayserispor

Estadísticas

Plantilla del Kayserispor Temporada 2018/2019

Noticias del Kayserispor

Hakan Kutlu deja de ser entrenador del Kayserispor

Reparto de puntos entre el Osmanlispor y el Kayserispor

Diego Biseswar, nuevo fichaje del PAOK

Tolunay Kafkas dimite como técnico del Kayserispor

Tighadouini sale cedido al Kayserispor turco

Kayserispor

Selecciona un equipo

Competiciones que juega

Liga Turca

RIVALES EN Copa Turca

RIVALES EN Liga Turca


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