4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Calo Sr B
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 6
Equipo PJ GF GC Puntos
1 Rodeiro CF Rodeiro CF 33 120 38 80
2 Amio CF Amio CF 33 102 35 79
3 Bandeira Bandeira 33 98 42 69
4 Manuel Peleteiro Manuel 33 74 39 68
5 Santiso UD Santiso UD 33 71 47 63
6 La Salle La Salle 33 67 54 49
7 Campo da Angustia Campo 32 64 70 43
8 Racing San Lorenzo Racing 31 58 81 34
9 Sporting Santiago Sporting 33 65 95 28
10 O Pino B O Pino B 32 45 78 25
11 Calo Sr B Calo Sr B 33 42 123 17
12 CF Vista Alegre Vista Alegre 33 34 138 9
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

  USO DE MEMORIA  
5,121,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0778
Total Execution Time  0.0791
  CADENA URL  
/historico/Calo-Sr-B-Senior
  GET DATOS  
$_GET['/historico/Calo-Sr-B-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0035  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 = 'Calo-Sr-B-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=103143 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=103143 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103143 AND type_rel = 2
0.0025  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 = '103143' 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 = '103143' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=103143 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73760 AND teamId = 103143
0.0024  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 = '103143' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '103143' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 103143 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.0022  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 = 103143 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 103143 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 = 103143 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 = 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.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.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 `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 = 45274 AND t.round = 33 ORDER BY team.conference 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 `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