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

Tekirdağspor

Temporada 1986/1987

TEMPORADA 1986/1987

2. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Eyupspor	32	48	17	72
2	Tekirdağspo	32	57	26	64
3	Uzunköprüs	31	41	24	52
4	Gaziosmanpas	32	31	21	49
5	Keşanspor	32	48	35	48
6	Beylerbeyisp	32	30	25	46
7	İstanbul	31	33	28	45
8	Lüleburgazs	32	46	38	44
9	Malkara	32	34	35	41
10	Yedikule	32	30	36	41
11	Tekirdağ	32	33	42	39
12	Bayrampasasp	32	37	34	38
13	Hayraboluspo	31	24	36	38
14	Istanbulspor	32	26	42	38
15	Küçükçek	32	32	39	37
16	Yeşildirek	32	31	51	28
17	Davutpaşa	31	13	65	8

TEMPORADA 1985/1986

1. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Antalyaspor	33	57	19	71
2	Adanaspor	34	73	30	66
3	Türk	33	52	35	58
4	Edirnespor	34	49	49	50
5	Üsküdar	34	37	37	49
6	Inegolspor	34	32	35	47
7	Fatih	34	34	29	46
8	Düzcespor	34	44	49	45
9	Babaeskispor	34	35	39	43
10	Karabükspor	34	31	41	43
11	Vefa SK	34	37	34	42
12	Bakırköysp	34	38	41	41
13	Mersin	34	21	28	40
14	Kirklarelisp	34	33	42	40
15	Tekirdağspo	34	26	45	39
16	Galata	34	25	41	38
17	Lüleburgazs	34	27	42	34
18	Golcukspor	34	22	37	31

TEMPORADA 1984/1985

1. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Samsunspor	32	49	15	72
2	Türk	32	49	29	58
3	Karsiyaka	32	50	22	56
4	Edirnespor	32	43	27	53
5	Galata	31	38	33	50
6	Fatih	32	34	31	47
7	Düzcespor	32	43	48	45
8	Vefa SK	32	25	29	41
9	Karabükspor	32	24	33	39
10	Kirklarelisp	32	32	36	38
11	Üsküdar	32	27	36	36
12	Babaeskispor	32	24	38	35
13	Altinordu	31	35	36	33
14	Tekirdağspo	31	29	45	33
15	Lüleburgazs	31	32	31	32
16	Küçükçek	32	22	37	32
17	Alibeykoyspo	32	17	47	26

TEMPORADA 1983/1984

1. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Karsiyaka	29	50	14	68
2	Eskişehirsp	29	46	11	68
3	Samsunspor	30	56	22	60
4	Göztepe	30	38	31	45
5	Petrol Ofisi	30	32	28	42
6	Kirklarelisp	30	28	33	38
7	Düzcespor	30	26	40	36
8	Galata	30	28	36	35
9	Edirnespor	30	25	32	34
10	Lüleburgazs	30	30	40	34
11	Sitespor	29	31	32	32
12	Bandirmaspor	30	31	34	32
13	Beykozspor	30	13	32	28
14	Küçükçek	30	14	29	27
15	Tekirdağspo	30	27	44	27
16	Istanbulspor	29	15	32	24

TEMPORADA 1982/1983

1. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fatih	30	43	16	64
2	Üsküdar	30	39	21	57
3	Edirnespor	30	29	20	51
4	Lüleburgazs	30	34	21	44
5	Galata	30	38	32	43
6	Beykozspor	30	22	20	41
7	Tekirdağspo	30	28	32	39
8	Alibeykoyspo	30	21	25	39
9	Küçükçek	30	28	21	38
10	Vefa SK	30	34	33	38
11	Beylerbeyisp	30	24	25	37
12	Istanbulspor	30	22	27	36
13	Davutpaşa	30	27	34	35
14	Yedikule	30	27	40	29
15	Feriköy	30	19	44	26
16	Eyupspor	30	14	38	22

TEMPORADA 1981/1982

1. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sariyer	28	40	14	60
2	Düzcespor	28	51	24	54
3	Üsküdar	28	27	19	48
4	Lüleburgazs	28	27	25	44
5	Vefa SK	28	34	29	42
6	Karabükspor	27	27	18	41
7	Fatih	28	20	19	38
8	Tekirdağspo	28	31	31	38
9	Beylerbeyisp	28	21	24	33
10	Istanbulspor	28	21	31	33
11	Beykozspor	28	20	23	31
12	Edirnespor	27	23	34	27
13	Davutpaşa	28	15	34	22
14	Alibeykoyspo	27	16	27	20
15	Kirklarelisp	27	16	37	19

TEMPORADA 1980/1981

1. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sakaryaspor	34	60	23	77
2	Sariyer	34	42	28	59
3	Ankaragücü	34	53	25	57
4	Ankara	34	41	24	55
5	Kayseri	34	40	26	54
6	Düzcespor	33	25	25	45
7	Tekirdağspo	34	30	33	45
8	Lüleburgazs	33	35	36	42
9	Edirnespor	34	33	39	42
10	Karabükspor	34	40	44	41
11	Beykozspor	34	32	43	40
12	Kırıkkales	34	34	34	39
13	Vefa SK	34	30	38	39
14	Alibeykoyspo	34	29	50	39
15	Fatih	34	22	36	38
16	Turanspor	34	31	39	36
17	Gençlerbirl	34	30	42	35
18	Kirklarelisp	34	28	50	32

TEMPORADA 1979/1980

1. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kocaelispor	30	53	20	65
2	Düzcespor	30	37	21	49
3	Antalyaspor	30	38	26	46
4	Edirnespor	30	26	26	45
5	Sariyer	30	23	21	43
6	Vefa SK	30	23	23	40
7	Tekirdağspo	30	30	33	40
8	Balikesirspo	30	29	38	40
9	Denizlispor	30	28	31	39
10	Sakaryaspor	30	25	35	39
11	Aydinspor	30	30	26	38
12	Bandirmaspor	29	26	26	38
13	Altinordu	30	28	30	38
14	Lüleburgazs	30	23	27	35
15	Ispartaspor	29	23	42	34
16	Tirespor	30	25	42	23

TEMPORADA 1978/1979

1. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rizespor	28	39	13	56
2	Ankaragücü	28	36	12	52
3	Turanspor	28	31	15	46
4	Vefa SK	28	22	26	39
5	Ankara	28	21	23	36
6	Elazigspor	27	22	31	36
7	Tekirdağspo	28	21	20	35
8	Ispartaspor	28	23	26	34
9	Sivasspor	28	22	37	34
10	Akçaabat	28	21	24	33
11	Sakaryaspor	28	24	30	33
12	Tirespor	28	17	26	33
13	Aydinspor	27	22	24	32
14	Konya İdman	28	28	33	32
15	Beykozspor	28	23	32	32

TEMPORADA 1977/1978

1. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rizespor	30	46	15	67
2	Göztepe	29	65	20	65
3	Turanspor	30	39	22	49
4	Aydinspor	30	30	24	43
5	İskenderuns	30	23	27	41
6	Konya İdman	29	28	28	39
7	Elazigspor	30	26	23	38
8	Vefa SK	30	27	29	38
9	Tekirdağspo	30	24	39	36
10	Sakaryaspor	30	21	37	36
11	Beykozspor	30	30	40	35
12	Ankara	30	24	28	33
13	Ispartaspor	30	23	30	33
14	Tirespor	30	18	30	33
15	Sivasspor	30	20	33	33
16	Altinordu	30	25	44	33

TEMPORADA 1976/1977

2. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tekirdağspo	20	25	15	38
2	Edirnespor	20	28	16	37
3	Alibeykoyspo	20	24	19	32
4	Kasımpaşa	20	20	19	32
5	Lüleburgazs	20	23	18	30
6	Kirklarelisp	20	18	17	28
7	Istanbulspor	20	23	17	27
8	Fatih	20	22	20	27
9	Galata	20	28	27	27
10	Üsküdar	20	11	35	11
11	Küçükçek	20	10	29	10

TEMPORADA 1975/1976

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ispartaspor	30	58	14	66
2	Istanbulspor	30	54	16	64
3	Izmirspor	30	47	26	57
4	Karsiyaka	30	31	18	53
5	Kirklarelisp	30	24	19	50
6	Ödemisspor	29	37	25	47
7	Tekirdağspo	30	38	28	42
8	Yeşilovaspo	30	32	30	38
9	Kasımpaşa	30	22	33	36
10	Lüleburgazs	30	18	24	35
11	Canakkale	30	24	34	35
12	Edirnespor	30	24	39	33
13	Alibeykoyspo	30	22	42	29
14	Düzcespor	29	21	33	28
15	Usakspor	30	16	44	17
16	Küçükçek	30	16	59	16

TEMPORADA 1974/1975

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bandirmaspor	31	44	18	62
2	Ispartaspor	32	39	17	56
3	Izmirspor	32	37	23	50
4	Tekirdağspo	32	37	25	49
5	Karsiyaka	32	30	25	49
6	Ödemisspor	32	32	34	46
7	Alibeykoyspo	32	30	36	42
8	Lüleburgazs	32	26	33	42
9	Kirklarelisp	32	27	26	41
10	Kasımpaşa	32	23	26	40
11	Edirnespor	32	28	32	40
12	Düzcespor	32	19	23	40
13	Petrol Ofisi	32	26	28	37
14	Yeşilovaspo	32	19	27	37
15	Küçükçek	32	22	42	37
16	Canakkale	31	19	34	33
17	Feriköy	32	24	33	32

TEMPORADA 1973/1974

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kırıkkales	38	62	18	78
2	Ispartaspor	38	62	31	78
3	Karabükspor	38	40	16	73
4	Izmirspor	38	40	22	62
5	Galata	38	35	33	54
6	Feriköy	38	35	31	53
7	Canakkale	38	41	41	51
8	Üsküdar	39	38	41	50
9	Karsiyaka	38	28	32	49
10	Düzcespor	38	32	37	49
11	Kasımpaşa	38	30	38	48
12	Tekirdağspo	38	26	37	48
13	Kirklarelisp	39	37	38	47
14	Edirnespor	38	24	29	47
15	Afjet	39	27	41	47
16	Yeşilovaspo	37	39	37	45
17	Küçükçek	38	31	35	45
18	Güneşspor	39	22	35	45
19	Ödemisspor	38	24	35	44
20	Fatih	38	28	37	42
21	Keciorengucu	37	25	35	37
22	Nazilli	38	27	54	34

TEMPORADA 1972/1973

2. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Eskişehir	24	36	9	55
2	Galata	23	33	8	50
3	Tekirdağspo	24	28	16	44
4	Yeşilovaspo	24	36	30	40
5	Nazilli	24	30	26	39
6	Ödemisspor	24	26	21	33
7	Kasımpaşa	24	28	32	29
8	Alibeykoyspo	24	15	22	25
9	Küçükçek	24	16	27	25
10	Yedikule	24	17	28	24
11	Beyogluspor	24	11	18	23
12	Burdurspor	24	11	26	20
13	Muğlaspor	23	13	37	15

TEMPORADA 1971/1972

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lüleburgazs	28	39	8	66
2	Tekirdağspo	28	50	12	64
3	Galata	28	37	25	47
4	Ödemisspor	28	33	21	47
5	Nazilli	28	29	21	41
6	Muğlaspor	28	24	30	39
7	Yeşilovaspo	28	23	27	38
8	Kasımpaşa	28	24	25	36
9	Burdurspor	28	22	29	33
10	Beyogluspor	28	16	25	29
11	Yedikule	28	25	36	28
12	Alibeykoyspo	28	17	29	28
13	Küçükçek	28	14	31	27
14	Hasköyspor	28	18	35	24
15	Ülküspor	28	24	41	22

TEMPORADA 1970/1971

2. LIG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sariyer	26	42	7	64
2	Eskişehir	26	59	12	63
3	Lüleburgazs	26	58	15	57
4	Tekirdağspo	27	47	19	56
5	Ödemisspor	26	21	18	46
6	Yedikule	26	24	20	38
7	Yeşilovaspo	26	28	23	35
8	Kasımpaşa	26	18	30	34
9	Burdurspor	26	25	29	33
10	Alibeykoyspo	26	17	24	28
11	Ülküspor	26	22	35	24
12	Hasköyspor	26	16	46	18
13	Muğlaspor	26	16	47	18
14	Küçükçek	27	13	58	18
15	Beyogluspor	26	16	39	14

TEMPORADA 1969/1970

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Usakspor	40	63	28	79
2	Edirnespor	40	57	29	77
3	Konya İdman	40	45	20	75
4	Ispartaspor	40	38	25	72
5	Sariyer	40	36	19	70
6	Konyaspor	40	69	28	69
7	Lüleburgazs	40	47	27	65
8	Karabükspor	40	39	35	61
9	Eskişehir	40	40	33	54
10	Fatih	40	37	45	50
11	Tekirdağspo	40	39	39	49
12	Canakkale	40	28	34	49
13	Kirklarelisp	40	23	39	48
14	Yedikule	40	28	38	47
15	Burdurspor	40	30	48	45
16	Kastamonuspo	40	34	52	42
17	Taksim	40	29	46	39
18	Kasımpaşa	40	28	45	39
19	Muğlaspor	40	33	58	36
20	Beyogluspor	40	26	52	33
21	Beylerbeyisp	40	22	51	33

TEMPORADA 1968/1969

2. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Nazilli	26	35	7	58
2	Usakspor	26	36	10	57
3	Ispartaspor	26	31	21	47
4	Tekirdağspo	25	24	17	36
5	Kasımpaşa	26	20	16	36
6	Eskişehir	26	19	16	36
7	Taksim	26	26	25	35
8	Lüleburgazs	26	21	24	35
9	Muğlaspor	26	16	27	30
10	Konya İdman	26	20	22	29
11	Canakkale	26	15	23	26
12	Beyogluspor	26	17	29	23
13	Davutpaşa	25	9	21	20
14	Burdurspor	26	10	41	19

TEMPORADA 1967/1968

2. LIG
Equipo		PJ	GF	GC	Puntos
1	Düzcespor	32	57	17	64
2	Kırıkkales	32	58	46	58
3	İskenderuns	32	31	21	57
4	Eskişehir	32	46	25	56
5	Nazilli	32	45	32	53
6	Tekirdağspo	32	27	21	51
7	Konya İdman	32	38	30	49
8	Hatayspor	32	39	35	46
9	Lüleburgazs	32	41	37	44
10	Canakkale	32	32	29	42
11	Tarsus Idman	32	42	49	41
12	Beyogluspor	32	26	37	38
13	Corumspor	32	25	34	37
14	Elazigspor	32	30	48	31
15	Muğlaspor	32	27	55	30
16	Davutpaşa	32	24	38	25
17	Ceyhanspor	32	28	62	22

Competiciones que juega

2. Lig Grupo 9

Pos	Equipos		Pts
1		Eyupspor	72
2		Tekirdağspor	64
3		Uzunköprüspor	52
4		Gaziosmanpasaspor	49
5		Keşanspor	48
6		Beylerbeyispor	46
7		İstanbul THY	45
8		Lüleburgazspor	44
9		Malkara Belediyespor	41
10		Yedikule GSK	41
11		Tekirdağ Sarayspor	39
12		Bayrampasaspor	38
13		Hayraboluspor	38
14		Istanbulspor AS	38
15		Küçükçekmecespor	37
16		Yeşildirek SK	28
17		Davutpaşa	8

RIVALES EN Copa Turca

RIVALES EN 2. Lig

USO DE MEMORIA

7,593,288 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1933
Total Execution Time	0.1944

CADENA URL

/historico/Tekirdagspor/1987

GET DATOS

$_GET['/historico/Tekirdagspor/1987']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0032	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 = 'Tekirdagspor' AND l.year = 1987 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=65751 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=65751 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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 50915
0.0027	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 = 49358
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65751 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=359 AND type_rel = 3
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 359 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022	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 (1307337,1244348,1234831,1117729,1085507) ORDER BY n.cover_points DESC, update_date DESC
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 = '65751' ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '65751' AND l.year = 1987 ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '65751' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029	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 = '65751' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0039	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 = 49358 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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 = 50915 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0038	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=65751 AND l.year in (1986,1987,1988) ORDER BY l.id DESC, l.year DESC ;
0.0024	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 (50915,50490,49423) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 50490 AND teamId = 65751
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 50915 AND teamId = 65751
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 49423 AND teamId = 65751
0.0041	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 50915 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030	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 = '65751' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65751' and rp.type = 4
0.0029	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 = '65751' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031	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 events1987 e ON e.player_id = p.id AND e.league_id = 50915 WHERE rp.league_id = 50915 AND rp.teamId = 65751 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.0030	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 events1987 e ON e.player_id = p.id AND e.league_id = 50915 WHERE rp.league_id = 50915 AND rp.teamId = 65751 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 events1987 e ON e.player_id = p.id AND e.league_id = 50915 WHERE rp.league_id = 50915 AND rp.teamId = 65751 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046	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 = 65751 AND l.year <= 1987 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039	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 = 50915 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 50490 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* `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 = 50510 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* `tables1984` 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 = 50513 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* `tables1983` 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 = 50517 AND t.round = 30 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* `tables1982` 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 = 50528 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* `tables1981` 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 = 50533 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* `tables1980` 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 = 50537 AND t.round = 30 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* `tables1979` 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 = 50549 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* `tables1978` 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 = 50552 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1977` 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 = 50996 AND t.round = 22 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* `tables1976` 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 = 50997 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* `tables1975` 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 = 50999 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* `tables1974` 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 = 51004 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0104	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* `tables1973` 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 = 51007 AND t.round = 26 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* `tables1972` 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 = 51010 AND t.round = 30 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* `tables1971` 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 = 51013 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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* `tables1970` 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 = 51018 AND t.round = 42 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* `tables1969` 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 = 51020 AND t.round = 26 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* `tables1968` 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 = 51024 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 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 = 50915 ORDER BY nameShow LIMIT 100

Tekirdağspor

Tekirdağspor

Selecciona un equipo

Competiciones que juega

2. Lig Grupo 9

RIVALES EN Copa Turca

RIVALES EN 2. Lig