4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD San José
TEMPORADA 2023/2024
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CF Briviesca Briviesca 27 59 19 56
2 CD Villamuriel Villamuriel 27 43 25 50
3 Turégano Turégano 27 50 36 46
4 Villarcayo Nela Villarcayo 27 35 23 44
5 CD San José José 27 48 34 44
6 Vista Alegre CD Vista Alegre 26 36 25 41
7 Calasanz de Soria Calasanz 27 41 31 39
8 Numancia B Numancia B 27 32 30 39
9 Racing Lermeño CF Racing 27 23 30 39
10 SC Uxama SC Uxama 27 33 40 38
11 Cebrereña Cebrereña 27 35 41 33
12 UP Palencia UP Palencia 27 23 28 30
13 Belorado Belorado 27 37 59 28
14 Unami CP Unami CP 26 32 42 25
15 Deportivo Arenas Deportivo 27 29 42 25
16 Carejas Paredes Carejas 27 16 67 11
TEMPORADA 2022/2023
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 DiocesÁvila - UCAV DiocesÁvila 32 70 19 74
2 Turégano Turégano 32 81 28 71
3 CF Briviesca Briviesca 32 88 26 67
4 Palencia Cristo Atlético B Palencia 32 72 25 64
5 CD San José José 32 65 35 61
6 Cebrereña Cebrereña 32 65 34 53
7 Vista Alegre CD Vista Alegre 32 57 39 52
8 Calasanz de Soria Calasanz 32 79 47 52
9 Racing Lermeño CF Racing 32 55 42 46
10 Villarcayo Nela Villarcayo 32 47 45 45
11 SC Uxama SC Uxama 32 43 40 41
12 UP Palencia UP Palencia 32 42 48 40
13 CD Villamuriel Villamuriel 32 45 68 32
14 CD Cuéllar Balompié Cuéllar 32 37 112 27
15 Abejar Abejar 32 25 92 15
16 CD La Granja Granja 32 23 73 13
17 Las Navas Las Navas 32 21 142 8
TEMPORADA 2021/2022
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Becerril Becerril 30 59 12 75
2 Unami CP Unami CP 30 68 24 74
3 Turégano Turégano 30 53 28 59
4 Palencia Cristo Atlético B Palencia 30 72 42 56
5 CD San José José 30 55 44 54
6 CD Villamuriel Villamuriel 30 67 49 49
7 CD La Granja Granja 30 59 45 48
8 CF Briviesca Briviesca 30 45 36 46
9 Villarcayo Nela Villarcayo 30 37 39 42
10 Calasanz de Soria Calasanz 30 50 54 37
11 SC Uxama SC Uxama 30 46 53 37
12 Polideportivo Salas Polideportiv 30 35 55 29
13 Racing Lermeño CF Racing 30 37 58 29
14 Monteresma Atalaya Monteresma 30 35 87 23
15 CD Burgalés Burgalés 30 21 50 22
16 Tardelcuende Tardelcuende 30 10 73 5
17 Real Burgos CF Real Burgos 0 0 0 0
TEMPORADA 2020/2021
PREFERENTE C. LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Unami CP Unami CP 20 40 12 49
2 CD San José José 20 34 20 38
3 SC Uxama SC Uxama 20 30 16 35
4 Turégano Turégano 20 23 16 31
5 Calasanz de Soria Calasanz 20 37 33 28
6 Tardelcuende Tardelcuende 20 28 27 23
7 A. Candeleda Candeleda 20 24 37 23
8 Monteresma Atalaya Monteresma 20 28 33 22
9 Bosco de Arévalo Bosco 20 18 34 22
10 Abejar Abejar 20 12 30 13
11 San Esteban San Esteban 20 19 35 11
TEMPORADA 2019/2020
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 DiocesÁvila - UCAV DiocesÁvila 24 55 15 58
2 Cebrereña Cebrereña 24 50 20 53
3 SC Uxama SC Uxama 24 39 19 50
4 CF Briviesca Briviesca 24 41 20 47
5 Unami CP Unami CP 24 42 34 45
6 Castilla Palencia Castilla 24 47 23 42
7 CD San José José 24 28 20 40
8 Palencia CF Palencia CF 24 41 35 36
9 Turégano Turégano 24 39 32 32
10 Villarcayo Nela Villarcayo 24 27 23 32
11 Racing Lermeño CF Racing 24 34 41 29
12 CD Villamuriel Villamuriel 24 27 31 27
13 San Esteban San Esteban 24 29 46 26
14 Tardelcuende Tardelcuende 24 36 42 20
15 Carejas Paredes Carejas 24 28 42 20
16 Calasanz de Soria Calasanz 24 28 42 20
17 Vista Alegre CD Vista Alegre 24 29 61 17
18 A. Candeleda Candeleda 24 10 84 6
TEMPORADA 2018/2019
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Becerril Becerril 32 65 14 73
2 Mirandés B Mirandés B 32 71 26 72
3 DiocesÁvila - UCAV DiocesÁvila 32 97 25 70
4 Unami CP Unami CP 32 72 34 60
5 Villarcayo Nela Villarcayo 32 44 38 60
6 Castilla Palencia Castilla 31 77 47 55
7 CD Villamuriel Villamuriel 32 45 38 53
8 CD San José José 32 39 25 49
9 Racing Lermeño CF Racing 32 44 42 41
10 Tardelcuende Tardelcuende 32 54 58 41
11 Calasanz de Soria Calasanz 31 45 71 34
12 Palencia CF Palencia CF 32 39 50 33
13 CD Cuéllar Balompié Cuéllar 32 49 70 33
14 Venta De Baños Venta Baños 32 37 68 28
15 El Espinar-San Rafael Espinar-San 32 37 88 26
16 Arandina CF B Arandina 32 32 63 25
17 Bosco Arévalo Bosco 32 20 110 12
18 CD Palencia Balompié Palencia 0 0 0 0
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Unionistas CF Unionistas 38 72 34 80
2 Arandina Arandina 38 79 26 77
3 Palencia Cristo Atlético Palencia 38 69 38 74
4 Salamanca UDS Salamanca 38 74 35 74
5 Atl. Astorga Atl. Astorga 38 66 34 73
6 Atlético Tordesillas Atlético 38 66 40 72
7 La Bañeza La Bañeza 38 53 52 68
8 Numancia B Numancia B 38 55 30 66
9 Zamora Zamora 38 51 41 58
10 Real Ávila Real Ávila 38 50 49 52
11 La Virgen del Camino Virgen 38 41 54 42
12 Cebrereña Cebrereña 38 55 66 42
13 Atl. Bembibre Atl. 38 40 61 38
14 SD Almazán SD Almazán 38 38 51 38
15 CD Burgalés Burgalés 38 44 56 37
16 Burgos CF B Burgos CF B 38 38 61 35
17 SC Uxama SC Uxama 38 39 61 33
18 Real Burgos CF Real Burgos 38 31 82 32
19 Becerril Becerril 38 42 73 32
20 CD San José José 38 26 85 18
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Gimnástica Segoviana Gimnástica 38 97 22 91
2 Atl. Astorga Atl. Astorga 38 83 37 80
3 Unionistas CF Unionistas 38 77 29 78
4 Palencia Cristo Atlético Palencia 38 73 35 76
5 SD Almazán SD Almazán 38 69 47 68
6 Zamora Zamora 38 51 42 60
7 Real Ávila Real Ávila 38 65 55 54
8 Numancia B Numancia B 38 55 55 53
9 La Virgen del Camino Virgen 38 56 56 50
10 Atl. Bembibre Atl. 38 42 51 48
11 CD Burgalés Burgalés 38 53 53 48
12 La Bañeza La Bañeza 38 49 52 47
13 CD San José José 38 39 68 45
14 Atlético Tordesillas Atlético 38 53 70 44
15 Burgos CF B Burgos CF B 38 39 55 43
16 Cebrereña Cebrereña 38 38 55 41
17 SC Uxama SC Uxama 38 37 45 41
18 CD Villamuriel Villamuriel 38 35 49 37
19 Mirandés B Mirandés B 38 26 49 37
20 CD Villaralbo Villaralbo 38 27 139 13
TEMPORADA 2015/2016
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Ávila Real Ávila 33 80 14 81
2 CD San José José 33 69 16 76
3 Unami CP Unami CP 33 72 19 70
4 CD La Granja Granja 33 61 25 67
5 Polideportivo Salas Polideportiv 33 56 37 65
6 CF Briviesca Briviesca 33 64 36 56
7 Real Burgos CF Real Burgos 33 41 42 50
8 Venta De Baños Venta Baños 33 38 45 48
9 Villarcayo Nela Villarcayo 33 42 47 44
10 Burgos CF B Burgos CF B 33 43 52 37
11 Racing Lermeño CF Racing 33 41 51 37
12 Palencia CF Palencia CF 33 44 48 34
13 Bosco Arévalo Bosco 33 27 62 32
14 San Esteban San Esteban 33 41 79 27
15 Arandina CF B Arandina 33 39 71 26
16 CD Sotillo CD Sotillo 33 47 81 26
17 El Espinar-San Rafael Espinar-San 33 43 75 25
18 Mombeltran Mombeltran 17 10 58 0
TEMPORADA 2014/2015
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 SC Uxama SC Uxama 31 64 24 68
2 CD Villamuriel Villamuriel 31 63 24 67
3 Unami CP Unami CP 31 70 29 66
4 CD San José José 31 55 29 58
5 Polideportivo Salas Polideportiv 31 56 36 58
6 Venta De Baños Venta Baños 31 39 35 48
7 CF Briviesca Briviesca 31 50 36 46
8 Burgos CF B Burgos CF B 31 41 39 40
9 Arandina CF B Arandina 31 37 45 40
10 Real Burgos CF Real Burgos 31 52 59 38
11 Racing Lermeño CF Racing 31 38 47 38
12 CD Sotillo CD Sotillo 31 38 57 35
13 CD Juventud CD Juventud 31 39 53 30
14 Bosco Arévalo Bosco 31 27 44 30
15 CD Raudense CD Raudense 31 40 58 30
16 CD Univ. Burgos Univ. Burgos 31 20 76 14
17 CD Cuéllar Balompié Cuéllar 16 8 46 0

  USO DE MEMORIA  
6,235,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1280
Total Execution Time  0.1299
  CADENA URL  
/historico/San-Jose-Soria
  GET DATOS  
$_GET['/historico/San-Jose-Soria']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19015 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 19015 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  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 (93130,427710) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '19015' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 73528 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=19015 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 (73528,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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73528 AND teamId = 19015
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19015
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 FROM `tables2024` 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 = 73528 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '19015' 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 = '19015' 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 = '19015' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 19015 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.0027  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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 19015 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 19015 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 19015 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 = 68798 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.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 `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 = 63673 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.0091  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 = 59995 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.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 `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 = 51275 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 44674 AND t.round = 34 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 `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 = 39032 AND t.round = 38 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 `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 = 33358 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 `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 = 16749 AND t.round = 34 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 `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 = 4090 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC