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

Batman Petrolspor

Entrenador: Mesut Toros

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

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

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 3
Equipo		PJ	GF	GC	Puntos
1	Somaspor	32	64	30	69
2	Erokspor	32	59	27	64
3	Ispartaspor	32	49	35	50
4	İçel	32	41	32	50
5	Çatalca	32	35	31	49
6	Çarşambasp	32	37	29	45
7	Osmaniyespor	32	35	32	44
8	Karsiyaka	32	36	39	44
9	Kalecik FK	32	36	34	43
10	Sile	32	38	39	43
11	23 Elazig	32	37	38	42
12	Erbaaspor	32	29	35	40
13	Batman	32	24	30	39
14	Cizrespor	32	30	55	32
15	Golcukspor	32	27	39	30
16	Arhavispor	32	23	49	27
17	Yalovaspor	32	26	52	22

TEMPORADA 2019/2020

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Karacabey	28	45	17	64
2	Somaspor	28	39	29	45
3	Pazarspor	27	48	41	44
4	Nevşehir	28	28	19	42
5	Muğlaspor	28	39	34	41
6	Osmaniyespor	28	35	32	41
7	Nazilli	28	47	30	40
8	Diyarbekirsp	28	35	28	40
9	1954 Kelkit	28	34	30	40
10	Darica	28	29	34	35
11	Halide Edip	28	22	30	35
12	Yozgatspor	28	24	32	34
13	Bayrampasasp	28	22	24	33
14	Golcukspor	28	31	42	31
15	Yeşilyurt	27	27	32	29
16	Kalecik FK	28	29	42	28
17	Batman	28	31	49	28
18	Modafenspor	28	19	39	27

TEMPORADA 2018/2019

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	1461 Trabzon	32	47	17	66
2	Nazilli	32	57	27	65
3	Buca FK	32	48	27	59
4	Nevşehir	32	50	30	57
5	Ergene	32	43	33	50
6	Karaköprü	32	44	45	44
7	Artvin	32	33	33	42
8	Erbaaspor	32	35	35	40
9	Silivrispor	32	30	29	39
10	Yomraspor	32	39	46	39
11	Sile	32	45	47	38
12	Batman	32	36	44	38
13	İskenderuns	32	47	43	37
14	Kozanspor	32	28	36	37
15	Tepecik	32	36	46	37
16	Gebzespor	32	30	38	34
17	Korfez FK	32	16	88	8

TEMPORADA 2017/2018

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Manisa FK	34	60	27	75
2	Bayburt	34	51	33	62
3	Kemerspor	34	62	44	57
4	Bayrampasasp	34	43	34	57
5	Ofspor	34	41	27	55
6	Düzcespor	34	41	34	55
7	Halide Edip	34	45	33	51
8	Batman	34	43	36	48
9	Erbaaspor	34	46	41	48
10	Kalecik FK	34	42	44	42
11	Çatalca	34	33	37	41
12	Kozanspor	34	42	52	39
13	Yomraspor	34	23	42	37
14	İskenderuns	34	35	53	36
15	Bingölspor	34	28	42	34
16	Bergama	34	35	54	34
17	Orhangazispo	34	34	52	31
18	Canakkale	34	35	54	26

TEMPORADA 2016/2017

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bodrumspor	34	59	31	65
2	Erbaaspor	34	48	29	60
3	Manisa FK	34	59	37	58
4	Silivrispor	34	34	25	58
5	Çatalca	34	42	33	55
6	Düzcespor	34	55	46	54
7	Halide Edip	34	46	39	53
8	Kirikhanspor	34	36	39	47
9	Kemerspor	34	52	45	45
10	Yomraspor	34	28	29	44
11	Batman	34	38	38	43
12	Buca FK	34	41	46	43
13	Yeşil Bursa	34	40	35	41
14	Canakkale	34	42	54	41
15	Pazarspor	34	34	46	39
16	Dersim Spor	34	33	54	33
17	Derince	34	31	59	26
18	Turk Metal.	34	28	61	23

TEMPORADA 2015/2016

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kastamonuspo	36	58	31	74
2	Nigde	36	52	34	61
3	Bayburt	36	37	26	61
4	Corum FK	36	47	36	59
5	Beylerbeyi	36	45	37	59
6	Golcukspor	36	43	33	58
7	Darica	36	50	36	54
8	Erzincan	36	42	29	54
9	Dersim Spor	36	40	44	51
10	Canakkale	36	45	38	49
11	Çatalca	36	37	33	47
12	Batman	36	37	42	47
13	Manavgat	36	50	52	44
14	Bergama	36	39	46	42
15	Vanspor FK	36	33	46	42
16	Iskenderun	36	37	55	40
17	Tavsanlı	36	31	44	34
18	Çine	36	27	48	31
19	Sandiklispor	36	35	75	21

TEMPORADA 2014/2015

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tuzlaspor	34	73	33	74
2	Darica	34	50	23	68
3	Zonguldak	34	50	24	63
4	Istanbulspor	34	53	23	61
5	Corum FK	34	44	36	56
6	Bursa	34	45	26	54
7	Buca FK	34	56	39	54
8	Kizilcaboluk	34	50	35	53
9	Çankaya FK	34	50	39	48
10	Nigde	34	44	40	47
11	Çatalca	34	34	32	45
12	Kirikhanspor	34	41	34	44
13	Manavgat	34	42	38	44
14	Batman	34	40	41	44
15	Gaziosmanpas	34	39	46	36
16	Akçaabat	34	18	70	21
17	Turanspor	34	23	71	19
18	Bozuyukspor	34	0	102	0

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 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 2
Equipo		PJ	GF	GC	Puntos
1	Kirklarelisp	34	62	27	73
2	Afyonkarahis	34	57	23	69
3	Gumushanespo	34	47	19	67
4	Altinordu	34	57	33	61
5	Darica	34	45	27	61
6	Sivas	34	61	37	60
7	Orhangazispo	34	48	24	60
8	Yeşil Bursa	34	52	26	58
9	Anadolu	34	51	35	56
10	İskenderuns	34	39	31	48
11	Batman	34	39	38	43
12	Akçaabat	34	38	41	41
13	Kahramanmara	34	38	43	40
14	Keçiören	34	47	57	33
15	Yozgatspor	34	30	49	32
16	Beykozspor	34	39	83	28
17	Ispartaspor	34	26	81	19
18	Erzurumspor	34	0	102	0

TEMPORADA 2009/2010

3. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Siirtspor	16	41	19	34
2	Kirikhanspor	16	24	18	27
3	Yeni	16	22	16	25
4	Belediye	16	20	13	23
5	Hatayspor	16	19	21	23
6	Batman Spor	16	16	23	22
7	Batman	16	12	19	16
8	Kayapınar	16	11	18	15
9	Sanliurfa	16	9	27	11

TEMPORADA 2008/2009

3. LIG GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Kayapınar	14	21	18	25
2	Baglar	14	21	18	23
3	Batman Spor	14	20	13	22
4	Siirtspor	14	24	21	19
5	Batman	14	21	22	18
6	Ceyhanspor	14	16	17	16
7	Kilis	14	18	27	15
8	Belediye	14	10	15	14

TEMPORADA 2007/2008

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Yeni	30	46	28	52
2	Vanspor FK	30	43	26	52
3	Karsspor	30	38	25	49
4	Şırnakspor	30	34	25	46
5	Batman Spor	30	40	34	44
6	Belediye	30	28	33	44
7	Aksarayspor	30	47	34	43
8	Ceyhanspor	30	36	33	40
9	Siirtspor	29	33	32	40
10	Batman	29	40	34	39
11	Kayapınar	29	35	32	38
12	Kilis	29	29	41	38
13	İskenderun	30	31	35	36
14	Nusaybin	30	39	51	36
15	Cizrespor	30	19	44	32
16	Mezitlispor	30	24	55	18

TEMPORADA 2006/2007

3. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Amedspor	30	57	20	60
2	Mezitlispor	30	43	26	55
3	Adanaspor	29	52	16	54
4	Aksarayspor	29	36	27	52
5	Batman Spor	29	41	28	50
6	Batman	29	37	33	47
7	Yeni	30	33	30	47
8	Şırnakspor	30	44	32	45
9	Vanspor FK	30	47	35	44
10	Nusaybin	30	36	40	42
11	Ceyhanspor	30	36	44	37
12	Kilis	30	25	41	33
13	Kayapınar	30	29	36	28
14	İskenderun	30	25	46	26
15	Osmaniyespor	30	23	64	24
16	Karamanspor	30	16	62	14

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,471,528 bytes

BENCHMARKS

Loading Time Base Classes	0.0017
Controller Execution Time ( Home / Category )	0.1559
Total Execution Time	0.1576

CADENA URL

/historico/Batman-Petrolspor

GET DATOS

$_GET['/historico/Batman-Petrolspor']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0042	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.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12962 AND type_rel = 2
0.0029	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 = '12962' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '12962' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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.0024	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=12962 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,73220,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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 68198 AND teamId = 12962
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 73220 AND teamId = 12962
0.0039	SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 12962
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 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.0020	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 = '12962' 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 = '12962' and rp.type = 4
0.0023	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 = '12962' 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 = 73220 WHERE rp.league_id = 73220 AND rp.teamId = 12962 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 = 73220 WHERE rp.league_id = 73220 AND rp.teamId = 12962 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 = 73220 WHERE rp.league_id = 73220 AND rp.teamId = 12962 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037	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 = 12962 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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* `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.0054	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 = 58627 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.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* `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 = 50979 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 = 44489 AND t.round = 34 ORDER BY team.conference 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* `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 = 38978 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045	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 = 33914 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 15825 AND t.round = 38 ORDER BY team.conference 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* `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 = 4465 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* `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.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* `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.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* `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.0028	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 = 27117 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 27168 AND t.round = 14 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* `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 = 27139 AND t.round = 18 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* `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 = 27173 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 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 = 27215 AND t.round = 14 ORDER BY team.conference 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* `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 = 49306 AND t.round = 30 ORDER BY team.conference 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* `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 = 50225 AND t.round = 30 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

Batman Petrolspor

Batman Petrolspor

Selecciona un equipo

Competiciones que juega

3. Lig Grupo 2

RIVALES EN Copa Turca

RIVALES EN 3. Lig