4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Fernando CD

San Fernando CD

Entrenador: Alfredo Santaelena

Temporada 2023/2024
TEMPORADA 2023/2024
PRIMERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Castellón Castellón 33 68 32 75
2 Córdoba CF Córdoba CF 33 60 28 67
3 UD Ibiza UD Ibiza 33 52 28 63
4 Málaga Málaga 33 44 21 62
5 AD Ceuta FC AD Ceuta FC 33 46 33 56
6 Recreativo Recreativo 33 35 30 52
7 Real Murcia Real Murcia 33 31 31 51
8 Antequera CF Antequera 33 41 39 50
9 Atlético B Atlético B 33 47 39 45
10 Alcoyano Alcoyano 33 34 34 45
11 RM Castilla RM Castilla 34 41 41 44
12 CF Intercity Intercity 33 34 40 42
13 Algeciras CF Algeciras 33 36 35 42
14 At. Sanluqueño Sanluqueño 33 32 37 38
15 AD Mérida AD Mérida 33 29 41 38
16 San Fernando CD Fernando 34 32 45 35
17 Linares Deportivo Linares 33 26 45 32
18 UD Melilla UD Melilla 33 23 48 27
19 Atlético Baleares Atlético 33 17 52 23
20 Recreativo Granada Recreativo 33 23 52 18
TEMPORADA 2022/2023
PRIMERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Ferrol Racing 38 55 25 75
2 Alcorcón Alcorcón 38 53 23 74
3 RM Castilla RM Castilla 38 58 38 69
4 RC Deportivo Deportivo 38 53 29 67
5 Celta Fortuna Celta 38 48 38 59
6 Linares Deportivo Linares 38 53 53 59
7 Unionistas CF Unionistas 38 38 40 56
8 AD Mérida AD Mérida 38 40 37 54
9 Córdoba CF Córdoba CF 38 48 37 54
10 Cultural Leonesa Cultural 38 41 43 48
11 Fuenlabrada Fuenlabrada 38 32 51 46
12 AD Ceuta FC AD Ceuta FC 38 53 52 45
13 San Fernando CD Fernando 38 46 50 45
14 Rayo Majadahonda Rayo 38 42 51 45
15 Algeciras CF Algeciras 38 36 47 44
16 CD Badajoz CD Badajoz 38 35 52 43
17 UD Sanse UD Sanse 38 30 46 43
18 RB Linense RB Linense 38 31 34 42
19 Pontevedra Pontevedra 38 34 53 36
20 CF Talavera CF Talavera 38 36 63 33
TEMPORADA 2021/2022
PRIMERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 FC Andorra FC Andorra 38 61 38 71
2 Villarreal B Villarreal 38 65 36 67
3 Albacete Albacete 38 52 34 67
4 Gimnàstic Tarragona Gimnàstic 38 41 30 61
5 Linares Deportivo Linares 38 59 47 60
6 Atlético Baleares Atlético 38 52 35 59
7 Algeciras CF Algeciras 38 50 39 59
8 CE Sabadell CE Sabadell 38 44 33 58
9 Barça Atlètic Barça 38 59 51 57
10 RM Castilla RM Castilla 38 66 47 56
11 Alcoyano Alcoyano 38 41 40 52
12 RB Linense RB Linense 38 35 44 50
13 CD Castellón Castellón 38 37 50 50
14 UE Cornellà Cornellà 38 39 48 48
15 San Fernando CD Fernando 38 49 58 48
16 At. Sanluqueño Sanluqueño 38 39 56 46
17 Sevilla At. Sevilla At. 38 36 55 46
18 UCAM Murcia UCAM Murcia 38 42 56 35
19 CF Badalona Futur Badalona 38 26 51 33
20 Betis Deportivo Betis 38 23 68 21
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 4
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 28 33 19 54
2 Marbella FC Marbella FC 28 39 20 53
3 CD Badajoz CD Badajoz 28 37 22 49
4 Yeclano Deportivo Yeclano 28 42 33 47
5 Córdoba CF Córdoba CF 28 33 27 45
6 San Fernando CD Fernando 28 39 25 44
7 RB Linense RB Linense 28 27 26 41
8 Real Murcia Real Murcia 28 33 26 39
9 Sevilla At. Sevilla At. 28 31 33 36
10 UCAM Murcia UCAM Murcia 28 29 33 36
11 Cádiz CF Mirandilla Cádiz 28 23 27 36
12 Villarrubia CF Villarrubia 28 34 33 35
13 Recreativo Recreativo 28 30 31 33
14 CD Don Benito Benito 28 32 35 32
15 At. Sanluqueño Sanluqueño 28 20 28 30
16 Algeciras CF Algeciras 28 31 40 29
17 CF Talavera CF Talavera 28 23 33 29
18 Recreativo Granada Recreativo 28 21 35 29
19 AD Mérida AD Mérida 28 28 37 27
20 CP Villarrobledo Villarrobled 28 23 45 22
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 38 50 23 78
2 FC Cartagena Cartagena 38 62 27 75
3 UD Melilla UD Melilla 38 55 32 72
4 CD Badajoz CD Badajoz 38 44 31 66
5 UCAM Murcia UCAM Murcia 38 54 40 66
6 UD Ibiza UD Ibiza 38 41 31 63
7 Marbella FC Marbella FC 38 42 33 60
8 San Fernando CD Fernando 38 44 36 60
9 CF Talavera CF Talavera 38 34 34 50
10 Sevilla At. Sevilla At. 38 37 46 48
11 Real Murcia Real Murcia 38 32 32 48
12 RB Linense RB Linense 38 33 33 46
13 At. Sanluqueño Sanluqueño 38 32 48 46
14 Recreativo Granada Recreativo 38 37 42 45
15 CD Don Benito Benito 38 38 49 44
16 Jumilla Jumilla 38 31 42 43
17 Pvo. El Ejido Pvo. Ejido 38 29 47 39
18 Villanovense Villanovense 38 32 40 38
19 At. Malagueño Malagueño 38 27 54 29
20 Almería B Almería B 38 27 61 23
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
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Lorca FC Lorca FC 38 52 39 73
2 Real Murcia Real Murcia 38 48 29 67
3 Villanovense Villanovense 38 55 32 66
4 FC Cartagena Cartagena 38 49 35 65
5 AD Mérida AD Mérida 38 51 33 64
6 UD Melilla UD Melilla 38 39 25 60
7 Marbella FC Marbella FC 38 46 45 58
8 Recreativo Granada Recreativo 38 60 48 53
9 RB Linense RB Linense 38 41 48 52
10 Jumilla Jumilla 38 32 37 48
11 Córdoba CF B Córdoba 38 43 42 48
12 Recreativo Recreativo 38 35 41 47
13 Extremadura Extremadura 38 37 48 46
14 Pvo. El Ejido Pvo. Ejido 38 40 47 46
15 San Fernando CD Fernando 38 42 52 46
16 Linares Deportivo Linares 38 40 46 45
17 At. Sanluqueño Sanluqueño 38 36 51 39
18 Mancha Real Mancha Real 38 44 64 38
19 Real Jaén Real Jaén 38 37 43 37
20 La Roda CF La Roda CF 38 36 58 28
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Córdoba CF B Córdoba 40 90 42 85
2 At. Sanluqueño Sanluqueño 40 71 34 79
3 San Fernando CD Fernando 40 69 30 75
4 CD Alcalá CD Alcalá 40 59 33 73
5 CD Gerena CD Gerena 40 65 46 61
6 AD Ceuta FC AD Ceuta FC 40 47 43 58
7 Arcos CF Arcos CF 40 44 43 58
8 Sevilla C Sevilla C 40 43 44 55
9 Castilleja Castilleja 40 49 54 55
10 Los Barrios Los Barrios 40 54 56 55
11 CD Guadalcacín Guadalcacín 40 42 50 54
12 Écija Balompié Écija 40 58 54 52
13 Utrera Utrera 40 70 76 52
14 CD San Roque Roque 40 46 52 50
15 Lebrijana Lebrijana 40 45 59 49
16 Cabecense Cabecense 40 49 57 49
17 Coria CF Coria CF 40 38 39 48
18 San Juan San Juan 40 42 53 48
19 Conil Conil 40 41 65 39
20 Roteña Roteña 40 43 73 36
21 Lucena Lucena 40 19 81 13
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 42 77 28 100
2 San Fernando CD Fernando 42 88 28 91
3 CD Gerena CD Gerena 42 89 38 87
4 At. Sanluqueño Sanluqueño 42 74 40 83
5 AD Ceuta FC AD Ceuta FC 42 50 32 72
6 Lebrijana Lebrijana 42 60 66 60
7 Conil Conil 42 51 60 60
8 Écija Balompié Écija 42 49 41 58
9 Sevilla C Sevilla C 42 42 45 58
10 Coria CF Coria CF 42 48 42 57
11 CD Alcalá CD Alcalá 42 40 52 57
12 CD San Roque Roque 42 47 49 56
13 San Juan San Juan 42 48 49 52
14 Los Barrios Los Barrios 42 45 50 52
15 CD Guadalcacín Guadalcacín 42 39 48 52
16 Cabecense Cabecense 42 36 54 49
17 Arcos CF Arcos CF 42 46 74 48
18 Mairena Mairena 42 42 55 44
19 PD Rociera PD Rociera 42 40 73 40
20 Cádiz CF Mirandilla Cádiz 42 45 54 38
21 La Palma CF La Palma CF 42 35 69 36
22 Atlético Onubense Atlético 42 34 78 33
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Albacete Albacete 38 62 30 82
2 Lorca FC Lorca FC 38 62 22 79
3 FC Cartagena Cartagena 38 59 35 73
4 Cádiz Cádiz 38 75 38 71
5 CD Guadalajara Guadalajara 38 57 33 69
6 Recreativo Granada Recreativo 38 65 47 58
7 RB Linense RB Linense 38 51 42 56
8 UD Melilla UD Melilla 38 47 45 55
9 Lucena Lucena 38 42 45 55
10 CP Cacereño Cacereño 38 43 49 53
11 Córdoba CF B Córdoba 38 42 50 45
12 El Palo FC El Palo FC 38 35 47 45
13 Almería B Almería B 38 42 49 43
14 Sevilla At. Sevilla At. 38 33 44 43
15 Arroyo Arroyo 38 38 47 43
16 Algeciras CF Algeciras 38 39 45 43
17 La Roda CF La Roda CF 38 39 46 40
18 San Fernando CD Fernando 38 36 60 39
19 At. Sanluqueño Sanluqueño 38 34 68 34
20 Écija Balompié Écija 38 28 87 23
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 38 44 24 70
2 FC Cartagena Cartagena 38 52 33 68
3 Albacete Albacete 38 45 32 61
4 Lucena Lucena 38 47 38 59
5 Almería B Almería B 38 52 46 59
6 RB Linense RB Linense 38 48 45 58
7 San Fernando CD Fernando 38 45 39 56
8 Écija Balompié Écija 38 47 38 53
9 UD Melilla UD Melilla 38 38 37 53
10 La Roda CF La Roda CF 38 39 36 52
11 At. Sanluqueño Sanluqueño 38 49 46 50
12 CP Cacereño Cacereño 38 40 36 48
13 Cádiz Cádiz 38 40 38 48
14 Sevilla At. Sevilla At. 38 42 53 46
15 Arroyo Arroyo 38 32 40 45
16 Villanovense Villanovense 38 32 46 43
17 UCAM Murcia UCAM Murcia 38 35 41 41
18 San Roque de Lepe Roque Lepe 38 47 58 38
19 Loja Loja 38 30 54 38
20 Betis Deportivo Betis 38 38 62 30
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 At. Sanluqueño Sanluqueño 38 81 32 89
2 San Fernando CD Fernando 38 88 51 74
3 Mairena Mairena 38 64 32 71
4 Coria CF Coria CF 38 72 46 68
5 Sevilla C Sevilla C 38 67 46 66
6 Algeciras CF Algeciras 38 57 50 59
7 CD Alcalá CD Alcalá 38 57 52 57
8 Atlético Onubense Atlético 38 59 55 54
9 Cádiz CF Mirandilla Cádiz 38 53 53 50
10 Córdoba CF B Córdoba 38 35 37 45
11 Conil Conil 38 47 68 45
12 CD Pozoblanco Pozoblanco 38 47 49 45
13 Atlético Antoniano Atlético 38 31 45 43
14 CD San Roque Roque 38 53 67 42
15 Puerto Real CF Puerto Real 38 45 63 40
16 RC Portuense Portuense 38 41 53 39
17 Ayamonte Ayamonte 38 46 72 38
18 Jerez Industrial CF Jerez 38 34 51 38
19 UD Marinaleda Marinaleda 38 39 59 38
20 PD Rociera PD Rociera 38 40 75 35
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 RB Linense RB Linense 38 65 32 76
2 San Fernando CD Fernando 38 61 33 72
3 CD Pozoblanco Pozoblanco 38 56 33 71
4 Mairena Mairena 38 41 29 63
5 Algeciras CF Algeciras 38 44 33 62
6 RC Portuense Portuense 38 44 38 61
7 Puerto Real CF Puerto Real 38 42 32 59
8 At. Sanluqueño Sanluqueño 38 47 42 56
9 Sevilla C Sevilla C 38 42 40 51
10 Córdoba CF B Córdoba 38 41 38 49
11 UD Los Palacios Palacios 38 40 44 49
12 Coria CF Coria CF 38 57 60 46
13 Jerez Industrial CF Jerez 38 36 58 45
14 Atlético Onubense Atlético 38 40 47 44
15 Conil Conil 38 44 47 43
16 Cádiz CF Mirandilla Cádiz 38 52 50 43
17 UD Marinaleda Marinaleda 38 36 53 42
18 Ayamonte Ayamonte 38 53 62 42
19 Peñarroya Pueblonuevo Peñarroya 38 35 60 34
20 Los Barrios Los Barrios 38 23 68 20
TEMPORADA 2009/2010
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Conil Conil 34 55 38 70
2 San Fernando CD Fernando 34 74 33 66
3 Arcos CF Arcos CF 34 57 20 65
4 Xerez B Xerez B 34 68 34 63
5 Ol. Valverdeña Valverdeña 34 61 39 56
6 Pastores Pastores 34 51 37 55
7 Chiclana CF Chiclana CF 34 63 46 53
8 Balón de Cádiz CF Balón 34 55 47 52
9 La Palma La Palma 34 55 45 47
10 Isla Cristina Isla 34 52 51 47
11 CD Rota CD Rota 34 42 47 44
12 Roteña Roteña 34 50 57 42
13 CD San Roque Sub 19 Roque 34 40 78 38
14 Atlético Zabal Atlético 34 44 67 36
15 Gibraleón Gibraleón 34 31 58 36
16 Atl. Cortegana Atl. 34 47 57 35
17 Punta Umbria Punta Umbria 34 29 60 25
18 Almonte Almonte 34 33 93 17
TEMPORADA 2008/2009
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 34 64 30 69
2 Conil Conil 34 64 39 69
3 Arcos CF Arcos CF 34 70 32 67
4 CD Rota CD Rota 34 55 48 54
5 Punta Umbria Punta Umbria 34 40 42 53
6 Roteña Roteña 34 59 48 50
7 La Palma La Palma 34 49 44 49
8 Xerez B Xerez B 34 47 45 47
9 Atl. Cortegana Atl. 34 46 48 42
10 San Roque de Lepe B Roque Lepe 34 31 42 41
11 Balón de Cádiz CF Balón 34 36 41 40
12 Isla Cristina Isla 34 34 41 39
13 Ol. Valverdeña Valverdeña 34 37 55 39
14 San Fernando CD Fernando 34 41 49 38
15 Atlético Tharsis Atlético 34 36 50 38
16 Ud Bornense Ud Bornense 34 45 60 32
17 Tesorillo Tesorillo 34 39 56 31
18 Chiclana Industrial Chiclana 34 24 47 31
TEMPORADA 2007/2008
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Onubense Atlético 34 75 19 75
2 Chiclana CF Chiclana CF 34 57 28 68
3 Tesorillo Tesorillo 34 67 38 66
4 Conil Conil 34 65 43 66
5 Punta Umbria Punta Umbria 34 52 32 64
6 La Palma La Palma 34 45 38 56
7 Ol. Valverdeña Valverdeña 34 37 31 53
8 CD Rota CD Rota 34 39 44 43
9 At. Cortegana Cortegana 34 40 48 43
10 Atlético Tharsis Atlético 34 40 48 42
11 San Fernando CD Fernando 34 63 54 40
12 Los Cortijillos Cortijillos 34 37 55 38
13 Roteña Roteña 34 43 61 37
14 Chiclana Industrial Chiclana 34 45 66 37
15 Atlético Cruceño Atlético 34 36 51 36
16 Barbate Barbate 34 36 65 31
17 Pastores Pastores 34 40 73 28
18 Chipiona CF Chipiona CF 34 31 54 26

  USO DE MEMORIA  
7,824,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1307
Total Execution Time  0.1320
  CADENA URL  
/historico/San-Fernando-Huelva
  GET DATOS  
$_GET['/historico/San-Fernando-Huelva']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2221 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2221 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (38323,70823,75296,79873,84522) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '2221' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=2221 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 (72359,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72359 AND teamId = 2221
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2221
0.0025  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 = '2221' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2221' and rp.type = 4
0.0021  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 = '2221' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0056  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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 2221 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.0035  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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 2221 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 2221 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 2221 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040  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 = 67959 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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.0024  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 = 50268 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 44098 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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.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 `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 = 33381 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 `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 = 15451 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 = 3919 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 2467 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 1905 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 1406 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 1136 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 856 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 114 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC