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

« Temporada Anterior

Temporada 2006

Temporada Siguiente »

2005/2006

primera liga de austria, erste liga, segunda de austria, 2.liga

Eliminatoria

Segunda Austria 2006

Segunda Austria

Segunda Austria

Ver

TEMPORADA 2005/2006

Equipo		PJ	GF	GC	Puntos
1	SCR Altach	36	61	35	68
2	LASK	36	51	30	66
3	Austria	36	54	32	62
4	Austria Wien	36	58	40	58
5	Gratkorn	36	47	40	54
6	Leoben	36	59	49	51
7	FC Kärnten	36	57	50	51
8	Kapfenberger	36	51	69	39
9	Schwanenstad	36	33	57	33
10	Kufstein	36	23	92	16

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	SV Ried	36	79	38	77
2	Kapfenberger	36	64	37	71
3	FC Kärnten	36	68	41	58
4	Austria	36	55	43	56
5	Leoben	36	43	49	47
6	SCR Altach	36	37	45	41
7	LASK	36	38	64	39
8	Untersiebenb	36	45	66	34
9	Gratkorn	36	43	58	32
10	Wörgl	36	32	63	32

Ver

TEMPORADA 2003/2004

Equipo		PJ	GF	GC	Puntos
1	Wacker	36	65	44	72
2	Austria	36	55	36	65
3	Kapfenberger	36	68	55	60
4	Untersiebenb	36	61	48	60
5	SV Ried	36	60	43	56
6	Leoben	36	44	44	46
7	LASK	36	46	55	44
8	Wörgl	36	48	66	37
9	FC Lustenau	36	40	58	31
10	BSV Juniors	36	31	69	24

Ver

TEMPORADA 2002/2003

Equipo		PJ	GF	GC	Puntos
1	Mattersburg	36	58	33	70
2	Leoben	36	69	57	57
3	Austria	36	41	40	53
4	Untersiebenb	36	59	58	52
5	LASK	36	47	47	49
6	Kapfenberger	36	50	49	48
7	FC Lustenau	36	53	53	46
8	Wörgl	36	44	58	45
9	Bleiberg	36	49	60	44
10	Wiener SC	36	56	71	42

Ver

TEMPORADA 2001/2002

Equipo		PJ	GF	GC	Puntos
1	Superfund	36	66	37	72
2	Austria	36	68	36	70
3	Bleiberg	36	68	38	67
4	Untersiebenb	36	57	39	62
5	LASK	36	45	38	52
6	Mattersburg	36	60	57	47
7	Leoben	36	51	51	46
8	Wörgl	36	61	72	34
9	Braunau	36	25	85	24
10	FC Lustenau	36	33	81	22

Ver

TEMPORADA 2000/2001

Equipo		PJ	GF	GC	Puntos
1	FC Kärnten	36	71	34	70
2	Bleiberg	36	71	42	68
3	Untersiebenb	36	61	56	57
4	Leoben	36	59	45	54
5	Austria	36	58	55	49
6	Wörgl	36	58	69	45
7	Mattersburg	36	52	67	42
8	Braunau	36	46	67	41
9	First Vienna	36	41	59	38
10	WSG Tirol	36	39	62	34

Ver

TEMPORADA 1999/2000

Equipo		PJ	GF	GC	Puntos
1	Admira	36	70	29	77
2	Leoben	36	50	32	66
3	Wörgl	36	58	41	62
4	Untersiebenb	36	50	31	57
5	FC Kärnten	36	54	40	57
6	Braunau	36	42	37	51
7	First Vienna	36	55	43	50
8	WSG Tirol	36	52	66	38
9	Polten	34	25	58	30
10	Vorwarts	34	13	92	4

Ver

TEMPORADA 1998/1999

Equipo		PJ	GF	GC	Puntos
1	SW Bregenz	36	66	48	69
2	Polten	36	54	41	58
3	Admira	36	44	42	54
4	First Vienna	36	51	43	52
5	Braunau	36	31	34	48
6	Austria	36	41	41	45
7	Wörgl	36	46	56	45
8	Leoben	36	47	44	44
9	Spittal	36	33	40	40
10	Stockerau	36	35	59	37

Ver

TEMPORADA 1997/1998

Equipo		PJ	GF	GC	Puntos
1	Vorwarts	28	59	30	54
2	Spittal	28	52	30	50
3	First Vienna	28	44	26	46
4	Braunau	28	42	27	46
5	SW Bregenz	28	44	31	45
6	Leoben	28	40	43	41
7	Stockerau	28	44	45	40
8	Gerasdorf	28	49	47	39
9	Polten	28	32	40	39
10	SCR Altach	28	30	31	38
11	Hartberg	28	35	39	35
12	WSG Tirol	28	32	36	34
13	Kufstein	28	22	37	28
14	Kottingbrunn	28	28	60	19
15	Eintracht	28	24	55	18

Ver

TEMPORADA 1996/1997

Equipo		PJ	GF	GC	Puntos
1	Austria	30	60	18	65
2	Vorwarts	30	65	26	60
3	First Vienna	30	67	31	58
4	Gerasdorf	30	54	38	51
5	Spittal	30	43	26	50
6	Polten	30	54	49	48
7	SW Bregenz	30	39	38	43
8	Stockerau	30	39	36	42
9	Braunau	30	36	35	41
10	Kufstein	30	29	42	41
11	WSG Tirol	30	41	45	38
12	Leoben	30	35	37	35
13	Modling	30	35	55	34
14	Hartberg	30	34	48	30
15	Flavia Solva	30	19	69	15
16	Favoritner	30	16	73	12

Ver

TEMPORADA 1995/1996

Equipo		PJ	GF	GC	Puntos
1	FC Linz	30	62	27	68
2	Gerasdorf	30	54	25	56
3	First Vienna	30	48	39	48
4	Modling	30	45	33	46
5	Leoben	30	41	33	44
6	Favoritner	30	38	31	44
7	Austria	30	34	24	40
8	Braunau	30	39	40	38
9	WSG Tirol	30	34	34	36
10	Flavia Solva	30	21	37	36
11	Spittal	30	35	42	35
12	Kufstein	30	33	42	35
13	Polten	30	36	51	34
14	Klagenfurt	30	30	50	32
15	Oberwart	30	33	49	30
16	Klingenbach	30	28	54	20

Ver

TEMPORADA 1994/1995

Equipo		PJ	GF	GC	Puntos
1	Grazer AK	30	62	15	50
2	SV Ried	30	55	18	46
3	First Vienna	30	68	33	40
4	Spittal	30	59	36	40
5	Austria	30	60	26	36
6	Polten	30	53	32	35
7	Oberwart	30	40	40	31
8	Wiener SC	30	40	42	31
9	Kufstein	30	32	44	29
10	Leoben	30	30	31	27
11	Braunau	30	33	50	25
12	Flavia Solva	30	22	42	23
13	Klingenbach	30	20	44	21
14	Puch	30	33	59	21
15	Stockerau	30	16	50	15
16	Wiener	30	24	85	10

Ver

TEMPORADA 1993/1994

Equipo		PJ	GF	GC	Puntos
1	LASK	30	65	16	52
2	FC Linz	30	64	31	44
3	Grazer AK	30	63	20	43
4	SV Ried	30	52	39	37
5	Spittal	30	64	37	33
6	First Vienna	30	35	32	32
7	Stockerau	30	43	46	32
8	Puch	30	44	35	31
9	Oberwart	30	33	34	28
10	Leoben	30	33	40	28
11	Kufstein	30	31	38	28
12	Braunau	30	38	39	27
13	Wiener	30	37	70	23
14	Favoritner	30	31	64	19
15	WSG Tirol	30	25	67	13
16	Kremser SC	30	16	66	10

Ver

TEMPORADA 1992/1993

Equipo		PJ	GF	GC	Puntos
1	First Vienna	36	48	34	39
2	Spittal	36	57	55	37
3	Puch	36	45	55	35
4	Kremser SC	36	47	60	34
5	Stockerau	36	48	67	33
6	Oberwart	36	41	46	31
7	WSG Tirol	36	47	53	31
8	LUV Graz	36	39	51	30
9	Grazer AK	22	33	14	29
10	SV Ried	22	34	21	27
11	Leoben	22	32	22	26
12	Favoritner	22	32	25	24

Ver

TEMPORADA 1991/1992

Equipo		PJ	GF	GC	Puntos
1	Favoritner	36	52	38	42
2	WSG Tirol	36	42	39	40
3	Stockerau	36	51	46	36
4	Austria	36	47	54	30
5	Spittal	36	48	58	30
6	SV Ried	36	43	54	30
7	LASK	22	38	20	29
8	Grazer AK	22	41	27	29
9	Donaufeld	36	38	61	29
10	SCR Altach	36	40	58	28
11	Modling	22	35	30	27
12	Wiener SC	22	37	27	26

Ver

TEMPORADA 1990/1991

Equipo		PJ	GF	GC	Puntos
1	Grazer AK	36	57	31	46
2	Donaufeld	36	58	60	36
3	WSG Tirol	36	55	59	35
4	Spittal	36	52	54	32
5	Modling	22	59	22	31
6	FC Linz	22	45	32	30
7	Vösendorf	36	40	61	30
8	Stockerau	22	34	23	29
9	LASK	22	41	27	28
10	FC Salzburg	36	76	81	28
11	Austria	36	30	57	27
12	Wolfsberger	36	39	79	24

Ver

TEMPORADA 1989/1990

Equipo		PJ	GF	GC	Puntos
1	Vorwarts	14	29	14	22
2	Wiener SC	14	20	18	15
3	Kremser SC	14	18	17	15
4	Leoben	14	16	15	14
5	FC Linz	14	19	18	13
6	Modling	14	21	22	13
7	Grazer AK	14	18	25	11
8	Spittal	14	13	25	9

Ver

TEMPORADA 1988/1989

Equipo		PJ	GF	GC	Puntos
1	Sturm Graz	14	32	13	21
2	Vorwarts	14	26	17	19
3	Salzburg	14	18	20	17
4	Kremser SC	14	24	17	16
5	LASK	14	22	20	14
6	Austria	14	21	24	13
7	Flavia Solva	14	9	25	9
8	Kufstein	14	12	28	3

Ver

TEMPORADA 1987/1988

Equipo		PJ	GF	GC	Puntos
1	FC Linz	14	16	7	18
2	Austria	14	18	12	18
3	Polten	14	30	17	17
4	Vorwarts	14	14	8	17
5	LASK	14	17	18	15
6	Kremser SC	14	14	16	12
7	Salzburg	14	10	20	9
8	Modling	14	14	35	6

Ver

TEMPORADA 1986/1987

Equipo		PJ	GF	GC	Puntos
1	Modling	14	19	9	18
2	First Vienna	14	29	18	17
3	Grazer AK	14	16	12	17
4	Austria	14	12	17	16
5	Vorwarts	14	16	15	14
6	Salzburg	14	11	19	12
7	Eisenstadt	14	14	22	10
8	Leoben	14	11	16	8

Ver

TEMPORADA 1985/1986

Equipo		PJ	GF	GC	Puntos
1	First Vienna	14	20	19	18
2	FC Linz	14	22	15	17
3	Wiener SC	14	21	14	15
4	Eisenstadt	14	18	15	15
5	Leoben	14	22	19	14
6	Spittal	14	15	18	13
7	Vorwarts	14	14	18	13
8	Salzburger	14	8	22	7

Ver

TEMPORADA 1984/1985

Equipo		PJ	GF	GC	Puntos
1	Flavia Solva	30	66	23	60
2	Salzburger	30	57	18	60
3	Kremser SC	30	52	31	59
4	Vorwarts	30	37	32	46
5	Sankt Veit	30	42	35	43
6	Kufstein	30	34	33	43
7	SW Bregenz	30	33	39	43
8	Voitsberg	30	53	40	42
9	Thörl	30	37	36	42
10	WSG Tirol	30	37	41	41
11	FC Salzburg	30	40	48	41
12	Oberwart	30	45	54	37
13	Simmeringer	30	29	44	34
14	Kapfenberger	30	33	45	33
15	Badener	30	30	58	22
16	Wolfsberger	30	27	75	13

JUGADORES DESTACADOS

Nombre	Goles	Equipo
I. Vastic	19	LAS
Markus Aigner	17	LBN
A. Hobel	17	SCA
Georges Panagiotopoulos	16	GKN
Gerald Krajic	15	LBN
Rade Djokic	14	KAP
C. Saurer	12	AUS
Oliver Mattle	11	ALT
J. Parapatits	10	AUS
A. Kozelsky	10	LBN

Equipos de esta liga

USO DE MEMORIA

6,871,032 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.6530
Total Execution Time	0.6550

CADENA URL

/erste_liga_austria2006/grupo1/historico

GET DATOS

$_GET['/erste_liga_austria2006/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=337 AND type_rel = 3
0.0148	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 337 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148	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 (1217055,1213703,1054642,1053655,1020782) ORDER BY n.cover_points DESC, update_date DESC
0.0146	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 8916 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 337 AND group_code = 1 and tables = 1 AND year <= 2006 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0149	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 = 8916 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 8914 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 8912 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 8911 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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* `tables2002` 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 = 8908 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables2001` 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 = 8906 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 10039 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 10040 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0221	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 = 10041 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 10042 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 10043 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 10044 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 10046 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 10047 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 10048 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 10060 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 10061 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 10062 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 10063 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 10064 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 10065 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 12:42:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 12:42:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 12:42:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 12:42:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0217	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2006 e ON e.player_id = p.id AND e.league_id = 8916 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8916 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0222	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2006 e ON e.player_id = p.id AND e.league_id = 8916 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8916 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0191	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2006 e ON e.player_id = p.id AND e.league_id = 8916 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8916 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155	SELECT ,(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 = 8916 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Nombre	Rojas	Equipo
Wolfgang Thaler	2	KUF
T. De Lima	2	SCA
M. Hartl	2	SCH
A. Djordjevic	2	SCH
Almedin Hota	2	FCK
Manuel Schmid	2	ALT
Andreas Feichtinger	2	SCH
O. Schnellrieder	2	ALT
Harald Ruckendorfer	2	LAS
Andreas Lipa	1	SCA


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Nombre	Amarillas	Equipo
Wolfgang Thaler	18	KUF
M. Briza	14	LBN
O. Schnellrieder	14	ALT
Georges Panagiotopoulos	13	GKN
G. Harding	13	LBN
C. Stückler	13	FCK
Thomas Gruber	12	KUF
W. Klapf	11	LAS
D. Hofer	11	GKN
H. Dürr	11	SCA