4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Comillas CF

Comillas CF

Entrenador: Alberto Azofra

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 UD Logroñés B Logroñés 30 58 17 66
2 CD Alfaro CD Alfaro 30 64 33 66
3 Anguiano Anguiano 30 58 34 58
4 CD Calahorra B Calahorra 30 53 31 55
5 CD Varea CD Varea 30 54 27 54
6 Oyonesa Oyonesa 30 39 26 48
7 Casalarreina Casalarreina 30 46 40 46
8 La Calzada La Calzada 30 46 28 45
9 CD Berceo CD Berceo 30 35 38 40
10 Arnedo Arnedo 30 33 39 39
11 Racing Rioja Racing Rioja 30 34 41 39
12 Peña Balsamaiso CF Peña 30 39 51 36
13 River Ebro River Ebro 30 37 43 35
14 Vianés Vianés 30 29 56 32
15 CD Tedeón CD Tedeón 30 20 50 27
16 Haro Deportivo Haro 30 31 44 25
17 Comillas CF Comillas CF 30 27 51 18
18 Alberite Alberite 30 34 88 16
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 Náxara Náxara 30 64 26 70
2 CD Varea CD Varea 30 59 35 62
3 Agoncillo Agoncillo 30 42 23 61
4 La Calzada La Calzada 30 49 29 57
5 Oyonesa Oyonesa 30 50 27 56
6 Anguiano Anguiano 30 49 27 52
7 Peña Balsamaiso CF Peña 30 27 30 39
8 Vianés Vianés 30 29 40 38
9 Haro Deportivo Haro 30 38 37 37
10 CD Calahorra B Calahorra 30 35 40 37
11 Casalarreina Casalarreina 30 45 54 36
12 CD Berceo CD Berceo 30 40 51 34
13 River Ebro River Ebro 30 33 47 34
14 Comillas CF Comillas CF 30 25 49 24
15 Yagüe Yagüe 30 32 64 19
16 Racing Rioja B Racing Rioja 30 25 63 14
TEMPORADA 2021/2022
PREFERENTE LA RIOJA GRUPO 3
Equipo PJ GF GC Puntos
1 Peña Balsamaiso CF Peña 24 59 22 55
2 Alberite Alberite 26 64 35 51
3 Pradejón Pradejón 24 54 29 49
4 Comillas CF Comillas CF 26 61 31 49
5 Autol Autol 26 44 32 47
6 Aldeano Aldeano 24 42 46 39
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 CD Alfaro CD Alfaro 20 35 14 45
2 Anguiano Anguiano 20 32 11 44
3 CD Varea CD Varea 20 48 12 41
4 Arnedo Arnedo 20 30 17 36
5 La Calzada La Calzada 20 30 26 27
6 Oyonesa Oyonesa 20 24 22 25
7 CD Berceo CD Berceo 20 26 36 24
8 Vianés Vianés 20 18 22 23
9 Agoncillo Agoncillo 20 29 36 22
10 Comillas CF Comillas CF 20 19 34 20
11 Villegas Villegas 20 7 68 2
12 Racing Rioja Racing Rioja 20 46 14 45
13 UD Logroñés B Logroñés 20 31 18 39
14 Náxara Náxara 20 43 22 39
15 CD Calahorra B Calahorra 20 30 14 35
16 Yagüe Yagüe 20 30 22 31
17 Casalarreina Casalarreina 20 27 26 27
18 River Ebro River Ebro 20 19 26 24
19 CD Tedeón CD Tedeón 20 16 30 22
20 Pradejón Pradejón 20 21 35 16
21 Calasancio Calasancio 20 12 43 13
22 Alberite Alberite 20 14 39 11
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 SD Logroñés Logroñés 28 68 12 70
2 CD Varea CD Varea 28 83 22 70
3 Casalarreina Casalarreina 28 59 26 61
4 Arnedo Arnedo 28 55 30 60
5 UD Logroñés B Logroñés 28 69 23 56
6 Anguiano Anguiano 28 64 35 55
7 Náxara Náxara 28 71 37 52
8 Oyonesa Oyonesa 28 51 36 46
9 CD Calahorra B Calahorra 28 49 38 46
10 CD Alfaro CD Alfaro 28 54 41 40
11 River Ebro River Ebro 28 42 47 33
12 CD Berceo CD Berceo 28 50 61 33
13 Pradejón Pradejón 28 36 53 27
14 Vianés Vianés 28 30 47 27
15 Alberite Alberite 28 32 59 26
16 Comillas CF Comillas CF 28 32 61 24
17 Calasancio Calasancio 28 20 65 22
18 La Calzada La Calzada 28 25 56 19
19 Yagüe Yagüe 28 20 73 16
20 Villegas Villegas 28 13 101 7
TEMPORADA 2018/2019
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 CD Calahorra B Calahorra 24 56 17 54
2 Comillas CF Comillas CF 24 47 26 51
3 Casalarreina Casalarreina 24 49 19 50
4 Villegas Villegas 24 40 23 48
5 CD Tedeón CD Tedeón 24 47 25 44
6 Cenicero Cenicero 24 37 23 40
7 Racing Rioja Racing Rioja 24 47 37 35
8 San Marcial San Marcial 24 29 46 27
9 Bañuelos Bañuelos 24 36 46 24
10 Haro Sport Club Haro Sport. 24 44 62 22
11 Aldeano Aldeano 24 30 57 21
12 Alfaro B Alfaro B 24 27 55 21
13 CD San Lorenzo Lorenzo 24 20 73 8

  USO DE MEMORIA  
5,519,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.0868
Total Execution Time  0.0884
  CADENA URL  
/historico/Cd-Comillas-Senior
  GET DATOS  
$_GET['/historico/Cd-Comillas-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0030  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 = 'Cd-Comillas-Senior' 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.0018  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=112848 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=112848 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 72276
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112848 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 112848 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 (744436,746217,746264,746757,757254) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '112848' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '112848' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=112848 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 (72276) 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 = 72276 AND teamId = 112848
0.0044  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 = 72276 WHERE rp.league_id = 72276 AND rp.teamId = 112848 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.0040  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 = 72276 WHERE rp.league_id = 72276 AND rp.teamId = 112848 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 72276 WHERE rp.league_id = 72276 AND rp.teamId = 112848 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 112848 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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 `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 = 72276 AND t.round = 31 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 `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 = 64034 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.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 `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 = 66947 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 58595 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.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 `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 = 50284 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.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 `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 = 45240 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC