4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1988
Temporada Siguiente »
Tercera División 1988 G 10
1987/1988

G10

Tercera División 1988 G 10

  • Algeciras CF
  • CD San Fernando
  • Palma del Rio Atletico CF
  • Cádiz CF Mirandilla
  • Atlético Antoniano
  • Ayamonte
  • Écija Balompié
  • Bollullos CF
  • Coria CF
  • San Roque de Lepe
  • Dos Hermanas CF
  • Utrera
  • CD Rota
  • Brenes Balompié
  • Pilas
  • Montilla
  • RC Portuense
  • Ubrique Ind.
  • Mairena
  • UA. Ceutí
  • Imperio Ceuta
  • Moguer CD
  • Tercera División:
Ver
TEMPORADA 1987/1988
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 42 70 31 64
2 CD San Fernando Fernando 42 64 33 57
3 Palma del Rio Atletico CF Palma 42 66 40 56
4 Cádiz CF Mirandilla Cádiz 42 70 44 53
5 Atlético Antoniano Atlético 42 63 35 52
6 Ayamonte Ayamonte 42 55 32 50
7 Écija Balompié Écija 42 59 41 50
8 Bollullos CF Bollullos 42 57 44 46
9 Coria CF Coria CF 42 55 44 44
10 San Roque de Lepe Roque Lepe 42 45 41 44
11 Dos Hermanas CF Hermanas 42 63 53 43
12 Utrera Utrera 42 51 43 41
13 CD Rota CD Rota 42 47 57 41
14 Brenes Balompié Brenes 42 41 50 40
15 Pilas Pilas 42 42 42 40
16 Montilla Montilla 42 47 48 39
17 RC Portuense Portuense 41 48 71 35
18 Ubrique Ind. Ubrique Ind. 42 35 55 34
19 Mairena Mairena 42 35 72 29
20 UA. Ceutí UA. Ceutí 42 35 67 26
21 Imperio Ceuta Imperio 42 38 85 22
22 Moguer CD Moguer CD 41 24 82 16
Ver
TEMPORADA 1986/1987
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 38 87 24 58
2 Betis Deportivo Betis 38 97 31 58
3 At. Sanluqueño Sanluqueño 38 56 37 51
4 Bollullos CF Bollullos 38 56 30 50
5 Cádiz CF Mirandilla Cádiz 38 69 34 48
6 Utrera Utrera 38 55 31 46
7 Ayamonte Ayamonte 38 43 40 44
8 Coria CF Coria CF 38 62 51 43
9 Dos Hermanas CF Hermanas 38 52 46 43
10 Pilas Pilas 38 37 34 42
11 CD San Fernando Fernando 38 43 32 41
12 Palma del Rio Atletico CF Palma 38 32 50 34
13 Brenes Balompié Brenes 38 39 59 33
14 Mairena Mairena 38 34 46 33
15 RC Portuense Portuense 38 47 64 27
16 CD Rota CD Rota 38 33 61 25
17 Moguer CD Moguer CD 38 36 63 23
18 CD Pozoblanco Pozoblanco 38 32 64 22
19 Egabrense Egabrense 38 31 89 21
20 UA. Ceutí UA. Ceutí 38 35 90 18
Ver
TEMPORADA 1985/1986
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 40 112 22 70
2 Coria CF Coria CF 40 80 31 63
3 Utrera Utrera 40 54 36 50
4 At. Sanluqueño Sanluqueño 40 50 38 48
5 CD Pozoblanco Pozoblanco 40 73 57 48
6 Pilas Pilas 40 58 24 47
7 Mairena Mairena 40 56 36 46
8 CD San Fernando Fernando 40 47 45 45
9 Cádiz CF Mirandilla Cádiz 40 68 40 44
10 Palma del Rio Atletico CF Palma 40 54 40 38
11 RC Portuense Portuense 40 49 57 37
12 Bollullos CF Bollullos 40 32 59 37
13 CD Rota CD Rota 40 55 59 35
14 Moguer CD Moguer CD 40 39 66 34
15 Brenes Balompié Brenes 40 39 52 34
16 Egabrense Egabrense 40 44 61 32
17 Jerez Industrial CF Jerez 40 43 61 32
18 Chiclana CF Chiclana CF 40 40 60 28
19 Imperio Ceuta Imperio 40 42 68 27
20 Puerto Real CF Puerto Real 40 37 66 23
21 Rute Calidad Rute Calidad 40 29 123 22
Ver
TEMPORADA 1984/1985
Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 38 88 38 57
2 Córdoba CF Córdoba CF 38 83 23 56
3 Sevilla At. Sevilla At. 38 80 34 52
4 Moguer CD Moguer CD 38 46 31 47
5 Mairena Mairena 38 60 37 46
6 CD Pozoblanco Pozoblanco 38 51 40 44
7 Puerto Real CF Puerto Real 38 42 45 43
8 Coria CF Coria CF 38 64 45 42
9 Brenes Balompié Brenes 38 56 58 39
10 Rute Calidad Rute Calidad 38 58 54 38
11 At. Sanluqueño Sanluqueño 38 48 48 38
12 Imperio Ceuta Imperio 38 49 52 36
13 RC Portuense Portuense 38 34 45 34
14 CD Rota CD Rota 38 44 55 33
15 Atlético Onubense Atlético 38 56 61 32
16 Jerez Industrial CF Jerez 38 40 58 31
17 Chiclana CF Chiclana CF 38 45 61 30
18 Palma del Rio Atletico CF Palma 38 49 63 29
19 CD San Fernando Fernando 38 38 88 18
20 Racing de Ceuta Racing Ceuta 38 28 123 15
Ver
TEMPORADA 1983/1984
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 38 88 36 56
2 Betis Deportivo Betis 38 79 31 54
3 At. Sanluqueño Sanluqueño 38 61 32 54
4 Coria CF Coria CF 38 50 28 47
5 Mairena Mairena 38 55 33 46
6 Iliturgi CF Iliturgi CF 38 61 49 45
7 Imperio Ceuta Imperio 38 45 39 42
8 CD Rota CD Rota 38 44 47 41
9 CD Pozoblanco Pozoblanco 38 62 44 40
10 Atlético Onubense Atlético 38 63 56 39
11 Brenes Balompié Brenes 38 50 45 37
12 Moguer CD Moguer CD 38 36 45 36
13 Puerto Real CF Puerto Real 38 46 51 36
14 Rute Calidad Rute Calidad 38 46 49 33
15 Jerez Industrial CF Jerez 38 50 61 33
16 Chiclana CF Chiclana CF 38 41 61 31
17 Ayamonte Ayamonte 38 28 63 28
18 CD Alcalá CD Alcalá 38 33 51 27
19 Lucena Lucena 38 33 83 19
20 Riotinto Balompié Riotinto 38 33 100 16
Ver
TEMPORADA 1982/1983
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 38 82 28 61
2 Coria CF Coria CF 38 66 42 48
3 CP Cacereño Cacereño 38 55 42 45
4 CD Pozoblanco Pozoblanco 38 61 36 44
5 Brenes Balompié Brenes 38 50 43 44
6 Mérida CP Mérida CP 38 41 28 43
7 Diter Zafra Diter Zafra 38 42 46 39
8 Puerto Real CF Puerto Real 38 37 37 39
9 Jerez Industrial CF Jerez 38 45 47 39
10 Plasencia Plasencia 38 49 49 39
11 CD Rota CD Rota 38 42 51 38
12 CD Alcalá CD Alcalá 38 36 42 38
13 CF Extremadura Extremadura 38 45 43 37
14 Betis Deportivo Betis 38 49 47 37
15 CD Don Benito Benito 38 45 47 36
16 Iliturgi CF Iliturgi CF 38 46 55 33
17 Riotinto Balompié Riotinto 38 41 55 31
18 Moralo Moralo 38 30 60 24
19 At. Sanluqueño Sanluqueño 38 34 64 23
20 UD Montijo UD Montijo 38 32 66 22
Ver
TEMPORADA 1981/1982
Equipo PJ GF GC Puntos
1 CP Cacereño Cacereño 38 71 29 55
2 Mérida CP Mérida CP 38 56 26 55
3 Sevilla At. Sevilla At. 38 86 40 54
4 Diter Zafra Diter Zafra 38 46 36 48
5 Coria CF Coria CF 38 57 45 46
6 Jerez Industrial CF Jerez 38 62 42 45
7 Plasencia Plasencia 38 47 43 42
8 Betis Deportivo Betis 38 38 33 39
9 Puerto Real CF Puerto Real 38 49 48 38
10 RB Linense RB Linense 38 37 37 38
11 CD Don Benito Benito 38 59 60 37
12 At. Sanluqueño Sanluqueño 38 35 44 34
13 CF Extremadura Extremadura 38 45 57 33
14 CD Rota CD Rota 38 38 49 32
15 Moralo Moralo 38 35 55 32
16 CD Pozoblanco Pozoblanco 38 46 53 29
17 Alcalá de Guadaira Alcalá 38 32 52 28
18 CD Villanovense Villanovense 38 47 61 28
19 UC La Estrella Estrella 38 32 60 26
20 Imperio Ceuta Imperio 38 31 79 21
Ver
TEMPORADA 1980/1981
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 38 88 37 55
2 CD Don Benito Benito 38 48 23 51
3 At. Sanluqueño Sanluqueño 38 49 28 49
4 CP Cacereño Cacereño 38 41 28 48
5 Coria CF Coria CF 38 56 36 47
6 CD Pozoblanco Pozoblanco 38 50 36 45
7 Betis Deportivo Betis 38 60 38 45
8 Puerto Real CF Puerto Real 38 59 33 43
9 Moralo Moralo 38 52 57 39
10 CD Rota CD Rota 38 51 46 38
11 CF Extremadura Extremadura 38 46 57 37
12 Jerez Industrial CF Jerez 38 40 41 37
13 RB Linense RB Linense 38 47 58 36
14 Plasencia Plasencia 38 52 66 34
15 CD Villanovense Villanovense 38 45 55 32
16 Ayamonte Ayamonte 38 42 44 32
17 UD Montijo UD Montijo 38 36 59 28
18 AD Llerenense Llerenense 38 39 69 26
19 UA. Ceutí UA. Ceutí 38 33 64 23
20 O Donnell O Donnell 38 25 84 15
Ver
TEMPORADA 1967/1968
Equipo PJ GF GC Puntos
1 RB Linense RB Linense 30 56 20 46
2 C.D. Almería C.D. 30 57 24 44
3 Algeciras CF Algeciras 30 62 26 43
4 UD Melilla UD Melilla 30 51 30 37
5 Linares CF Linares CF 30 57 26 36
6 Atlético Marbella Atlético 30 50 35 35
7 Estepona Estepona 30 42 49 34
8 At. Malagueño Malagueño 30 36 28 33
9 Iliturgi CF Iliturgi CF 30 50 37 32
10 Adra Adra 30 32 38 31
11 CD Fuengirola Fuengirola 30 45 43 29
12 Recreativo Granada Recreativo 30 40 44 27
13 J. Torremolinos Torremolinos 30 29 54 20
14 C.D.Hispania C.D.Hispania 30 27 64 12
15 Olimpica Victoriana CF Olimpica 30 19 88 11
16 Vandalia Vandalia 30 22 69 10
Ver
TEMPORADA 1966/1967
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 30 67 27 45
2 C.D. Almería C.D. 30 55 28 42
3 RB Linense RB Linense 30 57 25 42
4 UD Melilla UD Melilla 30 53 33 33
5 Atlético Marbella Atlético 30 40 35 33
6 At. Malagueño Malagueño 30 48 38 33
7 Estepona Estepona 30 47 51 32
8 Linares CF Linares CF 30 43 44 28
9 Iliturgi CF Iliturgi CF 30 35 43 28
10 Algeciras CF B Algeciras 30 28 37 28
11 Olimpica Victoriana CF Olimpica 30 37 51 25
12 CD Fuengirola Fuengirola 30 39 55 24
13 Recreativo Granada Recreativo 30 31 49 24
14 Adra Adra 30 29 48 24
15 Imperio Ceuta Imperio 30 31 57 21
16 J. Torremolinos Torremolinos 30 40 59 18
Ver
TEMPORADA 1965/1966
Equipo PJ GF GC Puntos
1 Eldense Eldense 30 76 17 50
2 Cartagena F.C. UCAM Cartagena 30 64 23 48
3 Albacete Albacete 30 47 33 42
4 Alicante Alicante 30 65 48 35
5 Águilas CF Águilas CF 30 49 37 34
6 Real Murcia Imperial Real Murcia 30 67 47 33
7 Rayo Ibense Rayo Ibense 30 60 48 32
8 Jumilla Jumilla 30 48 56 27
9 Atlético Cartagena Atlético 30 49 61 27
10 Orihuela Deportiva CF Orihuela 30 40 43 26
11 Novelda CF Novelda CF 30 46 50 25
12 Ilicitano Ilicitano 30 45 60 22
13 La Roda CF La Roda CF 30 30 66 22
14 Cieza Cieza 29 25 56 22
15 CD Abarán CD Abarán 29 33 54 19
16 CD Lorca CD Lorca 30 31 76 14
Ver
TEMPORADA 1964/1965
Equipo PJ GF GC Puntos
1 Albacete Albacete 30 68 25 47
2 Cartagena F.C. UCAM Cartagena 30 65 21 42
3 Real Murcia Imperial Real Murcia 30 58 30 41
4 Eldense Eldense 30 62 31 38
5 Alicante Alicante 30 49 35 33
6 Jumilla Jumilla 30 38 45 31
7 Rayo Ibense Rayo Ibense 30 47 53 30
8 Ilicitano Ilicitano 30 49 52 30
9 La Roda CF La Roda CF 30 42 59 27
10 Atlético Cartagena Atlético 30 43 52 24
11 Cieza Cieza 30 40 55 24
12 CD Lorca CD Lorca 30 37 70 24
13 Orihuela Deportiva CF Orihuela 30 40 56 23
14 AP Almansa AP Almansa 30 41 48 23
15 Aspense Aspense 30 36 57 23
16 Monovar Monovar 30 40 66 20
Ver
TEMPORADA 1963/1964
Equipo PJ GF GC Puntos
1 Albacete Albacete 30 68 21 52
2 Cartagena F.C. UCAM Cartagena 30 72 17 48
3 Real Murcia Imperial Real Murcia 30 56 40 32
4 Jumilla Jumilla 30 47 37 32
5 Atlético Cartagena Atlético 30 56 46 30
6 Cieza Cieza 30 55 34 30
7 Rayo Ibense Rayo Ibense 30 43 54 29
8 Alicante Alicante 30 28 31 29
9 La Roda CF La Roda CF 30 51 59 28
10 Orihuela Deportiva CF Orihuela 30 36 52 28
11 AP Almansa AP Almansa 30 47 55 27
12 Ilicitano Ilicitano 30 53 58 26
13 CD Lorca CD Lorca 30 35 50 25
14 Monovar Monovar 30 46 70 25
15 Águilas CF Águilas CF 30 38 68 21
16 Madrigueras UD Madrigueras 30 26 65 18
Ver
TEMPORADA 1962/1963
Equipo PJ GF GC Puntos
1 CD Abarán CD Abarán 30 75 30 44
2 Orihuela Deportiva CF Orihuela 30 59 30 42
3 Jumilla Jumilla 30 69 33 39
4 AP Almansa AP Almansa 30 50 46 35
5 Albacete Albacete 30 59 32 35
6 Cieza Cieza 30 52 55 33
7 Real Murcia Imperial Real Murcia 30 55 44 29
8 CD Lorca CD Lorca 30 46 58 29
9 Alicante Alicante 30 47 43 27
10 Rayo Ibense Rayo Ibense 30 51 57 27
11 La Roda CF La Roda CF 30 44 57 25
12 Madrigueras UD Madrigueras 30 42 65 25
13 Monovar Monovar 30 47 74 25
14 Águilas CF Águilas CF 30 59 64 23
15 Crevillente Deportivo Crevillente 30 50 59 23
16 Almoradí Almoradí 30 30 88 19
Ver
TEMPORADA 1961/1962
Equipo PJ GF GC Puntos
1 Constància Constància 10 18 7 17
2 CD Menorca CD Menorca 10 19 16 12
3 Soledad Soledad 10 14 15 10
4 Manacor Manacor 10 16 11 10
5 SD Ibiza SD Ibiza 10 16 17 8
6 Atlètic De Ciutadella Atlètic 10 11 28 3
Ver
TEMPORADA 1960/1961
Equipo PJ GF GC Puntos
1 Albacete Albacete 30 101 27 50
2 Cartagena F.C. UCAM Cartagena 30 97 30 47
3 Real Murcia Imperial Real Murcia 30 75 39 44
4 Eldense Eldense 30 83 52 37
5 Alicante Alicante 30 58 35 35
6 Orihuela Deportiva CF Orihuela 30 64 53 34
7 CD Lorca CD Lorca 30 49 48 30
8 CD Abarán CD Abarán 30 55 59 28
9 Cieza Cieza 30 56 63 27
10 Madrigueras UD Madrigueras 30 45 65 27
11 Novelda CF Novelda CF 30 49 75 25
12 Rayo Ibense Rayo Ibense 30 51 80 24
13 Almoradí Almoradí 29 45 70 23
14 Crevillente Deportivo Crevillente 30 48 84 22
15 Águilas CF Águilas CF 30 55 76 18
16 Callosa Deportiva CF Callosa 29 19 94 5
Ver
TEMPORADA 1959/1960
Equipo PJ GF GC Puntos
1 Hércules Hércules 30 84 19 52
2 Crevillente Deportivo Crevillente 30 58 38 40
3 Albacete Albacete 30 57 30 39
4 Real Murcia Imperial Real Murcia 30 64 40 39
5 Eldense Eldense 30 58 49 31
6 Cartagena F.C. UCAM Cartagena 30 64 46 31
7 CD Lorca CD Lorca 30 41 44 29
8 Novelda CF Novelda CF 30 43 58 29
9 Orihuela Deportiva CF Orihuela 30 47 52 28
10 Alicante Alicante 30 51 44 28
11 Cieza Cieza 30 50 58 27
12 Callosa Deportiva CF Callosa 30 54 78 26
13 Rayo Ibense Rayo Ibense 30 49 65 26
14 Águilas CF Águilas CF 30 48 76 22
15 Almoradí Almoradí 30 41 68 18
16 Villajoyosa Villajoyosa 30 38 82 15
Ver
TEMPORADA 1958/1959
Equipo PJ GF GC Puntos
1 Albacete Albacete 30 66 23 46
2 Alicante Alicante 30 81 30 44
3 Cartagena F.C. UCAM Cartagena 30 84 37 44
4 Orihuela Deportiva CF Orihuela 30 76 48 36
5 CD Lorca CD Lorca 30 58 53 32
6 Almoradí Almoradí 30 70 56 29
7 Novelda CF Novelda CF 30 47 50 29
8 Villajoyosa Villajoyosa 30 53 63 28
9 Callosa Deportiva CF Callosa 30 54 80 27
10 Águilas CF Águilas CF 30 42 53 26
11 Real Murcia Imperial Real Murcia 30 55 71 26
12 Thader Thader 30 62 75 26
13 Crevillente Deportivo Crevillente 30 52 66 25
14 Cieza Cieza 30 48 70 25
15 Hellin Deportivo Hellin 30 46 68 24
16 Élitei Project Élitei 30 35 86 13
Ver
TEMPORADA 1957/1958
Equipo PJ GF GC Puntos
1 Elche Elche 32 129 34 57
2 Cartagena F.C. UCAM Cartagena 32 100 43 41
3 Albacete Albacete 32 83 57 37
4 Real Murcia Imperial Real Murcia 32 81 66 37
5 Orihuela Deportiva CF Orihuela 32 68 54 36
6 Thader Thader 32 83 71 35
7 Lorca FC Lorca FC 32 66 70 33
8 Villajoyosa Villajoyosa 32 85 74 32
9 Águilas CF Águilas CF 32 64 73 31
10 Novelda CF Novelda CF 32 68 61 30
11 Almoradí Almoradí 32 57 75 30
12 Callosa Deportiva CF Callosa 32 54 62 28
13 Cieza Cieza 32 54 71 28
14 Hellin Deportivo Hellin 32 59 73 27
15 Élitei Project Élitei 32 47 106 22
16 Deportiva Minera Deportiva 32 42 70 22
17 AP Almansa AP Almansa 32 51 131 18
18 CD Yeclano CD Yeclano 0 0 0 0
Ver
TEMPORADA 1956/1957
Equipo PJ GF GC Puntos
1 Elche Elche 34 99 36 50
2 Élitei Project Élitei 34 81 46 47
3 Cartagena F.C. UCAM Cartagena 34 108 60 45
4 Real Murcia Imperial Real Murcia 34 89 45 43
5 Albacete Albacete 34 100 50 41
6 Hellin Deportivo Hellin 34 79 54 37
7 Callosa Deportiva CF Callosa 34 95 76 36
8 AP Almansa AP Almansa 34 80 111 34
9 CD Yeclano CD Yeclano 34 71 74 32
10 Orihuela Deportiva CF Orihuela 34 84 85 32
11 Deportiva Minera Deportiva 34 71 80 32
12 CD Lorca CD Lorca 34 60 65 31
13 Thader Thader 34 72 82 30
14 Cieza Cieza 34 49 99 29
15 Águilas CF Águilas CF 34 72 91 28
16 Almoradí Almoradí 34 54 87 28
17 Novelda CF Novelda CF 34 39 81 22
18 Aspense Aspense 34 32 113 15
Ver
TEMPORADA 1955/1956
Equipo PJ GF GC Puntos
1 Levante Levante 18 43 17 28
2 Alicante Alicante 18 48 22 26
3 CF Gandia CF Gandia 18 27 24 19
4 Alcoyano Alcoyano 18 26 21 19
5 CD Acero CD Acero 18 30 29 18
6 UD Alzira UD Alzira 18 30 37 16
7 CD Burriana CD Burriana 18 23 33 15
8 Ontinyent CF Ontinyent 18 27 34 13
9 Peña Soriano Peña 18 22 45 13
10 Albacete Albacete 18 25 39 13
Ver
TEMPORADA 1954/1955
Equipo PJ GF GC Puntos
1 Alcoyano Alcoyano 18 41 19 26
2 Valencia Mestalla Valencia 18 47 24 23
3 CD Burriana CD Burriana 18 22 20 21
4 CF Gandia CF Gandia 18 39 41 20
5 Alicante Alicante 18 42 31 19
6 UD Alzira UD Alzira 18 40 36 18
7 Peña Soriano Peña 18 38 47 16
8 Albacete Albacete 18 40 42 15
9 Villena Villena 18 31 50 14
10 Catarroja CF Catarroja 18 19 49 8

  USO DE MEMORIA  
8,171,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6681
Total Execution Time  0.6701
  CADENA URL  
/tercera1988/grupo10/historico
  GET DATOS  
$_GET['/tercera1988/grupo10/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0145  SELECT type FROM routes WHERE alias = 'tercera1988'
0.0305  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 10 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1988 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=10 DESC LIMIT 1
0.0237  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 4 AND group_code = 10 and tables = 1 AND year <= 1988 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0168  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 = 21766 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 = 21752 AND t.round = 51 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 21738 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 21723 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 21710 AND t.round = 38 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 `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 = 21693 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 21678 AND t.round = 38 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 `tables1968` 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 = 21608 AND t.round = 30 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 `tables1967` 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 = 22205 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1966` 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 = 21594 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 `tables1965` 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 = 21581 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 `tables1964` 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 = 21568 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 `tables1963` 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 = 21556 AND t.round = 30 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 `tables1962` 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 = 21541 AND t.round = 10 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 `tables1961` 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 = 21528 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1960` 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 = 21515 AND t.round = 30 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 `tables1959` 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 = 21502 AND t.round = 30 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 `tables1958` 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 = 21455 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 `tables1957` 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 = 21486 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 `tables1956` 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 = 21468 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables1955` 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 = 21425 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 06:44:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 06:44:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 06:44:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 06:44:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0160  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1988 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0153  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 events1988 e ON e.player_id = p.id AND e.league_id = 21785 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21785 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.0152  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 events1988 e ON e.player_id = p.id AND e.league_id = 21785 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21785 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 events1988 e ON e.player_id = p.id AND e.league_id = 21785 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21785 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0222  SELECT *,(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 = 21785 AND t.round = 51 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC