4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Vecindario
TEMPORADA 2023/2024
1ª REGIONAL CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Vecindario Vecindario 30 107 19 79
2 Castillo CF Castillo CF 30 112 26 73
3 UD San Fernando B Fernando 29 120 34 70
4 Unión Carrizal Unión 30 86 56 53
5 Agüimes CF Agüimes CF 30 68 46 51
6 San Pedro Mártir Pedro 30 78 49 49
7 Las Longueras Longueras 30 71 48 47
8 Tablero Tablero 29 62 44 45
9 Club Atlético Fomento Club 29 75 73 40
10 Juan Grande Juan Grande 30 70 71 39
11 CF Las Majoreras Majoreras 29 49 54 36
12 Cerruda Cerruda 30 61 66 34
13 Unión Viera B Unión Viera 29 60 53 33
14 Las Huesas Las Huesas 30 60 99 30
15 Union Marina Union Marina 30 45 95 30
16 Doramas B Doramas B 29 59 77 29
17 UD Los Vélez Vélez 30 44 68 26
18 Cercado de Espino Cercado 30 17 255 4
TEMPORADA 2022/2023
PREFERENTE CANARIAS GRUPO 3
Equipo PJ GF GC Puntos
1 UD Las Palmas C Palmas 28 102 15 75
2 San Bartolomé CF Bartolomé 28 63 34 57
3 Lomo Blanco Lomo Blanco 28 36 35 46
4 UD Teror UD Teror 28 36 30 45
5 Tinajo Tinajo 28 38 34 41
6 UD Guía UD Guía 28 44 39 40
7 Sporting Tías Sporting 28 44 41 40
8 Tahiche Tahiche 28 41 45 39
9 Maspalomas Maspalomas 28 36 33 37
10 CD Ingenio CD Ingenio 28 36 48 36
11 Vecindario Vecindario 28 41 48 34
12 UD San Fernando B Fernando 28 35 49 33
13 Real Sporting San José Real 28 40 46 29
14 Agaete Agaete 28 27 63 22
15 Guayarmina Guayarmina 28 26 85 19
TEMPORADA 2021/2022
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Estrella Estrella 28 69 19 66
2 Universitario FC Universitari 28 58 13 66
3 Breñamen Las Playitas Breñamen 28 56 26 56
4 El Cotillo El Cotillo 28 51 22 54
5 Doramas Doramas 28 51 32 53
6 UD Guía UD Guía 28 44 40 42
7 UD Teror UD Teror 28 41 38 37
8 Lomo Blanco Lomo Blanco 28 40 43 32
9 Tarajalejo Tarajalejo 28 35 61 32
10 Vecindario Vecindario 28 37 46 31
11 CD Valleseco Valleseco 28 24 39 30
12 UD Barrial UD Barrial 28 29 52 28
13 Costa Ayala Costa Ayala 28 31 48 26
14 Unión Carrizal Unión 28 29 58 21
15 Las Longueras Longueras 28 30 88 9
TEMPORADA 2020/2021
TERCERA DIVISIÓN FUTSAL GRUPO 16
Equipo PJ GF GC Puntos
1 Tecnasa FS Tecnasa FS 14 72 39 33
2 MaspaSala MaspaSala 14 62 51 28
3 Valsefutsal Valsefutsal 14 71 60 25
4 Montevideo Futsal Montevideo 14 68 71 22
5 Cruce de Arinaga Cruce 14 64 65 21
6 Agüimes Agüimes 14 58 67 19
7 Trican Lanzarote FS Trican 14 52 53 12
8 Vecindario Vecindario 14 38 79 4
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN B FUTSAL GRUPO 7
Equipo PJ GF GC Puntos
1 CFS Alamos CFS Alamos 13 80 31 37
2 Agüimes Agüimes 12 69 43 26
3 Malta 97 Malta 97 11 62 35 25
4 Isla Larga Futsal Isla Larga. 11 55 44 20
5 Arguineguin Cd Futsal Arguineguin 12 57 47 20
6 Trican Lanzarote FS Trican 10 57 39 19
7 La Cuevita Artenara Cuevita 11 41 48 15
8 Arsenal Futsal Arsenal 11 40 51 10
9 Doctoral Ludeservicios Doctoral 11 33 66 8
10 SBT SBT 12 34 62 7
11 Vecindario Vecindario 12 45 72 6
12 Cruce de Arinaga Cruce 12 50 85 6

  USO DE MEMORIA  
5,182,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0762
Total Execution Time  0.0775
  CADENA URL  
/historico/Cd-Doblepenalty-Vecindario-Futsal
  GET DATOS  
$_GET['/historico/Cd-Doblepenalty-Vecindario-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0041  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 = 73641
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=22246 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2523 AND type_rel = 3
0.0024  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 = '22246' 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 = 73641 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=22246 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73641,68936) 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 = 68936 AND teamId = 22246
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73641 AND teamId = 22246
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 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 = 73641 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '22246' 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 = '22246' and rp.type = 4
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 = '22246' 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 = 73641 WHERE rp.league_id = 73641 AND rp.teamId = 22246 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 = 73641 WHERE rp.league_id = 73641 AND rp.teamId = 22246 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 = 73641 WHERE rp.league_id = 73641 AND rp.teamId = 22246 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 22246 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73641 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 `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 = 68936 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 = 64495 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` 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 = 62120 AND t.round = 14 ORDER BY team.conference ASC,t.position 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 `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 = 4615 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC