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

Tarsus Idman Yurdu

Entrenador: Murat Gündeş

Temporada 2023/2024

TEMPORADA 2023/2024

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kepez	28	67	18	70
2	Aliaga FK	28	60	18	66
3	Ayvalikgucu	28	40	25	52
4	52 Orduspor	28	40	28	49
5	Inegöl	28	37	30	47
6	Edirnespor	28	45	28	44
7	Mardin	28	40	34	41
8	Kücükcekme	28	41	31	38
9	Karabük	28	27	44	35
10	Artvin	28	33	29	34
11	Talasgücü	28	34	45	34
12	Kırıkkales	28	31	42	29
13	Gumushanespo	28	25	49	22
14	Arguvanspor	28	21	57	13
15	Tarsus Idman	28	20	83	10

TEMPORADA 2022/2023

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Corum FK	36	65	24	79
2	Sanliurfaspo	36	75	25	75
3	Erokspor	36	77	35	62
4	Amedspor	36	63	36	60
5	Erzincanspor	36	50	34	58
6	Ankaraspor	36	58	42	58
7	Somaspor	36	54	35	57
8	Düzcespor	36	55	46	52
9	Menemenspor	36	57	44	51
10	Afjet	36	48	47	47
11	Inegolspor	36	40	53	47
12	Ispartaspor	36	43	42	46
13	Nazilli	36	48	48	46
14	Arnavutkoy	36	41	42	46
15	Bursaspor	36	51	57	46
16	Batman	36	40	44	45
17	Tarsus Idman	36	26	125	21
18	Bayburt	36	25	68	19
19	Sivas	36	27	96	15

TEMPORADA 2021/2022

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pendikspor	34	56	25	77
2	Amedspor	34	43	35	57
3	Karacabey	34	58	41	56
4	Ispartaspor	34	39	28	55
5	Tarsus Idman	34	43	34	55
6	Erzincanspor	34	59	42	54
7	Bucaspor	34	50	42	53
8	Ankara	34	44	35	49
9	Kirsehirspor	34	44	35	49
10	Kirklarelisp	34	40	35	47
11	Sanliurfaspo	34	50	41	46
12	Nazilli	34	36	37	45
13	Usakspor	34	31	47	40
14	Zonguldak	34	37	47	38
15	Pazarspor	34	35	60	34
16	Akhisar	34	34	56	31
17	1922	34	36	52	29
18	Eskişehirsp	34	31	74	22
19	Kastamonuspo	0	0	0	0

TEMPORADA 2020/2021

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eyupspor	38	82	25	92
2	Sakaryaspor	38	74	35	75
3	Kirsehirspor	38	57	32	72
4	Kirklarelisp	38	60	32	70
5	Vanspor FK	38	59	35	69
6	Bodrumspor	38	80	48	63
7	Etimesgut	38	63	36	61
8	Karacabey	38	52	41	56
9	Turgutluspor	38	44	56	54
10	Serik	38	51	48	53
11	Pendikspor	38	66	53	52
12	Pazarspor	38	60	64	50
13	Tarsus Idman	38	56	55	49
14	Bayburt	38	52	61	48
15	Sivas	38	63	58	46
16	1922	38	47	49	42
17	Kastamonuspo	38	31	58	36
18	Elazigspor	38	61	90	33
19	Mamak Fk	38	32	121	24
20	Karabükspor	38	16	109	3

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 2
Equipo		PJ	GF	GC	Puntos
1	Menemenspor	34	76	46	68
2	Fatih	33	52	34	65
3	Manisa FK	34	65	28	62
4	Tuzlaspor	34	57	25	59
5	Sanliurfaspo	34	48	33	56
6	Etimesgut	34	46	41	55
7	Pendikspor	34	54	48	51
8	Kirklarelisp	34	46	40	45
9	Sivas	34	49	53	44
10	Tarsus Idman	34	48	53	42
11	Zonguldak	34	36	49	42
12	Mamak Fk	34	37	54	41
13	Bandirmaspor	34	46	57	38
14	Kahramanmara	34	38	54	38
15	1922	34	50	60	37
16	Fethiyespor	34	35	40	35
17	Tokatspor	33	28	43	30
18	Darica	34	26	79	21

TEMPORADA 2017/2018

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Usakspor	33	54	26	65
2	Tarsus Idman	34	60	36	61
3	Sultanbeyli	34	52	34	58
4	Kizilcaboluk	34	54	39	56
5	23 Elazig	34	43	40	52
6	Tepecik	34	39	40	52
7	Corum FK	34	51	39	48
8	Cizrespor	34	39	46	46
9	Karaköprü	34	46	33	45
10	1461 Trabzon	34	48	50	45
11	Karacabey	34	28	32	42
12	Payas	34	37	46	41
13	Kocaelispor	34	35	42	40
14	Çankaya FK	34	32	40	38
15	Osmaniyespor	34	37	49	38
16	Aydinspor	34	28	50	32
17	Tekirdağspo	34	42	64	30
18	Arsinspor	33	22	41	29

TEMPORADA 2016/2017

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Afjet	34	62	25	74
2	Sakaryaspor	34	66	27	68
3	Darica	34	60	28	68
4	Diyarbekirsp	34	54	43	60
5	Bayrampasasp	34	52	38	56
6	23 Elazig	34	51	37	54
7	1461 Trabzon	34	42	34	50
8	Tarsus Idman	34	57	53	48
9	Çankaya FK	34	38	49	42
10	Muğlaspor	34	41	54	42
11	Orhangazispo	34	40	43	41
12	Sultanbeyli	34	38	49	40
13	Bingölspor	34	31	42	39
14	Bergama	34	31	44	39
15	Payas	34	26	40	35
16	Maltepespor	34	23	49	32
17	Denizli	34	26	54	22
18	Orduspor	34	36	65	20

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

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Giresunspor	35	57	34	70
2	Göztepe	35	54	30	67
3	Hatayspor	35	51	30	66
4	Kartalspor	35	52	36	59
5	Yeni	35	50	35	58
6	Inegolspor	35	47	33	57
7	Pendikspor	35	43	31	57
8	Aydinspor	35	45	39	49
9	Turgutluspor	35	44	43	46
10	Tokatspor	35	40	57	41
11	Gumushanespo	35	31	33	40
12	Kirklarelisp	35	35	53	38
13	1922	35	31	40	36
14	Sariyer	35	39	50	34
15	Tarsus Idman	35	34	52	34
16	Canakkale	35	31	42	33
17	Gaziosmanpas	35	33	53	28
18	Cankirispor	35	17	43	26

TEMPORADA 2012/2013

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kahramanmara	32	53	30	62
2	Hatayspor	32	46	26	55
3	Mamak Fk	32	42	31	55
4	Tepecik	32	47	36	54
5	Nazilli	32	54	34	53
6	Fethiyespor	32	49	32	53
7	Bandirmaspor	32	36	34	44
8	Cankirispor	32	36	39	43
9	Pendikspor	32	35	33	41
10	Bozuyukspor	32	37	38	41
11	Tarsus Idman	32	32	35	38
12	Turgutluspor	32	29	33	37
13	Sariyer	32	37	49	35
14	İstanbul	32	23	32	34
15	Giresunspor	32	32	42	34
16	Unyespor	32	18	47	25
17	Sakaryaspor	32	30	65	21

TEMPORADA 2011/2012

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hatayspor	36	55	29	72
2	Tarsus Idman	36	62	41	65
3	Sancaktepe	36	54	38	59
4	Siirtspor	36	43	34	58
5	Bursa	36	51	39	57
6	Darica	36	50	42	53
7	Aydinspor	36	43	36	53
8	Erzurumspor	36	46	42	53
9	Anadolu	36	49	46	53
10	Pazarspor	36	44	45	53
11	Yozgatspor	36	45	43	51
12	Canakkale	36	30	31	46
13	Kemerspor	36	31	34	45
14	Beylerbeyi	36	39	40	44
15	Ankara	36	42	47	42
16	Kayapınar	36	34	46	38
17	Afyonkarahis	36	38	50	37
18	Araklispor	36	36	64	32
19	Çarşambasp	36	25	70	19

TEMPORADA 2010/2011

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Elazigspor	34	55	24	71
2	1922	34	64	36	67
3	Eyupspor	34	39	33	56
4	Sakaryaspor	34	40	37	54
5	Adana	34	36	34	50
6	Fethiyespor	34	43	38	46
7	Kocaelispor	34	39	41	45
8	Tokatspor	34	38	33	44
9	Sanliurfaspo	34	33	33	43
10	Balikesirspo	34	48	50	43
11	Pendikspor	34	40	48	43
12	Gölbaşispo	34	28	38	40
13	Ofspor	34	39	44	39
14	1461 Trabzon	34	41	51	39
15	Türk	34	34	40	38
16	Tarsus Idman	34	40	49	38
17	Vanspor FK	34	32	46	35
18	Canakkale	34	30	44	32

TEMPORADA 2009/2010

2. LIG GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Vanspor FK	16	33	12	35
2	Adiyamanspor	16	27	11	33
3	Elazigspor	16	25	11	33
4	Adana	16	28	20	27
5	Amedspor	16	21	25	22
6	Tarsus Idman	16	17	17	21
7	Mardinspor	16	15	21	12
8	Kahramanmara	16	16	35	8
9	Malatyaspor	16	8	38	6

TEMPORADA 2008/2009

2. LIG GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Bucaspor	18	34	21	37
2	Mersin	18	26	14	31
3	Tokatspor	18	27	28	29
4	Tarsus Idman	18	34	27	28
5	Corumspor	18	24	21	27
6	Vanspor FK	18	22	27	26
7	Korfez FK	18	19	24	22
8	Beykozspor	18	26	23	20
9	Eyupspor	18	24	28	19
10	Amedspor	18	14	37	4

TEMPORADA 2007/2008

2. LIG GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Karabükspor	11	12	7	23
2	Adana	12	15	13	21
3	Adanaspor	11	18	14	19
4	Gaziosmanpas	11	7	11	16
5	Mersin	11	15	11	15
6	Tarsus Idman	12	15	13	15
7	Erzurumspor	11	10	14	13
8	Pendikspor	11	12	12	12
9	Etimesgut	11	13	14	12
10	Canakkale	11	4	12	9

Competiciones que juega

Grupo 1

3. Lig Grupo 1

Pos	Equipos		Pts
1		Kepez Belediyespor	70
2		Aliaga FK	66
3		Ayvalikgucu Belediyespor	52
4		52 Orduspor	49
5		Inegöl Kafkas Genclik SK	47
6		Edirnespor	44
7		Mardin Fosfat	41
8		Kücükcekmece Sinop Spor	38
9		Karabük İdman Yurdu	35
10		Artvin Hopaspor	34
11		Talasgücü Belediyespor	34
12		MKE Kırıkkalespor	29
13		Gumushanespor	22
14		Arguvanspor	13
15		Tarsus Idman Yurdu	10

	Ascenso : Kepez Belediyespor
	Playoff Ascenso : Aliaga FK, Ayvalikgucu Belediyespor, 52 Orduspor, Inegöl Kafkas Genclik SK, Edirnespor
	Descenso : Gumushanespor, Arguvanspor, Tarsus Idman Yurdu

RIVALES EN Copa Turca

RIVALES EN 3. Lig

USO DE MEMORIA

7,338,376 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.6664
Total Execution Time	0.6678

CADENA URL

/historico/Tarsus

GET DATOS

$_GET['/historico/Tarsus']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0165	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 = 'Tarsus' 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=12926 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=12926 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=12926 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254	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.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12926 AND type_rel = 2
0.0134	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 = '12926' ORDER BY l.year DESC,cat.coefficient DESC
0.0131	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 = '12926' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131	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 = '12926' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 73217 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136	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=12926 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,73217,68198) 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 = 68198 AND teamId = 12926
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 73217 AND teamId = 12926
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 12926
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 = '12926' 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 = '12926' and rp.type = 4
0.0127	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 = '12926' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0143	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 = 73217 WHERE rp.league_id = 73217 AND rp.teamId = 12926 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.0144	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 = 73217 WHERE rp.league_id = 73217 AND rp.teamId = 12926 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73217 WHERE rp.league_id = 73217 AND rp.teamId = 12926 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 12926 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68198 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.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* `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 = 63657 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.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* `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 = 58624 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.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* `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.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* `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 = 44488 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 = 38980 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* `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 = 33915 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.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* `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.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* `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 = 2804 AND t.round = 34 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* `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 = 16525 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* `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 = 27108 AND t.round = 38 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* `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 = 16531 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* `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 = 16536 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 16540 AND t.round = 18 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* `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 = 16548 AND t.round = 22 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* `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 = 16560 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 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 = 16569 AND t.round = 18 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* `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 = 16576 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿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

Tarsus Idman Yurdu

Tarsus Idman Yurdu

Selecciona un equipo

Competiciones que juega

3. Lig Grupo 1

RIVALES EN Copa Turca

RIVALES EN 3. Lig