4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Raris CF
TEMPORADA 2023/2024
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Camporrapado Camporrapado 21 44 34 41
2 Touro SD Touro SD 21 41 19 40
3 CD Lalín B CD Lalín B 21 59 38 40
4 Calo Sr B Calo Sr B 21 50 31 37
5 Recesende Recesende 21 58 44 37
6 Santiso UD Santiso UD 21 50 40 34
7 Raris CF Raris CF 21 35 45 27
8 Gallaecia CF Gallaecia 21 36 40 25
9 Sporting Santiago Sporting 21 42 43 22
10 San Pedro FC Pedro 21 36 52 21
11 EF Boqueixon Boqueixon 21 33 59 15
12 Vilatuxe F.C. Vilatuxe 21 29 68 12
TEMPORADA 2022/2023
TERCERA GALICIA GRUPO 6
Equipo PJ GF GC Puntos
1 Lamela Lamela 26 99 26 63
2 Bandeira Bandeira 26 89 29 60
3 Recesende Recesende 26 81 39 58
4 Rois Rois 26 57 21 58
5 Calo Sr B Calo Sr B 26 70 36 52
6 Sar Extramundi Extramundi 26 60 51 38
7 Vista Alegre C Vista Alegre 26 60 79 35
8 Raris CF Raris CF 26 41 55 33
9 Camporrapado Camporrapado 26 49 50 31
10 SD Cruces B SD Cruces B 26 32 52 30
11 Vilatuxe F.C. Vilatuxe 26 53 84 22
12 Val Do Ulla B Ulla 26 39 74 21
13 EF Boqueixon Boqueixon 26 23 95 11
14 Nicrariense B Nicrariense 26 20 82 9
15 Boqueixon SD Boqueixon 0 0 0 0
TEMPORADA 2021/2022
TERCERA GALICIA GRUPO 6
Equipo PJ GF GC Puntos
1 Sporting Estrada Sporting 21 72 7 57
2 SD O Pino B SD O Pino B 22 52 16 52
3 Santiso UD Santiso UD 22 53 28 45
4 Bandeira Bandeira 22 52 28 39
5 Vilatuxe F.C. Vilatuxe 22 45 44 31
6 EF Boqueixon Boqueixon 22 42 35 29
7 Camporrapado Camporrapado 22 24 25 28
8 Vista Alegre C Vista Alegre 22 41 64 24
9 Silleda B Silleda B 22 23 54 24
10 SR Calo B SR Calo B 21 32 48 22
11 Raris CF Raris CF 22 24 66 10
12 Guimarei Guimarei 20 20 65 9
TEMPORADA 2019/2020
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Rois Rois 19 51 9 47
2 Carcacía Carcacía 18 47 13 42
3 Val Do Ulla B Ulla 19 32 23 36
4 Milladoiro SD Milladoiro 19 48 35 32
5 Camporrapado Camporrapado 19 26 20 32
6 Viduido CF Viduido CF 18 31 25 26
7 Portomouro Portomouro 18 29 30 24
8 Brion SD Brion SD 18 29 34 23
9 Guimarei Guimarei 19 22 31 22
10 Resmon Resmon 19 34 39 21
11 AD Estudiantil Estudiantil 19 29 37 20
12 EF Boqueixon Boqueixon 19 37 52 18
13 Raris CF Raris CF 19 29 49 14
14 Calo Sr B Calo Sr B 19 22 69 12
TEMPORADA 2018/2019
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Vea CF Vea CF 24 86 31 61
2 Nicrariense Nicrariense 24 69 35 53
3 Val Do Ulla B Ulla 24 57 20 50
4 Rois Rois 24 53 23 49
5 Dubra B Dubra B 24 43 37 38
6 Viduido CF Viduido CF 24 49 41 37
7 Portomouro Portomouro 24 39 35 36
8 Resmon Resmon 24 35 50 33
9 San Mamed B San Mamed B 24 32 57 18
10 EF Boqueixon Boqueixon 23 29 67 18
11 Guimarei Guimarei 24 38 56 17
12 Trazo CF B Trazo CF B 24 27 64 15
13 Raris CF Raris CF 23 22 63 10
TEMPORADA 2017/2018
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Estradense B Estradense 27 83 27 68
2 Brion SD Brion SD 28 74 38 63
3 Vea CF Vea CF 28 51 26 58
4 Milladoiro SD Milladoiro 28 96 46 55
5 Viduido CF Viduido CF 28 76 45 50
6 Dubra B Dubra B 28 61 43 47
7 Escola D Val Do Ulla Ribadu Escola Ulla 28 50 47 44
8 Resmon Resmon 28 43 46 43
9 Portomouro Portomouro 28 49 60 37
10 San Mamed B San Mamed B 28 38 51 29
11 Guimarei Guimarei 28 36 54 29
12 Tordoia B Tordoia B 28 39 69 27
13 Calo Sr B Calo Sr B 28 36 73 19
14 Trazo CF B Trazo CF B 28 34 81 13
15 Raris CF Raris CF 27 26 86 10
TEMPORADA 2016/2017
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Cruces SD Cruces SD 22 68 20 57
2 Touro SD Touro SD 22 62 17 51
3 O Pino SD O Pino SD 22 58 29 43
4 Victoria CF Victoria CF 22 45 34 41
5 Guimarei Guimarei 22 40 35 39
6 Silleda B Silleda B 22 48 54 28
7 Santiso UD Santiso UD 22 51 54 26
8 Vea CF Vea CF 22 41 54 26
9 Raris CF Raris CF 22 48 66 24
10 Arzua B Arzua B 22 34 42 22
11 At. Lavacolla Lavacolla 22 19 53 15
12 Dozon SD Dozon SD 22 16 72 2
13 Atletico de Melide Atletico 0 0 0 0
TEMPORADA 2015/2016
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Luaña SD Luaña SD 22 63 29 51
2 Vea CF Vea CF 22 67 27 50
3 Calo SR Calo SR 22 59 34 40
4 Furia Furia 22 55 35 38
5 Agron CF Agron CF 22 48 35 37
6 Brion SD Brion SD 22 53 44 34
7 Viduido CF Viduido CF 22 56 43 30
8 Sporting Santiago Sporting 22 43 47 29
9 Raris CF Raris CF 22 38 43 26
10 Rois Rois 22 25 59 18
11 Campo da Angustia Campo 22 21 82 11
12 Racing San Lorenzo Racing 22 21 71 9
TEMPORADA 2014/2015
TERCERA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Bugallido CF Bugallido 22 44 20 48
2 Callobre CF Callobre CF 22 41 28 41
3 Vea CF Vea CF 22 44 29 39
4 Brion SD Brion SD 22 45 33 39
5 Ortoño CF Ortoño CF 22 48 39 36
6 Viduido CF Viduido CF 22 39 32 33
7 Luaña SD Luaña SD 22 36 29 31
8 Raris CF Raris CF 22 38 39 29
9 Agron CF Agron CF 22 32 45 22
10 Calo SR Calo SR 22 26 45 20
11 Berres CD Berres CD 22 21 46 15
12 Negreira B Negreira B 22 27 56 15

  USO DE MEMORIA  
5,464,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5585
Total Execution Time  0.5599
  CADENA URL  
/historico/Raris-Cf
  GET DATOS  
$_GET['/historico/Raris-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0170  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 = 'Raris-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.0146  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=27549 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=27549 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0297  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 = 73760
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27549 AND type_rel = 2
0.0153  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 = '27549' ORDER BY l.year DESC,cat.coefficient DESC
0.0160  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 = '27549' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0161  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 = '27549' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 73760 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=27549 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73760) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73760 AND teamId = 27549
0.0149  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 = 73760 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '27549' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '27549' and rp.type = 4
0.0147  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 = '27549' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 = 73760 WHERE rp.league_id = 73760 AND rp.teamId = 27549 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.0146  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 = 73760 WHERE rp.league_id = 73760 AND rp.teamId = 27549 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 73760 WHERE rp.league_id = 73760 AND rp.teamId = 27549 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 27549 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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 = 73760 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.0148  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 = 69306 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.0151  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 = 65421 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.0150  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 = 51556 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 45275 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 39857 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 34655 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 16875 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 5012 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC