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

Deportivo Alavés

Entrenador: Luis García

Temporada 1994/1995

TEMPORADA 1994/1995

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	92	26	61
2	Numancia	38	61	19	55
3	Sestao Sport	38	56	26	49
4	Beasain KE	38	44	28	46
5	Real Unión	38	51	36	45
6	Osasuna	38	47	43	44
7	Izarra	38	35	23	42
8	Lemona	38	40	51	38
9	Palencia	38	36	46	36
10	Real	38	29	38	35
11	Amurrio	38	34	44	34
12	Logroñés	38	42	54	33
13	Barakaldo	38	46	50	33
14	Club Bermeo	38	35	50	33
15	Tudelano	38	37	45	33
16	Casetas	38	48	57	32
17	Gimnástica	38	39	46	32
18	Deportivo	38	39	52	31
19	SD Gernika	38	34	49	31
20	Hullera	38	24	86	17

TEMPORADA 1993/1994

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	71	17	60
2	Sestao Sport	38	56	17	52
3	Numancia	38	50	30	52
4	Barakaldo	38	58	36	48
5	Club Bermeo	38	42	32	47
6	Beasain KE	38	45	33	40
7	Real	38	50	39	39
8	Osasuna	38	44	50	38
9	Logroñés	38	46	42	38
10	Lemona	38	46	39	38
11	Gimnástica	38	49	39	36
12	Izarra	38	40	39	36
13	Tudelano	38	38	43	35
14	Real Unión	38	37	44	34
15	Palencia	38	33	48	34
16	Real	38	32	52	33
17	CD Basconia	38	38	67	33
18	Andorra	38	41	54	31
19	Utebo	38	18	59	22
20	CD Touring	38	28	82	14

TEMPORADA 1992/1993

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	62	30	52
2	Barakaldo	38	54	29	45
3	Gimnástica	38	35	30	45
4	Palencia	38	51	44	45
5	Osasuna	38	37	31	44
6	Izarra	38	40	36	44
7	CD Basconia	38	52	35	43
8	Numancia	38	51	41	42
9	Real	38	49	39	38
10	FC Andorra	38	47	41	37
11	Real	38	42	53	36
12	Logroñés	38	34	40	36
13	Beasain KE	38	38	48	34
14	Lemona	38	32	34	34
15	Andorra	38	39	53	33
16	Tudelano	38	31	44	33
17	CD Hernani	38	39	50	32
18	Deportivo	38	35	51	32
19	CD Elgoibar	38	30	52	28
20	Santurtzi	38	25	42	27

TEMPORADA 1991/1992

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sant Andreu	38	70	35	54
2	Manlleu	38	61	32	49
3	Girona	38	66	44	48
4	Deportivo	38	51	31	48
5	L´Hospitale	38	65	44	46
6	FC Andorra	38	64	46	44
7	Barakaldo	38	49	33	44
8	Real	38	49	38	42
9	Gimnàstic	38	45	41	40
10	Osasuna	38	54	45	37
11	Deportivo	38	47	47	35
12	Mahonès	38	35	45	35
13	CD Basconia	38	36	52	35
14	CD Hernani	38	49	53	35
15	Lemona	38	33	50	35
16	Santurtzi	38	29	45	33
17	Fraga	38	29	68	27
18	Huesca	38	41	68	25
19	Mollerussa	38	46	78	24
20	CD Binéfar	38	30	54	24

TEMPORADA 1990/1991

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Racing	38	67	32	54
2	Deportivo	38	61	28	52
3	Osasuna	38	61	32	48
4	Real	38	52	31	47
5	Deportivo	38	59	36	44
6	Lemona	38	38	31	41
7	Barakaldo	38	37	34	40
8	FC Andorra	38	42	34	40
9	CD Basconia	38	35	37	40
10	Mollerussa	38	51	36	39
11	Numancia	38	45	41	38
12	Gimnástica	38	33	40	36
13	Huesca	38	39	51	34
14	CD Binéfar	38	31	39	34
15	Santurtzi	38	29	43	32
16	Izarra	38	34	56	31
17	Mirandés	38	21	43	30
18	SCD Durango	38	23	43	30
19	Andorra	38	24	42	30
20	CD Teruel	38	29	82	20

TEMPORADA 1989/1990

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	73	26	60
2	Aurrera KE	38	54	28	51
3	Tolosa CF	38	58	26	49
4	CD Mungia	38	47	27	45
5	Real Unión	38	49	35	42
6	CD Elgoibar	38	37	31	41
7	Larramendi	38	44	50	40
8	Mondragón	38	41	29	40
9	Zalla	38	35	36	40
10	CD Touring	37	36	37	39
11	Pasajes	38	30	32	39
12	Amorebieta	38	42	42	38
13	Galdakao	38	51	54	36
14	CD Hernani	38	33	40	36
15	Sodupe	38	31	49	34
16	SD Gernika	38	43	50	33
17	Arenas Getxo	37	35	39	32
18	Abetxuko	38	34	78	25
19	Zumaiako	38	34	55	22
20	Anaitasuna	38	21	64	16

TEMPORADA 1988/1989

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Santurtzi	38	71	30	55
2	Deportivo	38	59	29	52
3	CD Touring	38	58	39	50
4	Zalla	38	46	31	47
5	Tolosa CF	38	42	28	44
6	Real Unión	38	65	45	42
7	Larramendi	38	38	34	40
8	CD Mungia	38	45	35	38
9	Mondragón	38	47	47	36
10	Galdakao	38	43	48	36
11	CD Hernani	38	51	62	35
12	Anaitasuna	38	49	61	35
13	Aurrera KE	38	29	35	35
14	Arenas Getxo	38	37	42	34
15	SD Gernika	38	27	42	34
16	Pasajes	38	24	38	33
17	Amorebieta	38	44	55	33
18	Aurrera	38	42	48	33
19	Mutriku FT	38	21	54	24
20	Alegría	38	32	67	24

TEMPORADA 1987/1988

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Barakaldo	38	62	26	53
2	Aurrera KE	38	48	28	51
3	CD Hernani	38	54	39	50
4	Tolosa CF	38	48	25	48
5	Real Unión	38	48	26	47
6	Santurtzi	38	45	29	47
7	CD Mungia	38	48	35	45
8	Deportivo	38	49	35	43
9	Amorebieta	38	55	45	42
10	SD Gernika	38	45	41	40
11	Mondragón	38	48	56	35
12	Anaitasuna	38	38	49	34
13	Arenas Getxo	38	42	50	33
14	Zalla	38	33	42	33
15	Pasajes	38	37	56	33
16	Galdakao	38	33	49	28
17	CD Touring	38	40	54	26
18	Portugalete	38	27	59	25
19	SD Erandio	38	31	55	24
20	Aretxabaleta	38	32	64	23

TEMPORADA 1986/1987

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	SCD Durango	38	49	20	51
2	CD Basconia	38	59	26	50
3	Lemona	38	69	36	48
4	Barakaldo	38	58	38	48
5	Amorebieta	38	74	44	48
6	Santurtzi	38	54	33	47
7	Deportivo	38	58	37	47
8	Real Unión	38	39	34	41
9	Aurrera KE	38	33	35	37
10	Aretxabaleta	38	34	50	36
11	Zalla	38	43	56	36
12	Arenas Getxo	38	40	43	35
13	SD Erandio	38	35	44	34
14	Portugalete	38	22	31	32
15	CD Hernani	38	39	54	31
16	Tolosa CF	38	36	53	30
17	Anaitasuna	38	23	43	30
18	Mutriku FT	38	26	52	29
19	SD Gernika	38	34	59	28
20	Santutxu	38	26	63	22

TEMPORADA 1985/1986

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UE Figueres	38	71	31	55
2	Burgos	38	47	32	48
3	Salamanca	38	55	32	48
4	Lleida	38	49	25	46
5	Deportivo	38	46	31	46
6	CD Ourense	38	49	32	46
7	Palencia	38	43	34	43
8	Real	38	57	53	42
9	Pontevedra	38	48	41	39
10	L´Hospitale	38	55	52	39
11	Zamora	38	47	38	39
12	CD Binéfar	38	47	51	37
13	Andorra	38	59	58	37
14	Gimnàstic	38	43	42	36
15	FC Andorra	38	43	57	31
16	Sporting	38	39	61	29
17	Arosa	38	37	67	29
18	Compostela	38	46	72	26
19	Barcelona C	38	35	61	23
20	Lalín	38	26	72	21

TEMPORADA 1984/1985

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sestao Sport	38	59	28	55
2	Deportivo	38	56	31	54
3	Deportivo	38	70	38	50
4	Andorra	38	51	38	46
5	UE Figueres	38	65	50	43
6	Lleida	38	51	45	42
7	Pontevedra	38	56	41	41
8	CD Binéfar	38	49	40	40
9	FC Andorra	38	51	57	38
10	Sporting	38	43	48	36
11	Zamora	38	41	54	36
12	Palencia	38	47	46	36
13	Gimnàstic	38	41	44	35
14	Arosa	38	44	52	35
15	Compostela	38	41	55	34
16	Barcelona C	38	54	62	33
17	Real	38	41	47	33
18	Osasuna	38	42	55	30
19	Real Avilés	38	47	62	27
20	SD Erandio	38	38	94	16

TEMPORADA 1983/1984

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CE Sabadell	38	73	31	51
2	Logroñés	38	68	26	51
3	Deportivo	38	65	35	50
4	UE Figueres	38	56	47	48
5	Gimnàstic	38	57	38	47
6	Sestao Sport	38	57	36	46
7	CD Binéfar	38	50	40	42
8	Lleida	38	53	39	42
9	Real	38	43	38	41
10	FC Andorra	38	52	44	41
11	Osasuna	38	39	44	38
12	Andorra	38	47	50	37
13	Sporting	38	50	47	37
14	Compostela	38	41	55	33
15	Arosa	38	39	64	30
16	Real Avilés	38	50	68	29
17	SD Erandio	38	42	65	29
18	Barakaldo	38	46	75	28
19	Huesca	38	33	68	24
20	Racing	38	25	76	16

TEMPORADA 1982/1983

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Real Murcia	38	68	30	54
2	Cádiz	38	56	37	47
3	Mallorca	38	54	37	46
4	Deportivo	38	58	36	46
5	Palencia	38	42	34	43
6	RM Castilla	38	45	43	41
7	Elche	38	51	38	41
8	Hércules	38	44	41	40
9	Rayo	38	53	50	39
10	Recreativo	38	46	50	39
11	Barça	38	46	40	38
12	Real Oviedo	38	35	45	36
13	Atlético B	38	44	44	36
14	Linares CF	38	28	41	36
15	Castellón	38	45	60	35
16	Cartagena	38	40	46	34
17	Deportivo	38	40	54	32
18	CE Sabadell	38	43	51	30
19	Xerez CD	38	36	56	25
20	Córdoba CF	38	30	71	22

TEMPORADA 1981/1982

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Celta	38	79	40	53
2	Salamanca	38	70	33	51
3	CD Málaga	38	70	35	50
4	Elche	38	55	31	50
5	Real Murcia	38	54	38	46
6	Mallorca	38	55	46	42
7	Rayo	38	45	44	41
8	RM Castilla	38	48	48	40
9	Burgos	38	46	41	40
10	Atlético B	38	44	44	38
11	CE Sabadell	38	59	63	38
12	Deportivo	38	40	48	37
13	Córdoba CF	38	45	49	36
14	Recreativo	38	39	40	35
15	Linares CF	38	42	57	34
16	Real Oviedo	38	34	53	31
17	AD Almería	38	27	43	30
18	Deportivo	38	38	52	29
19	Levante	38	26	74	20
20	Getafe	38	39	76	19

TEMPORADA 1980/1981

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Castellón	38	45	33	45
2	Cádiz	38	55	37	45
3	Racing	38	48	40	45
4	Elche	38	55	44	45
5	Rayo	38	37	23	45
6	CD Málaga	38	47	45	42
7	CE Sabadell	38	45	44	42
8	Deportivo	38	49	35	39
9	Levante	38	36	37	38
10	Real Oviedo	38	37	39	37
11	RM Castilla	38	50	44	36
12	Linares CF	38	36	42	36
13	Getafe	38	41	50	35
14	Atlético B	38	44	55	35
15	Burgos	38	47	52	35
16	Recreativo	38	33	37	35
17	Granada	38	33	45	33
18	Palencia	38	30	37	32
19	Barakaldo	38	34	46	31
20	AgD Ceuta	38	33	50	29

TEMPORADA 1979/1980

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Real Murcia	38	58	39	47
2	Real	38	53	40	45
3	Osasuna	38	74	49	44
4	Castellón	38	47	42	42
5	Elche	38	46	41	42
6	CE Sabadell	38	47	49	41
7	RM Castilla	38	46	39	40
8	Cádiz	38	43	42	39
9	Deportivo	38	37	39	38
10	Levante	38	47	51	38
11	Real Oviedo	38	40	45	38
12	Recreativo	38	38	42	37
13	Granada	38	42	42	37
14	Getafe	38	44	50	37
15	Palencia	38	49	49	36
16	Racing	38	34	39	36
17	Celta	38	48	43	35
18	Deportivo	38	49	50	35
19	Gimnàstic	38	29	61	27
20	Algeciras	38	29	48	26

TEMPORADA 1978/1979

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	AD Almería	38	62	44	47
2	CD Málaga	38	47	27	47
3	Real Betis	38	58	35	46
4	Real	38	47	32	46
5	Elche	38	50	31	45
6	Granada	38	46	34	44
7	RM Castilla	38	55	45	42
8	Cádiz	38	52	47	41
9	Deportivo	38	45	31	40
10	Getafe	38	57	56	40
11	Castellón	38	48	43	38
12	CE Sabadell	38	50	49	37
13	Osasuna	38	51	51	37
14	Real Murcia	38	35	52	35
15	Deportivo	38	43	45	35
16	Algeciras	38	40	53	34
17	Real Jaén	38	41	55	34
18	Terrassa FC	38	34	51	29
19	Barakaldo	38	31	53	28
20	Racing	38	22	80	15

TEMPORADA 1977/1978

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Real	38	68	46	50
2	Recreativo	38	51	33	46
3	Celta	38	51	31	46
4	Barakaldo	38	53	51	44
5	Real Murcia	38	58	55	40
6	CE Sabadell	38	46	50	40
7	Real	38	44	48	39
8	Deportivo	38	63	47	39
9	Granada	38	46	44	38
10	Osasuna	38	53	47	38
11	Deportivo	38	47	40	38
12	Terrassa FC	38	46	52	37
13	CD Málaga	38	41	42	37
14	Castellón	38	34	37	35
15	Real Jaén	38	38	42	35
16	Getafe	38	32	44	35
17	Real Oviedo	38	40	42	35
18	Córdoba CF	38	37	46	32
19	Tenerife	38	34	52	31
20	Puertollano	38	43	76	25

TEMPORADA 1976/1977

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Real	38	62	35	47
2	Cádiz	38	60	42	46
3	Rayo	38	46	34	45
4	Real Jaén	38	42	32	43
5	Real Oviedo	38	48	43	43
6	Tenerife	38	48	48	40
7	Terrassa FC	38	44	34	40
8	Deportivo	38	57	42	40
9	Recreativo	38	42	50	38
10	Granada	38	42	39	36
11	Deportivo	38	40	50	36
12	Real	38	57	56	36
13	Getafe	38	37	48	35
14	Castellón	38	46	45	35
15	Córdoba CF	38	39	45	35
16	Puertollano	38	39	56	34
17	Pontevedra	38	34	44	34
18	Levante	38	47	61	34
19	Sant Andreu	38	39	52	33
20	Barça	38	39	52	30

TEMPORADA 1975/1976

SEGUNDA DIVISIÓN
Equipo		PJ	GF	GC	Puntos
1	Burgos	38	54	31	51
2	Celta	38	42	22	49
3	CD Málaga	38	75	39	47
4	Real	38	44	27	43
5	Deportivo	38	47	36	42
6	Barça	38	46	47	41
7	Tenerife	38	50	44	40
8	Córdoba CF	38	48	48	38
9	Rayo	38	48	49	36
10	Recreativo	38	35	42	36
11	Puertollano	38	42	51	36
12	Castellón	38	45	47	36
13	Cádiz	38	46	43	35
14	Sant Andreu	38	38	45	35
15	Deportivo	38	33	46	34
16	Terrassa FC	38	35	45	34
17	Real Murcia	38	46	61	33
18	Ensidesa	38	31	46	33
19	Osasuna	38	47	58	33
20	Gimnàstic	38	29	54	28

Comparar equipos

Deportivo Alavés

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda B - Play.

RIVALES EN Segunda División.

USO DE MEMORIA

8,783,760 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.7725
Total Execution Time	0.7740

CADENA URL

/historico/Alaves/1995

GET DATOS

$_GET['/historico/Alaves/1995']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0147	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 = 'Alaves' AND l.year = 1995 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.0126	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=137 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=137 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=137 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=137 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134	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 = 22259
0.0130	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 = 46255
0.0144	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 = '137' AND l.year = 1995 ORDER BY l.year DESC,cat.coefficient DESC
0.0148	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 = '137' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133	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 = 21729 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 46255 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 22259 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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=137 AND l.year in (1994,1995,1996) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (46256,22259,21757,5492) 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.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 5492 AND teamId = 137
0.0143	SELECT count(id) as num_players from rel_players WHERE league_id = 22259 AND teamId = 137
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 21757 AND teamId = 137
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 46256 AND teamId = 137
0.0126	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 21729 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0185	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 = '137' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '137' and rp.type = 4
0.0142	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 = '137' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '137' and rp.type = 4
0.0142	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 events1995 e ON e.player_id = p.id AND e.league_id = 21729 WHERE rp.league_id = 21729 AND rp.teamId = 137 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.0145	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 events1995 e ON e.player_id = p.id AND e.league_id = 21729 WHERE rp.league_id = 21729 AND rp.teamId = 137 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139	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 events1995 e ON e.player_id = p.id AND e.league_id = 21729 WHERE rp.league_id = 21729 AND rp.teamId = 137 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 137 AND l.year <= 1995 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0136	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 = 22259 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 22256 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 22253 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 22250 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 22247 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 21817 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 21798 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 21779 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 21760 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 21052 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 21051 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 21050 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 5479 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 5478 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 5477 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 5476 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 5475 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 5474 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 5473 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 5472 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC