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

Keciorengucu

Entrenador: Tahsin Tam

Temporada 2023/2024

TEMPORADA 2023/2024

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Eyupspor	32	71	27	72
2	Göztepe	32	54	19	64
3	Corum FK	32	52	31	56
4	Sakaryaspor	32	46	33	54
5	Bodrumspor	32	39	21	53
6	Kocaelispor	32	45	35	53
7	Bandirmaspor	32	46	27	48
8	Gençlerbirl	32	37	30	48
9	Boluspor	32	28	32	48
10	Erzurumspor	32	28	27	42
11	Keciorengucu	32	30	38	39
12	Manisa FK	32	39	38	37
13	Umraniyespor	32	34	44	37
14	Sanliurfaspo	32	28	34	34
15	Tuzlaspor	32	32	46	34
16	Adanaspor	32	25	45	33
17	Altay	32	14	70	16
18	Giresunspor	32	15	66	10

TEMPORADA 2022/2023

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Samsunspor	36	70	26	78
2	Rizespor	36	64	35	68
3	Pendikspor	36	65	36	67
4	Bodrumspor	36	55	34	62
5	Sakaryaspor	36	59	47	62
6	Eyupspor	36	40	30	62
7	Göztepe	35	45	28	60
8	Manisa FK	36	53	47	56
9	Keciorengucu	36	59	47	56
10	Bandirmaspor	36	55	58	55
11	Boluspor	36	44	46	52
12	Altay	35	45	45	40
13	Erzurumspor	36	43	48	39
14	Tuzlaspor	36	42	52	38
15	Gençlerbirl	36	46	55	38
16	Altinordu	36	41	57	35
17	Adanaspor	36	32	76	25
18	Denizlispor	36	35	67	23
19	Yeni	36	22	81	16

TEMPORADA 2021/2022

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Ankaragücü	36	56	31	70
2	Umraniyespor	36	64	37	70
3	Bandirmaspor	36	56	34	62
4	Istanbulspor	36	57	40	60
5	Erzurumspor	36	55	44	58
6	Eyupspor	36	56	44	57
7	Samsunspor	36	54	46	51
8	Boluspor	36	42	44	50
9	Manisa FK	36	45	44	49
10	Tuzlaspor	36	45	44	49
11	Denizlispor	36	46	50	49
12	Keciorengucu	36	45	47	48
13	Gençlerbirl	36	44	54	48
14	Altinordu	36	45	62	45
15	Adanaspor	36	40	44	45
16	Kocaelispor	36	40	49	44
17	Bursaspor	36	43	53	44
18	Menemenspor	36	42	57	38
19	Balikesirspo	36	26	77	12

TEMPORADA 2020/2021

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Adana	34	64	27	70
2	Giresunspor	34	54	25	70
3	Samsunspor	34	58	30	70
4	Istanbulspor	34	62	34	64
5	Altay	34	66	39	63
6	Altinordu	34	58	45	60
7	Keciorengucu	34	49	28	58
8	Umraniyespor	34	46	43	51
9	Tuzlaspor	34	46	53	47
10	Bursaspor	34	56	57	46
11	Bandirmaspor	34	48	51	42
12	Boluspor	34	38	41	42
13	Balikesirspo	34	35	53	35
14	Adanaspor	34	44	55	34
15	Menemenspor	34	38	62	34
16	Akhisar	34	36	59	30
17	Ankaraspor	34	33	61	26
18	Eskişehirsp	34	23	91	8

TEMPORADA 2019/2020

1. LIG
Equipo		PJ	GF	GC	Puntos
1	Hatayspor	34	48	28	66
2	Erzurumspor	34	42	26	62
3	Adana	34	71	43	61
4	Akhisar	34	46	39	57
5	Fatih	34	53	39	56
6	Bursaspor	34	49	41	56
7	Altay	34	48	37	54
8	Keciorengucu	34	33	28	50
9	Menemenspor	34	42	46	44
10	Giresunspor	34	39	47	44
11	Umraniyespor	34	48	51	44
12	Istanbulspor	34	45	43	40
13	Balikesirspo	34	36	48	38
14	Altinordu	34	37	44	37
15	Boluspor	34	30	41	33
16	Ankaraspor	34	41	56	30
17	Adanaspor	34	30	55	21
18	Eskişehirsp	34	34	60	18

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 2
Equipo		PJ	GF	GC	Puntos
1	Hatayspor	34	63	15	76
2	Menemenspor	34	68	26	74
3	Afjet	34	62	31	70
4	Sivas	34	57	29	67
5	Keciorengucu	34	77	41	64
6	Sancaktepe	34	58	32	59
7	Inegolspor	34	53	41	59
8	Sariyer	34	44	45	44
9	Tokatspor	34	37	45	43
10	Etimesgut	34	44	47	42
11	Kastamonuspo	34	46	49	40
12	Amedspor	34	37	41	40
13	Eyupspor	34	52	62	39
14	Tuzlaspor	34	42	51	38
15	Bodrumspor	34	39	53	38
16	Bucaspor	34	51	60	36
17	Korfez FK	34	30	78	13
18	Mersin	34	19	133	1

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 2
Equipo		PJ	GF	GC	Puntos
1	Manisaspor	34	41	27	66
2	Korfez FK	34	62	37	62
3	Tuzlaspor	34	53	37	56
4	Keciorengucu	34	45	38	53
5	Gumushanespo	34	52	42	50
6	Amedspor	34	45	39	50
7	Ankaragücü	34	40	32	49
8	Inegolspor	34	37	31	49
9	Aydinspor	34	42	36	48
10	Tepecik	34	35	37	43
11	Bucaspor	34	43	51	43
12	Sivas	34	38	40	42
13	Tokatspor	34	35	37	42
14	Eyupspor	34	38	48	41
15	Fatih	34	32	49	41
16	Kartalspor	34	30	47	39
17	Ankara	34	33	49	31
18	Tarsus Idman	34	28	52	25

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 3
Equipo		PJ	GF	GC	Puntos
1	Keciorengucu	34	54	38	66
2	Istanbulspor	34	57	33	63
3	Diyarbekirsp	34	57	24	61
4	Tuzlaspor	34	59	41	60
5	Menemenspor	34	47	32	59
6	Golcukspor	34	40	33	51
7	Ayvalikgucu	34	49	42	48
8	Denizli	34	44	43	47
9	Anadolu	34	38	41	45
10	Erzincan	34	32	36	45
11	Kirikhanspor	34	52	45	44
12	Kayseri	34	41	49	42
13	Turanspor	34	31	40	42
14	Arsinspor	34	39	49	42
15	Belediye	34	34	36	40
16	Yozgatspor	34	32	41	39
17	Kocaelispor	34	37	73	28
18	Bafraspor	34	28	75	18

TEMPORADA 2012/2013

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Altinordu	34	75	27	76
2	Darica	34	66	33	70
3	Keciorengucu	34	59	31	69
4	Kahramanmara	34	65	34	65
5	Gumushanespo	34	58	25	64
6	Erzurumspor	34	53	25	64
7	Sancaktepe	34	55	26	60
8	Maltepespor	34	36	33	51
9	Yeşil Bursa	34	40	29	44
10	Beylerbeyi	34	48	48	43
11	Yozgatspor	34	52	57	41
12	Kocaelispor	34	44	60	40
13	Corum FK	34	43	48	38
14	Arsinspor	34	41	44	37
15	Emrespor	34	31	37	35
16	23 Elazig	34	26	35	33
17	Diyarbakirsp	34	26	78	14
18	Mardinspor	34	2	150	0

TEMPORADA 2011/2012

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Nazilli	36	67	24	78
2	Keciorengucu	36	71	35	64
3	Belediye	36	49	28	64
4	Akçaabat	36	42	31	63
5	Kahramanmara	36	62	42	61
6	Batman	36	42	32	60
7	Istanbulspor	36	50	30	57
8	Sivas	36	50	47	49
9	Golcukspor	36	33	32	47
10	Maltepespor	36	53	58	45
11	İskenderuns	36	47	58	43
12	Orhangazispo	36	44	47	42
13	Kilimli	36	40	51	42
14	Yeşil Bursa	36	36	41	41
15	Arsinspor	36	37	43	41
16	Karsspor	36	45	55	40
17	Küçükçek	36	40	54	40
18	Kepez	36	28	72	27
19	Ergani Spor	36	18	74	14

TEMPORADA 2010/2011

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gaziosmanpas	34	47	23	69
2	Beylerbeyi	34	48	27	63
3	Amedspor	34	54	46	56
4	Sancaktepe	34	36	34	56
5	Denizli	34	37	26	54
6	Golcukspor	34	38	27	51
7	Keciorengucu	34	52	41	50
8	Kastamonuspo	34	36	33	49
9	Karsspor	34	38	39	48
10	Kirikhanspor	34	41	42	47
11	Pazarspor	34	48	43	45
12	Kırıkkales	34	59	45	43
13	Araklispor	34	36	42	43
14	Siirtspor	34	37	37	41
15	Kepez	34	31	42	39
16	Yalovaspor	34	34	41	35
17	Torbalispor	34	33	45	35
18	Zeytinburnus	34	18	90	7

TEMPORADA 2009/2010

3. LIG GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Keciorengucu	16	26	12	66
2	Beylerbeyi	16	22	15	54
3	Golcukspor	16	23	17	52
4	Ankara	16	23	16	46
5	Kırıkkales	16	21	26	45
6	Orhangazispo	16	17	24	42
7	Kartal	16	19	18	40
8	Düzcespor	16	15	21	40
9	Maltepespor	16	9	26	30

TEMPORADA 2008/2009

3. LIG GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Bursa	14	28	17	28
2	Inegolspor	14	27	14	27
3	Aksarayspor	14	28	22	27
4	Keciorengucu	14	22	12	25
5	Düzcespor	14	19	12	23
6	Kecioren	14	20	22	15
7	Orhangazispo	14	18	21	14
8	Usakspor	14	0	42	0

TEMPORADA 2007/2008

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tokatspor	30	43	27	57
2	Ofspor	30	43	28	55
3	Corumspor	30	39	25	51
4	Kastamonuspo	30	31	22	50
5	Keciorengucu	30	43	27	48
6	Surmenespor	30	28	25	44
7	Ankara	30	42	39	41
8	Tarım	30	29	22	39
9	Unyespor	30	31	37	38
10	Gumushanespo	30	27	31	37
11	Divrigispor	30	28	25	36
12	Bulancakspor	30	35	40	36
13	Keçiören	30	32	43	36
14	İlkadım	30	32	47	30
15	Artvin	30	22	33	29
16	Bafraspor	30	20	54	26

TEMPORADA 2006/2007

2. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Boluspor	18	36	27	32
2	Kartalspor	18	25	17	32
3	Karabükspor	18	23	20	28
4	Cankirispor	18	18	19	28
5	Zeytinburnus	18	24	20	26
6	Maltepespor	18	21	25	26
7	Pendikspor	18	22	19	23
8	Gebzespor	18	23	21	22
9	Keciorengucu	18	21	27	17
10	Darica	18	12	30	8

Competiciones que juega

1. Lig

Pos	Equipos		Pts
1		Eyupspor	72
2		Göztepe	64
3		Corum FK	56
4		Sakaryaspor	54
5		Bodrumspor	53
6		Kocaelispor	53
7		Bandirmaspor	48
8		Gençlerbirliği SK	48
9		Boluspor	48
10		Erzurumspor	42
11		Keciorengucu	39
12		Manisa FK	37
13		Umraniyespor	37
14		Sanliurfaspor	34
15		Tuzlaspor	34
16		Adanaspor	33
17		Altay	16
18		Giresunspor	10

	Ascenso : Eyupspor, Göztepe
	Playoff Ascenso : Corum FK
	Siguiente Ronda : Sakaryaspor, Bodrumspor, Kocaelispor, Bandirmaspor
	Descenso : Adanaspor, Altay, Giresunspor

RIVALES EN Copa Turca

RIVALES EN 1. Lig

USO DE MEMORIA

7,548,752 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.6926
Total Execution Time	0.6946

CADENA URL

/historico/Keciorengucu

GET DATOS

$_GET['/historico/Keciorengucu']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0138	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 = 'Keciorengucu' 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.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=12981 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=12981 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=12981 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253	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 = 72493
0.0131	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 = 74094
0.0124	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12981 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=358 AND type_rel = 3
0.0129	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 358 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128	SELECT /53 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 (1309832,1307337,1307165,1294898,1267840) ORDER BY n.cover_points DESC, update_date DESC
0.0133	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 = '12981' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134	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 = '12981' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74094 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132	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=12981 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 (74094,72493,67320) 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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 72493 AND teamId = 12981
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 12981
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 12981
0.0142	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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 12981 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.0137	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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 12981 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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 12981 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 12981 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 = 72493 AND t.round = 32 ORDER BY team.conference ASC,t.position 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* `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 = 68073 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.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* `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 = 63196 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.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* `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 = 58566 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.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* `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 = 50003 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.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* `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.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* `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 = 38969 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* `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.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* `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 = 16604 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* `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.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* `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 = 2807 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 27100 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* `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 = 27107 AND t.round = 38 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 = 27126 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* `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 = 27128 AND t.round = 22 ORDER BY team.conference 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* `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 = 27159 AND t.round = 18 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* `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 = 27163 AND t.round = 18 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* `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 = 27196 AND t.round = 14 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* `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 = 49307 AND t.round = 30 ORDER BY team.conference 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* `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 = 50653 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Keciorengucu

Keciorengucu

Selecciona un equipo

Competiciones que juega

1. Lig

RIVALES EN Copa Turca

RIVALES EN 1. Lig