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

Fatsa Belediye

Entrenador: Murat Atalar

Temporada 2023/2024

TEMPORADA 2023/2024

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Karaköprü	28	51	24	60
2	Erbaaspor	28	55	21	57
3	Silivrispor	28	38	22	51
4	Viven	28	47	33	50
5	Kuşadasısp	28	36	28	45
6	Belediye	28	40	25	44
7	Ağrı Spor	28	36	35	39
8	Tepecikspor	28	29	30	39
9	Fatsa	28	24	27	37
10	Osmaniyespor	28	29	34	29
11	1922	28	25	30	28
12	Bayburt	28	18	38	28
13	Darica	28	18	33	25
14	Akhisar	28	25	67	19
15	Sivas	28	22	46	17

TEMPORADA 2022/2023

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Aksaray	34	60	29	73
2	Kepez	34	53	21	72
3	Efeler	34	61	28	60
4	Beyoglu Yeni	34	68	40	59
5	Çankaya FK	34	60	34	59
6	Artvin	34	37	28	58
7	Sapancaspor	34	46	40	52
8	Muş	34	32	31	47
9	Bursa	34	37	34	44
10	Tepecik	34	37	47	44
11	Bergama	34	47	42	43
12	Siirt Özel	34	35	36	42
13	Erbaaspor	34	41	46	39
14	Akhisar	34	36	52	36
15	Fatsa	34	37	51	31
16	Osmaniyespor	33	25	54	31
17	Arguvanspor	33	22	60	26
18	Nigde	34	20	81	17

TEMPORADA 2021/2022

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Batman	34	55	29	74
2	Belediye	34	63	32	66
3	Bursa	34	45	27	62
4	Artvin	34	45	26	59
5	Arnavutkoy	34	47	29	59
6	Erbaaspor	34	48	33	52
7	Çatalca	34	47	32	50
8	Nevşehir	34	56	53	50
9	1954 Kelkit	34	41	40	48
10	Bergama	34	54	47	46
11	Fatsa	34	32	31	42
12	Osmaniyespor	34	33	34	40
13	Karaman FK	34	33	44	40
14	Kahta Spor	34	39	42	39
15	Elazigspor	34	36	51	39
16	Hendek Spor	34	33	41	32
17	Mamak Fk	34	22	79	18
18	Sancaktepe	34	28	87	13

TEMPORADA 2020/2021

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Diyarbekirsp	30	43	18	68
2	Bucaspor	30	58	18	67
3	Yeşilyurt	30	50	27	56
4	Ofspor	30	43	31	53
5	Arnavutkoy	30	40	29	48
6	Edirnespor	30	34	31	45
7	Belediye	30	41	29	43
8	Artvin	30	41	44	39
9	Fatsa	30	22	31	38
10	Kizilcaboluk	30	34	33	37
11	Nevşehir	30	31	31	34
12	Çankaya FK	30	28	48	34
13	1877	30	37	48	33
14	Kemerspor	30	27	50	27
15	Payas	30	29	56	23
16	Manisaspor	30	22	56	12

TEMPORADA 2019/2020

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kocaelispor	27	56	22	64
2	Belediye	27	41	28	50
3	Turgutluspor	26	34	19	49
4	Erokspor	27	42	25	47
5	Karsiyaka	26	33	23	43
6	Tepecik	27	29	30	41
7	Ofspor	26	35	31	38
8	Fethiyespor	26	28	25	38
9	Ağrı Spor	27	32	35	32
10	Cizrespor	24	31	33	31
11	Kozanspor	26	25	35	31
12	Fatsa	26	24	35	29
13	Erbaaspor	26	26	37	27
14	Payas	26	23	33	25
15	23 Elazig	25	22	35	25
16	1877	26	28	42	22
17	Kemerspor	26	28	49	22

TEMPORADA 2018/2019

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bayburt	34	48	22	68
2	Kocaelispor	34	40	31	58
3	Karacabey	34	45	40	58
4	Corum FK	34	42	32	52
5	Serik	34	38	36	51
6	Turgutluspor	34	49	47	49
7	Erzincanspor	34	45	38	48
8	Payas	34	32	37	48
9	Halide Edip	34	40	40	46
10	Diyarbekirsp	34	38	40	45
11	Muğlaspor	34	31	33	42
12	Çankaya FK	34	37	35	41
13	Fatsa	34	32	36	40
14	Golcukspor	34	28	32	40
15	Cizrespor	34	33	39	40
16	1461 Trabzon	34	31	39	37
17	Bagcilarspor	34	37	47	37
18	Bucaspor	34	35	57	28

TEMPORADA 1999/2000

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Gumushanespo	31	47	20	60
2	Akçaabat	32	43	32	58
3	Ofspor	32	46	35	57
4	Tokatspor	32	48	28	55
5	Erzincanspor	32	43	38	48
6	Çarşambasp	32	33	33	42
7	Bulancakspor	32	37	43	42
8	Divrigispor	32	42	52	42
9	Doğubayazı	32	34	34	41
10	Termespor	32	33	36	41
11	Bayburtspor	31	34	39	39
12	Pazarspor	32	38	47	39
13	Unyespor	31	27	29	38
14	Iğdırspor	32	37	45	38
15	Fatsa	32	34	40	37
16	Trabzon	31	28	31	35
17	Surmenespor	32	27	49	34

TEMPORADA 1998/1999

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sivasspor	32	71	35	66
2	Doğubayazı	32	43	28	58
3	Bayburtspor	32	49	37	51
4	Unyespor	32	42	34	51
5	Tokatspor	32	49	35	50
6	Bulancakspor	32	55	44	48
7	Çarşambasp	32	34	37	46
8	Ofspor	32	38	30	44
9	Corumspor	32	35	37	42
10	Termespor	32	37	45	40
11	Pazarspor	32	44	41	39
12	Akçaabat	32	31	31	38
13	Trabzon	32	26	46	37
14	Fatsa	32	25	38	35
15	Merzifonspor	32	25	36	34
16	Turhalspor	32	28	50	33
17	Ardeşenspor	32	25	53	30

TEMPORADA 1992/1993

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Giresunspor	30	78	25	72
2	Trabzon	30	60	22	61
3	Bayburtspor	30	56	28	56
4	Erzincanspor	30	38	31	43
5	Aras	30	33	36	43
6	Artvin Özel	30	31	39	42
7	Karsspor	30	38	47	40
8	Çayelispor	30	42	52	40
9	Pazarspor	30	36	51	40
10	Artvin	30	37	48	38
11	Kanunispor	30	29	41	38
12	Bulancakspor	30	35	35	37
13	Gumushanespo	30	36	38	37
14	Fatsa	30	47	41	35
15	Ağrıspor	30	33	56	30
16	Ardeşenspor	30	34	73	18

TEMPORADA 1991/1992

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Akçaabat	38	78	25	88
2	Giresunspor	38	87	29	85
3	Bulancakspor	38	75	35	73
4	Kadıköyspo	38	61	42	71
5	Trabzon	38	61	40	66
6	Bayburtspor	38	70	46	62
7	Çayelispor	38	60	58	62
8	Artvin	38	57	49	56
9	Kanunispor	38	49	45	53
10	Köy	38	47	59	47
11	Pazarspor	38	43	57	47
12	Gumushanespo	38	41	48	42
13	Erbaaspor	38	42	51	42
14	Fatsa	38	40	57	39
15	Ardeşenspor	38	46	78	39
16	Vezirköprü	38	27	57	38
17	Çarşambasp	38	42	69	37
18	Aras	38	35	68	36
19	Artvinspor	38	40	65	33
20	Suluovaspor	38	32	55	24

TEMPORADA 1990/1991

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bafraspor	32	85	12	86
2	Merzifonspor	32	49	29	57
3	Bulancakspor	31	39	26	52
4	Artvin	32	37	27	49
5	Bayburtspor	32	38	39	45
6	Artvinspor	32	37	43	44
7	Erbaaspor	31	35	36	42
8	Aras	32	35	38	42
9	Trabzon	32	42	45	41
10	Kanunispor	32	26	35	41
11	Fatsa	32	38	52	39
12	Gumushanespo	32	31	39	38
13	Çarşambasp	32	31	39	36
14	Suluovaspor	32	31	44	35
15	Köy	32	42	53	34
16	Çayelispor	32	37	56	31
17	Görelespor	32	18	38	29

TEMPORADA 1989/1990

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Unyespor	27	50	15	65
2	Bafraspor	28	57	26	60
3	Trabzonspor	28	46	24	50
4	Görelespor	28	33	24	44
5	Bayburtspor	28	36	39	43
6	Aras	28	38	36	37
7	Trabzon	28	27	39	35
8	Tokatspor	28	35	31	33
9	Artvinspor	28	27	32	33
10	Fatsa	28	27	35	33
11	Merzifonspor	28	31	36	31
12	Kanunispor	28	25	33	31
13	Turhalspor	28	32	45	31
14	Artvin	27	24	34	28
15	Çayelispor	28	16	55	16

TEMPORADA 1988/1989

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bulancakspor	30	45	20	60
2	Tokatspor	30	44	19	60
3	Unyespor	30	43	25	51
4	Fatsa	29	35	30	45
5	Turhalspor	30	46	40	41
6	Artvin	30	29	28	40
7	Kanunispor	30	32	33	40
8	Bayburtspor	30	26	28	37
9	Artvinspor	30	25	32	37
10	Çayelispor	29	24	35	37
11	Aras	30	20	33	36
12	Merzifonspor	30	19	25	34
13	Bafraspor	30	25	31	33
14	Görelespor	30	27	43	32
15	Erbaaspor	30	32	37	31
16	SinopSpor	30	21	34	31

TEMPORADA 1987/1988

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Giresunspor	28	52	21	59
2	Bafraspor	28	52	27	55
3	Kanunispor	28	37	39	44
4	Fatsa	28	39	31	39
5	Turhalspor	28	31	30	39
6	Sivasspor	28	36	33	37
7	Artvin	28	31	27	36
8	Artvinspor	28	25	28	36
9	Aras	28	27	26	35
10	Ağrıspor	28	28	47	35
11	Çayelispor	28	32	42	34
12	Görelespor	28	41	39	33
13	Bulancakspor	28	44	44	33
14	Karsspor	28	31	54	33
15	Gumushanespo	28	29	47	32

TEMPORADA 1986/1987

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Trabzonspor	32	55	21	64
2	Unyespor	32	53	19	62
3	Artvin	32	41	16	62
4	Giresunspor	32	42	30	51
5	Tokatspor	32	43	24	50
6	Sivas	32	41	37	46
7	Bafraspor	32	35	28	45
8	Bulancakspor	32	36	32	45
9	Çayelispor	32	37	37	41
10	Artvinspor	32	30	32	40
11	Fatsa	32	34	33	39
12	Görelespor	32	25	33	39
13	Karsspor	32	31	41	37
14	Ağrıspor	32	31	47	37
15	Gumushanespo	32	25	41	36
16	Iğdırspor	32	18	57	24
17	Palandökens	32	29	78	16

TEMPORADA 1985/1986

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bayburtspor	18	27	11	39
2	Bulancakspor	18	28	7	36
3	Unyespor	18	20	12	34
4	Iğdırspor	18	25	21	31
5	Artvinspor	18	16	22	24
6	Ağrıspor	18	24	23	20
7	Fatsa	18	14	15	19
8	Gumushanespo	18	21	26	18
9	Karsspor	18	10	25	14
10	Palandökens	18	11	34	11

TEMPORADA 1984/1985

2. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Artvin	18	43	14	41
2	Çarşambasp	18	21	9	38
3	Tokatspor	18	26	9	37
4	SinopSpor	18	21	21	26
5	Unyespor	18	17	17	21
6	Bulancakspor	18	22	28	21
7	Amasyaspor	18	18	27	20
8	Bafraspor	18	21	26	16
9	Fatsa	18	12	28	11
10	Artvinspor	18	18	40	10

Competiciones que juega

Grupo 3

3. Lig Grupo 3

Pos	Equipos		Pts
1		Karaköprü Bld.	60
2		Erbaaspor	57
3		Silivrispor Kulübü	51
4		Viven Bornova FK	50
5		Kuşadasıspor	45
6		Belediye Kütahyaspor	44
7		Ağrı Spor	39
8		Tepecikspor	39
9		Fatsa Belediye	37
10		Osmaniyespor Kulübü	29
11		1922 Konyaspor	28
12		Bayburt	28
13		Darica Genclerbirligi	25
14		Akhisar Belediyespor	19
15		Sivas Belediyespor	17

	Ascenso : Karaköprü Bld.
	Playoff Ascenso : Erbaaspor, Silivrispor Kulübü, Viven Bornova FK, Kuşadasıspor, Belediye Kütahyaspor
	Descenso : Darica Genclerbirligi, Akhisar Belediyespor, Sivas Belediyespor

RIVALES EN Copa Turca

RIVALES EN 3. Lig

USO DE MEMORIA

7,190,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1311
Total Execution Time	0.1323

CADENA URL

/historico/Fatsa-Belediye

GET DATOS

$_GET['/historico/Fatsa-Belediye']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0027	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 = 'Fatsa-Belediye' 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.0018	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=101512 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=101512 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=101512 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=101512 AND type_rel = 2
0.0024	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 = '101512' ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '101512' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '101512' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73221 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=101512 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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,73221) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 73221 AND teamId = 101512
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 101512
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* `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 = 73221 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '101512' 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 = '101512' 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 = '101512' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033	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 = 73221 WHERE rp.league_id = 73221 AND rp.teamId = 101512 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 events2024 e ON e.player_id = p.id AND e.league_id = 73221 WHERE rp.league_id = 73221 AND rp.teamId = 101512 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 73221 WHERE rp.league_id = 73221 AND rp.teamId = 101512 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 101512 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68889 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.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* `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 = 63654 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.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* `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 = 58625 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.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* `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 = 50978 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.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* `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 = 44491 AND t.round = 34 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* `tables2000` 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 = 50708 AND t.round = 34 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* `tables1999` 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 = 50728 AND t.round = 34 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* `tables1993` 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 = 50835 AND t.round = 30 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* `tables1992` 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 = 50844 AND t.round = 38 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* `tables1991` 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 = 50863 AND t.round = 34 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* `tables1990` 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 = 50865 AND t.round = 30 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* `tables1989` 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 = 50882 AND t.round = 30 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* `tables1988` 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 = 50891 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* `tables1987` 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 = 50907 AND t.round = 34 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* `tables1986` 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 = 50925 AND t.round = 18 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* `tables1985` 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 = 50946 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 73221 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

Fatsa Belediye

Fatsa Belediye

Selecciona un equipo

Competiciones que juega

3. Lig Grupo 3

RIVALES EN Copa Turca

RIVALES EN 3. Lig