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

Hacettepe SK

Entrenador: Gökhan Kılavuz

Temporada 2023/2024

TEMPORADA 2023/2024

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Batman	28	54	19	60
2	Elazigspor	27	38	20	55
3	Karsiyaka	27	54	33	52
4	Turgutluspor	28	42	35	47
5	Efeler	28	41	38	47
6	Anadolu	28	34	33	39
7	Silifke	28	29	39	34
8	Pazarspor	28	28	33	33
9	Kartal	28	26	31	33
10	Yeni	28	26	32	33
11	Ergene	28	29	35	32
12	1954 Kelkit	28	28	35	31
13	Hacettepe	28	25	32	29
14	Eynesil	27	23	46	27
15	Sapancaspor	27	30	46	23

TEMPORADA 2022/2023

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mersin	34	49	21	68
2	Belediye	34	51	24	66
3	Belediye	34	52	34	65
4	52 Orduspor	34	54	34	64
5	Nevşehir	34	52	40	58
6	Karaköprü	34	44	32	56
7	Karsiyaka	34	44	28	54
8	Çatalca	34	40	39	44
9	Yeni	34	33	36	44
10	Elazigspor	34	44	53	42
11	1922	34	42	47	41
12	Hacettepe	34	41	50	36
13	Ağrı Spor	34	23	39	36
14	Edirnespor	34	35	45	35
15	1954 Kelkit	34	25	35	35
16	Yomraspor	34	36	42	34
17	Eskişehirsp	34	39	69	26
18	Sile	34	29	65	26

TEMPORADA 2021/2022

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Düzcespor	36	59	30	78
2	İskenderuns	36	72	31	74
3	76 Iğdır	36	64	39	72
4	Aksaray	36	49	43	59
5	52 Orduspor	36	48	41	58
6	Kestel	36	46	34	57
7	Kuşadasısp	36	42	48	47
8	Sile	36	39	46	47
9	Bayrampasasp	36	41	33	45
10	Kalecik FK	36	41	48	45
11	23 Elazig	36	40	36	43
12	Halide Edip	36	33	39	41
13	Yomraspor	36	35	45	41
14	Siirt Özel	36	38	57	41
15	Darica	36	33	46	38
16	Kizilcaboluk	36	41	51	37
17	Yeşilyurt	36	31	44	36
18	Çarşambasp	36	32	52	34
19	Hacettepe	36	24	45	31

TEMPORADA 2020/2021

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Manisa FK	36	84	22	84
2	1461 Trabzon	36	80	37	71
3	Kocaelispor	36	59	32	68
4	Ankara	36	56	36	65
5	Erzincanspor	36	51	31	62
6	Sariyer	36	51	33	61
7	Afjet	36	52	45	57
8	Amedspor	36	52	46	57
9	Usakspor	36	56	47	55
10	Corum FK	36	61	37	54
11	Kahramanmara	36	44	63	37
12	Nigde	36	38	53	36
13	Zonguldak	36	32	48	36
14	Inegolspor	36	40	52	35
15	Sanliurfaspo	36	41	70	34
16	Ergene	36	43	71	31
17	Gumushanespo	36	36	79	30
18	Sancaktepe	36	34	78	26
19	Hacettepe	36	26	56	25

TEMPORADA 2019/2020

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Samsunspor	28	64	11	73
2	Manisa FK	28	79	31	63
3	1461 Trabzon	28	51	34	55
4	Sancaktepe	28	51	23	52
5	Inegolspor	28	41	30	45
6	Afjet	28	47	30	43
7	Tarsus Idman	28	45	39	43
8	Pendikspor	28	40	39	40
9	Sariyer	28	34	33	40
10	Zonguldak	28	35	37	36
11	Corum FK	28	36	42	36
12	Hacettepe	28	37	48	35
13	1922	28	38	45	33
14	Kirklarelisp	28	25	41	33
15	Mamak Fk	27	34	41	28
16	Amedspor	28	28	46	28
17	Gumushanespo	27	31	54	25
18	Sanliurfaspo	28	10	102	1

TEMPORADA 2018/2019

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Keciorengucu	34	69	24	76
2	Kastamonuspo	34	67	23	74
3	Samsunspor	34	60	25	73
4	Sakaryaspor	34	63	31	69
5	Sariyer	34	56	32	68
6	Sancaktepe	34	52	36	53
7	Bodrumspor	34	56	48	52
8	Amedspor	34	44	42	49
9	Eyupspor	34	50	46	46
10	Inegolspor	34	45	48	45
11	Usakspor	34	40	39	40
12	Gumushanespo	34	41	42	40
13	Nigde	34	38	47	37
14	Ankara	34	36	50	34
15	Hacettepe	34	45	58	33
16	Bayrampasasp	34	32	53	33
17	Manisaspor	34	31	100	15
18	Gaziantepspo	34	11	92	11

TEMPORADA 2017/2018

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Altay	34	62	32	66
2	Gumushanespo	34	55	30	64
3	Bandirmaspor	34	56	34	64
4	Sanliurfaspo	34	57	36	63
5	Sakaryaspor	34	55	40	61
6	Mamak Fk	34	55	35	56
7	Hacettepe	34	49	33	56
8	1922	34	52	45	55
9	Nigde	34	42	43	49
10	Kirklarelisp	34	43	52	42
11	Kahramanmara	34	40	54	39
12	Zonguldak	34	26	40	38
13	Pendikspor	34	34	47	37
14	Fethiyespor	34	40	49	36
15	Fatih	34	32	48	36
16	Nazilli	34	34	58	29
17	Karsiyaka	34	32	54	21
18	Silivrispor	34	26	60	17

TEMPORADA 2016/2017

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Istanbulspor	34	48	22	68
2	Amedspor	34	51	31	66
3	Erzurumspor	34	56	33	61
4	Korfez FK	34	40	35	56
5	Sivas	34	44	35	53
6	Keciorengucu	34	51	48	49
7	Nazilli	34	41	44	49
8	Zonguldak	34	48	42	47
9	Hacettepe	34	39	35	44
10	Pendikspor	34	43	47	44
11	1922	34	31	40	42
12	Fatih	34	39	42	42
13	Bucaspor	34	43	55	40
14	Kahramanmara	34	37	43	40
15	Fethiyespor	34	35	44	38
16	Anadolu	34	34	43	37
17	Tepecik	34	42	58	32
18	Ofspor	34	30	55	26

TEMPORADA 2015/2016

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Umraniyespor	34	56	29	75
2	Istanbulspor	34	49	20	71
3	Bandirmaspor	34	64	40	60
4	Hacettepe	34	45	28	57
5	Sariyer	34	37	27	55
6	Menemenspor	34	49	36	53
7	Kirklarelisp	34	38	32	51
8	Nazilli	34	38	30	48
9	Pendikspor	34	35	35	45
10	Fethiyespor	34	37	39	44
11	Mamak Fk	34	29	36	43
12	1922	34	34	39	38
13	Kahramanmara	34	35	43	37
14	Hatayspor	34	31	39	35
15	Anadolu	34	39	49	34
16	Bayrampasasp	34	24	39	33
17	Orduspor	34	28	59	24
18	Pazarspor	34	32	80	24

TEMPORADA 2014/2015

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Yeni	36	54	30	66
2	Pendikspor	36	58	44	62
3	Kartalspor	36	46	34	60
4	1461 Trabzon	36	51	33	59
5	Umraniyespor	36	47	30	59
6	Menemenspor	36	44	35	57
7	Fatih	36	41	34	57
8	Aydinspor	36	44	42	54
9	1922	36	43	42	45
10	Tokatspor	36	40	47	45
11	Bayrampasasp	36	31	43	45
12	Hacettepe	36	36	36	44
13	Keciorengucu	36	45	42	43
14	Fethiyespor	36	28	39	43
15	Tarsus Idman	36	41	47	42
16	Turgutluspor	36	34	38	39
17	Iskenderun	36	35	47	39
18	Ofspor	36	38	48	38
19	Tavsanlı	36	28	73	15

TEMPORADA 2013/2014

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	1461 Trabzon	34	55	27	65
2	Batman	34	49	33	63
3	Hacettepe	34	56	32	57
4	Sandiklispor	34	42	27	56
5	Erzurumspor	34	45	31	56
6	Darica	34	46	25	55
7	Corum FK	34	49	35	53
8	Manavgat	34	56	49	53
9	Sancaktepe	34	45	41	48
10	Bursa	34	30	38	45
11	Maltepespor	34	43	47	43
12	Aksarayspor	34	31	38	42
13	Orhangazispo	34	45	58	40
14	Balcova	34	35	49	39
15	Istanbul	34	38	43	37
16	Sakaryaspor	34	35	47	37
17	Unyespor	34	21	41	24
18	23 Elazig	34	23	83	18

TEMPORADA 2012/2013

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Aydinspor	34	62	24	68
2	Canakkale	34	63	31	63
3	Sivas	34	47	33	59
4	Batman	34	49	37	59
5	Umraniyespor	34	53	33	58
6	Belediye	34	44	38	53
7	Hacettepe	34	51	41	52
8	Menemenspor	34	47	43	48
9	Manavgat	34	53	53	43
10	Erzincan	34	36	36	42
11	Adiyamanspor	34	44	46	42
12	Derince	34	37	47	41
13	Silivrispor	34	27	43	41
14	Bursa	34	45	51	40
15	Akçaabat	34	31	47	40
16	Kilimli	34	39	47	39
17	İskenderuns	34	37	72	27
18	Gebzespor	34	39	82	16

TEMPORADA 2011/2012

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Inegolspor	36	62	19	77
2	Bayrampasasp	36	61	28	71
3	Amedspor	36	57	30	67
4	Hacettepe	36	60	38	64
5	Gumushanespo	36	46	37	63
6	Manavgatspor	36	52	33	61
7	Menemenspor	36	49	40	56
8	Sandiklispor	36	55	41	53
9	Vanspor FK	36	47	39	53
10	Beşikdüzü	36	42	38	53
11	Kastamonuspo	36	38	42	49
12	Kirikhanspor	36	47	48	48
13	Umraniyespor	36	52	54	46
14	23 Elazig	36	41	46	43
15	Gebzespor	36	36	61	37
16	Kırıkkales	36	33	60	34
17	Lüleburgazs	36	27	44	33
18	Keçiören	36	31	52	25
19	Akçaabat	36	19	105	7

TEMPORADA 2010/2011

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Göztepe	34	70	27	74
2	Bandirmaspor	34	59	28	67
3	Mamak Fk	34	52	27	66
4	Turanspor	34	45	28	60
5	Yeni	34	36	33	58
6	Corumspor	34	43	35	55
7	Iskenderun	34	57	34	54
8	Turgutluspor	34	45	42	53
9	Bozuyukspor	34	44	42	51
10	Korfez FK	34	36	38	42
11	Sariyer	34	32	41	38
12	Cankirispor	34	43	53	38
13	Mardinspor	34	23	34	36
14	Alanyaspor	34	35	54	35
15	Adiyamanspor	34	31	42	34
16	Akçaabat	34	32	53	34
17	Hacettepe	34	41	59	32
18	Gebzespor	34	26	80	11

TEMPORADA 2009/2010

1. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Karabükspor	34	74	28	77
2	Bucaspor	34	69	40	64
3	Adanaspor	34	42	30	64
4	Altay	34	48	36	59
5	Karsiyaka	34	48	35	56
6	Konyaspor	34	42	37	55
7	Giresunspor	34	51	42	51
8	Orduspor	34	33	32	44
9	Boluspor	34	48	53	43
10	Samsunspor	34	49	47	42
11	Gaziantep	34	31	38	41
12	Mersin	34	36	44	41
13	Kayseri	34	42	53	41
14	Kartalspor	34	32	43	41
15	Rizespor	34	37	53	40
16	Hacettepe	34	38	50	38
17	Canakkale	34	37	53	35
18	Kocaelispor	34	23	66	14

TEMPORADA 2008/2009

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Beşiktaş	34	60	30	71
2	Sivasspor	34	54	28	66
3	Trabzonspor	34	54	34	65
4	Fenerbahçe	34	60	36	61
5	Galatasaray	34	57	39	61
6	Bursaspor	34	47	36	58
7	Kayserispor	34	38	26	50
8	Gaziantepspo	34	46	48	47
9	İstanbul	34	37	46	42
10	Ankaraspor	34	36	42	41
11	Eskişehirsp	34	45	49	40
12	Antalyaspor	34	34	42	40
13	Ankaragücü	34	36	47	39
14	Gençlerbirl	34	38	50	38
15	Denizlispor	34	39	52	38
16	Konyaspor	34	35	46	38
17	Kocaelispor	34	47	73	29
18	Hacettepe	34	24	63	22

TEMPORADA 2007/2008

LIGA TURCA
Equipo		PJ	GF	GC	Puntos
1	Galatasaray	34	64	23	79
2	Fenerbahçe	34	72	37	73
3	Beşiktaş	34	58	32	73
4	Sivasspor	34	57	29	73
5	Kayserispor	34	50	31	55
6	Trabzonspor	34	44	39	49
7	Denizlispor	34	48	48	45
8	Ankaragücü	34	36	44	43
9	Gaziantepspo	34	36	45	43
10	Ankaraspor	34	35	38	41
11	Hacettepe	34	30	36	40
12	İstanbul	34	44	47	38
13	Bursaspor	34	31	40	38
14	Konyaspor	34	37	64	36
15	Gençlerbirl	34	44	51	35
16	Manisaspor	34	42	62	29
17	Rizespor	34	32	64	29
18	Kasımpaşa	34	26	56	29

TEMPORADA 2006/2007

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Hacettepe	34	48	29	66
2	İstanbul	34	56	27	65
3	Malatyaspor	34	66	41	61
4	Kasımpaşa	34	53	39	54
5	Diyarbakirsp	34	37	32	51
6	Altay	34	51	51	51
7	Elazigspor	34	52	48	50
8	Orduspor	34	50	43	49
9	Gaziantep	34	47	48	44
10	Istanbulspor	34	39	46	43
11	Samsunspor	34	31	38	43
12	Kocaelispor	34	42	45	42
13	Karsiyaka	34	35	39	40
14	Eskişehirsp	34	33	39	40
15	Mardinspor	34	30	44	38
16	Türk	34	43	54	35
17	Akçaabat	34	40	66	31
18	Usakspor	34	33	57	29

TEMPORADA 2005/2006

2. LIG GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Kasımpaşa	18	24	12	38
2	Hacettepe	18	31	17	36
3	Eskişehirsp	18	25	19	29
4	Inegolspor	18	22	18	22
5	Kartalspor	18	13	14	21
6	Kahramanmara	18	21	27	21
7	Alanyaspor	18	21	28	21
8	Siirtspor	18	25	28	20
9	Unyespor	18	16	22	18
10	Bucaspor	18	18	31	17

Competiciones que juega

Grupo 2

3. Lig Grupo 2

Pos	Equipos		Pts
1		Batman Petrolspor	60
2		Elazigspor	55
3		Karsiyaka	52
4		Turgutluspor	47
5		Efeler	47
6		Anadolu Üniversitesi	39
7		Silifke Belediyespor	34
8		Pazarspor	33
9		Kartal Bulvarspor	33
10		Yeni Amasyaspor	33
11		Ergene Velimese Spor	32
12		1954 Kelkit Belediyespor	31
13		Hacettepe SK	29
14		Eynesil	27
15		Sapancaspor	23

	Ascenso : Batman Petrolspor
	Playoff Ascenso : Elazigspor, Karsiyaka, Turgutluspor, Efeler, Anadolu Üniversitesi
	Descenso : Hacettepe SK, Eynesil, Sapancaspor

RIVALES EN Copa Turca

RIVALES EN 3. Lig

USO DE MEMORIA

7,717,160 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7242
Total Execution Time	0.7254

CADENA URL

/historico/Hacettepe-Spor-Kulubu

GET DATOS

$_GET['/historico/Hacettepe-Spor-Kulubu']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0142	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 = 'Hacettepe-Spor-Kulubu' 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.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=12951 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=12951 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=12951 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0260	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 = 73220
0.0128	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12951 AND type_rel = 2
0.0163	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 = '12951' ORDER BY l.year DESC,cat.coefficient DESC
0.0155	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 = '12951' AND l.year = 2024 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 = '12951' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137	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 = 73220 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0168	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=12951 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133	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 (74094,73220) 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.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 73220 AND teamId = 12951
0.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 12951
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 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 = 73220 AND t.round = 30 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 = '12951' 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 = '12951' and rp.type = 4
0.0126	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 = '12951' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138	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 = 73220 WHERE rp.league_id = 73220 AND rp.teamId = 12951 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.0136	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 = 73220 WHERE rp.league_id = 73220 AND rp.teamId = 12951 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 73220 WHERE rp.league_id = 73220 AND rp.teamId = 12951 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 = 12951 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73220 AND t.round = 30 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* `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 = 68887 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 63655 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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 = 58623 AND t.round = 38 ORDER BY team.conference ASC,t.position 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* `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 = 50822 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 44487 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 38968 AND t.round = 34 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* `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 = 33785 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 16603 AND t.round = 34 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* `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 = 4007 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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 = 2806 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 27099 AND t.round = 34 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* `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 = 27105 AND t.round = 38 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* `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 = 16532 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 9938 AND t.round = 34 ORDER BY team.conference 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* `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 = 248 AND t.round = 34 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* `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 = 411 AND t.round = 34 ORDER BY team.conference 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* `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 = 9950 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 50680 AND t.round = 18 ORDER BY team.conference 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* `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 = 50682 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 73220 ORDER BY nameShow LIMIT 100

Hacettepe SK

Hacettepe SK

Selecciona un equipo

Competiciones que juega

3. Lig Grupo 2

RIVALES EN Copa Turca

RIVALES EN 3. Lig