4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del La Florida
TEMPORADA 2022/2023
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Atletico Victoria Atletico 34 78 18 81
2 Vera Vera 34 67 30 73
3 Atlético Tacoronte Atlético 34 58 22 73
4 CD Sauzal CD Sauzal 34 70 27 72
5 Tenisca Tenisca 34 66 30 70
6 Puerto Cruz Puerto Cruz 34 58 39 55
7 UD Fuencaliente Fuencaliente 34 70 44 54
8 Llanos Aridane Llanos 34 63 45 51
9 UD Icodense UD Icodense 34 67 53 51
10 EMF Matanza EMF Matanza 34 62 51 50
11 Juventud Laguna Juventud 34 66 61 48
12 Orotava Orotava 34 50 42 44
13 CD Guancha CD Guancha 34 51 49 41
14 Unión Tejina Unión 34 49 73 40
15 La Florida La Florida 34 41 85 27
16 EF El Cano EF El Cano 34 31 100 19
17 UD Tacoronte Tacoronte 34 31 88 10
18 CD Buenavista Buenavista 34 19 140 4
TEMPORADA 2021/2022
PREFERENTE CANARIAS GRUPO 4
Equipo PJ GF GC Puntos
1 Atletico Victoria Atletico 22 50 12 52
2 CD Guancha CD Guancha 22 34 12 45
3 Orotava Orotava 22 31 26 41
4 Puerto Cruz Puerto Cruz 22 35 24 40
5 UD Icodense UD Icodense 22 26 39 30
6 EF El Cano EF El Cano 22 21 29 26
7 La Florida La Florida 22 27 33 25
8 CD Buenavista Buenavista 22 22 29 25
9 UD Fuencaliente Fuencaliente 22 22 29 24
10 EMF Matanza EMF Matanza 22 21 35 24
11 UD Cruz Santa Cruz Santa 22 24 32 22
12 Realejos Realejos 22 13 26 20
TEMPORADA 2020/2021
PREFERENTE CANARIAS GRUPO 3
Equipo PJ GF GC Puntos
1 CD Laguna CD Laguna 12 32 7 32
2 Cd Arguijón Arguijón 13 25 18 28
3 CD Guancha CD Guancha 10 17 7 19
4 Unión Tejina Unión 13 13 17 15
5 CD Sauzal CD Sauzal 9 16 11 13
6 Puerto Cruz Puerto Cruz 7 9 7 12
7 La Florida La Florida 10 23 26 11
8 UD Cruz Santa Cruz Santa 7 13 12 10
9 CD Buenavista Buenavista 7 10 14 8
10 Zamorano Esperanza Zamorano 8 8 12 8
11 Isora CF Isora CF 7 8 12 7
12 UD Tacoronte Tacoronte 5 7 13 3
13 Orotava Orotava 7 6 16 3
14 UD Icodense UD Icodense 7 7 22 1
TEMPORADA 2018/2019
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Vera Vera 34 67 35 75
2 Atletico Victoria Atletico 34 72 24 71
3 UD Cruz Santa Cruz Santa 34 57 29 66
4 San Lorenzo Constancia Lorenzo 34 59 43 58
5 Atlético San Juan Atlético 34 62 60 54
6 UD Icodense UD Icodense 34 57 54 52
7 AD Añaza AD Añaza 34 61 58 51
8 Puerto Cruz Puerto Cruz 34 63 43 50
9 Orotava Orotava 34 66 47 49
10 Unión Tejina Unión 34 69 55 49
11 At. Granadilla Granadilla 34 52 49 47
12 CD Águilas CD Águilas 34 55 54 47
13 CD Guancha CD Guancha 34 46 50 44
14 CD Marino B CD Marino B 34 52 58 42
15 La Florida La Florida 34 39 46 31
16 I'Gara I'Gara 34 52 92 28
17 Cd Arguijón Arguijón 34 30 89 21
18 Ud Valle Frontera Valle 34 25 98 17
TEMPORADA 2017/2018
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Tacoronte Atlético 34 67 22 75
2 UD Icodense UD Icodense 34 77 46 66
3 Atletico Victoria Atletico 34 54 32 61
4 San Lorenzo Constancia Lorenzo 34 64 47 61
5 UD Cruz Santa Cruz Santa 34 55 39 59
6 Puerto Cruz Puerto Cruz 34 55 35 57
7 Orotava Orotava 34 45 37 49
8 La Florida La Florida 34 43 47 49
9 CD Marino B CD Marino B 34 55 52 47
10 CD Águilas CD Águilas 34 44 50 46
11 Ud Valle Frontera Valle 34 51 58 45
12 CD Guancha CD Guancha 34 50 48 42
13 At. Granadilla Granadilla 34 42 44 42
14 Unión Tejina Unión 34 54 68 42
15 CD Portezuelo Portezuelo 34 42 55 38
16 Juventud Laguna Juventud 34 36 70 25
17 Charco del Pino Charco Pino 34 40 73 24
18 Santiago del Teide Santiago 34 35 86 16

  USO DE MEMORIA  
5,257,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0731
Total Execution Time  0.0743
  CADENA URL  
/historico/Cf-La-Florida
  GET DATOS  
$_GET['/historico/Cf-La-Florida']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=102831 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 80 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1227759,1055368,1019795,1016738,992278) ORDER BY n.cover_points DESC, update_date 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 = '102831' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = '102831' 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=102831 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 (68789) 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 WHERE league_id = 68789 AND teamId = 102831
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 = '102831' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '102831' 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 = '102831' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2023 e ON e.player_id = p.id AND e.league_id = 68789 WHERE rp.league_id = 68789 AND rp.teamId = 102831 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.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 events2023 e ON e.player_id = p.id AND e.league_id = 68789 WHERE rp.league_id = 68789 AND rp.teamId = 102831 AND (e.action = 4 or e.action = 5) 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 events2023 e ON e.player_id = p.id AND e.league_id = 68789 WHERE rp.league_id = 68789 AND rp.teamId = 102831 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 102831 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039  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 = 68789 AND t.round = 34 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 = 64497 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.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 `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 = 59645 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.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 = 44766 AND t.round = 34 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 = 39650 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 = 68789 ORDER BY nameShow LIMIT 100