4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Apaga Y Vamonos
TEMPORADA 2021/2022
2ª CORDOBA FUTSAL
Equipo PJ GF GC Puntos
1 Decorseneca CD Decorseneca 17 94 51 39
2 Apaga Y Vamonos Apaga 18 86 56 39
3 CD Carcabuey Carcabuey 18 94 64 28
4 Cabra Cabra 18 100 89 26
5 Toxar Toxar 18 63 63 23
6 Adecor Adecor 17 73 82 23
7 Villafranca CF Villafranca 16 71 84 22
8 Valenzuela CD Valenzuela 17 65 83 18
9 Miragenil FS Miragenil 16 60 70 16
10 Albendin Atletico Albendin 17 48 112 9
TEMPORADA 2020/2021
2ª CORDOBA FUTSAL
Equipo PJ GF GC Puntos
1 Córdoba FS Córdoba FS 19 136 32 54
2 Apaga Y Vamonos Apaga 20 97 75 42
3 Adecor Adecor 19 83 58 37
4 Decorseneca CD Decorseneca 19 83 69 35
5 Cabra Cabra 19 88 80 35
6 Miragenil FS Miragenil 20 69 86 25
7 Sinapsis de Luque Sinapsis 20 64 77 23
8 Albendin Atletico Albendin 19 82 103 18
9 Villafranca CF Villafranca 20 62 98 13
10 Deportivo Peñarroya Deportivo 19 55 94 12
11 Adeval FS Adeval FS 20 56 103 12
12 Cañete CD Base Cañete Base 0 0 0 0
TEMPORADA 2019/2020
2ª CORDOBA FUTSAL
Equipo PJ GF GC Puntos
1 Baenense Baenense 16 84 36 42
2 Córdoba FS Córdoba FS 16 79 50 34
3 Apaga Y Vamonos Apaga 16 81 56 33
4 Cañete CD Base Cañete Base 15 77 57 31
5 Cabra Cabra 16 81 56 30
6 Adecor Adecor 17 65 57 30
7 Sinapsis de Luque Sinapsis 16 73 77 22
8 Valenzuela CD Valenzuela 15 60 53 21
9 Miragenil FS Miragenil 15 46 56 14
10 Asociacion La Rambla FS Asociacion 17 48 70 12
11 Guadalcazar Guadalcazar 16 39 96 11
12 Albendin Atletico Albendin 16 53 97 8
13 Deportivo Peñarroya Deportivo 0 0 0 0
14 Moriles CF Moriles CF 5 14 39 0
TEMPORADA 2018/2019
2ª CORDOBA FUTSAL
Equipo PJ GF GC Puntos
1 Apaga Y Vamonos Apaga 14 77 42 35
2 Baenense Baenense 14 65 43 33
3 Córdoba FS Córdoba FS 13 87 55 27
4 Moriles CF Moriles CF 14 81 76 22
5 Miragenil FS Miragenil 13 67 59 16
6 Deportivo Peñarroya Deportivo 13 45 81 9
7 Villa de Benameji Villa 14 39 74 8
8 Valenzuela CD Valenzuela 13 42 73 7
TEMPORADA 2017/2018
TERCERA DIVISIÓN FUTSAL GRUPO 18
Equipo PJ GF GC Puntos
1 AV Torcal-Carranque Torcal-Carra 22 96 49 53
2 Bujalance Caldereria Manzan Bujalance 22 106 79 43
3 Electro Beltran Electro 23 112 102 43
4 Mancha Real Cincocina Mancha Real 23 110 86 41
5 Jaén Paraiso Interior B Jaén 23 114 72 39
6 Club Torremolinos Club 22 108 81 37
7 UD Playas de Málaga FS Playas 23 100 108 33
8 Apaga Y Vamonos Apaga 22 93 104 25
9 Loja Loja 22 76 83 24
10 CD Alhaurin El Grande FS Alhaurin 21 73 87 24
11 CD Puntos Suspensivos FS Puntos 22 79 130 18
12 Desierto de Tabernas Desierto 23 66 142 7
13 San Antonio de Casanueva Antonio 6 20 30 5
TEMPORADA 2016/2017
TERCERA DIVISIÓN FUTSAL GRUPO 18
Equipo PJ GF GC Puntos
1 Villa de Fines Villa Fines 24 157 59 65
2 Baeza Dental Company Baeza Dental 24 116 69 54
3 Inagroup El Ejido Inagroup 24 171 103 53
4 CD Pizarra FS Pizarra 24 111 65 49
5 Cincocina Upi Mancha Real Cincocina 24 86 86 36
6 Apaga Y Vamonos Apaga 24 87 92 31
7 Desierto de Tabernas Desierto 24 89 129 30
8 Club Torremolinos Club 24 81 107 29
9 Espejo Espejo 25 85 100 27
10 Alhaurin El Grande Alhaurin 25 68 89 24
11 Villanueva Mesia Villanueva 25 89 129 21
12 Atletico Linares Atletico 24 88 126 19
13 Amigos Transmado Express Amigos 25 78 147 15
14 Guadix Guadix 6 24 29 9
15 Mutrayil Mutrayil 0 0 0 0
TEMPORADA 2015/2016
TERCERA DIVISIÓN FUTSAL GRUPO 18
Equipo PJ GF GC Puntos
1 CD Gador CD Gador 23 133 58 58
2 Inagroup El Ejido Inagroup 22 123 73 50
3 Atletico Linares Atletico 24 123 115 41
4 Villa de Fines Villa Fines 25 120 125 41
5 Villanueva Mesia Villanueva 24 98 104 35
6 Apaga Y Vamonos Apaga 24 105 113 35
7 El Palo Pedregalejo Palo 24 115 104 34
8 Cabra Joven Cabra Joven 23 95 106 30
9 Cincocina Upi Mancha Real Cincocina 23 85 92 29
10 Amigos Transmado Express Amigos 25 107 129 28
11 Club Torremolinos Club 23 100 105 26
12 Yokin Tuning Dcepas Yokin Tuning 19 55 97 16
13 Estepona Achedosol Estepona 17 58 87 16
14 Archidona Futsala Archidona 12 41 50 10
TEMPORADA 2014/2015
2ª CORDOBA FUTSAL
Equipo PJ GF GC Puntos
1 Moriles CF Moriles CF 22 116 68 58
2 Baenense Baenense 23 109 71 52
3 Apaga Y Vamonos Apaga 22 86 56 46
4 Sinapsis de Luque Sinapsis 23 85 65 45
5 Miragenil FS Miragenil 22 94 61 37
6 Bar Latino Encinas Reales Latino 22 98 104 32
7 Adecor Adecor 22 68 61 31
8 El Peñasco El Peñasco 22 76 71 27
9 Espejo Espejo 23 73 108 24
10 Club Atlético Boca Juniors Club 22 62 96 17
11 Aldepal S Aldepal S 23 64 117 15
12 Grupo Egisse Peñarroya Grupo Egisse 19 58 102 11
13 Peña La Lata Peña Lata 9 0 9 0

  USO DE MEMORIA  
5,312,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5352
Total Execution Time  0.5364
  CADENA URL  
/historico/Cd-Apaga-Y-Vamonos-Futsal
  GET DATOS  
$_GET['/historico/Cd-Apaga-Y-Vamonos-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0132  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-Apaga-Y-Vamonos-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.0143  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-Apaga-Y-Vamonos-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.0126  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=41311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=41311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=41311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=41311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=41311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=41311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=41311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=41311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=41311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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 = 65397
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=41311 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1012 AND type_rel = 3
0.0128  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 = '41311' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '41311' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 65397 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=41311 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (65397) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 65397 AND teamId = 41311
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 65397 AND t.round = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '41311' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  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 = '41311' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 events2022 e ON e.player_id = p.id AND e.league_id = 65397 WHERE rp.league_id = 65397 AND rp.teamId = 41311 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.0127  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 events2022 e ON e.player_id = p.id AND e.league_id = 65397 WHERE rp.league_id = 65397 AND rp.teamId = 41311 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 events2022 e ON e.player_id = p.id AND e.league_id = 65397 WHERE rp.league_id = 65397 AND rp.teamId = 41311 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 41311 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 65397 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.0129  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 = 60221 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.0129  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 = 48771 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 40333 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 35405 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 17404 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 6617 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC