4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Tres Columnas
TEMPORADA 2022/2023
DIVISIÓN DE HONOR JUVENIL FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Tierno Galván Tierno 23 185 67 60
2 5 Coruña FS Coruña 24 160 50 59
3 Leis Pontevedra FS Leis 24 152 72 51
4 CD Trepalio CD Trepalio 24 148 106 46
5 Lugo Sala Lugo Sala 23 86 73 44
6 O Parrulo O Parrulo 24 109 79 41
7 San Cristobal de Segovia Cristobal 24 129 107 37
8 FS Salamanca Salamanca 24 83 111 31
9 Ribeira de Piquin Ribeira 24 83 140 22
10 River Zamora River Zamora 24 74 134 20
11 CD Tres Columnas Tres 24 87 141 17
12 Vigo 2015 Vigo 2015 24 63 169 10
13 CD Laguna FSVV Laguna FSVV 24 67 177 10
TEMPORADA 2021/2022
DIVISIÓN DE HONOR JUVENIL FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 5 Coruña FS Coruña 27 147 46 71
2 O Parrulo O Parrulo 27 149 52 70
3 Tierno Galván Tierno 28 224 58 69
4 CD Trepalio CD Trepalio 27 120 98 49
5 River Zamora River Zamora 28 119 124 45
6 Galefén Marin Futsal Galefén 28 116 122 42
7 Lugo Sala Lugo Sala 26 83 82 38
8 Distrito Ventorrillo FS Distrito 27 112 123 38
9 San Cristobal de Segovia Cristobal 28 131 125 35
10 FS Salamanca Salamanca 28 80 126 28
11 CD Laguna FSVV Laguna FSVV 25 87 137 26
12 CD Tres Columnas Tres 28 78 119 25
13 Leis Pontevedra FS Leis 28 87 161 19
14 CD Valverde CD Valverde 28 67 163 15
15 Pescados Burela FS Pescados 27 59 123 13
TEMPORADA 2020/2021
DIVISIÓN DE HONOR JUVENIL FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Tres Columnas Tres 2 11 3 6
2 FS Salamanca Salamanca 2 11 7 6
3 CD Valverde CD Valverde 2 6 12 3
4 La Amistad Burgos Amistad 0 0 0 0
5 Cuéllar Cojalba Cuéllar 0 0 0 0
6 Tierno Galván Tierno 0 0 0 0
7 River Zamora River Zamora 0 0 0 0
8 San Cristobal de Segovia Cristobal 1 4 5 0
9 CD Segosala CD Segosala 1 2 3 0
10 Atlético Benavente Atlético 2 7 11 0
TEMPORADA 2018/2019
DIVISIÓN DE HONOR JUVENIL FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 Segovia Futsal Segovia 32 240 57 93
2 Cistierna Cistierna 32 150 77 70
3 River Zamora River Zamora 32 159 101 70
4 Tierno Galván Tierno 32 125 71 65
5 Laguna FS Laguna FS 32 166 120 60
6 FS Salamanca Salamanca 32 132 126 47
7 Alhambra de Guijuelo Alhambra 32 126 128 47
8 Valverde Valverde 32 120 109 46
9 CD Tres Columnas Tres 32 120 140 44
10 La Amistad Burgos Amistad 32 130 156 44
11 La Lastrilla Lastrilla 32 165 169 43
12 Cuéllar Cojalba Cuéllar 32 124 120 42
13 Atlético Benavente Atlético 32 102 113 39
14 San José San José 32 157 251 29
15 San Cristobal Segovia Cristobal 32 99 164 20
16 C FS La Bañeza Bañeza 32 73 172 20
17 CD Trepalio CD Trepalio 32 80 194 13

  USO DE MEMORIA  
4,852,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0761
Total Execution Time  0.0775
  CADENA URL  
/historico/Cd-Tres-Columnas-Juvenil-Futsal
  GET DATOS  
$_GET['/historico/Cd-Tres-Columnas-Juvenil-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0026  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-Tres-Columnas-Juvenil-Futsal' 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.0033  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-Tres-Columnas-Juvenil-Futsal' 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=112017 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=112017 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=112017 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=112017 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=112017 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 = 69525
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112017 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1021 AND type_rel = 3
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 = '112017' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '112017' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '112017' 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,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 = 69525 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=112017 AND l.year in (2022,2023,2024) 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 (69525) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69525 AND teamId = 112017
0.0020  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 = '112017' 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 = '112017' and rp.type = 4
0.0020  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 = '112017' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 112017 AND l.year <= 2023 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 `tables2023_base` 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 = 69525 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.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_base` 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 = 65380 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.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 `tables2021_base` 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 = 59676 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