4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Deportiva Minera Deportiva 31 47 16 72
2 Real Murcia Imperial Real Murcia 30 58 27 59
3 Cieza Cieza 31 39 22 59
4 Lorca Deportiva Lorca 31 58 27 55
5 UCAM Murcia B UCAM Murcia 30 35 22 55
6 Unión Molinense Unión 31 53 29 53
7 Caravaca Caravaca 30 48 30 52
8 At. Pulpileño Pulpileño 30 33 20 43
9 Racing Murcia Racing 31 34 43 40
10 Plus Ultra Plus Ultra 31 38 48 38
11 Muleño CF Muleño CF 30 33 39 37
12 El Palmar El Palmar 30 33 40 36
13 Alcantarilla FC Alcantarilla 31 30 39 31
14 CD Bullense CD Bullense 30 32 59 30
15 Balsicas Atlético Balsicas 30 31 48 30
16 CAP Ciudad de Murcia Ciudad 31 25 40 27
17 CD Algar CD Algar 31 27 55 26
18 Montecasillas Montecasilla 31 29 79 20
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Águilas FC Águilas FC 30 55 15 69
2 Lorca Deportiva Lorca 30 54 28 58
3 FC La Unión Atl. Unión Atl. 30 39 23 56
4 Racing Murcia Racing 30 42 30 53
5 At. Pulpileño Pulpileño 30 45 33 51
6 Unión Molinense Unión 30 44 31 50
7 Real Murcia Imperial Real Murcia 30 39 32 44
8 UCAM Murcia B UCAM Murcia 30 35 37 41
9 Cieza Cieza 30 43 39 40
10 El Palmar El Palmar 30 44 51 37
11 CAP Ciudad de Murcia Ciudad 30 26 31 35
12 Caravaca Caravaca 30 33 43 34
13 Deportiva Minera Deportiva 30 34 47 30
14 Alcantarilla FC Alcantarilla 30 20 38 25
15 Muleño CF Muleño CF 30 33 63 21
16 CD Bullense CD Bullense 30 22 67 18
TEMPORADA 2021/2022
PREFERENTE MURCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Muleño CF Muleño CF 28 56 24 61
2 Cieza Cieza 28 50 25 59
3 EDMF Churra EDMF Churra 28 39 24 51
4 Villa de Fortuna Villa 28 41 23 49
5 Unión Molinense Unión 28 44 34 47
6 CD Beniel CD Beniel 28 45 38 44
7 Abarán CF Abarán CF 28 38 35 42
8 Yeclano Deportivo B Yeclano 28 45 41 41
9 El Raal El Raal 28 36 35 39
10 Plus Ultra Plus Ultra 28 36 35 38
11 Santomera Santomera 28 33 29 36
12 Cehegin Cehegin 28 35 37 36
13 CD El Esparragal Esparragal 28 26 62 22
14 CD Hoya del Campo Hoya Campo 28 23 56 13
15 Independiente Ceutí Independient 28 24 73 9
TEMPORADA 2020/2021
PREFERENTE MURCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Archena Sport Archena 22 68 21 55
2 Villa de Fortuna Villa 22 45 15 53
3 Algezares UD Algezares 22 30 20 37
4 Santomera Santomera 22 30 24 34
5 Cieza Cieza 22 34 24 32
6 Aguilas FC B Aguilas 22 32 41 29
7 CD Algar CD Algar 22 30 26 27
8 Yeclano Deportivo B Yeclano 22 25 34 27
9 CD El Esparragal Esparragal 22 18 35 26
10 CD Beniel CD Beniel 22 30 38 25
11 Alcantarilla FC Alcantarilla 22 17 40 24
12 Atletico Pinatarense Atletico 22 12 53 5
TEMPORADA 2019/2020
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 Racing Murcia Racing 27 76 23 67
2 CD Bullense CD Bullense 27 43 17 62
3 Abarán CF Abarán CF 27 56 31 57
4 FC La Unión Atl. Unión Atl. 27 62 34 45
5 CD Algar CD Algar 27 45 41 41
6 Mar Menor B Mar Menor B 27 44 38 37
7 Archena Sport Archena 27 41 41 36
8 Balsicas Atlético Balsicas 27 44 48 36
9 Villa de Fortuna Villa 27 45 50 36
10 Bala Azul Bala Azul 27 41 49 36
11 Cieza Cieza 27 34 40 32
12 EF Alhama EF Alhama 27 34 49 31
13 CD Beniel CD Beniel 27 42 50 29
14 Unión Molinense Unión 27 38 46 28
15 Ciudad de Calasparra Ciudad 27 39 54 28
16 Atletico Cabezo de Torres Atletico 27 28 55 28
17 CD El Esparragal Esparragal 27 36 61 25
18 Caravaca Caravaca 27 26 47 24
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Yeclano Deportivo Yeclano 42 88 30 89
2 Lorca Deportiva Lorca 42 69 28 89
3 Lorca FC Lorca FC 42 73 28 80
4 EDMF Churra EDMF Churra 42 63 50 77
5 At. Pulpileño Pulpileño 42 65 41 76
6 Águilas FC Águilas FC 42 56 33 74
7 Racing Cartagena Mar Menor Racing 42 55 49 65
8 UCAM Murcia B UCAM Murcia 42 52 42 63
9 Deportiva Minera Deportiva 42 45 55 55
10 Mazarrón FC Mazarrón 42 48 56 54
11 Olímpico de Totana Olímpico 42 54 64 54
12 UD Los Garres Garres 42 36 48 53
13 Real Murcia Imperial Real Murcia 42 56 64 51
14 Muleño CF Muleño CF 42 44 59 49
15 Minerva Minerva 42 42 55 48
16 Huércal-Overa Huércal-Ove 42 56 68 48
17 FC Cartagena B Cartagena 42 51 53 48
18 CAP Ciudad de Murcia Ciudad 42 43 70 44
19 FC La Unión Atl. Unión Atl. 42 42 55 43
20 Estudiantes Murcia Estudiantes 42 37 55 42
21 CD Algar CD Algar 42 29 71 35
22 Cieza Cieza 42 36 66 32
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Yeclano Deportivo Yeclano 38 81 37 75
2 Racing Cartagena Mar Menor Racing 38 59 39 68
3 At. Pulpileño Pulpileño 38 58 34 67
4 EDMF Churra EDMF Churra 38 57 40 63
5 Minerva Minerva 38 63 46 62
6 FC Pinatar FC Pinatar 38 52 47 58
7 Águilas FC Águilas FC 38 48 44 56
8 FC Cartagena B Cartagena 38 49 51 55
9 Estudiantes Murcia Estudiantes 38 53 54 54
10 UCAM Murcia B UCAM Murcia 38 50 50 53
11 Muleño CF Muleño CF 38 43 46 52
12 Deportiva Minera Deportiva 38 48 50 47
13 Lorca FC B Lorca FC B 38 51 48 47
14 Huércal-Overa Huércal-Ove 38 53 57 46
15 Cieza Cieza 38 41 53 46
16 Real Murcia Imperial Real Murcia 38 50 57 45
17 UD Los Garres Garres 38 55 60 44
18 FC La Unión Atl. Unión Atl. 38 43 53 42
19 El Palmar El Palmar 38 52 65 40
20 Bala Azul Bala Azul 38 30 105 15
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Lorca Deportiva Lorca 38 96 38 85
2 Lorca FC B Lorca FC B 38 87 34 85
3 Águilas FC Águilas FC 38 78 30 81
4 Racing Cartagena Mar Menor Racing 38 54 27 67
5 Yeclano Deportivo Yeclano 38 61 38 65
6 Real Murcia Imperial Real Murcia 38 67 44 59
7 El Palmar El Palmar 38 54 48 58
8 UCAM Murcia B UCAM Murcia 38 71 51 55
9 Estudiantes Murcia Estudiantes 38 58 52 53
10 FC La Unión Atl. Unión Atl. 38 47 54 52
11 Cieza Cieza 38 58 66 52
12 At. Pulpileño Pulpileño 38 50 55 49
13 Huércal-Overa Huércal-Ove 38 40 59 43
14 EDMF Churra EDMF Churra 38 53 57 42
15 Muleño CF Muleño CF 38 44 60 42
16 Deportiva Minera Deportiva 38 40 56 41
17 Pinatar Pinatar 38 39 47 39
18 CAP Ciudad de Murcia Ciudad 38 41 63 37
19 CD Algar CD Algar 38 39 68 33
20 Olímpico de Totana Olímpico 38 27 157 17
TEMPORADA 2015/2016
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 UCAM Murcia B UCAM Murcia 34 77 29 73
2 Lorca FC B Lorca FC B 34 68 27 73
3 Olímpico de Totana Olímpico 34 54 36 64
4 Minerva Minerva 34 59 27 60
5 Cieza Cieza 34 57 35 59
6 CD Algar CD Algar 34 59 43 58
7 Mazarrón FC Mazarrón 34 59 45 57
8 UD Los Garres Garres 34 59 56 51
9 Montecasillas Montecasilla 34 56 55 50
10 FC Cartagena B Cartagena 34 50 41 48
11 Jumilla CD Jumilla CD 34 44 40 47
12 Beniajan H. Portman Beniajan 34 43 57 40
13 Unión Molinense Unión 34 38 50 38
14 Alquerias Alquerias 34 37 74 33
15 Bala Azul Bala Azul 34 37 53 31
16 CD Bullense CD Bullense 34 31 69 27
17 Sporting Club Aguileño Sporting 34 30 69 24
18 Juvenia Juvenia 34 27 79 16
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Jumilla Jumilla 34 57 26 72
2 Real Murcia Imperial Real Murcia 34 56 20 69
3 Huércal-Overa Huércal-Ove 34 57 32 68
4 Águilas FC Águilas FC 34 66 30 64
5 Racing Cartagena Mar Menor Racing 34 47 32 60
6 Yeclano Deportivo Yeclano 34 56 43 56
7 Deportiva Minera Deportiva 34 43 41 50
8 FC La Unión Atl. Unión Atl. 34 44 46 47
9 Pinatar Pinatar 34 42 44 45
10 Plus Ultra Plus Ultra 34 50 59 43
11 Muleño CF Muleño CF 34 43 41 39
12 El Palmar El Palmar 34 41 48 39
13 Caravaca Caravaca 34 37 48 38
14 Club Fortuna Club Fortuna 34 48 61 38
15 EF Alhama EF Alhama 34 39 56 35
16 FC Cartagena B Cartagena 34 36 58 35
17 Unión Molinense Unión 34 32 55 29
18 Cieza Cieza 34 23 77 17
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 UCAM Murcia UCAM Murcia 36 71 15 88
2 Yeclano Deportivo Yeclano 36 78 34 75
3 Águilas FC Águilas FC 36 71 33 73
4 Racing Cartagena Mar Menor Racing 36 75 38 70
5 FC La Unión Atl. Unión Atl. 36 80 32 69
6 Jumilla Jumilla 36 69 56 64
7 Huércal-Overa Huércal-Ove 36 50 40 56
8 Deportiva Minera Deportiva 36 59 49 56
9 Real Murcia Imperial Real Murcia 36 57 54 48
10 Plus Ultra Plus Ultra 36 48 57 47
11 Cieza Cieza 36 54 64 45
12 El Palmar El Palmar 36 49 55 43
13 Muleño CF Muleño CF 36 44 75 35
14 Unión Molinense Unión 36 37 64 35
15 At. Pulpileño Pulpileño 36 35 60 32
16 CD Bullense CD Bullense 36 31 80 27
17 Olímpico de Totana Olímpico 36 38 94 21
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Lorca FC Lorca FC 34 86 25 79
2 Cieza Cieza 34 55 27 70
3 Racing Cartagena Mar Menor Racing 34 64 30 69
4 Jumilla Jumilla 34 66 35 67
5 Deportiva Minera Deportiva 34 41 31 57
6 Plus Ultra Plus Ultra 34 43 29 54
7 Real Murcia Imperial Real Murcia 34 32 35 50
8 Unión Molinense Unión 34 40 42 47
9 At. Pulpileño Pulpileño 34 39 42 44
10 El Palmar El Palmar 34 46 48 43
11 Águilas FC Águilas FC 34 42 39 42
12 CD Bullense CD Bullense 34 36 38 42
13 Olímpico de Totana Olímpico 34 46 60 40
14 Huércal-Overa Huércal-Ove 34 39 46 39
15 Club Fortuna Club Fortuna 34 30 53 34
16 Bala Azul Bala Azul 34 34 66 31
17 CD Beniel CD Beniel 34 30 81 19
18 Pinatar Pinatar 34 26 68 14
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Yeclano Deportivo Yeclano 36 73 24 86
2 Águilas FC Águilas FC 36 77 34 81
3 Lorca FC Lorca FC 36 77 24 79
4 Racing Cartagena Mar Menor Racing 36 81 34 79
5 Cieza Cieza 36 79 42 69
6 UCAM Murcia UCAM Murcia 36 70 45 58
7 Real Murcia Imperial Real Murcia 36 45 36 56
8 Jumilla Jumilla 36 54 52 50
9 Bala Azul Bala Azul 36 47 54 50
10 At. Pulpileño Pulpileño 36 54 46 45
11 Plus Ultra Plus Ultra 36 47 58 42
12 Pinatar Pinatar 36 31 43 41
13 Deportiva Minera Deportiva 36 33 56 41
14 Club Fortuna Club Fortuna 36 40 66 36
15 Unión Molinense Unión 36 45 81 34
16 Santomera Santomera 36 39 61 30
17 FC Cartagena B Cartagena 36 28 61 28
18 CF Base Abarán Base Abarán 36 39 77 26
19 Esperanza Esperanza 36 20 85 24
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Costa Calida Costa Calida 36 79 17 86
2 Real Murcia Imperial Real Murcia 36 66 16 80
3 Cieza Cieza 36 74 24 80
4 Racing Cartagena Mar Menor Racing 36 78 28 77
5 Bala Azul Bala Azul 36 56 41 62
6 La Hoya Deportiva Hoya 36 55 45 60
7 At. Pulpileño Pulpileño 36 52 39 56
8 Unión Molinense Unión 36 58 43 52
9 Pinatar Pinatar 36 49 46 51
10 Club Fortuna Club Fortuna 36 37 55 49
11 Santomera Santomera 36 43 52 45
12 Plus Ultra Plus Ultra 36 42 54 45
13 FC Cartagena B Cartagena 36 41 55 43
14 Moratalla Moratalla 36 42 65 41
15 Calasparra Calasparra 36 44 60 38
16 CF Base Abarán Base Abarán 36 26 42 36
17 Puente Tocinos Puente 36 40 82 32
18 CD Beniel CD Beniel 36 32 88 15
19 Lorca Deportiva Lorca 36 5 67 8
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Jumilla Jumilla 38 84 26 86
2 Yeclano Deportivo Yeclano 38 93 37 84
3 Lorca Deportiva Lorca 38 95 36 84
4 Costa Calida Costa Calida 38 81 39 83
5 FC Cartagena B Cartagena 38 84 40 81
6 Pinatar Pinatar 38 68 28 80
7 Cieza Cieza 38 80 32 80
8 At. Pulpileño Pulpileño 38 61 56 52
9 Plus Ultra Plus Ultra 38 59 56 52
10 Santomera Santomera 38 51 44 49
11 Puente Tocinos Puente 38 48 56 48
12 Club Fortuna Club Fortuna 38 50 73 47
13 CPeinsa Cartagena FS CPeinsa 38 59 55 43
14 CD Beniel CD Beniel 38 53 71 42
15 Calasparra Calasparra 38 44 70 36
16 CF Base Abarán Base Abarán 38 26 81 31
17 Bala Azul Bala Azul 38 47 76 30
18 Mazarrón CF Mazarrón 38 41 68 28
19 Lumbreras Lumbreras 38 28 127 18
20 Cuarto Distrito Cuarto 38 30 111 14
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Cfba Caravaca Cfba 38 115 26 87
2 Moratalla Moratalla 38 82 32 83
3 CD La Unión Unión 38 76 27 80
4 Yeclano Deportivo Yeclano 38 83 37 80
5 Pinatar Pinatar 38 77 37 72
6 Mazarrón CF Mazarrón 38 81 46 67
7 Cieza Cieza 38 77 45 62
8 Jumilla Jumilla 38 63 35 62
9 CD Beniel CD Beniel 38 39 32 56
10 Santomera Santomera 38 51 66 49
11 At. Pulpileño Pulpileño 38 50 67 46
12 Murcia Deportivo Murcia 38 59 56 45
13 San Ginés San Ginés 38 49 54 42
14 Bala Azul Bala Azul 38 52 86 40
15 Plus Ultra Plus Ultra 38 43 64 40
16 Calasparra Calasparra 38 43 60 40
17 Lumbreras Lumbreras 38 41 90 30
18 Pozo Estrecho Pozo 38 40 88 30
19 Muleño CF Muleño CF 38 33 85 23
20 Ciudad Lorca Ciudad Lorca 38 32 153 14
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Atlético Ciudad Atlético 38 84 29 93
2 Sangonera Sangonera 38 78 34 79
3 Real Murcia Imperial Real Murcia 38 75 30 79
4 Cfba Caravaca Cfba 38 93 38 76
5 Pinatar Pinatar 38 90 38 75
6 Calasparra Calasparra 38 62 45 65
7 CD La Unión Unión 38 55 39 62
8 Las Palas Las Palas 38 60 44 60
9 Moratalla Moratalla 38 56 41 59
10 Cieza Cieza 38 66 61 55
11 Santomera Santomera 38 46 44 53
12 Yeclano Deportivo Yeclano 38 62 54 49
13 Muleño CF Muleño CF 38 43 64 45
14 Jumilla Jumilla 38 45 66 39
15 San Ginés San Ginés 38 39 53 37
16 Imperial Prom. Imperial 38 50 98 34
17 Bala Azul Bala Azul 38 42 71 33
18 Olímpico de Totana Olímpico 38 41 91 29
19 Alquerias Alquerias 38 27 83 22
20 Ceuti At. Ceuti At. 38 25 116 13
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Orihuela CF Orihuela CF 38 58 25 76
2 Águilas CF Águilas CF 38 79 32 76
3 Sangonera Sangonera 38 65 35 75
4 AD Mar Menor Menor 38 77 42 75
5 Mazarrón CF Mazarrón 38 69 37 71
6 Real Murcia Imperial Real Murcia 38 59 31 69
7 Horadada Horadada 38 52 43 60
8 Cfba Caravaca Cfba 38 51 58 54
9 Pinatar Pinatar 38 57 50 53
10 Ciudad Lorca Ciudad Lorca 38 54 57 51
11 Molinense Molinense 38 53 49 50
12 Las Palas Las Palas 38 61 59 46
13 Jumilla Jumilla 38 39 54 45
14 Calasparra Calasparra 38 40 58 43
15 Balsicas Atlético Balsicas 38 52 74 42
16 CD La Unión Unión 38 50 66 40
17 UCAM Murcia UCAM Murcia 38 38 51 34
18 Santomera Santomera 38 38 64 34
19 Cieza Cieza 38 40 74 33
20 Bala Azul Bala Azul 38 38 111 16
TEMPORADA 2000/2001
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Ciudad de Murcia Ciudad 42 87 20 99
2 Orihuela CF Orihuela CF 42 102 25 98
3 Yeclano CF Yeclano CF 42 95 29 94
4 Lorca CF Lorca CF 42 104 35 93
5 AD Mar Menor Menor 42 82 40 85
6 Águilas CF Águilas CF 42 65 43 73
7 Sangonera Sangonera 42 58 48 70
8 Las Palas Las Palas 42 77 44 69
9 Bala Azul Bala Azul 42 71 57 61
10 Real Murcia Imperial Real Murcia 42 66 65 57
11 Horadada Horadada 42 64 70 57
12 Mazarrón CF Mazarrón 42 48 65 55
13 Jumilla Jumilla 42 49 67 50
14 UCAM Murcia UCAM Murcia 42 48 76 46
15 Caravaca Caravaca 42 45 67 45
16 Molinense Molinense 42 51 71 44
17 Alquerias Alquerias 42 36 67 41
18 Olímpico de Totana Olímpico 42 40 93 35
19 CD Alhameño Orenés Alhameño 42 41 89 34
20 Cieza Cieza 42 40 90 32
21 Pinatar Pinatar 42 40 101 31
22 Lumbreras Lumbreras 42 35 82 22
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Olímpico de Totana Olímpico 38 80 35 76
2 Horadada Horadada 38 66 29 76
3 AD Mar Menor Menor 38 70 39 75
4 Orihuela CF Orihuela CF 38 66 35 71
5 Jumilla Jumilla 38 56 41 68
6 Las Palas Las Palas 38 60 44 61
7 CD Alhameño Orenés Alhameño 38 68 46 59
8 Molinense Molinense 38 54 43 59
9 Real Murcia Imperial Real Murcia 38 63 46 57
10 Cieza Cieza 38 47 45 54
11 Bala Azul Bala Azul 38 56 51 50
12 CD Bullense CD Bullense 38 41 48 47
13 Alquerias Alquerias 38 37 58 42
14 Sangonera Sangonera 38 40 51 41
15 Lumbreras Lumbreras 38 36 58 39
16 CD Abarán CD Abarán 38 49 71 38
17 Caravaca Caravaca 38 51 79 38
18 Muleño CF Muleño CF 38 46 78 35
19 UA. Ceutí UA. Ceutí 38 41 84 29
20 CD Beniel CD Beniel 38 28 74 23

  USO DE MEMORIA  
8,184,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.7048
Total Execution Time  0.7069
  CADENA URL  
/historico/Cieza
  GET DATOS  
$_GET['/historico/Cieza']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0301  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73335
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=775 AND type_rel = 2
0.0156  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 775 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0160  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 (129256,520254,637063,836089) ORDER BY n.cover_points DESC, update_date DESC
0.0188  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 = '775' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73335 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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=775 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (73335,72273,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.0169  SELECT count(id) as num_players from rel_players WHERE league_id = 72273 AND teamId = 775
0.0168  SELECT count(id) as num_players from rel_players WHERE league_id = 73335 AND teamId = 775
0.0177  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 775
0.0155  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 = '775' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '775' and rp.type = 4
0.0156  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 = '775' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0209  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 = 72273 WHERE rp.league_id = 72273 AND rp.teamId = 775 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.0205  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 = 72273 WHERE rp.league_id = 72273 AND rp.teamId = 775 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0196  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 = 72273 WHERE rp.league_id = 72273 AND rp.teamId = 775 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0181  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 = 775 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67987 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.0164  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 = 59805 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 = 44401 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39037 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 = 33363 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 3922 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 2562 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 1955 AND t.round = 34 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 `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 = 1447 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 `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 = 1157 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 `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 = 841 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 `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 = 143 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 20 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 `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 = 22106 AND t.round = 38 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 `tables2001` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22042 AND t.round = 42 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 `tables2000` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22026 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC