Calendario de Primera División - Temporada 1973/1974

Ver jornada

Jornada 1

01 Sep 73	Espanyol	Espanyol - Real Murcia 1973-09-01T00:00:00 RCDE Stadium 3 - 0	Real Murcia	...
01 Sep 73	Real	Real - Granada 1973-09-01T00:00:00 Anoeta 0 - 2	Granada	...
01 Sep 73	Real Madrid	Real Madrid - Castellón 1973-09-01T00:00:00 Santiago Bernabéu 0 - 0	Castellón	...
01 Sep 73	Valencia	Valencia - Real Oviedo 1973-09-01T00:00:00 Mestalla 2 - 1	Real Oviedo	...
02 Sep 73	Celta	Celta - Athletic 1973-09-02T00:00:00 Abanca Balaídos 2 - 1	Athletic	...
02 Sep 73	Elche	Elche - Barcelona 1973-09-02T00:00:00 Martínez Valero 1 - 0	Barcelona	...
02 Sep 73	Real	Real - Atlético 1973-09-02T00:00:00 El Molinón-Enrique Castro Quini 0 - 3	Atlético	...
02 Sep 73	Las Palmas	Las Palmas - CD Málaga 1973-09-02T00:00:00 Gran Canaria 1 - 0	CD Málaga	...
02 Sep 73	Racing	Racing - Real 1973-09-02T00:00:00 Campos de Sport de El Sardinero 1 - 1	Real	...

Ver jornada

Jornada 2

08 Sep 73	Athletic	Athletic - Espanyol 1973-09-08T00:00:00 San Mamés 1 - 0	Espanyol	...
08 Sep 73	Atlético	Atlético - Valencia 1973-09-08T00:00:00 Wanda Metropolitano 3 - 1	Valencia	...
08 Sep 73	CD Málaga	CD Málaga - Elche 1973-09-08T00:00:00 No disponible 3 - 1	Elche	...
08 Sep 73	Real Murcia	Real Murcia - Real 1973-09-08T00:00:00 Enrique Roca de Murcia 1 - 1	Real	...
09 Sep 73	Barcelona	Barcelona - Racing 1973-09-09T00:00:00 Spotify Camp Nou 0 - 0	Racing	...
09 Sep 73	Castellón	Castellón - Real 1973-09-09T00:00:00 Municipal de Castalia 3 - 2	Real	...
09 Sep 73	Granada	Granada - Real Madrid 1973-09-09T00:00:00 Nuevo Los Cármenes 1 - 1	Real Madrid	...
09 Sep 73	Real Oviedo	Real Oviedo - Las Palmas 1973-09-09T00:00:00 Carlos Tartiere 1 - 0	Las Palmas	...
09 Sep 73	Real	Real - Celta 1973-09-09T00:00:00 La Romareda 2 - 1	Celta	...

Ver jornada

Jornada 3

15 Sep 73	Espanyol	Espanyol - Real 1973-09-15T00:00:00 RCDE Stadium 3 - 1	Real	...
15 Sep 73	Real	Real - Valencia 1973-09-15T00:00:00 El Molinón-Enrique Castro Quini 1 - 2	Valencia	...
15 Sep 73	Las Palmas	Las Palmas - Atlético 1973-09-15T00:00:00 Gran Canaria 1 - 0	Atlético	...
15 Sep 73	Real Madrid	Real Madrid - Real Murcia 1973-09-15T00:00:00 Santiago Bernabéu 1 - 1	Real Murcia	...
16 Sep 73	Castellón	Castellón - Granada 1973-09-16T00:00:00 Municipal de Castalia 1 - 1	Granada	...
16 Sep 73	Celta	Celta - Barcelona 1973-09-16T00:00:00 Abanca Balaídos 2 - 1	Barcelona	...
16 Sep 73	Elche	Elche - Real Oviedo 1973-09-16T00:00:00 Martínez Valero 1 - 1	Real Oviedo	...
16 Sep 73	Racing	Racing - CD Málaga 1973-09-16T00:00:00 Campos de Sport de El Sardinero 1 - 1	CD Málaga	...
16 Sep 73	Real	Real - Athletic 1973-09-16T00:00:00 Anoeta 2 - 1	Athletic	...

Ver jornada

Jornada 4

22 Sep 73	CD Málaga	CD Málaga - Celta 1973-09-22T00:00:00 No disponible 1 - 1	Celta	...
22 Sep 73	Valencia	Valencia - Las Palmas 1973-09-22T00:00:00 Mestalla 2 - 0	Las Palmas	...
23 Sep 73	Athletic	Athletic - Real Madrid 1973-09-23T00:00:00 San Mamés 2 - 1	Real Madrid	1
23 Sep 73	Atlético	Atlético - Elche 1973-09-23T00:00:00 Wanda Metropolitano 2 - 1	Elche	...
23 Sep 73	Barcelona	Barcelona - Espanyol 1973-09-23T00:00:00 Spotify Camp Nou 3 - 0	Espanyol	...
23 Sep 73	Granada	Granada - Real 1973-09-23T00:00:00 Nuevo Los Cármenes 1 - 0	Real	...
23 Sep 73	Real Murcia	Real Murcia - Castellón 1973-09-23T00:00:00 Enrique Roca de Murcia 3 - 1	Castellón	...
23 Sep 73	Real Oviedo	Real Oviedo - Racing 1973-09-23T00:00:00 Carlos Tartiere 2 - 1	Racing	...
23 Sep 73	Real	Real - Real 1973-09-23T00:00:00 La Romareda 0 - 0	Real	...

Ver jornada

Jornada 5

29 Sep 73	Espanyol	Espanyol - CD Málaga 1973-09-29T00:00:00 RCDE Stadium 1 - 1	CD Málaga	...
29 Sep 73	Real	Real - Las Palmas 1973-09-29T00:00:00 El Molinón-Enrique Castro Quini 1 - 0	Las Palmas	...
29 Sep 73	Granada	Granada - Real Murcia 1973-09-29T00:00:00 Nuevo Los Cármenes 1 - 1	Real Murcia	...
29 Sep 73	Real Madrid	Real Madrid - Real 1973-09-29T00:00:00 Santiago Bernabéu 4 - 0	Real	...
30 Sep 73	Castellón	Castellón - Athletic 1973-09-30T00:00:00 Municipal de Castalia 0 - 0	Athletic	...
30 Sep 73	Celta	Celta - Real Oviedo 1973-09-30T00:00:00 Abanca Balaídos 5 - 1	Real Oviedo	...
30 Sep 73	Elche	Elche - Valencia 1973-09-30T00:00:00 Martínez Valero 1 - 0	Valencia	...
30 Sep 73	Racing	Racing - Atlético 1973-09-30T00:00:00 Campos de Sport de El Sardinero 2 - 1	Atlético	...
30 Sep 73	Real	Real - Barcelona 1973-09-30T00:00:00 Anoeta 2 - 1	Barcelona	...

Ver jornada

Jornada 6

06 Oct 73	Las Palmas	Las Palmas - Elche 1973-10-06T00:00:00 Gran Canaria 3 - 1	Elche	...
07 Oct 73	Athletic	Athletic - Granada 1973-10-07T00:00:00 San Mamés 1 - 0	Granada	...
07 Oct 73	Atlético	Atlético - Celta 1973-10-07T00:00:00 Wanda Metropolitano 2 - 0	Celta	...
07 Oct 73	Barcelona	Barcelona - Real Madrid 1973-10-07T00:00:00 Spotify Camp Nou 0 - 0	Real Madrid	...
07 Oct 73	CD Málaga	CD Málaga - Real 1973-10-07T00:00:00 No disponible 2 - 0	Real	...
07 Oct 73	Real Murcia	Real Murcia - Real 1973-10-07T00:00:00 Enrique Roca de Murcia 2 - 1	Real	...
07 Oct 73	Real Oviedo	Real Oviedo - Espanyol 1973-10-07T00:00:00 Carlos Tartiere 1 - 0	Espanyol	...
07 Oct 73	Valencia	Valencia - Racing 1973-10-07T00:00:00 Mestalla 5 - 2	Racing	...
07 Oct 73	Real	Real - Castellón 1973-10-07T00:00:00 La Romareda 3 - 2	Castellón	...

Ver jornada

Jornada 7

12 Oct 73	Castellón	Castellón - Barcelona 1973-10-12T00:00:00 Municipal de Castalia 0 - 2	Barcelona	...
12 Oct 73	Celta	Celta - Valencia 1973-10-12T00:00:00 Abanca Balaídos 0 - 2	Valencia	...
12 Oct 73	Espanyol	Espanyol - Atlético 1973-10-12T00:00:00 RCDE Stadium 1 - 0	Atlético	...
12 Oct 73	Real	Real - Elche 1973-10-12T00:00:00 El Molinón-Enrique Castro Quini 2 - 0	Elche	...
12 Oct 73	Granada	Granada - Real 1973-10-12T00:00:00 Nuevo Los Cármenes 1 - 2	Real	...
12 Oct 73	Real Murcia	Real Murcia - Athletic 1973-10-12T00:00:00 Enrique Roca de Murcia 0 - 0	Athletic	...
12 Oct 73	Racing	Racing - Las Palmas 1973-10-12T00:00:00 Campos de Sport de El Sardinero 1 - 0	Las Palmas	...
12 Oct 73	Real	Real - Real Oviedo 1973-10-12T00:00:00 Anoeta 2 - 0	Real Oviedo	...
12 Oct 73	Real Madrid	Real Madrid - CD Málaga 1973-10-12T00:00:00 Santiago Bernabéu 0 - 0	CD Málaga	...

Ver jornada

Jornada 8

27 Oct 73	Las Palmas	Las Palmas - Celta 1973-10-27T00:00:00 Gran Canaria 1 - 0	Celta	...
28 Oct 73	Athletic	Athletic - Real 1973-10-28T00:00:00 San Mamés 2 - 3	Real	...
28 Oct 73	Atlético	Atlético - Real 1973-10-28T00:00:00 Wanda Metropolitano 5 - 1	Real	...
28 Oct 73	Barcelona	Barcelona - Granada 1973-10-28T00:00:00 Spotify Camp Nou 4 - 0	Granada	...
28 Oct 73	Elche	Elche - Racing 1973-10-28T00:00:00 Martínez Valero 0 - 0	Racing	...
28 Oct 73	CD Málaga	CD Málaga - Castellón 1973-10-28T00:00:00 No disponible 2 - 1	Castellón	...
28 Oct 73	Real Oviedo	Real Oviedo - Real Madrid 1973-10-28T00:00:00 Carlos Tartiere 1 - 1	Real Madrid	...
28 Oct 73	Valencia	Valencia - Espanyol 1973-10-28T00:00:00 Mestalla 1 - 0	Espanyol	...
28 Oct 73	Real	Real - Real Murcia 1973-10-28T00:00:00 La Romareda 0 - 0	Real Murcia	...

Ver jornada

Jornada 9

03 Nov 73	Real Madrid	Real Madrid - Atlético 1973-11-03T00:00:00 Santiago Bernabéu 2 - 0	Atlético	...
04 Nov 73	Athletic	Athletic - Real 1973-11-04T00:00:00 San Mamés 2 - 1	Real	...
04 Nov 73	Castellón	Castellón - Real Oviedo 1973-11-04T00:00:00 Municipal de Castalia 2 - 0	Real Oviedo	...
04 Nov 73	Celta	Celta - Elche 1973-11-04T00:00:00 Abanca Balaídos 1 - 0	Elche	...
04 Nov 73	Espanyol	Espanyol - Las Palmas 1973-11-04T00:00:00 RCDE Stadium 2 - 0	Las Palmas	...
04 Nov 73	Real	Real - Racing 1973-11-04T00:00:00 El Molinón-Enrique Castro Quini 2 - 0	Racing	...
04 Nov 73	Granada	Granada - CD Málaga 1973-11-04T00:00:00 Nuevo Los Cármenes 0 - 0	CD Málaga	...
04 Nov 73	Real Murcia	Real Murcia - Barcelona 1973-11-04T00:00:00 Enrique Roca de Murcia 2 - 2	Barcelona	...
04 Nov 73	Real	Real - Valencia 1973-11-04T00:00:00 Anoeta 3 - 2	Valencia	...

Ver jornada

Jornada 10

10 Nov 73	Las Palmas	Las Palmas - Real 1973-11-10T00:00:00 Gran Canaria 1 - 0	Real	...
11 Nov 73	Atlético	Atlético - Castellón 1973-11-11T00:00:00 Wanda Metropolitano 0 - 0	Castellón	...
11 Nov 73	Barcelona	Barcelona - Athletic 1973-11-11T00:00:00 Spotify Camp Nou 2 - 0	Athletic	...
11 Nov 73	Elche	Elche - Espanyol 1973-11-11T00:00:00 Martínez Valero 0 - 0	Espanyol	...
11 Nov 73	CD Málaga	CD Málaga - Real Murcia 1973-11-11T00:00:00 No disponible 1 - 0	Real Murcia	...
11 Nov 73	Racing	Racing - Celta 1973-11-11T00:00:00 Campos de Sport de El Sardinero 1 - 1	Celta	...
11 Nov 73	Real Oviedo	Real Oviedo - Granada 1973-11-11T00:00:00 Carlos Tartiere 3 - 0	Granada	...
11 Nov 73	Valencia	Valencia - Real Madrid 1973-11-11T00:00:00 Mestalla 1 - 0	Real Madrid	...
11 Nov 73	Real	Real - Real 1973-11-11T00:00:00 La Romareda 3 - 0	Real	...

Ver jornada

Jornada 11

18 Nov 73	Athletic	Athletic - CD Málaga 1973-11-18T00:00:00 San Mamés 1 - 0	CD Málaga	...
18 Nov 73	Castellón	Castellón - Valencia 1973-11-18T00:00:00 Municipal de Castalia 0 - 0	Valencia	...
18 Nov 73	Espanyol	Espanyol - Racing 1973-11-18T00:00:00 RCDE Stadium 0 - 2	Racing	...
18 Nov 73	Real	Real - Celta 1973-11-18T00:00:00 El Molinón-Enrique Castro Quini 2 - 1	Celta	...
18 Nov 73	Granada	Granada - Atlético 1973-11-18T00:00:00 Nuevo Los Cármenes 1 - 0	Atlético	...
18 Nov 73	Real Murcia	Real Murcia - Real Oviedo 1973-11-18T00:00:00 Enrique Roca de Murcia 3 - 1	Real Oviedo	...
18 Nov 73	Real	Real - Elche 1973-11-18T00:00:00 Anoeta 2 - 1	Elche	...
18 Nov 73	Real Madrid	Real Madrid - Las Palmas 1973-11-18T00:00:00 Santiago Bernabéu 5 - 0	Las Palmas	1
18 Nov 73	Real	Real - Barcelona 1973-11-18T00:00:00 La Romareda 2 - 2	Barcelona	...

Ver jornada

Jornada 12

01 Dic 73	Las Palmas	Las Palmas - Castellón 1973-12-01T00:00:00 Gran Canaria 2 - 0	Castellón	...
02 Dic 73	Atlético	Atlético - Real Murcia 1973-12-02T00:00:00 Wanda Metropolitano 4 - 1	Real Murcia	...
02 Dic 73	Barcelona	Barcelona - Real 1973-12-02T00:00:00 Spotify Camp Nou 5 - 1	Real	...
02 Dic 73	Celta	Celta - Espanyol 1973-12-02T00:00:00 Abanca Balaídos 1 - 2	Espanyol	...
02 Dic 73	Elche	Elche - Real Madrid 1973-12-02T00:00:00 Martínez Valero 1 - 0	Real Madrid	...
02 Dic 73	CD Málaga	CD Málaga - Real 1973-12-02T00:00:00 No disponible 0 - 1	Real	...
02 Dic 73	Racing	Racing - Real 1973-12-02T00:00:00 Campos de Sport de El Sardinero 0 - 0	Real	...
02 Dic 73	Real Oviedo	Real Oviedo - Athletic 1973-12-02T00:00:00 Carlos Tartiere 0 - 1	Athletic	...
02 Dic 73	Valencia	Valencia - Granada 1973-12-02T00:00:00 Mestalla 1 - 1	Granada	...

Ver jornada

Jornada 13

09 Dic 73	Athletic	Athletic - Atlético 1973-12-09T00:00:00 San Mamés 2 - 2	Atlético	...
09 Dic 73	Barcelona	Barcelona - CD Málaga 1973-12-09T00:00:00 Spotify Camp Nou 4 - 0	CD Málaga	...
09 Dic 73	Castellón	Castellón - Elche 1973-12-09T00:00:00 Municipal de Castalia 0 - 2	Elche	...
09 Dic 73	Real	Real - Espanyol 1973-12-09T00:00:00 El Molinón-Enrique Castro Quini 3 - 0	Espanyol	...
09 Dic 73	Granada	Granada - Las Palmas 1973-12-09T00:00:00 Nuevo Los Cármenes 2 - 1	Las Palmas	...
09 Dic 73	Real Murcia	Real Murcia - Valencia 1973-12-09T00:00:00 Enrique Roca de Murcia 1 - 0	Valencia	...
09 Dic 73	Real	Real - Celta 1973-12-09T00:00:00 Anoeta 2 - 1	Celta	...
09 Dic 73	Real Madrid	Real Madrid - Racing 1973-12-09T00:00:00 Santiago Bernabéu 3 - 2	Racing	...
09 Dic 73	Real	Real - Real Oviedo 1973-12-09T00:00:00 La Romareda 4 - 2	Real Oviedo	...

Ver jornada

Jornada 14

15 Dic 73	Las Palmas	Las Palmas - Real Murcia 1973-12-15T00:00:00 Gran Canaria 3 - 0	Real Murcia	...
16 Dic 73	Atlético	Atlético - Real 1973-12-16T00:00:00 Wanda Metropolitano 0 - 0	Real	...
16 Dic 73	Celta	Celta - Real Madrid 1973-12-16T00:00:00 Abanca Balaídos 2 - 1	Real Madrid	...
16 Dic 73	Elche	Elche - Granada 1973-12-16T00:00:00 Martínez Valero 1 - 0	Granada	...
16 Dic 73	Espanyol	Espanyol - Real 1973-12-16T00:00:00 RCDE Stadium 1 - 0	Real	...
16 Dic 73	CD Málaga	CD Málaga - Real 1973-12-16T00:00:00 No disponible 2 - 0	Real	...
16 Dic 73	Racing	Racing - Castellón 1973-12-16T00:00:00 Campos de Sport de El Sardinero 1 - 1	Castellón	...
16 Dic 73	Real Oviedo	Real Oviedo - Barcelona 1973-12-16T00:00:00 Carlos Tartiere 1 - 3	Barcelona	1
16 Dic 73	Valencia	Valencia - Athletic 1973-12-16T00:00:00 Mestalla 0 - 1	Athletic	...

Ver jornada

Jornada 15

22 Dic 73	Barcelona	Barcelona - Atlético 1973-12-22T00:00:00 Spotify Camp Nou 2 - 1	Atlético	...
23 Dic 73	Athletic	Athletic - Las Palmas 1973-12-23T00:00:00 San Mamés 2 - 1	Las Palmas	...
23 Dic 73	Castellón	Castellón - Celta 1973-12-23T00:00:00 Municipal de Castalia 1 - 1	Celta	...
23 Dic 73	Real	Real - Real 1973-12-23T00:00:00 El Molinón-Enrique Castro Quini 3 - 1	Real	...
23 Dic 73	Granada	Granada - Racing 1973-12-23T00:00:00 Nuevo Los Cármenes 2 - 0	Racing	...
23 Dic 73	CD Málaga	CD Málaga - Real Oviedo 1973-12-23T00:00:00 No disponible 1 - 0	Real Oviedo	...
23 Dic 73	Real Murcia	Real Murcia - Elche 1973-12-23T00:00:00 Enrique Roca de Murcia 0 - 1	Elche	...
23 Dic 73	Real Madrid	Real Madrid - Espanyol 1973-12-23T00:00:00 Santiago Bernabéu 2 - 1	Espanyol	...
23 Dic 73	Real	Real - Valencia 1973-12-23T00:00:00 La Romareda 2 - 1	Valencia	...

Ver jornada

Jornada 16

29 Dic 73	Las Palmas	Las Palmas - Real 1973-12-29T00:00:00 Gran Canaria 1 - 0	Real	...
30 Dic 73	Atlético	Atlético - CD Málaga 1973-12-30T00:00:00 Wanda Metropolitano 2 - 0	CD Málaga	...
30 Dic 73	Celta	Celta - Granada 1973-12-30T00:00:00 Abanca Balaídos 1 - 0	Granada	...
30 Dic 73	Elche	Elche - Athletic 1973-12-30T00:00:00 Martínez Valero 0 - 0	Athletic	...
30 Dic 73	Espanyol	Espanyol - Castellón 1973-12-30T00:00:00 RCDE Stadium 1 - 0	Castellón	...
30 Dic 73	Real	Real - Real Oviedo 1973-12-30T00:00:00 El Molinón-Enrique Castro Quini 0 - 3	Real Oviedo	...
30 Dic 73	Racing	Racing - Real Murcia 1973-12-30T00:00:00 Campos de Sport de El Sardinero 2 - 0	Real Murcia	...
30 Dic 73	Real	Real - Real Madrid 1973-12-30T00:00:00 Anoeta 2 - 2	Real Madrid	...
30 Dic 73	Valencia	Valencia - Barcelona 1973-12-30T00:00:00 Mestalla 0 - 2	Barcelona	...

Ver jornada

Jornada 17

06 Ene 74	Athletic	Athletic - Racing 1974-01-06T00:00:00 San Mamés 3 - 1	Racing	...
06 Ene 74	Barcelona	Barcelona - Las Palmas 1974-01-06T00:00:00 Spotify Camp Nou 3 - 0	Las Palmas	...
06 Ene 74	Castellón	Castellón - Real 1974-01-06T00:00:00 Municipal de Castalia 2 - 0	Real	...
06 Ene 74	Granada	Granada - Espanyol 1974-01-06T00:00:00 Nuevo Los Cármenes 2 - 0	Espanyol	...
06 Ene 74	CD Málaga	CD Málaga - Valencia 1974-01-06T00:00:00 No disponible 1 - 0	Valencia	...
06 Ene 74	Real Murcia	Real Murcia - Celta 1974-01-06T00:00:00 Enrique Roca de Murcia 2 - 2	Celta	...
06 Ene 74	Real Madrid	Real Madrid - Real 1974-01-06T00:00:00 Santiago Bernabéu 2 - 2	Real	...
06 Ene 74	Real Oviedo	Real Oviedo - Atlético 1974-01-06T00:00:00 Carlos Tartiere 2 - 0	Atlético	...
06 Ene 74	Real	Real - Elche 1974-01-06T00:00:00 La Romareda 2 - 1	Elche	...

Ver jornada

Jornada 18

13 Ene 74	Athletic	Athletic - Celta 1974-01-13T00:00:00 San Mamés 2 - 0	Celta	...
13 Ene 74	Atlético	Atlético - Real 1974-01-13T00:00:00 Wanda Metropolitano 2 - 0	Real	...
13 Ene 74	Barcelona	Barcelona - Elche 1974-01-13T00:00:00 Spotify Camp Nou 2 - 0	Elche	...
13 Ene 74	Castellón	Castellón - Real Madrid 1974-01-13T00:00:00 Municipal de Castalia 2 - 0	Real Madrid	1
13 Ene 74	Granada	Granada - Real 1974-01-13T00:00:00 Nuevo Los Cármenes 2 - 1	Real	...
13 Ene 74	CD Málaga	CD Málaga - Las Palmas 1974-01-13T00:00:00 No disponible 1 - 0	Las Palmas	...
13 Ene 74	Real Murcia	Real Murcia - Espanyol 1974-01-13T00:00:00 Enrique Roca de Murcia 1 - 0	Espanyol	...
13 Ene 74	Real Oviedo	Real Oviedo - Valencia 1974-01-13T00:00:00 Carlos Tartiere 1 - 2	Valencia	...
13 Ene 74	Real	Real - Racing 1974-01-13T00:00:00 La Romareda 5 - 1	Racing	...

Ver jornada

Jornada 19

19 Ene 74	Las Palmas	Las Palmas - Real Oviedo 1974-01-19T00:00:00 Gran Canaria 1 - 2	Real Oviedo	...
20 Ene 74	Celta	Celta - Real 1974-01-20T00:00:00 Abanca Balaídos 2 - 0	Real	...
20 Ene 74	Elche	Elche - CD Málaga 1974-01-20T00:00:00 Martínez Valero 0 - 1	CD Málaga	...
20 Ene 74	Espanyol	Espanyol - Athletic 1974-01-20T00:00:00 RCDE Stadium 2 - 0	Athletic	...
20 Ene 74	Real	Real - Castellón 1974-01-20T00:00:00 El Molinón-Enrique Castro Quini 4 - 0	Castellón	...
20 Ene 74	Racing	Racing - Barcelona 1974-01-20T00:00:00 Campos de Sport de El Sardinero 1 - 3	Barcelona	...
20 Ene 74	Real	Real - Real Murcia 1974-01-20T00:00:00 Anoeta 2 - 1	Real Murcia	...
20 Ene 74	Real Madrid	Real Madrid - Granada 1974-01-20T00:00:00 Santiago Bernabéu 0 - 1	Granada	1
20 Ene 74	Valencia	Valencia - Atlético 1974-01-20T00:00:00 Mestalla 0 - 1	Atlético	...

Ver jornada

Jornada 20

27 Ene 74	Athletic	Athletic - Real 1974-01-27T00:00:00 San Mamés 1 - 2	Real	...
27 Ene 74	Atlético	Atlético - Las Palmas 1974-01-27T00:00:00 Wanda Metropolitano 3 - 1	Las Palmas	...
27 Ene 74	Barcelona	Barcelona - Celta 1974-01-27T00:00:00 Spotify Camp Nou 5 - 2	Celta	...
27 Ene 74	Granada	Granada - Castellón 1974-01-27T00:00:00 Nuevo Los Cármenes 2 - 0	Castellón	...
27 Ene 74	CD Málaga	CD Málaga - Racing 1974-01-27T00:00:00 No disponible 3 - 0	Racing	...
27 Ene 74	Real Murcia	Real Murcia - Real Madrid 1974-01-27T00:00:00 Enrique Roca de Murcia 0 - 1	Real Madrid	...
27 Ene 74	Real Oviedo	Real Oviedo - Elche 1974-01-27T00:00:00 Carlos Tartiere 1 - 0	Elche	...
27 Ene 74	Valencia	Valencia - Real 1974-01-27T00:00:00 Mestalla 6 - 1	Real	...
27 Ene 74	Real	Real - Espanyol 1974-01-27T00:00:00 La Romareda 3 - 1	Espanyol	...

Ver jornada

Jornada 21

02 Feb 74	Las Palmas	Las Palmas - Valencia 1974-02-02T00:00:00 Gran Canaria 0 - 0	Valencia	...
03 Feb 74	Castellón	Castellón - Real Murcia 1974-02-03T00:00:00 Municipal de Castalia 1 - 0	Real Murcia	...
03 Feb 74	Celta	Celta - CD Málaga 1974-02-03T00:00:00 Abanca Balaídos 5 - 1	CD Málaga	...
03 Feb 74	Elche	Elche - Atlético 1974-02-03T00:00:00 Martínez Valero 0 - 0	Atlético	...
03 Feb 74	Espanyol	Espanyol - Barcelona 1974-02-03T00:00:00 RCDE Stadium 0 - 0	Barcelona	...
03 Feb 74	Real	Real - Granada 1974-02-03T00:00:00 El Molinón-Enrique Castro Quini 4 - 0	Granada	...
03 Feb 74	Racing	Racing - Real Oviedo 1974-02-03T00:00:00 Campos de Sport de El Sardinero 2 - 0	Real Oviedo	...
03 Feb 74	Real	Real - Real 1974-02-03T00:00:00 Anoeta 2 - 0	Real	...
03 Feb 74	Real Madrid	Real Madrid - Athletic 1974-02-03T00:00:00 Santiago Bernabéu 1 - 0	Athletic	...

Ver jornada

Jornada 22

17 Feb 74	Castellón	Castellón - Real 1974-02-17T00:00:00 Municipal de Castalia 2 - 1	Real	...
17 Feb 74	Celta	Celta - Atlético 1974-02-17T00:00:00 Abanca Balaídos 1 - 3	Atlético	...
17 Feb 74	Elche	Elche - Las Palmas 1974-02-17T00:00:00 Martínez Valero 1 - 0	Las Palmas	...
17 Feb 74	Espanyol	Espanyol - Real Oviedo 1974-02-17T00:00:00 RCDE Stadium 2 - 0	Real Oviedo	...
17 Feb 74	Real	Real - Real Murcia 1974-02-17T00:00:00 El Molinón-Enrique Castro Quini 2 - 1	Real Murcia	...
17 Feb 74	Granada	Granada - Athletic 1974-02-17T00:00:00 Nuevo Los Cármenes 0 - 0	Athletic	...
17 Feb 74	Racing	Racing - Valencia 1974-02-17T00:00:00 Campos de Sport de El Sardinero 0 - 1	Valencia	...
17 Feb 74	Real	Real - CD Málaga 1974-02-17T00:00:00 Anoeta 1 - 1	CD Málaga	...
17 Feb 74	Real Madrid	Real Madrid - Barcelona 1974-02-17T00:00:00 Santiago Bernabéu 0 - 5	Barcelona	14

Ver jornada

Jornada 23

24 Feb 74	Atlético	Atlético - Racing 1974-02-24T00:00:00 Wanda Metropolitano 2 - 1	Racing	...
24 Feb 74	Real Murcia	Real Murcia - Granada 1974-02-24T00:00:00 Enrique Roca de Murcia 0 - 0	Granada	...
26 Feb 74	CD Málaga	CD Málaga - Espanyol 1974-02-26T00:00:00 No disponible 1 - 1	Espanyol	...
27 Feb 74	Athletic	Athletic - Castellón 1974-02-27T00:00:00 San Mamés 2 - 0	Castellón	...
27 Feb 74	Barcelona	Barcelona - Real 1974-02-27T00:00:00 Spotify Camp Nou 4 - 1	Real	...
27 Feb 74	Las Palmas	Las Palmas - Real 1974-02-27T00:00:00 Gran Canaria 1 - 0	Real	...
27 Feb 74	Real Oviedo	Real Oviedo - Celta 1974-02-27T00:00:00 Carlos Tartiere 1 - 1	Celta	...
27 Feb 74	Valencia	Valencia - Elche 1974-02-27T00:00:00 Mestalla 2 - 0	Elche	...
28 Feb 74	Real	Real - Real Madrid 1974-02-28T00:00:00 La Romareda 2 - 1	Real Madrid	...

Ver jornada

Jornada 24

02 Mar 74	Atlético	Atlético - Espanyol 1974-03-02T00:00:00 Wanda Metropolitano 5 - 1	Espanyol	...
02 Mar 74	Las Palmas	Las Palmas - Racing 1974-03-02T00:00:00 Gran Canaria 2 - 0	Racing	...
03 Mar 74	Athletic	Athletic - Real Murcia 1974-03-03T00:00:00 San Mamés 3 - 0	Real Murcia	...
03 Mar 74	Barcelona	Barcelona - Castellón 1974-03-03T00:00:00 Spotify Camp Nou 5 - 0	Castellón	...
03 Mar 74	Elche	Elche - Real 1974-03-03T00:00:00 Martínez Valero 1 - 0	Real	...
03 Mar 74	CD Málaga	CD Málaga - Real Madrid 1974-03-03T00:00:00 No disponible 1 - 0	Real Madrid	...
03 Mar 74	Real Oviedo	Real Oviedo - Real 1974-03-03T00:00:00 Carlos Tartiere 0 - 2	Real	...
03 Mar 74	Valencia	Valencia - Celta 1974-03-03T00:00:00 Mestalla 0 - 0	Celta	...
03 Mar 74	Real	Real - Granada 1974-03-03T00:00:00 La Romareda 1 - 0	Granada	...

Ver jornada

Jornada 25

10 Mar 74	Castellón	Castellón - CD Málaga 1974-03-10T00:00:00 Municipal de Castalia 1 - 0	CD Málaga	...
10 Mar 74	Celta	Celta - Las Palmas 1974-03-10T00:00:00 Abanca Balaídos 3 - 1	Las Palmas	...
10 Mar 74	Espanyol	Espanyol - Valencia 1974-03-10T00:00:00 RCDE Stadium 1 - 0	Valencia	...
10 Mar 74	Real	Real - Athletic 1974-03-10T00:00:00 El Molinón-Enrique Castro Quini 2 - 0	Athletic	...
10 Mar 74	Granada	Granada - Barcelona 1974-03-10T00:00:00 Nuevo Los Cármenes 1 - 1	Barcelona	...
10 Mar 74	Real Murcia	Real Murcia - Real 1974-03-10T00:00:00 Enrique Roca de Murcia 1 - 0	Real	...
10 Mar 74	Racing	Racing - Elche 1974-03-10T00:00:00 Campos de Sport de El Sardinero 2 - 1	Elche	...
10 Mar 74	Real	Real - Atlético 1974-03-10T00:00:00 Anoeta 0 - 0	Atlético	...
10 Mar 74	Real Madrid	Real Madrid - Real Oviedo 1974-03-10T00:00:00 Santiago Bernabéu 2 - 0	Real Oviedo	...

Ver jornada

Jornada 26

16 Mar 74	Las Palmas	Las Palmas - Espanyol 1974-03-16T00:00:00 Gran Canaria 1 - 1	Espanyol	...
17 Mar 74	Atlético	Atlético - Real Madrid 1974-03-17T00:00:00 Wanda Metropolitano 0 - 2	Real Madrid	...
17 Mar 74	Barcelona	Barcelona - Real Murcia 1974-03-17T00:00:00 Spotify Camp Nou 1 - 0	Real Murcia	...
17 Mar 74	Elche	Elche - Celta 1974-03-17T00:00:00 Martínez Valero 2 - 0	Celta	...
17 Mar 74	CD Málaga	CD Málaga - Granada 1974-03-17T00:00:00 No disponible 1 - 1	Granada	...
17 Mar 74	Racing	Racing - Real 1974-03-17T00:00:00 Campos de Sport de El Sardinero 3 - 3	Real	...
17 Mar 74	Real Oviedo	Real Oviedo - Castellón 1974-03-17T00:00:00 Carlos Tartiere 0 - 0	Castellón	...
17 Mar 74	Valencia	Valencia - Real 1974-03-17T00:00:00 Mestalla 1 - 2	Real	...
17 Mar 74	Real	Real - Athletic 1974-03-17T00:00:00 La Romareda 3 - 0	Athletic	...

Ver jornada

Jornada 27

24 Mar 74	Athletic	Athletic - Barcelona 1974-03-24T00:00:00 San Mamés 0 - 0	Barcelona	...
24 Mar 74	Castellón	Castellón - Atlético 1974-03-24T00:00:00 Municipal de Castalia 1 - 1	Atlético	...
24 Mar 74	Celta	Celta - Racing 1974-03-24T00:00:00 Abanca Balaídos 1 - 0	Racing	...
24 Mar 74	Espanyol	Espanyol - Elche 1974-03-24T00:00:00 RCDE Stadium 1 - 1	Elche	...
24 Mar 74	Real	Real - Real 1974-03-24T00:00:00 El Molinón-Enrique Castro Quini 2 - 2	Real	...
24 Mar 74	Granada	Granada - Real Oviedo 1974-03-24T00:00:00 Nuevo Los Cármenes 3 - 0	Real Oviedo	...
24 Mar 74	Real Murcia	Real Murcia - CD Málaga 1974-03-24T00:00:00 Enrique Roca de Murcia 0 - 0	CD Málaga	...
24 Mar 74	Real	Real - Las Palmas 1974-03-24T00:00:00 Anoeta 0 - 0	Las Palmas	...
24 Mar 74	Real Madrid	Real Madrid - Valencia 1974-03-24T00:00:00 Santiago Bernabéu 2 - 1	Valencia	...

Ver jornada

Jornada 28

30 Mar 74	Valencia	Valencia - Castellón 1974-03-30T00:00:00 Mestalla 3 - 0	Castellón	...
31 Mar 74	Atlético	Atlético - Granada 1974-03-31T00:00:00 Wanda Metropolitano 2 - 1	Granada	...
31 Mar 74	Barcelona	Barcelona - Real 1974-03-31T00:00:00 Spotify Camp Nou 2 - 0	Real	...
31 Mar 74	Celta	Celta - Real 1974-03-31T00:00:00 Abanca Balaídos 1 - 0	Real	...
31 Mar 74	Elche	Elche - Real 1974-03-31T00:00:00 Martínez Valero 1 - 2	Real	...
31 Mar 74	Las Palmas	Las Palmas - Real Madrid 1974-03-31T00:00:00 Gran Canaria 1 - 0	Real Madrid	...
31 Mar 74	CD Málaga	CD Málaga - Athletic 1974-03-31T00:00:00 No disponible 1 - 0	Athletic	...
31 Mar 74	Racing	Racing - Espanyol 1974-03-31T00:00:00 Campos de Sport de El Sardinero 1 - 1	Espanyol	...
31 Mar 74	Real Oviedo	Real Oviedo - Real Murcia 1974-03-31T00:00:00 Carlos Tartiere 0 - 1	Real Murcia	...

Ver jornada

Jornada 29

06 Abr 74	Real Murcia	Real Murcia - Atlético 1974-04-06T00:00:00 Enrique Roca de Murcia 1 - 0	Atlético	...
07 Abr 74	Athletic	Athletic - Real Oviedo 1974-04-07T00:00:00 San Mamés 2 - 0	Real Oviedo	2
07 Abr 74	Castellón	Castellón - Las Palmas 1974-04-07T00:00:00 Municipal de Castalia 1 - 1	Las Palmas	...
07 Abr 74	Espanyol	Espanyol - Celta 1974-04-07T00:00:00 RCDE Stadium 1 - 0	Celta	...
07 Abr 74	Real	Real - Barcelona 1974-04-07T00:00:00 El Molinón-Enrique Castro Quini 2 - 4	Barcelona	...
07 Abr 74	Granada	Granada - Valencia 1974-04-07T00:00:00 Nuevo Los Cármenes 2 - 2	Valencia	...
07 Abr 74	Real	Real - Racing 1974-04-07T00:00:00 Anoeta 4 - 1	Racing	...
07 Abr 74	Real Madrid	Real Madrid - Elche 1974-04-07T00:00:00 Santiago Bernabéu 1 - 0	Elche	...
07 Abr 74	Real	Real - CD Málaga 1974-04-07T00:00:00 La Romareda 3 - 1	CD Málaga	...

Ver jornada

Jornada 30

13 Abr 74	Espanyol	Espanyol - Real 1974-04-13T00:00:00 RCDE Stadium 3 - 0	Real	...
13 Abr 74	Las Palmas	Las Palmas - Granada 1974-04-13T00:00:00 Gran Canaria 1 - 1	Granada	...
13 Abr 74	Valencia	Valencia - Real Murcia 1974-04-13T00:00:00 Mestalla 1 - 0	Real Murcia	...
14 Abr 74	Atlético	Atlético - Athletic 1974-04-14T00:00:00 Wanda Metropolitano 1 - 0	Athletic	...
14 Abr 74	Celta	Celta - Real 1974-04-14T00:00:00 Abanca Balaídos 3 - 0	Real	...
14 Abr 74	Elche	Elche - Castellón 1974-04-14T00:00:00 Martínez Valero 1 - 0	Castellón	...
14 Abr 74	CD Málaga	CD Málaga - Barcelona 1974-04-14T00:00:00 No disponible 0 - 0	Barcelona	...
14 Abr 74	Racing	Racing - Real Madrid 1974-04-14T00:00:00 Campos de Sport de El Sardinero 2 - 1	Real Madrid	...
14 Abr 74	Real Oviedo	Real Oviedo - Real 1974-04-14T00:00:00 Carlos Tartiere 1 - 0	Real	...

Ver jornada

Jornada 31

20 Abr 74	Real	Real - Espanyol 1974-04-20T00:00:00 Anoeta 3 - 0	Espanyol	...
20 Abr 74	Real	Real - Atlético 1974-04-20T00:00:00 La Romareda 4 - 0	Atlético	...
21 Abr 74	Athletic	Athletic - Valencia 1974-04-21T00:00:00 San Mamés 1 - 0	Valencia	16
21 Abr 74	Barcelona	Barcelona - Real Oviedo 1974-04-21T00:00:00 Spotify Camp Nou 6 - 2	Real Oviedo	2
21 Abr 74	Castellón	Castellón - Racing 1974-04-21T00:00:00 Municipal de Castalia 1 - 1	Racing	...
21 Abr 74	Real	Real - CD Málaga 1974-04-21T00:00:00 El Molinón-Enrique Castro Quini 1 - 0	CD Málaga	...
21 Abr 74	Granada	Granada - Elche 1974-04-21T00:00:00 Nuevo Los Cármenes 2 - 1	Elche	...
21 Abr 74	Real Murcia	Real Murcia - Las Palmas 1974-04-21T00:00:00 Enrique Roca de Murcia 0 - 1	Las Palmas	...
21 Abr 74	Real Madrid	Real Madrid - Celta 1974-04-21T00:00:00 Santiago Bernabéu 6 - 1	Celta	...

Ver jornada

Jornada 32

27 Abr 74	Espanyol	Espanyol - Real Madrid 1974-04-27T00:00:00 RCDE Stadium 1 - 0	Real Madrid	...
27 Abr 74	Las Palmas	Las Palmas - Athletic 1974-04-27T00:00:00 Gran Canaria 1 - 0	Athletic	...
27 Abr 74	Real	Real - Real 1974-04-27T00:00:00 Anoeta 2 - 1	Real	...
27 Abr 74	Valencia	Valencia - Real 1974-04-27T00:00:00 Mestalla 0 - 0	Real	...
28 Abr 74	Atlético	Atlético - Barcelona 1974-04-28T00:00:00 Wanda Metropolitano 2 - 0	Barcelona	...
28 Abr 74	Celta	Celta - Castellón 1974-04-28T00:00:00 Abanca Balaídos 0 - 1	Castellón	...
28 Abr 74	Elche	Elche - Real Murcia 1974-04-28T00:00:00 Martínez Valero 1 - 0	Real Murcia	...
28 Abr 74	Racing	Racing - Granada 1974-04-28T00:00:00 Campos de Sport de El Sardinero 2 - 0	Granada	...
28 Abr 74	Real Oviedo	Real Oviedo - CD Málaga 1974-04-28T00:00:00 Carlos Tartiere 1 - 1	CD Málaga	...

Ver jornada

Jornada 33

04 May 74	Athletic	Athletic - Elche 1974-05-04T00:00:00 San Mamés 2 - 1	Elche	...
05 May 74	Barcelona	Barcelona - Valencia 1974-05-05T00:00:00 Spotify Camp Nou 1 - 0	Valencia	...
05 May 74	Castellón	Castellón - Espanyol 1974-05-05T00:00:00 Municipal de Castalia 3 - 2	Espanyol	...
05 May 74	Granada	Granada - Celta 1974-05-05T00:00:00 Nuevo Los Cármenes 2 - 1	Celta	...
05 May 74	CD Málaga	CD Málaga - Atlético 1974-05-05T00:00:00 No disponible 1 - 2	Atlético	...
05 May 74	Real Murcia	Real Murcia - Racing 1974-05-05T00:00:00 Enrique Roca de Murcia 2 - 0	Racing	...
05 May 74	Real Madrid	Real Madrid - Real 1974-05-05T00:00:00 Santiago Bernabéu 3 - 1	Real	...
05 May 74	Real Oviedo	Real Oviedo - Real 1974-05-05T00:00:00 Carlos Tartiere 0 - 0	Real	...
05 May 74	Real	Real - Las Palmas 1974-05-05T00:00:00 La Romareda 2 - 0	Las Palmas	...

Ver jornada

Jornada 34

11 May 74	Espanyol	Espanyol - Granada 1974-05-11T00:00:00 RCDE Stadium 1 - 1	Granada	...
11 May 74	Las Palmas	Las Palmas - Barcelona 1974-05-11T00:00:00 Gran Canaria 1 - 0	Barcelona	...
11 May 74	Valencia	Valencia - CD Málaga 1974-05-11T00:00:00 Mestalla 2 - 2	CD Málaga	...
12 May 74	Celta	Celta - Real Murcia 1974-05-12T00:00:00 Abanca Balaídos 0 - 2	Real Murcia	...
12 May 74	Elche	Elche - Real 1974-05-12T00:00:00 Martínez Valero 1 - 1	Real	...
12 May 74	Real	Real - Real Madrid 1974-05-12T00:00:00 El Molinón-Enrique Castro Quini 4 - 3	Real Madrid	...
12 May 74	Racing	Racing - Athletic 1974-05-12T00:00:00 Campos de Sport de El Sardinero 2 - 2	Athletic	...
12 May 74	Real	Real - Castellón 1974-05-12T00:00:00 Anoeta 3 - 1	Castellón	...
20 May 74	Atlético	Atlético - Real Oviedo 1974-05-20T00:00:00 Wanda Metropolitano 1 - 0	Real Oviedo	...

Nombre	Goles	Equipo
Quini	20	SPO
Arrúa	17	ZAR
Marcial	17	FCB
J. Cruyff	16	FCB
De Diego	12	ESP
Ansola	12	RSO
Marianín	12	OVI
Galán	12	OVI
Asensi	11	FCB
Grande	11	RAC

Nombre	Amarillas	Equipo
Fernández Amado	6	CEL
Ocampos	6	ZAR
Julio Montero	6	GRA
Aguirre Suárez	6	GRA
Viberti	5	MAL
Gallego	5	FCB
Abel Pérez	5	MUR
Jacquet	5	OVI
Jaén	5	GRA
Macías	5	MAL

Nombre	Rojas	Equipo
Rojo	2	ATH
Megido	2	SPO
Ocampos	2	ZAR
Cela	1	CAS
Iriarte	1	OVI
Villar	1	ATH
Velázquez	1	RMA
Casco	1	MUR
Tonín	1	CAS
Indio	1	ELC

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.3878
Total Execution Time	0.3896

0.0125	SELECT type FROM routes WHERE alias = 'primera1974'
0.0252	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1974 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127	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 = 5399 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0257	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 calendars1974 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 5399 ORDER BY round ASC
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 15:39:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 15:39:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 15:39:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 15:39:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1974 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0260	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 events1974 e ON e.player_id = p.id AND e.league_id = 5399 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5399 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.0209	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 events1974 e ON e.player_id = p.id AND e.league_id = 5399 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5399 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0163	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 events1974 e ON e.player_id = p.id AND e.league_id = 5399 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5399 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138	SELECT ,(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 = 5399 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

laliga,la liga santander,primera división española,liga españa,primera,primera division,liga,la liga,campeonato nacional de españa,liga bbva, LaLiga EA Sports, la liga EA Sports

Primera División 1974

JUGADORES DESTACADOS

Clasificación

Equipos de esta liga

Equipo		PJ	GF	GC	Puntos
1	Barcelona	34	75	24	50
2	Atlético	34	50	31	42
3	Real	34	51	38	40
4	Real	34	46	45	39
5	Athletic	34	35	31	37
6	Granada	34	34	35	36
7	CD Málaga	34	31	32	36
8	Real Madrid	34	48	38	34
9	Espanyol	34	34	38	34
10	Valencia	34	41	33	33
11	Las Palmas	34	28	35	33
12	Celta	34	43	49	30
13	Real	34	49	59	30
14	Elche	34	25	33	29
15	Real Murcia	34	27	37	29
16	Castellón	34	28	46	29
17	Racing	34	36	54	27
18	Real Oviedo	34	29	52	24