4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Palencia Cristo Atlético B
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 1
Equipo PJ GF GC Puntos
1 Palencia CF Palencia CF 18 51 17 40
2 Castilla Palencia Castilla 18 46 19 40
3 CF Briviesca Briviesca 18 30 13 36
4 CD Villamuriel Villamuriel 18 26 20 29
5 Palencia Cristo Atlético B Palencia 18 36 29 27
6 Villarcayo Nela Villarcayo 18 11 21 18
7 Polideportivo Salas Polideportiv 18 14 37 16
8 Racing Lermeño CF Racing 18 18 23 16
9 Carejas Paredes Carejas 18 12 38 12
10 Vista Alegre CD Vista Alegre 18 7 34 12
TEMPORADA 2019/2020
1ª CASTILLA Y LEÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Palencia Cristo Atlético B Palencia 26 64 17 62
2 Monzon Monzon 26 70 25 58
3 Villada Villada 26 54 34 50
4 Guardense Guardense 25 59 33 46
5 Baltanás Baltanás 26 45 26 46
6 CD Cervera CD Cervera 24 68 31 44
7 Villalobon Villalobon 26 51 35 44
8 Atlético Aguilar Atlético 25 42 36 43
9 Venta De Baños Venta Baños 25 58 31 41
10 San Telmo San Telmo 26 68 48 41
11 Fromista Fromista 26 60 47 40
12 Saldaña Saldaña 25 34 30 40
13 San Antonio Hyuconsa Antonio 25 54 72 33
14 Alar Alar 26 35 53 30
15 Jovenes Promesas Jovenes 25 34 40 25
16 Astudillo Astudillo 26 40 55 24
17 Cd Velilla Cd Velilla 26 41 77 21
18 Castilla de Dueñas Castilla 26 37 64 20
19 UP Palencia UP Palencia 26 27 64 16
20 CD Grijota CD Grijota 26 19 142 0
TEMPORADA 2017/2018
1ª CASTILLA Y LEÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Monzon Monzon 26 60 32 55
2 CD Cervera CD Cervera 26 57 18 51
3 Venta De Baños Venta Baños 26 59 26 50
4 Saldaña Saldaña 26 42 24 49
5 Atlético Aguilar Atlético 26 43 33 45
6 Castilla Dueñas Castilla 26 57 53 45
7 San Telmo San Telmo 26 45 36 44
8 Villada Villada 26 47 47 39
9 Astudillo Astudillo 26 55 38 38
10 Fromista Fromista 26 44 62 23
11 Villalobon Villalobon 26 36 68 22
12 Cd Velilla Cd Velilla 26 39 73 19
13 Palencia Cristo Atlético B Palencia 26 35 71 17
14 Alar Alar 26 41 79 16

  USO DE MEMORIA  
5,365,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3877
Total Execution Time  0.3896
  CADENA URL  
/historico/Cd-Palencia-Balompie-B-Senior
  GET DATOS  
$_GET['/historico/Cd-Palencia-Balompie-B-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103004 AND type_rel = 2
0.0127  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 = '103004' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = '103004' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 68798 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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=103004 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (68798) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 68798 AND teamId = 103004
0.0254  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '103004' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '103004' and rp.type = 4
0.0133  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 = '103004' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0177  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 events2023 e ON e.player_id = p.id AND e.league_id = 68798 WHERE rp.league_id = 68798 AND rp.teamId = 103004 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.0174  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 events2023 e ON e.player_id = p.id AND e.league_id = 68798 WHERE rp.league_id = 68798 AND rp.teamId = 103004 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0181  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 events2023 e ON e.player_id = p.id AND e.league_id = 68798 WHERE rp.league_id = 68798 AND rp.teamId = 103004 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 103004 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0146  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.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 `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.0155  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 = 59994 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.0145  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 = 51312 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.0133  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 = 39779 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC