Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Keciorengucu

Entrenador: Tahsin Tam

Temporada 2006/2007

TEMPORADA 2006/2007

2. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Karabükspor	14	14	8	29
2	Pendikspor	14	19	12	26
3	Gebzespor	14	20	16	21
4	Keciorengucu	14	21	16	20
5	Darica	14	24	21	19
6	Maltepespor	14	14	23	14
7	Zeytinburnus	14	16	21	13
8	Cankirispor	14	10	21	12

TEMPORADA 2005/2006

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Keciorengucu	30	48	24	65
2	Fethiyespor	30	48	25	64
3	Sarayköy	30	51	32	58
4	Akhisar	30	52	38	54
5	Ispartaspor	30	37	27	49
6	Afyonkarahis	30	36	38	41
7	Yeni	30	40	42	40
8	Göztepe	30	40	43	40
9	Sidespor	30	39	40	39
10	Yeni Burdur	30	36	44	36
11	Karacabeyspo	30	34	30	35
12	Aliağa	30	29	31	35
13	Altinordu	30	34	41	34
14	Kütahyaspor	30	36	44	32
15	Anadolu	30	29	45	29
16	Akseki	30	16	61	9

TEMPORADA 2004/2005

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pazarspor	30	65	26	61
2	Giresunspor	30	50	16	60
3	Araklispor	30	49	24	60
4	Ofspor	30	55	34	59
5	Tokatspor	30	44	32	45
6	Corumspor	30	40	28	45
7	Keciorengucu	30	40	27	44
8	Arsinspor	30	43	38	39
9	Divrigispor	30	36	44	39
10	Kızılcaham	30	29	47	37
11	Gumushanespo	30	34	48	32
12	Çubukspor	30	32	42	30
13	Tarım	30	37	43	28
14	Karsspor	30	20	50	27
15	SinopSpor	30	25	54	26
16	Amasyaspor	30	26	72	18

TEMPORADA 2003/2004

3. LIG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Unyespor	31	52	23	62
2	Hacettepe	30	57	28	60
3	Giresunspor	30	46	27	52
4	Pazarspor	30	43	35	43
5	Araklispor	30	32	29	41
6	SinopSpor	30	43	48	41
7	Çubukspor	30	30	41	41
8	Keciorengucu	30	46	47	39
9	Mamak Fk	30	35	40	38
10	Tarım	30	34	30	37
11	Tokatspor	30	41	44	37
12	Kızılcaham	30	42	43	36
13	Corumspor	30	36	37	36
14	Ofspor	30	27	40	36
15	Artvin	30	31	39	33
16	Merzifonspor	31	33	51	33
17	Murgul	30	23	49	30

TEMPORADA 2002/2003

3. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Aksarayspor	26	50	23	56
2	Eskişehir	26	50	20	54
3	Hacettepe	26	49	20	54
4	Boluspor	26	46	21	53
5	Mamak Fk	26	43	16	48
6	Karamanspor	26	42	30	43
7	Afjet	26	42	35	41
8	Keciorengucu	26	41	33	40
9	Yeni	26	42	33	39
10	Alanyaspor	27	32	32	34
11	Bilecikspor	26	36	38	30
12	Düzcespor	27	29	39	30
13	Kızılcaham	26	34	46	30
14	Kayseri	26	3	75	3
15	Mobellaspor	26	0	78	0

TEMPORADA 1999/2000

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ispartaspor	32	63	18	68
2	Afjet	32	55	24	65
3	Petrol Ofisi	32	38	22	54
4	Keciorengucu	31	44	34	52
5	Mamak Fk	31	40	29	49
6	Aksarayspor	32	44	45	46
7	Seydişehir	32	24	25	46
8	Side	32	43	47	42
9	Eskişehir	32	46	45	41
10	Kemerspor	32	30	44	38
11	Dalaman	32	27	32	37
12	Sidespor	31	37	40	36
13	Alanyaspor	32	32	43	36
14	Karamanspor	32	30	42	36
15	Fethiyespor	32	30	46	35
16	Anamur	32	29	51	34
17	Manavgat	31	26	51	24

TEMPORADA 1998/1999

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kırıkkales	32	49	19	62
2	Bilecikspor	32	49	25	58
3	Cankirispor	32	44	26	58
4	Düzcespor	31	51	30	56
5	Keciorengucu	32	44	32	52
6	ASKİspor	32	35	24	51
7	Türk	32	42	39	44
8	Akçakocaspo	32	43	46	42
9	Keskinspor	32	49	50	41
10	Kastamonuspo	31	44	51	40
11	Erdemir	32	37	40	38
12	Karadeniz	32	44	48	37
13	Mudurnuspor	32	32	36	37
14	Çubukspor	31	32	47	36
15	Çaycumaspor	32	32	49	33
16	Beypazarı	32	22	51	32
17	Bartinspor	31	24	60	25

TEMPORADA 1997/1998

1. LIG GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Erzincanspor	14	26	20	25
2	Artvin	14	15	13	23
3	Giresunspor	14	19	16	21
4	Ankara	14	19	19	20
5	Orduspor	14	12	12	20
6	Yozgatspor	14	17	16	16
7	Keciorengucu	14	12	16	16
8	Corumspor	14	10	18	12

TEMPORADA 1996/1997

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Boluspor	32	70	15	77
2	Keciorengucu	32	62	22	65
3	ASKİspor	32	49	29	62
4	Kastamonuspo	32	40	37	50
5	Merzifonspor	32	47	32	49
6	Akçakocaspo	32	52	46	47
7	Beypazarı	32	46	52	43
8	Karadeniz	32	33	44	43
9	Cankirispor	32	38	34	41
10	Kırıkkales	32	35	36	39
11	Keskinspor	32	40	55	38
12	Erdemir	32	33	46	37
13	Çaycumaspor	32	29	51	37
14	Kozlu	32	24	43	36
15	Çubukspor	32	38	39	35
16	Ziraat	32	31	35	35
17	Yeni	32	32	83	19

TEMPORADA 1995/1996

2. LIG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Unyespor	26	47	16	57
2	Keciorengucu	26	37	19	53
3	ASKİspor	26	39	16	49
4	Kastamonuspo	26	39	22	43
5	Kadıköyspo	26	34	21	41
6	Çarşambasp	26	32	24	38
7	Çubukspor	26	34	36	36
8	Yeni	26	27	34	36
9	Tokatspor	26	34	34	34
10	Merzifonspor	26	30	32	33
11	Amasyaspor	26	30	27	31
12	Turhalspor	26	26	32	30
13	Erbaaspor	26	27	45	24
14	DHMİ Ankara	26	0	78	0

TEMPORADA 1994/1995

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Türk	26	75	27	61
2	Keciorengucu	26	71	18	60
3	Kırıkkales	26	51	26	55
4	Ankara	26	60	28	54
5	Aksarayspor	26	37	40	33
6	Kayserispor	26	33	33	30
7	Keskinspor	25	23	29	30
8	Nevşehir	26	33	46	30
9	Niğdespor	26	33	46	26
10	Kayseri	26	22	46	26
11	DHMİ Ankara	26	31	46	25
12	Kızılcaham	26	30	49	25
13	Ankara	26	24	51	21
14	Polatlıspor	25	27	65	18

TEMPORADA 1993/1994

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Turanspor	24	42	10	54
2	Nevşehir	24	44	21	53
3	Ankara	24	50	24	46
4	Kırıkkales	24	38	23	45
5	Çubukspor	24	36	26	40
6	Beypazarı	24	30	25	29
7	Niğdespor	24	32	35	29
8	Aksarayspor	24	23	30	29
9	Ankara	24	31	36	28
10	Polatlıspor	24	26	41	27
11	Keciorengucu	24	33	35	26
12	Tarımspor	24	37	44	23
13	Ankara DSİ	24	0	72	0

TEMPORADA 1992/1993

1. LIG GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Ispartaspor	14	19	8	26
2	Boluspor	14	25	16	22
3	Tarsus Idman	14	13	9	20
4	Kütahyaspor	14	9	11	20
5	Alanyaspor	14	14	14	19
6	Türk	14	9	11	15
7	Keciorengucu	14	13	15	13
8	Mudurnuspor	14	5	23	11

TEMPORADA 1991/1992

1. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kayseri	32	65	23	69
2	Petrol Ofisi	32	52	29	54
3	Adanaspor	32	56	49	51
4	Siirtspor	32	47	46	48
5	Malatyaspor	32	36	37	45
6	Muş Spor	32	40	58	45
7	Keciorengucu	32	41	43	44
8	Türk	32	33	36	44
9	Diyarbakirsp	32	44	50	43
10	Mersin	32	44	39	42
11	Erzurumspor	32	39	39	41
12	Tarsus Idman	32	27	25	40
13	Kahramanmara	32	39	51	40
14	Vanspor	32	45	51	39
15	Hatayspor	32	31	38	39
16	Elazigspor	32	30	46	37
17	Turanspor	32	30	39	33

TEMPORADA 1990/1991

1. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Adana	32	82	31	73
2	Malatyaspor	32	61	24	65
3	Mersin	32	69	36	64
4	Petrol Ofisi	32	53	40	61
5	Siirtspor	32	41	34	55
6	Keciorengucu	32	58	50	44
7	Erzurumspor	32	29	35	43
8	Vanspor	32	36	39	40
9	Turanspor	32	28	33	40
10	Hatayspor	32	39	48	40
11	Elazigspor	32	35	46	40
12	Türk	32	41	52	39
13	Diyarbakirsp	32	38	52	39
14	Kahramanmara	32	33	46	33
15	Nevşehir	32	28	43	33
16	Niğdespor	32	35	58	31
17	Polatlıspor	32	21	60	19

TEMPORADA 1989/1990

1. LIG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gaziantepspo	32	60	32	69
2	Petrol Ofisi	32	38	21	52
3	Mersin	32	43	37	52
4	Keciorengucu	32	56	47	49
5	Siirtspor	32	38	26	48
6	Diyarbakirsp	32	38	37	47
7	Polatlıspor	32	31	40	47
8	Niğdespor	32	30	32	44
9	Türk	32	45	41	43
10	Turanspor	32	41	41	43
11	Nevşehir	32	37	40	42
12	Vanspor	32	27	26	41
13	Erzurumspor	32	38	44	40
14	Kahramanmara	32	38	52	40
15	İskenderuns	32	29	38	39
16	Sanliurfaspo	32	27	38	39
17	Erzincanspor	32	32	56	32

TEMPORADA 1988/1989

2. LIG GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Keciorengucu	33	90	33	79
2	Sivasspor	34	79	35	72
3	Aksarayspor	34	77	47	64
4	Corumspor	34	60	38	59
5	Ankara	34	63	36	58
6	Kırıkkales	34	59	38	57
7	Amasyaspor	34	59	41	57
8	Beypazarı	34	63	37	53
9	Kastamonuspo	34	52	55	44
10	Yeni	34	30	52	40
11	Sitespor	33	48	50	38
12	Kayseri	34	38	44	38
13	Sivas	34	53	62	37
14	Yozgatspor	34	36	47	36
15	Çubukspor	33	36	64	34
16	Cankirispor	34	42	72	34
17	Kirsehirspor	34	43	60	33
18	Kamanspor	33	15	132	13

Competiciones que juega

2. Lig Grupo 3

Pos	Equipos		Pts
1		Boluspor	32
2		Kartalspor	32
3		Karabükspor	28
4		Cankirispor	28
5		Zeytinburnuspor	26
6		Maltepespor	26
7		Pendikspor	23
8		Gebzespor	22
9		Keciorengucu	17
10		Darica Genclerbirligi	8

RIVALES EN 2. Lig

USO DE MEMORIA

6,752,232 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1571
Total Execution Time	0.1583

CADENA URL

/historico/Keciorengucu/2007

GET DATOS

$_GET['/historico/Keciorengucu/2007']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0037	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Keciorengucu' AND l.year = 2007 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.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12981 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.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=12981 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12981 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 50653
0.0025	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 = 50659
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12981 AND type_rel = 2
0.0035	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '12981' AND l.year = 2007 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 = '12981' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 50659 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=12981 AND l.year in (2006,2007,2008) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (50659,50232) 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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 50659 AND teamId = 12981
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 50232 AND teamId = 12981
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 FROM* `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50653 AND t.round = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '12981' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12981' and rp.type = 4
0.0021	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 = '12981' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021	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 events2007 e ON e.player_id = p.id AND e.league_id = 50653 WHERE rp.league_id = 50653 AND rp.teamId = 12981 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 events2007 e ON e.player_id = p.id AND e.league_id = 50653 WHERE rp.league_id = 50653 AND rp.teamId = 12981 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 events2007 e ON e.player_id = p.id AND e.league_id = 50653 WHERE rp.league_id = 50653 AND rp.teamId = 12981 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 12981 AND l.year <= 2007 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* `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50653 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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 = 50659 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* `tables2006` 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 = 50232 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* `tables2005` 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 = 50238 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* `tables2004` 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 = 50243 AND t.round = 32 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* `tables2003` 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 = 50248 AND t.round = 28 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* `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 = 50711 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* `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 = 50730 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* `tables1998` 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 = 50317 AND t.round = 18 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* `tables1998` 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 = 50323 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* `tables1997` 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 = 50773 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* `tables1996` 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 = 50804 AND t.round = 26 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* `tables1995` 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 = 50814 AND t.round = 26 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* `tables1994` 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 = 50830 AND t.round = 26 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* `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 = 50377 AND t.round = 18 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* `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 = 50383 AND t.round = 14 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 = 50390 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* `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 = 50394 AND t.round = 34 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* `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 = 50397 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* `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 = 50885 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Keciorengucu

Keciorengucu

Selecciona un equipo

Competiciones que juega

2. Lig Grupo 3

RIVALES EN 2. Lig