4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA ÉLITE CATALANA
Equipo PJ GF GC Puntos
1 Europa B Europa B 26 48 22 57
2 Sabadell B Sabadell B 26 41 24 43
3 UE Vic UE Vic 26 33 20 42
4 UA Horta UA Horta 26 45 35 39
5 UE Figueres UE Figueres 26 35 29 38
6 Atlètic Lleida Atlètic 26 42 35 37
7 Rubí Rubí 26 37 31 36
8 UE Valls UE Valls 26 32 34 35
9 Lloret Lloret 26 38 41 34
10 Can Vidalet Can Vidalet 26 37 35 34
11 Palamós Palamós 26 32 44 29
12 UE Sants UE Sants 26 24 35 29
13 EC Granollers Granollers 26 42 43 28
14 Santboià Santboià 26 23 42 26
15 Viladecans Viladecans 26 24 42 24
16 Guineueta Guineueta 26 26 47 23
TEMPORADA 2022/2023
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 L'Escala L'Escala 30 52 30 59
2 Palamós Palamós 30 46 35 53
3 UE Vic UE Vic 30 43 31 53
4 UE Figueres UE Figueres 30 44 39 51
5 EC Granollers Granollers 30 51 34 49
6 Lloret Lloret 30 57 45 48
7 Mataró Mataró 30 46 46 41
8 Manlleu Manlleu 30 43 44 40
9 Parets Parets 30 34 35 38
10 Banyoles Banyoles 30 33 37 38
11 Caldes Montbui Caldes 30 55 54 36
12 EF Bosc de Tosca Bosc Tosca 30 37 40 35
13 Can Gibert Can Gibert 30 40 53 34
14 Mollet Mollet 30 29 35 33
15 Bescanó Bescanó 30 37 57 29
16 CF Torelló CF Torelló 30 30 62 21
TEMPORADA 2021/2022
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Montañesa Montañesa 26 48 25 53
2 Lloret Lloret 26 52 34 45
3 L'Escala L'Escala 26 47 33 42
4 Mollet Mollet 26 33 24 40
5 Mataró Mataró 26 38 32 40
6 Parets Parets 26 41 35 39
7 Bescanó Bescanó 26 32 36 38
8 Palamós Palamós 26 42 36 35
9 Unificació Llefià Unificació 26 36 36 35
10 Banyoles Banyoles 26 25 30 33
11 Martinenc Martinenc 26 26 33 32
12 Les Franqueses Franqueses 26 39 41 31
13 Llagostera B Llagostera 26 24 48 28
14 La Jonquera UE Jonquera 26 18 58 12
TEMPORADA 2020/2021
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Tona Tona 18 37 20 36
2 Lloret Lloret 18 45 23 35
3 UE Vic UE Vic 18 33 17 29
4 L'Escala L'Escala 18 34 23 29
5 Bescanó Bescanó 18 25 15 29
6 Manlleu Manlleu 18 28 29 26
7 Palamós Palamós 18 21 18 23
8 Llagostera B Llagostera 18 22 28 23
9 Vic Riuprimer Riuprimer 18 17 29 15
10 La Jonquera UE Jonquera 18 7 67 1
TEMPORADA 2019/2020
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Girona FC B Girona FC B 22 46 2 62
2 FE Grama FE Grama 22 34 24 42
3 Palamós Palamós 22 43 29 41
4 Manlleu Manlleu 22 37 28 41
5 UE Vic UE Vic 22 34 17 38
6 Guineueta Guineueta 22 29 20 34
7 Mataró Mataró 22 24 24 33
8 Júpiter Júpiter 21 26 30 26
9 L'Escala L'Escala 22 30 35 26
10 Rubí Rubí 21 24 37 26
11 Lloret Lloret 21 31 36 25
12 La Jonquera UE Jonquera 22 17 28 25
13 Sabadell Nord Sabadell 21 25 38 24
14 Mollet Mollet 21 32 33 22
15 Tona Tona 22 18 32 17
16 Parets Parets 22 25 45 16
17 Llagostera B Llagostera 21 14 31 13
TEMPORADA 2018/2019
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 UE Vilassar de Mar Vilassar 34 56 31 70
2 Girona FC B Girona FC B 34 69 26 68
3 Banyoles Banyoles 34 42 31 57
4 Palamós Palamós 34 50 39 53
5 Guineueta Guineueta 34 50 44 52
6 Manlleu Manlleu 34 51 48 47
7 UE Vic UE Vic 34 41 29 46
8 Sabadell Nord Sabadell 34 46 54 46
9 Lloret Lloret 34 52 48 45
10 Can Vidalet Can Vidalet 34 45 44 44
11 Llagostera B Llagostera 34 53 58 44
12 Rubí Rubí 34 45 47 43
13 Tona Tona 34 52 65 42
14 La Jonquera UE Jonquera 34 40 53 41
15 Sant Cugat Sant Cugat 34 42 51 40
16 San Juan At. M. Juan 34 52 64 36
17 Farners Farners 34 29 49 36
18 Argentona Argentona 34 37 71 28
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Espanyol B Espanyol B 38 74 25 90
2 UE Sant Andreu Sant Andreu 38 61 24 71
3 L´Hospitalet L´Hospitale 38 61 31 71
4 Terrassa FC Terrassa FC 38 60 38 64
5 AE Prat AE Prat 38 57 35 63
6 CF Pobla de Mafumet Pobla 38 40 25 63
7 Ascó Ascó 38 47 41 60
8 CE Europa CE Europa 38 48 46 58
9 FC Vilafranca Vilafranca 38 48 42 54
10 UE Figueres UE Figueres 38 47 43 53
11 UA Horta UA Horta 38 47 52 50
12 Cerdanyola FC Cerdanyola 38 35 43 48
13 Santboià Santboià 38 35 37 48
14 Reus Deportiu B Reus 38 40 50 47
15 Santfeliuenc FC Santfeliuenc 38 43 42 46
16 Castelldefels Castelldefel 38 40 46 44
17 EC Granollers Granollers 38 32 54 38
18 Palamós Palamós 38 38 64 31
19 CF Gavá CF Gavá 38 28 87 21
20 UE Vilassar de Mar Vilassar 38 24 80 18
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Olot Olot 38 73 38 80
2 CF Peralada CF Peralada 38 68 27 77
3 Terrassa FC Terrassa FC 38 48 26 66
4 FC Vilafranca Vilafranca 38 60 37 64
5 UE Sant Andreu Sant Andreu 38 51 40 60
6 Ascó Ascó 38 44 37 57
7 CF Pobla de Mafumet Pobla 38 43 36 55
8 EC Granollers Granollers 38 47 54 50
9 UE Figueres UE Figueres 38 39 41 50
10 UE Vilassar de Mar Vilassar 38 40 44 50
11 Palamós Palamós 38 49 55 49
12 CE Europa CE Europa 38 28 32 47
13 Santfeliuenc FC Santfeliuenc 38 39 44 45
14 Cerdanyola FC Cerdanyola 38 43 51 45
15 Castelldefels Castelldefel 38 34 51 42
16 La Jonquera UE Jonquera 38 19 29 42
17 Montañesa Montañesa 38 32 48 42
18 Manlleu Manlleu 38 41 59 40
19 Júpiter Júpiter 38 32 52 35
20 Sabadell B Sabadell B 38 34 63 31
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 AE Prat AE Prat 38 62 26 76
2 CF Gavá CF Gavá 38 69 38 70
3 CE Europa CE Europa 38 60 33 68
4 FC Vilafranca Vilafranca 38 68 55 66
5 Montañesa Montañesa 38 52 35 65
6 Sabadell B Sabadell B 38 57 41 62
7 UE Sant Andreu Sant Andreu 38 54 46 55
8 Cerdanyola FC Cerdanyola 38 52 50 54
9 Júpiter Júpiter 38 60 68 51
10 UE Figueres UE Figueres 38 48 40 51
11 Ascó Ascó 38 35 43 49
12 Palamós Palamós 38 54 54 48
13 Terrassa FC Terrassa FC 38 43 61 48
14 CF Peralada CF Peralada 38 50 54 47
15 Manlleu Manlleu 38 44 58 47
16 Santfeliuenc FC Santfeliuenc 38 47 55 45
17 EC Granollers Granollers 38 52 63 44
18 Rubí Rubí 38 38 57 39
19 Morell Morell 38 29 70 28
20 Masnou Masnou 38 40 67 26
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Ascó Ascó 38 61 34 72
2 CF Pobla de Mafumet Pobla 38 54 30 69
3 CE Europa CE Europa 38 53 32 68
4 UE Figueres UE Figueres 38 46 44 59
5 FC Vilafranca Vilafranca 38 57 56 59
6 AE Prat AE Prat 38 49 34 59
7 Terrassa FC Terrassa FC 38 56 42 59
8 Rubí Rubí 38 47 40 54
9 Masnou Masnou 38 40 48 51
10 Cerdanyola FC Cerdanyola 38 44 49 49
11 Palamós Palamós 38 52 53 49
12 CF Peralada CF Peralada 38 41 50 49
13 Montañesa Montañesa 38 41 40 48
14 CF Gavá CF Gavá 38 42 54 48
15 Sabadell B Sabadell B 38 46 49 47
16 Santfeliuenc FC Santfeliuenc 38 41 48 47
17 Manlleu Manlleu 38 51 54 45
18 Castelldefels Castelldefel 38 39 47 41
19 Martinenc Martinenc 38 49 70 37
20 UE Vilassar de Mar Vilassar 38 28 63 28
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 UE Cornellà Cornellà 38 58 40 73
2 Montañesa Montañesa 38 61 31 73
3 CE Europa CE Europa 38 52 29 69
4 Terrassa FC Terrassa FC 38 55 35 69
5 Rubí Rubí 38 58 37 69
6 Ascó Ascó 38 53 40 68
7 Palamós Palamós 38 62 53 61
8 CF Pobla de Mafumet Pobla 38 45 37 57
9 Santfeliuenc FC Santfeliuenc 38 46 41 57
10 Manlleu Manlleu 38 39 39 50
11 UE Figueres UE Figueres 38 51 52 47
12 Cerdanyola FC Cerdanyola 38 52 58 46
13 FC Vilafranca Vilafranca 38 41 50 44
14 Masnou Masnou 38 36 46 44
15 CF Gavá CF Gavá 38 43 52 42
16 Castelldefels Castelldefel 38 47 50 42
17 UE Vilassar de Mar Vilassar 38 35 49 42
18 Santboià Santboià 38 47 54 40
19 Rapitenca Rapitenca 38 31 67 31
20 UDA Gramanet Gramanet 38 25 77 18
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 UE Cornellà Cornellà 36 67 30 76
2 Olot Olot 36 62 28 73
3 CE Europa CE Europa 36 51 25 69
4 Manlleu Manlleu 36 43 27 61
5 UE Figueres UE Figueres 36 49 42 56
6 CF Pobla de Mafumet Pobla 36 48 48 51
7 Rapitenca Rapitenca 36 46 39 50
8 UDA Gramanet Gramanet 36 32 30 48
9 Palamós Palamós 36 46 51 45
10 Castelldefels Castelldefel 36 31 39 45
11 Rubí Rubí 36 56 50 44
12 CF Gavá CF Gavá 36 36 41 44
13 UE Vilassar de Mar Vilassar 36 42 43 43
14 Santboià Santboià 36 40 46 39
15 FC Vilafranca Vilafranca 36 34 52 39
16 Montañesa Montañesa 36 32 49 38
17 Júpiter Júpiter 36 39 54 37
18 UE Vic UE Vic 36 38 58 35
19 Balaguer Balaguer 36 33 73 23
TEMPORADA 2011/2012
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 UE Figueres UE Figueres 34 69 28 78
2 UE Vilassar de Mar Vilassar 34 64 31 69
3 Palamós Palamós 34 66 29 67
4 CP San Cristóbal Cristóbal 34 53 50 63
5 Cerdanyola FC Cerdanyola 34 57 41 54
6 Mollet Mollet 34 61 44 53
7 UE Avià UE Avià 34 61 59 48
8 Farners Farners 34 63 63 45
9 Cf Lloret Cf Lloret 34 48 59 45
10 Ripollet Ripollet 34 65 65 44
11 Montcada Montcada 34 52 61 44
12 Guíxols Guíxols 34 44 54 42
13 CF Peralada CF Peralada 34 58 58 41
14 Gramanet B Gramanet B 34 49 66 40
15 San Lorenzo San Lorenzo 34 38 54 38
16 Premià Premià 34 35 59 32
17 CE Manresa CE Manresa 34 45 65 28
18 Junior Junior 34 32 74 24
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CF Badalona Futur Badalona 38 65 36 73
2 Montañesa Montañesa 38 40 33 67
3 CF Pobla de Mafumet Pobla 38 60 36 67
4 Reus Deportiu Reus 38 52 26 65
5 Espanyol B Espanyol B 38 65 38 64
6 Manlleu Manlleu 38 58 40 61
7 CE Europa CE Europa 38 54 42 58
8 UE Cornellà Cornellà 38 58 44 55
9 AE Prat AE Prat 38 49 42 53
10 CF Gavá CF Gavá 38 42 45 52
11 FC Vilafranca Vilafranca 38 48 55 49
12 Terrassa FC Terrassa FC 38 58 53 47
13 Castelldefels Castelldefel 38 37 45 47
14 Amposta Amposta 38 45 65 45
15 Balaguer Balaguer 38 42 60 43
16 Masnou Masnou 38 51 60 41
17 Vilanova Geltru CF Vilanova 38 42 51 41
18 Palamós Palamós 38 35 45 41
19 Ascó Ascó 38 29 72 29
20 Premià Premià 38 24 66 27
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 L´Hospitalet L´Hospitale 38 75 16 86
2 Reus Deportiu Reus 38 69 23 83
3 Santboià Santboià 38 68 46 70
4 AE Prat AE Prat 38 60 33 67
5 UE Cornellà Cornellà 38 43 41 61
6 Manlleu Manlleu 38 53 39 60
7 CF Badalona Futur Badalona 38 58 42 56
8 CE Europa CE Europa 38 56 51 54
9 Balaguer Balaguer 38 55 48 52
10 Amposta Amposta 38 56 59 50
11 Castelldefels Castelldefel 38 52 60 48
12 CF Pobla de Mafumet Pobla 38 46 52 47
13 Vilanova Geltru CF Vilanova 38 50 54 46
14 Palamós Palamós 38 42 55 46
15 Ascó Ascó 38 48 69 43
16 Cassà Cassà 38 48 61 42
17 Premià Premià 38 35 53 36
18 Rapitenca Rapitenca 38 46 71 34
19 Blanes Blanes 38 43 85 27
20 Olesa Montserrat Olesa 38 30 75 26
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Espanyol B Espanyol B 38 84 26 83
2 Reus Deportiu Reus 38 76 37 79
3 L´Hospitalet L´Hospitale 38 63 28 76
4 Santboià Santboià 38 58 39 66
5 Manlleu Manlleu 38 61 41 64
6 Premià Premià 38 70 53 64
7 Vilanova Geltru CF Vilanova 38 64 49 55
8 AE Prat AE Prat 38 46 45 55
9 CF Pobla de Mafumet Pobla 38 55 62 52
10 Amposta Amposta 38 62 66 49
11 CE Europa CE Europa 38 52 55 48
12 UE Cornellà Cornellà 38 47 59 48
13 Cassà Cassà 38 47 52 46
14 Rapitenca Rapitenca 38 44 55 43
15 Blanes Blanes 38 58 73 42
16 Balaguer Balaguer 38 49 58 39
17 Palamós Palamós 38 45 69 38
18 Mataró Mataró 38 44 68 36
19 Miapuesta Miapuesta 38 42 80 31
20 Banyoles Banyoles 38 30 82 18
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Barça Atlètic Barça 38 70 41 83
2 UE Sant Andreu Sant Andreu 38 74 25 82
3 Reus Deportiu Reus 38 63 37 65
4 Santboià Santboià 38 45 32 60
5 Rapitenca Rapitenca 38 51 43 59
6 Palamós Palamós 38 46 41 58
7 Premià Premià 38 65 52 55
8 CF Pobla de Mafumet Pobla 38 52 45 52
9 Banyoles Banyoles 38 39 48 51
10 Balaguer Balaguer 38 46 45 50
11 CE Europa CE Europa 38 51 49 50
12 Vilanova Geltru CF Vilanova 38 58 53 49
13 Manlleu Manlleu 38 52 62 48
14 Cassà Cassà 38 49 58 48
15 Blanes Blanes 38 52 61 48
16 Mataró Mataró 38 42 48 48
17 Castelldefels B Castelldefel 38 40 54 45
18 Igualada Igualada 38 45 68 37
19 CE Manresa CE Manresa 38 37 58 35
20 Masnou Masnou 38 27 84 21
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Reus Deportiu Reus 38 62 12 82
2 Girona Girona 38 64 34 80
3 CE Sabadell CE Sabadell 38 78 35 80
4 CF Gavá CF Gavá 38 69 41 72
5 Vilanova Geltru CF Vilanova 38 64 49 64
6 Mataró Mataró 38 54 46 62
7 Santboià Santboià 38 45 48 55
8 Balaguer Balaguer 38 55 59 51
9 Palamós Palamós 38 41 41 51
10 CE Manresa CE Manresa 38 32 50 46
11 Rapitenca Rapitenca 38 50 44 45
12 Castelldefels Castelldefel 38 44 59 45
13 Barcelona C Barcelona C 38 45 52 45
14 CE Europa CE Europa 38 51 48 44
15 Blanes Blanes 38 50 57 43
16 Premià Premià 38 40 58 43
17 Masnou Masnou 38 47 66 40
18 AE Prat AE Prat 38 42 62 40
19 CF Peralada CF Peralada 38 43 69 33
20 Palafrugell Palafrugell 38 29 75 26
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Girona Girona 38 86 40 84
2 Espanyol B Espanyol B 38 84 32 82
3 CF Gavá CF Gavá 38 72 44 67
4 Vilanova Geltru CF Vilanova 38 61 43 66
5 CE Manresa CE Manresa 38 45 37 59
6 Santboià Santboià 38 47 45 58
7 Rapitenca Rapitenca 38 44 44 55
8 CF Peralada CF Peralada 38 54 58 55
9 Balaguer Balaguer 38 49 46 54
10 Castelldefels Castelldefel 38 42 37 52
11 Mataró Mataró 38 52 53 52
12 AE Prat AE Prat 38 50 47 51
13 CE Europa CE Europa 38 38 49 50
14 Barcelona C Barcelona C 38 40 50 43
15 Palafrugell Palafrugell 38 39 59 41
16 Palamós Palamós 38 34 63 40
17 UE Cornellà Cornellà 38 39 63 38
18 F.E. Figueres F.E. 38 40 56 36
19 Rubí Rubí 38 38 57 33
20 EC Granollers Granollers 38 37 68 31
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 L´Hospitalet L´Hospitale 38 86 36 80
2 Mataró Mataró 38 70 31 72
3 UE Sant Andreu Sant Andreu 38 58 34 72
4 Reus Deportiu Reus 38 60 39 65
5 CF Peralada CF Peralada 38 57 43 64
6 Santboià Santboià 38 47 39 63
7 Balaguer Balaguer 38 53 45 61
8 EC Granollers Granollers 38 45 39 60
9 CF Gavá CF Gavá 38 44 48 54
10 F.E. Figueres F.E. 38 36 39 53
11 Castelldefels Castelldefel 38 52 54 51
12 Barcelona C Barcelona C 38 45 54 46
13 Palamós Palamós 38 33 46 46
14 Rubí Rubí 38 45 61 46
15 Vilanova Geltru CF Vilanova 38 45 39 45
16 UE Cornellà Cornellà 38 37 55 41
17 CE Manresa CE Manresa 38 43 68 36
18 UE Vilassar de Mar Vilassar 38 50 74 34
19 Banyoles Banyoles 38 32 63 29
20 Tàrrega Tàrrega 38 31 62 24

  USO DE MEMORIA  
8,067,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7278
Total Execution Time  0.7290
  CADENA URL  
/historico/Palamos-Cf
  GET DATOS  
$_GET['/historico/Palamos-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0185  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 = 'Palamos-Cf' 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.0129  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=1904 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=1904 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=1904 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1904 AND type_rel = 2
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1904 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0150  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 (43805,71202,93103,98637,154434) ORDER BY n.cover_points DESC, update_date DESC
0.0165  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 = '1904' ORDER BY l.year DESC,cat.coefficient DESC
0.0192  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 = '1904' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153  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=1904 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (72732,71432,68448) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 72732 AND teamId = 1904
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 68448 AND teamId = 1904
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1904
0.0141  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 = '1904' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1904' and rp.type = 4
0.0137  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 = '1904' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  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 = 72732 WHERE rp.league_id = 72732 AND rp.teamId = 1904 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.0153  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 = 72732 WHERE rp.league_id = 72732 AND rp.teamId = 1904 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 72732 WHERE rp.league_id = 72732 AND rp.teamId = 1904 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 1904 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 68448 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.0130  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 = 63408 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 58714 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.0129  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 `tables2020` 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 = 50597 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 44407 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 39029 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 33355 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 15446 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0214  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 = 3915 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 2555 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 1945 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 1458 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 1105 AND t.round = 38 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 `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 = 836 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 135 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 12 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 90 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 22117 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 22098 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC