4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Las Palmas At.

Las Palmas At.

Entrenador: Raúl Martín

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Tenerife B Tenerife B 31 60 21 73
2 Union Sur Yaiza Union Yaiza 31 57 18 69
3 Lanzarote Lanzarote 31 59 28 68
4 Las Palmas At. Palmas 31 68 21 68
5 Panadería Pulido Panadería 31 49 36 52
6 CD Santa Úrsula Santa 31 33 33 42
7 Tamaraceite Tamaraceite 31 39 47 40
8 Arucas Arucas 31 44 40 40
9 Villa Santa Brígida Villa Santa 31 35 31 37
10 San Bartolomé CF Bartolomé 31 39 40 36
11 Marino Marino 31 40 47 36
12 Herbania Herbania 31 28 41 35
13 Ibarra Ibarra 31 31 40 33
14 CD Buzanada CD Buzanada 31 25 39 33
15 Atletico Victoria Atletico 31 28 47 28
16 Gran Tarajal Gran Tarajal 31 19 46 23
17 UD Teror UD Teror 31 25 62 20
18 Unión Puerto Unión 31 24 66 19
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 CD Mensajero Mensajero 30 53 36 58
2 Lanzarote Lanzarote 30 51 29 53
3 UD San Fernando Fernando 30 39 25 51
4 Las Palmas At. Palmas 30 43 28 50
5 Villa Santa Brígida Villa Santa 30 38 26 50
6 Tenerife B Tenerife B 30 44 33 49
7 Panadería Pulido Panadería 30 36 28 47
8 CD Santa Úrsula Santa 30 42 34 44
9 Tamaraceite Tamaraceite 30 33 33 38
10 Union Sur Yaiza Union Yaiza 30 40 49 38
11 Marino Marino 30 38 44 37
12 Arucas Arucas 30 37 47 37
13 Unión Puerto Unión 30 49 38 37
14 Ibarra Ibarra 30 31 58 26
15 Gran Tarajal Gran Tarajal 30 29 49 25
16 Estrella Estrella 30 19 65 17
TEMPORADA 2021/2022
SEGUNDA FEDERACIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Córdoba CF Córdoba CF 34 86 29 82
2 AD Mérida AD Mérida 34 49 26 62
3 CP Cacereño Cacereño 34 48 37 61
4 AD Ceuta FC AD Ceuta FC 34 46 32 54
5 CD Coria CD Coria 34 42 40 53
6 San Roque de Lepe Roque Lepe 34 39 28 52
7 Cádiz CF Mirandilla Cádiz 34 36 35 50
8 Villanovense Villanovense 34 39 28 50
9 UD Montijo UD Montijo 34 37 38 47
10 Xerez Deportivo Xerez 34 28 40 47
11 Vélez CF Vélez CF 34 39 42 46
12 Antequera CF Antequera 34 36 37 44
13 CD Don Benito Benito 34 43 42 41
14 CD Mensajero Mensajero 34 35 47 35
15 Las Palmas At. Palmas 34 41 61 31
16 UD San Fernando Fernando 34 30 55 29
17 Panadería Pulido Panadería 34 32 61 25
18 Tamaraceite Tamaraceite 34 36 64 25
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 18 21 17 32
2 San Fernando CD Fernando 18 22 15 31
3 At. Sanluqueño Sanluqueño 18 18 17 31
4 RB Linense RB Linense 18 17 12 28
5 Tamaraceite Tamaraceite 18 19 15 27
6 Cádiz CF Mirandilla Cádiz 18 20 19 23
7 Las Palmas At. Palmas 18 13 16 21
8 Recreativo Recreativo 18 29 27 20
9 Marbella FC Marbella FC 18 20 19 18
10 Marino Marino 18 11 33 10
11 UCAM Murcia UCAM Murcia 18 22 15 33
12 Linares Deportivo Linares 18 22 16 33
13 Betis Deportivo Betis 18 23 15 30
14 Sevilla At. Sevilla At. 18 27 19 30
15 Córdoba CF Córdoba CF 18 21 16 27
16 Real Murcia Real Murcia 18 22 21 25
17 Recreativo Granada Recreativo 18 20 19 23
18 Pvo. El Ejido Pvo. Ejido 18 17 21 19
19 Yeclano Deportivo Yeclano 18 13 27 11
20 Lorca Deportiva Lorca 18 15 33 9
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 28 44 22 58
2 UD Ibiza UD Ibiza 28 41 18 56
3 Atlético B Atlético B 28 52 27 53
4 Peña Deportiva Peña 28 43 41 45
5 Coruxo Coruxo 28 32 30 41
6 Rayo Majadahonda Rayo 28 31 29 41
7 RM Castilla RM Castilla 28 42 35 40
8 Internacional de Madrid Internaciona 28 39 37 40
9 Pontevedra Pontevedra 28 38 40 38
10 Langreo Langreo 28 28 33 38
11 Racing Ferrol Racing 28 33 33 37
12 Real Oviedo Vetusta Real Oviedo 28 31 38 37
13 UD Melilla UD Melilla 28 29 37 36
14 Celta Fortuna Celta 28 41 45 35
15 Sporting Atlético Sporting 28 36 31 34
16 Las Palmas At. Palmas 28 20 35 34
17 Las Rozas Las Rozas 28 32 29 33
18 Marino de Luanco Marino 28 26 37 32
19 Getafe B Getafe B 28 25 37 28
20 UD Sanse UD Sanse 28 24 53 19
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Fuenlabrada Fuenlabrada 38 49 21 71
2 Ponferradina Ponferradina 38 55 27 69
3 Atlético B Atlético B 38 57 32 68
4 RM Castilla RM Castilla 38 62 45 65
5 Cultural Leonesa Cultural 38 56 34 65
6 Pontevedra Pontevedra 38 45 38 62
7 Guijuelo Guijuelo 38 35 33 59
8 UD Sanse UD Sanse 38 54 45 56
9 Unionistas CF Unionistas 38 39 37 52
10 Coruxo Coruxo 38 38 41 50
11 Real Valladolid Promesas Real 38 33 40 49
12 Salamanca UDS Salamanca 38 40 42 49
13 Burgos Burgos 38 28 32 48
14 Internacional de Madrid Internaciona 38 47 54 48
15 Las Palmas At. Palmas 38 26 33 48
16 Celta Fortuna Celta 38 45 48 46
17 Rápido de Bouzas Rápido 38 28 55 38
18 Unión Adarve Unión 38 42 62 36
19 CDA Navalcarnero Navalcarnero 38 37 70 25
20 Deportivo Fabril Deportivo 38 28 55 24
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 38 51 33 71
2 Marbella FC Marbella FC 38 49 27 70
3 Real Murcia Real Murcia 38 49 33 65
4 Extremadura Extremadura 38 59 38 60
5 UD Melilla UD Melilla 38 43 24 60
6 Villanovense Villanovense 38 29 33 54
7 UCAM Murcia UCAM Murcia 38 38 42 52
8 Recreativo Granada Recreativo 38 34 35 51
9 San Fernando CD Fernando 38 47 46 49
10 Pvo. El Ejido Pvo. Ejido 38 54 55 49
11 RB Linense RB Linense 38 44 37 48
12 CD Badajoz CD Badajoz 38 46 44 48
13 Jumilla Jumilla 38 30 42 47
14 Las Palmas At. Palmas 38 45 44 47
15 Recreativo Recreativo 38 33 36 47
16 AD Mérida AD Mérida 38 34 42 46
17 Écija Balompié Écija 38 38 56 45
18 Córdoba CF B Córdoba 38 40 51 43
19 Betis Deportivo Betis 38 47 61 40
20 Lorca Deportiva Lorca 38 33 64 32
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 92 20 94
2 UD San Fernando Fernando 38 54 38 66
3 Villa Santa Brígida Villa Santa 38 64 44 65
4 Ibarra Ibarra 38 61 41 65
5 Tenerife B Tenerife B 38 57 42 56
6 Marino Marino 38 51 45 56
7 Union Sur Yaiza Union Yaiza 38 55 44 55
8 Panadería Pulido Panadería 38 52 49 55
9 Unión Puerto Unión 38 45 50 51
10 CD Buzanada CD Buzanada 38 45 48 51
11 Tenisca Tenisca 38 66 70 51
12 Lanzarote Lanzarote 38 53 60 49
13 Las Zocas Las Zocas 38 43 56 48
14 El Cotillo El Cotillo 38 62 64 47
15 Estrella Estrella 38 40 42 46
16 CD Santa Úrsula Santa 38 54 61 44
17 Vera Vera 38 44 60 44
18 Unión Viera Unión Viera 38 57 80 42
19 Arucas Arucas 38 41 58 37
20 Telde Telde 38 22 86 20
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Villa Santa Brígida Villa Santa 38 59 26 81
2 Lanzarote Lanzarote 38 67 28 75
3 Las Palmas At. Palmas 38 70 37 73
4 Tenisca Tenisca 38 60 38 71
5 UD San Fernando Fernando 38 41 26 64
6 Las Zocas Las Zocas 38 47 34 63
7 El Cotillo El Cotillo 38 58 52 62
8 Telde Telde 38 59 38 60
9 Tenerife B Tenerife B 38 56 36 59
10 Ibarra Ibarra 38 63 46 57
11 Union Sur Yaiza Union Yaiza 38 47 43 52
12 Vera Vera 38 59 52 52
13 CD Santa Úrsula Santa 38 41 47 47
14 Arucas Arucas 38 36 41 46
15 Unión Viera Unión Viera 38 44 54 43
16 Unión Puerto Unión 38 36 61 37
17 Marino Marino 38 35 67 33
18 Real Sporting San José Real 38 28 63 28
19 UD Cruz Santa Cruz Santa 38 23 61 24
20 At. Granadilla Granadilla 38 27 106 17
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Huesca Huesca 38 61 30 69
2 Bilbao Ath. Bilbao Ath. 38 65 30 66
3 CD Guadalajara Guadalajara 38 49 43 61
4 Real Unión Club Real Unión 38 48 38 60
5 Tudelano Tudelano 38 42 31 58
6 RM Castilla RM Castilla 38 59 40 58
7 Barakaldo Barakaldo 38 50 43 58
8 UD Yugo Socuéllamos Yugo 38 45 45 58
9 CD Toledo CD Toledo 38 47 54 57
10 SD Amorebieta Amorebieta 38 59 54 52
11 Fuenlabrada Fuenlabrada 38 43 54 51
12 Getafe B Getafe B 38 50 51 51
13 Sestao River Sestao River 38 46 51 50
14 Real Sociedad B Real 38 51 56 48
15 Leioa Leioa 38 42 60 48
16 Las Palmas At. Palmas 38 58 60 47
17 Rayo Vallecano B Rayo 38 43 60 43
18 Atlético B Atlético B 38 52 62 41
19 Trival Valderas Trival 38 42 71 37
20 UB Conquense Conquense 38 48 67 30
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Sestao River Sestao River 38 61 41 71
2 Leganés Leganés 38 53 24 70
3 CD Toledo CD Toledo 38 51 33 67
4 Las Palmas At. Palmas 38 50 27 66
5 Bilbao Ath. Bilbao Ath. 38 59 38 65
6 Fuenlabrada Fuenlabrada 38 51 38 64
7 Huesca Huesca 38 52 43 63
8 Barakaldo Barakaldo 38 48 37 60
9 Real Madrid C Real Madrid 38 66 54 56
10 SD Amorebieta Amorebieta 38 55 54 55
11 UB Conquense Conquense 38 47 53 53
12 Real Sociedad B Real 38 41 38 51
13 Tudelano Tudelano 38 45 50 46
14 Getafe B Getafe B 38 37 48 46
15 Real Unión Club Real Unión 38 34 42 44
16 Atlético B Atlético B 38 43 48 41
17 Laudio Laudio 38 42 66 37
18 Puerta Bonita Puerta 38 35 52 36
19 Peña Sport Peña Sport 38 17 60 23
20 Sariñena Sariñena 38 17 58 22
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 90 27 85
2 At. Granadilla Granadilla 38 63 31 81
3 Estrella Estrella 38 65 30 77
4 Unión Viera Unión Viera 38 82 49 75
5 CD Mensajero Mensajero 38 80 37 74
6 Tenerife B Tenerife B 38 63 40 63
7 Vecindario Vecindario 37 49 35 60
8 Corralejo Corralejo 38 43 41 56
9 Las Zocas Las Zocas 38 42 55 56
10 Villa Santa Brígida Villa Santa 38 55 59 54
11 San Andrés y Sauces Andrés 38 50 45 52
12 Telde Telde 38 44 55 52
13 Tenisca Tenisca 38 46 65 51
14 Lanzarote Lanzarote 38 59 58 49
15 Atletico Victoria Atletico 38 41 48 45
16 Vera Vera 38 43 75 42
17 Raqui San Isidro Raqui Isidro 38 41 57 33
18 San Pedro Mártir Pedro 38 21 41 24
19 Tijarafe Tijarafe 37 28 92 15
20 UD Gomera UD Gomera 38 30 95 14
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Marino Marino 38 74 35 76
2 Tenisca Tenisca 38 59 40 72
3 Las Palmas At. Palmas 38 68 29 71
4 Vera Vera 38 67 40 70
5 Lanzarote Lanzarote 38 47 34 66
6 At. Granadilla Granadilla 38 52 35 65
7 Estrella Estrella 38 47 34 63
8 Tenerife B Tenerife B 38 70 53 59
9 Corralejo Corralejo 38 48 45 58
10 Telde Telde 38 55 49 54
11 San Pedro Mártir Pedro 38 50 59 47
12 San Andrés y Sauces Andrés 38 46 64 46
13 CD Mensajero Mensajero 38 54 63 45
14 Villa Santa Brígida Villa Santa 38 56 66 45
15 Atletico Victoria Atletico 38 45 61 45
16 Las Zocas Las Zocas 38 46 60 41
17 Tijarafe Tijarafe 38 39 67 38
18 CD Laguna CD Laguna 38 35 55 37
19 Real Sporting San José Real 38 35 64 35
20 Charco del Pino Charco Pino 38 35 75 22
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Lanzarote Lanzarote 40 65 30 79
2 Las Palmas At. Palmas 40 68 43 78
3 Tenerife B Tenerife B 40 64 34 72
4 At. Granadilla Granadilla 40 48 29 71
5 Villa Santa Brígida Villa Santa 40 62 47 63
6 Corralejo Corralejo 40 52 39 62
7 Marino Marino 40 51 38 61
8 Pájara Playas Jandía Pájara 40 54 58 59
9 Tenisca Tenisca 40 48 58 57
10 Tijarafe Tijarafe 40 54 49 56
11 Vera Vera 40 63 60 56
12 CD Laguna CD Laguna 40 47 48 51
13 CD Mensajero Mensajero 40 62 62 50
14 AD Huracán AD Huracán 40 45 59 49
15 UD Teror UD Teror 40 54 60 49
16 Las Zocas Las Zocas 40 41 50 47
17 CD Victoria Tazacorte Victoria 40 36 57 46
18 Orientación Marítima Orientación 40 45 59 45
19 Raqui San Isidro Raqui Isidro 40 44 69 44
20 Guía Guía 40 37 47 42
21 Realejos Realejos 40 40 84 23
22 Huércal-Overa Huércal-Ove 0 0 0 0
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Corralejo Corralejo 41 56 25 79
2 Las Palmas At. Palmas 41 67 38 74
3 Pájara Playas Jandía Pájara 41 64 36 74
4 Marino Marino 41 65 39 70
5 CD Mensajero Mensajero 41 59 36 68
6 At. Granadilla Granadilla 41 55 48 68
7 Villa Sta. Brigida Villa Sta.. 41 42 29 60
8 Realejos Realejos 41 45 43 56
9 AD Huracán AD Huracán 41 43 41 55
10 Tenisca Tenisca 41 55 47 55
11 Tijarafe Tijarafe 41 52 54 52
12 Castillo CF Castillo CF 41 46 50 50
13 Orientación Marítima Orientación 41 44 55 50
14 UD Teror UD Teror 41 46 53 49
15 CD Laguna CD Laguna 41 41 54 47
16 Las Zocas Las Zocas 41 38 53 47
17 CD Victoria Tazacorte Victoria 41 37 44 47
18 Charco del Pino Charco Pino 41 39 50 46
19 Gáldar Gáldar 41 34 62 40
20 Llanos Aridane Llanos 41 33 58 36
21 Universidad LPGC B Universidad 41 44 73 32
22 Fuerteventura Fuerteventur 21 23 40 22
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 38 60 28 73
2 Lorca Deportiva Lorca 38 58 34 69
3 Alcorcón Alcorcón 38 61 34 66
4 Leganés Leganés 38 51 37 66
5 Real Murcia Imperial Real Murcia 38 41 32 65
6 RM Castilla RM Castilla 38 60 45 63
7 Mérida UD Mérida UD 38 50 34 62
8 Atlético Ciudad Atlético 38 39 27 62
9 Sangonera Sangonera 38 46 37 56
10 Águilas CF Águilas CF 38 43 44 55
11 Vecindario Vecindario 38 36 39 52
12 Universidad LPGC Universidad 38 32 45 48
13 Atlético B Atlético B 38 43 44 47
14 Lanzarote Lanzarote 38 40 57 40
15 Fuerteventura Fuerteventur 38 45 66 39
16 Las Palmas At. Palmas 38 38 54 38
17 CDA Navalcarnero Navalcarnero 38 37 55 37
18 Pájara Playas Jandía Pájara 38 38 55 35
19 CD Alfaro CD Alfaro 38 31 55 32
20 Villa Sta. Brigida Villa Sta.. 38 33 60 26
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 At. Granadilla Granadilla 38 68 36 74
2 Las Palmas At. Palmas 38 60 36 73
3 Gáldar Gáldar 38 47 25 73
4 Castillo CF Castillo CF 38 58 36 68
5 Las Zocas Las Zocas 38 56 42 60
6 Tenisca Tenisca 38 46 39 57
7 Teguise Teguise 38 33 26 57
8 Orientación Marítima Orientación 38 53 50 57
9 Universidad LPGC B Universidad 38 47 45 56
10 CD Laguna CD Laguna 38 55 43 55
11 CD Victoria Tazacorte Victoria 38 55 48 49
12 Villa Sta. Brigida B Villa Sta.. 38 36 48 47
13 Tenerife B Tenerife B 38 42 46 46
14 Tegueste Tegueste 38 36 44 45
15 Tijarafe Tijarafe 38 44 55 45
16 Union Antigua Union 38 35 42 44
17 Marino Marino 38 42 46 43
18 UD Balos UD Balos 38 38 62 37
19 Ibarra Ibarra 38 36 61 34
20 Atlético Arona Atlético 38 34 91 21
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Villa Sta. Brigida Villa Sta.. 35 53 24 63
2 Las Palmas At. Palmas 33 54 31 59
3 Raqui San Isidro Raqui Isidro 33 43 34 56
4 Tenerife B Tenerife B 33 37 23 54
5 Castillo CF Castillo CF 33 43 29 53
6 CD Laguna CD Laguna 33 36 22 52
7 Gáldar Gáldar 32 40 28 51
8 Las Zocas Las Zocas 32 49 37 48
9 Tijarafe Tijarafe 32 44 33 48
10 Teguise Teguise 33 29 32 47
11 At. Granadilla Granadilla 33 52 41 46
12 Doramas Doramas 32 41 37 42
13 Fuerteventura Fuerteventur 32 42 38 41
14 Tenisca Tenisca 32 36 47 39
15 Tegueste Tegueste 33 42 54 38
16 Union Antigua Union 34 37 48 35
17 AD Huracán AD Huracán 32 33 46 35
18 Ibarra Ibarra 32 29 46 35
19 Realejos Realejos 32 35 61 35
20 UD Teror UD Teror 34 28 64 25
21 Union Sur Yaiza Union Yaiza 33 33 61 23
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Fuerteventura Fuerteventur 38 46 25 75
2 CP Mijas Las Lagunas Mijas 38 64 34 72
3 Orientación Marítima Orientación 38 58 48 68
4 At. Granadilla Granadilla 38 42 30 66
5 Villa Santa Brígida Villa Santa 38 56 42 64
6 Tenerife B Tenerife B 38 62 47 61
7 Realejos Realejos 38 45 54 51
8 Gáldar Gáldar 38 53 48 51
9 Teguise Teguise 38 50 49 50
10 Doramas Doramas 38 38 33 50
11 Ibarra Ibarra 38 57 55 49
12 Tenisca Tenisca 38 49 50 48
13 Las Palmas At. Palmas 38 55 45 47
14 Las Zocas Las Zocas 38 39 47 47
15 Tegueste Tegueste 38 39 59 44
16 AD Huracán AD Huracán 38 39 50 43
17 Union Antigua Union 38 38 54 42
18 Maspalomas Maspalomas 38 46 59 42
19 CD Mensajero Mensajero 38 38 55 36
20 Universidad LPGC B Universidad 38 36 66 33
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Tenisca Tenisca 38 77 33 76
2 Raqui San Isidro Raqui Isidro 38 58 29 74
3 CP Mijas Las Lagunas Mijas 38 48 21 64
4 Orientación Marítima Orientación 38 50 42 64
5 Gáldar Gáldar 38 58 49 58
6 Las Zocas Las Zocas 38 56 34 57
7 Villa Santa Brígida Villa Santa 38 46 37 57
8 Las Palmas At. Palmas 38 54 43 53
9 Union Antigua Union 38 49 57 52
10 CD Mensajero Mensajero 38 37 48 50
11 Universidad LPGC B Universidad 38 43 46 50
12 AD Huracán AD Huracán 38 45 41 49
13 Tegueste Tegueste 38 35 40 48
14 Maspalomas Maspalomas 38 46 54 48
15 Ibarra Ibarra 38 51 51 48
16 Realejos Realejos 38 43 60 47
17 Teguise Teguise 38 40 50 43
18 Telde Telde 38 37 58 35
19 CD La Oliva CD La Oliva 38 36 85 29
20 Atlético Arona Atlético 38 36 67 25

  USO DE MEMORIA  
8,307,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2138
Total Execution Time  0.2149
  CADENA URL  
/historico/Palmas-Atletico
  GET DATOS  
$_GET['/historico/Palmas-Atletico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0032  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Palmas-Atletico' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=4668 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=4668 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=4668 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4668 AND type_rel = 2
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4668 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0028  SELECT /*35 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 (1155,2407,11756,12488,13702) ORDER BY n.cover_points DESC, update_date DESC
0.0038  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '4668' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0041  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '4668' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0065  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=4668 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72271,71489,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0043  SELECT count(id) as num_players from rel_players WHERE league_id = 72271 AND teamId = 4668
0.0052  SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 4668
0.0067  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4668
0.0031  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '4668' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4668' and rp.type = 4
0.0042  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '4668' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0079  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72271 WHERE rp.league_id = 72271 AND rp.teamId = 4668 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0067  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72271 WHERE rp.league_id = 72271 AND rp.teamId = 4668 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72271 WHERE rp.league_id = 72271 AND rp.teamId = 4668 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0066  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 4668 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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 `tables2023` 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 = 67986 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2022` 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 = 62383 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 `tables2021` 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 = 58611 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables2019` 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 = 44080 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 `tables2018` 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 = 38809 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  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 `tables2017` 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 = 33362 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables2016` 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 = 15453 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2015` 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 = 3863 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables2014` 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 = 2469 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables2013` 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 = 1954 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2012` 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 = 1408 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2011` 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 = 1124 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables2010` 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 = 840 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables2009` 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 = 128 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2008` 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 = 19 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2007` 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 = 97 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 22124 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 22105 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72271 ORDER BY nameShow LIMIT 100