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

« Temporada Anterior

Temporada 1920

Temporada Siguiente »

1919/1920

primera division de austria, austrian football bundesliga, liga austria, campeonato nacional de austria, liga austriaca,liga austria,bundesliga austria

Eliminatoria

Bundesliga Austria 1920

Bundesliga Austria

Bundesliga Austria:

Ver jornada

Jornada 1

19 Oct 19	Hertha Wien	Hertha Wien - Wiener SC 1919-10-19T00:00:00 No disponible 2 - 1	Wiener SC	...
24 Ago 19	Rudolfshüg	Rudolfshüg - FAC Wien 1919-08-24T00:00:00 No disponible 5 - 0	FAC Wien	...
24 Ago 19	WAF	WAF - Simmeringer 1919-08-24T00:00:00 No disponible 3 - 3	Simmeringer	...
24 Ago 19	Wacker Wien	Wacker Wien - Wiener AC 1919-08-24T00:00:00 No disponible 0 - 2	Wiener AC	...
24 Ago 19	Rapid Wien	Rapid Wien - Austria 1919-08-24T00:00:00 Allianz Stadion 1 - 2	Austria	...
24 Ago 19	Admira	Admira - First 1919-08-24T00:00:00 BSFZ-Arena 1 - 4	First	...

Ver jornada

Jornada 2

14 Sep 19	WAF	WAF - Hertha Wien 1919-09-14T00:00:00 No disponible 3 - 0	Hertha Wien	...
14 Sep 19	FAC Wien	FAC Wien - Simmeringer 1919-09-14T00:00:00 FAC-Platz 4 - 1	Simmeringer	...
14 Sep 19	Wacker Wien	Wacker Wien - Admira 1919-09-14T00:00:00 No disponible 6 - 1	Admira	...
14 Sep 19	Rudolfshüg	Rudolfshüg - First 1919-09-14T00:00:00 No disponible 5 - 1	First	...
14 Sep 19	Wiener SC	Wiener SC - Rapid Wien 1919-09-14T00:00:00 Sportclub-Platz 0 - 7	Rapid Wien	...
14 Sep 19	Wiener AC	Wiener AC - Austria 1919-09-14T00:00:00 No disponible 1 - 0	Austria	...

Ver jornada

Jornada 3

21 Sep 19	Admira	Admira - Rudolfshüg 1919-09-21T00:00:00 BSFZ-Arena 0 - 3	Rudolfshüg	...
21 Sep 19	Hertha Wien	Hertha Wien - FAC Wien 1919-09-21T00:00:00 No disponible 1 - 1	FAC Wien	...
21 Sep 19	Wiener AC	Wiener AC - Wiener SC 1919-09-21T00:00:00 No disponible 3 - 1	Wiener SC	...
21 Sep 19	First	First - Simmeringer 1919-09-21T00:00:00 Stadion Hohe Warte 3 - 3	Simmeringer	...
21 Sep 19	Wacker Wien	Wacker Wien - Austria 1919-09-21T00:00:00 No disponible 2 - 4	Austria	...
21 Sep 19	Rapid Wien	Rapid Wien - WAF 1919-09-21T00:00:00 Allianz Stadion 4 - 2	WAF	...

Ver jornada

Jornada 4

28 Sep 19	WAF	WAF - Wiener AC 1919-09-28T00:00:00 No disponible 2 - 2	Wiener AC	...
28 Sep 19	FAC Wien	FAC Wien - Rapid Wien 1919-09-28T00:00:00 FAC-Platz 1 - 0	Rapid Wien	...
28 Sep 19	First	First - Hertha Wien 1919-09-28T00:00:00 Stadion Hohe Warte 2 - 2	Hertha Wien	...
28 Sep 19	Austria	Austria - Admira 1919-09-28T00:00:00 Generali Arena 4 - 2	Admira	...
28 Sep 19	Rudolfshüg	Rudolfshüg - Simmeringer 1919-09-28T00:00:00 No disponible 2 - 0	Simmeringer	...
28 Sep 19	Wiener SC	Wiener SC - Wacker Wien 1919-09-28T00:00:00 Sportclub-Platz 4 - 0	Wacker Wien	...

Ver jornada

Jornada 5

12 Oct 19	Admira	Admira - Simmeringer 1919-10-12T00:00:00 BSFZ-Arena 1 - 0	Simmeringer	...
12 Oct 19	Austria	Austria - Wiener SC 1919-10-12T00:00:00 Generali Arena 2 - 2	Wiener SC	...
12 Oct 19	Hertha Wien	Hertha Wien - Rudolfshüg 1919-10-12T00:00:00 No disponible 0 - 2	Rudolfshüg	...
12 Oct 19	Wiener AC	Wiener AC - FAC Wien 1919-10-12T00:00:00 No disponible 2 - 2	FAC Wien	...
12 Oct 19	Wacker Wien	Wacker Wien - WAF 1919-10-12T00:00:00 No disponible 1 - 0	WAF	...
12 Oct 19	Rapid Wien	Rapid Wien - First 1919-10-12T00:00:00 Allianz Stadion 1 - 1	First	...

Ver jornada

Jornada 6

26 Oct 19	Wiener SC	Wiener SC - Admira 1919-10-26T00:00:00 Sportclub-Platz 2 - 2	Admira	...
26 Oct 19	FAC Wien	FAC Wien - Wacker Wien 1919-10-26T00:00:00 FAC-Platz 3 - 1	Wacker Wien	...
26 Oct 19	Hertha Wien	Hertha Wien - Simmeringer 1919-10-26T00:00:00 No disponible 1 - 3	Simmeringer	...
26 Oct 19	WAF	WAF - Austria 1919-10-26T00:00:00 No disponible 0 - 3	Austria	...
26 Oct 19	Rudolfshüg	Rudolfshüg - Rapid Wien 1919-10-26T00:00:00 No disponible 4 - 2	Rapid Wien	...
18 Oct 19	First	First - Wiener AC 1919-10-18T00:00:00 Stadion Hohe Warte 3 - 0	Wiener AC	...

Ver jornada

Jornada 7

20 Jun 20	Wiener AC	Wiener AC - Rudolfshüg 1920-06-20T00:00:00 No disponible 0 - 4	Rudolfshüg	...
14 Dic 19	Wacker Wien	Wacker Wien - First 1919-12-14T00:00:00 No disponible 4 - 1	First	...
14 Dic 19	Wiener SC	Wiener SC - WAF 1919-12-14T00:00:00 Sportclub-Platz 5 - 1	WAF	...
07 Dic 19	Rapid Wien	Rapid Wien - Simmeringer 1919-12-07T00:00:00 Allianz Stadion 2 - 1	Simmeringer	...
02 Nov 19	Admira	Admira - Hertha Wien 1919-11-02T00:00:00 BSFZ-Arena 1 - 2	Hertha Wien	...
01 Nov 19	Austria	Austria - FAC Wien 1919-11-01T00:00:00 Generali Arena 2 - 2	FAC Wien	...

Ver jornada

Jornada 8

22 Feb 20	Wiener AC	Wiener AC - Simmeringer 1920-02-22T00:00:00 No disponible 0 - 1	Simmeringer	...
21 Dic 19	Rudolfshüg	Rudolfshüg - Wacker Wien 1919-12-21T00:00:00 No disponible 2 - 2	Wacker Wien	...
16 Nov 19	Hertha Wien	Hertha Wien - Rapid Wien 1919-11-16T00:00:00 No disponible 1 - 2	Rapid Wien	...
16 Nov 19	First	First - Austria 1919-11-16T00:00:00 Stadion Hohe Warte 1 - 3	Austria	...
16 Nov 19	FAC Wien	FAC Wien - Wiener SC 1919-11-16T00:00:00 FAC-Platz 1 - 2	Wiener SC	...
15 Nov 19	WAF	WAF - Admira 1919-11-15T00:00:00 No disponible 7 - 2	Admira	...

Ver jornada

Jornada 9

22 Feb 20	Wiener SC	Wiener SC - First 1920-02-22T00:00:00 Sportclub-Platz 1 - 0	First	...
22 Feb 20	WAF	WAF - FAC Wien 1920-02-22T00:00:00 No disponible 0 - 1	FAC Wien	...
23 Nov 19	Admira	Admira - Rapid Wien 1919-11-23T00:00:00 BSFZ-Arena 2 - 5	Rapid Wien	...
23 Nov 19	Austria	Austria - Rudolfshüg 1919-11-23T00:00:00 Generali Arena 6 - 0	Rudolfshüg	...
23 Nov 19	Wiener AC	Wiener AC - Hertha Wien 1919-11-23T00:00:00 No disponible 3 - 1	Hertha Wien	...
23 Nov 19	Wacker Wien	Wacker Wien - Simmeringer 1919-11-23T00:00:00 No disponible 1 - 1	Simmeringer	...

Ver jornada

Jornada 10

30 Nov 19	First	First - WAF 1919-11-30T00:00:00 Stadion Hohe Warte 0 - 2	WAF	...
30 Nov 19	Austria	Austria - Simmeringer 1919-11-30T00:00:00 Generali Arena 4 - 1	Simmeringer	...
30 Nov 19	FAC Wien	FAC Wien - Admira 1919-11-30T00:00:00 FAC-Platz 0 - 0	Admira	...
30 Nov 19	Rudolfshüg	Rudolfshüg - Wiener SC 1919-11-30T00:00:00 No disponible 0 - 1	Wiener SC	...
30 Nov 19	Rapid Wien	Rapid Wien - Wiener AC 1919-11-30T00:00:00 Allianz Stadion 4 - 2	Wiener AC	...
30 Nov 19	Hertha Wien	Hertha Wien - Wacker Wien 1919-11-30T00:00:00 No disponible 3 - 0	Wacker Wien	...

Ver jornada

Jornada 11

07 Dic 19	Austria	Austria - Hertha Wien 1919-12-07T00:00:00 Generali Arena 2 - 0	Hertha Wien	...
07 Dic 19	WAF	WAF - Rudolfshüg 1919-12-07T00:00:00 No disponible 1 - 2	Rudolfshüg	...
07 Dic 19	Admira	Admira - Wiener AC 1919-12-07T00:00:00 BSFZ-Arena 1 - 2	Wiener AC	...
07 Dic 19	FAC Wien	FAC Wien - First 1919-12-07T00:00:00 FAC-Platz 1 - 2	First	...
09 Nov 19	Rapid Wien	Rapid Wien - Wacker Wien 1919-11-09T00:00:00 Allianz Stadion 9 - 2	Wacker Wien	...
09 Nov 19	Wiener SC	Wiener SC - Simmeringer 1919-11-09T00:00:00 Sportclub-Platz 4 - 3	Simmeringer	...

Ver jornada

Jornada 12

29 Feb 20	Simmeringer	Simmeringer - Admira 1920-02-29T00:00:00 Simmeringer Had 1 - 1	Admira	...
29 Feb 20	Rudolfshüg	Rudolfshüg - Wiener AC 1920-02-29T00:00:00 No disponible 1 - 2	Wiener AC	...
29 Feb 20	Hertha Wien	Hertha Wien - WAF 1920-02-29T00:00:00 No disponible 4 - 0	WAF	...
29 Feb 20	FAC Wien	FAC Wien - Austria 1920-02-29T00:00:00 FAC-Platz 1 - 1	Austria	...
29 Feb 20	Rapid Wien	Rapid Wien - Wiener SC 1920-02-29T00:00:00 Allianz Stadion 1 - 0	Wiener SC	...
29 Feb 20	First	First - Wacker Wien 1920-02-29T00:00:00 Stadion Hohe Warte 2 - 3	Wacker Wien	...

Ver jornada

Jornada 13

07 Mar 20	Simmeringer	Simmeringer - Rudolfshüg 1920-03-07T00:00:00 Simmeringer Had 4 - 2	Rudolfshüg	...
07 Mar 20	Rapid Wien	Rapid Wien - FAC Wien 1920-03-07T00:00:00 Allianz Stadion 2 - 0	FAC Wien	...
07 Mar 20	Wiener AC	Wiener AC - WAF 1920-03-07T00:00:00 No disponible 1 - 1	WAF	...
07 Mar 20	Admira	Admira - Wacker Wien 1920-03-07T00:00:00 BSFZ-Arena 0 - 0	Wacker Wien	...
07 Mar 20	First	First - Wiener SC 1920-03-07T00:00:00 Stadion Hohe Warte 2 - 3	Wiener SC	...
07 Mar 20	Hertha Wien	Hertha Wien - Austria 1920-03-07T00:00:00 No disponible 1 - 3	Austria	...

Ver jornada

Jornada 14

21 Mar 20	Rudolfshüg	Rudolfshüg - WAF 1920-03-21T00:00:00 No disponible 1 - 1	WAF	...
21 Mar 20	First	First - FAC Wien 1920-03-21T00:00:00 Stadion Hohe Warte 1 - 1	FAC Wien	...
21 Mar 20	Admira	Admira - Wiener SC 1920-03-21T00:00:00 BSFZ-Arena 0 - 2	Wiener SC	...
21 Mar 20	Austria	Austria - Wiener AC 1920-03-21T00:00:00 Generali Arena 3 - 0	Wiener AC	...
21 Mar 20	Rapid Wien	Rapid Wien - Hertha Wien 1920-03-21T00:00:00 Allianz Stadion 4 - 1	Hertha Wien	...
21 Mar 20	Simmeringer	Simmeringer - Wacker Wien 1920-03-21T00:00:00 Simmeringer Had 6 - 1	Wacker Wien	...

Ver jornada

Jornada 15

28 Mar 20	Wacker Wien	Wacker Wien - Rudolfshüg 1920-03-28T00:00:00 No disponible 0 - 2	Rudolfshüg	...
28 Mar 20	Simmeringer	Simmeringer - Wiener SC 1920-03-28T00:00:00 Simmeringer Had 0 - 3	Wiener SC	...
28 Mar 20	Hertha Wien	Hertha Wien - First 1920-03-28T00:00:00 No disponible 1 - 0	First	...
28 Mar 20	Admira	Admira - FAC Wien 1920-03-28T00:00:00 BSFZ-Arena 0 - 4	FAC Wien	...
28 Mar 20	Wiener AC	Wiener AC - Rapid Wien 1920-03-28T00:00:00 No disponible 0 - 0	Rapid Wien	...
25 Mar 20	Austria	Austria - WAF 1920-03-25T00:00:00 Generali Arena 2 - 0	WAF	...

Ver jornada

Jornada 16

18 Abr 20	Hertha Wien	Hertha Wien - Admira 1920-04-18T00:00:00 No disponible 3 - 1	Admira	...
18 Abr 20	Simmeringer	Simmeringer - FAC Wien 1920-04-18T00:00:00 Simmeringer Had 1 - 0	FAC Wien	...
18 Abr 20	Wacker Wien	Wacker Wien - Wiener SC 1920-04-18T00:00:00 No disponible 0 - 0	Wiener SC	...
18 Abr 20	WAF	WAF - Rapid Wien 1920-04-18T00:00:00 No disponible 2 - 0	Rapid Wien	...
18 Abr 20	Rudolfshüg	Rudolfshüg - Austria 1920-04-18T00:00:00 No disponible 1 - 1	Austria	...
14 Mar 20	Wiener AC	Wiener AC - First 1920-03-14T00:00:00 No disponible 4 - 1	First	...

Ver jornada

Jornada 17

25 Abr 20	Austria	Austria - Rapid Wien 1920-04-25T00:00:00 Generali Arena 2 - 3	Rapid Wien	...
25 Abr 20	WAF	WAF - First 1920-04-25T00:00:00 No disponible 1 - 1	First	...
25 Abr 20	Wiener AC	Wiener AC - Admira 1920-04-25T00:00:00 No disponible 4 - 1	Admira	...
25 Abr 20	Wacker Wien	Wacker Wien - FAC Wien 1920-04-25T00:00:00 No disponible 1 - 2	FAC Wien	...
25 Abr 20	Wiener SC	Wiener SC - Rudolfshüg 1920-04-25T00:00:00 Sportclub-Platz 1 - 0	Rudolfshüg	...
25 Abr 20	Simmeringer	Simmeringer - Hertha Wien 1920-04-25T00:00:00 Simmeringer Had 1 - 0	Hertha Wien	...

Ver jornada

Jornada 18

09 May 20	Wacker Wien	Wacker Wien - Hertha Wien 1920-05-09T00:00:00 No disponible 0 - 0	Hertha Wien	...
09 May 20	Rapid Wien	Rapid Wien - Rudolfshüg 1920-05-09T00:00:00 Allianz Stadion 3 - 1	Rudolfshüg	...
09 May 20	Simmeringer	Simmeringer - Wiener AC 1920-05-09T00:00:00 Simmeringer Had 2 - 2	Wiener AC	...
09 May 20	Austria	Austria - First 1920-05-09T00:00:00 Generali Arena 3 - 2	First	...
09 May 20	Wiener SC	Wiener SC - FAC Wien 1920-05-09T00:00:00 Sportclub-Platz 0 - 2	FAC Wien	...
09 May 20	Admira	Admira - WAF 1920-05-09T00:00:00 BSFZ-Arena 2 - 1	WAF	...

Ver jornada

Jornada 19

16 May 20	First	First - Rapid Wien 1920-05-16T00:00:00 Stadion Hohe Warte 1 - 1	Rapid Wien	...
16 May 20	Wiener SC	Wiener SC - Hertha Wien 1920-05-16T00:00:00 Sportclub-Platz 1 - 0	Hertha Wien	...
16 May 20	Wiener AC	Wiener AC - Wacker Wien 1920-05-16T00:00:00 No disponible 0 - 2	Wacker Wien	...
16 May 20	Simmeringer	Simmeringer - WAF 1920-05-16T00:00:00 Simmeringer Had 3 - 1	WAF	...
16 May 20	Admira	Admira - Austria 1920-05-16T00:00:00 BSFZ-Arena 1 - 4	Austria	...
16 May 20	FAC Wien	FAC Wien - Rudolfshüg 1920-05-16T00:00:00 FAC-Platz 1 - 0	Rudolfshüg	...

Ver jornada

Jornada 20

20 Jun 20	Rapid Wien	Rapid Wien - Admira 1920-06-20T00:00:00 Allianz Stadion 11 - 2	Admira	...
30 May 20	FAC Wien	FAC Wien - Hertha Wien 1920-05-30T00:00:00 FAC-Platz 1 - 0	Hertha Wien	...
30 May 20	First	First - Rudolfshüg 1920-05-30T00:00:00 Stadion Hohe Warte 2 - 4	Rudolfshüg	...
30 May 20	WAF	WAF - Wacker Wien 1920-05-30T00:00:00 No disponible 0 - 1	Wacker Wien	...
30 May 20	Wiener SC	Wiener SC - Wiener AC 1920-05-30T00:00:00 Sportclub-Platz 1 - 0	Wiener AC	...
30 May 20	Simmeringer	Simmeringer - Austria 1920-05-30T00:00:00 Simmeringer Had 1 - 0	Austria	...

Ver jornada

Jornada 21

06 Jun 20	Austria	Austria - Wacker Wien 1920-06-06T00:00:00 Generali Arena 2 - 0	Wacker Wien	...
06 Jun 20	WAF	WAF - Wiener SC 1920-06-06T00:00:00 No disponible 0 - 1	Wiener SC	...
06 Jun 20	First	First - Admira 1920-06-06T00:00:00 Stadion Hohe Warte 2 - 2	Admira	...
06 Jun 20	FAC Wien	FAC Wien - Wiener AC 1920-06-06T00:00:00 FAC-Platz 4 - 0	Wiener AC	...
06 Jun 20	Simmeringer	Simmeringer - Rapid Wien 1920-06-06T00:00:00 Simmeringer Had 2 - 5	Rapid Wien	...
06 Jun 20	Rudolfshüg	Rudolfshüg - Hertha Wien 1920-06-06T00:00:00 No disponible 1 - 0	Hertha Wien	...

Ver jornada

Jornada 22

29 Jun 20	Wacker Wien	Wacker Wien - Rapid Wien 1920-06-29T00:00:00 No disponible 0 - 4	Rapid Wien	...
13 Jun 20	Simmeringer	Simmeringer - First 1920-06-13T00:00:00 Simmeringer Had 1 - 4	First	...
13 Jun 20	Wiener SC	Wiener SC - Austria 1920-06-13T00:00:00 Sportclub-Platz 2 - 2	Austria	...
13 Jun 20	FAC Wien	FAC Wien - WAF 1920-06-13T00:00:00 FAC-Platz 4 - 2	WAF	...
13 Jun 20	Hertha Wien	Hertha Wien - Wiener AC 1920-06-13T00:00:00 No disponible 1 - 1	Wiener AC	...
11 Abr 20	Rudolfshüg	Rudolfshüg - Admira 1920-04-11T00:00:00 No disponible 0 - 2	Admira	...

Clasificación

Jornada 22

Equipo		PJ	GF	GC	Puntos
1	Rapid Wien	22	71	29	48
2	Austria Wien	22	55	24	47
3	Wiener SC	22	37	28	43
4	FAC Wien	22	36	24	39
5	Rudolfshüge	22	42	30	36
6	Wiener AC	22	31	36	30
7	Simmeringer	22	39	44	29
8	Wacker Wien	22	27	48	23
9	Hertha Wien	22	24	33	22
10	First Vienna	22	36	47	19
11	WAF	22	30	43	17
12	Admira	22	25	67	14

Equipos de esta liga

USO DE MEMORIA

5,628,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.3983
Total Execution Time	0.4002

CADENA URL

/austria1920/grupo1/calendario

GET DATOS

$_GET['/austria1920/grupo1/calendario']

POST DATOS

No hay datos POST existentes

CONSULTAS (17)

0.0147	SELECT type FROM routes WHERE alias = 'austria1920'
0.0301	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'austria' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1920 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11 AND type_rel = 3
0.0152	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 11 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147	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 (1296271,1294805,1277727,1270786,1270305) ORDER BY n.cover_points DESC, update_date DESC
0.0145	SELECT id,name,alias,stepParent FROM categories WHERE parentId=11 ORDER BY order_id ASC
0.0145	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 = 26305 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153	SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars1920 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 26305 ORDER BY round ASC
0.0145	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 00:33:35' 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-05-09 00:33:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 00:33:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 00:33:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'austria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1920 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146	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 events1920 e ON e.player_id = p.id AND e.league_id = 26305 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26305 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.0145	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 events1920 e ON e.player_id = p.id AND e.league_id = 26305 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26305 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0145	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 events1920 e ON e.player_id = p.id AND e.league_id = 26305 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26305 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* `tables1920` 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 = 26305 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC