4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rois
TEMPORADA 2023/2024
SEGUNDA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Bastavales Bastavales 28 67 27 71
2 Taragoña Taragoña 28 83 45 65
3 Agron CF Agron CF 28 74 38 55
4 Luaña SD Luaña SD 29 51 37 51
5 Urdilde Urdilde 28 60 42 50
6 Esclavitud Esclavitud 28 51 45 40
7 Xuventú Aguiño Xuventú 28 50 54 40
8 Rois Rois 28 48 55 39
9 Atlético Oleiros Atlético 27 51 50 36
10 Lesende CFC Lousame Lesende 29 47 49 33
11 Queiruga Queiruga 28 50 60 33
12 Noia B Noia B 28 49 67 32
13 Dodro Dodro 29 41 51 31
14 Sporting Lampón Sporting 29 55 78 29
15 Victoria CF Victoria CF 27 40 57 21
16 Puebla B Puebla B 28 35 56 21
17 Galicia-Bealo Galicia-Beal 28 37 78 17
18 Nicrariense Nicrariense 0 0 0 0
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
SEGUNDA GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Calo SR Calo SR 18 67 29 44
2 Luaña SD Luaña SD 18 39 27 34
3 Cacheiras Cacheiras 18 32 22 30
4 Urdilde Urdilde 18 35 34 30
5 Bertamiráns FC Bertamiráns 18 36 34 27
6 Bastavales Bastavales 18 33 32 26
7 Agron CF Agron CF 18 28 28 22
8 Rois Rois 18 26 42 16
9 Nicrariense Nicrariense 18 29 37 15
10 Recesende Recesende 18 16 56 5
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 5
Equipo PJ GF GC Puntos
1 Queiruga Queiruga 28 112 39 70
2 Baroña CF Baroña CF 28 85 39 65
3 Atlético Oleiros Atlético 28 101 37 59
4 Sporting Lampón Sporting 28 87 48 56
5 Artes CD Artes CD 28 81 47 55
6 Cruido AD Cruido AD 28 76 52 45
7 Rois Rois 28 42 43 44
8 Porto do Son Porto 28 69 69 41
9 Xuventú Aguiño Xuventú 28 69 71 39
10 Furia Furia 28 44 47 39
11 Crocha Balompe Crocha 28 55 70 28
12 Galicia-Bealo Galicia-Beal 28 38 90 24
13 Carreira CF Carreira CF 28 39 108 16
14 Cures SD Cures SD 28 37 103 11
15 Olveira CF Olveira CF 28 27 99 10
TEMPORADA 2016/2017
TERCERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Agron CF Agron CF 34 76 25 76
2 Araño SD Araño SD 34 98 48 75
3 Sporting Lampón Sporting 34 89 40 73
4 Queiruga Queiruga 34 88 42 68
5 Baroña CF Baroña CF 33 100 41 67
6 C.D. Sar Extramundi C.D. 34 90 31 66
7 Cruido AD Cruido AD 33 85 44 59
8 Brion SD Brion SD 34 69 73 53
9 Carreira CF Carreira CF 34 60 77 52
10 Artes CD Artes CD 34 76 61 48
11 Crocha Balompe Crocha 34 85 76 46
12 Galicia-Bealo Galicia-Beal 33 67 72 44
13 Xuventú Aguiño Xuventú 34 54 66 40
14 Rois Rois 33 44 57 40
15 Cures SD Cures SD 34 47 102 23
16 Goian FC Goian FC 33 37 98 20
17 Olveira CF Olveira CF 34 23 130 8
18 Nebra CF Nebra CF 33 18 123 6
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
SEGUNDA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Hijos Palmeira Hijos 34 86 42 79
2 Carcacía Carcacía 34 69 39 79
3 Cacheiras Cacheiras 34 77 33 75
4 Taragoña Taragoña 34 79 39 73
5 Recesende Recesende 34 70 52 60
6 Esclavitud Esclavitud 34 52 48 50
7 Urdilde Urdilde 34 52 43 48
8 Praiña Praiña 34 51 43 48
9 Sálvora Sálvora 34 65 63 44
10 Bastavales Bastavales 34 53 54 41
11 Dodro Dodro 34 49 58 41
12 Atlético Oleiros Atlético 34 58 73 41
13 Queiruga Queiruga 34 53 67 40
14 Sporting Lampón Sporting 34 43 62 34
15 Porto do Son Porto 34 49 75 30
16 Rois Rois 34 39 82 26
17 C.D. Sar Extramundi C.D. 34 40 65 23
18 Furia Furia 34 50 97 22

  USO DE MEMORIA  
5,667,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1110
Total Execution Time  0.1124
  CADENA URL  
/historico/Rois
  GET DATOS  
$_GET['/historico/Rois']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0027  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 = 'Rois' 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=20032 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=20032 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 73703
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20032 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=714 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 714 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 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 (369188,189167,170033,122664) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '20032' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '20032' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '20032' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73703 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=20032 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73703,69306) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73703 AND teamId = 20032
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 69306 AND teamId = 20032
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 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 = 73703 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '20032' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20032' and rp.type = 4
0.0023  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 = '20032' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73703 WHERE rp.league_id = 73703 AND rp.teamId = 20032 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.0020  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 = 73703 WHERE rp.league_id = 73703 AND rp.teamId = 20032 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 73703 WHERE rp.league_id = 73703 AND rp.teamId = 20032 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 = 20032 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73703 AND t.round = 32 ORDER BY team.conference ASC,t.position 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 `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.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 `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 = 67242 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `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 = 65768 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.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 = 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.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 = 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.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 `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 = 39855 AND t.round = 30 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 `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 = 34653 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 `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.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 `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 = 4348 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73703 ORDER BY nameShow LIMIT 100